username@email.com
2024-05-16 2d2a6b9d20ae8c5d9fcbedac48b4428f696fa127
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
141
142
143
144
145
146
147
148
149
150
151
152
153
<script src="/lib/layuiAdmin/lib/extend/echarts.js"></script>
<script src="/lib/layuiAdmin/lib/extend/echartsTheme.js"></script>
<div class="layui-form coreshop-search-form">
    <div class="layui-form-item">
        <label class="layui-form-label">时间范围:</label>
        <div class="layui-input-inline layui-inline-4">
            <input type="text" name="date" value="" id="date" placeholder="请输入起止时间" autocomplete="off" class="layui-input">
        </div>
        <label class="layui-form-label">粒度:</label>
        <div class="layui-input-inline layui-inline-2">
            <select name="section" id="section">
                <option value="1">小时</option>
                <option value="2" selected="selected">天</option>
            </select>
        </div>
        <div class="layui-inline">
            <div class="">
                <button class="layui-btn layui-btn-sm" val="" lay-submit lay-filter="*"><i class="iconfont icon-chaxun"></i>确定</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="1" lay-submit lay-filter="*">今日</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="2" lay-submit lay-filter="*">昨日</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="3" lay-submit lay-filter="*">本周</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="4" lay-submit lay-filter="*">上周</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="5" lay-submit lay-filter="*">本月</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="6" lay-submit lay-filter="*">上月</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="7" lay-submit lay-filter="*">7日内</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="8" lay-submit lay-filter="*">一月内</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="9" lay-submit lay-filter="*">三月内</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="10" lay-submit lay-filter="*">半年内</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="11" lay-submit lay-filter="*">一年内</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="12" lay-submit lay-filter="*">本年度</button>
                <button class="layui-btn layui-btn-primary layui-btn-sm" val="13" lay-submit lay-filter="*">上年度</button>
            </div>
        </div>
    </div>
</div>
<div class="table-body">
    <div id="main" style="height:400px;padding:10px;"></div>
    <table id="LAY-app-Report-tableBox" lay-filter="LAY-app-Report-tableBox"></table>
</div>
 
 
<script type="text/html" id="LAY-app-Report-toolbar">
    <div class="report_table_bar"><span><i class="layui-icon layui-icon-triangle-r"></i> 右侧按钮进行打印下载操作。</span></div>
</script>
 
<script type="text/javascript">
    var debug = layui.setter.debug;
    layui.use(['index', 'element', 'laydate', 'form', 'table', 'coreHelper', 'util', 'table'], function () {
        var $ = layui.$;
        var form = layui.form;
        var element = layui.element;
        var coreHelper = layui.coreHelper;
        var util = layui.util;
        var table = layui.table;
        var tableData = {};
        //时间插件
        var date = new Date();
        layui.laydate.render({
            elem: '#date',
            range: '到',
            type: 'date',
            value: util.toDateString(date, 'yyyy-MM-dd') + ' 到 ' + util.toDateString(date, 'yyyy-MM-dd'),
            trigger: 'click'
        });
 
        layui.form.on('submit(*)', function (data) {
            type = data.elem.getAttribute('val');
            if (type != "") {
                getTime(type, function () {
                    order_report();
                });
            } else {
                order_report();
            }
            return false; //阻止表单跳转。如果需要表单跳转,去掉这段即可。
        });
 
 
        //数据绑定
        table.render({
            elem: '#LAY-app-Report-tableBox',
            method: 'POST',
            toolbar: '#LAY-app-Report-toolbar',
            defaultToolbar: ['filter', 'print', 'exports'],
            //height: 'full-127',
            page: false,
            limit: 8760,
            //limits: [10, 15, 20, 25, 30, 50, 100, 200],
            text: { none: '暂无相关数据' },
            totalRow: true,
            cols: [
                [
                    { field: 'x', title: '日期', width: 150 }
                    , { field: 'order_all_val', title: '全部金额', width: 150, totalRow: true }
                    , { field: 'order_all_num', title: '全部数量', width: 150, totalRow: true }
                    , { field: 'order_nopay_val', title: '待支付金额', width: 150, totalRow: true }
                    , { field: 'order_nopay_num', title: '待支付数量', width: 150, totalRow: true }
                    , { field: 'order_payed_val', title: '已付款金额', width: 150, totalRow: true }
                    , { field: 'order_payed_num', title: '已付款数量', width: 150, totalRow: true }
                ]
            ]
        });
 
        //重载form
        form.render();
 
        //取值
        function order_report() {
            var data = {
                date: $('#date').val(),
                section: $('#section').val()
            };
 
            coreHelper.Post("Api/CoreCmsReports/GetOrder", data, function (res) {
                if (debug) { console.log(res); } //开启调试返回数据
                if (res.code == 0) {
                    //刷新折线图
                    var myChart = echarts.init(document.getElementById('main'));
                    option = res.data.option;
                    // 使用刚指定的配置项和数据显示图表。
                    myChart.setOption(option);
                    //刷新table
                    layui.table.reloadData('LAY-app-Report-tableBox', {
                        data: res.data.table
                    });
                    tableData = res.data.table;
                } else {
                    layer.msg(res.msg);
                }
            });
        }
        //解析时间按钮
        function getTime(type, calback) {
            var data = {
                id: type
            };
            coreHelper.Post("Api/CoreCmsReports/GetDateType", data, function (res) {
                if (debug) { console.log(res); } //开启调试返回数据
                if (res.code == 0) {
                    //设置时间,回调
                    $('#date').val(res.data.start + " 到 " + res.data.end);
                    calback();
                } else {
                    layer.msg(res.msg);
                }
            });
        }
        function table_export() {
            layui.table.exportFile('table', tableData);
        }
        order_report();
    });
</script>