/** * 首页 * */ public function actionIndex() { $model = new GoodsPlan(); $criteria = new CDbCriteria(); $condition = '1=1'; $goods_name = trim($this->_request->getParam('plan_name')); $goods_name && ($condition .= ' AND plan_name LIKE \'%' . $goods_name . '%\''); $goods_id = trim($this->_request->getParam('goods_id')); $goods_id && ($condition .= ' AND goods_id =' . $goods_id); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $criteria->with = array('goods'); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; //根据plan_name,goods_id查询 $pageParams = $this->buildCondition($_GET, array('plan_name' . 'goods_id')); $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)); }