Yii 分页

//Controller
$model = new AutoSale;
$data = $model->getPageAutos(array('state'=>3),'id DESC', 0, 2);
$this->render('index',array(
   'autos'=>$data['autos'],
    'pages'=>$data['pages'],
     model'=>$model,
));
//Model
public function getPageAutos($terms, $order='id DESC', $page=0, $limit=8)
    {
        $criteria = new CDbCriteria;
        foreach($terms as $key=>$value)
        {
            $criteria->compare($key, $value);
        }
        $pages=new CPagination($this->count($criteria));
        $pages->pageSize=$limit;
        $pages->applyLimit($criteria); 
        $criteria->offset = $pages->currentPage*$pages->pageSize;
        $criteria->order = 'id DESC';
        $criteria->limit = $limit;
        return array(
            'autos'=>  $this->findAll($criteria),
            'pages'=>  $pages,
        );
    }

//View
$this->widget('CLinkPager', array(
                    'pages' => $pages,
                    'prevPageLabel' => '上一页',
                    'nextPageLabel' => '下一页',
                ));
//Controller
$model = new AutoSale;
$data = $model->getPageAutos(array('state'=>3),'id DESC', 0, 2);
$this->render('index',array(
   'autos'=>$data['autos'],
    'pages'=>$data['pages'],
     model'=>$model,
));
//Model
public function getPageAutos($terms, $order='id DESC', $page=0, $limit=8)
    {
        $criteria = new CDbCriteria;
        foreach($terms as $key=>$value)
        {
            $criteria->compare($key, $value);
        }
        $pages=new CPagination($this->count($criteria));
        $pages->pageSize=$limit;
        $pages->applyLimit($criteria); 
        $criteria->offset = $pages->currentPage*$pages->pageSize;
        $criteria->order = 'id DESC';
        $criteria->limit = $limit;
        return array(
            'autos'=>  $this->findAll($criteria),
            'pages'=>  $pages,
        );
    }

//View
$this->widget('CLinkPager', array(
                    'pages' => $pages,
                    'prevPageLabel' => '上一页',
                    'nextPageLabel' => '下一页',
                ));

发表评论