/**
*
* @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;
}
/**
*
* @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;
}
public function add(Pap_Stats_Transactions $transactions) {
$this->commission->add($transactions->getCommission());
$this->count->add($transactions->getCount());
$this->totalCost->add($transactions->getTotalCost());
}
/**
* @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;
}
