test_tpl_project_fields.js 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. /**
  2. * Created by Tony on 2018/6/12.
  3. * 专门测试项目技术经济指标类型表
  4. */
  5. let test = require('tape');
  6. import JpcEx from "../../../modules/reports/rpt_component/jpc_ex";
  7. import JV from "../../../modules/reports/rpt_component/jpc_value_define";
  8. let config = require("../../../config/config.js");
  9. config.setupDb(process.env.NODE_ENV);
  10. let mongoose = require("mongoose");
  11. let fileUtils = require("../../../modules/common/fileUtils");
  12. let path = require('path');
  13. let dbm = require("../../../config/db/db_manager");
  14. let rpt_cfg = require('./rpt_cfg');
  15. dbm.connect(process.env.NODE_ENV);
  16. //统一引用models
  17. fileUtils.getGlobbedFiles('../../../modules/all_models/*.js').forEach(function(modelPath) {
  18. require(path.resolve(modelPath));
  19. });
  20. //config.setupCache();
  21. let cfgCacheUtil = require("../../../config/cacheCfg");
  22. cfgCacheUtil.setupDftCache();
  23. let fsUtil = require("../../../public/fsUtil");
  24. let pm_facade = require('../../../modules/pm/facade/pm_facade');
  25. let demoPrjId = - 1;
  26. // let demoRptId = 1006; //qa 重庆2018 A03
  27. let demoRptId = 1005; //qa 重庆2018 A01
  28. let pagesize = "A4";
  29. // let userId_Leng = "59cdf14a0034a1000ba52b97"; //小冷User Id 换成_id了 QQ号
  30. let userId_Leng = "5acac1e885bf55000bd055ba"; //小冷User Id2
  31. let userId_me = "5b6a60b1c4ba33000dd417c0"; //我的
  32. // let userId_HaiZhu = "5b5a66c4a3c23e000dccdd77"; //海珠user id
  33. demoPrjId = 9279; //
  34. //*/
  35. let userId_Dft = userId_Leng;
  36. // let userId_Dft = "5a025c4c15074d134c2b9689";
  37. /*/
  38. let userId_Dft = "595328da1934dc327cad08eb";
  39. //*/
  40. let rptTplFacade = require("../../../modules/reports/facade/rpt_template_facade");
  41. let rptTplDataFacade = require("../../../modules/reports/facade/rpt_tpl_data_facade");
  42. import rptDataExtractor from "../../../modules/reports/util/rpt_construct_data_util";
  43. import rpt_xl_util from "../../../modules/reports/util/rpt_excel_util";
  44. import rpt_pdf_util from "../../../modules/reports/util/rpt_pdf_util";
  45. let fs = require('fs');
  46. //设置Date Format函数
  47. fs.readFile(__dirname.slice(0, __dirname.length - 18) + '/public/web/date_util.js', 'utf8', 'r', function (err, data) {
  48. eval(data);
  49. });
  50. test('测试 - : ', function (t) {
  51. rptTplFacade.getRptTemplate(demoRptId).then(function(rptTpl) {
  52. let rptDataUtil = new rptDataExtractor();
  53. rptDataUtil.initialize(rptTpl._doc);
  54. let promiseArr = [null, null, null];
  55. let summaryRst = [], economicRst = [];
  56. let filter = rptDataUtil.getDataRequestFilter(summaryRst, economicRst);
  57. // console.log(filter);
  58. if (economicRst.length > 0) {
  59. // economicRst.push('ProjectInfoFields');
  60. // economicRst.push('ProjectFeatureFields');
  61. promiseArr[2] = pm_facade.getIndexReportData(demoPrjId, economicRst);
  62. }
  63. //正常应该根据报表模板定义的数据类型来请求数据
  64. rptTplDataFacade.prepareProjectData(userId_Dft, demoPrjId, filter, function (err, msg, rawDataObj) {
  65. if (!err) {
  66. try {
  67. promiseArr[2].then(function (rst) {
  68. let ecoFieldsRst = (rst._doc)?rst._doc:rst;
  69. // fsUtil.writeObjToFile(ecoFieldsRst, "D:/GitHome/ConstructionCost/tmp/testEcoFieldsResult.jsp");
  70. rawDataObj.prjData.push({moduleName: 'ProjectInfoFields', data: ecoFieldsRst.ProjectInfoFields});
  71. rawDataObj.prjData.push({moduleName: 'ProjectFeatureFields', data: ecoFieldsRst.ProjectFeatureFields});
  72. rawDataObj.prjData.push({moduleName: 'ProjectCostFields', data: ecoFieldsRst.ProjectCostFields});
  73. rawDataObj.prjData.push({moduleName: 'ProjectEcoFields', data: ecoFieldsRst.ProjectEcoFields});
  74. rawDataObj.prjData.push({moduleName: 'ProjectLabMaterialFields', data: ecoFieldsRst.ProjectLabMaterialFields});
  75. rawDataObj.prjData.push({moduleName: 'ProjectQtyFields', data: ecoFieldsRst.ProjectQtyFields});
  76. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataObject_系统指标.jsp");
  77. let tplData = rptDataUtil.assembleData(rawDataObj);
  78. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataAfterCacl_系统指标.jsp");
  79. // fsUtil.writeObjToFile(tplData, "D:/GitHome/ConstructionCost/tmp/rptTplAssembledData_系统指标.jsp");
  80. //it's time to build the report!!!
  81. let printCom = JpcEx.createNew();
  82. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pagesize;
  83. let defProperties = rpt_cfg;
  84. let dftOption = JV.PAGING_OPTION_NORMAL;
  85. printCom.initialize(rptTpl);
  86. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, JV.OUTPUT_TYPE_EXCEL);
  87. let maxPages = printCom.totalPages;
  88. let customizeCfg = {"fillZero": true};
  89. let pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
  90. if (pageRst) {
  91. // fsUtil.writeObjToFile(pageRst, "D:/GitHome/ConstructionCost/tmp/testBuiltPageResult_系统指标.jsp");
  92. // rpt_xl_util.exportExcel(pageRst, pagesize, "local_test_rpt_excel", true, null, null, function(uuidName){
  93. // console.log("excel uuid: " + uuidName);
  94. // });
  95. // rpt_pdf_util.export_pdf_file(pageRst, pagesize, 'local_test_rpt_pdf', function(uuidName){
  96. // console.log("pdf uuid: " + uuidName);
  97. // });
  98. } else {
  99. console.log("oh! no pages were created!");
  100. }
  101. });
  102. } catch (ex) {
  103. console.log(ex);
  104. t.pass('pass with exception!');
  105. t.end();
  106. }
  107. t.pass('pass succeeded!');
  108. t.end();
  109. } else {
  110. console.log(msg);
  111. t.pass('pass with error!');
  112. t.end();
  113. }
  114. })
  115. });
  116. });
  117. test('close the connection', function (t) {
  118. setTimeout(function () {
  119. mongoose.disconnect();
  120. t.pass('closing db connection');
  121. t.end();
  122. }, 1000);
  123. // mongoose.disconnect();
  124. // t.pass('closing db connection');
  125. // t.end();
  126. });