| | |
|---|
| | | if ($this->dataRecord["template_type"] == 'm'){
|
|---|
| | | $sql = "SELECT client_id FROM client WHERE template_master = " . $this->id;
|
|---|
| | | } else {
|
|---|
| | | $sql = "SELECT client_id FROM client WHERE template_additional LIKE '%/" . $this->id . "/%' OR template_additional LIKE '" . $this->id . "/%' OR template_additional LIKE '%/" . $this->id . "'";
|
|---|
| | | $sql = "SELECT client_id FROM client WHERE template_additional LIKE '%/" . $this->id . "/%' OR template_additional LIKE '" . $this->id . "/%' OR template_additional LIKE '%/" . $this->id . "' UNION SELECT client_id FROM client_template_assigned WHERE client_template_id = " . $this->id;
|
|---|
| | | }
|
|---|
| | | $clients = $app->db->queryAllRecords($sql);
|
|---|
| | | if (is_array($clients)){
|
|---|
