/** * 首页 * */ public function actionIndex() { $model = new Goods(); $criteria = new CDbCriteria(); $condition = "type = " . $this->_type; $goods_name = trim($this->_request->getParam('goods_name')); $catalogId = intval($this->_request->getParam('catalogId')); $goods_name && ($condition .= ' AND goods_name LIKE \'%' . $goods_name . '%\''); $catalogId && ($condition .= ' AND catalog_id= ' . $catalogId); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $criteria->with = array('catalog'); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; //根据goods_name,catelogId查询 $pageParams = $this->buildCondition($_GET, array('goods_name', 'catalogId')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); //推荐位 $recom_list = RecommendPosition::model()->findAll('type=:type', array(':type' => $this->_type), array('order' => 'id')); $this->render('index', array('datalist' => $result, 'pagebar' => $pages, 'recom_list' => $recom_list)); }