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