Calculation/app/public/js/sr_detail.js

'use strict';

/**
 * 期计量 - 本期计量台账页面 js
 *
 * @author Mai
 * @date 2018/12/7
 * @version
 */
const ckBillsSpread = window.location.pathname + '-billsSelect';
function checkTzMeasureType () {
    return relaTender.measure_type === measureType.tz.value;
}

function transExpr(expr) {
    return $.trim(expr).replace('\t', '').replace('=', '').replace('%', '/100');
}
function getExprInfo (field) {
    const exprField = [
        {qty: 'sgfh_qty', expr: 'sgfh_expr'},
        {qty: 'sjcl_qty', expr: 'sjcl_expr'},
        {qty: 'qtcl_qty', expr: 'qtcl_expr'},
        {qty: 'contract_qty', expr: 'contract_expr'},
    ];
    return _.find(exprField, {qty: field});
}

/**
 * 从cookie中读取缓存的列显示设置，没有则取默认
 * @returns {*[]}
 */
function customColDisplay () {
    const defaultSetting = [
        { title: '本期计量合同', fields: ['contract_qty', 'contract_tp'], visible: true },
        { title: '本期数量变更', fields: ['qc_qty', 'qc_tp', 'qc_bgl'], visible: true },
        { title: '本期完成计量', fields: ['gather_qty', 'gather_tp'], visible: true },
        { title: '截止本期计量合同', fields: ['end_contract_qty', 'end_contract_tp'], visible: true },
        { title: '截止本期数量变更', fields: ['end_qc_qty', 'end_qc_tp', 'end_qc_bgl'], visible: true },
        { title: '截止本期完成计量', fields: ['end_gather_qty', 'end_gather_tp', 'end_gather_percent'], visible: true },
        { title: '本期批注', fields: ['postil'], visible: true },
        { title: '图册号', fields: ['drawing_code'], visible: true },
        { title: '备注', fields: ['memo'], visible: true },
        { title: '总额计量', fields: ['is_tp'], visible: true},
    ];
    if (!checkTzMeasureType()) {
        defaultSetting.unshift({ title: '签约合同', fields: ['deal_qty', 'deal_tp'], visible: true }, { title: '台账', fields: ['quantity', 'total_price'], visible: true});
    }
    const settingStr = Cookies.get(ckColSetting);
    if (settingStr) {
        const customSetting = JSON.parse(settingStr);
        for (const ds of defaultSetting) {
            const cs = customSetting.find(x => {return x.title === ds.title});
            if (cs) ds.visible = cs.visible;
        }
    }
    return defaultSetting;
}

/**
 * 根据列显示设置，调整setting中的列是否显示
 * @param setting
 * @param customDisplay
 */
function customizeStageTreeSetting(setting, customDisplay) {
    for (const cd of customDisplay) {
        for (const c of setting.cols) {
            if (cd.fields.indexOf(c.field) !== -1) {
                c.visible = cd.visible;
            }
        }
    }
}

// 生成所有附件列表
function getAllList(currPageNum = 1) {
    // 每页最多几个附件
    const pageCount = 15;
    // 附件总数
    const total = attData.length;
    // 总页数
    const pageNum = Math.ceil(total/pageCount);
    $('#totalPage').text(pageNum);
    $('#currentPage').text(total === 0 ? 0 : currPageNum);
    // 当前页附件内容
    const currPageAttData = attData.slice((currPageNum-1)*pageCount, currPageNum*pageCount);
    let html = '';
    for(const att of currPageAttData) {
        html += `<tr>
        <td width="25"><input type="checkbox" class="check-file" file-id=${att.id}></td>
        <td>
        <div class="d-flex">
            <a href="javascript:void(0)" class="pl-0 col-11 att-file-name" file-id=${att.id}>${att.filename}${att.fileext}</a>
            <a href="/tender/${relaTender.id}/measure/stage/${relaStage.order}/download/file/${att.id}" class="col-1 pl-0 att-file-btn"><i class="fa fa-download"></i></a>
        </div>
        </td><td>${att.username}</td></tr>`
    }
    $('#alllist-table').html(html);
    $('#alllist-table').on('click', 'tr', function() {
        $('#alllist-table tr').removeClass('bg-light')
        $(this).addClass('bg-light')
    })
}
// 生成当前节点列表
function getNodeList(node) {
    let html = '';
    for(const att of attData) {
        if (node === att.lid) {
            html += `<tr>
            <td width="25"><input type="checkbox" class="check-file" file-id=${att.id}></td>
            <td>
            <div class="d-flex">
                <a href="javascript:void(0)" class="pl-0 col-11 att-file-name" file-id=${att.id}>${att.filename}${att.fileext}</a>
                <a href="/tender/${relaTender.id}/measure/stage/${relaStage.order}/download/file/${att.id}" class="col-1 pl-0 att-file-btn"><i class="fa fa-download"></i></a>
            </div>
            </td><td>${att.username}</td></tr>`
        }
    }
    $('#nodelist-table').html(html);
    $('#nodelist-table').on('click', 'tr', function() {
        $('#nodelist-table tr').removeClass('bg-light');
        $(this).addClass('bg-light');
    })
}

function getGxbyText(data) {
    const def = thirdParty.gxby.find(function (x) {
        return x.value === data.gxby_status;
    });
    return def ? def.name : '';
}
function getDaglText(data) {
    const def = thirdParty.dagl.find(function (x) {
        return x.value === data.dagl_status;
    });
    return def ? def.name : '';
}

function getHintMsg () {
    return {
        invalidExpr: {type: 'warning', msg: '粘贴了非法表达式，已过滤'},
        disableChange: {type: 'error', msg: '不可修改此数据'},
    }
}


