public function run() { $model = new AdPosition(); //条件 $criteria = new CDbCriteria(); $title = trim(Yii::app()->request->getParam('title')); $title && $criteria->addSearchCondition('title', $title); $criteria->order = 't.id ASC'; $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 AdPosition(); $criteria = new CDbCriteria(); $condition = '1'; $title = $this->_request->getParam('title'); $title && ($condition .= ' AND title LIKE \'%' . $title . '%\''); $criteria->condition = $condition; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; $pageParams = $this->buildCondition($_GET, array('title')); $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)); }