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(); }