コード例 #1
0
 /**
  * 首页
  *
  */
 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));
 }