/** * * @service mail_outbox write * @param $ids * @return Gpf_Rpc_Action */ public function restartSendingMail(Gpf_Rpc_Params $params) { $action = new Gpf_Rpc_Action($params); $action->setErrorMessage($this->_('Failed to restart %s row(s)')); $action->setInfoMessage($this->_('%s row(s) successfully restarted')); foreach ($action->getIds() as $id) { try { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_MailOutbox::getName()); $update->set->add(Gpf_Db_Table_MailOutbox::ERROR_MSG, self::RESTART_ERROR_MSG); $update->set->add(Gpf_Db_Table_MailOutbox::RETRY_NR, self::RESTART_RETRY_NR); $update->set->add(Gpf_Db_Table_MailOutbox::SCHNEDULET_AT, Gpf_Common_DateUtils::now()); $update->where->add(Gpf_Db_Table_MailOutbox::ID, '=', $id, 'AND'); $update->where->add(Gpf_Db_Table_MailOutbox::STATUS, '=', self::STATUS_PENDING); $update->executeOne(); $action->addOk(); } catch (Exception $e) { $action->addError(); } } return $action; }
/** * @throws Gpf_Exception */ public function setCampaignDefault($campaignId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Pap_Db_Table_Campaigns::ACCOUNTID); $select->from->add(Pap_Db_Table_Campaigns::getName()); $select->where->add(Pap_Db_Table_Campaigns::ID, '=', $campaignId); $campaign = $select->getOneRow(); $oldCampaignSelect = new Gpf_SqlBuilder_SelectBuilder(); $oldCampaignSelect->select->add(Pap_Db_Table_Campaigns::ID); $oldCampaignSelect->from->add(Pap_Db_Table_Campaigns::getName()); $oldCampaignSelect->where->add(Pap_Db_Table_Campaigns::ACCOUNTID, '=', $campaign->get(Pap_Db_Table_Campaigns::ACCOUNTID)); $oldCampaignSelect->where->add(Pap_Db_Table_Campaigns::IS_DEFAULT, '=', Gpf::YES); $oldCampaignId = $oldCampaignSelect->getOneRow()->get(Pap_Db_Table_Campaigns::ID); if ($oldCampaignId == $campaignId) { return; } $oldCampaignUpdate = new Gpf_SqlBuilder_UpdateBuilder(); $oldCampaignUpdate->from->add(Pap_Db_Table_Campaigns::getName()); $oldCampaignUpdate->set->add(Pap_Db_Table_Campaigns::IS_DEFAULT, Gpf::NO); $oldCampaignUpdate->where->add(Pap_Db_Table_Campaigns::ID, '=', $oldCampaignId); $oldCampaignUpdate->executeOne(); $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_Campaigns::getName()); $update->set->add(Pap_Db_Table_Campaigns::IS_DEFAULT, Gpf::YES); $update->where->add(Pap_Db_Table_Campaigns::ID, '=', $campaignId); $update->executeOne(); }
private function insertUser($record) { $user = new Pap_Affiliates_User(); $user->setId($record->get('userid')); $user->setRefId(($record->get('refid') != '' ? $record->get('refid') : $record->get('userid'))); $user->setPassword($record->get('rpassword')); $user->setUserName($record->get('username')); $user->setFirstName($record->get('name')); $user->setLastName($record->get('surname')); $user->setAccountId(Pap3Compatibility_Migration_Pap3Constants::DEFAULT_ACCOUNT_ID); $user->setDateInserted($record->get('dateinserted')); if ($record->get('minimumpayout') != NULL) { $user->setMinimumPayout($record->get('minimumpayout')); } else { $user->setMinimumPayout(Gpf_Settings::get(Pap_Settings::PAYOUTS_MINIMUM_PAYOUT_SETTING_NAME)); } if($record->get('dateapproved') != null && $record->get('dateapproved') != '') { $user->setDateApproved($record->get('dateapproved')); } if (Pap3Compatibility_Migration_Pap3Constants::translateStatus($record->get('rstatus')) == Pap_Common_Constants::STATUS_APPROVED && $user->getDateApproved() == null) { $actualDate = new Gpf_DateTime(); $user->setDateApproved($actualDate->toDateTime()); } $user->setStatus(Pap3Compatibility_Migration_Pap3Constants::translateStatus($record->get('rstatus'))); $user->setType('A'); $user->set('numberuserid',1); $this->setAffiliateField($user, $record, 'street'); $this->setAffiliateField($user, $record, 'city'); $this->setAffiliateField($user, $record, 'company_name'); $this->setAffiliateField($user, $record, 'state'); $this->setAffiliateField($user, $record, 'zipcode'); $this->setAffiliateField($user, $record, 'weburl'); $this->setAffiliateField($user, $record, 'phone'); $this->setAffiliateField($user, $record, 'fax'); $this->setAffiliateField($user, $record, 'tax_ssn'); $this->setAffiliateField($user, $record, 'country'); $this->setAffiliateField($user, $record, 'data1'); $this->setAffiliateField($user, $record, 'data2'); $this->setAffiliateField($user, $record, 'data3'); $this->setAffiliateField($user, $record, 'data4'); $this->setAffiliateField($user, $record, 'data5'); $user->setSendNotification(false); $user->setPayoutOptionId($this->savePayoutData($record->get('userid'))); $user->save(); // handle parent id $parentUserId = $record->get('parentuserid'); if($parentUserId != '') { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->from->add(Pap_Db_Table_Users::getName()); $updateBuilder->set->add(Pap_Db_Table_Users::PARENTUSERID, $parentUserId); $updateBuilder->where->add(Pap_Db_Table_Users::ID, '=', $record->get('userid')); try { $updateBuilder->executeOne(); } catch (Gpf_Exception $e) { Pap3Compatibility_Migration_OutputWriter::log("<br/>Error setting parentuserid: ".$e->getMessage()); } } $this->countUsers++; }