david-PC\david
2018-06-12 f240ac3ccd37c541cab2c21cfc433d3510999a3c
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
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>经销商终端销售汇总(销售)</title>
    <link rel="stylesheet" type="text/css" href="../../css/easyui.css">
    <link rel="stylesheet" type="text/css" href="../../css/icon.css">
    <script src="../../js/jquery-1.7.2.min.js"></script>
    <script src="../../js/foundation-2.0.js"></script>
    
    <script type="text/javascript" src="../../js/jquery.easyui.min.js"></script>
    
    <script type="text/javascript" src="../../js/datagrid-filter.js"></script>
    <script type="text/javascript" src="../../js/easyui-lang-zh_CN.js"></script>    
    <script type="text/javascript" src="../../js/datagrid_handler.js"></script>    
    <script type="text/javascript" >
        var grid, dataGridHander;
        function initDateime() {
            //1. set begin date, default this month begin
            var starttime = $('#starttime').datebox('getValue');
            if (starttime == "") {
                var datetime = new DateTime();
                datetime.toMonthBegin();
                starttime = datetime.str;
                $('#starttime').datebox('setValue', starttime);    
            }
            
            //2. set end date, default now
            var endtime = $('#endtime').datebox('getValue');
            if (endtime == "") {
                var datetime = new DateTime();
                endtime = datetime.str;
                $('#endtime').datebox('setValue', endtime);    
            }            
        }
 
        function query() {
            initDateime();
            
            var starttime = $('#starttime').datebox('getValue');
            var endtime = $('#endtime').datebox('getValue');
            
            var params = '&startDate='+starttime+'&endDate='+endtime;
            
            dataGridHander.resetGridParams({
                url:'root/data/procedure/getTotal4Sales/getDataSet?'+params,
            });
            
            dataGridHander.gridRefresh();
            
        } 
        
        function initQuery() {
            var datearray = [];
            
            initDateime();
            
            datearray[0] = $('#starttime').datebox('getValue');
            datearray[1] = $('#endtime').datebox('getValue');
 
            return datearray;
        }
        
        $(document).ready(function() {
        
            grid = $('#invoicingcomparisontotal');
            var datearray = initQuery();         
            var params = '&startDate='+datearray[0]+'&endDate='+datearray[1];    
            var columnsurl = "statistics-report/invoicingcomparisontotal";
            var gridUrl = 'root/data/procedure/getInvoicingComparisonTotal/getDataSet?'+params;
            
            dataGridHander = new DataGridHandler({
                grid:grid,
                tbOption:["fieldSetting","fresh","addline","export","upload","delete","edit"],
                columnUrl:columnsurl,
                gridUrl:gridUrl,
                tbFuncParams: [
                {
                    //fieldSettingurl
                },
                {},
                {
                    tablename:"haha"
                },
                {
                    exporturl:"http://localhost:3456/api/FileCenter/Download?code=InvoicingComparisonTotal&fileExtension=xlsx" + params
                },
                {
                    from:"InvoicingComparisonTotal"
                },
                {
                    key:"key",
                    tablename:"name"
                },{}]
                
            });
            
        });    
            
    </script>        
</head>
 
<body>
    <div class="query-list">
        <div style="margin-left:20px;height:40px;margin-top:10px">
                <label style="margin: 0 10px 0 10px;font-size: initial;font-weight: 600;font-size:medium;color: #5a5a5a;">开始时间:</label>
                <input id="starttime" class="easyui-datebox" style="margin-left:20px;height:30px;width:120px;float:left;">
                <label style="margin: 0 10px 0 10px;font-size: initial;font-weight: 600;font-size:medium;color: #5a5a5a;">结束时间:</label>
                <input id="endtime" class="easyui-datebox" style="margin-left:20px;height:30px;width:120px;float:left;">
                    <a href="#" onclick="query()" class="easyui-linkbutton l-btn l-btn-small" data-options="iconCls:'icon-search'" style="margin: 0 10px 0 30px">
                        <span class="l-btn-left l-btn-icon-left">
                            <span class="l-btn-text">
                                <span class="l-btn-left l-btn-icon-left">
                                    <span class="l-btn-text">查看</span>
                                </span>
                            </span>
                        </span>
                    </a>
        </div>
    </div>
    
    <table id="invoicingcomparisontotal"></table>
</body>
</html>