calc_util.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518
  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, aprice = 0, mprice = 0, tmpSum = 0, mdSum = 0;
  23. function isSubset(sub, arr){
  24. // if(!(sub instanceof Array) || !(arr instanceof Array)) return false;
  25. // if(sub.length > arr.length) return false;
  26. for(var i = 0, len = sub.length; i < len; i++){
  27. if(arr.indexOf(sub[i]) == -1) return false;
  28. }
  29. return true;
  30. }
  31. // 机上人工费:多一层
  32. if (isSubset(base.gljTypes, [gljType.MACHINE_LABOUR])) {
  33. for (let glj of me.treeNode.data.gljList) {
  34. if (glj.type == gljType.GENERAL_MACHINE) {
  35. // 获取机械组成物
  36. let mds = projectObj.project.composition.getCompositionByCode(glj.code);
  37. if (!mds) mds = [];
  38. for (let md of mds){
  39. if (base.gljTypes.indexOf(md.glj_type) >= 0) {
  40. price = md["base_price"];
  41. if (!price) price = 0;
  42. mdSum = mdSum + (md["consumption"] * price).toDecimal(me.digit);
  43. mdSum = (mdSum).toDecimal(me.digitDefault);
  44. }
  45. };
  46. tmpSum = tmpSum + (glj["quantity"] * mdSum).toDecimal(me.digitDefault);
  47. tmpSum = (tmpSum).toDecimal(me.digitDefault);
  48. }
  49. };
  50. }else{
  51. for (let glj of me.treeNode.data.gljList) {
  52. if (base.gljTypes.indexOf(glj.type) >= 0) {
  53. if (base.calcType == baseCalc){ price = glj["basePrice"];}
  54. else if (base.calcType == adjustCalc){price = glj["adjustPrice"];}
  55. else if (base.calcType == budgetCalc){price = glj["marketPrice"];}
  56. else if (base.calcType == diffCalc){
  57. aprice = glj["adjustPrice"];
  58. if (!aprice) aprice = 0;
  59. mprice = glj["marketPrice"];
  60. if (!mprice) mprice = 0;
  61. price = mprice - aprice;
  62. };
  63. if (!price) price = 0;
  64. tmpSum = tmpSum + (glj["quantity"] * price).toDecimal(me.digitDefault);
  65. tmpSum = (tmpSum).toDecimal(me.digitDefault);
  66. };
  67. };
  68. };
  69. rst = (tmpSum).toDecimal(me.digitDefault);
  70. };
  71. return rst;
  72. },
  73. HJ: function () {
  74. let me = this;
  75. return me.treeNode.data.baseTotalPrice;
  76. }
  77. };
  78. let analyzer = {
  79. calcTemplate: null,
  80. success: true,
  81. standard: function(expr){
  82. let str = expr;
  83. str = str.replace(/\s/g, ""); // 去空格、去中文空格
  84. str = str.replace(/(/g, "("); // 中文括号"("换成英文括号"("
  85. str = str.replace(/)/g, ")"); // 中文括号")"换成英文括号")"
  86. str = str.replace(/f/g, "F"); // f换成F
  87. return str;
  88. },
  89. analyzeCalcBase: function(expr){
  90. // 前提:必须无空格、无特殊符号
  91. function getCalcBase(expr){
  92. let base = '',
  93. iPos1 = -1, iPos2 = -1;
  94. for (let i = 0; i < expr.length; i++) {
  95. if (expr[i] === '['){
  96. iPos1 = i;
  97. }
  98. else if (iPos1 != -1 && expr[i]===']'){
  99. iPos2 = i;
  100. };
  101. if (iPos1 != -1 && iPos2 != -1){
  102. base = expr.slice(iPos1, iPos2 + 1);
  103. break;
  104. }
  105. };
  106. return base;
  107. };
  108. function calcBaseToIDExpr(base){
  109. /*// for test. 公路模式,基数到ID
  110. let id = -1;
  111. if (base == '[人工费]'){
  112. id = 111;
  113. }
  114. else if (base == '[材料费]'){
  115. id = 222;
  116. }
  117. else if (base == '[机械费]'){
  118. id = 333;
  119. }
  120. else id = "错误";
  121. return "@('" + id + "')";*/
  122. let baseValue = base.slice(1, -1);
  123. return "base('" + baseValue + "')";
  124. };
  125. while (expr.indexOf('[') > 0) {
  126. let base = getCalcBase(expr);
  127. let id = calcBaseToIDExpr(base);
  128. let baseValue = base.slice(1, -1); // []会给下面的正则带来干扰,这里去掉
  129. var pattBase =new RegExp(baseValue, "g");
  130. expr = expr.replace(pattBase, id);
  131. expr = expr.replace(/\[base\('/g, "base('"); // [@(' [base('
  132. expr = expr.replace(/'\)\]/g, "')"); // ')]
  133. };
  134. return expr;
  135. },
  136. analyzeLineRef: function(expr){
  137. let me = this;
  138. function isOperator(char){
  139. var operator = "+-*/()";
  140. return operator.indexOf(char) > -1;
  141. };
  142. function lineNumToID(lineNum){
  143. if (lineNum > me.calcTemplate.calcItems.length){
  144. me.success = false;
  145. return '越界';
  146. }
  147. else{
  148. let id = me.calcTemplate.calcItems[lineNum - 1].ID;
  149. return id;
  150. }
  151. };
  152. // 前提:必须无空格、无特殊符号、标准大写F
  153. function getSection(expr){
  154. let section = '',
  155. iPos1 = -1, iPos2 = -1;
  156. for (let i = 0; i < expr.length; i++) {
  157. if (expr[i] === 'F'){
  158. iPos1 = i;
  159. }
  160. else if (iPos1 != -1 && isOperator(expr[i])){
  161. iPos2 = i;
  162. }
  163. else if (iPos1 != -1 && i == expr.length - 1){
  164. iPos2 = i + 1;
  165. };
  166. if (iPos1 != -1 && iPos2 != -1){
  167. section = expr.slice(iPos1, iPos2);
  168. break;
  169. }
  170. };
  171. return section;
  172. };
  173. function sectionToIDExpr(section){
  174. if (section){
  175. let lineNum = section.slice(1);
  176. if (isNaN(lineNum)){
  177. me.success = false;
  178. return '错误'; // 这里的返回提示不能加上section,因为会无限循环
  179. }
  180. else
  181. return "@('" + lineNumToID(lineNum) + "')";
  182. }
  183. else return '';
  184. };
  185. while (expr.indexOf('F') > 0) {
  186. let sec = getSection(expr);
  187. let id = sectionToIDExpr(sec);
  188. var pattSec =new RegExp(sec, "g");
  189. expr = expr.replace(pattSec, id);
  190. };
  191. return expr;
  192. },
  193. analyzeUserExpr: function(calcTemplate, calcItem){
  194. let me = this;
  195. me.calcTemplate = calcTemplate;
  196. let expr = calcItem.dispExpr;
  197. // 标准化:处理特殊字符、中文符号、大小写
  198. expr = me.standard(expr);
  199. calcItem.dispExpr = expr;
  200. // 先换掉计算基数
  201. expr = me.analyzeCalcBase(expr);
  202. // 再换掉行引用
  203. expr = me.analyzeLineRef(expr);
  204. calcItem.expression = expr;
  205. return me.success;
  206. }
  207. };
  208. class Calculation {
  209. // 先编译公用的基础数据
  210. compilePublics(feeRates, labourCoes, feeTypes, calcBases){
  211. let me = this;
  212. me.compiledFeeRates = {};
  213. me.compiledLabourCoes = {};
  214. me.compiledTemplates = {};
  215. me.compiledFeeTypes = {};
  216. me.compiledFeeTypeNames = [];
  217. me.compiledCalcBases = {};
  218. me.saveForReports = [];
  219. me.digit = 2;
  220. me.digitDefault = 6;
  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. if (item.expression == 'HJ')
  318. item.compiledExpr = '$CE.HJ()'
  319. else{
  320. item.compiledExpr = item.expression.split('@(').join('$CE.at(');
  321. item.compiledExpr = item.compiledExpr.split('base(').join('$CE.base(');
  322. };
  323. if (item.labourCoeID){
  324. let lc = me.compiledLabourCoes["LabourCoe_" + item.labourCoeID].coe;
  325. item.dispExprUser = item.dispExpr.replace(/L/gi, lc.toString());
  326. item.compiledExpr = item.compiledExpr.replace(/L/gi, lc.toString());
  327. };
  328. if (item.feeRateID) {
  329. let orgFeeRate = item.feeRate;
  330. let cmf = me.compiledFeeRates["feeRate_" + item.feeRateID];
  331. item.feeRate = cmf?cmf.rate:100;
  332. if (!orgFeeRate || (orgFeeRate && orgFeeRate != item.feeRate)){
  333. me.saveForReports.push({templatesID: template.ID, calcItem: item});
  334. }
  335. };
  336. // 字段名映射
  337. item.displayFieldName = me.compiledFeeTypes[item.fieldName];
  338. }
  339. };
  340. if (template && template.calcItems && template.calcItems.length > 0) {
  341. template.compiledSeq = [];
  342. template.compiledCalcItems = {};
  343. for (let i = 0; i < template.calcItems.length; i++) {
  344. let item = template.calcItems[i];
  345. template.compiledCalcItems[item.ID] = item;
  346. template.compiledCalcItems[item.ID + "_idx"] = i;
  347. }
  348. for (let i = 0; i < template.calcItems.length; i++) {
  349. private_setup_seq(template.calcItems[i], i);
  350. }
  351. if (template.errs.length == 0) {
  352. private_compile_items();
  353. template.hasCompiled = true;
  354. } else {
  355. console.log('errors: ' + template.errs.toString());
  356. }
  357. };
  358. };
  359. initFees(treeNode){
  360. if (!treeNode.data.fees) {
  361. treeNode.data.fees = [];
  362. treeNode.data.feesIndex = {};
  363. treeNode.changed = true;
  364. };
  365. };
  366. checkFee(treeNode, feeObj){
  367. if (feeObj.fieldName == '') return;
  368. if (!treeNode.data.feesIndex[feeObj.fieldName]){
  369. let fee = {
  370. 'fieldName': feeObj.fieldName,
  371. 'unitFee': feeObj.unitFee,
  372. 'totalFee': feeObj.totalFee,
  373. 'tenderUnitFee': 0,
  374. 'tenderTotalFee': 0
  375. };
  376. treeNode.data.fees.push(fee);
  377. treeNode.data.feesIndex[feeObj.fieldName] = fee;
  378. treeNode.changed = true;
  379. }
  380. else{
  381. if (treeNode.data.feesIndex[feeObj.fieldName].unitFee != feeObj.unitFee){
  382. treeNode.data.feesIndex[feeObj.fieldName].unitFee = feeObj.unitFee;
  383. treeNode.changed = true;
  384. };
  385. if (treeNode.data.feesIndex[feeObj.fieldName].totalFee != feeObj.totalFee){
  386. treeNode.data.feesIndex[feeObj.fieldName].totalFee = feeObj.totalFee;
  387. treeNode.changed = true;
  388. };
  389. };
  390. };
  391. calculate(treeNode){
  392. let me = this;
  393. let project = projectObj.project;
  394. // 汇总定额或子清单的费用类别
  395. if (treeNode.data.gatherType != undefined){
  396. if (treeNode.sourceType != project.Bills.getSourceType()) return;
  397. me.initFees(treeNode);
  398. let objsArr = (treeNode.data.gatherType === CP_GatherType.rations) ? project.Ration.getRationsByNode(treeNode) : treeNode.children;
  399. let rst = [];
  400. for (let ft of feeType) {
  401. let ftObj = {};
  402. ftObj.fieldName = ft.type;
  403. ftObj.name = ft.name;
  404. let uf = 0, tf = 0, tuf = 0, ttf = 0;
  405. for (let item of objsArr) {
  406. let data = (treeNode.data.gatherType === CP_GatherType.rations) ? item : item.data;
  407. if (data.feesIndex && data.feesIndex[ft.type]) {
  408. uf = (uf + parseFloat(data.feesIndex[ft.type].unitFee)).toDecimal(me.digitDefault);
  409. tf = (tf + parseFloat(data.feesIndex[ft.type].totalFee)).toDecimal(me.digitDefault);
  410. tuf = (tuf + parseFloat(data.feesIndex[ft.type].tenderUnitFee)).toDecimal(me.digitDefault);
  411. ttf = (ttf + parseFloat(data.feesIndex[ft.type].tenderTotalFee)).toDecimal(me.digitDefault);
  412. };
  413. };
  414. ftObj.unitFee = uf.toDecimal(me.digit);
  415. ftObj.totalFee = tf.toDecimal(me.digit);
  416. ftObj.tenderUnitFee = tuf.toDecimal(me.digit);
  417. ftObj.tenderTotalFee = ttf.toDecimal(me.digit);
  418. me.checkFee(treeNode, ftObj);
  419. rst.push(ftObj);
  420. };
  421. treeNode.data.calcTemplate = {"calcItems": rst};
  422. }
  423. else{
  424. // 叶子清单的缺省计算程序需要提供总金额作为计算基数(不需要工料机),然后每条按比例(费率)计算,不需要工料机明细。
  425. if (treeNode.data.baseTotalPrice != undefined){
  426. if (treeNode.sourceType != project.Bills.getSourceType()) return;
  427. delete treeNode.data.gljList;
  428. if (treeNode.data.programID == undefined){
  429. treeNode.data.programID = defaultBillTemplate.ID;
  430. };
  431. }
  432. else {
  433. if (treeNode.sourceType === project.Ration.getSourceType()) {
  434. treeNode.data.gljList = project.ration_glj.getGljArrByRation(treeNode.data.ID);
  435. }
  436. else if (treeNode.sourceType === project.Bills.getSourceType()) {
  437. let rations = project.Ration.getBillsSortRation(treeNode.source.getID());
  438. treeNode.data.gljList = project.ration_glj.getGatherGljArrByRations(rations);
  439. };
  440. if (treeNode.data.programID == undefined){
  441. treeNode.data.programID = 1;
  442. };
  443. };
  444. let template = me.compiledTemplates[treeNode.data.programID];
  445. treeNode.data.calcTemplate = template;
  446. if (treeNode && template.hasCompiled) {
  447. let $CE = executeObj;
  448. $CE.treeNode = treeNode;
  449. $CE.template = template;
  450. $CE.calcBase = me.compiledCalcBases;
  451. me.initFees(treeNode);
  452. for (let idx of template.compiledSeq) {
  453. let calcItem = template.calcItems[idx];
  454. let feeRate = calcItem.feeRate;
  455. if (!feeRate) feeRate = 100; // 100%
  456. calcItem.unitFee = (eval(calcItem.compiledExpr) * feeRate * 0.01).toDecimal(me.digit); // 如果eval()对清单树有影响,就换成小麦的Expression对象再试
  457. let quantity = treeNode.data.quantity;
  458. if (!quantity) quantity = 0;
  459. calcItem.totalFee = (calcItem.unitFee * quantity).toDecimal(me.digit);
  460. me.checkFee(treeNode, calcItem);
  461. };
  462. }
  463. };
  464. }
  465. };
  466. /*
  467. export default analyzer;*/