public function fetchAll() { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('opr' => 'operations'), array('id', 'client_id', 'date', 'amount', 'observations', 'report', 'date_added', 'state_order_id')); $select->joinLeft(array('opts' => 'operations_state'), 'opr.state_order_id = opts.order_id', array('name as operations_state_name')); $select->order('opr.id ASC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Operations(); $entry->setId($row->id); $entry->setClient_id($row->client_id); $entry->setDate(date("d/m/Y", strtotime($row->date))); $entry->setAmount($row->amount); $entry->setState($row->state_order_id); $entry->setOperations_state_name(htmlentities($row->operations_state_name)); $entry->setObservations($row->observations); $entry->setReport($row->report); $entries[] = $entry; } return $entries; /* $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Operations(); $entry->setId($row->id); $entry->setClient_id($row->client_id); $entry->setDate(date("d/m/Y",strtotime($row->date))); $entry->setAmount($row->amount); $entry->setObservations($row->observations); $entry->setReport($row->report); $entries[] = $entry; } return $entries; */ }