public function GetLiquidacionesByCaveId(Gyuser_Model_Liquidaciones $obj) { $table = $this->getDbTable(); $select = $table->select(); $select->from($table, array('id', 'date', 'current_account_balance', 'amount_payed', 'previous_account_balance', 'committed')); $select->where('status = ?', true); $select->where('cave_id = ?', $obj->getCave_id()); $select->order('date DESC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Liquidaciones(); $entry->setId($row->id); $entry->setDate(date("d/m/Y", strtotime($row->date))); $entry->setCurrent_account_balance($row->current_account_balance); $entry->setAmount_payed($row->amount_payed); $entry->setPrevious_account_balance($row->previous_account_balance); $entry->setCommitted($row->committed); $entries[] = $entry; } return $entries; }