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();