Ejemplo n.º 1
0
 /**
  * @return Gpf_SqlBuilder_SelectBuilder
  */
 public function getLastAccountingCommissionSelect() {
     $select = new Gpf_SqlBuilder_SelectBuilder();
     $select->select->add('i.'.Pap_Db_Table_Invoices::ACCOUNTID, 'aid');
     $select->select->add('MAX(i.'.Pap_Db_Table_Invoices::DATE_TO.')', 'lastDate');
     $select->from->add(Pap_Db_Table_Accountings::getName(), 'a');
     $select->from->addInnerJoin(Pap_Db_Table_Invoices::getName(), 'i',
         'a.'.Pap_Db_Table_Accountings::INVOICEID.'=i.'.Pap_Db_Table_Invoices::ID);
     $select->where->add(Pap_Db_Table_Accountings::TYPE, '=', Pap_Db_Accounting::TYPE_COMMISSSION);
     $select->groupBy->add('i.'.Pap_Db_Table_Invoices::ACCOUNTID);
     return $select;
 }
Ejemplo n.º 2
0
 /**
  * @return Pap_Db_Table_Accountings
  */
 public static function getInstance() {
     if(self::$instance === null) {
         self::$instance = new self;
     }
     return self::$instance;
 }
Ejemplo n.º 3
0
	function init() {
		$this->setTable(Pap_Db_Table_Accountings::getInstance());
		parent::init();
	}