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)));
}
