builder_report_index_define.js 76 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210
  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', 'table_field_define');
  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. // 其他台账
  24. const stage_jgcl = {
  25. name: '期-甲供材料(mem_stage_jgcl)',
  26. remark: '',
  27. id: 30,
  28. key: 'mem_stage_jgcl',
  29. prefix: '期-甲供材料',
  30. cols: [
  31. { name: 'id', field: 'id', type: dataType.int },
  32. { name: 'uuid', field: 'uuid', type: dataType.str },
  33. { name: '名称', field: 'name', type: dataType.str },
  34. { name: '单位', field: 'unit', type: dataType.str },
  35. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  36. { name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 4 } },
  37. { name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency, tag: { type: 'tp' } },
  38. { name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 4 } },
  39. { name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency, tag: { type: 'tp' } },
  40. { name: '材料来源', field: 'source', type: dataType.str },
  41. { name: '单据号', field: 'bills_code', type: dataType.str },
  42. { name: '检验单编号', field: 'check_code', type: dataType.str },
  43. { name: '新增人id', field: 'add_uid', type: dataType.int },
  44. { name: '新增期id', field: 'add_sid', type: dataType.int },
  45. { name: '所属期id', field: 'sid', type: dataType.int },
  46. { name: '期历史记录', field: 'shistory', type: dataType.str },
  47. { name: '排序', field: 'order', type: dataType.int },
  48. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  49. { name: '截止上期到场-数量', field: 'pre_arrive_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 4 } },
  50. { name: '截止上期到场-金额', field: 'pre_arrive_tp', type: dataType.currency, tag: { type: 'tp' } },
  51. { name: '截止上期扣回-数量', field: 'pre_deduct_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 4 } },
  52. { name: '截止上期扣回-金额', field: 'pre_deduct_tp', type: dataType.currency, tag: { type: 'tp' } },
  53. ],
  54. };
  55. const stage_bonus = {
  56. name: '期-奖罚金(mem_stage_bonus)',
  57. remark: '',
  58. id: 31,
  59. key: 'mem_stage_bonus',
  60. prefix: '期-奖罚金',
  61. cols: [
  62. { name: 'id', field: 'id', type: dataType.str },
  63. { name: '所属标段id', field: 'tid', type: dataType.int },
  64. { name: '所属期id', field: 'sid', type: dataType.int },
  65. { name: '所属第几期', field: 'sorder', type: dataType.int },
  66. { name: '新增人id', field: 'uid', type: dataType.int },
  67. { name: '名称', field: 'name', type: dataType.str },
  68. { name: '金额', field: 'tp', type: dataType.currency, tag: { type: 'tp' } },
  69. { name: '证明材料', field: 'proof', type: dataType.str },
  70. { name: '创建时间', field: 'create_time', type: dataType.time },
  71. { name: '时间', field: 'real_time', type: dataType.time },
  72. { name: '备注', field: 'memo', type: dataType.str },
  73. { name: '期历史记录', field: 'shistory', type: dataType.str },
  74. { name: '排序', field: 'order', type: dataType.int },
  75. { name: '编号', field: 'code', type: dataType.str},
  76. { name: '发文单位', field: 'doc_co', type: dataType.str},
  77. { name: '类型', field: 'b_type', type: dataType.str },
  78. ],
  79. };
  80. const stage_other = {
  81. name: '期-其他(mem_stage_other)',
  82. remark: '',
  83. id: 32,
  84. key: 'mem_stage_other',
  85. prefix: '期-其他',
  86. cols: [
  87. { name: 'id', field: 'id', type: dataType.int },
  88. { name: 'uuid', field: 'uuid', type: dataType.str },
  89. { name: '所属标段id', field: 'tid', type: dataType.int },
  90. { name: '所属期id', field: 'sid', type: dataType.int },
  91. { name: '所属第几期', field: 'sorder', type: dataType.int },
  92. { name: '新增人id', field: 'add_uid', type: dataType.int },
  93. { name: '新增期id', field: 'add_sid', type: dataType.int },
  94. { name: '创建时间', field: 'add_time', type: dataType.time },
  95. { name: '名称', field: 'name', type: dataType.str },
  96. { name: '金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  97. { name: '本期金额', field: 'tp', type: dataType.currency, tag: { type: 'tp' } },
  98. { name: '时间', field: 'real_time', type: dataType.time },
  99. { name: '备注', field: 'memo', type: dataType.str },
  100. { name: '期历史记录', field: 'shistory', type: dataType.str },
  101. { name: '排序', field: 'order', type: dataType.int },
  102. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  103. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency, tag: { type: 'tp' } },
  104. { name: '类型', field: 'o_type', type: dataType.str },
  105. ],
  106. };
  107. // 变更令
  108. const change = {
  109. name: '变更令(mem_change)',
  110. remark: '',
  111. id: 33,
  112. key: 'mem_change',
  113. prefix: '变更令',
  114. cols: [
  115. { name: '变更令id', field: 'cid', type: dataType.str },
  116. { name: '变更令号', field: 'code', type: dataType.str },
  117. { name: '批复文号', field: 'w_code', type: dataType.str },
  118. { name: '批复编号', field: 'p_code', type: dataType.str },
  119. { name: '变更名称', field: 'name', type: dataType.str },
  120. { name: '桩号', field: 'peg', type: dataType.str },
  121. { name: '原设计图名称', field: 'org_name', type: dataType.str },
  122. { name: '原图号', field: 'org_code', type: dataType.str },
  123. { name: '变更设计图名称', field: 'new_name', type: dataType.str },
  124. { name: '变更图号', field: 'new_code', type: dataType.str },
  125. { name: '工程变更理由及内容', field: 'content', type: dataType.str },
  126. { name: '工程变更合同依据', field: 'basis', type: dataType.str },
  127. { name: '变更工程量数量计算式', field: 'expr', type: dataType.str },
  128. { name: '备注', field: 'memo', type: dataType.str },
  129. { name: '变更类型', field: 'type', type: dataType.str },
  130. { name: '变更类别', field: 'class', type: dataType.int },
  131. { name: '变更性质', field: 'quality', type: dataType.int },
  132. { name: '变更提出单位', field: 'company', type: dataType.str },
  133. { name: '费用承担方', field: 'charge', type: dataType.int },
  134. { name: '金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  135. { name: '变更状态发生时间(时间戳)', field: 'cin_time', type: dataType.str },
  136. { name: '完成审批时间(时间戳)', field: 'sin—_ime', type: dataType.str },
  137. { name: '金额_1', field: 'tp_1', type: dataType.currency, tag: { type: 'tp' } },
  138. { name: '金额_2', field: 'tp_2', type: dataType.currency, tag: { type: 'tp' } },
  139. { name: '金额_3', field: 'tp_3', type: dataType.currency, tag: { type: 'tp' } },
  140. { name: '金额_4', field: 'tp_4', type: dataType.currency, tag: { type: 'tp' } },
  141. { name: '金额_5', field: 'tp_5', type: dataType.currency, tag: { type: 'tp' } },
  142. { name: '金额_6', field: 'tp_6', type: dataType.currency, tag: { type: 'tp' } },
  143. { name: '金额_7', field: 'tp_7', type: dataType.currency, tag: { type: 'tp' } },
  144. { name: '金额_8', field: 'tp_8', type: dataType.currency, tag: { type: 'tp' } },
  145. { name: '金额_9', field: 'tp_9', type: dataType.currency, tag: { type: 'tp' } },
  146. { name: '附件名称列表', field: 'attNames', type: dataType.currency },
  147. ],
  148. };
  149. const change_bills = {
  150. name: '变更清单(mem_change_bills)',
  151. remark: '',
  152. id: 29,
  153. key: 'mem_change_bills',
  154. prefix: '变更清单',
  155. cols: [
  156. { name: '变更令id', field: 'cid', type: dataType.str },
  157. { name: '签约清单id或台账id', field: 'lid', type: dataType.str },
  158. { name: '清单编号', field: 'code', type: dataType.str },
  159. { name: '名称', field: 'name', type: dataType.str },
  160. { name: '单位', field: 'unit', type: dataType.str },
  161. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  162. { name: '原-数量', field: 'o_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  163. { name: '原-金额', field: 'o_tp', type: dataType.currency, tag: { type: 'tp' } },
  164. { name: '变更-数量', field: 'c_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  165. { name: '变更-金额', field: 'c_tp', type: dataType.currency, tag: { type: 'tp' } },
  166. { name: '审批变更后-数量', field: 's_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  167. { name: '审批变更后-金额', field: 's_tp', type: dataType.currency, tag: { type: 'tp' } },
  168. { name: '部位明细', field: 'bwmx', type: dataType.str },
  169. { name: '变更详情', field: 'detail', type: dataType.str },
  170. { name: '数量_1', field: 'qty_1', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  171. { name: '金额_1', field: 'tp_1', type: dataType.currency, tag: { type: 'tp' } },
  172. { name: '数量_2', field: 'qty_2', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  173. { name: '金额_2', field: 'tp_2', type: dataType.currency, tag: { type: 'tp' } },
  174. { name: '数量_3', field: 'qty_3', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  175. { name: '金额_3', field: 'tp_3', type: dataType.currency, tag: { type: 'tp' } },
  176. { name: '数量_4', field: 'qty_4', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  177. { name: '金额_4', field: 'tp_4', type: dataType.currency, tag: { type: 'tp' } },
  178. { name: '数量_5', field: 'qty_5', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  179. { name: '金额_5', field: 'tp_5', type: dataType.currency, tag: { type: 'tp' } },
  180. { name: '数量_6', field: 'qty_6', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  181. { name: '金额_6', field: 'tp_6', type: dataType.currency, tag: { type: 'tp' } },
  182. { name: '数量_7', field: 'qty_7', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  183. { name: '金额_7', field: 'tp_7', type: dataType.currency, tag: { type: 'tp' } },
  184. { name: '数量_8', field: 'qty_8', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  185. { name: '金额_8', field: 'tp_8', type: dataType.currency, tag: { type: 'tp' } },
  186. { name: '数量_9', field: 'qty_9', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  187. { name: '金额_9', field: 'tp_9', type: dataType.currency, tag: { type: 'tp' } },
  188. ],
  189. };
  190. // 期 - 清单
  191. const stage_bills = {
  192. name: '期-清单 数据表(mem_stage_bills)',
  193. remark: '',
  194. id: 25,
  195. key: 'mem_stage_bills',
  196. prefix: '期-清单',
  197. cols: [
  198. { name: '台账ID', field: 'id', type: dataType.int },
  199. { name: '标段ID', field: 'tender_id', type: dataType.int },
  200. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  201. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  202. { name: '树结构-层级', field: 'level', type: dataType.int },
  203. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  204. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  205. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  206. { name: '项目节编号', field: 'code', type: dataType.str },
  207. { name: '清单编号', field: 'b_code', type: dataType.str },
  208. { name: '名称', field: 'name', type: dataType.str },
  209. { name: '单位', field: 'unit', type: dataType.str }, // 12
  210. { name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'} },
  211. { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  212. { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: {type: 'tp'} },
  213. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  214. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: {type: 'tp'} },
  215. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  216. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: {type: 'tp'} },
  217. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  218. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: {type: 'tp'} },
  219. { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  220. { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'} },
  221. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  222. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  223. { name: '图册号', field: 'drawing_code', type: dataType.str },
  224. { name: '备注', field: 'memo', type: dataType.str },
  225. { name: '节点类型', field: 'node_type', type: dataType.int },
  226. { name: '总额计量', field: 'is_tp', type: dataType.int },
  227. { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  228. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  229. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  230. { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  231. { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  232. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  233. { name: '本期批注', field: 'postil', type: dataType.str },
  234. { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  235. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  236. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  237. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  238. { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  239. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  240. { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  241. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  242. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  243. { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  244. { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  245. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  246. { name: '(台账 + 截止本期变更)-金额', field: 'final_tp', type: dataType.currency, tag: {type: 'tp'} },
  247. { name: '截止本期完成率(%)', field: 'final_ratio', type: dataType.double },
  248. { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },
  249. { name: '章节编号', field: 'chapter', type: dataType.str },
  250. { name: '预留扩展字段_1', field: 'ex_value1', type: dataType.currency },
  251. { name: '预留扩展字段_2', field: 'ex_value2', type: dataType.currency },
  252. { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },
  253. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  254. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  255. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  256. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  257. { name: '合同-设计数量1', field: 'deal_dgn_qty1', type: dataType.currency },
  258. { name: '合同-设计数量2', field: 'deal_dgn_qty2', type: dataType.currency },
  259. { name: '变更-设计数量1', field: 'c_dgn_qty1', type: dataType.currency },
  260. { name: '变更-设计数量2', field: 'c_dgn_qty2', type: dataType.currency },
  261. ],
  262. };
  263. const stage_bills_compare = {
  264. name: '期-清单-全参与人 数据表(mem_stage_bills_compare)',
  265. remark: '',
  266. id: 26,
  267. key: 'mem_stage_bills_compare',
  268. prefix: '期-清单-全参与人',
  269. cols: [
  270. { name: '台账ID', field: 'id', type: dataType.int },
  271. { name: '标段ID', field: 'tender_id', type: dataType.int },
  272. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  273. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  274. { name: '树结构-层级', field: 'level', type: dataType.int },
  275. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  276. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  277. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  278. { name: '项目节编号', field: 'code', type: dataType.str },
  279. { name: '清单编号', field: 'b_code', type: dataType.str },
  280. { name: '名称', field: 'name', type: dataType.str },
  281. { name: '单位', field: 'unit', type: dataType.str }, // 12
  282. { name: '单价', field: 'unit_price', type: dataType.currency, tag: {type: 'up'} },
  283. { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  284. { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: {type: 'tp'} },
  285. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  286. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: {type: 'tp'} },
  287. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  288. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: {type: 'tp'} },
  289. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  290. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: {type: 'tp'} },
  291. { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  292. { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: {type: 'tp'} },
  293. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  294. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  295. { name: '图册号', field: 'drawing_code', type: dataType.str },
  296. { name: '备注', field: 'memo', type: dataType.str },
  297. { name: '节点类型', field: 'node_type', type: dataType.int },
  298. { name: '总额计量', field: 'is_tp', type: dataType.int },
  299. { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  300. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  301. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  302. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  303. { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  304. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  305. { name: '本期-合同-数量_0', field: 'r0_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  306. { name: '本期-合同-金额_0', field: 'r0_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  307. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  308. { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  309. { name: '本期-完成-数量_0', field: 'r0_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  310. { name: '本期-完成-金额_0', field: 'r0_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  311. { name: '本期-合同-数量_1', field: 'r1_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  312. { name: '本期-合同-金额_1', field: 'r1_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  313. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  314. { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  315. { name: '本期-完成-数量_1', field: 'r1_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  316. { name: '本期-完成-金额_1', field: 'r1_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  317. { name: '本期-合同-数量_2', field: 'r2_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  318. { name: '本期-合同-金额_2', field: 'r2_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  319. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  320. { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  321. { name: '本期-完成-数量_2', field: 'r2_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  322. { name: '本期-完成-金额_2', field: 'r2_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  323. { name: '本期-合同-数量_3', field: 'r3_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  324. { name: '本期-合同-金额_3', field: 'r3_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  325. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  326. { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  327. { name: '本期-完成-数量_3', field: 'r3_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  328. { name: '本期-完成-金额_3', field: 'r3_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  329. { name: '本期-合同-数量_4', field: 'r4_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  330. { name: '本期-合同-金额_4', field: 'r4_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  331. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  332. { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  333. { name: '本期-完成-数量_4', field: 'r4_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  334. { name: '本期-完成-金额_4', field: 'r4_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  335. { name: '本期-合同-数量_5', field: 'r5_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  336. { name: '本期-合同-金额_5', field: 'r5_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  337. { name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  338. { name: '本期-数量变更-金额_5', field: 'r5_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  339. { name: '本期-完成-数量_5', field: 'r5_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  340. { name: '本期-完成-金额_5', field: 'r5_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  341. { name: '本期-合同-数量_6', field: 'r6_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  342. { name: '本期-合同-金额_6', field: 'r6_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  343. { name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  344. { name: '本期-数量变更-金额_6', field: 'r6_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  345. { name: '本期-完成-数量_6', field: 'r6_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  346. { name: '本期-完成-金额_6', field: 'r6_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  347. { name: '本期-合同-数量_7', field: 'r7_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  348. { name: '本期-合同-金额_7', field: 'r7_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  349. { name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  350. { name: '本期-数量变更-金额_7', field: 'r7_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  351. { name: '本期-完成-数量_7', field: 'r7_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  352. { name: '本期-完成-金额_7', field: 'r7_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  353. { name: '本期-合同-数量_8', field: 'r8_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  354. { name: '本期-合同-金额_8', field: 'r8_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  355. { name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  356. { name: '本期-数量变更-金额_8', field: 'r8_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  357. { name: '本期-完成-数量_8', field: 'r8_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  358. { name: '本期-完成-金额_8', field: 'r8_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  359. { name: '本期-合同-数量_9', field: 'r9_contract_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  360. { name: '本期-合同-金额_9', field: 'r9_contract_tp', type: dataType.currency, tag: {type: 'tp'} },
  361. { name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  362. { name: '本期-数量变更-金额_9', field: 'r9_qc_tp', type: dataType.currency, tag: {type: 'tp'} },
  363. { name: '本期-完成-数量_9', field: 'r9_gather_qty', type: dataType.currency, tag: {type: 'qty', unitKey: 12} },
  364. { name: '本期-完成-金额_9', field: 'r9_gather_tp', type: dataType.currency, tag: {type: 'tp'} },
  365. { name: '章节编号', field: 'chapter', type: dataType.str },
  366. { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },
  367. ],
  368. };
  369. // 期 - 计量单元
  370. const stage_pos = {
  371. name: '期-计量单元(mem_stage_pos)',
  372. remark: '',
  373. id: 34,
  374. key: 'mem_stage_pos',
  375. prefix: '期-计量单元',
  376. cols: [
  377. { name: 'id', field: 'id', type: dataType.str },
  378. { name: '所属标段id', field: 'tid', type: dataType.int },
  379. { name: '所属清单id', field: 'lid', type: dataType.str },
  380. { name: '名称', field: 'name', type: dataType.str },
  381. { name: '位置', field: 'position', type: dataType.str },
  382. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  383. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  384. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  385. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  386. { name: '图号', field: 'drawing_code', type: dataType.str },
  387. { name: '排序', field: 'p_order', type: dataType.str },
  388. { name: '本期-合同计量-数量', field: 'contract_qty', type: dataType.currency },
  389. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
  390. { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },
  391. { name: '本期-完成计量-数量', field: 'gather_qty', type: dataType.currency },
  392. { name: '本期批注', field: 'postil', type: dataType.str },
  393. { name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency },
  394. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  395. { name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency },
  396. { name: '截止本期-合同计量-数量', field: 'end_contract_qty', type: dataType.currency },
  397. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
  398. { name: '截止本期-完成计量-数量', field: 'end_gather_qty', type: dataType.currency },
  399. { name: '截止本期-完成率', field: 'final_ratio', type: dataType.currency },
  400. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  401. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  402. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  403. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  404. ],
  405. };
  406. const stage_pos_compare = {
  407. name: '期-计量单元-全参与人(mem_stage_pos_compare)',
  408. remark: '',
  409. id: 35,
  410. key: 'mem_stage_pos_compare',
  411. prefix: '期-计量单元-全参与人',
  412. cols: [
  413. { name: 'id', field: 'id', type: dataType.str },
  414. { name: '所属标段id', field: 'tid', type: dataType.int },
  415. { name: '所属清单id', field: 'lid', type: dataType.str },
  416. { name: '名称', field: 'name', type: dataType.str },
  417. { name: '位置', field: 'position', type: dataType.str },
  418. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  419. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  420. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  421. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  422. { name: '图号', field: 'drawing_code', type: dataType.str },
  423. { name: '排序', field: 'p_order', type: dataType.str },
  424. { name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency },
  425. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  426. { name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency },
  427. { name: '本期-合同计量-数量_0', field: 'r0_contract_qty', type: dataType.currency },
  428. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
  429. { name: '本期-完成计量-数量_0', field: 'r0_gather_qty', type: dataType.currency },
  430. { name: '本期-合同计量-数量_1', field: 'r1_contract_qty', type: dataType.currency },
  431. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
  432. { name: '本期-完成计量-数量_1', field: 'r1_gather_qty', type: dataType.currency },
  433. { name: '本期-合同计量-数量_2', field: 'r2_contract_qty', type: dataType.currency },
  434. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
  435. { name: '本期-完成计量-数量_2', field: 'r2_gather_qty', type: dataType.currency },
  436. { name: '本期-合同计量-数量_3', field: 'r3_contract_qty', type: dataType.currency },
  437. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
  438. { name: '本期-完成计量-数量_3', field: 'r3_gather_qty', type: dataType.currency },
  439. { name: '本期-合同计量-数量_4', field: 'r4_contract_qty', type: dataType.currency },
  440. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
  441. { name: '本期-完成计量-数量_4', field: 'r4_gather_qty', type: dataType.currency },
  442. { name: '本期-合同计量-数量_5', field: 'r5_contract_qty', type: dataType.currency },
  443. { name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency },
  444. { name: '本期-完成计量-数量_5', field: 'r5_gather_qty', type: dataType.currency },
  445. { name: '本期-合同计量-数量_6', field: 'r6_contract_qty', type: dataType.currency },
  446. { name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency },
  447. { name: '本期-完成计量-数量_6', field: 'r6_gather_qty', type: dataType.currency },
  448. { name: '本期-合同计量-数量_7', field: 'r7_contract_qty', type: dataType.currency },
  449. { name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency },
  450. { name: '本期-完成计量-数量_7', field: 'r7_gather_qty', type: dataType.currency },
  451. { name: '本期-合同计量-数量_8', field: 'r8_contract_qty', type: dataType.currency },
  452. { name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency },
  453. { name: '本期-完成计量-数量_8', field: 'r8_gather_qty', type: dataType.currency },
  454. { name: '本期-合同计量-数量_9', field: 'r9_contract_qty', type: dataType.currency },
  455. { name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency },
  456. { name: '本期-完成计量-数量_9', field: 'r9_gather_qty', type: dataType.currency },
  457. ],
  458. };
  459. // 工程进度
  460. const month_progress = {
  461. name: '工程进度 数据表(mem_month_progress)',
  462. remark: '',
  463. id: 22,
  464. key: 'mem_month_progress',
  465. prefix: '工程进度',
  466. cols: [
  467. { name: '计量年月', field: 'month', type: dataType.str },
  468. { name: '本月计量', field: 'tp', type: dataType.currency, tag: {type: 'tp'} },
  469. { name: '本月完成度', field: 'ratio', type: dataType.double },
  470. { name: '累计计量', field: 'end_tp', type: dataType.currency, tag: {type: 'tp'} },
  471. { name: '累计完成度', field: 'end_ratio', type: dataType.double },
  472. ],
  473. };
  474. // 预留扩展数据
  475. const union_data = {
  476. name: '预留扩展-合并 数据表(mem_union_data)',
  477. remark: '',
  478. id: 28,
  479. key: 'mem_union_data',
  480. prefix: '预留扩展-合并',
  481. cols: [
  482. { name: '字符串1', field: 'str1', type: dataType.str },
  483. { name: '字符串2', field: 'str2', type: dataType.str },
  484. { name: '字符串3', field: 'str3', type: dataType.str },
  485. { name: '字符串4', field: 'str4', type: dataType.str },
  486. { name: '字符串5', field: 'str5', type: dataType.str },
  487. { name: '字符串6', field: 'str6', type: dataType.str },
  488. { name: '字符串7', field: 'str7', type: dataType.str },
  489. { name: '字符串8', field: 'str8', type: dataType.str },
  490. { name: '字符串9', field: 'str9', type: dataType.str },
  491. { name: '字符串10', field: 'str10', type: dataType.str },
  492. { name: '整数1', field: 'int1', type: dataType.int },
  493. { name: '整数2', field: 'int2', type: dataType.int },
  494. { name: '整数3', field: 'int3', type: dataType.int },
  495. { name: '整数4', field: 'int4', type: dataType.int },
  496. { name: '整数5', field: 'int5', type: dataType.int },
  497. { name: '整数6', field: 'int6', type: dataType.int },
  498. { name: '数量1', field: 'qty1', type: dataType.currency },
  499. { name: '数量2', field: 'qty2', type: dataType.currency },
  500. { name: '数量3', field: 'qty3', type: dataType.currency },
  501. { name: '数量4', field: 'qty4', type: dataType.currency },
  502. { name: '数量5', field: 'qty5', type: dataType.currency },
  503. { name: '数量6', field: 'qty6', type: dataType.currency },
  504. { name: '数量7', field: 'qty7', type: dataType.currency },
  505. { name: '数量8', field: 'qty8', type: dataType.currency },
  506. { name: '数量9', field: 'qty9', type: dataType.currency },
  507. { name: '数量10', field: 'qty10', type: dataType.currency },
  508. { name: '金额1', field: 'tp1', type: dataType.currency },
  509. { name: '金额2', field: 'tp2', type: dataType.currency },
  510. { name: '金额3', field: 'tp3', type: dataType.currency },
  511. { name: '金额4', field: 'tp4', type: dataType.currency },
  512. { name: '金额5', field: 'tp5', type: dataType.currency },
  513. { name: '金额6', field: 'tp6', type: dataType.currency },
  514. { name: '金额7', field: 'tp7', type: dataType.currency },
  515. { name: '金额8', field: 'tp8', type: dataType.currency },
  516. { name: '金额9', field: 'tp9', type: dataType.currency },
  517. { name: '金额10', field: 'tp10', type: dataType.currency },
  518. ],
  519. };
  520. // 期 - 合同支付
  521. const stage_pay = {
  522. name: '期-合同支付-数据(mem_stage_pay)',
  523. remark: '',
  524. id: 27,
  525. key: 'mem_stage_pay',
  526. prefix: '期-合同支付',
  527. cols: [
  528. { name: '名称', field: 'name', type: dataType.str },
  529. { name: '计算公式', field: 'expr', type: dataType.str },
  530. { name: '金额', field: 'tp', type: dataType.currency },
  531. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
  532. { name: '截止上期-金额', field: 'end_tp', type: dataType.currency },
  533. { name: '排序', field: 'order', type: dataType.int },
  534. { name: '是否扣款项', field: 'minus', type: dataType.int },
  535. { name: '支付类型', field: 'ptype', type: dataType.int },
  536. { name: '起扣金额', field: 'sprice', type: dataType.currency },
  537. { name: '扣款限额', field: 'rprice', type: dataType.currency },
  538. { name: '流程-本期-金额_0', field: 'r0_tp', type: dataType.currency },
  539. { name: '流程-本期-金额_1', field: 'r1_tp', type: dataType.currency },
  540. { name: '流程-本期-金额_2', field: 'r2_tp', type: dataType.currency },
  541. { name: '流程-本期-金额_3', field: 'r3_tp', type: dataType.currency },
  542. { name: '流程-本期-金额_4', field: 'r4_tp', type: dataType.currency },
  543. { name: '流程-本期-金额_5', field: 'r5_tp', type: dataType.currency },
  544. { name: '流程-本期-金额_6', field: 'r6_tp', type: dataType.currency },
  545. { name: '流程-本期-金额_7', field: 'r7_tp', type: dataType.currency },
  546. { name: '流程-本期-金额_8', field: 'r8_tp', type: dataType.currency },
  547. { name: '流程-本期-金额_9', field: 'r9_tp', type: dataType.currency },
  548. { name: '第几期开始计量', field: 'start_stage_order', type: dataType.int },
  549. ],
  550. };
  551. // 期 - 中间计量
  552. const stage_im_zl = {
  553. name: '期-中间计量-总量-数据(mem_stage_im_zl)',
  554. remark: '',
  555. id: 21,
  556. key: 'mem_stage_im_zl',
  557. prefix: '期-中间计量-总量',
  558. cols: [
  559. { name: '台账id', field: 'lid', type: dataType.str },
  560. { name: '部位id', field: 'pid', type: dataType.str },
  561. { name: '编号', field: 'code', type: dataType.str },
  562. { name: '名称', field: 'name', type: dataType.str },
  563. { name: '单位', field: 'unit', type: dataType.str },
  564. { name: '单价', field: 'unit_price', type: dataType.currency },
  565. { name: '本期数量', field: 'jl', type: dataType.currency },
  566. { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
  567. { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
  568. { name: '桩号', field: 'peg', type: dataType.str },
  569. { name: '图册号', field: 'drawing_code', type: dataType.str },
  570. { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
  571. { name: '部位', field: 'bw', type: dataType.str },
  572. { name: '细目', field: 'xm', type: dataType.str },
  573. { name: '凭证号', field: 'doc_code', type: dataType.str },
  574. { name: '计算式说明', field: 'calc_memo', type: dataType.str },
  575. { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
  576. { name: '变更令号', field: 'bgl_code', type: dataType.str },
  577. { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
  578. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  579. { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
  580. { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
  581. { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
  582. { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
  583. { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
  584. { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
  585. { name: '本期金额', field: 'tp', type: dataType.currency },
  586. { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
  587. { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
  588. { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  589. { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  590. { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  591. { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  592. { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  593. { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  594. { name: '台账数量', field: 'quantity', type: dataType.currency },
  595. { name: '台账金额', field: 'total_price', type: dataType.currency },
  596. { name: '位置', field: 'position', type: dataType.str },
  597. { name: '计量单元', field: 'jldy', type: dataType.str },
  598. ],
  599. };
  600. const stage_im_tz = {
  601. name: '期-中间计量-台账-数据(mem_stage_im_tz)',
  602. remark: '',
  603. id: 19,
  604. key: 'mem_stage_im_tz',
  605. prefix: '期-中间计量-台账',
  606. cols: [
  607. { name: 'id', field: 'id', type: dataType.int },
  608. { name: '台账id', field: 'lid', type: dataType.str },
  609. { name: '部位id', field: 'pid', type: dataType.str },
  610. { name: '编号', field: 'code', type: dataType.str },
  611. { name: '本期金额', field: 'jl', type: dataType.currency },
  612. { name: '本期合同金额', field: 'contract_jl', type: dataType.currency },
  613. { name: '本期变更金额', field: 'qc_jl', type: dataType.currency },
  614. { name: '桩号', field: 'peg', type: dataType.str },
  615. { name: '图册号', field: 'drawing_code', type: dataType.str },
  616. { name: '部位', field: 'bw', type: dataType.str },
  617. { name: '细目', field: 'xm', type: dataType.str },
  618. { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
  619. { name: '计算式说明', field: 'calc_memo', type: dataType.str },
  620. { name: '变更令号', field: 'bgl_code', type: dataType.str },
  621. { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
  622. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  623. { name: '凭证号', field: 'doc_code', type: dataType.str },
  624. { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
  625. { name: '截止上期 - 金额', field: 'pre_jl', type: dataType.currency },
  626. { name: '截止上期 - 合同金额', field: 'pre_contract_jl', type: dataType.currency },
  627. { name: '截止上期 - 变更金额', field: 'pre_qc_jl', type: dataType.currency },
  628. { name: '截止本期 - 金额', field: 'end_jl', type: dataType.currency },
  629. { name: '截止本期 - 合同金额', field: 'end_contract_jl', type: dataType.currency },
  630. { name: '截止本期 - 变更金额', field: 'end_qc_jl', type: dataType.currency },
  631. { name: '位置', field: 'position', type: dataType.str },
  632. { name: '计量单元', field: 'jldy', type: dataType.str },
  633. ],
  634. };
  635. const stage_im_tz_bills = {
  636. name: '期-中间计量-台账清单-数据(mem_stage_im_tz_bills)',
  637. remark: '',
  638. id: 20,
  639. key: 'mem_stage_im_tz_bills',
  640. prefix: '期-中间计量-台账清单',
  641. cols: [
  642. { name: '中间计量id', field: 'imid', type: dataType.int },
  643. { name: '清单id', field: 'bid', type: dataType.str },
  644. { name: '清单编号', field: 'b_code', type: dataType.str },
  645. { name: '名称', field: 'name', type: dataType.str },
  646. { name: '单位', field: 'unit', type: dataType.str },
  647. { name: '单价', field: 'unit_price', type: dataType.currency },
  648. { name: '本期数量', field: 'jl', type: dataType.currency },
  649. { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
  650. { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
  651. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  652. { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
  653. { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
  654. { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
  655. { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
  656. { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
  657. { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
  658. { name: '本期金额', field: 'tp', type: dataType.currency },
  659. { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
  660. { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
  661. { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  662. { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  663. { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  664. { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  665. { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  666. { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  667. { name: '台账数量', field: 'quantity', type: dataType.currency },
  668. { name: '台账金额', field: 'total_price', type: dataType.currency },
  669. ],
  670. };
  671. const gather_stage_bills = {
  672. name: '汇总-清单数据表(mem_gather_stage_bills)',
  673. remark: '',
  674. id: 36,
  675. key: 'mem_gather_stage_bills',
  676. prefix: '汇总-清单数据',
  677. cols: [
  678. { name: '项目节编号', field: 'code', type: dataType.str },
  679. { name: '清单编号', field: 'b_code', type: dataType.str },
  680. { name: '名称', field: 'name', type: dataType.str },
  681. { name: '单位', field: 'unit', type: dataType.str },
  682. { name: '单价', field: 'unit_price', type: dataType.currency },
  683. { name: '标段id', field: 't_id', type: dataType.int },
  684. { name: '标段-名称', field: 't_name', type: dataType.str },
  685. { name: '(标段)台账-数量', field: 't_qty', type: dataType.currency },
  686. { name: '(标段)台账-金额', field: 't_tp', type: dataType.currency },
  687. { name: '(标段)本期-合同-数量', field: 't_contract_qty', type: dataType.currency },
  688. { name: '(标段)本期-合同-金额', field: 't_contract_tp', type: dataType.currency },
  689. { name: '(标段)本期-变更-数量', field: 't_qc_qty', type: dataType.currency },
  690. { name: '(标段)本期-变更-金额', field: 't_qc_tp', type: dataType.currency },
  691. { name: '(标段)本期-完成-数量', field: 't_gather_qty', type: dataType.currency },
  692. { name: '(标段)本期-完成-金额', field: 't_gather_tp', type: dataType.currency },
  693. { name: '(标段)截止上期-合同-数量', field: 't_pre_contract_qty', type: dataType.currency },
  694. { name: '(标段)截止上期-合同-金额', field: 't_pre_contract_tp', type: dataType.currency },
  695. { name: '(标段)截止上期-变更-数量', field: 't_pre_qc_qty', type: dataType.currency },
  696. { name: '(标段)截止上期-变更-金额', field: 't_pre_qc_tp', type: dataType.currency },
  697. { name: '(标段)截止上期-完成-数量', field: 't_pre_gather_qty', type: dataType.currency },
  698. { name: '(标段)截止上期-完成-金额', field: 't_pre_gather_tp', type: dataType.currency },
  699. { name: '(标段)截止本期-合同-数量', field: 't_end_contract_qty', type: dataType.currency },
  700. { name: '(标段)截止本期-合同-金额', field: 't_end_contract_tp', type: dataType.currency },
  701. { name: '(标段)截止本期-变更-数量', field: 't_end_qc_qty', type: dataType.currency },
  702. { name: '(标段)截止本期-变更-金额', field: 't_end_qc_tp', type: dataType.currency },
  703. { name: '(标段)截止本期-完成-数量', field: 't_end_gather_qty', type: dataType.currency },
  704. { name: '(标段)截止本期-完成-金额', field: 't_end_gather_tp', type: dataType.currency },
  705. { name: '(合计)台账-数量', field: 's_qty', type: dataType.currency },
  706. { name: '(合计)台账-金额', field: 's_tp', type: dataType.currency },
  707. { name: '(合计)本期-合同-数量', field: 's_contract_qty', type: dataType.currency },
  708. { name: '(合计)本期-合同-金额', field: 's_contract_tp', type: dataType.currency },
  709. { name: '(合计)本期-变更-数量', field: 's_qc_qty', type: dataType.currency },
  710. { name: '(合计)本期-变更-金额', field: 's_qc_tp', type: dataType.currency },
  711. { name: '(合计)本期-完成-数量', field: 's_gather_qty', type: dataType.currency },
  712. { name: '(合计)本期-完成-金额', field: 's_gather_tp', type: dataType.currency },
  713. { name: '(合计)截止上期-合同-数量', field: 's_pre_contract_qty', type: dataType.currency },
  714. { name: '(合计)截止上期-合同-金额', field: 's_pre_contract_tp', type: dataType.currency },
  715. { name: '(合计)截止上期-变更-数量', field: 's_pre_qc_qty', type: dataType.currency },
  716. { name: '(合计)截止上期-变更-金额', field: 's_pre_qc_tp', type: dataType.currency },
  717. { name: '(合计)截止上期-完成-数量', field: 's_pre_gather_qty', type: dataType.currency },
  718. { name: '(合计)截止上期-完成-金额', field: 's_pre_gather_tp', type: dataType.currency },
  719. { name: '(合计)截止本期-合同-数量', field: 's_end_contract_qty', type: dataType.currency },
  720. { name: '(合计)截止本期-合同-金额', field: 's_end_contract_tp', type: dataType.currency },
  721. { name: '(合计)截止本期-变更-数量', field: 's_end_qc_qty', type: dataType.currency },
  722. { name: '(合计)截止本期-变更-金额', field: 's_end_qc_tp', type: dataType.currency },
  723. { name: '(合计)截止本期-完成-数量', field: 's_end_gather_qty', type: dataType.currency },
  724. { name: '(合计)截止本期-完成-金额', field: 's_end_gather_tp', type: dataType.currency },
  725. { name: '(特殊1-需替换key1)台账-数量', field: 'ts_key1_qty', type: dataType.currency },
  726. { name: '(特殊1-需替换key1)台账-金额', field: 'ts_key1_tp', type: dataType.currency },
  727. { name: '(特殊2-需替换key2)台账-数量', field: 'ts_key2_qty', type: dataType.currency },
  728. { name: '(特殊2-需替换key2)台账-金额', field: 'ts_key2_tp', type: dataType.currency },
  729. { name: '(特殊3-需替换key3)台账-数量', field: 'ts_key3_qty', type: dataType.currency },
  730. { name: '(特殊3-需替换key3)台账-金额', field: 'ts_key3_tp', type: dataType.currency },
  731. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  732. { name: '树结构-id', field: 'id', type: dataType.int },
  733. { name: '树结构-父项id', field: 'pid', type: dataType.int },
  734. { name: '树结构-层次', field: 'level', type: dataType.int },
  735. { name: '树结构-排序', field: 'order', type: dataType.int },
  736. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  737. { name: '(特殊1-需替换key1)台账-设计数量1', field: 'ts_key1_dgn_qty1', type: dataType.currency },
  738. { name: '(特殊1-需替换key1)台账-设计数量2', field: 'ts_key1_dgn_qty2', type: dataType.currency },
  739. { name: '(特殊2-需替换key2)台账-设计数量1', field: 'ts_key2_dgn_qty1', type: dataType.currency },
  740. { name: '(特殊2-需替换key2)台账-设计数量2', field: 'ts_key2_dgn_qty2', type: dataType.currency },
  741. { name: '(特殊3-需替换key3)台账-设计数量1', field: 'ts_key3_dgn_qty1', type: dataType.currency },
  742. { name: '(特殊3-需替换key3)台账-设计数量2', field: 'ts_key3_dgn_qty2', type: dataType.currency },
  743. { name: '(标段)台账-设计数量1', field: 't_dgn_qty1', type: dataType.currency },
  744. { name: '(标段)台账-设计数量2', field: 't_dgn_qty2', type: dataType.currency },
  745. { name: '(标段)合同-设计数量1', field: 't_deal_dgn_qty1', type: dataType.currency },
  746. { name: '(标段)合同-设计数量2', field: 't_deal_dgn_qty2', type: dataType.currency },
  747. { name: '(标段)变更-设计数量1', field: 't_c_dgn_qty1', type: dataType.currency },
  748. { name: '(标段)变更-设计数量2', field: 't_c_dgn_qty2', type: dataType.currency },
  749. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int },
  750. ],
  751. };
  752. const gather_tender_info = {
  753. name: '汇总-标段信息(mem_gather_tender_info)',
  754. remark: '',
  755. id: 37,
  756. key: 'mem_gather_tender_info',
  757. prefix: '汇总-标段信息',
  758. cols: [
  759. { name: 'id', field: 'id', type: dataType.int},
  760. { name: '名称', field: 'name', type: dataType.str },
  761. { name: '是否特殊标', field: 'spec', type: dataType.str },
  762. { name: '台账-金额', field: 'tp', type: dataType.currency },
  763. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  764. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
  765. { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
  766. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
  767. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency },
  768. { name: '截止上期-变更-金额', field: 'pre_qc_tp', type: dataType.currency },
  769. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency },
  770. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
  771. { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
  772. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
  773. { name: '截止上期-应付', field: 'pre_yf_tp', type: dataType.currency },
  774. { name: '本期-应付', field: 'yf_tp', type: dataType.currency },
  775. { name: '截止本期-应付', field: 'end_yf_tp', type: dataType.currency },
  776. { name: '签约清单-金额', field: 'deal_bills_tp', type: dataType.currency },
  777. { name: '合同信息-建设项目名称', field: 'deal_info.buildName', type: dataType.str},
  778. { name: '合同信息-合同编号', field: 'deal_info.dealCode', type: dataType.str},
  779. { name: '合同信息-合同名称', field: 'deal_info.dealName', type: dataType.str},
  780. { name: '参建单位-建设单位-单位名称', field: 'construction_unit.build.company', type: dataType.str},
  781. { name: '参建单位-建设单位-法人代表', field: 'construction_unit.build.corporation', type: dataType.str},
  782. { name: '参建单位-建设单位-签订日期', field: 'construction_unit.build.date', type: dataType.str},
  783. { name: '参建单位-承包单位1-单位名称', field: 'construction_unit.contract1.company', type: dataType.str},
  784. { name: '参建单位-承包单位1-法人代表', field: 'construction_unit.contract1.corporation', type: dataType.str},
  785. { name: '参建单位-承包单位1-签订日期', field: 'construction_unit.contract1.date', type: dataType.str},
  786. { name: '参建单位-承包单位2-单位名称', field: 'construction_unit.contract2.company', type: dataType.str},
  787. { name: '参建单位-承包单位2-法人代表', field: 'construction_unit.contract2.corporation', type: dataType.str},
  788. { name: '参建单位-承包单位2-签订日期', field: 'construction_unit.contract2.date', type: dataType.str},
  789. { name: '参建单位-监理单位1-单位名称', field: 'construction_unit.supervision1.company', type: dataType.str},
  790. { name: '参建单位-监理单位1-法人代表', field: 'construction_unit.supervision1.corporation', type: dataType.str},
  791. { name: '参建单位-监理单位1-签订日期', field: 'construction_unit.supervision1.date', type: dataType.str},
  792. { name: '参建单位-监理单位2-单位名称', field: 'construction_unit.supervision2.company', type: dataType.str},
  793. { name: '参建单位-监理单位2-法人代表', field: 'construction_unit.supervision2.corporation', type: dataType.str},
  794. { name: '参建单位-监理单位2-签订日期', field: 'construction_unit.supervision2.date', type: dataType.str},
  795. { name: '技术参数-公路等级', field: 'tech_param.loadLevel', type: dataType.int},
  796. { name: '技术参数-长度(KM)', field: 'tech_param.loadLength', type: dataType.int},
  797. { name: '技术参数-起始桩号', field: 'tech_param.startPeg', type: dataType.str},
  798. { name: '技术参数-终止桩号', field: 'tech_param.endPeg', type: dataType.str},
  799. { name: '技术参数-车道数', field: 'tech_param.laneCount', type: dataType.int},
  800. { name: '技术参数-合同工期', field: 'tech_param.dealPeriod', type: dataType.str},
  801. { name: '技术参数-开工日期', field: 'tech_param.startDate', type: dataType.str},
  802. { name: '技术参数-计划完工日期', field: 'tech_param.planEndDate', type: dataType.str},
  803. { name: '合同参数-签约合同价', field: 'deal_param.contractPrice', type: dataType.currency },
  804. { name: '合同参数-暂列金额', field: 'deal_param.zanLiePrice', type: dataType.currency },
  805. { name: '合同参数-签约合同价(不含暂列金额)', field: 'deal_param.contractPriceWithoutZL', type: dataType.currency },
  806. { name: '合同参数-签约开工预付款', field: 'deal_param.startAdvance', type: dataType.currency },
  807. { name: '合同参数-签约材料预付款', field: 'deal_param.materialAdvance', type: dataType.currency },
  808. { name: '付款账号-工程款账户-开户名称', field: 'pay_account.project.name', type: dataType.str },
  809. { name: '付款账号-工程款账户-开户银行', field: 'pay_account.project.bank', type: dataType.str },
  810. { name: '付款账号-工程款账户-开户账号', field: 'pay_account.project.account', type: dataType.str },
  811. { name: '付款账号-工程款账户-分账划拨比例(%)', field: 'pay_account.project.rate', type: dataType.str },
  812. { name: '付款账号-工程款账户-联系人', field: 'pay_account.project.contact', type: dataType.str },
  813. { name: '付款账号-工程款账户-联系电话', field: 'pay_account.project.phone', type: dataType.str },
  814. { name: '付款账号-农民工工资专用账户-开户名称', field: 'pay_account.worker.name', type: dataType.str },
  815. { name: '付款账号-农民工工资专用账户-开户银行', field: 'pay_account.worker.bank', type: dataType.str },
  816. { name: '付款账号-农民工工资专用账户-开户账号', field: 'pay_account.worker.account', type: dataType.str },
  817. { name: '付款账号-农民工工资专用账户-分账划拨比例(%)', field: 'pay_account.worker.rate', type: dataType.str },
  818. { name: '付款账号-农民工工资专用账户-联系人', field: 'pay_account.worker.contact', type: dataType.str },
  819. { name: '付款账号-农民工工资专用账户-联系电话', field: 'pay_account.worker.phone', type: dataType.str },
  820. ],
  821. };
  822. const gather_stage_pay = {
  823. name: '汇总-期-合同支付 数据表(mem_gather_stage_pay)',
  824. remark: '',
  825. id: 38,
  826. key: 'mem_gather_stage_pay',
  827. prefix: '汇总-期-合同支付',
  828. cols: [
  829. { name: '名称', field: 'name', type: dataType.str },
  830. { name: '类型', field: 'ptype', type: dataType.int },
  831. { name: '是否扣款项', field: 'minus', type: dataType.int },
  832. { name: '是否参与本期应付计算', field: 'is_yf', type: dataType.int },
  833. { name: '标段id', field: 't_id', type: dataType.int },
  834. { name: '标段-名称', field: 't_name', type: dataType.str },
  835. { name: '(标段)本期-金额', field: 't_tp', type: dataType.currency },
  836. { name: '(标段)截止上期-金额', field: 't_pre_tp', type: dataType.currency },
  837. { name: '(标段)截止本期-金额', field: 't_end_tp', type: dataType.currency },
  838. { name: '(合计)本期-金额', field: 's_tp', type: dataType.currency },
  839. { name: '(合计)截止上期-金额', field: 's_pre_tp', type: dataType.currency },
  840. { name: '(合计)截止本期-金额', field: 's_end_tp', type: dataType.currency },
  841. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  842. ],
  843. };
  844. const gather_deal_bills = {
  845. name: '汇总-签约清单 数据表(mem_gather_deal_bills)',
  846. remark: '',
  847. id: 39,
  848. key: 'mem_gather_deal_bills',
  849. prefix: '汇总-签约清单',
  850. cols: [
  851. { name: '编号', field: 'code', type: dataType.str },
  852. { name: '名称', field: 'name', type: dataType.str },
  853. { name: '单位', field: 'unit', type: dataType.str },
  854. { name: '单价', field: 'unit_price', type: dataType.currency },
  855. { name: '标段id', field: 't_id', type: dataType.int },
  856. { name: '标段-名称', field: 't_name', type: dataType.str },
  857. { name: '(标段)金额', field: 't_tp', type: dataType.currency },
  858. { name: '(合计)金额', field: 's_tp', type: dataType.currency },
  859. { name: '(特殊1)金额', field: 'ts_key1_tp', type: dataType.currency },
  860. { name: '(特殊2)金额', field: 'ts_key2_tp', type: dataType.currency },
  861. { name: '(特殊3)金额', field: 'ts_key3_tp', type: dataType.currency },
  862. { name: '(标段)数量', field: 't_qty', type: dataType.currency },
  863. { name: '(合计)数量', field: 's_qty', type: dataType.currency },
  864. { name: '(特殊1)数量', field: 'ts_key1_qty', type: dataType.currency },
  865. { name: '(特殊2)数量', field: 'ts_key2_qty', type: dataType.currency },
  866. { name: '(特殊3)数量', field: 'ts_key3_qty', type: dataType.currency },
  867. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  868. ],
  869. };
  870. // 材差
  871. const material = {
  872. name: '材料调差-期列表-数据(mem_material)',
  873. remark: '',
  874. id: 40,
  875. key: 'mem_material',
  876. prefix: '材料调差-期列表',
  877. cols: [
  878. { name: 'id', field: 'id', type: dataType.int },
  879. { name: '标段id', field: 'tid', type: dataType.int },
  880. { name: '创建者id', field: 'user_id', type: dataType.int },
  881. { name: '审批次数', field: 'times', type: dataType.int },
  882. { name: '审批状态', field: 'status', type: dataType.int },
  883. { name: '期id列表', field: 'stage_id', type: dataType.str },
  884. { name: '期order列表', field: 's_order', type: dataType.str },
  885. { name: '材料调差期数', field: 'order', type: dataType.int },
  886. { name: '本期金额', field: 'm_tp', type: dataType.currency },
  887. { name: '截止上期金额', field: 'pre_tp', type: dataType.currency },
  888. { name: '税率', field: 'rate', type: dataType.int },
  889. { name: '创建时间', field: 'in_time', type: dataType.str },
  890. ],
  891. };
  892. const materialGl = {
  893. name: '材料调差-期-调差工料-数据(mem_material_gl)',
  894. remark: '',
  895. id: 41,
  896. key: 'mem_material_gl',
  897. prefix: '材料调差-期-调差工料',
  898. cols: [
  899. { name: 'id', field: 'id', type: dataType.int },
  900. { name: '标段id', field: 'tid', type: dataType.int },
  901. { name: '创建期id', field: 'mid', type: dataType.int },
  902. { name: '调差类型', field: 't_type', type: dataType.int },
  903. { name: '调差类型s', field: 't_type_str', type: dataType.str },
  904. { name: '工料分类', field: 'm_type', type: dataType.int },
  905. { name: '工料分类s', field: 'm_type_str', type: dataType.str },
  906. { name: '编号', field: 'code', type: dataType.str },
  907. { name: '名称', field: 'name', type: dataType.str },
  908. { name: '单位', field: 'unit', type: dataType.str },
  909. { name: '规格', field: 'spec', type: dataType.str },
  910. { name: '基准价', field: 'basic_price', type: dataType.currency },
  911. { name: '基准时间', field: 'basic_time', type: dataType.str },
  912. { name: '本期信息价-单价', field: 'msg_tp', type: dataType.currency },
  913. { name: '本期信息价-时间', field: 'msg_times', type: dataType.str },
  914. { name: '本期信息价-价差', field: 'msg_spread', type: dataType.currency },
  915. { name: '本期材料调差-上涨幅度', field: 'm_up_risk', type: dataType.int },
  916. { name: '本期材料调差-下跌幅度', field: 'm_down_risk', type: dataType.int },
  917. { name: '本期材料调差-有效价差', field: 'm_spread', type: dataType.currency },
  918. { name: '本期应耗数据', field: 'quantity', type: dataType.currency },
  919. { name: '计算式', field: 'expr', type: dataType.str },
  920. { name: '本期-调差金额', field: 'tp', type: dataType.currency },
  921. { name: '截止上期-调差金额', field: 'pre_tp', type: dataType.currency },
  922. { name: '截止本期-调差金额', field: 'end_tp', type: dataType.currency },
  923. { name: '创建时间', field: 'in_time', type: dataType.str },
  924. { name: '备注', field: 'remark', type: dataType.str },
  925. ],
  926. };
  927. const sum_stage_bills = {
  928. name: '期汇总-清单数据表(mem_sum_stage_bills)',
  929. remark: '',
  930. id: 42,
  931. key: 'mem_sum_stage_bills',
  932. prefix: '期汇总-清单数据',
  933. cols: [
  934. { name: '台账ID', field: 'id', type: dataType.int },
  935. { name: '标段ID', field: 'tender_id', type: dataType.int },
  936. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  937. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  938. { name: '树结构-层级', field: 'level', type: dataType.int },
  939. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  940. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  941. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  942. { name: '项目节编号', field: 'code', type: dataType.str },
  943. { name: '清单编号', field: 'b_code', type: dataType.str },
  944. { name: '名称', field: 'name', type: dataType.str },
  945. { name: '单位', field: 'unit', type: dataType.str }, // 12
  946. { name: '单价', field: 'unit_price', type: dataType.currency },
  947. { name: '签约-数量', field: 'deal_qty', type: dataType.currency },
  948. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  949. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  950. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency },
  951. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  952. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency },
  953. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  954. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency },
  955. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  956. { name: '台账-金额', field: 'total_price', type: dataType.currency },
  957. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  958. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  959. { name: '图册号', field: 'drawing_code', type: dataType.str },
  960. { name: '备注', field: 'memo', type: dataType.str },
  961. { name: '节点类型', field: 'node_type', type: dataType.int },
  962. { name: '总额计量', field: 'is_tp', type: dataType.int },
  963. { name: '第1期-合同-数量', field: 's1_contract_qty', type: dataType.currency },
  964. { name: '第1期-合同-金额', field: 's1_contract_tp', type: dataType.currency },
  965. { name: '第1期-变更-数量', field: 's1_qc_qty', type: dataType.currency },
  966. { name: '第1期-变更-金额', field: 's1_qc_tp', type: dataType.currency },
  967. { name: '第1期-完成-数量', field: 's1_gather_qty', type: dataType.currency },
  968. { name: '第1期-完成-金额', field: 's1_gather_tp', type: dataType.currency },
  969. { name: '第2期-合同-数量', field: 's2_contract_qty', type: dataType.currency },
  970. { name: '第2期-合同-金额', field: 's2_contract_tp', type: dataType.currency },
  971. { name: '第2期-变更-数量', field: 's2_qc_qty', type: dataType.currency },
  972. { name: '第2期-变更-金额', field: 's2_qc_tp', type: dataType.currency },
  973. { name: '第2期-完成-数量', field: 's2_gather_qty', type: dataType.currency },
  974. { name: '第2期-完成-金额', field: 's2_gather_tp', type: dataType.currency },
  975. { name: '第3期-合同-数量', field: 's3_contract_qty', type: dataType.currency },
  976. { name: '第3期-合同-金额', field: 's3_contract_tp', type: dataType.currency },
  977. { name: '第3期-变更-数量', field: 's3_qc_qty', type: dataType.currency },
  978. { name: '第3期-变更-金额', field: 's3_qc_tp', type: dataType.currency },
  979. { name: '第3期-完成-数量', field: 's3_gather_qty', type: dataType.currency },
  980. { name: '第3期-完成-金额', field: 's3_gather_tp', type: dataType.currency },
  981. { name: '第4期-合同-数量', field: 's4_contract_qty', type: dataType.currency },
  982. { name: '第4期-合同-金额', field: 's4_contract_tp', type: dataType.currency },
  983. { name: '第4期-变更-数量', field: 's4_qc_qty', type: dataType.currency },
  984. { name: '第4期-变更-金额', field: 's4_qc_tp', type: dataType.currency },
  985. { name: '第4期-完成-数量', field: 's4_gather_qty', type: dataType.currency },
  986. { name: '第4期-完成-金额', field: 's4_gather_tp', type: dataType.currency },
  987. { name: '第5期-合同-数量', field: 's5_contract_qty', type: dataType.currency },
  988. { name: '第5期-合同-金额', field: 's5_contract_tp', type: dataType.currency },
  989. { name: '第5期-变更-数量', field: 's5_qc_qty', type: dataType.currency },
  990. { name: '第5期-变更-金额', field: 's5_qc_tp', type: dataType.currency },
  991. { name: '第5期-完成-数量', field: 's5_gather_qty', type: dataType.currency },
  992. { name: '第5期-完成-金额', field: 's5_gather_tp', type: dataType.currency },
  993. ],
  994. };
  995. const recursiveMkdirSync = async function(pathName) {
  996. if (!fs.existsSync(pathName)) {
  997. const upperPath = path.dirname(pathName);
  998. if (!fs.existsSync(upperPath)) {
  999. await this.recursiveMkdirSync(upperPath);
  1000. }
  1001. await fs.mkdirSync(pathName);
  1002. }
  1003. };
  1004. const saveBufferFile = async function(buffer, fileName) {
  1005. // 检查文件夹是否存在,不存在则直接创建文件夹
  1006. const pathName = path.dirname(fileName);
  1007. if (!fs.existsSync(pathName)) {
  1008. await recursiveMkdirSync(pathName);
  1009. }
  1010. await fs.writeFileSync(fileName, buffer);
  1011. };
  1012. const addFields = function(table, col) {
  1013. const data = {};
  1014. data.ID = table.ID * 100 + (col.id ? Math.max(table.items.length + 1, col.id) : table.items.length + 1);
  1015. data.Name = col.name + (col.field ? '(' + col.field + ')' : '') + (data.ID ? '(id: ' + data.ID + ')' : '');
  1016. if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
  1017. data.DataType = col.type;
  1018. data.TableName = table.key;
  1019. data.descr = '';
  1020. data.mapExpression = "$PROJECT.REPORT.getProperty('" + table.key + "', '" + col.field + "')";
  1021. if (col.tag) {
  1022. switch (tag.type) {
  1023. case 'up':
  1024. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
  1025. break;
  1026. case 'tp':
  1027. if (col.tag.subType) {
  1028. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + '_' + col.tag.subType + "_tp')" };
  1029. } else {
  1030. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" };
  1031. }
  1032. break;
  1033. case 'qty':
  1034. data.Precision = { type: 'flexible', flexibleRefFieldID: table.ID * 100 + tag.unitKey, flexibleMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'precision')" };
  1035. break;
  1036. }
  1037. }
  1038. if (col.isPic) {
  1039. data.isPic = true;
  1040. }
  1041. table.items.push(data);
  1042. };
  1043. const saveTableDefine = async function(tableDefine, file) {
  1044. delete tableDefine.ID;
  1045. delete tableDefine.key;
  1046. delete tableDefine.prefix;
  1047. let defineStr = JSON.stringify(tableDefine, '', '\t');
  1048. const replaceStr = [
  1049. { match: '"Name":', str: 'Name:' },
  1050. { match: '"remark":', str: 'remark:' },
  1051. { match: '"items":', str: 'items:' },
  1052. { match: '"ID":', str: 'ID:' },
  1053. { match: '"DataType":', str: 'DataType:' },
  1054. { match: '"TableName":', str: 'TableName:' },
  1055. { match: '"descr":', str: 'descr:' },
  1056. { match: '"mapExpression":', str: 'mapExpression:' },
  1057. { match: '"Precision":', str: 'Precision:' },
  1058. { match: '"type":', str: 'type:' },
  1059. { match: '"flexibleRefFieldID":', str: 'flexibleRefFieldID:' },
  1060. { match: '"fixedMapExpression":', str: 'fixedMapExpression:' },
  1061. { match: '"flexibleMapExpression":', str: 'flexibleMapExpression:' },
  1062. ];
  1063. for (const rs of replaceStr) {
  1064. const reg = new RegExp(rs.match, 'gm');
  1065. defineStr = defineStr.replace(reg, rs.str);
  1066. }
  1067. await saveBufferFile(defineStr, file);
  1068. };
  1069. const exportTableDefine = async function(define) {
  1070. const tableDefine = {};
  1071. tableDefine.Name = define.name;// '期-清单-全参与人数据表(mem_stage_bills_compare)';
  1072. tableDefine.remark = define.remark;
  1073. tableDefine.ID = define.id;
  1074. tableDefine.key = define.key;
  1075. tableDefine.items = [];
  1076. tableDefine.prefix = define.prefix;
  1077. for (const col of define.cols) {
  1078. addFields(tableDefine, col);
  1079. }
  1080. addFields(tableDefine, { id: 99, name: '空白', field: '', type: dataType.str });
  1081. await saveTableDefine(tableDefine, path.join(savePath, define.key + '_define.json'));
  1082. };
  1083. const defines = [
  1084. union_data,
  1085. month_progress,
  1086. stage_bills, stage_bills_compare,
  1087. stage_jgcl, stage_bonus, stage_other,
  1088. change, change_bills,
  1089. stage_pos, stage_pos_compare,
  1090. stage_pay,
  1091. stage_im_zl, stage_im_tz, stage_im_tz_bills,
  1092. gather_stage_bills, gather_tender_info, gather_stage_pay, gather_deal_bills,
  1093. material, materialGl,
  1094. sum_stage_bills
  1095. ];
  1096. for (const d of defines) {
  1097. exportTableDefine(d);
  1098. }