Calculation/builder_report_index_define.js

'use strict';

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

const fs = require('fs');
const path = require('path');
const savePath = path.join(__dirname, 'report_temp', 'table_field_define');
const dataType = {
    int: 'int',
    str: 'string',
    double: 'double',
    currency: 'currency',
    time: 'string',
};
const tag = {
    tp: {type: 'tp'},
    up: {type: 'up'},
};
// 其他台账
const stage_jgcl = {
    name: '期-甲供材料(mem_stage_jgcl)',
    remark: '',
    id: 30,
    key: 'stage_jgcl',
    prefix: '期-甲供材料',
    cols: [
        {name: 'id', field: 'id', type: dataType.int},
        {name: 'uuid', field: 'uuid', type: dataType.str},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '单位', field: 'unit', type: dataType.str},
        {name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'}},
        {name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 4}},
        {name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 4}},
        {name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '材料来源', field: 'source', type: dataType.str},
        {name: '单据号', field: 'bills_code', type: dataType.str},
        {name: '检验单编号', field: 'check_code', type: dataType.str},
        {name: '新增人id', field: 'add_uid', type: dataType.int},
        {name: '新增期id', field: 'add_sid', type: dataType.int},
        {name: '所属期id', field: 'sid', type: dataType.int},
        {name: '期历史记录', field: 'shistory', type: dataType.str},
        {name: '排序', field: 'order', type: dataType.int},
        {name: '往期是否已用', field: 'pre_used', type: dataType.int},
        {name: '截止上期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 4}},
        {name: '截止上期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '截止上期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 4}},
        {name: '截止上期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
    ]
};
const stage_bonus = {
    name: '期-奖罚金(mem_stage_bonus)',
    remark: '',
    id: 31,
    key: 'stage_bonus',
    prefix: '期-奖罚金',
    cols: [
        {name: 'id', field: 'id', type: dataType.str},
        {name: '所属标段id', field: 'tid', type: dataType.int},
        {name: '所属期id', field: 'sid', type: dataType.int},
        {name: '所属第几期', field: 'sorder', type: dataType.int},
        {name: '新增人id', field: 'uid', type: dataType.int},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '证明材料', field: 'proof', type: dataType.str},
        {name: '创建时间', field: 'create_time', type: dataType.time},
        {name: '时间', field: 'real_time', type: dataType.time},
        {name: '备注', field: 'memo', type: dataType.str},
        {name: '期历史记录', field: 'shistory', type: dataType.str},
        {name: '排序', field: 'order', type: dataType.int},
    ]
};
const stage_other = {
    name: '期-其他(mem_stage_other)',
    remark: '',
    id: 32,
    key: 'stage_other',
    prefix: '期-其他',
    cols: [
        {name: 'id', field: 'id', type: dataType.int},
        {name: 'uuid', field: 'uuid', type: dataType.str},
        {name: '所属标段id', field: 'tid', type: dataType.int},
        {name: '所属期id', field: 'sid', type: dataType.int},
        {name: '所属第几期', field: 'sorder', type: dataType.int},
        {name: '新增人id', field: 'add_uid', type: dataType.int},
        {name: '新增期id', field: 'add_sid', type: dataType.int},
        {name: '创建时间', field: 'add_time', type: dataType.time},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'}},
        {name: '本期金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '时间', field: 'real_time', type: dataType.time},
        {name: '备注', field: 'memo', type: dataType.str},
        {name: '期历史记录', field: 'shistory', type: dataType.str},
        {name: '排序', field: 'order', type: dataType.int},
        {name: '往期是否已用', field: 'pre_used', type: dataType.int},
        {name: '截止上期-金额', field: 'pre_tp', type: dataType.currency, tag: {type: 'tp'}},
    ]
};
// 变更令
const change = {
    name: '变更令(mem_change)',
    remark: '',
    id: 33,
    key: 'mem_change',
    prefix: '变更令',
    cols: [
        {name: '变更令id', field: 'cid', type: dataType.str},
        {name: '变更令号', field: 'code', type: dataType.str},
        {name: '批复文号', field: 'w_code', type: dataType.str},
        {name: '批复编号', field: 'p_code', type: dataType.str},
        {name: '变更名称', field: 'name', type: dataType.str},
        {name: '桩号', field: 'peg', type: dataType.str},
        {name: '原设计图名称', field: 'org_name', type: dataType.str},
        {name: '原图号', field: 'org_code', type: dataType.str},
        {name: '变更设计图名称', field: 'new_name', type: dataType.str},
        {name: '变更图号', field: 'new_code', type: dataType.str},
        {name: '工程变更理由及内容', field: 'content', type: dataType.str},
        {name: '工程变更合同依据', field: 'basis', type: dataType.str},
        {name: '变更工程量数量计算式', field: 'expr', type: dataType.str},
        {name: '备注', field: 'memo', type: dataType.str},
        {name: '变更类型', field: 'type', type: dataType.str},
        {name: '变更类别', field: 'class', type: dataType.int},
        {name: '变更性质', field: 'quality', type: dataType.int},
        {name: '变更提出单位', field: 'company', type: dataType.str},
        {name: '费用承担方', field: 'charge', type: dataType.int},
        {name: '金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'}},
        {name: '变更状态发生时间（时间戳）', field: 'cin_time', type: dataType.str},
        {name: '完成审批时间（时间戳）', field: 'sin—_ime', type: dataType.str},
        {name: '金额_1', field: 'tp_1', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_2', field: 'tp_2', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_3', field: 'tp_3', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_4', field: 'tp_4', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_5', field: 'tp_5', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_6', field: 'tp_6', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_7', field: 'tp_7', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_8', field: 'tp_8', type: dataType.currency, tag: {type: 'tp'}},
        {name: '金额_9', field: 'tp_9', type: dataType.currency, tag: {type: 'tp'}},
        {name: '附件名称列表', field: 'attNames', type: dataType.currency},
    ]
};
const change_bills = {
    name: '变更清单(mem_change_bills)',
    remark: '',
    id: 29,
    key: 'mem_change_bills',
    prefix: '变更清单',
    cols: [
        {name: '变更令id', field: 'cid', type: dataType.str},
        {name: '签约清单id或台账id', field: 'lid', type: dataType.str},
        {name: '清单编号', field: 'code', type: dataType.str},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '单位', field: 'unit', type: dataType.str},
        {name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'}},
        {name: '原-数量', field: 'o_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '原-金额', field: 'o_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '变更-数量', field: 'c_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '变更-金额', field: 'c_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '审批变更后-数量', field: 's_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '审批变更后-金额', field: 's_tp', type: dataType.currency, tag: {type: 'tp'}},
        {name: '部位明细', field: 'bwmx', type: dataType.str},
        {name: '变更详情', field: 'detail', type: dataType.str},
        {name: '数量_1', field: 'qty_1', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_1', field: 'tp_1', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_2', field: 'qty_2', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_2', field: 'tp_2', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_3', field: 'qty_3', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_3', field: 'tp_3', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_4', field: 'qty_4', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_4', field: 'tp_4', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_5', field: 'qty_5', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_5', field: 'tp_5', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_6', field: 'qty_6', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_6', field: 'tp_6', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_7', field: 'qty_7', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_7', field: 'tp_7', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_8', field: 'qty_8', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_8', field: 'tp_8', type: dataType.currency, tag: {type: 'tp'}},
        {name: '数量_9', field: 'qty_9', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
        {name: '金额_9', field: 'tp_9', type: dataType.currency, tag: {type: 'tp'}},

    ]
};
// 期 - 计量单元
const stage_pos = {
    name: '期-计量单元(mem_stage_pos)',
    remark: '',
    id: 34,
    key: 'mem_stage_pos',
    prefix: '期-计量单元',
    cols: [
        {name: 'id', field: 'id', type: dataType.str},
        {name: '所属标段id', field: 'tid', type: dataType.int},
        {name: '所属清单id', field: 'lid', type: dataType.str},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '位置', field: 'position', type: dataType.str},
        {name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency},
        {name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency},
        {name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency},
        {name: '台账-数量', field: 'quantity', type: dataType.currency},
        {name: '图号', field: 'drawing_code', type: dataType.str},
        {name: '排序', field: 'p_order', type: dataType.str},
        {name: '本期-合同计量-数量', field: 'contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency},
        {name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str},
        {name: '本期-完成计量-数量', field: 'gather_qty', type: dataType.currency},
        {name: '本期批注', field: 'postil', type: dataType.str},
        {name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency},
        {name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency},
        {name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency},
        {name: '截止本期-合同计量-数量', field: 'end_contract_qty', type: dataType.currency},
        {name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency},
        {name: '截止本期-完成计量-数量', field: 'end_gather_qty', type: dataType.currency},
        {name: '截止本期-完成率', field: 'final_ratio', type: dataType.currency},
    ],
};
const stage_pos_compare = {
    name: '期-计量单元-全参与人(mem_stage_pos_compare)',
    remark: '',
    id: 35,
    key: 'mem_stage_pos_compare',
    prefix: '期-计量单元-全参与人',
    cols: [
        {name: 'id', field: 'id', type: dataType.str},
        {name: '所属标段id', field: 'tid', type: dataType.int},
        {name: '所属清单id', field: 'lid', type: dataType.str},
        {name: '名称', field: 'name', type: dataType.str},
        {name: '位置', field: 'position', type: dataType.str},
        {name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency},
        {name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency},
        {name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency},
        {name: '台账-数量', field: 'quantity', type: dataType.currency},
        {name: '图号', field: 'drawing_code', type: dataType.str},
        {name: '排序', field: 'p_order', type: dataType.str},
        {name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency},
        {name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency},
        {name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_0', field: 'r0_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_0', field: 'r0_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_1', field: 'r1_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_1', field: 'r1_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_2', field: 'r2_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_2', field: 'r2_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_3', field: 'r3_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_3', field: 'r3_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_4', field: 'r4_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_4', field: 'r4_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_5', field: 'r5_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_5', field: 'r5_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_6', field: 'r6_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_6', field: 'r6_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_7', field: 'r7_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_7', field: 'r7_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_8', field: 'r8_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_8', field: 'r8_gather_qty', type: dataType.currency},
        {name: '本期-合同计量-数量_9', field: 'r9_contract_qty', type: dataType.currency},
        {name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency},
        {name: '本期-完成计量-数量_9', field: 'r9_gather_qty', type: dataType.currency},
    ],
};

// 期 - 合同支付
const stage_pay = {
    Name: '期-合同支付-数据(mem_stage_pay)',
    remark: '',
    id: 27,
    key: 'mem_stage_pay',
    prefix: '期-合同支付',
    cols: [
        {name: '名称', field: 'name', type: dataType.str},
        {name: '计算公式', field: 'expr', type: dataType.str},
        {name: '金额', field: 'tp', type: dataType.currency},
        {name: '截止上期-金额', field: 'pre_tp', type: dataType.currency},
        {name: '截止上期-金额', field: 'end_tp', type: dataType.currency},
        {name: '排序', field: 'order', type: dataType.int},
        {name: '是否扣款项', field: 'minus', type: dataType.int},
        {name: '支付类型', field: 'ptype', type: dataType.int},
        {name: '起扣金额', field: 'sprice', type: dataType.currency},
        {name: '扣款限额', field: 'rprice', type: dataType.currency},
        {name: '流程-本期-金额_0', field: 'r0_tp', type: dataType.currency},
        {name: '流程-本期-金额_1', field: 'r1_tp', type: dataType.currency},
        {name: '流程-本期-金额_2', field: 'r2_tp', type: dataType.currency},
        {name: '流程-本期-金额_3', field: 'r3_tp', type: dataType.currency},
        {name: '流程-本期-金额_4', field: 'r4_tp', type: dataType.currency},
        {name: '流程-本期-金额_5', field: 'r5_tp', type: dataType.currency},
        {name: '流程-本期-金额_6', field: 'r6_tp', type: dataType.currency},
        {name: '流程-本期-金额_7', field: 'r7_tp', type: dataType.currency},
        {name: '流程-本期-金额_8', field: 'r8_tp', type: dataType.currency},
        {name: '流程-本期-金额_9', field: 'r9_tp', type: dataType.currency},
        {name: '第几期开始计量', field: 'start_stage_order', type: dataType.int},
    ],
};

const recursiveMkdirSync = async function (pathName) {
    if (!fs.existsSync(pathName)) {
        const upperPath = path.dirname(pathName);
        if (!fs.existsSync(upperPath)) {
            await this.recursiveMkdirSync(upperPath);
        }
        await fs.mkdirSync(pathName);
    }
};
const saveBufferFile = async function (buffer, fileName) {
    // 检查文件夹是否存在，不存在则直接创建文件夹
    const pathName = path.dirname(fileName);
    if (!fs.existsSync(pathName)) {
        await recursiveMkdirSync(pathName);
    }
    await fs.writeFileSync(fileName, buffer);
};
const addFields = function(table, name, field, type, tag) {
    const data = {};
    data.ID = table.ID * 100 + table.items.length + 1;
    data.Name = name + '(' + field + ')';
    if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
    data.DataType = type;
    data.TableName = table.key;
    data.descr = '';
    data.mapExpression = "$PROJECT.REPORT.getProperty('" + table.key + "', '" + field + "')";
    if (tag) {
        switch (tag.type) {
            case 'up':
                data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
                break;
            case 'tp':
                if (tag.subType) {
                    data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + "_" + tag.subType + "_tp')" };
                } else {
                    data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" };
                }
                break;
            case 'qty':
                data.Precision = { type: "flexible", flexibleRefFieldID: table.ID * 100 + tag.unitKey, flexibleMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'precision')" };
                break;
        }
    }
    table.items.push(data);
};
const saveTableDefine = async function (tableDefine, file) {
    delete tableDefine.ID;
    delete tableDefine.key;
    delete tableDefine.prefix;
    let defineStr = JSON.stringify(tableDefine, "", "\t");
    const replaceStr = [
        {match: '"Name":', str: 'Name:'},
        {match: '"remark":', str: 'remark:'},
        {match: '"items":', str: 'items:'},
        {match: '"ID":', str: 'ID:'},
        {match: '"DataType":', str: 'DataType:'},
        {match: '"TableName":', str: 'TableName:'},
        {match: '"descr":', str: 'descr:'},
        {match: '"mapExpression":', str: 'mapExpression:'},
        {match: '"Precision":', str: 'Precision:'},
        {match: '"type":', str: 'type:'},
        {match: '"flexibleRefFieldID":', str: 'flexibleRefFieldID:'},
        {match: '"fixedMapExpression":', str: 'fixedMapExpression:'},
        {match: '"flexibleMapExpression":', str: 'flexibleMapExpression:'},
    ];
    for (const rs of replaceStr) {
        const reg = new RegExp(rs.match, 'gm');
        defineStr = defineStr.replace(reg, rs.str);
    }
    await saveBufferFile(defineStr, file);
};

const exportTableDefine = async function (define) {
    const tableDefine = {};
    tableDefine.Name = define.name;// '期-清单-全参与人数据表(mem_stage_bills_compare)';
    tableDefine.remark = define.remark;
    tableDefine.ID = define.id;
    tableDefine.key = define.key;
    tableDefine.items = [];
    tableDefine.prefix = define.prefix;
    for (const col of define.cols) {
        addFields(tableDefine, col.name, col.field, col.type, col.tag);
    }
    await saveTableDefine(tableDefine, path.join(savePath, define.key + '_define.json'));
};

const defines = [stage_jgcl, stage_bonus, stage_other, change, change_bills, stage_pos, stage_pos_compare, stage_pay];
for (const d of defines) {
    exportTableDefine(d);
}