rpt_construct_data_util.js 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254
  1. /**
  2. * Created by Tony on 2017/7/14.
  3. * 报表数据提取class,是协助报表模板里指标字段自主提取数据的工具类
  4. */
  5. let JV = require('../rpt_component/jpc_value_define');
  6. let $JE = require('../rpt_component/jpc_rte');
  7. let consts = require('../../../modules/main/models/project_consts');
  8. let projectConst = consts.projectConst;
  9. let projectConstList = consts.projectConstList;
  10. class Rpt_Common{
  11. initialize(Projects) {
  12. this.Projects = Projects;
  13. };
  14. getSerialNo(fieldId, $CURRENT_RPT, $CURRENT_DATA){
  15. let itemSerialNoRec = $JE.F(fieldId, $CURRENT_RPT);
  16. if (itemSerialNoRec) {
  17. itemSerialNoRec[JV.PROP_AD_HOC_DATA] = [];
  18. for (var innerFmlIdx = 0; innerFmlIdx < $CURRENT_DATA[JV.DATA_DETAIL_DATA][0].length; innerFmlIdx++) {
  19. itemSerialNoRec[JV.PROP_AD_HOC_DATA][innerFmlIdx] = (innerFmlIdx + 1);
  20. }
  21. itemSerialNoRec = null;
  22. }
  23. };
  24. }
  25. class Rpt_Data_Extractor {
  26. constructor () {
  27. this.COMMON = new Rpt_Common();
  28. };
  29. initialize(tpl) {
  30. this.rptTpl = tpl;
  31. };
  32. getDataRequestFilter() {
  33. let rst = [];
  34. let tpl = this.rptTpl;
  35. let pri_func_chk_filter = function (field) {
  36. for (let key of projectConstList) {
  37. if (rst.indexOf(key) < 0) {
  38. if (field[JV.PROP_FIELD_EXP_MAP]) {
  39. if (field[JV.PROP_FIELD_EXP_MAP].indexOf('.' + key + '.') >= 0) {
  40. rst.push(key);
  41. }
  42. }
  43. }
  44. }
  45. };
  46. if (tpl[JV.NODE_FIELD_MAP][JV.NODE_DISCRETE_FIELDS]) {
  47. for (let field of tpl[JV.NODE_FIELD_MAP][JV.NODE_DISCRETE_FIELDS]) {
  48. pri_func_chk_filter(field);
  49. }
  50. }
  51. if (tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS]) {
  52. for (let field of tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS]) {
  53. pri_func_chk_filter(field);
  54. }
  55. }
  56. if (tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS]) {
  57. for (let field of tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS]) {
  58. pri_func_chk_filter(field);
  59. }
  60. }
  61. if (tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS_EX]) {
  62. for (let field of tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS_EX]) {
  63. pri_func_chk_filter(field);
  64. }
  65. }
  66. if (tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS_EX]) {
  67. for (let field of tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS_EX]) {
  68. pri_func_chk_filter(field);
  69. }
  70. }
  71. return rst;
  72. };
  73. //--- 装配数据(把收集到的数据,依据报表模板的指示,预处理(如:排序、过滤、合计)及装配到相关指标) ---//
  74. assembleData(rawDataObj) {
  75. let $PROJECT = {"COMMON": {}, "MAIN": {}, "DETAIL": {}};
  76. let tpl = this.rptTpl;
  77. $PROJECT.MAIN["myOwnRawDataObj"] = rawDataObj.prj._doc;
  78. $PROJECT.MAIN.getProperty = ext_mainGetPropety;
  79. $PROJECT.MAIN.getFee = ext_mainGetFee;
  80. $PROJECT.DETAIL.getRationPropertyByID = ext_getRationPropertyByID;
  81. if (tpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  82. for (let preHandle of tpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  83. switch(preHandle[JV.PROP_HANDLE_TYPE]) {
  84. case JV.PROP_HANDLE_TYPE_SORT:
  85. break;
  86. case JV.PROP_HANDLE_TYPE_FILTER:
  87. break;
  88. case JV.PROP_HANDLE_TYPE_SUM:
  89. //
  90. }
  91. }
  92. }
  93. for (let item of rawDataObj.prjData) {
  94. setupFunc($PROJECT.DETAIL, item.moduleName, item);
  95. }
  96. let rptDataObj = {};
  97. rptDataObj[JV.DATA_DISCRETE_DATA] = [];
  98. rptDataObj[JV.DATA_MASTER_DATA] = [];
  99. rptDataObj[JV.DATA_DETAIL_DATA] = [];
  100. rptDataObj[JV.DATA_MASTER_DATA_EX] = [];
  101. rptDataObj[JV.DATA_DETAIL_DATA_EX] = [];
  102. assembleFields(tpl[JV.NODE_FIELD_MAP][JV.NODE_DISCRETE_FIELDS], rptDataObj[JV.DATA_DISCRETE_DATA], $PROJECT);
  103. // console.log(JV.DATA_DISCRETE_DATA);
  104. // console.log(rptDataObj[JV.DATA_DISCRETE_DATA]);
  105. assembleFields(tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS], rptDataObj[JV.DATA_MASTER_DATA], $PROJECT);
  106. // console.log(JV.DATA_MASTER_DATA);
  107. // console.log(rptDataObj[JV.DATA_MASTER_DATA]);
  108. assembleFields(tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS], rptDataObj[JV.DATA_DETAIL_DATA], $PROJECT);
  109. // console.log(JV.DATA_DETAIL_DATA);
  110. // console.log(rptDataObj[JV.DATA_DETAIL_DATA]);
  111. assembleFields(tpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS_EX], rptDataObj[JV.DATA_MASTER_DATA_EX], $PROJECT);
  112. // console.log(JV.DATA_MASTER_DATA_EX);
  113. // console.log(rptDataObj[JV.DATA_MASTER_DATA_EX]);
  114. assembleFields(tpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS_EX], rptDataObj[JV.DATA_DETAIL_DATA_EX], $PROJECT);
  115. // console.log(JV.DATA_DETAIL_DATA_EX);
  116. // console.log(rptDataObj[JV.DATA_DETAIL_DATA_EX]);
  117. };
  118. }
  119. function setupFunc(obj, prop, ownRawObj) {
  120. obj[prop] = {};
  121. obj[prop]["myOwnRawDataObj"] = ownRawObj;
  122. obj[prop].getProperty = ext_getPropety;
  123. obj[prop].getFee = ext_getFee;
  124. }
  125. function assembleFields(fieldList, rstDataArr, $PROJECT) {
  126. if (fieldList) {
  127. for (let field of fieldList) {
  128. shielded_exec_env($PROJECT, field, rstDataArr);
  129. }
  130. }
  131. }
  132. function shielded_exec_env($PROJECT, $ME, rptDataItemObj) {
  133. if ($ME[JV.PROP_FIELD_EXP_MAP]) {
  134. rptDataItemObj.push(eval($ME[JV.PROP_FIELD_EXP_MAP]));
  135. }
  136. }
  137. function ext_mainGetPropety(propKey) {
  138. let rst = [];
  139. let parentObj = this;
  140. //console.log(this);
  141. let dtObj = parentObj["myOwnRawDataObj"];
  142. if ((dtObj) && (propKey)) {
  143. if (dtObj.hasOwnProperty("property")) {
  144. rst.push(dtObj["property"][propKey]);
  145. } else {
  146. rst.push(dtObj[propKey]);
  147. }
  148. }
  149. return rst;
  150. }
  151. function ext_mainGetFee(feeKey) {
  152. let rst = [];
  153. let parentObj = this;
  154. let dtObj = parentObj["myOwnRawDataObj"];
  155. if ((dtObj) && (feeKey)) {
  156. if (dtObj.hasOwnProperty("fees")) {
  157. for (let fee of dtObj["fees"]) {
  158. if (fee["fieldName"] === feeKey) {
  159. rst.push(dtObj["fees"][feeKey]);
  160. break;
  161. }
  162. }
  163. } else if (dtObj.hasOwnProperty(feeKey)) {
  164. rst.push(dtObj[feeKey]);
  165. } else {
  166. //
  167. }
  168. }
  169. return rst;
  170. }
  171. function ext_getPropety(propKey) {
  172. let rst = [], parentObj = this;
  173. let dtObj = parentObj["myOwnRawDataObj"];
  174. if (propKey && dtObj) {
  175. for (let dItem of dtObj.data) {
  176. let doc = dItem._doc;
  177. if (doc.hasOwnProperty("property")) {
  178. rst.push(doc["property"][propKey]);
  179. } else if (doc.hasOwnProperty(propKey)) {
  180. rst.push(doc[propKey]);
  181. } else {
  182. rst.push('');
  183. }
  184. }
  185. }
  186. return rst;
  187. }
  188. function ext_getFee(feeKey) {
  189. let rst = [], parentObj = this;
  190. let dtObj = parentObj["myOwnRawDataObj"];
  191. if (feeKey && dtObj) {
  192. for (let dItem of dtObj.data) {
  193. if (dItem.hasOwnProperty("fees")) {
  194. for (let fee of dItem["fees"]) {
  195. if (fee["fieldName"] === feeKey) {
  196. rst.push(dItem["fees"][feeKey]);
  197. break;
  198. }
  199. }
  200. } else if (dItem.hasOwnProperty(feeKey)) {
  201. rst.push(dItem[feeKey]);
  202. } else {
  203. rst.push[0];
  204. }
  205. }
  206. }
  207. return rst;
  208. }
  209. function ext_getRationPropertyByID(IdVal, propKey) {
  210. let rst = [], me = this;
  211. if (IdVal !== null && IdVal !== undefined && me[projectConst.RATION]) {
  212. let isFound = false;
  213. if (IdVal instanceof Array) {
  214. for (let id of IdVal) {
  215. isFound = false;
  216. for (let item of me[projectConst.RATION]["myOwnRawDataObj"].data) {
  217. if (item.ID === id) {
  218. rst.push(item[propKey]);
  219. isFound = true;
  220. break;
  221. }
  222. }
  223. // if (!isFound) rst.push[null];
  224. }
  225. } else {
  226. for (let item of me[projectConst.RATION]["myOwnRawDataObj"].data) {
  227. if (item.ID === IdVal) {
  228. rst.push(item[propKey]);
  229. isFound = true;
  230. break;
  231. }
  232. }
  233. // if (!isFound) rst.push[null];
  234. }
  235. }
  236. return rst;
  237. }
  238. export default Rpt_Data_Extractor;