protected function buildWhere(Pap_Stats_Params $statParams) {
$statParams->addTo($this->transactionsSelect);
if ($statParams->isTypeDefined()) {
$this->transactionsSelect->where->add(Pap_Db_Table_Transactions::R_TYPE, 'IN', explode(',', $statParams->getType()));
}
if ($statParams->isStatusDefined()) {
if (is_array($statParams->getStatus())) {
$this->transactionsSelect->where->add(Pap_Db_Table_Transactions::R_STATUS, 'IN', $statParams->getStatus());
} else {
$this->transactionsSelect->where->add(Pap_Db_Table_Transactions::R_STATUS, 'IN', explode(',', $statParams->getStatus()));
}
}
}
/**
* @return Gpf_SqlBuilder_UnionBuilder
*/
public function getStatsSelect(Pap_Stats_Params $statParams, $groupColumn, $groupColumnAlias) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add($groupColumn, $groupColumnAlias);
$this->initStatsSelect($select->select);
$select->from->add($this->name());
$statParams->addTo($select);
$select->groupBy->add($groupColumn);
$unionBuilder = new Gpf_SqlBuilder_UnionBuilder();
$unionBuilder->addSelect($select);
$statsSelectContext = new Pap_Stats_StatsSelectContext($unionBuilder, $select, $groupColumn, $groupColumnAlias);
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Pap_Db_Table_ClicksImpressions.getStatsSelect', $statsSelectContext);
return $unionBuilder;
}
protected function initWhereConditions() {
$this->params->addTo($this->selectBuilder, 't');
}
protected function buildWhere(Pap_Stats_Params $statParams) {
$statParams->addTo($this->transactionsSelect);
$this->transactionsSelect->where->add(Pap_Db_Table_Users::ID, '=', $this->getLoggedAffId());
$this->transactionsSelect->where->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '!=', null);
$this->transactionsSelect->where->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '<>', '');
}
