第一步:控制器里的方法:
//每笔订单详情
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 \Think\Page($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> <span>人数:{$peoplenum}</span> <span>就餐形式:{$eattype}</span> <span>桌号:{$desknum}</span> <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>