/**
* @service trend_stats read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$this->statParams = $this->createStatParams($data->getFilters());
$this->setActionAndCommissionId($data->getFilters());
$this->fillData($data, $params);
return $data;
}
/**
*
* @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;
}
/**
* Load affiliate detail for affiliate manager
*
* @service affiliate read
* @param $fields
*/
public function affiliateDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$search = $data->getFilters()->getFilter("id");
if (sizeof($search) == 1) {
$id = $search[0]->getValue();
}
$user = new Pap_Affiliates_User();
$user->setId($id);
try {
$user->load();
} catch (Gpf_DbEngine_NoRowException $e) {
return $data;
}
$data->setValue("id", $user->getId());
$data->setValue("name", $user->getFirstName()." ".$user->getLastName());
$data->setValue("username", $user->getUserName());
$formFields = $this->getUserFormFields();
foreach($formFields as $record) {
$code = $record->get('code');
$data->setValue($code, $user->get($code));
}
return $data;
}
/**
* @service campaign read
* @return Gpf_Data_RecordSet
*/
public function getActionTypes(Gpf_Rpc_Params $params) {
$actionTypesHeader = array(Pap_Db_Table_CommissionTypes::TYPE, Pap_Db_Table_CommissionTypes::NAME, Pap_Db_Table_CommissionTypes::ID, 'campaignName');
$data = new Gpf_Rpc_Data($params);
$filters = $data->getFilters();
$statsParams = new Pap_Stats_Params();
$statsParams->setCampaignId($filters->getFilterValue('campaignid'));
$statsParams->setBannerId($filters->getFilterValue('bannerid'));
$transactionTypeStats = new Pap_Stats_TransactionTypeStats($statsParams);
$transactionTypes = $transactionTypeStats->getTypes();
$actionTypesRecordSet = new Gpf_Data_RecordSet();
$actionTypesRecordSet->setHeader($actionTypesHeader);
$this->initActionCampaignNames();
foreach ($transactionTypes as $transactionType) {
if ($transactionType->getType() != Pap_Common_Constants::TYPE_SALE && $transactionType->getType() !=Pap_Common_Constants::TYPE_ACTION && $transactionType->getType() != Pap_Common_Constants::TYPE_RECURRING) {
continue;
}
$actionTypesRecordSet->add(new Gpf_Data_Record($actionTypesHeader, array($transactionType->getType(), $transactionType->getName(), $transactionType->getCommissionTypeId(), $this->getActionCampaignName($transactionType->getCommissionTypeId()))));
}
return $actionTypesRecordSet;
}
private function checkFilters(Gpf_Rpc_Data $data) {
$filters = $data->getFilters();
if ($filters->getSize() == 0 || count($filters->getFilter("datetime")) == 0) {
throw new Exception($this->_("Filter does not contain date parameters"));
}
return $filters;
}
/**
* @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 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;
}
/**
* @service mail_outbox read
* @param $fields
*/
public function mailDetails(Gpf_Rpc_Params $params)
{
$data = new Gpf_Rpc_Data($params);
$search = $data->getFilters()->getFilter("outboxid");
if (sizeof($search) == 1) {
$id = $search[0]->getValue();
}
$mail = $this->loadMailFromOutbox($id);
$mailTemplateObj = new Gpf_Db_MailTemplate();
$data->setValue("subject", $mail->getSubject());
$data->setValue("body_html", $mailTemplateObj->previewIncludedImages($mail->getHtmlBody()));
$data->setValue("body_text", $mail->getTextBody());
$data->setValue("attachments", $this->formatAttachments($mail->getAttachements()));
return $data;
}
/**
*
* @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;
}
/**
* Load transaction detail for transaction manager
*
* @service transaction_stats read
* @param $fields
*/
public function transactionDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$ids = $data->getFilters()->getFilter("id");
if (sizeof($ids) == 1) {
$id = $ids[0]->getValue();
}
$trans = $this->getTransactionData($id);
if($trans == null) {
return $data;
}
foreach ($trans as $name => $value) {
$data->setValue($name, $value);
}
return $data;
}
/**
* Load category detail for transaction manager
*
* @service banners_categories read
* @param $fields
*/
public function categoryDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$ids = $data->getFilters()->getFilter("id");
if (sizeof($ids) == 1) {
$id = $ids[0]->getValue();
}
$category = $this->getCategoryData($id);
if($category == null) {
return $data;
}
foreach ($category as $name => $value) {
$data->setValue($name, $this->_localize($value));
}
return $data;
}
/**
* @service pay_affiliate read
* @param $fields
* @throws Gpf_Exception
*/
public function payeesDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$idFilter = $data->getFilters()->getFilter('id');
if (sizeof($data) != 1) {
throw new Gpf_Exception('No id specified');
}
$id = $idFilter[0]->getValue();
$payeeData = $this->getPayeeData(array($id));
$i = 0;
foreach($payeeData as $id => $payee) {
foreach($payee['users'] as $user) {
$payeeDataObject = new Gpf_Rpc_Data();
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::USERNAME, $user[Gpf_Db_Table_AuthUsers::USERNAME]);
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::FIRSTNAME, $user[Gpf_Db_Table_AuthUsers::FIRSTNAME]);
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::LASTNAME, $user[Gpf_Db_Table_AuthUsers::LASTNAME]);
$payeeDataObject->setValue(Pap_Db_Table_Payouts::AMOUNT, $user[Pap_Db_Table_Payouts::AMOUNT]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(3), $user[Pap_Db_Table_Users::getDataColumnName(3)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(4), $user[Pap_Db_Table_Users::getDataColumnName(4)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(5), $user[Pap_Db_Table_Users::getDataColumnName(5)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(6), $user[Pap_Db_Table_Users::getDataColumnName(6)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(7), $user[Pap_Db_Table_Users::getDataColumnName(7)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(8), $user[Pap_Db_Table_Users::getDataColumnName(8)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(9), $user[Pap_Db_Table_Users::getDataColumnName(9)]);
$data->setValue("user$i", $payeeDataObject->toObject());
$i++;
}
}
return $data;
}
private function getFilter($filterName, Gpf_Rpc_Data $data) {
$filters = $data->getFilters()->getFilter($filterName);
if (count($filters)>0) {
return $filters[0]->getValue();
}
return null;
}
/**
* @service campaign read
* @return Gpf_Rpc_Serializable
*/
public function getLongDescription(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$search = $data->getFilters()->getFilter("id");
if (sizeof($search) == 1) {
$id = $search[0]->getValue();
}
$campaign = new Pap_Db_Campaign();
$campaign->setId($id);
$campaign->load();
$longDescription = $this->_localize($campaign->getLongDescription());
if($longDescription == '') {
$longDescription = $this->_('Empty');
}
$data->setValue("longdescription", $longDescription);
return $data;
}
