quantity_detail.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450
  1. /**
  2. * Created by Mai on 2017/4/1.
  3. */
  4. var quantity_detail = {
  5. createNew: function (project) {
  6. // 用户定义private方法
  7. var tools = {};
  8. // 所有通过this访问的属性,都不应在此单元外部进行写入操作
  9. var quantity_detail = function (proj) {
  10. this.gljTree = cacheTree.createNew(this);
  11. // this.project = proj;
  12. this.datas = [];
  13. var sourceType = ModuleNames.quantity_detail;
  14. this.getSourceType = function () {
  15. return sourceType;
  16. }
  17. proj.registerModule(ModuleNames.quantity_detail, this);
  18. this.temList=[];
  19. };
  20. // prototype用于定义public方法
  21. quantity_detail.prototype.loadData = function (datas) {
  22. this.datas = datas;
  23. };
  24. // 提交数据后返回数据处理
  25. quantity_detail.prototype.doAfterUpdate = function(err, data){
  26. if(!err){
  27. if(data.updateTpye=='ut_update'){
  28. this.refreshAfterUpdate(data);
  29. }else if(data.updateTpye=='ut_delete'){
  30. this.refreshAfterDelete(data);
  31. } else {
  32. this.refreshAfterSave(data);
  33. }
  34. }else {
  35. alert(err.message);
  36. this.refreshSheetData();
  37. }
  38. };
  39. quantity_detail.prototype.refreshAfterSave=function(data){
  40. console.log(data);
  41. var me = this;
  42. if(data.hasOwnProperty('resort')){
  43. this.resortData(data.doc,1);
  44. _.forEach(data.update_task,function (item) {
  45. me.refreshEachItme(item.query,item.doc);
  46. })
  47. gljOprObj.detailData.push(data.doc);
  48. this.datas.push(data.doc);
  49. }else {
  50. this.datas.push(data);
  51. gljOprObj.detailData.push(data);
  52. }
  53. gljOprObj.detailData=_.sortBy(gljOprObj.detailData,'seq');
  54. this.refreshSheetData();
  55. };
  56. quantity_detail.prototype.resortData=function(data,req){
  57. for(var i =0;i<gljOprObj.detailData.length;i++){
  58. var item = gljOprObj.detailData[i];
  59. if(item.seq>=data.seq){
  60. item.seq=item.seq+req;
  61. }
  62. }
  63. };
  64. quantity_detail.prototype.refreshAfterUpdate=function(data){
  65. var me = this;
  66. var filter_object;
  67. if(data.hasOwnProperty('refreshList')){
  68. _.forEach(data.refreshList,function (item) {
  69. filter_object= me.refreshEachItme(item.query,item.doc);
  70. })
  71. }else {
  72. filter_object = me.refreshEachItme(data.query,data.doc);
  73. }
  74. var showList = _.filter(this.datas,filter_object);
  75. gljOprObj.detailData=showList;
  76. gljOprObj.detailData=_.sortBy(gljOprObj.detailData,'seq');
  77. this.refreshSheetData();
  78. };
  79. quantity_detail.prototype.refreshEachItme = function(query,doc){
  80. var detail_list = this.datas;
  81. var detail_index= _.findIndex(detail_list,function(detail){
  82. return detail.ID==query.ID;
  83. })
  84. _.forEach(doc, function(n, key) {
  85. detail_list[detail_index][key] = n;
  86. });
  87. var filter_object;
  88. if(detail_list[detail_index].hasOwnProperty('rationID')){
  89. filter_object={'rationID':detail_list[detail_index].rationID};
  90. }else {
  91. filter_object={'billID':detail_list[detail_index].billID};
  92. }
  93. return filter_object;
  94. };
  95. quantity_detail.prototype.refreshAfterDelete=function(data){
  96. var me = this;
  97. if(data.doc.seq != gljOprObj.detailData.length - 1){
  98. this.resortData(data.doc,-1);
  99. }
  100. _.forEach(data.update_task,function (item) {
  101. me.refreshEachItme(item.query,item.doc);
  102. });
  103. _.remove(this.datas,{ID:data.doc.ID});
  104. _.remove(gljOprObj.detailData,{ID:data.doc.ID});
  105. this.refreshSheetData();
  106. };
  107. quantity_detail.prototype.refreshSheetData=function () {
  108. sheetCommonObj.showData(gljOprObj.detailSheet,gljOprObj.detailSetting,gljOprObj.detailData);
  109. };
  110. quantity_detail.prototype.getUpdateData=function(type,query,doc,callfunction){
  111. var updateData = [];
  112. var newobj = {
  113. 'updateType': type,
  114. 'query': query,
  115. }
  116. if(doc){
  117. newobj['doc']=doc;
  118. }
  119. if(callfunction){
  120. newobj['updateFunction']=callfunction;
  121. }
  122. updateData.push(newobj);
  123. return updateData;
  124. };
  125. quantity_detail.prototype.saveQuantityDetail=function (args,dataCode) {
  126. var doc={};
  127. var selected = projectObj.project.mainTree.selected;
  128. if(selected.sourceType==ModuleNames.ration){
  129. doc.rationID=selected.data.ID;
  130. }
  131. if(selected.sourceType==ModuleNames.bills){
  132. doc.billID=selected.data.ID;
  133. }
  134. doc.projectID = selected.data.projectID;
  135. doc[dataCode]=args.editingText;
  136. doc.seq=args.row;
  137. if(dataCode=='regex'){
  138. if(!this.regexChecking(args.editingText)||!this.referenceChecking(args.editingText,args.row,doc)){
  139. return;
  140. }
  141. doc.refreshQuantity=true;
  142. if(!selected.data.hasOwnProperty('isFromDetail')||selected.data.isFromDetail==0){
  143. var c = confirm("确定要使用工程量明细替换原工程量吗?");
  144. if(!c){
  145. doc.refreshQuantity=false;
  146. }
  147. }
  148. }
  149. var updateData
  150. if(args.hasOwnProperty("insertRecode")){
  151. updateData = this.getUpdateData('ut_update',null,doc,'insertRecode');
  152. }else{
  153. updateData = this.getUpdateData('ut_create',null,doc);
  154. }
  155. project.pushNow('saveQuantityDetail',[this.getSourceType()],updateData);
  156. };
  157. quantity_detail.prototype.insertQuantityDetail = function (row) {
  158. var args = {
  159. row:row,
  160. editingText:1
  161. }
  162. if(row < gljOprObj.detailData.length){
  163. args.insertRecode = true;
  164. }
  165. this.saveQuantityDetail(args,'isSummation');
  166. };
  167. quantity_detail.prototype.deleteQuantityDetail = function (row) {
  168. var deleteable = this.checkReference(row);
  169. if(deleteable){
  170. var recode = gljOprObj.detailData[row];
  171. var updateData = this.getUpdateData('ut_delete',null,recode);
  172. project.pushNow('deleteQuantityDetail',[this.getSourceType()],updateData);
  173. }else {
  174. alert("当前行已被引用,不可删除。");
  175. }
  176. };
  177. quantity_detail.prototype.checkReference = function (row) {
  178. var deleteable = true;
  179. for(var i =0;i<gljOprObj.detailData.length;i++){
  180. var item = gljOprObj.detailData[i];
  181. if(_.includes(item.referenceIndexs,row+1)){
  182. deleteable = false;
  183. break;
  184. }
  185. }
  186. return deleteable;
  187. };
  188. quantity_detail.prototype.moveDown = function (row) {
  189. this.swapRow(row);
  190. };
  191. quantity_detail.prototype.moveUp = function (row) {
  192. this.swapRow(row-1);
  193. };
  194. quantity_detail.prototype.swapRow = function (preRow) {
  195. var me = this;
  196. var update_task = [];
  197. var a_row = gljOprObj.detailData[preRow];//
  198. var b_row = gljOprObj.detailData[preRow +1];//
  199. var temA = a_row.seq;
  200. var temB = b_row.seq;
  201. a_row.seq = temB;
  202. update_task.push({query:{ID:a_row.ID,projectID:a_row.projectID},doc:{seq:a_row.seq}});
  203. b_row.seq = temA;
  204. update_task.push({query:{ID:b_row.ID,projectID:b_row.projectID},doc:{seq:b_row.seq}});
  205. gljOprObj.detailData.forEach(function (item) {
  206. if(_.includes(item.referenceIndexs,temA+1)||_.includes(item.referenceIndexs,temB+1)){
  207. var regex = item.regex;
  208. for (var i=0;i<item.referenceIndexs.length;i++){
  209. if(item.referenceIndexs[i]==temA+1){
  210. regex = me.replaceAll('C'+item.referenceIndexs[i],'B'+(temB+1),regex);
  211. regex = me.replaceAll('c'+item.referenceIndexs[i],'b'+(temB+1),regex);
  212. item.referenceIndexs[i]=temB+1;
  213. }else if(item.referenceIndexs[i]==temB+1){
  214. regex = me.replaceAll('C'+item.referenceIndexs[i],'B'+(temA+1),regex);
  215. regex = me.replaceAll('c'+item.referenceIndexs[i],'b'+(temA+1),regex);
  216. item.referenceIndexs[i]=temA+1;
  217. }
  218. }
  219. regex = me.replaceAll('B','C',regex);
  220. regex = me.replaceAll('b','c',regex);
  221. update_task.push({query:{ID:item.ID,projectID:item.projectID},doc:{regex:regex,referenceIndexs:item.referenceIndexs}});
  222. }
  223. })
  224. var updateData=[];
  225. update_task.forEach(function (task) {
  226. updateData.push({'updateType': 'ut_update', 'query': task.query,'doc':task.doc});
  227. })
  228. project.pushNow('updateQuantityDetail',[this.getSourceType()],[updateData]);
  229. };
  230. quantity_detail.prototype.replaceAll=function(FindText, RepText,str) {
  231. let regExp = new RegExp(FindText, "g");
  232. return str.replace(regExp, RepText);
  233. };
  234. quantity_detail.prototype.updateQuantityDetail=function (args,dataCode,recode) {
  235. var doc ={};
  236. var query={
  237. ID:recode.ID,
  238. projectID:recode.projectID
  239. };
  240. var selected = projectObj.project.mainTree.selected;
  241. doc[dataCode]=args.editingText;
  242. if (dataCode == 'regex') {
  243. if(recode.hasOwnProperty('rationID')){
  244. query.rationID=recode.rationID;
  245. }else {
  246. query.billID = recode.billID
  247. }
  248. query.refreshQuantity=true;
  249. if(!selected.data.hasOwnProperty('isFromDetail')||selected.data.isFromDetail==0){
  250. var c = confirm("确定要使用工程量明细替换原工程量吗?");
  251. if(!c){
  252. query.refreshQuantity=false;
  253. }
  254. }
  255. query.index = args.row;
  256. this.updateQuantityRegex(query,doc,args)
  257. }else {
  258. this.normalUpdate(query,doc);
  259. }
  260. };
  261. quantity_detail.prototype.updateQuantityRegex=function(query,doc,args){
  262. var needupdate = false;
  263. if(args.editingText==null){
  264. needupdate =true;
  265. }else {
  266. args.editingText = _.trim(args.editingText,/\r\n/);
  267. if(this.regexChecking(args.editingText)&&this.referenceChecking(args.editingText,args.row,doc)){
  268. needupdate = true;
  269. }
  270. }
  271. if(needupdate){
  272. var updateData = this.getUpdateData('ut_update',query,doc,'updateQuantityRegex');
  273. project.pushNow('updateQuantityDetail',[this.getSourceType()],updateData);
  274. }
  275. };
  276. quantity_detail.prototype.isSummationUpdate=function (args,detailList,newval) {
  277. var query={
  278. ID:detailList[args.row].ID,
  279. projectID:detailList[args.row].projectID
  280. };
  281. var selected = projectObj.project.mainTree.selected;
  282. query.refreshQuantity=true;
  283. if(!selected.data.hasOwnProperty('isFromDetail')||selected.data.isFromDetail==0){
  284. var c = confirm("确定要使用工程量明细替换原工程量吗?");
  285. if(!c){
  286. query.refreshQuantity=false;
  287. }
  288. }
  289. if(detailList[args.row].hasOwnProperty('rationID')){
  290. query.rationID=detailList[args.row].rationID;
  291. }else {
  292. query.billID = detailList[args.row].billID
  293. }
  294. var doc={
  295. isSummation:newval
  296. };
  297. this.normalUpdate(query,doc);
  298. };
  299. quantity_detail.prototype.normalUpdate=function(query,doc){
  300. var updateData = this.getUpdateData('ut_update',query,doc);
  301. project.pushNow('updateQuantityDetail',[this.getSourceType()],updateData);
  302. };
  303. quantity_detail.prototype.regexChecking=function(text){
  304. var regex=/^[0-9Cc\+\-\*\^/\(\)\.]*$/g;
  305. if(!regex.test(text)){
  306. alert("输入了非法字符,请重新输入!")
  307. return false;
  308. }else {
  309. return true;
  310. }
  311. };
  312. quantity_detail.prototype.referenceChecking=function (text,row,doc) {
  313. text = text.toUpperCase();
  314. //text= this.replaceSqr(text);
  315. var me = this;
  316. var refReg = /C\d+/g;
  317. var self ='C'+(row+1);
  318. var refList = text.match(refReg);
  319. var invalidate = _.includes(refList,self);
  320. var referenceIndexs = [];
  321. var indexOut = false;
  322. _.forEach(refList,function (item) {
  323. var ref_index = parseInt(item.substring(1));
  324. if(ref_index>gljOprObj.detailData.length){
  325. indexOut=true;
  326. return;
  327. }else {
  328. referenceIndexs.push(ref_index);
  329. }
  330. });
  331. if(indexOut){
  332. alert("引用有误,请重新输入!");
  333. return false;
  334. }
  335. referenceIndexs=_.uniq(referenceIndexs);
  336. doc.referenceIndexs = referenceIndexs;
  337. this.temList = referenceIndexs;
  338. invalidate=this.getAllReferenceList((row+1),referenceIndexs);
  339. if(invalidate){
  340. alert("计算式中产生了循环引用,请重新输入!");
  341. return false;
  342. }
  343. return true;
  344. };
  345. quantity_detail.prototype.getAllReferenceList=function(original,refList){
  346. var me =this;
  347. var invalidate=false;
  348. _.forEach(refList,function (item) {
  349. if(me.getReferenceList(item,original)){
  350. invalidate=true;
  351. }
  352. })
  353. return invalidate;
  354. };
  355. quantity_detail.prototype.getReferenceList=function(item,original) {
  356. var invalidate =false;
  357. if(gljOprObj.detailData.length>=item){
  358. var recode = gljOprObj.detailData[item - 1];
  359. if (recode.referenceIndexs.length > 0) {
  360. if(_.includes(recode.referenceIndexs,original)){
  361. invalidate = true;
  362. return invalidate;
  363. }
  364. this.temList = this.temList.concat(recode.referenceIndexs);
  365. _.forEach(recode.referenceIndex, function (item) {
  366. if(this.getReferenceList(item,original)){
  367. invalidate = true;
  368. }
  369. })
  370. }
  371. }
  372. return invalidate;
  373. }
  374. quantity_detail.prototype.replaceSqr = function(text) {
  375. var squarRegex = /\([^\^]+\)\^\d+/g;
  376. var sqararr = text.match(squarRegex);
  377. var squarRegex2 = /C[0-9]+\^\d+|[0-9]+([.]{1}[0-9]+){0,1}\^\d+/g; //匹配没有括号的
  378. var sqararr2=text.match(squarRegex2);
  379. if(sqararr){
  380. text=converSqrByArr(sqararr,text);
  381. }
  382. if(sqararr2){
  383. text=converSqrByArr(sqararr2,text);
  384. }
  385. return text;
  386. };
  387. quantity_detail.prototype.converSqrByArr = function (sqararr,text) {
  388. var temp = text;
  389. sqararr.forEach(function (item) {
  390. var arr = item.split('\^');
  391. var y = parseInt(arr[1]);
  392. var x_arr = [];
  393. for (var i = 0; i < y; i++) {
  394. x_arr.push(arr[0]);
  395. }
  396. var temStr = x_arr.join('*');
  397. temp = temp.replace(item, temStr);
  398. });
  399. return temp;
  400. };
  401. quantity_detail.prototype.deleteByRation = function(ration){
  402. var detail_list = this.datas;
  403. var newList =_.filter(detail_list,(d)=>{
  404. return d.rationID!=ration.ID;
  405. });
  406. if(newList!=undefined){
  407. this.datas = newList;
  408. }
  409. };
  410. quantity_detail.prototype.deleteByBills=function(deleteData){
  411. var detail_list = this.datas;
  412. var billIDList = [];
  413. for(var i=0;i<deleteData.length;i++){
  414. if(deleteData[i].type=='delete'){
  415. billIDList.push(deleteData[i].data.ID);
  416. }
  417. }
  418. var newList =_.filter(detail_list,(d)=>{
  419. return !_.includes(billIDList,d.billID);
  420. });
  421. if(newList!=undefined){
  422. this.datas = newList;
  423. }
  424. };
  425. return new quantity_detail(project);
  426. }
  427. };