| | |
| | | $name=str_replace('['.$keyword.']', $this->getClientID($dataRecord), $name); |
| | | break; |
| | | case 'DOMAINID': |
| | | $name=str_replace('['.$keyword.']', $dataRecord['parent_domain_id'], $name); |
| | | $name=str_replace('['.$keyword.']', $dataRecord['parent_domain_id'] ? $dataRecord['parent_domain_id'] : '[DOMAINID]', $name); |
| | | break; |
| | | } |
| | | } |
| | |
| | | if(isset($dataRecord['client_group_id'])) { |
| | | $client_group_id = $dataRecord['client_group_id']; |
| | | } elseif (isset($dataRecord['parent_domain_id'])) { |
| | | $tmp = $app->db->queryOneRecord("SELECT sys_groupid FROM web_domain WHERE domain_id = " . $dataRecord['parent_domain_id']); |
| | | $tmp = $app->db->queryOneRecord("SELECT sys_groupid FROM web_domain WHERE domain_id = ?", $dataRecord['parent_domain_id']); |
| | | $client_group_id = $tmp['sys_groupid']; |
| | | } elseif(isset($dataRecord['sys_groupid'])) { |
| | | $client_group_id = $dataRecord['sys_groupid']; |
| | | } else { |
| | | $client_group_id = 0; |
| | | return '[CLIENTNAME]'; |
| | | } |
| | | } |
| | | |
| | | $tmp = $app->db->queryOneRecord("SELECT name FROM sys_group WHERE groupid = " . $app->functions->intval($client_group_id)); |
| | | $tmp = $app->db->queryOneRecord("SELECT name FROM sys_group WHERE groupid = ?", $client_group_id); |
| | | $clientName = $tmp['name']; |
| | | if ($clientName == "") $clientName = 'default'; |
| | | $clientName = $this->convertClientName($clientName); |
| | |
| | | if(isset($dataRecord['client_group_id'])) { |
| | | $client_group_id = $dataRecord['client_group_id']; |
| | | } elseif (isset($dataRecord['parent_domain_id']) && $dataRecord['parent_domain_id'] != 0) { |
| | | $tmp = $app->db->queryOneRecord("SELECT sys_groupid FROM web_domain WHERE domain_id = " . $dataRecord['parent_domain_id']); |
| | | $tmp = $app->db->queryOneRecord("SELECT sys_groupid FROM web_domain WHERE domain_id = ?", $dataRecord['parent_domain_id']); |
| | | $client_group_id = $tmp['sys_groupid']; |
| | | } elseif(isset($dataRecord['sys_groupid'])) { |
| | | $client_group_id = $dataRecord['sys_groupid']; |
| | | } else { |
| | | $client_group_id = 0; |
| | | return '[CLIENTID]'; |
| | | } |
| | | } |
| | | $tmp = $app->db->queryOneRecord("SELECT client_id FROM sys_group WHERE groupid = " . $app->functions->intval($client_group_id)); |
| | | $tmp = $app->db->queryOneRecord("SELECT client_id FROM sys_group WHERE groupid = ?", $client_group_id); |
| | | $clientID = $tmp['client_id']; |
| | | if ($clientID == '') $clientID = '0'; |
| | | return $clientID; |
| | |
| | | return $res; |
| | | } |
| | | |
| | | /* TODO: rewrite SQL */ |
| | | function getDomainModuleDomains($not_used_in_table = null, $selected_domain = null) { |
| | | global $app; |
| | | |
| | |
| | | return $app->db->queryAllRecords($sql, $not_used_in_table, $selected_domain); |
| | | } |
| | | |
| | | /* TODO: rewrite SQL */ |
| | | function checkDomainModuleDomain($domain_id) { |
| | | global $app; |
| | | |
| | |
| | | if(!$domain || !$domain['domain_id']) return false; |
| | | return $domain['domain']; |
| | | } |
| | | |
| | | /* TODO: rewrite SQL */ |
| | | function getClientIdForDomain($domain_id) { |
| | | global $app; |
| | | |
| | | $sql = "SELECT sys_groupid FROM domain WHERE domain_id = " . $app->functions->intval($domain_id); |
| | | if ($_SESSION["s"]["user"]["typ"] != 'admin') { |
| | | $groups = ( $_SESSION["s"]["user"]["groups"] ) ? $_SESSION["s"]["user"]["groups"] : 0; |
| | | $sql .= " AND sys_groupid IN (".$groups.")"; |
| | | } |
| | | $domain = $app->db->queryOneRecord($sql); |
| | | if(!$domain || !$domain['sys_groupid']) return false; |
| | | return $domain['sys_groupid']; |
| | | } |
| | | |
| | | } |
| | | |