/** * Get query results */ public function dataAction() { $pager = Request::post('pager', 'array', array()); $this->_checkLoaded(); $query = $this->_session->get('query'); /** * @var Db_Select */ $sql = $query->getSql(); if (!empty($pager)) { Model::queryAddPagerParams($sql, $pager); } try { $data = $this->_db->fetchAll($sql); $count = $this->_db->fetchOne($query->getCountSql()); } catch (Exception $e) { Response::jsonError($e->getMessage()); } Response::jsonSuccess($data, array('count' => $count)); }