支表5 工程变更一览表.js 66 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587
  1. {
  2. "ID_KEY": "DUMMY_FLOW_SAMPLE",
  3. "GROUP_KEY": "RPT_支表5 工程变更一览表_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. "报表名称": "支表5 工程变更一览表",
  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.2",
  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.85",
  62. "Name": "ColumnBand",
  63. "control": "Default",
  64. "style": "Default_Normal",
  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_analyzing",
  100. "expression": "\nlet bCode=$JE.F(2510,$CURRENT_RPT);\nlet bName=$JE.F(2511,$CURRENT_RPT);\nlet bUnit=$JE.F(2512,$CURRENT_RPT);\nlet bPrice=$JE.F(2513,$CURRENT_RPT);\nlet bDealQty=$JE.F(2553,$CURRENT_RPT);\nlet bJZBQty=$JE.F(2545,$CURRENT_RPT);\nlet bJZBTP=$JE.F(2546,$CURRENT_RPT);\nlet bJZSQty=$JE.F(2539,$CURRENT_RPT);\nlet bJZSTP=$JE.F(2540,$CURRENT_RPT);\nlet bBqQty=$JE.F(2532,$CURRENT_RPT);\nlet bBqTP=$JE.F(2533,$CURRENT_RPT);\nlet bBglCode=$JE.F(2551,$CURRENT_RPT);\nlet bChapterCode=$JE.F(2552,$CURRENT_RPT);\nlet bCodeArr=$JE.getFieldValueArray(bCode,$CURRENT_DATA);\n//let fLen0=$JE.getFieldDataLen(bCode, $CURRENT_DATA);\nlet orgFieldArr=[bCode,bName,bUnit,bPrice,bDealQty,bJZBQty,bJZBTP,bJZSQty,bJZSTP,bBqQty,bBqTP,bBglCode,bChapterCode];\n\nlet newBCode=$JE.F(12070,$CURRENT_RPT);\nlet newBName=$JE.F(12071,$CURRENT_RPT);\nlet newBUnit=$JE.F(12072,$CURRENT_RPT);\nlet newBPrice=$JE.F(12074,$CURRENT_RPT);\nlet newBDealQty=$JE.F(12073,$CURRENT_RPT);\nlet newBJZBQty=$JE.F(12075,$CURRENT_RPT);\nlet newBJZBTP=$JE.F(12076,$CURRENT_RPT);\nlet newBJZSQty=$JE.F(12077,$CURRENT_RPT);\nlet newBJZSTP=$JE.F(12078,$CURRENT_RPT);\nlet newBBqQty=$JE.F(12079,$CURRENT_RPT);\nlet newBBqTP=$JE.F(12080,$CURRENT_RPT);\nlet newBglCode=$JE.F(12081,$CURRENT_RPT);\nlet newBChapterCode=$JE.F(12082,$CURRENT_RPT);\nlet newFieldArr=[newBCode,newBName,newBUnit,newBPrice,newBDealQty,newBJZBQty,newBJZBTP,newBJZSQty,newBJZSTP,newBBqQty,newBBqTP,newBglCode,newBChapterCode];\n\n//处理原始列表中章节编号为空的\n\tlet count=0;\nfor(let i=0;i< bCodeArr.length;i++){\n\t//非标准清单章节号都为空,要特殊处理\n\tlet chapterCode=$CTX_HELPER.getChapterCode(bCodeArr[i], '-');\n\t//console.log('清单编号:%s,章节号:%s',chapterCode,chapterCode);\n\tlet orgChapterCode = $JE.getFieldValue(bChapterCode, $CURRENT_DATA, i, '');\n\t//console.log('天天',orgChapterCode,orgChapterCode);\n\t//拼接签约清单后,签约清单的章节为空,所以需要赋值\n\tif(orgChapterCode===null || orgChapterCode==='' || orgChapterCode==10000){\n\t\tif(chapterCode===null || chapterCode==='' || chapterCode==10000){\n\t\t\t//console.log('我是未计入章节',orgChapterCode);\n\t\t\t$JE.setFieldValue(bChapterCode, $CURRENT_DATA, i, '其他');\n\t\t}else{\n\t\t\t//console.log('我是签约清单');\n\t\t\t$JE.setFieldValue(bChapterCode, $CURRENT_DATA, i, chapterCode);\n\t\t}\t\t\n\t}\n\tlet orgBJZBQty=$JE.getFieldValue(bJZBQty, $CURRENT_DATA, i, 0);\n\tlet orgBJZSQty=$JE.getFieldValue(bJZSQty, $CURRENT_DATA, i, 0);\n\tlet orgBBqQty=$JE.getFieldValue(bBqQty, $CURRENT_DATA, i, 0);\n\n\tif(orgBJZBQty!==0 || orgBJZSQty!==0 || orgBBqQty!==0){\n\t\t\n\t\tfor(let j=0;j<newFieldArr.length;j++){\n\t\t\tlet tempData=$JE.getFieldValue(orgFieldArr[j], $CURRENT_DATA, i, '');\t\n\t\t\t$JE.setFieldValue(newFieldArr[j], $CURRENT_DATA, count, tempData);\n\t\t}\n\tcount ++;\t\t\n\t}\n}\n\n\n\n\nlet yleng=$JE.getFieldDataLen(newBCode, $CURRENT_DATA);\nfor(let k=0;k<yleng;k++){\n\t//console.log(k);\n\tlet bb=$JE.getFieldValue(newBCode, $CURRENT_DATA, k, '');\n\tlet cc=$JE.getFieldValue(newBName, $CURRENT_DATA, k, '');\n\t//console.log('%s:%s',bb,cc);\n}\n\n//9. 如果新指标和原始不一样,就要进行数据筛选,原始多,则移除原始多余的,独立多,则原始的增加缺少的 \n// !!!记得计算式类型要设置为:数据分析前运行\nlet chkField = bCode;\nlet dtlLen = $JE.getFieldDataLen(chkField, $CURRENT_DATA), \n fValIdx = $JE.getFieldDataLen(newBCode, $CURRENT_DATA), \n\tdiff = dtlLen - fValIdx;\nif (diff > 0) {\n\tfor (let ix = 1; ix <= diff; ix++) {\n\t\t$JE.removeFieldValue(chkField, $CURRENT_DATA, dtlLen - ix);\n\t}\n} else if (diff < 0) {\n\tfor (let ix = 0; ix < (0 - diff); ix++) {\n\t\t$JE.setFieldValue(chkField, $CURRENT_DATA, dtlLen + ix, 0);\n\t}\n}\n\n\n",
  101. "format": ""
  102. },
  103. {
  104. "Name": "新计算式",
  105. "run_type": "before_group_text_output",
  106. "expression": "let newBChapterCode=$JE.F(12082,$CURRENT_RPT); //新分组判断指标, 用来做前缀\n\nif ($TEXT.Label && $TEXT.Label.indexOf('小计') >= 0) {\n\tif (!$TEXT.hasOwnProperty('accCount')) {\n\t\t$TEXT.accCount = 0; //考虑到跨页的情况,需要额外的下标计数器来处理, $TIMES是不足够的\n\t}\n\t\n\tlet sumIdx = $TEXT.Label.indexOf('小计');\n\tlet preVal = $JE.getFieldValue(newBChapterCode, $CURRENT_DATA, 0, '');\n\tlet fLen0 = $JE.getFieldDataLen(newBChapterCode, $CURRENT_DATA);\n\tif ($TEXT.accCount > 0 && fLen0 > 1) {\n\t\tlet cnt = 0;\n\t\tfor (let gIdx = 1; gIdx < fLen0; gIdx++) {\n\t\t\tif (preVal !== $JE.getFieldValue(newBChapterCode, $CURRENT_DATA, gIdx, '')) {\n\t\t\t\tcnt++;\n\t\t\t\tpreVal = $JE.getFieldValue(newBChapterCode, $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+ '章' + $TEXT.Label.slice(sumIdx);\n\t}\n\t$TEXT.accCount++;\n\tconsole.log('我是accCount:',$TEXT.accCount)\t\n}",
  107. "format": ""
  108. }
  109. ],
  110. "流水式表_信息": {
  111. "离散信息": [
  112. {
  113. "BandName": "TitleBand",
  114. "text_s": [
  115. {
  116. "Label": "支表5 工程变更一览表",
  117. "font": "ReportTitle_Main",
  118. "control": "Title",
  119. "style": "Default_None",
  120. "Title": "",
  121. "area": {
  122. "Left": 0,
  123. "Right": "100.00",
  124. "Top": 0,
  125. "Bottom": "100.00",
  126. "H_CalculationType": "percentage",
  127. "V_CalculationType": "percentage"
  128. }
  129. }
  130. ]
  131. },
  132. {
  133. "BandName": "HeaderBand",
  134. "discrete_field_s": [
  135. {
  136. "FieldID": 1103,
  137. "font": "Header",
  138. "control": "Header",
  139. "style": "Default_None",
  140. "Prefix": "项目名称:",
  141. "isAutoHeight": false,
  142. "area": {
  143. "Left": 0,
  144. "Right": "32.95",
  145. "Top": 0,
  146. "Bottom": "50",
  147. "H_CalculationType": "percentage",
  148. "V_CalculationType": "percentage"
  149. }
  150. },
  151. {
  152. "FieldID": 1312,
  153. "font": "Header",
  154. "control": "Header",
  155. "style": "Default_None",
  156. "Prefix": "截至日期:",
  157. "isAutoHeight": false,
  158. "area": {
  159. "Left": 0,
  160. "Right": "32.95",
  161. "Top": "50",
  162. "Bottom": "100",
  163. "H_CalculationType": "percentage",
  164. "V_CalculationType": "percentage"
  165. }
  166. },
  167. {
  168. "FieldID": 1134,
  169. "font": "Header",
  170. "control": "Header",
  171. "style": "Default_None",
  172. "Prefix": "承包单位:",
  173. "isAutoHeight": false,
  174. "area": {
  175. "Left": "32.95",
  176. "Right": "65.52",
  177. "Top": "0",
  178. "Bottom": "50",
  179. "H_CalculationType": "percentage",
  180. "V_CalculationType": "percentage"
  181. }
  182. },
  183. {
  184. "FieldID": 1140,
  185. "font": "Header",
  186. "control": "Header",
  187. "style": "Default_None",
  188. "Prefix": "监理单位:",
  189. "isAutoHeight": false,
  190. "area": {
  191. "Left": "32.95",
  192. "Right": "65.52",
  193. "Top": "50",
  194. "Bottom": "100",
  195. "H_CalculationType": "percentage",
  196. "V_CalculationType": "percentage"
  197. }
  198. },
  199. {
  200. "FieldID": 1102,
  201. "font": "Header",
  202. "control": "Header",
  203. "style": "Default_None",
  204. "Prefix": "合同号:",
  205. "isAutoHeight": false,
  206. "area": {
  207. "Left": "65.52",
  208. "Right": "85.77",
  209. "Top": "0",
  210. "Bottom": "50",
  211. "H_CalculationType": "percentage",
  212. "V_CalculationType": "percentage"
  213. }
  214. },
  215. {
  216. "FieldID": 1103,
  217. "font": "Header",
  218. "control": "Header",
  219. "style": "Default_None",
  220. "Prefix": "编 号:",
  221. "isAutoHeight": false,
  222. "area": {
  223. "Left": "65.52",
  224. "Right": "85.77",
  225. "Top": "50",
  226. "Bottom": "100",
  227. "H_CalculationType": "percentage",
  228. "V_CalculationType": "percentage"
  229. }
  230. },
  231. {
  232. "ParamID": "5010",
  233. "font": "Header",
  234. "control": "Header_Right",
  235. "style": "Default_None",
  236. "Default_Value": "第 X 页",
  237. "area": {
  238. "Left": "85.77",
  239. "Right": "92.45",
  240. "Top": "50",
  241. "Bottom": "100.00",
  242. "H_CalculationType": "percentage",
  243. "V_CalculationType": "percentage"
  244. }
  245. },
  246. {
  247. "ParamID": "5011",
  248. "font": "Header",
  249. "control": "Header",
  250. "style": "Default_None",
  251. "Default_Value": "共 X 页",
  252. "area": {
  253. "Left": "92.45",
  254. "Right": "100.00",
  255. "Top": "50",
  256. "Bottom": "100.00",
  257. "H_CalculationType": "percentage",
  258. "V_CalculationType": "percentage"
  259. }
  260. }
  261. ]
  262. },
  263. {
  264. "BandName": "FooterBand",
  265. "discrete_field_s": [
  266. {
  267. "FieldID": 12083,
  268. "font": "Content",
  269. "control": "NewContent_Left",
  270. "style": "Default_None",
  271. "isAutoHeight": false,
  272. "area": {
  273. "Left": "5",
  274. "Right": "22.5",
  275. "Top": 0,
  276. "Bottom": 100,
  277. "H_CalculationType": "percentage",
  278. "V_CalculationType": "percentage"
  279. }
  280. },
  281. {
  282. "FieldID": 12084,
  283. "font": "Content",
  284. "control": "NewContent_Left",
  285. "style": "Default_None",
  286. "isAutoHeight": false,
  287. "area": {
  288. "Left": "28",
  289. "Right": "46",
  290. "Top": 0,
  291. "Bottom": 100,
  292. "H_CalculationType": "percentage",
  293. "V_CalculationType": "percentage"
  294. }
  295. },
  296. {
  297. "FieldID": 12085,
  298. "font": "Content",
  299. "control": "NewContent_Left",
  300. "style": "Default_None",
  301. "isAutoHeight": false,
  302. "area": {
  303. "Left": "54",
  304. "Right": "71",
  305. "Top": 0,
  306. "Bottom": 100,
  307. "H_CalculationType": "percentage",
  308. "V_CalculationType": "percentage"
  309. }
  310. },
  311. {
  312. "FieldID": 12086,
  313. "font": "Content",
  314. "control": "NewContent_Left",
  315. "style": "Default_None",
  316. "isAutoHeight": false,
  317. "area": {
  318. "Left": "82",
  319. "Right": 100,
  320. "Top": 0,
  321. "Bottom": 100,
  322. "H_CalculationType": "percentage",
  323. "V_CalculationType": "percentage"
  324. }
  325. }
  326. ],
  327. "text_s": [
  328. {
  329. "Label": "承包人:",
  330. "font": "Content",
  331. "control": "Footer",
  332. "style": "Default_None",
  333. "Title": "",
  334. "area": {
  335. "Left": 0,
  336. "Right": "5",
  337. "Top": 0,
  338. "Bottom": 100,
  339. "H_CalculationType": "percentage",
  340. "V_CalculationType": "percentage"
  341. }
  342. },
  343. {
  344. "Label": "监理员:",
  345. "font": "Content",
  346. "control": "Footer",
  347. "style": "Default_None",
  348. "Title": "",
  349. "area": {
  350. "Left": "22.5",
  351. "Right": "28",
  352. "Top": 0,
  353. "Bottom": 100,
  354. "H_CalculationType": "percentage",
  355. "V_CalculationType": "percentage"
  356. }
  357. },
  358. {
  359. "Label": "监理组组长:",
  360. "font": "Content",
  361. "control": "Footer",
  362. "style": "Default_None",
  363. "Title": "",
  364. "area": {
  365. "Left": "46",
  366. "Right": "54",
  367. "Top": 0,
  368. "Bottom": 100,
  369. "H_CalculationType": "percentage",
  370. "V_CalculationType": "percentage"
  371. }
  372. },
  373. {
  374. "Label": "业主(业主代表):",
  375. "font": "Content",
  376. "control": "Footer",
  377. "style": "Default_None",
  378. "Title": "",
  379. "area": {
  380. "Left": "71",
  381. "Right": "82",
  382. "Top": 0,
  383. "Bottom": 100,
  384. "H_CalculationType": "percentage",
  385. "V_CalculationType": "percentage"
  386. }
  387. }
  388. ]
  389. }
  390. ],
  391. "流水式表_列": {
  392. "BandName": "ColumnBand",
  393. "text_s": [
  394. {
  395. "Label": "清单号",
  396. "font": "Content",
  397. "control": "Column",
  398. "style": "Default_Normal",
  399. "Title": "",
  400. "area": {
  401. "Left": 0,
  402. "Right": "5.64",
  403. "Top": 0,
  404. "Bottom": "100.00",
  405. "H_CalculationType": "percentage",
  406. "V_CalculationType": "percentage"
  407. }
  408. },
  409. {
  410. "Label": "变更内容",
  411. "font": "Content",
  412. "control": "Column",
  413. "style": "Default_Normal",
  414. "Title": "",
  415. "area": {
  416. "Left": "5.64",
  417. "Right": "21.59",
  418. "Top": 0,
  419. "Bottom": "100.00",
  420. "H_CalculationType": "percentage",
  421. "V_CalculationType": "percentage"
  422. }
  423. },
  424. {
  425. "Label": "单位",
  426. "font": "Content",
  427. "control": "Column",
  428. "style": "Default_Normal",
  429. "Title": "",
  430. "area": {
  431. "Left": "21.59",
  432. "Right": "27.22",
  433. "Top": 0,
  434. "Bottom": "100.00",
  435. "H_CalculationType": "percentage",
  436. "V_CalculationType": "percentage"
  437. }
  438. },
  439. {
  440. "Label": "合同数量",
  441. "font": "Content",
  442. "control": "Column",
  443. "style": "Default_Normal",
  444. "Title": "",
  445. "area": {
  446. "Left": "27.22",
  447. "Right": "32.95",
  448. "Top": 0,
  449. "Bottom": "100.00",
  450. "H_CalculationType": "percentage",
  451. "V_CalculationType": "percentage"
  452. }
  453. },
  454. {
  455. "Label": "单价",
  456. "font": "Content",
  457. "control": "Column",
  458. "style": "Default_Normal",
  459. "Title": "",
  460. "area": {
  461. "Left": "32.95",
  462. "Right": "38.68",
  463. "Top": 0,
  464. "Bottom": "100.00",
  465. "H_CalculationType": "percentage",
  466. "V_CalculationType": "percentage"
  467. }
  468. },
  469. {
  470. "Label": "工程量增减(+,—)",
  471. "font": "Content",
  472. "control": "Column",
  473. "style": "Default_Normal",
  474. "Title": "",
  475. "area": {
  476. "Left": "38.68",
  477. "Right": "52.15",
  478. "Top": 0,
  479. "Bottom": "62.86",
  480. "H_CalculationType": "percentage",
  481. "V_CalculationType": "percentage"
  482. }
  483. },
  484. {
  485. "Label": "到本期末完成(+,—)",
  486. "font": "Content",
  487. "control": "Column",
  488. "style": "Default_Normal",
  489. "Title": "",
  490. "area": {
  491. "Left": "52.15",
  492. "Right": "65.52",
  493. "Top": "32.86",
  494. "Bottom": "62.86",
  495. "H_CalculationType": "percentage",
  496. "V_CalculationType": "percentage"
  497. }
  498. },
  499. {
  500. "Label": "本期完成",
  501. "font": "Content",
  502. "control": "Column",
  503. "style": "Default_Normal",
  504. "Title": "",
  505. "area": {
  506. "Left": "78.99",
  507. "Right": "92.45",
  508. "Top": "32.86",
  509. "Bottom": "62.86",
  510. "H_CalculationType": "percentage",
  511. "V_CalculationType": "percentage"
  512. }
  513. },
  514. {
  515. "Label": "工程量增减金额(+,—)",
  516. "font": "Content",
  517. "control": "Column",
  518. "style": "Default_Normal",
  519. "Title": "",
  520. "area": {
  521. "Left": "52.15",
  522. "Right": "92.45",
  523. "Top": 0,
  524. "Bottom": "32.86",
  525. "H_CalculationType": "percentage",
  526. "V_CalculationType": "percentage"
  527. }
  528. },
  529. {
  530. "Label": "批复文号",
  531. "font": "Content",
  532. "control": "Column",
  533. "style": "Default_Normal",
  534. "Title": "",
  535. "area": {
  536. "Left": "92.45",
  537. "Right": "100.00",
  538. "Top": 0,
  539. "Bottom": "100.00",
  540. "H_CalculationType": "percentage",
  541. "V_CalculationType": "percentage"
  542. }
  543. },
  544. {
  545. "Label": "到上期末完成(+,—)",
  546. "font": "Content",
  547. "control": "Column",
  548. "style": "Default_Normal",
  549. "Title": "",
  550. "area": {
  551. "Left": "65.52",
  552. "Right": "78.99",
  553. "Top": "32.86",
  554. "Bottom": "62.86",
  555. "H_CalculationType": "percentage",
  556. "V_CalculationType": "percentage"
  557. }
  558. },
  559. {
  560. "Label": "本期末完成",
  561. "font": "Content",
  562. "control": "Column",
  563. "style": "Default_Normal",
  564. "Title": "",
  565. "area": {
  566. "Left": "38.68",
  567. "Right": "45.37",
  568. "Top": "62.86",
  569. "Bottom": "100.00",
  570. "H_CalculationType": "percentage",
  571. "V_CalculationType": "percentage"
  572. }
  573. },
  574. {
  575. "Label": "其中本期",
  576. "font": "Content",
  577. "control": "Column",
  578. "style": "Default_Normal",
  579. "Title": "",
  580. "area": {
  581. "Left": "45.37",
  582. "Right": "52.15",
  583. "Top": "62.86",
  584. "Bottom": "100.00",
  585. "H_CalculationType": "percentage",
  586. "V_CalculationType": "percentage"
  587. }
  588. },
  589. {
  590. "Label": "数量",
  591. "font": "Content",
  592. "control": "Column",
  593. "style": "Default_Normal",
  594. "Title": "",
  595. "area": {
  596. "Left": "52.15",
  597. "Right": "58.83",
  598. "Top": "62.86",
  599. "Bottom": "100.00",
  600. "H_CalculationType": "percentage",
  601. "V_CalculationType": "percentage"
  602. }
  603. },
  604. {
  605. "Label": "金额",
  606. "font": "Content",
  607. "control": "Column",
  608. "style": "Default_Normal",
  609. "Title": "",
  610. "area": {
  611. "Left": "58.83",
  612. "Right": "65.52",
  613. "Top": "62.86",
  614. "Bottom": "100.00",
  615. "H_CalculationType": "percentage",
  616. "V_CalculationType": "percentage"
  617. }
  618. },
  619. {
  620. "Label": "数量",
  621. "font": "Content",
  622. "control": "Column",
  623. "style": "Default_Normal",
  624. "Title": "",
  625. "area": {
  626. "Left": "65.52",
  627. "Right": "72.30",
  628. "Top": "62.86",
  629. "Bottom": "100.00",
  630. "H_CalculationType": "percentage",
  631. "V_CalculationType": "percentage"
  632. }
  633. },
  634. {
  635. "Label": "金额",
  636. "font": "Content",
  637. "control": "Column",
  638. "style": "Default_Normal",
  639. "Title": "",
  640. "area": {
  641. "Left": "72.30",
  642. "Right": "78.99",
  643. "Top": "62.86",
  644. "Bottom": "100.00",
  645. "H_CalculationType": "percentage",
  646. "V_CalculationType": "percentage"
  647. }
  648. },
  649. {
  650. "Label": "数量",
  651. "font": "Content",
  652. "control": "Column",
  653. "style": "Default_Normal",
  654. "Title": "",
  655. "area": {
  656. "Left": "78.99",
  657. "Right": "85.77",
  658. "Top": "62.86",
  659. "Bottom": "100.00",
  660. "H_CalculationType": "percentage",
  661. "V_CalculationType": "percentage"
  662. }
  663. },
  664. {
  665. "Label": "金额",
  666. "font": "Content",
  667. "control": "Column",
  668. "style": "Default_Normal",
  669. "Title": "",
  670. "area": {
  671. "Left": "85.77",
  672. "Right": "92.45",
  673. "Top": "62.86",
  674. "Bottom": "100.00",
  675. "H_CalculationType": "percentage",
  676. "V_CalculationType": "percentage"
  677. }
  678. }
  679. ]
  680. },
  681. "多列显示数量": 1,
  682. "流水式表_数据": {
  683. "BandName": "ContentBand",
  684. "CommonHeight": "0.61",
  685. "flow_field_s": [
  686. {
  687. "FieldID": 12070,
  688. "font": "Content",
  689. "control": "Column_Left",
  690. "style": "Default_Normal",
  691. "isAutoHeight": false,
  692. "area": {
  693. "Left": 0,
  694. "Right": "5.64",
  695. "Top": 0,
  696. "Bottom": "100",
  697. "H_CalculationType": "percentage",
  698. "V_CalculationType": "percentage"
  699. }
  700. },
  701. {
  702. "FieldID": 12071,
  703. "font": "Content",
  704. "control": "Column_Left",
  705. "style": "Default_Normal",
  706. "isAutoHeight": false,
  707. "area": {
  708. "Left": "5.64",
  709. "Right": "21.59",
  710. "Top": 0,
  711. "Bottom": "100",
  712. "H_CalculationType": "percentage",
  713. "V_CalculationType": "percentage"
  714. }
  715. },
  716. {
  717. "FieldID": 12072,
  718. "font": "Content",
  719. "control": "Column",
  720. "style": "Default_Normal",
  721. "isAutoHeight": false,
  722. "area": {
  723. "Left": "21.59",
  724. "Right": "27.22",
  725. "Top": 0,
  726. "Bottom": "100",
  727. "H_CalculationType": "percentage",
  728. "V_CalculationType": "percentage"
  729. }
  730. },
  731. {
  732. "FieldID": 12073,
  733. "font": "Content",
  734. "control": "Column_Right",
  735. "style": "Default_Normal",
  736. "isAutoHeight": false,
  737. "area": {
  738. "Left": "27.22",
  739. "Right": "32.95",
  740. "Top": 0,
  741. "Bottom": "100",
  742. "H_CalculationType": "percentage",
  743. "V_CalculationType": "percentage"
  744. }
  745. },
  746. {
  747. "FieldID": 12074,
  748. "font": "Content",
  749. "control": "Column_Right",
  750. "style": "Default_Normal",
  751. "isAutoHeight": false,
  752. "area": {
  753. "Left": "32.95",
  754. "Right": "38.68",
  755. "Top": 0,
  756. "Bottom": "100",
  757. "H_CalculationType": "percentage",
  758. "V_CalculationType": "percentage"
  759. }
  760. },
  761. {
  762. "FieldID": 12075,
  763. "font": "Content",
  764. "control": "Column_Right",
  765. "style": "Default_Normal",
  766. "isAutoHeight": false,
  767. "area": {
  768. "Left": "38.68",
  769. "Right": "45.37",
  770. "Top": 0,
  771. "Bottom": "100",
  772. "H_CalculationType": "percentage",
  773. "V_CalculationType": "percentage"
  774. }
  775. },
  776. {
  777. "FieldID": 12079,
  778. "font": "Content",
  779. "control": "Column_Right",
  780. "style": "Default_Normal",
  781. "isAutoHeight": false,
  782. "area": {
  783. "Left": "45.37",
  784. "Right": "52.15",
  785. "Top": 0,
  786. "Bottom": "100",
  787. "H_CalculationType": "percentage",
  788. "V_CalculationType": "percentage"
  789. }
  790. },
  791. {
  792. "FieldID": 12075,
  793. "font": "Content",
  794. "control": "Column_Right",
  795. "style": "Default_Normal",
  796. "isAutoHeight": false,
  797. "area": {
  798. "Left": "52.15",
  799. "Right": "58.83",
  800. "Top": 0,
  801. "Bottom": "100",
  802. "H_CalculationType": "percentage",
  803. "V_CalculationType": "percentage"
  804. }
  805. },
  806. {
  807. "FieldID": 12076,
  808. "font": "Content",
  809. "control": "Column_Right",
  810. "style": "Default_Normal",
  811. "isAutoHeight": false,
  812. "area": {
  813. "Left": "58.83",
  814. "Right": "65.52",
  815. "Top": 0,
  816. "Bottom": "100",
  817. "H_CalculationType": "percentage",
  818. "V_CalculationType": "percentage"
  819. }
  820. },
  821. {
  822. "FieldID": 12077,
  823. "font": "Content",
  824. "control": "Column_Right",
  825. "style": "Default_Normal",
  826. "isAutoHeight": false,
  827. "area": {
  828. "Left": "65.52",
  829. "Right": "72.30",
  830. "Top": 0,
  831. "Bottom": "100",
  832. "H_CalculationType": "percentage",
  833. "V_CalculationType": "percentage"
  834. }
  835. },
  836. {
  837. "FieldID": 12078,
  838. "font": "Content",
  839. "control": "Column_Right",
  840. "style": "Default_Normal",
  841. "isAutoHeight": false,
  842. "area": {
  843. "Left": "72.3",
  844. "Right": "78.99",
  845. "Top": 0,
  846. "Bottom": "100",
  847. "H_CalculationType": "percentage",
  848. "V_CalculationType": "percentage"
  849. }
  850. },
  851. {
  852. "FieldID": 12079,
  853. "font": "Content",
  854. "control": "Column_Right",
  855. "style": "Default_Normal",
  856. "isAutoHeight": false,
  857. "area": {
  858. "Left": "78.99",
  859. "Right": "85.77",
  860. "Top": 0,
  861. "Bottom": "100",
  862. "H_CalculationType": "percentage",
  863. "V_CalculationType": "percentage"
  864. }
  865. },
  866. {
  867. "FieldID": 12080,
  868. "font": "Content",
  869. "control": "Column_Right",
  870. "style": "Default_Normal",
  871. "isAutoHeight": false,
  872. "area": {
  873. "Left": "85.77",
  874. "Right": "92.45",
  875. "Top": 0,
  876. "Bottom": "100",
  877. "H_CalculationType": "percentage",
  878. "V_CalculationType": "percentage"
  879. }
  880. },
  881. {
  882. "FieldID": 12081,
  883. "font": "Content",
  884. "control": "Column_Left",
  885. "style": "Default_Normal",
  886. "isAutoHeight": true,
  887. "area": {
  888. "Left": "92.45",
  889. "Right": "100.00",
  890. "Top": 0,
  891. "Bottom": "100",
  892. "H_CalculationType": "percentage",
  893. "V_CalculationType": "percentage"
  894. }
  895. }
  896. ]
  897. },
  898. "流水式表_分组信息": {
  899. "group_field_s": [
  900. {
  901. "FieldID": 12082
  902. }
  903. ],
  904. "sum_field_s": [
  905. {
  906. "FieldID": 12076,
  907. "SumKey": "新截止本期变更金额"
  908. },
  909. {
  910. "FieldID": 12078,
  911. "SumKey": "新截止上期变更金额"
  912. },
  913. {
  914. "FieldID": 12080,
  915. "SumKey": "新本期变更金额"
  916. }
  917. ],
  918. "group_lines": [
  919. {
  920. "SumKey_S": [
  921. {
  922. "FieldID": 12076,
  923. "font": "Content",
  924. "control": "Currency",
  925. "style": "Default_Normal",
  926. "isAutoHeight": false,
  927. "area": {
  928. "Left": "58.83",
  929. "Right": "65.52",
  930. "Top": 0,
  931. "Bottom": 100,
  932. "H_CalculationType": "percentage",
  933. "V_CalculationType": "percentage"
  934. },
  935. "SumKey": "新截止本期变更金额"
  936. },
  937. {
  938. "FieldID": 12078,
  939. "font": "Content",
  940. "control": "Currency",
  941. "style": "Default_Normal",
  942. "isAutoHeight": false,
  943. "area": {
  944. "Left": "72.3",
  945. "Right": "78.99",
  946. "Top": 0,
  947. "Bottom": 100,
  948. "H_CalculationType": "percentage",
  949. "V_CalculationType": "percentage"
  950. },
  951. "SumKey": "新截止上期变更金额"
  952. },
  953. {
  954. "FieldID": 12080,
  955. "font": "Content",
  956. "control": "Currency",
  957. "style": "Default_Normal",
  958. "isAutoHeight": false,
  959. "area": {
  960. "Left": "85.77",
  961. "Right": "92.45",
  962. "Top": 0,
  963. "Bottom": 100,
  964. "H_CalculationType": "percentage",
  965. "V_CalculationType": "percentage"
  966. },
  967. "SumKey": "新本期变更金额"
  968. }
  969. ],
  970. "text_s": [
  971. {
  972. "Label": "小计",
  973. "font": "Content",
  974. "control": "NewContent_Center",
  975. "style": "Default_Normal",
  976. "Title": "",
  977. "area": {
  978. "Left": "5.64",
  979. "Right": "21.59",
  980. "Top": 0,
  981. "Bottom": 100,
  982. "H_CalculationType": "percentage",
  983. "V_CalculationType": "percentage"
  984. }
  985. },
  986. {
  987. "Label": "",
  988. "font": "Content",
  989. "control": "Default",
  990. "style": "Default_Normal",
  991. "Title": "",
  992. "area": {
  993. "Left": "0",
  994. "Right": "5.64",
  995. "Top": 0,
  996. "Bottom": 100,
  997. "H_CalculationType": "percentage",
  998. "V_CalculationType": "percentage"
  999. }
  1000. },
  1001. {
  1002. "Label": "",
  1003. "font": "Content",
  1004. "control": "Default",
  1005. "style": "Default_Normal",
  1006. "Title": "",
  1007. "area": {
  1008. "Left": "21.59",
  1009. "Right": "27.22",
  1010. "Top": 0,
  1011. "Bottom": 100,
  1012. "H_CalculationType": "percentage",
  1013. "V_CalculationType": "percentage"
  1014. }
  1015. },
  1016. {
  1017. "Label": "",
  1018. "font": "Content",
  1019. "control": "Default",
  1020. "style": "Default_Normal",
  1021. "Title": "",
  1022. "area": {
  1023. "Left": "27.22",
  1024. "Right": "32.95",
  1025. "Top": 0,
  1026. "Bottom": 100,
  1027. "H_CalculationType": "percentage",
  1028. "V_CalculationType": "percentage"
  1029. }
  1030. },
  1031. {
  1032. "Label": "",
  1033. "font": "Content",
  1034. "control": "Default",
  1035. "style": "Default_Normal",
  1036. "Title": "",
  1037. "area": {
  1038. "Left": "32.95",
  1039. "Right": "38.68",
  1040. "Top": 0,
  1041. "Bottom": 100,
  1042. "H_CalculationType": "percentage",
  1043. "V_CalculationType": "percentage"
  1044. }
  1045. },
  1046. {
  1047. "Label": "",
  1048. "font": "Content",
  1049. "control": "Default",
  1050. "style": "Default_Normal",
  1051. "Title": "",
  1052. "area": {
  1053. "Left": "38.68",
  1054. "Right": "45.37",
  1055. "Top": 0,
  1056. "Bottom": 100,
  1057. "H_CalculationType": "percentage",
  1058. "V_CalculationType": "percentage"
  1059. }
  1060. },
  1061. {
  1062. "Label": "",
  1063. "font": "Content",
  1064. "control": "Default",
  1065. "style": "Default_Normal",
  1066. "Title": "",
  1067. "area": {
  1068. "Left": "45.37",
  1069. "Right": "52.15",
  1070. "Top": 0,
  1071. "Bottom": 100,
  1072. "H_CalculationType": "percentage",
  1073. "V_CalculationType": "percentage"
  1074. }
  1075. },
  1076. {
  1077. "Label": "",
  1078. "font": "Content",
  1079. "control": "Default",
  1080. "style": "Default_Normal",
  1081. "Title": "",
  1082. "area": {
  1083. "Left": "65.52",
  1084. "Right": "72.3",
  1085. "Top": 0,
  1086. "Bottom": 100,
  1087. "H_CalculationType": "percentage",
  1088. "V_CalculationType": "percentage"
  1089. }
  1090. },
  1091. {
  1092. "Label": "",
  1093. "font": "Content",
  1094. "control": "Default",
  1095. "style": "Default_Normal",
  1096. "Title": "",
  1097. "area": {
  1098. "Left": "78.99",
  1099. "Right": "85.77",
  1100. "Top": 0,
  1101. "Bottom": 100,
  1102. "H_CalculationType": "percentage",
  1103. "V_CalculationType": "percentage"
  1104. }
  1105. },
  1106. {
  1107. "Label": "",
  1108. "font": "Content",
  1109. "control": "Default",
  1110. "style": "Default_Normal",
  1111. "Title": "",
  1112. "area": {
  1113. "Left": "85.77",
  1114. "Right": "92.45",
  1115. "Top": 0,
  1116. "Bottom": 100,
  1117. "H_CalculationType": "percentage",
  1118. "V_CalculationType": "percentage"
  1119. }
  1120. },
  1121. {
  1122. "Label": "",
  1123. "font": "Content",
  1124. "control": "Default",
  1125. "style": "Default_Normal",
  1126. "Title": "",
  1127. "area": {
  1128. "Left": "92.45",
  1129. "Right": 100,
  1130. "Top": 0,
  1131. "Bottom": 100,
  1132. "H_CalculationType": "percentage",
  1133. "V_CalculationType": "percentage"
  1134. }
  1135. }
  1136. ]
  1137. }
  1138. ]
  1139. },
  1140. "流水式表_段统计信息": {
  1141. "BandName": "",
  1142. "sum_field_s": [],
  1143. "text_s": []
  1144. },
  1145. "流水式表_页统计信息": {
  1146. "BandName": "",
  1147. "sum_field_s": [],
  1148. "text_s": []
  1149. }
  1150. },
  1151. "离散参数_集合": [
  1152. {
  1153. "ID": "5001",
  1154. "Name": "打印时间",
  1155. "DataType": "String",
  1156. "Default_Value": ""
  1157. },
  1158. {
  1159. "ID": "5010",
  1160. "Name": "当前页",
  1161. "DataType": "String",
  1162. "Default_Value": "第 X 页"
  1163. },
  1164. {
  1165. "ID": "5011",
  1166. "Name": "总页数",
  1167. "DataType": "String",
  1168. "Default_Value": "共 X 页"
  1169. }
  1170. ],
  1171. "指标_数据_映射": {
  1172. "离散指标_集合": [
  1173. {
  1174. "ID": 1101,
  1175. "Name": "标段_项目名称",
  1176. "DataType": "string",
  1177. "TableName": "tender_info",
  1178. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.buildName')",
  1179. "descr": "",
  1180. "Title": "ID: 1101"
  1181. },
  1182. {
  1183. "ID": 1134,
  1184. "Name": "标段_标段清单_承包单位1_单位名称",
  1185. "DataType": "string",
  1186. "TableName": "tender_info",
  1187. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.contract1.company')",
  1188. "descr": "",
  1189. "Title": "ID: 1134"
  1190. },
  1191. {
  1192. "ID": 1140,
  1193. "Name": "标段_标段清单_监理单位1_单位名称",
  1194. "DataType": "string",
  1195. "TableName": "tender_info",
  1196. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.supervision1.company')",
  1197. "descr": "",
  1198. "Title": "ID: 1140"
  1199. },
  1200. {
  1201. "ID": 1312,
  1202. "Name": "期计量信息_截至日期",
  1203. "DataType": "string",
  1204. "TableName": "stage",
  1205. "mapExpression": "$PROJECT.REPORT.getSplitProperty('stage', 'period', ' ~ ', 1, '')",
  1206. "descr": "",
  1207. "Title": "ID: 1312"
  1208. },
  1209. {
  1210. "ID": 1102,
  1211. "Name": "标段_合同号",
  1212. "DataType": "string",
  1213. "TableName": "tender_info",
  1214. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealCode')",
  1215. "descr": "",
  1216. "Title": "ID: 1102"
  1217. },
  1218. {
  1219. "ID": 1103,
  1220. "Name": "标段_编号",
  1221. "DataType": "string",
  1222. "TableName": "tender_info",
  1223. "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.dealName')",
  1224. "descr": "",
  1225. "Title": "ID: 1103"
  1226. },
  1227. {
  1228. "ID": 1103,
  1229. "Name": "标段_合同名称",
  1230. "DataType": "string",
  1231. "TableName": "tender_info",
  1232. "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealName\")",
  1233. "descr": "",
  1234. "Title": "ID: 1103"
  1235. }
  1236. ],
  1237. "主数据指标_集合": [],
  1238. "从数据指标_集合": [
  1239. {
  1240. "ID": 2510,
  1241. "Name": "清单编号(b_code)",
  1242. "DataType": "string",
  1243. "TableName": "mem_stage_bills",
  1244. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'b_code')",
  1245. "descr": "",
  1246. "Title": "ID: 2510"
  1247. },
  1248. {
  1249. "ID": 2511,
  1250. "Name": "名称(name)",
  1251. "DataType": "string",
  1252. "TableName": "mem_stage_bills",
  1253. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'name')",
  1254. "descr": "",
  1255. "Title": "ID: 2511"
  1256. },
  1257. {
  1258. "ID": 2512,
  1259. "Name": "单位(unit)",
  1260. "DataType": "string",
  1261. "TableName": "mem_stage_bills",
  1262. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit')",
  1263. "descr": "",
  1264. "Title": "ID: 2512"
  1265. },
  1266. {
  1267. "ID": 2513,
  1268. "Name": "单价(unit_price)",
  1269. "DataType": "currency",
  1270. "TableName": "mem_stage_bills",
  1271. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit_price')",
  1272. "descr": "",
  1273. "Title": "ID: 2513"
  1274. },
  1275. {
  1276. "ID": 2508,
  1277. "Name": "树结构-是否子项(is_leaf)",
  1278. "DataType": "int",
  1279. "TableName": "mem_stage_bills",
  1280. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')",
  1281. "descr": "",
  1282. "Title": "ID: 2508"
  1283. },
  1284. {
  1285. "ID": 2552,
  1286. "Name": "章节编号(chapter)",
  1287. "DataType": "string",
  1288. "TableName": "mem_stage_bills",
  1289. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'chapter')",
  1290. "descr": "",
  1291. "Title": "ID: 2552"
  1292. },
  1293. {
  1294. "ID": 2551,
  1295. "Name": "本期-数量变更-变更令(qc_bgl_code)",
  1296. "DataType": "string",
  1297. "TableName": "mem_stage_bills",
  1298. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'qc_bgl_code')",
  1299. "descr": "",
  1300. "Title": "ID: 2551"
  1301. },
  1302. {
  1303. "ID": 2532,
  1304. "Name": "本期-数量变更-数量(qc_qty)",
  1305. "DataType": "currency",
  1306. "TableName": "mem_stage_bills",
  1307. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'qc_qty')",
  1308. "descr": "",
  1309. "Title": "ID: 2532"
  1310. },
  1311. {
  1312. "ID": 2533,
  1313. "Name": "本期-数量变更-金额(qc_tp)",
  1314. "DataType": "currency",
  1315. "TableName": "mem_stage_bills",
  1316. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'qc_tp')",
  1317. "descr": "",
  1318. "Title": "ID: 2533"
  1319. },
  1320. {
  1321. "ID": 2539,
  1322. "Name": "截止上期-数量变更-数量(pre_qc_qty)",
  1323. "DataType": "currency",
  1324. "TableName": "mem_stage_bills",
  1325. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_qc_qty')",
  1326. "descr": "",
  1327. "Title": "ID: 2539"
  1328. },
  1329. {
  1330. "ID": 2540,
  1331. "Name": "截止上期-数量变更-金额(pre_qc_tp)",
  1332. "DataType": "currency",
  1333. "TableName": "mem_stage_bills",
  1334. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_qc_tp')",
  1335. "descr": "",
  1336. "Title": "ID: 2540"
  1337. },
  1338. {
  1339. "ID": 2545,
  1340. "Name": "截止本期-数量变更-数量(end_qc_qty)",
  1341. "DataType": "currency",
  1342. "TableName": "mem_stage_bills",
  1343. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_qc_qty')",
  1344. "descr": "",
  1345. "Title": "ID: 2545"
  1346. },
  1347. {
  1348. "ID": 2546,
  1349. "Name": "截止本期-数量变更-金额(end_qc_tp)",
  1350. "DataType": "currency",
  1351. "TableName": "mem_stage_bills",
  1352. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_qc_tp')",
  1353. "descr": "",
  1354. "Title": "ID: 2546"
  1355. },
  1356. {
  1357. "ID": 1600,
  1358. "Name": "签约清单信息_清单编号(code)",
  1359. "DataType": "string",
  1360. "TableName": "deal_bills",
  1361. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"code\")",
  1362. "descr": "",
  1363. "Title": "ID: 1600"
  1364. },
  1365. {
  1366. "ID": 1601,
  1367. "Name": "签约清单信息_名称(name)",
  1368. "DataType": "string",
  1369. "TableName": "deal_bills",
  1370. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"name\")",
  1371. "descr": "",
  1372. "Title": "ID: 1601"
  1373. },
  1374. {
  1375. "ID": 1602,
  1376. "Name": "签约清单信息_单位(unit)",
  1377. "DataType": "string",
  1378. "TableName": "deal_bills",
  1379. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"unit\")",
  1380. "descr": "",
  1381. "Title": "ID: 1602"
  1382. },
  1383. {
  1384. "ID": 1603,
  1385. "Name": "签约清单信息_数量(quanitty)",
  1386. "DataType": "number",
  1387. "TableName": "deal_bills",
  1388. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"quantity\")",
  1389. "descr": "",
  1390. "Title": "ID: 1603",
  1391. "Precision": {
  1392. "type": "flexible",
  1393. "flexibleRefFieldID": 1602,
  1394. "flexibleMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"precision\")"
  1395. }
  1396. },
  1397. {
  1398. "ID": 1604,
  1399. "Name": "签约清单信息_单价(unit_price)",
  1400. "DataType": "currency",
  1401. "TableName": "deal_bills",
  1402. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"unit_price\")",
  1403. "descr": "",
  1404. "Title": "ID: 1604",
  1405. "Precision": {
  1406. "type": "fixed",
  1407. "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.up\")"
  1408. }
  1409. },
  1410. {
  1411. "ID": 1605,
  1412. "Name": "签约清单信息_合价(total_price)",
  1413. "DataType": "currency",
  1414. "TableName": "deal_bills",
  1415. "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"total_price\")",
  1416. "descr": "",
  1417. "Title": "ID: 1605",
  1418. "Precision": {
  1419. "type": "fixed",
  1420. "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")"
  1421. }
  1422. },
  1423. {
  1424. "ID": 2553,
  1425. "Name": "预留扩展字段_1(ex_value1)",
  1426. "DataType": "string",
  1427. "TableName": "mem_stage_bills",
  1428. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ex_value1')",
  1429. "descr": "",
  1430. "Title": "ID: 2553"
  1431. },
  1432. {
  1433. "ID": 2554,
  1434. "Name": "预留扩展字段_2(ex_value2)",
  1435. "DataType": "string",
  1436. "TableName": "mem_stage_bills",
  1437. "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ex_value2')",
  1438. "descr": "",
  1439. "Title": "ID: 2554"
  1440. }
  1441. ],
  1442. "主数据指标_拓展集合": [],
  1443. "从数据指标_拓展集合": []
  1444. },
  1445. "映射数据预处理": [
  1446. {
  1447. "预处理类型": "指定方式",
  1448. "映射数据对象": "",
  1449. "方式Key": "gatherGcl",
  1450. "hint": "请使用mem_stage_bills下指标,注意事项:\n1. 以下字段,不管报表是否实际使用,均应添加至指标映射,且在此处应勾选(不要求顺序):\n 清单编号(b_code), 名称(name), 单位(unit), 单价(unit_price), 树结构-是否子项(is_leaf)\n2. 汇总后,以下字段,均会失效, 请勿使用:\n 台账ID(id), 树结构-ID(ledger_id), 树结构父项-ID(ledger_pid),\n 树结构-层级(level), 树结构-同层排序(order), 树结构-完整路径(full_path),\n 图册号(drawing_code), 备注(memo), 节点类型(node_type), 总额计量(is_tp)\n3. 如需汇总\"未计入清单章节项\",请勾选\"章节编号(chapter)\"字段\n",
  1451. "fields": [
  1452. {
  1453. "Name": "清单编号(b_code)",
  1454. "FieldID": 2510
  1455. },
  1456. {
  1457. "Name": "名称(name)",
  1458. "FieldID": 2511
  1459. },
  1460. {
  1461. "Name": "单位(unit)",
  1462. "FieldID": 2512
  1463. },
  1464. {
  1465. "Name": "单价(unit_price)",
  1466. "FieldID": 2513
  1467. },
  1468. {
  1469. "Name": "树结构-是否子项(is_leaf)",
  1470. "FieldID": 2508
  1471. }
  1472. ],
  1473. "自定义设置": ""
  1474. },
  1475. {
  1476. "预处理类型": "指定方式",
  1477. "映射数据对象": "",
  1478. "方式Key": "join",
  1479. "hint": "用于处理类似于关联签约清单的情况,会改变主表的数据",
  1480. "fields": [],
  1481. "自定义设置": "{\n\t\"main\": \"mem_stage_bills\",\n\t\"sub\": \"deal_bills\",\n\t\"keyFields\": [\n\t\t{\n\t\t\t\"main\": \"b_code\",\n\t\t\t\"sub\": \"code\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"name\",\n\t\t\t\"sub\": \"name\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"unit\",\n\t\t\t\"sub\": \"unit\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"unit_price\",\n\t\t\t\"sub\": \"unit_price\",\n\t\t\t\"type\": \"number\"\n\t\t}\n\t],\n\t\"importFields\": [\n\t\t{\n\t\t\t\"main\": \"ex_value1\",\n\t\t\t\"sub\": \"quantity\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"ex_value2\",\n\t\t\t\"sub\": \"total_price\"\n\t\t}\n\t],\n\t\"joinType\": \"outer\"\n}"
  1482. },
  1483. {
  1484. "预处理类型": "指定方式",
  1485. "映射数据对象": "",
  1486. "方式Key": "sortGcl",
  1487. "hint": "只对一张表,进行工程量清单排序,排序哪张表,根据勾选的清单编号字段决定:\ne.g.1 要对mem_stage_bills排序,需要勾选mem_stage_bills下的\"清单编号(b_code)\"字段\ne.g.2 要对mem_stage_im_zl排序,需要勾选mem_stage_im_zl下的\"中间计量总量信息_编号(code)\"字段\n特别的,如有\"未计入清单章节项\": \n 1. 默认\"未计入清单章节项\"排列在最后\n 2. 如须\"未计入清单章节项\"排在100章之后,请在清单编号字段后,依次勾选\"章节编号(chapter)\", \"名称(name)\"\n",
  1488. "fields": [
  1489. {
  1490. "Name": "清单编号(b_code)",
  1491. "FieldID": 2510
  1492. }
  1493. ],
  1494. "自定义设置": ""
  1495. }
  1496. ],
  1497. "无映射离散指标_集合": [
  1498. {
  1499. "ID": 12070,
  1500. "Name": "新编号",
  1501. "DataType": "string"
  1502. },
  1503. {
  1504. "ID": 12071,
  1505. "Name": "新名称",
  1506. "DataType": "string"
  1507. },
  1508. {
  1509. "ID": 12072,
  1510. "Name": "新单位",
  1511. "DataType": "string"
  1512. },
  1513. {
  1514. "ID": 12073,
  1515. "Name": "新签约清单数量",
  1516. "DataType": "string"
  1517. },
  1518. {
  1519. "ID": 12074,
  1520. "Name": "新单价",
  1521. "DataType": "string"
  1522. },
  1523. {
  1524. "ID": 12075,
  1525. "Name": "新截止本期变更数量",
  1526. "DataType": "string"
  1527. },
  1528. {
  1529. "ID": 12076,
  1530. "Name": "新截止本期变更金额",
  1531. "DataType": "string"
  1532. },
  1533. {
  1534. "ID": 12077,
  1535. "Name": "新截止上期变更数量",
  1536. "DataType": "string"
  1537. },
  1538. {
  1539. "ID": 12078,
  1540. "Name": "新截止上期变更金额",
  1541. "DataType": "string"
  1542. },
  1543. {
  1544. "ID": 12079,
  1545. "Name": "新本期变更数量",
  1546. "DataType": "string"
  1547. },
  1548. {
  1549. "ID": 12080,
  1550. "Name": "新本期变更金额",
  1551. "DataType": "string"
  1552. },
  1553. {
  1554. "ID": 12081,
  1555. "Name": "新本期变更令号",
  1556. "DataType": "string"
  1557. },
  1558. {
  1559. "ID": 12082,
  1560. "Name": "新章节编号",
  1561. "DataType": "string"
  1562. }
  1563. ],
  1564. "动态日期离散参数_集合": [],
  1565. "电子签名离散指标_集合": [
  1566. {
  1567. "ID": 12083,
  1568. "Name": "承包人",
  1569. "DataType": "string"
  1570. },
  1571. {
  1572. "ID": 12084,
  1573. "Name": "监理员",
  1574. "DataType": "string"
  1575. },
  1576. {
  1577. "ID": 12085,
  1578. "Name": "监理组组长",
  1579. "DataType": "string"
  1580. },
  1581. {
  1582. "ID": 12086,
  1583. "Name": "业主(业主代表)",
  1584. "DataType": "string"
  1585. }
  1586. ]
  1587. }