Calculation/app/public/js/change_information_set.js

'use strict';

/**
 * 变更令详细页js
 *
 * @author EllisRan.
 * @date 2018/11/22
 * @version
 */
// 编号排序，多重判断
function sortByCode(a, b) {
    const codeValue1 = a && a.code != null ? String(a.code) : '';
    const codeValue2 = b && b.code != null ? String(b.code) : '';
    // 空编号排在最后，两者都为空时保持原顺序。
    if (codeValue1 === '' || codeValue2 === '') {
        return codeValue1 === codeValue2 ? 0 : (codeValue1 === '' ? 1 : -1);
    }
    let code1 = codeValue1.split('-');
    let code2 = codeValue2.split('-');
    let code1length = code1.length;
    let code2length = code2.length;
    for (let i = 0; i < code1length; i ++) {
        if (i+1 <= code2length) {
            if (code1[i] != code2[i]) {
                if (/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
                    return parseInt(code1[i]) - parseInt(code2[i]);
                } else if (!/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
                    return 1;
                } else if (/^\d+$/.test(code1[i]) && !/^\d+$/.test(code2[i])) {
                    return -1;
                } else {
                    const str1length = code1[i].length;
                    const str2length = code2[i].length;
                    for (let j = 0; j < str1length; j++) {
                        if (j+1 <= str2length) {
                            if (code1[i].charAt(j) != code2[i].charAt(j)) {
                                return code1[i].charAt(j).charCodeAt() - code2[i].charAt(j).charCodeAt();
                            }  else if (j+1 == str1length && code1[i].charAt(j) == code2[i].charAt(j)) {
                                if (str1length == str2length) {
                                    return 0;
                                } else {
                                    return str1length - str2length;
                                }
                            }
                        } else {
                            if (j+1 >= str1length) {
                                return 1;
                            } else {
                                return -1;
                            }
                        }
                    }
                }
            } else if (i+1 == code1length && code1[i] == code2[i]) {
                if (code1length == code2length) {
                    return 0;
                } else {
                    return code1length - code2length;
                }
            }
        } else {
            if (i+1 >= code1length) {
                return 1;
            } else {
                return -1;
            }
        }
    }
}
$.event.special.valuechange = {
    teardown: function (namespaces) {
        $(this).unbind('.valuechange');
    },

    handler: function (e) {
        $.event.special.valuechange.triggerChanged($(this));
    },

    add: function (obj) {
        $(this).on('keyup.valuechange cut.valuechange paste.valuechange input.valuechange', obj.selector, $.event.special.valuechange.handler)
    },

    triggerChanged: function (element) {
        var current = element[0].contentEditable === 'true' ? element.html() : element.val()
            , previous = typeof element.data('previous') === 'undefined' ? element[0].defaultValue : element.data('previous');
        if (current !== previous) {
            element.trigger('valuechange', [element.data('previous')]);
            element.data('previous', current);
        }
    }
};
function getPasteHint (str, row = '') {
    let returnObj = str;
    if (row) {
        returnObj.msg = '清单第' + (row+1) + '行' + str.msg;
    }
    return returnObj;
}
let searchCodeList = [];
$(document).ready(() => {
    const changeSpreadSetting = {
        cols: [
            {title: '计价', colSpan: '1', rowSpan: '2', field: 'is_valuation', hAlign: 1, width: 50, cellType: 'checkbox', readOnly: 'readOnly.isEdit3'},
            {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.isEdit2'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 120, formatter: '@', readOnly: 'readOnly.isEdit2'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isEdit2', cellType: 'unit', comboItems: changeUnits, comboEdit: true},
            {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit2', getValue: 'getValue.unit_price'},
            {title: '变更部位', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 120, formatter: '@', readOnly: 'readOnly.isEdit2'},
            {title: '变更详情', colSpan: '1', rowSpan: '2', field: 'detail', hAlign: 0, width: 120, formatter: '@', readOnly: false},
            {title: '计量上限（%）', colSpan: '1', rowSpan: '2', field: 'delimit', hAlign: 2, width: 60, type: 'Number', readOnly: false, visible: openChangeState},
            {title: '原设计|数量', colSpan: '2|1', rowSpan: '1|1', field: 'oamount2', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isSettle', getValue: 'getValue.oamount2'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'oa_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.oa_tp'},
            {title: '申请变更增(+)减(-)|数量', colSpan: '2|1', rowSpan: '1|1', field: 'camount', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isSettle', getValue: 'getValue.camount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'ca_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.ca_tp'},
            {title: '变更后|数量', colSpan: '2|1', rowSpan: '1|1', field: 'samount', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.changed_amount'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'sa_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.changed_tp'},
            {title: '操作', colSpan: '1', rowSpan: '2', field: 'del_list', hAlign: 1, width: 40, readOnly: true, cellType: 'mouseTouch', getValue: 'getValue.del_list'},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: readOnly,
        rowHeader:[
            {
                rowHeaderType: 'circle',
                setting: {
                    size: 5,
                    indent: 16,
                    getColor: function (index, data) {
                        if (!data) return;
                        if (_.findIndex(changeLedgerList, { id: data.gcl_id }) !== -1 || _.findIndex(changePosList, { id: data.mx_id }) !== -1) {
                            return '#dc3545';
                        }
                        if(data.lid != 0) return;
                        return '#007bff';
                    }
                },
            },
        ],
        localCache: {
            key: 'changes-spread',
            colWidth: true,
        }
    };

    changeSpreadSetting.getColor = function (sheet, data, row, col, defaultColor) {
        return checkIsSettle(data) ? spreadColor.stage.settle : defaultColor;
    }

    const changeCol = {
        getValue: {
            unit_price: function(data) {
                return ZhCalc.round(data.unit_price, unitPriceUnit);
            },
            oa_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.oamount2, findDecimal(data.unit))), totalPriceUnit);
            },
            ca_tp: function (data) {
                return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.camount, findDecimal(data.unit))), totalPriceUnit);
            },
            oamount2: function (data) {
                return ZhCalc.round(data.oamount2, findDecimal(data.unit));
            },
            camount: function (data) {
                return ZhCalc.round(data.camount, findDecimal(data.unit));
            },
            changed_amount: function (data) {
                return ZhCalc.round(ZhCalc.add(data.oamount2, data.camount), findDecimal(data.unit));
            },
            changed_tp: function (data) {
                return ZhCalc.add(ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.oamount2, findDecimal(data.unit))), totalPriceUnit),
                    ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.camount, findDecimal(data.unit))), totalPriceUnit));
            },
            del_list: function (data) {
                return !_.find(changeUsedData, { cbid: data.id }) && !checkIsSettle(data) ? '移除' : '';
            }
        },
        readOnly: {
            isEdit: function (data) {
                return !readOnly && data.lid != 0;
            },
            isEdit2: function (data) {
                return !readOnly && (data.lid != 0 || (data.lid == 0 && _.findIndex(changeUsedData, { cbid: data.id }) !== -1));
            },
            isEdit3: function (data) {
                return !readOnly && _.findIndex(changeUsedData, { cbid: data.id }) === -1;
            },
            isSettle: function (data) {
                return !readOnly && checkIsSettle(data);
            }
        },
    };
    // 数字只判断几个值（unit_price, oamount, camount）
    const numField = ['unit_price', 'oamount2'];
    const changeSpreadObj = {
        makeSjsFooter: function () {
            // 增加汇总行并设为锁定禁止编辑状态
            changeSpreadSheet.addRows(changeSpreadSheet.getRowCount(), 1);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 0, '合计');
            const cellType1 = new GC.Spread.Sheets.CellTypes.Text();
            changeSpreadSheet.getCell(changeSpreadSheet.getRowCount() - 1, 0).cellType(cellType1);
            changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1);
            changeSpreadObj.countSum();
        },
        countSum: function() {
            const rowCount = changeSpreadSheet.getRowCount();
            let oSum = 0,
                cSum = 0,
                cdSum = 0;
            for(var i = 0; i < rowCount - 1; i++){
                oSum = ZhCalc.add(oSum, changeSpreadSheet.getValue(i, startLimit));
                cSum = ZhCalc.add(cSum, changeSpreadSheet.getValue(i, startLimit + 2));
                cdSum = ZhCalc.add(cdSum, changeSpreadSheet.getValue(i, startLimit + 4));
            }
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit, oSum !== 0 ? oSum : null);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit + 2, cSum !== 0 ? cSum : null);
            changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit + 4, cdSum !== 0 ? cdSum : null);
        },
        add: function () {
            let select = null;
            if (changeOrder) {
                select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            }
            postData(window.location.pathname + '/save', {type: 'add', postData: select ? select.order : null}, function (result) {
                if (result) {
                    if (changeOrder === 1 && select) {
                        // 批量更新changeList的order值
                        _.forEach(changeList, function (item) {
                            item.order = item.order > select.order ? item.order + 1 : item.order;
                        });
                        changeList.splice(select.order, 0, result);
                        changeSpreadSheet.addRows(select.order, 1);
                        SpreadJsObj.reLoadRowData(changeSpreadSheet, select.order);
                        changeSpreadSheet.setSelection(select.order, 0, 1, 1);
                        // console.log(changeList);
                    } else {
                        changeList.push(result);
                        changeSpreadSheet.addRows(changeList.length - 1, 1);
                        SpreadJsObj.reLoadRowData(changeSpreadSheet, changeList.length - 1);
                        changeSpreadSheet.setSelection(changeList.length - 1, 0, 1, 1);
                    }
                    changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1);
                    changeSpreadObj.resetXmjSpread();
                    changeSpreadObj.refreshActn();
                }
            });
        },
        batchAdd: function(num) {
            let select = null;
            if (changeOrder) {
                select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            }
            postData(window.location.pathname + '/save', {type: 'batchadd', num, postData: select ? select.order : null}, function (result) {
                if (result) {
                    changeList = result;
                    SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
                    SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
                    SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                    changeSpreadObj.makeSjsFooter();
                    changeSpreadObj.resetXmjSpread();
                    changeSpreadObj.refreshActn();
                }
            });
        },
        del: function () {
            const selection = changeSpreadSheet.getSelections();
            const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0];
            const row = sel && sel.row !== undefined ? sel.row : -1;
            if (readOnly || row === -1 || sel.row + sel.rowCount > changeList.length) {
                return false;
            }
            const delList = [];
            let lastSelect = null;
            let hadTaiZhang = false;
            for (let r = 0; r < sel.rowCount; r++) {
                const select = changeList[row + r];
                if(!select || _.find(changeUsedData, { cbid: select.id })) {
                    return false;
                }
                if (r === sel.rowCount - 1 && changeOrder) {
                    lastSelect = select;
                }
                if (select.lid != 0) {
                    hadTaiZhang = true;
                }
                delList.push(select.id);
            }
            // console.log(lastSelect, delList);
            if (delList.length) {
                postData(window.location.pathname + '/save', {type: 'del', ids: delList, postData: lastSelect ? lastSelect.order : null}, function (result) {
                    changeList.splice(row, delList.length);
                    changeSpreadSheet.deleteRows(row, delList.length);
                    const sel = changeSpreadSheet.getSelections();
                    changeSpreadSheet.setSelection(0, 0, 1, 1);
                    changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                    if (hadTaiZhang) {
                        tableDataRemake(changeListData);
                    }
                    changeSpreadObj.countSum();
                    changeSpreadObj.refreshActn();
                });
            }
            // const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            // const index = changeList.indexOf(select);
            // if (index > -1 && !_.find(changeUsedData, { cbid: select.id })) {
                // postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
                //     changeList.splice(index, 1);
                //     changeSpreadSheet.deleteRows(index, 1);
                //     const sel = changeSpreadSheet.getSelections();
                //     changeSpreadSheet.setSelection(0, 0, 1, 1);
                //     changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                //     if (select.lid != 0) {
                //         tableDataRemake(changeListData);
                //     }
                //     changeSpreadObj.countSum();
                //     changeSpreadObj.refreshActn();
                // });
            // }
        },
        upMove: function () {
            const data = {
                type: 'changeOrder',
                postData: [],
            };
            const selection = changeSpreadSheet.getSelections();
            const row = selection[0].row, count = selection[0].rowCount;
            const first = changeSpreadSheet.zh_data[row];
            if (!first) {
                changeSpreadObj.refreshActn();
                return false;
            }
            const pre = changeSpreadSheet.zh_data[row - 1], preUpdate = {id: pre.id};
            for (let iRow = 0; iRow < count; iRow++) {
                const posData = changeSpreadSheet.zh_data[iRow + row];
                if (posData) {
                    data.postData.push({id: posData.id, order: changeSpreadSheet.zh_data[iRow + row - 1].order});
                    preUpdate.order = posData.order;
                }
            }
            data.postData.push(preUpdate);
            // console.log(data);
            if (data.postData.length > 0) {
                postData(window.location.pathname + '/save', data, function () {
                    _.forEach(data.postData, function (item) {
                        const cl = _.find(changeList, { id: item.id });
                        cl.order = item.order;
                    });
                    changeList.sort(function (a, b) {
                        return a.order - b.order
                    });
                    SpreadJsObj.reLoadSheetData(changeSpreadSheet);
                    changeSpreadObj.makeSjsFooter();
                    const sel = selection[0];
                    if (sel) {
                        changeSpreadSheet.setSelection(changeSpreadSheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
                    }
                    changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                    changeSpreadObj.refreshActn();
                });
            }
        },
        downMove: function () {
            const data = {
                type: 'changeOrder',
                postData: [],
            };
            const selection = changeSpreadSheet.getSelections();
            const row = selection[0].row, count = selection[0].rowCount;
            const first = changeSpreadSheet.zh_data[row];
            if (!first) {
                changeSpreadObj.refreshActn();
                return false;
            }
            const next = changeSpreadSheet.zh_data[row + count], nextUpdate = {id: next.id};
            for (let iRow = count - 1; iRow >= 0; iRow--) {
                const posData = changeSpreadSheet.zh_data[iRow + row];
                if (posData) {
                    data.postData.push({id: posData.id, order: changeSpreadSheet.zh_data[iRow + row + 1].order});
                    nextUpdate.order = posData.order;
                }
            }
            data.postData.push(nextUpdate);
            // console.log(data);
            if (data.postData.length > 0) {
                postData(window.location.pathname + '/save', data, function () {
                    _.forEach(data.postData, function (item) {
                        const cl = _.find(changeList, { id: item.id });
                        cl.order = item.order;
                    });
                    changeList.sort(function (a, b) {
                        return a.order - b.order
                    });
                    SpreadJsObj.reLoadSheetData(changeSpreadSheet);
                    changeSpreadObj.makeSjsFooter();
                    const sel = selection[0];
                    if (sel) {
                        changeSpreadSheet.setSelection(changeSpreadSheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
                    }
                    changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                    changeSpreadObj.refreshActn();
                });
            }
        },
        resetXmjSpread: function(data = null) {
            const xmj = [];
            if (data && data.lid != 0) {
                const newData = JSON.parse(JSON.stringify(data));
                if (newData.bwmx === newData.xmj_jldy) {
                    newData.bwmx = '';
                }
                xmj.push(newData);
            }
            SpreadJsObj.loadSheetData(xmjSpread.getActiveSheet(), SpreadJsObj.DataType.Data, xmj);
        },
        editStarting: function (e, info) {
            const col = info.sheet.zh_setting.cols[info.col];
            const select = SpreadJsObj.getSelectObject(info.sheet);
            if (col.field === 'camount') {
                if (select.camount_expr && select.camount_expr !== '') {
                    info.sheet.getCell(info.row, info.col).text(select.camount_expr);
                }
            }
        },
        selectionChanged: function (e, info) {
            const sel = info.sheet.getSelections()[0];
            const col = info.sheet.zh_setting.cols[sel.col];
            const data = SpreadJsObj.getSelectObject(info.sheet);
            if (col && col.field === 'del_list' && data && !_.find(changeUsedData, { cbid: data.id }) && !checkIsSettle(data)) {
                changeSpreadObj.del();
            }
            if (col && col.field === 'camount' && data) {
                $('#camount-expr').removeAttr('readonly').val(data.camount_expr ? data.camount_expr : data.camount);
            } else {
                $('#camount-expr').attr('readonly', true).val('');
            }
            changeSpreadObj.resetXmjSpread(data);
            changeSpreadObj.refreshActn();
        },
        refreshActn: function (rowCount = 1) {
            const setObjEnable = function (obj, enable) {
                if (enable) {
                    obj.removeClass('disabled');
                } else {
                    obj.addClass('disabled');
                }
            };
            // const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            // 还需判断是否已被调差清单调用
            const selection = changeSpreadSheet.getSelections();
            const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0];
            const row = sel ? sel.row : -1;
            const first = changeList[row];
            let last = first;
            if (sel.rowCount > 1 && first) {
                for (let r = 1; r < sel.rowCount; r++) {
                    const rNode = changeList[sel.row + r];
                    if (!rNode) break;
                    last = rNode;
                }
            }
            const preNode = changeList[row - 1];

            setObjEnable($('#up-move'), !readOnly && first && preNode && changeList.indexOf(last) > 0 && sel.row + sel.rowCount <= changeList.length);
            setObjEnable($('#down-move'), !readOnly && first && changeList.indexOf(last) < changeList.length - 1 && sel.row + sel.rowCount <= changeList.length);
            // setObjEnable($('#open-list-modal'), !readOnly && select && changeList.indexOf(select) !== -1);
            // setObjEnable($('#add-white-btn'), !readOnly && select && changeList.indexOf(select) !== -1);
        },
        deletePress: function (sheet) {
            if (!sheet.zh_setting) return;
            // 暂时仅支持移除数量
            const sel = sheet.getSelections()[0], datas = [];
            for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
                let bDel = false;
                const node = sheet.zh_data[iRow];
                for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
                    const col = sheet.zh_setting.cols[iCol];
                    if (col.field === 'camount' || col.field === 'oamount2') {
                        node[col.field] = null;
                        if (col.field === 'camount') {
                            node.camount_expr = '';
                            node.spamount = null;
                        }
                        delete node.waitingLoading;
                        bDel = true;
                    }
                }
                if (bDel) datas.push(node);
            }
            if (datas.length > 0) {
                postData(window.location.pathname + '/save', { type:'paste', updateData: datas }, function (result) {
                    changeList = result;
                    SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                    changeSpreadObj.makeSjsFooter();
                    changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                }, function () {
                    SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
                    return;
                });
            }
            return;
        },
        editEnded: function (e, info) {
            if (info.sheet.zh_setting) {
                const select = SpreadJsObj.getSelectObject(info.sheet);
                const col = info.sheet.zh_setting.cols[info.col];
                if (col.field === 'del_list' || col.field === 'is_valuation') {
                    return;
                }
                let validText = is_numeric(info.editingText) && _.indexOf(numField, col.field) !== -1 ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : '');
                let orgValue;
                if (col.field === 'camount') {
                    orgValue = validText && validText !== ''
                        ? (_.toNumber(validText) ? select.camount : select.camount_expr)
                        : (select.camount_expr && select.camount_expr !== '' ? select.camount_expr : select.camount);
                } else {
                    orgValue = select[col.field];
                }
                if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) {
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    return;
                }
                // // 未改变值则不提交
                // let validText = is_numeric(info.editingText) && _.indexOf(numField, col.field) !== -1 ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : '');
                // const orgValue = select[col.field];
                // if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
                //     SpreadJsObj.reLoadRowData(info.sheet, info.row);
                //     return;
                // }
                // 判断部分值是否输入的是数字判断和数据计算
                if(col.field === 'camount') {
                    const exprQuantity = {
                        expr: '',
                        quantity: 0,
                    };
                    const [valid, msg] = changeSpreadObj._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;
                    }
                    validText = parseFloat(exprQuantity.quantity);
                    // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改
                    const usedInfo = _.find(changeUsedData, { cbid: select.id });
                    if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) {
                        toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty);
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    } else if (usedInfo && usedInfo.qty < 0  && validText > usedInfo.qty) {
                        toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty);
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    select.spamount = ZhCalc.round(validText, findDecimal(select.unit)) || 0;
                    select.camount_expr = exprQuantity.expr;
                }
                if (col.type === 'Number') {
                    if (isNaN(validText)) {
                        toastr.error('不能输入其它非数字类型字符');
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                        return;
                    }
                    if (col.field === 'unit_price') {
                        validText = ZhCalc.round(validText, unitPriceUnit);
                    } else {
                        validText = ZhCalc.round(validText, findDecimal(select.unit)) || 0;
                    }
                    if (col.field === 'delimit') {
                        const reg = /^(\d{1,2}|100)$/;
                        if (!(_.isNumber(validText) && reg.test(validText))) {
                            toastr.error('计量上限默认值只能输入0-100之间的整数');
                            SpreadJsObj.reLoadRowData(info.sheet, info.row);
                            return;
                        }
                        // 需要判断是否已调用，已调用的则不能低于原有值大小
                        const usedInfo = _.find(changeUsedData, { cbid: select.id });
                        if (usedInfo && usedInfo.qty) {
                            const minLimit = Math.ceil(ZhCalc.mul(ZhCalc.div(usedInfo.qty, select.camount), 100));
                            if (validText < minLimit) {
                                toastr.error('计量上限值至少大于等于 ' + minLimit);
                                SpreadJsObj.reLoadRowData(info.sheet, info.row);
                                return;
                            }
                        }
                    }
                }
                if (col.field === 'unit') {
                    select.camount = ZhCalc.round(select.camount, findDecimal(validText)) || 0;
                    select.oamount2 = ZhCalc.round(select.oamount2, findDecimal(validText)) || 0;
                }
                select[col.field] = validText;
                // console.log(select);
                delete select.waitingLoading;

                // 更新至服务器
                postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
                    changeList.splice(info.row, 1, select);
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    changeSpreadObj.countSum();
                }, function () {
                    select[col.field] = orgValue;
                    if(col.field === 'camount') {
                        select.spamount = orgValue;
                    }
                    SpreadJsObj.reLoadRowData(info.sheet, info.row);
                });
            }
        },
        clipboardPasted(e, info) {
            const hint = {
                cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
                numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
            };
            const range = info.cellRange;
            const sortData = info.sheet.zh_data || [];
            if (range.row + range.rowCount > sortData.length) {
                toastMessageUniq(hint.cellError);
                // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
                SpreadJsObj.reLoadSheetHeader(changeSpreadSheet);
                SpreadJsObj.reLoadSheetData(changeSpreadSheet);
                changeSpreadObj.makeSjsFooter();
                return;
            }
            if (sortData.length > 0 && range.col + range.colCount > 14) {
                toastMessageUniq(hint.cellError);
                SpreadJsObj.reLoadSheetHeader(changeSpreadSheet);
                SpreadJsObj.reLoadSheetData(changeSpreadSheet);
                changeSpreadObj.makeSjsFooter();
                return;
            }
            const data = [];
            // const rowData = [];
            let needCopyIgnore = !$('#customCheck1').is(':checked');
            let needColAdd = false;
            for (let iRow = 0; iRow < range.rowCount; iRow++) {
                let bPaste = true;
                const curRow = range.row + iRow;
                // const materialData = JSON.parse(JSON.stringify(sortData[curRow]));
                const cLData = { id: sortData[curRow].id };
                const hintRow = range.rowCount >= 1 ? curRow : '';
                let sameCol = 0;
                for (let iCol = 0; iCol < range.colCount; iCol++) {
                    const curCol = range.col + iCol;
                    let colSetting = info.sheet.zh_setting.cols[curCol];
                    if ((needColAdd && curCol > 6) || (needCopyIgnore && curCol === 6)) { // 要判断是否已隐藏了变更详情，是则变更详情后面的curCol要+1
                        const newCurCol = curCol + 1;
                        needColAdd = true;
                        colSetting = info.sheet.zh_setting.cols[newCurCol];
                    }
                    if (!colSetting) continue;

                    let validText = info.sheet.getText(curRow, curCol);
                    validText = is_numeric(validText) && _.indexOf(numField, colSetting.field) !== -1 ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : '');
                    let orgValue;
                    if (colSetting.field === 'camount') {
                        orgValue = validText && validText !== ''
                            ? (_.toNumber(validText) ? sortData[curRow].camount : sortData[curRow].camount_expr)
                            : (sortData[curRow].camount_expr && sortData[curRow].camount_expr !== '' ? sortData[curRow].camount_expr : sortData[curRow].camount);
                    } else {
                        orgValue = sortData[curRow][colSetting.field];
                    }
                    if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
                        sameCol++;
                        if (range.colCount === sameCol)  {
                            bPaste = false;
                        }
                        continue;
                    }

                    if(colSetting.field === 'camount') {
                        const exprQuantity = {
                            expr: '',
                            quantity: 0,
                        };
                        const [valid, msg] = changeSpreadObj._checkExpr(validText, exprQuantity);
                        if (!valid) {
                            toastMessageUniq(getPasteHint(msg, hintRow));
                            bPaste = false;
                            continue;
                        }
                        if (isNaN(exprQuantity.quantity)) {
                            toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
                            bPaste = false;
                            continue;
                        }
                        validText = parseFloat(exprQuantity.quantity);
                        // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改
                        const usedInfo = _.find(changeUsedData, { cbid: sortData[curRow].id });
                        if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) {
                            toastr.error(hintRow ? '清单第' + (hintRow+1) + '行变更数值必须大于等于已调用值 ' + usedInfo.qty : '清单变更数值必须大于等于已调用值 ' + usedInfo.qty);
                            bPaste = false;
                            continue;
                        } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) {
                            toastr.error(hintRow ? '清单第' + (hintRow+1) + '行变更数值必须小于等于已调用值 ' + usedInfo.qty : '清单变更数值必须小于等于已调用值 ' + usedInfo.qty);
                            bPaste = false;
                            continue;
                        }
                        cLData.camount_expr = exprQuantity.expr;
                        sortData[curRow].camount_expr = exprQuantity.expr;
                    }
                    if (colSetting.type === 'Number') {
                        if (isNaN(validText)) {
                            toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
                            bPaste = false;
                            continue;
                        }
                        if (colSetting.field === 'unit_price') {
                            validText = ZhCalc.round(validText, unitPriceUnit);
                        } else {
                            validText = ZhCalc.round(validText, findDecimal(sortData[curRow].unit)) || 0;
                        }
                        if (colSetting.field === 'delimit') {
                            const reg = /^(\d{1,2}|100)$/;
                            if (!(_.isNumber(validText) && reg.test(validText))) {
                                toastr.error('清单第' + (hintRow+1) + '行计量上限默认值只能粘贴0-100之间的整数');
                                bPaste = false;
                                continue;
                            }
                            // 需要判断是否已调用，已调用的则不能低于原有值大小
                            const usedInfo = _.find(changeUsedData, { cbid: sortData[curRow].id });
                            if (usedInfo && usedInfo.qty) {
                                const minLimit = Math.ceil(ZhCalc.mul(ZhCalc.div(usedInfo.qty, sortData[curRow].camount), 100));
                                if (validText < minLimit) {
                                    toastr.error('清单第' + (hintRow+1) + '行计量上限值至少大于等于 ' + minLimit);
                                    bPaste = false;
                                    continue;
                                }
                            }
                        }
                    }
                    let unitdecimal = validText;
                    if (colSetting.field === 'unit') {
                        //粘贴内容要为下拉列表里所有的单位，不然为空
                        if (changeUnits.indexOf(validText) === -1) {
                            unitdecimal = '';
                        }
                        cLData.camount = ZhCalc.round(sortData[curRow].camount, findDecimal(unitdecimal)) || 0;
                        cLData.oamount2 = ZhCalc.round(sortData[curRow].oamount2, findDecimal(unitdecimal)) || 0;
                    }
                    if (colSetting.field !== 'oa_tp' && colSetting.field !== 'ca_tp') {
                        cLData[colSetting.field] = validText;
                        sortData[curRow][colSetting.field] = validText;
                    }
                    cLData.spamount = ZhCalc.round(sortData[curRow].camount, findDecimal(unitdecimal)) || 0;
                }
                if (bPaste) {
                    data.push(cLData);
                    // rowData.push(curRow);
                } else {
                    SpreadJsObj.reLoadRowData(info.sheet, curRow);
                }
            }
            if (data.length === 0) {
                SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
                return;
            }
            // console.log(data);
            // 更新至服务器
            postData(window.location.pathname + '/save', { type:'paste', updateData: data }, function (result) {
                changeList = result;
                SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                changeSpreadObj.makeSjsFooter();
                changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
            }, function () {
                SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
                return;
            });
        },
        buttonClicked: function (e, info) {
            if (info.sheet.zh_setting) {
                const select = SpreadJsObj.getSelectObject(info.sheet);
                const col = info.sheet.zh_setting.cols[info.col];
                if (col.field === 'is_valuation') {
                    if (info.sheet.isEditing()) {
                        info.sheet.endEdit(true);
                    }
                    if (_.findIndex(changeUsedData, { cbid: select.id }) !== -1) {
                        return;
                    }
                    select.is_valuation = info.sheet.getValue(info.row, info.col) ? 0 : 1;
                    delete select.waitingLoading;
                    // 更新至服务器
                    postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
                        changeList.splice(info.row, 1, select);
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    }, function () {
                        select.is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0;
                        SpreadJsObj.reLoadRowData(info.sheet, info.row);
                    });
                }
            }
        },
        valueChanged(e, info) {
            // 防止ctrl+z撤销数据
            SpreadJsObj.reLoadRowData(info.sheet, info.row);
        },
        setAllValuation(is_valuation) {
            if (changeList.length === 0) {
                toastr.warning('暂无清单无法设置清单计价');
                return;
            }
            const needChangeList = _.filter(changeList, { is_valuation: is_valuation ? 0 : 1 });
            if (needChangeList.length === 0) {
                toastr.warning('全部清单已设置清单'+ (is_valuation ? '' : '不') +'计价');
                return;
            }
            const realNeedChangeList = [];
            for (const nc of needChangeList) {
                if (_.findIndex(changeUsedData, { cbid: nc.id }) === -1) {
                    realNeedChangeList.push(nc.id);
                }
            }
            if (realNeedChangeList.length === 0) {
                toastr.warning('全部清单已设置清单'+ (is_valuation ? '' : '不') +'计价');
                return;
            }
            postData(window.location.pathname + '/save', { type:'set_all_valuation', ids: realNeedChangeList, is_valuation }, function (result) {
                changeList = result;
                SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                changeSpreadObj.makeSjsFooter();
                changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
            });
        },
        _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].type === 'num') {
                    param[1].value = '-' + param[1].value;
                    param.shift();
                }
            }
            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.replace(new RegExp('%', 'gm'), '/100'));
                    // const ce = new CalcEvalMin();
                    // data.quantity = ce.eval(expr);
                    // console.log(data.quantity);
                }
            } else {
                data.quantity = 0;
                data.expr = '';
            }
            return [true, ''];
        },
    };

    const preUrl = window.location.pathname.split('/').slice(0, 4).join('/');
    let changeListData;
    let gclGatherData;
    postData(preUrl + '/defaultBills', {}, function (result) {
        gclGatherModel.loadLedgerData(result.bills);
        gclGatherModel.loadPosData(result.pos);
        ledgerList = result.bills;
        posList = result.pos;
        $('#change-ai-model').data('ledger-context', result.aiLedger);

        gclGatherData = gclGatherModel.gatherGclData();
        gclGatherData = _.filter(gclGatherData, function (item) {
            return item.leafXmjs && item.leafXmjs.length !== 0;
        });
        for (const ggd in gclGatherData) {
            if (gclGatherData[ggd].leafXmjs && gclGatherData[ggd].leafXmjs.length === 0) {
                gclGatherData.splice(ggd, 1);
            }
            gclGatherData[ggd].code = gclGatherData[ggd].b_code;
            let hadcid = 0;
            for (const xmj of gclGatherData[ggd].leafXmjs) {
                const changeLedger = _.find(changeLedgerList, { id: xmj.gcl_id });
                const changePos = _.find(changePosList, { id: xmj.mx_id, lid: xmj.gcl_id });
                if (changeLedger || changePos) {
                    xmj.cid = 1;
                    xmj.ccid = changeLedger ? changeLedger.ccid : changePos.ccid;
                    hadcid = 1;
                }
            }

            if (hadcid !== 0) gclGatherData[ggd].cid = 1;
        }
        // console.log(gclGatherData);
        // 数组去重
        const dealBillList = result.dealBills;
        for (const db of gclGatherData) {
            const exist_index = dealBillList.findIndex(function (item) {
                return item.code === db.code && item.name === db.name && item.unit === db.unit && item.unit_price === db.unit_price;
            });
            if (exist_index !== -1) {
                dealBillList.splice(exist_index, 1);
            }
        }
        changeListData = gclGatherData.concat(dealBillList).sort(sortByCode);
        tableDataRemake(changeListData);
        console.log(changeListData);
        const updateOrderList = setUpdateOrder();
        if (updateOrderList.length > 0) {
            postData(window.location.pathname + '/save', { type:'changeOrder', postData: updateOrderList }, function (result) {
            });
        }

        // 默认模式
        SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
        SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
        SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
        // changeSpreadSheet.options.protectionOptions = {
        //     allowSort: true,
        //     allowFilter: true
        // };
        // var option = changeSpreadSheet.options.protectionOptions;
        // changeSpreadSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, changeSpreadSetting.cols.length)));
        // // changeSpreadSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, 3)));
        // const filter = changeSpreadSheet.rowFilter();
        // filter.filterButtonVisible(false);
        // filter.filterButtonVisible(0, true);
        // filter.filterButtonVisible(2, true);
        // filter.filterDialogVisibleInfo({
        //     sortByValue: true,         //SortByValue item is visible.
        //     sortByColor: false,          //SortByColor item is visible.
        //     filterByColor: false,        //FilterByColor item is visible.
        //     filterByValue: false,        //FilterByValue item is visible.
        //     listFilterArea: false       //ListFilterArea item is visible.
        // });
        // function compareList(obj1, obj2) {
        //     console.log(obj1, obj2);
        //     var list = ["", '204-1-b', '合计'];
        //     var index1 = list.indexOf(obj1), index2 = list.indexOf(obj2);
        //     if (index1 > index2) {
        //         return 1;
        //     } else if (index1 < index2) {
        //         return -1;
        //     } else {
        //         return 0;
        //     }
        // }
        // changeSpreadSheet.sortRange(0, 0, changeSpreadSetting.cols.length, 1, true, [{index: 0, ascending: true, compareFunction: compareList}]);
        // changeSpreadSheet.bind(GC.Spread.Sheets.Events.RangeSorting, function (e, info) {
        //     info.compareFunction = compareList;
        // });
        // filter.sortColumn(0, true);
        changeSpreadObj.makeSjsFooter();
        changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
        changeSpreadObj.refreshActn();
    });

    function setUpdateOrder(newOrder = changeOrder) {
        // 先加载台账数据
        const newChangeList = [];
        for (const gcl of changeListData) {
            if (!newOrder) {
                if (gcl.leafXmjs !== undefined && gcl.leafXmjs !== null) {
                    const cl = _.filter(changeList, function (item) {
                        return _.findIndex(gcl.leafXmjs, { gcl_id: item.gcl_id }) !== -1;
                    });
                    if (cl.length > 0) {
                        for (const l of gcl.leafXmjs) {
                            const c = _.find(cl, { gcl_id: l.gcl_id, mx_id: l.mx_id || '' });
                            if (c) newChangeList.push(c);
                        }
                    }
                } else {
                    // 签约清单
                    const c = _.find(changeList, { lid: gcl.id });
                    if (c) newChangeList.push(c);
                }
            }
        }
        const updateOrderList = [];
        // 按台账去重新排序changeList，空白清单居后
        if (!newOrder) {
            const sycList = _.difference(changeList, newChangeList);
            changeList = newChangeList.concat(sycList);
            // order如果不同，则修改并提交
            for (let i = 0; i < changeList.length; i++) {
                if (changeList[i].order !== i + 1) {
                    changeList[i].order = i + 1;
                    updateOrderList.push({ id: changeList[i].id, order: i + 1 });
                }
            }
        }
        return updateOrderList;
    }

    if (!readOnly) {
        $('#add-white-btn').click(changeSpreadObj.add);
        $('#up-move').click(changeSpreadObj.upMove);
        $('#down-move').click(changeSpreadObj.downMove);
        changeSpread.bind(spreadNS.Events.EditEnded, changeSpreadObj.editEnded);
        changeSpread.bind(spreadNS.Events.EditStarting, changeSpreadObj.editStarting);
        changeSpread.bind(spreadNS.Events.SelectionChanged, changeSpreadObj.selectionChanged);
        changeSpread.bind(spreadNS.Events.ClipboardPasted, changeSpreadObj.clipboardPasted);
        changeSpread.bind(spreadNS.Events.ValueChanged, changeSpreadObj.valueChanged);
        changeSpread.bind(spreadNS.Events.ButtonClicked, changeSpreadObj.buttonClicked);
        SpreadJsObj.addDeleteBind(changeSpread, changeSpreadObj.deletePress);
        changeSpreadSheet.getCell(-1, startLimit + 5).foreColor('#dc3545');
        const delCommand = {
            canUndo: false,
            execute: function (context, options, isUndo) {
                const Commands = GC.Spread.Sheets.Commands;
                const sel = changeSpreadSheet.getSelections()[0];
                const col = changeSpreadSheet.zh_setting.cols[sel.col];
                if (col && col.field !== 'sa_tp') {
                    isUndo = true;
                }
                if (isUndo) {
                    Commands.undoTransaction(context, options);
                    return true;
                } else {
                    Commands.startTransaction(context, options);

                    Commands.endTransaction(context, options);
                    return true;
                }
            }
        };
        const delCommand2 = {
            canUndo: false,
            execute: function (context, options, isUndo) {
                const Commands = GC.Spread.Sheets.Commands;
                const sel = changeSpreadSheet.getSelections()[0];
                const col = changeSpreadSheet.zh_setting.cols[sel.col];
                if (col && col.field !== 'del_list') {
                    isUndo = true;
                }
                if (isUndo) {
                    Commands.undoTransaction(context, options);
                    return true;
                } else {
                    Commands.startTransaction(context, options);

                    Commands.endTransaction(context, options);
                    return true;
                }
            }
        };
        const commandManager = changeSpread.commandManager();
        commandManager.register('banDel', delCommand);
        commandManager.register('banDel2', delCommand2);
        commandManager.register('banDel3', _.cloneDeep(delCommand2));// 不能共用banDel2
        commandManager.setShortcutKey('banDel', 39, false, false, false, false);// 改写键盘右键，防止删除清单
        commandManager.setShortcutKey('banDel2', 40, false, false, false, false);// 改写键盘下键，防止删除清单
        commandManager.setShortcutKey('banDel3', 38, false, false, false, false);// 改写键盘上键，防止删除清单
        let batchInsertObj;
        $.contextMenu.types.batchInsert = function (item, opt, root) {
            const self = this;
            if ($.isFunction(item.icon)) {
                item._icon = item.icon.call(this, this, $t, key, item);
            } else {
                if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
                    // to enable font awesome
                    item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
                } else {
                    item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
                }
            }
            this.addClass(item._icon);
            const $obj = $('<div>' + item.name + '<input class="text-right ml-1 mr-1" type="tel" max="100" min="1" value="' + item.value + '" style="width: 30px; height: 18px; padding-right: 4px;">行</div>')
                .appendTo(this);
            const $input = $obj.find('input');
            const event = () => {
                if (self.hasClass('context-menu-disabled')) return;
                item.batchInsert($input[0], root);
            };
            $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }});
            $input.click((e) => {e.stopPropagation();})
                .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);})
                .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');});
        };

        // 右键菜单
        $.contextMenu({
            selector: '#change-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, changeSpread);
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                'createList': {
                    name: '添加台账清单',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 0;
                    },
                    callback: function (key, opt) {
                        // $('#addlist').modal('show');
                        $('#set-site-btn').click();
                    },
                },
                'createAdd': {
                    name: '添加空白清单',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 0 && openChangeWhiteList;
                    },
                    callback: function (key, opt) {
                        changeSpreadObj.add(changeSpreadSheet);
                    },
                },
                'batchInsert': {
                    name: '批量添加空白清单',
                    type: 'batchInsert',
                    value: '2',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 0 && openChangeWhiteList;
                    },
                    batchInsert: function (obj, root) {
                        if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
                            obj.value = obj.max;
                            toastr.warning('批量添加不可多于' + obj.max);
                        } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
                            obj.value = obj.min;
                            toastr.warning('批量添加不可少于' + obj.min);
                        } else {
                            // treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
                            changeSpreadObj.batchAdd(obj.value);
                            root.$menu.trigger('contextmenu:hide');
                        }
                    },
                },
                'createList1': {
                    name: '插入台账清单',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 1;
                    },
                    // disabled: function (key, opt) {
                    //     const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
                    //     const sel = changeSpreadSheet.getSelections()[0];
                    //     changeSpreadObj.resetXmjSpread(select);
                    //     // console.log(select, sel);
                    //     if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) {
                    //         return false;
                    //     } else {
                    //         return true;
                    //     }
                    // },
                    callback: function (key, opt) {
                        // $('#addlist').modal('show');
                        $('#set-site-btn').click();
                    },
                },
                'createAdd1': {
                    name: '插入空白清单',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 1 && openChangeWhiteList;
                    },
                    // disabled: function (key, opt) {
                    //     const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
                    //     const sel = changeSpreadSheet.getSelections()[0];
                    //     changeSpreadObj.resetXmjSpread(select);
                    //     // console.log(select, sel);
                    //     if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) {
                    //         return false;
                    //     } else {
                    //         return true;
                    //     }
                    // },
                    callback: function (key, opt) {
                        changeSpreadObj.add(changeSpreadSheet);
                    },
                },
                'batchInsert1': {
                    name: '批量插入空白清单',
                    type: 'batchInsert',
                    value: '2',
                    icon: 'fa-sign-in',
                    visible: function () {
                        return changeOrder === 1 && openChangeWhiteList;
                    },
                    // disabled: function (key, opt) {
                    //     const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
                    //     const sel = changeSpreadSheet.getSelections()[0];
                    //     changeSpreadObj.resetXmjSpread(select);
                    //     // console.log(select, sel);
                    //     if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) {
                    //         return false;
                    //     } else {
                    //         return true;
                    //     }
                    // },
                    batchInsert: function (obj, root) {
                        if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
                            obj.value = obj.max;
                            toastr.warning('批量插入不可多于' + obj.max);
                        } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
                            obj.value = obj.min;
                            toastr.warning('批量插入不可少于' + obj.min);
                        } else {
                            // treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
                            changeSpreadObj.batchAdd(obj.value);
                            root.$menu.trigger('contextmenu:hide');
                        }
                    },
                },
                'delete': {
                    name: '删除',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        changeSpreadObj.del(changeSpreadSheet);
                    },
                    disabled: function (key, opt) {
                        // const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
                        // const sel = changeSpreadSheet.getSelections()[0];
                        // changeSpreadObj.resetXmjSpread(select);
                        // // console.log(select, sel);
                        // if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1 && !_.find(changeUsedData, { cbid: select.id })) {
                        //     return false;
                        // } else {
                        //     return true;
                        // }
                        const selection = changeSpreadSheet.getSelections();
                        const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0];
                        const row = sel && sel.row !== undefined ? sel.row : -1;
                        if (readOnly || row === -1 || sel.row + sel.rowCount > changeList.length) {
                            return true;
                        }
                        let isUsed = false;
                        for (let r = 0; r < sel.rowCount; r++) {
                            const select = changeList[row + r];
                            if(!select || _.find(changeUsedData, { cbid: select.id })) {
                                isUsed = true;
                            }
                        }
                        return isUsed;
                    }
                },
                sprEdit: '----',
                'allNotValuation': {
                    name: '设置全部清单不计价',
                    icon: 'fa-magic',
                    callback: function (key, opt) {
                        changeSpreadObj.setAllValuation(0);
                    },
                },
                'allValuation': {
                    name: '设置全部清单计价',
                    icon: 'fa-magic',
                    callback: function (key, opt) {
                        changeSpreadObj.setAllValuation(1);
                    },
                },

            }
        });

        // 表达式判断
        $('#camount-expr').change(function () {
            if (this.readOnly) return;
            let validText = $(this).val();
            const sel = changeSpreadSheet.getSelections()[0];
            const row = sel ? sel.row : -1;
            const col = changeSpreadSheet.zh_setting.cols[sel.col];
            if (row === -1 || !(col && col.field === 'camount')) return;
            const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            if (!select) return;
            validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : '');
            let orgValue = validText && validText !== ''
                    ? (_.toNumber(validText) ? select.camount : select.camount_expr)
                    : (select.camount_expr && select.camount_expr !== '' ? select.camount_expr : select.camount);
            const orgExprValue = _.clone(select.camount_expr);
            if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) {
                return;
            }
            const exprQuantity = {
                expr: '',
                quantity: 0,
            };
            const [valid, msg] = changeSpreadObj._checkExpr(validText, exprQuantity);
            if (!valid) {
                toastr.error(msg);
                $(this).val(select.camount_expr ? select.camount_expr : select.camount);
                return;
            }
            if (isNaN(exprQuantity.quantity)) {
                toastr.error('不能输入其它非数字类型字符');
                $(this).val(select.camount_expr ? select.camount_expr : select.camount);
                return;
            }
            validText = parseFloat(exprQuantity.quantity);
            // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改
            const usedInfo = _.find(changeUsedData, { cbid: select.id });
            if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) {
                toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty);
                $(this).val(select.camount_expr ? select.camount_expr : select.camount);
                return;
            } else if (usedInfo && usedInfo.qty < 0  && validText > usedInfo.qty) {
                toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty);
                $(this).val(select.camount_expr ? select.camount_expr : select.camount);
                return;
            }
            select.spamount = ZhCalc.round(validText, findDecimal(select.unit)) || 0;
            select.camount_expr = exprQuantity.expr;
            select.camount = validText;
            // console.log(select);
            delete select.waitingLoading;

            // 更新至服务器
            postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
                changeList.splice(row, 1, select);
                SpreadJsObj.reLoadRowData(changeSpreadSheet, row);
                changeSpreadObj.countSum();
            }, function () {
                select.camount = orgValue;
                select.camount_expr = orgExprValue;
                select.spamount = orgValue;
                SpreadJsObj.reLoadRowData(changeSpreadSheet, row);
            });
        });
    }

    // 清单选中和移除
    $('body').on('click', '#table-list-select tr', function () {
        searchCodeList = [];
        $('#table-list-select tr').removeClass('table-warning');
        $(this).addClass('table-warning');
        const isCheck = $(this).hasClass('table-success') ? true : false;
        const data_bwmx = $(this).attr('data-bwmx').split('$#$');
        const data_charu = $(this).attr('data-charu') ? $(this).attr('data-charu').split('$#$') : [];
        const isDeal = $(this).data('gcl') !== undefined ? true : false;
        let codeHtml = '<tr quantity="'+ $(this).children('td').eq(5).text() +'" gcl_id="" mx_id=""><td class="text-center">1</td><td colspan="7" class="colspan_1">&nbsp;</td><td class="colspan_2 text-center"><input type="checkbox"></td></tr>';
        // console.log(isDeal, isCheck);
        if (isDeal) {
            const lid = $(this).data('lid');
            let gcl = _.find(gclGatherData, function (item) {
                return item.leafXmjs && item.leafXmjs[0].gcl_id === lid;
            });
            if (!gcl) {
                gcl = gclGatherData[$(this).data('gcl')];
            }
            codeHtml = '';
            for (const [index, leaf] of gcl.leafXmjs.entries()) {
                const quantity = leaf.quantity !== undefined && leaf.quantity !== null ? leaf.quantity : 0;
                const gcl_id = leaf.gcl_id ? leaf.gcl_id : '';
                const mx_id = leaf.mx_id ? leaf.mx_id : '';
                const bwmx = leaf.bwmx !== undefined ? leaf.bwmx : undefined;
                const pushMsg = leaf.code + '!_!' + (leaf.jldy ? leaf.jldy : '') + '!_!' +
                    (leaf.dwgc ? leaf.dwgc : '') + '!_!' + (leaf.fbgc ? leaf.fbgc : '') + '!_!' + (leaf.fxgc ? leaf.fxgc : '')
                    + '!_!' + (leaf.gcl_id ? leaf.gcl_id : '0') + '!_!' + (leaf.mx_id ? leaf.mx_id : '') + '!_!' +
                    (bwmx !== undefined ? bwmx : leaf.jldy ? leaf.jldy : '') + '*;*' + quantity;
                const isChecked = data_bwmx.indexOf(pushMsg) !== -1 && isCheck ? 'checked ' : '';
                const existGcl = _.find(changeList, {gcl_id: leaf.gcl_id, bwmx: (bwmx ? bwmx : leaf.jldy ? leaf.jldy : ''), oamount: leaf.quantity});
                const isUsed = existGcl ? _.find(changeUsedData, { cbid: existGcl.id }) : null;
                const isOldChaRu = changeOrder && isChecked && data_charu.indexOf(pushMsg) === -1;
                const isDisabled = isUsed || isOldChaRu || (leaf.settle_status === settleStatus.finish && !isChecked) ? 'disabled ' : '';
                const bgColor = leaf.settle_status === settleStatus.finish ? 'style="background-color: ' + spreadColor.stage.settle + '"' : '';
                codeHtml += '<tr quantity="' + quantity + '" gcl_id="' + gcl_id + '" mx_id="' + mx_id + '"' + bgColor + '>' +
                    '<td class="text-center">' + (index+1) + (leaf.cid ? '<i class="text-danger" style="font-weight: 900">*</i>' : '') + '</td>' +
                    '<td>' + leaf.code + '</td>' +
                    '<td>' + (leaf.jldy ? leaf.jldy: '') + '</td>' +
                    '<td>' + (leaf.dwgc ? leaf.dwgc : '') + '</td>' +
                    '<td>' + (leaf.fbgc ? leaf.fbgc : '') + '</td>' +
                    '<td>' + (leaf.fxgc ? leaf.fxgc : '') + '</td>' +
                    '<td>' + (bwmx !== undefined ? bwmx : '') + '</td>' +
                    '<td class="text-right">' + (ZhCalc.round(quantity, findDecimal(gcl.unit)) ? ZhCalc.round(quantity, findDecimal(gcl.unit)) : 0) + '</td>' +
                    '<td class="text-center"><input type="checkbox" ' + isDisabled + isChecked +
                    '></td></tr>';
                searchCodeList.push(leaf.code + '|!|' + (leaf.jldy ? leaf.jldy: '') + '|!|' + (bwmx !== undefined ? bwmx : ''));
            }
        } else if (!isDeal && isCheck) {
            const pushMsg = '0*;*' + $(this).children('td').eq(5).text();
            const isChecked = data_bwmx.indexOf(pushMsg) !== -1 && isCheck ? 'checked ' : '';
            const isDisabeld = (changeOrder && isChecked && data_charu.indexOf(pushMsg) === -1) ? 'disabled ' : '';
            codeHtml = '<tr quantity="'+ $(this).children('td').eq(5).text() +'" gcl_id="" mx_id=""><td class="text-center">1</td><td colspan="7" class="colspan_1">&nbsp;</td><td class="colspan_2 text-center"><input type="checkbox" ' + isChecked + isDisabeld +'></td></tr>';
        }
        $('#code-list').attr('data-index', parseInt($(this).children('td').eq(0).text()));
        $('#code-input').val('');
        $('#code-input').siblings('a').hide();
        $('#code-list').html(codeHtml);
        checkSelectAll();
    });

    // 右边项目节选择
    $('body').on('click', '#code-list input', function () {
        let index = $('#code-list').attr('data-index');
        // 判断是否是自定义排序，是则另外保存一份到tr中，和data-bwmx不相通，最后提交再清除所有的data-charu清单
        if ($(this).is(':checked')) {
            // 去除其它可能已选的checked
            // $('#code-list input').prop('checked', false);
            $(this).prop('checked', true);
            // 左边表单传值并添加class
            $('#table-list-select tr[data-index="' + index + '"]').addClass('table-success');
            // 去除部分data-detail值
            let data_bwmx = [];
            let data_charu = [];
            $('#code-list input:checked').each(function () {
                const tr = $(this).parents('tr');
                const length = tr.children('td').length;
                const gcl_id = tr.attr('gcl_id');
                const mx_id = tr.attr('mx_id');
                const bwmx = length === 9 ?
                    tr.children('td').eq(1).text() + '!_!' +
                    tr.children('td').eq(2).text() + '!_!' +
                    tr.children('td').eq(3).text() + '!_!' +
                    tr.children('td').eq(4).text() + '!_!' +
                    tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' +
                    (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0';
                const quantity = tr.attr('quantity');
                const de_qu = bwmx + '*;*' + quantity;
                data_bwmx.push(de_qu);
                if (changeOrder && $(this).prop('disabled') !== true) {
                    data_charu.push(de_qu);
                }
            });
            data_bwmx = data_bwmx.join('$#$');
            $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx);
            if (changeOrder) {
                data_charu = data_charu.join('$#$');
                $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu);
            }
        } else {
            // 判断还有无选中项目节编号
            if ($('#code-list input').is(':checked')) {
                // 去除部分data-detail值
                let data_bwmx = [];
                let data_charu = [];
                $('#code-list input:checked').each(function () {
                    const tr = $(this).parents('tr');
                    const length = tr.children('td').length;
                    const gcl_id = tr.attr('gcl_id');
                    const mx_id = tr.attr('mx_id');
                    const bwmx = length === 9 ?
                        tr.children('td').eq(1).text() + '!_!' +
                        tr.children('td').eq(2).text() + '!_!' +
                        tr.children('td').eq(3).text() + '!_!' +
                        tr.children('td').eq(4).text() + '!_!' +
                        tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' +
                        (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0';
                    const quantity = tr.attr('quantity');
                    const de_qu = bwmx + '*;*' + quantity;
                    data_bwmx.push(de_qu);
                    if (changeOrder && $(this).prop('disabled') !== true) {
                        data_charu.push(de_qu);
                    }
                });
                data_bwmx = data_bwmx.join('$#$');
                $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx);
                if (changeOrder) {
                    data_charu = data_charu.join('$#$');
                    $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu);
                }
            } else {
                $('#table-list-select tr[data-index="' + index + '"]').removeClass('table-success');
                $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', '');
                if (changeOrder) {
                    $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', '');
                }
            }
        }
        checkSelectAll();
    });

    // 添加空白清单or签约清单
    $('.add-list-btn').on('click', function () {
        let select = null;
        if (changeOrder) {
            select = SpreadJsObj.getSelectObject(changeSpreadSheet);
        }
        const newLedgerList = remakeChangeSpread();
        // console.log(newLedgerList, select);
        // 更新至服务器
        postData(window.location.pathname + '/save', { type:'ledger_list', updateData: newLedgerList, postData: select ? select.order : null }, function (result) {
            changeList = result.changeList;
            changeUsedData = result.usedList;
            SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
            SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
            SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
            // SpreadJsObj.reLoadSheetData(changeSpreadSheet);
            changeSpreadObj.makeSjsFooter();
            const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            changeSpreadObj.resetXmjSpread(select);
            changeSpreadObj.refreshActn();
            $('#table-list-select tr').attr('data-charu', '');
            if(changeOrder) {
                $('#code-list input:checked').each(function () {
                    $(this).attr('disabled', true);
                })
            }
            $('#addlist').modal('hide');
            tableDataRemake(changeListData);
        }, function () {
            $('#table-list-select tr').attr('data-charu', '');
            $('#addlist').modal('hide');
            tableDataRemake(changeListData);
        });
    });

    // 选中input所有值
    $('body').on('focus', ".clist input", function() {
        $(this).select();
    });

    // 取消选中清单
    $('#cancel-list-btn').click(function () {
        // $('#table-list-select tr').removeClass('table-success');
        // $('#table-list-select tr').attr('data-bwmx', '');
        // $('#code-list').html('');
        tableDataRemake(changeListData);
    });

    // 自动编号
    $('.reduction-code').click(function () {
        const code = $(this).attr('data-code');
        $('input[name="code"]').val(code);
    });

    $('#select-list').change(function () {
        const select = parseInt($(this).val());
        let showListData = changeListData;
        const value = $('#list-input').val();
        if (select === 1) {
            if (value !== '') {
                $('#list-input').siblings('a').show();
                showListData = _.filter(changeListData, function (c) {
                    return ((c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1)) && c.cid;
                });
            } else {
                $('#list-input').siblings('a').hide();
                showListData = _.filter(changeListData, function (c) {
                    return c.cid;
                });
            }
        } else {
            if (value !== '') {
                $('#list-input').siblings('a').show();
                showListData = _.filter(changeListData, function (c) {
                    return (c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1);
                });
            } else {
                $('#list-input').siblings('a').hide();
            }
        }
        makeListTable(changeListData, showListData);
        $('#table-list-select tr').removeClass('table-warning');
        $('#code-input').val('');
        $('#code-input').siblings('a').hide();
        $('#code-list').html('');
        $('#code-select-all').prop('checked', false);
    });
    // 回车提交
    $('#list-input').on('keypress', function () {
        if(window.event.keyCode === 13) {
            $(this).blur();
        }
    });
    $('#list-input').on('blur', function () {
        const select = parseInt($('#select-list').val());
        const value = _.trim($(this).val());
        const valueList = _.slice(_.without(_.uniq(_.replace(_.replace(value, /\'|\"/g, ''), /\t/g, ' ').split(' ')), ''), 0, 10);
        // console.log(valueList);
        // 判断是否存在多个分词，以换行或空格分隔，多个则显示左侧菜单
        if (value !== '' && valueList.length > 1) {
            if (_.without(_.uniq(value.split(' ')), '').length > 10) {
                toastr.warning('最多筛选以空格分割的前10个不重复关键词');
            }
            $('#table-list').addClass('col-9').removeClass('col-12');
            $('#table-list').siblings('.col-3').show();
            $('#list-search-keyword').html('<tr data-keyword="" class="text-white bg-primary"><td class="border-primary">全部</td></tr>');
            for (const v of valueList) {
                $('#list-search-keyword').append(`<tr data-keyword="${v}" class=""><td>${v}</td></tr>`);
            }
            $('#list-input').val(valueList.join(' '));
        } else {
            $('#table-list').addClass('col-12').removeClass('col-9');
            $('#table-list').siblings('.col-3').hide();
            $('#list-search-keyword').html('<tr data-keyword="" class="text-white bg-primary border-primary"><td class="border-primary">全部</td></tr>');
        }
        let showListData = changeListData;
        if (select === 1 && value !== '') {
            $(this).siblings('a').show();
            showListData = _.filter(changeListData, function (c) {
                let flag = false;
                if (c.cid) {
                    for(const v of valueList) {
                        if ((c.code && c.code.indexOf(v) !== -1) || (c.name && c.name.indexOf(v) !== -1)) {
                            flag = true;
                            break;
                        }
                    }
                }
                return flag;
                // return ((c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1)) && c.cid;
            });
        } else if (select === 1 && value === '') {
            $(this).siblings('a').hide();
            showListData = _.filter(changeListData, function (c) {
                return c.cid;
            });
        } else if (value !== '') {
            $(this).siblings('a').show();
            showListData = _.filter(changeListData, function (c) {
                let flag = false;
                for(const v of valueList) {
                    if ((c.code && c.code.indexOf(v) !== -1) || (c.name && c.name.indexOf(v) !== -1)) {
                        flag = true;
                        break;
                    }
                }
                return flag;
                // return (c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1);
            });
        } else {
            $(this).siblings('a').hide();
        }
        makeListTable(changeListData, showListData);
        $('#table-list-select tr').removeClass('table-warning');
        $('#code-input').val('');
        $('#code-input').siblings('a').hide();
        $('#code-list').html('');
        $('#code-select-all').prop('checked', false);
    });
    // 双击编辑搜索值
    $('body').on('dblclick', '#list-search-keyword tr', function () {
        if ($(this).attr('data-keyword') !== '') {
            $(this).children('td').html(`<input class="form-control form-control-sm" value="">`);
            $(this).find('input').focus();
            $(this).find('input').val($(this).attr('data-keyword'));
        }
    });
    // 光标离开
    $('body').on('blur', '#list-search-keyword tr td input', function () {
        let val = $(this).val();
        const oldVal = $(this).parents('tr').attr('data-keyword');
        if (_.trim(val) === '') {
            toastr.warning('不能为空');
            val = oldVal;
        } else if (_.trim(val) === oldVal) {
            val = oldVal;
        } else {
            const value = _.trim($('#list-input').val());
            const valueList = _.slice(_.without(_.uniq(_.replace(value, /\t/g, ' ').split(' ')), ''), 0, 10);
            // console.log(_.indexOf(valueList, oldVal), valueList, val, oldVal);
            if (_.indexOf(valueList, val) !== -1) {
                toastr.warning('已存在相同的检索词');
                val = oldVal;
            }
            valueList.splice(_.indexOf(valueList, oldVal), 1, val);
            $('#list-input').val(valueList.join(' '));
            const select = parseInt($('#select-list').val());
            const showListData = _.filter(changeListData, function (c) {
                return ((c.code && c.code.indexOf(val) !== -1) || (c.name && c.name.indexOf(val) !== -1)) && (select === 1 ? c.cid : 1);
            });
            makeListTable(changeListData, showListData);
            $('#table-list-select tr').removeClass('table-warning');
            $('#code-input').val('');
            $('#code-input').siblings('a').hide();
            $('#code-list').html('');
            $('#code-select-all').prop('checked', false);
        }
        $(this).parents('tr').attr('data-keyword', val);
        $(this).parents('td').html(`${val}`);
    });
    $('body').on('keypress', '#list-search-keyword tr td input', function () {
        if(window.event.keyCode === 13) {
            $(this).blur();
        }
    });
    $("#addlist").draggable({ handle: '.modal-header, .modal-footer'});
    // 检索关键字切换
    $('body').on('click', '#list-search-keyword tr', function () {
        if (!$(this).hasClass('bg-primary')) {
            const keyword = $(this).attr('data-keyword');
            $(this).siblings().removeClass('text-white bg-primary');
            $(this).siblings().children('td').removeClass('border-primary');
            $(this).addClass('text-white bg-primary');
            $(this).children('td').addClass('border-primary');
            if (keyword === '') {
                $('#list-input').blur();
            } else {
                const select = parseInt($('#select-list').val());
                const showListData = _.filter(changeListData, function (c) {
                    return ((c.code && c.code.indexOf(keyword) !== -1) || (c.name && c.name.indexOf(keyword) !== -1)) && (select === 1 ? c.cid : 1);
                });
                makeListTable(changeListData, showListData);
                $('#table-list-select tr').removeClass('table-warning');
                $('#code-input').val('');
                $('#code-input').siblings('a').hide();
                $('#code-list').html('');
                $('#code-select-all').prop('checked', false);
            }
        }
    });
    // 回车提交
    $('#code-input').on('keypress', function () {
        if(window.event.keyCode === 13) {
            $(this).blur();
        }
    });
    $('#code-input').on('blur', function () {
        const value = $(this).val();
        if (value !== '') {
            $(this).siblings('a').show();
        } else {
            $(this).siblings('a').hide();
        }
        makeCodeTable($(this).val());
        checkSelectAll();
    });

    $('.remove-btn').on('click', function () {
        $(this).hide();
        $(this).siblings('input').val('');
        if ($(this).data('btn') === 'list') {
            const select = parseInt($('#select-list').val());
            let showListData = changeListData;
            if (select === 1) {
                showListData = _.filter(changeListData, function (c) {
                    return c.cid;
                });
            }
            makeListTable(changeListData, showListData);
            $('#table-list-select tr').removeClass('table-warning');
            $('#code-list').html('');
            $('#table-list').addClass('col-12').removeClass('col-9');
            $('#table-list').siblings('.col-3').hide();
            $('#list-search-keyword').html('');
            $('#list-search-keyword').siblings('a').addClass('active');
        } else {
            makeCodeTable();
        }
        checkSelectAll();
    });
    // 全选及取消
    $('#code-select-all').click(function () {
        // 全选checkbox
        let index = $('#code-list').attr('data-index');
        if (index) {
            if ($(this).is(':checked')){
                $('#code-list tr').each(function () {
                    if ($(this).css('display') !== 'none' && $(this).find('input').prop('disabled') !== true) {
                        $(this).find('input').prop('checked', true);
                    }
                })
            } else {
                $('#code-list tr').each(function () {
                    if ($(this).css('display') !== 'none' && $(this).find('input').prop('disabled') !== true) {
                        $(this).find('input').prop('checked', false);
                    }
                });
            }
            // 判断还有无选中项目节编号
            if ($('#code-list input').is(':checked')) {
                // 去除部分data-detail值
                let data_bwmx = [];
                let data_charu = [];
                $('#code-list input:checked').each(function () {
                    const tr = $(this).parents('tr');
                    const length = tr.children('td').length;
                    const gcl_id = tr.attr('gcl_id');
                    const mx_id = tr.attr('mx_id');
                    const bwmx = length === 9 ?
                        tr.children('td').eq(1).text() + '!_!' +
                        tr.children('td').eq(2).text() + '!_!' +
                        tr.children('td').eq(3).text() + '!_!' +
                        tr.children('td').eq(4).text() + '!_!' +
                        tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' +
                        (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0';
                    const quantity = tr.attr('quantity');
                    const de_qu = bwmx + '*;*' + quantity;
                    data_bwmx.push(de_qu);
                    if (changeOrder && $(this).prop('disabled') !== true) {
                        data_charu.push(de_qu);
                    }
                });
                data_bwmx = data_bwmx.join('$#$');
                $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx);
                if (changeOrder) {
                    data_charu = data_charu.join('$#$');
                    $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu);
                }
                $('#table-list-select tr[data-index="' + index + '"]').addClass('table-success');
            } else {
                $('#table-list-select tr[data-index="' + index + '"]').removeClass('table-success');
                $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', '');
                if (changeOrder) {
                    $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', '');
                }
            }
        }
    });
    // 选中所有新增部位/清单
    $('#select-all-revise').click(function() {
        const qtySpr = '*;*', infoSpr = '!_!', recSpr = '$#$';
        const gclTr = $('#table-list-select tr');
        for (const tr of gclTr) {
            const lid = $(tr).data('lid');
            let gcl = _.find(gclGatherData, function (item) {
                return item.leafXmjs && item.leafXmjs[0].gcl_id === lid;
            });
            if (!gcl) gcl = gclGatherData[$(this).data('gcl')];
            if (!gcl || !gcl.cid) continue;

            let data_bwmx = [];
            if ($(tr).attr('data-bwmx') !== '') {
                data_bwmx = $(tr).attr('data-bwmx').split(recSpr);
                data_bwmx = data_bwmx.filter(x => {
                    const rec = x.split(qtySpr);
                    const info = rec[0].split(infoSpr);
                    if (info.length < 8) return true;

                    const leaf = gcl.leafXmjs.find(lx => { return lx.mx_id === info[6]});
                    return !leaf || !leaf.cid || leaf.ccid !== window.location.pathname.split('/')[4];
                });
            }
            let hasNew = false;
            for (const [index, leaf] of gcl.leafXmjs.entries()) {
                if (!leaf.cid || leaf.ccid !== window.location.pathname.split('/')[4]) continue;
                const bwmx = [leaf.code, leaf.jldy || '', leaf.dwgc || '', leaf.fbgc || '', leaf.fxgc || '', leaf.gcl_id, leaf.mx_id, leaf.bwmx || leaf.jldy || ''];
                const de_qu = bwmx.join(infoSpr) + qtySpr + (leaf.quantity || 0);
                if (data_bwmx.indexOf(de_qu) < 0) data_bwmx.push(de_qu);
                hasNew = true;
            }
            if (hasNew) $(tr).attr('data-bwmx', data_bwmx.join(recSpr)).addClass('table-success');
        }

        // 触发点击当前清单，重载当前全部部位
        const dataIndex = $('#code-list').attr('data-index');
        if (dataIndex) {
            $(`tr[data-index=${dataIndex}]`).trigger('click');
        }
    });

    // 记录变更信息操作
    $('body').on('valuechange', '#change_form input[type="text"]', function (e, previous) {
        changeInfo[$(this).attr('name')] = $(this).val();
        judgeChange();
    });
    $('body').on('valuechange', '#change_form textarea', function (e, previous) {
        changeInfo[$(this).attr('name')] = $(this).val().replace(/[\r\n]/g, '<br><br>');
        judgeChange();
    });
    $('body').on('change', '#change_form select', function (e, previous) {
        changeInfo[$(this).attr('name')] = $(this).val();
        judgeChange();
    });
    $('body').on('click', '#change_form input[type="radio"]', function (e, previous) {
        changeInfo[$(this).attr('name')] = $(this).val();
        judgeChange();
    });
    $('body').on('click', '#change_form input[type="checkbox"]', function (e, previous) {
        const typecheck = [];
        $.each($('#change_form input[name="type[]"]:checked'), function () {
            typecheck.push($(this).val());
        });
        changeInfo.type = typecheck.join(',');
        judgeChange();
    });

    // 保存修改ajax提交（不刷新页面）
    $('.save_change_btn').on('click', function () {
        // 保存修改modal
        if ($('input[name="code"]').val() === '') {
            toastr.error('申请编号不能为空！');
            return;
        }
        if ($('input[name="name"]').val() === '') {
            toastr.error('变更工程名称不能为空！');
            return;
        }
        // 换行更改并提交
        changeInfo.content = changeInfo.content.replace(/<br><br>/g, '\r\n');
        changeInfo.basis = changeInfo.basis.replace(/<br><br>/g, '\r\n');
        changeInfo.expr = changeInfo.expr.replace(/<br><br>/g, '\r\n');
        changeInfo.memo = changeInfo.memo.replace(/<br><br>/g, '\r\n');
        changeInfo.company = $('#change_form select[name="company"]').val();
        // 后改为br
        // 更新至服务器
        postData(window.location.pathname + '/save', { type:'info', updateData: changeInfo }, function (result) {
            $('.reduction-code').attr('data-code', $('input[name="code"]').val());
            toastr.success(result ? result.msg : '');
            $('#show-save-btn').hide();
            $('#sp-btn').show();
            $('.title-main').removeClass('bg-warning');
            changeInfo.content = changeInfo.content.replace(/[\r\n]/g, '<br>');
            changeInfo.basis = changeInfo.basis.replace(/[\r\n]/g, '<br>');
            changeInfo.expr = changeInfo.expr.replace(/[\r\n]/g, '<br>');
            changeInfo.memo = changeInfo.memo.replace(/[\r\n]/g, '<br>');
            back_changeInfo = Object.assign({}, changeInfo);
            if (result.changeList) {
                deLimit = result.deLimit;
                changeList = result.changeList;
                SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
                SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
                SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                // SpreadJsObj.reLoadSheetData(changeSpreadSheet);
                changeSpreadObj.makeSjsFooter();
                const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
                changeSpreadObj.resetXmjSpread(select);
                changeSpreadObj.refreshActn();
            }
        });
        return false;
    });

    $('#cancel_change').on('click', function () {
        $('#show-save-btn').hide();
        $('#sp-btn').show();
        $('.title-main').removeClass('bg-warning');
        if (!isObjEqual(changeInfo, back_changeInfo)) {
            changeFormRemake();
        }
        toastr.success('已还原到上次保存状态');
    });

    $('.dropdown-menu input[name="paixu"]').on('click', function () {
        const newChangeOrder = parseInt($(this).val());
        if (newChangeOrder !== changeOrder) {
            const updateOrderList = !newChangeOrder ? setUpdateOrder(newChangeOrder) : [];
            // 更新至服务器
            postData(window.location.pathname + '/save', { type:'order_by', updateData: newChangeOrder, updateOrderList }, function (result) {
                if (newChangeOrder === 0) {
                    $('#bpaixu').text('清单排序：清单编号');
                    $('#upAndMoveBtn').attr('style', 'display: none !important');
                    $('.order_text').text('添加');
                    changeOrder = newChangeOrder;
                } else if (newChangeOrder === 1) {
                    $('#bpaixu').text('清单排序：添加顺序');
                    $('#upAndMoveBtn').show();
                    $('.order_text').text('插入');
                    changeOrder = newChangeOrder;
                }
                changeList = result.changeList;
                changeUsedData = result.usedList;
                SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
                SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
                SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
                changeSpreadObj.makeSjsFooter();
                changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet));
                changeSpreadObj.refreshActn();
            });
        }
    });

    $('#set-site-btn').click(async function () {
        if (changeOrder) {
            const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
            await postDataAsync(window.location.pathname + '/save', { type:'order_site', listid: select ? select.id : null }, function (result) {
            });
        }
        window.location.href = window.location.pathname + '/revise';
    });
});
function checkSelectAll() {
    let check = $('#code-list tr').length > 0 ? true : false;
    const codeNum = $('#code-list tr').length;
    let i = 0;
    $('#code-list tr').each(function () {
        if ($(this).css('display') !== 'none' && !$(this).find('input').is(':checked')) {
            check = false;
            return;
        }
        else if ($(this).css('display') === 'none') {
            i++;
        }
    });
    if (check && i === codeNum) {
        check = false;
    }
    $('#code-select-all').prop('checked', check);
}

