/** * Delete all privileges for current role * * @param string $roleId */ public function deleteAllPrivileges($roleId) { $select = new Gpf_SqlBuilder_DeleteBuilder(); $select->from->add(self::getName()); $select->where->add(self::ROLE_ID, "=", $roleId); $select->delete(); }
private function deleteLoginshistory() { $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add(Gpf_Db_Table_LoginsHistory::getName()); $delete->where->add(Gpf_Db_Table_LoginsHistory::LAST_REQUEST, '<', $this->getLastDate(Gpf_Settings::get(Gpf_Settings_Gpf::AUTO_DELETE_LOGINSHISTORY))->toDateTime()); $delete->limit->set('', Gpf_Log_DeleteTaskBase::DELETE_LIMIT); return $delete->delete(); }
private function deleteEvents() { $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add(Gpf_Db_Table_Logs::getName()); $delete->where->add(Gpf_Db_Table_Logs::CREATED, '<', $this->getLastDate(Gpf_Settings::get(Gpf_Settings_Gpf::AUTO_DELETE_EVENTS))->toDateTime()); $delete->limit->set('', Gpf_Log_DeleteTaskBase::DELETE_LIMIT); return $delete->delete(); }
private function deleteVisitorAffiliates() { $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add(Pap_Db_Table_VisitorAffiliates::getName()); $delete->where->add(Pap_Db_Table_VisitorAffiliates::VALIDTO,'<',Gpf_Common_DateUtils::now()); $delete->where->add(Pap_Db_Table_VisitorAffiliates::VALIDTO,'!=',null); $delete->limit->set('',$this->deleteLimit); $statement = $delete->delete(); return $statement->affectedRows()>0; }
private function deleteRawClicks() { if (Gpf_Settings::get(Pap_Settings::AUTO_DELETE_RAWCLICKS) <= 0) { return; } $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add(Pap_Db_Table_RawClicks::getName()); $delete->where->add(Pap_Db_Table_RawClicks::RSTATUS, '=', 'P'); $delete->where->add(Pap_Db_Table_RawClicks::DATETIME, '<', $this->getLastDate(Gpf_Settings::get(Pap_Settings::AUTO_DELETE_RAWCLICKS))->toDateTime()); $delete->delete(); }
private function removeCommissionGroups() { $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->delete->add('cg'); $delete->from->add(Pap_Db_Table_UserInCommissionGroup::getName(), 'ucg'); $delete->from->addRightJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID.'=cg.'.Pap_Db_Table_CommissionGroups::ID); $delete->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID.'=c.'.Pap_Db_Table_Campaigns::ID); $delete->where->add('cg.'.Pap_Db_Table_CommissionGroups::IS_DEFAULT, '=', Gpf::NO); $delete->delete(); }
/** * * @service click delete * @param ids, status * @return Gpf_Rpc_Action */ public function deleteClicks(Gpf_Rpc_Params $params) { $action = new Gpf_Rpc_Action($params); $date = array(); switch ($action->getParam("status")) { case self::DATE_ONE_WEEK: $filter = new Gpf_SqlBuilder_Filter(array("", "DP", "L7D")); $date = $filter->addDateValueToArray($date); $olderThan = "one week"; break; case self::DATE_TWO_WEEKS: $dateFrom = Gpf_DbEngine_Database::getDateString( Gpf_Common_DateUtils::getServerTime( mktime(0,0,0,date("m"), date("d") - 14, date("Y")))); $date = array("dateFrom" => $dateFrom); $olderThan = "two weeks"; break; case self::DATE_ONE_MONTH: $filter = new Gpf_SqlBuilder_Filter(array("", "DP", "L30D")); $date = $filter->addDateValueToArray($date); $olderThan = "one month"; break; } $action->setInfoMessage($this->_("Raw clicks older than %s are deleted", $olderThan)); $action->setErrorMessage($this->_("Failed to delete raw clicks")); $delete = new Gpf_SqlBuilder_DeleteBuilder(); $delete->from->add(Pap_Db_Table_RawClicks::getName()); $delete->where->add(Pap_Db_Table_RawClicks::DATETIME, "<", $date["dateFrom"]); try { $delete->delete(); $action->addOk(); } catch(Gpf_DbEngine_NoRowException $e) { $action->addError(); } return $action; }
public static function clearCachedBanners(){ $select = new Gpf_SqlBuilder_DeleteBuilder(); $select->from->add(Pap_Db_Table_CachedBanners::getName()); $select->delete(); }
/** * deletes tier commission * if deleteType == exact, it will delete only given tier * if deleteType == above, it will delete given tier and all above * * @param unknown_type $fromTier * @param unknown_type $subType * @param unknown_type $commGroupId * @param unknown_type $commTypeId * @param unknown_type $deleteType */ public function deleteUnusedCommissions($fromTier, $subType, $commGroupId, $commTypeId, $deleteType = 'extact') { $deleteBuilder = new Gpf_SqlBuilder_DeleteBuilder(); $deleteBuilder->from->add(Pap_Db_Table_Commissions::getName()); $deleteBuilder->where->add('subtype', '=', $subType); if($deleteType == 'above') { $deleteBuilder->where->add('tier', '>', $fromTier); } else { $deleteBuilder->where->add('tier', '=', $fromTier); } $deleteBuilder->where->add('commtypeid', '=', $commTypeId); $deleteBuilder->where->add('commissiongroupid', '=', $commGroupId); $deleteBuilder->delete(); }
private function deleteAffiliates() { if (count($this->paramsArray['papUserIds']) > 0) { $deleteBuilder = new Gpf_SqlBuilder_DeleteBuilder(); $deleteBuilder->delete->add('pu'); $deleteBuilder->delete->add('gu'); $deleteBuilder->delete->add('au'); $deleteBuilder->from->add(Pap_Db_Table_Users::getName(), 'pu'); $deleteBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'gu.'. Gpf_Db_Table_Users::ID.' = pu.'.Pap_Db_Table_Users::ACCOUNTUSERID); $deleteBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'au.'.Gpf_Db_Table_AuthUsers::ID.' = gu.'.Gpf_Db_Table_Users::AUTHID); $deleteBuilder->where->add('pu.'.Pap_Db_Table_Users::TYPE, '=', Pap_Application::ROLETYPE_AFFILIATE); $deleteBuilder->where->add('pu.'.Pap_Db_Table_Users::ID, 'NOT IN', $this->paramsArray['papUserIds'], 'AND', false); $deleteBuilder->delete(); } }
protected function removeRotatorFromCache($bannerId) { $select = new Gpf_SqlBuilder_DeleteBuilder(); $select->from->add(Pap_Db_Table_CachedBanners::getName()); $select->where->add(Pap_Db_Table_CachedBanners::BANNERID, '=', $bannerId); $select->delete(); }