Calculation/app/public/js/revise_price.js

'use strict';

/**
 *
 *
 * @author Mai
 * @date
 * @version
 */

const showSideTools = function (show) {
    const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
    if (show) {
        right.show();
        autoFlashHeight();
        const percent = 100 - right.outerWidth() /parent.width() * 100;
        left.css('width', percent + '%');
    } else {
        left.width(parent.width());
        right.hide();
    }
};

const setPriceHint = function (show) {
    const hinticon = show ? 'fa-bell' : undefined;
    subMiniMenu.$children[2].hinticon = hinticon;
    subMenu.$children[2].hinticon = hinticon;
};

$(document).ready(() => {
    const ledgerGclSpreadSetting = {
        cols: [
            { title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@' },
            { title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 200, formatter: '@' },
            { title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@' },
            { title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number' },
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    const ledgerXmjSpreadSetting = {
        cols: [
            {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 100, formatter: '@'},
            {title: '单位工程', colSpan: '1', rowSpan: '1', field: 'dwgc', hAlign: 0, width: 80, formatter: '@'},
            {title: '分部工程', colSpan: '1', rowSpan: '1', field: 'fbgc', hAlign: 0, width: 80, formatter: '@'},
            {title: '分项工程', colSpan: '1', rowSpan: '1', field: 'fxgc', hAlign: 0, width: 80, formatter: '@'},
            {title: '细目', colSpan: '1', rowSpan: '1', field: 'jldy', hAlign: 0, width: 80, formatter: '@'},
            {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'bwmx', hAlign: 0, width: 80, formatter: '@'},
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    const priceSpreadSetting = {
        cols: [
            { title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 100, formatter: '@', readOnly: true },
            { title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 210, formatter: '@', readOnly: true },
            { title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: true },
            { title: '当前单价', colSpan: '1', rowSpan: '2', field: 'org_price', hAlign: 2, width: 80, type: 'Number', readOnly: true },
            { title: '调整后单价', colSpan: '1', rowSpan: '2', field: 'new_price', hAlign: 2, width: 80, type: 'Number' },
            { title: '备注', colSpan: '1', rowSpan: '2', field: 'memo', hAlign: 2, width: 150, formatter: '@' },
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly,
        getColor: function (sheet, data, row, col, defaultColor) {
            if (!data || (data.rela_lid && data.rela_cid)) return defaultColor;

            const samePrice = sheet.zh_data.find(x => {
                return x.b_code === data.b_code && x.name === data.name && x.unit === data.unit && x.org_price === data.org_price;
            });
            return samePrice ? '#f5deb3' : defaultColor;
        }
    };
    const priceBwSpreadSetting = {
        cols: [
            {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'},
            {title: '清单编号', colSpan: '1', rowSpan: '1', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
            {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 230, formatter: '@'},
            {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
        ],
        headRows: 1,
        emptyRows: 0,
        headRowHeight: [25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    sjsSettingObj.setFxTreeStyle(priceBwSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
    const priceChangeSpreadSetting = {
        cols: [
            {title: '变更令', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 80, formatter: '@'},
            {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 230, formatter: '@'},
            {title: '批复文号', colSpan: '1', rowSpan: '1', field: 'w_code', hAlign: 1, width: 80, formatter: '@'},
        ],
        headRows: 1,
        emptyRows: 0,
        headRowHeight: [25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    autoFlashHeight();
    const bcontent = $(".bcontent-wrap").length > 0 ? $(".bcontent-wrap").height() : 0;
    $(".sp-wrap").height(bcontent-30);
    const priceSpread = SpreadJsObj.createNewSpread($('#price-spread')[0]);
    const priceSheet = priceSpread.getActiveSheet();
    const priceBwSpread = SpreadJsObj.createNewSpread($('#price-bw-spread')[0]);
    const priceBwSheet = priceBwSpread.getActiveSheet();
    const priceChangeSpread = SpreadJsObj.createNewSpread($('#price-change-spread')[0]);
    const priceChangeSheet = priceChangeSpread.getActiveSheet();

    SpreadJsObj.initSheet(priceSheet, priceSpreadSetting);
    SpreadJsObj.initSheet(priceBwSheet, priceBwSpreadSetting);
    SpreadJsObj.initSheet(priceChangeSheet, priceChangeSpreadSetting);

    class RevisePrice {
        constructor () {
            this.data = [];
            this.tree = createNewPathTree('filter', {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                fullPath: 'full_path',
                keys: ['id', 'tender_id', 'ledger_id'],
            });
        }
        resortData() {
            this.data.sort(function (a, b) {
                return a.order - b.order;
            });
        }
        loadDatas(datas, treeData, changeData) {
            this.data = datas;
            this.tree.loadDatas(treeData);
            this.resortData();
            this.change = changeData;
            this.relaChange = [];
            if (this.data.length > 0) this.refreshRela(this.data[0]);
        }
        loadUpdateData(updateData) {
            if (updateData.add) {
                for (const a of updateData.add) {
                    this.data.push(a);
                }
            }
            if (updateData.update) {
                for (const u of updateData.update) {
                    const d = this.data.find(function (x) {
                        return u.id === x.id;
                    });
                    if (d) {
                        _.assign(d, u);
                    } else {
                        this.data.push(d);
                    }
                }
            }
            if (updateData.del) {
                _.remove(this.data, function (d) {
                    return updateData.del.indexOf(d.id) >= 0;
                });
            }
            this.resortData();
        }
        getSamePrice(price) {
            return this.data.filter(x => {
                if (x.id === price.id) return false;
                return x.b_code === price.b_code && x.name === price.name && x.unit === price.unit && x.org_price === price.org_price;
            });
        }
        refreshTreeRela(price, samePrice) {
            if (price.rela_lid) {
                this.tree.loadFilter(price.rela_lid);
            } else {
                const invalid = [];
                for (const sp of samePrice) {
                    const lid = sp.rela_lid ? sp.rela_lid.split(',') : [];
                    invalid.push(...lid);
                }
                this.tree.loadFilter(invalid.join(','), 'filter');
            }
        }
        refreshChangeRela(price, samePrice) {
            if (price.rela_cid) {
                const choose = price.rela_cid.split(',');
                for (const c of this.change) {
                    c.rela = choose.indexOf(c.cid + '') >= 0;
                    c.valid = c.rela;
                }
            } else {
                const invalid = [];
                for (const sp of samePrice) {
                    const cid = sp.rela_cid ? sp.rela_cid.split(',') : [];
                    invalid.push(...cid);
                }
                for (const c of this.change) {
                    c.rela = invalid.indexOf(c.cid + '') >= 0;
                    if (c.rela) {
                        c.valid = 0;
                    } else {
                        const exist = c.bills.find(x => {
                            return x.code === price.b_code && x.name === price.name && x.unit === price.unit && x.unit_price === price.org_price;
                        });
                        c.valid = exist;
                    }
                }
            }
            this.relaChange.length = 0;

            for (const c of this.change) {
                if (c.valid) this.relaChange.push(c);
            }
        }
        refreshRela(price) {
            const samePrice = this.getSamePrice(price);
            this.refreshTreeRela(price, samePrice);
            this.refreshChangeRela(price, samePrice);
        }
    }
    const revisePrice = new RevisePrice();
    const priceOprObj = {
        addRevisePrice(data) {
            const op = revisePrice.data.find(x => {
                return x.b_code === data.b_code && x.name === x.name && x.unit === x.unit && checkZero(ZhCalc.sub(x.org_price, data.unit_price)) && (!x.rela_lid || !x.rela_cid);
            });
            if (op) {
                toastr.warning('已存在该单价调整');
                SpreadJsObj.locateData(priceSheet, op);
                return;
            }
            postData(window.location.pathname + '/update', { add: { b_code: data.b_code, name: data.name, unit: data.unit, unit_price: data.unit_price } }, result => {
                revisePrice.loadUpdateData(result);
                SpreadJsObj.reLoadSheetData(priceSheet);
                setPriceHint(revisePrice.data.length > 0);
            });
        },
        /**
         * 删除按钮响应事件
         * @param sheet
         */
        deletePress: function (sheet) {
            if (!sheet.zh_setting || readOnly) return;

            const sortData = sheet.zh_data;
            const datas = [];
            const sels = sheet.getSelections();
            if (!sels || !sels[0]) return;

            for (let iRow = sels[0].row; iRow < sels[0].row + sels[0].rowCount; iRow++) {
                let bDel = false;
                const node = sortData[iRow];
                if (node) {
                    const data = {id: node.id};
                    for (let iCol = sels[0].col; iCol < sels[0].col + sels[0].colCount; iCol++) {
                        const style = sheet.getStyle(iRow, iCol);
                        if (!style.locked) {
                            const colSetting = sheet.zh_setting.cols[iCol];
                            data[colSetting.field] = null;
                            bDel = true;
                        }
                    }
                    if (bDel) {
                        datas.push(data);
                    }
                }
            }
            if (datas.length > 0) {
                postData(window.location.pathname + '/update', {update: datas}, function (result) {
                    revisePrice.loadUpdateData(result);
                    SpreadJsObj.reLoadSheetData(priceSheet);
                }, function () {
                    SpreadJsObj.reLoadSheetData(priceSheet);
                });
            }
        },
        delete: function (sheet) {
            if (!sheet.zh_setting || readOnly) return;

            const sortData = sheet.zh_data;
            const datas = [];
            const sels = sheet.getSelections();
            if (!sels || !sels[0]) return;

            for (let iRow = sels[0].row, iLen = sels[0].row + sels[0].rowCount; iRow < iLen; iRow++) {
                const node = sortData[iRow];
                datas.push(node.id);
            }
            if (datas.length > 0) {
                postData(window.location.pathname + '/update', {del: datas}, function (result) {
                    revisePrice.loadUpdateData(result);
                    SpreadJsObj.reLoadSheetData(priceSheet);
                    setPriceHint(revisePrice.data.length > 0);
                }, function () {
                    SpreadJsObj.reLoadSheetData(priceSheet);
                });
            }
        },
        editEnded: function (e, info) {
            if (!info.sheet.zh_setting || !info.sheet.zh_data) return;

            const node = info.sheet.zh_data[info.row];
            if (!node) return;

            const col = info.sheet.zh_setting.cols[info.col];
            const data = { update: { id: node.id, org_price: node.org_price } };
            const oldValue = node ? node[col.field] : null;
            const newValue = trimInvalidChar(info.editingText);
            if (oldValue == info.editingText || ((!oldValue || oldValue === '') && (newValue === ''))) {
                SpreadJsObj.reLoadRowData(info.sheet, info.row);
                return;
            }
            if (col.type === 'Number') {
                const num = _.toNumber(newValue);
                if (num) data.update[col.field] = num;
            } else {
                data.update[col.field] = newValue;
            }

            postData(window.location.pathname + '/update', data, function (result) {
                revisePrice.loadUpdateData(result);
                SpreadJsObj.reLoadSheetData(info.sheet);
            }, function () {
                SpreadJsObj.reLoadRowData(info.sheet, info.row);
            });
        },
        clipboardPasting(e, info) {
            const setting = info.sheet.zh_setting, sortData = info.sheet.zh_data;
            info.cancel = true;

            if (!setting || !sortData) return;
            const pasteData = info.pasteData.html
                ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
                : (info.pasteData.text === ''
                    ? SpreadJsObj.Clipboard.getAnalysisPasteText()
                    : SpreadJsObj.analysisPasteText(info.pasteData.text));

            const uDatas = [];
            for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
                const curRow = info.cellRange.row + iRow;
                const node = sortData[curRow];

                let bPaste = false;
                const data = {};
                for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
                    const curCol = info.cellRange.col + iCol;
                    const colSetting = setting.cols[curCol];
                    const value = trimInvalidChar(pasteData[iRow][iCol]);
                    if (colSetting.type === 'Number') {
                        const num = _.toNumber(value);
                        if (num) {
                            data[colSetting.field] = num;
                            bPaste = true;
                        }
                    } else {
                        data[colSetting.field] = value;
                        bPaste = true;
                    }
                }
                if (bPaste) {
                    data.id = node.id;
                    uDatas.push(data);
                }
            }
            const updateData = {};
            if (uDatas.length > 0) updateData.update = uDatas;
            if (uDatas.length > 0) {
                postData(window.location.pathname + '/update', updateData, function (result) {
                    revisePrice.loadUpdateData(result);
                    SpreadJsObj.reLoadSheetData(info.sheet);
                });
            } else {
                SpreadJsObj.reLoadSheetData(info.sheet);
            }
        },
        upMove: function () {
            const sels = priceSheet.getSelections(), sortData = priceSheet.zh_data;
            const node = sortData[sels[0].row];
            const preNode = sortData[sels[0].row - 1];
            const data = [
                {id: node.id, order: preNode.order},
                {id: preNode.id, order: node.order}
            ];
            postData(window.location.pathname + '/update', {update: data}, function (result) {
                revisePrice.loadUpdateData(result);
                SpreadJsObj.reLoadRowsData(priceSheet, [sels[0].row, sels[0].row - 1]);
                priceSheet.setSelection(sels[0].row - 1, sels[0].col, sels[0].rowCount, sels[0].colCount);
            });
        },
        downMove: function () {
            const sels = priceSheet.getSelections(), sortData = priceSheet.zh_data;
            const node = sortData[sels[0].row];
            const nextNode = sortData[sels[0].row + 1];
            const data = [
                {id: node.id, order: nextNode.order},
                {id: nextNode.id, order: node.order}
            ];
            postData(window.location.pathname + '/update', {update: data}, function (result) {
                revisePrice.loadUpdateData(result);
                SpreadJsObj.reLoadRowsData(priceSheet, [sels[0].row, sels[0].row + 1]);
                priceSheet.setSelection(sels[0].row + 1, sels[0].col, sels[0].rowCount, sels[0].colCount);
            });
        },
        updateRelaLid: function (price, rela_lid) {
            const data = { update: { id: price.id, rela_lid } };
            postData(window.location.pathname + '/update', data, function (result) {
                revisePrice.loadUpdateData(result);
                revisePrice.refreshTreeRela(price);
                SpreadJsObj.refreshTreeRowVisible(priceBwSheet);
            });
        },
        updateRelaCid: function (price, rela_cid) {
            const data = { update: { id: price.id, rela_cid } };
            postData(window.location.pathname + '/update', data, function (result) {
                revisePrice.loadUpdateData(result);
                revisePrice.refreshChangeRela(price);
                SpreadJsObj.reLoadSheetData(priceChangeSheet);
            });
        },
        selectionChanged: function () {
            const price = SpreadJsObj.getSelectObject(priceSheet);
            revisePrice.refreshRela(price);
            SpreadJsObj.refreshTreeRowVisible(priceBwSheet);
            SpreadJsObj.reLoadSheetData(priceChangeSheet);
        },
    };
    if (!readOnly) {
        priceSheet.bind(spreadNS.Events.EditEnded, priceOprObj.editEnded);
        priceSheet.bind(spreadNS.Events.ClipboardPasting, priceOprObj.clipboardPasting);
        SpreadJsObj.addDeleteBind(priceSpread, priceOprObj.deletePress);
        $.contextMenu({
            selector: '#price-spread',
            build: function ($trigger, e) {
                const target = SpreadJsObj.safeRightClickSelection($trigger, e, priceSpread);
                return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
            },
            items: {
                del: {
                    name: '删除',
                    icon: 'fa-remove',
                    callback: function (key, opt) {
                        priceOprObj.delete(priceSheet);
                    },
                    disabled: function (key, opt) {
                        const node = SpreadJsObj.getSelectObject(priceSheet);
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                sprDel: '----',
                upMove: {
                    name: '上移',
                    icon: 'fa-arrow-up',
                    callback: function (key, opt) {
                        priceOprObj.upMove();
                    },
                    disabled: function (key, opt) {
                        const sels = priceSheet.getSelections();
                        if (!sels || !sels[0] || sels[0].row === 0) return true;

                        const row = sels[0].row;
                        const node = revisePrice.data[row];
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                downMove: {
                    name: '下移',
                    icon: 'fa-arrow-down',
                    callback: function (key, opt) {
                        priceOprObj.downMove();
                    },
                    disabled: function (key, opt) {
                        const sels = priceSheet.getSelections();
                        if (!sels || !sels[0] || sels[0].row >= revisePrice.data.length - 1) return true;

                        const row = sels[0].row;
                        const node = revisePrice.data[row];
                        return node === undefined || node === null;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                sprMove: '----',
                chooseRelaBw: {
                    name: '选择应用部位',
                    icon: 'fa-tags',
                    callback: function (key, opt) {
                        const price = SpreadJsObj.getSelectObject(priceSheet);
                        const samePrice = revisePrice.getSamePrice(price);
                        chooseRelaBw.show(price, samePrice);
                    },
                    disabled: function (key, opt) {
                        const node = SpreadJsObj.getSelectObject(priceSheet);
                        return !node;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
                chooseRelaChange: {
                    name: '选择应用变更令',
                    icon: 'fa-tags',
                    callback: function (key, opt) {
                        const price = SpreadJsObj.getSelectObject(priceSheet);
                        const samePrice = revisePrice.getSamePrice(price);
                        chooseRelaChange.show(price, samePrice);
                    },
                    disabled: function (key, opt) {
                        const node = SpreadJsObj.getSelectObject(priceSheet);
                        return !node;
                    },
                    visible: function (key, opt) {
                        return !readOnly;
                    }
                },
            },
        });
    }
    priceSpread.bind(spreadNS.Events.SelectionChanged, priceOprObj.selectionChanged);

    class LedgerGcl {
        constructor(setting) {
            this.setting = setting;
            this.spread = SpreadJsObj.createNewSpread($(this.setting.selector)[0]);
            this.sheet = this.spread.getActiveSheet();
            SpreadJsObj.initSheet(this.sheet, this.setting.spreadSetting);
            this.xmjSpread = SpreadJsObj.createNewSpread($(this.setting.xmjSelector)[0]);
            this.xmjSheet = this.xmjSpread.getActiveSheet();
            SpreadJsObj.initSheet(this.xmjSheet, this.setting.xmjSpreadSetting);
            if (!readOnly) {
                this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
                    const gcl = SpreadJsObj.getSelectObject(info.sheet);
                    priceOprObj.addRevisePrice(gcl);
                });
            }
            const self = this;
            this.spread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
                self.loadLeafXmj();
            });
        }
        loadData(bills, pos) {
            gclGatherModel.loadLedgerData(bills);
            gclGatherModel.loadPosData(pos);
            this.gcl = gclGatherModel.gatherGclData();
            this.sheet && SpreadJsObj.loadSheetData(this.sheet, SpreadJsObj.DataType.Data, this.gcl);
            this.loadLeafXmj(0);
        }
        loadLeafXmj(iGclRow) {
            const gcl = iGclRow ? this.gcl[iGclRow] : SpreadJsObj.getSelectObject(this.sheet);
            SpreadJsObj.resetTopAndSelect(this.xmjSheet);
            if (gcl) {
                SpreadJsObj.loadSheetData(this.xmjSheet, SpreadJsObj.DataType.Data, gcl.leafXmjs);
            } else {
                SpreadJsObj.loadSheetData(this.xmjSheet, SpreadJsObj.DataType.Data, []);
            }
        }
    }
    const ledgerGcl = new LedgerGcl({
        selector: '#ledger-gcl-spread',
        spreadSetting: ledgerGclSpreadSetting,
        xmjSelector: '#ledger-xmj-spread',
        xmjSpreadSetting: ledgerXmjSpreadSetting,
    });

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

    $.divResizer({
        select: '#revise-right-spr',
        callback: function () {
            priceSpread.refresh();
            priceBwSpread.refresh();
            priceChangeSpread.refresh();
            ledgerGcl.spread.refresh();
            ledgerGcl.xmjSpread.refresh();
        }
    });
    $.divResizer({
        select: '#gcl-spr',
        callback: function () {
            ledgerGcl.spread.refresh();
            ledgerGcl.xmjSpread.refresh();
        }
    });
    $.divResizer({
        select: '#price-resize',
        callback: function () {
            priceSpread.refresh();
            let bcontent = $(".bcontent-wrap").length > 0 ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent-30);
            priceBwSpread.refresh();
            priceChangeSpread.refresh();
        }
    });

    class ChooseRelaBw {
        constructor() {
            const self = this;
            this.tree = createNewPathTree('base', {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                fullPath: 'full_path',
                keys: ['id', 'tender_id', 'ledger_id'],
            });
            $('#choose-rela-bw').on('shown.bs.modal', function() {
                self.initSpread();
                SpreadJsObj.reloadColData(self.sheet, 0, 1);
                SpreadJsObj.reloadRowBackColor(self.sheet, 0, self.tree.nodes.length);
            });
            $('#choose-rela-bw-ok').click(function() {
                const choose_lid = [];
                self.tree.nodes.forEach(x => {
                    if (x.check) choose_lid.push(x.ledger_id);
                });
                priceOprObj.updateRelaLid(self.price, choose_lid.join(','));
                $('#choose-rela-bw').modal('hide');
            });
        }
        initSpread() {
            if (this.spread) return;

            this.spread = SpreadJsObj.createNewSpread($('#rela-bw-spread')[0]);
            this.sheet = this.spread.getActiveSheet();
            const spreadSetting = {
                cols: [
                    {title: '选择', colSpan: '1', rowSpan: '1', field: 'check', hAlign: 1, width: 50, formatter: '@', cellType: 'checkbox'},
                    {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'},
                    {title: '清单编号', colSpan: '1', rowSpan: '1', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
                    {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 230, formatter: '@'},
                    {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
                ],
                headRows: 1,
                emptyRows: 0,
                headRowHeight: [25],
                defaultRowHeight: 21,
                headerFont: '12px 微软雅黑',
                font: '12px 微软雅黑',
                readOnly: true,
                getColor: function (sheet, data, row, col, defaultColor) {
                    return data && data.invalid ? '#dddddd' : defaultColor;
                }
            };
            sjsSettingObj.setFxTreeStyle(spreadSetting, sjsSettingObj.FxTreeStyle.jz);
            SpreadJsObj.initSheet(this.sheet, spreadSetting);
            const self = this;
            this.spread.bind(spreadNS.Events.ButtonClicked, function (e, info) {
                function checkInvalid(node) {
                    if (node.invalid) return 1;
                    if (self.tree.checkParent(node, 'invalid')) return 2;
                    if (self.tree.checkChildren(node, 'invalid')) return 3;
                    return 0;
                }

                const sheet = info.sheet, cellType = sheet.getCellType(info.row, info.col);
                if (!sheet.zh_setting) return;

                if (cellType instanceof spreadNS.CellTypes.CheckBox) {
                    if (sheet.isEditing()) sheet.endEdit(true);
                }

                const col = sheet.zh_setting.cols[info.col];
                if (col.field !== 'check') return;

                const tree = sheet.zh_tree;
                const node = SpreadJsObj.getSelectObject(sheet);
                if (node.b_code) {
                    toastr.warning('请选择部位');
                    return;
                }

                if (!node.check) {
                    const invalid = checkInvalid(node);
                    const invalidHint = ['该部位已被选择，请勿重复选择', '该部位的父项已被选择，请勿选择', '该部位的子项已被选择，请勿在其子项中选择'];
                    if (invalid) {
                        toastr.warning(invalidHint[invalid-1]);
                        return;
                    }
                    if (self.tree.checkParent(node)) {
                        const rect = info.sheet.getCellRect(info.row, info.col);
                        self.chooseConfirmPopover({
                            x: rect.x + rect.width / 2 + 25,
                            y: rect.y + rect.height / 2 + 3,
                        }, '父项已勾选，继续将取消父项勾选。', function () {
                            node.check = true;
                            const parents = tree.getFullPathNodes(tree.getParent(node).full_path);
                            const rows = [tree.nodes.indexOf(node)];
                            for (const p of parents) {
                                if (p.check) {
                                    p.check = false;
                                    rows.push(tree.nodes.indexOf(p));
                                }
                            }
                            SpreadJsObj.reLoadRowsData(info.sheet, rows);
                        });
                    } else if (self.tree.checkChildren(node)) {
                        const rect = info.sheet.getCellRect(info.row, info.col);
                        self.chooseConfirmPopover({
                            x: rect.x + rect.width / 2 + 25,
                            y: rect.y + rect.height / 2 + 3,
                        }, '子项已勾选，继续将取消子项勾选。', function () {
                            node.check = true;
                            const posterity = tree.getPosterity(node);
                            const rows = [tree.nodes.indexOf(node)];
                            for (const p of posterity) {
                                if (p.check) {
                                    rows.push(tree.nodes.indexOf(p));
                                    p.check = false;
                                }
                            }
                            SpreadJsObj.reLoadRowsData(info.sheet, rows);
                        });
                    } else {
                        node.check = true;
                        SpreadJsObj.reLoadRowsData(info.sheet, [info.row]);
                    }
                } else {
                    node.check = false;
                    SpreadJsObj.reLoadRowsData(info.sheet, [info.row]);
                }
            });
            SpreadJsObj.loadSheetData(this.sheet, SpreadJsObj.DataType.Tree, this.tree);
        }
        reBind(obj, eventName, fun) {
            obj.unbind(eventName);
            obj.bind(eventName, fun);
        }
        chooseConfirmPopover(pos, hint, okCallback) {
            const confirmObj = $('#choose-confirm'), hintObj = $('#choose-confirm-hint');
            const okObj = $('#choose-confirm-ok'), cancelObj = $('#choose-confirm-cancel');
            this.reBind(cancelObj, 'click', function () {
                confirmObj.hide();
            });
            this.reBind(okObj, 'click', function () {
                okCallback();
                confirmObj.hide();
            });
            hintObj.text(hint);
            confirmObj.css("top", pos.y).css("left", pos.x).show();
        }
        loadTree(data) {
            this.tree.loadDatas(data);
        }
        show(price, samePrice){
            this.price = price;
            this.choose = price.rela_lid ? price.rela_lid.split(',') : [];
            this.invalid = [];
            for (const sp of samePrice) {
                const lid = sp.rela_lid ? sp.rela_lid.split(',') : [];
                this.invalid.push(...lid);
            }
            for (const node of this.tree.nodes) {
                node.check = this.choose.indexOf(node.ledger_id + '') >= 0;
                node.invalid = this.invalid.indexOf(node.ledger_id + '') >= 0;
            }
            $('#choose-rela-bw').modal('show');
        }
    }
    const chooseRelaBw = new ChooseRelaBw();
    class ChooseRelaChange {
        constructor (){
            const self = this;
            $('#choose-rela-change').on('shown.bs.modal', function() {
                self.initSpread();
                SpreadJsObj.reloadColData(self.sheet, 0, 1);
                SpreadJsObj.reloadRowBackColor(self.sheet, 0, self.change.length);
            });
            $('#choose-rela-change-ok').click(function() {
                const choose_cid = [];
                self.change.forEach(x => {
                    if (x.check) choose_cid.push(x.cid);
                });
                priceOprObj.updateRelaCid(self.price, choose_cid.join(','));
                $('#choose-rela-change').modal('hide');
            });
        }
        initSpread() {
            if (this.spread) return;

            this.spread = SpreadJsObj.createNewSpread($('#rela-change-spread')[0]);
            this.sheet = this.spread.getActiveSheet();
            const spreadSetting = {
                cols: [
                    {title: '选择', colSpan: '1', rowSpan: '1', field: 'check', hAlign: 1, width: 50, formatter: '@',  cellType: 'checkbox'},
                    {title: '变更令', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 150, formatter: '@'},
                    {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 230, formatter: '@'},
                    {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
                ],
                headRows: 1,
                emptyRows: 0,
                headRowHeight: [25],
                defaultRowHeight: 21,
                headerFont: '12px 微软雅黑',
                font: '12px 微软雅黑',
                readOnly: true,
                getColor: function (sheet, data, row, col, defaultColor) {
                    return data && data.invalid ? '#dddddd' : defaultColor;
                }
            };
            SpreadJsObj.initSheet(this.sheet, spreadSetting);
            this.spread.bind(spreadNS.Events.ButtonClicked, function (e, info) {
                const sheet = info.sheet, cellType = sheet.getCellType(info.row, info.col);
                if (!sheet.zh_setting) return;

                if (cellType instanceof spreadNS.CellTypes.CheckBox) {
                    if (sheet.isEditing()) sheet.endEdit(true);
                }

                const col = sheet.zh_setting.cols[info.col];
                if (col.field !== 'check') return;

                const node = SpreadJsObj.getSelectObject(sheet);

                if (!node.check) {
                    if (node.invalid) return;
                    node.check = true;
                    SpreadJsObj.reLoadRowsData(info.sheet, [info.row]);
                } else {
                    node.check = false;
                    SpreadJsObj.reLoadRowsData(info.sheet, [info.row]);
                }
            });
            SpreadJsObj.loadSheetData(this.sheet, SpreadJsObj.DataType.Data, this.change);
        }
        loadChange(data) {
            this.change = data;
        }
        show(price, samePrice) {
            this.price = price;
            this.choose = price.rela_cid ? price.rela_cid.split(',') : [];
            this.invalid = [];
            for (const sp of samePrice) {
                const cid = sp.rela_cid ? sp.rela_cid.split(',') : [];
                this.invalid.push(...cid);
            }
            for (const c of this.change) {
                c.check = this.choose.indexOf(c.cid + '') >= 0;
                c.invalid = this.invalid.indexOf(c.cid + '') >= 0;
                if (!c.check && !c.invalid) {
                    const exist = c.bills.find(x => {
                        return x.code === price.b_code && x.name === price.name && x.unit === price.unit && x.unit_price === price.org_price;
                    });
                    c.visible = !exist;
                }
            }
            $('#choose-rela-change').modal('show');
        }
    }
    const chooseRelaChange = new ChooseRelaChange();

    postData('load', { filter: 'bills;pos;price;change' }, result => {
        revisePrice.loadDatas(result.price, result.bills, result.change);
        SpreadJsObj.loadSheetData(priceSheet, SpreadJsObj.DataType.Data, revisePrice.data);
        ledgerGcl.loadData(result.bills, result.pos);
        chooseRelaBw.loadTree(result.bills);
        chooseRelaChange.loadChange(result.change);
        SpreadJsObj.loadSheetData(priceBwSheet, SpreadJsObj.DataType.Tree, revisePrice.tree);
        SpreadJsObj.loadSheetData(priceChangeSheet, SpreadJsObj.DataType.Data, revisePrice.relaChange);
        $("[content='#ledgerGcl']").click();
    });

    $('a', '#side-menu').bind('click', function (e) {
        e.preventDefault();
        const tab = $(this), tabPanel = $(tab.attr('content'));
        // 展开工具栏、切换标签
        if (!tab.hasClass('active')) {
            $('a', '#side-menu').removeClass('active');
            tab.addClass('active');
            $('#right-view .tab-pane').removeClass('active');
            tabPanel.addClass('active');
            showSideTools(tab.hasClass('active'));
            ledgerGcl.spread.refresh();
            ledgerGcl.xmjSpread.refresh();
        } else {// 收起工具栏
            tab.removeClass('active');
            tabPanel.removeClass('active');
            showSideTools(tab.hasClass('active'));
        }
        priceSpread.refresh();
        priceBwSpread.refresh();
        priceChangeSpread.refresh();
    });
    $('a', '.bcontent-wrap').click(function() {
        $('[name=priceRela]').removeClass('active');
        $(this).addClass('active');
        $('#priceRelaTab').children().removeClass('active');
        $(this.getAttribute('href')).addClass('active');
        priceBwSpread.refresh();
        priceChangeSpread.refresh();
    });
});