☰

MEST QRCode

美尔斯通二维码

目前為 2022-10-28 提交的版本，檢視 最新版本。

// ==UserScript==
// @name         MEST QRCode
// @namespace    joyings.com.cn
// @version      1.5.8
// @description  美尔斯通二维码
// @author       zmz125000
// @match       http://*/mest/*
// @icon          http://www.google.com/s2/favicons?domain=openwrt.org
// @grant        none
// @require      https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.1/jquery.min.js
// @require      https://cdnjs.cloudflare.com/ajax/libs/qrcodejs/1.0.0/qrcode.js
// @license     MIT
// ==/UserScript==

(function () {
    'use strict';

    // Your code here...
    addPrintButtons();
    window.fastPrint = true;

    function sleep(ms) {
        return new Promise(resolve => setTimeout(resolve, ms));
    }

    function unsecuredCopyToClipboard(text) {
        const textArea = document.createElement("textarea");
        textArea.value = text;
        document.body.appendChild(textArea);
        textArea.focus();
        textArea.select();
        try {
            document.execCommand('copy');
        } catch (err) {
            console.error('Unable to copy to clipboard', err);
        }
        document.body.removeChild(textArea);
    }

    // 添加按钮、快速复制文本

    async function addPrintButtons() {
        if (!$('div[class="el-tabs__item is-top is-active is-closable"]:contains("自定义报表")')[0] || !$('input[placeholder="输入关键字进行过滤"]')[0]) {
            await sleep(500);
            addPrintButtons();
            return;
        }
        if ($('[role="group"]')[0]) {
            for (let elm of $('[class="custom-tree-node"]', $('[role="group"]')[0])) {
                if (!elm.hasAttribute('helper')) {
                    elm.addEventListener('click', async function () {
                        await sleep(100);
                        // 设为100条
                        while (!$('[class="el-scrollbar__view el-select-dropdown__list"]')[0]) {
                            await sleep(50);
                        }
                        $('li', $('[class="el-scrollbar__view el-select-dropdown__list"]')).last().click()
                        await sleep(100);
                        while ($('[class="el-loading-mask"]')[0] && $('[class="el-loading-mask"]')[0].getAttribute("style") == 'display: none;') {
                            await sleep(100);
                        }
                        while (!$('tbody')[0]) {
                            await sleep(100);
                        }
                        // 自动复制
                        if (!$('tbody')[0].hasAttribute('helper')) {
                            $('tbody')[0].addEventListener('click', function (e) {
                                const cell = e.target.closest('td');
                                if (cell) {
                                    let headerText = $('[class="has-gutter"]')[0].rows.item(0).cells.item(cell.cellIndex).firstChild.textContent;
                                    let sval = cell.childNodes[0].innerText;
                                    unsecuredCopyToClipboard(sval);
                                    setInput(headerText, sval);
                                }
                            });
                            $('tbody')[0].setAttribute('helper', true);
                        }
                        elm.setAttribute('helper', true);
                    })
                }
            }
        }

        if (!$('button:contains("打印")')[0]) {
            let btnRow = $('button:contains("导出")')[0].parentElement;
            var btn = document.createElement('button');
            btn.setAttribute('id', 'printMaterialBtn');
            btn.setAttribute('type', 'button');
            btn.onclick = generateMaterial;
            btn.appendChild(document.createTextNode('打印排料单'));

            var btn2 = document.createElement('button');
            btn2.setAttribute('id', 'printTableBtn');
            btn2.setAttribute('title', '同种物料合并计数');
            btn2.setAttribute('type', 'button');
            btn2.onclick = generateSumTable;
            btn2.appendChild(document.createTextNode('打印备料单'));

            var btn3 = document.createElement('button');
            btn3.setAttribute('type', 'button');
            btn3.onclick = generateAndPrint;
            btn3.appendChild(document.createTextNode('打印生产单'));

            var btn8 = document.createElement('button');
            btn8.setAttribute('title', '快速打印');
            btn8.setAttribute('id', 'fastPrintBtn');
            btn8.setAttribute('type', 'button');
            btn8.onclick = toggleFastPrint;
            btn8.appendChild(document.createTextNode(window.fastPrint ? "✔" : "✘"));

            btnRow.appendChild(btn);
            btnRow.appendChild(btn3);
            btnRow.appendChild(btn2);
            btnRow.appendChild(btn8);
        }
        if (!$('button:contains("重置")')[0].hasAttribute('helper')) {
            $('button:contains("重置")')[0].addEventListener('click', async function (e) {
                if ($('[class="el-tree-node is-expanded is-current is-focusable"]')[0]) {
                    $('[class="el-tree-node is-expanded is-current is-focusable"]')[0].click();
                }
                await sleep(100);
                while (!$('tbody')[0]) {
                    await sleep(100);
                }
                // 自动复制
                if (!$('tbody')[0].hasAttribute('helper')) {
                    $('tbody')[0].addEventListener('click', function (e) {
                        const cell = e.target.closest('td');
                        if (cell) {
                            let headerText = $('[class="has-gutter"]')[0].rows.item(0).cells.item(cell.cellIndex).firstChild.textContent;
                            let sval = cell.childNodes[0].innerText;
                            unsecuredCopyToClipboard(sval);
                            setInput(headerText, sval);
                        }
                    });
                    $('tbody')[0].setAttribute('helper', true);
                }
            })
            $('button:contains("重置")')[0].setAttribute('helper', true);
        }
        await sleep(500);
        addPrintButtons();
    }

    function setInput(label, value) {
        if ($('label:contains(' + label + ')')[0]) {
            $('input', $('label:contains(' + label + ')')[0].nextSibling)[0].value = value;
            $('input', $('label:contains(' + label + ')')[0].nextSibling)[0].dispatchEvent(new Event('input', {
                bubbles: true
            }));
        }
    }

    function toggleFastPrint() {
        if (window.fastPrint) {
            window.fastPrint = false;
            document.getElementById("fastPrintBtn").firstChild.nodeValue = "✘";
        } else {
            window.fastPrint = true;
            document.getElementById("fastPrintBtn").firstChild.nodeValue = "✔";
        }
    }

    async function getFullTable(index) {
        var tbody = document.createElement('table');
        let nextBodyRows = $('tr', $('tbody')[0]);
        for (let tr of nextBodyRows) {
            tbody.appendChild(tr.cloneNode(true));
        }
        // 主键所在列
        let i = index;
        if (!index) {
            i = 2
        }
        var oldValue = $('div', $('tbody')[0].rows.item(0).cells.item(i))[0].textContent;
        while (!$('[class="btn-next"]')[0].getAttribute("disabled")) {
            $('[class="btn-next"]')[0].click();
            await sleep(100);
            while ($('div', $('tbody')[0].rows.item(0).cells.item(i))[0].textContent == oldValue) {
                await sleep(100);
            }
            let nextBodyRows = $('tr', $('tbody')[0]);
            for (let tr of nextBodyRows) {
                tbody.appendChild(tr.cloneNode(true));
            }
            oldValue = $('div', $('tbody')[0].rows.item(0).cells.item(i))[0].textContent;
        }
        return tbody;
    }

    // 打印备料单
    async function generateSumTable() {
        if (!$('input', $('label:contains("订单号")')[0].nextSibling)[0].value) {
            alert("未输入订单号/生产单号/产品编号/产品名，请先设置至少一项筛选条件");
            return;
        }
        const orderNoIndex = $('th:contains("订单号")')[0].cellIndex;
        const customerIndex = $('th:contains("客户名")')[0].cellIndex;
        const billDateIndex = $('th:contains("单据日期")')[0].cellIndex;
        const billDeliveryIndex = $('th:contains("发货日期")')[0].cellIndex;
        // 物料
        const materialCodeIndex = $('th:contains("物料编码")')[0].cellIndex;
        const materialNameIndex = $('th:contains("物料名")')[0].cellIndex;
        const materialAliasIndex = $('th:contains("物料别名")')[0].cellIndex;
        const materialSpecsIndex = $('th:contains("物料规格")')[0].cellIndex;
        const materialQIndex = $('th:contains("领料数")')[0].cellIndex;
        const materialUnitIndex = $('th:contains("计量单位")')[0].cellIndex;
        const processIndex = $('th:contains("用途")')[0].cellIndex;

        var tbody = null;
        await getFullTable(materialCodeIndex).then(t => {
            tbody = t;
        })

        var bodyRows = tbody.rows;
        let w = null;
        let iframe = null;
        if (window.fastPrint) {
            iframe = document.createElement('iframe');
            document.body.appendChild(iframe);
            iframe.contentWindow.document.open();
            iframe.contentWindow.document.write(sumMaterialTemplate);
            w = iframe.contentWindow;
        } else {
            w = window.open();
            w.document.write(sumMaterialTemplate);
        }
        let map = new Map();
        let trCells = tbody.rows.item(0).cells;
        map.set('orderNo', trCells.item(orderNoIndex));
        map.set('orderDate', trCells.item(billDateIndex));
        map.set('deliveryDate', trCells.item(billDeliveryIndex));
        map.set('OCellA', trCells.item(orderNoIndex));
        map.set('OCellB', trCells.item(orderNoIndex));

        for (let item of map) {
            if ($('#' + item[0], w.document)[0]) {
                $('#' + item[0], w.document)[0].textContent = $('div', item[1])[0].textContent;
            }
        }
        // 填信息
        var today = new Date();
        var date = today.getFullYear() + '-' + (today.getMonth() + 1) + '-' + today.getDate();
        var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();
        $('#printTime', w.document)[0].textContent = date + ' ' + time;
        new QRCode($('#SCDQR', w.document)[0], {
            text: trCells.item(orderNoIndex),
            width: 144,
            height: 144
        });

        var materialTable = $('#materialTable', w.document)[0];
        // 工艺表指针
        var wIndex = 1;
        // 物料表指针
        var mIndex = 1;
        // 表体序号
        var tIndex = 1;
        let name = '';
        let lastName = '';
        let cell0 = null;
        let lastRow = null;
        for (let row of bodyRows) {
            let materialCode = $('div', row.cells.item(materialCodeIndex))[0].textContent;
            let process = $('div', row.cells.item(processIndex))[0].textContent;
            if (process != '包装') {
                name = $('div', row.cells.item(materialNameIndex))[0].textContent;
                const cells = row.cells;
                let tr = materialTable.insertRow(wIndex++);

                let i = 0;
                tr.insertCell(i++).innerHTML = tIndex++;
                tr.insertCell(i++).innerHTML = cells.item(materialCodeIndex).textContent;
                if (tr.rowIndex == 1) {
                    cell0 = tr.insertCell(i++);
                    cell0.innerHTML = name;
                } else
                if (name == lastName) {
                    cell0.setAttribute('rowspan', ++mIndex);
                    lastRow.setAttribute('class', 'avoidBreak');
                } else {
                    mIndex = 1;
                    cell0 = tr.insertCell(i++);
                    cell0.innerHTML = name;
                }
                tr.insertCell(i++).innerHTML = cells.item(materialAliasIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(materialSpecsIndex).textContent;
                if (materialCode.startsWith('00-') || materialCode.startsWith('01-012')) {
                    tr.insertCell(i++).innerHTML = '外购';
                } else {
                    tr.insertCell(i++).innerHTML = '';
                }
                tr.insertCell(i++).innerHTML = cells.item(materialQIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(materialUnitIndex).textContent;
                lastName = name;
                lastRow = tr;
            }

        }

        await sleep(100);
        if (window.fastPrint) {
            w.print();
            w.close();
            document.body.removeChild(iframe);
        }
    }


    // 打印排料单
    async function generateMaterial() {
        if (!$('input', $('label:contains("订单号")')[0].nextSibling)[0].value && !$('input', $('label:contains("生产单号")')[0].nextSibling)[0].value && !$('input', $('label:contains("产品编码")')[0].nextSibling)[0].value && !$('input', $('label:contains("产品名")')[0].nextSibling)[0].value) {
            alert("未输入订单号/生产单号/产品编号/产品名，请先设置至少一项筛选条件");
            return;
        }
        const orderNoIndex = $('th:contains("订单号")')[0].cellIndex;
        const customerIndex = $('th:contains("客户名")')[0].cellIndex;
        const billDateIndex = $('th:contains("单据日期")')[0].cellIndex;
        const billDeliveryIndex = $('th:contains("发货日期")')[0].cellIndex;
        const productCodeIndex = $('th:contains("产品编码")')[0].cellIndex;
        const productNameIndex = $('th:contains("产品名")')[0].cellIndex;
        const productAliasIndex = $('th:contains("产品别名")')[0].cellIndex;
        const productSpecsIndex = $('th:contains("产品规格")')[0].cellIndex;
        const scdIndex = $('th:contains("生产单号")')[0].cellIndex;
        const orderQuantityIndex = $('th:contains("下单数")')[0].cellIndex;
        const processIndex = $('th:contains("工序名")')[0].cellIndex;
        const semiIndex = $('th:contains("工件名")')[0].cellIndex;
        const plannedQuantityIndex = $('th:contains("加工数")')[0].cellIndex;
        const productPlannedQuantityIndex = $('th:contains("生产数")')[0].cellIndex;
        const workshopIndex = $('th:contains("车间")')[0].cellIndex;
        const keyIndex = $('th:contains("主键")')[0].cellIndex;
        // 物料
        const materialCodeIndex = $('th:contains("物料编码")')[0].cellIndex;
        const materialNameIndex = $('th:contains("物料名")')[0].cellIndex;
        const materialAliasIndex = $('th:contains("物料别名")')[0].cellIndex;
        const materialSpecsIndex = $('th:contains("物料规格")')[0].cellIndex;
        const semiSpecsIndex = $('th:contains("工件尺寸")')[0].cellIndex;
        const materialQIndex = $('th:contains("领料数")')[0].cellIndex;
        const materialUnitIndex = $('th:contains("计量单位")')[0].cellIndex;

        var tbody = null;
        await getFullTable().then(t => {
            tbody = t;
        })

        var bodyRows = tbody.rows;
        let w = null;
        let iframe = null;
        if (window.fastPrint) {
            iframe = document.createElement('iframe');
            document.body.appendChild(iframe);
            iframe.contentWindow.document.open();
            iframe.contentWindow.document.write(materialTemplate);
            w = iframe.contentWindow;
        } else {
            w = window.open();
            w.document.write(materialTemplate);
        }
        let map = new Map();
        let trCells = tbody.rows.item(0).cells;
        map.set('orderNo', trCells.item(orderNoIndex));
        map.set('SCD', trCells.item(scdIndex));
        map.set('SCDCell', trCells.item(scdIndex));
        map.set('orderQuantity', trCells.item(orderQuantityIndex));
        map.set('plannedQuantity', trCells.item(productPlannedQuantityIndex));
        map.set('orderDate', trCells.item(billDateIndex));
        map.set('deliveryDate', trCells.item(billDeliveryIndex));
        map.set('OCellA', trCells.item(orderNoIndex));
        map.set('OCellB', trCells.item(orderNoIndex));

        for (let item of map) {
            if ($('#' + item[0], w.document)[0]) {
                $('#' + item[0], w.document)[0].textContent = $('div', item[1])[0].textContent;
            }
        }
        // 填信息
        var today = new Date();
        var date = today.getFullYear() + '-' + (today.getMonth() + 1) + '-' + today.getDate();
        var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();
        $('#printTime', w.document)[0].textContent = date + ' ' + time;
        new QRCode($('#SCDQR', w.document)[0], {
            text: trCells.item(orderNoIndex),
            width: 144,
            height: 144
        });

        var materialTable = $('#materialTable', w.document)[0];
        // 工艺表指针
        var wIndex = 1;
        // 物料表指针
        var mIndex = 1;
        let lastCode = '';
        let cell0 = null;
        let cell1 = null;
        let cell2 = null;
        let lastRow = null;
        for (let row of bodyRows) {
            let materialCode = $('div', row.cells.item(materialCodeIndex))[0].textContent;
            let process = $('div', row.cells.item(processIndex))[0].textContent;
            if (materialCode && process != '包装') {
                const semi = $('div', row.cells.item(semiIndex))[0].textContent;
                const code = $('div', row.cells.item(productCodeIndex))[0].textContent;
                const cells = row.cells;
                let tr = materialTable.insertRow(wIndex++);
                if (tr.rowIndex == 1) {
                    cell0 = tr.insertCell(0);
                    cell1 = tr.insertCell(1);
                    cell2 = tr.insertCell(2);
                    cell0.innerHTML = cells.item(productNameIndex).textContent;
                    cell1.innerHTML = cells.item(productPlannedQuantityIndex).textContent;
                    cell1.className = "numCell";
                    cell2.innerHTML = cells.item(orderQuantityIndex).textContent;
                    cell2.className = "numCell";
                } else
                if (code == lastCode) {
                    cell0.setAttribute('rowspan', mIndex);
                    cell1.setAttribute('rowspan', mIndex);
                    cell2.setAttribute('rowspan', mIndex);
                    lastRow.setAttribute('class', 'avoidBreak');
                } else {
                    mIndex = 1;
                    cell0 = tr.insertCell(0);
                    cell1 = tr.insertCell(1);
                    cell2 = tr.insertCell(2);
                    cell0.innerHTML = cells.item(productNameIndex).textContent;
                    cell1.innerHTML = cells.item(productPlannedQuantityIndex).textContent;
                    cell1.className = "numCell";
                    cell2.innerHTML = cells.item(orderQuantityIndex).textContent;
                    cell2.className = "numCell";
                }
                let i = 0;
                if (code != lastCode) {
                    i = 3;
                }
                //tr.insertCell(i++).innerHTML = cells.item(processIndex).textContent;
                tr.insertCell(i++).innerHTML = semi;
                tr.insertCell(i++).innerHTML = mIndex++;
                tr.insertCell(i++).innerHTML = '';
                //tr.insertCell(i++).innerHTML = cells.item(materialCodeIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(materialNameIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(materialSpecsIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(semiSpecsIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(plannedQuantityIndex).textContent;
                if (materialCode.startsWith('00-') || materialCode.startsWith('01-012')) {
                    tr.insertCell(i++).innerHTML = '外购';
                } else {
                    tr.insertCell(i++).innerHTML = '';
                }
                tr.insertCell(i++).innerHTML = cells.item(materialQIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(materialUnitIndex).textContent;
                //tr.insertCell(i++).innerHTML = cells.item(processIndex).textContent;
                tr.insertCell(i++).innerHTML = cells.item(workshopIndex).textContent;
                lastCode = code;
                lastRow = tr;
            }

        }

        await sleep(100);
        if (window.fastPrint) {
            w.print();
            w.close();
            document.body.removeChild(iframe);
        }
    }

    // 打印生产单
    async function generateAndPrint() {
        if (!$('input', $('label:contains("订单号")')[0].nextSibling)[0].value && !$('input', $('label:contains("生产单号")')[0].nextSibling)[0].value && !$('input', $('label:contains("产品编码")')[0].nextSibling)[0].value && !$('input', $('label:contains("产品名")')[0].nextSibling)[0].value) {
            alert("未输入订单号/生产单号/产品编号/产品名，请先设置至少一项筛选条件");
            return;
        }
        const orderNoIndex = $('th:contains("订单号")')[0].cellIndex;
        const customerIndex = $('th:contains("客户名")')[0].cellIndex;
        const billDateIndex = $('th:contains("单据日期")')[0].cellIndex;
        const billDeliveryIndex = $('th:contains("发货日期")')[0].cellIndex;
        const productCodeIndex = $('th:contains("产品编码")')[0].cellIndex;
        const productNameIndex = $('th:contains("产品名")')[0].cellIndex;
        const productAliasIndex = $('th:contains("产品别名")')[0].cellIndex;
        const productSpecsIndex = $('th:contains("产品规格")')[0].cellIndex;
        const scdIndex = $('th:contains("生产单号")')[0].cellIndex;
        const orderQuantityIndex = $('th:contains("下单数")')[0].cellIndex;
        const processIndex = $('th:contains("工序名")')[0].cellIndex;
        const semiIndex = $('th:contains("工件名")')[0].cellIndex;
        const plannedQuantityIndex = $('th:contains("加工数")')[0].cellIndex;
        const productPlannedQuantityIndex = $('th:contains("生产数")')[0].cellIndex;
        const workshopIndex = $('th:contains("车间")')[0].cellIndex;
        const keyIndex = $('th:contains("主键")')[0].cellIndex;
        // 物料
        const materialCodeIndex = $('th:contains("物料编码")')[0].cellIndex;
        const materialNameIndex = $('th:contains("物料名")')[0].cellIndex;
        const materialAliasIndex = $('th:contains("物料别名")')[0].cellIndex;
        const materialSpecsIndex = $('th:contains("物料规格")')[0].cellIndex;
        const semiSpecsIndex = $('th:contains("工件尺寸")')[0].cellIndex;
        const materialQIndex = $('th:contains("领料数")')[0].cellIndex;
        const materialUnitIndex = $('th:contains("计量单位")')[0].cellIndex;


        var tbody = null;
        await getFullTable().then(t => {
            tbody = t;
        })

        var bodyRows = tbody.rows;
        let oldSCD = ''
        let atable = [];
        var currentTable = null;
        // 根据不同生产单生成n个表
        for (let tr of bodyRows) {
            let cSCD = $('div', tr.cells.item(scdIndex))[0].textContent;
            if (cSCD != oldSCD) {
                currentTable = document.createElement('table');
                atable.push(currentTable);
            }
            currentTable.appendChild(tr.cloneNode(true));
            oldSCD = cSCD;
        }

        for (let t of atable) {
            let w = null;
            let iframe = null;
            if (window.fastPrint) {
                iframe = document.createElement('iframe');
                document.body.appendChild(iframe);
                iframe.contentWindow.document.open();
                iframe.contentWindow.document.write(htmlTemplate);
                w = iframe.contentWindow;
            } else {
                w = window.open();
                w.document.write(htmlTemplate);
            }
            let map = new Map();
            let trCells = t.rows.item(0).cells;
            map.set('customerName', trCells.item(customerIndex));
            map.set('orderNo', trCells.item(orderNoIndex));
            map.set('productCode', trCells.item(productCodeIndex));
            map.set('productName', trCells.item(productNameIndex));
            map.set('ProductNameCell', trCells.item(productNameIndex));
            map.set('productAlias', trCells.item(productAliasIndex));
            map.set('productSpecs', trCells.item(productSpecsIndex));
            map.set('SCD', trCells.item(scdIndex));
            map.set('SCDCell', trCells.item(scdIndex));
            map.set('orderQuantity', trCells.item(orderQuantityIndex));
            map.set('plannedQuantity', trCells.item(productPlannedQuantityIndex));
            map.set('orderDate', trCells.item(billDateIndex));
            map.set('deliveryDate', trCells.item(billDeliveryIndex));

            // 填信息
            for (let item of map) {
                $('#' + item[0], w.document)[0].textContent = $('div', item[1])[0].textContent;
            }

            var today = new Date();
            var date = today.getFullYear() + '-' + (today.getMonth() + 1) + '-' + today.getDate();
            var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();
            $('#printTime', w.document)[0].textContent = date + ' ' + time;
            new QRCode($('#SCDQR', w.document)[0], {
                text: $('div', map.get('SCD'))[0].textContent,
                width: 144,
                height: 144
            });

            var tBodyRows = t.rows;
            var processTable = $('#procedureTable', w.document)[0];
            var materialTable = $('#materialTable', w.document)[0];
            // 工艺表指针
            var wIndex = 1;
            // 物料表指针
            var mIndex = 1;
            var contentIndex = 0;
            let outsourcing = '';
            let lastID = '';
            let processCell = null;
            let span = 1;
            let lastRow = null;
            for (let row of tBodyRows) {
                let process = $('div', row.cells.item(processIndex))[0].textContent;
                const semi = $('div', row.cells.item(semiIndex))[0].textContent;
                const plannedQuantity = $('div', row.cells.item(plannedQuantityIndex))[0].textContent;
                const workshop = $('div', row.cells.item(workshopIndex))[0].textContent;
                const key = $('div', row.cells.item(keyIndex))[0].textContent;

                if (process.includes('振光') || process.includes('镀') || process.includes('电解') || process.includes('丝印') || process.includes('打砂') || process.includes('浸塑') || process.includes('震光') || process.includes('氧化着色') || process.includes('喷粉')) {
                    outsourcing = outsourcing ? outsourcing + '/' + process : process;
                }


                let materialCode = $('div', row.cells.item(materialCodeIndex))[0].textContent;
                // 填工序卡表体
                if (key != lastID) {
                    let tr = processTable.insertRow(wIndex);
                    contentIndex = wIndex++ - 1;
                    tr.insertCell(0).innerHTML = contentIndex;
                    let processCell = tr.insertCell(1);
                    processCell.innerHTML = materialCode ? '🅐' + process : process;
                    processCell.setAttribute('class', 'processCell');
                    let semiCell = tr.insertCell(2);
                    semiCell.innerHTML = semi;
                    semiCell.setAttribute('class', 'semiCell');
                    let i = 3
                    tr.insertCell(i++).innerHTML = plannedQuantity;
                    tr.insertCell(i++).innerHTML = plannedQuantity / $('#plannedQuantity', w.document)[0].textContent;
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = '';
                    tr.insertCell(i++).innerHTML = workshop;
                    // let qrCell = tr.insertCell(6);
                    // var qrDiv = document.createElement('div');
                    // new QRCode(qrDiv, {
                    //     text: process,
                    //     width: 64,
                    //     height: 64
                    // });
                    // qrCell.appendChild(qrDiv);
                }

                // 填物料表体
                if (materialCode) {
                    let materialCode = $('div', row.cells.item(materialCodeIndex))[0].textContent;
                    let materialName = $('div', row.cells.item(materialNameIndex))[0].textContent;
                    let materialAlias = $('div', row.cells.item(materialAliasIndex))[0].textContent;
                    let materialSpecs = $('div', row.cells.item(materialSpecsIndex))[0].textContent;
                    let semiSpecs = $('div', row.cells.item(semiSpecsIndex))[0].textContent;
                    let materialQ = $('div', row.cells.item(materialQIndex))[0].textContent;
                    let materialUnit = $('div', row.cells.item(materialUnitIndex))[0].textContent;
                    let tr = materialTable.insertRow(mIndex++);
                    if (mIndex == 1) {
                        processCell = tr.insertCell(0);
                        processCell.innerHTML = contentIndex + '.' + process;
                        processCell.setAttribute('class', 'processCell');
                    } else
                    if (key == lastID) {
                        processCell.setAttribute('rowspan', ++span);
                        lastRow.setAttribute('class', 'avoidBreak');
                    } else {
                        span = 1;
                        processCell = tr.insertCell(0);
                        processCell.innerHTML = contentIndex + '.' + process;
                        processCell.setAttribute('class', 'processCell');
                    }
                    let i = 0;
                    if (key != lastID) {
                        i = 1;
                    }
                    tr.insertCell(i++).innerHTML = materialCode;
                    let nameCell = tr.insertCell(i++);
                    nameCell.innerHTML = materialName;
                    nameCell.setAttribute('class', 'nameCell');
                    tr.insertCell(i++).innerHTML = materialSpecs;
                    tr.insertCell(i++).innerHTML = semiSpecs;
                    tr.insertCell(i++).innerHTML = plannedQuantity;
                    tr.insertCell(i++).innerHTML = materialQ;
                    tr.insertCell(i++).innerHTML = materialUnit;
                }
                lastID = key;
                lastRow = tr;
            }
            $('#outSourceType', w.document)[0].textContent = outsourcing;

            await sleep(100);
            if (window.fastPrint) {
                w.print();
                w.close();
                document.body.removeChild(iframe);
            }
        }
    }

    //async function makeQRCode() {
    //    let bodyRows = document.querySelectorAll('[class="cell el-tooltip"]')[0].closest('table').lastChild.rows;
    //    const qrIndex = $('th:contains("二维码")')[0].cellIndex;
    //    if (!qrIndex) {
    //        return;
    //    }
    //    let qrCell = null;
    //    for (let row of bodyRows) {
    //        qrCell = row.cells.item(qrIndex);
    //        let qrDiv = $('#qrBoxDiv', qrCell)[0];
    //        if (qrDiv) {
    //            qrCell.removeChild(qrDiv);
    //        }
    //        qrDiv = document.createElement('div');
    //        qrDiv.setAttribute('id', 'qrBoxDiv');
    //        qrCell.appendChild(qrDiv);

    //        let str = $('div', row.cells.item(qrIndex))[0].textContent;
    //        new QRCode(qrDiv, {
    //            text: str,
    //            width: 96,
    //            height: 96
    //        });
    //    }
    //    while ($('img', qrCell)[0].getAttribute('style') == "display: none;") {
    //        await sleep(100);
    //    }
    //    formatAndPrint();
    //}

    //async function formatAndPrint() {
    //    var header = $('thead')[0].firstChild;
    //    var body = document.querySelectorAll('[class="cell el-tooltip"]')[0].closest('tbody').cloneNode(true);
    //    var bodyRows = body.rows;

    //    // cleanup table elements
    //    var tbl = document.createElement('table');

    //    for (let row of bodyRows) {
    //        // tr
    //        row.removeAttribute('class');
    //        for (let cell of row.cells) {
    //            // td
    //            cell.removeAttribute('class');
    //            cell.removeAttribute('rowspan');
    //            cell.removeAttribute('colspan');
    //            // td-div
    //            cell.firstChild.removeAttribute('class');
    //            cell.firstChild.removeAttribute('style');
    //        }
    //    }

    //    var printContents = body.innerHTML;
    //    var pageTemplate = '<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/paper-css/0.3.0/paper.css">\n<style>@page { size: A4 }</style>\n<body class="A5">\n<section class="sheet padding-10mm">\n';
    //    // add contents here
    //    pageTemplate += "<table>" + printContents + "</table>";
    //    pageTemplate += '\n</section>\n</body>';
    //    var w = window.open();
    //    w.document.write(pageTemplate);
    //    await sleep(500);
    //    w.print();
    //    // w.close();
    //}

    // 生产任务单
    const htmlTemplate = '<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/paper-css/0.3.0/paper.css">' +
        '' +
        '<body class="A4" style="height: auto;">' +
        '    <section class="sheet padding-10mm" style="height: auto;">' +
        '        <p align=center style="margin-top: -5px;"><span class=title lang=ZH-CN>车间生产任务单</span></p>' +
        '        <div align=center>' +
        '            <div id="leftbox">' +
        '                <p align=left><label>客户名: </label><span id="customerName"></span></p>' +
        '                <p align=left><label>订单号: </label><span id="orderNo"></span></p>' +
        '                <p align=left><label>产品编码: </label><span id="productCode"></span></p>' +
        '                <p align=left><label>产品名: </label><span id="productName"></span></p>' +
        '                <p align=left><label>产品别名: </label><span id="productAlias"></span></p>' +
        '                <p align=left><label>产品规格: </label><span id="productSpecs"></span></p>' +
        '                <p align=left><label>生产单号: </label><span id="SCD"></span></p>' +
        '                <p align=left><label>客户下单数: </label><span id="orderQuantity"></span></p>' +
        '                <p align=left><label>计划生产数: </label><span id="plannedQuantity"></span></p>' +
        '                <p align=left><label>订单日期: </label><span id="orderDate"></span></p>' +
        '                <p align=left><label>交货日期: </label><span id="deliveryDate"></span></p>' +
        '                <p align=left><label>打印时间: </label><span id="printTime"></span></p>' +
        '                <p align=left><label>外发类型: </label><span id="outSourceType"></span></p>' +
        '            </div>' +
        '' +
        '            <div id="rightbox" style="margin-bottom: 10px;">' +
        '                <table id="materialTable" style="font-size:small;" contenteditable>' +
        '                    <tr>' +
        '                        <th>工序</th>' +
        '                        <th>物料编号</th>' +
        '                        <th>物料名称</th>' +
        '                        <th>物料规格</th>' +
        '                        <th>开料尺寸</th>' +
        '                        <th>开料数</th>' +
        '                        <th>用量</th>' +
        '                        <th>单位</th>' +
        '                    </tr>' +
        '                </table>' +
        '                <div style="margin-top: 20px;" id="SCDQR"></div>' +
        '            </div>' +
        '        </div>' +
        '        <div style="clear: both;"></div>' +
        '        <div style="margin-top: 10px;" align=center>' +
        '            <table style="font-size:small;" contenteditable>' +
        '                <thead>' +
        '                    <tr>' +
        '                        <td colspan="12" style="font-size: medium;"><span>产品名: </span> <span' +
        '                                id="ProductNameCell"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </thead>' +
        '                <tfoot>' +
        '                    <tr>' +
        '                        <td colspan="12" style="font-size: medium;"><span>车间生产单号: </span><span id="SCDCell"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </tfoot>' +
        '                <tbody id="procedureTable">' +
        '                    <tr>' +
        '                        <th>#</th>' +
        '                        <th>工序</th>' +
        '                        <th>工序内容</th>' +
        '                        <th>数量</th>' +
        '                        <th>单件</th>' +
        '                        <th style="min-width: 15mm;">日期</th>' +
        '                        <th style="min-width: 15mm;">投入数</th>' +
        '                        <th style="min-width: 15mm;">产出数</th>' +
        '                        <th style="min-width: 10mm;">不良品</th>' +
        '                        <th style="min-width: 10mm;">用时</th>' +
        '                        <th style="min-width: 15mm;">生产员</th>' +
        '                        <th>车间</th>' +
        '                    </tr>' +
        '                </tbody>' +
        '            </table>' +
        '        </div>' +
        '    </section>' +
        '</body>' +
        '<style>' +
        '    @page {' +
        '        size: A4;' +
        '    }' +
        '' +
        '    #leftbox {' +
        '        float: left;' +
        '        margin-top: 20px;' +
        '        margin-bottom: 40px;' +
        '        width: 30%;' +
        '    }' +
        '' +
        '    #rightbox {' +
        '        float: right;' +
        '        margin-top: 30px;' +
        '        width: 70%;' +
        '    }' +
        '' +
        '    .title {' +
        '        text-align: center;' +
        '        font-size: large;' +
        '    }' +
        '' +
        '    p {' +
        '        margin-bottom: -10px;' +
        '        font-size: 90%;' +
        '    }' +
        '' +
        '    .avoidBreak {' +
        '        page-break-after: avoid;' +
        '    }' +
        '' +
        '    table,' +
        '    th,' +
        '    td {' +
        '        border: 1px solid black;' +
        '        word-wrap: break-word;' +
        '    }' +
        '' +
        '    .semiCell {' +
        '        max-width: 50mm;' +
        '    }' +
        '' +
        '    .processCell {' +
        '        max-width: 17mm;' +
        '    }' +
        '' +
        '    .nameCell {' +
        '        max-width: 25mm;' +
        '    }' +
        '' +
        '    table {' +
        '        page-break-inside: auto;' +
        '    }' +
        '' +
        '    td {' +
        '        font-size: smaller;' +
        '    }' +
        '' +
        '    tr {' +
        '        page-break-inside: avoid;' +
        '        page-break-after: auto;' +
        '    }' +
        '' +
        '    thead {' +
        '        display: table-header-group;' +
        '    }' +
        '' +
        '    tfoot {' +
        '        display: table-footer-group;' +
        '    }' +
        '</style>';

    // 排料单
    const materialTemplate = '<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/paper-css/0.3.0/paper.css">' +
        '' +
        '<body class="A4" style="height: auto;">' +
        '    <section class="sheet padding-10mm" style="height: auto;">' +
        '        <p align=center style="margin-top: -5px;"><span class=title lang=ZH-CN>生产排料单</span></p>' +
        '        <div align=center>' +
        '            <div id="leftbox">' +
        '                <p align=left><label>订单号: </label><span id="orderNo"></span></p>' +
        '                <p align=left><label>订单日期: </label><span id="orderDate"></span></p>' +
        '                <p align=left><label>领料日期: </label><span id="pickingDate"></span></p>' +
        '                <p align=left><label>交货日期: </label><span id="deliveryDate"></span></p>' +
        '                <p align=left><label>打印时间: </label><span id="printTime"></span></p>' +
        '            </div>' +
        '' +
        '            <div id="rightbox">' +
        '                <div align="right" style="margin-top: 20px;" id="SCDQR"></div>' +
        '            </div>' +
        '        </div>' +
        '        <div style="clear: both;"></div>' +
        '        <div style="margin-top: 10px;" align=center>' +
        '            <table style="font-size:small;" contenteditable>' +
        '                <thead>' +
        '                    <tr>' +
        '                        <td colspan="15" style="font-size: medium;"><span>订单号: </span> <span id="OCellA"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </thead>' +
        '                <tfoot>' +
        '                    <tr>' +
        '                        <td colspan="15" style="font-size: medium;"><span>订单号: </span><span id="OCellB"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </tfoot>' +
        '                <tbody id="materialTable">' +
        '                    <tr>' +
        '                        <th>产品名称</th>' +
        '                        <th class="numCell">生产数</th>' +
        '                        <th class="numCell">出货数</th>' +
        '                        <th>工件名称</th>' +
        '                        <th>#</th>' +
        '                        <th>物料编码</th>' +
        '                        <th>物料名称</th>' +
        '                        <th>物料规格</th>' +
        '                        <th>开料尺寸</th>' +
        '                        <th>开料数</th>' +
        '                        <th style="min-width: 30px;">物料来源</th>' +
        '                        <th>用量</th>' +
        '                        <th>单位</th>' +
        '                        <th>车间</th>' +
        '                    </tr>' +
        '                </tbody>' +
        '            </table>' +
        '        </div>' +
        '    </section>' +
        '</body>' +
        '<style>' +
        '    @page {' +
        '        size: A4;' +
        '    }' +
        '' +
        '    #leftbox {' +
        '        float: left;' +
        '        margin-top: 20px;' +
        '        margin-bottom: 40px;' +
        '        width: 30%;' +
        '    }' +
        '' +
        '    #rightbox {' +
        '        float: right;' +
        '        margin-top: 10px;' +
        '        width: 70%;' +
        '    }' +
        '' +
        '    .numCell {' +
        '        max-width: 25px;' +
        '    }' +
        '' +
        '    .title {' +
        '        text-align: center;' +
        '        font-size: large;' +
        '    }' +
        '' +
        '    .avoidBreak {' +
        '        page-break-after: avoid;' +
        '    }' +
        '' +
        '    p {' +
        '        margin-bottom: -10px;' +
        '        font-size: 90%;' +
        '    }' +
        '' +
        '    table,' +
        '    th,' +
        '    td {' +
        '        border: 1px solid black;' +
        '        word-wrap: break-word;' +
        '    }' +
        '' +
        '    table {' +
        '        page-break-inside: auto;' +
        '    }' +
        '' +
        '    td {' +
        '        font-size: smaller;' +
        '        max-width: 80px;' +
        '    }' +
        '</style>';

    // 备料单
    const sumMaterialTemplate = '<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/paper-css/0.3.0/paper.css">' +
        '' +
        '<body class="A4" style="height: auto;">' +
        '    <section class="sheet padding-10mm" style="height: auto;">' +
        '        <p align=center style="margin-top: -5px;"><span class=title lang=ZH-CN>生产排料单</span></p>' +
        '        <div align=center>' +
        '            <div id="leftbox">' +
        '                <p align=left><label>订单号: </label><span id="orderNo"></span></p>' +
        '                <p align=left><label>订单日期: </label><span id="orderDate"></span></p>' +
        '                <p align=left><label>领料日期: </label><span id="pickingDate"></span></p>' +
        '                <p align=left><label>交货日期: </label><span id="deliveryDate"></span></p>' +
        '                <p align=left><label>打印时间: </label><span id="printTime"></span></p>' +
        '            </div>' +
        '' +
        '            <div id="rightbox">' +
        '                <div align="right" style="margin-top: 20px;" id="SCDQR"></div>' +
        '            </div>' +
        '        </div>' +
        '        <div style="clear: both;"></div>' +
        '        <div style="margin-top: 10px;" align=center>' +
        '            <table style="font-size:small;" contenteditable>' +
        '                <thead>' +
        '                    <tr>' +
        '                        <td colspan="15" style="font-size: medium;"><span>订单号: </span> <span id="OCellA"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </thead>' +
        '                <tfoot>' +
        '                    <tr>' +
        '                        <td colspan="15" style="font-size: medium;"><span>订单号: </span><span id="OCellB"></span>' +
        '                        </td>' +
        '                    </tr>' +
        '                </tfoot>' +
        '                <tbody id="materialTable">' +
        '                    <tr>' +
        '                        <th>#</th>' +
        '                        <th>物料编码</th>' +
        '                        <th>物料名称</th>' +
        '                        <th>物料别名</th>' +
        '                        <th>物料规格</th>' +
        '                        <th style="min-width: 30px;">物料来源</th>' +
        '                        <th>用量</th>' +
        '                        <th>单位</th>' +
        '                    </tr>' +
        '                </tbody>' +
        '            </table>' +
        '        </div>' +
        '    </section>' +
        '</body>' +
        '<style>' +
        '    @page {' +
        '        size: A4;' +
        '    }' +
        '' +
        '    #leftbox {' +
        '        float: left;' +
        '        margin-top: 20px;' +
        '        margin-bottom: 40px;' +
        '        width: 30%;' +
        '    }' +
        '' +
        '    #rightbox {' +
        '        float: right;' +
        '        margin-top: 10px;' +
        '        width: 70%;' +
        '    }' +
        '' +
        '    .numCell {' +
        '        max-width: 10px;' +
        '    }' +
        '' +
        '    .title {' +
        '        text-align: center;' +
        '        font-size: large;' +
        '    }' +
        '' +
        '    p {' +
        '        margin-bottom: -10px;' +
        '        font-size: 90%;' +
        '    }' +
        '' +
        '    .avoidBreak {' +
        '        page-break-after: avoid;' +
        '    }' +
        '' +
        '    table,' +
        '    th,' +
        '    td {' +
        '        border: 1px solid black;' +
        '        word-wrap: break-word;' +
        '    }' +
        '' +
        '    table {' +
        '        page-break-inside: auto;' +
        '    }' +
        '</style>';
})();