rpt_tpl_calculation.js 6.2 KB

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