private function getTransactionStatsSelect(Pap_Common_StatsGridParamsContext $context, $commissionTypeId) {
$statsGrid = $context->getStatsGrid();
$statParams = $context->getStatsParams();
if ($this->isSubAffSaleStats($statsGrid)) {
$subAffSaleStats = new Pap_Affiliates_Reports_SubAffSaleStatsBuilder($statParams, $statsGrid->getGroupColumn(), Pap_Common_StatsGrid::GROUP_COLUMN_ALIAS);
$this->addActionConditionsToWhere($subAffSaleStats->getTransactionsWhereClause(), $commissionTypeId);
return $subAffSaleStats->getStatsSelect();
}
$actionStats = new Pap_Features_ActionCommission_ActionStatsBuilder($statParams, $statsGrid->getGroupColumn(),
Pap_Common_StatsGrid::GROUP_COLUMN_ALIAS, $commissionTypeId);
return $actionStats->getStatsSelect();
}
/**
* @param Pap_Stats_Params $statParams
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function getTransactionStatsSelect(Pap_Stats_Params $statParams) {
$subAffSaleStats = new Pap_Affiliates_Reports_SubAffSaleStatsBuilder($statParams, $this->getGroupColumn(), self::GROUP_COLUMN_ALIAS);
$subAffSaleStats->getTransactionsWhereClause()->add(Pap_Db_Table_Transactions::R_TYPE, 'in', array(Pap_Common_Constants::TYPE_SALE, Pap_Common_Constants::TYPE_CLICK));
return $subAffSaleStats->getStatsSelect();
}
