test_tpl_09_1.js 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. /**
  2. * Created by Tony on 2017/10/18.
  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 = 226, pagesize = "A4";
  25. // let userId_Leng = "59cdf14a0034a1000ba52b97"; //小冷User Id 换成_id了 QQ号
  26. let userId_Leng = "5acac1e885bf55000bd055ba"; //小冷User Id2
  27. // demoPrjId = 720; //QA: DW3
  28. //demoPrjId = 1626; //QA:
  29. demoPrjId = 2260; //QA:
  30. //*/
  31. let userId_Dft = userId_Leng;
  32. /*/
  33. let userId_Dft = "595328da1934dc327cad08eb";
  34. //*/
  35. let rptTplFacade = require("../../../modules/reports/facade/rpt_template_facade");
  36. let rptTplDataFacade = require("../../../modules/reports/facade/rpt_tpl_data_facade");
  37. import rptDataExtractor from "../../../modules/reports/util/rpt_construct_data_util";
  38. let fs = require('fs');
  39. //设置Date Format函数
  40. fs.readFile(__dirname.slice(0, __dirname.length - 18) + '/public/web/date_util.js', 'utf8', 'r', function (err, data) {
  41. eval(data);
  42. });
  43. //*
  44. test('测试 - 测试模板啦: ', function (t) {
  45. rptTplFacade.getRptTemplate(demoRptId).then(function(rptTpl) {
  46. let rptDataUtil = new rptDataExtractor();
  47. rptDataUtil.initialize(rptTpl._doc);
  48. let filter = rptDataUtil.getDataRequestFilter();
  49. console.log(filter);
  50. //正常应该根据报表模板定义的数据类型来请求数据
  51. rptTplDataFacade.prepareProjectData(userId_Dft, demoPrjId, filter, function (err, msg, rawDataObj) {
  52. if (!err) {
  53. try {
  54. // if (filter.indexOf('ration') >= 0 && filter.indexOf('ration_glj') >= 0) {
  55. // rptDataUtil.moveRationData(rawDataObj, filter);
  56. // }
  57. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataObject_建筑09-1表.jsp");
  58. let tplData = rptDataUtil.assembleData(rawDataObj);
  59. // fsUtil.writeObjToFile(tplData, "D:/GitHome/ConstructionCost/tmp/rptTplAssembledData_建筑09-1表.jsp");
  60. //it's time to build the report!!!
  61. let printCom = JpcEx.createNew();
  62. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pagesize;
  63. let defProperties = rpt_cfg;
  64. let dftOption = JV.PAGING_OPTION_NORMAL;
  65. printCom.initialize(rptTpl);
  66. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption);
  67. let maxPages = printCom.totalPages;
  68. let pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties);
  69. if (pageRst) {
  70. // fsUtil.writeObjToFile(pageRst, "D:/GitHome/ConstructionCost/tmp/testBuiltPageResult_建筑09-1表.jsp");
  71. } else {
  72. console.log("oh! no pages were created!");
  73. }
  74. } catch (ex) {
  75. console.log(ex);
  76. t.pass('pass with exception!');
  77. t.end();
  78. }
  79. t.pass('pass succeeded!');
  80. t.end();
  81. } else {
  82. console.log(msg);
  83. t.pass('pass with error!');
  84. t.end();
  85. }
  86. })
  87. });
  88. });
  89. //*/
  90. /*/
  91. test('测试 - 保存小数位数问题: ', function (t) {
  92. require('./rpt_test_decimal');
  93. let rpt_decimal_mdl = mongoose.model("rpt_decimal_test");
  94. let num = 300000;
  95. let ID = 1;
  96. for (let i = 0.0001; i < 1; (i+=0.0001)) {
  97. let test_doc = {};
  98. test_doc.ID = ID;
  99. test_doc.Value1 = num + i;
  100. test_doc.Value2 = num + i + 0.1 + 0.2;
  101. test_doc.Value3 = parseFloat((num + i + 0.1 + 0.2).toFixed(5));
  102. rpt_decimal_mdl.create(test_doc);
  103. ID++;
  104. }
  105. t.pass('pass save decimal ok!');
  106. t.end();
  107. });
  108. //*/
  109. /*/
  110. test('测试 - 显示保存小数位数问题: ', function (t) {
  111. require('./rpt_test_decimal');
  112. let rpt_decimal_mdl = mongoose.model("rpt_decimal_test");
  113. rpt_decimal_mdl.find({}).then(function (rst) {
  114. //console.log(rst);
  115. if (rst.length > 0) {
  116. fsUtil.writeObjToFile(rst, "D:/GitHome/ConstructionCost/tmp/testDecimalResult.jsp");
  117. }
  118. t.pass('pass get decimal ok!');
  119. t.end();
  120. });
  121. });
  122. //*/
  123. test('close the connection', function (t) {
  124. setTimeout(function () {
  125. mongoose.disconnect();
  126. t.pass('closing db connection');
  127. t.end();
  128. }, 1000);
  129. // mongoose.disconnect();
  130. // t.pass('closing db connection');
  131. // t.end();
  132. });