/**
* 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;
}
/**
* @param Gpf_Rpc_Params $params
* @service
* @anonym
* @return Gpf_Rpc_Data
*/
public function check(Gpf_Rpc_Params $params)
{
$data = new Gpf_Rpc_Data($params);
$text = $data->getParam('teststring');
$dataOut = new Gpf_Rpc_Data();
$dataOut->setValue('status', 'OK');
$dataOut->setValue('recieved', $text);
return $dataOut;
}
/**
*
* @service financial_overview read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$transactions = new Pap_Stats_Transactions(new Pap_Stats_Params());
$data->setValue("approvedCommissions", round($transactions->getCommission()->getApproved(), 2));
$data->setValue("pendingCommissions", round($transactions->getCommission()->getPending(), 2));
return $data;
}
/**
* @service campaigns_categories read
* @param $fields
*/
public function loadTree(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$tree = new Pap_Features_CampaignsCategories_Tree(false, array('Y'));
$tree->laod();
$data->setValue(Pap_Features_CampaignsCategories_TreePanel::CAMPAIGNS_CATEGORIES_TREE, $tree->toJSON());
$data->setValue(Pap_Features_CampaignsCategories_TreePanel::CAMPAIGNS_CATEGORIES_TREE_MAXITEMCODE, '0');
return $data;
}
/**
* @service banners_categories read
* @param $fields
*/
public function loadTree(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$tree = new Pap_Features_BannersCategories_Tree(false);
$tree->laod();
$data->setValue(self::BANNERS_CATEGORIES_TREE, $tree->toJSON());
$data->setValue(self::BANNERS_CATEGORIES_TREE_MAXITEMCODE, $tree->getMaxCode());
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;
}
/**
*
* @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 period_stats read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$thisMonthParams = $this->getStatsParams(Gpf_Data_Filter::RANGE_THIS_MONTH);
$transactions = new Pap_Stats_Transactions($thisMonthParams);
$data->setValue('totalCommisonsApprovedUnpaid', $transactions->getCommission()->getApproved());
$data->setValue('totalCommissionsPending', $transactions->getCommission()->getPending());
$data->setValue('totalCommissionsPaid', $transactions->getCommission()->getPaid());
$data->setValue('generalAffiliateLink', self::getAffiliateLink());
return $data;
}
/**
*
* @service pending_task read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$data->setValue("pendingAffiliates", $this->getPendingAffiliatesCount());
$data->setValue("pendingDirectLinks", $this->getPendingDirectLinksCount());
$transactionsInfo = $this->getPendingTransactionsInfo();
$data->setValue("pendingCommissions", $transactionsInfo->get("pendingCommissions"));
$data->setValue("totalCommissions", $transactionsInfo->get("totalCommissions"));
$data->setValue("unsentEmails", $this->getUnsentEmails());
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;
}
/**
*
* @param $message
* @param $simulation
* @return Gpf_Rpc_Form
*/
private function action(Gpf_Rpc_Params $params, $message = '', $simulation = false) {
$data = new Gpf_Rpc_Data($params);
$filters = new Gpf_Rpc_FilterCollection($params);
if ($filters->getFilterValue('reachedCondition') == Gpf::YES) {
$data->setValue('message', $message);
return $data;
}
$compressedCommissionProcesor = new Pap_Features_CompressedCommissionPlacementModel_Processor();
$output = $compressedCommissionProcesor->recalculate($params->get('filters'), $simulation);
$data->setValue('message', $output);
return $data;
}
/**
* @service sub_aff_stats read
* @param $fields
*/
public function load(Gpf_Rpc_Params $rpcParams) {
$data = new Gpf_Rpc_Data($rpcParams);
$data->setValue("numberOfSubaffiliates", $this->getNumberOfSubaffiliates());
return $data;
}
/**
* @service affiliate_panel_settings read
* @param $fields
*/
public function loadTree(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$data->setValue(Pap_Settings::AFFILIATE_MENU, Gpf_Settings::get(Pap_Settings::AFFILIATE_MENU));
return $data;
}
/**
* @service link_cloaker read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$data->setValue("urlToProtect", Pap_Affiliates_MainPanelHeader::getAffiliateLink());
return $data;
}
public function getDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
foreach ($this->fieldValues as $code => $value) {
$data->setValue($code, $value);
}
return $data;
}
/**
* @service coupon read
* @param Id
* @return Gpf_Rpc_Data
*/
public function loadCouponsCount(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$coupon = new Pap_Features_Coupon_Coupon();
$coupon->setId($data->getId());
try {
$coupon->load();
} catch (Gpf_DbEngine_NoRowException $e) {
return $data;
}
$couponsUsed = $coupon->getCouponsCount(Gpf_Session::getAuthUser()->getPapUserId());
$data->setValue('usedcoupons', $couponsUsed);
$data->setValue('availablecoupons', $this->computeAvailableCoupons($coupon, $couponsUsed));
$data->setValue('validcoupons', $coupon->getValidCouponsCount(Gpf_Session::getAuthUser()->getPapUserId()));
return $data;
}
/**
* @service country read
* @anonym
* @return Gpf_Rpc_Data
*/
public function loadDefaultCountry(Gpf_Rpc_Params $params)
{
$data = new Gpf_Rpc_Data($params);
$context = new Gpf_Plugins_ValueContext(Gpf_Settings::get(Gpf_Settings_Gpf::DEFAULT_COUNTRY));
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Countries.getDefaultCountry', $context);
$data->setValue('default', $context->get());
return $data;
}
/**
* @service affiliate_login_form read
* @param Gpf_Rpc_Params $params
* @return Gpf_Rpc_Data
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$loginFormPanel = new Gpf_Ui_TemplatePanel("login_form_downloadable.tpl", "affiliates");
$loginFormPanel->add('<input type="text" name="username">', "username");
$loginFormPanel->add('<input type="password" name="password">', "password");
$loginFormPanel->add('<input type="checkBox" name="rememberMe">', "rememberMe");
$loginFormPanel->add('<input type="submit" value="' . $this->_("Login") . '">', "LoginButton");
$loginFormPanelHtml = '<form action="' . self::getLoginScriptUrl() . '" method="post">'
. $loginFormPanel->render()
. '</form>';
$data->setValue("formSource", $loginFormPanelHtml);
$data->setValue("formPreview", $loginFormPanelHtml);
return $data;
}
/**
* Load Location information for Ip address specified in Id
*
* @anonym
* @service geoip read
* @param $fields
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$location = new GeoIp_Location();
$location->setIpString($data->getId());
$location->load();
$data->setValue('ip', $location->getIpString());
$data->setValue('countryCode', $location->getCountryCode());
$data->setValue('countryName', $location->getCountryName());
$data->setValue('city', $location->getCity());
$data->setValue('areaCode', $location->getAreaCode());
$data->setValue('dmaCode', $location->getDmaCode());
$data->setValue('latitude', $location->getLatitude());
$data->setValue('longitude', $location->getLongitude());
$data->setValue('postalCode', $location->getPostalCode());
$data->setValue('region', $location->getRegion());
return $data;
}
/**
* @service pay_affiliate read
* @param $data
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add("au.username","userName");
$select->select->add("au.firstname","firstName");
$select->select->add("au.lastname","lastname");
$select->select->add("SUM(t.".Pap_Db_Table_Transactions::COMMISSION.")", "payout");
$select->select->add("pu.".Pap_Db_Table_Users::MINIMUM_PAYOUT, "minimumPayout");
$select->select->add("IFNULL(po.".Gpf_Db_Table_FieldGroups::NAME.", 'undefined')", "payoutMethod");
$select->from->add(Pap_Db_Table_Transactions::getName(), "t");
$select->from->addInnerJoin(Pap_Db_Table_Users::getName(), "pu", "t.userid = pu.userid");
$select->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "pu.accountuserid = gu.accountuserid");
$select->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$select->groupBy->add("t.".Pap_Db_Table_Transactions::USER_ID);
$select->from->addLeftJoin(Gpf_Db_Table_FieldGroups::getName(), "po", "pu.payoutoptionid = po.fieldgroupid");
$select->where->add("t.".Pap_Db_Table_Transactions::USER_ID, "=", $params->get("id"));
$row = $select->getOneRow();
$data->setValue("userName", $row->get("userName"));
$data->setValue("firstName", $row->get("firstName"));
$data->setValue("lastname", $row->get("lastname"));
$data->setValue("payout", $row->get("payout"));
$data->setValue("minimumPayout", $row->get("minimumPayout"));
$data->setValue("payoutMethod", $row->get("payoutMethod"));
return $data;
}
/**
*
* @service
* @anonym
* @return Gpf_Rpc_Data
*/
public function ping(Gpf_Rpc_Params $params)
{
$sql = new Gpf_SqlBuilder_SelectBuilder();
$sql->select->addAll(Gpf_Db_Table_AuthUsers::getInstance());
$sql->from->add(Gpf_Db_Table_AuthUsers::getName());
$count = $sql->getAllRows()->getSize();
if ($count == 0) {
throw new Gpf_Exception($this->_('Ping failed'));
}
$data = new Gpf_Rpc_Data();
$data->setValue('status', 'OK');
return $data;
}
/**
* @anonym
* @service direct_link read
*/
public function getAffiliateId(Pap_Contexts_Click $context, Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$context = new Pap_Contexts_Click();
$context->getRequestObject()->setRequestParameter(
Pap_Tracking_Request::PARAM_REFERRERURL_NAME,
$params->get('url'));
$match = $this->getMatch($context);
if ($match != null) {
foreach ($match as $key => $value) {
$data->setValue($key, $value);
}
}
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 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;
}
/**
* Gets payout option name for Default payout method
*
* @service
* @anonym
* @param $id
*/
public function getPayoutName(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$payoutOption = new Gpf_Db_FieldGroup();
$this->setType(Pap_Common_Constants::FIELDGROUP_TYPE_PAYOUTOPTION);
$payoutOption->setPrimaryKeyValue($params->get('id'));
try {
$payoutOption->load();
$data->setValue('payoutoptionid', $payoutOption->getPrimaryKeyValue());
$data->setValue('name', $this->_localize($payoutOption->getName()));
} catch (Gpf_DbEngine_NoRowException $e) {
$data->setValue('payoutoptionid', null);
$data->setValue('name', $this->_('None'));
}
return $data;
}
/**
* @service
* @anonym
* @return Gpf_Rpc_Data
*/
public function load(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$data->setValue('affManagerContact', Pap_Merchants_User::getMerchantEmail());
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;
}
public static function setSessionInfo(Gpf_Rpc_Data $sessionInfo)
{
$sessionInfo->setValue('extra1', Pap_Db_Table_Users::getAffiliateCount());
}
/**
* Load fileName for import
*
* @service export_file read
* @param Gpf_Rpc_Params $params
* @return Gpf_Rpc_Data
*/
public function loadFileName(Gpf_Rpc_Params $params)
{
$data = new Gpf_Rpc_Data($params);
try {
$export = new Gpf_Db_Export();
$export->setPrimaryKeyValue($data->getId());
$export->load();
$fileUrl = $this->getFileUrl($export->getFileName());
$data->setValue("fileName", $fileUrl);
} catch (Gpf_DbEngine_NoRowException $e) {
$data->setValue("fileName", "");
}
return $data;
}
