private function updateWrapper($bannerTypes, $dataField) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_Banners::getName()); $update->set->add(Pap_Db_Table_Banners::WRAPPER_ID, 'script'); $update->where->add(Pap_Db_Table_Banners::TYPE, 'IN', $bannerTypes); $update->where->add($dataField, '=', Gpf::YES); $update->execute(); }
public function update() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_UserPayoutOptions::getName()); $update->set->add(Pap_Db_Table_UserPayoutOptions::VALUE, $this->get(Pap_Db_Table_UserPayoutOptions::VALUE)); $update->where->add(Pap_Db_Table_Users::ID, "=", $this->get(Pap_Db_Table_Users::ID)); $update->where->add(Gpf_Db_Table_FormFields::ID, "=", $this->get(Gpf_Db_Table_FormFields::ID)); $update->updateOne(); }
private function updateThemeExistingAffiliates($themeId) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_UserAttributes::getName(), 'ua'); $update->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 'ua.'.Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID.'=pu.'.Pap_Db_Table_Users::ACCOUNTUSERID); $update->set->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, $themeId); $update->where->add('ua.'.Gpf_Db_Table_UserAttributes::NAME, '=', Gpf_Auth_User::THEME_ATTRIBUTE_NAME); $update->where->add('pu.'.Pap_Db_Table_Users::TYPE, '=', Pap_Application::ROLETYPE_AFFILIATE); $update->update(); }
public static function invalidateOtherRequest($authId) { $sql = new Gpf_SqlBuilder_UpdateBuilder(); $sql->set->add(self::STATUS, self::STATUS_INVALIDATED); $sql->from->add(self::getName()); $sql->where->add(self::STATUS, '=', self::STATUS_PENDING); $sql->where->add(Gpf_Db_Table_AuthUsers::ID, '=', $authId); $sql->execute(); }
public function execute(Gpf_DbEngine_Row $dbRow) { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->from->add($this->foreignDbRow->getTable()->name()); for ($i = 0; $i < count($this->selfColumns); $i++) { $updateBuilder->set->add($this->foreignColumns[$i], 'NULL', false); $updateBuilder->where->add($this->foreignColumns[$i], "=", $dbRow->get($this->selfColumns[$i])); } $updateBuilder->execute(); }
protected function beforeSaveAction() { if ($this->get(Gpf_Db_Table_MailAccounts::IS_DEFAULT) == Gpf::YES) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_MailAccounts::getName()); $update->set->add(Gpf_Db_Table_MailAccounts::IS_DEFAULT, Gpf::NO); $update->where->add(Gpf_Db_Table_MailAccounts::ID, '<>', $this->getPrimaryKeyValue()); $update->execute(); } }
public function save(Pap_Merchants_Campaign_CommissionTypeRpcForm $form) { if($form->getFieldValue('rtype') != Pap_Common_Constants::TYPE_ACTION) { return; } $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_CommissionTypes::NAME, $form->getFieldValue(Pap_Db_Table_CommissionTypes::NAME)); $update->from->add(Pap_Db_Table_CommissionTypes::getName()); $update->where->add(Pap_Db_Table_CommissionTypes::CODE, '=', $form->getFieldValue(Pap_Db_Table_CommissionTypes::CODE)); $update->where->add(Pap_Db_Table_CommissionTypes::CAMPAIGNID, '=', Pap_Db_CommissionGroup::getCommissionGroupById($form->getFieldValue('CommissionGroupId'))->getCampaignId()); $update->execute(); }
private function updateValidToDate($lifetime, $campaignId = null) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_VisitorAffiliates::getName()); $update->set->add(Pap_Db_Table_VisitorAffiliates::VALIDTO, 'DATE_ADD('.Pap_Db_Table_VisitorAffiliates::DATEVISIT.', INTERVAL '.$lifetime.' DAY)', false); $update->where->add(Pap_Db_Table_VisitorAffiliates::VALIDTO, 'is', 'NULL', 'AND', false); if ($campaignId !== null) { $update->where->add(Pap_Db_Table_VisitorAffiliates::CAMPAIGNID, '=', $campaignId); } $update->update(); }
private function updateReferenced($increment = 1) { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->from->add(Gpf_Db_Table_Files::getName()); $updateBuilder->set->add('referenced', 'referenced + (' + $increment + ')', false); $updateBuilder->where->add('fileid', '=', $this->get('fileid')); if ($increment < 0) { $updateBuilder->where->add('referenced', '>', 0); } return $updateBuilder->update(); }
private function transferUsers() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg'); $update->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'cg.'.Pap_Db_Table_CommissionGroups::ID.'=ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID); $update->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID.'=c.'.Pap_Db_Table_Campaigns::ID); $update->set->add('ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID, $this->getDefaultCommissionGroup(), false); $update->where->add('cg.'.Pap_Db_Table_CommissionGroups::IS_DEFAULT, '=', Gpf::NO); $update->update(); }
private function massUpdateStatus($status, $ids, $response) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_RecurringCommissions::STATUS, $status); $update->from->add(Pap_Db_Table_RecurringCommissions::getName()); $update->where->add(Pap_Db_Table_RecurringCommissions::getName().".".Pap_Db_Table_RecurringCommissions::ID, "IN", $ids); try { $update->execute(); $response->addOk(); } catch(Gpf_DbEngine_NoRowException $e) { $response->addError(); } }
/** * Unset on all languages status default language */ public function unsetDefaultLanguage($defaultLanguageId) { $sql = new Gpf_SqlBuilder_UpdateBuilder(); $sql->from->add(self::getName()); $sql->where->add(Gpf_Db_Table_Accounts::ID, '=', Gpf_Application::getInstance()->getAccountId()); $sql->where->add(Gpf_Db_Table_Languages::ID, '<>', $defaultLanguageId); $sql->set->add(self::IS_DEFAULT, Gpf::NO); $sql->execute(); }
private function deleteNewEntries($tableName, Gpf_DateTime $fromDate) { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); for ($i = $fromDate->getDay(); $i<=31; $i++) { $updateBuilder->set->add("raw_$i", 0); $updateBuilder->set->add("unique_$i", 0); if (strstr($tableName, 'click')) { $updateBuilder->set->add("declined_$i", 0); } } $updateBuilder->from->add($tableName); $updateBuilder->where->add('month', '=', $fromDate->getMonthStart()->toDate()); $updateBuilder->execute(); $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add($tableName); $delete->where->add('month', '>', $fromDate->toDate()); $delete->execute(); }
public function execute() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_MailTemplates::getName()); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_HTML, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_HTML.',\'$commissions->list\',\'$commissionsList->list\')'); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_TEXT, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_TEXT.',\'$commissions->list\',\'$commissionsList->list\')'); $update->execute(); $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_MailTemplates::getName()); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_HTML, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_HTML.',\'$commissions->list\',\'$commissionsList->list\')'); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_TEXT, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_TEXT.',\'$actions->list\',\'$actionsList->list\')'); $update->execute(); $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_MailTemplates::getName()); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_HTML, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_HTML.',\'$sales->list\',\'$salesList->list\')'); $update->set->addDontQuote(Gpf_Db_Table_MailTemplates::BODY_TEXT, 'REPLACE ('.Gpf_Db_Table_MailTemplates::BODY_TEXT.',\'$sales->list\',\'$salesList->list\')'); $update->execute(); }
/** * @service coupon write * @param ids, status * @return Gpf_Rpc_Action */ public function changeStatus(Gpf_Rpc_Params $params) { $action = new Gpf_Rpc_Action($params); $action->setInfoMessage($this->_("Status successfully set to selected coupon(s)")); $action->setErrorMessage($this->_("Failed to set status selected coupon(s)")); $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_Coupons::getName()); $update->set->add(Pap_Db_Table_Coupons::STATUS, $action->getParam("status")); foreach ($action->getIds() as $id){ $update->where->add(Pap_Db_Table_Coupons::ID, "=", $id, "OR"); } try { $update->execute(); $action->addOk(); } catch(Gpf_DbEngine_NoRowException $e) { $action->addError(); } return $action; }
/** * * @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; }
private function processCampaignsToPublic() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_Campaigns::getName()); $update->set->add(Pap_Db_Table_Campaigns::TYPE, Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC); $update->execute(); }
/** * * @param $params * @return Gpf_Rpc_Action */ private function saveChangedStatusToDB(Gpf_Rpc_Params $params) { $action = new Gpf_Rpc_Action($params); $action->setInfoMessage($this->_("Status successfully set to selected url(s)")); $action->setErrorMessage($this->_("Failed to set status selected url(s)")); $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_DirectLinkUrls::getName()); $update->set->add(Pap_Db_Table_DirectLinkUrls::STATUS, $action->getParam("status")); foreach ($action->getIds() as $id){ $update->where->add(Pap_Db_Table_DirectLinkUrls::ID, "=", $id, "OR"); } try { $update->execute(); $action->addOk(); Pap_Tracking_DirectLinksBase::getInstance()->regenerateDirectLinksFile(); } catch(Gpf_DbEngine_NoRowException $e) { $action->addError(); } return $action; }
private function activateNewNodes() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_HierarchicalDataNodes::getName()); $update->set->add(Gpf_Db_Table_HierarchicalDataNodes::TYPE, $this->type); $update->where->add(Gpf_Db_Table_HierarchicalDataNodes::TYPE, '=', $this->type . '_'); $update->execute(); }
private function changeCommissionTypeChildsStatus($commtypeId, $status) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_CommissionTypes::getName(), 't'); $update->set->add('t.'.Pap_Db_Table_CommissionTypes::STATUS, $status); $update->where->add('t.'.Pap_Db_Table_CommissionTypes::PARENT_COMMISSIONTYPE_ID, '=', $commtypeId); $update->execute(); }
public static function setAllWindowClosed($accountUserId) { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->set->add('closed', 'Y'); $updateBuilder->from->add(self::getName()); $updateBuilder->where->add('accountuserid', '=', $accountUserId); $updateBuilder->execute(); }
/** * special handling for parent user IDs that were not set during insert * */ private function processParentUsers() { Pap3Compatibility_Migration_OutputWriter::log("<br/>Fixing parent users....."); $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->from->add(Pap_Db_Table_Users::getName(), 'u'); $updateBuilder->from->addLeftJoin(Pap_Db_Table_Users::getName(), 'pu', 'u.parentuserid = pu.userid'); $updateBuilder->set->add('u.parentuserid' ,'NULL', false); $updateBuilder->where->add('u.parentuserid', 'is not', 'NULL', 'AND', false); $updateBuilder->where->add('pu.userid', 'is', 'NULL', 'AND', false); try { $statement = $updateBuilder->execute(); } catch (Gpf_Exception $e) { Pap3Compatibility_Migration_OutputWriter::log("<br/> Exception when updating parentuserids: ".$e->getMessage()); return; } Pap3Compatibility_Migration_OutputWriter::log("<br/> ".$statement->affectedRows()." parentuserids fixed"); }
private function clearParentAffiliate() { $updateBuilder = new Gpf_SqlBuilder_UpdateBuilder(); $updateBuilder->from->add(Pap_Db_Table_Users::getName()); $updateBuilder->set->add(Pap_Db_Table_Users::PARENTUSERID, ""); $updateBuilder->where->add(Pap_Db_Table_Users::PARENTUSERID, "=", $this->getId()); $updateBuilder->execute(); }
private function updateRowsToBeProcessed($tableIndex) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_Visits::RSTATUS, Pap_Db_Visit::INPROCESSING); $update->from->add(Pap_Db_Table_Visits::getName($tableIndex)); $update->where->add(Pap_Db_Table_Visits::RSTATUS, '=', Pap_Db_Visit::UNPROCESSED); $this->initVisitsWhere($update->where); $update->execute(); }
/** * @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 clearPaymentPendingMark() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_Transactions::PAYOUTHISTORY_ID, 'NULL', false); $update->from->add(Pap_Db_Table_Transactions::getName()); $update->where->add(Pap_Db_Table_Transactions::PAYOUTHISTORY_ID, '=', Pap_Common_Transaction::PAYMENT_PENDING_ID); $update->execute(); }
private function updateProcessedImpressions() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_RawImpressions::RSTATUS, Pap_Db_RawImpression::PROCESSED); $update->from->add(Pap_Db_Table_RawImpressions::getName($this->processedTableIndex)); $update->where->add(Pap_Db_Table_RawImpressions::RSTATUS, '=', Pap_Db_RawImpression::UNPROCESSED); $update->limit->set(self::ROWS_FOR_PROCESSING_LIMIT); $update->execute(); }
private function markTransactionsAsPaid(Pap_Common_Payout $payout) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->set->add(Pap_Db_Table_Transactions::PAYOUT_STATUS, Pap_Common_Transaction::PAYOUT_PAID); $update->set->add(Pap_Db_Table_Transactions::PAYOUTHISTORY_ID, $payout->getPayoutHistoryId()); $update->from->add(Pap_Db_Table_Transactions::getName()); $update->where->add(Pap_Db_Table_Transactions::USER_ID, "=", $payout->getUserId()); $update->where->add(Pap_Db_Table_Transactions::PAYOUTHISTORY_ID, '=', Pap_Common_Transaction::PAYMENT_PENDING_ID); $update->execute(); }