calc_util.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366
  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. calcTemplate: null,
  40. standard: function(expr){
  41. let str = expr;
  42. str = str.replace(/\s/g, ""); // 去空格、去中文空格
  43. str = str.replace(/(/g, "("); // 中文括号"("换成英文括号"("
  44. str = str.replace(/)/g, ")"); // 中文括号")"换成英文括号")"
  45. str = str.replace(/f/g, "F"); // f换成F
  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 = "错误";
  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(calcTemplate, calcItem){
  142. this.calcTemplate = calcTemplate;
  143. let expr = calcItem.dispExpr;
  144. // 标准化:处理特殊字符、中文符号、大小写
  145. expr = this.standard(expr);
  146. calcItem.dispExpr = expr;
  147. // 先换掉计算基数
  148. expr = this.analyzeCalcBase(expr);
  149. // 再换掉行引用
  150. expr = this.analyzeLineRef(expr);
  151. calcItem.expression = expr;
  152. }
  153. };
  154. class Calculation {
  155. // 先编译公用的基础数据
  156. compilePublics(feeRates, labourCoes, feeTypes, calcBases){
  157. let me = this;
  158. let private_compile_feeRateFile = function() {
  159. if (feeRates) {
  160. me.compiledFeeRates = {};
  161. for (let rate of feeRates) {
  162. me.compiledFeeRates["feeRate_" + rate.ID] = rate;
  163. }
  164. }
  165. };
  166. let private_compile_labourCoeFile = function() {
  167. if (labourCoes) {
  168. me.compiledLabourCoes = {};
  169. for (let coe of labourCoes) {
  170. me.compiledLabourCoes["LabourCoe_" + coe.ID] = coe;
  171. }
  172. }
  173. };
  174. let private_compile_feeType = function() {
  175. if (feeTypes) {
  176. me.compiledFeeTypes = {};
  177. for (let ft of feeTypes) {
  178. me.compiledFeeTypes[ft.type] = ft.name;
  179. me.compiledFeeTypes[ft.name] = ft.type; // 中文预编译,可靠性有待验证
  180. }
  181. }
  182. };
  183. let private_compile_calcBase = function() {
  184. if (calcBases) {
  185. me.compiledCalcBases = {};
  186. for (let cb of calcBases) {
  187. me.compiledCalcBases[cb.dispName] = cb; // 中文预编译,可靠性有待验证
  188. }
  189. }
  190. };
  191. private_compile_feeRateFile();
  192. private_compile_labourCoeFile();
  193. private_compile_feeType();
  194. private_compile_calcBase();
  195. me.compiledTemplates = {};
  196. };
  197. compileTemplate(template){
  198. let me = this;
  199. me.compiledTemplates[template.ID] = template;
  200. template.hasCompiled = false;
  201. template.errs = [];
  202. let private_extract_ID = function(str, idx){
  203. let rst = '', lBracket = 0, rBracket = 0, firstIdx = idx, lastIdx = 0;
  204. for (let i = idx; i < str.length; i++) {
  205. if (str[i] === '(') {
  206. lBracket++;
  207. if (lBracket == 1) firstIdx = i + 1;
  208. }
  209. if (str[i] === ')') {
  210. rBracket++;
  211. if (lBracket == rBracket) {
  212. lastIdx = i - 1;
  213. if (lastIdx > firstIdx) {
  214. if (str[firstIdx] === "'") firstIdx++;
  215. if (str[lastIdx] !== "'") lastIdx++;
  216. if (lastIdx > firstIdx) {
  217. rst = str.slice(firstIdx, lastIdx);
  218. }
  219. }
  220. break;
  221. }
  222. }
  223. }
  224. return rst;
  225. };
  226. let private_parse_ref = function(item, itemIdx){
  227. let idx = item.expression.indexOf('@(', 0);
  228. while (idx >= 0) {
  229. let ID = private_extract_ID(item.expression, idx);
  230. if (ID.length > 0) {
  231. let subItem = template.compiledCalcItems[ID];
  232. if (subItem) {
  233. if (subItem.ID !== item.ID) {
  234. private_parse_ref(subItem, template.compiledCalcItems[ID + "_idx"]);
  235. } else {
  236. template.errs.push("There exists the self refer ID: " + ID);
  237. }
  238. } else {
  239. template.errs.push("There exists the invalid ID by which could not find the item: " + ID);
  240. console.log('invalid ID: ' + ID);
  241. }
  242. }
  243. idx = item.expression.indexOf('@(', idx + ID.length + 3);
  244. }
  245. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  246. template.compiledSeq.push(itemIdx);
  247. }
  248. };
  249. let private_setup_seq = function(item, itemIdx){
  250. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  251. private_parse_ref(item, itemIdx);
  252. }
  253. };
  254. let private_compile_items = function() {
  255. for (let idx of template.compiledSeq) {
  256. let item = template.calcItems[idx];
  257. item.compiledExpr = item.expression.split('@(').join('$CE.at(');
  258. item.compiledExpr = item.compiledExpr.split('base(').join('$CE.base(');
  259. if (item.labourCoeID){
  260. let lc = me.compiledLabourCoes["LabourCoe_" + item.labourCoeID].coe;
  261. item.dispExpr = item.dispExpr.replace(/L/gi, lc.toString());
  262. item.compiledExpr = item.compiledExpr.replace(/L/gi, lc.toString());
  263. };
  264. if (item.feeRateID) {
  265. item.feeRate = me.compiledFeeRates["feeRate_" + item.feeRateID].rate;
  266. };
  267. // 字段名映射
  268. item.displayFieldName = me.compiledFeeTypes[item.fieldName];
  269. }
  270. };
  271. if (template && template.calcItems && template.calcItems.length > 0) {
  272. template.compiledSeq = [];
  273. template.compiledCalcItems = {};
  274. for (let i = 0; i < template.calcItems.length; i++) {
  275. let item = template.calcItems[i];
  276. template.compiledCalcItems[item.ID] = item;
  277. template.compiledCalcItems[item.ID + "_idx"] = i;
  278. }
  279. for (let i = 0; i < template.calcItems.length; i++) {
  280. private_setup_seq(template.calcItems[i], i);
  281. }
  282. if (template.errs.length == 0) {
  283. private_compile_items();
  284. template.hasCompiled = true;
  285. } else {
  286. console.log('errors: ' + template.errs.toString());
  287. }
  288. };
  289. };
  290. calculate($treeNode){
  291. let me = this;
  292. let templateID = $treeNode.data.calcTemplateID;
  293. if (!templateID) templateID = 1;
  294. let template = me.compiledTemplates[templateID];
  295. $treeNode.data.calcTemplate = template;
  296. if ($treeNode && template.hasCompiled) {
  297. let $CE = executeObj;
  298. $CE.treeNode = $treeNode;
  299. $CE.template = template;
  300. $CE.calcBase = me.compiledCalcBases;
  301. if (!$treeNode.fees) {
  302. $treeNode.fees = [];
  303. $treeNode.feesIndex = {};
  304. };
  305. for (let idx of template.compiledSeq) {
  306. let calcItem = template.calcItems[idx];
  307. let feeRate = calcItem.feeRate;
  308. if (!feeRate) feeRate = 100; // 100%
  309. calcItem.unitFee = eval(calcItem.compiledExpr) * feeRate * 0.01; // 如果eval()对清单树有影响,就换成小麦的Expression对象再试
  310. let quantity = $treeNode.data.quantity;
  311. if (!quantity) quantity = 0;
  312. calcItem.totalFee = calcItem.unitFee * quantity;
  313. // 费用同步到定额
  314. // 引入小麦的字段检测后,快速切换定额出现计算卡顿现象,过多的循环造成。这里把她的代码拆出来,减少微循环。
  315. if (!$treeNode.feesIndex[calcItem.fieldName]){
  316. let fee = {
  317. 'fieldName': calcItem.fieldName,
  318. 'unitFee': calcItem.unitFee,
  319. 'totalFee': calcItem.totalFee,
  320. 'tenderUnitFee': 0,
  321. 'tenderTotalFee': 0
  322. };
  323. $treeNode.fees.push(fee);
  324. $treeNode.feesIndex[calcItem.fieldName] = fee;
  325. }
  326. else{
  327. $treeNode.feesIndex[calcItem.fieldName].unitFee = calcItem.unitFee;
  328. $treeNode.feesIndex[calcItem.fieldName].totalFee = calcItem.totalFee;
  329. }
  330. }
  331. }
  332. }
  333. };
  334. //export default analyzer;