public function run() { $model = new OAuth(); //条件 $criteria = new CDbCriteria(); $apiname = trim(Yii::app()->request->getParam('apiname')); $apiname && $criteria->addSearchCondition('apiname', $apiname); $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); $result = $model->findAll($criteria); $this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages)); }
/** * 首页 */ public function actionIndex() { $model = new OAuth(); $criteria = new CDbCriteria(); $condition = '1'; $apiname = trim($this->_request->getParam('apiname')); $apiname && ($condition .= ' AND apiname LIKE \'%' . $apiname . '%\''); $criteria->condition = $condition; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; $pageParams = $this->buildCondition($_GET, array('appname')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('index', array('datalist' => $result, 'pagebar' => $pages)); }