protected function buildFrom() { $this->_selectBuilder->from->add(Pap_Db_Table_AffiliateTrackingCodes::getName(), 'atc'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_CommissionTypes::getName(), 'com', 'com.commtypeid=atc.commtypeid'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'cam', 'cam.campaignid=com.campaignid'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'u', 'u.userid=atc.userid'); $this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'u.accountuserid=gu.accountuserid'); $this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'au.authid=gu.authid'); }
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()); }
/** * @return Pap_Db_Table_AffiliateTrackingCode */ public static function getInstance() { if(self::$instance === null) { self::$instance = new self; } return self::$instance; }
function init() { $this->setTable(Pap_Db_Table_AffiliateTrackingCodes::getInstance()); parent::init(); }