var syncTableData = [];
|
|
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: '#locSum',
|
headers: {token: localStorage.getItem('token')},
|
url: baseUrl + '/locSync/queryLocSum',
|
page: true,
|
// limit: 16,
|
// limits: [16, 30, 50, 100, 200, 500],
|
even: true,
|
toolbar: '#toolbar',
|
cellMinWidth: 50,
|
cols: [[
|
{field: 'matnr', align: 'center', title: '物料编码', width: 200}
|
, {field: 'maktx', align: 'center', title: '物料名称'}
|
, {field: 'anfme', align: 'center', title: '总数量[平仓+立库]', width: 180}
|
, {field: 'altme', align: 'center', title: '单位', width: 80}
|
, {field: 'memo', align: 'center', title: '备注'}
|
]],
|
request: {
|
pageName: 'curr',
|
pageSize: 'limit'
|
},
|
parseData: function (res) {
|
return {
|
'code': res.code,
|
'msg': res.msg,
|
'count': res.data.total,
|
'data': res.data
|
}
|
},
|
response: {
|
statusCode: 200
|
},
|
done: function (res, curr, count) {
|
if (res.code === 403) {
|
top.location.href = baseUrl + "/";
|
}
|
pageCurr = curr;
|
limit();
|
syncTableData = res.data;
|
}
|
});
|
|
// 监听头工具栏事件
|
table.on('toolbar(locSum)', function (obj) {
|
switch (obj.event) {
|
case 'otherExportData':
|
layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){
|
var titles=[];
|
var fields=[];
|
obj.config.cols[0].map(function (col) {
|
if (col.type === 'normal' && col.hide === false && col.toolbar == null) {
|
titles.push(col.title);
|
fields.push(col.field);
|
}
|
});
|
var exportData = {};
|
$.each($('#search-box [name]').serializeArray(), function() {
|
exportData[this.name] = this.value;
|
});
|
var param = {
|
'pakin': exportData,
|
'fields': fields
|
};
|
$.ajax({
|
url: baseUrl+"/locsync/export/auth",
|
headers: {'token': localStorage.getItem('token')},
|
data: JSON.stringify(param),
|
dataType:'json',
|
contentType:'application/json;charset=UTF-8',
|
method: 'POST',
|
success: function (res) {
|
layer.closeAll();
|
if (res.code === 200) {
|
table.exportFile(titles,res.data,'xls');
|
} else if (res.code === 403) {
|
top.location.href = baseUrl+"/";
|
} else {
|
layer.msg(res.msg, {icon: 2})
|
}
|
}
|
});
|
});
|
break;
|
case 'btnSync':
|
$.ajax({
|
url: baseUrl + "/locSync/syncLocWrkCount",
|
headers: {'token': localStorage.getItem('token')},
|
data: {},
|
method: 'POST',
|
traditional: true,
|
success: function (res) {
|
if (res.code === 200) {
|
var msg = '';
|
if (res.data == 0) {
|
msg = '确定要同步库存数据吗?'
|
} else {
|
msg = '同步任务正在进行，确定要中止并重新同步吗?'
|
}
|
layer.confirm(msg, {
|
shadeClose: true
|
, btn: ['确定']
|
}, function () {
|
var paramList = [];
|
syncTableData.map(function (e) {
|
paramList.push({
|
matnr: e.matnr,
|
qty: e.anfme,
|
});
|
});
|
var param = {
|
'list': paramList,
|
};
|
if (res.data > 0) {
|
// 清空同步上传清单数据,再进行插入数据
|
$.ajax({
|
url: baseUrl + "/locSync/updateWrklocSync",
|
headers: {'token': localStorage.getItem('token')},
|
data: JSON.stringify(param),
|
dataType: 'json',
|
contentType: 'application/json;charset=UTF-8',
|
method: 'POST',
|
success: function (res) {
|
if (res.code === 200) {
|
layer.msg("库存同步中！");
|
} else if (res.code === 403) {
|
top.location.href = baseUrl + "/";
|
} else {
|
layer.msg(res.msg)
|
}
|
}
|
});
|
} else {
|
// 调用同步上传清单数据插入接口
|
$.ajax({
|
url: baseUrl + "/locSync/insertWrklocSync",
|
headers: {'token': localStorage.getItem('token')},
|
data: JSON.stringify(param),
|
dataType: 'json',
|
contentType: 'application/json;charset=UTF-8',
|
method: 'POST',
|
success: function (res) {
|
if (res.code === 200) {
|
layer.msg("库存同步中！");
|
} else if (res.code === 403) {
|
top.location.href = baseUrl + "/";
|
} else {
|
layer.msg(res.msg)
|
}
|
}
|
});
|
}
|
layer.closeAll();
|
}
|
);
|
} else if (res.code === 403) {
|
top.location.href = baseUrl + "/";
|
} else {
|
layer.msg(res.msg)
|
}
|
}
|
});
|
break;
|
|
default:
|
break;
|
}
|
});
|
});
|
