Calculation/app/service/rpt_gather_memory.js

'use strict';

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

const Ledger = require('../lib/ledger');
const PayCalculator = require('../lib/pay_calc');

const auditConst = require('../const/audit');
const payConst = require('../const/deal_pay');
const materialConst = require('../const/material');

const moment = require('moment');

const indexPre = 'id_';

const gatherUtils = {
    gatherStage: function (tender, gatherNode, sourceNode, prefix, helper) {
        gatherNode[prefix + 'id'] = tender.id;
        gatherNode[prefix + 'name'] = tender.name;

        gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
        gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);

        gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
        gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
        gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
        gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
        gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
        gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);

        gatherNode[prefix + "pre_contract_qty"] = helper.add(gatherNode[prefix + "pre_contract_qty"], sourceNode.pre_contract_qty);
        gatherNode[prefix + "pre_contract_tp"] = helper.add(gatherNode[prefix + "pre_contract_tp"], sourceNode.pre_contract_tp);
        gatherNode[prefix + "pre_qc_qty"] = helper.add(gatherNode[prefix + "pre_qc_qty"], sourceNode.pre_qc_qty);
        gatherNode[prefix + "pre_qc_tp"] = helper.add(gatherNode[prefix + "pre_qc_tp"], sourceNode.pre_qc_tp);
        gatherNode[prefix + "pre_gather_qty"] = helper.add(gatherNode[prefix + "pre_gather_qty"], sourceNode.pre_gather_qty);
        gatherNode[prefix + "pre_gather_tp"] = helper.add(gatherNode[prefix + "pre_gather_tp"], sourceNode.pre_gather_tp);

        gatherNode[prefix + "end_contract_qty"] = helper.add(gatherNode[prefix + "end_contract_qty"], sourceNode.end_contract_qty);
        gatherNode[prefix + "end_contract_tp"] = helper.add(gatherNode[prefix + "end_contract_tp"], sourceNode.end_contract_tp);
        gatherNode[prefix + "end_qc_qty"] = helper.add(gatherNode[prefix + "end_qc_qty"], sourceNode.end_qc_qty);
        gatherNode[prefix + "end_qc_tp"] = helper.add(gatherNode[prefix + "end_qc_tp"], sourceNode.end_qc_tp);
        gatherNode[prefix + "end_gather_qty"] = helper.add(gatherNode[prefix + "end_gather_qty"], sourceNode.end_gather_qty);
        gatherNode[prefix + "end_gather_tp"] = helper.add(gatherNode[prefix + "end_gather_tp"], sourceNode.end_gather_tp);

        gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
        gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);

        gatherNode['s_' + "contract_qty"] = helper.add(gatherNode['s_' + "contract_qty"], sourceNode.contract_qty);
        gatherNode['s_' + "contract_tp"] = helper.add(gatherNode['s_' + "contract_tp"], sourceNode.contract_tp);
        gatherNode['s_' + "qc_qty"] = helper.add(gatherNode['s_' + "qc_qty"], sourceNode.qc_qty);
        gatherNode['s_' + "qc_tp"] = helper.add(gatherNode['s_' + "qc_tp"], sourceNode.qc_tp);
        gatherNode['s_' + "gather_qty"] = helper.add(gatherNode['s_' + "gather_qty"], sourceNode.gather_qty);
        gatherNode['s_' + "gather_tp"] = helper.add(gatherNode['s_' + "gather_tp"], sourceNode.gather_tp);

        gatherNode['s_' + "pre_contract_qty"] = helper.add(gatherNode['s_' + "pre_contract_qty"], sourceNode.pre_contract_qty);
        gatherNode['s_' + "pre_contract_tp"] = helper.add(gatherNode['s_' + "pre_contract_tp"], sourceNode.pre_contract_tp);
        gatherNode['s_' + "pre_qc_qty"] = helper.add(gatherNode['s_' + "pre_qc_qty"], sourceNode.pre_qc_qty);
        gatherNode['s_' + "pre_qc_tp"] = helper.add(gatherNode['s_' + "pre_qc_tp"], sourceNode.pre_qc_tp);
        gatherNode['s_' + "pre_gather_qty"] = helper.add(gatherNode['s_' + "pre_gather_qty"], sourceNode.pre_gather_qty);
        gatherNode['s_' + "pre_gather_tp"] = helper.add(gatherNode['s_' + "pre_gather_tp"], sourceNode.pre_gather_tp);

        gatherNode['s_' + "end_contract_qty"] = helper.add(gatherNode['s_' + "end_contract_qty"], sourceNode.end_contract_qty);
        gatherNode['s_' + "end_contract_tp"] = helper.add(gatherNode['s_' + "end_contract_tp"], sourceNode.end_contract_tp);
        gatherNode['s_' + "end_qc_qty"] = helper.add(gatherNode['s_' + "end_qc_qty"], sourceNode.end_qc_qty);
        gatherNode['s_' + "end_qc_tp"] = helper.add(gatherNode['s_' + "end_qc_tp"], sourceNode.end_qc_tp);
        gatherNode['s_' + "end_gather_qty"] = helper.add(gatherNode['s_' + "end_gather_qty"], sourceNode.end_gather_qty);
        gatherNode['s_' + "end_gather_tp"] = helper.add(gatherNode['s_' + "end_gather_tp"], sourceNode.end_gather_tp);
    },
    gatherZone: function (tender, gatherNode, sourceNode, prefix, helper) {
        gatherNode[prefix + 'id'] = tender.id;
        gatherNode[prefix + 'name'] = tender.name;

        gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
        gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);

        gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
        gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
        gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
        gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
        gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
        gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);

        gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
        gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);

        gatherNode['s_' + "contract_qty"] = helper.add(gatherNode['s_' + "contract_qty"], sourceNode.contract_qty);
        gatherNode['s_' + "contract_tp"] = helper.add(gatherNode['s_' + "contract_tp"], sourceNode.contract_tp);
        gatherNode['s_' + "qc_qty"] = helper.add(gatherNode['s_' + "qc_qty"], sourceNode.qc_qty);
        gatherNode['s_' + "qc_tp"] = helper.add(gatherNode['s_' + "qc_tp"], sourceNode.qc_tp);
        gatherNode['s_' + "gather_qty"] = helper.add(gatherNode['s_' + "gather_qty"], sourceNode.gather_qty);
        gatherNode['s_' + "gather_tp"] = helper.add(gatherNode['s_' + "gather_tp"], sourceNode.gather_tp);
    },
    gatherLedger: function (tender, gatherNode, sourceNode, prefix, helper) {
        gatherNode[prefix + 'id'] = tender.id;
        gatherNode[prefix + 'name'] = tender.name;

        gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
        gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);

        gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
        gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);
    },
    gatherSpecial: function (gatherNode, sourceNode, prefix, helper) {
        gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
        gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
    },
};