$(document).ready(() => {
    let detail, searchLedger;
    // 界面布局
    autoFlashHeight();
    // 初始化 台账树结构 数据结构
    removeLocalCache('bills-fold');
    const stageTreeSetting = {
        id: 'ledger_id',
        pid: 'ledger_pid',
        order: 'order',
        level: 'level',
        rootId: -1,
        keys: ['id', 'tender_id', 'ledger_id'],
        stageId: 'id',
        autoExpand: 3,
        // markFoldKey: 'bills-fold',
        // markFoldSubKey: window.location.pathname.split('/')[2],
        markExpandKey: 'stage-bills-expand',
        markExpandSubKey: window.location.pathname.split('/')[2],
    };
    // 台账树结构计算相关设置
    stageTreeSetting.updateFields = ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp', 'postil', 'used', 'contract_expr'];
    stageTreeSetting.calcFields = ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp', 'end_contract_tp', 'end_qc_tp', 'end_gather_tp', 'end_correct_tp'];
    stageTreeSetting.calcFun = function (node) {
        if (!node.children || node.children.length === 0) {
            node.gather_qty = ZhCalc.add(node.contract_qty, node.qc_qty);
            node.end_gather_qty = ZhCalc.add(node.end_contract_qty, node.end_qc_qty);
        }
        node.gather_tp = ZhCalc.add(node.contract_tp, node.qc_tp);
        node.end_gather_tp = ZhCalc.add(node.end_contract_tp, node.end_qc_tp);
        node.end_final_tp = ZhCalc.add(node.end_qc_tp, node.total_price);
        if (!node.children || node.children.length === 0) {
            if (node.end_contract_qty) {
                node.end_correct_tp = ZhCalc.add(node.end_qc_tp, ZhCalc.mul(node.end_contract_qty, node.unit_price, tenderInfo.decimal.tp));
            } else {
                node.end_correct_tp = node.end_gather_tp;
            }
        }
        node.end_gather_percent = ZhCalc.mul(ZhCalc.div(node.end_gather_tp, node.end_final_tp), 100, 2);
        node.end_correct_percent = ZhCalc.mul(ZhCalc.div(node.end_correct_tp, node.end_final_tp), 100, 2);
        node.final_dgn_price = ZhCalc.round(ZhCalc.div(node.end_gather_tp, ZhCalc.add(node.deal_dgn_qty1, node.c_dgn_qty1)), tenderInfo.decimal.up);
    };
    const stageTree = createNewPathTree('stage', stageTreeSetting);
    // 初始化 计量单元 数据结构
    const stagePosSetting = { id: 'id', ledgerId: 'lid' };
    stagePosSetting.calcFun = function (pos) {
        pos.gather_qty = ZhCalc.add(pos.contract_qty, pos.qc_qty);
        pos.end_gather_qty = ZhCalc.add(pos.end_contract_qty, pos.end_qc_qty);
        pos.sum = ZhCalc.add(pos.end_qc_qty, pos.quantity);
        pos.end_gather_percent = ZhCalc.mul(ZhCalc.div(pos.end_gather_qty, pos.sum), 100, 2);
        pos.estimate_qty = !checkZero(pos.real_qty)
            ? ZhCalc.sub(ZhCalc.sub(pos.real_qty, pos.quantity), pos.end_qc_qty)
            : null;
    };
    const stagePos = new StagePosData(stagePosSetting);

    // 初始化 台账 spread
    const slSpread = SpreadJsObj.createNewSpread($('#stage-ledger')[0]);
    customizeStageTreeSetting(ledgerSpreadSetting, customColDisplay());
    const ratioCol = ledgerSpreadSetting.cols.find(x => {return x.field === 'end_gather_percent' || x.field === 'end_correct_percent'});
    ratioCol.field = tenderInfo.display.stage.correct ? 'end_correct_percent' : 'end_gather_percent';
    ledgerSpreadSetting.imageClick = function (data, hitinfo) {
        const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
        if (col.field === 'dagl') data.dagl_url && window.open(data.dagl_url);
    };
    ledgerSpreadSetting.dgnUpFields = ['deal_dgn_qty1', 'deal_dgn_qty2', 'c_dgn_qty1', 'c_dgn_qty2'];
    ledgerSpreadSetting.getColor = function (sheet, data, row, col, defaultColor) {
        if (data) {
            if (col.field === 'gxby') {
                const def = thirdParty.gxby.find(function (x) {
                    return x.value === data.gxby_status;
                });
                if (def && def.color) return def.color;
            } else if (col.field === 'dagl') {
                const def = thirdParty.dagl.find(function (x) {
                    return x.value === data.dagl_status;
                });
                if (def && def.color) return def.color;
            }

            return checkUtils.billsOver(data, checkTzMeasureType(), stagePos) ? '#f8d7da' : defaultColor;
        } else {
            return defaultColor;
        }
    };
    sjsSettingObj.setFxTreeStyle(ledgerSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
    sjsSettingObj.setPropValue(ledgerSpreadSetting, ['gxby'], 'getValue', getGxbyText);
    sjsSettingObj.setPropValue(ledgerSpreadSetting, ['dagl'], 'getValue', getDaglText);
    const lDaglCol = _.find(ledgerSpreadSetting.cols, {field: 'dagl'});
    if (lDaglCol) {
        lDaglCol.getValue = getDaglText;
        lDaglCol.cellType = 'activeImageBtn';
        lDaglCol.normalImg = '#rela-file-icon';
        lDaglCol.indent = 5;
        lDaglCol.imgAlign = 2;
        lDaglCol.showImage = function (data) { return data && data.dagl_url; }
    }
    if (thousandth) sjsSettingObj.setTpThousandthFormat(ledgerSpreadSetting);
    ledgerSpreadSetting.headColWidth = [50];
    ledgerSpreadSetting.rowHeader = [
        {
            rowHeaderType: 'tag',
            setting: {
                indent: 14,
                tagSize: 0.8,
                tagFont: '8px 微软雅黑',
                getColor: function (index, data) {
                    if (!data) return;
                    return billsTag.getBillsTagsColor(data.id);
                },
                getTagHtml: function (index, data) {
                    if (!data) return;
                    const getHtml = function (list) {
                        if (!list || list.length === 0) return '';
                        const html = [];
                        for (const l of list) {
                            html.push('<div class="row mr-1">');
                            html.push(`<div class="col-auto pr-1 ${l.tagClass}">`, '<i class="fa fa-tag"></i>', '</div>');
                            html.push('<div class="col p-0">', '<p>', l.comment, '</p>', '</div>');
                            html.push('</div>');
                        }
                        return html.join('');
                    };
                    return getHtml(billsTag.getBillsTagsInfo(data.id));
                }
            },
        },
    ];
    SpreadJsObj.initSheet(slSpread.getActiveSheet(), ledgerSpreadSetting);
    slSpread.getActiveSheet().frozenColumnCount(5);
    slSpread.getActiveSheet().options.frozenlineColor = '#93b5e4';

    //初始化所有附件列表
    getAllList();

    // 初始化 计量单元 Spread
    const spSpread = SpreadJsObj.createNewSpread($('#stage-pos')[0]);
    const spCol = _.find(posSpreadSetting.cols, {field: 'qc_qty'});
    spCol.cellType = 'activeImageBtn';
    spCol.normalImg = '#ellipsis-icon';
    spCol.indent = 5;
    spCol.showImage = function (data) {
        return data !== undefined && data !== null;
    };
    posSpreadSetting.imageClick = function (data, hitinfo) {
        const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
        if (col.field === 'dagl') data.dagl_url && window.open(data.dagl_url);
    };
    posSpreadSetting.getColor = function (sheet, data, row, col, defaultColor) {
        if (data) {
            if (col.field === 'gxby') {
                const def = thirdParty.gxby.find(function (x) {
                    return x.value === data.gxby_status;
                });
                if (def && def.color) return def.color;
            } else if (col.field === 'dagl') {
                const def = thirdParty.dagl.find(function (x) {
                    return x.value === data.dagl_status;
                });
                if (def && def.color) return def.color;
            }
        }
        if (checkTzMeasureType()) {
            return checkUtils.posOver(data)  ? '#f8d7da' : defaultColor;
        }
    };
    sjsSettingObj.setGridSelectStyle(posSpreadSetting);
    if (thousandth) sjsSettingObj.setTpThousandthFormat(posSpreadSetting);
    sjsSettingObj.setPropValue(posSpreadSetting, ['gxby'], 'getValue', getGxbyText);
    sjsSettingObj.setPropValue(posSpreadSetting, ['dagl'], 'getValue', getDaglText);
    const pDaglCol = _.find(posSpreadSetting.cols, {field: 'dagl'});
    if (pDaglCol) {
        pDaglCol.getValue = getDaglText;
        pDaglCol.cellType = 'activeImageBtn';
        pDaglCol.normalImg = '#rela-file-icon';
        pDaglCol.indent = 5;
        pDaglCol.imgAlign = 2;
        pDaglCol.showImage = function (data) { return data && data.dagl_url; }
    }
    SpreadJsObj.initSheet(spSpread.getActiveSheet(), posSpreadSetting);

    const billsTag = $.billsTag({
        selector: '#bills-tag',
        relaSpread: slSpread,
        updateUrl: window.location.pathname + '/tag',
        readOnly: true,
        afterModify: function (nodes) {
            SpreadJsObj.repaintNodesRowHeader(slSpread.getActiveSheet(), nodes);
        },
        afterLocated:  function () {
            stagePosSpreadObj.loadCurPosData();
        },
        afterShow: function () {
            slSpread.refresh();
            if (spSpread) spSpread.refresh();
        },
    });

    const stageTreeSpreadObj = {
        loadExprToInput(sheet) {
            const sel = sheet.getSelections()[0];
            const col = sheet.zh_setting.cols[sel.col];
            if (col.type === 'Number') {
                const data = SpreadJsObj.getSelectObject(sheet);
                if (!data) {
                    $('#bills-expr').val('');
                    return;
                }
                const nodePos = stagePos.getLedgerPos(data.id);
                if (nodePos && nodePos.length > 0) {
                    $('#bills-expr').val('');
                } else {
                    const exprInfo = getExprInfo(col.field);
                    const value = exprInfo && data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field];
                    $('#bills-expr').val(value).attr('field', col.field).attr('org', data[col.field]);
                }
            } else {
                $('#bills-expr').val('');
            }
        },
        selectionChanged: function (e, info) {
            if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
                SpreadJsObj.resetTopAndSelect(spSpread.getActiveSheet());
                stagePosSpreadObj.loadCurPosData();
                if (posSearch) {
                    posSearch.search();
                }
            }
            SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
            stageTreeSpreadObj.loadExprToInput(info.sheet);
        },
        topRowChanged(e, info) {
            SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
        },
    };
    slSpread.bind(spreadNS.Events.SelectionChanged, stageTreeSpreadObj.selectionChanged);
    slSpread.bind(spreadNS.Events.TopRowChanged, stageTreeSpreadObj.topRowChanged);
    stageTreeSpreadObj.loadExprToInput(slSpread.getActiveSheet());
    $.contextMenu({
        selector: '#stage-ledger',
        build: function ($trigger, e) {
            const target = SpreadJsObj.safeRightClickSelection($trigger, e, slSpread);
            return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
        },
        items: {
            'locateZjjl': {
                name: '定位至中间计量',
                icon: 'fa-sign-in',
                callback: function (key, opt) {
                    if (!detail) {
                        detail = new Detail($('#detail-spread'));
                    }
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    const [leafUsedBills, usedPos] = stageIm.getFirstUsed(node);
                    if (leafUsedBills) {
                        if (!$('#zhongjian').hasClass('active')) {
                            const tab = $('#zhongjiantab'), tabPanel = $(tab.attr('content'));
                            $('a', '.side-menu').removeClass('active');
                            $('.tab-content .tab-select-show').removeClass('active');
                            tab.addClass('active');
                            tabPanel.addClass('active');
                            showSideTools(tab.hasClass('active'));
                            slSpread.refresh();
                            spSpread.refresh();
                        }
                        const relaXmj = stageIm.getRelaXmj(leafUsedBills);
                        const im = stageIm.getRelaImData(relaXmj, leafUsedBills, usedPos);
                        SpreadJsObj.locateData(detail.sheet, im);
                        detail.spread.refresh();
                        $('#zhongjian .sjs-bottom').height('400px');
                        $('.zhongjian-msg').height($('#zhongjian .sjs-bottom').height());
                        detail.reLoadDetailData();
                    } else {
                        toastr.error('无可定位中间计量');
                    }
                },
            },
            tagSpr: '----',
            tag: {
                name: '书签',
                callback: function (key, opt, menu, e) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    addTag.do(node);
                },
                disabled: function (key, opt) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return !node;
                }
            },
            showSpr: '----',
            showLast: {
                name: '显示至最底层',
                callback: function (key, opt, menu, e) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    setTimeout(() => {
                        showWaitingView();
                        stageTree.expandByCustom(x => {
                            return x.expanded || (x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0);
                        });
                        SpreadJsObj.refreshTreeRowVisible(slSpread.getActiveSheet());
                        closeWaitingView();
                    }, 100);
                },
            },
            exportSpr: '----',
            exportSelectNodeXlsx: {
                name: '导出选中节点至Excel',
                callback: function (key, opt, menu, e) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    stageTreeSpreadObj.exportExcel($('.sidebar-title').attr('data-original-title') + `计量台账(${node.name || ''}).xlsx`, [node]);
                },
                disabled: function (key, opt) {
                    const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                    return !node;
                }
            },
        }
    });

    const stagePosSpreadObj = {
        loadExprToInput(sheet) {
            const sel = sheet.getSelections()[0];
            if (!sel) return;

            const col = sheet.zh_setting.cols[sel.col];
            if (col && col.type === 'Number') {
                const data = SpreadJsObj.getSelectObject(sheet);
                if (data) {
                    const exprInfo = getExprInfo(col.field);
                    const value = exprInfo && data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field];
                    $('#pos-expr').val(value);
                } else {
                    $('#pos-expr').val('');
                }
            } else {
                $('#pos-expr').val('');
            }
        },
        /**
         * 加载计量单元 根据当前台账选择节点
         */
        loadCurPosData: function () {
            const sheet = slSpread.getActiveSheet();
            const node = SpreadJsObj.getSelectObject(sheet);
            if (node) {
                const posData = stagePos.ledgerPos[itemsPre + node.id] || [];
                SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', posData);
                getNodeList(node.id);
                // 如果是附件是当前节点，隐藏
                // if ($('#dqjiedian').hasClass('active')) {
                //     $('#showAttachment').hide();
                // }
            } else {
                SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', []);
            }
            stagePosSpreadObj.loadExprToInput(spSpread.getActiveSheet());
        },
        selectionChanged: function (e, info) {
            stagePosSpreadObj.loadExprToInput(info.sheet);
        },
    };
    // 加载上下窗口resizer
    $.divResizer({
        select: '#main-resize',
        callback: function () {
            slSpread.refresh();
            let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent-30);
            spSpread.refresh();
            window.getSelection ? window.getSelection().removeAllRanges() : document.selection.empty();
        }
    });

    // 加载计量单元数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
    postData(window.location.pathname + '/load', { filter: 'ledger;pos;detail;change;tag;sumDeal' }, function (result) {
        for (const l of result.ledgerData) {
            const sd = result.sumDeal.find(x => { return x.code === l.b_code && x.name === l.name && x.unit === l.unit; });
            if (sd) {
                l.unit_price = sd.unit_price;
                l.deal_tp = ZhCalc.mul(l.unit_price, l.deal_qty, tenderInfo.decimal.tp);
                l.sgfh_tp = ZhCalc.mul(l.unit_price, l.sgfh_qty, tenderInfo.decimal.tp);
                l.sjcl_tp = ZhCalc.mul(l.unit_price, l.sjcl_qty, tenderInfo.decimal.tp);
                l.qtcl_tp = ZhCalc.mul(l.unit_price, l.qtcl_qty, tenderInfo.decimal.tp);
                l.total_price = ZhCalc.mul(l.unit_price, l.quantity, tenderInfo.decimal.tp);
            }
        }
        // 加载树结构
        stageTree.loadDatas(result.ledgerData);
        treeCalc.calculateAll(stageTree);
        for (const t of result.tags) {
            t.node = stageTree.datas.find(x => {return x.id === t.lid});
        }
        billsTag.loadDatas(result.tags);
        // 加载部位明细
        stagePos.loadDatas(result.posData);
        stagePos.calculateAll();
        SpreadJsObj.loadSheetData(slSpread.getActiveSheet(), 'tree', stageTree);
        SpreadJsObj.loadTopAndSelect(slSpread.getActiveSheet(), ckBillsSpread);
        stagePosSpreadObj.loadCurPosData();
        SpreadJsObj.resetTopAndSelect(spSpread.getActiveSheet());
        // 加载中间计量
        stageIm.init(relaStage, imType, tenderInfo.decimal);
        stageIm.loadData(result.ledgerData, result.posData, result.detailData, result.changeData);
    }, null, true);
    spSpread.bind(spreadNS.Events.SelectionChanged, stagePosSpreadObj.selectionChanged);

    $.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();
            slSpread.refresh();
            spSpread.refresh();
            if (searchLedger) searchLedger.spread.refresh();
            if (detail) detail.spread.refresh();
        }
    });

    const posSearch = (function () {
        let resultArr = [];
        const search = function () {
            resultArr = [];
            const keyword = $('#pos-search-keyword').val();
            const checkOver = $('#pos-over-search')[0].checked;
            const checkEmpty = $('#pos-empty-search')[0].checked;
            const sortData = spSpread.getActiveSheet().zh_data;
            if (checkOver || checkEmpty) {
                if (sortData) {
                    for (let i = 0, iLength = sortData.length; i < iLength; i++) {
                        const sd = sortData[i];
                        let match = false;
                        if (checkOver) {
                            if (sd.end_gather_qty) {
                                if (!sd.quantity || Math.abs(sd.end_gather_qty) > Math.abs(ZhCalc.add(sd.quantity, sd.end_qc_qty))) match = true;
                            }
                        }
                        if (checkEmpty) {
                            if (sd.quantity) {
                                if (!sd.end_gather_qty || ZhCalc.sub(ZhCalc.add(sd.quantity, sd.end_qc_qty), sd.end_gather_qty) > 0) match = true;
                            }
                        }
                        if (keyword && keyword !== '' && sd.name && sd.name.indexOf(keyword) === -1) match = false;
                        if (match) {
                            resultArr.push({index: i, data: sd});
                        }
                    }
                }
            } else if (keyword && keyword !== '') {
                if (sortData) {
                    for (let i = 0, iLength = sortData.length; i < iLength; i++) {
                        const sd = sortData[i];
                        if (sd.name && sd.name.indexOf(keyword) > -1) {
                            resultArr.push({index: i, data: sd});
                        }
                    }
                }
            }
            $('#pos-search-result').html('结果：' + resultArr.length);
        };
        const searchAndLocate = function () {
            search();
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                const pos = resultArr[0];
                if (pos.index !== curRow) {
                    sheet.setSelection(pos.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(pos.index, spreadNS.VerticalPosition.center);
                    SpreadJsObj.reloadRowsBackColor(sheet, [pos.index, curRow]);
                }
            }
        };
        const locateNext = function () {
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                let next = _.find(resultArr, function (d) {
                    return d.index > curRow;
                });
                if (!next) next = resultArr[0];
                if (next.index !== curRow) {
                    sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(next.index, spreadNS.VerticalPosition.center);
                    SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]);
                }
            }
        };
        const locatePre = function () {
            if (resultArr.length > 0) {
                const sheet = spSpread.getActiveSheet();
                const sel = sheet.getSelections()[0];
                const curRow = sel ? sel.row : 0;
                let next = _.findLast(resultArr, function (d) {
                    return d.index < curRow;
                });
                if (!next) next = resultArr[resultArr.length - 1];
                if (next.index !== curRow) {
                    sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
                    sheet.showRow(next.index, spreadNS.VerticalPosition.center);
                    SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]);
                }
            }
        };
        return {search, searchAndLocate, locateNext, locatePre};
    })();
    $('#pos-search-keyword').bind('keydown', function(e){
        if (e.keyCode == 13) posSearch.searchAndLocate();
    });
    $('#pos-empty-search').click(function () {
        if (this.checked) {
            $('[for=' + this.id +']').addClass('text-warning');
        } else {
            $('[for=' + this.id +']').removeClass('text-warning');
        }
        if (this.checked) {
            if ($('#pos-over-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '漏计中按名称查询');
            }
        } else {
            if ($('#pos-over-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '超计中按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            }
        }
        posSearch.searchAndLocate();
    });
    $('#pos-over-search').click(function () {
        if (this.checked) {
            $('[for=' + this.id +']').addClass('text-danger');
        } else {
            $('[for=' + this.id +']').removeClass('text-danger');
        }
        if (this.checked) {
            if ($('#pos-empty-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '超计中按名称查询');
            }
        } else {
            if ($('#pos-empty-search')[0].checked) {
                $('#pos-search-keyword').attr('placeholder', '漏计中按名称查询');
            } else {
                $('#pos-search-keyword').attr('placeholder', '按名称查询');
            }
        }
        posSearch.searchAndLocate();
    });
    $('#pos-search-next').click(() => {posSearch.locateNext()});
    $('#pos-search-pre').click(() => {posSearch.locatePre()});

    $.divResizer({
        select: '#right-spr',
        callback: function () {
            slSpread.refresh();
            spSpread.refresh();
            if (searchLedger) {
                searchLedger.spread.refresh();
            }
            if (detail) {
                detail.spread.refresh();
            }
            window.getSelection ? window.getSelection().removeAllRanges() : document.selection.empty();
        }
    });

    // 中间计量加载上下窗口resizer
    $.divResizer({
        select: '#zhongjian-spr',
        callback: function () {
            if (detail) {
                detail.spread.refresh();
            }
            $('.zhongjian-msg').height($('#zhongjian .sjs-bottom').height());
            window.getSelection ? window.getSelection().removeAllRanges() : document.selection.empty();
        }
    });

    // 附件加载上下窗口resizer
    $.divResizer({
        select: '#file-spr',
        callback: function () {
            window.getSelection ? window.getSelection().removeAllRanges() : document.selection.empty();
        }
    });

    class Detail {
        constructor (obj) {
            const self = this;
            this.spreadSetting = {
                cols: [
                    {title: '编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 80, formatter: '@'},
                    {title: '中间计量表号', colSpan: '1', rowSpan: '1', field: 'im_code', hAlign: 0, width: 85, formatter: '@'},
                    {title: '交工证书/凭证号', colSpan: '1', rowSpan: '1', field: 'doc_code', hAlign: 0, width: 110, formatter: '@'},
                    {
                        title: relaStage.im_type === imType.tz.value ? '本期计量金额' : '本期计量数量',
                        colSpan: '1', rowSpan: '1', field: 'jl', hAlign: 2, width: 85, formatter: '@'
                    },
                ],
                headRows: 1,
                emptyRows: 0,
                headRowHeight: [32],
                headColWidth: [30],
                defaultRowHeight: 21,
                headerFont: '12px 微软雅黑',
                font: '12px 微软雅黑',
                readOnly: true,
                selectedBackColor: '#fffacd',
            };
            this.spread = SpreadJsObj.createNewSpread(obj[0]);
            this.sheet = this.spread.getActiveSheet();
            SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);

            this.detailObj = {
                selectionChanged: function (e, info) {
                    self.reLoadDetailData();
                    if (!info.oldSelections || !info.oldSelections[0] || info.oldSelections[0].row !== info.newSelections[0].row) {
                        self.loadLocateInfo();
                    }
                },
            };

            this.spread.bind(spreadNS.Events.SelectionChanged, this.detailObj.selectionChanged);

            this._initLocateRela();
            this.reBuildImData();
        }
        _initImTypeSetRela() {
            const self = this;
            const gatherConfirmPopover = {
                reBind: function (obj, eventName, fun) {
                    obj.unbind(eventName);
                    obj.bind(eventName, fun);
                },
                check: function (pos, hint, okCallback) {
                    const confirmObj = $('#gather-confirm'), hintObj = $('#gather-confirm-hint');
                    const okObj = $('#gather-confirm-ok'), cancelObj = $('#gather-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();
                }
            };
            this.gsTree = stageIm.getGsTree();

            if (relaStage.im_type === imType.tz.value || relaStage.im_type === imType.bb.value) {
                const jlCol = self.spreadSetting.cols.find(function (x) {return x.field === 'jl'});
                jlCol.title = '本期计量金额';
                SpreadJsObj.reLoadSheetHeader(self.sheet);
                $('#type-title-contract').text('本期合同计量金额');
                $('#type-title-qc').text('本期变更计量金额');
            } else {
                const jlCol = self.spreadSetting.cols.find(function (x) {return x.field === 'jl'});
                jlCol.title = '本期计量数量';
                SpreadJsObj.reLoadSheetHeader(self.sheet);
                $('#type-title-contract').text('本期合同计量数量');
                $('#type-title-qc').text('本期变更计量数量');
            }
            if (relaStage.im_type === imType.bb.value || relaStage.im_type === imType.bw.value) {
                $('#show-jldy').parent().show();
                $('#jldy').parent().show();
                $('#show-xm-name').parent().hide();
                $('#xm-name').parent().hide();
            } else {
                $('#show-jldy').parent().hide();
                $('#jldy').parent().hide();
                $('#show-xm-name').parent().show();
                $('#xm-name').parent().show();
            }
        }
        _initLocateRela() {
            const self = this;
            $('#im-locate2bills').click(function () {
                const curIndex = parseInt($('#im-locate-info')[0].innerText.split('/')[0]);
                const select = SpreadJsObj.getSelectObject(self.spread.getActiveSheet());
                if (select && select.source) {
                    SpreadJsObj.locateTreeNode(slSpread.getActiveSheet(), select.source[curIndex-1].id, true);
                    stagePosSpreadObj.loadCurPosData();
                }
            });
            $('#im-locate-pre').click(function () {
                const curIndex = parseInt($('#im-locate-info')[0].innerText.split('/')[0]);
                const select = SpreadJsObj.getSelectObject(self.spread.getActiveSheet());
                if (select && select.source) {
                    const targetIndex = Math.max(curIndex-1, 1);
                    SpreadJsObj.locateTreeNode(slSpread.getActiveSheet(), select.source[targetIndex-1].id, true);
                    stagePosSpreadObj.loadCurPosData();
                    $('#im-locate-info')[0].innerText = targetIndex + '/' + select.source.length;
                }
            });
            $('#im-locate-next').click(function () {
                const curIndex = parseInt($('#im-locate-info')[0].innerText.split('/')[0]);
                const select = SpreadJsObj.getSelectObject(self.spread.getActiveSheet());
                if (select && select.source) {
                    const targetIndex = Math.min(curIndex+1, select.source.length);
                    SpreadJsObj.locateTreeNode(slSpread.getActiveSheet(), select.source[targetIndex-1].id, true);
                    stagePosSpreadObj.loadCurPosData();
                    $('#im-locate-info')[0].innerText = targetIndex + '/' + select.source.length;
                }

            });
        }
        loadLocateInfo() {
            const select = SpreadJsObj.getSelectObject(this.sheet);
            if (select && select.source.length > 1) {
                $('#im-locate2bills').next().show();
            } else {
                $('#im-locate2bills').next().hide();
            }
            $('#im-locate-info')[0].innerText = '1/' + (select ? select.source.length : '0');
        }
        reLoadDetailData() {
            const data = SpreadJsObj.getSelectObject(this.spread.getActiveSheet());

            $('#detail-show').show();

            const contractJl = data && data.contract_jl ? data.contract_jl : '';
            $('#show-contract-jl').text(contractJl);
            $('#contract-jl').val(contractJl);

            const qcJl = data && data.qc_jl ? data.qc_jl : '';
            $('#show-qc-jl').text(qcJl);
            $('#qc-jl').val(qcJl);

            const bglCode = data && data.bgl_code ? data.bgl_code : '';
            $('#show-bgl-code').text(bglCode);
            $('#bgl-code').val(bglCode);

            const bglDrawingCode = data && data.bgl_drawing_code ? data.bgl_drawing_code : '';
            $('#show-bgl-drawing-code').text(bglDrawingCode);
            $('#bgl-drawing-code').val(bglDrawingCode);

            const bwName = data && data.bw ? data.bw : '';
            $('#show-bw-name').text(bwName);
            $('#bw-name').val(bwName);

            const position = data && data.position ? data.position : '';
            $('#show-position').text(position);
            $('#position').val(position);

            const peg = data && data.peg ? data.peg : '';
            $('#show-peg').text(peg);
            $('#peg').val(peg);

            const xmName = data && data.xm ? data.xm: '';
            $('#show-xm-name').text(xmName);
            $('#xm-name').val(xmName);

            const jldy = data && data.jldy ? data.jldy: '';
            $('#show-jldy').text(jldy);
            $('#jldy').val(jldy);

            const drawingCode = data && data.drawing_code ? data.drawing_code: '';
            $('#show-drawing-code').text(drawingCode);
            $('#drawing-code').val(drawingCode);

            const calcMemo = data && data.calc_memo ? data.calc_memo: '';
            $('#show-calc-memo').html(calcMemo.replace(/\n/g, '<br/>'));
            $('#calc-memo').val(calcMemo);

            const calcImgSrc = data && data.calc_img ? '/' + data.calc_img : '';
            $('#show-calc-img').attr('src', calcImgSrc);
            $('#calc-img').attr('src', calcImgSrc);
            $('#view-calc-img').attr('src', calcImgSrc);

            const calcImgRemark = data && data.calc_img_remark || '';
            $('#view-calc-remark').val(calcImgRemark);
            $("#view-calc-remark").attr('readonly', true);
            $('#text-edit').val(calcImgRemark)
        }
        reBuildImData() {
            const imData = stageIm.buildImData();
            SpreadJsObj.loadSheetData(this.sheet, SpreadJsObj.DataType.Data, imData);
            this.reLoadDetailData();
            this.loadLocateInfo();
        }
    }
    // 展开收起附件
    $('a', '.right-nav').bind('click', function () {
        //const main = $('#main-view'), tool = $('#tools-view');
        const tab = $(this), tabPanel = $(tab.attr('content'));
        if (!tab.hasClass('active')) {
            $('a', '.side-menu').removeClass('active');
            $('.tab-content .tab-select-show').removeClass('active');
            tab.addClass('active');
            tabPanel.addClass('active');
            showSideTools(tab.hasClass('active'));
            if (tab.attr('content') === '#search' && !searchLedger) {
                searchLedger = $.billsSearch({
                    selector: '#search',
                    searchSpread: slSpread,
                    searchRangeStr: '项目节编号/名称',
                    searchOver: true,
                    searchEmpty: true,
                    resultSpreadSetting: {
                        cols: [
                            {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@'},
                            {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
                            {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@'},
                            {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'},
                            {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
                            {title: '数量', field: 'quantity', hAlign: 2, width: 50},
                            {title: '完成率(%)', field: 'complete_percent', hAlign: 2, width: 70},
                        ],
                        emptyRows: 0,
                        headRows: 1,
                        headRowHeight: [32],
                        headColWidth: [30],
                        defaultRowHeight: 21,
                        headerFont: '12px 微软雅黑',
                        font: '12px 微软雅黑',
                        selectedBackColor: '#fffacd',
                    },
                    afterLocated: function () {
                        stagePosSpreadObj.loadCurPosData();
                    },
                    customSearch: [
                        {
                            key: 'less', title: '漏计', valid: true,
                            check: function (node) {
                                if (node.quantity) {
                                    return ZhCalc.sub(ZhCalc.add(node.quantity, node.end_qc_qty), node.end_gather_qty) > 0;
                                } else if (node.total_price) {
                                    return ZhCalc.sub(ZhCalc.add(node.total_price, node.end_qc_tp), node.end_gather_tp) > 0;
                                }
                            }
                        }, {
                            key: 'over', title: '超计', valid: true,
                            check: function (node) {
                                return checkUtils.billsOver(node, checkTzMeasureType(), stagePos);
                            }
                        }, {
                            key: 'empty', title: '漏计', valid: false,
                            check: function (node) {
                                if (node.quantity) {
                                    return !node.end_gather_qty || checkZero(node.end_gather_qty);
                                } else if (node.total_price) {
                                    return !node.end_gather_tp || checkZero(node.end_gather_tp);
                                }
                            }
                        },
                    ],
                });
                searchLedger.spread.refresh();
            }
            if (tab.attr('content') === '#fujian') {
                const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
                getNodeList(node.id);
            }
            if (tab.attr('content') === '#zhongjian') {
                if (!detail) {
                    detail = new Detail($('#detail-spread'));
                    detail.spread.refresh();
                    $('#zhongjian .sjs-bottom').height('400px');
                    $('.zhongjian-msg').height($('#zhongjian .sjs-bottom').height());
                } else {
                    detail.spread.refresh();
                }
            }
        } else {
            tab.removeClass('active');
            tabPanel.removeClass('active');
            showSideTools(tab.hasClass('active'));
        }
        slSpread.refresh();
        spSpread.refresh();
    });

    // 切换附件里节点和所有附件
    $('#fujian .nav-link').on('click', function () {
        const tabPanel = $(this).attr('fujian-content');
        if (tabPanel !== 'syfujian') {
            $('#showPage').hide();
            $('#bach-download').prop('type', 'curr');
        } else {
            $('#showPage').show();
            $('#bach-download').prop('type', 'all')
        }
        $('#showAttachment').hide();
    });

    // 获取附件信息
    $('.list-table').on('click', '.att-file-name', function () {
        const fid = $(this).attr('file-id');
        if ($('#showAttachment').attr('file-id') === fid && !$('#showAttachment').is(":hidden")) {
            return;
        }
        const att = attData.find(function (item) {
            return item.id === parseInt(fid);
        });
        $('#edit-att').hide();
        $('#show-att').show();
        if (att !== undefined) {
            // 进来先把编辑功能隐藏
            $('#btn-att a').eq(3).hide()
            $('#show-att tr').eq(0).children('td').text(att.filename + att.fileext);
            const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
            $('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + att.lname));
            $('#show-att tr').eq(2).children('td').eq(0).text(att.username);
            $('#show-att tr').eq(2).children('td').eq(1).text(att.in_time);
            $('#show-att tr').eq(3).children('td').text(att.remark);
            // 附件uid等于当前用户id, 附件上传本人
            if (parseInt(cur_uid) === att.uid) {
                $('#btn-att').show();
                $('#btn-att a').eq(2).hide();
                $('#btn-att a').eq(4).hide();
                $('#btn-att a').eq(5).hide();
            } else {
                $('#btn-att').hide();
                $('#btn-att a').eq(3).hide();
                $('#btn-att a').eq(2).hide();
                $('#btn-att a').eq(4).hide();
                $('#btn-att a').eq(5).hide();
            }
            $('#showAttachment').attr('file-id', fid);
            $('#showAttachment').show();
        } else {
            $('#showAttachment').hide();
            $('#showAttachment').attr('file-id', '');
            toastr.error('附件信息获取失败');
        }
    });
    // $('body').on('click', '.alllist-table a', handleFileList);
    $('body').on('click', '#btn-att a', function () {
        const content = $(this).attr('content');
        const fid = $('#showAttachment').attr('file-id');
        const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
        if (content === 'view') {
            const data = {id: fid};
            postData('/tender/' + relaTender.id + '/measure/stage/' + relaStage.order + '/check/file', data, function (result) {
                const { filepath } = result
                $('#load-file').attr('href', filepath);
                $('#load-file')[0].click();
            });
        } else if (content === 'location') {
            const att = attData.find(item => item.id === parseInt(fid));
            if (Object.keys(att).length) {
                SpreadJsObj.locateTreeNode(slSpread.getActiveSheet(), att.ledger_id, true);
                stagePosSpreadObj.loadCurPosData();
            }
        }
    });

    // 切换页数
    $('.page-select').on('click', function () {
        const totalPageNum = parseInt($('#totalPage').text());
        const lastPageNum = parseInt($('#currentPage').text());
        const status = $(this).attr('content');
        if (status === 'pre' && lastPageNum > 1) {
            getAllList(lastPageNum-1);
            $('#showAttachment').hide();
            $('#syfujian .check-all-file').prop('checked', false)
        } else if (status === 'next' && lastPageNum < totalPageNum) {
            getAllList(lastPageNum+1);
            $('#showAttachment').hide();
            $('#syfujian .check-all-file').prop('checked', false)
        }
    });

    // 批量下载
    $('#bach-download').click(function() {
        const fileIds = [];
        const type = $(this).attr('type');
        let node = ''
        if (type === 'curr') {
            node = '#nodelist-table .check-file:checked'
        } else {
            node = '#alllist-table .check-file:checked'
        }
        $(node).each(function() {
            const fileId = $(this).attr('file-id');
            fileId && fileIds.push(fileId);
        });

        if (fileIds.length) {
            if (fileIds.length > 10) {
              return toastr.warning(`最大允许10个文件(当前${fileIds.length}个)`)
            }
            toastr.success('正在进行压缩文件...', '', { timeOut: 0, extendedTimeOut: 0})
            $(this).attr('disabled', "true")
            const btn = $(this)
            postCompressFile(`/tender/${relaTender.id}/measure/stage/${relaStage.order}/download/compresse-file`, {fileIds}, function(result) {
              toastr.clear()
              toastr.success('压缩文件成功')
              btn.removeAttr('disabled')
              const href = window.URL.createObjectURL(result)
              $('#zipDown').attr('href', href);
              $('#zipDown').attr('download', `${relaTender.name}-计量台账-第${relaStage.order}期-附件.zip`);
              $("#zipDown")[0].click();
            }, () => {
              btn.removeAttr('disabled')
              toastr.clear()
              toastr.error('批量下载失败')
            });
        }
    });

    // 监听附件check是否选中
    $('.list-table').on('click', '.check-file', function() {
        const checkedList = $(this).parents('.list-table').children().find('input:checked');
        const childs = $(this).parents('.list-table').children().length;
        const checkBox = $(this).parents('.list-table').parent().find('.check-all-file');
        if (checkedList.length === childs) {
            checkBox.prop("checked", true);
        } else {
            checkBox.prop("checked", false);
        }
    });
    $('.check-all-file').click(function() {
        const isCheck = $(this).is(':checked');
        $(this).parents('table').find('.list-table').each(function() {
            $(this).find('input:checkbox').prop("checked", isCheck);
        })
    });

    // 显示层次
    (function (select, sheet) {
        $(select).click(function () {
            if (!sheet.zh_tree) return;
            const tag = $(this).attr('tag');
            const tree = sheet.zh_tree;
            setTimeout(() => {
                showWaitingView();
                switch (tag) {
                    case "1":
                    case "2":
                    case "3":
                    case "4":
                    case "5":
                        tree.expandByLevel(parseInt(tag));
                        SpreadJsObj.refreshTreeRowVisible(sheet);
                        break;
                    case "last":
                        tree.expandByCustom(() => { return true; });
                        SpreadJsObj.refreshTreeRowVisible(sheet);
                        break;
                    case "leafXmj":
                        tree.expandToLeafXmj();
                        SpreadJsObj.refreshTreeRowVisible(sheet);
                        break;
                    case "curMeasure":
                        tree.expandByCustom(function (node) {
                            for (const field of ['contract_tp', 'qc_tp', 'gather_tp']) {
                                if (node[field]) {
                                    return true;
                                }
                            }
                            return false;
                        });
                        SpreadJsObj.refreshTreeRowVisible(sheet);
                        break;
                }
                closeWaitingView();
            }, 100);
        });
    })('a[name=showLevel]', slSpread.getActiveSheet());
});