tp3.2中每笔订单商品详情分页

第一步：控制器里的方法：

        //每笔订单详情
        public function perOne(){
                $id=$_GET["id"];//订单id
                    $field="o.*";
            $order_data=M("orders")
                            ->alias("o")
                            ->field($field)
                            ->where(array("o.id"=>$id))
                            ->find();
                $data["order"]=$order_data;
                $totalmoney=$order_data["money"];
                $peoplenum=$order_data["peoplenum"];
                $eattype=$order_data["eattype"];
                $desknum=$order_data["desknum"];
                $note=$order_data["note"];
                $id=$order_data["id"];

            $count      = M("order_goods")
                ->alias("og")
                ->field("og.*,d.*")
                ->join("left join zbt_goods AS d ON og.goodsid=d.id")
                ->where(array("og.orderid"=>$id))
                ->count("d.id");// 查询满足要求的总记录数
                $Page       = new ThinkPage($count,2);// 实例化分页类 传入总记录数和每页显示的记录数
                $show       = $Page->show();// 分页显示输出
                // 进行分页数据查询 注意limit方法的参数要使用Page类的属性
                $order_goods_data=M("order_goods")
                 ->alias("og")
                 ->field("og.*,d.*")
                 ->join("left join zbt_goods AS d ON og.goodsid=d.id")
                ->where(array("og.orderid"=>$id))
                ->limit($Page->firstRow.",".$Page->listRows)
                ->select();
                $data["order"]["goods"]=$order_goods_data;
                $this->assign("money",$totalmoney);
                $this->assign("peoplenum", $peoplenum);
                $this->assign("eattype", $eattype);
                $this->assign("desknum", $desknum);
                $this->assign("note", $note);
                        $this->assign("orderdata",$order_goods_data);// 赋值数据集
                        $this->assign("page",$show);// 赋值分页输出
                        $this->display("Performance/perOnes");


        }

第二步：视图层

        <div class="yingfujine">       
                <span>应付金额：<span style="color: red;font-size: 20px;font-weight: bold;">{$money}元</span></span>&nbsp;&nbsp;<span>人数：{$peoplenum}</span>&nbsp;&nbsp;<span>就餐形式：{$eattype}</span>&nbsp;&nbsp;<span>桌号：{$desknum}</span>&nbsp;&nbsp;<span>备注:{$note}</span>
                </div>
        <table class="layui-table text-center margin-top-1" lay-even>
            <thead>
            <tr>
                <th> ID</th>
                <th>商品名称</th>
                <th>单价</th>
                <th>单位</th>
                <th>数量</th>
            </tr>
            </thead>
            <tbody>
            <volist name="orderdata" id="orders">
                <tr>
                    <td>{$orders.id}</td>
                    <td>{$orders.title}</td>
                    <td>{$orders.price}</td>
                    <td>{$orders.unitname}</td>
                    <td>{$orders.total}</td>
                </tr>
            </volist>
            
           </tbody>
        </table>
        <ul class="paginList pager">{$page}</ul>