calc_util.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362
  1. /**
  2. * Created by Tony on 2017/6/21.
  3. * Modified by CSL, 2017-08-01 引入多套计算程序、费率同步、人工系数同步、改进基数计算、费字段映射等。
  4. * added by CSL, 2017-09-01 增加公式解析对象analyzer,用于解析用户修改公式、自定义表达式。
  5. */
  6. let executeObj = {
  7. treeNode: null,
  8. template: null,
  9. calcBase: null,
  10. at: function(ID) {
  11. let me = executeObj,
  12. rst = 0;
  13. rst = me.template.compiledCalcItems[ID].unitFee;
  14. rst = parseFloat(rst);
  15. return rst;
  16. },
  17. base: function(calcBaseName) {
  18. let me = executeObj, rst = 0,
  19. //base = getRationCalcBase(calcBaseName);
  20. base = me.calcBase[calcBaseName];
  21. if (base != null) {
  22. let price = 0, tmpSum = 0;
  23. for (let glj of me.treeNode.data.gljList) {
  24. if (base.gljTypes.indexOf(glj.type) >= 0) {
  25. if (base.calcType == baseCalc){ price = glj["basePrice"];}
  26. else if (base.calcType == adjustCalc){price = glj["adjustPrice"];}
  27. else if (base.calcType == budgetCalc){price = glj["marketPrice"];}
  28. else if (base.calcType == diffCalc){price = glj["marketPrice"] - glj["adjustPrice"];};
  29. };
  30. tmpSum = tmpSum + glj["quantity"] * price;
  31. glj = null;
  32. };
  33. rst = tmpSum;
  34. };
  35. return rst;
  36. }
  37. };
  38. let analyzer = {
  39. standard: function(expr){
  40. let str = expr;
  41. str = str.replace(/\s/g, ""); // 去空格、去中文空格
  42. str = str.replace(/(/g, "("); // 中文括号"("换成英文括号"("
  43. str = str.replace(/)/g, ")"); // 中文括号")"换成英文括号")"
  44. str = str.replace(/f/g, "F"); // f换成F
  45. console.log(str);
  46. return str;
  47. },
  48. analyzeCalcBase: function(expr){
  49. // 前提:必须无空格、无特殊符号
  50. function getCalcBase(expr){
  51. let base = '',
  52. iPos1 = -1, iPos2 = -1;
  53. for (let i = 0; i < expr.length; i++) {
  54. if (expr[i] === '['){
  55. iPos1 = i;
  56. }
  57. else if (iPos1 != -1 && expr[i]===']'){
  58. iPos2 = i;
  59. };
  60. if (iPos1 != -1 && iPos2 != -1){
  61. base = expr.slice(iPos1, iPos2 + 1);
  62. break;
  63. }
  64. };
  65. return base;
  66. };
  67. function calcBaseToIDExpr(base){
  68. // for test.
  69. let id = -1;
  70. if (base == '[人工费]'){
  71. id = 111;
  72. }
  73. else if (base == '[材料费]'){
  74. id = 222;
  75. }
  76. else if (base == '[机械费]'){
  77. id = 333;
  78. }
  79. else id = 999;
  80. return "@('" + id + "')";
  81. };
  82. while (expr.indexOf('[') > 0) {
  83. let base = getCalcBase(expr);
  84. let id = calcBaseToIDExpr(base);
  85. let baseValue = base.slice(1, -1); // []会给下面的正则带来干扰,这里去掉
  86. var pattBase =new RegExp(baseValue, "g");
  87. expr = expr.replace(pattBase, id);
  88. expr = expr.replace(/\[@\('/g, "@('"); // [@('
  89. expr = expr.replace(/'\)\]/g, "')"); // ')]
  90. };
  91. return expr;
  92. },
  93. analyzeLineRef: function(expr){
  94. function isOperator(char){
  95. var operator = "+-*/()";
  96. return operator.indexOf(char) > -1;
  97. };
  98. function codeToID(code){
  99. return eval(parseFloat(code)+1);
  100. };
  101. // 前提:必须无空格、无特殊符号、标准大写F
  102. function getSection(expr){
  103. let section = '',
  104. iPos1 = -1, iPos2 = -1;
  105. for (let i = 0; i < expr.length; i++) {
  106. if (expr[i] === 'F'){
  107. iPos1 = i;
  108. }
  109. else if (iPos1 != -1 && isOperator(expr[i])){
  110. iPos2 = i;
  111. }
  112. else if (iPos1 != -1 && i == expr.length - 1){
  113. iPos2 = i + 1;
  114. };
  115. if (iPos1 != -1 && iPos2 != -1){
  116. section = expr.slice(iPos1, iPos2);
  117. break;
  118. }
  119. };
  120. return section;
  121. };
  122. function sectionToIDExpr(section){
  123. if (section){
  124. let code = section.slice(1);
  125. if (isNaN(code)){
  126. return '错误' // 这里的返回提示不能加上section,因为会无限循环
  127. }
  128. else
  129. return "@('" + codeToID(code) + "')";
  130. }
  131. else return '';
  132. };
  133. while (expr.indexOf('F') > 0) {
  134. let sec = getSection(expr);
  135. let id = sectionToIDExpr(sec);
  136. var pattSec =new RegExp(sec, "g");
  137. expr = expr.replace(pattSec, id);
  138. };
  139. return expr;
  140. },
  141. analyzeUserExpr: function(expr){
  142. // 标准化:处理特殊字符、中文符号、大小写
  143. expr = this.standard(expr);
  144. // 先换掉计算基数
  145. expr = this.analyzeCalcBase(expr);
  146. // 再换掉行引用
  147. expr = this.analyzeLineRef(expr);
  148. return expr;
  149. }
  150. };
  151. class Calculation {
  152. // 先编译公用的基础数据
  153. compilePublics(feeRates, labourCoes, feeTypes, calcBases){
  154. let me = this;
  155. let private_compile_feeRateFile = function() {
  156. if (feeRates) {
  157. me.compiledFeeRates = {};
  158. for (let rate of feeRates) {
  159. me.compiledFeeRates["feeRate_" + rate.ID] = rate;
  160. }
  161. }
  162. };
  163. let private_compile_labourCoeFile = function() {
  164. if (labourCoes) {
  165. me.compiledLabourCoes = {};
  166. for (let coe of labourCoes) {
  167. me.compiledLabourCoes["LabourCoe_" + coe.ID] = coe;
  168. }
  169. }
  170. };
  171. let private_compile_feeType = function() {
  172. if (feeTypes) {
  173. me.compiledFeeTypes = {};
  174. for (let ft of feeTypes) {
  175. me.compiledFeeTypes[ft.type] = ft.name;
  176. me.compiledFeeTypes[ft.name] = ft.type; // 中文预编译,可靠性有待验证
  177. }
  178. }
  179. };
  180. let private_compile_calcBase = function() {
  181. if (calcBases) {
  182. me.compiledCalcBases = {};
  183. for (let cb of calcBases) {
  184. me.compiledCalcBases[cb.dispName] = cb; // 中文预编译,可靠性有待验证
  185. }
  186. }
  187. };
  188. private_compile_feeRateFile();
  189. private_compile_labourCoeFile();
  190. private_compile_feeType();
  191. private_compile_calcBase();
  192. me.compiledTemplates = {};
  193. };
  194. compileTemplate(template){
  195. let me = this;
  196. me.compiledTemplates[template.ID] = template;
  197. template.hasCompiled = false;
  198. template.errs = [];
  199. let private_extract_ID = function(str, idx){
  200. let rst = '', lBracket = 0, rBracket = 0, firstIdx = idx, lastIdx = 0;
  201. for (let i = idx; i < str.length; i++) {
  202. if (str[i] === '(') {
  203. lBracket++;
  204. if (lBracket == 1) firstIdx = i + 1;
  205. }
  206. if (str[i] === ')') {
  207. rBracket++;
  208. if (lBracket == rBracket) {
  209. lastIdx = i - 1;
  210. if (lastIdx > firstIdx) {
  211. if (str[firstIdx] === "'") firstIdx++;
  212. if (str[lastIdx] !== "'") lastIdx++;
  213. if (lastIdx > firstIdx) {
  214. rst = str.slice(firstIdx, lastIdx);
  215. }
  216. }
  217. break;
  218. }
  219. }
  220. }
  221. return rst;
  222. };
  223. let private_parse_ref = function(item, itemIdx){
  224. let idx = item.expression.indexOf('@(', 0);
  225. while (idx >= 0) {
  226. let ID = private_extract_ID(item.expression, idx);
  227. if (ID.length > 0) {
  228. let subItem = template.compiledCalcItems[ID];
  229. if (subItem) {
  230. if (subItem.ID !== item.ID) {
  231. private_parse_ref(subItem, template.compiledCalcItems[ID + "_idx"]);
  232. } else {
  233. template.errs.push("There exists the self refer ID: " + ID);
  234. }
  235. } else {
  236. template.errs.push("There exists the invalid ID by which could not find the item: " + ID);
  237. console.log('invalid ID: ' + ID);
  238. }
  239. }
  240. idx = item.expression.indexOf('@(', idx + ID.length + 3);
  241. }
  242. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  243. template.compiledSeq.push(itemIdx);
  244. }
  245. };
  246. let private_setup_seq = function(item, itemIdx){
  247. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  248. private_parse_ref(item, itemIdx);
  249. }
  250. };
  251. let private_compile_items = function() {
  252. for (let idx of template.compiledSeq) {
  253. let item = template.calcItems[idx];
  254. item.compiledExpr = item.expression.split('@(').join('$CE.at(');
  255. item.compiledExpr = item.compiledExpr.split('base(').join('$CE.base(');
  256. if (item.labourCoeID){
  257. let lc = me.compiledLabourCoes["LabourCoe_" + item.labourCoeID].coe;
  258. item.dispExpr = item.dispExpr.replace(/L/gi, lc.toString());
  259. item.compiledExpr = item.compiledExpr.replace(/L/gi, lc.toString());
  260. };
  261. if (item.feeRateID) {
  262. item.feeRate = me.compiledFeeRates["feeRate_" + item.feeRateID].rate;
  263. };
  264. // 字段名映射
  265. item.displayFieldName = me.compiledFeeTypes[item.fieldName];
  266. }
  267. };
  268. if (template && template.calcItems && template.calcItems.length > 0) {
  269. template.compiledSeq = [];
  270. template.compiledCalcItems = {};
  271. for (let i = 0; i < template.calcItems.length; i++) {
  272. let item = template.calcItems[i];
  273. template.compiledCalcItems[item.ID] = item;
  274. template.compiledCalcItems[item.ID + "_idx"] = i;
  275. }
  276. for (let i = 0; i < template.calcItems.length; i++) {
  277. private_setup_seq(template.calcItems[i], i);
  278. }
  279. if (template.errs.length == 0) {
  280. private_compile_items();
  281. template.hasCompiled = true;
  282. } else {
  283. console.log('errors: ' + template.errs.toString());
  284. }
  285. };
  286. };
  287. calculate($treeNode){
  288. let me = this;
  289. let templateID = $treeNode.data.calcTemplateID;
  290. if (!templateID) templateID = 1;
  291. let template = me.compiledTemplates[templateID];
  292. $treeNode.data.calcTemplate = template;
  293. if ($treeNode && template.hasCompiled) {
  294. let $CE = executeObj;
  295. $CE.treeNode = $treeNode;
  296. $CE.template = template;
  297. $CE.calcBase = me.compiledCalcBases;
  298. if (!$treeNode.fees) {
  299. $treeNode.fees = [];
  300. $treeNode.feesIndex = {};
  301. };
  302. for (let idx of template.compiledSeq) {
  303. let calcItem = template.calcItems[idx];
  304. let feeRate = calcItem.feeRate;
  305. if (!feeRate) feeRate = 100; // 100%
  306. calcItem.unitFee = eval(calcItem.compiledExpr) * feeRate * 0.01; // 如果eval()对清单树有影响,就换成小麦的Expression对象再试
  307. let quantity = $treeNode.data.quantity;
  308. if (!quantity) quantity = 0;
  309. calcItem.totalFee = calcItem.unitFee * quantity;
  310. // 费用同步到定额
  311. // 引入小麦的字段检测后,快速切换定额出现计算卡顿现象,过多的循环造成。这里把她的代码拆出来,减少微循环。
  312. if (!$treeNode.feesIndex[calcItem.fieldName]){
  313. let fee = {
  314. 'fieldName': calcItem.fieldName,
  315. 'unitFee': calcItem.unitFee,
  316. 'totalFee': calcItem.totalFee,
  317. 'tenderUnitFee': 0,
  318. 'tenderTotalFee': 0
  319. };
  320. $treeNode.fees.push(fee);
  321. $treeNode.feesIndex[calcItem.fieldName] = fee;
  322. }
  323. else{
  324. $treeNode.feesIndex[calcItem.fieldName].unitFee = calcItem.unitFee;
  325. $treeNode.feesIndex[calcItem.fieldName].totalFee = calcItem.totalFee;
  326. }
  327. }
  328. }
  329. }
  330. };
  331. export default analyzer;