if (!ValidId($CpId) && !$nsUser->ADMIN) { $nsProduct->Redir("default", "", "admin"); } if ($CpId) { $Client = GetCompany($CpId); } if (!ValidId($Client->ID) && !$nsUser->ADMIN) { $nsProduct->Redir("default", "", "admin"); } if (!$CpId) { $CpId = 0; } $GroupByForm = array(); $WhereForm = array(); UserColumns(); $Report = new Natural_v2(); if ($SaveQ && defined("DEBUG") && DEBUG) { $Report->LoggerFunc = "QueriesLog"; } if ($nsUser->Columns->HITS) { $Report->ShowVisitors = true; } if ($nsUser->Columns->ACTIONS) { $Report->ShowActions = true; } if ($nsUser->Columns->SALES) { $Report->ShowSales = true; } if ($nsUser->Columns->ACTIONS) { $Report->ShowActionConv = true; }
} ///////////////////////////////////////////// ///////// call any process functions ///////////////////////////////////////////// ///////// display section here if ($nsUser->Columns->HITS || $nsUser->Columns->ACTIONS || $nsUser->Columns->CLICKS || $nsUser->Columns->SALES) { $Stamp = gmdate("Y-m-d H:i:s", time()); $Query = "\n\tSELECT \n\t\tS_LOG.SITE_ID,\n\t\tCOUNT(DISTINCT S_LOG.VISITOR_ID) AS CNT\n\t\tFROM " . PFX . "_tracker_" . $CpId . "_stat_log S_LOG\n\t\tWHERE S_LOG.STAMP >= DATE_ADD('{$Stamp}', INTERVAL -{$OnlinePeriod} SECOND)\n\t\tGROUP BY S_LOG.SITE_ID\n"; $Sql = new Query($Query); $OnlineArr = array(); while ($Row = $Sql->Row()) { $OnlineArr[$Row->SITE_ID] = $Row->CNT; } $Query = "SELECT COUNT(*) FROM " . PFX . "_tracker_site WHERE COMPANY_ID = " . $CurrentCompany->ID; $SitesCnt = $Db->ReturnValue($Query); $NaturalReport = new Natural_v2(); $NaturalReport->NoRef = true; $NaturalReport->RsNeeded = false; if ($nsUser->Columns->HITS) { $NaturalReport->ShowVisitors = true; } if ($nsUser->Columns->ACTIONS) { $NaturalReport->ShowActions = true; } if ($nsUser->Columns->SALES) { $NaturalReport->ShowSales = true; } $NaturalReport->ViewDate = $Today; $NaturalReport->CpId = $CurrentCompany->ID; if ($SitesCnt == 0) { $NaturalReport->SiteId = -1;