Example #1
0
 /**
  * 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));
 }