Calculation/app/public/js/quality_lab.js

$(document).ready(() => {
    autoFlashHeight();
    const labSpread = SpreadJsObj.createNewSpread($('#lab-spread')[0]);
    const labSheet = labSpread.getActiveSheet();
    const labSpreadSetting = {
        cols: [
            { title: '分类编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 80, formatter: '@', cellType: 'tree' },
            { title: '分类名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 185, formatter: '@' },
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [32],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
    };
    SpreadJsObj.initSheet(labSheet, labSpreadSetting);
    const labTree = createNewPathTree('base', { id: 'tree_id', pid: 'tree_pid', order: 'order', level: 'level', rootId: -1 });

    postData('load', { filter: 'lab' }, function(result) {
        labTree.loadDatas(result.lab);
        SpreadJsObj.loadSheetData(labSheet, SpreadJsObj.DataType.Tree, labTree);
    });

    const labSpreadObj = {
        selectionChanged: function(e, info) {
            if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
                lab
            }
        }
    };

    labSpread.bind(spreadNS.Events.SelectionChanged, labSpreadObj.selectionChanged);

    // 显示层次
    (function (select, sheet) {
        $(select).click(function () {
            const tag = $(this).attr('tag');
            setTimeout(() => {
                showWaitingView();
                const tree = sheet.zh_tree;
                if (!tree) return;
                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;
                }
                closeWaitingView();
            }, 100);
        });
    })('a[name=showLevel]', labSheet);
    const labSearch = $.posSearch({selector: '#lab-search', searchSpread: labSpread, hint: '请输入 编号/名称 查询', specClass: 'mt-1', searchFields: ['name'] });
});