public function listAction() { $this->_helper->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); try { $params = $this->_getAllParams(); $iDisplayStart = isset($params['start']) ? $params['start'] : null; $iDisplayLength = isset($params['length']) ? $params['length'] : null; $sEcho = isset($params['sEcho']) ? $params['sEcho'] : null; $search = isset($params['search']) ? $params['search'] : ''; $columns = isset($params['columns']) ? $params['columns'] : ''; $arrSearch = array(); if (!empty($search['value'])) { $arrSearch[] = array("m.name like ?", '%' . $search['value'] . '%'); } if (isset($columns[1]) && !empty($columns[1]['search']['value'])) { $arrSearch[] = array("m.name like ?", '%' . $columns[1]['search']['value'] . '%'); } if (isset($columns[8]) && !empty($columns[8]['search']['value'])) { $arrSearch[] = array("c.name like ?", '%' . $columns[8]['search']['value'] . '%'); } if (isset($columns[9]) && !empty($columns[9]['search']['value'])) { $arrSearch[] = array("s.name like ?", '%' . $columns[9]['search']['value'] . '%'); } $obj = new Application_Entity_DataTable(self::_TABLECLASS, 0, $sEcho, true); $obj->setSearch2($arrSearch); $obj->setIconAction($this->tableIcons()); parent::response(200, $obj->getQuery2($iDisplayStart, $iDisplayLength)); } catch (Exception $exc) { $status = 200; parent::response($status, array('msj' => $exc->getMessage())); } }
public function listAction() { $this->_helper->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $params = $this->_getAllParams(); $iDisplayStart = isset($params['iDisplayStart']) ? $params['iDisplayStart'] : null; $iDisplayLength = isset($params['iDisplayLength']) ? $params['iDisplayLength'] : null; $sEcho = isset($params['sEcho']) ? $params['sEcho'] : 1; $sSearch = isset($params['sSearch']) ? $params['sSearch'] : ''; $obj = new Application_Entity_DataTable('Banner', $iDisplayLength, $sEcho, true); $obj->setIconAction($this->action()); $query = ""; $query .= !empty($sSearch) ? " AND descripcion like '%" . $sSearch . "%' OR posicion = '{$sSearch}' " : " "; $obj->setSearch($query); $this->getResponse()->setHttpResponseCode(200)->setHeader('Content-type', 'application/json;charset=UTF-8', true)->appendBody(json_encode($obj->getQuery($iDisplayStart, $iDisplayLength))); }