function checkChangeFrom() {
    let returnFlag = false;
    // 表单判断
    if ($('input[name="code"]').val() === '') {
        toastr.error('申请编号不能为空！');
        returnFlag = true;
    }
    if ($('input[name="name"]').val() === '') {
        toastr.error('变更工程名称不能为空！');
        returnFlag = true;
    }
    if ($('textarea[name="content"]').val() === '') {
        toastr.error('工程变更理由及内容不能为空！');
        returnFlag = true;
    }
    if (changeList.length === 0) {
        toastr.error('请添加变更清单！');
        returnFlag = true;
    } else {
        for (const [i,cl] of changeList.entries()) {
            if (cl.name === '') {
                toastr.error('变更清单第' + (i+1) + '行未完整填写数据（名称不可为空）');
                returnFlag = true;
            }
        }
    }
    if(!checkAuditorFrom ()) {
        returnFlag = true;
    }
    // 判断非空白变更清单是否有重复值（gcl_id及mx_id），如果存在完全相同则需要提示并删除，上报失败，这功能主要是因为清单数据过多服务器处理不过来偶然出现
    const doubleList = findDuplicates(_.filter(changeList, item => item.lid != 0));
    console.log(doubleList);
    if (doubleList.length > 0) {
        for (const double of doubleList) {
            const msgIndex = [];
            for (const one of double) {
                const index = _.findIndex(changeList, { id: one.id });
                if (index !== -1) msgIndex.push(index+1);
            }
            if (msgIndex.length > 0) {
                toastr.error('第 ' + msgIndex.splice(',') + ' 行变更清单 ' + double[0].code + ' 重复，请只保留一条数据');
            }
        }
        returnFlag = true;
    }
    if (returnFlag) {
        return false;
    }
    postData(window.location.pathname + '/audit/start', {}, function (result) {
        window.location.reload();
    })
}
// 检查上报情况
function checkAuditorFrom () {
    if ($('#auditList li').length === 0) {
        if(shenpi_status === shenpiConst.sp_status.gdspl) {
            toastr.error('请联系管理员添加审批人');
        } else {
            toastr.error('请先选择审批人，再上报数据');
        }
        return false;
    }
    return true;
}
// 找出数组中相同的清单
function findDuplicates(arr, keys = ['lid', 'gcl_id', 'mx_id']) {
    const groupedData = _.groupBy(arr, item => JSON.stringify(_.pick(item, keys)));
    const duplicates = _.filter(groupedData, group => group.length > 1);
    return _.values(duplicates);
}

