/** * 查询多条记录 * @param integer $paged * @return array */ public function findRows($paged = 0) { $paged = max((int) $paged, 1); $limit = PageHelper::getListRows(); $offset = PageHelper::getFirstRow($paged, $limit); $rows = $this->getService()->findRows(array(), '', $limit, $offset, 'SQL_CALC_FOUND_ROWS'); return $rows; }
/** * 执行操作:查询数据列表 * @param string $className * @param string $moduleName * @return void */ public function execute($className, $moduleName = '') { $ret = array(); $mod = Model::getInstance($className, $moduleName); $params = $this->getSearchParams(); $order = $this->getOrder(); $limit = PageHelper::getListRows(); $offset = PageHelper::getFirstRow(); $ret = $mod->search($params, $order, $limit, $offset); if ($ret['err_no'] !== ErrorNo::SUCCESS_NUM) { $this->err404(); } $params = $this->getLLUParams($ret['paginator']); $mod->setLLU($params); $this->assign('elements', $mod); $this->render($ret); }
/** * 查询数据列表 * @param array $params * @param string $order * @param integer $limit * @param integer $offset * @return array */ public function search(array $params = array(), $order = '', $limit = null, $offset = null) { if ($limit === null) { $limit = PageHelper::getListRows(); } if ($offset === null) { $offset = PageHelper::getFirstRow(); } $ret = $this->callFetchMethod($this->getService(), 'findAll', array($params, $order, $limit, $offset, 'SQL_CALC_FOUND_ROWS')); if ($ret['err_no'] !== ErrorNo::SUCCESS_NUM) { return $ret; } $data = $ret['data']['rows']; unset($ret['data']['rows']); $ret['paginator'] = $ret['data']; $ret['data'] = $data; return $ret; }