} $NaturalReport->ViewDate = $Today; $NaturalReport->CpId = $CurrentCompany->ID; if ($SitesCnt == 0) { $NaturalReport->SiteId = -1; } $NaturalReport->SelectArr[] = "TS.ID"; $NaturalReport->SelectArr[] = "TS.HOST AS NAME"; $NaturalReport->JoinArr[] = "INNER JOIN " . PFX . "_tracker_site TS ON TS.ID=S_LOG.SITE_ID"; $NaturalReport->GroupArr[] = "TS.ID"; $NaturalReport->GrpFld = "ID"; $NaturalReport->GrpName = "NAME"; $NaturalReport->OrderArr[] = "TS.HOST ASC"; $NaturalReport->Calculate(); 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 (!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 Paid_v2(); if ($nsUser->Columns->CLICKS) { $Report->ShowVisitors = true; } if ($nsUser->Columns->ACTIONS) { $Report->ShowActions = true; } if ($nsUser->Columns->SALES) { $Report->ShowSales = true; } if ($nsUser->Columns->ROI) { $Report->ShowROI = true; } if ($nsUser->Columns->SALES) { $Report->ShowSaleConv = true; }
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();