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 }); });