Calculation/app/public/js/material_checklist.js

'use strict';

/**
 * 材料调差 - 调差清单设置
 *
 * @author EllisRan
 * @date 2022/1/7
 * @version
 */

function getStageId() {
    return window.location.pathname.split('/')[5];
}

function findNotJoinLeafXmj(x, type = '') {
    if (type === 'index') {
        return notJoinList.findIndex(function (item) {
            return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id));
        });
    }
    return notJoinList.find(function (item) {
        return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id));
    });
}

function getPasteHint (str, row = '') {
    let returnObj = str;
    if (row) {
        returnObj.msg = '清单第' + (row+1) + '行' + (str.msg ? str.msg : str);
    }
    return returnObj;
}

function makeChecklistData(lists, checklists) {
    let html = '';
    if (lists.length > 0) {
        for(const [i,l] of lists.entries()) {
            const checklistInfo = _.find(checklists, { b_code: l.b_code, name: l.name, unit: l.unit, unit_price: l.unit_price });
            const isChecked = checklistInfo ? ' checked' : '';
            const isDisabled = checklistInfo && checklistInfo.had_bills === 1 ? ' disabled' : '';
            html += '<tr>\n' +
                '                                    <td><div class="text-center custom-control custom-checkbox mb-2">\n' +
                '                                            <input type="checkbox" id="lists_'+ i +'" value="'+ i +'" name="customCheckbox" class="custom-control-input"'+ isChecked + isDisabled +'>\n' +
                '                                            <label class="custom-control-label" for="lists_'+ i +'"></label>\n' +
                '                                        </div></td>\n' +
                '                                    <td class="text-center">'+ (i+1) +'</td>\n' +
                '                                    <td>'+ l.b_code +'</td>\n' +
                '                                    <td>'+ l.name +'</td>\n' +
                '                                    <td class="text-center">'+ (l.unit ? l.unit : '') +'</td>\n' +
                '                                    <td class="text-right">'+ (l.unit_price ? l.unit_price : '') +'</td>\n' +
                '                                    <td class="text-right">'+ (l.quantity ? l.quantity : '') +'</td>\n' +
                '                                    <td class="text-right">'+ (l.total_price ? l.total_price : '') +'</td>\n' +
                '                                </tr>';
        }
    }
    $('#lists_data').html(html);
}

// 清单搜索隐藏清单table部分值
function remakeChecklistData(lists, showListData = lists) {
    // 先加载台账数据
    if (lists.length > 0) {
        for (const [index,gcl] of lists.entries()) {
            const isShow = _.find(showListData, gcl);
            $('#lists_data tr').eq(index).css('display', (isShow ? 'table-row' : 'none'));
        }
    }
}

