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