/**
*
* @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);
}
