protected function buildFrom() {
parent::buildFrom();
$onCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
$onCondition->add('c.'.Pap_Db_Table_Campaigns::ID, '=', 'b.'.Pap_Db_Table_Banners::CAMPAIGN_ID, 'AND', false);
$onCondition->add('b.'.Pap_Db_Table_Banners::STATUS, '=', Pap_Db_Banner::STATUS_ACTIVE);
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_Banners::getName(), 'b', $onCondition->toString());
Gpf_Plugins_Engine::extensionPoint('PostAffiliate.Affiliates.Campaigns.buildFrom', $this->_selectBuilder);
}
protected function buildFrom() {
$affiliateWhere = new Gpf_SqlBuilder_CompoundWhereCondition();
$affiliateWhere->add(Pap_Db_Table_AffiliateTrackingCodes::AFFILIATEID, '=', Gpf_Session::getAuthUser()->getPapUserId(), 'OR');
$affiliateWhere->add(Pap_Db_Table_AffiliateTrackingCodes::AFFILIATEID, 'IS', 'NULL', 'OR', false);
$this->_selectBuilder->from->add(Pap_Db_Table_CommissionTypes::getName(), 'ct');
$onCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
$onCondition->add('ct.'.Pap_Db_Table_CommissionTypes::ID, '=', 'c.'.Pap_Db_Table_AffiliateTrackingCodes::COMMTYPEID, 'AND', false);
$onCondition->addCondition($affiliateWhere);
$this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_AffiliateTrackingCodes::getName(), 'c',
$onCondition->toString());
}
protected function modifySelect(Gpf_SqlBuilder_SelectBuilder $selectBuilder) {
$condition = new Gpf_SqlBuilder_CompoundWhereCondition();
$condition->add('accountUsers.'.Gpf_Db_Table_Users::ID, '=',
'ua.'.Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID, 'AND', false);
$condition->add('ua.'.Gpf_Db_Table_UserAttributes::NAME, '=',
'apply_vat_invoicing');
$selectBuilder->from->addLeftJoin(Gpf_Db_Table_UserAttributes::getName(), 'ua',
$condition->toString());
if ($this->getVat() == Gpf::NO) {
$condition = new Gpf_SqlBuilder_CompoundWhereCondition();
$condition->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', Gpf::NO, 'OR');
$condition->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', null, 'OR');
$selectBuilder->where->addCondition($condition);
return;
}
$selectBuilder->where->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', Gpf::YES);
}
public function filterBanners (Gpf_SqlBuilder_SelectBuilder $selectBuilder) {
$selectBuilder->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(),'cg','cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID.'=c.'.Pap_Db_Table_Campaigns::ID);
$onCondition = new Gpf_SqlBuilder_CompoundWhereCondition();
$onCondition->add('cg.'.Pap_Db_Table_CommissionGroups::ID, '=', 'uic.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID, 'AND', false);
$onCondition->add('uic.'.Pap_Db_Table_UserInCommissionGroup::USER_ID, '=', Gpf_Session::getAuthUser()->getPapUserId());
$selectBuilder->from->addLeftJoin(Pap_Db_Table_UserInCommissionGroup::getName(), 'uic', $onCondition->toString());
$condition = new Gpf_SqlBuilder_CompoundWhereCondition();
$condition->add('c.'.Pap_Db_Table_Campaigns::TYPE, '=', Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC, 'OR');
$condition->add('uic.'.Pap_Db_Table_UserInCommissionGroup::STATUS, '=', Pap_Common_Constants::STATUS_APPROVED, 'OR');
$condition->add('uic.'.Pap_Db_Table_UserInCommissionGroup::STATUS, '=', Pap_Features_PerformanceRewards_Condition::STATUS_FIXED, 'OR');
$selectBuilder->where->addCondition($condition);
$selectBuilder->groupBy->add('b.'.Pap_Db_Table_Banners::ID);
}
