public function fetchAll() { $entries = array(); $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('pvs' => 'events'), array('id', 'operation_id', 'type_id', 'action_id', 'schedule', 'assigned_operator_id', 'comments')); $select->join(array('ete' => 'event_type'), 'pvs.type_id = ete.id', array('name as type_name')); $select->join(array('ean' => 'event_action'), 'pvs.action_id = ean.id', array('name as action_name')); $select->where('pvs.status = ?', true); $select->order('pvs.id ASC'); $resultSet = $table->fetchAll($select); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Events(); $entry->setId($row->id); $entry->setOperation_id($row->operation_id); $entry->setType_id($row->type_id); $entry->setType_name($row->type_name); $entry->setAction_id($row->action_id); $entry->setAction_name($row->action_name); $entry->setSchedule(date("d/m/Y", strtotime($row->schedule))); $entry->setAssigned_operator_id($row->assigned_operator_id); $entry->setComments($row->comments); $entries[] = $entry; } return $entries; }
public function eventdeleteajaxAction() { $request = $this->getRequest(); if ($this->getRequest()->isPost()) { $mapper = new Gyuser_Model_EventsDataMapper(); $Obj = new Gyuser_Model_Events(); $Obj->setId($request->id); $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(); $result = $mapper->delete($Obj); if ($result) { echo $result; } else { echo "f"; } } }