/** * @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; }
/** * @return Pap_Db_Table_Accountings */ public static function getInstance() { if(self::$instance === null) { self::$instance = new self; } return self::$instance; }
function init() { $this->setTable(Pap_Db_Table_Accountings::getInstance()); parent::init(); }