第一步:控制器里:
public function lookorder(){
$date=I('post.date');
$da=explode(' - ',$date);
$startdate=$da['0']."00:00:00";
$enddate=$da['1']."23:59:59";
$sdate=strtotime($startdate);
$edate=strtotime($enddate);
$usermobile=$_SESSION['usermobile'];//当前登录者用户手机号
$user=M('user');
$userdata=$user->where(array('tellphone'=>$usermobile))->find();
$role=$userdata['role'];
$arrrole=explode(",",$role);
if(in_array("2", $arrrole) or in_array("4", $arrrole) or in_array("5", $arrrole)){//查看当前登录者角色是否具有商家属性
$sid=$userdata['sid'];//在商家表里的ID
$seller=M('seller')->where(array("id"=>$sid))->find();
$id=$seller['id'];
$where['seller_id']= array('eq',$id);
$where['status']=array('egt',1);
$where['ctime'] = array('between',array($sdate,$edate));
$data=array();
$order_data= M("orders")
->alias('o')
->field('o.*')
->order('o.id desc')
->where($where)
->select();
$data['order']=$order_data;
foreach ($order_data as $key => $value) {
$order_goods_data=M('order_goods')->alias('g')->field('g.*,d.*')->join('left join zbt_goods AS d ON g.goodsid=d.id')->where(array("g.orderid"=>$value['id'],"g.storeid"=>$id))->select();
$data['order'][$key]['goods']=$order_goods_data;
}
$countmoney="";
$countmoney=array_sum(array_map(create_function('$val', 'return $val["money"];'), $data['order']));
$order_goods_count=M("orders")->where($where)->count();
$this->assign('order_goods_data',$data['order']);//订单信息
$this->assign('order_goods_count',$order_goods_count);//总订单量
$this->assign('countmoney',$countmoney);//总金额
$arr=array();
$arr['desc']['count']=$order_goods_count;
$arr['desc']['money']=$countmoney;
$arr['item']=$data['order'];
echo json_encode($arr);
}else{
$this->error("不好意思您当前角色不具有商家属性");
}
}
第二步:视图层
<!DOCTYPE html>
<html dir="ltr" lang="en-US">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
<title>订单查询</title>
<link rel="stylesheet" type="text/css" href="__ROOT__/Application/Weixin/Public/bootstrap/css/bootstrap.css">
<link rel="stylesheet" type="text/css" media="all" href="__ROOT__/Application/Weixin/Public/datetime/daterangepicker-bs3.css" />
<style type="text/css">
*{
margin: 0px;
padding: 0px;
}
.shu_jia{
width: 100%;
}
.shu_jia ul{
width: 95%;
height: 30px;
margin: 0px auto;
}
.shu_jia ul li{
list-style: none;
width: 47%;
float: left;
font-size: 14px;
}
th{
text-align: center;
}
td{
padding: 8px;
border: 1px solid;
}
</style>
</head>
<body style="background: ghostwhite;">
<div class="container">
<div class="span12">
<div class="well">
<form class="form-horizontal">
<fieldset>
<div class="control-group">
<div class="controls">
<div class="input-prepend input-group">
<span style="padding: 0px;" class="add-on input-group-addon"><i style="margin:0px 10px;" class="glyphicon glyphicon-calendar fa fa-calendar"></i></span><input type="text" readonly="readonly" style="width: 200px" name="reservation" id="reservation" class="form-control" value="<?php echo date("Y-m-d",time());?> - <?php echo date("Y-m-d",time());?>" />
<button type="button" class="applyBtn btn btn-small btn-success" id="look" style="float: right;display: block;">查看</button>
</div>
</div>
</div>
</fieldset>
</form>
<script type="text/javascript" src="__ROOT__/Application/Weixin/Public/datetime/jquery-1.8.3.min.js"></script>
<script src="__ROOT__/Application/Weixin/Public/bootstrap/js/bootstrap.min.js"></script>
<script type="text/javascript" src="__ROOT__/Application/Weixin/Public/datetime/moment.js"></script>
<script type="text/javascript" src="__ROOT__/Application/Weixin/Public/datetime/daterangepicker.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#reservation').daterangepicker(null, function(start, end, label) {
});
});
function addZero(m) {
return m < 10 ? '0' + m : m ;
}
function formatTime(time) {
var time = new Date(time*1000);
var y = time.getFullYear();
var m = time.getMonth()+1;
var d = time.getDate();
var h = time.getHours();
var mm = time.getMinutes();
var s = time.getSeconds();
return y+'-'+addZero(m)+'-'+addZero(d)+' '+addZero(h)+':'+addZero(mm)+':'+addZero(s);
}
</script>
<script type="text/javascript">
$
$(document).ready(function(){
$("#look").click(function(){
// alert(123);
var date=$("#reservation").val();
// alert(da);
$.ajax({
type:'POST',
url:'__APP__/Weixin/Person/lookorder',
data:{date:date},
//dataType:'json',
success:function(res){
var datasum=JSON.parse(res);
var counts=datasum.desc.count;
var moneys=datasum.desc.money;
$('.count').text(counts);
$('.money').text(moneys);
//console.log(datasum.item.ctime);
var tp1="";
datasum.item.forEach(function(v,k){
tp1 +='<tr>'+'<td>'+v.id+'</td>'+'<td>'+v.ordercode+'</td>'+'<td>'+formatTime(v.ctime)+'</td>'+'<td>'+v.money+'</td>'+'</tr>'+'\n' ;
});
$('.data').html(tp1);
}
})
})
})
</script>
</div>
</div>
</div>
<style type="text/css">
*{
margin: 0px;
padding: 0px;
}
.shu_jia{
width: 100%;
}
.shu_jia ul{
width: 95%;
height: 30px;
margin: 0px auto;
}
.shu_jia ul li{
list-style: none;
width: 47%;
float: left;
font-size: 14px;
}
</style>
<div class="shu_jia">
<ul>
<li>总订单量:<span class="count">0</span></li>
<li>总金额:<span class="money">0</span></li>
</ul>
</div>
<div class="biao" style="width: 95%;margin:0px auto;border: 1px solid gainsboro;">
<table class="table table table-hover">
<tr>
<th>ID</th>
<th>订单号</th>
<th>时间</th>
<th>金额</th>
</tr>
</table>
<div class="data"></div>
</div>
</body>
</html>