支表14 中间计量汇总表.js 48 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153
  1. {
  2. "ID_KEY": "DUMMY_FLOW_SAMPLE",
  3. "GROUP_KEY": "RPT_支表14 中间计量汇总表_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. "报表名称": "支表14 中间计量汇总表",
  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.8",
  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": "0.8",
  62. "Name": "ColumnBand",
  63. "control": "Default",
  64. "style": "Default_None",
  65. "MergeBorder": "F"
  66. },
  67. {
  68. "Alignment": "Bottom",
  69. "DisplayType": "LastPage",
  70. "Height": "0.6",
  71. "Name": "GrandTotalBand",
  72. "control": "Default",
  73. "style": "Default_None",
  74. "MergeBorder": "F"
  75. },
  76. {
  77. "Alignment": "Fulfill",
  78. "DisplayType": "EveryPage",
  79. "Name": "ContentBand",
  80. "control": "Default",
  81. "style": "Default_None",
  82. "MergeBorder": "F"
  83. }
  84. ]
  85. }
  86. ],
  87. "计算式_集合": [
  88. {
  89. "Name": "获取打印时间",
  90. "run_type": "before_paging",
  91. "expression": "let rpt = $JE.P(5001,$CURRENT_RPT);\n let dt = new Date();\n rpt.Default_Value = dt.Format($ME.format);\n rpt = null;",
  92. "format": "yyyy 年 M 月 dd 日"
  93. },
  94. {
  95. "Name": "获取当前页",
  96. "run_type": "before_output",
  97. "expression": "let ttp = $JE.P(5010,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getCurrentPage($CURRENT_RPT));\n ttp = null;",
  98. "format": "第 ($S) 页"
  99. },
  100. {
  101. "Name": "获取总页数",
  102. "run_type": "before_output",
  103. "expression": "let ttp = $JE.P(5011,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getTotalPage($CURRENT_RPT));\n ttp = null;",
  104. "format": "共 ($S) 页"
  105. },
  106. {
  107. "Name": "综合设置",
  108. "run_type": "before_paging",
  109. "expression": "//峨山县定制 综合设置\nlet zlBillsCodeField = $JE.F(2103,$CURRENT_RPT) //中间计量总量 清单代码\n\t;\n\t\nlet newRowBillCodeField = $JE.F(12104,$CURRENT_RPT) //新分组判断指标\n\t;\n\nlet fLen0 = $JE.getFieldDataLen(zlBillsCodeField, $CURRENT_DATA);\nconst propPrefix = '_';\nlet chapterCodeArr = [];\nlet chapterCodeIdxArr = [];\n\n//遍历总量清单,根据代码提取章号(100~1300)\nfor (let iIdx = 0; iIdx < fLen0; iIdx++) {\n\tlet bCode = $JE.getFieldValue(zlBillsCodeField, $CURRENT_DATA, iIdx, '');\n\tlet firstIdx = bCode.indexOf('-');\n\tlet codeKey = '';\n\tif (firstIdx === 3) {\n\t\tif(!isNaN(parseInt(bCode.slice(0,1)))){\n\t\t\tcodeKey = propPrefix + parseInt(bCode.slice(0,1)) * 100; //'-'符号前有三位数,表示<1000章\n\t\t}\n\t} else if (firstIdx === 4) {\n\t\tif(!isNaN(parseInt(bCode.slice(0,1)))){\n\t\t\tcodeKey = propPrefix + parseInt(bCode.slice(0,2)) * 100; //'-'符号前有四位数,则表示>=1000章\n\t\t}\n\t}\n\tchapterCodeArr.push(codeKey);\n\tchapterCodeIdxArr.push(iIdx);\n\t$JE.setFieldValue(newRowBillCodeField, $CURRENT_DATA, iIdx, codeKey);\n}\n//console.log(chapterCodeArr);\n\n//这里简单排序,如果用独立指标来显示数据的话,这个排序就派上用场,否则就是默认的顺序\nchapterCodeIdxArr.sort(function(idx1, idx2) {\n\treturn (chapterCodeArr[idx1] - chapterCodeArr[idx2]);\n});\n//根据实际方案,提取原始数据到独立指标去。\n//。。。",
  110. "format": ""
  111. },
  112. {
  113. "Name": "分组txt调整",
  114. "run_type": "before_group_text_output",
  115. "expression": "let newRowBillCodeField = $JE.F(12104,$CURRENT_RPT); //新分组判断指标, 用来做前缀\n\nlet fLen0 = $JE.getFieldDataLen(newRowBillCodeField, $CURRENT_DATA);\n\nif ($TEXT.Label && $TEXT.Label.indexOf('小计') >= 0) {\n\tif (!$TEXT.hasOwnProperty('accCount')) {\n\t\t$TEXT.accCount = 0; //考虑到跨页的情况,需要额外的下标计数器来处理, $TIMES是不足够的\n\t}\n\tlet sumIdx = $TEXT.Label.indexOf('小计');\n\tlet preVal = $JE.getFieldValue(newRowBillCodeField, $CURRENT_DATA, 0, '');\n\tlet fLen0 = $JE.getFieldDataLen(newRowBillCodeField, $CURRENT_DATA);\n\tlet gIdx;\n\tif ($TEXT.accCount > 0 && fLen0 > 1) {\n\t\tlet cnt = 0;\n\t\tfor (gIdx = 1; gIdx < fLen0; gIdx++) {\n\t\t\tif (preVal !== $JE.getFieldValue(newRowBillCodeField, $CURRENT_DATA, gIdx, '')) {\n\t\t\t\tcnt++;\n\t\t\t\tpreVal = $JE.getFieldValue(newRowBillCodeField, $CURRENT_DATA, gIdx, '');\n\t\t\t}\n\t\t\tif (cnt === $TEXT.accCount) {\n\t\t\t\tbreak;\n\t\t\t}\n\t\t}\n\t}\n\tif (preVal !== '') {\n\t\t$TEXT.Label = preVal.slice(1) + '章' + $TEXT.Label.slice(sumIdx);\n\t}else{\n\t\t$TEXT.Label = '其他章' + $TEXT.Label.slice(sumIdx);\n\t}\n\t$TEXT.accCount++;\n}",
  116. "format": ""
  117. },
  118. {
  119. "Name": "合计金额",
  120. "run_type": "before_paging",
  121. "expression": "let benQiJiLiang = $JE.F(2127,$CURRENT_RPT); //本期计量金额\nlet zlBillsCodeField_ht = $JE.F(2128,$CURRENT_RPT) ;//本期合同金额\nlet zlBillsCodeField_bg = $JE.F(2129,$CURRENT_RPT) ;//本期变更金额\n\nlet totalFee = $JE.F(12106,$CURRENT_RPT);//新增合计指标 \n\nlet totalRreci = $JE.F(1156,$CURRENT_RPT);//金额的精度\n\nlet jingdu = $JE.getFieldValue(totalRreci,$CURRENT_DATA,0,0);\n\nlet sumValue = 0; \nlet fLen0 = $JE.getFieldDataLen(benQiJiLiang, $CURRENT_DATA);\n\nfor (let chkIdx = 0; chkIdx < fLen0; chkIdx++) {\n\tif($JE.getFieldValue(benQiJiLiang,$CURRENT_DATA,chkIdx,0)){\n\t\tlet bqwc = 0;\n\t\tlet ht = $JE.getFieldValue(zlBillsCodeField_ht,$CURRENT_DATA,chkIdx,0);\n\t\tlet bg = $JE.getFieldValue(zlBillsCodeField_bg,$CURRENT_DATA,chkIdx,0);\n\t\tbqwc = $CTX_HELPER.add(Math.round(parseFloat(ht)*Math.pow(10,jingdu))/Math.pow(10,jingdu),Math.round(parseFloat(bg)*Math.pow(10,jingdu))/Math.pow(10,jingdu));\n\t\tsumValue = $CTX_HELPER.add(sumValue,bqwc);\n\t}\n}\n\n$JE.setFieldValue(totalFee,$CURRENT_DATA,0,sumValue);",
  122. "format": ""
  123. },
  124. {
  125. "Name": "截至日期转换",
  126. "run_type": "before_paging",
  127. "expression": "let rpt = $JE.F(1312,$CURRENT_RPT);\nlet newShiJian = $JE.F(12108,$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(newShiJian, $CURRENT_DATA, 0, newRiQiValue);\n}",
  128. "format": "yyyy 年 M 月 dd 日"
  129. },
  130. {
  131. "Name": "本期金额修改",
  132. "run_type": "before_paging",
  133. "expression": "//峨山县定制 综合设置\nlet zlBillsCodeField = $JE.F(2127,$CURRENT_RPT) ;//本期完成金额\nlet zlBillsCodeField_ht = $JE.F(2128,$CURRENT_RPT) ;//本期合同金额\nlet zlBillsCodeField_bg = $JE.F(2129,$CURRENT_RPT) ;//本期变更金额\n\nlet totalRreci = $JE.F(1156,$CURRENT_RPT);//金额的精度\nlet jingdu = $JE.getFieldValue(totalRreci,$CURRENT_DATA,0,0);\n\nlet fLen0 = $JE.getFieldDataLen(zlBillsCodeField, $CURRENT_DATA);\n\nfor(let i = 0; i< fLen0 ;i++){\n\tlet bqwc = 0;\n\tlet ht = $JE.getFieldValue(zlBillsCodeField_ht,$CURRENT_DATA,i,0);\n\tlet bg = $JE.getFieldValue(zlBillsCodeField_bg,$CURRENT_DATA,i,0);\n\tbqwc = $CTX_HELPER.add(Math.round(parseFloat(ht)*Math.pow(10,jingdu))/Math.pow(10,jingdu),Math.round(parseFloat(bg)*Math.pow(10,jingdu))/Math.pow(10,jingdu));\n\t\n\t$JE.setFieldValue(zlBillsCodeField,$CURRENT_DATA,i,bqwc);\n}",
  134. "format": ""
  135. }
  136. ],
  137. "流水式表_信息": {
  138. "离散信息": [
  139. {
  140. "BandName": "TitleBand",
  141. "text_s": [
  142. {
  143. "Label": "支表14 中间计量支付汇总表",
  144. "font": "ReportTitle_Main",
  145. "control": "Title",
  146. "style": "Default_None",
  147. "Title": "",
  148. "area": {
  149. "Left": 0,
  150. "Right": 100,
  151. "Top": 0,
  152. "Bottom": 100,
  153. "H_CalculationType": "percentage",
  154. "V_CalculationType": "percentage"
  155. }
  156. }
  157. ]
  158. },
  159. {
  160. "BandName": "HeaderBand",
  161. "discrete_field_s": [
  162. {
  163. "FieldID": 1134,
  164. "font": "Header",
  165. "control": "Header",
  166. "style": "Default_None",
  167. "Prefix": "承包单位:",
  168. "isAutoHeight": false,
  169. "area": {
  170. "Left": 0,
  171. "Right": "56",
  172. "Top": "33.33",
  173. "Bottom": "66.66",
  174. "H_CalculationType": "percentage",
  175. "V_CalculationType": "percentage"
  176. }
  177. },
  178. {
  179. "FieldID": 1140,
  180. "font": "Header",
  181. "control": "Header",
  182. "style": "Default_None",
  183. "Prefix": "监理单位:",
  184. "isAutoHeight": false,
  185. "area": {
  186. "Left": "56",
  187. "Right": "88",
  188. "Top": 0,
  189. "Bottom": "33.33",
  190. "H_CalculationType": "percentage",
  191. "V_CalculationType": "percentage"
  192. }
  193. },
  194. {
  195. "FieldID": 1102,
  196. "font": "Header",
  197. "control": "Header",
  198. "style": "Default_None",
  199. "Prefix": "合 同 号:",
  200. "isAutoHeight": false,
  201. "area": {
  202. "Left": "56",
  203. "Right": "88",
  204. "Top": "33.33",
  205. "Bottom": "66.66",
  206. "H_CalculationType": "percentage",
  207. "V_CalculationType": "percentage"
  208. }
  209. },
  210. {
  211. "ParamID": "5010",
  212. "font": "Header",
  213. "control": "Header",
  214. "style": "Default_None",
  215. "Default_Value": "第 X 页",
  216. "area": {
  217. "Left": "88",
  218. "Right": "94",
  219. "Top": "66.66",
  220. "Bottom": 100,
  221. "H_CalculationType": "percentage",
  222. "V_CalculationType": "percentage"
  223. }
  224. },
  225. {
  226. "ParamID": "5011",
  227. "font": "Header",
  228. "control": "Header",
  229. "style": "Default_None",
  230. "Default_Value": "共 Y 页",
  231. "area": {
  232. "Left": "94",
  233. "Right": 100,
  234. "Top": "66.66",
  235. "Bottom": 100,
  236. "H_CalculationType": "percentage",
  237. "V_CalculationType": "percentage"
  238. }
  239. },
  240. {
  241. "FieldID": 1103,
  242. "font": "Header",
  243. "control": "Header",
  244. "style": "Default_None",
  245. "Prefix": "项目名称:",
  246. "isAutoHeight": false,
  247. "area": {
  248. "Left": 0,
  249. "Right": "56",
  250. "Top": 0,
  251. "Bottom": "33.33",
  252. "H_CalculationType": "percentage",
  253. "V_CalculationType": "percentage"
  254. }
  255. },
  256. {
  257. "FieldID": 1300,
  258. "font": "Header",
  259. "control": "Header",
  260. "style": "Default_None",
  261. "Prefix": "编 号:",
  262. "isAutoHeight": false,
  263. "area": {
  264. "Left": "56",
  265. "Right": "88",
  266. "Top": "66.66",
  267. "Bottom": 100,
  268. "H_CalculationType": "percentage",
  269. "V_CalculationType": "percentage"
  270. }
  271. },
  272. {
  273. "FieldID": 12108,
  274. "font": "Header",
  275. "control": "Header",
  276. "style": "Default_None",
  277. "Prefix": "截至日期:",
  278. "isAutoHeight": false,
  279. "area": {
  280. "Left": 0,
  281. "Right": "56",
  282. "Top": "66.66",
  283. "Bottom": 100,
  284. "H_CalculationType": "percentage",
  285. "V_CalculationType": "percentage"
  286. }
  287. }
  288. ]
  289. },
  290. {
  291. "BandName": "FooterBand",
  292. "discrete_field_s": [
  293. {
  294. "FieldID": 12058,
  295. "font": "Content",
  296. "control": "NewContent_Left",
  297. "style": "Default_None",
  298. "isAutoHeight": false,
  299. "area": {
  300. "Left": "5",
  301. "Right": "22.5",
  302. "Top": 0,
  303. "Bottom": 100,
  304. "H_CalculationType": "percentage",
  305. "V_CalculationType": "percentage"
  306. }
  307. },
  308. {
  309. "FieldID": 12059,
  310. "font": "Content",
  311. "control": "NewContent_Left",
  312. "style": "Default_None",
  313. "isAutoHeight": false,
  314. "area": {
  315. "Left": "28",
  316. "Right": "46",
  317. "Top": 0,
  318. "Bottom": 100,
  319. "H_CalculationType": "percentage",
  320. "V_CalculationType": "percentage"
  321. }
  322. },
  323. {
  324. "FieldID": 12060,
  325. "font": "Content",
  326. "control": "NewContent_Left",
  327. "style": "Default_None",
  328. "isAutoHeight": false,
  329. "area": {
  330. "Left": "54",
  331. "Right": "71",
  332. "Top": 0,
  333. "Bottom": 100,
  334. "H_CalculationType": "percentage",
  335. "V_CalculationType": "percentage"
  336. }
  337. },
  338. {
  339. "FieldID": 12061,
  340. "font": "Content",
  341. "control": "NewContent_Left",
  342. "style": "Default_None",
  343. "isAutoHeight": false,
  344. "area": {
  345. "Left": "82",
  346. "Right": "100",
  347. "Top": 0,
  348. "Bottom": 100,
  349. "H_CalculationType": "percentage",
  350. "V_CalculationType": "percentage"
  351. }
  352. }
  353. ],
  354. "text_s": [
  355. {
  356. "Label": "承包人:",
  357. "font": "Content",
  358. "control": "Footer",
  359. "style": "Default_None",
  360. "Title": "",
  361. "area": {
  362. "Left": 0,
  363. "Right": "5",
  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": "22.5",
  378. "Right": "28",
  379. "Top": 0,
  380. "Bottom": 100,
  381. "H_CalculationType": "percentage",
  382. "V_CalculationType": "percentage"
  383. }
  384. },
  385. {
  386. "Label": "监理组组长:",
  387. "font": "Content",
  388. "control": "Footer",
  389. "style": "Default_None",
  390. "Title": "",
  391. "area": {
  392. "Left": "46",
  393. "Right": "54",
  394. "Top": 0,
  395. "Bottom": 100,
  396. "H_CalculationType": "percentage",
  397. "V_CalculationType": "percentage"
  398. }
  399. },
  400. {
  401. "Label": "业主(业主代表):",
  402. "font": "Content",
  403. "control": "Footer",
  404. "style": "Default_None",
  405. "Title": "",
  406. "area": {
  407. "Left": "71",
  408. "Right": "82",
  409. "Top": 0,
  410. "Bottom": 100,
  411. "H_CalculationType": "percentage",
  412. "V_CalculationType": "percentage"
  413. }
  414. }
  415. ]
  416. },
  417. {
  418. "BandName": "GrandTotalBand",
  419. "discrete_field_s": [
  420. {
  421. "FieldID": 12106,
  422. "font": "Content",
  423. "control": "Currency",
  424. "style": "Default_Normal",
  425. "isAutoHeight": false,
  426. "area": {
  427. "Left": "88",
  428. "Right": 100,
  429. "Top": 0,
  430. "Bottom": 100,
  431. "H_CalculationType": "percentage",
  432. "V_CalculationType": "percentage"
  433. }
  434. }
  435. ],
  436. "text_s": [
  437. {
  438. "Label": "合计",
  439. "font": "Content",
  440. "control": "Column",
  441. "style": "Default_Normal",
  442. "Title": "",
  443. "area": {
  444. "Left": "10",
  445. "Right": "40",
  446. "Top": 0,
  447. "Bottom": 100,
  448. "H_CalculationType": "percentage",
  449. "V_CalculationType": "percentage"
  450. }
  451. },
  452. {
  453. "Label": "",
  454. "font": "Content",
  455. "control": "Column",
  456. "style": "Default_Normal",
  457. "Title": "",
  458. "area": {
  459. "Left": 0,
  460. "Right": "10",
  461. "Top": 0,
  462. "Bottom": 100,
  463. "H_CalculationType": "percentage",
  464. "V_CalculationType": "percentage"
  465. }
  466. },
  467. {
  468. "Label": "",
  469. "font": "Content",
  470. "control": "Column",
  471. "style": "Default_Normal",
  472. "Title": "",
  473. "area": {
  474. "Left": "40",
  475. "Right": "56",
  476. "Top": 0,
  477. "Bottom": 100,
  478. "H_CalculationType": "percentage",
  479. "V_CalculationType": "percentage"
  480. }
  481. },
  482. {
  483. "Label": "",
  484. "font": "Content",
  485. "control": "Column",
  486. "style": "Default_Normal",
  487. "Title": "",
  488. "area": {
  489. "Left": "56",
  490. "Right": "64",
  491. "Top": 0,
  492. "Bottom": 100,
  493. "H_CalculationType": "percentage",
  494. "V_CalculationType": "percentage"
  495. }
  496. },
  497. {
  498. "Label": "",
  499. "font": "Content",
  500. "control": "Column",
  501. "style": "Default_Normal",
  502. "Title": "",
  503. "area": {
  504. "Left": "64",
  505. "Right": "76",
  506. "Top": 0,
  507. "Bottom": 100,
  508. "H_CalculationType": "percentage",
  509. "V_CalculationType": "percentage"
  510. }
  511. },
  512. {
  513. "Label": "",
  514. "font": "Content",
  515. "control": "Column",
  516. "style": "Default_Normal",
  517. "Title": "",
  518. "area": {
  519. "Left": "76",
  520. "Right": "88",
  521. "Top": 0,
  522. "Bottom": 100,
  523. "H_CalculationType": "percentage",
  524. "V_CalculationType": "percentage"
  525. }
  526. }
  527. ]
  528. }
  529. ],
  530. "流水式表_列": {
  531. "BandName": "ColumnBand",
  532. "text_s": [
  533. {
  534. "Label": "项目编号",
  535. "font": "HeaderColumn",
  536. "control": "Column",
  537. "style": "Default_Normal",
  538. "Title": "",
  539. "area": {
  540. "Left": 0,
  541. "Right": "10",
  542. "Top": 0,
  543. "Bottom": 100,
  544. "H_CalculationType": "percentage",
  545. "V_CalculationType": "percentage"
  546. }
  547. },
  548. {
  549. "Label": "项 目 名 称",
  550. "font": "HeaderColumn",
  551. "control": "Column",
  552. "style": "Default_Normal",
  553. "Title": "",
  554. "area": {
  555. "Left": "10",
  556. "Right": "40",
  557. "Top": 0,
  558. "Bottom": 100,
  559. "H_CalculationType": "percentage",
  560. "V_CalculationType": "percentage"
  561. }
  562. },
  563. {
  564. "Label": "凭证号",
  565. "font": "HeaderColumn",
  566. "control": "Column",
  567. "style": "Default_Normal",
  568. "Title": "",
  569. "area": {
  570. "Left": "40",
  571. "Right": "56",
  572. "Top": 0,
  573. "Bottom": 100,
  574. "H_CalculationType": "percentage",
  575. "V_CalculationType": "percentage"
  576. }
  577. },
  578. {
  579. "Label": "单位",
  580. "font": "HeaderColumn",
  581. "control": "Column",
  582. "style": "Default_Normal",
  583. "Title": "",
  584. "area": {
  585. "Left": "56",
  586. "Right": "64",
  587. "Top": 0,
  588. "Bottom": 100,
  589. "H_CalculationType": "percentage",
  590. "V_CalculationType": "percentage"
  591. }
  592. },
  593. {
  594. "Label": "数量",
  595. "font": "HeaderColumn",
  596. "control": "Column",
  597. "style": "Default_Normal",
  598. "Title": "",
  599. "area": {
  600. "Left": "64",
  601. "Right": "76",
  602. "Top": 0,
  603. "Bottom": 100,
  604. "H_CalculationType": "percentage",
  605. "V_CalculationType": "percentage"
  606. }
  607. },
  608. {
  609. "Label": "单价",
  610. "font": "HeaderColumn",
  611. "control": "Column",
  612. "style": "Default_Normal",
  613. "Title": "",
  614. "area": {
  615. "Left": "76",
  616. "Right": "88",
  617. "Top": 0,
  618. "Bottom": 100,
  619. "H_CalculationType": "percentage",
  620. "V_CalculationType": "percentage"
  621. }
  622. },
  623. {
  624. "Label": "金额",
  625. "font": "HeaderColumn",
  626. "control": "Column",
  627. "style": "Default_Normal",
  628. "Title": "",
  629. "area": {
  630. "Left": "88",
  631. "Right": 100,
  632. "Top": 0,
  633. "Bottom": 100,
  634. "H_CalculationType": "percentage",
  635. "V_CalculationType": "percentage"
  636. }
  637. }
  638. ]
  639. },
  640. "多列显示数量": 1,
  641. "流水式表_数据": {
  642. "BandName": "ContentBand",
  643. "CommonHeight": "0.6",
  644. "flow_field_s": [
  645. {
  646. "FieldID": 2103,
  647. "font": "Content",
  648. "control": "NewContent_Left",
  649. "style": "Default_Normal",
  650. "isAutoHeight": false,
  651. "area": {
  652. "Left": 0,
  653. "Right": "10",
  654. "Top": 0,
  655. "Bottom": 100,
  656. "H_CalculationType": "percentage",
  657. "V_CalculationType": "percentage"
  658. }
  659. },
  660. {
  661. "FieldID": 2104,
  662. "font": "Content",
  663. "control": "NewContent_Left",
  664. "style": "Default_Normal",
  665. "isAutoHeight": false,
  666. "area": {
  667. "Left": "10",
  668. "Right": "40",
  669. "Top": 0,
  670. "Bottom": 100,
  671. "H_CalculationType": "percentage",
  672. "V_CalculationType": "percentage"
  673. }
  674. },
  675. {
  676. "FieldID": 2115,
  677. "font": "Content",
  678. "control": "NewContent_Left",
  679. "style": "Default_Normal",
  680. "isAutoHeight": false,
  681. "area": {
  682. "Left": "40",
  683. "Right": "56",
  684. "Top": 0,
  685. "Bottom": 100,
  686. "H_CalculationType": "percentage",
  687. "V_CalculationType": "percentage"
  688. }
  689. },
  690. {
  691. "FieldID": 2105,
  692. "font": "Content",
  693. "control": "NewContent_Center",
  694. "style": "Default_Normal",
  695. "isAutoHeight": false,
  696. "area": {
  697. "Left": "56",
  698. "Right": "64",
  699. "Top": 0,
  700. "Bottom": 100,
  701. "H_CalculationType": "percentage",
  702. "V_CalculationType": "percentage"
  703. }
  704. },
  705. {
  706. "FieldID": 2106,
  707. "font": "Content",
  708. "control": "Currency",
  709. "style": "Default_Normal",
  710. "isAutoHeight": false,
  711. "area": {
  712. "Left": "76",
  713. "Right": "88",
  714. "Top": 0,
  715. "Bottom": 100,
  716. "H_CalculationType": "percentage",
  717. "V_CalculationType": "percentage"
  718. }
  719. },
  720. {
  721. "FieldID": 2127,
  722. "font": "Content",
  723. "control": "Currency",
  724. "style": "Default_Normal",
  725. "isAutoHeight": false,
  726. "area": {
  727. "Left": "88",
  728. "Right": 100,
  729. "Top": 0,
  730. "Bottom": 100,
  731. "H_CalculationType": "percentage",
  732. "V_CalculationType": "percentage"
  733. }
  734. },
  735. {
  736. "FieldID": 2107,
  737. "font": "Content",
  738. "control": "Currency",
  739. "style": "Default_Normal",
  740. "isAutoHeight": false,
  741. "area": {
  742. "Left": "64",
  743. "Right": "76",
  744. "Top": 0,
  745. "Bottom": 100,
  746. "H_CalculationType": "percentage",
  747. "V_CalculationType": "percentage"
  748. }
  749. }
  750. ]
  751. },
  752. "流水式表_分组信息": {
  753. "group_field_s": [
  754. {
  755. "FieldID": 12104
  756. }
  757. ],
  758. "sum_field_s": [
  759. {
  760. "FieldID": 2127,
  761. "SumKey": "中间计量总量信息_本期金额"
  762. }
  763. ],
  764. "group_lines": [
  765. {
  766. "SumKey_S": [
  767. {
  768. "FieldID": 2127,
  769. "font": "Content",
  770. "control": "Currency",
  771. "style": "Default_Normal",
  772. "Prefix": "",
  773. "isAutoHeight": false,
  774. "area": {
  775. "Left": "88",
  776. "Right": "100",
  777. "Top": 0,
  778. "Bottom": 100,
  779. "H_CalculationType": "percentage",
  780. "V_CalculationType": "percentage"
  781. },
  782. "SumKey": "中间计量总量信息_本期金额"
  783. }
  784. ],
  785. "text_s": [
  786. {
  787. "Label": "小计",
  788. "font": "Content",
  789. "control": "Column",
  790. "style": "Default_Normal",
  791. "Title": "",
  792. "area": {
  793. "Left": "10",
  794. "Right": "40",
  795. "Top": 0,
  796. "Bottom": 100,
  797. "H_CalculationType": "percentage",
  798. "V_CalculationType": "percentage"
  799. }
  800. },
  801. {
  802. "Label": "",
  803. "font": "Content",
  804. "control": "Column",
  805. "style": "Default_Normal",
  806. "Title": "",
  807. "area": {
  808. "Left": 0,
  809. "Right": "10",
  810. "Top": 0,
  811. "Bottom": 100,
  812. "H_CalculationType": "percentage",
  813. "V_CalculationType": "percentage"
  814. }
  815. },
  816. {
  817. "Label": "",
  818. "font": "Content",
  819. "control": "Column",
  820. "style": "Default_Normal",
  821. "Title": "",
  822. "area": {
  823. "Left": "40",
  824. "Right": "56",
  825. "Top": 0,
  826. "Bottom": 100,
  827. "H_CalculationType": "percentage",
  828. "V_CalculationType": "percentage"
  829. }
  830. },
  831. {
  832. "Label": "",
  833. "font": "Content",
  834. "control": "Column",
  835. "style": "Default_Normal",
  836. "Title": "",
  837. "area": {
  838. "Left": "56",
  839. "Right": "64",
  840. "Top": 0,
  841. "Bottom": 100,
  842. "H_CalculationType": "percentage",
  843. "V_CalculationType": "percentage"
  844. }
  845. },
  846. {
  847. "Label": "",
  848. "font": "Content",
  849. "control": "Column",
  850. "style": "Default_Normal",
  851. "Title": "",
  852. "area": {
  853. "Left": "64",
  854. "Right": "76",
  855. "Top": 0,
  856. "Bottom": 100,
  857. "H_CalculationType": "percentage",
  858. "V_CalculationType": "percentage"
  859. }
  860. },
  861. {
  862. "Label": "",
  863. "font": "Content",
  864. "control": "Column",
  865. "style": "Default_Normal",
  866. "Title": "",
  867. "area": {
  868. "Left": "76",
  869. "Right": "88",
  870. "Top": 0,
  871. "Bottom": 100,
  872. "H_CalculationType": "percentage",
  873. "V_CalculationType": "percentage"
  874. }
  875. }
  876. ]
  877. }
  878. ]
  879. },
  880. "流水式表_段统计信息": {
  881. "BandName": "",
  882. "sum_field_s": [],
  883. "text_s": []
  884. },
  885. "流水式表_页统计信息": {
  886. "BandName": "",
  887. "sum_field_s": [],
  888. "text_s": []
  889. }
  890. },
  891. "离散参数_集合": [
  892. {
  893. "ID": "5001",
  894. "Name": "打印时间",
  895. "DataType": "String",
  896. "Default_Value": ""
  897. },
  898. {
  899. "ID": "5010",
  900. "Name": "当前页",
  901. "DataType": "String",
  902. "Default_Value": "第 X 页"
  903. },
  904. {
  905. "ID": "5011",
  906. "Name": "总页数",
  907. "DataType": "String",
  908. "Default_Value": "共 Y 页"
  909. }
  910. ],
  911. "指标_数据_映射": {
  912. "离散指标_集合": [
  913. {
  914. "ID": 1101,
  915. "Name": "标段_项目名称",
  916. "DataType": "string",
  917. "TableName": "tender_info",
  918. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.buildName')",
  919. "descr": "",
  920. "Title": "ID: 1101"
  921. },
  922. {
  923. "ID": 1102,
  924. "Name": "标段_合同号",
  925. "DataType": "string",
  926. "TableName": "tender_info",
  927. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealCode')",
  928. "descr": "",
  929. "Title": "ID: 1102"
  930. },
  931. {
  932. "ID": 1103,
  933. "Name": "标段_合同名称",
  934. "DataType": "string",
  935. "TableName": "tender_info",
  936. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealName\")",
  937. "descr": "",
  938. "Title": "ID: 1103"
  939. },
  940. {
  941. "ID": 1300,
  942. "Name": "期计量信息_期数",
  943. "DataType": "number",
  944. "TableName": "stage",
  945. "mapExpression": "$PROJECT.REPORT.getProperty('stage', 'order')",
  946. "descr": "",
  947. "Title": "ID: 1300"
  948. },
  949. {
  950. "ID": 1134,
  951. "Name": "标段_标段清单_承包单位1_单位名称",
  952. "DataType": "string",
  953. "TableName": "tender_info",
  954. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.contract1.company')",
  955. "descr": "",
  956. "Title": "ID: 1134"
  957. },
  958. {
  959. "ID": 1140,
  960. "Name": "标段_标段清单_监理单位1_单位名称",
  961. "DataType": "string",
  962. "TableName": "tender_info",
  963. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.supervision1.company')",
  964. "descr": "",
  965. "Title": "ID: 1140"
  966. },
  967. {
  968. "ID": 1310,
  969. "Name": "期计量信息_开始截至日期",
  970. "DataType": "string",
  971. "TableName": "stage",
  972. "mapExpression": "$PROJECT.REPORT.getProperty('stage', 'period')",
  973. "descr": "",
  974. "Title": "ID: 1310"
  975. },
  976. {
  977. "ID": 1103,
  978. "Name": "标段_编号",
  979. "DataType": "string",
  980. "TableName": "tender_info",
  981. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealName')",
  982. "descr": "",
  983. "Title": "ID: 1103"
  984. },
  985. {
  986. "ID": 1312,
  987. "Name": "期计量信息_截至日期",
  988. "DataType": "string",
  989. "TableName": "stage",
  990. "mapExpression": "$PROJECT.REPORT.getSplitProperty(\"stage\", \"period\", \" ~ \", 1, \"\")",
  991. "descr": "",
  992. "Title": "ID: 1312"
  993. },
  994. {
  995. "ID": 1156,
  996. "Name": "标段_小数位数_金额",
  997. "DataType": "int",
  998. "TableName": "tender_info",
  999. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")",
  1000. "descr": "",
  1001. "Title": "ID: 1156"
  1002. }
  1003. ],
  1004. "主数据指标_集合": [],
  1005. "从数据指标_集合": [
  1006. {
  1007. "ID": 2103,
  1008. "Name": "中间计量总量信息_编号",
  1009. "DataType": "string",
  1010. "TableName": "mem_stage_im_zl",
  1011. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'code')",
  1012. "descr": "",
  1013. "Title": "ID: 2103"
  1014. },
  1015. {
  1016. "ID": 2104,
  1017. "Name": "中间计量总量信息_名称",
  1018. "DataType": "string",
  1019. "TableName": "mem_stage_im_zl",
  1020. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'name')",
  1021. "descr": "",
  1022. "Title": "ID: 2104"
  1023. },
  1024. {
  1025. "ID": 2115,
  1026. "Name": "中间计量总量信息_凭证号",
  1027. "DataType": "string",
  1028. "TableName": "mem_stage_im_zl",
  1029. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'doc_code')",
  1030. "descr": "",
  1031. "Title": "ID: 2115"
  1032. },
  1033. {
  1034. "ID": 2105,
  1035. "Name": "中间计量总量信息_单位",
  1036. "DataType": "string",
  1037. "TableName": "mem_stage_im_zl",
  1038. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'unit')",
  1039. "descr": "",
  1040. "Title": "ID: 2105"
  1041. },
  1042. {
  1043. "ID": 2106,
  1044. "Name": "中间计量总量信息_单价",
  1045. "DataType": "currency",
  1046. "TableName": "mem_stage_im_zl",
  1047. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'unit_price')",
  1048. "descr": "",
  1049. "Title": "ID: 2106",
  1050. "Precision": {
  1051. "type": "fixed",
  1052. "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.up')"
  1053. }
  1054. },
  1055. {
  1056. "ID": 2127,
  1057. "Name": "中间计量总量信息_本期金额",
  1058. "DataType": "currency",
  1059. "TableName": "mem_stage_im_zl",
  1060. "mapExpression": "$PROJECT.COMMON.Multiply($PROJECT.REPORT.getProperty('mem_stage_im_zl', 'jl'),$PROJECT.REPORT.getProperty('mem_stage_im_zl', 'unit_price'),6)",
  1061. "descr": "",
  1062. "Title": "ID: 2127",
  1063. "Precision": {
  1064. "type": "fixed",
  1065. "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')"
  1066. }
  1067. },
  1068. {
  1069. "ID": 2107,
  1070. "Name": "中间计量总量信息_本期数量",
  1071. "DataType": "currency",
  1072. "TableName": "mem_stage_im_zl",
  1073. "mapExpression": "$PROJECT.REPORT.getProperty(\"mem_stage_im_zl\", \"jl\")",
  1074. "descr": "",
  1075. "Title": "ID: 2107",
  1076. "Precision": {
  1077. "type": "flexible",
  1078. "flexibleRefFieldID": 2105,
  1079. "flexibleMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"precision\")"
  1080. }
  1081. },
  1082. {
  1083. "ID": 2128,
  1084. "Name": "中间计量总量信息_本期合同金额",
  1085. "DataType": "currency",
  1086. "TableName": "mem_stage_im_zl",
  1087. "mapExpression": "$PROJECT.COMMON.Multiply($PROJECT.REPORT.getProperty(\"mem_stage_im_zl\", \"contract_jl\"),$PROJECT.REPORT.getProperty(\"mem_stage_im_zl\", \"unit_price\"),6)",
  1088. "descr": "",
  1089. "Title": "ID: 2128",
  1090. "Precision": {
  1091. "type": "fixed",
  1092. "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")"
  1093. }
  1094. },
  1095. {
  1096. "ID": 2129,
  1097. "Name": "中间计量总量信息_本期变更金额",
  1098. "DataType": "currency",
  1099. "TableName": "mem_stage_im_zl",
  1100. "mapExpression": "$PROJECT.COMMON.Multiply($PROJECT.REPORT.getProperty(\"mem_stage_im_zl\", \"qc_jl\"),$PROJECT.REPORT.getProperty(\"mem_stage_im_zl\", \"unit_price\"),6)",
  1101. "descr": "",
  1102. "Title": "ID: 2129",
  1103. "Precision": {
  1104. "type": "fixed",
  1105. "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")"
  1106. }
  1107. }
  1108. ],
  1109. "主数据指标_拓展集合": [],
  1110. "从数据指标_拓展集合": []
  1111. },
  1112. "映射数据预处理": [],
  1113. "无映射离散指标_集合": [
  1114. {
  1115. "ID": 12104,
  1116. "Name": "新分组判断指标",
  1117. "DataType": "string"
  1118. },
  1119. {
  1120. "ID": 12106,
  1121. "Name": "汇总金额",
  1122. "DataType": "string"
  1123. },
  1124. {
  1125. "ID": 12108,
  1126. "Name": "新截至日期",
  1127. "DataType": "string"
  1128. }
  1129. ],
  1130. "动态日期离散参数_集合": [],
  1131. "电子签名离散指标_集合": [
  1132. {
  1133. "ID": 12058,
  1134. "Name": "承包人",
  1135. "DataType": "string"
  1136. },
  1137. {
  1138. "ID": 12059,
  1139. "Name": "监理员",
  1140. "DataType": "string"
  1141. },
  1142. {
  1143. "ID": 12060,
  1144. "Name": "监理组组长",
  1145. "DataType": "string"
  1146. },
  1147. {
  1148. "ID": 12061,
  1149. "Name": "业主(业主代表)",
  1150. "DataType": "string"
  1151. }
  1152. ]
  1153. }