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