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 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 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(); } }
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; }
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; }
/** * 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 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(); }
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(); }
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(); }
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(); }
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(); }
/** * 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 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 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(); }