function tableDataRemake(changeListData) {
    $('#table-list-select tr').removeClass('table-warning');
    $('#table-list-select tr').removeClass('table-success');
    $('#table-list-select tr').attr('data-bwmx', '');
    $('#table-list-select tr').attr('data-charu', '');
    $('#code-list').html('');
    $('#code-list').attr('data-index', '');
    $('#code-input').val('');
    $('#code-select-all').prop('checked', false);
    $('#code-input').siblings('a').hide();
    // 根据已添加的清单显示
    if (changeList.length > 0 && changeList[0]) {
        const removeList = [];
        const updateList = [];
        const updateGclIdList = [];
        for (const [index,clinfo] of changeList.entries()) {
            if (clinfo.lid != 0) {
                let listinfo = changeListData.find(function (item) {
                    return (item.id !== undefined && item.id == clinfo.lid) || (item.id === undefined && item.leafXmjs !== undefined && item.leafXmjs.length !== 0 && item.leafXmjs[0].gcl_id == clinfo.lid);
                });
                if (listinfo === undefined || (clinfo.lid && clinfo.gcl_id && clinfo.lid !== clinfo.gcl_id)) {
                    // 有可能这部分台账发生变化，此时要更新清单lid信息，防止数据丢失
                    const newlistinfo = changeListData.find(function (item) {
                        return (item.id !== undefined && item.id == clinfo.gcl_id) || (item.id === undefined && item.leafXmjs !== undefined && item.leafXmjs.length !== 0 && _.find(item.leafXmjs, {gcl_id: clinfo.gcl_id }));
                    });
                    if ((listinfo === undefined && newlistinfo) || (listinfo && newlistinfo && !isObjEqual(listinfo, newlistinfo))) {
                        listinfo = newlistinfo;
                        updateList.push({id: clinfo.id, lid: newlistinfo.leafXmjs[0].gcl_id});
                        // 更新lid
                        changeList[index].lid = newlistinfo.leafXmjs[0].gcl_id;
                    }
                }
                let lidIsNumber = false;
                if (listinfo === undefined) {
                    // 针对旧数据获取清单信息
                    listinfo = changeListData[clinfo.lid - 1];
                    if (listinfo === undefined) {
                        toastr.warning('台账清单列表已不存在'+ clinfo.code +'，已更新变更清单列表');
                        if (changeStatus !== auditConst.status.revise) {
                            removeList.push(clinfo);
                        } else {
                            updateList.push(makeWhiteList(clinfo));
                        }
                        continue;
                    }
                    lidIsNumber = true;
                }
                const info = makePushBwmx(clinfo, listinfo, removeList, updateList, lidIsNumber);
                if (info && _.findIndex(changeLedgerList, { id: clinfo.gcl_id }) !== -1) {
                    // 可能因为升降级关系：细目，分部分项等会发生变化，更新清单
                    const updateInfo = {};
                    if (info.code !== clinfo.xmj_code) {
                        updateInfo.xmj_code = info.code;
                        changeList[index].xmj_code = info.code;
                    }
                    if (info.jldy !== clinfo.xmj_jldy) {
                        updateInfo.xmj_jldy = info.jldy;
                        changeList[index].xmj_jldy = info.jldy;
                    }
                    if (info.dwgc !== clinfo.xmj_dwgc) {
                        updateInfo.xmj_dwgc = info.dwgc;
                        changeList[index].xmj_dwgc = info.dwgc;
                    }
                    if (info.fbgc !== clinfo.xmj_fbgc) {
                        updateInfo.xmj_fbgc = info.fbgc;
                        changeList[index].xmj_fbgc = info.fbgc;
                    }
                    if (info.fxgc !== clinfo.xmj_fxgc) {
                        updateInfo.xmj_fxgc = info.fxgc;
                        changeList[index].xmj_fxgc = info.fxgc;
                    }
                    if (!_.isEmpty(updateInfo) && _.indexOf(updateGclIdList, clinfo.gcl_id) === -1) {
                        updateGclIdList.push(clinfo.gcl_id);
                        // updateInfo.gcl_id = info.id;
                        updateList.push({ row: updateInfo, where: { tid: tenderId, gcl_id: clinfo.gcl_id } });
                    }
                }
            }
        }
        if(updateList.length > 0) {
            console.log(updateList);
            postData(window.location.pathname + '/save', { type:'update_list', updateData: updateList }, function (result) {
            }, function () {
            });
        }
        if(removeList.length > 0) {
            _.pullAll(changeList, removeList);
            postData(window.location.pathname + '/save', { type:'remove_list', updateData: removeList }, function (result) {
            }, function () {
            });
        }
    }
}

