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