123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194 |
- 'use strict';
- /**
- *
- *
- * @author Mai
- * @date
- * @version
- */
- const fs = require('fs');
- const path = require('path');
- const savePath = path.join(__dirname, 'report_temp');
- const dataType = {
- int: 'int',
- str: 'string',
- double: 'double',
- currency: 'currency',
- time: 'string',
- };
- const tag = {
- tp: {type: 'tp'},
- up: {type: 'up'},
- };
- const stage_jgcl = {
- name: '期-甲供材料(mem_stage_jgcl)',
- remark: '',
- id: 30,
- key: 'stage_jgcl',
- prefix: '期-甲供材料',
- cols: [
- {name: 'id', field: 'id', type: dataType.int},
- {name: 'uuid', field: 'uuid', type: dataType.str},
- {name: '名称', field: 'name', type: dataType.str},
- {name: '单位', field: 'unit', type: dataType.str},
- {name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'}},
- {name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
- {name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
- {name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
- {name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
- {name: '材料来源', field: 'source', type: dataType.str},
- {name: '单据号', field: 'bills_code', type: dataType.str},
- {name: '检验单编号', field: 'check_code', type: dataType.str},
- {name: '新增人id', field: 'add_uid', type: dataType.int},
- {name: '新增期id', field: 'add_sid', type: dataType.int},
- {name: '所属期id', field: 'sid', type: dataType.int},
- {name: '期历史记录', field: 'shistory', type: dataType.str},
- {name: '排序', field: 'order', type: dataType.int},
- {name: '往期是否已用', field: 'pre_used', type: dataType.int},
- {name: '截止上期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
- {name: '截止上期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
- {name: '截止上期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
- {name: '截止上期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
- ]
- };
- const stage_bonus = {
- name: '期-奖罚金(mem_stage_bonus)',
- remark: '',
- id: 31,
- key: 'stage_bonus',
- prefix: '期-奖罚金',
- cols: [
- {name: 'id', field: 'id', type: dataType.str},
- {name: '所属标段id', field: 'tid', type: dataType.int},
- {name: '所属期id', field: 'sid', type: dataType.int},
- {name: '所属第几期', field: 'sorder', type: dataType.int},
- {name: '新增人id', field: 'uid', type: dataType.int},
- {name: '名称', field: 'name', type: dataType.str},
- {name: '金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
- {name: '证明材料', field: 'proof', type: dataType.str},
- {name: '创建时间', field: 'create_time', type: dataType.time},
- {name: '时间', field: 'real_time', type: dataType.time},
- {name: '备注', field: 'memo', type: dataType.str},
- {name: '期历史记录', field: 'shistory', type: dataType.str},
- {name: '排序', field: 'order', type: dataType.int},
- ]
- };
- const stage_other = {
- name: '期-其他(mem_stage_other)',
- remark: '',
- id: 32,
- key: 'stage_other',
- prefix: '期-其他',
- cols: [
- {name: 'id', field: 'id', type: dataType.int},
- {name: 'uuid', field: 'uuid', type: dataType.str},
- {name: '所属标段id', field: 'tid', type: dataType.int},
- {name: '所属期id', field: 'sid', type: dataType.int},
- {name: '所属第几期', field: 'sorder', type: dataType.int},
- {name: '新增人id', field: 'add_uid', type: dataType.int},
- {name: '新增期id', field: 'add_sid', type: dataType.int},
- {name: '创建时间', field: 'add_time', type: dataType.time},
- {name: '名称', field: 'name', type: dataType.str},
- {name: '金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'}},
- {name: '本期金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
- {name: '时间', field: 'real_time', type: dataType.time},
- {name: '备注', field: 'memo', type: dataType.str},
- {name: '期历史记录', field: 'shistory', type: dataType.str},
- {name: '排序', field: 'order', type: dataType.int},
- {name: '往期是否已用', field: 'pre_used', type: dataType.int},
- {name: '截止上期-金额', field: 'pre_tp', type: dataType.currency, tag: {type: 'tp'}},
- ]
- };
- const recursiveMkdirSync = async function (pathName) {
- if (!fs.existsSync(pathName)) {
- const upperPath = path.dirname(pathName);
- if (!fs.existsSync(upperPath)) {
- await this.recursiveMkdirSync(upperPath);
- }
- await fs.mkdirSync(pathName);
- }
- };
- const saveBufferFile = async function (buffer, fileName) {
- // 检查文件夹是否存在,不存在则直接创建文件夹
- const pathName = path.dirname(fileName);
- if (!fs.existsSync(pathName)) {
- await recursiveMkdirSync(pathName);
- }
- await fs.writeFileSync(fileName, buffer);
- };
- const addFields = function(table, name, field, type, tag) {
- const data = {};
- data.ID = table.ID * 100 + table.items.length + 1;
- data.Name = name + '(' + field + ')';
- if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
- data.DataType = type;
- data.TableName = table.key;
- data.descr = '';
- data.mapExpression = "$PROJECT.REPORT.getProperty('" + table.key + "', '" + field + "')";
- if (tag) {
- switch (tag.type) {
- case 'up':
- data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
- break;
- case 'tp':
- if (tag.subType) {
- data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + "_" + tag.subType + "_tp')" };
- } else {
- data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" };
- }
- break;
- case 'qty':
- data.Precision = { type: "flexible", flexibleRefFieldID: table.ID * 100 + tag.unitKey, flexibleMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'precision')" };
- break;
- }
- }
- table.items.push(data);
- };
- const saveTableDefine = async function (tableDefine, file) {
- delete tableDefine.ID;
- delete tableDefine.key;
- delete tableDefine.prefix;
- let defineStr = JSON.stringify(tableDefine, "", "\t");
- const replaceStr = [
- {match: '"Name":', str: 'Name:'},
- {match: '"remark":', str: 'remark:'},
- {match: '"items":', str: 'items:'},
- {match: '"ID":', str: 'ID:'},
- {match: '"DataType":', str: 'DataType:'},
- {match: '"TableName":', str: 'TableName:'},
- {match: '"descr":', str: 'descr:'},
- {match: '"mapExpression":', str: 'mapExpression:'},
- {match: '"Precision":', str: 'Precision:'},
- {match: '"type":', str: 'type:'},
- {match: '"flexibleRefFieldID":', str: 'flexibleRefFieldID:'},
- {match: '"fixedMapExpression":', str: 'fixedMapExpression:'},
- {match: '"flexibleMapExpression":', str: 'flexibleMapExpression:'},
- ];
- for (const rs of replaceStr) {
- const reg = new RegExp(rs.match, 'gm');
- defineStr = defineStr.replace(reg, rs.str);
- }
- await saveBufferFile(defineStr, file);
- };
- const exportTableDefine = async function (define) {
- const tableDefine = {};
- tableDefine.Name = define.name;// '期-清单-全参与人数据表(mem_stage_bills_compare)';
- tableDefine.remark = define.remark;
- tableDefine.ID = define.id;
- tableDefine.key = define.key;
- tableDefine.items = [];
- tableDefine.prefix = define.prefix;
- for (const col of define.cols) {
- addFields(tableDefine, col.name, col.field, col.type, col.tag);
- }
- await saveTableDefine(tableDefine, path.join(savePath, define.key + '.json'));
- };
- const defines = [stage_bonus, stage_jgcl, stage_other];
- for (const d of defines) {
- exportTableDefine(d);
- }
|