builder_report_index_define.js 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const fs = require('fs');
  10. const path = require('path');
  11. const savePath = path.join(__dirname, 'report_temp');
  12. const dataType = {
  13. int: 'int',
  14. str: 'string',
  15. double: 'double',
  16. currency: 'currency',
  17. time: 'string',
  18. };
  19. const tag = {
  20. tp: {type: 'tp'},
  21. up: {type: 'up'},
  22. };
  23. const stage_jgcl = {
  24. name: '期-甲供材料(mem_stage_jgcl)',
  25. remark: '',
  26. id: 30,
  27. key: 'stage_jgcl',
  28. prefix: '期-甲供材料',
  29. cols: [
  30. {name: 'id', field: 'id', type: dataType.int},
  31. {name: 'uuid', field: 'uuid', type: dataType.str},
  32. {name: '名称', field: 'name', type: dataType.str},
  33. {name: '单位', field: 'unit', type: dataType.str},
  34. {name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'}},
  35. {name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
  36. {name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
  37. {name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
  38. {name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
  39. {name: '材料来源', field: 'source', type: dataType.str},
  40. {name: '单据号', field: 'bills_code', type: dataType.str},
  41. {name: '检验单编号', field: 'check_code', type: dataType.str},
  42. {name: '新增人id', field: 'add_uid', type: dataType.int},
  43. {name: '新增期id', field: 'add_sid', type: dataType.int},
  44. {name: '所属期id', field: 'sid', type: dataType.int},
  45. {name: '期历史记录', field: 'shistory', type: dataType.str},
  46. {name: '排序', field: 'order', type: dataType.int},
  47. {name: '往期是否已用', field: 'pre_used', type: dataType.int},
  48. {name: '截止上期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
  49. {name: '截止上期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: {type: 'tp'}},
  50. {name: '截止上期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 5}},
  51. {name: '截止上期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: {type: 'tp'}},
  52. ]
  53. };
  54. const stage_bonus = {
  55. name: '期-奖罚金(mem_stage_bonus)',
  56. remark: '',
  57. id: 31,
  58. key: 'stage_bonus',
  59. prefix: '期-奖罚金',
  60. cols: [
  61. {name: 'id', field: 'id', type: dataType.str},
  62. {name: '所属标段id', field: 'tid', type: dataType.int},
  63. {name: '所属期id', field: 'sid', type: dataType.int},
  64. {name: '所属第几期', field: 'sorder', type: dataType.int},
  65. {name: '新增人id', field: 'uid', type: dataType.int},
  66. {name: '名称', field: 'name', type: dataType.str},
  67. {name: '金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
  68. {name: '证明材料', field: 'proof', type: dataType.str},
  69. {name: '创建时间', field: 'create_time', type: dataType.time},
  70. {name: '时间', field: 'real_time', type: dataType.time},
  71. {name: '备注', field: 'memo', type: dataType.str},
  72. {name: '期历史记录', field: 'shistory', type: dataType.str},
  73. {name: '排序', field: 'order', type: dataType.int},
  74. ]
  75. };
  76. const stage_other = {
  77. name: '期-其他(mem_stage_other)',
  78. remark: '',
  79. id: 32,
  80. key: 'stage_other',
  81. prefix: '期-其他',
  82. cols: [
  83. {name: 'id', field: 'id', type: dataType.int},
  84. {name: 'uuid', field: 'uuid', type: dataType.str},
  85. {name: '所属标段id', field: 'tid', type: dataType.int},
  86. {name: '所属期id', field: 'sid', type: dataType.int},
  87. {name: '所属第几期', field: 'sorder', type: dataType.int},
  88. {name: '新增人id', field: 'add_uid', type: dataType.int},
  89. {name: '新增期id', field: 'add_sid', type: dataType.int},
  90. {name: '创建时间', field: 'add_time', type: dataType.time},
  91. {name: '名称', field: 'name', type: dataType.str},
  92. {name: '金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'}},
  93. {name: '本期金额', field: 'tp', type: dataType.currency, tag: {type: 'tp'}},
  94. {name: '时间', field: 'real_time', type: dataType.time},
  95. {name: '备注', field: 'memo', type: dataType.str},
  96. {name: '期历史记录', field: 'shistory', type: dataType.str},
  97. {name: '排序', field: 'order', type: dataType.int},
  98. {name: '往期是否已用', field: 'pre_used', type: dataType.int},
  99. {name: '截止上期-金额', field: 'pre_tp', type: dataType.currency, tag: {type: 'tp'}},
  100. ]
  101. };
  102. const recursiveMkdirSync = async function (pathName) {
  103. if (!fs.existsSync(pathName)) {
  104. const upperPath = path.dirname(pathName);
  105. if (!fs.existsSync(upperPath)) {
  106. await this.recursiveMkdirSync(upperPath);
  107. }
  108. await fs.mkdirSync(pathName);
  109. }
  110. };
  111. const saveBufferFile = async function (buffer, fileName) {
  112. // 检查文件夹是否存在,不存在则直接创建文件夹
  113. const pathName = path.dirname(fileName);
  114. if (!fs.existsSync(pathName)) {
  115. await recursiveMkdirSync(pathName);
  116. }
  117. await fs.writeFileSync(fileName, buffer);
  118. };
  119. const addFields = function(table, name, field, type, tag) {
  120. const data = {};
  121. data.ID = table.ID * 100 + table.items.length + 1;
  122. data.Name = name + '(' + field + ')';
  123. if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
  124. data.DataType = type;
  125. data.TableName = table.key;
  126. data.descr = '';
  127. data.mapExpression = "$PROJECT.REPORT.getProperty('" + table.key + "', '" + field + "')";
  128. if (tag) {
  129. switch (tag.type) {
  130. case 'up':
  131. data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
  132. break;
  133. case 'tp':
  134. if (tag.subType) {
  135. data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + "_" + tag.subType + "_tp')" };
  136. } else {
  137. data.Precision = { type: "fixed", fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" };
  138. }
  139. break;
  140. case 'qty':
  141. data.Precision = { type: "flexible", flexibleRefFieldID: table.ID * 100 + tag.unitKey, flexibleMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'precision')" };
  142. break;
  143. }
  144. }
  145. table.items.push(data);
  146. };
  147. const saveTableDefine = async function (tableDefine, file) {
  148. delete tableDefine.ID;
  149. delete tableDefine.key;
  150. delete tableDefine.prefix;
  151. let defineStr = JSON.stringify(tableDefine, "", "\t");
  152. const replaceStr = [
  153. {match: '"Name":', str: 'Name:'},
  154. {match: '"remark":', str: 'remark:'},
  155. {match: '"items":', str: 'items:'},
  156. {match: '"ID":', str: 'ID:'},
  157. {match: '"DataType":', str: 'DataType:'},
  158. {match: '"TableName":', str: 'TableName:'},
  159. {match: '"descr":', str: 'descr:'},
  160. {match: '"mapExpression":', str: 'mapExpression:'},
  161. {match: '"Precision":', str: 'Precision:'},
  162. {match: '"type":', str: 'type:'},
  163. {match: '"flexibleRefFieldID":', str: 'flexibleRefFieldID:'},
  164. {match: '"fixedMapExpression":', str: 'fixedMapExpression:'},
  165. {match: '"flexibleMapExpression":', str: 'flexibleMapExpression:'},
  166. ];
  167. for (const rs of replaceStr) {
  168. const reg = new RegExp(rs.match, 'gm');
  169. defineStr = defineStr.replace(reg, rs.str);
  170. }
  171. await saveBufferFile(defineStr, file);
  172. };
  173. const exportTableDefine = async function (define) {
  174. const tableDefine = {};
  175. tableDefine.Name = define.name;// '期-清单-全参与人数据表(mem_stage_bills_compare)';
  176. tableDefine.remark = define.remark;
  177. tableDefine.ID = define.id;
  178. tableDefine.key = define.key;
  179. tableDefine.items = [];
  180. tableDefine.prefix = define.prefix;
  181. for (const col of define.cols) {
  182. addFields(tableDefine, col.name, col.field, col.type, col.tag);
  183. }
  184. await saveTableDefine(tableDefine, path.join(savePath, define.key + '.json'));
  185. };
  186. const defines = [stage_bonus, stage_jgcl, stage_other];
  187. for (const d of defines) {
  188. exportTableDefine(d);
  189. }