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
| var pageCurr;
| var tableIns;
|
| function getCol() {
| var sumCol = [
| {field: 'matnr', align: 'center',title: '物料编码'}
| ,{field: 'maktx', align: 'center',title: '物料名称', width: 500}
| ,{field: 'lgnum', align: 'center',title: '规格'}
| ,{field: 'type', align: 'center',title: '物料类别'}
| ,{field: 'mnemonic', align: 'center',title: '生产单号'}
| ,{field: 'supplier', align: 'center',title: '通知单号'}
| ,{field: 'anfme', align: 'center',title: '数量'}
| ];
| var cols = [{field: 'locNo', align: 'center', title: '库位号'}];
| cols.push.apply(cols, sumCol);
| return cols;
| }
|
| layui.use(['table', 'laydate', 'form'], function () {
| var table = layui.table;
| var $ = layui.jquery;
| var layer = layui.layer;
| var layDate = layui.laydate;
| var form = layui.form;
|
| // 数据渲染
| tableIns = table.render({
| elem: '#sumLocDetl',
| headers: {token: localStorage.getItem('token')},
| url: baseUrl + '/locDetl/queryAllMatDetl',
| page: true,
| limit: 16,
| limits: [16, 30, 50, 100, 200, 500],
| even: true,
| toolbar: '#toolbar',
| cellMinWidth: 50,
| cols: [getCol()],
| request: {
| pageName: 'curr',
| pageSize: 'limit'
| },
| parseData: function (res) {
| return {
| 'code': res.code,
| 'msg': res.msg,
| 'count': res.data.total,
| 'data': res.data.records
| }
| },
| response: {
| statusCode: 200
| },
| done: function (res, curr, count) {
| if (res.code === 403) {
| top.location.href = baseUrl + "/";
| }
| pageCurr = curr;
| limit();
| form.on('checkbox(tableCheckbox)', function (data) {
| var _index = $(data.elem).attr('table-index') || 0;
| if (data.elem.checked) {
| res.data[_index][data.value] = 'Y';
| } else {
| res.data[_index][data.value] = 'N';
| }
| });
| }
| });
|
| /* 搜索 */
| form.on('submit(search)',function () {
| tableReload(false);
| });
| /* 重置 */
| form.on('submit(reset)',function () {
| pageCurr = 1;
| clearFormVal($('#search-box'));
| tableReload(false);
| });
| });
|
| function clearFormVal(el) {
| $(':input', el)
| .val('')
| .removeAttr('checked')
| .removeAttr('selected');
| }
|
| /* 表格数据重载 */
| function tableReload(child) {
| var searchData = {};
| $.each($('#search-box [name]').serializeArray(), function () {
| searchData[this.name] = this.value;
| });
| (child ? parent.tableIns : tableIns).reload({
| where: searchData,
| page: {
| curr: pageCurr
| },
| done: function (res, curr, count) {
| if (res.code === 403) {
| top.location.href = baseUrl + "/";
| }
| pageCurr = curr;
| if (res.data.length === 0 && count !== 0) {
| tableIns.reload({
| where: searchData,
| page: {
| curr: pageCurr - 1
| }
| });
| pageCurr -= 1;
| }
| limit(child);
| // 当前分页数据存储
| locNormalList = res.data;
| }
| });
| }
|
|