get_statistics.html
5.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
{include file="common/head"/}
<div class="admin-main layui-anim layui-anim-upbit">
<fieldset class="layui-elem-field layui-field-title">
<legend>{:$title}</legend>
</fieldset>
<div class="demoTable">
商家:
<div class="layui-input-inline">
<input class="layui-input" name="key" id="key" placeholder="{:lang('pleaseEnter')}店铺名称" autocomplete="off">
</div>
日期范围:
<div class="layui-input-inline" >
<input type="text" style = "width:300px"; class="layui-input" id="time" placeholder="默认为当天的统计情况">
</div>
商家来源:
<div class="layui-input-inline layui-form">
<div class="layui-input-8">
<select name="class" id="channel" lay-filter="myselect">
<option value="-1">全部</option>
<option value="1" selected>合作</option>
<option value="2">推广</option>
<option value="3">测试</option>
</select>
</div>
</div>
筛选条件:
<div class="layui-input-inline layui-form">
<div class="layui-input-8">
<select name="class" id="time_type" lay-filter="myselect">
<option value="1">录入时间</option>
<option value="2">到店时间</option>
</select>
</div>
</div>
<!--地区:
<div class="layui-input-inline">
<input type="text" class="layui-input" id="area" placeholder="地区暂未开放">
</div>-->
<button class="layui-btn" id="search" data-type="reload">查询统计</button>
</div>
<table class="layui-table" id="list" lay-filter="list">
</table>
</div>
<script type="text/html" id="toolbarDemo">
<span>订单总数:<i id="count">X</i>条 【小程序 <i id="appReserveCount">X</i> / 座机 <i id="AndroidReserveCount">D</i> / C端 <i id="CReserveCount">C</i>】</span>
<span>短信发送数量:<i id="size">Y</i>条 【小程序 <i id="appSmsCount">Y</i> / 座机 <i id="AndroidSmsCount">Y</i>】</span>
<span>邀请总数:<i id="invitee">Z</i>条</span>
<span>联系人总数:<i id="Contacts">W</i>条</span>
</script>
{include file="common/foot"/}
<script>
layui.use(['table','form','laydate'], function() {
var table = layui.table,laydate = layui.laydate,$ = layui.jquery;
console.log(layui);
var tableIn = table.render({
elem: '#list',
url: '{:url("getStatistics")}',
method: 'post',
title: '预定订单统计',
page:true,
sort:true,
toolbar: '#toolbarDemo',
cols: [[
{checkbox:true,fixed: true},
{field: 'id', title: '{:lang("id")}',width:60, fixed: true},
{field: 'address_component', title: '省-市', sort: true},
{field: 'sellername', title: '商家名称'},
{field: 'contacts_total', title: '联系人总数',width:110, sort: true},
{field: 'table_room_total', title: '桌位/包间(总数)',width:130},
{field: 'reserve_count_sort', align: 'right', title: '预定总量',width:100, sort: true},
{field: 'reserve_count', align: 'left', title: '订单构成(小程序/座机/C端)',width:220},
{field: 'sms_send_count_sort', align: 'right',title: '短信发送总量',colspan:1, sort: true},
{field: 'sms_send_count', align: 'left',title: '短信发送构成(小程序/座机)'},
{field: 'inviting', align: 'center',title: '当前商户通过邀请函拉到的顾客', sort: true},
]],
done: function(res, curr, count){
$('#count').html(res.countReserve);
$('#size').html(res.countSms);
$('#invitee').html(res.inviteeCount);
$('#appReserveCount').html(res.appReserveCount);
$('#AndroidReserveCount').html(res.AndroidReserveCount);
$('#CReserveCount').html(res.CReserveCount);
$('#appSmsCount').html(res.appSmsCount);
$('#AndroidSmsCount').html(res.AndroidSmsCount);
$('#Contacts').html(res.Contacts);
}
,id: 'testReload'
,page: true
,limit:15
});
//日期时间范围
laydate.render({
elem: '#time'
,type: 'datetime'
,range: true
});
//搜索
$('#search').on('click', function() {
//关键字
var key = $('#key').val();
//选中的商家ID
var checkStatus = table.checkStatus('testReload'); //test即为参数id设定的值
var a = [];
$(checkStatus.data).each(function(i,o){
a.push(o.id);
});
console.log(a);
var time = $('#time').val();
console.log(time);
//商家来源
var channel = $('#channel').val();
console.log(channel);
//筛选条件
var time_type = $('#time_type').val();
console.log(time_type);
//传参
tableIn.reload({ page: {page: 1},where: {key: key,sid: a,time_type: time_type,time: time,channel: channel}});
});
var $ = layui.$, active = {
reload: function(){
var key = $('#key');
//执行重载
table.reload('testReload', {
page: {
curr: 1 //重新从第 1 页开始
}
,where: {
key: {
id: key.val()
}
}
});
}
};
})
</script>