function makePushBwmx(clinfo, listinfo, removeList, updateList, lidIsNumber) {
    let info = '';
    const checkKey = ['name', 'code', 'unit', 'unit_price'];
    const checkLeafKey = ['oamount', 'bwmx', 'code', 'dwgc', 'fbgc', 'fxgc', 'jldy'];
    let pushbwmx = '0*;*0';
    if (listinfo.leafXmjs !== undefined) {
        const leafInfo = listinfo.leafXmjs.find(function (item) {
            // const flag = (item.bwmx === undefined || item.bwmx === clinfo.bwmx || item.jldy === clinfo.bwmx) && item.gcl_id === clinfo.gcl_id && (!clinfo.mx_id || (item.mx_id && clinfo.mx_id && item.mx_id === clinfo.mx_id)) && (item.quantity !== null ? item.quantity === parseFloat(clinfo.oamount) : 0 === parseFloat(clinfo.oamount));
            const flag = item.gcl_id === clinfo.gcl_id && (!clinfo.mx_id || (item.mx_id && clinfo.mx_id && item.mx_id === clinfo.mx_id));
            if (flag && item.code === clinfo.xmj_code) {
                return flag && item.code === clinfo.xmj_code;
            }
            return flag;
        });
        if (leafInfo) {
            const oneUpdate = { id: clinfo.id };
            let needUpdate = false;
            // 判断要不要更新名称，单位，原数量，单价
            checkKey.forEach(function (key) {
                if ((key === 'name' || key === 'unit') && listinfo[key] === null) {
                    listinfo[key] = '';
                }
                if (listinfo[key] !== clinfo[key]) {
                    oneUpdate[key] = listinfo[key];
                    clinfo[key] = listinfo[key];
                    if (key === 'unit') {
                        const changeKey = ['oamount', 'oamount2', 'camount'];
                        changeKey.forEach(function (key) {
                            const value = ZhCalc.round(clinfo[key], findDecimal(listinfo[key]));
                            if (value !== clinfo[key]) {
                                oneUpdate[key] = value;
                                clinfo[key] = value;
                            }
                        });
                    }
                    // else if (key === 'unit_price') {
                    //     // 可能要更新总金额了
                    //     oneUpdate[key] = ZhCalc.round(listinfo[key], unitPriceUnit);
                    //     clinfo[key] = ZhCalc.round(listinfo[key], unitPriceUnit);
                    // }
                    needUpdate = true;
                }
            });
            checkLeafKey.forEach(function (key) {
                // 只有数量是对比leafInfo，其它对比listinfo，且有些值需要重新计算
                if (key === 'oamount') {
                    if (leafInfo.quantity !== clinfo[key]) {
                        oneUpdate[key] = leafInfo.quantity;
                        clinfo[key] = leafInfo.quantity;
                        needUpdate = true;
                    }
                } else if (key === 'bwmx') {
                    if (leafInfo[key] !== undefined && leafInfo[key] !== clinfo[key]) {
                        oneUpdate[key] = leafInfo[key];
                        clinfo[key] = leafInfo[key];
                        needUpdate = true;
                    } else if (leafInfo[key] === undefined && (leafInfo.jldy || '') !== clinfo[key]) {
                        oneUpdate[key] = leafInfo.jldy || '';
                        clinfo[key] = leafInfo.jldy || '';
                        needUpdate = true;
                    }
                } else {
                    if (leafInfo[key] !== clinfo['xmj_' + key]) {
                        oneUpdate['xmj_' + key] = leafInfo[key];
                        clinfo['xmj_' + key] = leafInfo[key];
                        needUpdate = true;
                    }
                }
            });
            if (needUpdate) {
                updateList.push(oneUpdate);
            }
            info = leafInfo;
            pushbwmx = leafInfo.code + '!_!' + (leafInfo.jldy !== undefined ? leafInfo.jldy : '') + '!_!' +
                (leafInfo.dwgc ? leafInfo.dwgc : '') + '!_!' +
                (leafInfo.fbgc ? leafInfo.fbgc : '') + '!_!' +
                (leafInfo.fxgc ? leafInfo.fxgc : '') + '!_!' +
                (leafInfo.gcl_id ? leafInfo.gcl_id : '') + '!_!' +
                (leafInfo.mx_id ? leafInfo.mx_id : '') + '!_!' +
                (leafInfo.bwmx !== undefined ? leafInfo.bwmx : (leafInfo.jldy !== undefined ? leafInfo.jldy : '')) + '*;*' + (leafInfo.quantity !== null ? leafInfo.quantity : 0);
        } else {
            toastr.warning('台账清单列表已不存在'+ clinfo.code +'，已更新变更清单列表');
            if (changeStatus !== auditConst.status.revise) {
                removeList.push(clinfo);
            } else {
                updateList.push(makeWhiteList(clinfo));
            }
            return false;
        }
    } else {
        pushbwmx = '0*;*' + (listinfo.quantity !== null ? listinfo.quantity : 0);
    }
    const bwmx = lidIsNumber ? $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx') : $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx');
    if (bwmx) {
        const bwmxArray = bwmx.split('$#$');
        bwmxArray.push(pushbwmx);
        if (lidIsNumber) {
            $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$'));
        } else {
            $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$'));
        }
    } else {
        if (lidIsNumber) {
            $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx);
        } else {
            $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx);
        }
    }
    if (lidIsNumber) {
        $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').addClass('table-success');
    } else {
        $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').addClass('table-success');
    }
    return info;
}

