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