test_rpt_test_template.js 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. /**
  2. * Created by Tony on 2018/6/12.
  3. */
  4. let test = require('tape');
  5. import JpcEx from "../../../modules/reports/rpt_component/jpc_ex";
  6. import JV from "../../../modules/reports/rpt_component/jpc_value_define";
  7. let config = require("../../../config/config.js");
  8. config.setupDb(process.env.NODE_ENV);
  9. let mongoose = require("mongoose");
  10. let fileUtils = require("../../../modules/common/fileUtils");
  11. let path = require('path');
  12. let dbm = require("../../../config/db/db_manager");
  13. let rpt_cfg = require('./rpt_cfg');
  14. dbm.connect(process.env.NODE_ENV);
  15. //统一引用models
  16. fileUtils.getGlobbedFiles('../../../modules/all_models/*.js').forEach(function(modelPath) {
  17. require(path.resolve(modelPath));
  18. });
  19. //config.setupCache();
  20. let cfgCacheUtil = require("../../../config/cacheCfg");
  21. cfgCacheUtil.setupDftCache();
  22. let fsUtil = require("../../../public/fsUtil");
  23. let demoPrjId = - 1;
  24. // let demoRptId = 279;
  25. // let demoRptId = 275; //测试模板-流水式
  26. // let demoRptId = 337; //19表
  27. // let demoRptId = 361; //封1
  28. // let demoRptId = 279; //表04
  29. // let demoRptId = 448; //封3
  30. // let demoRptId = 450; //09
  31. // let demoRptId = 704; //05
  32. // let demoRptId = 626; //06
  33. // let demoRptId = 451; //09-1
  34. // let demoRptId = 452; //04
  35. // let demoRptId = 612; //09-3
  36. // let demoRptId = 530; //封2
  37. // let demoRptId = 386; //04
  38. // let demoRptId = 389; //10
  39. // let demoRptId = 280; //11-1 暂列金
  40. // let demoRptId = 514; //12
  41. // let demoRptId = 2260; //测试基本信息
  42. // let demoRptId = 613; //09-4 2018
  43. // let demoRptId = 726; //定制:清单子目表
  44. // let demoRptId = 756; //江西 封1
  45. let demoRptId = 710; //qa 01
  46. // let demoRptId = 475; //计日工
  47. // let demoRptId = 551; //表05
  48. let pagesize = "A4";
  49. //288: 11-2表(新)
  50. //279: 04
  51. // let userId_Leng = "59cdf14a0034a1000ba52b97"; //小冷User Id 换成_id了 QQ号
  52. let userId_Leng = "5acac1e885bf55000bd055ba"; //小冷User Id2
  53. let userId_me = "5b6a60b1c4ba33000dd417c0"; //我的
  54. // let userId_HaiZhu = "5b5a66c4a3c23e000dccdd77"; //海珠user id
  55. // demoPrjId = 720; //QA: DW3
  56. //demoPrjId = 1626; //QA:
  57. // demoPrjId = 2260; //QA:
  58. // demoPrjId = 5029; //
  59. // demoPrjId = 5029; //项目名称过长
  60. demoPrjId = 6776; //
  61. // demoPrjId = 4107; //UAT:
  62. //*/
  63. let userId_Dft = userId_Leng;
  64. // let userId_Dft = "5a025c4c15074d134c2b9689";
  65. /*/
  66. let userId_Dft = "595328da1934dc327cad08eb";
  67. //*/
  68. let rptTplFacade = require("../../../modules/reports/facade/rpt_template_facade");
  69. let rptTplDataFacade = require("../../../modules/reports/facade/rpt_tpl_data_facade");
  70. import rptDataExtractor from "../../../modules/reports/util/rpt_construct_data_util";
  71. import rpt_xl_util from "../../../modules/reports/util/rpt_excel_util";
  72. import rpt_pdf_util from "../../../modules/reports/util/rpt_pdf_util";
  73. let fs = require('fs');
  74. //设置Date Format函数
  75. fs.readFile(__dirname.slice(0, __dirname.length - 18) + '/public/web/date_util.js', 'utf8', 'r', function (err, data) {
  76. eval(data);
  77. });
  78. test('测试 - 测试模板啦: ', function (t) {
  79. rptTplFacade.getRptTemplate(demoRptId).then(function(rptTpl) {
  80. let rptDataUtil = new rptDataExtractor();
  81. rptDataUtil.initialize(rptTpl._doc);
  82. let filter = rptDataUtil.getDataRequestFilter();
  83. // console.log(filter);
  84. //正常应该根据报表模板定义的数据类型来请求数据
  85. rptTplDataFacade.prepareProjectData(userId_Dft, demoPrjId, filter, function (err, msg, rawDataObj) {
  86. if (!err) {
  87. try {
  88. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataObject_测试模板.jsp");
  89. let tplData = rptDataUtil.assembleData(rawDataObj);
  90. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataAfterCacl_测试模板.jsp");
  91. // fsUtil.writeObjToFile(tplData, "D:/GitHome/ConstructionCost/tmp/rptTplAssembledData_测试模板.jsp");
  92. //it's time to build the report!!!
  93. let printCom = JpcEx.createNew();
  94. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pagesize;
  95. let defProperties = rpt_cfg;
  96. let dftOption = JV.PAGING_OPTION_NORMAL;
  97. printCom.initialize(rptTpl);
  98. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, JV.OUTPUT_TYPE_EXCEL);
  99. let maxPages = printCom.totalPages;
  100. let customizeCfg = {"fillZero": true};
  101. let pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
  102. if (pageRst) {
  103. fsUtil.writeObjToFile(pageRst, "D:/GitHome/ConstructionCost/tmp/testBuiltPageResult_测试模板.jsp");
  104. // rpt_xl_util.exportExcel(pageRst, pagesize, "local_test_rpt_excel", true, null, null, function(uuidName){
  105. // console.log("excel uuid: " + uuidName);
  106. // });
  107. // rpt_pdf_util.export_pdf_file(pageRst, pagesize, 'local_test_rpt_pdf', function(uuidName){
  108. // console.log("pdf uuid: " + uuidName);
  109. // });
  110. } else {
  111. console.log("oh! no pages were created!");
  112. }
  113. } catch (ex) {
  114. console.log(ex);
  115. t.pass('pass with exception!');
  116. t.end();
  117. }
  118. t.pass('pass succeeded!');
  119. t.end();
  120. } else {
  121. console.log(msg);
  122. t.pass('pass with error!');
  123. t.end();
  124. }
  125. })
  126. });
  127. });
  128. test('close the connection', function (t) {
  129. setTimeout(function () {
  130. mongoose.disconnect();
  131. t.pass('closing db connection');
  132. t.end();
  133. }, 1000);
  134. // mongoose.disconnect();
  135. // t.pass('closing db connection');
  136. // t.end();
  137. });