Helius
2021-06-16 5728be2af515b2200e782aa201ca5d4d67d9ea47
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
154
155
156
157
158
159
160
161
162
163
layui.define([ 'form', 'laydate', 'table' ], function(exports) {
    var form = layui.form;
    var laydate = layui.laydate;
    var table = layui.table;
    var orderStatisticsDetailTable = null;
    var data = null;
    laydate.render({
        elem: '#date',
        format: 'yyyy-MM-dd HH:mm'
    });
    laydate.render({
        elem: '#date1',
        format: 'yyyy-MM-dd HH:mm'
    });
 
    var view ={
 
        init:function(){
            this.initTable();
        },
        initTable:function(){
 
            orderStatisticsDetailTable = table.render({
                elem : '#orderStatisticsDetailTable',
                // height : 'full-180',
                method : 'post',
                url : Common.ctxPath+ '/admin/order/statistics/queryUserOrderNo.json', //数据接口
                where :data,
                page : {"layout":['count','prev', 'page', 'next']} //开启分页
                ,limit : 20,
                cols : [ [ //表头
                    {
                        title : '',
                        width : '100%',
                        templet:function(d){
                            var html = appendSGx(d);
                            var time="--";
                            var name = "--";
                            if(d.receiveTime!=null){
                                time = d.receiveTime;
                            }
                            return '<span>入库单编号:</span>'+d.storageId + '<span>&nbsp;&nbsp;&nbsp;  入库单时间:</span>'+time +'<span>&nbsp;&nbsp;&nbsp;  入库员:'+$.base64.atob(name, true)+'&nbsp;&nbsp;&nbsp;  (电话:'+$("#phone").val()+')</span><br><br/>'+
                                html;
                        }
                    }
                ] ]
 
            });
        },
    };
    var searchTotal = function(){
        data['startTime']= $("#startTime").val();
        data['endTime']= $("#endTime").val();
        // 获取统计数据
        $.post(Common.ctxPath+ '/admin/order/statistics/queryDetailTotal.json',data,
            function (value) {
                var d = {'afterData':value.data.afterTotalx,'before':value.data.beforeTotal};
                $("#sigleStatic").after(appendTable(d));
            });
    }
    var appendSGx = function (data) {
        console.log(data);
        var att = data.afterData;
        var btt = data.before;
        var afterWeithtTotal = 0;
        var afterMoneyTotal = 0;
        var beforeWeithTotal = 0;
        var beforeMoneyTotal = 0;
        var weithSubTotal = 0;
        var moneySubTotal = 0;
        var ids1 = 'x' + Math.floor(Math.random()*1000000);
        var htmlType = '<div class="layui-row layui-col-space10" id="'+ids1+'"><div class="layui-col-sm88" style="border: 1px solid #afaaaa;height: 31px;">类型</div>';
        var ids2 = 'x' + Math.floor(Math.random()*1000000);
        var htmlWeight = '<div class="layui-row layui-col-space10" id="'+ids2+'"><div class="layui-col-sm88" style="border: 1px solid #afaaaa;height: 31px;">入库重量</div>';
        var ids3 = 'x' + Math.floor(Math.random()*1000000);
        var htmlMoney = '<div class="layui-row layui-col-space10" id="'+ids3+'"><div class="layui-col-sm88" style="border: 1px solid #afaaaa;height: 31px;">回收重量</div>';
        var htmlSub = '<div class="layui-row layui-col-space10" id="hs"><div class="layui-col-sm88" style="border: 1px solid #afaaaa;height: 31px;">误差</div>';
        for(var i = 0; i < att.length; i++){
            htmlType += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+att[i].configValueName+'</div>';
            htmlWeight += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+att[i].weight+'kg/'+att[i].money+'元</div>';
            htmlMoney += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+btt[i].weight+'kg/'+btt[i].money+'元</div>';
            htmlSub += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+(btt[i].weight - att[i].weight).toFixed(2)+'kg/' + (btt[i].money - att[i].money).toFixed(2) +'元</div>';
            weithSubTotal += (btt[i].weight - att[i].weight);
            moneySubTotal += (btt[i].money - att[i].money);
            afterWeithtTotal += att[i].weight;
            afterMoneyTotal += att[i].money;
            beforeWeithTotal += btt[i].weight;
            beforeMoneyTotal += btt[i].money;
        }
        htmlType += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">统计</div></div>';
        htmlWeight += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+afterWeithtTotal.toFixed(2)+'kg/'+afterMoneyTotal.toFixed(2)+'元</div></div>';
        htmlMoney += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+beforeWeithTotal.toFixed(2)+'kg/'+beforeMoneyTotal.toFixed(2)+'元</div></div>';
        htmlSub += '<div class="layui-col-sm99" style="border: 1px solid #afaaaa;height: 31px;">'+weithSubTotal.toFixed(2)+'kg/'+moneySubTotal.toFixed(2)+'元</div></div>';
        return htmlType + htmlWeight + htmlMoney + htmlSub;
    }
 
    $("#sigleStatic").append('<legend>回收员统计</legend>');
    data = {'receiverphone':$("#phone").val()};
    if($("#flag").val() == 1){
        data['startTime'] = new Date().Format("yyyy-MM-dd")+' 00:00:00';
        data['endTime'] = new Date().Format("yyyy-MM-dd")+ ' 23:59:59';
    }
    searchTotal();
 
    var appendTable = function (data) {
        var att = data.afterData;
        var btt = data.before;
        var afterWeithtTotal = 0;
        var afterMoneyTotal = 0;
        var beforeWeithTotal = 0;
        var beforeMoneyTotal = 0;
        var weithSubTotal = 0;
        var moneySubTotal = 0;
        for(var i = 0; i < att.length; i++){
 
            var row=document.createElement("tr");
            var td1=document.createElement("td");
            var td2=document.createElement("td");
            var td3=document.createElement("td");
            var td4=document.createElement("td");
            td1.appendChild(document.createTextNode(att[i].configValueName));
            td2.appendChild(document.createTextNode(att[i].weight+'kg/'+att[i].money+'元'));
            td3.appendChild(document.createTextNode(btt[i].weight+'kg/'+btt[i].money+'元'));
            td4.appendChild(document.createTextNode((btt[i].weight - att[i].weight).toFixed(2)+'kg/' + (btt[i].money - att[i].money).toFixed(2) +'元'));
            row.appendChild(td1);
            row.appendChild(td2);
            row.appendChild(td3);
            row.appendChild(td4);
 
            weithSubTotal += (btt[i].weight - att[i].weight);
            moneySubTotal += (btt[i].money - att[i].money);
            afterWeithtTotal += att[i].weight;
            afterMoneyTotal += att[i].money;
            beforeWeithTotal += btt[i].weight;
            beforeMoneyTotal += btt[i].money;
            document.getElementById("rows").append(row);
            if(i==(att.length-1)){
                var row1=document.createElement("tr");
                var td11=document.createElement("td");
                var td22=document.createElement("td");
                var td33=document.createElement("td");
                var td44=document.createElement("td");
                td11.appendChild(document.createTextNode('统计'));
                td22.appendChild(document.createTextNode(afterWeithtTotal.toFixed(2)+'kg/'+afterMoneyTotal.toFixed(2)+'元'));
                td33.appendChild(document.createTextNode(beforeWeithTotal.toFixed(2)+'kg/'+beforeMoneyTotal.toFixed(2)+'元'));
                td44.appendChild(document.createTextNode(weithSubTotal.toFixed(2)+'kg/'+moneySubTotal.toFixed(2)+'元'));
                row1.appendChild(td11);
                row1.appendChild(td22);
                row1.appendChild(td33);
                row1.appendChild(td44);
                    document.getElementById("rows").append(row1);
            }
        }
    }
    view.init();
    /*var x = $(".layui-table-cell");
    for(var i = 1; i < x.length; i++){
        console.log(x[i]);
        x[i].css({'height':'100px'});
    }*/
    exports('orderStatisticsReceiveDetail',view);
 
});