Calculation/app/public/js/schedule_plan.js

/**
 * 进度台账相关js
 *
 * @author Ellisran
 * @date 2020/11/6
 * @version
 */
function getTenderId() {
    return window.location.pathname.split('/')[2];
}
$(function () {
    autoFlashHeight();
    if(schedule && !schedule.mode) {
        $('#mode').modal('show');
    }
    // 初始化台账
    const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
    const treeSetting = {
        id: 'ledger_id',
        pid: 'ledger_pid',
        order: 'order',
        level: 'level',
        rootId: -1,
        fullPath: 'full_path',
        calcFields: ['total_price']
        //treeCacheKey: 'ledger_bills_fold' + '_' + getTenderId(),
        // markFoldKey: 'bills-fold',
        // markFoldSubKey: window.location.pathname.split('/')[2],
    };
    treeSetting.calcFun = function (node) {
        node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
    };
    const ledgerTree = createNewPathTree('base', treeSetting);

    const ledgerSpreadSetting = {
        cols: [
            {title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 145, formatter: '@', readOnly: true, cellType: 'tree'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 185, formatter: '@', readOnly: true},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
            {title: '经济指标', colSpan: '1', rowSpan: '2', field: 'dgn_price', hAlign: 2, width: 60, type: 'Number', readOnly: true},
            {title: '总设计|工程量', colSpan: '2|1', rowSpan: '1|1', field: 'dgn_qty1', hAlign: 2, width: 70, type: 'Number', readOnly: true},
            {title: '|金额(万元)', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 70, type: 'Number', readOnly: true},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        // readOnly: true,
        localCache: {
            key: 'ledger-bills',
            colWidth: true,
        }
    };

    sjsSettingObj.setFxTreeStyle(ledgerSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
    if (thousandth) sjsSettingObj.setTpThousandthFormat(ledgerSpreadSetting);
    SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
    SpreadJsObj.selChangedRefreshBackColor(ledgerSpread.getActiveSheet());

    postData('/tender/' + getTenderId() + '/schedule/ledger/load', {}, function (data) {
        console.log(data, selectedLedgerList);
        const treeData = [];
        for(const sl of selectedLedgerList) {
            const one = _.find(data, { 'ledger_id' : sl });
            treeData.push(one);
        }
        ledgerTree.loadDatas(treeData);
        treeCalc.calculateAll(ledgerTree);
        // console.log(ledgerTree);
        SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Tree, ledgerTree);
    }, null, true);

    const ledgerSpreadObj = {
        refreshTree: function (sheet, data) {
            SpreadJsObj.massOperationSheet(sheet, function () {
                const tree = sheet.zh_tree;
                // 处理删除
                if (data.delete) {
                    data.delete.sort(function (x, y) {
                        return y.deleteIndex - x.deleteIndex;
                    });
                    for (const d of data.delete) {
                        sheet.deleteRows(d.deleteIndex, 1);
                    }
                }
                // 处理新增
                if (data.create) {
                    const newNodes = data.create;
                    if (newNodes) {
                        newNodes.sort(function (a, b) {
                            return a.index - b.index;
                        });

                        for (const node of newNodes) {
                            sheet.addRows(node.index, 1);
                            SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
                        }
                    }
                }
                // 处理更新
                if (data.update) {
                    const rows = [];
                    for (const u of data.update) {
                        rows.push(tree.nodes.indexOf(u));
                    }
                    SpreadJsObj.reLoadRowsData(sheet, rows);
                }
                // 处理展开
                if (data.expand) {
                    const expanded = [];
                    for (const e of data.expand) {
                        if (expanded.indexOf(e) === -1) {
                            const posterity = tree.getPosterity(e);
                            for (const p of posterity) {
                                sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
                                expanded.push(p);
                            }
                        }
                    }
                }
            });
        },
    };
    // 进度计算方式选择
    $('.mode-select').on('click', function () {
        const _self = $(this);
        postData(window.location.pathname + '/save', {type: 'mode', postData: $(this).data('mode')}, function (result) {
            _self.addClass('disabled').attr('disabled', true);
            _self.parents('.col-6').siblings('.col-6').find('button').removeClass('disabled').removeAttr('disabled');
            $('#mode-tips').show();
            $('#mode-cancel').show();
            $('#mode').modal('hide');
        })
    });

    $.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');
            }
            ledgerSpread.refresh();
            autoFlashHeight();
        }
    });
});