builder_report_index_define.js 145 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384
  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. arr: 'array',
  19. };
  20. const tag = {
  21. tp: { type: 'tp' },
  22. up: { type: 'up' },
  23. };
  24. // 预付款
  25. const advance_pay = {
  26. name: '预付款记录(advance_pay)',
  27. remark: '',
  28. id: 44,
  29. key: 'advance_pay',
  30. prefix: '预付款',
  31. cols: [
  32. { name: 'id', field: 'id', type: dataType.int },
  33. { name: '创建者id', field: 'uid', type: dataType.int },
  34. { name: '审批次数', field: 'times', type: dataType.int },
  35. { name: '审批状态', field: 'status', type: dataType.int },
  36. { name: '期数索引', field: 'order', type: dataType.int },
  37. { name: '类型', field: 'type', type: dataType.int },
  38. { name: '支付比例', field: 'pay_ratio', type: dataType.currency },
  39. { name: '本期金额', field: 'cur_amount', type: dataType.currency },
  40. { name: '截止上期金额', field: 'prev_amount', type: dataType.currency },
  41. { name: '截止本期金额', field: 'prev_total_amount', type: dataType.currency },
  42. { name: '创建时间', field: 'create_time', type: dataType.str },
  43. { name: '备注', field: 'remark', type: dataType.str },
  44. { name: '结束时间', field: 'end_time', type: dataType.str },
  45. ],
  46. };
  47. const ledger_cooperation = {
  48. name: '台账-协作(ledger_cooperation)',
  49. remark: '',
  50. id: 45,
  51. key: 'ledger_cooperation',
  52. prefix: '台账-协作',
  53. cols: [
  54. { name: 'id', field: 'id', type: dataType.int },
  55. { name: '标段id', field: 'tid', type: dataType.int },
  56. { name: '审批人id', field: 'user_id', type: dataType.int },
  57. { name: '台账id', field: 'ledger_id', type: dataType.int },
  58. { name: '密码', field: 'pwd', type: dataType.str },
  59. { name: '签字地址', field: 'sign_path', type: dataType.str },
  60. ],
  61. };
  62. // 其他台账
  63. const stage_jgcl = {
  64. name: '期-甲供材料(mem_stage_jgcl)',
  65. remark: '',
  66. id: 30,
  67. key: 'mem_stage_jgcl',
  68. prefix: '期-甲供材料',
  69. cols: [
  70. { name: 'id', field: 'id', type: dataType.int },
  71. { name: 'uuid', field: 'uuid', type: dataType.str },
  72. { name: '名称', field: 'name', type: dataType.str },
  73. { name: '单位', field: 'unit', type: dataType.str },
  74. { name: '单价', field: 'unit_price', type: dataType.currency },
  75. { name: '本期到场-数量', field: 'arrive_qty', type: dataType.currency },
  76. { name: '本期到场-金额', field: 'arrive_tp', type: dataType.currency },
  77. { name: '本期扣回-数量', field: 'deduct_qty', type: dataType.currency },
  78. { name: '本期扣回-金额', field: 'deduct_tp', type: dataType.currency },
  79. { name: '材料来源', field: 'source', type: dataType.str },
  80. { name: '单据号', field: 'bills_code', type: dataType.str },
  81. { name: '检验单编号', field: 'check_code', type: dataType.str },
  82. { name: '新增人id', field: 'add_uid', type: dataType.int },
  83. { name: '新增期id', field: 'add_sid', type: dataType.int },
  84. { name: '所属期id', field: 'sid', type: dataType.int },
  85. { name: '期历史记录', field: 'shistory', type: dataType.str },
  86. { name: '排序', field: 'order', type: dataType.int },
  87. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  88. { name: '截止上期到场-数量', field: 'pre_arrive_qty', type: dataType.currency },
  89. { name: '截止上期到场-金额', field: 'pre_arrive_tp', type: dataType.currency },
  90. { name: '截止上期扣回-数量', field: 'pre_deduct_qty', type: dataType.currency },
  91. { name: '截止上期扣回-金额', field: 'pre_deduct_tp', type: dataType.currency },
  92. { name: '备注', field: 'memo', type: dataType.str },
  93. { name: '截止本期到场-数量', field: 'end_arrive_qty', type: dataType.currency },
  94. { name: '截止本期到场-金额', field: 'end_arrive_tp', type: dataType.currency },
  95. { name: '截止本期扣回-数量', field: 'end_deduct_qty', type: dataType.currency },
  96. { name: '截止本期扣回-金额', field: 'end_deduct_tp', type: dataType.currency },
  97. ],
  98. };
  99. const stage_bonus = {
  100. name: '期-奖罚金(mem_stage_bonus)',
  101. remark: '',
  102. id: 31,
  103. key: 'mem_stage_bonus',
  104. prefix: '期-奖罚金',
  105. cols: [
  106. { name: 'id', field: 'id', type: dataType.str },
  107. { name: '所属标段id', field: 'tid', type: dataType.int },
  108. { name: '所属期id', field: 'sid', type: dataType.int },
  109. { name: '所属第几期', field: 'sorder', type: dataType.int },
  110. { name: '新增人id', field: 'uid', type: dataType.int },
  111. { name: '名称', field: 'name', type: dataType.str },
  112. { name: '金额', field: 'tp', type: dataType.currency, tag: { type: 'tp' } },
  113. { name: '证明材料', field: 'proof', type: dataType.str },
  114. { name: '创建时间', field: 'create_time', type: dataType.time },
  115. { name: '时间', field: 'real_time', type: dataType.time },
  116. { name: '备注', field: 'memo', type: dataType.str },
  117. { name: '期历史记录', field: 'shistory', type: dataType.str },
  118. { name: '排序', field: 'order', type: dataType.int },
  119. { name: '编号', field: 'code', type: dataType.str },
  120. { name: '发文单位', field: 'doc_co', type: dataType.str },
  121. { name: '类型', field: 'b_type', type: dataType.str },
  122. ],
  123. };
  124. const stage_other = {
  125. name: '期-其他(mem_stage_other)',
  126. remark: '',
  127. id: 32,
  128. key: 'mem_stage_other',
  129. prefix: '期-其他',
  130. cols: [
  131. { name: 'id', field: 'id', type: dataType.int },
  132. { name: 'uuid', field: 'uuid', type: dataType.str },
  133. { name: '所属标段id', field: 'tid', type: dataType.int },
  134. { name: '所属期id', field: 'sid', type: dataType.int },
  135. { name: '所属第几期', field: 'sorder', type: dataType.int },
  136. { name: '新增人id', field: 'add_uid', type: dataType.int },
  137. { name: '新增期id', field: 'add_sid', type: dataType.int },
  138. { name: '创建时间', field: 'add_time', type: dataType.time },
  139. { name: '名称', field: 'name', type: dataType.str },
  140. { name: '金额', field: 'total_price', type: dataType.currency },
  141. { name: '本期金额', field: 'tp', type: dataType.currency },
  142. { name: '时间', field: 'real_time', type: dataType.time },
  143. { name: '备注', field: 'memo', type: dataType.str },
  144. { name: '期历史记录', field: 'shistory', type: dataType.str },
  145. { name: '排序', field: 'order', type: dataType.int },
  146. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  147. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
  148. { name: '类型', field: 'o_type', type: dataType.str },
  149. { name: '截止本期-金额', field: 'end_tp', type: dataType.currency},
  150. ],
  151. };
  152. const stage_safe_prod = {
  153. name: '期-安全生产(mem_stage_safe_prod)',
  154. remark: '',
  155. id: 69,
  156. key: 'mem_stage_safe_prod',
  157. prefix: '期-安全生产',
  158. cols: [
  159. { name: 'id', field: 'id', type: dataType.int },
  160. { name: 'uuid', field: 'uuid', type: dataType.str },
  161. { name: '所属标段id', field: 'tid', type: dataType.int },
  162. { name: '所属期id', field: 'sid', type: dataType.int },
  163. { name: '所属第几期', field: 'sorder', type: dataType.int },
  164. { name: '新增人id', field: 'add_uid', type: dataType.int },
  165. { name: '新增期id', field: 'add_sid', type: dataType.int },
  166. { name: '创建时间', field: 'add_time', type: dataType.time },
  167. { name: '名称', field: 'name', type: dataType.str },
  168. { name: '单位', field: 'unit', type: dataType.str },
  169. { name: '单价', field: 'unit_price', type: dataType.currency },
  170. { name: '数量', field: 'quantity', type: dataType.currency },
  171. { name: '金额', field: 'total_price', type: dataType.currency },
  172. { name: '本期数量', field: 'qty', type: dataType.currency },
  173. { name: '本期金额', field: 'tp', type: dataType.currency },
  174. { name: '备注', field: 'memo', type: dataType.str },
  175. { name: '期历史记录', field: 'shistory', type: dataType.str },
  176. { name: '排序', field: 'order', type: dataType.int },
  177. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  178. { name: '截止上期-数量', field: 'pre_qty', type: dataType.currency },
  179. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
  180. { name: '截止本期-数量', field: 'end_qty', type: dataType.currency },
  181. { name: '截止本期-金额', field: 'end_tp', type: dataType.currency },
  182. ],
  183. };
  184. const stage_temp_land = {
  185. name: '期-临时占地(mem_stage_temp_land)',
  186. remark: '',
  187. id: 70,
  188. key: 'mem_stage_temp_land',
  189. prefix: '期-临时占地',
  190. cols: [
  191. { name: 'id', field: 'id', type: dataType.int },
  192. { name: 'uuid', field: 'uuid', type: dataType.str },
  193. { name: '所属标段id', field: 'tid', type: dataType.int },
  194. { name: '所属期id', field: 'sid', type: dataType.int },
  195. { name: '所属第几期', field: 'sorder', type: dataType.int },
  196. { name: '新增人id', field: 'add_uid', type: dataType.int },
  197. { name: '新增期id', field: 'add_sid', type: dataType.int },
  198. { name: '创建时间', field: 'add_time', type: dataType.time },
  199. { name: '名称', field: 'name', type: dataType.str },
  200. { name: '单位', field: 'unit', type: dataType.str },
  201. { name: '单价', field: 'unit_price', type: dataType.currency},
  202. { name: '本期数量', field: 'qty', type: dataType.currency },
  203. { name: '本期金额', field: 'tp', type: dataType.currency },
  204. { name: '备注', field: 'memo', type: dataType.str },
  205. { name: '期历史记录', field: 'shistory', type: dataType.str },
  206. { name: '排序', field: 'order', type: dataType.int },
  207. { name: '往期是否已用', field: 'pre_used', type: dataType.int },
  208. { name: '截止上期-数量', field: 'pre_qty', type: dataType.currency },
  209. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
  210. { name: '截止本期-数量', field: 'end_qty', type: dataType.currency },
  211. { name: '截止本期-金额', field: 'end_tp', type: dataType.currency },
  212. ],
  213. };
  214. // 变更令
  215. const change = {
  216. name: '变更令(mem_change)',
  217. remark: '',
  218. id: 33,
  219. key: 'mem_change',
  220. prefix: '变更令',
  221. cols: [
  222. { name: '变更令id', field: 'cid', type: dataType.str },
  223. { name: '变更令号', field: 'code', type: dataType.str },
  224. { name: '批复文号', field: 'w_code', type: dataType.str },
  225. { name: '批复编号', field: 'p_code', type: dataType.str },
  226. { name: '变更名称', field: 'name', type: dataType.str },
  227. { name: '桩号', field: 'peg', type: dataType.str },
  228. { name: '原设计图名称', field: 'org_name', type: dataType.str },
  229. { name: '原图号', field: 'org_code', type: dataType.str },
  230. { name: '变更设计图名称', field: 'new_name', type: dataType.str },
  231. { name: '变更图号', field: 'new_code', type: dataType.str },
  232. { name: '工程变更理由及内容', field: 'content', type: dataType.str },
  233. { name: '工程变更合同依据', field: 'basis', type: dataType.str },
  234. { name: '变更工程量数量计算式', field: 'expr', type: dataType.str },
  235. { name: '备注', field: 'memo', type: dataType.str },
  236. { name: '变更类型', field: 'type', type: dataType.str },
  237. { name: '变更类别', field: 'class', type: dataType.int },
  238. { name: '变更性质', field: 'quality', type: dataType.int },
  239. { name: '变更提出单位', field: 'company', type: dataType.str },
  240. { name: '费用承担方', field: 'charge', type: dataType.int },
  241. { name: '金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  242. { name: '变更状态发生时间(时间戳)', field: 'cin_time', type: dataType.str },
  243. { name: '完成审批时间(时间戳)', field: 'sin_time', type: dataType.str },
  244. { name: '金额_1', field: 'tp_1', type: dataType.currency, tag: { type: 'tp' } },
  245. { name: '金额_2', field: 'tp_2', type: dataType.currency, tag: { type: 'tp' } },
  246. { name: '金额_3', field: 'tp_3', type: dataType.currency, tag: { type: 'tp' } },
  247. { name: '金额_4', field: 'tp_4', type: dataType.currency, tag: { type: 'tp' } },
  248. { name: '金额_5', field: 'tp_5', type: dataType.currency, tag: { type: 'tp' } },
  249. { name: '金额_6', field: 'tp_6', type: dataType.currency, tag: { type: 'tp' } },
  250. { name: '金额_7', field: 'tp_7', type: dataType.currency, tag: { type: 'tp' } },
  251. { name: '金额_8', field: 'tp_8', type: dataType.currency, tag: { type: 'tp' } },
  252. { name: '金额_9', field: 'tp_9', type: dataType.currency, tag: { type: 'tp' } },
  253. { name: '附件名称列表', field: 'attNames', type: dataType.currency },
  254. { name: '报表用,是否选择', field: 'selected', type: dataType.int },
  255. ],
  256. };
  257. const change_bills = {
  258. name: '变更清单(mem_change_bills)',
  259. remark: '',
  260. id: 29,
  261. key: 'mem_change_bills',
  262. prefix: '变更清单',
  263. cols: [
  264. { name: '变更令id', field: 'cid', type: dataType.str },
  265. { name: '签约清单id或台账id', field: 'lid', type: dataType.str },
  266. { name: '清单编号', field: 'code', type: dataType.str },
  267. { name: '名称', field: 'name', type: dataType.str },
  268. { name: '单位', field: 'unit', type: dataType.str },
  269. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  270. { name: '原-数量', field: 'o_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  271. { name: '原-金额', field: 'o_tp', type: dataType.currency, tag: { type: 'tp' } },
  272. { name: '变更-数量', field: 'c_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  273. { name: '变更-金额', field: 'c_tp', type: dataType.currency, tag: { type: 'tp' } },
  274. { name: '审批变更后-数量', field: 's_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  275. { name: '审批变更后-金额', field: 's_tp', type: dataType.currency, tag: { type: 'tp' } },
  276. { name: '部位明细', field: 'bwmx', type: dataType.str },
  277. { name: '变更详情', field: 'detail', type: dataType.str },
  278. { name: '数量_1', field: 'qty_1', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  279. { name: '金额_1', field: 'tp_1', type: dataType.currency, tag: { type: 'tp' } },
  280. { name: '数量_2', field: 'qty_2', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  281. { name: '金额_2', field: 'tp_2', type: dataType.currency, tag: { type: 'tp' } },
  282. { name: '数量_3', field: 'qty_3', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  283. { name: '金额_3', field: 'tp_3', type: dataType.currency, tag: { type: 'tp' } },
  284. { name: '数量_4', field: 'qty_4', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  285. { name: '金额_4', field: 'tp_4', type: dataType.currency, tag: { type: 'tp' } },
  286. { name: '数量_5', field: 'qty_5', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  287. { name: '金额_5', field: 'tp_5', type: dataType.currency, tag: { type: 'tp' } },
  288. { name: '数量_6', field: 'qty_6', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  289. { name: '金额_6', field: 'tp_6', type: dataType.currency, tag: { type: 'tp' } },
  290. { name: '数量_7', field: 'qty_7', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  291. { name: '金额_7', field: 'tp_7', type: dataType.currency, tag: { type: 'tp' } },
  292. { name: '数量_8', field: 'qty_8', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  293. { name: '金额_8', field: 'tp_8', type: dataType.currency, tag: { type: 'tp' } },
  294. { name: '数量_9', field: 'qty_9', type: dataType.currency, tag: { type: 'qty', unitKey: 5 } },
  295. { name: '金额_9', field: 'tp_9', type: dataType.currency, tag: { type: 'tp' } },
  296. { name: '项目节编号', field: 'xmj_code', type: dataType.str },
  297. { name: '细目', field: 'xmj_jldy', type: dataType.str },
  298. { name: '单位工程', field: 'xmj_dwgc', type: dataType.str },
  299. { name: '分部工程', field: 'xmj_fbgc', type: dataType.str },
  300. { name: '分项工程', field: 'xmj_fxgc', type: dataType.str },
  301. { name: '(空) 截止本期-已变更', field: 'used_qty', type: dataType.currency },
  302. { name: '(空) 变更令-本期使用', field: 'is_used_bgl', type: dataType.int },
  303. { name: '(空) 变更清单-本期使用', field: 'is_used', type: dataType.int },
  304. ],
  305. };
  306. const change_audit = {
  307. name: '变更审批 列表(mem_change_audit)',
  308. remark: '',
  309. id: 73,
  310. key: 'mem_change_audit',
  311. prefix: '变更审批',
  312. cols: [
  313. { name: '变更令id', field: 'cid', type: dataType.str },
  314. { name: '审批人id', field: 'uid', type: dataType.int },
  315. { name: '姓名', field: 'name', type: dataType.str },
  316. { name: '职称', field: 'jobs', type: dataType.str },
  317. { name: '公司', field: 'company', type: dataType.str },
  318. { name: '审批意见', field: 'sdesc', type: dataType.str },
  319. { name: '审批时间', field: 'sin_time', type: dataType.str },
  320. { name: '审批顺序', field: 'usort', type: dataType.str },
  321. ],
  322. };
  323. const change_project = {
  324. name: '变更立项(mem_change_project)',
  325. remark: '',
  326. id: 75,
  327. key: 'mem_change_project',
  328. prefix: '变更立项',
  329. cols: [
  330. { name: 'id', field: 'id', type: dataType.int },
  331. { name: '标段id', field: 'tid', type: dataType.int },
  332. { name: '报表用,是否选择', field: 'selected', type: dataType.int },
  333. { name: '发起人', field: 'uid', type: dataType.int },
  334. { name: '立项书编号', field: 'code', type: dataType.str },
  335. { name: '立项书名称', field: 'name', type: dataType.str },
  336. { name: '发起时间', field: 'in_time', type: dataType.str },
  337. { name: '立项状态', field: 'status', type: dataType.int },
  338. { name: '审批次数', field: 'times', type: dataType.int },
  339. { name: '立项书类型', field: 'type', type: dataType.int },
  340. { name: '原设计图名称', field: 'org_name', type: dataType.str },
  341. { name: '桩号', field: 'peg', type: dataType.str },
  342. { name: '图号', field: 'new_code', type: dataType.str },
  343. { name: '变更类别', field: 'class', type: dataType.str },
  344. { name: '变更性质', field: 'quality', type: dataType.str },
  345. { name: '原工程造价(元)', field: 'org_price', type: dataType.currency },
  346. { name: '预计变更造价(元)', field: 'change_price', type: dataType.currency },
  347. { name: '预计造价增减(元)', field: 'crease_price', type: dataType.currency },
  348. { name: '变更原因', field: 'reason', type: dataType.str },
  349. { name: '内容摘要', field: 'content', type: dataType.str },
  350. ],
  351. };
  352. const change_project_audit = {
  353. name: '变更立项 审批(mem_change_project_audit)',
  354. remark: '',
  355. id: 76,
  356. key: 'mem_change_project_audit',
  357. prefix: '变更立项 审批',
  358. cols: [
  359. { name: 'id', field: 'id', type: dataType.int },
  360. { name: '标段id', field: 'tid', type: dataType.int },
  361. { name: '立项id', field: 'cpid', type: dataType.int },
  362. { name: '审批人id', field: 'aid', type: dataType.int },
  363. { name: '审批顺序', field: 'order', type: dataType.int },
  364. { name: '审批次数', field: 'times', type: dataType.int },
  365. { name: '审批状态', field: 'status', type: dataType.int },
  366. { name: '开始审批时间', field: 'begin_time', type: dataType.time },
  367. { name: '结束审批时间', field: 'end_time', type: dataType.time },
  368. { name: '审批意见', field: 'opinion', type: dataType.str },
  369. ],
  370. };
  371. const change_apply = {
  372. name: '变更申请(mem_change_apply)',
  373. remark: '',
  374. id: 77,
  375. key: 'mem_change_apply',
  376. prefix: '变更申请',
  377. cols: [
  378. { name: 'id', field: 'id', type: dataType.int },
  379. { name: '标段id', field: 'tid', type: dataType.int },
  380. { name: '报表用,是否选择', field: 'selected', type: dataType.int },
  381. { name: '发起人', field: 'uid', type: dataType.int },
  382. { name: '申请编号', field: 'code', type: dataType.str },
  383. { name: '申请名称(变更工程名称)', field: 'name', type: dataType.str },
  384. { name: '创建时间', field: 'in_time', type: dataType.time },
  385. { name: '申请状态', field: 'status', type: dataType.int },
  386. { name: '申请次数', field: 'times', type: dataType.int },
  387. { name: '变更意向编号', field: 'project_code', type: dataType.str },
  388. { name: '通知书编号', field: 'notice_code', type: dataType.str },
  389. { name: '通知书发起人', field: 'notice_uid', type: dataType.int },
  390. { name: '原设计图名称', field: 'org_name', type: dataType.str },
  391. { name: '桩号', field: 'peg', type: dataType.str },
  392. { name: '图号', field: 'new_code', type: dataType.str },
  393. { name: '变更图号', field: 'c_new_code', type: dataType.str },
  394. { name: '变更设计名称', field: 'design_name', type: dataType.str },
  395. { name: '变更类别', field: 'class', type: dataType.str },
  396. { name: '变更性质', field: 'quality', type: dataType.str },
  397. { name: '原工程造价(元)', field: 'org_price', type: dataType.currency },
  398. { name: '预计变更造价(元)', field: 'change_price', type: dataType.currency },
  399. { name: '预计造价增减(元)', field: 'crease_price', type: dataType.currency },
  400. { name: '变更原因', field: 'reason', type: dataType.str },
  401. { name: '原设计情况描述', field: 'org_content', type: dataType.str },
  402. { name: '现场实际情况描述', field: 'site_content', type: dataType.str },
  403. { name: '内容摘要', field: 'content', type: dataType.str },
  404. ],
  405. };
  406. const change_apply_audit = {
  407. name: '变更申请 审批(mem_change_apply_audit)',
  408. remark: '',
  409. id: 78,
  410. key: 'mem_change_apply_audit',
  411. prefix: '变更申请 审批',
  412. cols: [
  413. { name: 'id', field: 'id', type: dataType.int },
  414. { name: '标段id', field: 'tid', type: dataType.int },
  415. { name: '立项id', field: 'caid', type: dataType.int },
  416. { name: '审批人id', field: 'aid', type: dataType.int },
  417. { name: '审批顺序', field: 'order', type: dataType.int },
  418. { name: '审批次数', field: 'times', type: dataType.int },
  419. { name: '审批状态', field: 'status', type: dataType.int },
  420. { name: '开始审批时间', field: 'begin_time', type: dataType.time },
  421. { name: '结束审批时间', field: 'end_time', type: dataType.time },
  422. { name: '审批意见', field: 'opinion', type: dataType.str },
  423. ],
  424. };
  425. // 期 - 清单
  426. const stage_bills = {
  427. name: '期-清单 数据表(mem_stage_bills)',
  428. remark: '',
  429. id: 25,
  430. key: 'mem_stage_bills',
  431. prefix: '期-清单',
  432. cols: [
  433. { name: '台账ID', field: 'id', type: dataType.int },
  434. { name: '标段ID', field: 'tender_id', type: dataType.int },
  435. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  436. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  437. { name: '树结构-层级', field: 'level', type: dataType.int },
  438. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  439. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  440. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  441. { name: '项目节编号', field: 'code', type: dataType.str },
  442. { name: '清单编号', field: 'b_code', type: dataType.str },
  443. { name: '名称', field: 'name', type: dataType.str },
  444. { name: '单位', field: 'unit', type: dataType.str }, // 12
  445. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  446. { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  447. { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },
  448. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  449. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
  450. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  451. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  452. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  453. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  454. { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  455. { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  456. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  457. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  458. { name: '图册号', field: 'drawing_code', type: dataType.str },
  459. { name: '备注', field: 'memo', type: dataType.str },
  460. { name: '节点类型', field: 'node_type', type: dataType.int },
  461. { name: '总额计量', field: 'is_tp', type: dataType.int },
  462. { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  463. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  464. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  465. { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  466. { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  467. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  468. { name: '本期批注', field: 'postil', type: dataType.str },
  469. { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  470. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  471. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  472. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  473. { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  474. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  475. { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  476. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  477. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  478. { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  479. { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  480. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  481. { name: '(台账 + 截止本期变更)-金额', field: 'final_tp', type: dataType.currency, tag: { type: 'tp' } },
  482. { name: '截止本期完成率(%)', field: 'final_ratio', type: dataType.double },
  483. { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },
  484. { name: '章节编号', field: 'chapter', type: dataType.str },
  485. { name: '预留扩展字段_1', field: 'ex_value1', type: dataType.currency },
  486. { name: '预留扩展字段_2', field: 'ex_value2', type: dataType.currency },
  487. { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },
  488. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  489. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  490. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  491. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  492. { name: '合同-设计数量1', field: 'deal_dgn_qty1', type: dataType.currency },
  493. { name: '合同-设计数量2', field: 'deal_dgn_qty2', type: dataType.currency },
  494. { name: '变更-设计数量1', field: 'c_dgn_qty1', type: dataType.currency },
  495. { name: '变更-设计数量2', field: 'c_dgn_qty2', type: dataType.currency },
  496. { name: '工序报验-状态', field: 'gxby_status', type: dataType.int },
  497. { name: '工序报验-是否限制计量', field: 'gxby_limit', type: dataType.int },
  498. { name: '工序报验-限制比例', field: 'gxby_ratio', type: dataType.currency },
  499. { name: '档案管理-状态', field: 'dagl_status', type: dataType.int },
  500. { name: '档案管理-是否限制计量', field: 'dagl_limit', type: dataType.int },
  501. { name: '档案管理-限制比例', field: 'dagl_ratio', type: dataType.currency },
  502. { name: '备注1', field: 'ex_memo1', type: dataType.str },
  503. { name: '备注2', field: 'ex_memo2', type: dataType.str },
  504. { name: '备注3', field: 'ex_memo3', type: dataType.str },
  505. ],
  506. };
  507. const stage_bills_compare = {
  508. name: '期-清单-全参与人 数据表(mem_stage_bills_compare)',
  509. remark: '',
  510. id: 26,
  511. key: 'mem_stage_bills_compare',
  512. prefix: '期-清单-全参与人',
  513. cols: [
  514. { name: '台账ID', field: 'id', type: dataType.int },
  515. { name: '标段ID', field: 'tender_id', type: dataType.int },
  516. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  517. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  518. { name: '树结构-层级', field: 'level', type: dataType.int },
  519. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  520. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  521. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  522. { name: '项目节编号', field: 'code', type: dataType.str },
  523. { name: '清单编号', field: 'b_code', type: dataType.str },
  524. { name: '名称', field: 'name', type: dataType.str },
  525. { name: '单位', field: 'unit', type: dataType.str }, // 12
  526. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  527. { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  528. { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },
  529. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  530. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
  531. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  532. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  533. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  534. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  535. { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  536. { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  537. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  538. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  539. { name: '图册号', field: 'drawing_code', type: dataType.str },
  540. { name: '备注', field: 'memo', type: dataType.str },
  541. { name: '节点类型', field: 'node_type', type: dataType.int },
  542. { name: '总额计量', field: 'is_tp', type: dataType.int },
  543. { name: '截止上期-合同-数量', field: 'pre_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  544. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  545. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  546. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  547. { name: '截止上期-完成-数量', field: 'pre_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  548. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  549. { name: '本期-合同-数量_0', field: 'r0_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  550. { name: '本期-合同-金额_0', field: 'r0_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  551. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  552. { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  553. { name: '本期-完成-数量_0', field: 'r0_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  554. { name: '本期-完成-金额_0', field: 'r0_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  555. { name: '本期-合同-数量_1', field: 'r1_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  556. { name: '本期-合同-金额_1', field: 'r1_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  557. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  558. { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  559. { name: '本期-完成-数量_1', field: 'r1_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  560. { name: '本期-完成-金额_1', field: 'r1_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  561. { name: '本期-合同-数量_2', field: 'r2_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  562. { name: '本期-合同-金额_2', field: 'r2_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  563. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  564. { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  565. { name: '本期-完成-数量_2', field: 'r2_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  566. { name: '本期-完成-金额_2', field: 'r2_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  567. { name: '本期-合同-数量_3', field: 'r3_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  568. { name: '本期-合同-金额_3', field: 'r3_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  569. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  570. { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  571. { name: '本期-完成-数量_3', field: 'r3_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  572. { name: '本期-完成-金额_3', field: 'r3_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  573. { name: '本期-合同-数量_4', field: 'r4_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  574. { name: '本期-合同-金额_4', field: 'r4_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  575. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  576. { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  577. { name: '本期-完成-数量_4', field: 'r4_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  578. { name: '本期-完成-金额_4', field: 'r4_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  579. { name: '本期-合同-数量_5', field: 'r5_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  580. { name: '本期-合同-金额_5', field: 'r5_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  581. { name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  582. { name: '本期-数量变更-金额_5', field: 'r5_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  583. { name: '本期-完成-数量_5', field: 'r5_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  584. { name: '本期-完成-金额_5', field: 'r5_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  585. { name: '本期-合同-数量_6', field: 'r6_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  586. { name: '本期-合同-金额_6', field: 'r6_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  587. { name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  588. { name: '本期-数量变更-金额_6', field: 'r6_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  589. { name: '本期-完成-数量_6', field: 'r6_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  590. { name: '本期-完成-金额_6', field: 'r6_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  591. { name: '本期-合同-数量_7', field: 'r7_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  592. { name: '本期-合同-金额_7', field: 'r7_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  593. { name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  594. { name: '本期-数量变更-金额_7', field: 'r7_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  595. { name: '本期-完成-数量_7', field: 'r7_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  596. { name: '本期-完成-金额_7', field: 'r7_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  597. { name: '本期-合同-数量_8', field: 'r8_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  598. { name: '本期-合同-金额_8', field: 'r8_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  599. { name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  600. { name: '本期-数量变更-金额_8', field: 'r8_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  601. { name: '本期-完成-数量_8', field: 'r8_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  602. { name: '本期-完成-金额_8', field: 'r8_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  603. { name: '本期-合同-数量_9', field: 'r9_contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  604. { name: '本期-合同-金额_9', field: 'r9_contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  605. { name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  606. { name: '本期-数量变更-金额_9', field: 'r9_qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  607. { name: '本期-完成-数量_9', field: 'r9_gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  608. { name: '本期-完成-金额_9', field: 'r9_gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  609. { name: '章节编号', field: 'chapter', type: dataType.str },
  610. { name: '最底层项目节id', field: 'leaf_xmj_id', type: dataType.str },
  611. ],
  612. };
  613. // 期 - 计量单元
  614. const stage_pos = {
  615. name: '期-计量单元(mem_stage_pos)',
  616. remark: '',
  617. id: 34,
  618. key: 'mem_stage_pos',
  619. prefix: '期-计量单元',
  620. cols: [
  621. { name: 'id', field: 'id', type: dataType.str },
  622. { name: '所属标段id', field: 'tid', type: dataType.int },
  623. { name: '所属清单id', field: 'lid', type: dataType.str },
  624. { name: '名称', field: 'name', type: dataType.str },
  625. { name: '位置', field: 'position', type: dataType.str },
  626. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  627. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  628. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  629. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  630. { name: '图号', field: 'drawing_code', type: dataType.str },
  631. { name: '排序', field: 'p_order', type: dataType.str },
  632. { name: '本期-合同计量-数量', field: 'contract_qty', type: dataType.currency },
  633. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
  634. { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },
  635. { name: '本期-完成计量-数量', field: 'gather_qty', type: dataType.currency },
  636. { name: '本期批注', field: 'postil', type: dataType.str },
  637. { name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency },
  638. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  639. { name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency },
  640. { name: '截止本期-合同计量-数量', field: 'end_contract_qty', type: dataType.currency },
  641. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
  642. { name: '截止本期-完成计量-数量', field: 'end_gather_qty', type: dataType.currency },
  643. { name: '截止本期-完成率', field: 'final_ratio', type: dataType.currency },
  644. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  645. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  646. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  647. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  648. { name: '工序报验-状态', field: 'gxby_status', type: dataType.int },
  649. { name: '工序报验-是否限制计量', field: 'gxby_limit', type: dataType.int },
  650. { name: '工序报验-限制比例', field: 'gxby_ratio', type: dataType.currency },
  651. { name: '档案管理-状态', field: 'dagl_status', type: dataType.int },
  652. { name: '档案管理-是否限制计量', field: 'dagl_limit', type: dataType.int },
  653. { name: '档案管理-限制比例', field: 'dagl_ratio', type: dataType.currency },
  654. { name: '备注1', field: 'ex_memo1', type: dataType.str },
  655. { name: '备注2', field: 'ex_memo2', type: dataType.str },
  656. { name: '备注3', field: 'ex_memo3', type: dataType.str },
  657. { name: '现场实际数量', field: 'real_qty', type: dataType.currency },
  658. ],
  659. };
  660. const stage_pos_compare = {
  661. name: '期-计量单元-全参与人(mem_stage_pos_compare)',
  662. remark: '',
  663. id: 35,
  664. key: 'mem_stage_pos_compare',
  665. prefix: '期-计量单元-全参与人',
  666. cols: [
  667. { name: 'id', field: 'id', type: dataType.str },
  668. { name: '所属标段id', field: 'tid', type: dataType.int },
  669. { name: '所属清单id', field: 'lid', type: dataType.str },
  670. { name: '名称', field: 'name', type: dataType.str },
  671. { name: '位置', field: 'position', type: dataType.str },
  672. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  673. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  674. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  675. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  676. { name: '图号', field: 'drawing_code', type: dataType.str },
  677. { name: '排序', field: 'p_order', type: dataType.str },
  678. { name: '截止上期-合同计量-数量', field: 'pre_contract_qty', type: dataType.currency },
  679. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  680. { name: '截止上期-完成计量-数量', field: 'pre_gather_qty', type: dataType.currency },
  681. { name: '本期-合同计量-数量_0', field: 'r0_contract_qty', type: dataType.currency },
  682. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
  683. { name: '本期-完成计量-数量_0', field: 'r0_gather_qty', type: dataType.currency },
  684. { name: '本期-合同计量-数量_1', field: 'r1_contract_qty', type: dataType.currency },
  685. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
  686. { name: '本期-完成计量-数量_1', field: 'r1_gather_qty', type: dataType.currency },
  687. { name: '本期-合同计量-数量_2', field: 'r2_contract_qty', type: dataType.currency },
  688. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
  689. { name: '本期-完成计量-数量_2', field: 'r2_gather_qty', type: dataType.currency },
  690. { name: '本期-合同计量-数量_3', field: 'r3_contract_qty', type: dataType.currency },
  691. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
  692. { name: '本期-完成计量-数量_3', field: 'r3_gather_qty', type: dataType.currency },
  693. { name: '本期-合同计量-数量_4', field: 'r4_contract_qty', type: dataType.currency },
  694. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
  695. { name: '本期-完成计量-数量_4', field: 'r4_gather_qty', type: dataType.currency },
  696. { name: '本期-合同计量-数量_5', field: 'r5_contract_qty', type: dataType.currency },
  697. { name: '本期-数量变更-数量_5', field: 'r5_qc_qty', type: dataType.currency },
  698. { name: '本期-完成计量-数量_5', field: 'r5_gather_qty', type: dataType.currency },
  699. { name: '本期-合同计量-数量_6', field: 'r6_contract_qty', type: dataType.currency },
  700. { name: '本期-数量变更-数量_6', field: 'r6_qc_qty', type: dataType.currency },
  701. { name: '本期-完成计量-数量_6', field: 'r6_gather_qty', type: dataType.currency },
  702. { name: '本期-合同计量-数量_7', field: 'r7_contract_qty', type: dataType.currency },
  703. { name: '本期-数量变更-数量_7', field: 'r7_qc_qty', type: dataType.currency },
  704. { name: '本期-完成计量-数量_7', field: 'r7_gather_qty', type: dataType.currency },
  705. { name: '本期-合同计量-数量_8', field: 'r8_contract_qty', type: dataType.currency },
  706. { name: '本期-数量变更-数量_8', field: 'r8_qc_qty', type: dataType.currency },
  707. { name: '本期-完成计量-数量_8', field: 'r8_gather_qty', type: dataType.currency },
  708. { name: '本期-合同计量-数量_9', field: 'r9_contract_qty', type: dataType.currency },
  709. { name: '本期-数量变更-数量_9', field: 'r9_qc_qty', type: dataType.currency },
  710. { name: '本期-完成计量-数量_9', field: 'r9_gather_qty', type: dataType.currency },
  711. ],
  712. };
  713. // 工程进度
  714. const month_progress = {
  715. name: '工程进度 数据表(mem_month_progress)',
  716. remark: '',
  717. id: 22,
  718. key: 'mem_month_progress',
  719. prefix: '工程进度',
  720. cols: [
  721. { name: '计量年月', field: 'month', type: dataType.str },
  722. { name: '本月计量', field: 'tp', type: dataType.currency, tag: { type: 'tp' } },
  723. { name: '本月完成度', field: 'ratio', type: dataType.double },
  724. { name: '累计计量', field: 'end_tp', type: dataType.currency, tag: { type: 'tp' } },
  725. { name: '累计完成度', field: 'end_ratio', type: dataType.double },
  726. ],
  727. };
  728. // 预留扩展数据
  729. const union_data = {
  730. name: '预留扩展-合并 数据表(mem_union_data)',
  731. remark: '',
  732. id: 28,
  733. key: 'mem_union_data',
  734. prefix: '预留扩展-合并',
  735. cols: [
  736. { name: '字符串1', field: 'str1', type: dataType.str },
  737. { name: '字符串2', field: 'str2', type: dataType.str },
  738. { name: '字符串3', field: 'str3', type: dataType.str },
  739. { name: '字符串4', field: 'str4', type: dataType.str },
  740. { name: '字符串5', field: 'str5', type: dataType.str },
  741. { name: '字符串6', field: 'str6', type: dataType.str },
  742. { name: '字符串7', field: 'str7', type: dataType.str },
  743. { name: '字符串8', field: 'str8', type: dataType.str },
  744. { name: '字符串9', field: 'str9', type: dataType.str },
  745. { name: '字符串10', field: 'str10', type: dataType.str },
  746. { name: '整数1', field: 'int1', type: dataType.int },
  747. { name: '整数2', field: 'int2', type: dataType.int },
  748. { name: '整数3', field: 'int3', type: dataType.int },
  749. { name: '整数4', field: 'int4', type: dataType.int },
  750. { name: '整数5', field: 'int5', type: dataType.int },
  751. { name: '整数6', field: 'int6', type: dataType.int },
  752. { name: '数量1', field: 'qty1', type: dataType.currency },
  753. { name: '数量2', field: 'qty2', type: dataType.currency },
  754. { name: '数量3', field: 'qty3', type: dataType.currency },
  755. { name: '数量4', field: 'qty4', type: dataType.currency },
  756. { name: '数量5', field: 'qty5', type: dataType.currency },
  757. { name: '数量6', field: 'qty6', type: dataType.currency },
  758. { name: '数量7', field: 'qty7', type: dataType.currency },
  759. { name: '数量8', field: 'qty8', type: dataType.currency },
  760. { name: '数量9', field: 'qty9', type: dataType.currency },
  761. { name: '数量10', field: 'qty10', type: dataType.currency },
  762. { name: '金额1', field: 'tp1', type: dataType.currency },
  763. { name: '金额2', field: 'tp2', type: dataType.currency },
  764. { name: '金额3', field: 'tp3', type: dataType.currency },
  765. { name: '金额4', field: 'tp4', type: dataType.currency },
  766. { name: '金额5', field: 'tp5', type: dataType.currency },
  767. { name: '金额6', field: 'tp6', type: dataType.currency },
  768. { name: '金额7', field: 'tp7', type: dataType.currency },
  769. { name: '金额8', field: 'tp8', type: dataType.currency },
  770. { name: '金额9', field: 'tp9', type: dataType.currency },
  771. { name: '金额10', field: 'tp10', type: dataType.currency },
  772. ],
  773. };
  774. // 期 - 合同支付
  775. const stage_pay = {
  776. name: '期-合同支付-数据(mem_stage_pay)',
  777. remark: '',
  778. id: 27,
  779. key: 'mem_stage_pay',
  780. prefix: '期-合同支付',
  781. cols: [
  782. { name: '名称', field: 'name', type: dataType.str },
  783. { name: '计算公式', field: 'expr', type: dataType.str },
  784. { name: '金额', field: 'tp', type: dataType.currency },
  785. { name: '截止上期-金额', field: 'pre_tp', type: dataType.currency },
  786. { name: '截止上期-金额', field: 'end_tp', type: dataType.currency },
  787. { name: '排序', field: 'order', type: dataType.int },
  788. { name: '是否扣款项', field: 'minus', type: dataType.int },
  789. { name: '支付类型', field: 'ptype', type: dataType.int },
  790. { name: '起扣金额', field: 'sprice', type: dataType.currency },
  791. { name: '扣款限额', field: 'rprice', type: dataType.currency },
  792. { name: '流程-本期-金额_0', field: 'r0_tp', type: dataType.currency },
  793. { name: '流程-本期-金额_1', field: 'r1_tp', type: dataType.currency },
  794. { name: '流程-本期-金额_2', field: 'r2_tp', type: dataType.currency },
  795. { name: '流程-本期-金额_3', field: 'r3_tp', type: dataType.currency },
  796. { name: '流程-本期-金额_4', field: 'r4_tp', type: dataType.currency },
  797. { name: '流程-本期-金额_5', field: 'r5_tp', type: dataType.currency },
  798. { name: '流程-本期-金额_6', field: 'r6_tp', type: dataType.currency },
  799. { name: '流程-本期-金额_7', field: 'r7_tp', type: dataType.currency },
  800. { name: '流程-本期-金额_8', field: 'r8_tp', type: dataType.currency },
  801. { name: '流程-本期-金额_9', field: 'r9_tp', type: dataType.currency },
  802. { name: '第几期开始计量', field: 'start_stage_order', type: dataType.int },
  803. ],
  804. };
  805. // 期 - 中间计量
  806. const stage_im_zl = {
  807. name: '期-中间计量-总量-数据(mem_stage_im_zl)',
  808. remark: '',
  809. id: 21,
  810. key: 'mem_stage_im_zl',
  811. prefix: '期-中间计量-总量',
  812. cols: [
  813. { name: '台账id', field: 'lid', type: dataType.str },
  814. { name: '部位id', field: 'pid', type: dataType.str },
  815. { name: '编号', field: 'code', type: dataType.str },
  816. { name: '名称', field: 'name', type: dataType.str },
  817. { name: '单位', field: 'unit', type: dataType.str },
  818. { name: '单价', field: 'unit_price', type: dataType.currency },
  819. { name: '本期数量', field: 'jl', type: dataType.currency },
  820. { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
  821. { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
  822. { name: '桩号', field: 'peg', type: dataType.str },
  823. { name: '图册号', field: 'drawing_code', type: dataType.str },
  824. { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
  825. { name: '部位', field: 'bw', type: dataType.str },
  826. { name: '细目', field: 'xm', type: dataType.str },
  827. { name: '凭证号', field: 'doc_code', type: dataType.str },
  828. { name: '计算式说明', field: 'calc_memo', type: dataType.str },
  829. { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
  830. { name: '变更令号', field: 'bgl_code', type: dataType.str },
  831. { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
  832. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  833. { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
  834. { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
  835. { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
  836. { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
  837. { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
  838. { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
  839. { name: '本期金额', field: 'tp', type: dataType.currency },
  840. { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
  841. { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
  842. { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  843. { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  844. { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  845. { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  846. { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  847. { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  848. { name: '台账数量', field: 'quantity', type: dataType.currency },
  849. { name: '台账金额', field: 'total_price', type: dataType.currency },
  850. { name: '位置', field: 'position', type: dataType.str },
  851. { name: '计量单元', field: 'jldy', type: dataType.str },
  852. { name: '草图备注', field: 'calc_memo_remark', type: dataType.str },
  853. { name: '签名列表', field: 'cooperation', type: dataType.arr },
  854. { name: '签名1', field: 'co_sign1', type: dataType.str, isPic: true },
  855. { name: '签名2', field: 'co_sign2', type: dataType.str, isPic: true },
  856. { name: '签名3', field: 'co_sign3', type: dataType.str, isPic: true },
  857. { name: '签名4', field: 'co_sign4', type: dataType.str, isPic: true },
  858. { name: '审批时间1', field: 'co_time1', type: dataType.time },
  859. { name: '审批时间2', field: 'co_time2', type: dataType.time },
  860. { name: '审批时间3', field: 'co_time3', type: dataType.time },
  861. { name: '审批时间4', field: 'co_time4', type: dataType.time },
  862. { name: '审批意见1', field: 'co_opinion1', type: dataType.time },
  863. { name: '审批意见2', field: 'co_opinion2', type: dataType.time },
  864. { name: '审批意见3', field: 'co_opinion3', type: dataType.time },
  865. { name: '审批意见4', field: 'co_opinion4', type: dataType.time },
  866. { name: '单位工程', field: 'dwgc', type: dataType.str },
  867. { name: '分部工程', field: 'fbgc', type: dataType.str },
  868. { name: '分项工程', field: 'fxgc', type: dataType.str },
  869. ],
  870. };
  871. const stage_im_tz = {
  872. name: '期-中间计量-台账-数据(mem_stage_im_tz)',
  873. remark: '',
  874. id: 19,
  875. key: 'mem_stage_im_tz',
  876. prefix: '期-中间计量-台账',
  877. cols: [
  878. { name: 'id', field: 'id', type: dataType.int },
  879. { name: '台账id', field: 'lid', type: dataType.str },
  880. { name: '部位id', field: 'pid', type: dataType.str },
  881. { name: '编号', field: 'code', type: dataType.str },
  882. { name: '本期金额', field: 'jl', type: dataType.currency },
  883. { name: '本期合同金额', field: 'contract_jl', type: dataType.currency },
  884. { name: '本期变更金额', field: 'qc_jl', type: dataType.currency },
  885. { name: '桩号', field: 'peg', type: dataType.str },
  886. { name: '图册号', field: 'drawing_code', type: dataType.str },
  887. { name: '部位', field: 'bw', type: dataType.str },
  888. { name: '细目', field: 'xm', type: dataType.str },
  889. { name: '勾选标记 - 勿用', field: 'check', type: dataType.int },
  890. { name: '计算式说明', field: 'calc_memo', type: dataType.str },
  891. { name: '变更令号', field: 'bgl_code', type: dataType.str },
  892. { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
  893. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  894. { name: '凭证号', field: 'doc_code', type: dataType.str },
  895. { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
  896. { name: '截止上期 - 金额', field: 'pre_jl', type: dataType.currency },
  897. { name: '截止上期 - 合同金额', field: 'pre_contract_jl', type: dataType.currency },
  898. { name: '截止上期 - 变更金额', field: 'pre_qc_jl', type: dataType.currency },
  899. { name: '截止本期 - 金额', field: 'end_jl', type: dataType.currency },
  900. { name: '截止本期 - 合同金额', field: 'end_contract_jl', type: dataType.currency },
  901. { name: '截止本期 - 变更金额', field: 'end_qc_jl', type: dataType.currency },
  902. { name: '位置', field: 'position', type: dataType.str },
  903. { name: '计量单元', field: 'jldy', type: dataType.str },
  904. { name: '草图备注', field: 'calc_img_remark', type: dataType.str },
  905. { name: '签名列表', field: 'cooperation', type: dataType.arr },
  906. { name: '签名1', field: 'co_sign1', type: dataType.str, isPic: true },
  907. { name: '签名2', field: 'co_sign2', type: dataType.str, isPic: true },
  908. { name: '签名3', field: 'co_sign3', type: dataType.str, isPic: true },
  909. { name: '签名4', field: 'co_sign4', type: dataType.str, isPic: true },
  910. { name: '审批时间1', field: 'co_time1', type: dataType.time },
  911. { name: '审批时间2', field: 'co_time2', type: dataType.time },
  912. { name: '审批时间3', field: 'co_time3', type: dataType.time },
  913. { name: '审批时间4', field: 'co_time4', type: dataType.time },
  914. { name: '审批意见1', field: 'co_opinion1', type: dataType.time },
  915. { name: '审批意见2', field: 'co_opinion2', type: dataType.time },
  916. { name: '审批意见3', field: 'co_opinion3', type: dataType.time },
  917. { name: '审批意见4', field: 'co_opinion4', type: dataType.time },
  918. { name: '单位工程', field: 'dwgc', type: dataType.str },
  919. { name: '分部工程', field: 'fbgc', type: dataType.str },
  920. { name: '分项工程', field: 'fxgc', type: dataType.str },
  921. ],
  922. };
  923. const stage_im_tz_bills = {
  924. name: '期-中间计量-台账清单-数据(mem_stage_im_tz_bills)',
  925. remark: '',
  926. id: 20,
  927. key: 'mem_stage_im_tz_bills',
  928. prefix: '期-中间计量-台账清单',
  929. cols: [
  930. { name: '中间计量id', field: 'imid', type: dataType.int },
  931. { name: '清单id', field: 'bid', type: dataType.str },
  932. { name: '清单编号', field: 'b_code', type: dataType.str },
  933. { name: '名称', field: 'name', type: dataType.str },
  934. { name: '单位', field: 'unit', type: dataType.str },
  935. { name: '单价', field: 'unit_price', type: dataType.currency },
  936. { name: '本期数量', field: 'jl', type: dataType.currency },
  937. { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
  938. { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
  939. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  940. { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
  941. { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
  942. { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
  943. { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
  944. { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
  945. { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
  946. { name: '本期金额', field: 'tp', type: dataType.currency },
  947. { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
  948. { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
  949. { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  950. { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  951. { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  952. { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  953. { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  954. { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  955. { name: '台账数量', field: 'quantity', type: dataType.currency },
  956. { name: '台账金额', field: 'total_price', type: dataType.currency },
  957. ],
  958. };
  959. // 期 - 关联台账 = 中间计量
  960. const stage_rela_im = {
  961. name: '期-关联台账-中间计量(台账/总量)(mem_stage_rela_im)',
  962. remark: '',
  963. id: 67,
  964. key: 'mem_stage_rela_im',
  965. prefix: '期-关联台账-中间计量',
  966. cols: [
  967. { name: '标段id', field: 'tid', type: dataType.int },
  968. { name: '期id', field: 'sid', type: dataType.int },
  969. { name: '期序号', field: 'sorder', type: dataType.int },
  970. { name: '关联标段id', field: 'rela_tid', type: dataType.int },
  971. { name: '关联期id', field: 'rela_sid', type: dataType.int },
  972. { name: '关联期序号', field: 'rela_sorder', type: dataType.int },
  973. { name: '中间计量id', field: 'im_id', type: dataType.int },
  974. { name: '台账id', field: 'lid', type: dataType.str },
  975. { name: '部位id', field: 'pid', type: dataType.str },
  976. { name: '编号', field: 'code', type: dataType.str },
  977. { name: '空/名称', field: 'name', type: dataType.str },
  978. { name: '空/单位', field: 'unit', type: dataType.str },
  979. { name: '空/单价', field: 'unit_price', type: dataType.currency },
  980. { name: '桩号', field: 'peg', type: dataType.str },
  981. { name: '图册号', field: 'drawing_code', type: dataType.str },
  982. { name: '部位', field: 'bw', type: dataType.str },
  983. { name: '细目', field: 'xm', type: dataType.str },
  984. { name: '位置', field: 'position', type: dataType.str },
  985. { name: '计量单元', field: 'jldy', type: dataType.str },
  986. { name: '单位工程', field: 'dwgc', type: dataType.str },
  987. { name: '分部工程', field: 'fbgc', type: dataType.str },
  988. { name: '分项工程', field: 'fxgc', type: dataType.str },
  989. { name: '凭证号', field: 'doc_code', type: dataType.str },
  990. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  991. { name: '计算式说明', field: 'calc_memo', type: dataType.str },
  992. { name: '草图', field: 'calc_img', type: dataType.str, isPic: true },
  993. { name: '草图备注', field: 'calc_img_remark', type: dataType.str },
  994. { name: '变更令号', field: 'bgl_code', type: dataType.str },
  995. { name: '变更图号', field: 'bgl_drawing_code', type: dataType.str },
  996. { name: '本期金额/数量', field: 'jl', type: dataType.currency },
  997. { name: '本期合同金额/数量', field: 'contract_jl', type: dataType.currency },
  998. { name: '本期变更金额/数量', field: 'qc_jl', type: dataType.currency },
  999. { name: '截止上期 - 金额/数量', field: 'pre_jl', type: dataType.currency },
  1000. { name: '截止上期 - 合同金额/数量', field: 'pre_contract_jl', type: dataType.currency },
  1001. { name: '截止上期 - 变更金额/数量', field: 'pre_qc_jl', type: dataType.currency },
  1002. { name: '截止本期 - 金额/数量', field: 'end_jl', type: dataType.currency },
  1003. { name: '截止本期 - 合同金额/数量', field: 'end_contract_jl', type: dataType.currency },
  1004. { name: '截止本期 - 变更金额/数量', field: 'end_qc_jl', type: dataType.currency },
  1005. { name: '空/本期金额', field: 'tp', type: dataType.currency },
  1006. { name: '空/本期合同金额', field: 'contract_tp', type: dataType.currency },
  1007. { name: '空/本期变更金额', field: 'qc_tp', type: dataType.currency },
  1008. { name: '空/截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  1009. { name: '空/截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  1010. { name: '空/截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  1011. { name: '空/截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  1012. { name: '空/截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  1013. { name: '空/截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  1014. ],
  1015. };
  1016. const stage_rela_im_bills = {
  1017. name: '期-关联台账-中间计量-清单(mem_stage_rela_im_bills)',
  1018. remark: '',
  1019. id: 68,
  1020. key: 'mem_stage_rela_im_bills',
  1021. prefix: '期-关联台账-中间计量-清单',
  1022. cols: [
  1023. { name: '标段id', field: 'tid', type: dataType.int },
  1024. { name: '期id', field: 'sid', type: dataType.int },
  1025. { name: '期序号', field: 'sorder', type: dataType.int },
  1026. { name: '关联标段id', field: 'rela_tid', type: dataType.int },
  1027. { name: '关联期id', field: 'rela_sid', type: dataType.int },
  1028. { name: '关联期序号', field: 'rela_sorder', type: dataType.int },
  1029. { name: '中间计量id', field: 'im_id', type: dataType.int },
  1030. { name: '清单id', field: 'bid', type: dataType.str },
  1031. { name: '清单编号', field: 'b_code', type: dataType.str },
  1032. { name: '名称', field: 'name', type: dataType.str },
  1033. { name: '单位', field: 'unit', type: dataType.str },
  1034. { name: '单价', field: 'unit_price', type: dataType.currency },
  1035. { name: '本期数量', field: 'jl', type: dataType.currency },
  1036. { name: '本期合同数量', field: 'contract_jl', type: dataType.currency },
  1037. { name: '本期变更数量', field: 'qc_jl', type: dataType.currency },
  1038. { name: '中间计量表号', field: 'im_code', type: dataType.str },
  1039. { name: '截止上期 - 数量', field: 'pre_jl', type: dataType.currency },
  1040. { name: '截止上期 - 合同数量', field: 'pre_contract_jl', type: dataType.currency },
  1041. { name: '截止上期 - 变更数量', field: 'pre_qc_jl', type: dataType.currency },
  1042. { name: '截止本期 - 数量', field: 'end_jl', type: dataType.currency },
  1043. { name: '截止本期 - 合同数量', field: 'end_contract_jl', type: dataType.currency },
  1044. { name: '截止本期 - 变更数量', field: 'end_qc_jl', type: dataType.currency },
  1045. { name: '本期金额', field: 'tp', type: dataType.currency },
  1046. { name: '本期合同金额', field: 'contract_tp', type: dataType.currency },
  1047. { name: '本期变更金额', field: 'qc_tp', type: dataType.currency },
  1048. { name: '截止上期 - 金额', field: 'pre_tp', type: dataType.currency },
  1049. { name: '截止上期 - 合同金额', field: 'pre_contract_tp', type: dataType.currency },
  1050. { name: '截止上期 - 变更金额', field: 'pre_qc_tp', type: dataType.currency },
  1051. { name: '截止本期 - 金额', field: 'end_tp', type: dataType.currency },
  1052. { name: '截止本期 - 合同金额', field: 'end_contract_tp', type: dataType.currency },
  1053. { name: '截止本期 - 变更金额', field: 'end_qc_tp', type: dataType.currency },
  1054. { name: '台账数量', field: 'quantity', type: dataType.currency },
  1055. { name: '台账金额', field: 'total_price', type: dataType.currency },
  1056. ],
  1057. };
  1058. const gather_stage_bills = {
  1059. name: '汇总-清单数据表(mem_gather_stage_bills)',
  1060. remark: '',
  1061. id: 36,
  1062. key: 'mem_gather_stage_bills',
  1063. prefix: '汇总-清单数据',
  1064. cols: [
  1065. { name: '项目节编号', field: 'code', type: dataType.str },
  1066. { name: '清单编号', field: 'b_code', type: dataType.str },
  1067. { name: '名称', field: 'name', type: dataType.str },
  1068. { name: '单位', field: 'unit', type: dataType.str },
  1069. { name: '单价', field: 'unit_price', type: dataType.currency },
  1070. { name: '标段id', field: 't_id', type: dataType.int },
  1071. { name: '标段-名称', field: 't_name', type: dataType.str },
  1072. { name: '(标段)台账-数量', field: 't_qty', type: dataType.currency },
  1073. { name: '(标段)台账-金额', field: 't_tp', type: dataType.currency },
  1074. { name: '(标段)本期-合同-数量', field: 't_contract_qty', type: dataType.currency },
  1075. { name: '(标段)本期-合同-金额', field: 't_contract_tp', type: dataType.currency },
  1076. { name: '(标段)本期-变更-数量', field: 't_qc_qty', type: dataType.currency },
  1077. { name: '(标段)本期-变更-金额', field: 't_qc_tp', type: dataType.currency },
  1078. { name: '(标段)本期-完成-数量', field: 't_gather_qty', type: dataType.currency },
  1079. { name: '(标段)本期-完成-金额', field: 't_gather_tp', type: dataType.currency },
  1080. { name: '(标段)截止上期-合同-数量', field: 't_pre_contract_qty', type: dataType.currency },
  1081. { name: '(标段)截止上期-合同-金额', field: 't_pre_contract_tp', type: dataType.currency },
  1082. { name: '(标段)截止上期-变更-数量', field: 't_pre_qc_qty', type: dataType.currency },
  1083. { name: '(标段)截止上期-变更-金额', field: 't_pre_qc_tp', type: dataType.currency },
  1084. { name: '(标段)截止上期-完成-数量', field: 't_pre_gather_qty', type: dataType.currency },
  1085. { name: '(标段)截止上期-完成-金额', field: 't_pre_gather_tp', type: dataType.currency },
  1086. { name: '(标段)截止本期-合同-数量', field: 't_end_contract_qty', type: dataType.currency },
  1087. { name: '(标段)截止本期-合同-金额', field: 't_end_contract_tp', type: dataType.currency },
  1088. { name: '(标段)截止本期-变更-数量', field: 't_end_qc_qty', type: dataType.currency },
  1089. { name: '(标段)截止本期-变更-金额', field: 't_end_qc_tp', type: dataType.currency },
  1090. { name: '(标段)截止本期-完成-数量', field: 't_end_gather_qty', type: dataType.currency },
  1091. { name: '(标段)截止本期-完成-金额', field: 't_end_gather_tp', type: dataType.currency },
  1092. { name: '(合计)台账-数量', field: 's_qty', type: dataType.currency },
  1093. { name: '(合计)台账-金额', field: 's_tp', type: dataType.currency },
  1094. { name: '(合计)本期-合同-数量', field: 's_contract_qty', type: dataType.currency },
  1095. { name: '(合计)本期-合同-金额', field: 's_contract_tp', type: dataType.currency },
  1096. { name: '(合计)本期-变更-数量', field: 's_qc_qty', type: dataType.currency },
  1097. { name: '(合计)本期-变更-金额', field: 's_qc_tp', type: dataType.currency },
  1098. { name: '(合计)本期-完成-数量', field: 's_gather_qty', type: dataType.currency },
  1099. { name: '(合计)本期-完成-金额', field: 's_gather_tp', type: dataType.currency },
  1100. { name: '(合计)截止上期-合同-数量', field: 's_pre_contract_qty', type: dataType.currency },
  1101. { name: '(合计)截止上期-合同-金额', field: 's_pre_contract_tp', type: dataType.currency },
  1102. { name: '(合计)截止上期-变更-数量', field: 's_pre_qc_qty', type: dataType.currency },
  1103. { name: '(合计)截止上期-变更-金额', field: 's_pre_qc_tp', type: dataType.currency },
  1104. { name: '(合计)截止上期-完成-数量', field: 's_pre_gather_qty', type: dataType.currency },
  1105. { name: '(合计)截止上期-完成-金额', field: 's_pre_gather_tp', type: dataType.currency },
  1106. { name: '(合计)截止本期-合同-数量', field: 's_end_contract_qty', type: dataType.currency },
  1107. { name: '(合计)截止本期-合同-金额', field: 's_end_contract_tp', type: dataType.currency },
  1108. { name: '(合计)截止本期-变更-数量', field: 's_end_qc_qty', type: dataType.currency },
  1109. { name: '(合计)截止本期-变更-金额', field: 's_end_qc_tp', type: dataType.currency },
  1110. { name: '(合计)截止本期-完成-数量', field: 's_end_gather_qty', type: dataType.currency },
  1111. { name: '(合计)截止本期-完成-金额', field: 's_end_gather_tp', type: dataType.currency },
  1112. { name: '(特殊1-需替换key1)台账-数量', field: 'ts_key1_qty', type: dataType.currency },
  1113. { name: '(特殊1-需替换key1)台账-金额', field: 'ts_key1_tp', type: dataType.currency },
  1114. { name: '(特殊2-需替换key2)台账-数量', field: 'ts_key2_qty', type: dataType.currency },
  1115. { name: '(特殊2-需替换key2)台账-金额', field: 'ts_key2_tp', type: dataType.currency },
  1116. { name: '(特殊3-需替换key3)台账-数量', field: 'ts_key3_qty', type: dataType.currency },
  1117. { name: '(特殊3-需替换key3)台账-金额', field: 'ts_key3_tp', type: dataType.currency },
  1118. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1119. { name: '树结构-id', field: 'id', type: dataType.int },
  1120. { name: '树结构-父项id', field: 'pid', type: dataType.int },
  1121. { name: '树结构-层次', field: 'level', type: dataType.int },
  1122. { name: '树结构-排序', field: 'order', type: dataType.int },
  1123. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  1124. { name: '(特殊1-需替换key1)台账-设计数量1', field: 'ts_key1_dgn_qty1', type: dataType.currency },
  1125. { name: '(特殊1-需替换key1)台账-设计数量2', field: 'ts_key1_dgn_qty2', type: dataType.currency },
  1126. { name: '(特殊2-需替换key2)台账-设计数量1', field: 'ts_key2_dgn_qty1', type: dataType.currency },
  1127. { name: '(特殊2-需替换key2)台账-设计数量2', field: 'ts_key2_dgn_qty2', type: dataType.currency },
  1128. { name: '(特殊3-需替换key3)台账-设计数量1', field: 'ts_key3_dgn_qty1', type: dataType.currency },
  1129. { name: '(特殊3-需替换key3)台账-设计数量2', field: 'ts_key3_dgn_qty2', type: dataType.currency },
  1130. { name: '(标段)台账-设计数量1', field: 't_dgn_qty1', type: dataType.currency },
  1131. { name: '(标段)台账-设计数量2', field: 't_dgn_qty2', type: dataType.currency },
  1132. { name: '(标段)合同-设计数量1', field: 't_deal_dgn_qty1', type: dataType.currency },
  1133. { name: '(标段)合同-设计数量2', field: 't_deal_dgn_qty2', type: dataType.currency },
  1134. { name: '(标段)变更-设计数量1', field: 't_c_dgn_qty1', type: dataType.currency },
  1135. { name: '(标段)变更-设计数量2', field: 't_c_dgn_qty2', type: dataType.currency },
  1136. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int },
  1137. { name: '(合计)台账-设计数量1', field: 's_dgn_qty1', type: dataType.currency },
  1138. { name: '(合计)台账-设计数量2', field: 's_dgn_qty2', type: dataType.currency },
  1139. { name: '(合计)合同-设计数量1', field: 's_deal_dgn_qty1', type: dataType.currency },
  1140. { name: '(合计)合同-设计数量2', field: 's_deal_dgn_qty2', type: dataType.currency },
  1141. { name: '(合计)变更-设计数量1', field: 's_c_dgn_qty1', type: dataType.currency },
  1142. { name: '(合计)变更-设计数量2', field: 's_c_dgn_qty2', type: dataType.currency },
  1143. { name: '标段-分类', field: 't_category', type: dataType.str },
  1144. ],
  1145. };
  1146. const gather_tender_info = {
  1147. name: '汇总-标段信息(mem_gather_tender_info)',
  1148. remark: '',
  1149. id: 37,
  1150. key: 'mem_gather_tender_info',
  1151. prefix: '汇总-标段信息',
  1152. cols: [
  1153. { name: 'id', field: 'id', type: dataType.int },
  1154. { name: '名称', field: 'name', type: dataType.str },
  1155. { name: '是否特殊标', field: 'spec', type: dataType.str },
  1156. { name: '台账-金额', field: 'tp', type: dataType.currency },
  1157. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  1158. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
  1159. { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
  1160. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
  1161. { name: '截止上期-合同-金额', field: 'pre_contract_tp', type: dataType.currency },
  1162. { name: '截止上期-变更-金额', field: 'pre_qc_tp', type: dataType.currency },
  1163. { name: '截止上期-完成-金额', field: 'pre_gather_tp', type: dataType.currency },
  1164. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
  1165. { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
  1166. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
  1167. { name: '截止上期-应付', field: 'pre_yf_tp', type: dataType.currency },
  1168. { name: '本期-应付', field: 'yf_tp', type: dataType.currency },
  1169. { name: '截止本期-应付', field: 'end_yf_tp', type: dataType.currency },
  1170. { name: '签约清单-金额', field: 'deal_bills_tp', type: dataType.currency },
  1171. { name: '合同信息-建设项目名称', field: 'deal_info.buildName', type: dataType.str },
  1172. { name: '合同信息-合同编号', field: 'deal_info.dealCode', type: dataType.str },
  1173. { name: '合同信息-合同名称', field: 'deal_info.dealName', type: dataType.str },
  1174. { name: '参建单位-建设单位-单位名称', field: 'construction_unit.build.company', type: dataType.str },
  1175. { name: '参建单位-建设单位-法人代表', field: 'construction_unit.build.corporation', type: dataType.str },
  1176. { name: '参建单位-建设单位-签订日期', field: 'construction_unit.build.date', type: dataType.str },
  1177. { name: '参建单位-承包单位1-单位名称', field: 'construction_unit.contract1.company', type: dataType.str },
  1178. { name: '参建单位-承包单位1-法人代表', field: 'construction_unit.contract1.corporation', type: dataType.str },
  1179. { name: '参建单位-承包单位1-签订日期', field: 'construction_unit.contract1.date', type: dataType.str },
  1180. { name: '参建单位-承包单位2-单位名称', field: 'construction_unit.contract2.company', type: dataType.str },
  1181. { name: '参建单位-承包单位2-法人代表', field: 'construction_unit.contract2.corporation', type: dataType.str },
  1182. { name: '参建单位-承包单位2-签订日期', field: 'construction_unit.contract2.date', type: dataType.str },
  1183. { name: '参建单位-监理单位1-单位名称', field: 'construction_unit.supervision1.company', type: dataType.str },
  1184. { name: '参建单位-监理单位1-法人代表', field: 'construction_unit.supervision1.corporation', type: dataType.str },
  1185. { name: '参建单位-监理单位1-签订日期', field: 'construction_unit.supervision1.date', type: dataType.str },
  1186. { name: '参建单位-监理单位2-单位名称', field: 'construction_unit.supervision2.company', type: dataType.str },
  1187. { name: '参建单位-监理单位2-法人代表', field: 'construction_unit.supervision2.corporation', type: dataType.str },
  1188. { name: '参建单位-监理单位2-签订日期', field: 'construction_unit.supervision2.date', type: dataType.str },
  1189. { name: '技术参数-公路等级', field: 'tech_param.loadLevel', type: dataType.int },
  1190. { name: '技术参数-长度(KM)', field: 'tech_param.loadLength', type: dataType.int },
  1191. { name: '技术参数-起始桩号', field: 'tech_param.startPeg', type: dataType.str },
  1192. { name: '技术参数-终止桩号', field: 'tech_param.endPeg', type: dataType.str },
  1193. { name: '技术参数-车道数', field: 'tech_param.laneCount', type: dataType.int },
  1194. { name: '技术参数-合同工期', field: 'tech_param.dealPeriod', type: dataType.str },
  1195. { name: '技术参数-开工日期', field: 'tech_param.startDate', type: dataType.str },
  1196. { name: '技术参数-计划完工日期', field: 'tech_param.planEndDate', type: dataType.str },
  1197. { name: '合同参数-签约合同价', field: 'deal_param.contractPrice', type: dataType.currency },
  1198. { name: '合同参数-暂列金额', field: 'deal_param.zanLiePrice', type: dataType.currency },
  1199. { name: '合同参数-签约合同价(不含暂列金额)', field: 'deal_param.contractPriceWithoutZL', type: dataType.currency },
  1200. { name: '合同参数-签约开工预付款', field: 'deal_param.startAdvance', type: dataType.currency },
  1201. { name: '合同参数-签约材料预付款', field: 'deal_param.materialAdvance', type: dataType.currency },
  1202. { name: '付款账号-工程款账户-开户名称', field: 'pay_account.project.name', type: dataType.str },
  1203. { name: '付款账号-工程款账户-开户银行', field: 'pay_account.project.bank', type: dataType.str },
  1204. { name: '付款账号-工程款账户-开户账号', field: 'pay_account.project.account', type: dataType.str },
  1205. { name: '付款账号-工程款账户-分账划拨比例(%)', field: 'pay_account.project.rate', type: dataType.str },
  1206. { name: '付款账号-工程款账户-联系人', field: 'pay_account.project.contact', type: dataType.str },
  1207. { name: '付款账号-工程款账户-联系电话', field: 'pay_account.project.phone', type: dataType.str },
  1208. { name: '付款账号-农民工工资专用账户-开户名称', field: 'pay_account.worker.name', type: dataType.str },
  1209. { name: '付款账号-农民工工资专用账户-开户银行', field: 'pay_account.worker.bank', type: dataType.str },
  1210. { name: '付款账号-农民工工资专用账户-开户账号', field: 'pay_account.worker.account', type: dataType.str },
  1211. { name: '付款账号-农民工工资专用账户-分账划拨比例(%)', field: 'pay_account.worker.rate', type: dataType.str },
  1212. { name: '付款账号-农民工工资专用账户-联系人', field: 'pay_account.worker.contact', type: dataType.str },
  1213. { name: '付款账号-农民工工资专用账户-联系电话', field: 'pay_account.worker.phone', type: dataType.str },
  1214. { name: '合同信息-工程类别', field: 'deal_info.projectType', type: dataType.str },
  1215. { name: '合同信息-合同类别', field: 'deal_info.dealType', type: dataType.str },
  1216. { name: '合同信息-结算书编号', field: 'deal_info.finalCode', type: dataType.str },
  1217. { name: '技术参数-实际开工日期', field: 'tech_param.realStartDate', type: dataType.str },
  1218. { name: '技术参数-实际完工日期', field: 'tech_param.realEndDate', type: dataType.str },
  1219. { name: '技术参数-构造物规模', field: 'tech_param.structureScale', type: dataType.str },
  1220. { name: '中标信息-业主控制价', field: 'bid_info.controlPrice', type: dataType.currency },
  1221. { name: '中标信息-中标价', field: 'bid_info.bidPrice', type: dataType.currency },
  1222. { name: '中标信息-开标日期', field: 'bid_info.bidStartDate', type: dataType.str },
  1223. ],
  1224. };
  1225. const gather_stage_pay = {
  1226. name: '汇总-期-合同支付 数据表(mem_gather_stage_pay)',
  1227. remark: '',
  1228. id: 38,
  1229. key: 'mem_gather_stage_pay',
  1230. prefix: '汇总-期-合同支付',
  1231. cols: [
  1232. { name: '名称', field: 'name', type: dataType.str },
  1233. { name: '类型', field: 'ptype', type: dataType.int },
  1234. { name: '是否扣款项', field: 'minus', type: dataType.int },
  1235. { name: '是否参与本期应付计算', field: 'is_yf', type: dataType.int },
  1236. { name: '标段id', field: 't_id', type: dataType.int },
  1237. { name: '标段-名称', field: 't_name', type: dataType.str },
  1238. { name: '(标段)本期-金额', field: 't_tp', type: dataType.currency },
  1239. { name: '(标段)截止上期-金额', field: 't_pre_tp', type: dataType.currency },
  1240. { name: '(标段)截止本期-金额', field: 't_end_tp', type: dataType.currency },
  1241. { name: '(合计)本期-金额', field: 's_tp', type: dataType.currency },
  1242. { name: '(合计)截止上期-金额', field: 's_pre_tp', type: dataType.currency },
  1243. { name: '(合计)截止本期-金额', field: 's_end_tp', type: dataType.currency },
  1244. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1245. ],
  1246. };
  1247. const gather_deal_bills = {
  1248. name: '汇总-签约清单 数据表(mem_gather_deal_bills)',
  1249. remark: '',
  1250. id: 39,
  1251. key: 'mem_gather_deal_bills',
  1252. prefix: '汇总-签约清单',
  1253. cols: [
  1254. { name: '编号', field: 'code', type: dataType.str },
  1255. { name: '名称', field: 'name', type: dataType.str },
  1256. { name: '单位', field: 'unit', type: dataType.str },
  1257. { name: '单价', field: 'unit_price', type: dataType.currency },
  1258. { name: '标段id', field: 't_id', type: dataType.int },
  1259. { name: '标段-名称', field: 't_name', type: dataType.str },
  1260. { name: '(标段)金额', field: 't_tp', type: dataType.currency },
  1261. { name: '(合计)金额', field: 's_tp', type: dataType.currency },
  1262. { name: '(特殊1)金额', field: 'ts_key1_tp', type: dataType.currency },
  1263. { name: '(特殊2)金额', field: 'ts_key2_tp', type: dataType.currency },
  1264. { name: '(特殊3)金额', field: 'ts_key3_tp', type: dataType.currency },
  1265. { name: '(标段)数量', field: 't_qty', type: dataType.currency },
  1266. { name: '(合计)数量', field: 's_qty', type: dataType.currency },
  1267. { name: '(特殊1)数量', field: 'ts_key1_qty', type: dataType.currency },
  1268. { name: '(特殊2)数量', field: 'ts_key2_qty', type: dataType.currency },
  1269. { name: '(特殊3)数量', field: 'ts_key3_qty', type: dataType.currency },
  1270. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1271. ],
  1272. };
  1273. // 材差
  1274. const select_material = {
  1275. name: '材料调差-选择期-数据(mem_select_material)',
  1276. remark: '',
  1277. id: 71,
  1278. key: 'mem_select_material',
  1279. prefix: '材料调差-选择期',
  1280. cols: [
  1281. { name: 'id', field: 'id', type: dataType.int },
  1282. { name: '标段id', field: 'tid', type: dataType.int },
  1283. { name: '创建者id', field: 'user_id', type: dataType.int },
  1284. { name: '审批次数', field: 'times', type: dataType.int },
  1285. { name: '审批状态', field: 'status', type: dataType.int },
  1286. { name: '期id列表', field: 'stage_id', type: dataType.str },
  1287. { name: '期order列表', field: 's_order', type: dataType.str },
  1288. { name: '材料调差期数', field: 'order', type: dataType.int },
  1289. { name: '本期金额', field: 'm_tp', type: dataType.currency },
  1290. { name: '截止上期金额', field: 'pre_tp', type: dataType.currency },
  1291. { name: '税率', field: 'rate', type: dataType.int },
  1292. { name: '创建时间', field: 'in_time', type: dataType.str },
  1293. ],
  1294. };
  1295. const select_material_audit = {
  1296. name: '材料调差-选择期-审批人 列表(mem_select_material_audit)',
  1297. remark: '',
  1298. id: 72,
  1299. key: 'mem_select_material_audit',
  1300. prefix: '材料调差-选择期',
  1301. cols: [
  1302. { name: '审批人id', field: 'aid', type: dataType.int },
  1303. { name: '姓名', field: 'name', type: dataType.str },
  1304. { name: '公司', field: 'company', type: dataType.str },
  1305. { name: '角色', field: 'role', type: dataType.str },
  1306. { name: '手机', field: 'mobile', type: dataType.str },
  1307. { name: '电话', field: 'telephone', type: dataType.str },
  1308. { name: '审批意见', field: 'opinion', type: dataType.str },
  1309. { name: '审批时间', field: 'end_time', type: dataType.str },
  1310. { name: '审批顺序', field: 'sort', type: dataType.str },
  1311. ],
  1312. };
  1313. const material = {
  1314. name: '材料调差-期列表-数据(mem_material)',
  1315. remark: '',
  1316. id: 40,
  1317. key: 'mem_material',
  1318. prefix: '材料调差-期列表',
  1319. cols: [
  1320. { name: 'id', field: 'id', type: dataType.int },
  1321. { name: '标段id', field: 'tid', type: dataType.int },
  1322. { name: '创建者id', field: 'user_id', type: dataType.int },
  1323. { name: '审批次数', field: 'times', type: dataType.int },
  1324. { name: '审批状态', field: 'status', type: dataType.int },
  1325. { name: '期id列表', field: 'stage_id', type: dataType.str },
  1326. { name: '期order列表', field: 's_order', type: dataType.str },
  1327. { name: '材料调差期数', field: 'order', type: dataType.int },
  1328. { name: '本期金额', field: 'm_tp', type: dataType.currency },
  1329. { name: '截止上期金额', field: 'pre_tp', type: dataType.currency },
  1330. { name: '税率', field: 'rate', type: dataType.int },
  1331. { name: '创建时间', field: 'in_time', type: dataType.str },
  1332. { name: '月信息价-年月份列表', field: 'months', type: dataType.str },
  1333. { name: '指数本期金额', field: 'ex_tp', type: dataType.currency },
  1334. { name: '指数截止上期金额', field: 'ex_pre_tp', type: dataType.currency },
  1335. { name: '指数调差结果公式', field: 'ex_expr', type: dataType.str },
  1336. { name: '调差基数值json', field: 'ex_calc', type: dataType.str },
  1337. { name: '是否已使用材料税,默认为0', field: 'material_tax', type: dataType.int },
  1338. { name: '材料含税总金额', field: 'm_tax_tp', type: dataType.currency },
  1339. { name: '截止上期材料含税金额', field: 'm_tax_pre_tp', type: dataType.currency },
  1340. { name: '小数位数设置JSON', field: 'decimal', type: dataType.currency },
  1341. { name: '批复时间', field: 'checked_time', type: dataType.str },
  1342. ],
  1343. };
  1344. const materialGl = {
  1345. name: '材料调差-期-调差工料-数据(mem_material_gl)',
  1346. remark: '',
  1347. id: 41,
  1348. key: 'mem_material_gl',
  1349. prefix: '材料调差-期-调差工料',
  1350. cols: [
  1351. { name: 'id', field: 'id', type: dataType.int },
  1352. { name: '标段id', field: 'tid', type: dataType.int },
  1353. { name: '创建期id', field: 'mid', type: dataType.int },
  1354. { name: '调差类型', field: 't_type', type: dataType.int },
  1355. { name: '调差类型s', field: 't_type_str', type: dataType.str },
  1356. { name: '工料分类', field: 'm_type', type: dataType.int },
  1357. { name: '工料分类s', field: 'm_type_str', type: dataType.str },
  1358. { name: '编号', field: 'code', type: dataType.str },
  1359. { name: '名称', field: 'name', type: dataType.str },
  1360. { name: '单位', field: 'unit', type: dataType.str },
  1361. { name: '规格', field: 'spec', type: dataType.str },
  1362. { name: '基准价', field: 'basic_price', type: dataType.currency },
  1363. { name: '基准时间', field: 'basic_time', type: dataType.str },
  1364. { name: '本期信息价-单价', field: 'msg_tp', type: dataType.currency },
  1365. { name: '本期信息价-时间', field: 'msg_times', type: dataType.str },
  1366. { name: '本期信息价-价差', field: 'msg_spread', type: dataType.currency },
  1367. { name: '本期材料调差-上涨幅度', field: 'm_up_risk', type: dataType.int },
  1368. { name: '本期材料调差-下跌幅度', field: 'm_down_risk', type: dataType.int },
  1369. { name: '本期材料调差-有效价差', field: 'm_spread', type: dataType.currency },
  1370. { name: '本期应耗数据', field: 'quantity', type: dataType.currency },
  1371. { name: '计算式', field: 'expr', type: dataType.str },
  1372. { name: '本期-调差金额', field: 'tp', type: dataType.currency },
  1373. { name: '截止上期-调差金额', field: 'pre_tp', type: dataType.currency },
  1374. { name: '截止本期-调差金额', field: 'end_tp', type: dataType.currency },
  1375. { name: '创建时间', field: 'in_time', type: dataType.str },
  1376. { name: '备注', field: 'remark', type: dataType.str },
  1377. { name: '税率', field: 'm_tax', type: dataType.int },
  1378. { name: '调差金额(材料税)', field: 'm_tax_tp', type: dataType.currency },
  1379. { name: '截止上期调差金额(材料税)', field: 'tax_pre_tp', type: dataType.currency },
  1380. ],
  1381. };
  1382. const material_bills = {
  1383. name: '材料调差-清单 数据表(mem_material_bills)',
  1384. remark: '',
  1385. id: 52,
  1386. key: 'mem_material_bills',
  1387. prefix: '材料调差-清单',
  1388. cols: [
  1389. { name: '台账ID', field: 'id', type: dataType.int },
  1390. { name: '标段ID', field: 'tender_id', type: dataType.int },
  1391. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  1392. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  1393. { name: '树结构-层级', field: 'level', type: dataType.int },
  1394. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  1395. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  1396. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  1397. { name: '项目节编号', field: 'code', type: dataType.str },
  1398. { name: '清单编号', field: 'b_code', type: dataType.str },
  1399. { name: '名称', field: 'name', type: dataType.str },
  1400. { name: '单位', field: 'unit', type: dataType.str }, // 12
  1401. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  1402. { name: '签约-数量', field: 'deal_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1403. { name: '签约-金额', field: 'deal_tp', type: dataType.currency, tag: { type: 'tp' } },
  1404. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1405. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency, tag: { type: 'tp' } },
  1406. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1407. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  1408. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1409. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency, tag: { type: 'tp' } },
  1410. { name: '台账-数量', field: 'quantity', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1411. { name: '台账-金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  1412. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  1413. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  1414. { name: '图册号', field: 'drawing_code', type: dataType.str },
  1415. { name: '备注', field: 'memo', type: dataType.str },
  1416. { name: '节点类型', field: 'node_type', type: dataType.int },
  1417. { name: '总额计量', field: 'is_tp', type: dataType.int },
  1418. { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1419. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency, tag: { type: 'tp' } },
  1420. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1421. { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency, tag: { type: 'tp' } },
  1422. { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency, tag: { type: 'qty', unitKey: 12 } },
  1423. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency, tag: { type: 'tp' } },
  1424. { name: '本期批注', field: 'postil', type: dataType.str },
  1425. { name: '预留扩展字段_1', field: 'ex_value1', type: dataType.currency },
  1426. { name: '预留扩展字段_2', field: 'ex_value2', type: dataType.currency },
  1427. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  1428. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  1429. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  1430. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  1431. ],
  1432. };
  1433. const material_pos = {
  1434. name: '材料调差-计量单元(mem_material_pos)',
  1435. remark: '',
  1436. id: 53,
  1437. key: 'mem_material_pos',
  1438. prefix: '材料调差-计量单元',
  1439. cols: [
  1440. { name: 'id', field: 'id', type: dataType.str },
  1441. { name: '所属标段id', field: 'tid', type: dataType.int },
  1442. { name: '所属清单id', field: 'lid', type: dataType.str },
  1443. { name: '名称', field: 'name', type: dataType.str },
  1444. { name: '位置', field: 'position', type: dataType.str },
  1445. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  1446. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  1447. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  1448. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  1449. { name: '图号', field: 'drawing_code', type: dataType.str },
  1450. { name: '排序', field: 'p_order', type: dataType.str },
  1451. { name: '本期-合同计量-数量', field: 'contract_qty', type: dataType.currency },
  1452. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
  1453. { name: '本期-数量变更-变更令', field: 'qc_bgl_code', type: dataType.str },
  1454. { name: '本期-完成计量-数量', field: 'gather_qty', type: dataType.currency },
  1455. { name: '本期批注', field: 'postil', type: dataType.str },
  1456. { name: '施工复核-公式', field: 'sgfh_expr', type: dataType.currency },
  1457. { name: '设计错漏-公式', field: 'sjcl_expr', type: dataType.currency },
  1458. { name: '其他错漏-公式', field: 'qtcl_expr', type: dataType.currency },
  1459. { name: '本期-合同-公式', field: 'contract_expr', type: dataType.currency },
  1460. ],
  1461. };
  1462. const material_gl_detail = {
  1463. name: '材料调差-调差工料明细(mem_material_gl_detail)',
  1464. remark: '',
  1465. id: 54,
  1466. key: 'mem_material_gl_detail',
  1467. prefix: '材料调差-调差工料明细',
  1468. cols: [
  1469. { name: 'id', field: 'id', type: dataType.int },
  1470. { name: '排序', field: 'order', type: dataType.int },
  1471. { name: '所属标段id', field: 'tid', type: dataType.int },
  1472. { name: '创建期id', field: 'mid', type: dataType.int },
  1473. { name: '所属工料id', field: 'mb_id', type: dataType.int },
  1474. { name: '清单id', field: 'gcl_id', type: dataType.int },
  1475. { name: '项目节id', field: 'xmj_id', type: dataType.int },
  1476. { name: '部位明细id', field: 'mx_id', type: dataType.int },
  1477. { name: '本期计量数量-小计', field: 'gather_qty', type: dataType.int },
  1478. { name: '数量', field: 'quantity', type: dataType.int },
  1479. { name: '(空)清单编号', field: 'b_code', type: dataType.str },
  1480. { name: '(空)名称', field: 'name', type: dataType.str },
  1481. { name: '(空)单位', field: 'unit', type: dataType.str },
  1482. { name: '(空)单价', field: 'unit_price', type: dataType.currency },
  1483. { name: '(空)本期-合同-数量', field: 'cur_contract_qty', type: dataType.currency, },
  1484. { name: '(空)本期-合同-金额', field: 'cur_contract_tp', type: dataType.currency, },
  1485. { name: '(空)本期-数量变更-数量', field: 'cur_qc_qty', type: dataType.currency, },
  1486. { name: '(空)本期-数量变更-金额', field: 'cur_qc_tp', type: dataType.currency, },
  1487. { name: '(空)本期-完成-数量', field: 'cur_gather_qty', type: dataType.currency, },
  1488. { name: '(空)本期-完成-金额', field: 'cur_gather_tp', type: dataType.currency, },
  1489. { name: '(空)本期-价差', field: 'jc', type: dataType.currency, },
  1490. { name: '(空)汇总工程量清单id', field: 'gather_gcl_id', type: dataType.int },
  1491. { name: '(空)工料-编号', field: 'gl_code', type: dataType.str },
  1492. { name: '(空)工料-名称', field: 'gl_name', type: dataType.str },
  1493. { name: '(空)工料-单位', field: 'gl_unit', type: dataType.str },
  1494. { name: '(空)工料-规格', field: 'gl_spec', type: dataType.str },
  1495. { name: '(空)基准价', field: 'gl_basic_price', type: dataType.currency },
  1496. { name: '(空)基准时间', field: 'gl_basic_time', type: dataType.str },
  1497. { name: '(空)本期信息价-单价', field: 'gl_msg_tp', type: dataType.currency },
  1498. { name: '(空)本期信息价-时间', field: 'gl_msg_times', type: dataType.str },
  1499. { name: '(空)本期信息价-价差', field: 'gl_msg_spread', type: dataType.currency },
  1500. { name: '(空)本期材料调差-上涨幅度', field: 'gl_m_up_risk', type: dataType.int },
  1501. { name: '(空)本期材料调差-下跌幅度', field: 'gl_m_down_risk', type: dataType.int },
  1502. { name: '(空)本期材料调差-有效价差', field: 'gl_m_spread', type: dataType.currency },
  1503. ]
  1504. };
  1505. const stage_sum_bills = {
  1506. name: '期汇总-清单-交叉数据表(mem_stage_sum_bills)',
  1507. remark: '',
  1508. id: 42,
  1509. key: 'mem_stage_sum_bills',
  1510. prefix: '期汇总-清单-交叉数据',
  1511. cols: [
  1512. { name: '台账ID', field: 'id', type: dataType.int },
  1513. { name: '标段ID', field: 'tender_id', type: dataType.int },
  1514. { name: '树结构-ID', field: 'ledger_id', type: dataType.int },
  1515. { name: '树结构-父项ID', field: 'ledger_pid', type: dataType.int },
  1516. { name: '树结构-层级', field: 'level', type: dataType.int },
  1517. { name: '树结构-同层排序', field: 'order', type: dataType.int },
  1518. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  1519. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int }, // 8
  1520. { name: '项目节编号', field: 'code', type: dataType.str },
  1521. { name: '清单编号', field: 'b_code', type: dataType.str },
  1522. { name: '名称', field: 'name', type: dataType.str },
  1523. { name: '单位', field: 'unit', type: dataType.str }, // 12
  1524. { name: '单价', field: 'unit_price', type: dataType.currency },
  1525. { name: '签约-数量', field: 'deal_qty', type: dataType.currency },
  1526. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  1527. { name: '施工复核-数量', field: 'sgfh_qty', type: dataType.currency },
  1528. { name: '施工复核-金额', field: 'sgfh_tp', type: dataType.currency },
  1529. { name: '设计错漏-数量', field: 'sjcl_qty', type: dataType.currency },
  1530. { name: '设计错漏-金额', field: 'sjcl_tp', type: dataType.currency },
  1531. { name: '其他错漏-数量', field: 'qtcl_qty', type: dataType.currency },
  1532. { name: '其他错漏-金额', field: 'qtcl_tp', type: dataType.currency },
  1533. { name: '台账-数量', field: 'quantity', type: dataType.currency },
  1534. { name: '台账-金额', field: 'total_price', type: dataType.currency },
  1535. { name: '项目节-数量1', field: 'dgn_qty1', type: dataType.currency },
  1536. { name: '项目节-数量2', field: 'dgn_qty2', type: dataType.currency },
  1537. { name: '图册号', field: 'drawing_code', type: dataType.str },
  1538. { name: '备注', field: 'memo', type: dataType.str },
  1539. { name: '节点类型', field: 'node_type', type: dataType.int },
  1540. { name: '总额计量', field: 'is_tp', type: dataType.int },
  1541. { name: '(期)-第几期', field: 's_order', type: dataType.int },
  1542. { name: '(期)-合同-数量', field: 's_contract_qty', type: dataType.currency },
  1543. { name: '(期)-合同-金额', field: 's_contract_tp', type: dataType.currency },
  1544. { name: '(期)-变更-数量', field: 's_qc_qty', type: dataType.currency },
  1545. { name: '(期)-变更-金额', field: 's_qc_tp', type: dataType.currency },
  1546. { name: '(期)-完成-数量', field: 's_gather_qty', type: dataType.currency },
  1547. { name: '(期)-完成-金额', field: 's_gather_tp', type: dataType.currency },
  1548. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1549. ],
  1550. };
  1551. const stage_sum_pay = {
  1552. name: '期汇总-合同支付 数据表(mem_stage_sum_pay)',
  1553. remark: '',
  1554. id: 43,
  1555. key: 'mem_stage_sum_pay',
  1556. prefix: '期汇总-合同支付',
  1557. cols: [
  1558. { name: '名称', field: 'name', type: dataType.str },
  1559. { name: '类型', field: 'ptype', type: dataType.int },
  1560. { name: '是否扣款项', field: 'minus', type: dataType.int },
  1561. { name: '是否参与本期应付计算', field: 'is_yf', type: dataType.int },
  1562. { name: '(期)第几期', field: 's_order', type: dataType.int },
  1563. { name: '(期)本期-金额', field: 't_tp', type: dataType.currency },
  1564. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1565. ],
  1566. };
  1567. const material_sum_gl = {
  1568. name: '材差期汇总-调差工料-交叉数据表(mem_material_sum_gl)',
  1569. remark: '',
  1570. id: 74,
  1571. key: 'mem_material_sum_gl',
  1572. prefix: '材差期汇总-调差工料',
  1573. cols: [
  1574. { name: 'id', field: 'id', type: dataType.int },
  1575. { name: '标段id', field: 'tid', type: dataType.int },
  1576. { name: '调差类型', field: 't_type', type: dataType.int },
  1577. { name: '调差类型s', field: 't_type_str', type: dataType.str },
  1578. { name: '工料分类', field: 'm_type', type: dataType.int },
  1579. { name: '工料分类s', field: 'm_type_str', type: dataType.str },
  1580. { name: '编号', field: 'code', type: dataType.str },
  1581. { name: '名称', field: 'name', type: dataType.str },
  1582. { name: '单位', field: 'unit', type: dataType.str },
  1583. { name: '规格', field: 'spec', type: dataType.str },
  1584. { name: '基准价', field: 'basic_price', type: dataType.currency },
  1585. { name: '基准时间', field: 'basic_time', type: dataType.str },
  1586. { name: '创建时间', field: 'in_time', type: dataType.str },
  1587. { name: '备注', field: 'remark', type: dataType.str },
  1588. { name: '交叉排序', field: 'cross_index', type: dataType.int },
  1589. { name: '(期)第几期', field: 'm_order', type: dataType.int },
  1590. { name: '(期)本期信息价-单价', field: 'm_msg_tp', type: dataType.currency },
  1591. { name: '(期)本期信息价-时间', field: 'm_msg_times', type: dataType.str },
  1592. { name: '(期)本期信息价-价差', field: 'm_msg_spread', type: dataType.currency },
  1593. { name: '(期)本期材料调差-上涨幅度', field: 'm_m_up_risk', type: dataType.int },
  1594. { name: '(期)本期材料调差-下跌幅度', field: 'm_m_down_risk', type: dataType.int },
  1595. { name: '(期)本期材料调差-有效价差', field: 'm_m_spread', type: dataType.currency },
  1596. { name: '(期)本期应耗数据', field: 'm_quantity', type: dataType.currency },
  1597. { name: '(期)计算式', field: 'm_expr', type: dataType.str },
  1598. { name: '(期)本期-调差金额', field: 'm_tp', type: dataType.currency },
  1599. { name: '(期)税率', field: 'm_m_tax', type: dataType.int },
  1600. { name: '(期)调差金额(材料税)', field: 'm_m_tax_tp', type: dataType.currency },
  1601. ],
  1602. };
  1603. const stage_audit = {
  1604. name: '期-审批人 列表(stage_audit)',
  1605. remark: '',
  1606. id: 46,
  1607. key: 'stage_audit',
  1608. prefix: '期-审批人',
  1609. cols: [
  1610. { name: '审批人id', field: 'aid', type: dataType.int },
  1611. { name: '姓名', field: 'name', type: dataType.str },
  1612. { name: '公司', field: 'company', type: dataType.str },
  1613. { name: '角色', field: 'role', type: dataType.str },
  1614. { name: '手机', field: 'mobile', type: dataType.str },
  1615. { name: '电话', field: 'telephone', type: dataType.str },
  1616. { name: '审批意见', field: 'opinion', type: dataType.str },
  1617. { name: '审批时间', field: 'end_time', type: dataType.str },
  1618. { name: '审批顺序', field: 'sort', type: dataType.str },
  1619. ],
  1620. };
  1621. const sign_select = {
  1622. name: '签字(mem_sign_select)',
  1623. remark: '',
  1624. id: 47,
  1625. key: 'mem_sign_select',
  1626. prefix: '签字',
  1627. cols: [
  1628. { name: 'id-1', field: 'sign1.id', type: dataType.int },
  1629. { name: '名字-1', field: 'sign1.name', type: dataType.str },
  1630. { name: '审批意见-1', field: 'sign1.opinion', type: dataType.str },
  1631. { name: '审批时间-1', field: 'sign1.end_time', type: dataType.str },
  1632. { name: '签名-1', field: 'sign1.sign_path', type: dataType.str, isPic: true },
  1633. { name: '协作签名-1', field: 'sign1.co_sign', type: dataType.str, isPic: true },
  1634. { name: 'id-2', field: 'sign2.id', type: dataType.int },
  1635. { name: '名字-2', field: 'sign2.name', type: dataType.str },
  1636. { name: '审批意见-2', field: 'sign2.opinion', type: dataType.str },
  1637. { name: '审批时间-2', field: 'sign2.end_time', type: dataType.str },
  1638. { name: '签名-2', field: 'sign2.sign_path', type: dataType.str, isPic: true },
  1639. { name: '协作签名-2', field: 'sign2.co_sign', type: dataType.str, isPic: true },
  1640. { name: 'id-3', field: 'sign3.id', type: dataType.int },
  1641. { name: '名字-3', field: 'sign3.name', type: dataType.str },
  1642. { name: '审批意见-3', field: 'sign3.opinion', type: dataType.str },
  1643. { name: '审批时间-3', field: 'sign3.end_time', type: dataType.str },
  1644. { name: '签名-3', field: 'sign3.sign_path', type: dataType.str, isPic: true },
  1645. { name: '协作签名-3', field: 'sign3.co_sign', type: dataType.str, isPic: true },
  1646. { name: 'id-4', field: 'sign4.id', type: dataType.int },
  1647. { name: '名字-4', field: 'sign4.name', type: dataType.str },
  1648. { name: '审批意见-4', field: 'sign4.opinion', type: dataType.str },
  1649. { name: '审批时间-4', field: 'sign4.end_time', type: dataType.str },
  1650. { name: '签名-4', field: 'sign4.sign_path', type: dataType.str, isPic: true },
  1651. { name: '协作签名-4', field: 'sign4.co_sign', type: dataType.str, isPic: true },
  1652. { name: 'id-5', field: 'sign5.id', type: dataType.int },
  1653. { name: '名字-5', field: 'sign5.name', type: dataType.str },
  1654. { name: '审批意见-5', field: 'sign5.opinion', type: dataType.str },
  1655. { name: '审批时间-5', field: 'sign5.end_time', type: dataType.str },
  1656. { name: '签名-5', field: 'sign5.sign_path', type: dataType.str, isPic: true },
  1657. { name: '协作签名-5', field: 'sign5.co_sign', type: dataType.str, isPic: true },
  1658. { name: 'id-6', field: 'sign6.id', type: dataType.int },
  1659. { name: '名字-6', field: 'sign6.name', type: dataType.str },
  1660. { name: '审批意见-6', field: 'sign6.opinion', type: dataType.str },
  1661. { name: '审批时间-6', field: 'sign6.end_time', type: dataType.str },
  1662. { name: '签名-6', field: 'sign6.sign_path', type: dataType.str, isPic: true },
  1663. { name: '协作签名-6', field: 'sign6.co_sign', type: dataType.str, isPic: true },
  1664. ],
  1665. };
  1666. const gcl_gather_bills = {
  1667. name: '工程量清单汇总2专用 - 工程量清单',
  1668. remark: '',
  1669. key: 'mem_gcl_gather_bills',
  1670. id: 50,
  1671. prefix: '工程量清单汇总2-清单',
  1672. cols: [
  1673. { name: 'id', field: 'id', type: dataType.int },
  1674. { name: '清单编号', field: 'b_code', type: dataType.str },
  1675. { name: '名称', field: 'name', type: dataType.str },
  1676. { name: '单位', field: 'unit', type: dataType.str },
  1677. { name: '单价', field: 'unit_price', type: dataType.currency },
  1678. { name: '签约清单-数量', field: 'deal_bills_qty', type: dataType.currency },
  1679. { name: '签约清单-金额', field: 'deal_bills_tp', type: dataType.currency },
  1680. { name: '签约-数量', field: 'deal_qty', type: dataType.currency },
  1681. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  1682. { name: '数量', field: 'quantity', type: dataType.currency },
  1683. { name: '金额', field: 'total_price', type: dataType.currency },
  1684. { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency },
  1685. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
  1686. { name: '本期-变更-数量', field: 'qc_qty', type: dataType.currency },
  1687. { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
  1688. { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency },
  1689. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
  1690. { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency },
  1691. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
  1692. { name: '截止本期-变更-数量', field: 'end_qc_qty', type: dataType.currency },
  1693. { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
  1694. { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency },
  1695. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
  1696. { name: '备用1-数量', field: 'spec1_qty', type: dataType.currency },
  1697. { name: '备用1-金额', field: 'spec1_tp', type: dataType.currency },
  1698. { name: '备用2-数量', field: 'spec2_qty', type: dataType.currency },
  1699. { name: '备用2-金额', field: 'spec2_tp', type: dataType.currency },
  1700. { name: '备用3-数量', field: 'spec3_qty', type: dataType.currency },
  1701. { name: '备用3-金额', field: 'spec3_tp', type: dataType.currency },
  1702. { name: '备用4-数量', field: 'spec4_qty', type: dataType.currency },
  1703. { name: '备用4-金额', field: 'spec4_tp', type: dataType.currency },
  1704. { name: '备用5-数量', field: 'spec5_qty', type: dataType.currency },
  1705. { name: '备用5-金额', field: 'spec5_tp', type: dataType.currency },
  1706. { name: '备用6-数量', field: 'spec6_qty', type: dataType.currency },
  1707. { name: '备用6-金额', field: 'spec6_tp', type: dataType.currency },
  1708. ],
  1709. };
  1710. const gcl_gather_xmj = {
  1711. name: '工程量清单汇总2专用 - 相关项目节',
  1712. remark: '',
  1713. key: 'mem_gcl_gather_xmj',
  1714. id: 51,
  1715. prefix: '工程量清单汇总2-项目节',
  1716. cols: [
  1717. { name: '清单id(所属工程量清单id)', field: 'gcl_id', type: dataType.int },
  1718. { name: '明细id(在台账中的id)', field: 'mx_id', type: dataType.str },
  1719. { name: '编号', field: 'code', type: dataType.str },
  1720. { name: '计量单元', field: 'jldy', type: dataType.str },
  1721. { name: '分部工程', field: 'fbgc', type: dataType.str },
  1722. { name: '分项工程', field: 'fxgc', type: dataType.str },
  1723. { name: '单位工程', field: 'dwgc', type: dataType.str },
  1724. { name: '部位明细', field: 'bwmx', type: dataType.str },
  1725. { name: '图册号', field: 'drawing_code', type: dataType.str },
  1726. { name: '数量', field: 'quantity', type: dataType.currency },
  1727. { name: '本期-合同-数量', field: 'contract_qty', type: dataType.currency },
  1728. { name: '本期-变更-数量', field: 'qc_qty', type: dataType.currency },
  1729. { name: '本期-完成-数量', field: 'gather_qty', type: dataType.currency },
  1730. { name: '截止本期-合同-数量', field: 'end_contract_qty', type: dataType.currency },
  1731. { name: '截止本期-变更-数量', field: 'end_qc_qty', type: dataType.currency },
  1732. { name: '截止本期-完成-数量', field: 'end_gather_qty', type: dataType.currency },
  1733. { name: '备用1-数量', field: 'spec1_qty', type: dataType.currency },
  1734. { name: '备用2-数量', field: 'spec2_qty', type: dataType.currency },
  1735. { name: '备用3-数量', field: 'spec3_qty', type: dataType.currency },
  1736. { name: '备用4-数量', field: 'spec4_qty', type: dataType.currency },
  1737. { name: '备用5-数量', field: 'spec5_qty', type: dataType.currency },
  1738. { name: '备用6-数量', field: 'spec6_qty', type: dataType.currency },
  1739. { name: 'id(项目节id)', field: 'id', type: dataType.int },
  1740. ],
  1741. };
  1742. const ledger_tag = {
  1743. name: '台账书签(仅显示当前登录用户可见书签)',
  1744. remark: '',
  1745. key: 'mem_ledger_tag',
  1746. id: 55,
  1747. prefix: '台账书签',
  1748. cols: [
  1749. { name: 'id', field: 'id', type: dataType.int },
  1750. { name: '创建用户', field: 'uid', type: dataType.int },
  1751. { name: '台账id(uuid)', field: 'lid', type: dataType.str },
  1752. { name: '是否共享', field: 'share', type: dataType.int },
  1753. { name: '书签颜色', field: 'color', type: dataType.str },
  1754. { name: '批注', field: 'comment', type: dataType.str },
  1755. { name: '创建时间', field: 'create_time', type: dataType.time },
  1756. { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
  1757. ],
  1758. };
  1759. const stage_tag = {
  1760. name: '期 - 台账书签(仅显示当前登录用户可见书签)',
  1761. remark: '',
  1762. key: 'mem_stage_tag',
  1763. id: 56,
  1764. prefix: '期 - 台账书签',
  1765. cols: [
  1766. { name: 'id', field: 'id', type: dataType.int },
  1767. { name: '创建用户', field: 'uid', type: dataType.int },
  1768. { name: '台账id(uuid)', field: 'lid', type: dataType.str },
  1769. { name: '是否共享', field: 'share', type: dataType.int },
  1770. { name: '书签颜色', field: 'color', type: dataType.str },
  1771. { name: '批注', field: 'comment', type: dataType.str },
  1772. { name: '创建时间', field: 'create_time', type: dataType.time },
  1773. { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
  1774. ],
  1775. };
  1776. const all_tag = {
  1777. name: '全部书签(台账&全部期&所有人)',
  1778. remark: '',
  1779. key: 'mem_all_tag',
  1780. id: 57,
  1781. prefix: '期 - 台账书签',
  1782. cols: [
  1783. { name: 'id', field: 'id', type: dataType.int },
  1784. { name: '创建用户', field: 'uid', type: dataType.int },
  1785. { name: '台账id(uuid)', field: 'lid', type: dataType.str },
  1786. { name: '期id(-1表示台账)', field: 'sid', type: dataType.str },
  1787. { name: '期序号(-1表示)', field: 'sorder', type: dataType.str },
  1788. { name: '是否共享', field: 'share', type: dataType.int },
  1789. { name: '书签颜色', field: 'color', type: dataType.str },
  1790. { name: '批注', field: 'comment', type: dataType.str },
  1791. { name: '创建时间', field: 'create_time', type: dataType.time },
  1792. { name: '最后编辑时间', field: 'modify_time', type: dataType.time },
  1793. ],
  1794. };
  1795. const stage_change_bills = {
  1796. name: '期-变更清单 调用明细(mem_stage_change_bills)',
  1797. remark: '',
  1798. key: 'mem_stage_change_bills',
  1799. id: 48,
  1800. prefix: '期-变更清单 调用明细',
  1801. cols: [
  1802. { name: '变更令id', field: 'cid', type: dataType.str },
  1803. { name: '变更清单id', field: 'cbid', type: dataType.int },
  1804. { name: '变更数量', field: 'qty', type: dataType.int },
  1805. { name: '变更令-批复编号', field: 'c_code', type: dataType.str },
  1806. { name: '变更令-变更名称', field: 'c_name', type: dataType.str },
  1807. { name: '变更令-变更图号', field: 'c_new_code', type: dataType.str },
  1808. { name: '变更令-变更设计图名称', field: 'c_new_name', type: dataType.str },
  1809. { name: '变更令-工程变更理由及内容', field: 'c_content', type: dataType.str },
  1810. { name: '变更令-工程变更合同依据', field: 'c_basis', type: dataType.str },
  1811. { name: '变更令-变更状态发生时间', field: 'c_cin_time', type: dataType.str },
  1812. { name: '变更清单-清单编号', field: 'b_code', type: dataType.str },
  1813. { name: '变更清单-名称', field: 'name', type: dataType.str },
  1814. { name: '变更清单-单位', field: 'unit', type: dataType.str },
  1815. { name: '变更清单-单价', field: 'unit_price', type: dataType.str },
  1816. { name: '变更令-变更类型', field: 'c_type', type: dataType.str },
  1817. { name: '变更令-变更类别', field: 'c_class', type: dataType.int },
  1818. { name: '变更令-变更性质', field: 'c_quality', type: dataType.int },
  1819. { name: '调用期-序号', field: 's_order', type: dataType.int },
  1820. ],
  1821. };
  1822. const stage_change_ledger = {
  1823. name: '期-变更台账(mem_stage_change_ledger)',
  1824. remark: '',
  1825. key: 'mem_stage_change_ledger',
  1826. id: 49,
  1827. prefix: '期-变更台账',
  1828. cols: [
  1829. { name: '项目节编号', field: 'code', type: dataType.str },
  1830. { name: '名称', field: 'name', type: dataType.str },
  1831. { name: '台账-金额', field: 'total_price', type: dataType.currency },
  1832. { name: '签约-金额', field: 'deal_tp', type: dataType.currency },
  1833. { name: '本期-合同-金额', field: 'contract_tp', type: dataType.currency },
  1834. { name: '本期-变更-金额', field: 'qc_tp', type: dataType.currency },
  1835. { name: '本期-完成-金额', field: 'gather_tp', type: dataType.currency },
  1836. { name: '截止本期-合同-金额', field: 'end_contract_tp', type: dataType.currency },
  1837. { name: '截止本期-变更-金额', field: 'end_qc_tp', type: dataType.currency },
  1838. { name: '截止本期-完成-金额', field: 'end_gather_tp', type: dataType.currency },
  1839. { name: '变更令-批复编号', field: 'c_code', type: dataType.str },
  1840. { name: '变更令-变更名称', field: 'c_name', type: dataType.str },
  1841. { name: '变更令-变更图号', field: 'c_new_code', type: dataType.str },
  1842. { name: '变更令-变更设计图名称', field: 'c_new_name', type: dataType.str },
  1843. { name: '变更令-工程变更理由及内容', field: 'c_content', type: dataType.str },
  1844. { name: '变更令-工程变更合同依据', field: 'c_basis', type: dataType.str },
  1845. { name: '变更令-变更状态发生时间', field: 'c_cin_time', type: dataType.str },
  1846. ],
  1847. };
  1848. const stage_change = {
  1849. name: '本期-变更清单-全审批人 调用明细(mem_stage_change)',
  1850. remark: '',
  1851. key: 'mem_stage_change',
  1852. id: 60,
  1853. prefix: '本期-变更清单-全审批人 调用明细',
  1854. cols: [
  1855. { name: 'id', field: 'id', type: dataType.str },
  1856. { name: '标段id', field: 'tid', type: dataType.str },
  1857. { name: '期id', field: 'sid', type: dataType.str },
  1858. { name: '台账id', field: 'lid', type: dataType.str },
  1859. { name: '计量单元id', field: 'pid', type: dataType.str },
  1860. { name: '变更令id', field: 'cid', type: dataType.str },
  1861. { name: '变更清单id', field: 'cbid', type: dataType.int },
  1862. { name: '期-调用人-第几轮', field: 'stimes', type: dataType.str },
  1863. { name: '期-调用人-排序', field: 'sorder', type: dataType.str },
  1864. { name: '变更数量', field: 'qty', type: dataType.int },
  1865. ],
  1866. };
  1867. const stage_change_info = {
  1868. name: '变更概况(mem_change_info)',
  1869. remark: '',
  1870. id: 65,
  1871. key: 'mem_change_info',
  1872. prefix: '变更概况',
  1873. cols: [
  1874. { name: '变更令id', field: 'cid', type: dataType.str },
  1875. { name: '变更令号', field: 'code', type: dataType.str },
  1876. { name: '批复文号', field: 'w_code', type: dataType.str },
  1877. { name: '批复编号', field: 'p_code', type: dataType.str },
  1878. { name: '变更名称', field: 'name', type: dataType.str },
  1879. { name: '桩号', field: 'peg', type: dataType.str },
  1880. { name: '原设计图名称', field: 'org_name', type: dataType.str },
  1881. { name: '原图号', field: 'org_code', type: dataType.str },
  1882. { name: '变更设计图名称', field: 'new_name', type: dataType.str },
  1883. { name: '变更图号', field: 'new_code', type: dataType.str },
  1884. { name: '工程变更理由及内容', field: 'content', type: dataType.str },
  1885. { name: '工程变更合同依据', field: 'basis', type: dataType.str },
  1886. { name: '变更工程量数量计算式', field: 'expr', type: dataType.str },
  1887. { name: '备注', field: 'memo', type: dataType.str },
  1888. { name: '变更类型', field: 'type', type: dataType.str },
  1889. { name: '变更类别', field: 'class', type: dataType.int },
  1890. { name: '变更性质', field: 'quality', type: dataType.int },
  1891. { name: '变更提出单位', field: 'company', type: dataType.str },
  1892. { name: '费用承担方', field: 'charge', type: dataType.int },
  1893. { name: '金额', field: 'total_price', type: dataType.currency, tag: { type: 'tp' } },
  1894. { name: '变更状态发生时间(时间戳)', field: 'cin_time', type: dataType.str },
  1895. { name: '完成审批时间(时间戳)', field: 'sin_time', type: dataType.str },
  1896. { name: '金额_1', field: 'tp_1', type: dataType.currency, tag: { type: 'tp' } },
  1897. { name: '金额_2', field: 'tp_2', type: dataType.currency, tag: { type: 'tp' } },
  1898. { name: '金额_3', field: 'tp_3', type: dataType.currency, tag: { type: 'tp' } },
  1899. { name: '金额_4', field: 'tp_4', type: dataType.currency, tag: { type: 'tp' } },
  1900. { name: '金额_5', field: 'tp_5', type: dataType.currency, tag: { type: 'tp' } },
  1901. { name: '金额_6', field: 'tp_6', type: dataType.currency, tag: { type: 'tp' } },
  1902. { name: '金额_7', field: 'tp_7', type: dataType.currency, tag: { type: 'tp' } },
  1903. { name: '金额_8', field: 'tp_8', type: dataType.currency, tag: { type: 'tp' } },
  1904. { name: '金额_9', field: 'tp_9', type: dataType.currency, tag: { type: 'tp' } },
  1905. { name: '附件名称列表', field: 'attNames', type: dataType.currency },
  1906. { name: '截止本期-已执行(%)', field: 'used_ratio', type: dataType.currency },
  1907. { name: '本期使用', field: 'cur_used', type: dataType.int },
  1908. ],
  1909. };
  1910. const stage_change_info_bills = {
  1911. name: '变更概况-清单(mem_change_info_bills)',
  1912. remark: '',
  1913. id: 66,
  1914. key: 'mem_change_info_bills',
  1915. prefix: '变更概况-清单',
  1916. cols: [
  1917. { name: '变更令id', field: 'cid', type: dataType.str },
  1918. { name: '签约清单id或台账id', field: 'lid', type: dataType.str },
  1919. { name: '清单编号', field: 'code', type: dataType.str },
  1920. { name: '名称', field: 'name', type: dataType.str },
  1921. { name: '单位', field: 'unit', type: dataType.str },
  1922. { name: '单价', field: 'unit_price', type: dataType.currency, tag: { type: 'up' } },
  1923. { name: '变更详情', field: 'detail', type: dataType.str },
  1924. { name: '变更部位', field: 'bwmx', type: dataType.str },
  1925. { name: '数量', field: 'qty', type: dataType.currency },
  1926. { name: '金额', field: 'tp', type: dataType.currency },
  1927. { name: '截止本期-已变更', field: 'used_qty', type: dataType.currency },
  1928. { name: '可执行', field: 'valid_qty', type: dataType.currency },
  1929. { name: '本期使用数量', field: 'cur_qty', type: dataType.currency },
  1930. { name: '本期使用', field: 'cur_used', type: dataType.int },
  1931. ],
  1932. };
  1933. // 定制表
  1934. // 季华项目 中间计量报表--变更相关 汇总对比表
  1935. const jh_im_change = {
  1936. name: '【定制】季华-中间计量-变更 数据表(mem_jh_im_change)',
  1937. remark: '',
  1938. id: 61,
  1939. key: 'mem_jh_im_change',
  1940. prefix: '【定制】季华-中间计量-变更',
  1941. cols: [
  1942. { name: '清单编号', field: 'b_code', type: dataType.str },
  1943. { name: '名称', field: 'name', type: dataType.str },
  1944. { name: '单位', field: 'unit', type: dataType.str }, // 12
  1945. { name: '单价', field: 'unit_price', type: dataType.currency },
  1946. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  1947. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency },
  1948. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
  1949. { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency },
  1950. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
  1951. { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency },
  1952. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
  1953. { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency },
  1954. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
  1955. { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency },
  1956. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
  1957. { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency },
  1958. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
  1959. { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency },
  1960. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
  1961. { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency },
  1962. ],
  1963. };
  1964. const jh_gather_im_change = {
  1965. name: '【定制】季华-中间计量-变更-汇总 数据表(mem_jh_gather_im_change)',
  1966. remark: '',
  1967. id: 62,
  1968. key: 'mem_jh_gather_im_change',
  1969. prefix: '【定制】季华-中间计量-变更-汇总',
  1970. cols: [
  1971. { name: '清单编号', field: 'b_code', type: dataType.str },
  1972. { name: '名称', field: 'name', type: dataType.str },
  1973. { name: '单位', field: 'unit', type: dataType.str },
  1974. { name: '单价', field: 'unit_price', type: dataType.currency },
  1975. { name: '截止上期-数量变更-数量', field: 'pre_qc_qty', type: dataType.currency },
  1976. { name: '截止上期-数量变更-金额', field: 'pre_qc_tp', type: dataType.currency },
  1977. { name: '本期-数量变更-数量', field: 'qc_qty', type: dataType.currency },
  1978. { name: '本期-数量变更-金额', field: 'qc_tp', type: dataType.currency },
  1979. { name: '截止本期-数量变更-数量', field: 'end_qc_qty', type: dataType.currency },
  1980. { name: '截止本期-数量变更-金额', field: 'end_qc_tp', type: dataType.currency },
  1981. { name: '本期-数量变更-数量_0', field: 'r0_qc_qty', type: dataType.currency },
  1982. { name: '本期-数量变更-金额_0', field: 'r0_qc_tp', type: dataType.currency },
  1983. { name: '本期-数量变更-数量_1', field: 'r1_qc_qty', type: dataType.currency },
  1984. { name: '本期-数量变更-金额_1', field: 'r1_qc_tp', type: dataType.currency },
  1985. { name: '本期-数量变更-数量_2', field: 'r2_qc_qty', type: dataType.currency },
  1986. { name: '本期-数量变更-金额_2', field: 'r2_qc_tp', type: dataType.currency },
  1987. { name: '本期-数量变更-数量_3', field: 'r3_qc_qty', type: dataType.currency },
  1988. { name: '本期-数量变更-金额_3', field: 'r3_qc_tp', type: dataType.currency },
  1989. { name: '本期-数量变更-数量_4', field: 'r4_qc_qty', type: dataType.currency },
  1990. { name: '本期-数量变更-金额_4', field: 'r4_qc_tp', type: dataType.currency },
  1991. ],
  1992. };
  1993. const jh_gather_stage_bills_compare = {
  1994. name: '【定制】季华-期-清单-汇总-多审 数据表(mem_jh_gather_stage_bills_compare)',
  1995. remark: '',
  1996. id: 64,
  1997. key: 'mem_jh_gather_stage_bills_compare',
  1998. prefix: '【定制】季华-期-清单-汇总-多审',
  1999. cols: [
  2000. { name: '项目节编号', field: 'code', type: dataType.str },
  2001. { name: '清单编号', field: 'b_code', type: dataType.str },
  2002. { name: '名称', field: 'name', type: dataType.str },
  2003. { name: '单位', field: 'unit', type: dataType.str },
  2004. { name: '单价', field: 'unit_price', type: dataType.currency },
  2005. { name: '(合计)台账-数量', field: 's_qty', type: dataType.currency },
  2006. { name: '(合计)台账-金额', field: 's_tp', type: dataType.currency },
  2007. { name: '(合计)本期-合同-数量', field: 's_contract_qty', type: dataType.currency },
  2008. { name: '(合计)本期-合同-金额', field: 's_contract_tp', type: dataType.currency },
  2009. { name: '(合计)本期-变更-数量', field: 's_qc_qty', type: dataType.currency },
  2010. { name: '(合计)本期-变更-金额', field: 's_qc_tp', type: dataType.currency },
  2011. { name: '(合计)本期-完成-数量', field: 's_gather_qty', type: dataType.currency },
  2012. { name: '(合计)本期-完成-金额', field: 's_gather_tp', type: dataType.currency },
  2013. { name: '(合计)截止上期-合同-数量', field: 's_pre_contract_qty', type: dataType.currency },
  2014. { name: '(合计)截止上期-合同-金额', field: 's_pre_contract_tp', type: dataType.currency },
  2015. { name: '(合计)截止上期-变更-数量', field: 's_pre_qc_qty', type: dataType.currency },
  2016. { name: '(合计)截止上期-变更-金额', field: 's_pre_qc_tp', type: dataType.currency },
  2017. { name: '(合计)截止上期-完成-数量', field: 's_pre_gather_qty', type: dataType.currency },
  2018. { name: '(合计)截止上期-完成-金额', field: 's_pre_gather_tp', type: dataType.currency },
  2019. { name: '(合计)截止本期-合同-数量', field: 's_end_contract_qty', type: dataType.currency },
  2020. { name: '(合计)截止本期-合同-金额', field: 's_end_contract_tp', type: dataType.currency },
  2021. { name: '(合计)截止本期-变更-数量', field: 's_end_qc_qty', type: dataType.currency },
  2022. { name: '(合计)截止本期-变更-金额', field: 's_end_qc_tp', type: dataType.currency },
  2023. { name: '(合计)截止本期-完成-数量', field: 's_end_gather_qty', type: dataType.currency },
  2024. { name: '(合计)截止本期-完成-金额', field: 's_end_gather_tp', type: dataType.currency },
  2025. { name: '(原报)本期-合同-数量', field: 'r0_contract_qty', type: dataType.currency },
  2026. { name: '(原报)本期-合同-金额', field: 'r0_contract_tp', type: dataType.currency },
  2027. { name: '(原报)本期-变更-数量', field: 'r0_qc_qty', type: dataType.currency },
  2028. { name: '(原报)本期-变更-金额', field: 'r0_qc_tp', type: dataType.currency },
  2029. { name: '(原报)本期-完成-数量', field: 'r0_gather_qty', type: dataType.currency },
  2030. { name: '(原报)本期-完成-金额', field: 'r0_gather_tp', type: dataType.currency },
  2031. { name: '(1审)本期-合同-数量', field: 'r1_contract_qty', type: dataType.currency },
  2032. { name: '(1审)本期-合同-金额', field: 'r1_contract_tp', type: dataType.currency },
  2033. { name: '(1审)本期-变更-数量', field: 'r1_qc_qty', type: dataType.currency },
  2034. { name: '(1审)本期-变更-金额', field: 'r1_qc_tp', type: dataType.currency },
  2035. { name: '(1审)本期-完成-数量', field: 'r1_gather_qty', type: dataType.currency },
  2036. { name: '(1审)本期-完成-金额', field: 'r1_gather_tp', type: dataType.currency },
  2037. { name: '(2审)本期-合同-数量', field: 'r2_contract_qty', type: dataType.currency },
  2038. { name: '(2审)本期-合同-金额', field: 'r2_contract_tp', type: dataType.currency },
  2039. { name: '(2审)本期-变更-数量', field: 'r2_qc_qty', type: dataType.currency },
  2040. { name: '(2审)本期-变更-金额', field: 'r2_qc_tp', type: dataType.currency },
  2041. { name: '(2审)本期-完成-数量', field: 'r2_gather_qty', type: dataType.currency },
  2042. { name: '(2审)本期-完成-金额', field: 'r2_gather_tp', type: dataType.currency },
  2043. { name: '(3审)本期-合同-数量', field: 'r3_contract_qty', type: dataType.currency },
  2044. { name: '(3审)本期-合同-金额', field: 'r3_contract_tp', type: dataType.currency },
  2045. { name: '(3审)本期-变更-数量', field: 'r3_qc_qty', type: dataType.currency },
  2046. { name: '(3审)本期-变更-金额', field: 'r3_qc_tp', type: dataType.currency },
  2047. { name: '(3审)本期-完成-数量', field: 'r3_gather_qty', type: dataType.currency },
  2048. { name: '(3审)本期-完成-金额', field: 'r3_gather_tp', type: dataType.currency },
  2049. { name: '树结构-id', field: 'id', type: dataType.int },
  2050. { name: '树结构-父项id', field: 'pid', type: dataType.int },
  2051. { name: '树结构-层次', field: 'level', type: dataType.int },
  2052. { name: '树结构-排序', field: 'order', type: dataType.int },
  2053. { name: '树结构-完整路径', field: 'full_path', type: dataType.str },
  2054. { name: '树结构-是否子项', field: 'is_leaf', type: dataType.int },
  2055. ],
  2056. };
  2057. const custom_select = {
  2058. name: '【用户交互】用户选择信息 数据表(mem_custom_select)',
  2059. remark: '',
  2060. id: 63,
  2061. key: 'mem_custom_select',
  2062. prefix: '【用户交互】用户选择信息',
  2063. cols: [
  2064. // audit_select
  2065. { name: '审批人选择-id', field: 'audit_select.aid', type: dataType.arr, map: 'arr' },
  2066. { name: '审批人选择-名称', field: 'audit_select.name', type: dataType.arr, map: 'arr' },
  2067. { name: '审批人选择-单位', field: 'audit_select.company', type: dataType.arr, map: 'arr' },
  2068. { name: '审批人选择-角色', field: 'audit_select.role', type: dataType.arr, map: 'arr' },
  2069. { name: '审批人选择-审批轮', field: 'audit_select.times', type: dataType.arr, map: 'arr' },
  2070. { name: '审批人选择-审批顺序', field: 'audit_select.order', type: dataType.arr, map: 'arr' },
  2071. // gather_select
  2072. { name: '标段汇总-类型', field: 'gather_select.type', type: dataType.str },
  2073. { name: '标段汇总-汇总年月', field: 'gather_select.month', type: dataType.str },
  2074. { name: '标段汇总-汇总区间(时间)', field: 'gather_select.zone', type: dataType.str },
  2075. { name: '标段汇总-汇总期', field: 'gather_select.stage', type: dataType.int },
  2076. { name: '标段汇总-汇总区间(期)', field: 'gather_select.stage_zone', type: dataType.int },
  2077. // stage_select
  2078. { name: '期汇总-选择期', field: 'stage_select.stages', type: dataType.str},
  2079. // change_select
  2080. { name: '变更令', field: 'change_select', type: dataType.arr, map: 'arr'}
  2081. ]
  2082. };
  2083. const recursiveMkdirSync = async function(pathName) {
  2084. if (!fs.existsSync(pathName)) {
  2085. const upperPath = path.dirname(pathName);
  2086. if (!fs.existsSync(upperPath)) {
  2087. await this.recursiveMkdirSync(upperPath);
  2088. }
  2089. await fs.mkdirSync(pathName);
  2090. }
  2091. };
  2092. const saveBufferFile = async function(buffer, fileName) {
  2093. // 检查文件夹是否存在,不存在则直接创建文件夹
  2094. const pathName = path.dirname(fileName);
  2095. if (!fs.existsSync(pathName)) {
  2096. await recursiveMkdirSync(pathName);
  2097. }
  2098. await fs.writeFileSync(fileName, buffer);
  2099. };
  2100. const addFields = function(table, col) {
  2101. const data = {};
  2102. data.ID = table.ID * 100 + (col.id ? Math.max(table.items.length + 1, col.id) : table.items.length + 1);
  2103. data.Name = col.name + (col.field ? '(' + col.field + ')' : '') + (data.ID ? '(id: ' + data.ID + ')' : '');
  2104. if (table.prefix && table.prefix !== '') data.Name = table.prefix + '-' + data.Name;
  2105. data.DataType = col.type;
  2106. data.TableName = table.key;
  2107. data.descr = '';
  2108. if (col.map && col.map === 'arr') {
  2109. data.mapExpression = `$PROJECT.REPORT.getArrayProperty('${table.key}', '${col.field}')`;
  2110. } else {
  2111. data.mapExpression = `$PROJECT.REPORT.getProperty('${table.key}', '${col.field}')`;
  2112. }
  2113. if (col.tag) {
  2114. switch (tag.type) {
  2115. case 'up':
  2116. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')" };
  2117. break;
  2118. case 'tp':
  2119. if (col.tag.subType) {
  2120. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal." + '_' + col.tag.subType + "_tp')" };
  2121. } else {
  2122. data.Precision = { type: 'fixed', fixedMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" };
  2123. }
  2124. break;
  2125. case 'qty':
  2126. data.Precision = { type: 'flexible', flexibleRefFieldID: table.ID * 100 + tag.unitKey, flexibleMapExpression: "$PROJECT.REPORT.getProperty('tender_info', 'precision')" };
  2127. break;
  2128. }
  2129. }
  2130. if (col.isPic) {
  2131. data.isPic = true;
  2132. }
  2133. table.items.push(data);
  2134. };
  2135. const saveTableDefine = async function(tableDefine, file) {
  2136. delete tableDefine.ID;
  2137. delete tableDefine.key;
  2138. delete tableDefine.prefix;
  2139. let defineStr = JSON.stringify(tableDefine, '', '\t');
  2140. const replaceStr = [
  2141. { match: '"Name":', str: 'Name:' },
  2142. { match: '"remark":', str: 'remark:' },
  2143. { match: '"items":', str: 'items:' },
  2144. { match: '"ID":', str: 'ID:' },
  2145. { match: '"DataType":', str: 'DataType:' },
  2146. { match: '"TableName":', str: 'TableName:' },
  2147. { match: '"descr":', str: 'descr:' },
  2148. { match: '"mapExpression":', str: 'mapExpression:' },
  2149. { match: '"Precision":', str: 'Precision:' },
  2150. { match: '"type":', str: 'type:' },
  2151. { match: '"flexibleRefFieldID":', str: 'flexibleRefFieldID:' },
  2152. { match: '"fixedMapExpression":', str: 'fixedMapExpression:' },
  2153. { match: '"flexibleMapExpression":', str: 'flexibleMapExpression:' },
  2154. ];
  2155. for (const rs of replaceStr) {
  2156. const reg = new RegExp(rs.match, 'gm');
  2157. defineStr = defineStr.replace(reg, rs.str);
  2158. }
  2159. await saveBufferFile(defineStr, file);
  2160. };
  2161. const exportTableDefine = async function(define) {
  2162. const tableDefine = {};
  2163. tableDefine.Name = define.name;// '期-清单-全参与人数据表(mem_stage_bills_compare)';
  2164. tableDefine.remark = define.remark;
  2165. tableDefine.ID = define.id;
  2166. tableDefine.key = define.key;
  2167. tableDefine.items = [];
  2168. tableDefine.prefix = define.prefix;
  2169. for (const col of define.cols) {
  2170. addFields(tableDefine, col);
  2171. }
  2172. addFields(tableDefine, { id: 99, name: '空白', field: '', type: dataType.str });
  2173. await saveTableDefine(tableDefine, path.join(savePath, define.key + '_define.json'));
  2174. };
  2175. const defines = [
  2176. ledger_cooperation,
  2177. advance_pay,
  2178. union_data,
  2179. month_progress,
  2180. stage_bills, stage_bills_compare,
  2181. stage_jgcl, stage_bonus, stage_other, stage_safe_prod, stage_temp_land,
  2182. change, change_bills, change_audit,
  2183. change_apply, change_apply_audit, change_project, change_project_audit,
  2184. stage_pos, stage_pos_compare,
  2185. stage_pay,
  2186. stage_im_zl, stage_im_tz, stage_im_tz_bills,
  2187. stage_rela_im, stage_rela_im_bills,
  2188. gather_stage_bills, gather_tender_info, gather_stage_pay, gather_deal_bills,
  2189. select_material, select_material_audit, material, materialGl, material_bills, material_pos, material_gl_detail,
  2190. stage_sum_bills, stage_sum_pay, material_sum_gl,
  2191. stage_audit, sign_select,
  2192. stage_change, stage_change_bills, stage_change_ledger,
  2193. gcl_gather_bills, gcl_gather_xmj,
  2194. ledger_tag, stage_tag, all_tag,
  2195. jh_im_change, jh_gather_im_change, jh_gather_stage_bills_compare,
  2196. custom_select,
  2197. stage_change_info, stage_change_info_bills,
  2198. ];
  2199. for (const d of defines) {
  2200. exportTableDefine(d);
  2201. }