fee_rate_view.js 40 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037
  1. /**
  2. * Created by chen on 2017/8/1.
  3. */
  4. var feeRateObject={
  5. mainFeeRateSpread:null,
  6. mainFeeRateSheet:null,
  7. mainFeeRateData:null,
  8. mainFeeRateSetting:{
  9. header: [
  10. {headerName: "专业名称", headerWidth: 250, dataCode: "name", dataType: "String"},
  11. {headerName: "值%", headerWidth: 80, dataCode: "rate", dataType: "Number",hAlign: "right",decimalField:"feeRate"},
  12. {headerName: "备注", headerWidth: 150, dataCode: "memo", dataType: "String"}
  13. ],
  14. view: {
  15. lockColumns: [0]
  16. }
  17. },
  18. mainViews:null,
  19. datas:null,
  20. datasBackup:null,
  21. canEdit:false,
  22. activateFeeRate:null,
  23. needCascadeSet:false,
  24. selectionLoad:false,
  25. changeInfo:null,
  26. feeRateSpreads:null,
  27. editingCell:null,
  28. feeRateSelection:null,
  29. sheetSetting: {
  30. header: [
  31. {headerName: "专业名称", headerWidth: 200, dataCode: "name", dataType: "String"},
  32. {headerName: "值%", headerWidth: 120, dataCode: "rate", dataType: "Number",hAlign: "right",decimalField:"feeRate"},
  33. {headerName: "备注", dataCode: "memo", dataType: "String"}
  34. ],
  35. view: {
  36. comboBox: [],
  37. lockColumns: [0, 1, 2]
  38. }
  39. },
  40. columns: [
  41. {
  42. id: 'name',
  43. caption: '专业名称',
  44. dataField: 'name',
  45. width: 450,
  46. allowEditing: false
  47. },
  48. {
  49. id: 'rate',
  50. caption: '值%',
  51. dataField: 'rate',
  52. width: 120,
  53. minWidth: 50,
  54. allowEditing: true
  55. },
  56. {
  57. id: 'memo',
  58. caption: '备注',
  59. dataField: 'memo',
  60. minWidth: 120,
  61. allowEditing: true
  62. },
  63. {
  64. id: 'ID',
  65. caption: 'ID',
  66. dataField: 'ID',
  67. width: 80,
  68. visible: false,
  69. allowEditing: false
  70. },
  71. {
  72. id: 'subFeeRate',
  73. caption: '子费率',
  74. dataField: 'subFeeRate',
  75. width: 80,
  76. visible: false,
  77. allowEditing: false
  78. },
  79. {
  80. id: '_id',
  81. caption: '自动ID',
  82. dataField: '_id',
  83. width: 80,
  84. visible: false,
  85. allowEditing: false
  86. },
  87. {
  88. id: 'ParentID',
  89. caption: '父结点ID',
  90. dataField: 'ParentID',
  91. width: 80,
  92. visible: false,
  93. allowEditing: false
  94. }
  95. ],
  96. options :{
  97. allowSorting: false,
  98. showRowHeader: true,
  99. colMinWidth: 80,
  100. rowHeight: 30,
  101. allowEditing: true,
  102. editMode: 'inline',
  103. editUnit: 'cell',
  104. selectionUnit: "row",
  105. hierarchy: {
  106. keyField: 'ID',
  107. parentField: 'ParentID',
  108. collapsed: false,
  109. column: 'name'
  110. }
  111. },
  112. dataSource : {
  113. loadRange: function(params) {
  114. params.success(feeRateObject.datas);
  115. },
  116. update: function(params) {
  117. if(!params.hasOwnProperty('sourceIndex')){
  118. var selected = feeRateObject.mainViews.getSelections()[0];
  119. params.sourceIndex = selected.sourceRow;
  120. }
  121. params.success();
  122. if(!$('#cascadeSet').prop('checked')||params.hasOwnProperty('viewIndex')){
  123. projectObj.project.FeeRate.updateFeeRateByEdit(params,feeRateObject.activateFeeRate);
  124. }
  125. }
  126. },
  127. createSheet:function(){
  128. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  129. feeRateObject.feeRateSpreads=sheetCommonObj.buildSheet($('#fee_rate_sheet')[0], feeRateObject.sheetSetting,feeRateFile.rates.length);
  130. feeRateObject.feeRateSheet = feeRateObject.feeRateSpreads.getSheet(0);
  131. feeRateObject.feeRateSheet.selectionUnit(1)//0 cell,1 row,2 col;
  132. feeRateObject.feeRateSheet.options.isProtected = true;
  133. feeRateObject.feeRateSheet.name('fee_rate');
  134. feeRateObject.feeRateSheet.bind(GC.Spread.Sheets.Events.CellClick,feeRateObject.onCellClick);
  135. feeRateObject.feeRateSheet.bind(GC.Spread.Sheets.Events.CellDoubleClick,feeRateObject.onCellDoubleClick);
  136. },
  137. showSelectTree:function (sheet,setting,data) {
  138. var ch = GC.Spread.Sheets.SheetArea.viewport;
  139. var groups=[];
  140. sheet.suspendPaint();
  141. sheet.suspendEvent();
  142. sheet.rowOutlines.direction(GC.Spread.Sheets.Outlines.OutlineDirection.backward);
  143. sheet.getRange(-1, 0, -1, 1).cellType(feeRateObject.getTreeNodeCellType());
  144. for (var col = 0; col < setting.header.length; col++) {
  145. var hAlign = "left", vAlign = "center";
  146. if (setting.header[col].hAlign) {
  147. hAlign = setting.header[col].hAlign;
  148. } else if (setting.header[col].dataType !== "String"){
  149. hAlign = "right";
  150. }
  151. vAlign = setting.header[col].vAlign?setting.header[col].vAlign:vAlign;
  152. sheetCommonObj.setAreaAlign(sheet.getRange(-1, col, -1, 1), hAlign, vAlign);
  153. if (setting.header[col].formatter) {
  154. sheet.setFormatter(-1, col, setting.header[col].formatter, GC.Spread.Sheets.SheetArea.viewport);
  155. }
  156. for (var row = 0; row < data.length; row++) {
  157. var val = data[row][setting.header[col].dataCode];
  158. if(val&&setting.header[col].dataType === "Number"){
  159. if(setting.header[col].hasOwnProperty('decimalField')){
  160. var decimal = getDecimal(setting.header[col].decimalField);
  161. val =scMathUtil.roundToString(val,decimal);
  162. sheet.setFormatter(-1, col,getFormatter(decimal), GC.Spread.Sheets.SheetArea.viewport);
  163. }else {
  164. val =scMathUtil.roundToString(val,2);
  165. }
  166. }
  167. sheet.setValue(row, col, val, ch);
  168. if(col==0){
  169. feeRateObject.setSheetGroup(data[row],data,groups,row+1);
  170. }
  171. }
  172. }
  173. //this.lockCells(sheet,setting);
  174. _.forEach(groups,function (g) {
  175. for(var k in g){
  176. sheet.rowOutlines.group(parseInt(k), g[k]);
  177. }
  178. })
  179. /* sheet.rowOutlines.group(1, 6);
  180. sheet.rowOutlines.group(8, 6);
  181. sheet.rowOutlines.group(15, 6);
  182. sheet.rowOutlines.group(22, 6);*/
  183. // sheet.getRange(-1, 0, -1, 1).width(300);
  184. sheet.showRowOutline(false);
  185. sheet.resumeEvent();
  186. sheet.resumePaint(false);
  187. },
  188. getTreeNodeCellType:function () {
  189. var ns = GC.Spread.Sheets;
  190. function TreeNodeCellType() {
  191. }
  192. TreeNodeCellType.prototype = new ns.CellTypes.Text();
  193. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  194. var level = options.sheet.rowOutlines.getLevel(options.row);
  195. var nlevel = -1;
  196. if (options.row < options.sheet.getRowCount() - 1) {
  197. nlevel = options.sheet.rowOutlines.getLevel(options.row + 1);
  198. }
  199. var hoffset = (level + 2) * 12;
  200. x += hoffset;
  201. w -= hoffset;
  202. GC.Spread.Sheets.CellTypes.Base.prototype.paint.apply(this, arguments);
  203. if (options.row == options.sheet.getRowCount() - 1) return; //last row
  204. if (nlevel > level) {
  205. var collapsed = options.sheet.rowOutlines.isCollapsed(options.row + 1);
  206. x--;
  207. y += h / 2 - 3;
  208. ctx.save();
  209. ctx.fillStyle = "black";
  210. ctx.beginPath();
  211. if (collapsed) {
  212. ctx.moveTo(x - 5, y);
  213. ctx.lineTo(x, y + 3);
  214. ctx.lineTo(x - 5, y + 6);
  215. } else {
  216. ctx.moveTo(x, y);
  217. ctx.lineTo(x, y + 5);
  218. ctx.lineTo(x - 5, y + 5);
  219. }
  220. ctx.fill();
  221. ctx.restore();
  222. }
  223. else {
  224. // x--;
  225. //y += h / 2 - 3;
  226. ctx.save();
  227. ctx.restore();
  228. }
  229. };
  230. // override getHitInfo to allow cell type get mouse messages
  231. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  232. return {
  233. x: x,
  234. y: y,
  235. row: context.row,
  236. col: context.col,
  237. cellStyle: cellStyle,
  238. cellRect: cellRect,
  239. sheetArea: context.sheetArea
  240. };
  241. }
  242. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  243. var level = hitinfo.sheet.rowOutlines.getLevel(hitinfo.row);
  244. var hoffset = (level + 2) * 12 + hitinfo.cellRect.x;
  245. if (level==-1&&hitinfo.x < hoffset && hitinfo.x > hoffset - 10) {
  246. var collapsed = hitinfo.sheet.rowOutlines.isCollapsed(hitinfo.row + 1);
  247. hitinfo.sheet.rowOutlines.setCollapsed(hitinfo.row, !collapsed);
  248. hitinfo.sheet.invalidateLayout();
  249. hitinfo.sheet.repaint();
  250. }
  251. };
  252. return new TreeNodeCellType()
  253. },
  254. getFeeRateEditCellType:function () {
  255. var ns = GC.Spread.Sheets;
  256. function FeeRateEditCellType() {
  257. var init=false;
  258. }
  259. FeeRateEditCellType.prototype = new ns.CellTypes.Text();
  260. FeeRateEditCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  261. // if(value!=null){
  262. // ctx.fillText(value,x+3+ctx.measureText(value).width,y+h-3);
  263. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  264. // }
  265. if(feeRateObject.editingCell){
  266. if(feeRateObject.editingCell.row==options.row&&feeRateObject.editingCell.col==options.col){
  267. var image = document.getElementById('f_btn'),imageMagin = 3;
  268. var imageHeight = h-2*imageMagin;
  269. var imageWidth = w*2/7;
  270. var imageX = x + w - imageWidth- imageMagin, imageY = y + h / 2 - imageHeight / 2;
  271. ctx.save();
  272. ctx.drawImage(image, imageX, imageY,imageWidth,imageHeight);
  273. ctx.beginPath();
  274. ctx.arc(imageX+imageWidth/2,imageY+imageHeight/2,1,0,360,false);
  275. ctx.arc(imageX+imageWidth/2-4,imageY+imageHeight/2,1,0,360,false);
  276. ctx.arc(imageX+imageWidth/2+4,imageY+imageHeight/2,1,0,360,false);
  277. ctx.fillStyle="black";//填充颜色,默认是黑色
  278. ctx.fill();//画实心圆
  279. ctx.closePath();
  280. ctx.restore();
  281. }
  282. }
  283. };
  284. FeeRateEditCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  285. return {
  286. x: x,
  287. y: y,
  288. row: context.row,
  289. col: context.col,
  290. cellStyle: cellStyle,
  291. cellRect: cellRect,
  292. sheetArea: context.sheetArea
  293. };
  294. };
  295. FeeRateEditCellType.prototype.processMouseDown = function (hitinfo) {
  296. var me=feeRateObject;
  297. me.pmLeave = false;
  298. if(me.editingCell==null){
  299. var showSelectBtn = true;
  300. if(hitinfo.sheet.name()!='calc_detail'){
  301. showSelectBtn=me.ifFeeRateEdit();
  302. }
  303. if(showSelectBtn){
  304. me.editingCell={
  305. row:hitinfo.row,
  306. col:hitinfo.col
  307. }
  308. hitinfo.sheet.invalidateLayout();
  309. hitinfo.sheet.repaint();
  310. }
  311. }else if(hitinfo.row==me.editingCell.row){
  312. var offset=hitinfo.cellRect.x+hitinfo.cellRect.width-6;
  313. var imageMagin=3;
  314. var imageHeight = hitinfo.cellRect.height-2*imageMagin;
  315. var imageWidth = hitinfo.cellRect.width*2/7;
  316. if(hitinfo.x<offset&&hitinfo.x>offset-imageWidth){
  317. me.showSelectModal(hitinfo);
  318. }
  319. }
  320. };
  321. FeeRateEditCellType.prototype.processMouseLeave = function (hitinfo) {
  322. if(!feeRateObject.pmLeave){
  323. feeRateObject.editingCell=null;
  324. hitinfo.sheet.invalidateLayout();
  325. hitinfo.sheet.repaint();
  326. feeRateObject.pmLeave = true;
  327. }
  328. }
  329. return new FeeRateEditCellType();
  330. },
  331. showSelectModal:function (hitinfo) {
  332. //锁定的清单不显示
  333. let project = projectObj.project;
  334. if(project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected)){
  335. return;
  336. }
  337. $("#fee_rate_tree").modal({show:true});
  338. $('#edit_from').val(hitinfo.sheet.name());
  339. },
  340. setSheetGroup:function (rate,data,groups,row) {
  341. var me=this;
  342. var group={};
  343. var count=me.getChildrenCount(rate.ID,data);
  344. if(count>0){
  345. group[row]=count;
  346. groups.push(group);
  347. }
  348. return groups;
  349. },
  350. getChildrenCount:function (id,data) {
  351. var me=this;
  352. var sum=0;
  353. var children=_.filter(data,{'ParentID':id});
  354. if(children&&children.length==0){
  355. return 0;
  356. }
  357. for(var i=0;i<children.length;i++){
  358. sum+=me.getChildrenCount(children[i].ID,data);
  359. }
  360. return children.length+sum;
  361. },
  362. ifFeeRateEdit:function () {
  363. var selected = projectObj.project.mainTree.selected;
  364. return MainTreeCol.readOnly.forFeeRate(selected)?false:true;
  365. },
  366. createSpreadView:function () {
  367. if (this.mainViews) {
  368. this.mainViews.destroy();
  369. this.mainViews = null;
  370. }
  371. if(subRateObject.views){
  372. subRateObject.views.destroy();
  373. subRateObject.views = null;
  374. }
  375. this.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  376. this.datas = this.activateFeeRate.rates;
  377. var rateColSetting = _.find(this.columns,{"id":"rate"});
  378. rateColSetting?rateColSetting.format=getFormatter(getDecimal("feeRate")):"";
  379. this.mainViews = new GC.Spread.Views.DataView($('#divFee')[0],
  380. this.dataSource, this.columns, new GC.Spread.Views.Plugins.GridLayout(this.options));
  381. this.mainViews["rowClick"].addHandler(subRateObject.reFreshRateViews);
  382. this.mainViews.invalidate();
  383. document.querySelector('#divFee').focus();
  384. },
  385. initFeeRateSpread:function (rowCount) {
  386. //初始化费用项表格
  387. this.mainFeeRateSpread = sheetCommonObj.buildSheet($('#divFee')[0], this.mainFeeRateSetting,rowCount);
  388. this.mainFeeRateSpread.options.scrollbarMaxAlign = true;
  389. this.mainFeeRateSheet = this.mainFeeRateSpread.getSheet(0);
  390. sheetCommonObj.lockCells(this.mainFeeRateSheet , this.mainFeeRateSetting);
  391. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onMainFeeRateSheetValueChange);
  392. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onMainFeeRateSelectChanged);
  393. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMainFeeRateRangeChanged);
  394. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.EditStarting, function (e,args) {
  395. let me =feeRateObject;
  396. if(!me.mainFeeRateEditChecking(args.row,args.col)){
  397. args.cancel = true;
  398. }
  399. });
  400. this.mainFeeRateSheet.name('mainFeeRateSheet');
  401. disableRightMenu("divFee",this.mainFeeRateSpread,this.rightClickCallback);
  402. },
  403. rightClickCallback:function (row) {
  404. let me = feeRateObject;
  405. me.onMainFeeRateSelect(row);
  406. },
  407. showMainFeeRateData:function () {
  408. let me = this;
  409. let selected = me.mainFeeRateSheet.getSelections()[0];
  410. me.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  411. me.mainFeeRateData = projectObj.project.FeeRate.getActivateFeeRate().rates;
  412. me.mainFeeRateSheet.setRowCount(0);
  413. me.mainFeeRateSheet.setRowCount(me.mainFeeRateData.length);
  414. me.showSelectTree(me.mainFeeRateSheet,me.mainFeeRateSetting,me.mainFeeRateData);
  415. me.mainFeeRateSheet.setSelection(selected.row,selected.col,selected.rowCount,selected.colCount);
  416. },
  417. reFreshRateViews:function() {
  418. //feeRateObject.createSpreadView();
  419. feeRateObject.loadPageContent();
  420. this.showMainFeeRateData();
  421. if(subRateObject.subRateSpread){//如果子费率没有初始化过的话,不需要显示。
  422. subRateObject.initSubRateSpread(this.mainFeeRateData[0]);
  423. }
  424. },
  425. mainFeeRateEditChecking:function (row,col) {//false 不能编辑,true 可以编辑
  426. let me =feeRateObject;
  427. let recode = me.mainFeeRateData[row];
  428. let dataCode = me.mainFeeRateSetting.header[col].dataCode;
  429. if(dataCode=="rate"&&me.getChildrenCount(recode.ID,me.mainFeeRateData)>0){//有子节点时不能编辑费率列
  430. return false;
  431. }
  432. return true;
  433. },
  434. onMainFeeRateSheetValueChange:function (e,info) {
  435. /* let me = feeRateObject,updateData = {},feeRate = projectObj.project.FeeRate;
  436. let recode = me.mainFeeRateData[info.row];
  437. let fieldID = me.mainFeeRateSetting.header[info.col].dataCode;
  438. let value = info.newValue;
  439. if(fieldID == 'rate'&&value != null){
  440. let checkResult = scMathUtil.isNumOrFormula(value);
  441. if(checkResult!=null){
  442. value = scMathUtil.roundForObj(checkResult,getDecimal("feeRate"));
  443. }else {
  444. alert('当前输入的数据类型不正确,请重新输入。');
  445. me.mainFeeRateSheet.setValue(info.row, info.col, info.oldValue);
  446. return;
  447. }
  448. }
  449. if(recode[fieldID] == value){//没有改变
  450. return;
  451. }
  452. updateData[fieldID] = value;
  453. $.bootstrapLoading.start();
  454. feeRate.updateFeeRateByID(recode.ID,updateData,function () {
  455. me.mainFeeRateSheet.setValue(info.row, info.col, value);
  456. if(fieldID == 'rate'){
  457. feeRate.onFeeRateChange(recode.ID,value);
  458. }
  459. $.bootstrapLoading.end();
  460. })*/
  461. feeRateObject.updateFeerateWhenCellsChange([info]);
  462. },
  463. onMainFeeRateRangeChanged:function (e,info) {
  464. let me = feeRateObject;
  465. let changeCells = [];
  466. for(let c of info.changedCells){
  467. let tem = {
  468. row:c.row,
  469. col:c.col,
  470. newValue:info.sheet.getCell(c.row,c.col).value()
  471. };
  472. changeCells.push(tem);
  473. }
  474. me.updateFeerateWhenCellsChange(changeCells);
  475. },
  476. updateFeerateWhenCellsChange:function (cells) {// col,row,newValue
  477. let me = feeRateObject,updateDatas = [],feeRate = projectObj.project.FeeRate;//[{rateID:rateID,doc:doc}]
  478. let refreshA = [];//记录刷新条数的数组
  479. for(let c of cells){
  480. let temData = {};
  481. let recode = me.mainFeeRateData[c.row];
  482. let fieldID = me.mainFeeRateSetting.header[c.col].dataCode;
  483. let value = c.newValue;
  484. let oldValue = recode[fieldID];
  485. if(!me.mainFeeRateEditChecking(c.row, c.col)){
  486. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  487. continue;
  488. }else if(fieldID == 'rate'&&value != null){
  489. let checkResult = scMathUtil.isNumOrFormula(value);
  490. if(checkResult!=null && !isNaN(checkResult)){
  491. value = scMathUtil.roundForObj(checkResult,getDecimal("feeRate"));
  492. }else {
  493. setTimeout(function () {
  494. alert('当前输入的数据类型不正确,请重新输入。');
  495. },100);
  496. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  497. continue;
  498. }
  499. }
  500. if(recode[fieldID] == value){//没有改变
  501. continue;
  502. }
  503. temData[fieldID] = value ;
  504. updateDatas.push({rateID:recode.ID,doc:temData});
  505. refreshA.push({col:c.col,row:c.row,fieldID:fieldID,value:value,rateID:recode.ID});
  506. }
  507. if(updateDatas.length > 0){
  508. $.bootstrapLoading.start();
  509. feeRate.updateFeeRatesByIDs(updateDatas,function () {
  510. let feerateInfo = [];
  511. for(let r of refreshA){
  512. me.mainFeeRateSheet.setValue(r.row, r.col, r.value);
  513. if(r.fieldID == 'rate'){
  514. feerateInfo.push({rateID:r.rateID,value:r.value});
  515. }
  516. }
  517. feerateInfo.length > 0 ?feeRate.onFeeRatesChange(feerateInfo):'';
  518. $.bootstrapLoading.end();
  519. })
  520. }
  521. },
  522. onMainFeeRateSelectChanged:function (e, info) {
  523. let me = feeRateObject;
  524. let row = info.newSelections[0].row;
  525. me.onMainFeeRateSelect(row);
  526. },
  527. onMainFeeRateSelect:function (row) {
  528. let me = this;
  529. if(row!=-1){
  530. subRateObject.initSubRateSpread(me.mainFeeRateData[row]);
  531. }
  532. },
  533. updateBySelect:function (rate,selectMap,mapID) {
  534. let selected = this.mainFeeRateSheet.getSelections()[0];
  535. projectObj.project.FeeRate.backupDatas();
  536. let item = this.mainFeeRateData[selected.row];
  537. item.rate = rate;
  538. for(let key in selectMap){
  539. let recode = item.subFeeRate.recodes[key];
  540. let optionList = recode.optionList;
  541. for(let o of optionList){
  542. if(o.value==selectMap[key]){
  543. o.selected=true;
  544. }else {
  545. o.selected = false;
  546. }
  547. }
  548. }
  549. if($('#cascadeSet').prop('checked')){
  550. this.cascadeSetRates(item,selected.row,mapID,selectMap);
  551. }else {
  552. projectObj.project.FeeRate.batchUpdateFeeRate([{rateIndex:selected.row,rate:item}],feeRateObject.activateFeeRate);
  553. }
  554. },
  555. cascadeSetRates:function(selectedItem,sourceRow,mapID,selectMap){
  556. let items=[];
  557. items.push({rateIndex:sourceRow,rate:selectedItem});
  558. _.forEach(this.mainFeeRateData,function (recode,Index) {
  559. if(Index!=sourceRow&&recode.subFeeRate){
  560. let valueMaps = recode.subFeeRate.valueMaps;
  561. let valueMap = _.find(valueMaps,{ID:mapID});
  562. if(valueMap){//选项完全一样的情况
  563. if(valueMap.value==recode.rate){
  564. return;
  565. }else {
  566. recode.rate = valueMap.value;
  567. _.forEach(selectMap,function (value,key) {
  568. let tempRecode = recode.subFeeRate.recodes[key];
  569. let optionList = tempRecode.optionList;
  570. _.forEach(optionList,function (o) {
  571. if(o.value==value){
  572. o.selected = true;
  573. }else {
  574. o.selected = false;
  575. }
  576. })
  577. });
  578. items.push({rateIndex:Index,rate:recode});
  579. }
  580. }else {//某条选项一样的情况
  581. let needUpdate = false;
  582. let selectList = mapID.split('-');
  583. let newList=[];
  584. _.forEach(recode.subFeeRate.recodes,function (r) {
  585. let oList = r.optionList;
  586. let oldSelectIndex=0;
  587. let hasChange=false;
  588. _.forEach(oList,function (o,key) {
  589. if(o.selected){
  590. oldSelectIndex = key;
  591. }
  592. if(_.includes(selectList,o.value)){
  593. needUpdate=true;
  594. o.selected=true;
  595. hasChange=true;
  596. newList.push(o.value);
  597. }else {
  598. o.selected=false;
  599. }
  600. });
  601. if(!hasChange){
  602. oList[oldSelectIndex].selected=true;
  603. newList.push(oList[oldSelectIndex].value)
  604. }
  605. });
  606. if(needUpdate){
  607. let newValue = _.find(valueMaps,{ID:newList.join("-")})//取出费率值并更新
  608. if(newValue){
  609. if(recode.rate != newValue.value){
  610. recode.rate = newValue.value
  611. items.push({rateIndex:Index,rate:recode});
  612. }
  613. }
  614. }
  615. }
  616. }
  617. });
  618. projectObj.project.FeeRate.batchUpdateFeeRate(items,feeRateObject.activateFeeRate);
  619. },
  620. loadPageContent:function(){
  621. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  622. var usageProjects = feeRateFile.usageProjects;
  623. $('#feeRateFileName').text(feeRateFile.name);
  624. $('#feeRateLibName').text(feeRateFile.libName);
  625. $('#projectCount').text(usageProjects.length);
  626. },
  627. loadFeeRateSelection:function() {
  628. if(!this.selectionLoad){
  629. var selectedID=0;
  630. _.forEach(projectObj.project.FeeRate.datas,function (data) {
  631. var option = $("<option>").val(data.ID).text(data.libName);
  632. $('#inlineFormCustomSelect').append(option);
  633. if(data.status=='activate'){
  634. selectedID=data.ID;
  635. }
  636. })
  637. $('#inlineFormCustomSelect').val(selectedID);
  638. }
  639. },
  640. getFeeRateStandards:function (callback) {
  641. CommonAjax.post('/feeRates/getFeeRateStandards', {"projectID": projectObj.project.ID()}, function (data) {
  642. if (data) {
  643. callback(data);
  644. }
  645. });
  646. },
  647. changeFeeRateStandard:function(newVal){
  648. $.bootstrapLoading.start();
  649. var callback=function () {
  650. feeRateObject.reFreshRateViews();
  651. projectObj.project.FeeRate.onFeeRateFileChange();
  652. $.bootstrapLoading.end();
  653. };
  654. projectObj.project.FeeRate.changeFeeRateStandard(newVal,callback);
  655. },
  656. checkFeeRateName:function (newVal) {
  657. if(!newVal||newVal==""){
  658. $('#saveAsConfirm').attr("disabled","disabled");
  659. $('#nameError').text("请输入文件名称。").show();
  660. return;
  661. }
  662. var callback=function (data) {
  663. if(data){
  664. $('#saveAsConfirm').attr("disabled","disabled");
  665. $('#nameError').text("已存在同名费率文件。").show();
  666. $('#valid_name').val('');
  667. }else {
  668. $('#valid_name').val(newVal);
  669. $('#saveAsConfirm').removeAttr("disabled");
  670. $('#nameError').hide();
  671. }
  672. };
  673. projectObj.project.FeeRate.checkFeeRateName(newVal,callback);
  674. },
  675. feeRateFileSaveAs:function (newName) {
  676. if(!newName||newName==""){
  677. $('#saveAsConfirm').attr("disabled","disabled");
  678. $('#nameError').text("请输入文件名称。").show();
  679. return;
  680. }
  681. var valideName = $('#valid_name').val();
  682. if(valideName==''||valideName!==newName){
  683. var callback=function (data) {
  684. if(data){
  685. $('#saveAsConfirm').attr("disabled","disabled");
  686. $('#nameError').text("已存在同名费率文件。").show();
  687. $('#valid_name').val('');
  688. }else {
  689. feeRateObject.submitSaveAs(newName);
  690. }
  691. }
  692. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  693. }else {
  694. feeRateObject.submitSaveAs(newName);
  695. }
  696. },
  697. submitSaveAs:function (newName) {
  698. var me = this;
  699. projectObj.project.FeeRate.feeRateFileSaveAs(newName,function (result) {
  700. me.activateFeeRate = result;
  701. me.loadPageContent();
  702. $('#copy-lv').modal('hide');
  703. socket.emit('feeRateChangeNotify', projectObj.project.FeeRate.getActivateFeeRateFileID());
  704. $.bootstrapLoading.end();
  705. });
  706. },
  707. getChangeInfo:function () {
  708. var me = this;
  709. var callback=function (data) {
  710. me.changeInfo=data;
  711. me.loadChangePageContent(data);
  712. console.log(data);
  713. };
  714. projectObj.project.FeeRate.getChangeInfo(callback);
  715. },
  716. loadChangePageContent:function (data) {
  717. $('#currentProject').text(data.currentProject.name);
  718. $('#currentOptions').empty();
  719. _.forEach(data.currentProject.currentOptions,function (s) {
  720. var option = $("<option>").val(s.ID).text(s.name);
  721. $('#currentOptions').append(option);
  722. })
  723. $('#currentOptions').val(projectObj.project.FeeRate.getActivateFeeRateFileID());
  724. $('#otherProject').empty();
  725. _.forEach(data.others,function (p) {
  726. var option = $("<option>").val(p.ID).text(p.name);
  727. $('#otherProject').append(option);
  728. });
  729. $('#otherFeeRateOption').empty();
  730. if(data.others.length>0){
  731. _.forEach(data.others[0].optionList,function (f) {
  732. var option = $("<option>").val(f.ID).text(f.name);
  733. $('#otherFeeRateOption').append(option);
  734. });
  735. }
  736. },
  737. changeFeeRateFileFromCurrent:function(){
  738. $.bootstrapLoading.start();
  739. var newVal = $("#currentOptions").val();
  740. if($("#currentOptions").val()==this.activateFeeRate.ID){
  741. return;
  742. }
  743. var name =$("#currentOptions").find("option:selected").text();
  744. var newFeeRateFile = {
  745. id:newVal,
  746. name:name
  747. }
  748. var callback=function () {
  749. //feeRateObject.createSpreadView();
  750. feeRateObject.reFreshRateViews();
  751. projectObj.project.FeeRate.onFeeRateFileChange();
  752. $.bootstrapLoading.end();
  753. }
  754. projectObj.project.FeeRate.changeFeeRateFileFromCurrent(newFeeRateFile,callback);
  755. },
  756. changeFeeRateFileFromOthers:function () {
  757. var feeRateFileID = $("#otherFeeRateOption").val();
  758. var name =$("#otherFeeRateOption").find("option:selected").text();
  759. if(null===feeRateFileID){
  760. alert("请选择一个费率文件!");
  761. return;
  762. }
  763. var currentOption = _.find(this.changeInfo.currentProject.currentOptions,{name:name})
  764. if(currentOption){
  765. $("#rename-lv").modal({show:true});
  766. $("#newFeeRateID").val(feeRateFileID);
  767. $("#newFeeRateName").val(name);
  768. }else {
  769. this.changeFeeRateFileConfirm(feeRateFileID,name);
  770. }
  771. },
  772. changeFeeRateFileConfirm:function(feeRateFileID,name){
  773. $.bootstrapLoading.start();
  774. var callback=function () {
  775. feeRateObject.reFreshRateViews();
  776. projectObj.project.FeeRate.onFeeRateFileChange();
  777. $.bootstrapLoading.end();
  778. }
  779. projectObj.project.FeeRate.changeFeeRateFileFromOthers(feeRateFileID,name,callback);
  780. },
  781. setFeeRateCellCol:function (sheet,col) {
  782. sheet.getRange(-1, col, -1, 1).cellType(this.getFeeRateEditCellType());
  783. },
  784. onCellClick:function (sender,args) {
  785. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  786. feeRateObject.feeRateSelection=data[args.row];
  787. },
  788. onCellDoubleClick:function (sender,args) {
  789. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  790. feeRateObject.feeRateSelection=data[args.row];
  791. feeRateObject.submitFeeRateBySelect();
  792. },
  793. checkSelectedFeeRate:function () {
  794. var validate = false;
  795. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  796. if(feeRateObject.feeRateSelection!=null){
  797. var children=_.filter(data,{'ParentID':feeRateObject.feeRateSelection.ID});
  798. validate=children&&children.length==0;
  799. }
  800. return validate;
  801. },
  802. submitFeeRateFromBill:function () {
  803. var rate = feeRateObject.feeRateSelection;
  804. var selected = projectObj.project.mainTree.selected;
  805. $.bootstrapLoading.start();
  806. projectObj.project.FeeRate.submitFeeRateFromBill(rate,selected.data,function (data) {
  807. selected.data.feeRateID=rate.ID.toString();
  808. selected.data.feeRate=scMathUtil.roundToString(rate.rate,getDecimal("feeRate"));
  809. selected.changed = true;
  810. projectObj.project.calcProgram.calcAndSave(selected);
  811. //projectObj.mainController.refreshTreeNode([selected]);
  812. $("#fee_rate_tree").modal('hide');
  813. $.bootstrapLoading.end();
  814. });
  815. },
  816. submitFeeRateFromCalc:function () {
  817. var rate = feeRateObject.feeRateSelection;
  818. var calInfo = calcProgramManage.getSelectionInfo();
  819. calInfo.calcItem.feeRateID=rate.ID;
  820. calInfo.calcItem.feeRate=null;
  821. var data={'projectID': projectObj.project.ID(),'templatesID': calInfo.template.ID,'calcItem': calInfo.calcItem};
  822. $.bootstrapLoading.start();
  823. calcProgramManage.saveCalcItem(data,function (result) {
  824. calInfo.calcItem.feeRate=rate.rate;
  825. projectObj.project.calcProgram.compileAllTemps();
  826. projectObj.project.calcProgram.calcAllNodesAndSave();
  827. calcProgramManage.refreshDetailSheet();
  828. $("#fee_rate_tree").modal('hide');
  829. $.bootstrapLoading.end();
  830. });
  831. console.log(calInfo);
  832. },
  833. submitFeeRateBySelect:function () {
  834. var validate = this.checkSelectedFeeRate();
  835. if(validate){
  836. if($('#edit_from').val()=='calc_detail'){
  837. this.submitFeeRateFromCalc();
  838. }else {
  839. this.submitFeeRateFromBill();
  840. }
  841. }else {
  842. //$("#fee_rate_tree").modal('hide');
  843. }
  844. }
  845. }
  846. function getPopoverContent() {
  847. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  848. var usageProjects = feeRateFile.usageProjects;
  849. var popover_content = "";
  850. _.forEach(usageProjects,function (p,index) {
  851. if(index>0){
  852. popover_content+='<br>';
  853. }
  854. popover_content+=p.name;
  855. })
  856. return popover_content;
  857. }
  858. $(function(){
  859. $('#pop-lv').popover({
  860. placement:"bottom",
  861. html:true,
  862. trigger:"hover | focus",
  863. content:getPopoverContent
  864. }
  865. );
  866. $('#tab_fee_rate').on('shown.bs.tab', function (e) {
  867. sessionStorage.setItem('mainTab', '#tab_fee_rate');
  868. let me = feeRateObject;
  869. $(e.relatedTarget.hash).removeClass('active');
  870. if(me.mainFeeRateSpread == null){
  871. me.initFeeRateSpread(0);
  872. }
  873. me.showMainFeeRateData();
  874. me.loadPageContent();
  875. });
  876. $('#setNewFeeRate').bind('click', function () {
  877. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  878. var usageProjects = feeRateFile.usageProjects;
  879. var listString ='';
  880. _.forEach(usageProjects,function (u) {
  881. listString+="<li>"+u.name+"</li>"
  882. })
  883. $("#usageProjectList").html(listString);
  884. $("#set-lv-feeRateName").text(feeRateFile.name);
  885. $("#set-use-feeRateName").text(feeRateFile.name);
  886. feeRateObject.getFeeRateStandards(function (data) {
  887. $('#standardSelect').empty();
  888. _.forEach(data,function (s) {
  889. var option = $("<option>").val(s.ID).text(s.libName);
  890. $('#standardSelect').append(option);
  891. })
  892. $('#standardSelect').val(feeRateFile.libID);
  893. });
  894. });
  895. $('#changeConfirm').bind('click', function (){
  896. var newVal=$('#standardSelect').val();
  897. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  898. if(newVal&&newVal!=feeRateFile.libID){
  899. feeRateObject.changeFeeRateStandard(newVal);
  900. }
  901. });
  902. $('#saveAs').bind('click', function (){
  903. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  904. $('#copyFeeRateName').val(feeRateFile.name+'副本');
  905. $('#valid_name').val(feeRateFile.name+'副本');
  906. $('#nameError').hide();
  907. });
  908. $('#saveAsConfirm').bind('click',function () {
  909. feeRateObject.feeRateFileSaveAs($('#copyFeeRateName').val());
  910. })
  911. $('#copyFeeRateName').change(function () {
  912. feeRateObject.checkFeeRateName(this.value);
  913. });
  914. $('#newFeeRateName').change(function () {
  915. var newName = $(this).val();
  916. if(!newName||newName==""){
  917. $('#renameConfirm').attr("disabled","disabled");
  918. $('#renameError').text("请输入文件名称。").show();
  919. return;
  920. }
  921. var callback=function (data) {
  922. if(data){
  923. $('#renameConfirm').attr("disabled","disabled");
  924. $('#renameError').text("本建设项目中已存在同名费率文件。").show();
  925. }else {
  926. $('#renameConfirm').removeAttr("disabled");
  927. $('#renameError').hide();
  928. }
  929. };
  930. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  931. });
  932. $('#changeFeeRateConfirm').bind('click',function (){
  933. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  934. if(radioV==='0'){
  935. feeRateObject.changeFeeRateFileFromCurrent();
  936. }else {
  937. feeRateObject.changeFeeRateFileFromOthers();
  938. }
  939. })
  940. $('#changFeeRateFile').bind('click',function (){
  941. $("input[name='chaneg-lv-Radio']")[0].checked=true;
  942. $("#fromProject").show();
  943. $("#fromOther").hide();
  944. feeRateObject.getChangeInfo();
  945. })
  946. $('#otherProject').change(function(){
  947. var newVal = $(this).val();
  948. var projects = feeRateObject.changeInfo.others;
  949. var selected = _.find(projects,{ID:parseInt(newVal)});
  950. $('#otherFeeRateOption').empty();
  951. _.forEach(selected.optionList,function (f) {
  952. var option = $("<option>").val(f.ID).text(f.name);
  953. $('#otherFeeRateOption').append(option);
  954. });
  955. })
  956. $('#renameConfirm').bind('click',function (){
  957. var feeRateFileID= $("#newFeeRateID").val();
  958. var name = $("#newFeeRateName").val();
  959. feeRateObject.changeFeeRateFileConfirm(feeRateFileID,name);
  960. })
  961. $('#inlineFormCustomSelect').change(function(){
  962. var updateTask = [];
  963. var selectID = $(this).val();
  964. var oldValue=0;
  965. _.forEach(projectObj.project.FeeRate.datas,function (feeRate) {
  966. if(feeRate.status=='activate'){
  967. oldValue=feeRate.ID;
  968. }
  969. if(feeRate.ID ==selectID){
  970. feeRate.status='activate';
  971. }else {
  972. feeRate.status='disable';
  973. }
  974. updateTask.push({query:{ID:feeRate.feeRateID},doc:{status:feeRate.status}});
  975. })
  976. projectObj.project.FeeRate.updateStatusBySelected(updateTask);
  977. feeRateObject.createSpreadView();
  978. subRateObject.destorySpreadView();
  979. socket.emit('changeActivateFeeRate',{oldRoom:oldValue,newRoom:selectID});
  980. })
  981. $('#fee_rate_tree').on('shown.bs.modal', function (e) {
  982. if(feeRateObject.feeRateSpreads==null){
  983. feeRateObject.createSheet();
  984. }
  985. feeRateObject.feeRateSelection=null;
  986. feeRateObject.showSelectTree(feeRateObject.feeRateSheet,feeRateObject.sheetSetting,projectObj.project.FeeRate.getActivateFeeRate().rates);
  987. });
  988. $('#fee_rate_tree').on('hidden.bs.modal', function (e) {
  989. if(feeRateObject.feeRateSpreads){
  990. feeRateObject.feeRateSpreads.destroy();
  991. feeRateObject.feeRateSpreads=null;
  992. $('#edit_from').val('');
  993. $('#edit_row').val('');
  994. }
  995. });
  996. $('#fee_selected_conf').bind('click',function (){
  997. feeRateObject.submitFeeRateBySelect();
  998. })
  999. })
  1000. function changeFRadioClick() {
  1001. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  1002. if(radioV==='0'){
  1003. $("#fromProject").show();
  1004. $("#fromOther").hide();
  1005. }else {
  1006. $("#fromProject").hide();
  1007. $("#fromOther").show();
  1008. }
  1009. }