function makeWhiteList(clinfo) {
    clinfo.lid = 0;
    clinfo.xmj_code = null;
    clinfo.xmj_jldy = null;
    clinfo.xmj_dwgc = null;
    clinfo.xmj_fbgc = null;
    clinfo.xmj_fxgc = null;
    clinfo.gcl_id = '';
    clinfo.mx_id = '';
    return clinfo;
}

// 清单搜索隐藏清单table部分值
function makeListTable(changeListData, showListData = changeListData) {
    // 先加载台账数据
    let listHtml = '';
    let list_index = 1;
    let gcl_index = 0;
    for (const [index,gcl] of changeListData.entries()) {
        const isShow = _.find(showListData, gcl);
        $('#table-list-select tr').eq(index).css('display', (isShow ? 'table-row' : 'none'));
    }
}
// 项目节搜索隐藏code-table部分值
function makeCodeTable(search = '') {
    if (search === '') {
        $('#code-list tr').css('display', 'table-row');
        return;
    }
    $('#code-list tr').css('display', 'none');
    if (searchCodeList.length > 0) {
        for (const [index,list] of searchCodeList.entries()) {
            if (list.indexOf(search) !== -1) {
                $('#code-list tr').eq(index).css('display', 'table-row');
            }
        }
    } else {
        for(let i = 0; i < $('#code-list tr').length; i++) {
            const length = $('#code-list tr').eq(i).children('td').length;
            if (length === 9) {
                const code = $('#code-list tr').eq(i).children('td').eq(1).text();
                const name = $('#code-list tr').eq(i).children('td').eq(2).text();
                const jldy = $('#code-list tr').eq(i).children('td').eq(6).text();
                const isShow = code.indexOf(search) !== -1 || name.indexOf(search) !== -1 || jldy.indexOf(search) !== -1;
                if (isShow) {
                    $('#code-list tr').eq(i).css('display', 'table-row');
                }
                // $('#code-list tr').eq(i).css('display', (isShow ? 'table-row' : 'none'));
            } else {
                return;
            }
        }
    }
}

