jpc_ex.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386
  1. let JV = require('./jpc_value_define');
  2. let JpcBand = require('./jpc_band');
  3. let JpcFlowTab = require('./jpc_flow_tab');
  4. let JpcBillTab = require('./jpc_bill_tab');
  5. let JpcCrossTab = require('./jpc_cross_tab');
  6. let JpcField = require('./jpc_field');
  7. let JpcParam = require('./jpc_param');
  8. let JpcFunc = require('./jpc_function');
  9. let JpcEvent = require('./jpc_event');
  10. let JpcData = require('./jpc_data');
  11. let JpcCommonHelper = require('./helper/jpc_helper_common');
  12. let $JE = require('./jpc_rte'); //Important: for self-define function execution purpose
  13. let JpcExSrv = function(){};
  14. JpcExSrv.prototype.createNew = function(){
  15. function private_buildDftItems(rptTpl, dftCollection, propArray, nodeName) {
  16. let rst = {};
  17. if (dftCollection) {
  18. for (let i = 0; i < dftCollection.length; i++) {
  19. let item = {};
  20. for (let j = 0; j < propArray.length; j++) {
  21. item[propArray[j]] = dftCollection[i][propArray[j]];
  22. }
  23. rst[dftCollection[i][JV.PROP_ID]] = item;
  24. }
  25. if (rptTpl && rptTpl[nodeName] && rptTpl[nodeName].length > 0) {
  26. for (let i = 0; i < rptTpl[nodeName].length; i++) {
  27. let rptDftItem = rptTpl[nodeName][i];
  28. if (rst[rptDftItem[JV.PROP_ID]] === undefined) {
  29. let item = {};
  30. for (let j = 0; j < propArray.length; j++) {
  31. item[propArray[j]] = rptDftItem[propArray[j]];
  32. }
  33. rst[rptDftItem[JV.PROP_ID]] = item;
  34. }
  35. }
  36. }
  37. }
  38. return rst;
  39. }
  40. function private_buildDftControls(rptTpl, dftControlCollection) {
  41. return private_buildDftItems(rptTpl,dftControlCollection, JV.CONTROL_PROPS, JV.NODE_CONTROL_COLLECTION);
  42. }
  43. function private_buildDftFonts(rptTpl, dftFontCollection) {
  44. return private_buildDftItems(rptTpl,dftFontCollection, JV.FONT_PROPS, JV.NODE_FONT_COLLECTION);
  45. }
  46. function private_buildDftStyles(rptTpl, dftStyleCollection) {
  47. let rst = {};
  48. function private_CopyBorder(destItem, srcItem) {
  49. destItem[JV.PROP_LINE_WEIGHT] = srcItem[JV.PROP_LINE_WEIGHT];
  50. destItem[JV.PROP_DASH_STYLE] = srcItem[JV.PROP_DASH_STYLE];
  51. destItem[JV.PROP_COLOR] = srcItem[JV.PROP_COLOR];
  52. }
  53. if (dftStyleCollection) {
  54. for (let i = 0; i < dftStyleCollection.length; i++) {
  55. let item = {};
  56. if (dftStyleCollection[i][JV.PROP_BORDER_STYLE] && dftStyleCollection[i][JV.PROP_BORDER_STYLE].length > 0) {
  57. for (let j = 0; j < dftStyleCollection[i][JV.PROP_BORDER_STYLE].length; j++) {
  58. let borderItem = {};
  59. private_CopyBorder(borderItem, dftStyleCollection[i][JV.PROP_BORDER_STYLE][j]);
  60. item[dftStyleCollection[i][JV.PROP_BORDER_STYLE][j][JV.PROP_POSITION]] = borderItem;
  61. }
  62. }
  63. rst[dftStyleCollection[i][JV.PROP_ID]] = item;
  64. }
  65. if (rptTpl && rptTpl[JV.NODE_STYLE_COLLECTION] && rptTpl[JV.NODE_STYLE_COLLECTION].length > 0) {
  66. for (let i = 0; i < rptTpl[JV.NODE_STYLE_COLLECTION].length; i++) {
  67. let rptDftItem = rptTpl[JV.NODE_STYLE_COLLECTION][i];
  68. if (rst[rptDftItem[JV.PROP_ID]] === undefined) {
  69. if (rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Top') > 0) {
  70. let key = rptDftItem[JV.PROP_ID].substr(0, rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Top'));
  71. if (rst[key]) {
  72. let item = {};
  73. if (rst[key][JV.PROP_LEFT]) {
  74. item[JV.PROP_LEFT] = {};
  75. private_CopyBorder(item[JV.PROP_LEFT], rst[key][JV.PROP_LEFT]);
  76. }
  77. if (rst[key][JV.PROP_RIGHT]) {
  78. item[JV.PROP_RIGHT] = {};
  79. private_CopyBorder(item[JV.PROP_RIGHT], rst[key][JV.PROP_RIGHT]);
  80. }
  81. if (rst[key][JV.PROP_TOP]) {
  82. item[JV.PROP_TOP] = {};
  83. private_CopyBorder(item[JV.PROP_TOP], rst[key][JV.PROP_TOP]);
  84. }
  85. rst[rptDftItem[JV.PROP_ID]] = item;
  86. }
  87. } else if (rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Middle') > 0) {
  88. let key = rptDftItem[JV.PROP_ID].substr(0, rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Middle'));
  89. if (rst[key]) {
  90. let item = {};
  91. if (rst[key][JV.PROP_LEFT]) {
  92. item[JV.PROP_LEFT] = {};
  93. private_CopyBorder(item[JV.PROP_LEFT], rst[key][JV.PROP_LEFT]);
  94. }
  95. if (rst[key][JV.PROP_RIGHT]) {
  96. item[JV.PROP_RIGHT] = {};
  97. private_CopyBorder(item[JV.PROP_RIGHT], rst[key][JV.PROP_RIGHT]);
  98. }
  99. rst[rptDftItem[JV.PROP_ID]] = item;
  100. }
  101. } else if (rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Bottom') > 0) {
  102. let key = rptDftItem[JV.PROP_ID].substr(0, rptDftItem[JV.PROP_ID].indexOf('_AutoHeightMerge_Bottom'));
  103. if (rst[key]) {
  104. let item = {};
  105. if (rst[key][JV.PROP_LEFT]) {
  106. item[JV.PROP_LEFT] = {};
  107. private_CopyBorder(item[JV.PROP_LEFT], rst[key][JV.PROP_LEFT]);
  108. }
  109. if (rst[key][JV.PROP_RIGHT]) {
  110. item[JV.PROP_RIGHT] = {};
  111. private_CopyBorder(item[JV.PROP_RIGHT], rst[key][JV.PROP_RIGHT]);
  112. }
  113. if (rst[key][JV.PROP_BOTTOM]) {
  114. item[JV.PROP_BOTTOM] = {};
  115. private_CopyBorder(item[JV.PROP_BOTTOM], rst[key][JV.PROP_BOTTOM]);
  116. }
  117. rst[rptDftItem[JV.PROP_ID]] = item;
  118. }
  119. } else {
  120. let item = {};
  121. for (let j = 0; j < rptDftItem[JV.PROP_BORDER_STYLE].length; j++) {
  122. let borderItem = {};
  123. private_CopyBorder(borderItem, rptDftItem[JV.PROP_BORDER_STYLE][j]);
  124. item[rptDftItem[JV.PROP_BORDER_STYLE][j][JV.PROP_POSITION]] = borderItem;
  125. }
  126. rst[rptDftItem[JV.PROP_ID]] = item;
  127. }
  128. }
  129. }
  130. }
  131. }
  132. return rst;
  133. }
  134. let JpcResult = {};
  135. //JpcResult.report_title
  136. JpcResult.initialize = function(rptTpl) {
  137. let me = this;
  138. if (rptTpl[JV.NODE_FLOW_INFO]) {
  139. me.flowTab = JpcFlowTab.createNew();
  140. me.flowTab.initialize(false);
  141. me.isFollowMode = false;
  142. }
  143. if (rptTpl[JV.NODE_FLOW_INFO_EX]) {
  144. me.flowTabEx = JpcFlowTab.createNew();
  145. me.flowTabEx.initialize(true);
  146. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.PROP_FLOW_EX_DISPLAY_MODE] === JV.DISPLAY_MODE_FOLLOW) {
  147. me.isFollowMode = true;
  148. }
  149. }
  150. if (rptTpl[JV.NODE_BILL_INFO]) {
  151. me.billTab = JpcBillTab.createNew();
  152. me.billTab.initialize();
  153. }
  154. //let dt1 = new Date();
  155. if (rptTpl[JV.NODE_CROSS_INFO]) {
  156. me.crossTab = JpcCrossTab.createNew();
  157. me.crossTab.initialize();
  158. }
  159. me.totalPages = 0;
  160. me.exTotalPages = 0;
  161. me.runTimePageData = {};
  162. me.fields = JpcField.createNew(rptTpl);
  163. me.params = JpcParam.createNew(rptTpl);
  164. me.formulas = JpcFunc.createNew(rptTpl);
  165. me.events = JpcEvent.createNew(rptTpl);
  166. };
  167. JpcResult.analyzeData = function(rptTpl, dataObj, defProperties, option, outputType) {
  168. let me = this, dftPagingOption = option||JV.PAGING_OPTION_NORMAL;
  169. //1. data object
  170. let dataHelper = JpcData.createNew();
  171. me.executeFormulas(JV.RUN_TYPE_BEFORE_ANALYZING, rptTpl, dataObj, me); //在分析前运行,主要是增加灵活性,比如:重新编排数据的主从关系
  172. if (me.crossTab) {
  173. me.executeFormulas(JV.RUN_TYPE_BEFORE_PAGING, rptTpl, dataObj, me);
  174. dataHelper.analyzeData(rptTpl, dataObj);
  175. me.crossTab.sorting(rptTpl, dataObj, dataHelper.dataSeq.slice(0), me);
  176. } else {
  177. dataHelper.analyzeData(rptTpl, dataObj);
  178. //2. tab object
  179. //pre-condition: the data should be sorted in SQL/NoSQL level!
  180. //let dt1 = new Date();
  181. if (me.flowTab) {
  182. me.flowTab.sorting(rptTpl, dataObj, dataHelper.dataSeq.slice(0), me);
  183. if (me.flowTabEx) {
  184. me.flowTabEx.sorting(rptTpl, dataObj, dataHelper.exDataSeq.slice(0), me);
  185. }
  186. }
  187. if (me.billTab) {
  188. me.billTab.sorting(rptTpl, dataObj, dataHelper.dataSeq.slice(0), me);
  189. }
  190. //let dt2 = new Date();
  191. //alert(dt2 - dt1);
  192. //3. formulas
  193. me.executeFormulas(JV.RUN_TYPE_BEFORE_PAGING, rptTpl, dataObj, me);
  194. }
  195. //4. paging
  196. me.paging(rptTpl, dataObj, defProperties, dftPagingOption, outputType);
  197. //alert('analyzeData was completed!');
  198. //for garbage collection:
  199. dataHelper = null;
  200. };
  201. JpcResult.paging = function(rptTpl, dataObj, defProperties, option, outputType) {
  202. let me = this, dftPagingOption = option||JV.PAGING_OPTION_NORMAL;
  203. if (me.flowTab) {
  204. if (me.isFollowMode) {
  205. me.totalPages = me.flowTab.preSetupPages(rptTpl, dataObj, defProperties, dftPagingOption, me, me.flowTabEx, outputType);
  206. } else {
  207. me.totalPages = me.flowTab.preSetupPages(rptTpl, dataObj, defProperties, dftPagingOption, me, null, outputType);
  208. if (me.flowTabEx) {
  209. me.exTotalPages = me.flowTabEx.preSetupPages(rptTpl, dataObj, defProperties, dftPagingOption, me, null, outputType);
  210. //console.log('ad-hoc flow pages: ' + me.exTotalPages);
  211. }
  212. me.totalPages += me.exTotalPages;
  213. }
  214. } else if (me.crossTab) {
  215. //me.totalPages = me.crossTab.preSetupPages(rptTpl, defProperties, dftPagingOption);
  216. me.totalPages = me.crossTab.preSetupPages(rptTpl, defProperties, JV.PAGING_OPTION_NORMAL); //infinity对交叉表来说无意义
  217. } else if (me.billTab) {
  218. me.totalPages = me.billTab.paging(rptTpl, dataObj);
  219. }
  220. };
  221. JpcResult.executeFormulas = function(runType, $CURRENT_TEMPLATE, $CURRENT_DATA, $CURRENT_RPT) {
  222. let execFmlMe = this;
  223. for (let execFmlIdx = 0; execFmlIdx < execFmlMe.formulas.length; execFmlIdx++) {
  224. //remark: 搞这么复杂的变量名是为了防止与表达式起冲突(如循环变量i,j,k,容易造成变量冲突且不容易看出问题)
  225. if (execFmlMe.formulas[execFmlIdx][JV.PROP_RUN_TYPE] === runType) {
  226. let expression = execFmlMe.formulas[execFmlIdx][JV.PROP_EXPRESSION];
  227. if (expression) {
  228. let $ME = execFmlMe.formulas[execFmlIdx];
  229. // console.log("current expression idx: " + execFmlIdx);
  230. // console.log(expression);
  231. try {
  232. eval(expression);
  233. } catch (ex) {
  234. console.log(ex);
  235. }
  236. }
  237. }
  238. }
  239. };
  240. JpcResult.outputAsPreviewPage= function(rptTpl, defProperties) {
  241. let me = this, rst = {};
  242. rst[JV.NODE_CONTROL_COLLECTION] = private_buildDftControls(rptTpl, (defProperties === null)?null:defProperties.ctrls);
  243. rst[JV.NODE_STYLE_COLLECTION] = private_buildDftStyles(rptTpl, (defProperties === null)?null:defProperties.styles);
  244. rst[JV.NODE_FONT_COLLECTION] = private_buildDftFonts(rptTpl, (defProperties === null)?null:defProperties.fonts);
  245. rst[JV.NODE_PAGE_INFO] = {};
  246. rst[JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME];
  247. rst[JV.NODE_PAGE_INFO][JV.NODE_PAGE_SIZE] = JpcCommonHelper.getPageSize(rptTpl);
  248. rst[JV.NODE_PAGE_INFO][JV.NODE_MARGINS] = rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS];
  249. rst.items = [];
  250. let bands = JpcBand.createNew(rptTpl, defProperties);
  251. try {
  252. function getPageMergeBorder() {
  253. let mergeRst = null;
  254. if (bands[JV.BAND_PROP_MERGE_BAND]) {
  255. let mergedBand = bands[JV.BAND_PROP_MERGE_BAND];
  256. mergeRst = {};
  257. mergeRst[JV.PROP_LEFT] = parseInt(mergedBand[JV.PROP_LEFT].toFixed(0));
  258. mergeRst[JV.PROP_RIGHT] = parseInt(mergedBand[JV.PROP_RIGHT].toFixed(0));
  259. mergeRst[JV.PROP_TOP] = parseInt(mergedBand[JV.PROP_TOP].toFixed(0));
  260. mergeRst[JV.PROP_BOTTOM] = parseInt(mergedBand[JV.PROP_BOTTOM].toFixed(0));
  261. }
  262. return mergeRst;
  263. }
  264. //1.
  265. let rstPage = {};
  266. rstPage[JV.PROP_PAGE_SEQ] = 1;
  267. if (me.flowTab) {
  268. rstPage[JV.PROP_CELLS] = me.flowTab.outputAsPreviewPage(rptTpl, bands, rst[JV.NODE_CONTROL_COLLECTION], me);
  269. } else if (me.crossTab) {
  270. rstPage[JV.PROP_CELLS] = me.crossTab.outputAsPreviewPage(rptTpl, bands, rst[JV.NODE_CONTROL_COLLECTION], me);
  271. } else if (me.billTab) {
  272. rstPage[JV.PROP_CELLS] = me.billTab.outputAsPreviewPage(rptTpl, bands, rst[JV.NODE_CONTROL_COLLECTION], me);
  273. }
  274. let pageMergeBorder = getPageMergeBorder();
  275. if (pageMergeBorder) {
  276. rstPage[JV.PROP_PAGE_MERGE_BORDER] = pageMergeBorder;
  277. }
  278. rst.items.push(rstPage);
  279. //2.
  280. if (bands[JV.BAND_PROP_MERGE_BAND]) {
  281. let mergedBand = {}, band = bands[JV.BAND_PROP_MERGE_BAND];
  282. mergedBand[JV.PROP_LEFT] = parseInt(band[JV.PROP_LEFT].toFixed(0));
  283. mergedBand[JV.PROP_RIGHT] = parseInt(band[JV.PROP_RIGHT].toFixed(0));
  284. mergedBand[JV.PROP_TOP] = parseInt(band[JV.PROP_TOP].toFixed(0));
  285. mergedBand[JV.PROP_BOTTOM] = parseInt(band[JV.PROP_BOTTOM].toFixed(0));
  286. mergedBand[JV.BAND_PROP_STYLE] = band[JV.BAND_PROP_STYLE];
  287. rst[JV.BAND_PROP_MERGE_BAND] = mergedBand;
  288. }
  289. } catch(exception) {
  290. console.log(exception);
  291. } finally {
  292. bands = null;
  293. }
  294. return rst;
  295. };
  296. JpcResult.outputAsSimpleJSONPageArray = function(rptTpl, dataObj, startPage, endPage, defProperties, customizeCfg) {
  297. let me = this, rst = {};
  298. if ((startPage > 0) && (startPage <= endPage) && (endPage <= me.totalPages)) {
  299. rst[JV.NODE_CONTROL_COLLECTION] = private_buildDftControls(rptTpl, (defProperties === null)?null:defProperties.ctrls);
  300. rst[JV.NODE_STYLE_COLLECTION] = private_buildDftStyles(rptTpl, (defProperties === null)?null:defProperties.styles);
  301. rst[JV.NODE_FONT_COLLECTION] = private_buildDftFonts(rptTpl, (defProperties === null)?null:defProperties.fonts);
  302. rst[JV.NODE_PAGE_INFO] = {};
  303. rst[JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME] = rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MAIN_INFO_RPT_NAME];
  304. rst[JV.NODE_PAGE_INFO][JV.NODE_PAGE_SIZE] = JpcCommonHelper.getPageSize(rptTpl);
  305. rst[JV.NODE_PAGE_INFO][JV.NODE_MARGINS] = rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS];
  306. rst.items = [];
  307. let bands = JpcBand.createNew(rptTpl, defProperties);
  308. try {
  309. for (let page = startPage; page <= endPage; page++) {
  310. me.runTimePageData.currentPage = page;
  311. me.executeFormulas(JV.RUN_TYPE_BEFORE_OUTPUT, rptTpl, dataObj, me);
  312. rst.items.push(me.outputAsSimpleJSONPage(rptTpl, dataObj, bands, page, rst[JV.NODE_CONTROL_COLLECTION], customizeCfg));
  313. }
  314. if (bands[JV.BAND_PROP_MERGE_BAND]) {
  315. let mergedBand = {}, band = bands[JV.BAND_PROP_MERGE_BAND];
  316. mergedBand[JV.PROP_LEFT] = parseInt(band[JV.PROP_LEFT].toFixed(0));
  317. mergedBand[JV.PROP_RIGHT] = parseInt(band[JV.PROP_RIGHT].toFixed(0));
  318. mergedBand[JV.PROP_TOP] = parseInt(band[JV.PROP_TOP].toFixed(0));
  319. mergedBand[JV.PROP_BOTTOM] = parseInt(band[JV.PROP_BOTTOM].toFixed(0));
  320. mergedBand[JV.BAND_PROP_STYLE] = band[JV.BAND_PROP_STYLE];
  321. rst[JV.BAND_PROP_MERGE_BAND] = mergedBand;
  322. }
  323. } catch(exception) {
  324. console.log(exception);
  325. } finally {
  326. bands = null;
  327. }
  328. }
  329. return rst;
  330. };
  331. JpcResult.outputAsSimpleJSONPage = function(rptTpl, dataObj, bands, page, controls, customizeCfg) {
  332. let me = this, rst = null;
  333. function getPageMergeBorder() {
  334. let mergeRst = null;
  335. if (bands[JV.BAND_PROP_MERGE_BAND]) {
  336. let mergedBand = bands[JV.BAND_PROP_MERGE_BAND];
  337. mergeRst = {};
  338. mergeRst[JV.PROP_LEFT] = parseInt(mergedBand[JV.PROP_LEFT].toFixed(0));
  339. mergeRst[JV.PROP_RIGHT] = parseInt(mergedBand[JV.PROP_RIGHT].toFixed(0));
  340. mergeRst[JV.PROP_TOP] = parseInt(mergedBand[JV.PROP_TOP].toFixed(0));
  341. mergeRst[JV.PROP_BOTTOM] = parseInt(mergedBand[JV.PROP_BOTTOM].toFixed(0));
  342. }
  343. return mergeRst;
  344. }
  345. if (me.totalPages >= page) {
  346. rst = {};
  347. rst[JV.PROP_PAGE_SEQ] = page;
  348. //rst.cells = [];
  349. let adHocMergePos = null;
  350. if (me.flowTab) {
  351. if (me.totalPages - me.exTotalPages >= page) {
  352. if (me.flowTab.paging_option === JV.PAGING_OPTION_INFINITY) {
  353. adHocMergePos = {};
  354. }
  355. rst[JV.PROP_CELLS] = me.flowTab.outputAsSimpleJSONPage(rptTpl, dataObj, page, bands, controls, adHocMergePos, me, customizeCfg);
  356. if (adHocMergePos) {
  357. adHocMergePos[JV.NODE_PAGE_SIZE] = JpcCommonHelper.getPageSize(rptTpl);
  358. rst[JV.PAGE_SPECIAL_MERGE_POS] = adHocMergePos;
  359. }
  360. } else {
  361. if (!me.isFollowMode) {
  362. rst[JV.PROP_CELLS] = me.flowTabEx.outputAsSimpleJSONPage(rptTpl, dataObj, page - (me.totalPages - me.exTotalPages), bands, controls, adHocMergePos, me, customizeCfg);
  363. }
  364. }
  365. } else if (me.crossTab) {
  366. rst[JV.PROP_CELLS] = me.crossTab.outputAsSimpleJSONPage(rptTpl, dataObj, page, bands, controls, me, customizeCfg);
  367. } else if (me.billTab) {
  368. rst[JV.PROP_CELLS] = me.billTab.outputAsSimpleJSONPage(rptTpl, dataObj, page, bands, controls, me, customizeCfg);
  369. }
  370. if (!(me.flowTab && me.flowTab.paging_option === JV.PAGING_OPTION_INFINITY)) {
  371. let pageMergeBorder = getPageMergeBorder();
  372. if (pageMergeBorder) {
  373. rst[JV.PROP_PAGE_MERGE_BORDER] = pageMergeBorder;
  374. }
  375. }
  376. }
  377. return rst;
  378. };
  379. //JpcEx.rte.currentRptObj = JpcResult;
  380. return JpcResult;
  381. };
  382. export default new JpcExSrv();