/** * 首页 * */ public function actionIndex() { parent::_acl(); $model = new Host(); $criteria = new CDbCriteria(); $criteria->condition = $condition; $criteria->order = 't.id ASC'; //$criteria->with = array ( 'catalog' ); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; //$pageParams = XUtils::buildCondition( $_GET, array ( 'title' , 'catalogId','titleAlias' ) ); //$pages->params = is_array( $pageParams ) ? $pageParams : array (); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('host_index', array('datalist' => $result, 'pagebar' => $pages)); }
public function actionList() { $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $list = array(); $criteria = new CDbCriteria(array('order' => 'id ASC')); $request = Yii::app()->getRequest(); $id = trim($request->getParam("id")); if ($id) { $criteria->addCondition("id = {$id}"); } $hosts = new Host(); $count = $hosts->count($criteria); $pager = new CPagination($count); $pager->pageSize = Yii::app()->params['postsPerPage']; $pager->setCurrentPage($page - 1); $pager->applyLimit($criteria); $list = $hosts->findAll($criteria); $this->render('list', array('r' => Yii::app()->request->baseUrl . '/', 'pages' => $pager, 'list' => $list)); }