/**
* @param array $requestArray
* @return StdClass
*/
function decode($requestArray)
{
$param = new stdClass();
$reservedParams = array(Gpf_Rpc_Params::CLASS_NAME, Gpf_Rpc_Params::METHOD_NAME, Gpf_Rpc_Params::SESSION_ID, Gpf_Rpc_Server::FORM_REQUEST, Gpf_Rpc_Server::FORM_RESPONSE);
$recordset = new Gpf_Data_RecordSet();
$recordset->setHeader(array("name", "value"));
foreach ($requestArray as $name => $value) {
if (in_array($name, $reservedParams)) {
continue;
}
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
$record = $recordset->createRecord();
$record->set("name", $name);
$record->set("value", $value);
$recordset->add($record);
}
$param->fields = $recordset->toObject();
foreach ($reservedParams as $paramName) {
if (array_key_exists($paramName, $requestArray)) {
$param->{$paramName} = $requestArray[$paramName];
}
}
return $param;
}
public function addValue($code, $value)
{
$record = $this->recordSet->createRecord();
$record->set(self::CODE, $code);
$record->set(self::VALUE, $value);
$this->recordSet->addRecord($record);
}
/**
* @service channel write
*
* @param $fields
* @return Gpf_Rpc_Action
*/
public function saveFields(Gpf_Rpc_Params $params) {
$action = new Gpf_Rpc_Action($params);
$action->setErrorMessage($this->_('Failed to save %s field(s)'));
$action->setInfoMessage($this->_('%s field(s) successfully saved'));
$fields = new Gpf_Data_RecordSet();
$fields->loadFromArray($action->getParam("fields"));
$channels = Pap_Db_Table_Channels::getUserChannels(Gpf_Session::getAuthUser()->getPapUserId());
foreach ($fields as $field) {
$isUnique = true;
foreach ($channels as $channel) {
if ($field->get('value') == $channel->get(Pap_Db_Table_Channels::VALUE)) {
$isUnique = false;
break;
}
}
if ($isUnique) {
$this->saveField($field);
} else {
$action->setErrorMessage($this->_("Failed to save %s field(s). Data with value '".$field->get('value').
"' already exist. Data must be unique."));
$action->addError();
return $action;
}
}
$action->addOk();
return $action;
}
protected function saveFieldsRpc(Gpf_Rpc_Params $params) {
$action = new Gpf_Rpc_Action($params);
$action->setErrorMessage($this->_('Failed to save %s field(s) in %s(s)', '%s', $this->getDbRowObjectName()));
$action->setInfoMessage($this->_('%s field(s) in %s(s) successfully saved', '%s', $this->getDbRowObjectName()));
$fields = new Gpf_Data_RecordSet();
$fields->loadFromArray($action->getParam("fields"));
foreach ($fields as $field) {
$dbRow = $this->createDbRowObject();
$dbRow->setPrimaryKeyValue($field->get(Gpf_Db_Table_FormFields::ID));
$dbRow->load();
$dbRow->setName($field->get(Gpf_Db_Table_FormFields::NAME));
$dbRow->setStatus($field->get(Gpf_Db_Table_FormFields::STATUS));
$dbRow->setType($field->get(Gpf_Db_Table_FormFields::TYPE));
if ($field->get(Gpf_Db_Table_FormFields::AVAILABLEVALUES) != null) {
$dbRow->setAvailableValues($field->get(Gpf_Db_Table_FormFields::AVAILABLEVALUES));
}
$dbRow->save();
$action->addOk();
}
return $action;
}
/**
* @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;
}
public function getNumberOfSubaffiliates($userid = null) {
$result = new Gpf_Data_RecordSet();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('COUNT(u.userid)', 'amount');
$selectBuilder->from->add(Pap_Db_Table_Users::getName(), "u");
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), "gu", "u.accountuserid = gu.accountuserid");
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), "au", "gu.authid = au.authid");
$selectBuilder->where->add('u.deleted', '=', Gpf::NO);
if ($userid === null) {
$selectBuilder->where->add('u.parentuserid', '=', Gpf_Session::getAuthUser()->getPapUserId());
} else {
$selectBuilder->where->add('u.parentuserid', '=', $userid);
}
$selectBuilder->where->add('gu.rstatus', '<>', 'D');
if ($this->params->isDateFromDefined()) {
$selectBuilder->where->add('u.' . Pap_Stats_Table::DATEINSERTED, '>=', $this->params->getDateFrom()->toDateTime());
}
if ($this->params->isDateToDefined()) {
$selectBuilder->where->add('u.' . Pap_Stats_Table::DATEINSERTED, '<=', $this->params->getDateTo()->toDateTime());
}
$selectBuilder->limit->set(0, 1);
$result->load($selectBuilder);
if($result->getSize() == 0) {
return 0;
}
foreach($result as $record) {
return $record->get('amount');
}
}
/**
* Save role privileges
*
* @service role write
* @param Gpf_Rpc_Params $params
* @return Gpf_Rpc_Form
*/
public function saveRolePrivileges(Gpf_Rpc_Params $params)
{
$form = new Gpf_Rpc_Form($params);
$role = new Gpf_Db_Role();
$role->setId($form->getFieldValue('roleid'));
$role->load();
if (!strlen($role->getAccountId())) {
$form->setErrorMessage($this->_('It is not possible to changes privileges for default role %s', $role->getName()));
return $form;
}
//delete all privileges for selected role
Gpf_Db_Table_RolePrivileges::getInstance()->deleteAllPrivileges($role->getId());
//insert all privileges again to database
$objects = new Gpf_Data_RecordSet();
$objects->loadFromArray($form->getFieldValue('objects'));
foreach ($objects as $record) {
$rights = explode(',', $record->get('privileges'));
foreach ($rights as $right) {
$privilege = new Gpf_Db_RolePrivilege();
$privilege->setObject($record->get('object'));
$privilege->setRoleId($role->getId());
$privilege->setPrivilege($right);
$privilege->insert();
}
}
$form->setInfoMessage($this->_('Changes saved'));
return $form;
}
/**
* @service mail_template write
* @param $fields
* @return Gpf_Rpc_Form
*/
public function save(Gpf_Rpc_Params $params)
{
$form = new Gpf_Rpc_Form($params);
try {
$mailTemplate = $this->loadMailTemplate($form->getFieldValue('templateid'));
} catch (Gpf_Exception $e) {
$form->setErrorMessage($this->_('Failed to load mail template with error: %s', $e->getMessage()));
return $form;
}
try {
$className = $mailTemplate->get(Gpf_Db_Table_MailTemplates::CLASS_NAME);
$objTemplate = new $className();
$templateVariables = new Gpf_Data_RecordSet();
$templateVariables->setHeader(array('id', 'value'));
foreach ($objTemplate->getTemplateVariables() as $code => $name) {
$record = $templateVariables->createRecord();
$record->set('id', $code);
$record->set('value', $form->getFieldValue('var_' . $code));
$templateVariables->add($record);
}
$objTemplate->setCachedVariableValues($templateVariables);
$objTemplate->addRecipient($form->getFieldValue('recipient'));
$objTemplate->sendNow();
} catch (Gpf_Exception $e) {
$form->setErrorMessage($this->_('Failed to send test mail with error: %s', $e->getMessage()));
return $form;
}
$form->setInfoMessage($this->_('Test mail was successfully queued'));
return $form;
}
public function toObject()
{
$object = new stdClass();
$object->rows = $this->rows->toObject();
$object->from = $this->from;
$object->to = $this->to;
$object->count = $this->count;
return $object;
}
private function setData(Gpf_Data_RecordSet $recordSet, $totalCount = null)
{
$this->cachedData = $recordSet;
if ($totalCount == null) {
$this->size = $this->cachedData->getSize();
return;
}
$this->size = $totalCount;
}
/**
*
* @return Gpf_Data_RecordSet
*/
private function getAvailableLanguages()
{
$languages = new Gpf_Data_RecordSet();
$languages->setHeader(array('id', 'name'));
foreach (new Gpf_Lang_InstallLanguages() as $language) {
$languages->add(array($language->getCode(), $language->getExtendedName()));
}
return $languages;
}
/**
* @service banner_format_setting read
* @return Gpf_Data_RecordSet
*/
public function loadWrapperNames(Gpf_Rpc_Params $params) {
$row = new Pap_Db_BannerWrapper();
$collection = $row->loadCollection();
$result = new Gpf_Data_RecordSet();
$result->setHeader(array('id', 'name'));
foreach ($collection as $row){
$result->add(array($row->getId(), $row->getName()));
}
return $result;
}
/**
* returns data for chart
*
* @service trend_stats read
* @param $fields
* @return Gpf_Rpc_Chart
*/
public function loadDataTypes(Gpf_Rpc_Params $params) {
$this->initCampaignId($params);
$this->initDataTypes();
$recordSet = new Gpf_Data_RecordSet();
$recordSet->setHeader(array("id", "value"));
foreach ($this->dataTypes as $dataType) {
$recordSet->add(array($dataType->getId(), $dataType->getName()));
}
return $recordSet;
}
/**
* Load list of template variables for custom template
*
* @service mail_template read
* @param Gpf_Rpc_Params $params
*/
public function getTemplateVariables(Gpf_Rpc_Params $params)
{
$recordSet = new Gpf_Data_RecordSet();
$recordSet->setHeader(array('code', 'name'));
//TODO - treba prerobit cez extension point ... v pap newsletter feature budu premenne definovane cez Pap_Mail_UserMail
$objTemplate = new Pap_Mail_UserMail();
foreach ($objTemplate->getTemplateVariables() as $code => $name) {
$recordSet->add(array($code, $name));
}
return $recordSet;
}
private function fillFromUser(Gpf_Rpc_Form $form, Pap_Affiliates_User $user) {
$userData = new Gpf_Data_RecordSet();
$userData->setHeader(array('userid', 'username','firstname', 'lastname'));
$data = $userData->createRecord();
$data->add('userid', $user->getId());
$data->add('username', $user->getUserName());
$data->add('firstname', $user->getFirstName());
$data->add('lastname', $user->getLastName());
$userData->add($data);
$form->setField('userid', null, $userData->toObject());
}
/**
* @param string $roleId
* @return Gpf_Data_RecordSet
*/
public function getAllPrivileges($roleId)
{
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(self::ID, 'id');
$select->select->add(self::OBJECT, 'object');
$select->select->add(self::PRIVILEGE, 'privilege');
$select->from->add(self::getName());
$select->where->add(self::ROLE_ID, "=", $roleId);
$privileges = new Gpf_Data_RecordSet();
$privileges->load($select);
return $privileges;
}
private function getCampaignRecordSetForAffiliate() {
$selectBuilder = $this->createSelectBuilder();
$selectBuilder->select->add('c.'.Pap_Db_Table_Campaigns::STATUS, 'rstatus');
$selectBuilder->select->add('c.'.Pap_Db_Table_Campaigns::TYPE, 'rtype');
Gpf_Plugins_Engine::extensionPoint('Pap_Common_Campaign_CampaignForAffiliateRichListBox.getCampaignRecordSetForAffiliate',
new Pap_Affiliates_Promo_SelectBuilderCompoundFilter($selectBuilder));
$result = new Gpf_Data_RecordSet();
$result->load($selectBuilder);
return $result;
}
private function loadSubfilesFiles($fileUrl, Gpf_Data_RecordSet $result, $directories = false)
{
foreach (new Gpf_Io_DirectoryIterator($fileUrl, '', false, $directories) as $fullFileName => $file) {
$file = new Gpf_Io_File($fullFileName);
if ($file->isDirectory()) {
$filesData = $this->getFilesData($fullFileName);
$result->add(array($fullFileName, $filesData['count'], $file->getName(), $filesData['size'], self::TYPE_DIRECTORY));
continue;
}
$result->add(array($fullFileName, 0, $file->getName(), $file->getSize(), self::TYPE_FILE));
}
}
/**
* Load list of template variables for custom template
*
* @service mail_template read
* @param Gpf_Rpc_Params $params
*/
public function getTemplateVariables(Gpf_Rpc_Params $params) {
$recordSet = new Gpf_Data_RecordSet();
$recordSet->setHeader(array('code', 'name'));
$objTemplate = new Pap_Mail_UserMail();
foreach ($objTemplate->getTemplateVariables() as $code => $name) {
$recordSet->add(array($code, $name));
}
return $recordSet;
}
/**
* Load list of template variables for template specified in input parameter templateId
*
* @service mail_template read
* @param Gpf_Rpc_Params $params
*/
public function getTemplateVariables(Gpf_Rpc_Params $params)
{
$dbRow = $this->loadMailTemplate($params->get("templateId"));
$recordSet = new Gpf_Data_RecordSet();
$recordSet->setHeader(array('code', 'name'));
$className = $dbRow->get(Gpf_Db_Table_MailTemplates::CLASS_NAME);
$objTemplate = new $className();
foreach ($objTemplate->getTemplateVariables() as $code => $name) {
$recordSet->add(array($code, $name));
}
return $recordSet;
}
/**
* @param String $viewtype
*
* @return Gpf_Data_RecordSet
*/
public function getAllWallpapers()
{
$result = new Gpf_Data_RecordSet();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add(self::ID, 'id');
$selectBuilder->select->add(self::NAME, 'name');
$selectBuilder->select->add(self::URL, 'url');
$selectBuilder->select->add(self::FILEID, 'fileid');
$selectBuilder->from->add(self::getName());
$selectBuilder->where->add(self::ACCOUNTUSERID, '=', Gpf_Session::getAuthUser()->getAccountUserId());
$result->load($selectBuilder);
return $result;
}
public function getAllIconsNoRpc()
{
$response = new Gpf_Data_RecordSet();
$response->setHeader(array("iconName", "smallIcon", "middleIcon", "bigIcon"));
foreach ($this->icons as $iconName => $imageFile) {
try {
$response->add(array($iconName, $this->getImageUrl($imageFile, "small"), $this->getImageUrl($imageFile, "middle"), $this->getImageUrl($imageFile, "big")));
} catch (Exception $e) {
//TODO: add default image !
}
}
return $response;
}
/**
* Gets template names for template name suggestion oracle
*
* @service template read
* @param $search
*/
public function getTemplateNames(Gpf_Rpc_Params $params)
{
$searchString = $params->get('search');
$this->loadTemplates();
$result = new Gpf_Data_RecordSet();
$result->setHeader(array('id', 'name'));
foreach ($this->templates as $templateName) {
if ($searchString == "" || strstr($templateName, $searchString) !== false) {
$result->add(array($templateName, $templateName . '.tpl'));
}
}
return $result;
}
protected function afterExecute(Gpf_Data_RecordSet $inputResult)
{
$inputResult->addColumn('default', Gpf::NO);
$defaultCountry = Gpf_Settings::get(Gpf_Settings_Gpf::DEFAULT_COUNTRY);
foreach ($inputResult as $country) {
if ($country->get(Gpf_Db_Table_Countries::COUNTRY_CODE) == $defaultCountry) {
$country->set('country', $this->_localize($country->get('country')) . ' ' . $this->_('(default)'));
$country->set('default', Gpf::YES);
continue;
}
$country->set('country', $this->_localize($country->get('country')));
}
return $inputResult;
}
/**
* @param String commissionTypeId
*
* @return Gpf_Data_RecordSet
*/
public function getAllCommissionTypeAttributes($commissionTypeId) {
$result = new Gpf_Data_RecordSet('id');
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add(self::ID, 'attributeid');
$selectBuilder->select->add(self::COMMISSION_TYPE_ID, 'commtypeid');
$selectBuilder->select->add(self::NAME, 'name');
$selectBuilder->select->add(self::VALUE, 'value');
$selectBuilder->from->add(self::getName());
$selectBuilder->where->add(self::ID, '=', $commissionTypeId);
$result->load($selectBuilder);
return $result;
}
/**
* @param Gpf_Data_RecordSet $recordset
* @return Gpf_Data_Record
*/
public function toRecord(Gpf_Data_RecordSet $recordset)
{
$record = $recordset->createRecord();
$record->set(self::CODE, $this->getCodeName());
$record->set(self::NAME, $this->getName());
$record->set(self::URL, $this->getUrl());
$record->set(self::DESCRIPTION, $this->getDescription());
$record->set(self::VERSION, $this->getVersion());
$record->set(self::AUTHOR, $this->getAuthor());
$record->set(self::AUTHOR_URL, $this->getAuthorUrl());
$record->set(self::HELP, $this->getHelp());
$record->set(self::ACTIVE, 'N');
$record->set(self::CONFIG_CLASS_NAME, $this->getConfigurationClassName());
return $record;
}
private function getAllRowsRecordSet(Gpf_Data_RecordSet $recordSet)
{
try {
$sth = $this->execute();
} catch (Gpf_DbEngine_NoRowException $e) {
return $recordSet;
}
$row = $sth->fetchArray();
$recordSet->setHeader(array_keys($row));
$recordSet->add(array_values($row));
while ($row = $sth->fetchRow()) {
$recordSet->add($row);
}
return $recordSet;
}
/**
* Load list of template variables for custom template
*
* @service mail_template read
* @param Gpf_Rpc_Params $params
*/
public function getTemplateVariables(Gpf_Rpc_Params $params) {
$recordSet = new Gpf_Data_RecordSet();
$recordSet->setHeader(array('code', 'name'));
$objTemplate = new Pap_Mail_AffiliateUserMail();
foreach ($objTemplate->getTemplateVariables() as $code => $name) {
if($code == 'password' || $code == 'parent_password'){
continue;
}
$recordSet->add(array($code, $name));
}
return $recordSet;
}
protected function buildData(Gpf_Data_RecordSet $fields, Gpf_Rpc_Params $params) {
$selectBuilder = Pap_Db_Table_Commissions::getInstance()->getAllCommissionsInCampaignSelectBuilder($params->get('campaignid'), '');
$selectBuilder->orderBy->add('c.' . Pap_Db_Table_Commissions::ID);
$selectBuilder->orderBy->add('tier');
$selectBuilder->orderBy->add('ct.' . Pap_Db_Table_CommissionTypes::PARENT_COMMISSIONTYPE_ID);
$commissionGroupID = $this->getCommissionGroupId($params->get('campaignid'));
foreach ($selectBuilder->getAllRowsIterator() as $commission) {
if ($commission->get('commissiongroupid') != $commissionGroupID) {
continue;
}
$fields->add($this->createRecordArray($commission));
$this->addCommission($commission);
}
}
protected function afterExecute(Gpf_Data_RecordSet $inputResult) {
$outputResult = new Gpf_Data_RecordSet();
$campaignFilter = $this->filters->getFilter('campaignid');
if (count($campaignFilter)>0) {
$filterValue = $campaignFilter[0]->getValue();
$categories = $this->getCampaignCategories($filterValue);
}
foreach ($inputResult as $record) {
if ($record->get('code')=='0') {
continue;
}
$record->set('name', $this->_localize($record->get('name')));
if (count($campaignFilter)>0) {
$filterValue = $campaignFilter[0]->getValue();
if (in_array($record->get('code'), $categories)) {
$record->add('selected', 'Y');
} else {
$record->add('selected', 'N');
}
}
$outputResult->add($record);
}
$outputResult->setHeader($inputResult->getHeader());
$outputResult->getHeader()->add('selected');
return $outputResult;
}
