/**
*
* @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++;
}
