public function GetAllOperations() { try { $entries = array(); $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('ope' => 'operations'), array('id', 'client_id', 'amount'))->join(array('us' => 'clients'), 'us.id = ope.client_id', array('first_name')); $resultSet = $table->fetchAll($select); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Operations(); $entry->setId($row->id); $entry->setClient_id($row->client_id); $entry->setAmount($row->amount); $entry->setOperations_first_name($row->first_name); $entries[] = $entry; } return $entries; } catch (Exception $ex) { } }