protected function buildFrom() { $this->_selectBuilder->from->add(Pap_Db_Table_Rules::getName(), 'r'); $this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Campaigns::getName(), 'c', 'c.'.Pap_Db_Table_Campaigns::ID.'=r.'.Pap_Db_Table_Rules::CAMPAIGN_ID); $this->_selectBuilder->from->addLeftJoin(Pap_Db_Table_CommissionGroups::getName(), 'cg', 'r.'.Pap_Db_Table_Rules::COMMISSION_GROUP_ID.'=cg.'.Pap_Db_Table_CommissionGroups::ID); }
/** * @param String $campaignId * @return Gpf_SqlBuilder_SelectIterator */ private function getRules($campaignId) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->addAll(Pap_Db_Table_Rules::getInstance()); $select->from->add(Pap_Db_Table_Rules::getName()); $select->where->add(Pap_Db_Table_Rules::CAMPAIGN_ID, '=', $campaignId); return $select->getAllRowsIterator(); }
public static function getInstance() { if (self::$instance === null) { self::$instance = new self; } return self::$instance; }
function init() { $this->setTable(Pap_Db_Table_Rules::getInstance()); parent::init(); }