public function __construct(Pap_Stats_Params $params) { parent::__construct(Pap_Db_Table_Impressions::getInstance(), $params); }
protected function init() { $this->setTable(Pap_Db_Table_Impressions::getInstance()); parent::init(); }
protected function buildStatsFrom() { $statParams = $this->getStatsParameters(); if ($this->areColumnsRequiredOrInFilter(array(self::CLICKS_RAW, self::CLICKS_UNIQUE, self::CTR_RAW, self::CTR_UNIQUE, self::SCR_RAW, self::SCR_UNIQUE, self::AVG_COMMISSION_PER_CLICK))) { $clickSelect = Pap_Db_Table_Clicks::getInstance()->getStatsSelect($statParams, $this->groupColumn, self::GROUP_COLUMN_ALIAS); $this->_selectBuilder->from->addLeftJoin('('.$clickSelect->toString().')', 'cl', 'cl.'.self::GROUP_COLUMN_ALIAS.'='.$this->mainTablePreffix. '.'. $this->mainTableColumn); } if ($this->areColumnsRequiredOrInFilter(array(self::IMPRESSIONS_RAW, self::IMPRESSIONS_UNIQUE, self::CTR_RAW, self::CTR_UNIQUE, self::AVG_COMMISSION_PER_IMP))) { $impSelect = Pap_Db_Table_Impressions::getInstance()->getStatsSelect($statParams, $this->groupColumn, self::GROUP_COLUMN_ALIAS); $this->_selectBuilder->from->addLeftJoin('('.$impSelect->toString().')', 'im', 'im.'.self::GROUP_COLUMN_ALIAS.'='.$this->mainTablePreffix. '.'. $this->mainTableColumn); } if ($this->areColumnsRequiredOrInFilter(array(self::SALES_COUNT, self::SALES_TOTAL, self::COMMISSIONS, self::SCR_RAW, self::SCR_UNIQUE, self::AVG_COMMISSION_PER_CLICK, self::AVG_COMMISSION_PER_IMP, self::AVG_AMOUNT_OF_ORDER))) { $transSelect = $this->getTransactionStatsSelect($statParams); $this->addJoinSelectToSelectBuilder($transSelect, 'tr'); } Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Pap_Common_StatsGrid.buildStatsFrom', new Pap_Common_StatsGridParamsContext($this->_selectBuilder, $this, $statParams)); }