if ($nsUser->Columns->CLICKS) {
$PaidReport = new Paid_v2();
$PaidReport->ShowVisitors = true;
$PaidReport->CpId = $CurrentCompany->ID;
if ($SitesCnt == 0) {
$PaidReport->SiteId = -1;
}
$PaidReport->ViewDate = $Today;
$PaidReport->SelectArr[] = "TS.ID";
$PaidReport->SelectArr[] = "TS.HOST AS NAME";
$PaidReport->JoinArr[] = "INNER JOIN " . PFX . "_tracker_site TS ON TS.ID=S_LOG.SITE_ID";
$PaidReport->GroupArr[] = "TS.ID";
$PaidReport->GrpFld = "ID";
$PaidReport->GrpName = "NAME";
$PaidReport->OrderArr[] = "TS.HOST ASC";
$PaidReport->Calculate();
}
if (ValidArr($NaturalReport->StatArr) && count($NaturalReport->StatArr) > 0 && !isset($NaturalReport->StatArr[0])) {
if ($nsUser->Columns->HITS) {
foreach ($NaturalReport->StatArr as $SiteId => $Row) {
if (ValidVar($PaidReport->CampStat[$SiteId])) {
$Row['CntCamp'] = ValidVar($PaidReport->CampStat[$SiteId]['CntClick']);
$Row['UniCamp'] = ValidVar($PaidReport->CampStat[$SiteId]['UniClick']);
$Row['Camp'] = ValidVar($PaidReport->CampStat[$SiteId]['Camp']);
} else {
$Row['CntCamp'] = 0;
$Row['UniCamp'] = 0;
$Row['Camp'] = 0;
}
if (ValidVar($OnlineArr[$SiteId])) {
$Row['Online'] = $OnlineArr[$SiteId];
require "lib/const_path.inc.php";
$CurrentPath = GetConstPath($WhereArr, count($WhereArr) - 2, false);
$CurrentPath .= "GroupBy={$GroupBy}&Limit={$Limit}&Filter={$Filter}";
$CurrentPath = $nsProduct->SelfAction($CurrentPath);
//////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////
if ($PrevReport && $nsUser->Columns->CONVERSIONS) {
$PrevReport->Calculate();
$Report->PrevLevelUni = $PrevReport->CampStat[$Report->ConversionUni];
}
$Report->PageLimit = $Limit;
if ($OrderBy == "ACTCONV" || $OrderBy == "SALECONV" || $OrderBy == "ACTIONCNT" || $OrderBy == "ACTIONUNI" || $OrderBy == "SALECNT" || $OrderBy == "SALEUNI" || $OrderBy == "COST" || $OrderBy == "ROI" || $OrderBy == "INCOME") {
$Report->PageLimit = false;
@ini_set("memory_limit", "20M");
}
$Report->Calculate();
if (ValidVar($Report->CampStat)) {
if (!$GroupBy) {
$Report->Tmp[0] = $Report->CampStat;
$Report->CampStat = $Report->Tmp;
}
if ($ShowListName) {
$Report->CampStat[0]['Name'] = $ListName;
}
if (!$GroupBy && !$WhereArr) {
$Report->CampStat[0]['Name'] = $Lang['Total'];
$GroupBy = "General";
}
// Experimenting with sorting by actions conversion
if ($OrderBy == "ACTCONV" || $OrderBy == "SALECONV" || $OrderBy == "ACTIONCNT" || $OrderBy == "ACTIONUNI" || $OrderBy == "SALECNT" || $OrderBy == "SALEUNI" || $OrderBy == "ROI" || $OrderBy == "COST" || $OrderBy == "INCOME") {
usort($Report->CampStat, "SortRows");
while ($Row = $Sql->Row()) {
$ShowStats = true;
$SiteList[$Row->SITE_ID] = new Natural_v2();
//$SiteList[$Row->SITE_ID]->NoRef=true;
if ($nsUser->Columns->HITS) {
$SiteList[$Row->SITE_ID]->ShowVisitors = true;
}
if ($nsUser->Columns->ACTIONS) {
$SiteList[$Row->SITE_ID]->ShowActions = true;
}
$SiteList[$Row->SITE_ID]->SiteId = $Row->SITE_ID;
$SiteList[$Row->SITE_ID]->CpId = $Row->CLIENT_ID;
$SiteList[$Row->SITE_ID]->Name = $Row->HOST;
$SiteList[$Row->SITE_ID]->ClientName = $Row->CLIENT_NAME;
$SiteList[$Row->SITE_ID]->ViewDate = $Today;
$SiteList[$Row->SITE_ID]->NoRef = true;
$SiteList[$Row->SITE_ID]->Calculate();
if ($nsUser->Columns->CLICKS) {
$Tmp = new Paid_v2();
$Tmp->ViewDate = $Today;
$Tmp->CpId = $Row->CLIENT_ID;
$Tmp->ShowVisitors = true;
$Tmp->SiteId = $Row->SITE_ID;
$Tmp->Calculate();
$SiteList[$Row->SITE_ID]->StatArr['CntCamp'] = $Tmp->CampStat['CntClick'];
$SiteList[$Row->SITE_ID]->StatArr['UniCamp'] = $Tmp->CampStat['UniClick'];
$SiteList[$Row->SITE_ID]->StatArr['Camp'] = $Tmp->CampStat['Camp'];
}
}
}
include $nsTemplate->Inc();