$(document).ready(() => {
    function TipCellType()
    {
    }
    TipCellType.prototype = new GC.Spread.Sheets.CellTypes.ColumnHeader();
    TipCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
        return { x: x, y: y, row: context.row, col: context.col, cellRect: cellRect, sheetArea: context.sheetArea, sheet: context.sheet };
    };
    TipCellType.prototype.processMouseEnter = function (hitInfo){
        if (!this._toolTipElement) {
            var div = document.createElement("div");
            $(div).css("position", "absolute")
                .css("border", "1px #C0C0C0 solid")
                .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
                .css("font", "9pt Arial")
                .css("background", "#fff")
                // .css("color", "#fff")
                .css("z-index", "1000")
                .css("padding", 5);
            this._toolTipElement = div;
        }
        $(this._toolTipElement).text("单位数量：每一单位清单下所需工料消耗量。")
            .css("top", hitInfo.y + 15)
            .css("left", hitInfo.x - 15);
        $(this._toolTipElement).hide();
        // document.body.insertBefore(this._toolTipElement, null);
        $('#material-spread-div').append(this._toolTipElement, null);
        $(this._toolTipElement).show("fast");
    };
    TipCellType.prototype.processMouseLeave = function (hitInfo) {
        if (this._toolTipElement) {
            this._toolTipElement.remove();
            this._toolTipElement = null;
        }
    };
    autoFlashHeight();
    // 清单table
    const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
    const ledgerSpreadSetting = {
        cols: [
            {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 90, formatter: '@'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 220, formatter: '@'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 80, formatter: '@'},
            {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 110, type: 'Number'},
            {title: '工程量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 110, type: 'Number'},
            {title: '台账金额', colSpan: '1', rowSpan: '2', field: 'total_price', hAlign: 2, width: 110, type: 'Number'},
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);

    // 加载清单数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
    postData(window.location.pathname + '/load', {}, function (result) {
        ledger = result.ledger;
        curLedgerData = result.curLedgerData;
        pos = result.pos;
        curPosData = result.curPosData;
        materialListData = result.materialListData;
        notJoinList = result.materialNotJoinListData;
        materialChecklistData = result.materialChecklistData;
        // 解析清单汇总数据
        gclGatherModel.loadLedgerData(ledger, curLedgerData);
        gclGatherModel.loadPosData(pos, curPosData);
        gclGatherData = gclGatherModel.gatherGclData();
        console.log(gclGatherData);
        const hadBillsidList = _.uniq(_.map(materialListData, 'gcl_id'));
        console.log(hadBillsidList);
        // 对比清单设置和调差清单，还要和台账对比，显示已选清单列表 不同则更新到清单设置页中
        const pushData = [];
        const updateData = [];
        for (const hb of hadBillsidList) {
            const gcl = _.find(gclGatherData, function (item) {
                return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, { gcl_id : hb }) !== -1;
            });
            if (gcl) {
                const mc = _.find(materialChecklistData, { b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price });
                // const newOrder = _.indexOf(gclGatherData, gcl);
                // console.log(newOrder);
                if (!mc && _.findIndex(pushData, { b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price }) === -1) {
                    pushData.push({ b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price, quantity: (gcl.quantity ? gcl.quantity : null), total_price: (gcl.total_price ? gcl.total_price : null), had_bills: 1 });
                }
            }
        }
        const removeData = [];
        for (const mc of materialChecklistData) {
            const gcl = _.find(gclGatherData, { b_code: mc.b_code, name: mc.name, unit: mc.unit, unit_price: mc.unit_price });
            // 判断是否已不存在工料清单，台账修改过后删除之
            if (!gcl) {
                removeData.push(mc.id);
            }
            // 更新had_bills值
            if (mc.had_bills === 1) {
                if (_.indexOf(hadBillsidList, gcl.leafXmjs ? gcl.leafXmjs[0].gcl_id : null) === -1) {
                    updateData.push({ id: mc.id, mid: materialID, had_bills: 0 });
                }
            }
        }
        setChecklistData(pushData, removeData, updateData, true);
    });
    function setChecklistData(pushData, removeData, updateData = [], sendmsg = false) {
        if (pushData.length > 0 || removeData.length > 0 || updateData.length > 0) {
            postData(window.location.pathname + '/save', { type: 'resetChecklist', pushData, removeData, updateData }, function (result2) {
                if (sendmsg && pushData.length > 0) {
                    toastr.success('已同步并添加到调差清单数据至本页中');
                }
                if (sendmsg && removeData.length > 0) {
                    toastr.warning('已删除部分与台账清单不匹配的清单数据');
                }
                materialChecklistData = result2;
                showSjsData();
            })
        } else {
            showSjsData();
        }
    }
    function showSjsData() {
        SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialChecklistData);
        SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet());
        if (materialChecklistData.length > 0) {
            const index = _.findIndex(gclGatherData, { b_code: materialChecklistData[0].b_code, name: materialChecklistData[0].name, unit: materialChecklistData[0].unit, unit_price: materialChecklistData[0].unit_price });
            loadMaterialData(index, 0);
        } else {
            loadMaterialData(-1, 0);
        }
        const sheet = materialSpread.getActiveSheet();
        sheet.suspendPaint();
        sheet.setCellType(1, 3, new TipCellType(), spreadNS.SheetArea.colHeader);
        sheet.resumePaint();
    }
    // 调差清单工料table
    const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]);
    const materialSpreadSetting = {
        cols: [
            {title: '清单工料含量|编号', colSpan: '5|1', rowSpan: '1|1', field: 'code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
            {title: '|名称', colSpan: '|1', rowSpan: '|1', field: 'name', hAlign: 0, width: 100, formatter: '@', readOnly: true},
            {title: '|单位', colSpan: '|1', rowSpan: '|1', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: true},
            {title: '|数量 �', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number', readOnly: 'readOnly.isEdit'},
            {title: '|计算式', colSpan: '1', rowSpan: '|1', field: 'expr', hAlign: 2, width: 120, formatter: '@', readOnly: 'readOnly.isEdit'},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
    };

    const materialBase = {
        isEdit: function (data) {
            // 是否本期添加的工料
            return data.order === stage_order;
        }
    };

    const materialCol = {
        readOnly: {
            isEdit: function (data) {
                return !(!readOnly && materialBase.isEdit(data));
            },
        },
    };
    SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
    // 获取项目节数据
    let materialList = [];
    function loadMaterialData(iGclRow, iLXmjRow) {
        const gcl = gclGatherData[iGclRow];
        if (gcl && gcl.leafXmjs[iLXmjRow]) {
            const xmj = gcl.leafXmjs[iLXmjRow];
            materialList = [];
            materialList = _.filter(materialListData, function (m) {
                return m.gcl_id === xmj.gcl_id && m.xmj_id === xmj.id && ((xmj.mx_id !==undefined && m.mx_id === xmj.mx_id) || xmj.mx_id === undefined);
            });
            // for (const m of materialListData) {
            //     if (m.gcl_id === xmj.gcl_id && m.xmj_id === xmj.id && ((xmj.mx_id !==undefined && m.mx_id === xmj.mx_id) || xmj.mx_id === undefined)) {
            //         materialList.push(m);
            //     }
            // }
            // 对清单调差工料table的单位数量进行改变
            materialSpreadSetting.cols[materialSpreadSetting.cols.length - 2].title = '|' + gcl.unit + '数量 �';
            SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
            SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialList);
        } else {
            materialSpreadSetting.cols[materialSpreadSetting.cols.length - 2].title = '数量 �';
            SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
            SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
        }
        SpreadJsObj.resetTopAndSelect(materialSpread.getActiveSheet());
    }

    // 对添加工料表格赋值
    function changeMaterialTable() {
        $('#materialBills tr').removeClass('table-secondary');
        $('#materialBills').find('input').removeAttr('disabled');
        $('#materialBills').find('input').prop('checked', false);
        for (const ml of materialList) {
            const mbIndex = _.findIndex(materialBillsData, {id : ml.mb_id });
            if (mbIndex !== -1) {
                $('#materialBills tr').eq(mbIndex).addClass('table-secondary');
                $('#materialBills').find('input').eq(mbIndex).attr('disabled', true);
                $('#materialBills').find('input').eq(mbIndex).prop('checked', true);
            }
        }
    }
    // 选中清单并添加
    $('#set_checklist_btn').click(function () {
        const select_checklist = $('#lists_data').find('input:checked:not(:disabled)');
        const pushData = [];
        for (const sc of select_checklist) {
            const order = parseInt($(sc).val());
            const checklistInfo = _.find(materialChecklistData, { b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price });
            if (!checklistInfo) {
                pushData.push({
                    b_code: gclGatherData[order].b_code,
                    name: gclGatherData[order].name,
                    unit: gclGatherData[order].unit,
                    unit_price: gclGatherData[order].unit_price,
                    quantity: gclGatherData[order].quantity ? gclGatherData[order].quantity : null,
                    total_price: gclGatherData[order].total_price ? gclGatherData[order].total_price : null,
                    had_bills: 0,
                })
            }
        }
        const notSelect_checklist = $('#lists_data').find('input:not(:checked):not(:disabled)');
        const removeData = [];
        for (const nsc of notSelect_checklist) {
            const order = parseInt($(nsc).val());
            // const order = parseInt($(nsc).attr('data-index'));
            const checklistInfo = _.find(materialChecklistData, { b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price });
            if (checklistInfo) {
               removeData.push(checklistInfo.id);
            }
        }
        setChecklistData(pushData, removeData);
        $('#addtclist').modal('hide');
    });
    // 筛选无调差工料清单
    $('#notBills_checkList').click(function () {
        const isCheck = $(this).is(':checked');
        let newMaterialChecklistData = materialChecklistData;
        if (isCheck) {
            newMaterialChecklistData = _.filter(materialChecklistData, { had_bills: 0 });
        }
        SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialChecklistData);
        SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet());
        if (newMaterialChecklistData.length > 0) {
            const index = _.findIndex(gclGatherData, { b_code: newMaterialChecklistData[0].b_code, name: newMaterialChecklistData[0].name, unit: newMaterialChecklistData[0].unit, unit_price: newMaterialChecklistData[0].unit_price });
            loadMaterialData(index, 0);
        } else {
            loadMaterialData(-1, 0);
        }
    });
    // 添加调差工料
    $('#add_material_bill').click(function () {
        // 获取已选工料
        $('#materialBills').find('input:disabled').prop('checked', false);
        const selectList = $('#materialBills').find('input:checked');
        if (selectList.length === 0) {
            toastr.warning('请选择调差工料');
            $('#materialBills').find('input:disabled').prop('checked', true);
            return false;
        }
        const mb_id = [];
        for (let s = 0; s < selectList.length; s++) {
            mb_id.push($('#materialBills').find('input:checked').eq(s).val());
        }
        // 获取当前项目节或部位明细id
        const sheet = ledgerSpread.getActiveSheet();
        const select = SpreadJsObj.getSelectObject(sheet);
        const gclIndex = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price });
        const gcl = gclGatherData[gclIndex].leafXmjs;
        const index = materialChecklistData.indexOf(select);
        const datas = [];
        for (const xmj of gcl) {
            const notx = findNotJoinLeafXmj(xmj);
            const data = {
                xmj_id: xmj.id,
                gcl_id: xmj.gcl_id,
                mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
                gather_qty: xmj.gather_qty,
                is_join: notx === undefined ? 1 : 0,
            };
            datas.push(data);
        }
        // 上传到数据库
        console.log(datas, gcl);
        postData(window.location.pathname + '/save', {type: 'adds', checklist: { id: select.id, had_bills: 1 }, postData: {xmjs: datas, mbIds: mb_id}}, function (result) {
            materialListData = result;
            materialChecklistData[index].had_bills = 1;
            loadMaterialData(gclIndex, 0);
            // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
            $('#addgl').modal('hide');
        });
        $('#materialBills').find('input:disabled').prop('checked', true);
    });
    if (!readOnly) {
        // material-spread右键功能
        const materialSpreadObj = {
            del: function () {
                const materialSheet = materialSpread.getActiveSheet();
                const materialSelect = SpreadJsObj.getSelectObject(materialSheet);
                const sheet = ledgerSpread.getActiveSheet();
                const select = SpreadJsObj.getSelectObject(sheet);
                const index = materialChecklistData.indexOf(select);
                const gclIndex = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price });
                const gcl = gclGatherData[gclIndex].leafXmjs;
                const datas = [];
                for (const xmj of gcl) {
                    const data = {
                        xmj_id: xmj.id,
                        gcl_id: xmj.gcl_id,
                        mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
                    };
                    datas.push(data);
                }
                const xmj = gcl[0];
                const materialCount = _.size(_.filter(materialListData, function (m) {
                    return m.gcl_id === xmj.gcl_id && m.xmj_id === xmj.id && ((xmj.mx_id !==undefined && m.mx_id === xmj.mx_id) || xmj.mx_id === undefined);
                }));
                let checklist = false;
                if (materialCount === 1) {
                    checklist = {
                        id: select.id,
                        had_bills: 0,
                    }
                }
                console.log(datas, materialSelect.mb_id, checklist);
                postData(window.location.pathname + '/save', {type: 'dels', checklist, postData: { xmjs: datas, mb_id: materialSelect.mb_id }}, function (result) {
                    materialListData = result;
                    if (checklist) materialChecklistData[index].had_bills = checklist.had_bills;
                    loadMaterialData(gclIndex, 0);
                    // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
                });
            },
            deletePress: function (sheet) {
                return;
            },
            editStarting: function (e, info) {
                const col = info.sheet.zh_setting.cols[info.col];
                const select = SpreadJsObj.getSelectObject(info.sheet);
                if (col.field === 'quantity') {
                    if (select.expr && select.expr !== '') {
                        info.sheet.getCell(info.row, info.col).text(select.expr);
                    }
                }
            },
            editEnded: function (e, info) {
                if (info.sheet.zh_setting) {
                    const select = SpreadJsObj.getSelectObject(info.sheet);
                    const col = info.sheet.zh_setting.cols[info.col];
                    const validText = info.editingText ? info.editingText.replace('\n', '') : null;
                    let orgValue;
                    if (col.field === 'quantity') {
                        orgValue = validText && validText !== ''
                            ? _.toNumber(validText) ? select.quantity : select.expr
                            : (select.expr && select.expr !== '') ? select.expr : select.quantity;
                    } else {
                        orgValue = select[col.field];
                    }
                    if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) {
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const exprQuantity = {
                        expr: '',
                        quantity: 0,
                    };
                    const [valid, msg] = materialSpreadObj._checkExpr(validText, exprQuantity);
                    if (!valid) {
                        toastr.error(msg);
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    if (isNaN(exprQuantity.quantity)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    const num = parseFloat(exprQuantity.quantity);
                    if (num < 0 || !/^\d+(\.\d{1,6})?$/.test(num)) {
                        toastr.warning('已保留6位小数');
                        exprQuantity.quantity = ZhCalc.round(num, 6);
                    }
                    // 更新至服务器
                    const ledgerSheet = ledgerSpread.getActiveSheet();
                    const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet);
                    const gclIndex = _.findIndex(gclGatherData, { b_code: ledgerSelect.b_code, name: ledgerSelect.name, unit: ledgerSelect.unit, unit_price: ledgerSelect.unit_price });
                    const gcl = gclGatherData[gclIndex].leafXmjs;
                    const datas = [];
                    for (const xmj of gcl) {
                        const data = {
                            xmj_id: xmj.id,
                            gcl_id: xmj.gcl_id,
                            mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
                        };
                        datas.push(data);
                    }
                    console.log(exprQuantity, datas, select.mb_id);
                    postData(window.location.pathname + '/save', { type:'updates', updateData: { xmjs: datas, expr: exprQuantity.expr, quantity: exprQuantity.quantity, mb_id: select.mb_id } }, function (result) {
                        materialListData = result;
                        loadMaterialData(gclIndex, 0);
                        materialSpread.getActiveSheet().setSelection(info.row + 1, info.col, 1, 1);
                    }, function () {
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    });
                }
            },
            clipboardPasted(e, info) {
                const hint = {
                    cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
                    numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
                    numberCan: {type: 'warning', msg: '已保留6位小数'},
                };
                const range = info.cellRange;
                const sortData = info.sheet.zh_data || [];
                if (range.row + range.rowCount > sortData.length) {
                    toastMessageUniq(hint.cellError);
                    SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
                    SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
                    return;
                }
                if (sortData.length > 0 && range.col + range.colCount > 5) {
                    toastMessageUniq(hint.cellError);
                    SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
                    SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
                    return;
                }
                const data = [];
                for (let iRow = 0; iRow < range.rowCount; iRow++) {
                    let bPaste = true;
                    const curRow = range.row + iRow;
                    const materialData = { id: sortData[curRow].id, mb_id: sortData[curRow].mb_id };
                    const hintRow = range.rowCount > 1 ? curRow : '';
                    let sameCol = 0;
                    for (let iCol = 0; iCol < range.colCount; iCol++) {
                        const curCol = range.col + iCol;
                        const colSetting = info.sheet.zh_setting.cols[curCol];
                        if (!colSetting) continue;

                        const validText = info.sheet.getText(curRow, curCol).replace('\n', '');
                        const orgValue = sortData[curRow][colSetting.field];
                        if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
                            sameCol++;
                            if (range.colCount === sameCol)  {
                                bPaste = false;
                            }
                            continue;
                        }
                        const exprQuantity = {
                            expr: '',
                            quantity: 0,
                        };
                        const [valid, msg] = materialSpreadObj._checkExpr(validText, exprQuantity);
                        if (!valid) {
                            toastMessageUniq(getPasteHint(msg, hintRow));
                            bPaste = false;
                            continue;
                        }
                        if (isNaN(exprQuantity.quantity)) {
                            toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
                            bPaste = false;
                            continue;
                        }
                        const num = parseFloat(exprQuantity.quantity);
                        if (num < 0 || !/^\d+(\.\d{1,6})?$/.test(num)) {
                            toastMessageUniq(getPasteHint(hint.numberCan, hintRow));
                            exprQuantity.quantity = ZhCalc.round(num, 6);
                        }
                        materialData.expr = exprQuantity.expr;
                        materialData.quantity = exprQuantity.quantity;
                    }
                    if (bPaste) {
                        data.push(materialData);
                    } else {
                        SpreadJsObj.reLoadRowData(info.sheet, curRow);
                    }
                }
                if (data.length === 0) {
                    SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
                    return;
                }
                const ledgerSheet = ledgerSpread.getActiveSheet();
                const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet);
                const gclIndex = _.findIndex(gclGatherData, { b_code: ledgerSelect.b_code, name: ledgerSelect.name, unit: ledgerSelect.unit, unit_price: ledgerSelect.unit_price });
                const gcl = gclGatherData[gclIndex].leafXmjs;
                const datas = [];
                for (const xmj of gcl) {
                    const data2 = {
                        xmj_id: xmj.id,
                        gcl_id: xmj.gcl_id,
                        mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
                    };
                    datas.push(data2);
                }
                console.log(data, datas);
                // 更新至服务器
                postData(window.location.pathname + '/save', { type:'pastes', updateData: { xmjs: datas, pasteData: data } }, function (result) {
                    materialListData = result;
                    loadMaterialData(gclIndex, 0);
                    materialSpread.getActiveSheet().setSelection(info.cellRange.row, info.cellRange.col, info.cellRange.rowCount, info.cellRange.colCount);
                }, function () {
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                });
            },
            _checkExprValid(expr) {
                if (!expr) return [true, null];
                const param = [];
                let num = '', base = '';
                for (let i = 0, iLen = expr.length; i < iLen; i++) {
                    if (/^[\d\.%]+/.test(expr[i])) {
                        if (base !== '') {
                            param.push({type: 'base', value: base});
                            base = '';
                        }
                        num = num + expr[i];
                    } else if (expr[i] === '(') {
                        if (num !== '') {
                            param.push({type: 'num', value: num});
                            num = '';
                        }
                        if (base !== '') {
                            param.push({type: 'base', value: base});
                            base = '';
                        }
                        param.push({type: 'left', value: '('});
                    } else if (expr[i] === ')') {
                        if (num !== '') {
                            param.push({type: 'num', value: num});
                            num = '';
                        }
                        if (base !== '') {
                            param.push({type: 'base', value: base});
                            base = '';
                        }
                        param.push({type: 'right', value: ')'});
                    } else if (/^[\+\-*\/]/.test(expr[i])) {
                        if (num !== '') {
                            param.push({type: 'num', value: num});
                            num = '';
                        }
                        if (base !== '') {
                            param.push({type: 'base', value: base});
                            base = '';
                        }
                        param.push({type: 'calc', value: expr[i]});
                    } else {
                        return [false, '输入的表达式含有非法字符: ' + expr[i]];
                    }
                }
                if (num !== '') {
                    param.push({type: 'num', value: num});
                    num = '';
                }
                if (base !== '') {
                    param.push({type: 'base', value: base});
                    base = '';
                }
                if (param.length === 0) return true;
                if (param.length > 1) {
                    if (param[0].value === '-') {
                        param[1].value = '-' + param[1];
                    }
                    param.unshift();
                }
                const iLen = param.length;
                let iLeftCount = 0, iRightCount = 0;
                for (const [i, p] of param.entries()) {
                    if (p.type === 'calc') {
                        if (i === 0 || i === iLen - 1)
                            return [false, '输入的表达式非法：计算符号' + p.value + '前后应有数字'];
                    }
                    if (p.type === 'num') {
                        num = p.value.replace('%', '');
                        if (p.value.length - num.length > 1)
                            return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字'];
                        num = _.toNumber(num);
                        if (num === undefined || num === null || _.isNaN(num))
                            return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字'];
                        if (i > 0) {
                            if (param[i - 1].type !== 'calc' && param[i - 1].type !== 'left') {
                                return [false, '输入的表达式非法：' + p.value + '前应有运算符'];
                            } else if (param[i - 1].value === '/' && num === 0) {
                                return [false, '输入的表达式非法：请勿除0'];
                            }
                        }
                    }
                    if (p.type === 'base') {
                        if (i > 0 && (param[i - 1].type === 'num' || param[i - 1].type === 'right'))
                            return [false, '输入的表达式非法：' + p.value + '前应有运算符'];
                    }
                    if (p.type === 'left') {
                        iLeftCount += 1;
                        if (i !== 0 && param[i-1].type !== 'calc')
                            return [false, '输入的表达式非法：（前应有运算符'];
                    }
                    if (p.type === 'right') {
                        iRightCount += 1;
                        if (i !== iLen - 1 && param[i+1].type !== 'calc')
                            return [false, '输入的表达式非法：)后应有运算符'];
                        if (iRightCount > iLeftCount)
                            return [false, '输入的表达式非法：")"前无对应的"（"'];
                    }
                }
                if (iLeftCount > iRightCount)
                    return [false, '输入的表达式非法："("后无对应的"）"'];
                return [true, ''];
            },
            _checkExpr: function (text, data) {
                if (text) {
                    const num = _.toNumber(text);
                    if (num) {
                        data.quantity = num;
                        data.expr = '';
                    } else {
                        const expr = $.trim(text).replace('\t', '').replace('=', '').toLowerCase();
                        const [valid, msg] = this._checkExprValid(expr);
                        if (!valid) return [valid, msg];
                        data.expr = expr;
                        data.quantity = ZhCalc.calcExpr.calcExprStrRpn(expr);
                    }
                } else {
                    data.quantity = 0;
                    data.expr = '';
                }
                return [true, ''];
            },
        };
        materialSpread.bind(spreadNS.Events.EditStarting, materialSpreadObj.editStarting);
        materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded);
        materialSpread.bind(spreadNS.Events.ClipboardPasted, materialSpreadObj.clipboardPasted);
        SpreadJsObj.addDeleteBind(materialSpread, materialSpreadObj.deletePress);
        $.contextMenu({
            selector: '#material-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, materialSpread);
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                'create': {
                    name: '添加工料',
                    icon: 'fa-sign-in',
                    callback: function (key, opt) {
                        // 获取已选清单
                        changeMaterialTable();
                        $('#addgl').modal('show');
                    },
                    disabled: function (key, opt) {
                        const sheet = ledgerSpread.getActiveSheet();
                        const select = SpreadJsObj.getSelectObject(sheet);
                        if (!select) {
                            return true;
                        }
                        return readOnly;
                    }
                },
                'delete': {
                    name: '删除工料',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        materialSpreadObj.del(materialSpread.getActiveSheet());
                    },
                    disabled: function (key, opt) {
                        const sheet = materialSpread.getActiveSheet();
                        const selection = sheet.getSelections();
                        const sel = selection ? selection[0] : sheet.getSelections()[0];
                        const select = SpreadJsObj.getSelectObject(sheet);
                        if (!select) {
                            return true;
                        }
                        if (!readOnly && sel.rowCount === 1 && select && materialBase.isEdit(select)) {
                            return false;
                        } else {
                            return true;
                        }
                    }
                },
            }
        });
    }

    // 切换清单行，读取所属项目节数据
    ledgerSpread.getActiveSheet().bind(spreadNS.Events.SelectionChanged, function (e, info) {
        if (info.oldSelections !== undefined) {
            const iOldRow = info.oldSelections[0].row, iNewRow = info.newSelections[0].row;
            if (iNewRow !== iOldRow) {
                const sheet = ledgerSpread.getActiveSheet();
                const select = SpreadJsObj.getSelectObject(sheet);
                const index = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price });
                loadMaterialData(index, 0);
            }
        }
    });

    $('#open_addtclist').click(function () {
        $('#tclist_search').val('');
        $('#tclist_search').siblings('a').hide();
        makeChecklistData(gclGatherData, materialChecklistData);
        $('#addtclist').modal('show');
    });

    // 回车提交
    $('#tclist_search').on('keypress', function () {
        if(window.event.keyCode === 13) {
            $(this).blur();
        }
    });

    $('#tclist_search').on('blur', function () {
        const value = _.trim($(this).val());
        let showListData = gclGatherData;
        if (value !== '') {
            $(this).siblings('a').show();
            showListData = _.filter(gclGatherData, function (c) {
                return (c.b_code && c.b_code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1);
            })
        } else {
            $(this).siblings('a').hide();
        }
        remakeChecklistData(gclGatherData, showListData);
    });

    $('.remove-btn').on('click', function () {
        $(this).hide();
        $(this).siblings('input').val('');
        remakeChecklistData(gclGatherData);
    });

    // 显示有调差工料清单
    // $('#show_material_gcl').click(function () {
    //     if ($(this).is(':checked')) {
    //         const hadMaterialGclGatherData = [];
    //         const hadGclIdList = [];
    //         for (const ml of materialListData) {
    //             if (hadGclIdList.indexOf(ml.gcl_id) === -1) {
    //                 hadGclIdList.push(ml.gcl_id);
    //             }
    //         }
    //         for (const gcl of gclGatherData) {
    //             for (const index in gcl.leafXmjs) {
    //                 const gcl_id = gcl.leafXmjs[index].gcl_id;
    //                 if (hadGclIdList.indexOf(gcl_id) !== -1) {
    //                     hadMaterialGclGatherData.push(gcl);
    //                     break;
    //                 }
    //             }
    //         }
    //         gclGatherData = hadMaterialGclGatherData;
    //     } else {
    //         gclGatherModel.loadLedgerData(ledger, curLedgerData);
    //         gclGatherModel.loadPosData(pos, curPosData);
    //         gclGatherData = gclGatherModel.gatherGclData().filter(item => {
    //             return item.qc_qty || item.contract_qty
    //         });
    //     }
    //     SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, gclGatherData);
    //     loadLeafXmjData(0);
    //     loadMaterialData(0, 0);
    //     SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet());
    //     SpreadJsObj.resetTopAndSelect(leafXmjSpread.getActiveSheet());
    //     SpreadJsObj.resetTopAndSelect(materialSpread.getActiveSheet());
    // });

    $.subMenu({
        menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
        toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
        key: 'menu.1.0.0',
        miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
        callback: function (info) {
            if (info.mini) {
                $('.panel-title').addClass('fluid');
                $('#sub-menu').removeClass('panel-sidebar');
            } else {
                $('.panel-title').removeClass('fluid');
                $('#sub-menu').addClass('panel-sidebar');
            }
            autoFlashHeight();
            ledgerSpread.refresh();
            materialSpread.refresh();
        }
    });

    $.divResizer({
        select: '#right-spr',
        callback: function () {
            ledgerSpread.refresh();
            materialSpread.refresh();
            const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
            setLocalCache('material_checklist_' + materialID, width);
        }
    });

    // 展开收起工料并浏览器记住本期展开收起
    $('a', '.right-nav').bind('click', function () {
        const tab = $(this), tabPanel = $(tab.attr('content'));
        if (!tab.hasClass('active')) {
            $('a', '.side-menu').removeClass('active');
            $('.tab-content .tab-select-show').removeClass('active');
            tab.addClass('active');
            tabPanel.addClass('active');
            showSideTools(tab.hasClass('active'));
            if (tab.attr('content') === '#material-tab') {
                const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
                setLocalCache('material_checklist_' + materialID, width);
            }
        } else {
            removeLocalCache('material_checklist_' + materialID);
            tab.removeClass('active');
            tabPanel.removeClass('active');
            showSideTools(tab.hasClass('active'));
        }
        ledgerSpread.refresh();
        materialSpread.refresh();
    });
    // 根据浏览器记录展开收起
    if (getLocalCache('material_checklist_' + materialID)) {
        const tab = $('.right-nav a[content="#material-tab"]'), tabPanel = $(tab.attr('content'));
        $('a', '.side-menu').removeClass('active');
        $('.tab-content .tab-select-show').removeClass('active');
        tab.addClass('active');
        tabPanel.addClass('active');
        $('#right-view').width(getLocalCache('material_checklist_' + materialID) + '%');
        showSideTools(tab.hasClass('active'));
        ledgerSpread.refresh();
        materialSpread.refresh();
    }
});