wzy
2021-04-01 d388e2788b7ef088d7cd40f901b0acdcec460bc3
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
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
 
<!DOCTYPE HTML>
<html xmlns:th="http://www.thymeleaf.org" xmlns:matrix="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
<LINK rel="Bookmark" href="../images/favicon.ico">
<!-- 本框架基本脚本和样式 -->
<script type="text/javascript"
        th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>
<script type="text/javascript" th:src="@{/js/systools/MBase.js}"></script>
 
</head>
<body class="gray-bg">
     
 
    <div class="ibox-content">
        <!-- 搜索框部分start -->
        <form class="form-inline" id="serchform">
        <div class="row mb-10">
                <div class="col-sm-8">
                    <button  onclick="myGrid.serchData()" type="button" class="btn btn-info btn-sm"><i class="fa fa-search" ></i> 搜索</button>
                    <button  onclick="myGrid.resetForm()" type="button"   class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button>
                    <button onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button>
                </div>
            </div>
            <div class="form-group mr-20">
                <label>日期范围</label>
                <input name="beginTime" type="text" class="form-control datetimepicker" id="beginTime">-
                <input name="endTime"  type="text" class="form-control datetimepicker" id="endTime">
            </div>
 
            <div class="form-group mr-20">
                <label >商品名称</label>
                <input autocomplete="off" id="productCode"  placeholder="输入商品名称/编码"  class="form-control " name="name" >
                <input   id="shopId"  type="hidden" name="shopId" >
            </div>
            <div class="form-group mr-20">
                <label >操作人</label>
                <input autocomplete="off"   class="form-control " name="userName"  >
            </div>
            <div class="form-group mr-20">
                <label for="parentId">库存分类</label>
                <select class="form-control select2" size="1" name="goodsSortId" id="parentId">
                    <option value="" selected="selected">--选择分类--</option>
                </select>
            </div>
            <div class="form-group mr-20">
                <label  >单据类型</label>
                <select class="form-control" name="orderType" id="goodType">
                    <option value=''>--请选择商品类型--</option>
                    <option value='消耗产品出库'>消耗产品出库</option>
                    <option value='盘亏出库'>盘亏出库</option>
                    <option value='采购入库'>采购入库</option>
                    <option value='退货入库'>退货入库</option>
                    <option value='其他入库'>其他入库</option>
                    <option value='盘盈入库'>盘盈入库</option>
                </select>
            </div>
        </form>
 
 
        <table id="mgrid">
            <thead>
                <tr>
                    <th data-formatter="MGrid.indexfn" data-align="center"
                        data-width="30px" data-footer-formatter="footCountTitle">序号</th>
                    <th data-field="createTime">时间</th>
                    <th data-field="code">产品编码</th>
                    <th data-field="name">商品名称</th>
                    <th data-field="typeName">库存分类</th>
                    <th data-field="amount" data-footer-formatter="countColumn">出库数量</th>
                    <th data-field="goodsPrice" >出库单价</th>
                    <th data-field="totalPrice" data-footer-formatter="countColumn">出库金额</th>
                    <th data-field="orderNo" data-formatter="buildJumpToDetailInfo" >单据编号</th>
                    <th data-field="orderType">单据类型</th>
                    <th data-field="batch">库存批次</th>
                    <th data-field="userName">操作人</th>
                    <th data-field="remark">单据备注</th>
                    <th data-field="shopName">门店</th>
                </tr>
            </thead>
        </table>
    </div>
    <div class="form-group " id="closeBtn" style="display: none;" >
        <div class="col-sm-12 text-center fixed-button">
            <a class="btn btn-danger radius" href="javascript:;"
               onclick="MTools.closeForm()"><i class="fa fa-close"></i> 关闭</a>
        </div>
    </div>
 
 
    <script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script><script type="text/javascript">
        var productCode=$.query.get('productCode');
 
        $("#productCode").val(productCode);
        if(productCode){
            $("#closeBtn").show();
        }
 
 
 
        debugger
        var myGrid;
        var initParam = {
                format : "yyyy-mm-dd hh:ii", //默认显示年与日,如果想显示十分秒:"yyyy-mm-dd hh:ii:ss"
                minView: "hour",     //"month",只显示年月日的选择,不会再跳转去选择时分秒;如果想要选择时分秒的:"hour"
            }
         MTools.ininDatetimepicker(initParam);
        //限制结束时间不小于开始时间
         MTools.limitStartEndTime({}); 
        
 
        $(function() {
            MTools.autoFullSelect();
            myGrid = MGrid.initGrid({
                url : basePath+"/admin/storeInOut/showCurrentShopList",
                showExport : true,
                showFooter : true,
                height:'auto',
                width:'auto',
 
            });
 
            $('[data-toggle="tooltip"]').tooltip()
 
        });
 
        function footCountTitle(data) {
            return "<b>合计</b>";
        };
        function countColumn(data) {
            console.log(data)
             field = this.field;
                var resultsumQuantity = parseFloat((data.reduce(function(sum, row) { 
                    console.log(sum,row[field]);
                    return sum + (+row[field]);
                }, 0)).toFixed(2));//保留有效数字
                return "<b>"+resultsumQuantity+"</b>";
        };
 
        function exportExcel(){
            var param=MForm.toUrlParam("#serchform");
            window.location.href=basePath+"/admin/storeInOut/exportExcel?"+param;
        }
 
        initFunctionList();
        function initFunctionList() {
            $.AjaxProxy({
                a: false,
                c: false
            }).invoke(basePath + "/admin/goodstype/all", function (loj) {
                $("#parentId").createSelectTree(loj.attr("result").rows, {
                    append: true,
                    value: "typeName",
                });
            });
        }
 
        function buildJumpToDetailInfo(value, row, index) {
            console.log(row)
            var html = [];
            if (row.orderType.indexOf("入库") > 0) {
                html[0] = '<a  onClick="lookInstore( \'' + row.id +'\')"   class="text-primary " >'+value+'</a>';
            } else {
                html[0] = '<a  onClick="lookOutstore( \'' + row.id +'\')"   class="text-primary " >'+value+'</a>';
            }
            return html;
        }
 
        function lookInstore(id) {
            layer.full(
                    layer.open({
                        type: 2,
                        title: "查看入库单",
                        area: [MUI.SIZE_L, '400px'],
                        maxmin: true,
                        content: [basePath+'/admin/instore/lookInfo?id=' + id]
                    }));
        }
 
        function lookOutstore(id){
            layer.full(
                    layer.open({
                        type : 2,
                        title : "查看出库单",
                        area : [ MUI.SIZE_L, '400px' ],
                        maxmin : true,
                        content : [ basePath+'/admin/outstore/lookForm?id=' + id]
                    }));
        }
        
    </script>
</body>
</html>