function remakeChangeSpread(cOrder = changeOrder) {
    const newTableList = [];
    // 获取选中的签约清单判断并插入到原有清单中
    $('#table-list-select .table-success').each(function(){
        let code = $(this).children('td').eq(1).text();
        let name = $(this).children('td').eq(2).text();
        let unit = $(this).children('td').eq(3).text();
        let price = $(this).children('td').eq(4).text();
        // let oamount = $(this).children('td').eq(5).text();

        // 根据单位获取数量的位数，并得出
        // let numdecimal = findDecimal(unit);

        // let scnum = makedecimalzero(numdecimal);
        let scnum = 0;
        // let detail = $(this).attr('data-detail') != 0 ? $(this).attr('data-detail').split('_')[1] : '';
        let lid = $(this).data('lid');
        let lindex = $(this).data('index');
        // 原清单和数量改变
        let data_bwmx = cOrder ? ($(this).attr('data-charu') ? $(this).attr('data-charu').split('$#$') : []) : $(this).attr('data-bwmx').split('$#$');

        for (const b of data_bwmx) {
            const oamount = b.split('*;*')[1] != '' ? b.split('*;*')[1] : 0;
            let bwmx = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[7] : '';
            let xmj_code = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[0] : '';
            let xmj_jldy = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[1] : '';
            let xmj_dwgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[2] : '';
            let xmj_fbgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[3] : '';
            let xmj_fxgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[4] : '';
            let gcl_id = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[5] : '';
            let mx_id = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[6] : '';
            let trlist = {
                code,
                name,
                bwmx,
                unit,
                unit_price: price,
                oamount,
                oamount2: oamount,
                camount: scnum,
                camount_expr: '',
                detail: '',
                lid,
                xmj_code,
                xmj_jldy,
                xmj_dwgc,
                xmj_fbgc,
                xmj_fxgc,
                gcl_id,
                mx_id,
                is_valuation: 1,
                delimit: deLimit,
            };
            const radionInfo = changeList.find(function (info) {
                //return info.code === code && (info.lid == lid || parseInt(info.lid) === parseInt(lindex)) && gcl_id == info.gcl_id && (info.bwmx === bwmx || (info.bwmx === xmj_jldy && info.mx_id && info.mx_id === mx_id)) && parseInt(info.oamount) === parseInt(oamount);
                return (info.lid == lid || parseInt(info.lid) === parseInt(lindex)) && gcl_id == info.gcl_id && (!mx_id || (mx_id && info.mx_id && info.mx_id === mx_id)) && (info.bwmx === bwmx || info.bwmx === xmj_jldy);
            });
            if (radionInfo) {
                trlist.oamount2 = radionInfo.oamount2;
                trlist.camount = radionInfo.camount;
                trlist.camount_expr = radionInfo.camount_expr;
                trlist.detail = radionInfo.detail;
                trlist.is_valuation = radionInfo.is_valuation;
                trlist.delimit = radionInfo.delimit;
            }
            newTableList.push(trlist);
        }
    });
    // const changeWhiteList = _.filter(changeList, function (item) {
    //     return item.lid == 0;
    // });
    // console.log(newTableList);
    // changeList = newTableList.concat(changeWhiteList);
    return newTableList;
}
//判断元素是否在数组中，相当于php的in_array();
function in_array(arr, obj) {
    let i = arr.length;
    while (i--) {
        if (arr[i] == obj) {
            return true;
        }
    }
    return false;
}
function isObjEqual(o1,o2){
    var props1 = Object.getOwnPropertyNames(o1);
    var props2 = Object.getOwnPropertyNames(o2);
    if (props1.length != props2.length) {
        return false;
    }
    for (var i = 0,max = props1.length; i < max; i++) {
        var propName = props1[i];
        if (o1[propName] !== o2[propName]) {
            return false;
        }
    }
    return true;
}
// 判断是否有更改过
function judgeChange() {
    let change = false;
    if (!isObjEqual(changeInfo, back_changeInfo)) {
        change = true;
    }
    if (change) {
        $('#show-save-btn').show();
        $('#sp-btn').hide();
        $('.title-main').addClass('bg-warning');
    } else {
        $('#show-save-btn').hide();
        $('#sp-btn').show();
        $('.title-main').removeClass('bg-warning');
    }
}

