test_tpl_09_1.js 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  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 mongoose = require("mongoose");
  8. let fileUtils = require("../../../modules/common/fileUtils");
  9. let path = require('path');
  10. let dbm = require("../../../config/db/db_manager");
  11. let rpt_cfg = require('./rpt_cfg');
  12. dbm.connect();
  13. let consts = require('../../../modules/main/models/project_consts');
  14. let projectConsts = consts.projectConst;
  15. fileUtils.getGlobbedFiles('../../../modules/complementary_glj_lib/models/*.js').forEach(function(modelPath) {
  16. require(path.resolve(modelPath));
  17. });
  18. fileUtils.getGlobbedFiles('../../../modules/ration_glj/models/*.js').forEach(function(modelPath) {
  19. require(path.resolve(modelPath));
  20. });
  21. //引入报表模块
  22. fileUtils.getGlobbedFiles('../../../modules/reports/models/*.js').forEach(function(modelPath) {
  23. require(path.resolve(modelPath));
  24. })
  25. //暂时引入其它模块的model
  26. require('../../../modules/fee_rates/models/fee_rates');
  27. // 引入人工系数模块
  28. require('../../../modules/main/models/labour_coe_model');
  29. require('../../../modules/main/models/calc_program_model');
  30. let fsUtil = require("../../../public/fsUtil");
  31. let prjMdl = require('../../../modules/pm/models/project_model');
  32. let projectDataMdl = require('../../../modules/main/models/project');
  33. let demoPrjId = - 1;
  34. let demoRptId = 226, pagesize = "A4";
  35. let userId_Leng = 1142; //小冷User Id
  36. // demoPrjId = 720; //QA: DW3
  37. demoPrjId = 1296; //QA:
  38. //*/
  39. let userId_Dft = userId_Leng;
  40. /*/
  41. let userId_Dft = 76075;
  42. //*/
  43. let rptTplFacade = require("../../../modules/reports/facade/rpt_template_facade");
  44. let rptTplDataFacade = require("../../../modules/reports/facade/rpt_tpl_data_facade");
  45. import rptDataExtractor from "../../../modules/reports/util/rpt_construct_data_util";
  46. let fs = require('fs');
  47. //设置Date Format函数
  48. fs.readFile(__dirname.slice(0, __dirname.length - 18) + '/public/web/date_util.js', 'utf8', 'r', function (err, data) {
  49. eval(data);
  50. });
  51. /*/
  52. test('测试 - 获取project数据: ', function (t) {
  53. projectDataMdl.getData(demoPrjId, function (err, message, result) {
  54. if (!err) {
  55. fsUtil.writeObjToFile(result, "D:/GitHome/ConstructionCost/tmp/ProjectDataFullObject.js");
  56. t.pass('pass succeeded!');
  57. t.end();
  58. } else {
  59. //callback(req, res, err, message, null);
  60. t.pass('pass failed!');
  61. t.end();
  62. }
  63. });
  64. });
  65. //*/
  66. /*/
  67. test('测试 - 获取project部分数据: ', function (t) {
  68. let filter = [];
  69. filter.push(projectConsts.BILLS);
  70. filter.push(projectConsts.RATION);
  71. filter.push(projectConsts.RATION_GLJ);
  72. filter.push(projectConsts.PROJECTGLJ);
  73. filter.push(projectConsts.FEERATE);
  74. filter.push(projectConsts.CALC_PROGRAM);
  75. prjMdl.project.getUserProject(userId_Dft, demoPrjId, function(err, msg, prjObj){
  76. if (!err) {
  77. projectDataMdl.getFilterData(demoPrjId, filter, function (results) {
  78. if (results) {
  79. // let newData = [];
  80. // for (let item of results) {
  81. // newData.push(JSON.stringify(item));
  82. // }
  83. // fsUtil.writeArrayToFile(newData, "D:/GitHome/ConstructionCost/tmp/getProjectData_partial.js");
  84. // fsUtil.writeObjToFile(prjObj, "D:/GitHome/ConstructionCost/tmp/getProjectObjectNew.js");
  85. fsUtil.writeObjToFile(results, "D:/GitHome/ConstructionCost/tmp/getProjectData_partialNew.js");
  86. t.pass('pass succeeded!');
  87. t.end();
  88. } else {
  89. //callback(req, res, err, message, null);
  90. t.pass('get project data failed!');
  91. t.end();
  92. }
  93. });
  94. } else {
  95. t.pass('get project failed!');
  96. t.end();
  97. }
  98. });
  99. });
  100. //*/
  101. //*
  102. test('测试 - 测试模板啦: ', function (t) {
  103. rptTplFacade.getRptTemplate(demoRptId).then(function(rptTpl) {
  104. let rptDataUtil = new rptDataExtractor();
  105. rptDataUtil.initialize(rptTpl._doc);
  106. let filter = rptDataUtil.getDataRequestFilter();
  107. console.log(filter);
  108. //正常应该根据报表模板定义的数据类型来请求数据
  109. rptTplDataFacade.prepareProjectData(userId_Dft, demoPrjId, filter, function (err, msg, rawDataObj) {
  110. if (!err) {
  111. try {
  112. // fsUtil.writeObjToFile(rawDataObj, "D:/GitHome/ConstructionCost/tmp/rptTplRawDataObject.js");
  113. let tplData = rptDataUtil.assembleData(rawDataObj);
  114. //it's time to build the report!!!
  115. let printCom = JpcEx.createNew();
  116. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pagesize;
  117. let defProperties = rpt_cfg;
  118. let dftOption = JV.PAGING_OPTION_NORMAL;
  119. printCom.initialize(rptTpl);
  120. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption);
  121. let maxPages = printCom.totalPages;
  122. let pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties);
  123. if (pageRst) {
  124. // fsUtil.wirteObjToFile(pageRst, "D:/GitHome/ConstructionCost/tmp/testBuiltPageResult.js");
  125. } else {
  126. console.log("oh! no pages were created!");
  127. }
  128. } catch (ex) {
  129. console.log(ex);
  130. t.pass('pass with exception!');
  131. t.end();
  132. }
  133. t.pass('pass succeeded!');
  134. t.end();
  135. } else {
  136. console.log(msg);
  137. t.pass('pass with error!');
  138. t.end();
  139. }
  140. })
  141. });
  142. });
  143. //*/
  144. /*/
  145. test('测试 - 保存小数位数问题: ', function (t) {
  146. require('./rpt_test_decimal');
  147. let rpt_decimal_mdl = mongoose.model("rpt_decimal_test");
  148. let num = 300000;
  149. let ID = 1;
  150. for (let i = 0.0001; i < 1; (i+=0.0001)) {
  151. let test_doc = {};
  152. test_doc.ID = ID;
  153. test_doc.Value1 = num + i;
  154. test_doc.Value2 = num + i + 0.1 + 0.2;
  155. test_doc.Value3 = parseFloat((num + i + 0.1 + 0.2).toFixed(5));
  156. rpt_decimal_mdl.create(test_doc);
  157. ID++;
  158. }
  159. t.pass('pass save decimal ok!');
  160. t.end();
  161. });
  162. //*/
  163. /*/
  164. test('测试 - 显示保存小数位数问题: ', function (t) {
  165. require('./rpt_test_decimal');
  166. let rpt_decimal_mdl = mongoose.model("rpt_decimal_test");
  167. rpt_decimal_mdl.find({}).then(function (rst) {
  168. //console.log(rst);
  169. if (rst.length > 0) {
  170. fsUtil.writeObjToFile(rst, "D:/GitHome/ConstructionCost/tmp/testDecimalResult.js");
  171. }
  172. t.pass('pass get decimal ok!');
  173. t.end();
  174. });
  175. });
  176. //*/
  177. test('close the connection', function (t) {
  178. setTimeout(function () {
  179. mongoose.disconnect();
  180. t.pass('closing db connection');
  181. t.end();
  182. }, 3000);
  183. // mongoose.disconnect();
  184. // t.pass('closing db connection');
  185. // t.end();
  186. });