var insTbCount = 0;
layui.config({
base: baseUrl + "/static/layui/lay/modules/"
}).use(['layer', 'form', 'table', 'util', 'admin', 'xmSelect', 'laydate'], function () {
var $ = layui.jquery;
var layer = layui.layer;
var form = layui.form;
var table = layui.table;
var util = layui.util;
var admin = layui.admin;
var xmSelect = layui.xmSelect;
var layDate = layui.laydate;
var laytpl = layui.laytpl;
// 渲染搜索模板
$.ajax({
url: baseUrl + "/docType/list/auth",
headers: {'token': localStorage.getItem('token')},
data: {
limit: 9999
},
method: 'POST',
success: function (res) {
if (res.code === 200) {
let template = Handlebars.compile($('#docTypeTpl').html());
$('#docType-query').html(template(res.data));
layui.form.render('select');
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2})
}
}
})
// 渲染表格
var insTb = table.render({
elem: '#order',
url: baseUrl + '/order/head/page/auth',
headers: {token: localStorage.getItem('token')},
page: true,
cellMinWidth: 100,
cols: [[
{type: 'numbers'},
{field: 'orderNo', title: '单据编号', templet: '#orderNoTpl'},
// {field: 'itemName', align: 'center', title: '客户po', minWidth: 160, width: 160},
{field: 'docType$', align: 'center', title: '类型', minWidth: 160, width: 160},
{field: 'cstmrName', align: 'center', title: '货主', minWidth: 160, width: 160},
{align: 'center', title: '明细', toolbar: '#tbLook', minWidth: 160, width: 160},
{field: 'createTime$', title: '创建时间', minWidth: 200, width: 200},
{field: 'settle$', align: 'center', title: '状态', templet: '#settleTpl', minWidth: 160, width: 160},
{field: 'memo', align: 'center', title: '备注', hide: true},
{align: 'center', title: '操作', toolbar: '#operate', width: 180}
]],
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) {
limit();
if (res.code === 403) {
top.location.href = baseUrl + "/";
}
insTbCount = count;
}
});
// 搜索
form.on('submit(tbSearch)', function (data) {
insTb.reload({where: data.field, page: {curr: 1}});
});
// 添加
$("#orderAddBtn").click(function () {
showEditModel();
});
// 工具条点击事件
table.on('tool(order)', function (obj) {
var data = obj.data;
var layEvent = obj.event;
if (layEvent === 'edit') {
showEditModel(data);
} else if (layEvent === 'wrkTrace') {
showWrkTrace(data.id);
} else if (layEvent === 'del') {
doDel(data.id);
} else if (layEvent === 'complete') {
doModify(data.id, data.orderNo, 6);
} else if (layEvent === 'continueExecution') {
doModify99(data.id, data.orderNo, 99);
} else if (layEvent === 'look') {
var $a = $(obj.tr).find('a[lay-event="look"]');
var offset = $a.offset();
var top = offset.top;
var left = offset.left;
layer.open({
type: 1,
title: false,
area: '820px',
offset: [top + 'px', (left - 530 + $a.outerWidth()) + 'px'],
shade: .01,
shadeClose: true,
fixed: false,
content: '
',
success: function (layero) {
table.render({
elem: '#lookSSXMTable',
headers: {token: localStorage.getItem('token')},
url: baseUrl + '/orderDetl/list/auth',
where: {
order_id: data.id
},
page: true,
cellMinWidth: 100,
cols: [[
{type: 'numbers'},
{field: 'matnr', title: '商品编号', width: 160},
{field: 'maktx', title: '名称', width: 80},
{field: 'standby1', title: '客户PO'},
{field: 'standby2', title: 'UPC'},
{field: 'standby3', title: '客户SKU'},
{field: 'boxType1', title: '货主'},
{field: 'boxType3', title: '采购单号'},
{field: 'anfme', title: '数量', width: 80},
{field: 'qty', title: '上报数量', style: 'font-weight: bold'},
{field: 'workQty', title: '历史上报数量'},
]],
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 () {
$(layero).find('.layui-table-view').css('margin', '0');
},
size: ''
});
}
});
}
});
// 显示表单弹窗
function showEditModel(expTpe) {
admin.open({
type: 1,
title: (expTpe ? '修改' : '添加') + '单据',
content: $('#editDialog').html(),
area: '1300px',
success: function (layero, dIndex) {
$(layero).children('.layui-layer-content').css('overflow', 'visible');
var isExpAdd = !expTpe;
// 回显数据
form.val('editForm', expTpe);
if (expTpe) {
$('#orderNo').attr("disabled", "disabled");
}
// 表单提交事件
form.on('submit(orderEditSubmit)', function (data) {
// 组装数据
if (xxDataList.length <= 0) {
layer.tips('请添加单据明细', '#matAddBtnComment', {tips: [1, '#ff4c4c']});
return false;
}
let nList = admin.util.deepClone(xxDataList);
for (let xi = 0; xi < nList.length; xi++) {
if (nList[xi].anfme <= 0) {
layer.msg('明细修改数量不合法', {icon: 2});
return false;
}
if (nList[xi].anfme < nList[xi].workQty) {
layer.msg('数量不能小于已作业数量', {icon: 2});
return false;
}
}
layer.load(2);
$.ajax({
url: baseUrl + "/order/form/" + (isExpAdd ? "add" : "modify") + "/auth",
headers: {'token': localStorage.getItem('token')},
data: JSON.stringify({
orderId: Number(data.field.id),
docType: Number(data.field.docType),
orderNo: data.field.orderNo,
standby1: data.field.standby1,
ownerId: Number(data.field.owner),
orderDetlList: nList
}),
contentType: 'application/json;charset=UTF-8',
method: 'POST',
success: function (res) {
layer.closeAll('loading');
if (res.code === 200) {
layer.close(dIndex);
$(".layui-laypage-btn")[0].click();
layer.msg(res.msg, {icon: 1});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2});
}
}
})
return false;
});
// 明细表格
var xxDataList = [];
var tbOptions = {
elem: '#formSSXMTable',
headers: {token: localStorage.getItem('token')},
data: xxDataList,
page: true,
height: '350px;',
cellMinWidth: 100,
cols: [[
{type: 'numbers', title: '#'},
{field: 'matnr', title: '商品编号', width: 160},
{field: 'maktx', title: '名称', width: 80},
// {field: 'batch', title: '批号', edit: true},
// {field: 'specs', title: '规格'},
{field: 'standby1', title: 'po', edit: true},
{field: 'standby2', title: 'upc', edit: true},
{field: 'standby3', title: '客户SKU', edit: true},
{field: 'boxType1', title: '货主名称', edit: true},
{field: 'boxType2', title: '货主编号', edit: true},
{field: 'boxType3', title: '采购单号', edit: true},
{
field: 'anfme',
title: '数量(修改)',
style: 'color: blue;font-weight: bold',
edit: true,
minWidth: 110,
width: 110
},
{field: 'workQty', title: '作业数量', minWidth: 100, width: 100},
// {field: 'unit', title: '单位', width: 80},
{field: 'memo', title: '备注', edit: true},
{
align: 'center',
title: '操作',
toolbar: '#formSSXMTableBar',
minWidth: 80,
width: 80,
fixed: 'right'
}
]],
done: function (res) {
$(layero).find('.layui-table-view').css('margin', '0');
},
size: ''
};
if (!isExpAdd) {
$.ajax({
url: baseUrl + "/order/detl/all/auth?orderId=" + expTpe.id,
headers: {'token': localStorage.getItem('token')},
method: 'GET',
async: false,
success: function (res) {
if (res.code === 200) {
xxDataList = res.data;
tbOptions.data = xxDataList;
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2})
}
}
})
}
var insTbSSXM = table.render(tbOptions);
// 工具条点击事件
table.on('tool(formSSXMTable)', function (obj) {
var data = obj.data;
var layEvent = obj.event;
if (layEvent === 'edit') {
showEditModel2(data);
} else if (layEvent === 'del') {
if (data.workQty > 0) {
layer.msg("已存在作业数量,不能删除", {icon: 2});
return;
}
layer.confirm('确定要删除吗?', {
shade: .1,
skin: 'layui-layer-admin'
}, function (i) {
layer.close(i);
for (var j = 0; j < xxDataList.length; j++) {
if (xxDataList[j].matnr === data.matnr && xxDataList[j].batch === data.batch) {
xxDataList.splice(j, 1);
break;
}
}
insTbSSXM.reload({data: xxDataList, page: {curr: 1}});
});
}
});
// 明细数据修改
table.on('edit(formSSXMTable)', function (obj) {
let index = obj.tr.attr("data-index");
let data = xxDataList[index];
if (obj.field === 'anfme') {
let vle = Number(obj.value);
if (isNaN(vle)) {
layer.msg("请输入数字", {icon: 2});
return false;
} else {
if (vle <= 0) {
layer.msg("数量必须大于零", {icon: 2});
// data[obj.field] = 0;
// insTbSSXM.reload({data: xxDataList});
return false;
}
if (obj.value < data.workQty) {
layer.msg("输入数量不能小于作业中数量", {icon: 2});
// data[obj.field] = 0;
// insTbSSXM.reload({data: xxDataList});
return false;
}
}
}
data[obj.field] = obj.value;
insTbSSXM.reload({data: xxDataList});
});
$('#matAddBtnComment').click(function () {
showEditModel2();
});
// 导入Excel按钮点击
$('#importExcelBtn').on('click', function () {
admin.open({
type: 1,
title: '导入明细Excel',
area: '500px',
content: $('#importExcelDialog').html(),
success: function (layero, dIndex) {
// 下载模板
$('#downloadExcelTemplate').on('click', function () {
var data = [
['物料编码', '客户PO', '条码UPC', '客户SKU', '采购单号', '出库数量'],
['', '', '', '', '', 0] // 示例行
];
var ws = XLSX.utils.aoa_to_sheet(data);
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "明细");
XLSX.writeFile(wb, "出库明细导入模板.xlsx");
});
// 开始导入
$('#doImportExcel').on('click', function () {
var fileInput = $('#excelFileInput')[0];
if (!fileInput.files || !fileInput.files[0]) {
layer.msg('请先选择Excel文件', {icon: 2});
return;
}
var file = fileInput.files[0];
var reader = new FileReader();
reader.onload = function (e) {
try {
var data = new Uint8Array(e.target.result);
var workbook = XLSX.read(data, {type: 'array'});
var firstSheet = workbook.Sheets[workbook.SheetNames[0]];
var jsonData = XLSX.utils.sheet_to_json(firstSheet, {
header: ['matnr', 'standby1', 'standby2', 'standby3', 'boxType3', 'anfme'],
range: 1
}); // 从第2行开始
if (jsonData.length === 0) {
layer.msg('Excel中没有数据', {icon: 2});
return;
}
var successCount = 0;
var errorMsgs = [];
jsonData.forEach(function (row, idx) {
if (!row.matnr) {
errorMsgs.push('第' + (idx + 2) + '行:物料编码不能为空');
return;
}
var anfme = Number(row.anfme);
if (isNaN(anfme) || anfme <= 0) {
errorMsgs.push('第' + (idx + 2) + '行:数量必须为大于0的数字');
return;
}
// 通过物料编码查询完整物料信息(与原有添加方式一致)
$.ajax({
url: baseUrl + "/mat/covert/" + row.matnr + "/auth",
headers: {'token': localStorage.getItem('token')},
method: 'GET',
async: false,
success: function (res) {
if (res.code === 200) {
var item = res.data;
// 覆盖导入的字段
item.standby1 = row.standby1 || item.standby1 || '';
item.standby2 = row.standby2 || item.standby2 || '';
item.standby3 = row.standby3 || item.standby3 || '';
item.boxType3 = row.boxType3 || item.boxType3 || '';
item.anfme = anfme;
item.workQty = item.workQty || 0;
if (anfme < item.workQty) {
errorMsgs.push('第' + (idx + 2) + '行:数量不能小于已作业数量(' + item.workQty + ')');
return;
}
xxDataList.push(item);
successCount++;
} else {
errorMsgs.push('第' + (idx + 2) + '行:物料编码 ' + row.matnr + ' 查询失败 - ' + res.msg);
}
},
error: function () {
errorMsgs.push('第' + (idx + 2) + '行:物料编码 ' + row.matnr + ' 查询失败');
}
});
});
insTbSSXM.reload({data: xxDataList});
if (errorMsgs.length > 0) {
layer.msg('导入完成,成功' + successCount + '条,失败信息:
' + errorMsgs.slice(0, 10).join('
') + (errorMsgs.length > 10 ? '
...等' : ''), {
icon: 2,
time: 8000
});
} else {
layer.msg('成功导入 ' + successCount + ' 条明细', {icon: 1});
}
layer.close(dIndex);
} catch (err) {
layer.msg('解析Excel失败:' + err.message, {icon: 2});
}
};
reader.readAsArrayBuffer(file);
});
}
});
});
// 显示添加明细表单弹窗
function showEditModel2(exp) {
admin.open({
type: 1,
offset: '150px',
area: '680px',
title: (exp ? '修改' : '添加') + '明细',
content: $('#matEditDialog').html(),
success: function (layero, dIndex) {
// 回显数据
form.val('matEditForm', exp);
// 表单提交事件
form.on('submit(matEditSubmit)', function (data) {
let selectList = matXmSelect.getValue();
for (let i = 0; i < selectList.length; i++) {
let item = selectList[i];
// 查询物料详情
$.ajax({
url: baseUrl + "/mat/covert/" + item.value + "/auth",
headers: {'token': localStorage.getItem('token')},
method: 'GET',
async: false,
success: function (res) {
if (res.code === 200) {
xxDataList.push(res.data);
insTbSSXM.reload({data: xxDataList, page: {curr: 1}});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2})
}
}
})
}
layer.close(dIndex);
return false;
});
// 渲染物料选择
var matXmSelect = xmSelect.render({
el: '#mat',
style: {
width: '340px',
},
autoRow: true,
toolbar: {show: true},
filterable: true,
remoteSearch: true,
remoteMethod: function (val, cb, show) {
$.ajax({
url: baseUrl + "/mat/all/get/kv",
headers: {'token': localStorage.getItem('token')},
data: {
condition: val
},
method: 'POST',
success: function (res) {
if (res.code === 200) {
cb(res.data)
} else {
cb([]);
layer.msg(res.msg, {icon: 2});
}
}
});
}
})
// 弹窗不出现滚动条
$(layero).children('.layui-layer-content').css('overflow', 'visible');
layui.form.render('select');
}
});
}
}
});
}
// 删除单据
function doDel(orderId) {
layer.confirm('确定要删除吗?', {
shade: .1,
skin: 'layui-layer-admin'
}, function (i) {
layer.close(i);
layer.load(2);
$.ajax({
url: baseUrl + "/order/delete/auth",
headers: {'token': localStorage.getItem('token')},
data: {
orderId: orderId
},
method: 'POST',
success: function (res) {
layer.closeAll('loading');
if (res.code === 200) {
if (insTbCount === 0) {
insTb.reload({page: {curr: 1}});
} else {
$(".layui-laypage-btn")[0].click();
}
layer.msg(res.msg, {icon: 1});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2});
}
}
})
});
}
// 修改订单状态
function doModify(orderId, orderNo, settle) {
layer.confirm('确定要彻底结束单据吗?(将转为历史档案)', {
shade: .1,
skin: 'layui-layer-admin'
}, function (i) {
layer.close(i);
layer.load(2);
console.log(orderId);
console.log(settle);
$.ajax({
url: baseUrl + "/order/update/auth",
headers: {'token': localStorage.getItem('token')},
data: {
id: orderId,
orderNo: orderNo,
settle: settle
},
method: 'POST',
success: function (res) {
layer.closeAll('loading');
if (res.code === 200) {
if (insTbCount === 0) {
insTb.reload({page: {curr: 1}});
} else {
$(".layui-laypage-btn")[0].click();
}
layer.msg(res.msg, {icon: 1});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2});
}
}
})
});
}
// 修改订单状态
function doModify99(orderId, orderNo, settle) {
layer.confirm('确定要继续执行吗?(会将未执行数量重新生成执行单据)', {
shade: .1,
skin: 'layui-layer-admin'
}, function (i) {
layer.close(i);
layer.load(2);
console.log(orderId);
console.log(settle);
$.ajax({
url: baseUrl + "/order/update/auth",
headers: {'token': localStorage.getItem('token')},
data: {
id: orderId,
orderNo: orderNo,
settle: settle
},
method: 'POST',
success: function (res) {
layer.closeAll('loading');
if (res.code === 200) {
if (insTbCount === 0) {
insTb.reload({page: {curr: 1}});
} else {
$(".layui-laypage-btn")[0].click();
}
layer.msg(res.msg, {icon: 1});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2});
}
}
})
});
}
// 任务追溯
function showWrkTrace(orderId) {
let loadIndex = layer.msg('请求中...', {icon: 16, shade: 0.01, time: false});
$.ajax({
url: baseUrl + "/order/wrk/trace/auth",
headers: {'token': localStorage.getItem('token')},
data: {
orderId: orderId
},
method: 'POST',
success: function (res) {
layer.close(loadIndex);
if (res.code === 200) {
laytpl(wrkTraceDialog.innerHTML).render(res.data, function (html) {
admin.open({
type: 1,
title: '任务追溯',
area: ['800px', '450px'],
shadeClose: true,
content: html,
success: function (layero, dIndex) {
$(layero).children('.layui-layer-content').css('overflow', 'visible');
/** 统计图表 */
var traceCharts = echarts.init(document.getElementById('wrkTraceCharts'));
var traceOptions = {
title: {
text: '总量/待上报/已上报', x: 'center', y: '38%',
textStyle: {fontSize: 18, color: '#262626', fontWeight: 'normal'},
subtextStyle: {fontSize: 36, color: '#10B4E8'},
itemGap: 20
},
color: ['#10B4E8', '#E0E0E0', '#FF0000'],
tooltip: {trigger: 'item'},
series: [{
name: '数量',
type: 'pie',
radius: ['75%', '80%'],
label: {normal: {show: false}}
}]
};
traceCharts.setOption(traceOptions);
// 赋值
traceCharts.setOption({
title: {
subtext: res.data.totalQty + "/" + res.data.endQty + "/" + res.data.wrkQty
},
series: [
{
data: [
{name: '已作业', value: res.data.wrkQty + res.data.endQty},
{
name: '未作业',
value: res.data.totalQty - res.data.wrkQty - res.data.endQty - res.data.lackQty
},
{name: '库存不足', value: res.data.lackQty},
]
}
]
});
}
});
});
} else if (res.code === 403) {
top.location.href = baseUrl + "/";
} else {
layer.msg(res.msg, {icon: 2});
}
}
})
}
layDate.render({
elem: '.layui-laydate-range'
, type: 'datetime'
, range: true
});
});