Calculation/app/public/js/ledger_gather.js

'use strict';

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


const showTools = function (show) {
    const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
    if (show) {
        right.show();
        autoFlashHeight();
        /**
         * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
         * 第一次left.width调整后，parent的缩回left.height, 此时parent.width又增加了10px
         * 故需要通过最终的parent.width再计算一次left.width
         *
         * Q: 为什么不通过先计算left.width的宽度，以避免计算两次left.width?
         * A: 右侧工具栏不一定显示，当右侧工具栏显示过一次后，就必须使用parent和right来计算left.width
         *
         */
            //left.css('width', parent.width() - right.outerWidth());
            //left.css('width', parent.width() - right.outerWidth());
        const percent = 100 - right.outerWidth() /parent.width() * 100;
        left.css('width', percent + '%');
    } else {
        right.hide();
        left.css('width', '100%');
    }
};

$(document).ready(() => {
    showTools(true);
    autoFlashHeight();
    const gclSpread = SpreadJsObj.createNewSpread($('#gcl-spread')[0]);
    const gclSpreadSetting = {
        cols: [
            {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 120, formatter: '@'},
            {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@'},
            {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', cellType: 'unit'},
            {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
            {title: '签约清单|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_bills_qty', hAlign: 2, width: 80, type: 'Number'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_bills_tp', hAlign: 2, width: 80, type: 'Number'},
            {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
            {title: '台账-签约|数量', colSpan: '2|1', rowSpan: '1|1', field: 'compare_qty', hAlign: 2, width: 80, type: 'Number'},
            {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'compare_tp', hAlign: 2, width: 80, type: 'Number'},
        ],
        emptyRows: 0,
        headRows: 2,
        headRowHeight: [25, 25],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        localCache: {
            key: 'ledger-gather-gcl',
            colWidth: true,
        },
        getColor: function (sheet, data, row, col, defaultColor) {
            return data
                ? $('#compare-tag')[0].checked && data.compare_differ
                    ? spreadColor.gcl.calc_differ
                    : (data.differ ? spreadColor.gcl.differ : defaultColor)
                : defaultColor;
        }
    };
    if (thousandth) sjsSettingObj.setTpThousandthFormat(gclSpreadSetting);
    SpreadJsObj.initSheet(gclSpread.getActiveSheet(), gclSpreadSetting);
    const gclSheet = gclSpread.getActiveSheet();

    const leafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-spread')[0]);
    const leafXmjSpreadSetting = {
        cols: [
            {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 120, formatter: '@'},
            {title: '台账数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
            {title: '单位工程', colSpan: '1', rowSpan: '1', field: 'dwgc', hAlign: 0, width: 100, formatter: '@'},
            {title: '分部工程', colSpan: '1', rowSpan: '1', field: 'fbgc', hAlign: 0, width: 100, formatter: '@'},
            {title: '分项工程', colSpan: '1', rowSpan: '1', field: 'fxgc', hAlign: 0, width: 100, formatter: '@'},
            {title: '细目', colSpan: '1', rowSpan: '1', field: 'jldy', hAlign: 0, width: 100, formatter: '@'},
            {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'},
            {title: '图册号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 120, formatter: '@'},
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        localCache: {
            key: 'ledger-gather-leafXmj',
            colWidth: true,
        },
    };
    if (!isTz) leafXmjSpreadSetting.cols.splice(1, 1);
    if (thousandth) sjsSettingObj.setTpThousandthFormat(leafXmjSpreadSetting);
    SpreadJsObj.initSheet(leafXmjSpread.getActiveSheet(), leafXmjSpreadSetting);
    const leafXmjSheet = leafXmjSpread.getActiveSheet();

    const gatherLeafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-gather-spread')[0]);
    const gatherLeafXmjSpreadSetting = {
        cols: [
            {title: '单位工程', colSpan: '1', rowSpan: '1', field: 'dwgc', hAlign: 0, width: 100, formatter: '@', visible: false},
            {title: '分部工程', colSpan: '1', rowSpan: '1', field: 'fbgc', hAlign: 0, width: 100, formatter: '@', visible: false},
            {title: '分项工程', colSpan: '1', rowSpan: '1', field: 'fxgc', hAlign: 0, width: 100, formatter: '@', visible: false},
            {title: '细目', colSpan: '1', rowSpan: '1', field: 'jldy', hAlign: 0, width: 100, formatter: '@', visible: false},
            {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'},
            {title: '台账数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
        ],
        emptyRows: 0,
        headRows: 1,
        headRowHeight: [32],
        headColWidth: [30],
        defaultRowHeight: 21,
        headerFont: '12px 微软雅黑',
        font: '12px 微软雅黑',
        readOnly: true,
        localCache: {
            key: 'ledger-gather-leafXmj',
            colWidth: true,
        },
    };
    if (!isTz) gatherLeafXmjSpreadSetting.cols.splice(1, 1);
    if (thousandth) sjsSettingObj.setTpThousandthFormat(gatherLeafXmjSpreadSetting);
    const gatherLeafXmjSheet = gatherLeafXmjSpread.getActiveSheet();
    SpreadJsObj.initSheet(gatherLeafXmjSheet, gatherLeafXmjSpreadSetting);

    let gclGatherData;
    // 获取项目节数据
    function loadLeafXmjData(iGclRow) {
        const gcl = iGclRow ? gclGatherData[iGclRow] : SpreadJsObj.getSelectObject(gclSheet);
        SpreadJsObj.resetTopAndSelect(leafXmjSheet);
        if (gcl) {
            SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, gcl.leafXmjs);
        } else {
            SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, []);
        }
    }
    function loadGatherLeafXmjData(iGclRow) {
        const gcl = iGclRow ? gclGatherData[iGclRow] : SpreadJsObj.getSelectObject(gclSheet);
        SpreadJsObj.resetTopAndSelect(gatherLeafXmjSheet);
        console.log(gcl.gatherLeafXmjs);
        if (gcl) {
            SpreadJsObj.loadSheetData(gatherLeafXmjSheet, SpreadJsObj.DataType.Data, gcl.gatherLeafXmjs);
        } else {
            SpreadJsObj.loadSheetData(gatherLeafXmjSheet, SpreadJsObj.DataType.Data, []);
        }
    }
    // 标红显示 签约-台账≠0
    function checkCompareData() {
        const sheet = gclSheet;
        const bCompare = $('#compare-tag')[0].checked;
        SpreadJsObj.beginMassOperation(gclSheet);
        for (let iRow = 0, iLength = gclSheet.getRowCount(); iRow < iLength; iRow++) {
            const node = gclSheet.zh_data[iRow];
            if (node) {
                const bDiffer = node.compare_qty ? !checkZero(Math.abs(node.compare_qty)) : !checkZero(Math.abs(node.compare_tp));
                const color = bCompare && bDiffer ? '#f8d7da' : '';
                sheet.getRange(iRow, -1, 1, -1).backColor(color);
            }
        }
        SpreadJsObj.endMassOperation(gclSheet);
    }    
    // 切换清单行，读取所属项目节数据
    gclSpread.getActiveSheet().bind(spreadNS.Events.SelectionChanged, function (e, info) {
        const iNewRow = info.newSelections[0].row;
        if (!info.oldSelections || iNewRow !== info.oldSelections[0].row) {
            loadLeafXmjData(iNewRow);
            loadGatherLeafXmjData(iNewRow);
        }
    });

    function generateChapterHtml(data) {
        const html = [];
        if (data) {
            for (const d of data) {
                if (['1000', '1100', '1200', '1300'].indexOf(d.code) >= 0) {
                    if (checkZero(d.total_price) && checkZero(d.deal_bills_tp)) {
                        continue;
                    }
                }
                html.push('<tr>');
                if (d.code) {
                    html.push('<td>', d.code, '</td>');
                    html.push('<td>', d.name, '</td>');
                } else {
                    html.push('<td colspan="2">', d.name, '</td>');
                }
                html.push('<td class="text-right">', d.deal_bills_tp ? d.deal_bills_tp : '', '</td>');
                html.push('<td class="text-right">', d.total_price ? d.total_price : '', '</td>');
                html.push('<td class="text-right">', d.compare_tp ? d.compare_tp : '', '</td>');
                html.push('</tr>');
            }
        }
        $('#chapter-list').html(html.join(''));
    }

    postData(window.location.pathname + '/load', {}, function (data) {
        gclGatherModel.loadLedgerData(data.bills);
        gclGatherModel.loadPosData(data.pos);
        gclGatherModel.loadDealBillsData(data.dealBills);
        gclGatherData = gclGatherModel.gatherGclData();
        gclGatherModel.checkDiffer(gclGatherData);
        gclGatherModel.reGatherLeafXmj();
        for (const gcl of gclGatherData) {
            gcl.compare_qty = ZhCalc.sub(gcl.quantity, gcl.deal_bills_qty);
            gcl.compare_tp = ZhCalc.sub(gcl.total_price, gcl.deal_bills_tp);
            gcl.compare_differ = !checkZero(gcl.compare_qty) || !checkZero(gcl.compare_tp);
        }
        SpreadJsObj.loadSheetData(gclSheet, SpreadJsObj.DataType.Data, gclGatherData);
        checkCompareData();
        loadLeafXmjData(0);
        loadGatherLeafXmjData(0);

        const chapterData = gclGatherModel.gatherChapterData(chapter, data.spec, ['total_price']);
        for (const c of chapterData) {
            c.compare_tp = ZhCalc.sub(c.total_price, c.deal_bills_tp);
        }
        generateChapterHtml(chapterData);
    }, null, true);

    $('#compare-tag').click(() => {
        // const rows = [];
        // for (let i = 0; i< gclSheet.getRowCount(); ++i) {
        //     rows.push(i);
        // }
        // SpreadJsObj.reloadRowsBackColor(gclSheet, rows);
        SpreadJsObj.reLoadSheetData(gclSheet);
    });
    const searchBills = $.listSearch({
        selector: '#search',
        searchSpread: gclSpread,
        searchRangeStr: '清单编号/名称',
        resultSpreadSetting: {
            cols: [
                {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: 60},
                {title: '台账金额', field: 'total_price', hAlign: 2, width: 60},
            ],
            emptyRows: 0,
            headRows: 1,
            headRowHeight: [32],
            headColWidth: [30],
            defaultRowHeight: 21,
            headerFont: '12px 微软雅黑',
            font: '12px 微软雅黑',
            selectedBackColor: '#fffacd',
            readOnly: true,
        },
        check: function(data, keyword) {
            return !keyword ||
                (data.b_code && data.b_code.indexOf(keyword) > -1) ||
                (data.name && data.name.indexOf(keyword) > -1);
        },
        afterLocated: function () {
            loadLeafXmjData();
            loadGatherLeafXmjData();
        },
        calcSum: function (result) {
            const sum = { name: '合计', searchIndex: -1 };
            for (const r of result) {
                sum.quantity = ZhCalc.add(r.quantity, sum.quantity);
                sum.total_price = ZhCalc.add(r.total_price, sum.total_price);
            }
            return sum;
        }
    });
    // 展开收起附件
    $('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');
            $('#right-view .tab-content .tab-pane.active').removeClass('active');
            tab.addClass('active');
            tabPanel.addClass('active');
            showTools(tab.hasClass('active'));
            if (tab.attr('content') === '#search') searchBills.spread.refresh();
        } else {
            tab.removeClass('active');
            tabPanel.removeClass('active');
            showTools(tab.hasClass('active'));
        }
        gclSpread.refresh();
        leafXmjSpread.refresh();
        gatherLeafXmjSpread.refresh();
    });

    $('[name=gather-xmj]').change(function() {
        const checkOption = $('[name=gather-xmj]:checked');
        if (checkOption.length === 0) {
            toastr.warning('请至少选择一个汇总条件');
            return;
        }

        const fields = [];
        for (const co of checkOption) {
            fields.push(co.value);
        }
        for (const col of gatherLeafXmjSpreadSetting.cols) {
            col.visible = col.type === 'Number' || fields.indexOf(col.field) >= 0;
        }
        gclGatherModel.reGatherLeafXmj(fields);
        SpreadJsObj.refreshColumnVisible(gatherLeafXmjSheet);
        loadGatherLeafXmjData();
    });

    $.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();
            gclSpread.refresh();
            leafXmjSpread.refresh();
            gatherLeafXmjSpread.refresh();
        }
    });
    $.divResizer({
        select: '#main-resize',
        callback: function () {
            gclSpread.refresh();
            let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
            $(".sp-wrap").height(bcontent-30);
            leafXmjSpread.refresh();
            gatherLeafXmjSpread.refresh();
        }
    });
    $.divResizer({
        select: '#right-spr',
        callback: function () {
            gclSpread.refresh();
            leafXmjSpread.refresh();
            gatherLeafXmjSpread.refresh();
        }
    });
    $('#exportExcel').click(function () {
        const data = [];
        const setting = {
            cols: [
                {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 70, formatter: '@'},
                {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 300, 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'},
                {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 100, formatter: '@'},
                {title: '签约清单|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_bills_qty', hAlign: 2, width: 80, type: 'Number'},
                {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_bills_tp', hAlign: 2, width: 80, type: 'Number'},
                {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
                {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
                {title: '台账－签约|数量', colSpan: '2|1', rowSpan: '1|1', field: 'compare_qty', hAlign: 2, width: 80, type: 'Number'},
                {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'compare_tp', hAlign: 2, width: 80, type: 'Number'},
                {title: '单位工程', colSpan: '1', rowSpan: '2', field: 'dwgc', hAlign: 0, width: 80, formatter: '@'},
                {title: '分部工程', colSpan: '1', rowSpan: '2', field: 'fbgc', hAlign: 0, width: 80, formatter: '@'},
                {title: '分项工程', colSpan: '1', rowSpan: '2', field: 'fxgc', hAlign: 0, width: 80, formatter: '@'},
                {title: '细目', colSpan: '1', rowSpan: '2', field: 'jldy', hAlign: 0, width: 80, formatter: '@'},
                {title: '计量单元', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 80, formatter: '@'},
                {title: '图册号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'},
            ],
            headRows: 2,
            headRowHeight: [25, 25],
            defaultRowHeight: 21,
            headerFont: 'bold 10px 微软雅黑',
            font: '10px 微软雅黑'
        };
        if (!gclSheet.zh_data || gclSheet.zh_data.length === 0) return;
        for (const gcl of gclSheet.zh_data) {
            data.push({
                b_code: gcl.b_code, name: gcl.name, unit: gcl.unit,
                unit_price: gcl.unit_price,
                deal_bills_qty: gcl.deal_bills_qty, deal_bills_tp: gcl.deal_bills_tp,
                quantity: gcl.quantity, total_price: gcl.total_price,
                compare_qty: gcl.compare_qty, compare_tp: gcl.compare_tp,
            });
            if (gcl.leafXmjs && gcl.leafXmjs.length > 0) {
                for (const xmj of gcl.leafXmjs) {
                    data.push({
                        code: xmj.code,
                        quantity: xmj.quantity,
                        dwgc: xmj.dwgc, fbgc: xmj.fbgc, fxgc: xmj.fxgc,
                        jldy: xmj.jldy, bwmx: xmj.bwmx, drawing_code: xmj.drawing_code,
                    });
                }
            }
        }

        SpreadExcelObj.exportSimpleXlsxSheet(setting, data, $('.sidebar-title').attr('data-original-title') + "-清单对比.xlsx");
    });
});