/** * @service quick_stats read * @param $fields */ public function load(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $this->statsParams = $this->getStatsParams(); $this->statsParams->initFrom($data->getFilters()); $this->fillData($data, $params); return $data; }
/** * * @service affiliate_stats read * @param $data */ public function load(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $filters = $data->getFilters(); $statsParams = new Pap_Stats_Params(); $statsParams->initFrom($filters); $transactions = new Pap_Stats_Transactions($statsParams); $select = new Gpf_SqlBuilder_SelectBuilder(); $select->from->add(Pap_Db_Table_Users::getName(), "pu"); $select->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "gu.accountuserid = pu.accountuserid"); $select->select->add("SUM(IF(pu.rtype = '". Pap_Application::ROLETYPE_AFFILIATE ."', 1, 0))", "countAffiliates"); $select->select->add("SUM(IF(gu.rstatus = 'A', 1, 0))", "approvedAffiliates"); $select->select->add("SUM(IF(gu.rstatus = 'P', 1, 0))", "pendingAffiliates"); $filters->addTo($select->where); $select->where->add("pu.".Pap_Db_Table_Users::TYPE, "=", Pap_Application::ROLETYPE_AFFILIATE); $row = $select->getOneRow(); $data->setValue("countAffiliates", $this->checkNullValue($row->get("countAffiliates"))); $data->setValue("approvedAffiliates", $this->checkNullValue($row->get("approvedAffiliates"))); $data->setValue("pendingAffiliates", $this->checkNullValue($row->get("pendingAffiliates"))); $data->setValue("totalSales", $transactions->getTotalCost()->getAll()); $data->setValue("approvedCommissions", $transactions->getCommission()->getApproved()); $data->setValue("pendingCommissions", $transactions->getCommission()->getPending()); return $data; }
private function initStatParams(Gpf_Rpc_FilterCollection $filterCollection) { $this->statsParameters = new Pap_Stats_Params(); $this->statsParameters->initFrom($filterCollection); if (!$this->statsParameters->isDateFromDefined() || !$this->statsParameters->isDateToDefined()) { throw new Gpf_Exception("Date filter must be set in StatisticsBase class"); } if (!$this->statsParameters->isStatusDefined()) { $this->statsParameters->setStatus(Pap_Common_Constants::STATUS_APPROVED); } }
/** * * @service pay_affiliate_stats read * @param $data */ public function load(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $statsParams = new Pap_Stats_Params(); $statsParams->initFrom($data->getFilters()); $transactions = new Pap_Stats_Transactions($statsParams); $data->setValue("paid", $this->getPaidData($data->getFilters())); $data->setValue("unpaidApprovedComm", $transactions->getCommission()->getApproved()); $data->setValue("unpaidPendingComm", $transactions->getCommission()->getPending()); $data->setValue("unpaidDeclinedComm", $transactions->getCommission()->getDeclined()); return $data; }
/** * * @service campaign_stats read * @param $data */ public function load(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $statsParams = new Pap_Stats_Params(); $statsParams->initFrom($data->getFilters()); $transactions = new Pap_Stats_Transactions($statsParams); $data->setValue("totalCommisions", $transactions->getCommission()->getAll()); $data->setValue("totalSales", $transactions->getTotalCost()->getAll()); $data->setValue("totalPendingCommisions", $transactions->getCommission()->getPending()); $data->setValue("totalUnpaidApprovedCommisions", $transactions->getCommission()->getApproved()); return $data; }
/** * @return Pap_Stats_Params */ protected function createStatParams(Gpf_Rpc_FilterCollection $filters) { $statParams = new Pap_Stats_Params(); $statParams->initFrom($filters); if (!$statParams->isStatusDefined()) { $statParams->setStatus(Pap_Common_Constants::STATUS_APPROVED); } $statParams->setDateFrom(new Gpf_DateTime(0)); $statParams->setDateTo(new Gpf_DateTime()); $dateFilter = $filters->getFilter("datetime"); if (sizeof($dateFilter) > 0) { $this->setDateFilter($statParams, $dateFilter); } return $statParams; }
/** * * @service banner_stats read * @param $data */ public function loadFilteredStatistics(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $statsParams = new Pap_Stats_Params(); $statsParams->initFrom($data->getFilters()); $impressions = new Pap_Stats_Impressions($statsParams); $clicks = new Pap_Stats_Clicks($statsParams); $sales = new Pap_Stats_Sales($statsParams); $data->setValue("impressions", $impressions->getCount()->getAll()); $data->setValue("rawClicks", $clicks->getCount()->getRaw()); $data->setValue("uniqueClicks", $clicks->getCount()->getUnique()); $data->setValue("sales", $sales->getCount()->getApproved()); $data->setValue("ctr", 0); if ($impressions->getCount()->getAll() !== 0) { $data->setValue("ctr", $clicks->getCount()->getAll() / ($impressions->getCount()->getAll() / 100)); } return $data; }
/** * @service traffic_stats read * @param $data */ public function getTransactionsData(Gpf_Rpc_Params $params) { $data = new Gpf_Rpc_Data($params); $filters = $this->checkFilters($data); $statsParameters = new Pap_Stats_Params(); $statsParameters->initFrom($filters); $transactions = new Pap_Stats_Transactions($statsParameters); $data->setValue("transactionsCount", $transactions->getCount()->getAll()); $data->setValue("transactionsCountApproved", $transactions->getCount()->getApproved()); $data->setValue("transactionsCountDeclined", $transactions->getCount()->getDeclined()); $data->setValue("transactionsCountPaid", $transactions->getCount()->getPaid()); $data->setValue("transactionsCountPending", $transactions->getCount()->getPending()); $data->setValue("transactionsTotalCost", $transactions->getTotalCost()->getAll()); $data->setValue("transactionsTotalCostApproved", $transactions->getTotalCost()->getApproved()); $data->setValue("transactionsTotalCostDeclined", $transactions->getTotalCost()->getDeclined()); $data->setValue("transactionsTotalCostPaid", $transactions->getTotalCost()->getPaid()); $data->setValue("transactionTotalCostPending", $transactions->getTotalCost()->getPending()); $data->setValue("transactionsCommission", $transactions->getCommission()->getAll()); $data->setValue("transactionsCommissionApproved", $transactions->getCommission()->getApproved()); $data->setValue("transactionsCommissionDeclined", $transactions->getCommission()->getDeclined()); $data->setValue("transactionsCommissionPaid", $transactions->getCommission()->getPaid()); $data->setValue("transactionsCommissionPending", $transactions->getCommission()->getPending()); return $data; }
protected function initAllSubAffStats() { $statParams = new Pap_Stats_Params(); $statParams->initFrom($this->filters); $statParams->setType(Pap_Common_Constants::TYPE_SALE . ',' . Pap_Common_Constants::TYPE_CLICK); $transactionStats = new Pap_Stats_Computer_TransactionsStatsBuilder($statParams, Pap_Db_Table_Transactions::USER_ID, Pap_Db_Table_Transactions::USERID, false); $transactionStats->getTransactionsWhereClause()->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '!=', null); $transactionStats->getTransactionsWhereClause()->add(Pap_Db_Table_Transactions::PARRENT_TRANSACTION_ID, '<>', ''); $allSubStats = $transactionStats->getStatsSelect(); try { $allSubStatsRow = $allSubStats->getOneRow(); $this->subAffCommissions = $allSubStatsRow->get(Pap_Db_Table_Transactions::COMMISSION); $this->subAffSaleCount = $allSubStatsRow->get('count'); } catch (Gpf_DbEngine_NoRowException $e) { $this->subAffCommissions = 0; $this->subAffSaleCount = 0; } }
/** * @return Pap_Stats_Params */ protected function getStatsParameters() { $params = new Pap_Stats_Params(); $params->initFrom($this->filters); if (!$params->isStatusDefined()) { $params->setStatus(Pap_Common_Constants::STATUS_APPROVED); } return $params; }