支表2 中期支付证书.js 59 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370
  1. {
  2. "ID_KEY": "DUMMY_FLOW_SAMPLE",
  3. "GROUP_KEY": "RPT_支表2 中期支付证书_SAMPLE_TPL",
  4. "主信息": {
  5. "单位": "厘米",
  6. "版本": {
  7. "主版本": "3",
  8. "功能版本": "0"
  9. },
  10. "页边距": {
  11. "Top": "1.0",
  12. "Left": "1.0",
  13. "Right": "1.0",
  14. "Bottom": "1.0"
  15. },
  16. "报表名称": "支表2 中期支付证书",
  17. "打印页面_信息": {
  18. "方向": "LANDSCAPE",
  19. "页规格": "A4"
  20. }
  21. },
  22. "布局框_集合": [
  23. {
  24. "Alignment": "Top",
  25. "DisplayType": "EveryPage",
  26. "Height": "1.6",
  27. "Name": "TitleBand",
  28. "control": "Default",
  29. "style": "Default_None",
  30. "MergeBorder": "F"
  31. },
  32. {
  33. "Alignment": "Top",
  34. "DisplayType": "EveryPage",
  35. "Height": "1.80",
  36. "Name": "HeaderBand",
  37. "control": "Default",
  38. "style": "Default_None",
  39. "MergeBorder": "F"
  40. },
  41. {
  42. "Alignment": "Bottom",
  43. "DisplayType": "EveryPage",
  44. "Height": "0.6",
  45. "Name": "FooterBand",
  46. "control": "Default",
  47. "style": "Default_None",
  48. "MergeBorder": "F"
  49. },
  50. {
  51. "Alignment": "Fulfill",
  52. "DisplayType": "EveryPage",
  53. "Name": "Report Body",
  54. "control": "Default",
  55. "style": "BORDER_ALL_AROUND",
  56. "MergeBorder": "T",
  57. "band_s": [
  58. {
  59. "Alignment": "Top",
  60. "DisplayType": "EveryPage",
  61. "Height": "1.80",
  62. "Name": "ColumnBand",
  63. "control": "Default",
  64. "style": "Default_None",
  65. "MergeBorder": "F"
  66. },
  67. {
  68. "Alignment": "Fulfill",
  69. "DisplayType": "EveryPage",
  70. "Name": "ContentBand",
  71. "control": "Default",
  72. "style": "Default_None",
  73. "MergeBorder": "F"
  74. }
  75. ]
  76. }
  77. ],
  78. "计算式_集合": [
  79. {
  80. "Name": "获取打印时间",
  81. "run_type": "before_paging",
  82. "expression": "let rpt = $JE.P(5001,$CURRENT_RPT);\n let dt = new Date();\n rpt.Default_Value = dt.Format($ME.format);\n rpt = null;",
  83. "format": "yyyy 年 M 月 dd 日"
  84. },
  85. {
  86. "Name": "获取当前页",
  87. "run_type": "before_output",
  88. "expression": "let ttp = $JE.P(5010,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getCurrentPage($CURRENT_RPT));\n ttp = null;",
  89. "format": "第 ($S) 页"
  90. },
  91. {
  92. "Name": "获取总页数",
  93. "run_type": "before_output",
  94. "expression": "let ttp = $JE.P(5011,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getTotalPage($CURRENT_RPT));\n ttp = null;",
  95. "format": "共 ($S) 页"
  96. },
  97. {
  98. "Name": "桩号长度合并",
  99. "run_type": "before_paging",
  100. "expression": "let startMilestoneField = $JE.F(1130,$CURRENT_RPT)\n\t, endMilestoneField = $JE.F(1131,$CURRENT_RPT)\n\t, roadLengthField = $JE.F(1152,$CURRENT_RPT)\n\t;\nlet dispParam = $JE.P(12106,$CURRENT_RPT);\nlet dftSpace = ' ';\nlet value = '由' + dftSpace + $JE.getFieldValue(startMilestoneField, $CURRENT_DATA, 0, '') + dftSpace + '至' + dftSpace + $JE.getFieldValue(endMilestoneField, $CURRENT_DATA, 0, '') + dftSpace + '全长' + dftSpace + $JE.getFieldValue(roadLengthField, $CURRENT_DATA, 0, 0) + dftSpace + '公里';\ndispParam.Default_Value = value;",
  101. "format": ""
  102. },
  103. {
  104. "Name": "清单号加后缀",
  105. "run_type": "before_paging",
  106. "expression": "let zhangJie_num = $JE.F(2801,$CURRENT_RPT); \n\nlet fLen0 = $JE.getFieldDataLen(zhangJie_num, $CURRENT_DATA);\n\nfor(let i = 0 ; i < fLen0 ; i++){\n\tlet new_zhangJie_num = $JE.getFieldValue(zhangJie_num, $CURRENT_DATA, i, '');\n\tif(new_zhangJie_num !== ''){\n\t\t$JE.setFieldValue(zhangJie_num,$CURRENT_DATA,i,new_zhangJie_num + '章');\n\t}\n}\n",
  107. "format": ""
  108. },
  109. {
  110. "Name": "综合设置",
  111. "run_type": "before_paging",
  112. "expression": "let tp1 = $JE.F(2827,$CURRENT_RPT); //tp1\nlet tp2 = $JE.F(2828,$CURRENT_RPT); //tp2\n\nlet tp4 = $JE.F(2830,$CURRENT_RPT); //tp4\nlet tp5 = $JE.F(2831,$CURRENT_RPT); //tp5\nlet tp6 = $JE.F(2832,$CURRENT_RPT); //tp6\nlet qy_price = $JE.F(2833,$CURRENT_RPT); //tp7\nlet bg_price = $JE.F(2834,$CURRENT_RPT); //tp8\nlet bgh_price = $JE.F(2835,$CURRENT_RPT); //tp9\n\nlet str1 = $JE.F(2801,$CURRENT_RPT); //str1\n\nlet name = $JE.F(2802,$CURRENT_RPT); //name\nlet fLen0 = $JE.getFieldDataLen(name, $CURRENT_DATA);\n\nfor(let i = 0; i < fLen0; i++){\n\tlet name1 = $JE.getFieldValue(name, $CURRENT_DATA, i, '');\n\tif(name1 === '暂定金额'){\n\t\tlet tp1_qy = $JE.getFieldValue(tp1, $CURRENT_DATA, i, 0);\n\t\tlet tp1_bg = $JE.getFieldValue(tp2, $CURRENT_DATA, i, 0);\n\t\t\n\t\t$JE.setFieldValue(qy_price,$CURRENT_DATA,i,tp1_qy);\n\t\t$JE.setFieldValue(bg_price,$CURRENT_DATA,i,tp1_bg);\n\t}\n\tif(name1 === '工程结算价款'){\n\t\t$JE.setFieldValue(qy_price,$CURRENT_DATA,i,0);\n\t\t$JE.setFieldValue(bg_price,$CURRENT_DATA,i,0);\n\t}\n}\n\nlet total_qy_price = 0;\nlet total_bg_price = 0;\nfor(let i = 0; i < fLen0; i++){\n\ttotal_qy_price = $CTX_HELPER.add(total_qy_price, $JE.getFieldValue(qy_price, $CURRENT_DATA, i, 0));\n\ttotal_bg_price = $CTX_HELPER.add(total_bg_price, $JE.getFieldValue(bg_price, $CURRENT_DATA, i, 0));\n}\n\n//给“合计”行赋值\nfor(let i = 0; i < fLen0; i++){\n\tlet name1 = $JE.getFieldValue(name, $CURRENT_DATA, i, '');\n\tif(name1 === '合计'){\n\t\t$JE.setFieldValue(qy_price,$CURRENT_DATA,i,total_qy_price);\n\t\t$JE.setFieldValue(bg_price,$CURRENT_DATA,i,total_bg_price);\n\t}\n}\n\n//最后给变更后总金额列赋值\nfor(let i = 0; i < fLen0; i++){\n\tlet qy = $JE.getFieldValue(qy_price, $CURRENT_DATA, i, '');\n\tlet bg = $JE.getFieldValue(bg_price, $CURRENT_DATA, i, '');\n\t\n\t$JE.setFieldValue(bgh_price,$CURRENT_DATA,i, $CTX_HELPER.add(qy,bg));\n}\n\nfor(let i = 0; i < fLen0; i++){\n\tlet name1 = $JE.getFieldValue(name, $CURRENT_DATA, i, '');\n\tif(name1 === '未计入章节清单项'){\n\t\tif($JE.getFieldValue(tp6, $CURRENT_DATA, i, 0) === 0 && $JE.getFieldValue(bgh_price, $CURRENT_DATA, i, 0) === 0){\n\t\t\t$JE.removeFieldValue(str1, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(name, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(qy_price, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(bg_price, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(bgh_price, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(tp4, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(tp5, $CURRENT_DATA, i);\n\t\t\t$JE.removeFieldValue(tp6, $CURRENT_DATA, i);\n\t\t}\n\t}\n}\n",
  113. "format": ""
  114. },
  115. {
  116. "Name": "截止日期转换",
  117. "run_type": "before_paging",
  118. "expression": "let rpt = $JE.F(1312,$CURRENT_RPT);\nlet jzrq = $JE.getFieldValue(rpt, $CURRENT_DATA, 0, '')\nlet shiJian = jzrq.split('-');\n\nif(shiJian[0]!==''){\n\tlet newRiQiValue = shiJian[0]+\"年\"+shiJian[1]+\"月\"+shiJian[2]+\"日\";\n\t$JE.setFieldValue(rpt, $CURRENT_DATA, 0, newRiQiValue);\n}",
  119. "format": ""
  120. }
  121. ],
  122. "流水式表_信息": {
  123. "离散信息": [
  124. {
  125. "BandName": "TitleBand",
  126. "text_s": [
  127. {
  128. "Label": "支表2 中期支付证书",
  129. "font": "ReportTitle_Main",
  130. "control": "NewContent_Center",
  131. "style": "Default_None",
  132. "Title": "",
  133. "area": {
  134. "Left": 0,
  135. "Right": "100.00",
  136. "Top": 0,
  137. "Bottom": "100.00",
  138. "H_CalculationType": "percentage",
  139. "V_CalculationType": "percentage"
  140. }
  141. }
  142. ]
  143. },
  144. {
  145. "BandName": "HeaderBand",
  146. "discrete_field_s": [
  147. {
  148. "FieldID": 1312,
  149. "font": "Header",
  150. "control": "Header",
  151. "style": "Default_None",
  152. "Prefix": "截至日期:",
  153. "isAutoHeight": false,
  154. "area": {
  155. "Left": 0,
  156. "Right": "39.35",
  157. "Top": "33.33",
  158. "Bottom": "66.66",
  159. "H_CalculationType": "percentage",
  160. "V_CalculationType": "percentage"
  161. }
  162. },
  163. {
  164. "FieldID": 1134,
  165. "font": "Header",
  166. "control": "Header",
  167. "style": "Default_None",
  168. "Prefix": "承包单位:",
  169. "isAutoHeight": false,
  170. "area": {
  171. "Left": "39.35",
  172. "Right": "76.41",
  173. "Top": 0,
  174. "Bottom": "33.33",
  175. "H_CalculationType": "percentage",
  176. "V_CalculationType": "percentage"
  177. }
  178. },
  179. {
  180. "FieldID": 1140,
  181. "font": "Header",
  182. "control": "Header",
  183. "style": "Default_None",
  184. "Prefix": "监理单位:",
  185. "isAutoHeight": false,
  186. "area": {
  187. "Left": "39.35",
  188. "Right": "76.41",
  189. "Top": "33.33",
  190. "Bottom": "66.66",
  191. "H_CalculationType": "percentage",
  192. "V_CalculationType": "percentage"
  193. }
  194. },
  195. {
  196. "FieldID": 1102,
  197. "font": "Header",
  198. "control": "Header",
  199. "style": "Default_None",
  200. "Prefix": "合同号:",
  201. "isAutoHeight": false,
  202. "area": {
  203. "Left": "76.41",
  204. "Right": "100.00",
  205. "Top": 0,
  206. "Bottom": "33.33",
  207. "H_CalculationType": "percentage",
  208. "V_CalculationType": "percentage"
  209. }
  210. },
  211. {
  212. "FieldID": 1300,
  213. "font": "Header",
  214. "control": "Header",
  215. "style": "Default_None",
  216. "Prefix": "编 号:",
  217. "isAutoHeight": false,
  218. "area": {
  219. "Left": "76.41",
  220. "Right": "100.00",
  221. "Top": "33.33",
  222. "Bottom": "66.66",
  223. "H_CalculationType": "percentage",
  224. "V_CalculationType": "percentage"
  225. }
  226. },
  227. {
  228. "ParamID": 12106,
  229. "font": "Header",
  230. "control": "Title",
  231. "style": "Default_None",
  232. "Default_Value": "",
  233. "area": {
  234. "Left": 0,
  235. "Right": "100.00",
  236. "Top": "66.66",
  237. "Bottom": "100.00",
  238. "H_CalculationType": "percentage",
  239. "V_CalculationType": "percentage"
  240. }
  241. },
  242. {
  243. "FieldID": 1103,
  244. "font": "Header",
  245. "control": "Header",
  246. "style": "Default_None",
  247. "Prefix": "项目名称:",
  248. "isAutoHeight": false,
  249. "area": {
  250. "Left": 0,
  251. "Right": "39.35",
  252. "Top": 0,
  253. "Bottom": "33.33",
  254. "H_CalculationType": "percentage",
  255. "V_CalculationType": "percentage"
  256. }
  257. }
  258. ]
  259. },
  260. {
  261. "BandName": "FooterBand",
  262. "discrete_field_s": [
  263. {
  264. "FieldID": 12113,
  265. "font": "Content",
  266. "control": "NewContent_Left",
  267. "style": "Default_None",
  268. "isAutoHeight": false,
  269. "area": {
  270. "Left": "5",
  271. "Right": "22.5",
  272. "Top": 0,
  273. "Bottom": 100,
  274. "H_CalculationType": "percentage",
  275. "V_CalculationType": "percentage"
  276. }
  277. },
  278. {
  279. "FieldID": 12114,
  280. "font": "Content",
  281. "control": "NewContent_Left",
  282. "style": "Default_None",
  283. "isAutoHeight": false,
  284. "area": {
  285. "Left": "28",
  286. "Right": "46",
  287. "Top": 0,
  288. "Bottom": 100,
  289. "H_CalculationType": "percentage",
  290. "V_CalculationType": "percentage"
  291. }
  292. },
  293. {
  294. "FieldID": 12115,
  295. "font": "Content",
  296. "control": "NewContent_Left",
  297. "style": "Default_None",
  298. "isAutoHeight": false,
  299. "area": {
  300. "Left": "54",
  301. "Right": "71",
  302. "Top": 0,
  303. "Bottom": 100,
  304. "H_CalculationType": "percentage",
  305. "V_CalculationType": "percentage"
  306. }
  307. },
  308. {
  309. "FieldID": 12116,
  310. "font": "Content",
  311. "control": "NewContent_Left",
  312. "style": "Default_None",
  313. "isAutoHeight": false,
  314. "area": {
  315. "Left": "82",
  316. "Right": "100",
  317. "Top": 0,
  318. "Bottom": 100,
  319. "H_CalculationType": "percentage",
  320. "V_CalculationType": "percentage"
  321. }
  322. }
  323. ],
  324. "text_s": [
  325. {
  326. "Label": "承包人:",
  327. "font": "Content",
  328. "control": "Footer",
  329. "style": "Default_None",
  330. "Title": "",
  331. "area": {
  332. "Left": 0,
  333. "Right": "5",
  334. "Top": 0,
  335. "Bottom": 100,
  336. "H_CalculationType": "percentage",
  337. "V_CalculationType": "percentage"
  338. }
  339. },
  340. {
  341. "Label": "监理员:",
  342. "font": "Content",
  343. "control": "Footer",
  344. "style": "Default_None",
  345. "Title": "",
  346. "area": {
  347. "Left": "22.5",
  348. "Right": "28",
  349. "Top": 0,
  350. "Bottom": 100,
  351. "H_CalculationType": "percentage",
  352. "V_CalculationType": "percentage"
  353. }
  354. },
  355. {
  356. "Label": "监理组组长:",
  357. "font": "Content",
  358. "control": "Footer",
  359. "style": "Default_None",
  360. "Title": "",
  361. "area": {
  362. "Left": "46",
  363. "Right": "54",
  364. "Top": 0,
  365. "Bottom": 100,
  366. "H_CalculationType": "percentage",
  367. "V_CalculationType": "percentage"
  368. }
  369. },
  370. {
  371. "Label": "业主(业主代表):",
  372. "font": "Content",
  373. "control": "Footer",
  374. "style": "Default_None",
  375. "Title": "",
  376. "area": {
  377. "Left": "71",
  378. "Right": "82",
  379. "Top": 0,
  380. "Bottom": 100,
  381. "H_CalculationType": "percentage",
  382. "V_CalculationType": "percentage"
  383. }
  384. }
  385. ]
  386. }
  387. ],
  388. "流水式表_列": {
  389. "BandName": "ColumnBand",
  390. "text_s": [
  391. {
  392. "Label": "清单号",
  393. "font": "HeaderColumn",
  394. "control": "Column",
  395. "style": "Default_Normal",
  396. "Title": "",
  397. "area": {
  398. "Left": 0,
  399. "Right": "8.12",
  400. "Top": 0,
  401. "Bottom": "100.00",
  402. "H_CalculationType": "percentage",
  403. "V_CalculationType": "percentage"
  404. }
  405. },
  406. {
  407. "Label": "项目内容",
  408. "font": "HeaderColumn",
  409. "control": "Column",
  410. "style": "Default_Normal",
  411. "Title": "",
  412. "area": {
  413. "Left": "8.12",
  414. "Right": "26.4",
  415. "Top": 0,
  416. "Bottom": "100.00",
  417. "H_CalculationType": "percentage",
  418. "V_CalculationType": "percentage"
  419. }
  420. },
  421. {
  422. "Label": "合同价及变更金额",
  423. "font": "HeaderColumn",
  424. "control": "Column",
  425. "style": "Default_Normal",
  426. "Title": "",
  427. "area": {
  428. "Left": "26.4",
  429. "Right": "64.66",
  430. "Top": 0,
  431. "Bottom": "33.82",
  432. "H_CalculationType": "percentage",
  433. "V_CalculationType": "percentage"
  434. }
  435. },
  436. {
  437. "Label": "原有总金额(人名币)",
  438. "font": "HeaderColumn",
  439. "control": "Column",
  440. "style": "Default_Normal",
  441. "Title": "",
  442. "area": {
  443. "Left": "26.4",
  444. "Right": "39.35",
  445. "Top": "33.82",
  446. "Bottom": "66.18",
  447. "H_CalculationType": "percentage",
  448. "V_CalculationType": "percentage"
  449. }
  450. },
  451. {
  452. "Label": "A",
  453. "font": "HeaderColumn",
  454. "control": "Column",
  455. "style": "Default_Normal",
  456. "Title": "",
  457. "area": {
  458. "Left": "26.4",
  459. "Right": "39.35",
  460. "Top": "66.18",
  461. "Bottom": "100.00",
  462. "H_CalculationType": "percentage",
  463. "V_CalculationType": "percentage"
  464. }
  465. },
  466. {
  467. "Label": "变更金额(人民币)",
  468. "font": "HeaderColumn",
  469. "control": "Column",
  470. "style": "Default_Normal",
  471. "Title": "",
  472. "area": {
  473. "Left": "39.35",
  474. "Right": "51.19",
  475. "Top": "33.82",
  476. "Bottom": "66.18",
  477. "H_CalculationType": "percentage",
  478. "V_CalculationType": "percentage"
  479. }
  480. },
  481. {
  482. "Label": "B",
  483. "font": "HeaderColumn",
  484. "control": "Column",
  485. "style": "Default_Normal",
  486. "Title": "",
  487. "area": {
  488. "Left": "39.35",
  489. "Right": "51.19",
  490. "Top": "66.18",
  491. "Bottom": "100.00",
  492. "H_CalculationType": "percentage",
  493. "V_CalculationType": "percentage"
  494. }
  495. },
  496. {
  497. "Label": "变更后总金额(人民币)",
  498. "font": "HeaderColumn",
  499. "control": "Column",
  500. "style": "Default_Normal",
  501. "Title": "",
  502. "area": {
  503. "Left": "51.19",
  504. "Right": "64.66",
  505. "Top": "33.82",
  506. "Bottom": "66.18",
  507. "H_CalculationType": "percentage",
  508. "V_CalculationType": "percentage"
  509. }
  510. },
  511. {
  512. "Label": "C",
  513. "font": "HeaderColumn",
  514. "control": "Column",
  515. "style": "Default_Normal",
  516. "Title": "",
  517. "area": {
  518. "Left": "51.19",
  519. "Right": "64.66",
  520. "Top": "66.18",
  521. "Bottom": "100.00",
  522. "H_CalculationType": "percentage",
  523. "V_CalculationType": "percentage"
  524. }
  525. },
  526. {
  527. "Label": "到本期末完成",
  528. "font": "HeaderColumn",
  529. "control": "Column",
  530. "style": "Default_Normal",
  531. "Title": "",
  532. "area": {
  533. "Left": "64.66",
  534. "Right": "76.41",
  535. "Top": 0,
  536. "Bottom": "33.82",
  537. "H_CalculationType": "percentage",
  538. "V_CalculationType": "percentage"
  539. }
  540. },
  541. {
  542. "Label": "金额(人民币)",
  543. "font": "HeaderColumn",
  544. "control": "Column",
  545. "style": "Default_Normal",
  546. "Title": "",
  547. "area": {
  548. "Left": "64.66",
  549. "Right": "76.41",
  550. "Top": "33.82",
  551. "Bottom": "66.18",
  552. "H_CalculationType": "percentage",
  553. "V_CalculationType": "percentage"
  554. }
  555. },
  556. {
  557. "Label": "D",
  558. "font": "HeaderColumn",
  559. "control": "Column",
  560. "style": "Default_Normal",
  561. "Title": "",
  562. "area": {
  563. "Left": "64.66",
  564. "Right": "76.41",
  565. "Top": "66.18",
  566. "Bottom": "100.00",
  567. "H_CalculationType": "percentage",
  568. "V_CalculationType": "percentage"
  569. }
  570. },
  571. {
  572. "Label": "到上期末完成",
  573. "font": "HeaderColumn",
  574. "control": "Column",
  575. "style": "Default_Normal",
  576. "Title": "",
  577. "area": {
  578. "Left": "76.41",
  579. "Right": "88.25",
  580. "Top": 0,
  581. "Bottom": "33.82",
  582. "H_CalculationType": "percentage",
  583. "V_CalculationType": "percentage"
  584. }
  585. },
  586. {
  587. "Label": "金额(人民币)",
  588. "font": "HeaderColumn",
  589. "control": "Column",
  590. "style": "Default_Normal",
  591. "Title": "",
  592. "area": {
  593. "Left": "76.41",
  594. "Right": "88.25",
  595. "Top": "33.82",
  596. "Bottom": "66.18",
  597. "H_CalculationType": "percentage",
  598. "V_CalculationType": "percentage"
  599. }
  600. },
  601. {
  602. "Label": "G",
  603. "font": "HeaderColumn",
  604. "control": "Column",
  605. "style": "Default_Normal",
  606. "Title": "",
  607. "area": {
  608. "Left": "76.41",
  609. "Right": "88.25",
  610. "Top": "66.18",
  611. "Bottom": "100.00",
  612. "H_CalculationType": "percentage",
  613. "V_CalculationType": "percentage"
  614. }
  615. },
  616. {
  617. "Label": "本期完成",
  618. "font": "HeaderColumn",
  619. "control": "Column",
  620. "style": "Default_Normal",
  621. "Title": "",
  622. "area": {
  623. "Left": "88.25",
  624. "Right": "100.00",
  625. "Top": 0,
  626. "Bottom": "33.82",
  627. "H_CalculationType": "percentage",
  628. "V_CalculationType": "percentage"
  629. }
  630. },
  631. {
  632. "Label": "金额(人民币)",
  633. "font": "HeaderColumn",
  634. "control": "Column",
  635. "style": "Default_Normal",
  636. "Title": "",
  637. "area": {
  638. "Left": "88.25",
  639. "Right": "100.00",
  640. "Top": "33.82",
  641. "Bottom": "66.18",
  642. "H_CalculationType": "percentage",
  643. "V_CalculationType": "percentage"
  644. }
  645. },
  646. {
  647. "Label": "J=D-G",
  648. "font": "HeaderColumn",
  649. "control": "Column",
  650. "style": "Default_Normal",
  651. "Title": "",
  652. "area": {
  653. "Left": "88.25",
  654. "Right": "100.00",
  655. "Top": "66.18",
  656. "Bottom": "100.00",
  657. "H_CalculationType": "percentage",
  658. "V_CalculationType": "percentage"
  659. }
  660. }
  661. ]
  662. },
  663. "多列显示数量": 1,
  664. "流水式表_数据": {
  665. "BandName": "ContentBand",
  666. "CommonHeight": "0.532",
  667. "flow_field_s": [
  668. {
  669. "FieldID": 2801,
  670. "font": "Content",
  671. "control": "Column",
  672. "style": "Default_Normal",
  673. "isAutoHeight": false,
  674. "area": {
  675. "Left": 0,
  676. "Right": "8.12",
  677. "Top": 0,
  678. "Bottom": 100,
  679. "H_CalculationType": "percentage",
  680. "V_CalculationType": "percentage"
  681. }
  682. },
  683. {
  684. "FieldID": 2802,
  685. "font": "Content",
  686. "control": "Column",
  687. "style": "Default_Normal",
  688. "isAutoHeight": false,
  689. "area": {
  690. "Left": "8.12",
  691. "Right": "26.4",
  692. "Top": 0,
  693. "Bottom": 100,
  694. "H_CalculationType": "percentage",
  695. "V_CalculationType": "percentage"
  696. }
  697. },
  698. {
  699. "FieldID": 2833,
  700. "font": "Content",
  701. "control": "Column_Right",
  702. "style": "Default_Normal",
  703. "isAutoHeight": false,
  704. "area": {
  705. "Left": "26.4",
  706. "Right": "39.35",
  707. "Top": 0,
  708. "Bottom": 100,
  709. "H_CalculationType": "percentage",
  710. "V_CalculationType": "percentage"
  711. }
  712. },
  713. {
  714. "FieldID": 2834,
  715. "font": "Content",
  716. "control": "Column_Right",
  717. "style": "Default_Normal",
  718. "isAutoHeight": false,
  719. "area": {
  720. "Left": "39.35",
  721. "Right": "51.19",
  722. "Top": 0,
  723. "Bottom": 100,
  724. "H_CalculationType": "percentage",
  725. "V_CalculationType": "percentage"
  726. }
  727. },
  728. {
  729. "FieldID": 2835,
  730. "font": "Content",
  731. "control": "Column_Right",
  732. "style": "Default_Normal",
  733. "isAutoHeight": false,
  734. "area": {
  735. "Left": "51.19",
  736. "Right": "64.66",
  737. "Top": 0,
  738. "Bottom": 100,
  739. "H_CalculationType": "percentage",
  740. "V_CalculationType": "percentage"
  741. }
  742. },
  743. {
  744. "FieldID": 2832,
  745. "font": "Content",
  746. "control": "Column_Right",
  747. "style": "Default_Normal",
  748. "isAutoHeight": false,
  749. "area": {
  750. "Left": "64.66",
  751. "Right": "76.41",
  752. "Top": 0,
  753. "Bottom": 100,
  754. "H_CalculationType": "percentage",
  755. "V_CalculationType": "percentage"
  756. }
  757. },
  758. {
  759. "FieldID": 2831,
  760. "font": "Content",
  761. "control": "Column_Right",
  762. "style": "Default_Normal",
  763. "isAutoHeight": false,
  764. "area": {
  765. "Left": "76.41",
  766. "Right": "88.25",
  767. "Top": 0,
  768. "Bottom": 100,
  769. "H_CalculationType": "percentage",
  770. "V_CalculationType": "percentage"
  771. }
  772. },
  773. {
  774. "FieldID": 2830,
  775. "font": "Content",
  776. "control": "Column_Right",
  777. "style": "Default_Normal",
  778. "isAutoHeight": false,
  779. "area": {
  780. "Left": "88.25",
  781. "Right": "100.00",
  782. "Top": 0,
  783. "Bottom": 100,
  784. "H_CalculationType": "percentage",
  785. "V_CalculationType": "percentage"
  786. }
  787. }
  788. ]
  789. },
  790. "流水式表_分组信息": {
  791. "group_field_s": [],
  792. "sum_field_s": [],
  793. "group_lines": []
  794. },
  795. "流水式表_段统计信息": {
  796. "BandName": "",
  797. "sum_field_s": [],
  798. "text_s": []
  799. },
  800. "流水式表_页统计信息": {
  801. "BandName": "",
  802. "sum_field_s": [],
  803. "text_s": []
  804. }
  805. },
  806. "离散参数_集合": [
  807. {
  808. "ID": "5001",
  809. "Name": "打印时间",
  810. "DataType": "String",
  811. "Default_Value": ""
  812. },
  813. {
  814. "ID": "5010",
  815. "Name": "当前页",
  816. "DataType": "String",
  817. "Default_Value": "第 X 页"
  818. },
  819. {
  820. "ID": "5011",
  821. "Name": "总页数",
  822. "DataType": "String",
  823. "Default_Value": "共 X 页"
  824. },
  825. {
  826. "ID": 12106,
  827. "Name": "参数-起止桩号长度",
  828. "DataType": "string",
  829. "Default_Value": ""
  830. }
  831. ],
  832. "指标_数据_映射": {
  833. "离散指标_集合": [
  834. {
  835. "ID": 1002,
  836. "Name": "项目_名称",
  837. "DataType": "string",
  838. "TableName": "project",
  839. "mapExpression": "$PROJECT.REPORT.getProperty('project', 'name')",
  840. "descr": "",
  841. "Title": "ID: 1002"
  842. },
  843. {
  844. "ID": 1102,
  845. "Name": "标段_合同号",
  846. "DataType": "string",
  847. "TableName": "tender_info",
  848. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealCode')",
  849. "descr": "",
  850. "Title": "ID: 1102"
  851. },
  852. {
  853. "ID": 1104,
  854. "Name": "标段_建设单位",
  855. "DataType": "string",
  856. "TableName": "tender_info",
  857. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.build.company')",
  858. "descr": "",
  859. "Title": "ID: 1104"
  860. },
  861. {
  862. "ID": 1103,
  863. "Name": "标段_编号",
  864. "DataType": "string",
  865. "TableName": "tender_info",
  866. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealName')",
  867. "descr": "",
  868. "Title": "ID: 1103"
  869. },
  870. {
  871. "ID": 1132,
  872. "Name": "标段_标段清单_章节代码",
  873. "DataType": "array",
  874. "TableName": "tender_info",
  875. "mapExpression": "$PROJECT.REPORT.getArrayProperty('tender_info', 'chapter.code')",
  876. "descr": "",
  877. "Title": "ID: 1132"
  878. },
  879. {
  880. "ID": 1133,
  881. "Name": "标段_标段清单_章节名称",
  882. "DataType": "array",
  883. "TableName": "tender_info",
  884. "mapExpression": "$PROJECT.REPORT.getArrayProperty('tender_info', 'chapter.name')",
  885. "descr": "",
  886. "Title": "ID: 1133"
  887. },
  888. {
  889. "ID": 1134,
  890. "Name": "标段_标段清单_承包单位1_单位名称",
  891. "DataType": "string",
  892. "TableName": "tender_info",
  893. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.contract1.company')",
  894. "descr": "",
  895. "Title": "ID: 1134"
  896. },
  897. {
  898. "ID": 1140,
  899. "Name": "标段_标段清单_监理单位1_单位名称",
  900. "DataType": "string",
  901. "TableName": "tender_info",
  902. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.supervision1.company')",
  903. "descr": "",
  904. "Title": "ID: 1140"
  905. },
  906. {
  907. "ID": 1130,
  908. "Name": "标段_技术参数_起点桩号",
  909. "DataType": "string",
  910. "TableName": "tender_info",
  911. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"tech_param.startPeg\")",
  912. "descr": "",
  913. "Title": "ID: 1130"
  914. },
  915. {
  916. "ID": 1131,
  917. "Name": "标段_技术参数_终点桩号",
  918. "DataType": "string",
  919. "TableName": "tender_info",
  920. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"tech_param.endPeg\")",
  921. "descr": "",
  922. "Title": "ID: 1131"
  923. },
  924. {
  925. "ID": 1152,
  926. "Name": "标段_技术参数_长度(KM)",
  927. "DataType": "double",
  928. "TableName": "tender_info",
  929. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"tech_param.loadLength\")",
  930. "descr": "",
  931. "Title": "ID: 1152"
  932. },
  933. {
  934. "ID": 1310,
  935. "Name": "期计量信息_开始截至日期",
  936. "DataType": "string",
  937. "TableName": "stage",
  938. "mapExpression": "$PROJECT.REPORT.getProperty('stage', 'period')",
  939. "descr": "",
  940. "Title": "ID: 1310"
  941. },
  942. {
  943. "ID": 1312,
  944. "Name": "期计量信息_截至日期",
  945. "DataType": "string",
  946. "TableName": "stage",
  947. "mapExpression": "$PROJECT.REPORT.getSplitProperty('stage', 'period', ' ~ ', 1, '')",
  948. "descr": "",
  949. "Title": "ID: 1312"
  950. },
  951. {
  952. "ID": 1308,
  953. "Name": "期计量信息_审批状态",
  954. "DataType": "number",
  955. "TableName": "stage",
  956. "mapExpression": "$PROJECT.REPORT.getProperty('stage', 'status')",
  957. "descr": "",
  958. "Title": "ID: 1308"
  959. },
  960. {
  961. "ID": 1300,
  962. "Name": "期计量信息_期数",
  963. "DataType": "number",
  964. "TableName": "stage",
  965. "mapExpression": "$PROJECT.REPORT.getProperty('stage', 'order')",
  966. "descr": "",
  967. "Title": "ID: 1300"
  968. },
  969. {
  970. "ID": 1399,
  971. "Name": "期计量信息_空白",
  972. "DataType": "string",
  973. "TableName": "stage",
  974. "mapExpression": "$PROJECT.REPORT.getBlank('stage', '')",
  975. "descr": "",
  976. "Title": "ID: 1399"
  977. },
  978. {
  979. "ID": 2701,
  980. "Name": "期-合同支付-名称(name)",
  981. "DataType": "string",
  982. "TableName": "mem_stage_pay",
  983. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'name')",
  984. "descr": "",
  985. "Title": "ID: 2701"
  986. },
  987. {
  988. "ID": 2703,
  989. "Name": "期-合同支付-金额(tp)",
  990. "DataType": "currency",
  991. "TableName": "mem_stage_pay",
  992. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'tp')",
  993. "descr": "",
  994. "Title": "ID: 2703"
  995. },
  996. {
  997. "ID": 2704,
  998. "Name": "期-合同支付-截止上期-金额(pre_tp)",
  999. "DataType": "currency",
  1000. "TableName": "mem_stage_pay",
  1001. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'pre_tp')",
  1002. "descr": "",
  1003. "Title": "ID: 2704"
  1004. },
  1005. {
  1006. "ID": 2705,
  1007. "Name": "期-合同支付-截止本期-金额(end_tp)",
  1008. "DataType": "currency",
  1009. "TableName": "mem_stage_pay",
  1010. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'end_tp')",
  1011. "descr": "",
  1012. "Title": "ID: 2705"
  1013. },
  1014. {
  1015. "ID": 2707,
  1016. "Name": "期-合同支付-是否扣款项(minus)",
  1017. "DataType": "int",
  1018. "TableName": "mem_stage_pay",
  1019. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'minus')",
  1020. "descr": "",
  1021. "Title": "ID: 2707"
  1022. },
  1023. {
  1024. "ID": 2708,
  1025. "Name": "期-合同支付-支付类型(ptype)",
  1026. "DataType": "int",
  1027. "TableName": "mem_stage_pay",
  1028. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_pay', 'ptype')",
  1029. "descr": "",
  1030. "Title": "ID: 2708"
  1031. },
  1032. {
  1033. "ID": 2508,
  1034. "Name": "树结构-是否子项(is_leaf)",
  1035. "DataType": "int",
  1036. "TableName": "mem_stage_bills",
  1037. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')",
  1038. "descr": "",
  1039. "Title": "ID: 2508"
  1040. },
  1041. {
  1042. "ID": 2510,
  1043. "Name": "清单编号(b_code)",
  1044. "DataType": "string",
  1045. "TableName": "mem_stage_bills",
  1046. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'b_code')",
  1047. "descr": "",
  1048. "Title": "ID: 2510"
  1049. },
  1050. {
  1051. "ID": 2511,
  1052. "Name": "名称(name)",
  1053. "DataType": "string",
  1054. "TableName": "mem_stage_bills",
  1055. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'name')",
  1056. "descr": "",
  1057. "Title": "ID: 2511"
  1058. },
  1059. {
  1060. "ID": 2512,
  1061. "Name": "单位(unit)",
  1062. "DataType": "string",
  1063. "TableName": "mem_stage_bills",
  1064. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit')",
  1065. "descr": "",
  1066. "Title": "ID: 2512"
  1067. },
  1068. {
  1069. "ID": 2513,
  1070. "Name": "单价(unit_price)",
  1071. "DataType": "currency",
  1072. "TableName": "mem_stage_bills",
  1073. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit_price')",
  1074. "descr": "",
  1075. "Title": "ID: 2513"
  1076. },
  1077. {
  1078. "ID": 2535,
  1079. "Name": "本期-完成-金额(gather_tp)",
  1080. "DataType": "currency",
  1081. "TableName": "mem_stage_bills",
  1082. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'gather_tp')",
  1083. "descr": "",
  1084. "Title": "ID: 2535"
  1085. },
  1086. {
  1087. "ID": 2542,
  1088. "Name": "截止上期-完成-金额(pre_gather_tp)",
  1089. "DataType": "currency",
  1090. "TableName": "mem_stage_bills",
  1091. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_gather_tp')",
  1092. "descr": "",
  1093. "Title": "ID: 2542"
  1094. },
  1095. {
  1096. "ID": 2548,
  1097. "Name": "截止本期-完成-金额(end_gather_tp)",
  1098. "DataType": "currency",
  1099. "TableName": "mem_stage_bills",
  1100. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_gather_tp')",
  1101. "descr": "",
  1102. "Title": "ID: 2548"
  1103. },
  1104. {
  1105. "ID": 1600,
  1106. "Name": "签约清单信息_清单编号(code)",
  1107. "DataType": "string",
  1108. "TableName": "deal_bills",
  1109. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"code\")",
  1110. "descr": "",
  1111. "Title": "ID: 1600"
  1112. },
  1113. {
  1114. "ID": 1605,
  1115. "Name": "签约清单信息_合价(total_price)",
  1116. "DataType": "currency",
  1117. "TableName": "deal_bills",
  1118. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"total_price\")",
  1119. "descr": "",
  1120. "Title": "ID: 1605",
  1121. "Precision": {
  1122. "type": "fixed",
  1123. "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")"
  1124. }
  1125. },
  1126. {
  1127. "ID": 2903,
  1128. "Name": "变更清单-清单编号(code)",
  1129. "DataType": "string",
  1130. "TableName": "mem_change_bills",
  1131. "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 'code')",
  1132. "descr": "",
  1133. "Title": "ID: 2903"
  1134. },
  1135. {
  1136. "ID": 2912,
  1137. "Name": "变更清单-审批变更后-金额(s_tp)",
  1138. "DataType": "currency",
  1139. "TableName": "mem_change_bills",
  1140. "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 's_tp')",
  1141. "descr": "",
  1142. "Title": "ID: 2912"
  1143. },
  1144. {
  1145. "ID": 1103,
  1146. "Name": "标段_合同名称",
  1147. "DataType": "string",
  1148. "TableName": "tender_info",
  1149. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealName\")",
  1150. "descr": "",
  1151. "Title": "ID: 1103"
  1152. }
  1153. ],
  1154. "主数据指标_集合": [],
  1155. "从数据指标_集合": [
  1156. {
  1157. "ID": 2801,
  1158. "Name": "预留扩展数据-合并-字符串1(str1)",
  1159. "DataType": "string",
  1160. "TableName": "mem_union_data",
  1161. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'str1')",
  1162. "descr": "",
  1163. "Title": "ID: 2801"
  1164. },
  1165. {
  1166. "ID": 2802,
  1167. "Name": "预留扩展数据-合并-字符串2(str2)",
  1168. "DataType": "string",
  1169. "TableName": "mem_union_data",
  1170. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'str2')",
  1171. "descr": "",
  1172. "Title": "ID: 2802"
  1173. },
  1174. {
  1175. "ID": 2827,
  1176. "Name": "预留扩展数据-合并-金额1(tp1)",
  1177. "DataType": "currency",
  1178. "TableName": "mem_union_data",
  1179. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp1')",
  1180. "descr": "",
  1181. "Title": "ID: 2827"
  1182. },
  1183. {
  1184. "ID": 2828,
  1185. "Name": "预留扩展数据-合并-金额2(tp2)",
  1186. "DataType": "currency",
  1187. "TableName": "mem_union_data",
  1188. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp2')",
  1189. "descr": "",
  1190. "Title": "ID: 2828"
  1191. },
  1192. {
  1193. "ID": 2829,
  1194. "Name": "预留扩展数据-合并-金额3(tp3)",
  1195. "DataType": "currency",
  1196. "TableName": "mem_union_data",
  1197. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp3')",
  1198. "descr": "",
  1199. "Title": "ID: 2829"
  1200. },
  1201. {
  1202. "ID": 2830,
  1203. "Name": "预留扩展数据-合并-金额4(tp4)",
  1204. "DataType": "currency",
  1205. "TableName": "mem_union_data",
  1206. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp4')",
  1207. "descr": "",
  1208. "Title": "ID: 2830"
  1209. },
  1210. {
  1211. "ID": 2831,
  1212. "Name": "预留扩展数据-合并-金额5(tp5)",
  1213. "DataType": "currency",
  1214. "TableName": "mem_union_data",
  1215. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp5')",
  1216. "descr": "",
  1217. "Title": "ID: 2831"
  1218. },
  1219. {
  1220. "ID": 2832,
  1221. "Name": "预留扩展数据-合并-金额6(tp6)",
  1222. "DataType": "currency",
  1223. "TableName": "mem_union_data",
  1224. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp6')",
  1225. "descr": "",
  1226. "Title": "ID: 2832"
  1227. },
  1228. {
  1229. "ID": 2833,
  1230. "Name": "预留扩展数据-合并-金额7(tp7)",
  1231. "DataType": "currency",
  1232. "TableName": "mem_union_data",
  1233. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp7')",
  1234. "descr": "",
  1235. "Title": "ID: 2833"
  1236. },
  1237. {
  1238. "ID": 2834,
  1239. "Name": "预留扩展数据-合并-金额8(tp8)",
  1240. "DataType": "currency",
  1241. "TableName": "mem_union_data",
  1242. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp8')",
  1243. "descr": "",
  1244. "Title": "ID: 2834"
  1245. },
  1246. {
  1247. "ID": 2835,
  1248. "Name": "预留扩展数据-合并-金额9(tp9)",
  1249. "DataType": "currency",
  1250. "TableName": "mem_union_data",
  1251. "mapExpression": "$PROJECT.REPORT.getProperty('mem_union_data', 'tp9')",
  1252. "descr": "",
  1253. "Title": "ID: 2835"
  1254. }
  1255. ],
  1256. "主数据指标_拓展集合": [],
  1257. "从数据指标_拓展集合": []
  1258. },
  1259. "映射数据预处理": [
  1260. {
  1261. "预处理类型": "指定方式",
  1262. "映射数据对象": "",
  1263. "方式Key": "gatherChapter",
  1264. "hint": "请使用mem_stage_bills/mem_stage_bills_compare/ledger,仅对一张表进行汇总,并生成数据:\n1. 因为是汇总章级数据,必须在离散数据中添加\"章节代码\"&\"章节名称\"\n2. 需勾选\"清单编号(b_code)\", \"树结构-是否子项(is_leaf)\"字段,可以对任何含有这些字段的表汇总\n注意事项:\n1. 算法对数据表没有要求,保证有上述字段,且按顺序勾选即可, 仅汇总金额\n2. 算法计算后,原数据表中非数字类型的字段全部失效(除清单编号、名称外),请勿在指标映射中添加\n示例:\ne.g.1 要对mem_stage_bills汇总,须勾选mem_stage_bills下的\"清单编号(b_code)\", \"树结构-是否子项((is_leaf)\"字段\ne.g.2 要对mem_stage_bills_compare汇总,须勾选mem_stage_bills_compare下的\"清单编号(b_code)\", \"树结构-是否子项((is_leaf)\"字段\n结果:\n汇总结果可参照 清单汇总--章节合计,但是不过滤1000-1300章数据",
  1265. "fields": [
  1266. {
  1267. "Name": "清单编号(b_code)",
  1268. "FieldID": 2510
  1269. },
  1270. {
  1271. "Name": "树结构-是否子项(is_leaf)",
  1272. "FieldID": 2508
  1273. }
  1274. ],
  1275. "自定义设置": "{\n \"count\": 7,\n \"activeFields\": [\"gather_tp\", \"pre_gather_tp\", \"end_gather_tp\"],\n\t\"unChapter\" : {\"name\" : \"未计入章节清单项\", \"order\": 1},\n \"gclSum\": {\"name\": \"工程结算价款\", \"order\": 2},\n \"custom\": [\n {\n \"name\": \"暂定金额\",\n \"order\": 3,\n \"match\": [\n {\"node_type\": \"暂列金额\"},\n {\"field\": \"name\", \"part\": \"暂列金额\"},\n {\"field\": \"name\", \"part\": \"暂定金额\"}\n ]\n }\n ],\n \"rela\": [\n {\n \"table\": \"deal_bills\", \"key\": \"code\",\n \"fields\": {\"source\": \"total_price\", \"target\": \"ex_value1\"}\n },{\n \"table\": \"mem_change_bills\", \"key\": \"code\",\n \"fields\": {\"source\": \"s_tp\", \"target\": \"ex_value2\"}\n }\n ]\n}"
  1276. },
  1277. {
  1278. "预处理类型": "指定方式",
  1279. "映射数据对象": "",
  1280. "方式Key": "gatherStagePay",
  1281. "fields": [],
  1282. "自定义设置": "{\n \"table\": \"mem_stage_pay\",\n \"custom\": [\n {\"name\": \"本期完成计量\", \"ptype\": 4, \"order\": 1, \"visible\": false},\n {\"name\": \"业主违约罚金\", \"match\": \"业主违约罚金\", \"order\": 2},\n {\"name\": \"迟付款利息\", \"match\": \"迟付款利息\", \"order\": 3},\n {\"name\": \"其他付款\", \"minus\": 0, \"ptype\": 1, \"rid\": [\"业主违约罚金\", \"迟付款利息\"], \"order\": 4},\n {\"name\": \"合计\", \"order\": 5, \"order_calc\": \"o1+o2+o3+o4\"},\n {\"name\": \"动员预付款\", \"order\": 6, \"empty\": 1},\n {\"name\": \"扣动员预付款\", \"match\": [\"扣动员预付款\", \"扣回动员预付款\", \"扣开工预付款\", \"扣回开工预付款\"], \"order\": 7},\n {\"name\": \"扣材料预付款\", \"match\": \"扣材料预付款\", \"order\": 8},\n {\"name\": \"承包人违约罚金\", \"match\": \"承包人违约罚金\", \"order\": 9},\n {\"name\": \"保留金\", \"match\": \"保留金\", \"order\": 10},\n {\"name\": \"税金\", \"match\": \"税金\", \"order\": 11},\n {\"name\": \"质量保证金\", \"match\": \"质量保证金\", \"order\": 12},\n {\"name\": \"其他扣款\", \"minus\": 1, \"ptype\": 1, \"rid\": [\"扣动员预付款\", \"扣回动员预付款\", \"扣开工预付款\", \"扣回开工预付款\", \"扣材料预付款\", \"承包人违约罚金\", \"保留金\", \"税金\", \"质量保证金\"], \"order\": 13},\n {\"name\": \"扣款合计\", \"minus\": 1, \"ptype\": 1, \"order\": 14},\n {\"name\": \"支付\", \"ptype\": 2, \"order\": 15}\n ]\n }"
  1283. },
  1284. {
  1285. "预处理类型": "指定方式",
  1286. "映射数据对象": "",
  1287. "方式Key": "union",
  1288. "fields": [],
  1289. "自定义设置": "{\n \"union\": [\n {\n \"table\": \"mem_stage_bills\",\n \"fields\": [\n {\"target\": \"str1\", \"source\": \"code\"},\n {\"target\": \"str2\", \"source\": \"name\"},\n {\"target\": \"tp1\", \"source\": \"total_price\"},\n {\"target\": \"tp2\", \"source\": \"end_qc_tp\"},\n {\"target\": \"tp3\", \"source\": \"final_tp\"},\n {\"target\": \"tp4\", \"source\": \"gather_tp\"},\n {\"target\": \"tp5\", \"source\": \"pre_gather_tp\"},\n {\"target\": \"tp6\", \"source\": \"end_gather_tp\"},\n {\"target\": \"tp7\", \"source\": \"ex_value1\"},\n {\"target\": \"tp8\", \"source\": \"ex_value2\"},\n {\"target\": \"str3\", \"data\": \"章级合计哟\"}\n ]\n }, {\n \"table\": \"mem_stage_pay\",\n \"fields\": [\n {\"target\": \"str2\", \"source\": \"name\"},\n {\"target\": \"tp4\", \"source\": \"tp\"},\n {\"target\": \"tp5\", \"source\": \"pre_tp\"},\n {\"target\": \"tp6\", \"source\": \"end_tp\"},\n {\"target\": \"str3\", \"data\": \"合同支付哟\"}\n ]\n }\n ]\n}"
  1290. }
  1291. ],
  1292. "无映射离散指标_集合": [
  1293. {
  1294. "ID": 12000,
  1295. "Name": "新_清单号",
  1296. "DataType": "string"
  1297. },
  1298. {
  1299. "ID": 12001,
  1300. "Name": "新_项目内容",
  1301. "DataType": "string"
  1302. },
  1303. {
  1304. "ID": 12002,
  1305. "Name": "新_原有总金额",
  1306. "DataType": "string"
  1307. },
  1308. {
  1309. "ID": 12003,
  1310. "Name": "新_变更后总金额",
  1311. "DataType": "string"
  1312. },
  1313. {
  1314. "ID": 12004,
  1315. "Name": "新_到本期末完成金额",
  1316. "DataType": "string"
  1317. },
  1318. {
  1319. "ID": 12005,
  1320. "Name": "新_到上期末完成金额",
  1321. "DataType": "string"
  1322. },
  1323. {
  1324. "ID": 12006,
  1325. "Name": "新_本期完成金额",
  1326. "DataType": "string"
  1327. },
  1328. {
  1329. "ID": 12105,
  1330. "Name": "新_变更金额",
  1331. "DataType": "string"
  1332. }
  1333. ],
  1334. "动态日期离散参数_集合": [
  1335. {
  1336. "ID": 12009,
  1337. "Name": "高级驻地监理工程师_签字日期",
  1338. "DataType": "string",
  1339. "Default_Value": ""
  1340. },
  1341. {
  1342. "ID": 12010,
  1343. "Name": "项目办_签字日期",
  1344. "DataType": "string",
  1345. "Default_Value": ""
  1346. }
  1347. ],
  1348. "电子签名离散指标_集合": [
  1349. {
  1350. "ID": 12113,
  1351. "Name": "承包人",
  1352. "DataType": "string"
  1353. },
  1354. {
  1355. "ID": 12114,
  1356. "Name": "监理员",
  1357. "DataType": "string"
  1358. },
  1359. {
  1360. "ID": 12115,
  1361. "Name": "监理组组长",
  1362. "DataType": "string"
  1363. },
  1364. {
  1365. "ID": 12116,
  1366. "Name": "业主(业主代表)",
  1367. "DataType": "string"
  1368. }
  1369. ]
  1370. }