calc_util.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474
  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. HJ: function () {
  80. let me = this;
  81. return me.treeNode.data.baseTotalPrice;
  82. }
  83. };
  84. let analyzer = {
  85. calcTemplate: null,
  86. success: true,
  87. standard: function(expr){
  88. let str = expr;
  89. str = str.replace(/\s/g, ""); // 去空格、去中文空格
  90. str = str.replace(/(/g, "("); // 中文括号"("换成英文括号"("
  91. str = str.replace(/)/g, ")"); // 中文括号")"换成英文括号")"
  92. str = str.replace(/f/g, "F"); // f换成F
  93. return str;
  94. },
  95. analyzeCalcBase: function(expr){
  96. // 前提:必须无空格、无特殊符号
  97. function getCalcBase(expr){
  98. let base = '',
  99. iPos1 = -1, iPos2 = -1;
  100. for (let i = 0; i < expr.length; i++) {
  101. if (expr[i] === '['){
  102. iPos1 = i;
  103. }
  104. else if (iPos1 != -1 && expr[i]===']'){
  105. iPos2 = i;
  106. };
  107. if (iPos1 != -1 && iPos2 != -1){
  108. base = expr.slice(iPos1, iPos2 + 1);
  109. break;
  110. }
  111. };
  112. return base;
  113. };
  114. function calcBaseToIDExpr(base){
  115. /*// for test. 公路模式,基数到ID
  116. let id = -1;
  117. if (base == '[人工费]'){
  118. id = 111;
  119. }
  120. else if (base == '[材料费]'){
  121. id = 222;
  122. }
  123. else if (base == '[机械费]'){
  124. id = 333;
  125. }
  126. else id = "错误";
  127. return "@('" + id + "')";*/
  128. let baseValue = base.slice(1, -1);
  129. return "base('" + baseValue + "')";
  130. };
  131. while (expr.indexOf('[') > 0) {
  132. let base = getCalcBase(expr);
  133. let id = calcBaseToIDExpr(base);
  134. let baseValue = base.slice(1, -1); // []会给下面的正则带来干扰,这里去掉
  135. var pattBase =new RegExp(baseValue, "g");
  136. expr = expr.replace(pattBase, id);
  137. expr = expr.replace(/\[base\('/g, "base('"); // [@(' [base('
  138. expr = expr.replace(/'\)\]/g, "')"); // ')]
  139. };
  140. return expr;
  141. },
  142. analyzeLineRef: function(expr){
  143. let me = this;
  144. function isOperator(char){
  145. var operator = "+-*/()";
  146. return operator.indexOf(char) > -1;
  147. };
  148. function lineNumToID(lineNum){
  149. if (lineNum > me.calcTemplate.calcItems.length){
  150. me.success = false;
  151. return '越界';
  152. }
  153. else{
  154. let id = me.calcTemplate.calcItems[lineNum - 1].ID;
  155. return id;
  156. }
  157. };
  158. // 前提:必须无空格、无特殊符号、标准大写F
  159. function getSection(expr){
  160. let section = '',
  161. iPos1 = -1, iPos2 = -1;
  162. for (let i = 0; i < expr.length; i++) {
  163. if (expr[i] === 'F'){
  164. iPos1 = i;
  165. }
  166. else if (iPos1 != -1 && isOperator(expr[i])){
  167. iPos2 = i;
  168. }
  169. else if (iPos1 != -1 && i == expr.length - 1){
  170. iPos2 = i + 1;
  171. };
  172. if (iPos1 != -1 && iPos2 != -1){
  173. section = expr.slice(iPos1, iPos2);
  174. break;
  175. }
  176. };
  177. return section;
  178. };
  179. function sectionToIDExpr(section){
  180. if (section){
  181. let lineNum = section.slice(1);
  182. if (isNaN(lineNum)){
  183. me.success = false;
  184. return '错误'; // 这里的返回提示不能加上section,因为会无限循环
  185. }
  186. else
  187. return "@('" + lineNumToID(lineNum) + "')";
  188. }
  189. else return '';
  190. };
  191. while (expr.indexOf('F') > 0) {
  192. let sec = getSection(expr);
  193. let id = sectionToIDExpr(sec);
  194. var pattSec =new RegExp(sec, "g");
  195. expr = expr.replace(pattSec, id);
  196. };
  197. return expr;
  198. },
  199. analyzeUserExpr: function(calcTemplate, calcItem){
  200. let me = this;
  201. me.calcTemplate = calcTemplate;
  202. let expr = calcItem.dispExpr;
  203. // 标准化:处理特殊字符、中文符号、大小写
  204. expr = me.standard(expr);
  205. calcItem.dispExpr = expr;
  206. // 先换掉计算基数
  207. expr = me.analyzeCalcBase(expr);
  208. // 再换掉行引用
  209. expr = me.analyzeLineRef(expr);
  210. calcItem.expression = expr;
  211. return me.success;
  212. }
  213. };
  214. class Calculation {
  215. // 先编译公用的基础数据
  216. compilePublics(feeRates, labourCoes, feeTypes, calcBases){
  217. let me = this;
  218. me.compiledFeeRates = {};
  219. me.compiledLabourCoes = {};
  220. me.compiledTemplates = {};
  221. me.compiledFeeTypes = {};
  222. me.compiledFeeTypeNames = [];
  223. me.compiledCalcBases = {};
  224. me.saveForReports = [];
  225. let private_compile_feeRateFile = function() {
  226. if (feeRates) {
  227. for (let rate of feeRates) {
  228. me.compiledFeeRates["feeRate_" + rate.ID] = rate;
  229. }
  230. }
  231. };
  232. let private_compile_labourCoeFile = function() {
  233. if (labourCoes) {
  234. for (let coe of labourCoes) {
  235. me.compiledLabourCoes["LabourCoe_" + coe.ID] = coe;
  236. }
  237. }
  238. };
  239. let private_compile_feeType = function() {
  240. if (feeTypes) {
  241. for (let ft of feeTypes) {
  242. me.compiledFeeTypes[ft.type] = ft.name;
  243. me.compiledFeeTypes[ft.name] = ft.type; // 中文预编译,可靠性有待验证
  244. me.compiledFeeTypeNames.push(ft.name);
  245. }
  246. }
  247. };
  248. let private_compile_calcBase = function() {
  249. if (calcBases) {
  250. for (let cb of calcBases) {
  251. me.compiledCalcBases[cb.dispName] = cb; // 中文预编译,可靠性有待验证
  252. }
  253. }
  254. };
  255. private_compile_feeRateFile();
  256. private_compile_labourCoeFile();
  257. private_compile_feeType();
  258. private_compile_calcBase();
  259. };
  260. compileTemplate(template){
  261. let me = this;
  262. me.compiledTemplates[template.ID] = template;
  263. template.hasCompiled = false;
  264. template.errs = [];
  265. let private_extract_ID = function(str, idx){
  266. let rst = '', lBracket = 0, rBracket = 0, firstIdx = idx, lastIdx = 0;
  267. for (let i = idx; i < str.length; i++) {
  268. if (str[i] === '(') {
  269. lBracket++;
  270. if (lBracket == 1) firstIdx = i + 1;
  271. }
  272. if (str[i] === ')') {
  273. rBracket++;
  274. if (lBracket == rBracket) {
  275. lastIdx = i - 1;
  276. if (lastIdx > firstIdx) {
  277. if (str[firstIdx] === "'") firstIdx++;
  278. if (str[lastIdx] !== "'") lastIdx++;
  279. if (lastIdx > firstIdx) {
  280. rst = str.slice(firstIdx, lastIdx);
  281. }
  282. }
  283. break;
  284. }
  285. }
  286. }
  287. return rst;
  288. };
  289. let private_parse_ref = function(item, itemIdx){
  290. let idx = item.expression.indexOf('@(', 0);
  291. while (idx >= 0) {
  292. let ID = private_extract_ID(item.expression, idx);
  293. if (ID.length > 0) {
  294. let subItem = template.compiledCalcItems[ID];
  295. if (subItem) {
  296. if (subItem.ID !== item.ID) {
  297. private_parse_ref(subItem, template.compiledCalcItems[ID + "_idx"]);
  298. } else {
  299. template.errs.push("There exists the self refer ID: " + ID);
  300. }
  301. } else {
  302. template.errs.push("There exists the invalid ID by which could not find the item: " + ID);
  303. console.log('invalid ID: ' + ID);
  304. }
  305. }
  306. idx = item.expression.indexOf('@(', idx + ID.length + 3);
  307. }
  308. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  309. template.compiledSeq.push(itemIdx);
  310. }
  311. };
  312. let private_setup_seq = function(item, itemIdx){
  313. if (template.compiledSeq.indexOf(itemIdx) < 0) {
  314. private_parse_ref(item, itemIdx);
  315. }
  316. };
  317. let private_compile_items = function() {
  318. for (let idx of template.compiledSeq) {
  319. let item = template.calcItems[idx];
  320. item.dispExprUser = item.dispExpr; // 用于界面显示。disExpr是公式模板,不允许修改:人工系数占位符被修改后变成数值,第二次无法正确替换。
  321. if (item.expression == 'HJ')
  322. item.compiledExpr = '$CE.HJ()'
  323. else{
  324. item.compiledExpr = item.expression.split('@(').join('$CE.at(');
  325. item.compiledExpr = item.compiledExpr.split('base(').join('$CE.base(');
  326. };
  327. if (item.labourCoeID){
  328. let lc = me.compiledLabourCoes["LabourCoe_" + item.labourCoeID].coe;
  329. item.dispExprUser = item.dispExpr.replace(/L/gi, lc.toString());
  330. item.compiledExpr = item.compiledExpr.replace(/L/gi, lc.toString());
  331. };
  332. if (item.feeRateID) {
  333. let orgFeeRate = item.feeRate;
  334. let cmf = me.compiledFeeRates["feeRate_" + item.feeRateID];
  335. item.feeRate = cmf?cmf.rate:100;
  336. if (!orgFeeRate || (orgFeeRate && orgFeeRate != item.feeRate)){
  337. me.saveForReports.push({templatesID: template.ID, calcItem: item});
  338. }
  339. };
  340. // 字段名映射
  341. item.displayFieldName = me.compiledFeeTypes[item.fieldName];
  342. }
  343. };
  344. if (template && template.calcItems && template.calcItems.length > 0) {
  345. template.compiledSeq = [];
  346. template.compiledCalcItems = {};
  347. for (let i = 0; i < template.calcItems.length; i++) {
  348. let item = template.calcItems[i];
  349. template.compiledCalcItems[item.ID] = item;
  350. template.compiledCalcItems[item.ID + "_idx"] = i;
  351. }
  352. for (let i = 0; i < template.calcItems.length; i++) {
  353. private_setup_seq(template.calcItems[i], i);
  354. }
  355. if (template.errs.length == 0) {
  356. private_compile_items();
  357. template.hasCompiled = true;
  358. } else {
  359. console.log('errors: ' + template.errs.toString());
  360. }
  361. };
  362. };
  363. calculate(treeNode){
  364. let me = this;
  365. let templateID = treeNode.data.programID;
  366. if (!templateID) templateID = 1;
  367. let template = me.compiledTemplates[templateID];
  368. treeNode.data.calcTemplate = template;
  369. let project = projectObj.project;
  370. // 缺省计算程序需要提供总金额作为计算基数,然后每条按比例(费率)计算,不需要工料机明细。
  371. if (treeNode.data.baseTotalPrice != undefined){
  372. delete treeNode.data.gljList;
  373. }
  374. else {
  375. if (treeNode.sourceType === project.Ration.getSourceType()) {
  376. treeNode.data.gljList = project.ration_glj.getGljArrByRation(treeNode.data.ID);
  377. }
  378. else if (treeNode.sourceType === project.Bills.getSourceType()) {
  379. let rations = project.Ration.getBillsSortRation(treeNode.source.getID());
  380. treeNode.data.gljList = project.ration_glj.getGatherGljArrByRations(rations);
  381. };
  382. };
  383. if (treeNode && template.hasCompiled) {
  384. let $CE = executeObj;
  385. $CE.treeNode = treeNode;
  386. $CE.template = template;
  387. $CE.calcBase = me.compiledCalcBases;
  388. if (!treeNode.data.fees) {
  389. treeNode.data.fees = [];
  390. treeNode.data.feesIndex = {};
  391. treeNode.changed = true;
  392. };
  393. for (let idx of template.compiledSeq) {
  394. let calcItem = template.calcItems[idx];
  395. let feeRate = calcItem.feeRate;
  396. if (!feeRate) feeRate = 100; // 100%
  397. calcItem.unitFee = round(eval(calcItem.compiledExpr) * feeRate * 0.01); // 如果eval()对清单树有影响,就换成小麦的Expression对象再试
  398. let quantity = treeNode.data.quantity;
  399. if (!quantity) quantity = 0;
  400. calcItem.totalFee = round(calcItem.unitFee * quantity);
  401. // 费用同步到定额
  402. // 引入小麦的字段检测后,快速切换定额出现计算卡顿现象,过多的循环造成。这里把她的代码拆出来,减少微循环。
  403. if (calcItem.fieldName != '') {
  404. if (!treeNode.data.feesIndex[calcItem.fieldName]){
  405. let fee = {
  406. 'fieldName': calcItem.fieldName,
  407. 'unitFee': calcItem.unitFee,
  408. 'totalFee': calcItem.totalFee,
  409. 'tenderUnitFee': 0,
  410. 'tenderTotalFee': 0
  411. };
  412. treeNode.data.fees.push(fee);
  413. treeNode.data.feesIndex[calcItem.fieldName] = fee;
  414. treeNode.changed = true;
  415. }
  416. else{
  417. if (treeNode.data.feesIndex[calcItem.fieldName].unitFee != calcItem.unitFee){
  418. treeNode.data.feesIndex[calcItem.fieldName].unitFee = calcItem.unitFee;
  419. treeNode.changed = true;
  420. };
  421. if (treeNode.data.feesIndex[calcItem.fieldName].totalFee != calcItem.totalFee){
  422. treeNode.data.feesIndex[calcItem.fieldName].totalFee = calcItem.totalFee;
  423. treeNode.changed = true;
  424. };
  425. }
  426. };
  427. };
  428. }
  429. }
  430. };
  431. /*
  432. export default analyzer;*/