function changeFormRemake() {
    changeInfo = Object.assign({}, back_changeInfo);
    $('#change_form input[name="code"]').val(changeInfo.code);
    $('#change_form input[name="name"]').val(changeInfo.name);
    $('#change_form input[name="peg"]').val(changeInfo.peg);
    $('#change_form input[name="org_name"]').val(changeInfo.org_name);
    $('#change_form input[name="org_code"]').val(changeInfo.org_code);
    $('#change_form input[name="new_name"]').val(changeInfo.new_name);
    $('#change_form input[name="new_code"]').val(changeInfo.new_code);
    $('#change_form textarea[name="content"]').val(changeInfo.content.replace(/<br><br>/g, '\r\n'));
    $('#change_form textarea[name="basis"]').val(changeInfo.basis.replace(/<br><br>/g, '\r\n'));
    $('#change_form textarea[name="expr"]').val(changeInfo.expr.replace(/<br><br>/g, '\r\n'));
    $('#change_form textarea[name="memo"]').val(changeInfo.memo.replace(/<br><br>/g, '\r\n'));
    $('#change_form select[name="type"]').val(changeInfo.type);
    $('#change_form select[name="class"]').val(changeInfo.class);
    $('#change_form select[name="quality"]').val(changeInfo.quality);
    $('#change_form select[name="company"]').val(changeInfo.company);
    $('#change_form input[name="charge"][value="'+ changeInfo.charge +'"]').prop('checked', true);
    $('#change_form input[name="state"][value="'+ changeInfo.state +'"]').prop('checked', true);
    $('#change_form input[name="type[]"]').prop('checked', false);
    const typecheck = changeInfo.type.split(',');
    for (const type of typecheck) {
        $('#change_form input[name="type[]"][value="'+ type +'"]').prop('checked', true);
    }
}