calc_util.js 16 KB

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