Calculation/app/public/js/compare_tz.js

'use strict';

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

$(document).ready(function () {
    autoFlashHeight();
    // 根据设置整理Spread设置
    const ledgerSpreadSetting = {
        cols: [
            { title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree' },
            { title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@' },
            { title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@' },
            { title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', cellType: 'unit' },
            { title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number' },
            { title: '标段1|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_1', hAlign: 2, width: 60, type: 'Number' },
            { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_1', hAlign: 2, width: 60, type: 'Number' },
            { title: '标段2|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_2', hAlign: 2, width: 60, type: 'Number' },
            { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_2', hAlign: 2, width: 60, type: 'Number' },
            { title: '标段1-标段2|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_differ', hAlign: 2, width: 60, type: 'Number' },
            { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_differ', hAlign: 2, width: 60, type: 'Number' },
        ],
        emptyRows: 2,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        getColor: function (sheet, data, row, col, defaultColor) {
            function checkDiffer(data) {
                return !checkZero(data.qty_differ) && !checkZero(data.tp_differ);
            }
            return data && checkDiffer(data) ? '#F2DEDE' : defaultColor;
        }
    };
    const posSpreadSetting = {
        cols: [
            { title: '计量单元', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@' },
            { title: '数量|标段1', colSpan: '3|1', rowSpan: '1|1', field: 'qty_1', hAlign: 2, width: 80, type: 'Number' },
            { title: '|标段2', colSpan: '|1', rowSpan: '|1', field: 'qty_2', hAlign: 2, width: 80, type: 'Number' },
            { title: '|标段1-标段2', colSpan: '|1', rowSpan: '|1', field: 'qty_differ', hAlign: 2, width: 80, type: 'Number' },
        ],
        emptyRows: 3,
        headRows: 2,
        headRowHeight: [25, 25],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        getColor: function (sheet, data, row, col, defaultColor) {
            function checkDiffer(data) {
                const fieldSufs = sheet.zh_setting.fieldSufs;
                if (fieldSufs.length <= 1) return false;
                const base = data['gather_qty' + fieldSufs[0]];
                for (let i = 1; i < fieldSufs.length; i++) {
                    const compare = data['gather_qty' + fieldSufs[i]];
                    if ((base || compare) && (compare !== base)) return true;
                }
            }
            return checkDiffer(data) ? '#F2DEDE' : defaultColor;
        }
    };
    // 初始化台账
    const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]);
    const billsSheet = billsSpread.getActiveSheet();
    SpreadJsObj.initSheet(billsSheet, ledgerSpreadSetting);
    // 初始化部位
    const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
    const posSheet = posSpread.getActiveSheet();
    SpreadJsObj.initSheet(posSheet, posSpreadSetting);

    // const billsTree = new CompareTree({
    //     id: 'id',
    //     pid: 'pid',
    //     order: 'order',
    //     level: 'level',        
    //     rootId: -1,
    //     loadInfo1: function (node, source) {
    //         node.qty_1 = source.quantity;
    //         node.tp_1 = source.total_price;
    //     },
    //     loadInfo2: function (node, source) {
    //         node.qty_2 = source.quantity;
    //         node.tp_2 = source.total_price;
    //     },
    //     calcDiffer: function (node) {
    //         node.qty_differ = ZhCalc.sub(node.qty_1, node.qty_2);
    //         node.tp_differ = ZhCalc.sub(node.tp_1, node.tp_2);
    //     },
    // });
    const billsTree = createNewPathTree('compare', {
        id: 'id',
        pid: 'pid',
        order: 'order',
        level: 'level',        
        rootId: -1,
        loadInfo1: function (node, source) {
            node.qty_1 = source.quantity;
            node.tp_1 = source.total_price;
        },
        loadInfo2: function (node, source) {
            node.qty_2 = source.quantity;
            node.tp_2 = source.total_price;
        },
        calcDiffer: function (node) {
            node.qty_differ = ZhCalc.sub(node.qty_1, node.qty_2);
            node.tp_differ = ZhCalc.sub(node.tp_1, node.tp_2);
        },
    });

    // // 获取部位明细数据
    // function loadPosData(iRow) {
    //     const node = billsSheet.zh_tree.nodes[iRow];
    //     if (node) {
    //         SpreadJsObj.loadSheetData(posSheet, SpreadJsObj.DataType.Data, node.pos);
    //     } else {
    //         SpreadJsObj.loadSheetData(posSheet, SpreadJsObj.DataType.Data, []);
    //     }
    //     SpreadJsObj.resetTopAndSelect(posSheet);
    // }
    // // 切换清单行，读取所属项目节数据
    // billsSheet.bind(spreadNS.Events.SelectionChanged, function (e, info) {
    //     if (info.newSelections) {
    //         const iNewRow = info.newSelections[0].row;
    //         if (info.oldSelections) {
    //             const iOldRow = info.oldSelections[0].row;
    //             if (iNewRow !== iOldRow) {
    //                 loadPosData(iNewRow);
    //             }
    //         } else {
    //             loadPosData(iNewRow);
    //         }
    //     }
    // });

    // 选择
    $('#select-ok').click(function () {
        let id1, id2;
        try {
            id1 = parseInt($('input[name=id1]').val());
            id2 = parseInt($('input[name=id2]').val());

            if (id1 > 0 && id2 > 0) {
                postData(window.location.pathname + '/load', { tid1: id1, tid2: id2 }, function (result) {
                    // 初始化基础数据分析
                    const tenderTreeSetting = {
                        id: 'ledger_id',
                        pid: 'ledger_pid',
                        order: 'order',
                        level: 'level',
                        rootId: -1,
                        keys: ['id', 'tender_id', 'ledger_id'],
                        calcFields: ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'],
                    };
                    const tender1 = {
                        billsTree: createNewPathTree('ledger', tenderTreeSetting),
                    };
                    tender1.billsTree.loadDatas(result.tender1.bills);
                    treeCalc.calculateAll(tender1.billsTree);
                    const col1 = ledgerSpreadSetting.cols.find(function (x) {
                        return x.field === 'qty_1';
                    });
                    col1.title = result.tender1.name + '|数量';

                    const tender2 = {
                        billsTree: createNewPathTree('ledger', tenderTreeSetting),
                    };
                    tender2.billsTree.loadDatas(result.tender2.bills);
                    treeCalc.calculateAll(tender2.billsTree);
                    const col2 = ledgerSpreadSetting.cols.find(function (x) {
                        return x.field === 'qty_2';
                    });
                    col2.title = result.tender2.name + '|数量';
                    
                    SpreadJsObj.initSheet(billsSheet, ledgerSpreadSetting);
                    billsTree.loadCompareData(tender1, tender2);
                    SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree);
                    $('#data-select').modal('hide');
                });
            }
        } catch (err) {
            toastr.error('输入的标段ID非法');
        }
    });
    // 显示层次
    (function (select, sheet) {
        $(select).click(function () {
            if (!sheet.zh_tree) return;
            const tag = $(this).attr('tag');
            const tree = sheet.zh_tree;
            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.expandByCalcFields();
                    SpreadJsObj.refreshTreeRowVisible(sheet);
                    break;
            }
        });
    })('a[name=showLevel]', billsSheet);
    // 导航栏
    $.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();
            billsSpread.refresh();
            posSpread.refresh();
        }
    });
    // 上下窗口resizer
    $.divResizer({
        select: '#main-resize',
        callback: function () {
            billsSpread.refresh();
            let bcontent = $(".bcontent-wrap").length > 0 ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent - 30);
            posSpread.refresh();
        }
    });
});