rpt_tpl_calculation.js 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  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. ];
  10. let calculationTreeOprObj = {
  11. treeObj : null,
  12. currentNode: null,
  13. iniTree: function(rptTpl) {
  14. var me = this;
  15. let fieldMapList = me.buildTreeData(rptTpl);
  16. me.treeObj = $.fn.zTree.init($("#rpt_tpl_formulas"), caculationSetting, fieldMapList);
  17. me.treeObj.expandAll(true);
  18. $("#exprDetail")[0].style.display = "none";
  19. // $("#exprFormat").get(0).value = "";
  20. // $("#exprContent").get(0).value = "";
  21. },
  22. buildExprTemplates: function () {
  23. let et = $("#exprTemplatesSelect");
  24. for (let i = 0; i < expr_templates.length; i++) {
  25. et.append("<option>" + expr_templates[i].Name + "</option>");
  26. }
  27. },
  28. buildRunType: function() {
  29. let et = $("#exprRunType");
  30. et.append("<option value='" + JV.RUN_TYPE_BEFORE_PAGING + "'>预运行</option>");
  31. et.append("<option value='" + JV.RUN_TYPE_BEFORE_OUTPUT + "'>实时运行</option>");
  32. },
  33. buildTreeData: function (rptTpl) {
  34. let me = this, rst = {"Name": "计算式", items: []};
  35. if (rptTpl[JV.NODE_FORMULAS]) {
  36. for (let cItem of rptTpl[JV.NODE_FORMULAS]) {
  37. let node = {};
  38. me.copyContent(cItem, node);
  39. node[JV.PROP_NAME] = cItem[JV.PROP_NAME];
  40. node[JV.PROP_RUN_TYPE] = cItem[JV.PROP_RUN_TYPE];
  41. node[JV.PROP_EXPRESSION] = cItem[JV.PROP_EXPRESSION];
  42. node["format"] = (cItem["format"])?cItem["format"]:"";
  43. rst.items.push(node);
  44. }
  45. }
  46. return rst;
  47. },
  48. copyContent: function(source, target) {
  49. target[JV.PROP_NAME] = source[JV.PROP_NAME];
  50. target[JV.PROP_RUN_TYPE] = source[JV.PROP_RUN_TYPE];
  51. target[JV.PROP_EXPRESSION] = source[JV.PROP_EXPRESSION];
  52. target["format"] = (source["format"])?source["format"]:"";
  53. },
  54. changeRunType: function (dom) {
  55. let me = calculationTreeOprObj;
  56. if (me.currentNode) {
  57. me.currentNode[JV.PROP_RUN_TYPE] = dom.value;
  58. }
  59. },
  60. setTemplateExpression: function (dom) {
  61. let selIdx = $("#exprTemplatesSelect")[0].selectedIndex;
  62. $("#exprContent")[0].value = expr_templates[selIdx].Expression;
  63. },
  64. changeFormat: function (dom) {
  65. let me = calculationTreeOprObj;
  66. if (me.currentNode) {
  67. me.currentNode["format"] = dom.value;
  68. }
  69. },
  70. changeExpression: function (dom) {
  71. let me = calculationTreeOprObj;
  72. if (me.currentNode) {
  73. me.currentNode[JV.PROP_EXPRESSION] = dom.value;
  74. }
  75. },
  76. onClick: function (event,treeId,treeNode) {
  77. let me = calculationTreeOprObj;
  78. me.currentNode = treeNode;
  79. if (treeNode.level === 0) {
  80. $("#exprDetail")[0].style.display = "none";
  81. } else {
  82. $("#exprDetail")[0].style.display = "";
  83. if (treeNode[JV.PROP_RUN_TYPE] === JV.RUN_TYPE_BEFORE_PAGING) {
  84. $("#exprRunType")[0].selectedIndex = 0;
  85. } else {
  86. $("#exprRunType")[0].selectedIndex = 1;
  87. }
  88. $("#exprFormat")[0].value = (treeNode["format"])?treeNode["format"]:"";
  89. $("#exprContent")[0].value = treeNode[JV.PROP_EXPRESSION];
  90. //
  91. }
  92. },
  93. onBeforeRemove: function(treeId, treeNode){
  94. let rst = false;
  95. if (treeNode.level > 0) {
  96. rst = confirm('请确认是否真的删除?');
  97. }
  98. return rst;
  99. },
  100. beforeRename: function(treeId, treeNode, newName, isCancel) {
  101. if (isCancel) {
  102. return true;
  103. }
  104. if (treeNode.level === 0) {
  105. return false;
  106. }
  107. return true;
  108. },
  109. onBeforeDrop: function (treeId, treeNodes, targetNode, moveType) {
  110. let rst = false;
  111. if (targetNode.level === 1 && (moveType === "next" || moveType === "prev")) {
  112. return true;
  113. }
  114. return rst;
  115. },
  116. addHoverDom: function(treeId, treeNode) {
  117. let me = calculationTreeOprObj, sObj = $("#" + treeNode.tId + "_span");
  118. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length > 0 || treeNode.level > 0) {
  119. return;
  120. } else {
  121. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增' onfocus='this.blur();'></span>";
  122. sObj.after(addStr);
  123. let btn = $("#addBtn_"+treeNode.tId);
  124. btn.bind("click", function(){
  125. let newNodes = [], node = {};
  126. node[JV.PROP_NAME] = "新计算式";
  127. node[JV.PROP_RUN_TYPE] = JV.RUN_TYPE_BEFORE_PAGING;
  128. node[JV.PROP_EXPRESSION] = "";
  129. node["format"] = "";
  130. newNodes.push(node);
  131. me.treeObj.addNodes(treeNode, -1, newNodes, true);
  132. });
  133. }
  134. },
  135. removeHoverDom: function(treeId, treeNode) {
  136. $("#addBtn_"+treeNode.tId).unbind().remove();
  137. },
  138. extractCalculation: function (rptTpl) {
  139. let me = this, newCaclList = [];
  140. let topNode = me.treeObj.getNodes()[0];
  141. for (let node of topNode.items) {
  142. let item = {};
  143. me.copyContent(node, item);
  144. newCaclList.push(item);
  145. }
  146. rptTpl[JV.NODE_FORMULAS] = newCaclList;
  147. }
  148. }