public static function modifySqlWhereForAsolDomainsQuery(&$sqlWhere, $domainReportTable, $current_user, $schedulerCall, $asolReportDomainId, $domainField = null, $aliasSuffix = '')
{
global $db;
if (!empty($asolReportDomainId) || $schedulerCall) {
require_once "modules/asol_Domains/AlineaSolDomainsFunctions.php";
$domainsBean = BeanFactory::getBean('asol_Domains', $asolReportDomainId);
if ($domainsBean->asol_domain_enabled) {
if ($domainField !== null) {
if ($domainField != "") {
$externalIdUsage = isset($domainField["externalIdUsage"]) && $domainField["externalIdUsage"];
$domainFieldName = $domainField["fieldName"];
$domainIsNumeric = $externalIdUsage ? false : $domainField["isNumeric"];
$domainShowUpperLevels = isset($domainField["showUpperLevels"]) ? $domainField["showUpperLevels"] : false;
$asolReportDomainValue = $externalIdUsage ? $domainsBean->external_id : $asolReportDomainId;
if (isset($domainField["domainRelation"])) {
$domainReportTable = $domainField["domainRelation"]["relatedTable"];
}
$domainFieldChar = $domainIsNumeric ? "" : "'";
$sqlWhere .= (empty($sqlWhere) ? " WHERE " : " AND ") . " ( (" . $domainReportTable . $aliasSuffix . "." . $domainFieldName . "=" . $domainFieldChar . $asolReportDomainValue . $domainFieldChar . ") ";
//***asol_child_domains***//
$childDomainsIds = asol_manageDomains::getChildDomainsArray($asolReportDomainId);
$childDomainsStr = array();
foreach ($childDomainsIds as $key => $domainId) {
if (!$domainId['enabled']) {
array_splice($childDomainsIds, $key, 1);
} else {
$childDomainsStr[] = $externalIdUsage ? $domainId['external_id'] : $domainId['id'];
}
}
$sqlWhere .= count($childDomainsIds) > 0 ? "OR (" . $domainReportTable . $aliasSuffix . "." . $domainFieldName . " IN (" . $domainFieldChar . implode($domainFieldChar . "," . $domainFieldChar, $childDomainsStr) . $domainFieldChar . ")) " : " ";
//***asol_child_domains***//
//***asol_parent_domains***//
if ($domainShowUpperLevels) {
$parentDomainIds = asol_manageDomains::getParentDomainsIds($asolReportDomainId);
if (!empty($parentDomainIds)) {
$sqlWhere .= "OR (" . $domainReportTable . $aliasSuffix . "." . $domainFieldName . " IN (" . $domainFieldChar . implode($domainFieldChar . "," . $domainFieldChar, $parentDomainIds) . $domainFieldChar . ")) ";
}
}
//***asol_parent_domains***//
$sqlWhere .= ") ";
}
} else {
$sqlWhere .= " AND ( (" . $domainReportTable . $aliasSuffix . ".asol_domain_id='" . $asolReportDomainId . "')";
if ($current_user->asol_only_my_domain == 0 || $schedulerCall) {
//***asol_domain_child_share_depth***//
$sqlWhere .= asol_manageDomains::getChildShareDepthQuery($domainReportTable . $aliasSuffix . '.', $asolReportDomainId);
//***asol_domain_child_share_depth***//
//***asol_multi_create_domain***//
if ($domainReportTable != 'users') {
$sqlWhere .= asol_manageDomains::getMultiCreateQuery($domainReportTable . $aliasSuffix . '.', $asolReportDomainId);
}
//***asol_multi_create_domain***//
//***asol_publish_to_all***//
$sqlWhere .= asol_manageDomains::getPublishToAllQuery($domainReportTable . $aliasSuffix . '.', $asolReportDomainId);
//***asol_publish_to_all***//
//***asol_child_domains***//
$sqlWhere .= asol_manageDomains::getChildHierarchyQuery($domainReportTable . $aliasSuffix . '.', $asolReportDomainId);
//***asol_child_domains***//
} else {
$sqlWhere .= ") ";
}
}
} else {
$sqlWhere .= " AND (1!=1) ";
}
}
}
require_once "modules/asol_Domains/AlineaSolDomainsFunctions.php";
$domainsBean = BeanFactory::getBean('asol_Domains', $current_user->asol_default_domain);
if ($domainsBean->asol_domain_enabled) {
$sqlWhere .= " AND ( (asol_reports.asol_domain_id='" . $current_user->asol_default_domain . "')";
if ($current_user->asol_only_my_domain == 0) {
//asol_domain_child_share_depth
$sqlWhere .= asol_manageDomains::getChildShareDepthQuery('asol_reports.');
//asol_domain_child_share_depth
//asol_multi_create_domain
$sqlWhere .= asol_manageDomains::getMultiCreateQuery('asol_reports.');
//asol_multi_create_domain
//***asol_publish_to_all***//
$sqlWhere .= asol_manageDomains::getPublishToAllQuery('asol_reports.');
//***asol_publish_to_all***//
//***asol_child_domains***//
$sqlWhere .= asol_manageDomains::getChildHierarchyQuery('asol_reports.');
//***asol_child_domains***//
} else {
$sqlWhere .= ") ";
}
} else {
$sqlWhere .= " AND (1!=1) ";
}
}
}
//**************************//
//***Is Domains Installed***//
//**************************//
$sqlJoinWhere = " AND users.user_name LIKE '%" . $assigned_user_name . "%'";
$rs = asol_Report::getSelectionResults("SELECT COUNT(asol_reports.id) AS total FROM asol_reports" . $sqlJoin . $sqlWhere . $sqlJoinWhere, null, false);
$total_entries = $rs[0]['total'];
