/** * * @return array */ public function bankTransactionReport() { $mapperBankStatement = new Fefop_Model_Mapper_BankStatement(); $select = $mapperBankStatement->getSelect(); $dbBankStatement = App_Model_DbTable_Factory::get('FEFOPBankStatements'); if (!empty($this->_data['fk_id_fefop_type_transaction'])) { $select->where('bs.fk_id_fefop_type_transaction IN(?)', $this->_data['fk_id_fefop_type_transaction']); } if (!empty($this->_data['fk_id_fefopfund'])) { $select->where('bs.fk_id_fefopfund IN(?)', $this->_data['fk_id_fefopfund']); } if (!empty($this->_data['status'])) { $select->where('bs.status IN(?)', $this->_data['status']); } if (!empty($this->_data['bank_payment'])) { if ('C' == $this->_data['bank_payment']) { $select->where('bsc.id_fefop_bank_contract IS NOT NULL'); } else { $select->where('bs.fk_id_fefopfund IS NOT NULL'); } } //Período $select->where("bs.date_statement >= STR_TO_DATE(?, '%d/%m/%Y')", $this->_data['date_start']); $select->where("bs.date_statement <= STR_TO_DATE(?, '%d/%m/%Y')", $this->_data['date_finish']); return array('rows' => $dbBankStatement->fetchAll($select)); }
/** * * @param array $bank_statements * @return Zend_Db_Table_Rowset */ public function listBankStatementsIn($bank_statements) { $mapperBankStatements = new Fefop_Model_Mapper_BankStatement(); $select = $mapperBankStatements->getSelect(); $select->where('bsc.id_fefop_bank_contract IN (?)', $bank_statements)->reset(Zend_Db_Select::GROUP); return $this->_dbTable->fetchAll($select); }