protected function init() {
$this->setTable(Pap_Db_Table_Clicks::getInstance());
parent::init();
}
public function __construct(Pap_Stats_Params $params, $timeGroupBy, $type = Pap_Db_Table_Clicks::RAW) {
parent::__construct(Pap_Db_Table_Clicks::getInstance(), $params, $timeGroupBy);
$this->type = $type;
}
public function __construct(Pap_Stats_Params $params) {
parent::__construct(Pap_Db_Table_Clicks::getInstance(), $params);
}
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));
}
