Ejemplo n.º 1
0
	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);
	}
Ejemplo n.º 2
0
 /**
  * @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();
 }
Ejemplo n.º 3
0
	public static function getInstance() {
		if (self::$instance === null) {
			self::$instance = new self;
		}
		return self::$instance;
	}
Ejemplo n.º 4
0
	function init() {
		$this->setTable(Pap_Db_Table_Rules::getInstance());
		parent::init();
	}