public function RejectedChequeByLiquidacionesId(Gyuser_Model_Cheques $obj) { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $Liquidacion_id = $obj->getLiquidacion_id(); $select->from(array('cqu' => 'cheques'), array('id as cheque_id', 'operation_id', 'bank_account_id', 'date as cheque_date', 'check_n', 'amount', 'local', 'liquidacion_id', 'status as cheque_status', 'rejected_cost', 'rejected_cost_prov', 'credit_provider_id', 'rejected_type')); $select->joinLeft(array('ops' => 'operations'), 'cqu.operation_id = ops.id', array('client_id', 'bank_account_id')); $select->joinLeft(array('bas' => 'bank_accounts'), 'cqu.bank_account_id = bas.id', array('bank_name')); $select->joinLeft(array('cls' => 'clients'), 'ops.client_id = cls.id', array('first_name', 'last_name')); $select->joinLeft(array('chqs' => 'cheques_status'), 'cqu.status = chqs.id', array('id as cheque_state_id', 'status_list')); $select->joinLeft(array('lqd' => 'liquidaciones'), "lqd.id = {$Liquidacion_id}", array('date as liquidacion_date')); $select->where('cqu.status = ?', 3); //$select->where('cqu.date <= ?', date("Y-m-d")); $select->where('cqu.rejected_liquidacion_id = ?', $Liquidacion_id); $select->where('cqu.credit_provider_id IS NULL'); //$select->where('cqu.status = ?', ''); $select->order('cqu.id ASC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = array('id' => $row->cheque_id, 'date' => date("d/m/Y", strtotime($row->cheque_date)), 'liquidacion_date' => date("d/m/Y", strtotime($row->liquidacion_date)), 'check_n' => $row->check_n, 'amount' => $row->amount, 'status' => $row->cheque_state_id, 'status_name' => $row->status_list, 'local' => $row->local, 'bank_name' => $row->bank_name, 'first_name' => $row->first_name, 'last_name' => $row->last_name, 'rejected_cost' => $row->rejected_cost, 'rejected_type' => $row->rejected_type, 'cave_id' => $row->credit_provider_id, 'rejected_cost_prov' => $row->rejected_cost_prov); $entries[] = $entry; } return $entries; }