ConstructionCost/web/over_write/js/guangdong_2018_import.js

'use strict';

const importXML = (() => {
    // 通用设置和工具
    const config = importXMLBase.CONFIG;
    const util = importXMLBase.UTIL;
    const {
        fixedFlag,
        billType,
        rationType,
        projectType,
        TaxType,
    } = commonConstants;
    const { AdjustType } = config;
    const {
        getValue,
        arrayValue,
        getFee,
        mergeFees,
        assignAttr,
        mergeDataRecur,
        getFlag,
        getBool,
        getItemsRecur,
        extractItemsRecur,
    } = util;

    //导入的文件类型，界面选的文件类型是生成项目的文件类型，这里的文件类型指的是，要导入文件的类型，
    //导入文件类型不同，导入数据不同
    let importFileKind = '';
    //文件类型
    const FileKind = {
        '6': 1, // 投标
        'tender': 1,
        '4': 2, // 招标
        'bid': 2,
        '5': 3, // 控制价
        'control': 3,
    };
    // 一些数据是需要从后端获取自增数字后赋值的，这里是记录，用完会在extractProject清空
    const countData = {
        projectCount: 0,    //项目数量
        projectGLJCount: 0,  //项目人材机数量
        ratioCount: 0,      //组成物数量
        unitPriceCount: 0,   //单价数量
        unitPriceFileCount: 0,  //单价文件数量
    };
    // 精度
    const Decimal = {
        // 工料机消耗量、含量、用量类小数精度
        GLJ: 4,
        // 工程量、数量类小数精度
        QUANTITY: 3,
        // 金额、合价、费用类小数精度
        FEE: 2,
        // 费率、指数、比例（%）类小数精度
        RATE: 3,
    };

    /* 
     * 从导入的xml文件中提取有用的数据
     *
    */

    // 建设项目
    function extractProject(xmlObjMap) {
        Object.keys(countData).forEach(key => countData[key] = 0); // 清缓存
        countData.projectCount++;
        const projectXMLObj = xmlObjMap['Project.xml'];
        const projectSrc = getValue(projectXMLObj, ['ConstructionProject']);
        importFileKind = FileKind[getValue(projectSrc, ['_FileKind'])]; // 标记当前导入的文件类型
        const rst = {
            projType: projectType.Project,
            name: getValue(projectSrc, ['_Name']),
            engs: extractEngs(projectSrc, xmlObjMap),
            property: {
                compilationIllustrationProject: getValue(projectSrc, ['_Explains'])
            },
            basicInformation: extractBasicInfo(projectSrc)
        };
        countData.unitPriceCount = countData.projectGLJCount;
        if (importFileKind !== FileKind.tender) {
            countData = {
                projectCount: countData.projectCount,
                unitPriceFileCount: countData.unitPriceFileCount
            };
        }
        return rst;
    }
    // 从xml对象中提取基本信息相关
    function extractBasicInfo(projectSrc) {
        const projectInfo = getValue(projectSrc, ['ProjectInfo']); // 估概预算信息
        const tendereeInfo = getValue(projectSrc, ['TendereeInfo']); // 招标信息
        const bidderInfo = getValue(projectSrc, ['BidderInfo']); // 投标信息
        return [
            { key: 'projNum', value: getValue(projectSrc, ['_Number']) }, // 编码
            { key: 'projectCategory', value: getValue(projectSrc, ['_ProjectCategory']) }, // 工程类别
            { key: 'constructionType', value: getValue(projectSrc, ['_ConstructionType']) }, // 建设性质
            { key: 'regionalCategories', value: getValue(projectSrc, ['_AreaKind']) }, // 地区类被
            { key: 'projLocation', value: getValue(projectSrc, ['_ProjectSite']) }, // 工程地点
            { key: 'constructingUnits', value: getValue(projectSrc, ['_BulidUnit']) }, // 建设单位
            { key: 'constructingUnitsPerson', value: getValue(projectSrc, ['_BulidAuthorizer']) }, // 建设单位法定代表人或其授权人
            { key: 'rangeOfCompilation', value: getValue(projectSrc, ['_RangeOfCompilation']) }, // 建设（编制）范围
            { key: 'scale', value: getValue(projectSrc, ['_Scale']) }, // 建设规模
            { key: 'unit', value: getValue(projectSrc, ['_Unit']) }, // 建设规模单位
            { key: 'designUnits', value: getValue(projectInfo, ['_Designer']) }, // 设计单位
            { key: 'constructionUnits', value: getValue(projectInfo, ['_Contractor']) }, // 承包单位
            { key: 'establishUnit', value: getValue(projectInfo, ['_CompileCompany']) }, // 编制单位
            { key: importFileKind === FileKind.tender ? 'bidCompileDate' : 'tenderCompileDate', value: getValue(projectInfo, ['_CompileDate']) }, // 编制时间
            { key: 'authorizer', value: getValue(projectInfo, ['_Authorizer']) }, // 编制单位法定代表人或其授权人
            { key: 'tendereeName', value: getValue(tendereeInfo, ['_TendereeName']) }, // 招标人
            { key: 'tenderAuthorizer', value: getValue(tendereeInfo, ['_TenderAuthorizer']) }, // 招标单位法定代表人或其授权人
            { key: 'tenderCompiler', value: getValue(tendereeInfo, ['_TenderCompiler']) }, // 招标单位编制人
            { key: 'tenderCompilerCertNo', value: getValue(tendereeInfo, ['_TenderCompilerCertNo']) }, // 招标单位编制人资格证书编号
            { key: 'tenderCompileDate', value: getValue(tendereeInfo, ['_TenderCompileDate']) }, // 招标单位编制时间
            { key: 'tenderExaminer', value: getValue(tendereeInfo, ['_TenderExaminer']) }, // 招标单位审核人
            { key: 'tenderExaminerCertNo', value: getValue(tendereeInfo, ['_TenderExaminerCertNo']) }, // 招标单位审核人资格证书编号
            { key: 'tenderExamineDate', value: getValue(tendereeInfo, ['_TenderExamineDate']) }, // 招标单位审核时间
            { key: 'tenderApprover', value: getValue(tendereeInfo, ['_TenderApprover']) }, // 招标单位审定人
            { key: 'tenderApproverCertNo', value: getValue(tendereeInfo, ['_TenderApproverCertNo']) }, // 招标单位审定人资格证书编号
            { key: 'proxy', value: getValue(tendereeInfo, ['_Proxy']) }, // 招标代理
            { key: 'proxyCertNo', value: getValue(tendereeInfo, ['_ProxyCertNo']) }, // 招标代理资质证书编号
            { key: 'proxyAuthorizer', value: getValue(tendereeInfo, ['_ProxyAuthorizer']) }, // 招标代理法定代表人或其授权人
            { key: 'proxyCompiler', value: getValue(tendereeInfo, ['_ProxyCompiler']) }, // 招标代理编制人员
            { key: 'proxyCompilerCertNo', value: getValue(tendereeInfo, ['_ProxyCompilerCertNo']) }, // 招标代理编制人员资格证书编号
            { key: 'proxyCompileDate', value: getValue(tendereeInfo, ['_ProxyCompileDate']) }, // 招标代理编制时间
            { key: 'proxyExaminer', value: getValue(tendereeInfo, ['_ProxyExaminer']) }, // 招标代理审核人
            { key: 'proxyExaminerCertNo', value: getValue(tendereeInfo, ['_ProxyExaminerCertNo']) }, // 招标代理审核人资格证书编号
            { key: 'proxyExamineDate', value: getValue(tendereeInfo, ['_ProxyExamineDate']) }, // 招标代理审核时间
            { key: 'proxyApprover', value: getValue(tendereeInfo, ['_ProxyApprover']) }, // 招标代理审定人
            { key: 'proxyApproverCertNo', value: getValue(tendereeInfo, ['_ProxyApproverCertNo']) }, // 招标代理审定人资格证书编号
            { key: 'proxyApproveDate', value: getValue(tendereeInfo, ['_ProxyApproveDate']) }, // 招标代理审定时间
            { key: 'consultant', value: getValue(tendereeInfo, ['_Consultant']) }, // 造价咨询
            { key: 'consultantCertNo', value: getValue(tendereeInfo, ['_ConsultantCertNo']) }, // 造价咨询资质证书编号
            { key: 'consultantCompiler', value: getValue(tendereeInfo, ['_ConsultantCompiler']) }, // 造价咨询编制人
            { key: 'consultantCompilerCertNo', value: getValue(tendereeInfo, ['_ConsultantCompilerCertNo']) }, // 造价咨询编制人资格证书
            { key: 'consultantCompileDate', value: getValue(tendereeInfo, ['_ConsultantCompileDate']) }, // 造价咨询编制时间
            { key: 'consultantExaminer', value: getValue(tendereeInfo, ['_ConsultantExaminer']) }, // 造价咨询审核人
            { key: 'consultantExaminerCertNo', value: getValue(tendereeInfo, ['_ConsultantExaminerCertNo']) }, // 造价咨询审核人资格证书编号
            { key: 'consultantExamineDate', value: getValue(tendereeInfo, ['_ConsultantExamineDate']) }, // 造价咨询审核时间
            { key: 'consultantApprover', value: getValue(tendereeInfo, ['_ConsultantApprover']) }, // 造价咨询审定人
            { key: 'consultantApproverCertNo', value: getValue(tendereeInfo, ['_ConsultantApproverCertNo']) }, // 造价咨询审定人资格证书编号
            { key: 'consultantApproveDate', value: getValue(tendereeInfo, ['_ConsultantApproveDate']) }, // 造价咨询审定时间
            { key: 'bidName', value: getValue(bidderInfo, ['_BidName']) }, // 投标人
            { key: 'bidAuthorizer', value: getValue(bidderInfo, ['_BidAuthorizer']) }, // 投标单位法定代表人或其授权人
            { key: 'bidCompiler', value: getValue(bidderInfo, ['_BidCompiler']) }, // 投标单位编制人
            { key: 'bidCompilerCertNo', value: getValue(bidderInfo, ['_BidCompilerCertNo']) }, // 投标单位编制人资格证书编号
            { key: 'bidCompileDate', value: getValue(bidderInfo, ['_BidCompileDate']) }, // 投标单位编制时间
            { key: 'bidExaminer', value: getValue(bidderInfo, ['_BidExaminer']) }, // 投标单位审核人
            { key: 'bidExaminerCertNo', value: getValue(bidderInfo, ['_BidExaminerCertNo']) }, // 投标单位审核人资格证书编号
            { key: 'bidExamineDate', value: getValue(bidderInfo, ['_BidExamineDate']) }, // 投标单位审核时间
            { key: 'bidApprover', value: getValue(bidderInfo, ['_BidApprover']) }, // 投标单位审定人
            { key: 'bidApproverCertNo', value: getValue(bidderInfo, ['_BidApproverCertNo']) }, // 投标单位审定人资格证书
            { key: 'bidApproveDate', value: getValue(bidderInfo, ['_BidApproveDate']) }, // 投标单位审定时间
        ];

    }
    // 从xml对象中提取单项工程数据
    function extractEngs(projectSrc, xmlObjMap) {
        const sectionWorks = arrayValue(projectSrc, ['ProjectInstallationWorkCost', 'SectionalWorks']);
        return sectionWorks.map(src => {
            countData.projectCount++;
            return {
                projType: projectType.Engineering,
                name: getValue(src, ['_Name']),
                code: getValue(src, ['_Number']),
                tenders: extractTenders(src, xmlObjMap)
            }
        });
    }
    // 从xml对象中提取单位工程数据
    function extractTenders(sectionWorkSrc, xmlObjMap) {
        const unitWorks = arrayValue(sectionWorkSrc, ['UnitWorks']);
        return unitWorks.map(unitWorckSrc => {
            countData.projectCount++;
            countData.unitPriceFileCount++;
            const fileName = getValue(unitWorckSrc, ['_FileName']);
            const tenderXMLObj = xmlObjMap[fileName];
            const src = getValue(tenderXMLObj, ['UnitWorks']); // 单位工程文件的数据
            return {
                projType: projectType.Tender,
                name: getValue(src, ['_Name']),
                code: getValue(src, ['_Number']),
                engineering: getValue(src, ['_ProjectType']),
                projectFeature: extractProjectFeature(src),
                workSummary: extractWorkSummary(src),
                fbfx: extractFBFX(src),
                csxm: extractCSXM(src),
                other: extractOther(src),
                tax: extractTax(src),
                ...extractGLJSummary(src),
                bidEvaluationSummary: extractBidEvaluationSummary(src)
            };
        });
    }
    // 提取工程特征数据
    function extractProjectFeature(tenderSrc) {
        // TODO 支持嵌套子项
        const attrInfoItems = arrayValue(tenderSrc, ['AttrInfo', 'AttrInfoItem']);
        return attrInfoItems.map(item => {
            return { name: getValue(item, ['_Name']), value: getValue(item, ['_Value']) };
        });
    }
    // 提取大项费用
    function extractWorkSummary(tenderSrc) {
        const summarySrc = getValue(tenderSrc, ['UnitWorksSummary']);
        const fields = [['UnitWorksSummaryGroup'], ['UnitWorksSummaryItem']];
        return extractItemsRecur(summarySrc, fields, (src, curField) => {
            const item = {
                code: getValue(src, ['_Number']),
                name: getValue(src, ['_Name']),
                quantity: getValue(src, ['_Quantity']),
                remark: getValue(src, ['_Remark']),
                feeCode: getValue(src, ['_Code']), //费用字典
                fees: [{
                    fieldName: 'common', totalFee: getValue(src, ['_Total']) || '0',
                    unitFee: getValue(src, ['_TechnicalAndEconomicIndex']) || '0'
                }]
            };
            if (curField[0] === fields[1][0]) {
                item.calcBase = getValue(src, ['_QtyFormula']);
                item.feeRate = getValue(src, ['_Rate']);
            }
            if (importFileKind !== FileKind.tender) {
                delete item.feeRate
                delete item.fees;
            }
            return item;
        });
    }
    // 从src子项的SummaryOfBasicCost中获取一部分费用
    function getFeesFromBasicCost(src) {
        const summaryCost = getValue(src, ['SummaryOfBasicCost']);
        if (!summaryCost) {
            return [];
        }
        // SummaryOfBasicCost中有用的价格只有：人工费、材料费、主材费、机械费、管理费、利润
        return [
            { fieldName: 'labour', totalFee: getValue(summaryCost, ['_Labor']) || '0' },
            { fieldName: 'material', totalFee: getValue(summaryCost, ['_Material']) || '0' },
            { fieldName: 'mainMaterial', totalFee: getValue(summaryCost, ['_MainMaterial']) || '0' },
            { fieldName: 'machine', totalFee: getValue(summaryCost, ['_Machine']) || '0' },
            { fieldName: 'manage', totalFee: getValue(summaryCost, ['_Overhead']) || '0' },
            { fieldName: 'profit', totalFee: getValue(summaryCost, ['_Profit']) || '0' },
        ];
    }
    // 提取分部分项
    function extractFBFX(tenderSrc) {
        const fbfxSrc = getValue(tenderSrc, ['DivisionalAndElementalWorks']);
        const fields = [['DivisionalWorks'], ['WorkElement']];
        const fees = getFeesFromBasicCost(fbfxSrc); // 分部分项的汇总价
        const items = getItemsRecur(fbfxSrc, fields, (itemSrc, curField) => {
            if (curField[0] === fields[0][0]) { // 分部
                return extractDivisionalWorks(itemSrc, billType.FB);
            } else {
                return extractWorkElement(itemSrc, billType.FX);
            }
        });
        return {
            fees,
            items
        };
    }
    // 提取分部
    function extractDivisionalWorks(divisionalSrc, type) {
        // 分部不需要基数，因此不用把基数导入
        const item = {
            type,
            code: getValue(divisionalSrc, ['_Number']),
            name: getValue(divisionalSrc, ['_Name']),
            unit: getValue(divisionalSrc, ['_Unit']),
            quantity: getValue(divisionalSrc, ['_Quantity']),
            feeCode: getValue(divisionalSrc, ['_Code']),
            remark: getValue(divisionalSrc, ['_Remark']),
        };
        if (importFileKind === FileKind.tender) {
            const summaryFees = getFeesFromBasicCost(divisionalSrc);
            const fees = [{ fieldName: 'common', totalFee: getValue(divisionalSrc, ['_Total']), unitFee: getValue(divisionalSrc, ['_TechnicalAndEconomicIndex']) }];
            item.fees = mergeFees(fees, summaryFees);
        }
        return item;
    }
    // 提取分项清单数据（包含定额、定额人材机）
    function extractWorkElement(workElementSrc, type) {
        const itemCharacterText = getItemCharacterText(getValue(workElementSrc, ['_Attr']));
        const bills = {
            type: type, // 清单类型
            code: getValue(workElementSrc, ['_Number']),
            name: getValue(workElementSrc, ['_Name']),
            itemCharacterText,
            itemCharacter: getItemCharacter(itemCharacterText),
            jocContentText: getValue(workElementSrc, ['_WorkContent']),
            jobContent: getJobContent(workElementSrc),
            unit: getValue(workElementSrc, ['_Unit']),
            quantity: getValue(workElementSrc, ['_Quantity']),
            feeRate: getValue(workElementSrc, ['_Rate']),
            mainBills: getBool(getValue(workElementSrc, ['_Major'])),
            feeCode: getValue(workElementSrc, ['_Code']),
            remark: getValue(workElementSrc, ['_Remark']),
            rations: extractRations(workElementSrc)
        };
        if (type === billType.BILL) {
            // 分项不需要基数
            bills.calcBase = getValue(workElementSrc, ['_QtyFormula']);
        }
        // 投标和控制价，需要导入最高限价
        if ([FileKind.tender, FileKind.control].includes(importFileKind)) {
            const maxPrice = getValue(workElementSrc, ['_PriceHigh']);
            //不为0才输出
            if (maxPrice && maxPrice !== '0') {
                bills.outPutMaxPrice = true;
                bills.maxPrice = maxPrice;
            }
            if (importFileKind === FileKind.tender) {
                const summaryFees = getFeesFromBasicCost(workElementSrc);
                const fees = [
                    { fieldName: 'common', unitFee: getValue(workElementSrc, ['_Price']), totalFee: getValue(workElementSrc, ['_Total']) },
                    { fieldName: 'equipment', unitFee: getValue(workElementSrc, ['_EquipmentPrice']) },
                ];
                bills.fees = mergeFees(fees, summaryFees);
            }
        }
        return bills;
        // 获取项目特征文本
        function getItemCharacterText(attr) {
            // 去掉除换行符以外的空白符
            const newLine = '{newLine}';
            attr = attr
                .replace(/[\r\n]/g, newLine)
                .replace(/\s/g, '')
                .replace(new RegExp(newLine, 'g'), '\n');
            const matchStrs = ['
', ';'];
            const matchStr = matchStrs.find(str => attr.includes(str));
            if (matchStr) {
                attr = attr.replace(new RegExp(matchStr, 'g'), '\n');
            }
            return attr;
        }
        // 获取清单项目特征窗口数据
        function getItemCharacter(itemText) {
            const itemsList = itemText.split('\n');
            const reg = /\d+\.([^:]+)[:：](.*)?/;
            const itemCharacter = [];
            let idx = 1;
            itemsList.forEach(str => {
                str = str.replace(/\s/g, '');
                const result = reg.exec(str);
                if (!result) {
                    return;
                }
                const name = result[1];
                const value = result[2] || '';
                const eigenvalue = value ? [{ value, isSelected: true }] : [];
                itemCharacter.push({
                    character: name,
                    isChecked: true,
                    serialNo: idx++,
                    eigenvalue
                });
            });
            return itemCharacter;
        }
        // 获取清单工作内容窗口数据
        function getJobContent(workElementSrc) {
            return arrayValue(workElementSrc, ['WorkContent']).map((workContent, idx) => ({
                content: getValue(workContent, ['_Name']),
                serialNo: idx + 1,
                isChecked: true
            }));
        }
    }
    // 提取定额
    function extractRations(workElementSrc) {
        if (importFileKind !== FileKind.tender) {
            return [];
        }
        // 正常情况下定额肯定是在WorkContent内的,但是也做定额不在WorkContent内的处理（外层定额）
        const rations = [];
        let serialNo = 1;
        const workContents = arrayValue(workElementSrc, ['WorkContent']);
        workContents.forEach(workContent => {
            const innerRationsSrc = arrayValue(workContent, ['Norm']);
            const jobContentText = getValue(workContent, ['_Name']);
            const innerRations = innerRationsSrc.map(rationSrc => extractRation(rationSrc, jobContentText));
            rations.push(...innerRations);
        });
        const outerRationsSrc = arrayValue(workElementSrc, ['Norm']);
        const outerRations = outerRationsSrc.map(rationSrc => extractRation(rationSrc, ''));
        rations.push(...outerRations);
        return rations;
        // 获取类型
        function getType(rationSrc) {
            const overHeightMap = {
                '1': true,
                '2': false
            };
            const isOverHeight = overHeightMap[getValue(rationSrc, ['EfficiencyKind'])];
            if (isOverHeight) {
                return rationType.overHeight;
            }
            const itemIncreaseMap = {
                '1': true,
                '2': false
            };
            const isItemIncrease = itemIncreaseMap[getValue(rationSrc, ['IncFeeKind'])];
            if (isItemIncrease) {
                return rationType.itemIncrease;
            }
            return rationType.ration;
        }
        // 从定额的计算程序提取价格
        function getFeesFromCalculationOfItem(rationSrc) {
            const calculationOfItems = arrayValue(rationSrc, ['UnitPriceCalculationOfItem']);
            const fees = [];
            const codeFiedNameMap = {
                'DEZJF': 'direct',
                'RGF': 'labour',
                'CLF': 'material',
                'JXF': 'machine',
                'ZCF': 'mainMaterial',
                'SBF': 'equipment',
                'LR': 'profit',
                'DJ': 'common',

            };
            calculationOfItems.forEach(item => {
                const totalFee = +getValue(item, ['_Total']);
                const fieldName = codeFiedNameMap[getValue(item, ['_Code'])];
                if (totalFee && fieldName) {
                    fees.push({ fieldName, totalFee });
                }
            });
            return fees;
        }
        // 提取定额人材机
        function extractRationGLJs(rationSrc) {
            const rationGLJsSrc = arrayValue(rationSrc, ['LabourMaterialsEquipmentsMachinesElement']);
            return rationGLJsSrc.map(src => ({
                code: getValue(src, ['_Number']),
                quantity: getValue(src, ['_Quantity'])
            }));
        }
        // TODO 目前无法确定定额的取费专业programID，暂时用专业类别Specialty
        function extractRation(rationSrc, jobContentText) {
            const ration = {
                serialNo: serialNo++,
                code: getValue(rationSrc, ['_Number']),
                name: getValue(rationSrc, ['_Name']),
                unit: getValue(rationSrc, ['_Unit']),
                quantity: getValue(rationSrc, ['_Quantity']),
                type: getType(rationSrc),
                programID: getValue(rationSrc, ['_Specialty']),
                libCode: getValue(rationSrc, ['_NormIdentity']),
                jobContentText,
                remark: getValue(rationSrc, ['_Remark'])
            };
            const fees = [{ fieldName: 'common', unitFee: getValue(rationSrc, ['_Price']), totalFee: getValue(rationSrc, ['_Total']) }]
            const feesFromCalcItem = getFeesFromCalculationOfItem(rationSrc);
            ration.fees = mergeFees(fees, feesFromCalcItem);
            ration.rationGLJs = extractRationGLJs(rationSrc);
            return ration;
        }
    }
    // 提取措施项目
    function extractCSXM(tenderSrc) {
        const csxmSrc = getValue(tenderSrc, ['Preliminaries']);
        const fields = [['DivisionalWorks'], ['WorkElement']];
        const fees = getFeesFromBasicCost(csxmSrc); // 措施项目的汇总价
        const items = getItemsRecur(csxmSrc, fields, (itemSrc, curField) => {
            if (curField[0] === fields[0][0]) {
                return extractDivisionalWorks(itemSrc, billType.BILL);
            } else {
                return extractWorkElement(itemSrc, billType.BILL);
            }
        });
        return {
            fees,
            items
        };
    }
    // 提取其他项目
    function extractOther(tenderSrc) {
        const sundry = getValue(tenderSrc, ['Sundry']);
        // SundryCosts 其他项目 ,对于我们软件是其他项目下完整数据，但是广联达的并不是，因此需要Sundry的其他节点来补充这份数据
        const sundryCosts = getValue(sundry, ['SundryCosts']);
        // 其他项目汇总费用
        const sundryFees = [{ fieldName: 'common', totalFee: getValue(sundryCosts, ['_Total']) }];
        const provisionalMaterialEquipment = getValue(sundry, ['ProvisionalMaterialEquipment']);
        return {
            fees: importFileKind === FileKind.tender ? sundryFees : [],
            sundryCosts: extractData(sundry, 'SundryCosts', [['SundryCostsGroup'], ['SundryCostsItem']]),
            provisional: extractData(sundry, 'ProvisionalSums', [['ProvisionalSumsGroup'], ['ProvisionalSumsItem']]),
            ProvisionalMaterialEquipment: {
                name: getValue(provisionalMaterialEquipment, ['_Name']),
                feeCode: getValue(provisionalMaterialEquipment, ['_Code']),
                remark: getValue(provisionalMaterialEquipment, ['_Remark']),
                fees: [{ fieldName: 'common', totalFee: getValue(provisionalMaterialEquipment, ['_Total']) }],
            },
            specialty: extractData(sundry, 'SpecialtyProvisionalPrice', [['SpecialtyProvisionalPriceGroup'], ['SpecialtyProvisionalPriceItem']],
                { engineeringContent: ['_Content'] }, { engineeringContent: ['_Content'] }),
            dayWork: extractData(sundry, 'DayWorkRate', [['DayWorkRateGroup'], ['DayWorkRateItem']]),
            mainContractor: extractData(sundry, 'MainContractorAttendance', [['MainContractorAttendanceGroup'], ['MainContractorAttendanceItem']], { serviceContent: ['_Content'] }),
            claim: extractData(sundry, 'ClaimsCost', [['ClaimsCostGroup'], ['ClaimsCostItem']]),
            visa: extractData(sundry, 'SiteInstructionCost', [['SiteInstructionCostGroup'], ['SiteInstructionCostItem']]),
        };
        // 提取标题和明细
        function extractGroupOrItem(itemSrc, isGroup = true, extendAttrs = null) {
            const source = isGroup
                ? {
                    name: getValue(itemSrc, ['_Name']),
                    fees: importFileKind === FileKind.tender ? [{ fieldName: 'common', totalFee: getValue(itemSrc, ['_Total']) }] : [],
                    feeCode: getValue(itemSrc, ['_Code']),
                    remark: getValue(itemSrc, ['_Remark'])
                }
                : {
                    name: getValue(itemSrc, ['_Name']),
                    unit: getValue(itemSrc, ['_Unit']),
                    quantity: getValue(itemSrc, ['_Quantity']),
                    calcBase: getValue(itemSrc, ['_QtyFormula']),
                    feeRate: getValue(itemSrc, ['_Rate']),
                    fees: importFileKind === FileKind.tender ? [{ fieldName: 'common', unitFee: getValue(itemSrc, ['_Price']), totalFee: getValue(itemSrc, ['_Total']) }] : [],
                    feeCode: getValue(itemSrc, ['_Code']),
                    remark: getValue(itemSrc, ['_Remark'])
                };
            return extendAttrs ? Object.assign(source, extendAttrs) : source;
        }
        // 提取数据
        function extractData(sundry, srcName, fields, groupExtendMap, itemExtendMap) {
            const src = getValue(sundry, [srcName]);
            return {
                fees: importFileKind === FileKind.tender ? [{ fieldName: 'common', totalFee: getValue(src, ['_Total']) }] : [],
                feeCode: getValue(src, ['_Code']),
                items: extractItemsRecur(src, fields, (itemSrc, curField) => {
                    const groupExtend = groupExtendMap
                        ? Object.keys(groupExtendMap).reduce((acc, key) => {
                            acc[key] = getValue(itemSrc, groupExtendMap[key]);
                            return acc;
                        }, {})
                        : null;
                    const itemExtend = itemExtendMap
                        ? Object.keys(itemExtendMap).reduce((acc, key) => {
                            acc[key] = getValue(itemSrc, itemExtendMap[key]);
                            return acc;
                        }, {})
                        : null;
                    return curField[0] === fields[0][0]
                        ? extractGroupOrItem(itemSrc, true, groupExtend)
                        : extractGroupOrItem(itemSrc, false, itemExtend);
                })
            };
        }
    }
    // 提取税金
    function extractTax(tenderSrc) {
        const taxSrc = getValue(tenderSrc, ['Tax']);
        const itemsSrc = arrayValue(taxSrc, ['TaxItem']);
        return {
            ...extractTaxItem(taxSrc),
            items: itemsSrc.map(extractTaxItem)
        };
        function extractTaxItem(src) {
            return {
                name: getValue(src, ['_Name']),
                calcBase: getValue(src, ['_QtyFormula']),
                feeRate: getValue(src, ['_Rate']),
                fees: importFileKind === FileKind.tender ? [{ fieldName: 'common', totalFee: getValue(src, ['_Total']) }] : [],
                feeCode: getValue(src, ['_Code']),
                remark: getValue(src, ['_Remark'])
            };
        }
    }

    // 供料方式
    const Provider = {
        '1': commonConstants.supplyType.ZXCG,
        '2': commonConstants.supplyType.BFJG,
        '3': commonConstants.supplyType.WQJG
    };

    // 提取人材机汇总相关(人材机汇总表、承包材料表)
    function extractGLJSummary(tenderSrc) {
        const initData = { gljSummary: [], differentiaSummary: [], exponentialSummary: [] };
        if (importFileKind !== FileKind.tender) {
            return initData;
        }
        const taxType = getValue(tenderSrc, ['_TaxModel']); // 计税方式
        const gljListSrc = arrayValue(tenderSrc, ['LabourMaterialsEquipmentsMachinesSummary']);
        return gljListSrc.reduce((acc, gljSrc) => {
            acc.gljSummary.push(extractGLJ(gljSrc));
            const differentiaGLJ = extractDifferentiaGLJ(gljSrc);
            if (differentiaGLJ) {
                acc.differentiaSummary.push(differentiaGLJ);
            }
            const exponentialGLJ = extractExponentialGLJ(gljSrc);
            if (exponentialGLJ) {
                acc.exponentialSummary.push(exponentialGLJ);
            }
            return acc;
        }, initData);

        // 获取原始编码
        function getOriginalCode(code) {
            //编码后面有-\d+的形式，去掉-\d+取前面的字符串作为原始代码
            return code.replace(/(.*)-\d+$/, '$1');
        }
        // TODO (不靠谱) 获取人材机类型数据
        // 导入的源文件没有细化区分人材机类型，这里只是暂时大概给个值。后续会在后端与标准人材机进行配对。也因此无法准确处理补充人材机
        function getTypeData(gljSrc) {
            const concrete = getBool(getValue(gljSrc, ['_Concrete']));
            if (concrete) {
                return { type: 205, shorName: '商砼' };
            }
            const type = getValue(gljSrc, ['_Kind']);
            switch (type) {
                case '6':
                    return { type: 202, shorName: '砼' };
                case '7':
                    return { type: 301, shorName: '机' };
                case '15':
                    return { type: 6, shortName: '管' };
                default:
                    return { type: 201, shortName: '材' };
            }
        }
        // 根据计税方式获取价格，一般计税对应不含税，简易对应含税
        function getPriceByTaxType(gljSrc, taxType) {
            return taxType === TaxType.NORMAL
                ? {
                    base_price: getValue(gljSrc, ['_NoTaxOrgPrice']),
                    market_price: getValue(gljSrc, ['_NoTaxPrice'])
                }
                : {
                    base_price: getValue(gljSrc, ['_TaxOrgPrice']),
                    market_price: getValue(gljSrc, ['_TaxPrice'])
                };
        }
        // 提取组成物
        function extractRatios(gljSrc) {
            const ratiosSrc = arrayValue(gljSrc, ['LabourMaterialsEquipmentsMachinesElement']);
            countData.ratioCount += ratiosSrc.length;
            return ratiosSrc.map(src => ({
                code: getValue(src, ['_Number']),
                consumption: getValue(src, ['_Quantity'])
            }));
        }
        // 提取项目人材机
        function extractGLJ(gljSrc) {
            countData.projectGLJCount++;
            const code = getValue(gljSrc, ['_Number']);
            return {
                code,
                original_code: getOriginalCode(code),
                name: getValue(gljSrc, ['_Name']),
                specs: getValue(gljSrc, ['_Specification']),
                unit: getValue(gljSrc, ['_Unit']),
                ...getTypeData(gljSrc),
                ...getPriceByTaxType(gljSrc, taxType), // 软件中项目人材机是没有价格的，只是为了后续处理单价文件
                is_main_material: getBool(getValue(gljSrc, ['_MainMaterial'])),
                is_evaluate: getBool(getValue(gljSrc, ['_ProvisionalMaterial'])),
                supply: Provider[getValue(gljSrc, ['_Provider'])],
                delivery: getValue(gljSrc, ['_Delivery']),
                delivery_address: getValue(gljSrc, ['_Location']),
                originPlace: getValue(gljSrc, ['_ProducingArea']),
                vender: getValue(gljSrc, ['_Supplier']),
                qualityGrace: getValue(gljSrc, ['_Character']),
                remark: getValue(gljSrc, ['_Remark']),
                ratios: extractRatios(gljSrc)
            };
        }
        // 提取造价信息差额调整法
        function extractDifferentiaGLJ(gljSrc) {
            // 风险系数或者基准单价有值，才算一条差额数据
            const riskCoe = getValue(gljSrc, ['_ProviderExp']);
            const standardPrice = getValue(gljSrc, ['_ProviderBase']);
            if ((riskCoe && riskCoe !== '0') || (standardPrice && standardPrice !== '0')) {
                return {
                    code: getValue(gljSrc, ['_Number']),
                    name: getValue(gljSrc, ['_Name']),
                    specs: getValue(gljSrc, ['_Specification']),
                    unit: getValue(gljSrc, ['_Unit']),
                    quantity: getValue(gljSrc, ['_Quantity']),
                    riskCoe,
                    standardPrice,
                    market_price: getPriceByTaxType(gljSrc, taxType).market_price,
                    remark: getValue(gljSrc, ['_Remark']),
                };
            }
            return null;
        }
        // 提取价格指数调整法
        function extractExponentialGLJ(gljSrc) {
            // 变值权重或基本、现行价格指数有值，才算一条指数数据
            const varWeight = getValue(gljSrc, ['_Weight']);
            const FO = getValue(gljSrc, ['_BasicPrice']);
            const FI = getValue(gljSrc, ['_CurrentPrice']);
            if ((varWeight && varWeight !== '0') || (FO && FO !== '0') || (FI && FI !== '0')) {
                return {
                    code: getValue(gljSrc, ['_Number']),
                    name: getValue(gljSrc, ['_Name']),
                    specs: getValue(gljSrc, ['_Specification']),
                    varWeight: varWeight,
                    FO: FO,
                    FI: FI,
                    remark: getValue(gljSrc, ['_Remark'])
                };
            }
            return null;
        }
    }
    // 提取评标材料
    function extractBidEvaluationSummary(tenderSrc) {
        if (importFileKind !== FileKind.tender) {
            return [];
        }
        const srcList = arrayValue(tenderSrc, ['BidEvaluationMainMaterial']);
        return srcList.map(gljSrc => ({
            seq: getValue(gljSrc, ['_Code']),
            code: getValue(gljSrc, ['_Number']),
            name: getValue(gljSrc, ['_Name']),
            specs: getValue(gljSrc, ['_Specification']),
            unit: getValue(gljSrc, ['_Unit']),
            quantity: getValue(gljSrc, ['_Quantity']),
            market_price: getValue(gljSrc, ['_Price']),
            originPlace: getValue(gljSrc, ['_ProducingArea']),
            vender: getValue(gljSrc, ['_Supplier']),
            remark: getValue(gljSrc, ['_Remark'])
        }));
    }


    /* 
     * 转换从xml提取的数据，转换成软件所需的数据结构
     *
    */
    async function transformData(extractedData) {
        const IDPlaceholder = await ajaxPost('/pm/import/getProjectPlaceholder', countData);
        extractedData.ID = IDPlaceholder.project++;
        // 最终上传到服务器的转换后的数据
        const transformedData = {
            ID: extractedData.ID,
            ParentID: extractedData.ParentID,
            NextSiblingID: extractedData.NextSiblingID,
            preID: extractedData.preID,
            name: extractedData.name,
            basicInformation: extractedData.basicInformation,
            projType: extractedData.projType,
            property: extractedData.property,
            shareInfo: [],
            engs: []
        };
        // 所有的清单模板库ID
        const allTemplateLibIDs = [];
        extractedData.engs.forEach(eng => {
            eng.tenders.forEach(tender => {
                let templateLibID = tender.property.templateLibID;
                if (!allTemplateLibIDs.includes(templateLibID)) {
                    allTemplateLibIDs.push(templateLibID);
                }
            });
        });
        // 模板映射：{[templateLibID]: data}
        const templateMapping = await ajaxPost('/template/bills/api/getNeedfulTemplate', { allTemplateLibIDs });
        for (let i = 0; i < extractedData.engs.length; i++) {
            const curEng = extractedData.engs[i];
            const preEng = transformedData.engs[i - 1];
            curEng.ID = IDPlaceholder.project++;
            curEng.ParentID = extractedData.ID;
            curEng.NextSiblingID = -1;
            if (preEng) {
                preEng.NextSiblingID = curEng.ID;
            }
            const engData = {
                ID: curEng.ID,
                ParentID: curEng.ParentID,
                NextSiblingID: curEng.NextSiblingID,
                code: curEng.code,
                name: curEng.name,
                projType: curEng.projType,
                shareInfo: [],
                tenders: []
            };
            transformedData.engs.push(engData);
            for (let j = 0; j < curEng.tenders.length; j++) {
                const curTender = curEng.tenders[j];
                const preTender = engData.tenders[j - 1];
                curTender.ID = IDPlaceholder.project++;
                curTender.ParentID = curEng.ID;
                curTender.NextSiblingID = -1;
                curTender.property.unitPriceFile.id = IDPlaceholder.unitPriceFile++;
                if (preTender) {
                    preTender.tender.NextSiblingID = curTender.ID;
                }
                // 项目清单模板(后台清单模板中提取含有固定类别的数据)
                const billsTemplate = _.cloneDeep(templateMapping[curTender.property.templateLibID]);
                // 重设模板树结构数据
                BILLS_UTIL.resetTreeData(billsTemplate, uuid.v1);
                console.log(billsTemplate);
                const tenderData = transformTender(curTender, IDPlaceholder, billsTemplate);
                tenderData.tender.property.rootProjectID = transformedData.ID;
                engData.tenders.push(tenderData);
            }
        }
        console.log(`transformedData`);
        console.log(transformedData);
        return transformedData;
    }
    // 获取承包人材料类型
    function getAdjustType(tenderData) {
        if (tenderData.differentiaSummary.length) {
            return AdjustType.info;
        } else if (tenderData.exponentialSummary.length) {
            return AdjustType.coe;
        } else {
            return AdjustType.info;
        }
    }
    // 获取当前文件
    // 转换单位工程的数据(直接可插入数据库的数据)，返回{tender: {}, bills: [], ration: [], rationGLJ: [], projectGLJ: [], unitPrice: [], mixRatio: []}
    function transformTender(tenderData, IDPlaceholder, billsTemplate) {
        const detailData = transformDetail(tenderData, IDPlaceholder, billsTemplate);
        // 提取需要插入的单位工程数据
        const transformedTender = {
            ID: tenderData.ID,
            ParentID: tenderData.ParentID,
            NextSiblingID: tenderData.NextSiblingID,
            code: tenderData.code,
            name: tenderData.name,
            projType: tenderData.projType,
            property: tenderData.property,
            projectFeature: tenderData.projectFeature,
            engineering: tenderData.engineering,
            defaultRationLib: tenderData.defaultRationLib,
            rationLibIDs: tenderData.rationLibIDs,
            gljLibIDs: tenderData.gljLibIDs,
            shareInfo: []
        };
        transformedTender.property.gljAdjustType = getAdjustType(tenderData)
        detailData.tender = transformedTender;
        return detailData;
    }
    // 过滤掉相关费用代号的数据(递归地)
    // 返回被过滤掉的数据
    function filterDataByFeeCodes(billsData, feeCodes) {
        const filterd = [];
        billsData.forEach(bills => {
            if (bills.items && bills.items.length) {
                const newItems = [];
                bills.items.forEach(subBills => {
                    if (!feeCodes.includes(subBills.feeCode)) {
                        newItems.push(subBills);
                    } else {
                        filterd.push(subBills);
                    }
                });
                bills.items = newItems;
                // bills.items = bills.items.filter(subBills => !feeCodes.includes(subBills.feeCode));
                const subFilterd = filterDataByFeeCodes(bills.items, feeCodes);
                filterd.push(...subFilterd);
            }
        });
        return filterd;
    }
    // 合并清单，将提取出来的清单相关数据，合并进项目清单(模板)
    function mergeBills(tenderData, billsTemplate) {
        debugger;
        const mergedBills = [...billsTemplate];
        const roots = billsTemplate.filter(bills => bills.ParentID === -1);
        let lastRoot = roots.find(root => root.NextSiblingID === -1);
        mergeWorkSummary(tenderData.workSummary);
        mergeFBFX(tenderData.fbfx);
        mergeCSXM(tenderData.csxm);
        mergeOther(tenderData.other);
        mergeTax(tenderData.tax);
        return mergedBills;

        // 合并清单数据
        function mergeitems(fixedBills, items) {
            const daryWorkMap = {
                '人工': fixedFlag.LABOUR,
                '材料': fixedFlag.MATERIAL,
                '机械': fixedFlag.MACHINE,
                '施工机械': fixedFlag.MACHINE,
                '施工机具': fixedFlag.MACHINE
            };
            const fixedBillsFlag = getFlag(fixedBills);
            let preBills = billsTemplate.find(bills => bills.ParentID === fixedBills.ID && bills.NextSiblingID === -1);
            items.forEach(bills => {
                // 计日工需要特殊处理，兼容广联达的数据，广联达的计日工下的人工、材料、机械的费用字典不对，因此用名称匹配
                let matched;
                if (fixedBillsFlag === fixedFlag.DAYWORK) {
                    const dayWorkSubFlag = daryWorkMap[bills.name];
                    matched = dayWorkSubFlag
                        ? billsTemplate.find(templateBills => getFlag(templateBills) === dayWorkSubFlag)
                        : null;
                } else {
                    matched = billsTemplate.find(templateBills => FlagFeeCodeMap[getFlag(templateBills)] === bills.feeCode);
                }
                if (matched) {
                    assignAttr(matched, bills, ['items'], true);
                    if (bills.items && bills.items.length) {
                        mergeitems(matched, bills.items);
                        //mergedBills.push(...mergeDataRecur(fixedBills, [bills]))    
                    }
                    preBills = matched;
                } else {
                    const nextID = preBills && preBills.NextSiblingID || -1;
                    mergedBills.push(...mergeDataRecur(fixedBills, [bills]));
                    bills.NextSiblingID = nextID;
                    if (preBills) {
                        preBills.NextSiblingID = bills.ID;
                    }
                    preBills = bills;
                }
            });
        }
        // 简单地合并: 设置某清单的金额,数据递归插入到某清单的子项
        function simpleMerge(flag, src) {
            const fixedBills = billsTemplate.find(bills => getFlag(bills) === flag);
            if (fixedBills) {
                assignAttr(fixedBills, src, ['fees', 'feeCode']);
                mergedBills.push(...mergeDataRecur(fixedBills, src.items));
            }
        }
        // 合并大项费用
        function mergeWorkSummary(workSummary) {
            // 首层数据与清单模板根据费用字典进行匹配，匹配到的则赋值一些属性，匹配不到则将其及其所有子数据插入到模板最末大项费用
            workSummary.forEach(summaryBills => {
                const matched = roots.find(root => FlagFeeCodeMap[getFlag(root)] === summaryBills.feeCode);
                if (matched) {
                    if (!summaryBills.calcBase) {
                        summaryBills.calcBase = matched.calcBase;
                        matched.ignoreValidator = true; // 用了模板的基数，基数无视基数验证
                    }
                    assignAttr(matched, summaryBills, ['items'], true);
                } else {
                    mergedBills.push(...mergeDataRecur(null, [summaryBills]));
                    if (lastRoot) {
                        lastRoot.NextSiblingID = summaryBills.ID;
                        lastRoot = summaryBills;
                    }
                }
            });
        }
        // 合并分部分项
        function mergeFBFX(fbfxSrc) {
            simpleMerge(fixedFlag.SUB_ENGINERRING, fbfxSrc);
        }
        // 合并措施项目
        function mergeCSXM(csxmSrc) {
            const fixedBills = billsTemplate.find(bills => getFlag(bills) === fixedFlag.MEASURE);
            fixedBills.fees = csxmSrc.fees;
            mergeitems(fixedBills, csxmSrc.items);
        }
        // 合并其他项目
        function mergeOther(otherSrc) {
            const fixedBills = billsTemplate.find(bills => getFlag(bills) === fixedFlag.OTHER);
            fixedBills.fees = otherSrc.fees;
            // 合并其他项目费

            // SundryCosts其他项目费会包含暂列金额等后续会再次出现的数据，因此合并SundryCosts的数据时，过滤掉一部分数据
            const feeCodeFilter = [
                FlagFeeCodeMap[fixedFlag.PROVISIONAL], // 暂列金额
                FlagFeeCodeMap[fixedFlag.MATERIAL_PROVISIONAL], // 材料暂估
                FlagFeeCodeMap[fixedFlag.ENGINEERING_ESITIMATE], // 专业工程暂估
                FlagFeeCodeMap[fixedFlag.DAYWORK], // 计日工
                FlagFeeCodeMap[fixedFlag.TURN_KEY_CONTRACT], // 总承包服务费
                FlagFeeCodeMap[fixedFlag.CLAIM], // 索赔
                FlagFeeCodeMap[fixedFlag.VISA], // 现场签证
            ];
            const filterdBills = filterDataByFeeCodes([otherSrc.sundryCosts], feeCodeFilter);
            /**
             * 有些源xml文件中，被过滤掉SundryCosts中的子项，相对于Sundry的子项会多一些属性
             * 比如：Sundry->SunryCosts->SundryCostsGroup->SundryCostsItem中的材料暂估价，含有QtyFormula属性，但是Sundry->ProvisionalMaterialEquipment中不含有QtyFormula
             * 因此，即使后续Sundry的子项会赋值给模板，也要将被过滤掉的子项的属性先赋给模板
             */
            filterdBills.forEach(filterdItem => {
                const matched = billsTemplate.find(templateBills => FlagFeeCodeMap[getFlag(templateBills)] === filterdItem.feeCode);
                if (matched) {
                    assignAttr(matched, filterdItem, ['items'], true); // 不拷贝item属性
                    matched.ignoreA
                }
            });

            const sundryCostsBills = otherSrc.sundryCosts.items;
            mergeitems(fixedBills, sundryCostsBills);
            // 合并暂列金额
            simpleMerge(fixedFlag.PROVISIONAL, otherSrc.provisional);
            // 合并材料暂估，由于材料暂估的子元素是暂估人材机，因此对清单来说，只需处理材料暂估根元素的属性
            const zgcFixedBills = billsTemplate.find(bills => getFlag(bills) === fixedFlag.MATERIAL_PROVISIONAL);
            assignAttr(zgcFixedBills, otherSrc.ProvisionalMaterialEquipment);
            // 合并专业工程暂估价
            simpleMerge(fixedFlag.ENGINEERING_ESITIMATE, otherSrc.specialty);
            // 合并计日工
            const dayWorkFixedBills = billsTemplate.find(bills => getFlag(bills) === fixedFlag.DAYWORK);
            assignAttr(dayWorkFixedBills, otherSrc.dayWork, ['fees', 'feeCode']);
            mergeitems(dayWorkFixedBills, otherSrc.dayWork.items);
            // 合并总承包服务费
            simpleMerge(fixedFlag.TURN_KEY_CONTRACT, otherSrc.mainContractor);
            // 合并索赔
            simpleMerge(fixedFlag.CLAIM, otherSrc.claim);
            // 合并现场签证
            simpleMerge(fixedFlag.VISA, otherSrc.visa);
        }
        // 合并税金
        function mergeTax(taxSrc) {
            const taxFixedBills = billsTemplate.find(bills => getFlag(bills) === fixedFlag.TAX);
            if (!taxSrc.calcBase) {
                taxSrc.calcBase = taxFixedBills.calcBase;
                taxFixedBills.ignoreValidator = true; // 用了模板的基数，基数无视基数验证
            } else {
                taxFixedBills.ignoreValidator = false;
            }
            assignAttr(taxFixedBills, taxSrc);
        }
    }
    // 给固定清单设置上费用字典，因为在合并清单的时候，清单模板中可能有一些数据应该有规定的费用字典，但是没有被设置上费用字典。
    function setupFeeCode(billsData) {
        billsData.forEach(bills => {
            if (bills.feeCode) {
                return;
            }
            bills.feeCode = FlagFeeCodeMap[getFlag(bills)] || '';
        })
    }
    // 检查清单是否引用了自身，比如广联达导出文件中 材料保管费基数为CLBGF
    function isCalcBaseCycle(bills) {
        return bills.calcBase.match(new RegExp(`\\b${bills.feeCode}\\b`)); // \b: 匹配前一个字符和后一个字符不全为\w的位置
    }
    // 转换计算基数
    // 1.有子项数据，则清空基数
    // 2.引用的基数造成自身循环，比如分部分项部分引用了QDF
    // 3.费用代号匹配清单基数的代号
    // 4.费用代号匹配不到清单基数的代号，则匹配此费用代号的清单，作为行引用（即ID引用）
    // 5.对应字典里找不到则设置成金额
    function transformCalcBase(billsData) {
        // 费用代号 - 计算基数映射
        const feeCodeFormulaMap = {}
        Object
            .entries(FormulaFeeCodeMap)
            .forEach(([formula, feeCode]) => {
                feeCodeFormulaMap[feeCode] = formula;
            });
        // 费用代号 - ID映射
        const feeCodeIDMap = {};
        billsData.forEach(data => {
            if (data.feeCode) {
                feeCodeIDMap[data.feeCode] = data.ID;
            }
        });
        for (const bills of billsData) {
            if (!bills.calcBase || bills.ignoreValidator) {
                continue;
            }
            const sub = billsData.find(data => data.ParentID === bills.ID);
            // 有子项数据，则清空基数，费率
            if (sub) {
                bills.calcBase = '';
                bills.feeRate = '';
                continue;
            }
            if (typeof bills.calcBase !== 'string') {
                bills.calcBase = String(bills.calcBase);
            }
            // 引用的基数造成自循环，清空基数
            const isCycle = isCalcBaseCycle(bills);
            if (isCycle) {
                bills.calcBase = '';
                continue;
            }
            // 提取基数中的费用代号
            bills.calcBase = bills.calcBase.replace(/\s/g, '');
            const feeCodes = bills.calcBase.split(/[\+\-\*\/]/g);
            // 提取操作符
            const oprs = bills.calcBase.match(/[\+\-\*\/]/g);
            // 转换后的基数
            const newBase = [];
            let illegal = false;    //不合法
            for (const feeCode of feeCodes) {
                const formula = feeCodeFormulaMap[feeCode];
                const refID = feeCodeIDMap[feeCode];
                if (formula) { // 匹配到公式
                    newBase.push(formula);
                } else if (refID) { // 匹配到行引用
                    newBase.push(`@${refID}`) // 转换成ID引用
                } else { // 无法识别
                    illegal = true;
                    break;
                }
            }
            if (illegal) {
                const fee = getFee(bills.fees, ['common', 'totalFee']);
                const feeRate = bills.feeRate && parseFloat(bills.feeRate) !== 0 ? parseFloat(bills.feeRate) : 0;
                if (fee && parseFloat(fee) !== 0 && feeRate) {
                    bills.calcBase = scMathUtil.roundForObj(parseFloat(fee) * 100 / feeRate, 2);
                } else {
                    bills.calcBase = fee !== '0' ? fee : '';
                }
            } else {
                let newCalcBase = '';
                for (let i = 0; i < newBase.length; i++) {
                    newCalcBase += newBase[i];
                    if (oprs && oprs[i]) {
                        newCalcBase += oprs[i];
                    }
                }
                bills.calcBase = newCalcBase;
            }
        }
    }
    // 转换清单
    function transformBills(tenderData, billsTemplate) {
        const billsData = mergeBills(tenderData, billsTemplate);
        setupFeeCode(billsData);
        transformCalcBase(billsData);
        // 处理综合单价
        // 没有子清单，且没有综合单价，且有综合合价，则综合单价 = 综合合价 / 工程量
        billsData.forEach(bills => {
            const hasChild = billsData.some(data => data.ParentID === bills.ID);
            let unitFee = getFee(bills.fees, ['common', 'unitFee']);
            const totalFee = getFee(bills.fees, ['common', 'totalFee']);
            if (!hasChild && !parseFloat(unitFee) && totalFee && parseFloat(totalFee)) {
                // 不存工程量
                if (!bills.quantity || !parseFloat(bills.quantity)) {
                    unitFee = totalFee;
                    // 源不存在工程量，没有计算基数、但是却有综合合价，工程量要设置为1
                    if (!bills.calcBase) {
                        bills.quantity = '1';
                    }
                } else {
                    // 综合合价的小数位数
                    const totalFeeDecimal = totalFee.match(/\.\d+/);
                    unitFee = scMathUtil.roundForObj(totalFee / bills.quantity, totalFeeDecimal ? totalFeeDecimal[0] : 0);
                }
                const commonFee = bills.fees.find(fee => fee.fieldName === 'common');
                if (commonFee) {
                    commonFee.unitFee = unitFee;
                }
            }
            bills.projectID = tenderData.ID;
            bills.quantityEXP = bills.quantity;
            // TODO 删除items rations feeCode
        });
        return billsData;
    }
    // 转换人材机汇总相关数据（人材机汇总、承包人材料、评标材料、暂估价材料、组成物、单价文件）
    function transformGLJList(tenderData, IDPlaceholder, projectGLJMap) {
        const rst = {
            projectGLJ: [], // 项目人材机
            contractorList: [], // 承包人材料
            bidEvaluationList: [], // 评标材料
            evaluationList: [], // 暂估材料
            unitPrice: [], // 单价文件
            mixRatio: [] // 组成物
        };
        transformGLJSummary();
        transformContractorSummary();
        transformRelatedGLJList(tenderData.bidEvaluationSummary, rst.bidEvaluationList, 'is_eval_material');
        transformEvalSummary();
        return rst;

        // 转换项目人材机、组成物
        function transformGLJSummary() {
            // 项目人材机
            tenderData.gljSummary.forEach(projectGLJ => {
                projectGLJ.project_id = tenderData.ID;
                projectGLJ.id = IDPlaceholder.projectGLJ++;
                projectGLJMap[projectGLJ.code] = projectGLJ;
            });
            tenderData.gljSummary.forEach(projectGLJ => {
                //组成物数据
                projectGLJ.ratios.forEach(ratio => {
                    const matched = projectGLJMap[ratio.code];
                    ratio.code = matched.code;
                    ratio.projectGLJID = projectGLJ.id;
                    ratio.id = IDPlaceholder.ratio++;
                    ratio.unit_price_file_id = tenderData.property.unitPriceFile.id;
                    ratio.unit = matched && matched.unit || '';
                    ratio.name = matched && matched.name || '';
                    ratio.specs = matched && matched.specs || '';
                    ratio.type = matched && matched.type || 1;
                    ratio.connect_key = [projectGLJ.code || 'null', projectGLJ.name || 'null', projectGLJ.specs || 'null', projectGLJ.unit || 'null', projectGLJ.type].join('|-|');
                    rst.mixRatio.push(ratio);
                });
                rst.projectGLJ.push(projectGLJ);
                // 单价文件数据：
                rst.unitPrice.push(generateUnitPrice(projectGLJ));
                // TODO 删除ratios
            });
        }
        // 转换与项目人材机关联的材料
        function transformRelatedGLJList(list, container, relatedType) {
            list.forEach(glj => {
                glj.ID = uuid.v1();
                glj.projectID = tenderData.ID;
                glj.projectGLJID = -1;
                if (typeof glj.seq === 'undefined') {
                    glj.seq = glj.code;
                }
                const projectGLJ = projectGLJMap[glj.code];
                if (projectGLJ) {
                    projectGLJ[relatedType] = 1;
                    glj.is_related = 1;
                    glj.projectGLJID = projectGLJ.id;
                }
                container.push(glj);
            });
        }
        // 转换承包人材料
        function transformContractorSummary() {
            // 由于承包人差额数据和指数数据共用承包人材料表，因此需要合并差额数据和指数数据
            const mergedList = [];
            tenderData.exponentialSummary.forEach(eGLJ => {
                const matched = tenderData.differentiaSummary.find(dGLJ => dGLJ.code === eGLJ.code);
                if (matched) {
                    assignAttr(matched, eGLJ, ['varWeight', 'FO', 'FI']);
                } else {
                    mergedList.push(eGLJ);
                }
            });
            mergedList.push(...tenderData.differentiaSummary);
            transformRelatedGLJList(mergedList, rst.contractorList, 'is_contractor_material');
        }
        // 转换暂估价材料
        function transformEvalSummary() {
            const evalGLJList = tenderData.gljSummary
                .filter(glj => glj.is_evaluate)
                .map(glj => {
                    const evalGLJ = {};
                    assignAttr(evalGLJ, glj, [
                        'code', 'name', 'specs', 'unit', 'quantity', 'market_price',
                        'originPlace', 'vender', 'remark'
                    ]);
                    evalGLJ.seq = evalGLJ.code;
                    return evalGLJ;
                });
            transformRelatedGLJList(evalGLJList, rst.evaluationList, 'is_evaluate');
        }
        // 生成单价文件
        function generateUnitPrice(projectGLJ) {
            return {
                projectGLJID: projectGLJ.id,    //做个标记，后端查找标准数据后，方便更新组成物数据
                unit_price_file_id: tenderData.property.unitPriceFile.id,
                id: IDPlaceholder.unitPrice++,
                code: projectGLJ.code,
                original_code: projectGLJ.original_code,
                name: projectGLJ.name,
                unit: projectGLJ.unit,
                specs: projectGLJ.specs,
                type: projectGLJ.type,
                short_name: projectGLJ.shortName,
                base_price: projectGLJ.base_price,
                market_price: projectGLJ.market_price
            };
        }
    }
    // 转换定额、定额人材机、定额系数
    // @param {Object} tenderData - 提取的单位工程数据
    // @param {Array} billsData - 转换后的清单数据
    // @param {Object} projectGLJMap - 转换项目人材机时生成的项目人材机编码-数据的映射
    function transformRations(tenderData, billsData, projectGLJMap) {
        const rst = {
            ration: [],
            rationGLJ: [],
            rationCoe: []
        };
        billsData
            .filter(bills => bills.rations && bills.rations.length)
            .forEach(bills => {
                bills.rations.forEach(ration => {
                    // TODO 取费专业不知如何取，暂时取单位工程取费专业
                    ration.programID = tenderData.property.projectEngineering;
                    ration.ID = uuid.v1();
                    ration.projectID = tenderData.ID;
                    ration.billsItemID = bills.ID;
                    ration.contain = getContain(bills, ration);
                    rst.ration.push(ration);
                    // 定额人材机
                    rst.rationGLJ.push(...transformRationGLJs(bills, ration));
                    // 定额系数
                    rst.rationCoe.push(generateRationCoe(ration));
                    // TODO 删除rationGljs
                });
            });
        return rst;

        // 含量：定额工程量/清单工程量
        function getContain(bills, ration) {
            if (!bills.quantity || !ration.quantity) {
                return '0';
            } else {
                const tempQuantity = ration.quantity / bills.quantity;
                return isFinite(tempQuantity) ? scMathUtil.roundForObj(tempQuantity, Decimal.QUANTITY) : '0';
            }
        }
        // 转换定额人材机
        function transformRationGLJs(bills, ration) {
            return ration.rationGLJs.map(rationGLJ => {
                const matched = projectGLJMap[rationGLJ.code];
                if (matched) {
                    rationGLJ.projectGLJID = matched.id;
                    rationGLJ.code = matched.code;
                    rationGLJ.type = matched.type;
                    rationGLJ.shortName = matched.shortName;
                    rationGLJ.name = matched.name;
                    rationGLJ.original_code = matched.original_code;
                    rationGLJ.unit = matched.unit;
                    rationGLJ.specs = matched.specs;
                }
                rationGLJ.ID = uuid.v1();
                rationGLJ.projectID = tenderData.ID;
                rationGLJ.billsItemID = bills.ID;
                rationGLJ.rationID = ration.ID;
                rationGLJ.rationCode = ration.code;  // 暂时跟定额编码关联，后端好匹配标准数据
                rationGLJ.rationItemQuantity = rationGLJ.quantity;  // 定额消耗，暂时取消耗量，需要后端匹配标准数据后更新
                return rationGLJ;
            });
        }
        // 生成定额系数（项目数据处理的方法很有可能无法共用，因此不把重庆的方法抽离了）
        function generateRationCoe(ration) {
            return {
                projectID: ration.projectID,
                rationID: ration.ID,
                coeID: -1,
                ID: uuid.v1(),
                seq: 1, // 以前排序有的字段，暂时没什么用，不过还是赋上一个值
                name: '自定义系数',
                content: '人工×1，材料×1，机械×1，主材×1，设备×1',
                coes: [
                    { amount: 1, operator: '*', gljCode: null, coeType: '定额' },
                    { amount: 1, operator: '*', gljCode: null, coeType: '人工' },
                    { amount: 1, operator: '*', gljCode: null, coeType: '材料' },
                    { amount: 1, operator: '*', gljCode: null, coeType: '机械' },
                    { amount: 1, operator: '*', gljCode: null, coeType: '主材' },
                    { amount: 1, operator: '*', gljCode: null, coeType: '设备' },
                ],
                option_list: []
            }
        }
    }
    // 删除一些无用属性，减少通信数据量
    function clean(detailData) {
        const {
            bills,
            ration,
            projectGLJ
        } = detailData;
        bills.forEach(item => delete item.items && delete item.rations && delete item.feeCode);
        ration.forEach(item => delete item.rationGLJs);
        projectGLJ.forEach(item => delete item.ratios);
    }
    // 需要给清单、定额价格字段赋上调价数据，不然打开项目后会被重算: project_view.js -> loadProjectData方法内
    function setupTenderFees(detailData) {
        const { bills, ration } = detailData;
        [...bills, ...ration].forEach(item => {
            if (item.fees && item.fees.length) {
                item.fees.forEach(feeItem => {
                    if (commonUtil.isDef(feeItem.unitFee)) {
                        feeItem.tenderUnitFee = feeItem.unitFee;
                    }
                    if (commonUtil.isDef(feeItem.totalFee)) {
                        feeItem.tenderTotalFee = feeItem.totalFee;
                    }
                })
            }
        });
    }
    // 转换详细的项目数据，清单、定额、定额人材机、项目人材机、单价文件等
    function transformDetail(tenderData, IDPlaceholder, billsTemplate) {
        const bills = transformBills(tenderData, billsTemplate);
        // 转换定额的处理依赖转换后的项目人材机数据，因此需要先转换项目人材机相关的数据
        const projectGLJMap = {};
        const relatedljGLJData = transformGLJList(tenderData, IDPlaceholder, projectGLJMap);
        const relatedRationData = transformRations(tenderData, bills, projectGLJMap);
        const detailData = {
            bills,
            ...relatedRationData,
            ...relatedljGLJData
        };
        clean(detailData);
        setupTenderFees(detailData);
        console.log(`detailData`);
        console.log(detailData);
        return detailData;
    }

    /**
     * 解压cos、zip文件
     * @param {File} file - 上传的文件 
     * @return {Object} 解压出来的xml文件名称与xml文件文本内容映射 
     */
    async function unzipFile(file) {
        const jsZip = new JSZip();
        const zip = await jsZip.loadAsync(file);
        const map = {};
        for (const fileName in zip.files) {
            // 将二进制数据转换成字符串
            map[fileName] = await jsZip.file(fileName).async('string');
        }
        return map;
    }

    //从xml文件中提取数据
    async function extractData(file, escape = false) {
        const fileMap = await unzipFile(file);
        const projectXML = fileMap['Project.xml'];
        if (!projectXML) {
            throw '无有效数据';
        }
        const xmlObjMap = {};
        for (const fileName in fileMap) {
            // x2js转换xml使用了DomParser接口，会将一些字符实体进行转义。若不想被自动转义，则需要调用escapeXMLEntity
            const xmlStr = escape ? util.escapeXMLEntity(fileMap[fileName]) : fileMap[fileName];
            //将xml格式良好的字符串转换成对象
            const x2js = new X2JS();
            let xmlObj = x2js.xml_str2json(xmlStr);
            xmlObj = JSON.parse(util.restoreXMLEntity(JSON.stringify(xmlObj)));
            if (!xmlObj) {
                throw '无有效数据。';
            }
            xmlObjMap[fileName] = xmlObj;
        }
        //提取数据
        return extractProject(xmlObjMap);
    };

    // 接受上传的文件类型(不同的省份可以上传的文件不同)
    const accept = ['.zip', '.cos'];

    return {
        accept,
        extractData,
        transformData,
    }
})();