rpt_tpl_calculation.js 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  1. /**
  2. * Created by Tony on 2017/7/7.
  3. */
  4. let expr_templates = [
  5. // {Name: "整理序号(单层)", Expression: "let destField = $JE.F(/*指标ID*/,$CURRENT_RPT);\n destField[JV.PROP_AD_HOC_DATA] = [];\n for (let innerFmlIdx = 0; innerFmlIdx < $CURRENT_DATA[JV.DATA_DETAIL_DATA][0].length; innerFmlIdx++) {\n $JE.setFieldValue(destField, $CURRENT_DATA, innerFmlIdx, (innerFmlIdx + 1));\n}"},
  6. {Name: "转换大写金额", Expression: "let capF = $JE.F(/*目标指标ID*/, $CURRENT_RPT), orgF = $JE.F(/*原始指标ID*/, $CURRENT_RPT);\n $JE.setFieldValue(capF, $CURRENT_DATA, 0, $JE.$STR_UTIL.convertToCaptionNum(parseFloat($JE.getFieldValue(orgF, $CURRENT_DATA, 0, 0)).toFixed(2), true, true));"},
  7. {Name: "总计汇总", Expression: "let totalFee = $JE.F(/*目标指标ID*/,$CURRENT_RPT), bill1 = $JE.F(/*原始指标ID*/,$CURRENT_RPT);\n let sumValue = 0.0;\n sumValue += parseFloat($JE.getFieldValue(bill1,$CURRENT_DATA,0,0));\n $JE.setFieldValue(totalFee,$CURRENT_DATA,0,sumValue);"},
  8. {Name: "格式化指标时间", Expression: "let dtF = $JE.F(/*时间指标ID*/,$CURRENT_RPT);\n let dt = new Date($JE.getFieldValue(dtF, $CURRENT_DATA, 0, 0));\n $JE.setFieldValue(dtF, $CURRENT_DATA, 0, dt.Format($ME.format));"},
  9. {Name: "依据单位调整格式(小数位数)", Expression: "let decimalField = $JE.F(3281,$CURRENT_RPT),\n unitField = $JE.F(/*单位指标ID*/,$CURRENT_RPT),\n targetField = $JE.F(/*原始目标指标ID*/,$CURRENT_RPT),\n outputField = $JE.F(/*真正输出目标指标ID*/,$CURRENT_RPT);\nlet tmpObj = {}, key_prefix = 'key_';\nlet dfv = $JE.getFieldValue(decimalField, $CURRENT_DATA, 0, null);\nif (dfv instanceof Array) {\n for (let dcmf of dfv) {\n tmpObj[key_prefix + dcmf['unit']] = dcmf['decimal'];\n }\n for (let dtlIdx = 0; dtlIdx < $CURRENT_DATA[JV.DATA_DETAIL_DATA][0].length; dtlIdx++) {\n let ukey = key_prefix + $JE.getFieldValue(unitField, $CURRENT_DATA, dtlIdx, '其他未列单位');\n let fstr = '#.####';\n if (tmpObj[ukey]) {\n fstr = '#.';\n for (let fIdx = 0; fIdx < tmpObj[ukey]; fIdx++) {\n fstr += '#';\n }\n }\n let val = $JE.getFieldValue(targetField, $CURRENT_DATA, dtlIdx, '0');\n val = $JE.$STR_UTIL.formatNumber(fstr, val);\n $JE.setFieldValue(outputField,$CURRENT_DATA,dtlIdx, val);\n }\n}"}
  10. ];
  11. let calculationTreeOprObj = {
  12. treeObj : null,
  13. currentNode: null,
  14. iniTree: function(rptTpl) {
  15. var me = this;
  16. let fieldMapList = me.buildTreeData(rptTpl);
  17. me.treeObj = $.fn.zTree.init($("#rpt_tpl_formulas"), caculationSetting, fieldMapList);
  18. me.treeObj.expandAll(true);
  19. $("#exprDetail")[0].style.display = "none";
  20. // $("#exprFormat").get(0).value = "";
  21. // $("#exprContent").get(0).value = "";
  22. },
  23. buildExprTemplates: function () {
  24. let et = $("#exprTemplatesSelect");
  25. for (let i = 0; i < expr_templates.length; i++) {
  26. et.append("<option>" + expr_templates[i].Name + "</option>");
  27. }
  28. },
  29. buildRunType: function() {
  30. let et = $("#exprRunType");
  31. et.append("<option value='" + JV.RUN_TYPE_BEFORE_PAGING + "'>预运行</option>");
  32. et.append("<option value='" + JV.RUN_TYPE_BEFORE_OUTPUT + "'>实时运行</option>");
  33. },
  34. buildTreeData: function (rptTpl) {
  35. let me = this, rst = {"Name": "计算式", items: []};
  36. if (rptTpl[JV.NODE_FORMULAS]) {
  37. for (let cItem of rptTpl[JV.NODE_FORMULAS]) {
  38. let node = {};
  39. me.copyContent(cItem, node);
  40. node[JV.PROP_NAME] = cItem[JV.PROP_NAME];
  41. node[JV.PROP_RUN_TYPE] = cItem[JV.PROP_RUN_TYPE];
  42. node[JV.PROP_EXPRESSION] = cItem[JV.PROP_EXPRESSION];
  43. node["format"] = (cItem["format"])?cItem["format"]:"";
  44. rst.items.push(node);
  45. }
  46. }
  47. return rst;
  48. },
  49. copyContent: function(source, target) {
  50. target[JV.PROP_NAME] = source[JV.PROP_NAME];
  51. target[JV.PROP_RUN_TYPE] = source[JV.PROP_RUN_TYPE];
  52. target[JV.PROP_EXPRESSION] = source[JV.PROP_EXPRESSION];
  53. target["format"] = (source["format"])?source["format"]:"";
  54. },
  55. changeRunType: function (dom) {
  56. let me = calculationTreeOprObj;
  57. if (me.currentNode) {
  58. me.currentNode[JV.PROP_RUN_TYPE] = dom.value;
  59. }
  60. },
  61. setTemplateExpression: function (dom) {
  62. let selIdx = $("#exprTemplatesSelect")[0].selectedIndex;
  63. $("#exprContent")[0].value = expr_templates[selIdx].Expression;
  64. },
  65. changeFormat: function (dom) {
  66. let me = calculationTreeOprObj;
  67. if (me.currentNode) {
  68. me.currentNode["format"] = dom.value;
  69. }
  70. },
  71. changeExpression: function (dom) {
  72. let me = calculationTreeOprObj;
  73. if (me.currentNode) {
  74. me.currentNode[JV.PROP_EXPRESSION] = dom.value;
  75. }
  76. },
  77. onClick: function (event,treeId,treeNode) {
  78. let me = calculationTreeOprObj;
  79. me.currentNode = treeNode;
  80. if (treeNode.level === 0) {
  81. $("#exprDetail")[0].style.display = "none";
  82. } else {
  83. $("#exprDetail")[0].style.display = "";
  84. if (treeNode[JV.PROP_RUN_TYPE] === JV.RUN_TYPE_BEFORE_PAGING) {
  85. $("#exprRunType")[0].selectedIndex = 0;
  86. } else {
  87. $("#exprRunType")[0].selectedIndex = 1;
  88. }
  89. $("#exprFormat")[0].value = (treeNode["format"])?treeNode["format"]:"";
  90. $("#exprContent")[0].value = treeNode[JV.PROP_EXPRESSION];
  91. //
  92. }
  93. },
  94. onBeforeRemove: function(treeId, treeNode){
  95. let rst = false;
  96. if (treeNode.level > 0) {
  97. rst = confirm('请确认是否真的删除?');
  98. }
  99. return rst;
  100. },
  101. beforeRename: function(treeId, treeNode, newName, isCancel) {
  102. if (isCancel) {
  103. return true;
  104. }
  105. if (treeNode.level === 0) {
  106. return false;
  107. }
  108. return true;
  109. },
  110. onBeforeDrop: function (treeId, treeNodes, targetNode, moveType) {
  111. let rst = false;
  112. if (targetNode.level === 1 && (moveType === "next" || moveType === "prev")) {
  113. return true;
  114. }
  115. return rst;
  116. },
  117. addHoverDom: function(treeId, treeNode) {
  118. let me = calculationTreeOprObj, sObj = $("#" + treeNode.tId + "_span");
  119. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length > 0 || treeNode.level > 0) {
  120. return;
  121. } else {
  122. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增' onfocus='this.blur();'></span>";
  123. sObj.after(addStr);
  124. let btn = $("#addBtn_"+treeNode.tId);
  125. btn.bind("click", function(){
  126. let newNodes = [], node = {};
  127. node[JV.PROP_NAME] = "新计算式";
  128. node[JV.PROP_RUN_TYPE] = JV.RUN_TYPE_BEFORE_PAGING;
  129. node[JV.PROP_EXPRESSION] = "";
  130. node["format"] = "";
  131. newNodes.push(node);
  132. me.treeObj.addNodes(treeNode, -1, newNodes, true);
  133. });
  134. }
  135. },
  136. removeHoverDom: function(treeId, treeNode) {
  137. $("#addBtn_"+treeNode.tId).unbind().remove();
  138. },
  139. extractCalculation: function (rptTpl) {
  140. let me = this, newCaclList = [];
  141. let topNode = me.treeObj.getNodes()[0];
  142. for (let node of topNode.items) {
  143. let item = {};
  144. me.copyContent(node, item);
  145. newCaclList.push(item);
  146. }
  147. rptTpl[JV.NODE_FORMULAS] = newCaclList;
  148. }
  149. }