Yii1.1中通过Sql查询进行的分页操作

控制器中方法：

public function actiontindex(){
        $user = Yii::app()->user;
        $id = $user->id;
        $connection=Yii::app()->db;
        $sql= "sql查询语句";
        $command = $connection->createCommand($sql)->queryAll();
        $pages = new CPagination(count($command));
        $list = $connection->createCommand($sql." limit ".$pages->limit." offset ".$pages->offset."")->queryAll();

        $this->render("index",array(
            "bonus" => $list,
            "pages" => $pages,
        ));
    }

视图中显示为：

第一部分为查询的结果显示：

<table class="table table-bordered">
            <thead>
            <tr>
                <th class="per10">公文类型</th>
                <th class="per50">公文标题</th>
                <th class="per15">当前步骤</th>
                <th class="per15">日期</th>
            </tr>
            </thead>
            <tbody>
            <?php if (isset($bonus)):?>
                <?php foreach ($bonus as $key=>$ad): ?>
                    <tr>
                        <td><?=$ad["typeName"] ?></td>
                        <td><?=$ad["doc_title"] ?></td>
                        <td><?=$ad["taskname"] ?></td>
                        <td><?=date("Y-m-d H:i:s",$v["create_time"]) ?></td>
                    </tr>
                <?php endforeach; ?>
            <?php endif; ?>
            </tbody>
        </table>

第二部分为分页的显示：

<?php
$this->widget("CLinkPager",array(
        "header"=>"",
        "firstPageLabel" => "首页",
        "lastPageLabel" => "末页",
        "prevPageLabel" => "上一页",
        "nextPageLabel" => "下一页",
        "pages" => $pages,
        "maxButtonCount"=>8,
        "cssFile"=>false,
        "htmlOptions" =>array("class"=>"pagination"),
        "selectedPageCssClass"=>"active"
    )
);
?>