#订单导入

lty

2 天以前 2998faf8dceff0189854742d78455762fffb95e3

 src/main/webapp/static/js/order/order.js

@@ -14,19 +14,19 @@

    // 渲染搜索模板
    $.ajax({
        url: baseUrl+"/docType/list/auth",
        url: baseUrl + "/docType/list/auth",
        headers: {'token': localStorage.getItem('token')},
        data: {
            limit: 9999
        },
        method: 'POST',
        success: function (res) {
            if (res.code === 200){
            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 if (res.code === 403) {
                top.location.href = baseUrl + "/";
            } else {
                layer.msg(res.msg, {icon: 2})
            }
@@ -36,7 +36,7 @@
    // 渲染表格
    var insTb = table.render({
        elem: '#order',
        url: baseUrl+'/order/head/page/auth',
        url: baseUrl + '/order/head/page/auth',
        headers: {token: localStorage.getItem('token')},
        page: true,
        cellMinWidth: 100,
@@ -44,12 +44,12 @@
            {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},
            {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},
            {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: {
@@ -70,7 +70,7 @@
        done: function (res, curr, count) {
            limit();
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
                top.location.href = baseUrl + "/";
            }
            insTbCount = count;
        }
@@ -118,7 +118,7 @@
                    table.render({
                        elem: '#lookSSXMTable',
                        headers: {token: localStorage.getItem('token')},
                        url: baseUrl+'/orderDetl/list/auth',
                        url: baseUrl + '/orderDetl/list/auth',
                        where: {
                            order_id: data.id
                        },
@@ -186,18 +186,18 @@
                    }
                    let nList = admin.util.deepClone(xxDataList);
                    for (let xi = 0; xi < nList.length; xi++) {
                        if (nList[xi].anfme <= 0){
                        if (nList[xi].anfme <= 0) {
                            layer.msg('明细修改数量不合法', {icon: 2});
                            return false;
                        }
                        if (nList[xi].anfme < nList[xi].workQty){
                        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",
                        url: baseUrl + "/order/form/" + (isExpAdd ? "add" : "modify") + "/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: JSON.stringify({
                            orderId: Number(data.field.id),
@@ -207,17 +207,17 @@
                            ownerId: Number(data.field.owner),
                            orderDetlList: nList
                        }),
                        contentType:'application/json;charset=UTF-8',
                        contentType: 'application/json;charset=UTF-8',
                        method: 'POST',
                        success: function (res) {
                            layer.closeAll('loading');
                            if (res.code === 200){
                            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 {
                            } else if (res.code === 403) {
                                top.location.href = baseUrl + "/";
                            } else {
                                layer.msg(res.msg, {icon: 2});
                            }
                        }
@@ -239,17 +239,31 @@
                        {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: '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'}
                        {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');
@@ -258,17 +272,17 @@
                };
                if (!isExpAdd) {
                    $.ajax({
                        url: baseUrl+"/order/detl/all/auth?orderId=" + expTpe.id,
                        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){
                            if (res.code === 200) {
                                xxDataList = res.data;
                                tbOptions.data = xxDataList;
                            } else if (res.code === 403){
                                top.location.href = baseUrl+"/";
                            }else {
                            } else if (res.code === 403) {
                                top.location.href = baseUrl + "/";
                            } else {
                                layer.msg(res.msg, {icon: 2})
                            }
                        }
@@ -282,7 +296,7 @@
                    if (layEvent === 'edit') {
                        showEditModel2(data);
                    } else if (layEvent === 'del') {
                        if(data.workQty > 0){
                        if (data.workQty > 0) {
                            layer.msg("已存在作业数量，不能删除", {icon: 2});
                            return;
                        }
@@ -305,7 +319,7 @@
                table.on('edit(formSSXMTable)', function (obj) {
                    let index = obj.tr.attr("data-index");
                    let data = xxDataList[index];
                    if (obj.field === 'anfme'){
                    if (obj.field === 'anfme') {
                        let vle = Number(obj.value);
                        if (isNaN(vle)) {
                            layer.msg("请输入数字", {icon: 2});
@@ -317,7 +331,7 @@
                                // insTbSSXM.reload({data: xxDataList});
                                return false;
                            }
                            if(obj.value < data.workQty){
                            if (obj.value < data.workQty) {
                                layer.msg("输入数量不能小于作业中数量", {icon: 2});
                                // data[obj.field] = 0;
                                // insTbSSXM.reload({data: xxDataList});
@@ -331,6 +345,119 @@

                $('#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 + '条，失败信息：<br>' + errorMsgs.slice(0, 10).join('<br>') + (errorMsgs.length > 10 ? '<br>...等' : ''), {
                                                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);
                            });
                        }
                    });
                });

                // 显示添加明细表单弹窗
@@ -347,21 +474,21 @@
                            // 表单提交事件
                            form.on('submit(matEditSubmit)', function (data) {
                                let selectList = matXmSelect.getValue();
                                for (let i = 0; i<selectList.length; i++) {
                                for (let i = 0; i < selectList.length; i++) {
                                    let item = selectList[i];
                                    // 查询物料详情
                                    $.ajax({
                                        url: baseUrl+"/mat/covert/"+item.value+"/auth",
                                        url: baseUrl + "/mat/covert/" + item.value + "/auth",
                                        headers: {'token': localStorage.getItem('token')},
                                        method: 'GET',
                                        async: false,
                                        success: function (res) {
                                            if (res.code === 200){
                                            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 {
                                            } else if (res.code === 403) {
                                                top.location.href = baseUrl + "/";
                                            } else {
                                                layer.msg(res.msg, {icon: 2})
                                            }
                                        }
@@ -377,19 +504,19 @@
                                    width: '340px',
                                },
                                autoRow: true,
                                toolbar: { show: true },
                                toolbar: {show: true},
                                filterable: true,
                                remoteSearch: true,
                                remoteMethod: function(val, cb, show){
                                remoteMethod: function (val, cb, show) {
                                    $.ajax({
                                        url: baseUrl+"/mat/all/get/kv",
                                        url: baseUrl + "/mat/all/get/kv",
                                        headers: {'token': localStorage.getItem('token')},
                                        data: {
                                            condition: val
                                        },
                                        method: 'POST',
                                        success: function (res) {
                                            if (res.code === 200){
                                            if (res.code === 200) {
                                                cb(res.data)
                                            } else {
                                                cb([]);
@@ -419,7 +546,7 @@
            layer.close(i);
            layer.load(2);
            $.ajax({
                url: baseUrl+"/order/delete/auth",
                url: baseUrl + "/order/delete/auth",
                headers: {'token': localStorage.getItem('token')},
                data: {
                    orderId: orderId
@@ -427,16 +554,16 @@
                method: 'POST',
                success: function (res) {
                    layer.closeAll('loading');
                    if (res.code === 200){
                    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 {
                    } else if (res.code === 403) {
                        top.location.href = baseUrl + "/";
                    } else {
                        layer.msg(res.msg, {icon: 2});
                    }
                }
@@ -455,7 +582,7 @@
            console.log(orderId);
            console.log(settle);
            $.ajax({
                url: baseUrl+"/order/update/auth",
                url: baseUrl + "/order/update/auth",
                headers: {'token': localStorage.getItem('token')},
                data: {
                    id: orderId,
@@ -465,16 +592,16 @@
                method: 'POST',
                success: function (res) {
                    layer.closeAll('loading');
                    if (res.code === 200){
                    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 {
                    } else if (res.code === 403) {
                        top.location.href = baseUrl + "/";
                    } else {
                        layer.msg(res.msg, {icon: 2});
                    }
                }
@@ -493,7 +620,7 @@
            console.log(orderId);
            console.log(settle);
            $.ajax({
                url: baseUrl+"/order/update/auth",
                url: baseUrl + "/order/update/auth",
                headers: {'token': localStorage.getItem('token')},
                data: {
                    id: orderId,
@@ -503,16 +630,16 @@
                method: 'POST',
                success: function (res) {
                    layer.closeAll('loading');
                    if (res.code === 200){
                    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 {
                    } else if (res.code === 403) {
                        top.location.href = baseUrl + "/";
                    } else {
                        layer.msg(res.msg, {icon: 2});
                    }
                }
@@ -524,7 +651,7 @@
    function showWrkTrace(orderId) {
        let loadIndex = layer.msg('请求中...', {icon: 16, shade: 0.01, time: false});
        $.ajax({
            url: baseUrl+"/order/wrk/trace/auth",
            url: baseUrl + "/order/wrk/trace/auth",
            headers: {'token': localStorage.getItem('token')},
            data: {
                orderId: orderId
@@ -532,7 +659,7 @@
            method: 'POST',
            success: function (res) {
                layer.close(loadIndex);
                if (res.code === 200){
                if (res.code === 200) {
                    laytpl(wrkTraceDialog.innerHTML).render(res.data, function (html) {
                        admin.open({
                            type: 1,
@@ -553,19 +680,27 @@
                                    },
                                    color: ['#10B4E8', '#E0E0E0', '#FF0000'],
                                    tooltip: {trigger: 'item'},
                                    series: [{name: '数量', type: 'pie', radius: ['75%', '80%'], label: {normal: {show: false}}}]
                                    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
                                        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.wrkQty + res.data.endQty},
                                                {
                                                    name: '未作业',
                                                    value: res.data.totalQty - res.data.wrkQty - res.data.endQty - res.data.lackQty
                                                },
                                                {name: '库存不足', value: res.data.lackQty},
                                            ]
                                        }
@@ -574,9 +709,9 @@
                            }
                        });
                    });
                } else if (res.code === 403){
                    top.location.href = baseUrl+"/";
                }else {
                } else if (res.code === 403) {
                    top.location.href = baseUrl + "/";
                } else {
                    layer.msg(res.msg, {icon: 2});
                }
            }
@@ -585,7 +720,7 @@

    layDate.render({
        elem: '.layui-laydate-range'
        ,type: 'datetime'
        ,range: true
        , type: 'datetime'
        , range: true
    });
});