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