calc_util.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449
  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. // 需求说小数位数固定为2位,这里预留缓冲接口,防止以后需求变卦。
  7. const Digit_Calc_Program = -2; // 需求指定计算程序用到的小数位数。
  8. const Digit_Calc_Program_Default = -6; // 需求末指定时默认用到的小数位数。
  9. function round(value, useDef = false) {
  10. let digit = useDef ? Digit_Calc_Program_Default : Digit_Calc_Program;
  11. return scMathUtil.roundTo(value, digit);
  12. };
  13. let executeObj = {
  14. treeNode: null,
  15. template: null,
  16. calcBase: null,
  17. at: function(ID) {
  18. let me = executeObj,
  19. rst = 0;
  20. rst = me.template.compiledCalcItems[ID].unitFee;
  21. rst = parseFloat(rst);
  22. return rst;
  23. },
  24. base: function(calcBaseName) {
  25. let me = executeObj, rst = 0,
  26. //base = getRationCalcBase(calcBaseName);
  27. base = me.calcBase[calcBaseName];
  28. if (base != null) {
  29. let price = 0, aprice = 0, mprice = 0, tmpSum = 0, mdSum = 0;
  30. function isSubset(sub, arr){
  31. // if(!(sub instanceof Array) || !(arr instanceof Array)) return false;
  32. // if(sub.length > arr.length) return false;
  33. for(var i = 0, len = sub.length; i < len; i++){
  34. if(arr.indexOf(sub[i]) == -1) return false;
  35. }
  36. return true;
  37. }
  38. // 机上人工费:多一层
  39. if (isSubset(base.gljTypes, [gljType.MACHINE_LABOUR])) {
  40. for (let glj of me.treeNode.data.gljList) {
  41. if (glj.type == gljType.GENERAL_MACHINE) {
  42. // 获取机械组成物
  43. let mds = projectObj.project.composition.getCompositionByCode(glj.code);
  44. if (!mds) mds = [];
  45. for (let md of mds){
  46. if (base.gljTypes.indexOf(md.glj_type) >= 0) {
  47. price = md["base_price"];
  48. if (!price) price = 0;
  49. mdSum = mdSum + round(md["consumption"] * price);
  50. mdSum = round(mdSum, true);
  51. }
  52. };
  53. tmpSum = tmpSum + round(glj["quantity"] * mdSum, true);
  54. tmpSum = round(tmpSum, true);
  55. }
  56. };
  57. }else{
  58. for (let glj of me.treeNode.data.gljList) {
  59. if (base.gljTypes.indexOf(glj.type) >= 0) {
  60. if (base.calcType == baseCalc){ price = glj["basePrice"];}
  61. else if (base.calcType == adjustCalc){price = glj["adjustPrice"];}
  62. else if (base.calcType == budgetCalc){price = glj["marketPrice"];}
  63. else if (base.calcType == diffCalc){
  64. aprice = glj["adjustPrice"];
  65. if (!aprice) aprice = 0;
  66. mprice = glj["marketPrice"];
  67. if (!mprice) mprice = 0;
  68. price = mprice - aprice;
  69. };
  70. if (!price) price = 0;
  71. tmpSum = round(tmpSum + round(glj["quantity"] * price, true), true);
  72. };
  73. };
  74. };
  75. rst = round(tmpSum);
  76. };
  77. return rst;
  78. }
  79. };
  80. let analyzer = {
  81. calcTemplate: null,
  82. success: true,
  83. standard: function(expr){
  84. let str = expr;
  85. str = str.replace(/\s/g, ""); // 去空格、去中文空格
  86. str = str.replace(/(/g, "("); // 中文括号"("换成英文括号"("
  87. str = str.replace(/)/g, ")"); // 中文括号")"换成英文括号")"
  88. str = str.replace(/f/g, "F"); // f换成F
  89. return str;
  90. },
  91. analyzeCalcBase: function(expr){
  92. // 前提:必须无空格、无特殊符号
  93. function getCalcBase(expr){
  94. let base = '',
  95. iPos1 = -1, iPos2 = -1;
  96. for (let i = 0; i < expr.length; i++) {
  97. if (expr[i] === '['){
  98. iPos1 = i;
  99. }
  100. else if (iPos1 != -1 && expr[i]===']'){
  101. iPos2 = i;
  102. };
  103. if (iPos1 != -1 && iPos2 != -1){
  104. base = expr.slice(iPos1, iPos2 + 1);
  105. break;
  106. }
  107. };
  108. return base;
  109. };
  110. function calcBaseToIDExpr(base){
  111. /*// for test. 公路模式,基数到ID
  112. let id = -1;
  113. if (base == '[人工费]'){
  114. id = 111;
  115. }
  116. else if (base == '[材料费]'){
  117. id = 222;
  118. }
  119. else if (base == '[机械费]'){
  120. id = 333;
  121. }
  122. else id = "错误";
  123. return "@('" + id + "')";*/
  124. let baseValue = base.slice(1, -1);
  125. return "base('" + baseValue + "')";
  126. };
  127. while (expr.indexOf('[') > 0) {
  128. let base = getCalcBase(expr);
  129. let id = calcBaseToIDExpr(base);
  130. let baseValue = base.slice(1, -1); // []会给下面的正则带来干扰,这里去掉
  131. var pattBase =new RegExp(baseValue, "g");
  132. expr = expr.replace(pattBase, id);
  133. expr = expr.replace(/\[base\('/g, "base('"); // [@(' [base('
  134. expr = expr.replace(/'\)\]/g, "')"); // ')]
  135. };
  136. return expr;
  137. },
  138. analyzeLineRef: function(expr){
  139. let me = this;
  140. function isOperator(char){
  141. var operator = "+-*/()";
  142. return operator.indexOf(char) > -1;
  143. };
  144. function lineNumToID(lineNum){
  145. if (lineNum > me.calcTemplate.calcItems.length){
  146. me.success = false;
  147. return '越界';
  148. }
  149. else{
  150. let id = me.calcTemplate.calcItems[lineNum - 1].ID;
  151. return id;
  152. }
  153. };
  154. // 前提:必须无空格、无特殊符号、标准大写F
  155. function getSection(expr){
  156. let section = '',
  157. iPos1 = -1, iPos2 = -1;
  158. for (let i = 0; i < expr.length; i++) {
  159. if (expr[i] === 'F'){
  160. iPos1 = i;
  161. }
  162. else if (iPos1 != -1 && isOperator(expr[i])){
  163. iPos2 = i;
  164. }
  165. else if (iPos1 != -1 && i == expr.length - 1){
  166. iPos2 = i + 1;
  167. };
  168. if (iPos1 != -1 && iPos2 != -1){
  169. section = expr.slice(iPos1, iPos2);
  170. break;
  171. }
  172. };
  173. return section;
  174. };
  175. function sectionToIDExpr(section){
  176. if (section){
  177. let lineNum = section.slice(1);
  178. if (isNaN(lineNum)){
  179. me.success = false;
  180. return '错误'; // 这里的返回提示不能加上section,因为会无限循环
  181. }
  182. else
  183. return "@('" + lineNumToID(lineNum) + "')";
  184. }
  185. else return '';
  186. };
  187. while (expr.indexOf('F') > 0) {
  188. let sec = getSection(expr);
  189. let id = sectionToIDExpr(sec);
  190. var pattSec =new RegExp(sec, "g");
  191. expr = expr.replace(pattSec, id);
  192. };
  193. return expr;
  194. },
  195. analyzeUserExpr: function(calcTemplate, calcItem){
  196. let me = this;
  197. me.calcTemplate = calcTemplate;
  198. let expr = calcItem.dispExpr;
  199. // 标准化:处理特殊字符、中文符号、大小写
  200. expr = me.standard(expr);
  201. calcItem.dispExpr = expr;
  202. // 先换掉计算基数
  203. expr = me.analyzeCalcBase(expr);
  204. // 再换掉行引用
  205. expr = me.analyzeLineRef(expr);
  206. calcItem.expression = expr;
  207. return me.success;
  208. }
  209. };
  210. class Calculation {
  211. // 先编译公用的基础数据
  212. compilePublics(feeRates, labourCoes, feeTypes, calcBases){
  213. let me = this;
  214. me.compiledFeeRates = {};
  215. me.compiledLabourCoes = {};
  216. me.compiledTemplates = {};
  217. me.compiledFeeTypes = {};
  218. me.compiledFeeTypeNames = [];
  219. me.compiledCalcBases = {};
  220. me.saveForReports = [];
  221. let private_compile_feeRateFile = function() {
  222. if (feeRates) {
  223. for (let rate of feeRates) {
  224. me.compiledFeeRates["feeRate_" + rate.ID] = rate;
  225. }
  226. }
  227. };
  228. let private_compile_labourCoeFile = function() {
  229. if (labourCoes) {
  230. for (let coe of labourCoes) {
  231. me.compiledLabourCoes["LabourCoe_" + coe.ID] = coe;
  232. }
  233. }
  234. };
  235. let private_compile_feeType = function() {
  236. if (feeTypes) {
  237. for (let ft of feeTypes) {
  238. me.compiledFeeTypes[ft.type] = ft.name;
  239. me.compiledFeeTypes[ft.name] = ft.type; // 中文预编译,可靠性有待验证
  240. me.compiledFeeTypeNames.push(ft.name);
  241. }
  242. }
  243. };
  244. let private_compile_calcBase = function() {
  245. if (calcBases) {
  246. for (let cb of calcBases) {
  247. me.compiledCalcBases[cb.dispName] = cb; // 中文预编译,可靠性有待验证
  248. }
  249. }
  250. };
  251. private_compile_feeRateFile();
  252. private_compile_labourCoeFile();
  253. private_compile_feeType();
  254. private_compile_calcBase();
  255. };
  256. compileTemplate(template){
  257. let me = this;
  258. me.compiledTemplates[template.ID] = template;
  259. template.hasCompiled = false;
  260. template.errs = [];
  261. let private_extract_ID = function(str, idx){
  262. let rst = '', lBracket = 0, rBracket = 0, firstIdx = idx, lastIdx = 0;
  263. for (let i = idx; i < str.length; i++) {
  264. if (str[i] === '(') {
  265. lBracket++;
  266. if (lBracket == 1) firstIdx = i + 1;
  267. }
  268. if (str[i] === ')') {
  269. rBracket++;
  270. if (lBracket == rBracket) {
  271. lastIdx = i - 1;
  272. if (lastIdx > firstIdx) {
  273. if (str[firstIdx] === "'") firstIdx++;
  274. if (str[lastIdx] !== "'") lastIdx++;
  275. if (lastIdx > firstIdx) {
  276. rst = str.slice(firstIdx, lastIdx);
  277. }
  278. }
  279. break;
  280. }
  281. }
  282. }
  283. return rst;
  284. };
  285. let private_parse_ref = function(item, itemIdx){
  286. let idx = item.expression.indexOf('@(', 0);
  287. while (idx >= 0) {
  288. let ID = private_extract_ID(item.expression, idx);
  289. if (ID.length > 0) {
  290. let subItem = template.compiledCalcItems[ID];
  291. if (subItem) {
  292. if (subItem.ID !== item.ID) {
  293. private_parse_ref(subItem, template.compiledCalcItems[ID + "_idx"]);
  294. } else {
  295. template.errs.push("There exists the self refer ID: " + ID);
  296. }
  297. } else {
  298. template.errs.push("There exists the invalid ID by which could not find the item: " + ID);
  299. console.log('invalid ID: ' + ID);
  300. }
  301. }
  302. idx = item.expression.indexOf('@(', idx + ID.length + 3);
  303. }
  304. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  305. template.compiledSeq.push(itemIdx);
  306. }
  307. };
  308. let private_setup_seq = function(item, itemIdx){
  309. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  310. private_parse_ref(item, itemIdx);
  311. }
  312. };
  313. let private_compile_items = function() {
  314. for (let idx of template.compiledSeq) {
  315. let item = template.calcItems[idx];
  316. item.dispExprUser = item.dispExpr; // 用于界面显示。disExpr是公式模板,不允许修改:人工系数占位符被修改后变成数值,第二次无法正确替换。
  317. item.compiledExpr = item.expression.split('@(').join('$CE.at(');
  318. item.compiledExpr = item.compiledExpr.split('base(').join('$CE.base(');
  319. if (item.labourCoeID){
  320. let lc = me.compiledLabourCoes["LabourCoe_" + item.labourCoeID].coe;
  321. item.dispExprUser = item.dispExpr.replace(/L/gi, lc.toString());
  322. item.compiledExpr = item.compiledExpr.replace(/L/gi, lc.toString());
  323. };
  324. if (item.feeRateID) {
  325. let orgFeeRate = item.feeRate;
  326. let cmf = me.compiledFeeRates["feeRate_" + item.feeRateID];
  327. item.feeRate = cmf?cmf.rate:100;
  328. if (!orgFeeRate || (orgFeeRate && orgFeeRate != item.feeRate)){
  329. me.saveForReports.push({templatesID: template.ID, calcItem: item});
  330. }
  331. };
  332. // 字段名映射
  333. item.displayFieldName = me.compiledFeeTypes[item.fieldName];
  334. }
  335. };
  336. if (template && template.calcItems && template.calcItems.length > 0) {
  337. template.compiledSeq = [];
  338. template.compiledCalcItems = {};
  339. for (let i = 0; i < template.calcItems.length; i++) {
  340. let item = template.calcItems[i];
  341. template.compiledCalcItems[item.ID] = item;
  342. template.compiledCalcItems[item.ID + "_idx"] = i;
  343. }
  344. for (let i = 0; i < template.calcItems.length; i++) {
  345. private_setup_seq(template.calcItems[i], i);
  346. }
  347. if (template.errs.length == 0) {
  348. private_compile_items();
  349. template.hasCompiled = true;
  350. } else {
  351. console.log('errors: ' + template.errs.toString());
  352. }
  353. };
  354. };
  355. calculate($treeNode){
  356. let me = this;
  357. let templateID = $treeNode.data.programID;
  358. if (!templateID) templateID = 1;
  359. let template = me.compiledTemplates[templateID];
  360. $treeNode.data.calcTemplate = template;
  361. if ($treeNode && template.hasCompiled) {
  362. let $CE = executeObj;
  363. $CE.treeNode = $treeNode;
  364. $CE.template = template;
  365. $CE.calcBase = me.compiledCalcBases;
  366. if (!$treeNode.data.fees) {
  367. $treeNode.data.fees = [];
  368. $treeNode.data.feesIndex = {};
  369. $treeNode.changed = true;
  370. };
  371. for (let idx of template.compiledSeq) {
  372. let calcItem = template.calcItems[idx];
  373. let feeRate = calcItem.feeRate;
  374. if (!feeRate) feeRate = 100; // 100%
  375. calcItem.unitFee = round(eval(calcItem.compiledExpr) * feeRate * 0.01); // 如果eval()对清单树有影响,就换成小麦的Expression对象再试
  376. let quantity = $treeNode.data.quantity;
  377. if (!quantity) quantity = 0;
  378. calcItem.totalFee = round(calcItem.unitFee * quantity);
  379. // 费用同步到定额
  380. // 引入小麦的字段检测后,快速切换定额出现计算卡顿现象,过多的循环造成。这里把她的代码拆出来,减少微循环。
  381. if (calcItem.fieldName != '') {
  382. if (!$treeNode.data.feesIndex[calcItem.fieldName]){
  383. let fee = {
  384. 'fieldName': calcItem.fieldName,
  385. 'unitFee': calcItem.unitFee,
  386. 'totalFee': calcItem.totalFee,
  387. 'tenderUnitFee': 0,
  388. 'tenderTotalFee': 0
  389. };
  390. $treeNode.data.fees.push(fee);
  391. $treeNode.data.feesIndex[calcItem.fieldName] = fee;
  392. $treeNode.changed = true;
  393. }
  394. else{
  395. if ($treeNode.data.feesIndex[calcItem.fieldName].unitFee != calcItem.unitFee){
  396. $treeNode.data.feesIndex[calcItem.fieldName].unitFee = calcItem.unitFee;
  397. $treeNode.changed = true;
  398. };
  399. if ($treeNode.data.feesIndex[calcItem.fieldName].totalFee != calcItem.totalFee){
  400. $treeNode.data.feesIndex[calcItem.fieldName].totalFee = calcItem.totalFee;
  401. $treeNode.changed = true;
  402. };
  403. }
  404. };
  405. };
  406. }
  407. }
  408. };
  409. /*
  410. export default analyzer;*/