calc_util.js 15 KB

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