module.exports = app => {
    class RptGatherMemory extends app.BaseService {

        /**
         * 构造函数
         *
         * @param {Object} ctx - egg全局context
         * @return {void}
         */
        constructor(ctx) {
            super(ctx);
            this.resultTree = new Ledger.gatherTree(ctx, {
                id: 'id',
                pid: 'pid',
                order: 'order',
                level: 'level',
                rootId: -1
            });
            this.resultTenderInfo = [];
            this.resultDealpPay = [];
            this.resultDealBills = [];
        }

        async _getValidStages(tenderId) {
            const stages = await this.db.select(this.ctx.service.stage.tableName, {
                where: { tid: tenderId },
                orders: [['order', 'desc']],
            });
            if (stages.length !== 0) {
                const lastStage = stages[0];
                if (lastStage.status === auditConst.stage.status.uncheck && lastStage.user_id !== this.ctx.session.sessionUser.accountId) {
                    stages.splice(0, 1);
                }
            }
            return stages;
        }

        async _getCheckedStages(tenderId) {
            const stages = await this.db.select(this.ctx.service.stage.tableName, {
                where: { tid: tenderId },
                orders: [['order', 'desc']],
            });
            if (stages.length !== 0) {
                const lastStage = stages[0];
                if (lastStage.status !== auditConst.stage.status.checked) {
                    stages.splice(0, 1);
                }
            }
            return stages;
        }

        _checkSpecialTender(tender, special) {
            if (special) {
                for (const spec of special) {
                    if (tender[spec.key] === true) return spec.key;
                }
            }
            return '';
        }

        /**
         * 台账数据
         */
        async _gatherStageData(index, tender, stage, hasPre) {
            const helper = this.ctx.helper;
            const billsTree = new Ledger.billsTree(this.ctx, {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                keys: ['id', 'tender_id', 'ledger_id'],
                stageId: 'id',
                calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp', 'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp'],
                calc: function (node) {
                    if (node.children && node.children.length === 0) {
                        node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
                        node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
                        node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
                        node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
                        node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
                    }
                    node.pre_gather_tp = helper.add(node.pre_contract_tp, node.pre_qc_tp);
                    node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
                    node.end_contract_tp = helper.add(node.pre_contract_tp, node.contract_tp);
                    node.end_qc_tp = helper.add(node.pre_qc_tp, node.qc_tp);
                    node.end_gather_tp = helper.add(node.pre_gather_tp, node.gather_tp);
                }
            });
            const billsData = await this.ctx.service.ledger.getData(tender.id);
            if (stage) {
                await this.ctx.service.stage.doCheckStage(stage);
                if (stage.readOnly) {
                    const curStage = await this.ctx.service.stageBills.getAuditorStageData(tender.id,
                        stage.id, stage.curTimes, stage.curOrder);
                    this.ctx.helper.assignRelaData(billsData, [
                        {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
                    ]);
                } else {
                    const curStage = await this.ctx.service.stageBills.getLastestStageData(tender.id, stage.id);
                    this.ctx.helper.assignRelaData(billsData, [
                        {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
                    ]);
                }
                if (hasPre) {
                    const preStage = stage.order > 1 ? await this.ctx.service.stageBillsFinal.getFinalData(tender, stage.order - 1) : [];
                    this.ctx.helper.assignRelaData(billsData, [
                        {data: preStage, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'lid'}
                    ]);
                }
            }
            billsTree.loadDatas(billsData);
            billsTree.calculateAll();
            this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
                gatherUtils.gatherStage(tender, gatherNode, sourceNode, 't_' + index + '_', helper);
            });
        }

        async _gatherMonthData(sTender, index, month, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getValidStages(tender.id);
            const stage = this.ctx.helper._.find(stages, {s_time: month});
            await this._gatherStageData(index, tender, stage, hasPre);
        }

        async _gatherZoneData(sTender, index, zone) {
            const helper = this.ctx.helper;
            /**
             * 汇总并合并 相关数据
             * @param {Array} index - 主数据
             * @param {Array[]}rela - 相关数据 {data, fields, prefix, relaId}
             */
            const sumAssignRelaData = function (index, rela) {
                const loadFields = function (datas, fields, prefix, relaId) {
                    for (const d of datas) {
                        const key = indexPre + d[relaId];
                        const m = index[key];
                        if (m) {
                            for (const f of fields) {
                                if (d[f] !== undefined) {
                                    m[prefix + f] = helper.add(m[prefix + f], d[f]);
                                }
                            }
                        }
                    }
                };
                for (const r of rela) {
                    loadFields(r.data, r.fields, r.prefix, r.relaId);
                }
            };

            const billsTree = new Ledger.billsTree(this.ctx, {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                keys: ['id', 'tender_id', 'ledger_id'],
                stageId: 'id',
                calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp'],
                calc: function (node) {
                    if (node.children && node.children.length === 0) {
                        node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
                    }
                    node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
                }
            });
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const billsData = await this.ctx.service.ledger.getData(tender.id);

            let billsIndexData = {};
            for (const bd of billsData) {
                billsIndexData[indexPre + bd.id] = bd;
            }

            const times = zone.split(' - ');
            if (times.length !== 2) throw '选择的汇总周期无效';
            const beginTime = moment(times[0], 'YYYY-MM');
            const endTime = moment(times[1], 'YYYY-MM');

            const stages = await this._getValidStages(tender.id);
            for (const stage of stages) {
                const sTime = moment(stage.s_time, 'YYYY-MM');
                if (sTime.isBetween(beginTime, endTime, null, '[]')) {
                    await this.ctx.service.stage.doCheckStage(stage);
                    if (stage.readOnly) {
                        const curStage = await this.ctx.service.stageBills.getAuditorStageData(tender.id,
                            stage.id, stage.curTimes, stage.curOrder);
                        sumAssignRelaData(billsIndexData, [
                            {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
                        ]);
                    } else {
                        const curStage = await this.ctx.service.stageBills.getLastestStageData(tender.id, stage.id);
                        sumAssignRelaData(billsIndexData, [
                            {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
                        ]);
                    }
                }
            }
            billsTree.loadDatas(billsData);
            billsTree.calculateAll();
            this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
                gatherUtils.gatherZone(gatherNode, sourceNode, 't_' + index + '_', helper);
            });
        }

        async _gatherFinalData(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getValidStages(tender.id);
            await this._gatherStageData(index, tender, stages[0], hasPre);
        }

        async _gatherCheckedFinalData(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getCheckedStages(tender.id);
            await this._gatherStageData(index, tender, stages[0], hasPre);
        }

        async _gatherLedgerData(sTender, index) {
            const helper = this.ctx.helper;
            const billsTree = new Ledger.billsTree(this.ctx, {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                keys: ['id', 'tender_id', 'ledger_id'],
                stageId: 'id',
                calcFields: ['deal_tp', 'total_price'],
            });
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const billsData = await this.ctx.service.ledger.getData(tender.id);
            billsTree.loadDatas(billsData);
            billsTree.calculateAll();
            this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
                gatherUtils.gatherLedger(tender, gatherNode, sourceNode, 't_' + index + '_', helper);
            })
        }

        async _gatherSpecialData(sTender, sKey) {
            const helper = this.ctx.helper;
            const billsTree = new Ledger.billsTree(this.ctx, {
                id: 'ledger_id',
                pid: 'ledger_pid',
                order: 'order',
                level: 'level',
                rootId: -1,
                keys: ['id', 'tender_id', 'ledger_id'],
                stageId: 'id',
                calcFields: ['deal_tp', 'total_price'],
            });
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const billsData = await this.ctx.service.ledger.getData(tender.id);
            billsTree.loadDatas(billsData);
            billsTree.calculateAll();
            this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
                gatherUtils.gatherSpecial(gatherNode, sourceNode, 'ts_' + sKey + '_', helper);
            })
        }

        async getGatherStageBills(memFieldKeys, gsDefine, gsCustom) {
            if (!gsDefine || !gsDefine.enable) return [];
            if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];

            const gsSetting = JSON.parse(gsDefine.setting);
            let commonIndex = 0;
            for (const tender of gsCustom.tenders) {
                const specialKey = this._checkSpecialTender(tender, gsSetting.special);
                if (specialKey === '') {
                    switch (gsSetting.type) {
                        case 'month':
                            await this._gatherMonthData(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
                            break;
                        case 'zone':
                            await this._gatherZoneData(tender, commonIndex, gsCustom.zone);
                            break;
                        case 'final':
                            await this._gatherFinalData(tender, commonIndex, gsSetting.hasPre);
                            break;
                        case 'checked-final':
                            await this._gatherCheckedFinalData(tender, commonIndex, gsSetting.hasPre);
                            break;
                        case 'ledger':
                            await this._gatherLedgerData(tender, commonIndex);
                            break;
                    }
                    commonIndex++;
                } else {
                    await this._gatherSpecialData(tender, specialKey);
                }
            }

            this.resultTree.generateSortNodes();
            return this.resultTree.getDefaultDatas();
        }

        /**
         * 标段信息
         */
        async _getBaseTenderInfo(tender) {
            const info = {
                id: tender.id,
                name: tender.name,

                deal_tp: tender.deal_tp,
                tp: tender.total_price
            };
            const deal_bills_sum = await this.ctx.service.dealBills.getSum(tender.id);
            info.deal_bills_tp = deal_bills_sum ? deal_bills_sum.total_price : 0;
            if (tender.ledger_status === auditConst.ledger.status.uncheck || tender.ledger_status === auditConst.ledger.status.checkNo) {
                const sum = await this.ctx.service.ledger.addUp({tender_id: tender.id/*, is_leaf: true*/});
                info.tp = sum.total_price;
                info.deal_tp = sum.deal_tp;
            }
            return info;
        }
        async _getStageTenderInfo(stage, info) {
            if (stage) {
                const helper = this.ctx.helper;
                await this.ctx.service.stage.doCheckStage(stage);
                await this.ctx.service.stage.checkStageGatherData(stage);

                info.pre_contract_tp = stage.pre_contract_tp;
                info.pre_qc_tp = stage.pre_qc_tp;
                info.pre_gather_tp = helper.add(info.pre_contract_tp, info.pre_qc_tp);

                info.contract_tp = stage.contract_tp;
                info.qc_tp = stage.qc_tp;
                info.gather_tp = helper.add(info.contract_tp, info.qc_tp);

                info.end_contract_tp = helper.add(info.pre_contract_tp, info.contract_tp);
                info.end_qc_tp = helper.add(info.pre_qc_tp, info.qc_tp);
                info.end_gather_tp = helper.add(info.pre_gather_tp, info.gather_tp);

                info.yf_tp = stage.yf_tp;
                info.pre_yf_tp = stage.pre_yf_tp;
                info.end_yf_tp = helper.add(stage.yf_tp, stage.pre_yf_tp);
            }
        }

        async _gatherMonthTenderInfo(sTender, index, month, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const info = await this._getBaseTenderInfo(tender);
            const stages = await this._getValidStages(tender.id);
            const stage = this.ctx.helper._.find(stages, {s_time: month});
            await this._getStageTenderInfo(stage, info);
            this.resultTenderInfo.push(info);
        }

        async _gatherZoneTenderInfo(sTender, index, zone) {
            const helper = this.ctx.helper;
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const info = await this._getBaseTenderInfo(tender);

            const times = zone.split(' - ');
            if (times.length !== 2) throw '选择的汇总周期无效';
            const beginTime = moment(times[0], 'YYYY-MM');
            const endTime = moment(times[1], 'YYYY-MM');

            const stages = await this._getValidStages(tender.id, true);
            for (const stage of stages) {
                const sTime = moment(stage.s_time, 'YYYY-MM');
                if (sTime.isBetween(beginTime, endTime, null, '[]')) {
                    await this.ctx.service.stage.doCheckStage(stage);
                    await this.ctx.service.stage.checkStageGatherData(stage);

                    info.contract_tp = helper.add(info.contract_tp, stage.contract_tp);
                    info.qc_tp = helper.add(info.qc_tp, stage.qc_tp);

                    info.yf_tp = helper.add(info.yf_tp, stage.yf_tp);
                }
            }
            info.gather_tp = helper.add(info.contract_tp, info.qc_tp);

            this.resultTenderInfo.push(info);
        }

        async _gatherFinalTenderInfo(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const info = await this._getBaseTenderInfo(tender);
            const stages = await this._getValidStages(tender.id);
            await this._getStageTenderInfo(stages[0], info);
            this.resultTenderInfo.push(info);
        }

        async _gatherCheckedFinalTenderInfo(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const info = await this._getBaseTenderInfo(tender);
            const stages = await this._getCheckedStages(tender.id);
            await this._getStageTenderInfo(stages[0], info);
            this.resultTenderInfo.push(info);
        }

        async _gatherLedgerTenderInfo(sTender, index) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const info = await this._getBaseTenderInfo(tender);
            this.resultTenderInfo.push(info);
        }

        async _gatherSpecialTenderInfo(sTender, sKey) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);

            const info = await this._getBaseTenderInfo(tender);
            info.spec = sKey;
            this.resultTenderInfo.push(info);
        }

        async getGatherTenderInfo(memFieldKeys, gsDefine, gsCustom) {
            if (!gsDefine || !gsDefine.enable) return [];
            if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];

            this.resultTenderInfo = [];
            const gsSetting = JSON.parse(gsDefine.setting);
            let commonIndex = 0;
            for (const tender of gsCustom.tenders) {
                const specialKey = this._checkSpecialTender(tender, gsSetting.special);
                if (specialKey === '') {
                    switch (gsSetting.type) {
                        case 'month':
                            await this._gatherMonthTenderInfo(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
                            break;
                        case 'zone':
                            await this._gatherZoneTenderInfo(tender, commonIndex, gsCustom.zone);
                            break;
                        case 'final':
                            await this._gatherFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
                            break;
                        case 'checked-final':
                            await this._gatherCheckedFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
                            break;
                        case 'ledger':
                            await this._gatherLedgerTenderInfo(tender, commonIndex);
                            break;
                    }
                    commonIndex++;
                } else {
                    await this._gatherSpecialTenderInfo(tender, specialKey);
                }
            }
            return this.resultTenderInfo;
        }

        /**
         * 合同支付
         */
        _gatherPayRecord(dealPay, fun) {
            let rdp;
            if (dealPay.ptype !== payConst.payType.normal) {
                rdp = this.ctx.helper._.find(this.resultDealpPay, {ptype: dealPay.ptype});
            } else {
                rdp = this.ctx.helper._.find(this.resultDealpPay, {
                    name: dealPay.name,
                    minus: dealPay.minus ? true : false,
                    is_yf: dealPay.is_yf ? true : false,
                });
            }
            if (!rdp) {
                rdp = {
                    ptype: dealPay.ptype,
                    name: dealPay.name,
                    minus: dealPay.minus ? true : false,
                    is_yf: dealPay.is_yf ? true : false,
                };
                this.resultDealpPay.push(rdp);
            }
            if (fun) fun(rdp, dealPay);
        }

        async _checkStagePayCalc(tender, stage, dealPay) {
            if (!stage.readOnly) {
                // 计算 本期金额
                const payCalculator = new PayCalculator(this.ctx, stage, tender.info);
                await payCalculator.calculateAll(dealPay);
            }
        }

        async _gatherStagePay(index, tender, stage, hasPre) {
            if (stage) {
                const helper = this.ctx.helper;
                await this.ctx.service.stage.doCheckStage(stage);

                const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
                await this._checkStagePayCalc(tender, stage, dealPay);
                for (const dp of dealPay) {
                    dp.end_tp = helper.add(dp.pre_tp, dp.tp);
                    this._gatherPayRecord(dp, function (gatherData, sourceData) {
                        const preFix = 't_' + index + '_';
                        gatherData[preFix + '_id'] = tender.id;
                        gatherData[preFix + '_name'] = tender.name;

                        gatherData[preFix + 'tp'] = helper.add(gatherData[preFix + 'tp'], sourceData.tp);
                        gatherData[preFix + 'pre_tp'] = helper.add(gatherData[preFix + 'pre_tp'], sourceData.pre_tp);
                        gatherData[preFix + 'end_tp'] = helper.add(gatherData[preFix + 'end_tp'], sourceData.end_tp);

                        gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
                        gatherData['s_' + 'pre_tp'] = helper.add(gatherData['s_' + 'pre_tp'], sourceData.pre_tp);
                        gatherData['s_' + 'end_tp'] = helper.add(gatherData['s_' + 'end_tp'], sourceData.end_tp);
                    });
                }
            }
        }

        async _gatherMonthStagePay(sTender, index, month, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getValidStages(tender.id);
            const stage = this.ctx.helper._.find(stages, {s_time: month});
            await this._gatherStagePay(index, tender, stage, hasPre);
        }

        async _gatherZoneStagePay(sTender, index, zone) {
            const helper = this.ctx.helper;

            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getValidStages(tender.id);

            const times = zone.split(' - ');
            if (times.length !== 2) throw '选择的汇总周期无效';
            const beginTime = moment(times[0], 'YYYY-MM');
            const endTime = moment(times[1], 'YYYY-MM');

            for (const stage of stages) {
                const sTime = moment(stage.s_time, 'YYYY-MM');
                if (sTime.isBetween(beginTime, endTime, null, '[]')) {
                    await this.ctx.service.stage.doCheckStage(stage);

                    const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
                    await this._checkStagePayCalc(tender, stage, dealPay);
                    for (const dp of dealPay) {
                        dp.end_tp = helper.add(dp.pre_tp, dp.tp);
                        this._gatherPayRecord(dp, function (gatherData, sourceData) {
                            const preFix = 't_' + index + '_';
                            gatherData[preFix + '_id'] = tender.id;
                            gatherData[preFix + '_name'] = tender.name;

                            gatherData[preFix + 'tp'] = helper.add(gatherData[preFix + 'tp'], sourceData.tp);
                            gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
                        });
                    }
                }
            }
        }

        async _gatherFinalStagePay(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getValidStages(tender.id);
            await this._gatherStagePay(index, tender, stages[0], hasPre);
        }

        async _gatherCheckedFinalStagePay(sTender, index, hasPre) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            const stages = await this._getCheckedStages(tender.id);
            await this._gatherStagePay(index, tender, stages[0], hasPre);
        }

        async getGatherStagePay(memFieldKeys, gsDefine, gsCustom) {
            if (!gsDefine || !gsDefine.enable) return [];
            if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];

            this.resultTenderInfo = [];
            const gsSetting = JSON.parse(gsDefine.setting);
            let commonIndex = 0;
            for (const tender of gsCustom.tenders) {
                const specialKey = this._checkSpecialTender(tender, gsSetting.special);
                if (specialKey === '') {
                    switch (gsSetting.type) {
                        case 'month':
                            await this._gatherMonthStagePay(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
                            break;
                        case 'zone':
                            await this._gatherZoneStagePay(tender, commonIndex, gsCustom.zone);
                            break;
                        case 'final':
                            await this._gatherFinalStagePay(tender, commonIndex, gsSetting.hasPre);
                            break;
                        case 'checked-final':
                            await this._gatherCheckedFinalStagePay(tender, commonIndex, gsSetting.hasPre);
                            break;
                    }
                    commonIndex++;
                }
                // 合同支付，只有在每一期中有数据，故特殊标段直接不汇总合同支付
            }
            return this.resultDealpPay;
        }

        /**
         * 签约清单
         */
        async _gatherDealBills(tender, fun) {
            const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({
                where: { tender_id: tender.id }
            });
            for (const db of dealBills) {
                let rdb = this.ctx.helper._.find(this.resultDealBills, {
                    code: db.code,
                    name: db.name,
                    unit: db.unit,
                    unit_price: db.unit_price ? db.unit_price: 0,
                });
                if (!rdb) {
                    rdb = {
                        code: db.code,
                        name: db.name,
                        unit: db.unit,
                        unit_price: db.unit_price ? db.unit_price: 0,
                    };
                    this.resultDealBills.push(rdb);
                }
                if (fun) fun(rdb, db);
            }
        }

        async _gatherCommonDealBills(sTender, index) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            await this._gatherDealBills(tender, function (gatherData, sourceData) {
                const prefix = 't_' + index + '_';
                gatherData[prefix + 'id'] = tender.id;
                gatherData[prefix + 'name'] = tender.name;

                gatherData[prefix + 'qty'] = sourceData.quantity;
                gatherData[prefix + 'tp'] = sourceData.total_price;

                gatherData['s_' + 'qty'] = sourceData.quantity;
                gatherData['s_' + 'tp'] = sourceData.total_price;
            });
        }

        async _gatherSpecialDealBills(sTender, sKey) {
            const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
            await this._gatherDealBills(tender, function (gatherData, sourceData) {
                const prefix = 'st_' + sKey + '_';

                gatherData[prefix + 'qty'] = sourceData.quantity;
                gatherData[prefix + 'tp'] = sourceData.total_price;
            });
        }

        async getGatherDealBills(memFieldKeys, gsDefine, gsCustom) {
            if (!gsDefine || !gsDefine.enable) return [];
            if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];

            this.resultTenderInfo = [];
            const gsSetting = JSON.parse(gsDefine.setting);
            let commonIndex = 0;
            for (const tender of gsCustom.tenders) {
                const specialKey = this._checkSpecialTender(tender, gsSetting.special);
                if (specialKey === '') {
                    await this._gatherCommonDealBills(tender, commonIndex);
                    commonIndex++;
                } else {
                    await this._gatherSpecialDealBills(tender, specialKey);
                }
            }
            return this.resultDealBills;
        }

        async getMaterial(tender_id, material_order, memFieldKeys) {
            return await this.ctx.service.material.getValidMaterials(tender_id);
        }

        _completeMaterialGl(materialGl) {
            const tTypeStr = [], mTypeStr = [];
            for (const t of materialConst.t_type) {
                tTypeStr[t.value] = t.text;
            }
            for (const m of materialConst.m_type) {
                mTypeStr[m.value] = m.text;
            }
            for (const gl of materialGl) {
                gl.tp = this.ctx.helper.mul(gl.quantity, gl.m_spread);
                gl.t_type_str = tTypeStr[gl.t_type];
                gl.m_type_str = tTypeStr[gl.m_type];
            }
        }

        async getMaterialGl(tender_id, material_order, memFieldKeys) {
            const materials = await this.ctx.service.material.getAllDataByCondition({
                where: {tid: tender_id},
                orders: [['order', 'desc']],
            });
            if (materials.length > 0) {
                let result;
                if (materials[0].order === material_order) {
                    result = await this.ctx.service.materialBills.getAllDataByCondition({
                        where: {tid: tender_id}
                    });
                } else {
                    const material = this.ctx.helper.find(materials, {order: material_order});
                    if (!material) return [];
                    const sql = 'SELECT m.id, m.tid, m.mid, m.t_type, m.code, m.name, m.unit, m.spec, m.m_type,' +
                        '    m.base_price, m.base_times, m.remark, m.in_time,' +
                        '    mh.quantity, mh.expr, mh.msg_tp, mh.msg_times, mh.msg_spread, mh.m_up_risk, mh.m_down_risk, mh.m_spread' +
                        '  FROM ' + this.ctx.service.materialBills.tableName + ' m' +
                        '  LEFT JOIN ' + this.ctx.service.materialBillsHistory.tableName + ' mh' +
                        '  ON m.id = mh.mb_id' +
                        '  WHERE mh.mid = ?';
                    const sqlParam = [material.id];
                    result = this.ctx.app.mysql.query(sql, sqlParam);
                }
                this._completeMaterialGl(result);
                return result;
            } else {
                return [];
            }
        }
    }

    return RptGatherMemory;
};