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',
    arr: 'array',
};
const tag = {
    tp: { type: 'tp' },
    up: { type: 'up' },
};

// 预付款
const advance_pay = {
    name: '预付款记录(advance_pay)',
    remark: '',
    id: 44,
    key: 'advance_pay',
    prefix: '预付款',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '创建者id', field: 'uid', type: dataType.int },
        { name: '审批次数', field: 'times', type: dataType.int },
        { name: '审批状态', field: 'status', type: dataType.int },
        { name: '期数索引', field: 'order', type: dataType.int },
        { name: '类型', field: 'type', type: dataType.int },
        { name: '支付比例', field: 'pay_ratio', type: dataType.currency },
        { name: '本期金额', field: 'cur_amount', type: dataType.currency },
        { name: '截止上期金额', field: 'prev_amount', type: dataType.currency },
        { name: '截止本期金额', field: 'prev_total_amount', type: dataType.currency },
        { name: '创建时间', field: 'create_time', type: dataType.str },
        { name: '备注', field: 'remark', type: dataType.str },
        { name: '结束时间', field: 'end_time', type: dataType.str },
    ],
};
const ledger_cooperation = {
    name: '台账-协作(ledger_cooperation)',
    remark: '',
    id: 45,
    key: 'ledger_cooperation',
    prefix: '台账-协作',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '审批人id', field: 'user_id', type: dataType.int },
        { name: '台账id', field: 'ledger_id', type: dataType.int },
        { name: '密码', field: 'pwd', type: dataType.str },
        { name: '签字地址', field: 'sign_path', type: dataType.str },
    ],
};
// 其他台账
const stage_jgcl = {
    name: '期-甲供材料(mem_stage_jgcl)',
    remark: '',
    id: 30,
    key: 'mem_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 },
        { name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency },
        { name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency },
        { name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency },
        { name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency },
        { 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: 'pre_arrive_qty', type: dataType.currency },
        { name: '截止上期到场-金额', field: 'pre_arrive_tp', type: dataType.currency },
        { name: '截止上期扣回-数量', field: 'pre_deduct_qty', type: dataType.currency },
        { name: '截止上期扣回-金额', field: 'pre_deduct_tp', type: dataType.currency },
        { name: '备注', field: 'memo', type: dataType.str },
        { name: '截止本期到场-数量', field: 'end_arrive_qty', type: dataType.currency },
        { name: '截止本期到场-金额', field: 'end_arrive_tp', type: dataType.currency },
        { name: '截止本期扣回-数量', field: 'end_deduct_qty', type: dataType.currency },
        { name: '截止本期扣回-金额', field: 'end_deduct_tp', type: dataType.currency },
    ],
};
const stage_bonus = {
    name: '期-奖罚金(mem_stage_bonus)',
    remark: '',
    id: 31,
    key: 'mem_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 },
        { name: '编号', field: 'code', type: dataType.str },
        { name: '发文单位', field: 'doc_co', type: dataType.str },
        { name: '类型', field: 'b_type', type: dataType.str },
    ],
};
const stage_other = {
    name: '期-其他(mem_stage_other)',
    remark: '',
    id: 32,
    key: 'mem_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 },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { 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 },
        { name: '类型', field: 'o_type', type: dataType.str },
        { name: '截止本期-金额', field: 'end_tp', type: dataType.currency},
    ],
};
const stage_safe_prod = {
    name: '期-安全生产(mem_stage_safe_prod)',
    remark: '',
    id: 69,
    key: 'mem_stage_safe_prod',
    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: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },
        { name: '数量', field: 'quantity', type: dataType.currency },
        { name: '金额', field: 'total_price', type: dataType.currency },
        { name: '本期数量', field: 'qty', type: dataType.currency },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { 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_qty', type: dataType.currency },
        { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
        { name: '截止本期-数量', field: 'end_qty', type: dataType.currency },
        { name: '截止本期-金额', field: 'end_tp', type: dataType.currency },
    ],
};
const stage_temp_land = {
    name: '期-临时占地(mem_stage_temp_land)',
    remark: '',
    id: 70,
    key: 'mem_stage_temp_land',
    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: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency},
        { name: '本期数量', field: 'qty', type: dataType.currency },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { 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_qty', type: dataType.currency },
        { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
        { name: '截止本期-数量', field: 'end_qty', type: dataType.currency },
        { name: '截止本期-金额', field: 'end_tp', type: dataType.currency },
    ],
};
// 变更令
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' } },
        { name: '项目节编号', field: 'xmj_code', type: dataType.str },
        { name: '细目', field: 'xmj_jldy', type: dataType.str },
        { name: '单位工程', field: 'xmj_dwgc', type: dataType.str },
        { name: '分部工程', field: 'xmj_fbgc', type: dataType.str },
        { name: '分项工程', field: 'xmj_fxgc', type: dataType.str },
        { name: '(空) 截止本期-已变更', field: 'used_qty', type: dataType.currency },
        { name: '(空) 变更令-本期使用', field: 'is_used_bgl', type: dataType.int },
        { name: '(空) 变更清单-本期使用', field: 'is_used', type: dataType.int },
    ],
};
const change_audit = {
    name: '变更审批 列表(mem_change_audit)',
    remark: '',
    id: 73,
    key: 'mem_change_audit',
    prefix: '变更审批',
    cols: [
        { name: '变更令id', field: 'cid', type: dataType.str },
        { name: '审批人id', field: 'uid', type: dataType.int },
        { name: '姓名', field: 'name', type: dataType.str },
        { name: '职称', field: 'jobs', type: dataType.str },
        { name: '公司', field: 'company', type: dataType.str },
        { name: '审批意见', field: 'sdesc', type: dataType.str },
        { name: '审批时间', field: 'sin_time', type: dataType.str },
        { name: '审批顺序', field: 'usort', type: dataType.str },
    ],
};
// 期 - 清单
const stage_bills = {
    name: '期-清单 数据表(mem_stage_bills)',
    remark: '',
    id: 25,
    key: 'mem_stage_bills',
    prefix: '期-清单',
    cols: [
        { name: '台账ID', field: 'id', type: dataType.int },
        { name: '标段ID', field: 'tender_id', type: dataType.int },
        { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
        { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
        { name: '树结构-层级', field: 'level', type: dataType.int },
        { name: '树结构-同层排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8

        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str }, // 12
        { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },

        { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },

        { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
        { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },

        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '备注', field: 'memo', type: dataType.str },
        { name: '节点类型', field: 'node_type', type: dataType.int },
        { name: '总额计量', field: 'is_tp', type: dataType.int },

        { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期批注', field: 'postil', type: dataType.str },

        { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '(台账 + 截止本期变更)-金额', field: 'final_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止本期完成率(%)', field: 'final_ratio', type: dataType.double },

        { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },

        { name: '章节编号', field: 'chapter', type: dataType.str },

        { name: '预留扩展字段_1', field: 'ex_value1', type: dataType.currency },
        { name: '预留扩展字段_2', field: 'ex_value2', type: dataType.currency },

        { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },

        { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
        { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
        { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
        { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },

        { name: '合同-设计数量1', field: 'deal_dgn_qty1', type: dataType.currency },
        { name: '合同-设计数量2', field: 'deal_dgn_qty2', type: dataType.currency },
        { name: '变更-设计数量1', field: 'c_dgn_qty1', type: dataType.currency },
        { name: '变更-设计数量2', field: 'c_dgn_qty2', type: dataType.currency },

        { name: '工序报验-状态', field: 'gxby_status', type: dataType.int },
        { name: '工序报验-是否限制计量', field: 'gxby_limit', type: dataType.int },
        { name: '工序报验-限制比例', field: 'gxby_ratio', type: dataType.currency },
        { name: '档案管理-状态', field: 'dagl_status', type: dataType.int },
        { name: '档案管理-是否限制计量', field: 'dagl_limit', type: dataType.int },
        { name: '档案管理-限制比例', field: 'dagl_ratio', type: dataType.currency },

        { name: '备注1', field: 'ex_memo1', type: dataType.str },
        { name: '备注2', field: 'ex_memo2', type: dataType.str },
        { name: '备注3', field: 'ex_memo3', type: dataType.str },
    ],
};
const stage_bills_compare = {
    name: '期-清单-全参与人 数据表(mem_stage_bills_compare)',
    remark: '',
    id: 26,
    key: 'mem_stage_bills_compare',
    prefix: '期-清单-全参与人',
    cols: [
        { name: '台账ID', field: 'id', type: dataType.int },
        { name: '标段ID', field: 'tender_id', type: dataType.int },
        { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
        { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
        { name: '树结构-层级', field: 'level', type: dataType.int },
        { name: '树结构-同层排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8

        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str }, // 12
        { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },

        { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },

        { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
        { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },

        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '备注', field: 'memo', type: dataType.str },
        { name: '节点类型', field: 'node_type', type: dataType.int },
        { name: '总额计量', field: 'is_tp', type: dataType.int },

        { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_0', field: 'r0_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_0', field: 'r0_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_0', field: 'r0_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_0', field: 'r0_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_1', field: 'r1_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_1', field: 'r1_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_1', field: 'r1_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_1', field: 'r1_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_2', field: 'r2_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_2', field: 'r2_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_2', field: 'r2_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_2', field: 'r2_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_3', field: 'r3_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_3', field: 'r3_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_3', field: 'r3_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_3', field: 'r3_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_4', field: 'r4_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_4', field: 'r4_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_4', field: 'r4_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_4', field: 'r4_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_5', field: 'r5_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_5', field: 'r5_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_5', field: 'r5_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_5', field: 'r5_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_5', field: 'r5_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_6', field: 'r6_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_6', field: 'r6_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_6', field: 'r6_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_6', field: 'r6_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_6', field: 'r6_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_7', field: 'r7_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_7', field: 'r7_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_7', field: 'r7_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_7', field: 'r7_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_7', field: 'r7_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_8', field: 'r8_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_8', field: 'r8_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_8', field: 'r8_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_8', field: 'r8_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_8', field: 'r8_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '本期-合同-数量_9', field: 'r9_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额_9', field: 'r9_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额_9', field: 'r9_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量_9', field: 'r9_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额_9', field: 'r9_gather_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '章节编号', field: 'chapter', type: dataType.str },
        { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },
    ],
};
// 期 - 计量单元
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 },

        { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
        { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
        { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
        { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },

        { name: '工序报验-状态', field: 'gxby_status', type: dataType.int },
        { name: '工序报验-是否限制计量', field: 'gxby_limit', type: dataType.int },
        { name: '工序报验-限制比例', field: 'gxby_ratio', type: dataType.currency },
        { name: '档案管理-状态', field: 'dagl_status', type: dataType.int },
        { name: '档案管理-是否限制计量', field: 'dagl_limit', type: dataType.int },
        { name: '档案管理-限制比例', field: 'dagl_ratio', type: dataType.currency },

        { name: '备注1', field: 'ex_memo1', type: dataType.str },
        { name: '备注2', field: 'ex_memo2', type: dataType.str },
        { name: '备注3', field: 'ex_memo3', type: dataType.str },

        { name: '现场实际数量', field: 'real_qty', 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 month_progress = {
    name: '工程进度 数据表(mem_month_progress)',
    remark: '',
    id: 22,
    key: 'mem_month_progress',
    prefix: '工程进度',
    cols: [
        { name: '计量年月', field: 'month', type: dataType.str },
        { name: '本月计量', field: 'tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本月完成度', field: 'ratio', type: dataType.double },
        { name: '累计计量', field: 'end_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '累计完成度', field: 'end_ratio', type: dataType.double },
    ],
};
// 预留扩展数据
const union_data = {
    name: '预留扩展-合并 数据表(mem_union_data)',
    remark: '',
    id: 28,
    key: 'mem_union_data',
    prefix: '预留扩展-合并',
    cols: [
        { name: '字符串1', field: 'str1', type: dataType.str },
        { name: '字符串2', field: 'str2', type: dataType.str },
        { name: '字符串3', field: 'str3', type: dataType.str },
        { name: '字符串4', field: 'str4', type: dataType.str },
        { name: '字符串5', field: 'str5', type: dataType.str },
        { name: '字符串6', field: 'str6', type: dataType.str },
        { name: '字符串7', field: 'str7', type: dataType.str },
        { name: '字符串8', field: 'str8', type: dataType.str },
        { name: '字符串9', field: 'str9', type: dataType.str },
        { name: '字符串10', field: 'str10', type: dataType.str },

        { name: '整数1', field: 'int1', type: dataType.int },
        { name: '整数2', field: 'int2', type: dataType.int },
        { name: '整数3', field: 'int3', type: dataType.int },
        { name: '整数4', field: 'int4', type: dataType.int },
        { name: '整数5', field: 'int5', type: dataType.int },
        { name: '整数6', field: 'int6', type: dataType.int },

        { name: '数量1', field: 'qty1', type: dataType.currency },
        { name: '数量2', field: 'qty2', type: dataType.currency },
        { name: '数量3', field: 'qty3', type: dataType.currency },
        { name: '数量4', field: 'qty4', type: dataType.currency },
        { name: '数量5', field: 'qty5', type: dataType.currency },
        { name: '数量6', field: 'qty6', type: dataType.currency },
        { name: '数量7', field: 'qty7', type: dataType.currency },
        { name: '数量8', field: 'qty8', type: dataType.currency },
        { name: '数量9', field: 'qty9', type: dataType.currency },
        { name: '数量10', field: 'qty10', type: dataType.currency },

        { name: '金额1', field: 'tp1', type: dataType.currency },
        { name: '金额2', field: 'tp2', type: dataType.currency },
        { name: '金额3', field: 'tp3', type: dataType.currency },
        { name: '金额4', field: 'tp4', type: dataType.currency },
        { name: '金额5', field: 'tp5', type: dataType.currency },
        { name: '金额6', field: 'tp6', type: dataType.currency },
        { name: '金额7', field: 'tp7', type: dataType.currency },
        { name: '金额8', field: 'tp8', type: dataType.currency },
        { name: '金额9', field: 'tp9', type: dataType.currency },
        { name: '金额10', field: 'tp10', 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 stage_im_zl = {
    name: '期-中间计量-总量-数据(mem_stage_im_zl)',
    remark: '',
    id: 21,
    key: 'mem_stage_im_zl',
    prefix: '期-中间计量-总量',
    cols: [
        { name: '台账id', field: 'lid', type: dataType.str },
        { name: '部位id', field: 'pid', 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 },
        { name: '本期数量', field: 'jl', type: dataType.currency },
        { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
        { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
        { name: '桩号', field: 'peg', type: dataType.str },
        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
        { name: '部位', field: 'bw', type: dataType.str },
        { name: '细目', field: 'xm', type: dataType.str },
        { name: '凭证号', field: 'doc_code', type: dataType.str },
        { name: '计算式说明', field: 'calc_memo', type: dataType.str },
        { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
        { name: '变更令号', field: 'bgl_code', type: dataType.str },
        { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
        { name: '中间计量表号', field: 'im_code', type: dataType.str },
        { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
        { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
        { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
        { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
        { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
        { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
        { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
        { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
        { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
        { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '台账数量', field: 'quantity', type: dataType.currency },
        { name: '台账金额', field: 'total_price', type: dataType.currency },
        { name: '位置', field: 'position', type: dataType.str },
        { name: '计量单元', field: 'jldy', type: dataType.str },
        { name: '草图备注', field: 'calc_memo_remark', type: dataType.str },
        { name: '签名列表', field: 'cooperation', type: dataType.arr },
        { name: '签名1', field: 'co_sign1', type: dataType.str, isPic: true },
        { name: '签名2', field: 'co_sign2', type: dataType.str, isPic: true },
        { name: '签名3', field: 'co_sign3', type: dataType.str, isPic: true },
        { name: '签名4', field: 'co_sign4', type: dataType.str, isPic: true },
        { name: '审批时间1', field: 'co_time1', type: dataType.time },
        { name: '审批时间2', field: 'co_time2', type: dataType.time },
        { name: '审批时间3', field: 'co_time3', type: dataType.time },
        { name: '审批时间4', field: 'co_time4', type: dataType.time },
        { name: '审批意见1', field: 'co_opinion1', type: dataType.time },
        { name: '审批意见2', field: 'co_opinion2', type: dataType.time },
        { name: '审批意见3', field: 'co_opinion3', type: dataType.time },
        { name: '审批意见4', field: 'co_opinion4', type: dataType.time },
        { name: '单位工程', field: 'dwgc', type: dataType.str },
        { name: '分部工程', field: 'fbgc', type: dataType.str },
        { name: '分项工程', field: 'fxgc', type: dataType.str },
    ],
};
const stage_im_tz = {
    name: '期-中间计量-台账-数据(mem_stage_im_tz)',
    remark: '',
    id: 19,
    key: 'mem_stage_im_tz',
    prefix: '期-中间计量-台账',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '台账id', field: 'lid', type: dataType.str },
        { name: '部位id', field: 'pid', type: dataType.str },
        { name: '编号', field: 'code', type: dataType.str },
        { name: '本期金额', field: 'jl', type: dataType.currency },
        { name: '本期合同金额', field: 'contract_jl', type: dataType.currency },
        { name: '本期变更金额', field: 'qc_jl', type: dataType.currency },
        { name: '桩号', field: 'peg', type: dataType.str },
        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '部位', field: 'bw', type: dataType.str },
        { name: '细目', field: 'xm', type: dataType.str },
        { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
        { name: '计算式说明', field: 'calc_memo', type: dataType.str },
        { name: '变更令号', field: 'bgl_code', type: dataType.str },
        { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
        { name: '中间计量表号', field: 'im_code', type: dataType.str },
        { name: '凭证号', field: 'doc_code', type: dataType.str },
        { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
        { name: '截止上期 - 金额', field: 'pre_jl', type: dataType.currency },
        { name: '截止上期 - 合同金额', field: 'pre_contract_jl', type: dataType.currency },
        { name: '截止上期 - 变更金额', field: 'pre_qc_jl', type: dataType.currency },
        { name: '截止本期 - 金额', field: 'end_jl', type: dataType.currency },
        { name: '截止本期 - 合同金额', field: 'end_contract_jl', type: dataType.currency },
        { name: '截止本期 - 变更金额', field: 'end_qc_jl', type: dataType.currency },
        { name: '位置', field: 'position', type: dataType.str },
        { name: '计量单元', field: 'jldy', type: dataType.str },
        { name: '草图备注', field: 'calc_img_remark', type: dataType.str },
        { name: '签名列表', field: 'cooperation', type: dataType.arr },
        { name: '签名1', field: 'co_sign1', type: dataType.str, isPic: true },
        { name: '签名2', field: 'co_sign2', type: dataType.str, isPic: true },
        { name: '签名3', field: 'co_sign3', type: dataType.str, isPic: true },
        { name: '签名4', field: 'co_sign4', type: dataType.str, isPic: true },
        { name: '审批时间1', field: 'co_time1', type: dataType.time },
        { name: '审批时间2', field: 'co_time2', type: dataType.time },
        { name: '审批时间3', field: 'co_time3', type: dataType.time },
        { name: '审批时间4', field: 'co_time4', type: dataType.time },
        { name: '审批意见1', field: 'co_opinion1', type: dataType.time },
        { name: '审批意见2', field: 'co_opinion2', type: dataType.time },
        { name: '审批意见3', field: 'co_opinion3', type: dataType.time },
        { name: '审批意见4', field: 'co_opinion4', type: dataType.time },
        { name: '单位工程', field: 'dwgc', type: dataType.str },
        { name: '分部工程', field: 'fbgc', type: dataType.str },
        { name: '分项工程', field: 'fxgc', type: dataType.str },
    ],
};
const stage_im_tz_bills = {
    name: '期-中间计量-台账清单-数据(mem_stage_im_tz_bills)',
    remark: '',
    id: 20,
    key: 'mem_stage_im_tz_bills',
    prefix: '期-中间计量-台账清单',
    cols: [
        { name: '中间计量id', field: 'imid', type: dataType.int },
        { name: '清单id', field: 'bid', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },
        { name: '本期数量', field: 'jl', type: dataType.currency },
        { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
        { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
        { name: '中间计量表号', field: 'im_code', type: dataType.str },
        { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
        { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
        { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
        { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
        { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
        { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
        { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
        { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
        { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
        { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '台账数量', field: 'quantity', type: dataType.currency },
        { name: '台账金额', field: 'total_price', type: dataType.currency },
    ],
};

// 期 - 关联台账 = 中间计量
const stage_rela_im = {
    name: '期-关联台账-中间计量(台账/总量)(mem_stage_rela_im)',
    remark: '',
    id: 67,
    key: 'mem_stage_rela_im',
    prefix: '期-关联台账-中间计量',
    cols: [
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '期id', field: 'sid', type: dataType.int },
        { name: '期序号', field: 'sorder', type: dataType.int },
        { name: '关联标段id', field: 'rela_tid', type: dataType.int },
        { name: '关联期id', field: 'rela_sid', type: dataType.int },
        { name: '关联期序号', field: 'rela_sorder', type: dataType.int },
        { name: '中间计量id', field: 'im_id', type: dataType.int },
        { name: '台账id', field: 'lid', type: dataType.str },
        { name: '部位id', field: 'pid', 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 },
        { name: '桩号', field: 'peg', type: dataType.str },
        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '部位', field: 'bw', type: dataType.str },
        { name: '细目', field: 'xm', type: dataType.str },
        { name: '位置', field: 'position', type: dataType.str },
        { name: '计量单元', field: 'jldy', type: dataType.str },
        { name: '单位工程', field: 'dwgc', type: dataType.str },
        { name: '分部工程', field: 'fbgc', type: dataType.str },
        { name: '分项工程', field: 'fxgc', type: dataType.str },
        { name: '凭证号', field: 'doc_code', type: dataType.str },
        { name: '中间计量表号', field: 'im_code', type: dataType.str },
        { name: '计算式说明', field: 'calc_memo', type: dataType.str },
        { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
        { name: '草图备注', field: 'calc_img_remark', type: dataType.str },
        { name: '变更令号', field: 'bgl_code', type: dataType.str },
        { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
        { name: '本期金额/数量', field: 'jl', type: dataType.currency },
        { name: '本期合同金额/数量', field: 'contract_jl', type: dataType.currency },
        { name: '本期变更金额/数量', field: 'qc_jl', type: dataType.currency },
        { name: '截止上期 - 金额/数量', field: 'pre_jl', type: dataType.currency },
        { name: '截止上期 - 合同金额/数量', field: 'pre_contract_jl', type: dataType.currency },
        { name: '截止上期 - 变更金额/数量', field: 'pre_qc_jl', type: dataType.currency },
        { name: '截止本期 - 金额/数量', field: 'end_jl', type: dataType.currency },
        { name: '截止本期 - 合同金额/数量', field: 'end_contract_jl', type: dataType.currency },
        { name: '截止本期 - 变更金额/数量', field: 'end_qc_jl', type: dataType.currency },
        { name: '空/本期金额', field: 'tp', type: dataType.currency },
        { name: '空/本期合同金额', field: 'contract_tp', type: dataType.currency },
        { name: '空/本期变更金额', field: 'qc_tp', type: dataType.currency },
        { name: '空/截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
        { name: '空/截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
        { name: '空/截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '空/截止本期 - 金额', field: 'end_tp', type: dataType.currency },
        { name: '空/截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '空/截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
    ],
};
const stage_rela_im_bills = {
    name: '期-关联台账-中间计量-清单(mem_stage_rela_im_bills)',
    remark: '',
    id: 68,
    key: 'mem_stage_rela_im_bills',
    prefix: '期-关联台账-中间计量-清单',
    cols: [
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '期id', field: 'sid', type: dataType.int },
        { name: '期序号', field: 'sorder', type: dataType.int },
        { name: '关联标段id', field: 'rela_tid', type: dataType.int },
        { name: '关联期id', field: 'rela_sid', type: dataType.int },
        { name: '关联期序号', field: 'rela_sorder', type: dataType.int },
        { name: '中间计量id', field: 'im_id', type: dataType.int },
        { name: '清单id', field: 'bid', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },
        { name: '本期数量', field: 'jl', type: dataType.currency },
        { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
        { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
        { name: '中间计量表号', field: 'im_code', type: dataType.str },
        { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
        { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
        { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
        { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
        { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
        { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
        { name: '本期金额', field: 'tp', type: dataType.currency },
        { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
        { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
        { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
        { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
        { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '台账数量', field: 'quantity', type: dataType.currency },
        { name: '台账金额', field: 'total_price', type: dataType.currency },
    ],
};

const gather_stage_bills = {
    name: '汇总-清单数据表(mem_gather_stage_bills)',
    remark: '',
    id: 36,
    key: 'mem_gather_stage_bills',
    prefix: '汇总-清单数据',
    cols: [
        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },

        { name: '标段id', field: 't_id', type: dataType.int },
        { name: '标段-名称', field: 't_name', type: dataType.str },

        { name: '(标段)台账-数量', field: 't_qty', type: dataType.currency },
        { name: '(标段)台账-金额', field: 't_tp', type: dataType.currency },

        { name: '(标段)本期-合同-数量', field: 't_contract_qty', type: dataType.currency },
        { name: '(标段)本期-合同-金额', field: 't_contract_tp', type: dataType.currency },
        { name: '(标段)本期-变更-数量', field: 't_qc_qty', type: dataType.currency },
        { name: '(标段)本期-变更-金额', field: 't_qc_tp', type: dataType.currency },
        { name: '(标段)本期-完成-数量', field: 't_gather_qty', type: dataType.currency },
        { name: '(标段)本期-完成-金额', field: 't_gather_tp', type: dataType.currency },

        { name: '(标段)截止上期-合同-数量', field: 't_pre_contract_qty', type: dataType.currency },
        { name: '(标段)截止上期-合同-金额', field: 't_pre_contract_tp', type: dataType.currency },
        { name: '(标段)截止上期-变更-数量', field: 't_pre_qc_qty', type: dataType.currency },
        { name: '(标段)截止上期-变更-金额', field: 't_pre_qc_tp', type: dataType.currency },
        { name: '(标段)截止上期-完成-数量', field: 't_pre_gather_qty', type: dataType.currency },
        { name: '(标段)截止上期-完成-金额', field: 't_pre_gather_tp', type: dataType.currency },

        { name: '(标段)截止本期-合同-数量', field: 't_end_contract_qty', type: dataType.currency },
        { name: '(标段)截止本期-合同-金额', field: 't_end_contract_tp', type: dataType.currency },
        { name: '(标段)截止本期-变更-数量', field: 't_end_qc_qty', type: dataType.currency },
        { name: '(标段)截止本期-变更-金额', field: 't_end_qc_tp', type: dataType.currency },
        { name: '(标段)截止本期-完成-数量', field: 't_end_gather_qty', type: dataType.currency },
        { name: '(标段)截止本期-完成-金额', field: 't_end_gather_tp', type: dataType.currency },

        { name: '(合计)台账-数量', field: 's_qty', type: dataType.currency },
        { name: '(合计)台账-金额', field: 's_tp', type: dataType.currency },

        { name: '(合计)本期-合同-数量', field: 's_contract_qty', type: dataType.currency },
        { name: '(合计)本期-合同-金额', field: 's_contract_tp', type: dataType.currency },
        { name: '(合计)本期-变更-数量', field: 's_qc_qty', type: dataType.currency },
        { name: '(合计)本期-变更-金额', field: 's_qc_tp', type: dataType.currency },
        { name: '(合计)本期-完成-数量', field: 's_gather_qty', type: dataType.currency },
        { name: '(合计)本期-完成-金额', field: 's_gather_tp', type: dataType.currency },

        { name: '(合计)截止上期-合同-数量', field: 's_pre_contract_qty', type: dataType.currency },
        { name: '(合计)截止上期-合同-金额', field: 's_pre_contract_tp', type: dataType.currency },
        { name: '(合计)截止上期-变更-数量', field: 's_pre_qc_qty', type: dataType.currency },
        { name: '(合计)截止上期-变更-金额', field: 's_pre_qc_tp', type: dataType.currency },
        { name: '(合计)截止上期-完成-数量', field: 's_pre_gather_qty', type: dataType.currency },
        { name: '(合计)截止上期-完成-金额', field: 's_pre_gather_tp', type: dataType.currency },

        { name: '(合计)截止本期-合同-数量', field: 's_end_contract_qty', type: dataType.currency },
        { name: '(合计)截止本期-合同-金额', field: 's_end_contract_tp', type: dataType.currency },
        { name: '(合计)截止本期-变更-数量', field: 's_end_qc_qty', type: dataType.currency },
        { name: '(合计)截止本期-变更-金额', field: 's_end_qc_tp', type: dataType.currency },
        { name: '(合计)截止本期-完成-数量', field: 's_end_gather_qty', type: dataType.currency },
        { name: '(合计)截止本期-完成-金额', field: 's_end_gather_tp', type: dataType.currency },

        { name: '(特殊1-需替换key1)台账-数量', field: 'ts_key1_qty', type: dataType.currency },
        { name: '(特殊1-需替换key1)台账-金额', field: 'ts_key1_tp', type: dataType.currency },

        { name: '(特殊2-需替换key2)台账-数量', field: 'ts_key2_qty', type: dataType.currency },
        { name: '(特殊2-需替换key2)台账-金额', field: 'ts_key2_tp', type: dataType.currency },

        { name: '(特殊3-需替换key3)台账-数量', field: 'ts_key3_qty', type: dataType.currency },
        { name: '(特殊3-需替换key3)台账-金额', field: 'ts_key3_tp', type: dataType.currency },

        { name: '交叉排序', field: 'cross_index', type: dataType.int },

        { name: '树结构-id', field: 'id', type: dataType.int },
        { name: '树结构-父项id', field: 'pid', type: dataType.int },
        { name: '树结构-层次', field: 'level', type: dataType.int },
        { name: '树结构-排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },

        { name: '(特殊1-需替换key1)台账-设计数量1', field: 'ts_key1_dgn_qty1', type: dataType.currency },
        { name: '(特殊1-需替换key1)台账-设计数量2', field: 'ts_key1_dgn_qty2', type: dataType.currency },

        { name: '(特殊2-需替换key2)台账-设计数量1', field: 'ts_key2_dgn_qty1', type: dataType.currency },
        { name: '(特殊2-需替换key2)台账-设计数量2', field: 'ts_key2_dgn_qty2', type: dataType.currency },

        { name: '(特殊3-需替换key3)台账-设计数量1', field: 'ts_key3_dgn_qty1', type: dataType.currency },
        { name: '(特殊3-需替换key3)台账-设计数量2', field: 'ts_key3_dgn_qty2', type: dataType.currency },

        { name: '(标段)台账-设计数量1', field: 't_dgn_qty1', type: dataType.currency },
        { name: '(标段)台账-设计数量2', field: 't_dgn_qty2', type: dataType.currency },
        { name: '(标段)合同-设计数量1', field: 't_deal_dgn_qty1', type: dataType.currency },
        { name: '(标段)合同-设计数量2', field: 't_deal_dgn_qty2', type: dataType.currency },
        { name: '(标段)变更-设计数量1', field: 't_c_dgn_qty1', type: dataType.currency },
        { name: '(标段)变更-设计数量2', field: 't_c_dgn_qty2', type: dataType.currency },

        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int },

        { name: '(合计)台账-设计数量1', field: 's_dgn_qty1', type: dataType.currency },
        { name: '(合计)台账-设计数量2', field: 's_dgn_qty2', type: dataType.currency },
        { name: '(合计)合同-设计数量1', field: 's_deal_dgn_qty1', type: dataType.currency },
        { name: '(合计)合同-设计数量2', field: 's_deal_dgn_qty2', type: dataType.currency },
        { name: '(合计)变更-设计数量1', field: 's_c_dgn_qty1', type: dataType.currency },
        { name: '(合计)变更-设计数量2', field: 's_c_dgn_qty2', type: dataType.currency },

        { name: '标段-分类', field: 't_category', type: dataType.str },
    ],
};
const gather_tender_info = {
    name: '汇总-标段信息(mem_gather_tender_info)',
    remark: '',
    id: 37,
    key: 'mem_gather_tender_info',
    prefix: '汇总-标段信息',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '是否特殊标', field: 'spec', type: dataType.str },

        { name: '台账-金额', field: 'tp', type: dataType.currency },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency },

        { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
        { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },

        { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency },
        { name: '截止上期-变更-金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency },

        { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },

        { name: '截止上期-应付', field: 'pre_yf_tp', type: dataType.currency },
        { name: '本期-应付', field: 'yf_tp', type: dataType.currency },
        { name: '截止本期-应付', field: 'end_yf_tp', type: dataType.currency },

        { name: '签约清单-金额', field: 'deal_bills_tp', type: dataType.currency },

        { name: '合同信息-建设项目名称', field: 'deal_info.buildName', type: dataType.str },
        { name: '合同信息-合同编号', field: 'deal_info.dealCode', type: dataType.str },
        { name: '合同信息-合同名称', field: 'deal_info.dealName', type: dataType.str },

        { name: '参建单位-建设单位-单位名称', field: 'construction_unit.build.company', type: dataType.str },
        { name: '参建单位-建设单位-法人代表', field: 'construction_unit.build.corporation', type: dataType.str },
        { name: '参建单位-建设单位-签订日期', field: 'construction_unit.build.date', type: dataType.str },

        { name: '参建单位-承包单位1-单位名称', field: 'construction_unit.contract1.company', type: dataType.str },
        { name: '参建单位-承包单位1-法人代表', field: 'construction_unit.contract1.corporation', type: dataType.str },
        { name: '参建单位-承包单位1-签订日期', field: 'construction_unit.contract1.date', type: dataType.str },

        { name: '参建单位-承包单位2-单位名称', field: 'construction_unit.contract2.company', type: dataType.str },
        { name: '参建单位-承包单位2-法人代表', field: 'construction_unit.contract2.corporation', type: dataType.str },
        { name: '参建单位-承包单位2-签订日期', field: 'construction_unit.contract2.date', type: dataType.str },

        { name: '参建单位-监理单位1-单位名称', field: 'construction_unit.supervision1.company', type: dataType.str },
        { name: '参建单位-监理单位1-法人代表', field: 'construction_unit.supervision1.corporation', type: dataType.str },
        { name: '参建单位-监理单位1-签订日期', field: 'construction_unit.supervision1.date', type: dataType.str },

        { name: '参建单位-监理单位2-单位名称', field: 'construction_unit.supervision2.company', type: dataType.str },
        { name: '参建单位-监理单位2-法人代表', field: 'construction_unit.supervision2.corporation', type: dataType.str },
        { name: '参建单位-监理单位2-签订日期', field: 'construction_unit.supervision2.date', type: dataType.str },

        { name: '技术参数-公路等级', field: 'tech_param.loadLevel', type: dataType.int },
        { name: '技术参数-长度(KM)', field: 'tech_param.loadLength', type: dataType.int },
        { name: '技术参数-起始桩号', field: 'tech_param.startPeg', type: dataType.str },
        { name: '技术参数-终止桩号', field: 'tech_param.endPeg', type: dataType.str },
        { name: '技术参数-车道数', field: 'tech_param.laneCount', type: dataType.int },
        { name: '技术参数-合同工期', field: 'tech_param.dealPeriod', type: dataType.str },
        { name: '技术参数-开工日期', field: 'tech_param.startDate', type: dataType.str },
        { name: '技术参数-计划完工日期', field: 'tech_param.planEndDate', type: dataType.str },

        { name: '合同参数-签约合同价', field: 'deal_param.contractPrice', type: dataType.currency },
        { name: '合同参数-暂列金额', field: 'deal_param.zanLiePrice', type: dataType.currency },
        { name: '合同参数-签约合同价(不含暂列金额)', field: 'deal_param.contractPriceWithoutZL', type: dataType.currency },
        { name: '合同参数-签约开工预付款', field: 'deal_param.startAdvance', type: dataType.currency },
        { name: '合同参数-签约材料预付款', field: 'deal_param.materialAdvance', type: dataType.currency },

        { name: '付款账号-工程款账户-开户名称', field: 'pay_account.project.name', type: dataType.str },
        { name: '付款账号-工程款账户-开户银行', field: 'pay_account.project.bank', type: dataType.str },
        { name: '付款账号-工程款账户-开户账号', field: 'pay_account.project.account', type: dataType.str },
        { name: '付款账号-工程款账户-分账划拨比例(%)', field: 'pay_account.project.rate', type: dataType.str },
        { name: '付款账号-工程款账户-联系人', field: 'pay_account.project.contact', type: dataType.str },
        { name: '付款账号-工程款账户-联系电话', field: 'pay_account.project.phone', type: dataType.str },

        { name: '付款账号-农民工工资专用账户-开户名称', field: 'pay_account.worker.name', type: dataType.str },
        { name: '付款账号-农民工工资专用账户-开户银行', field: 'pay_account.worker.bank', type: dataType.str },
        { name: '付款账号-农民工工资专用账户-开户账号', field: 'pay_account.worker.account', type: dataType.str },
        { name: '付款账号-农民工工资专用账户-分账划拨比例(%)', field: 'pay_account.worker.rate', type: dataType.str },
        { name: '付款账号-农民工工资专用账户-联系人', field: 'pay_account.worker.contact', type: dataType.str },
        { name: '付款账号-农民工工资专用账户-联系电话', field: 'pay_account.worker.phone', type: dataType.str },

        { name: '合同信息-工程类别', field: 'deal_info.projectType', type: dataType.str },
        { name: '合同信息-合同类别', field: 'deal_info.dealType', type: dataType.str },
        { name: '合同信息-结算书编号', field: 'deal_info.finalCode', type: dataType.str },

        { name: '技术参数-实际开工日期', field: 'tech_param.realStartDate', type: dataType.str },
        { name: '技术参数-实际完工日期', field: 'tech_param.realEndDate', type: dataType.str },
        { name: '技术参数-构造物规模', field: 'tech_param.structureScale', type: dataType.str },

        { name: '中标信息-业主控制价', field: 'bid_info.controlPrice', type: dataType.currency },
        { name: '中标信息-中标价', field: 'bid_info.bidPrice', type: dataType.currency },
        { name: '中标信息-开标日期', field: 'bid_info.bidStartDate', type: dataType.str },
    ],
};
const gather_stage_pay = {
    name: '汇总-期-合同支付 数据表(mem_gather_stage_pay)',
    remark: '',
    id: 38,
    key: 'mem_gather_stage_pay',
    prefix: '汇总-期-合同支付',
    cols: [
        { name: '名称', field: 'name', type: dataType.str },
        { name: '类型', field: 'ptype', type: dataType.int },
        { name: '是否扣款项', field: 'minus', type: dataType.int },
        { name: '是否参与本期应付计算', field: 'is_yf', type: dataType.int },

        { name: '标段id', field: 't_id', type: dataType.int },
        { name: '标段-名称', field: 't_name', type: dataType.str },

        { name: '(标段)本期-金额', field: 't_tp', type: dataType.currency },
        { name: '(标段)截止上期-金额', field: 't_pre_tp', type: dataType.currency },
        { name: '(标段)截止本期-金额', field: 't_end_tp', type: dataType.currency },

        { name: '(合计)本期-金额', field: 's_tp', type: dataType.currency },
        { name: '(合计)截止上期-金额', field: 's_pre_tp', type: dataType.currency },
        { name: '(合计)截止本期-金额', field: 's_end_tp', type: dataType.currency },

        { name: '交叉排序', field: 'cross_index', type: dataType.int },
    ],
};
const gather_deal_bills = {
    name: '汇总-签约清单 数据表(mem_gather_deal_bills)',
    remark: '',
    id: 39,
    key: 'mem_gather_deal_bills',
    prefix: '汇总-签约清单',
    cols: [
        { 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 },

        { name: '标段id', field: 't_id', type: dataType.int },
        { name: '标段-名称', field: 't_name', type: dataType.str },

        { name: '(标段)金额', field: 't_tp', type: dataType.currency },

        { name: '(合计)金额', field: 's_tp', type: dataType.currency },

        { name: '(特殊1)金额', field: 'ts_key1_tp', type: dataType.currency },
        { name: '(特殊2)金额', field: 'ts_key2_tp', type: dataType.currency },
        { name: '(特殊3)金额', field: 'ts_key3_tp', type: dataType.currency },

        { name: '(标段)数量', field: 't_qty', type: dataType.currency },

        { name: '(合计)数量', field: 's_qty', type: dataType.currency },

        { name: '(特殊1)数量', field: 'ts_key1_qty', type: dataType.currency },
        { name: '(特殊2)数量', field: 'ts_key2_qty', type: dataType.currency },
        { name: '(特殊3)数量', field: 'ts_key3_qty', type: dataType.currency },

        { name: '交叉排序', field: 'cross_index', type: dataType.int },
    ],
};

// 材差
const select_material = {
    name: '材料调差-选择期-数据(mem_select_material)',
    remark: '',
    id: 71,
    key: 'mem_select_material',
    prefix: '材料调差-选择期',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '创建者id', field: 'user_id', type: dataType.int },
        { name: '审批次数', field: 'times', type: dataType.int },
        { name: '审批状态', field: 'status', type: dataType.int },
        { name: '期id列表', field: 'stage_id', type: dataType.str },
        { name: '期order列表', field: 's_order', type: dataType.str },
        { name: '材料调差期数', field: 'order', type: dataType.int },
        { name: '本期金额', field: 'm_tp', type: dataType.currency },
        { name: '截止上期金额', field: 'pre_tp', type: dataType.currency },
        { name: '税率', field: 'rate', type: dataType.int },
        { name: '创建时间', field: 'in_time', type: dataType.str },

    ],
};

const select_material_audit = {
    name: '材料调差-选择期-审批人 列表(mem_select_material_audit)',
    remark: '',
    id: 72,
    key: 'mem_select_material_audit',
    prefix: '材料调差-选择期',
    cols: [
        { name: '审批人id', field: 'aid', type: dataType.int },
        { name: '姓名', field: 'name', type: dataType.str },
        { name: '公司', field: 'company', type: dataType.str },
        { name: '角色', field: 'role', type: dataType.str },
        { name: '手机', field: 'mobile', type: dataType.str },
        { name: '电话', field: 'telephone', type: dataType.str },
        { name: '审批意见', field: 'opinion', type: dataType.str },
        { name: '审批时间', field: 'end_time', type: dataType.str },
        { name: '审批顺序', field: 'sort', type: dataType.str },
    ],
};

const material = {
    name: '材料调差-期列表-数据(mem_material)',
    remark: '',
    id: 40,
    key: 'mem_material',
    prefix: '材料调差-期列表',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '创建者id', field: 'user_id', type: dataType.int },
        { name: '审批次数', field: 'times', type: dataType.int },
        { name: '审批状态', field: 'status', type: dataType.int },
        { name: '期id列表', field: 'stage_id', type: dataType.str },
        { name: '期order列表', field: 's_order', type: dataType.str },
        { name: '材料调差期数', field: 'order', type: dataType.int },
        { name: '本期金额', field: 'm_tp', type: dataType.currency },
        { name: '截止上期金额', field: 'pre_tp', type: dataType.currency },
        { name: '税率', field: 'rate', type: dataType.int },
        { name: '创建时间', field: 'in_time', type: dataType.str },
        { name: '月信息价-年月份列表', field: 'months', type: dataType.str },
        { name: '指数本期金额', field: 'ex_tp', type: dataType.currency },
        { name: '指数截止上期金额', field: 'ex_pre_tp', type: dataType.currency },
        { name: '指数调差结果公式', field: 'ex_expr', type: dataType.str },
        { name: '调差基数值json', field: 'ex_calc', type: dataType.str },
        { name: '是否已使用材料税，默认为0', field: 'material_tax', type: dataType.int },
        { name: '材料含税总金额', field: 'm_tax_tp', type: dataType.currency },
        { name: '截止上期材料含税金额', field: 'm_tax_pre_tp', type: dataType.currency },
        { name: '小数位数设置JSON', field: 'decimal', type: dataType.currency },
        { name: '批复时间', field: 'checked_time', type: dataType.str },

    ],
};
const materialGl = {
    name: '材料调差-期-调差工料-数据(mem_material_gl)',
    remark: '',
    id: 41,
    key: 'mem_material_gl',
    prefix: '材料调差-期-调差工料',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '标段id', field: 'tid', type: dataType.int },
        { name: '创建期id', field: 'mid', type: dataType.int },

        { name: '调差类型', field: 't_type', type: dataType.int },
        { name: '调差类型s', field: 't_type_str', type: dataType.str },
        { name: '工料分类', field: 'm_type', type: dataType.int },
        { name: '工料分类s', field: 'm_type_str', type: dataType.str },

        { name: '编号', field: 'code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '规格', field: 'spec', type: dataType.str },

        { name: '基准价', field: 'basic_price', type: dataType.currency },
        { name: '基准时间', field: 'basic_time', type: dataType.str },

        { name: '本期信息价-单价', field: 'msg_tp', type: dataType.currency },
        { name: '本期信息价-时间', field: 'msg_times', type: dataType.str },
        { name: '本期信息价-价差', field: 'msg_spread', type: dataType.currency },

        { name: '本期材料调差-上涨幅度', field: 'm_up_risk', type: dataType.int },
        { name: '本期材料调差-下跌幅度', field: 'm_down_risk', type: dataType.int },
        { name: '本期材料调差-有效价差', field: 'm_spread', type: dataType.currency },

        { name: '本期应耗数据', field: 'quantity', type: dataType.currency },
        { 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: 'in_time', type: dataType.str },
        { name: '备注', field: 'remark', type: dataType.str },

        { name: '税率', field: 'm_tax', type: dataType.int },

        { name: '调差金额（材料税）', field: 'm_tax_tp', type: dataType.currency },
        { name: '截止上期调差金额（材料税）', field: 'tax_pre_tp', type: dataType.currency },
    ],
};
const material_bills = {
    name: '材料调差-清单 数据表(mem_material_bills)',
    remark: '',
    id: 52,
    key: 'mem_material_bills',
    prefix: '材料调差-清单',
    cols: [
        { name: '台账ID', field: 'id', type: dataType.int },
        { name: '标段ID', field: 'tender_id', type: dataType.int },
        { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
        { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
        { name: '树结构-层级', field: 'level', type: dataType.int },
        { name: '树结构-同层排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8

        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str }, // 12
        { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },

        { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },

        { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },

        { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
        { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },

        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '备注', field: 'memo', type: dataType.str },
        { name: '节点类型', field: 'node_type', type: dataType.int },
        { name: '总额计量', field: 'is_tp', type: dataType.int },

        { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
        { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency, tag: { type: 'tp' } },
        { name: '本期批注', field: 'postil', type: dataType.str },

        { name: '预留扩展字段_1', field: 'ex_value1', type: dataType.currency },
        { name: '预留扩展字段_2', field: 'ex_value2', type: dataType.currency },

        { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
        { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
        { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
        { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
    ],
};
const material_pos = {
    name: '材料调差-计量单元(mem_material_pos)',
    remark: '',
    id: 53,
    key: 'mem_material_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: 'sgfh_expr', type: dataType.currency },
        { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
        { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
        { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
    ],
};
const material_gl_detail = {
    name: '材料调差-调差工料明细(mem_material_gl_detail)',
    remark: '',
    id: 54,
    key: 'mem_material_gl_detail',
    prefix: '材料调差-调差工料明细',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '排序', field: 'order', type: dataType.int },
        { name: '所属标段id', field: 'tid', type: dataType.int },
        { name: '创建期id', field: 'mid', type: dataType.int },
        { name: '所属工料id', field: 'mb_id', type: dataType.int },
        { name: '清单id', field: 'gcl_id', type: dataType.int },
        { name: '项目节id', field: 'xmj_id', type: dataType.int },
        { name: '部位明细id', field: 'mx_id', type: dataType.int },
        { name: '本期计量数量-小计', field: 'gather_qty', type: dataType.int },
        { name: '数量', field: 'quantity', type: dataType.int },

        { name: '(空)清单编号', field: 'b_code', type: dataType.str },
        { name: '(空)名称', field: 'name', type: dataType.str },
        { name: '(空)单位', field: 'unit', type: dataType.str },
        { name: '(空)单价', field: 'unit_price', type: dataType.currency },

        { name: '(空)本期-合同-数量', field: 'cur_contract_qty', type: dataType.currency, },
        { name: '(空)本期-合同-金额', field: 'cur_contract_tp', type: dataType.currency, },
        { name: '(空)本期-数量变更-数量', field: 'cur_qc_qty', type: dataType.currency, },
        { name: '(空)本期-数量变更-金额', field: 'cur_qc_tp', type: dataType.currency, },
        { name: '(空)本期-完成-数量', field: 'cur_gather_qty', type: dataType.currency, },
        { name: '(空)本期-完成-金额', field: 'cur_gather_tp', type: dataType.currency, },

        { name: '(空)本期-价差', field: 'jc', type: dataType.currency, },

        { name: '(空)汇总工程量清单id', field: 'gather_gcl_id', type: dataType.int },

        { name: '(空)工料-编号', field: 'gl_code', type: dataType.str },
        { name: '(空)工料-名称', field: 'gl_name', type: dataType.str },
        { name: '(空)工料-单位', field: 'gl_unit', type: dataType.str },
        { name: '(空)工料-规格', field: 'gl_spec', type: dataType.str },

        { name: '(空)基准价', field: 'gl_basic_price', type: dataType.currency },
        { name: '(空)基准时间', field: 'gl_basic_time', type: dataType.str },

        { name: '(空)本期信息价-单价', field: 'gl_msg_tp', type: dataType.currency },
        { name: '(空)本期信息价-时间', field: 'gl_msg_times', type: dataType.str },
        { name: '(空)本期信息价-价差', field: 'gl_msg_spread', type: dataType.currency },

        { name: '(空)本期材料调差-上涨幅度', field: 'gl_m_up_risk', type: dataType.int },
        { name: '(空)本期材料调差-下跌幅度', field: 'gl_m_down_risk', type: dataType.int },
        { name: '(空)本期材料调差-有效价差', field: 'gl_m_spread', type: dataType.currency },
    ]
};

const stage_sum_bills = {
    name: '期汇总-清单-交叉数据表(mem_stage_sum_bills)',
    remark: '',
    id: 42,
    key: 'mem_stage_sum_bills',
    prefix: '期汇总-清单-交叉数据',
    cols: [
        { name: '台账ID', field: 'id', type: dataType.int },
        { name: '标段ID', field: 'tender_id', type: dataType.int },
        { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
        { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
        { name: '树结构-层级', field: 'level', type: dataType.int },
        { name: '树结构-同层排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8

        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str }, // 12
        { name: '单价', field: 'unit_price', type: dataType.currency },

        { name: '签约-数量', field: 'deal_qty', type: dataType.currency },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency },

        { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
        { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency },
        { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
        { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency },
        { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
        { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency },
        { name: '台账-数量', field: 'quantity', type: dataType.currency },
        { name: '台账-金额', field: 'total_price', type: dataType.currency },

        { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
        { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },

        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '备注', field: 'memo', type: dataType.str },
        { name: '节点类型', field: 'node_type', type: dataType.int },
        { name: '总额计量', field: 'is_tp', type: dataType.int },

        { name: '(期)-第几期', field: 's_order', type: dataType.int },
        { name: '(期)-合同-数量', field: 's_contract_qty', type: dataType.currency },
        { name: '(期)-合同-金额', field: 's_contract_tp', type: dataType.currency },
        { name: '(期)-变更-数量', field: 's_qc_qty', type: dataType.currency },
        { name: '(期)-变更-金额', field: 's_qc_tp', type: dataType.currency },
        { name: '(期)-完成-数量', field: 's_gather_qty', type: dataType.currency },
        { name: '(期)-完成-金额', field: 's_gather_tp', type: dataType.currency },

        { name: '交叉排序', field: 'cross_index', type: dataType.int },
    ],
};
const stage_sum_pay = {
    name: '期汇总-合同支付 数据表(mem_stage_sum_pay)',
    remark: '',
    id: 43,
    key: 'mem_stage_sum_pay',
    prefix: '期汇总-合同支付',
    cols: [
        { name: '名称', field: 'name', type: dataType.str },
        { name: '类型', field: 'ptype', type: dataType.int },
        { name: '是否扣款项', field: 'minus', type: dataType.int },
        { name: '是否参与本期应付计算', field: 'is_yf', type: dataType.int },

        { name: '(期)第几期', field: 's_order', type: dataType.int },
        { name: '(期)本期-金额', field: 't_tp', type: dataType.currency },

        { name: '交叉排序', field: 'cross_index', type: dataType.int },
    ],
};

const stage_audit = {
    name: '期-审批人 列表(stage_audit)',
    remark: '',
    id: 46,
    key: 'stage_audit',
    prefix: '期-审批人',
    cols: [
        { name: '审批人id', field: 'aid', type: dataType.int },
        { name: '姓名', field: 'name', type: dataType.str },
        { name: '公司', field: 'company', type: dataType.str },
        { name: '角色', field: 'role', type: dataType.str },
        { name: '手机', field: 'mobile', type: dataType.str },
        { name: '电话', field: 'telephone', type: dataType.str },
        { name: '审批意见', field: 'opinion', type: dataType.str },
        { name: '审批时间', field: 'end_time', type: dataType.str },
        { name: '审批顺序', field: 'sort', type: dataType.str },
    ],
};

const sign_select = {
    name: '签字(mem_sign_select)',
    remark: '',
    id: 47,
    key: 'mem_sign_select',
    prefix: '签字',
    cols: [
        { name: 'id-1', field: 'sign1.id', type: dataType.int },
        { name: '名字-1', field: 'sign1.name', type: dataType.str },
        { name: '审批意见-1', field: 'sign1.opinion', type: dataType.str },
        { name: '审批时间-1', field: 'sign1.end_time', type: dataType.str },
        { name: '签名-1', field: 'sign1.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-1', field: 'sign1.co_sign', type: dataType.str, isPic: true },
        { name: 'id-2', field: 'sign2.id', type: dataType.int },
        { name: '名字-2', field: 'sign2.name', type: dataType.str },
        { name: '审批意见-2', field: 'sign2.opinion', type: dataType.str },
        { name: '审批时间-2', field: 'sign2.end_time', type: dataType.str },
        { name: '签名-2', field: 'sign2.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-2', field: 'sign2.co_sign', type: dataType.str, isPic: true },
        { name: 'id-3', field: 'sign3.id', type: dataType.int },
        { name: '名字-3', field: 'sign3.name', type: dataType.str },
        { name: '审批意见-3', field: 'sign3.opinion', type: dataType.str },
        { name: '审批时间-3', field: 'sign3.end_time', type: dataType.str },
        { name: '签名-3', field: 'sign3.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-3', field: 'sign3.co_sign', type: dataType.str, isPic: true },
        { name: 'id-4', field: 'sign4.id', type: dataType.int },
        { name: '名字-4', field: 'sign4.name', type: dataType.str },
        { name: '审批意见-4', field: 'sign4.opinion', type: dataType.str },
        { name: '审批时间-4', field: 'sign4.end_time', type: dataType.str },
        { name: '签名-4', field: 'sign4.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-4', field: 'sign4.co_sign', type: dataType.str, isPic: true },
        { name: 'id-5', field: 'sign5.id', type: dataType.int },
        { name: '名字-5', field: 'sign5.name', type: dataType.str },
        { name: '审批意见-5', field: 'sign5.opinion', type: dataType.str },
        { name: '审批时间-5', field: 'sign5.end_time', type: dataType.str },
        { name: '签名-5', field: 'sign5.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-5', field: 'sign5.co_sign', type: dataType.str, isPic: true },
        { name: 'id-6', field: 'sign6.id', type: dataType.int },
        { name: '名字-6', field: 'sign6.name', type: dataType.str },
        { name: '审批意见-6', field: 'sign6.opinion', type: dataType.str },
        { name: '审批时间-6', field: 'sign6.end_time', type: dataType.str },
        { name: '签名-6', field: 'sign6.sign_path', type: dataType.str, isPic: true },
        { name: '协作签名-6', field: 'sign6.co_sign', type: dataType.str, isPic: true },
    ],
};

const gcl_gather_bills = {
    name: '工程量清单汇总2专用 - 工程量清单',
    remark: '',
    key: 'mem_gcl_gather_bills',
    id: 50,
    prefix: '工程量清单汇总2-清单',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },
        { name: '签约清单-数量', field: 'deal_bills_qty', type: dataType.currency },
        { name: '签约清单-金额', field: 'deal_bills_tp', type: dataType.currency },
        { name: '签约-数量', field: 'deal_qty', type: dataType.currency },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
        { name: '数量', field: 'quantity', type: dataType.currency },
        { name: '金额', field: 'total_price', type: dataType.currency },
        { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency },
        { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期-变更-数量', field: 'qc_qty', type: dataType.currency },
        { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
        { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency },
        { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
        { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency },
        { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期-变更-数量', field: 'end_qc_qty', type: dataType.currency },
        { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency },
        { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
        { name: '备用1-数量', field: 'spec1_qty', type: dataType.currency },
        { name: '备用1-金额', field: 'spec1_tp', type: dataType.currency },
        { name: '备用2-数量', field: 'spec2_qty', type: dataType.currency },
        { name: '备用2-金额', field: 'spec2_tp', type: dataType.currency },
        { name: '备用3-数量', field: 'spec3_qty', type: dataType.currency },
        { name: '备用3-金额', field: 'spec3_tp', type: dataType.currency },
        { name: '备用4-数量', field: 'spec4_qty', type: dataType.currency },
        { name: '备用4-金额', field: 'spec4_tp', type: dataType.currency },
        { name: '备用5-数量', field: 'spec5_qty', type: dataType.currency },
        { name: '备用5-金额', field: 'spec5_tp', type: dataType.currency },
        { name: '备用6-数量', field: 'spec6_qty', type: dataType.currency },
        { name: '备用6-金额', field: 'spec6_tp', type: dataType.currency },
    ],
};
const gcl_gather_xmj = {
    name: '工程量清单汇总2专用 - 相关项目节',
    remark: '',
    key: 'mem_gcl_gather_xmj',
    id: 51,
    prefix: '工程量清单汇总2-项目节',
    cols: [
        { name: '清单id(所属工程量清单id）', field: 'gcl_id', type: dataType.int },
        { name: '明细id(在台账中的id)', field: 'mx_id', type: dataType.str },
        { name: '编号', field: 'code', type: dataType.str },
        { name: '计量单元', field: 'jldy', type: dataType.str },
        { name: '分部工程', field: 'fbgc', type: dataType.str },
        { name: '分项工程', field: 'fxgc', type: dataType.str },
        { name: '单位工程', field: 'dwgc', type: dataType.str },
        { name: '部位明细', field: 'bwmx', type: dataType.str },
        { name: '图册号', field: 'drawing_code', type: dataType.str },
        { name: '数量', field: 'quantity', type: dataType.currency },
        { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency },
        { name: '本期-变更-数量', field: 'qc_qty', type: dataType.currency },
        { name: '本期-完成-数量', field: '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: '备用1-数量', field: 'spec1_qty', type: dataType.currency },
        { name: '备用2-数量', field: 'spec2_qty', type: dataType.currency },
        { name: '备用3-数量', field: 'spec3_qty', type: dataType.currency },
        { name: '备用4-数量', field: 'spec4_qty', type: dataType.currency },
        { name: '备用5-数量', field: 'spec5_qty', type: dataType.currency },
        { name: '备用6-数量', field: 'spec6_qty', type: dataType.currency },
        { name: 'id(项目节id）', field: 'id', type: dataType.int },
    ],
};

const ledger_tag = {
    name: '台账书签（仅显示当前登录用户可见书签）',
    remark: '',
    key: 'mem_ledger_tag',
    id: 55,
    prefix: '台账书签',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '创建用户', field: 'uid', type: dataType.int },
        { name: '台账id(uuid)', field: 'lid', type: dataType.str },
        { name: '是否共享', field: 'share', type: dataType.int },
        { name: '书签颜色', field: 'color', type: dataType.str },
        { name: '批注', field: 'comment', type: dataType.str },
        { name: '创建时间', field: 'create_time', type: dataType.time },
        { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
    ],
};
const stage_tag = {
    name: '期 - 台账书签（仅显示当前登录用户可见书签）',
    remark: '',
    key: 'mem_stage_tag',
    id: 56,
    prefix: '期 - 台账书签',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '创建用户', field: 'uid', type: dataType.int },
        { name: '台账id(uuid)', field: 'lid', type: dataType.str },
        { name: '是否共享', field: 'share', type: dataType.int },
        { name: '书签颜色', field: 'color', type: dataType.str },
        { name: '批注', field: 'comment', type: dataType.str },
        { name: '创建时间', field: 'create_time', type: dataType.time },
        { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
    ],
};
const all_tag = {
    name: '全部书签（台账&全部期&所有人）',
    remark: '',
    key: 'mem_all_tag',
    id: 57,
    prefix: '期 - 台账书签',
    cols: [
        { name: 'id', field: 'id', type: dataType.int },
        { name: '创建用户', field: 'uid', type: dataType.int },
        { name: '台账id(uuid)', field: 'lid', type: dataType.str },
        { name: '期id(-1表示台账)', field: 'sid', type: dataType.str },
        { name: '期序号(-1表示)', field: 'sorder', type: dataType.str },
        { name: '是否共享', field: 'share', type: dataType.int },
        { name: '书签颜色', field: 'color', type: dataType.str },
        { name: '批注', field: 'comment', type: dataType.str },
        { name: '创建时间', field: 'create_time', type: dataType.time },
        { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
    ],
};

const stage_change_bills = {
    name: '期-变更清单 调用明细(mem_stage_change_bills)',
    remark: '',
    key: 'mem_stage_change_bills',
    id: 48,
    prefix: '期-变更清单 调用明细',
    cols: [
        { name: '变更令id', field: 'cid', type: dataType.str },
        { name: '变更清单id', field: 'cbid', type: dataType.int },
        { name: '变更数量', field: 'qty', type: dataType.int },
        { name: '变更令-批复编号', field: 'c_code', type: dataType.str },
        { name: '变更令-变更名称', field: 'c_name', type: dataType.str },
        { name: '变更令-变更图号', field: 'c_new_code', type: dataType.str },
        { name: '变更令-变更设计图名称', field: 'c_new_name', type: dataType.str },
        { name: '变更令-工程变更理由及内容', field: 'c_content', type: dataType.str },
        { name: '变更令-工程变更合同依据', field: 'c_basis', type: dataType.str },
        { name: '变更令-变更状态发生时间', field: 'c_cin_time', type: dataType.str },
        { name: '变更清单-清单编号', field: 'b_code', type: dataType.str },
        { name: '变更清单-名称', field: 'name', type: dataType.str },
        { name: '变更清单-单位', field: 'unit', type: dataType.str },
        { name: '变更清单-单价', field: 'unit_price', type: dataType.str },
        { name: '变更令-变更类型', field: 'c_type', type: dataType.str },
        { name: '变更令-变更类别', field: 'c_class', type: dataType.int },
        { name: '变更令-变更性质', field: 'c_quality', type: dataType.int },
        { name: '调用期-序号', field: 's_order', type: dataType.int },
    ],
};
const stage_change_ledger = {
    name: '期-变更台账(mem_stage_change_ledger)',
    remark: '',
    key: 'mem_stage_change_ledger',
    id: 49,
    prefix: '期-变更台账',
    cols: [
        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '台账-金额', field: 'total_price', type: dataType.currency },
        { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
        { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
        { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
        { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
        { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
        { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
        { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
        { name: '变更令-批复编号', field: 'c_code', type: dataType.str },
        { name: '变更令-变更名称', field: 'c_name', type: dataType.str },
        { name: '变更令-变更图号', field: 'c_new_code', type: dataType.str },
        { name: '变更令-变更设计图名称', field: 'c_new_name', type: dataType.str },
        { name: '变更令-工程变更理由及内容', field: 'c_content', type: dataType.str },
        { name: '变更令-工程变更合同依据', field: 'c_basis', type: dataType.str },
        { name: '变更令-变更状态发生时间', field: 'c_cin_time', type: dataType.str },
    ],
};
const stage_change = {
    name: '本期-变更清单-全审批人 调用明细(mem_stage_change)',
    remark: '',
    key: 'mem_stage_change',
    id: 60,
    prefix: '本期-变更清单-全审批人 调用明细',
    cols: [
        { name: 'id', field: 'id', type: dataType.str },
        { name: '标段id', field: 'tid', type: dataType.str },
        { name: '期id', field: 'sid', type: dataType.str },
        { name: '台账id', field: 'lid', type: dataType.str },
        { name: '计量单元id', field: 'pid', type: dataType.str },
        { name: '变更令id', field: 'cid', type: dataType.str },
        { name: '变更清单id', field: 'cbid', type: dataType.int },
        { name: '期-调用人-第几轮', field: 'stimes', type: dataType.str },
        { name: '期-调用人-排序', field: 'sorder', type: dataType.str },
        { name: '变更数量', field: 'qty', type: dataType.int },
    ],
};

const stage_change_info = {
    name: '变更概况(mem_change_info)',
    remark: '',
    id: 65,
    key: 'mem_change_info',
    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_time', 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 },
        { name: '截止本期-已执行(%)', field: 'used_ratio', type: dataType.currency },
        { name: '本期使用', field: 'cur_used', type: dataType.int },
    ],
};
const stage_change_info_bills = {
    name: '变更概况-清单(mem_change_info_bills)',
    remark: '',
    id: 66,
    key: 'mem_change_info_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: 'detail', type: dataType.str },
        { name: '变更部位', field: 'bwmx', type: dataType.str },
        { name: '数量', field: 'qty', type: dataType.currency },
        { name: '金额', field: 'tp', type: dataType.currency },
        { name: '截止本期-已变更', field: 'used_qty', type: dataType.currency },
        { name: '可执行', field: 'valid_qty', type: dataType.currency },
        { name: '本期使用数量', field: 'cur_qty', type: dataType.currency },
        { name: '本期使用', field: 'cur_used', type: dataType.int },
    ],
};

// 定制表
// 季华项目 中间计量报表--变更相关 汇总对比表
const jh_im_change = {
    name: '【定制】季华-中间计量-变更 数据表(mem_jh_im_change)',
    remark: '',
    id: 61,
    key: 'mem_jh_im_change',
    prefix: '【定制】季华-中间计量-变更',
    cols: [
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str }, // 12
        { name: '单价', field: 'unit_price', type: dataType.currency },

        { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
        { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency },
        { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
        { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency },
    ],
};
const jh_gather_im_change = {
    name: '【定制】季华-中间计量-变更-汇总 数据表(mem_jh_gather_im_change)',
    remark: '',
    id: 62,
    key: 'mem_jh_gather_im_change',
    prefix: '【定制】季华-中间计量-变更-汇总',
    cols: [
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },

        { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
        { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency },
        { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency },
        { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
        { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency },

        { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
        { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency },
    ],
};
const jh_gather_stage_bills_compare = {
    name: '【定制】季华-期-清单-汇总-多审 数据表(mem_jh_gather_stage_bills_compare)',
    remark: '',
    id: 64,
    key: 'mem_jh_gather_stage_bills_compare',
    prefix: '【定制】季华-期-清单-汇总-多审',
    cols: [
        { name: '项目节编号', field: 'code', type: dataType.str },
        { name: '清单编号', field: 'b_code', type: dataType.str },
        { name: '名称', field: 'name', type: dataType.str },
        { name: '单位', field: 'unit', type: dataType.str },
        { name: '单价', field: 'unit_price', type: dataType.currency },

        { name: '(合计)台账-数量', field: 's_qty', type: dataType.currency },
        { name: '(合计)台账-金额', field: 's_tp', type: dataType.currency },

        { name: '(合计)本期-合同-数量', field: 's_contract_qty', type: dataType.currency },
        { name: '(合计)本期-合同-金额', field: 's_contract_tp', type: dataType.currency },
        { name: '(合计)本期-变更-数量', field: 's_qc_qty', type: dataType.currency },
        { name: '(合计)本期-变更-金额', field: 's_qc_tp', type: dataType.currency },
        { name: '(合计)本期-完成-数量', field: 's_gather_qty', type: dataType.currency },
        { name: '(合计)本期-完成-金额', field: 's_gather_tp', type: dataType.currency },

        { name: '(合计)截止上期-合同-数量', field: 's_pre_contract_qty', type: dataType.currency },
        { name: '(合计)截止上期-合同-金额', field: 's_pre_contract_tp', type: dataType.currency },
        { name: '(合计)截止上期-变更-数量', field: 's_pre_qc_qty', type: dataType.currency },
        { name: '(合计)截止上期-变更-金额', field: 's_pre_qc_tp', type: dataType.currency },
        { name: '(合计)截止上期-完成-数量', field: 's_pre_gather_qty', type: dataType.currency },
        { name: '(合计)截止上期-完成-金额', field: 's_pre_gather_tp', type: dataType.currency },

        { name: '(合计)截止本期-合同-数量', field: 's_end_contract_qty', type: dataType.currency },
        { name: '(合计)截止本期-合同-金额', field: 's_end_contract_tp', type: dataType.currency },
        { name: '(合计)截止本期-变更-数量', field: 's_end_qc_qty', type: dataType.currency },
        { name: '(合计)截止本期-变更-金额', field: 's_end_qc_tp', type: dataType.currency },
        { name: '(合计)截止本期-完成-数量', field: 's_end_gather_qty', type: dataType.currency },
        { name: '(合计)截止本期-完成-金额', field: 's_end_gather_tp', type: dataType.currency },

        { name: '(原报)本期-合同-数量', field: 'r0_contract_qty', type: dataType.currency },
        { name: '(原报)本期-合同-金额', field: 'r0_contract_tp', type: dataType.currency },
        { name: '(原报)本期-变更-数量', field: 'r0_qc_qty', type: dataType.currency },
        { name: '(原报)本期-变更-金额', field: 'r0_qc_tp', type: dataType.currency },
        { name: '(原报)本期-完成-数量', field: 'r0_gather_qty', type: dataType.currency },
        { name: '(原报)本期-完成-金额', field: 'r0_gather_tp', type: dataType.currency },

        { name: '(1审)本期-合同-数量', field: 'r1_contract_qty', type: dataType.currency },
        { name: '(1审)本期-合同-金额', field: 'r1_contract_tp', type: dataType.currency },
        { name: '(1审)本期-变更-数量', field: 'r1_qc_qty', type: dataType.currency },
        { name: '(1审)本期-变更-金额', field: 'r1_qc_tp', type: dataType.currency },
        { name: '(1审)本期-完成-数量', field: 'r1_gather_qty', type: dataType.currency },
        { name: '(1审)本期-完成-金额', field: 'r1_gather_tp', type: dataType.currency },

        { name: '(2审)本期-合同-数量', field: 'r2_contract_qty', type: dataType.currency },
        { name: '(2审)本期-合同-金额', field: 'r2_contract_tp', type: dataType.currency },
        { name: '(2审)本期-变更-数量', field: 'r2_qc_qty', type: dataType.currency },
        { name: '(2审)本期-变更-金额', field: 'r2_qc_tp', type: dataType.currency },
        { name: '(2审)本期-完成-数量', field: 'r2_gather_qty', type: dataType.currency },
        { name: '(2审)本期-完成-金额', field: 'r2_gather_tp', type: dataType.currency },

        { name: '(3审)本期-合同-数量', field: 'r3_contract_qty', type: dataType.currency },
        { name: '(3审)本期-合同-金额', field: 'r3_contract_tp', type: dataType.currency },
        { name: '(3审)本期-变更-数量', field: 'r3_qc_qty', type: dataType.currency },
        { name: '(3审)本期-变更-金额', field: 'r3_qc_tp', type: dataType.currency },
        { name: '(3审)本期-完成-数量', field: 'r3_gather_qty', type: dataType.currency },
        { name: '(3审)本期-完成-金额', field: 'r3_gather_tp', type: dataType.currency },

        { name: '树结构-id', field: 'id', type: dataType.int },
        { name: '树结构-父项id', field: 'pid', type: dataType.int },
        { name: '树结构-层次', field: 'level', type: dataType.int },
        { name: '树结构-排序', field: 'order', type: dataType.int },
        { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
        { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int },
    ],
};

const custom_select = {
    name: '【用户交互】用户选择信息 数据表(mem_custom_select)',
    remark: '',
    id: 63,
    key: 'mem_custom_select',
    prefix: '【用户交互】用户选择信息',
    cols: [
        // audit_select
        { name: '审批人选择-id', field: 'audit_select.aid', type: dataType.arr, map: 'arr' },
        { name: '审批人选择-名称', field: 'audit_select.name', type: dataType.arr, map: 'arr' },
        { name: '审批人选择-单位', field: 'audit_select.company', type: dataType.arr, map: 'arr' },
        { name: '审批人选择-角色', field: 'audit_select.role', type: dataType.arr, map: 'arr' },
        { name: '审批人选择-审批轮', field: 'audit_select.times', type: dataType.arr, map: 'arr' },
        { name: '审批人选择-审批顺序', field: 'audit_select.order', type: dataType.arr, map: 'arr' },
        // gather_select
        { name: '标段汇总-类型', field: 'gather_select.type', type: dataType.str },
        { name: '标段汇总-汇总年月', field: 'gather_select.month', type: dataType.str },
        { name: '标段汇总-汇总区间(时间)', field: 'gather_select.zone', type: dataType.str },
        { name: '标段汇总-汇总期', field: 'gather_select.stage', type: dataType.int },
        { name: '标段汇总-汇总区间(期)', field: 'gather_select.stage_zone', type: dataType.int },
        // stage_select
        { name: '期汇总-选择期', field: 'stage_select.stages', type: dataType.str},
    ]
};

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, col) {
    const data = {};
    data.ID = table.ID * 100 + (col.id ? Math.max(table.items.length + 1, col.id) : table.items.length + 1);
    data.Name = col.name + (col.field ? '(' + col.field + ')' : '') + (data.ID ? '(id: ' + data.ID + ')' : '');
    if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
    data.DataType = col.type;
    data.TableName = table.key;
    data.descr = '';
    if (col.map && col.map === 'arr') {
        data.mapExpression = `$PROJECT.REPORT.getArrayProperty('${table.key}', '${col.field}')`;
    } else {
        data.mapExpression = `$PROJECT.REPORT.getProperty('${table.key}', '${col.field}')`;
    }
    if (col.tag) {
        switch (tag.type) {
            case 'up':
                data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
                break;
            case 'tp':
                if (col.tag.subType) {
                    data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + '_' + col.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;
        }
    }
    if (col.isPic) {
        data.isPic = true;
    }
    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);
    }
    addFields(tableDefine, { id: 99, name: '空白', field: '', type: dataType.str });
    await saveTableDefine(tableDefine, path.join(savePath, define.key + '_define.json'));
};

const defines = [
    ledger_cooperation,
    advance_pay,
    union_data,
    month_progress,
    stage_bills, stage_bills_compare,
    stage_jgcl, stage_bonus, stage_other, stage_safe_prod, stage_temp_land,
    change, change_bills, change_audit,
    stage_pos, stage_pos_compare,
    stage_pay,
    stage_im_zl, stage_im_tz, stage_im_tz_bills,
    stage_rela_im, stage_rela_im_bills,
    gather_stage_bills, gather_tender_info, gather_stage_pay, gather_deal_bills,
    select_material, select_material_audit, material, materialGl, material_bills, material_pos, material_gl_detail,
    stage_sum_bills, stage_sum_pay, stage_audit, sign_select,
    stage_change, stage_change_bills, stage_change_ledger,
    gcl_gather_bills, gcl_gather_xmj,
    ledger_tag, stage_tag, all_tag,
    jh_im_change, jh_gather_im_change, jh_gather_stage_bills_compare,
    custom_select,
    stage_change_info, stage_change_info_bills,
];
for (const d of defines) {
    exportTableDefine(d);
}