fee_rate_view.js 41 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045
  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 && !projectReadOnly){
  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. if(!projectReadOnly){
  318. me.showSelectModal(hitinfo);
  319. }
  320. }
  321. }
  322. };
  323. FeeRateEditCellType.prototype.processMouseLeave = function (hitinfo) {
  324. if(!feeRateObject.pmLeave){
  325. feeRateObject.editingCell=null;
  326. hitinfo.sheet.invalidateLayout();
  327. hitinfo.sheet.repaint();
  328. feeRateObject.pmLeave = true;
  329. }
  330. }
  331. return new FeeRateEditCellType();
  332. },
  333. showSelectModal:function (hitinfo) {
  334. //锁定的清单不显示
  335. let project = projectObj.project;
  336. if(project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected)){
  337. return;
  338. }
  339. $("#fee_rate_tree").modal({show:true});
  340. $('#edit_from').val(hitinfo.sheet.name());
  341. },
  342. setSheetGroup:function (rate,data,groups,row) {
  343. var me=this;
  344. var group={};
  345. var count=me.getChildrenCount(rate.ID,data);
  346. if(count>0){
  347. group[row]=count;
  348. groups.push(group);
  349. }
  350. return groups;
  351. },
  352. getChildrenCount:function (id,data) {
  353. var me=this;
  354. var sum=0;
  355. var children=_.filter(data,{'ParentID':id});
  356. if(children&&children.length==0){
  357. return 0;
  358. }
  359. for(var i=0;i<children.length;i++){
  360. sum+=me.getChildrenCount(children[i].ID,data);
  361. }
  362. return children.length+sum;
  363. },
  364. ifFeeRateEdit:function () {
  365. var selected = projectObj.project.mainTree.selected;
  366. return selected&&MainTreeCol.readOnly.forFeeRate(selected)?false:true;
  367. },
  368. createSpreadView:function () {
  369. if (this.mainViews) {
  370. this.mainViews.destroy();
  371. this.mainViews = null;
  372. }
  373. if(subRateObject.views){
  374. subRateObject.views.destroy();
  375. subRateObject.views = null;
  376. }
  377. this.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  378. this.datas = this.activateFeeRate.rates;
  379. var rateColSetting = _.find(this.columns,{"id":"rate"});
  380. rateColSetting?rateColSetting.format=getFormatter(getDecimal("feeRate")):"";
  381. this.mainViews = new GC.Spread.Views.DataView($('#divFee')[0],
  382. this.dataSource, this.columns, new GC.Spread.Views.Plugins.GridLayout(this.options));
  383. this.mainViews["rowClick"].addHandler(subRateObject.reFreshRateViews);
  384. this.mainViews.invalidate();
  385. document.querySelector('#divFee').focus();
  386. },
  387. initFeeRateSpread:function (rowCount) {
  388. //初始化费用项表格
  389. this.mainFeeRateSpread = sheetCommonObj.buildSheet($('#divFee')[0], this.mainFeeRateSetting,rowCount);
  390. this.mainFeeRateSpread.options.scrollbarMaxAlign = true;
  391. this.mainFeeRateSheet = this.mainFeeRateSpread.getSheet(0);
  392. if(!projectReadOnly){
  393. sheetCommonObj.lockCells(this.mainFeeRateSheet , this.mainFeeRateSetting);
  394. }
  395. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onMainFeeRateSheetValueChange);
  396. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onMainFeeRateSelectChanged);
  397. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMainFeeRateRangeChanged);
  398. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.EditStarting, function (e,args) {
  399. let me =feeRateObject;
  400. if(!me.mainFeeRateEditChecking(args.row,args.col)){
  401. args.cancel = true;
  402. }
  403. });
  404. this.mainFeeRateSheet.name('mainFeeRateSheet');
  405. disableRightMenu("divFee",this.mainFeeRateSpread,this.rightClickCallback);
  406. //打开他人分享的项目、只读
  407. if(projectReadOnly){
  408. disableSpread(this.mainFeeRateSpread);
  409. }
  410. },
  411. rightClickCallback:function (row) {
  412. let me = feeRateObject;
  413. me.onMainFeeRateSelect(row);
  414. },
  415. showMainFeeRateData:function () {
  416. let me = this;
  417. let selected = me.mainFeeRateSheet.getSelections()[0];
  418. me.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  419. me.mainFeeRateData = projectObj.project.FeeRate.getActivateFeeRate().rates;
  420. me.mainFeeRateSheet.setRowCount(0);
  421. me.mainFeeRateSheet.setRowCount(me.mainFeeRateData.length);
  422. me.showSelectTree(me.mainFeeRateSheet,me.mainFeeRateSetting,me.mainFeeRateData);
  423. me.mainFeeRateSheet.setSelection(selected.row,selected.col,selected.rowCount,selected.colCount);
  424. },
  425. reFreshRateViews:function() {
  426. //feeRateObject.createSpreadView();
  427. feeRateObject.loadPageContent();
  428. this.showMainFeeRateData();
  429. if(subRateObject.subRateSpread){//如果子费率没有初始化过的话,不需要显示。
  430. subRateObject.initSubRateSpread(this.mainFeeRateData[0]);
  431. }
  432. },
  433. mainFeeRateEditChecking:function (row,col) {//false 不能编辑,true 可以编辑
  434. let me =feeRateObject;
  435. let recode = me.mainFeeRateData[row];
  436. let dataCode = me.mainFeeRateSetting.header[col].dataCode;
  437. if(dataCode=="rate"&&me.getChildrenCount(recode.ID,me.mainFeeRateData)>0){//有子节点时不能编辑费率列
  438. return false;
  439. }
  440. return true;
  441. },
  442. onMainFeeRateSheetValueChange:function (e,info) {
  443. /* let me = feeRateObject,updateData = {},feeRate = projectObj.project.FeeRate;
  444. let recode = me.mainFeeRateData[info.row];
  445. let fieldID = me.mainFeeRateSetting.header[info.col].dataCode;
  446. let value = info.newValue;
  447. if(fieldID == 'rate'&&value != null){
  448. let checkResult = scMathUtil.isNumOrFormula(value);
  449. if(checkResult!=null){
  450. value = scMathUtil.roundForObj(checkResult,getDecimal("feeRate"));
  451. }else {
  452. alert('当前输入的数据类型不正确,请重新输入。');
  453. me.mainFeeRateSheet.setValue(info.row, info.col, info.oldValue);
  454. return;
  455. }
  456. }
  457. if(recode[fieldID] == value){//没有改变
  458. return;
  459. }
  460. updateData[fieldID] = value;
  461. $.bootstrapLoading.start();
  462. feeRate.updateFeeRateByID(recode.ID,updateData,function () {
  463. me.mainFeeRateSheet.setValue(info.row, info.col, value);
  464. if(fieldID == 'rate'){
  465. feeRate.onFeeRateChange(recode.ID,value);
  466. }
  467. $.bootstrapLoading.end();
  468. })*/
  469. feeRateObject.updateFeerateWhenCellsChange([info]);
  470. },
  471. onMainFeeRateRangeChanged:function (e,info) {
  472. let me = feeRateObject;
  473. let changeCells = [];
  474. for(let c of info.changedCells){
  475. let tem = {
  476. row:c.row,
  477. col:c.col,
  478. newValue:info.sheet.getCell(c.row,c.col).value()
  479. };
  480. changeCells.push(tem);
  481. }
  482. me.updateFeerateWhenCellsChange(changeCells);
  483. },
  484. updateFeerateWhenCellsChange:function (cells) {// col,row,newValue
  485. let me = feeRateObject,updateDatas = [],feeRate = projectObj.project.FeeRate;//[{rateID:rateID,doc:doc}]
  486. let refreshA = [];//记录刷新条数的数组
  487. for(let c of cells){
  488. let temData = {};
  489. let recode = me.mainFeeRateData[c.row];
  490. let fieldID = me.mainFeeRateSetting.header[c.col].dataCode;
  491. let value = c.newValue;
  492. let oldValue = recode[fieldID];
  493. if(!me.mainFeeRateEditChecking(c.row, c.col)){
  494. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  495. continue;
  496. }else if(fieldID == 'rate'&&value != null){
  497. let checkResult = scMathUtil.isNumOrFormula(value);
  498. if(checkResult!=null && !isNaN(checkResult)){
  499. value = scMathUtil.roundForObj(checkResult,getDecimal("feeRate"));
  500. }else {
  501. setTimeout(function () {
  502. alert('当前输入的数据类型不正确,请重新输入。');
  503. },100);
  504. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  505. continue;
  506. }
  507. }
  508. if(recode[fieldID] == value){//没有改变
  509. continue;
  510. }
  511. temData[fieldID] = value ;
  512. updateDatas.push({rateID:recode.ID,doc:temData});
  513. refreshA.push({col:c.col,row:c.row,fieldID:fieldID,value:value,rateID:recode.ID});
  514. }
  515. if(updateDatas.length > 0){
  516. $.bootstrapLoading.start();
  517. feeRate.updateFeeRatesByIDs(updateDatas,function () {
  518. let feerateInfo = [];
  519. for(let r of refreshA){
  520. me.mainFeeRateSheet.setValue(r.row, r.col, r.value);
  521. if(r.fieldID == 'rate'){
  522. feerateInfo.push({rateID:r.rateID,value:r.value});
  523. }
  524. }
  525. feerateInfo.length > 0 ?feeRate.onFeeRatesChange(feerateInfo):'';
  526. $.bootstrapLoading.end();
  527. })
  528. }
  529. },
  530. onMainFeeRateSelectChanged:function (e, info) {
  531. let me = feeRateObject;
  532. let row = info.newSelections[0].row;
  533. me.onMainFeeRateSelect(row);
  534. },
  535. onMainFeeRateSelect:function (row) {
  536. let me = this;
  537. if(row!=-1){
  538. subRateObject.initSubRateSpread(me.mainFeeRateData[row]);
  539. }
  540. },
  541. updateBySelect:function (rate,selectMap,mapID) {
  542. let selected = this.mainFeeRateSheet.getSelections()[0];
  543. projectObj.project.FeeRate.backupDatas();
  544. let item = this.mainFeeRateData[selected.row];
  545. item.rate = rate;
  546. for(let key in selectMap){
  547. let recode = item.subFeeRate.recodes[key];
  548. let optionList = recode.optionList;
  549. for(let o of optionList){
  550. if(o.value==selectMap[key]){
  551. o.selected=true;
  552. }else {
  553. o.selected = false;
  554. }
  555. }
  556. }
  557. if($('#cascadeSet').prop('checked')){
  558. this.cascadeSetRates(item,selected.row,mapID,selectMap);
  559. }else {
  560. projectObj.project.FeeRate.batchUpdateFeeRate([{rateIndex:selected.row,rate:item}],feeRateObject.activateFeeRate);
  561. }
  562. },
  563. cascadeSetRates:function(selectedItem,sourceRow,mapID,selectMap){
  564. let items=[];
  565. items.push({rateIndex:sourceRow,rate:selectedItem});
  566. _.forEach(this.mainFeeRateData,function (recode,Index) {
  567. if(Index!=sourceRow&&recode.subFeeRate){
  568. let valueMaps = recode.subFeeRate.valueMaps;
  569. let valueMap = _.find(valueMaps,{ID:mapID});
  570. if(valueMap){//选项完全一样的情况
  571. if(valueMap.value==recode.rate){
  572. return;
  573. }else {
  574. recode.rate = valueMap.value;
  575. _.forEach(selectMap,function (value,key) {
  576. let tempRecode = recode.subFeeRate.recodes[key];
  577. let optionList = tempRecode.optionList;
  578. _.forEach(optionList,function (o) {
  579. if(o.value==value){
  580. o.selected = true;
  581. }else {
  582. o.selected = false;
  583. }
  584. })
  585. });
  586. items.push({rateIndex:Index,rate:recode});
  587. }
  588. }else {//某条选项一样的情况
  589. let needUpdate = false;
  590. let selectList = mapID.split('-');
  591. let newList=[];
  592. _.forEach(recode.subFeeRate.recodes,function (r) {
  593. let oList = r.optionList;
  594. let oldSelectIndex=0;
  595. let hasChange=false;
  596. _.forEach(oList,function (o,key) {
  597. if(o.selected){
  598. oldSelectIndex = key;
  599. }
  600. if(_.includes(selectList,o.value)){
  601. needUpdate=true;
  602. o.selected=true;
  603. hasChange=true;
  604. newList.push(o.value);
  605. }else {
  606. o.selected=false;
  607. }
  608. });
  609. if(!hasChange){
  610. oList[oldSelectIndex].selected=true;
  611. newList.push(oList[oldSelectIndex].value)
  612. }
  613. });
  614. if(needUpdate){
  615. let newValue = _.find(valueMaps,{ID:newList.join("-")})//取出费率值并更新
  616. if(newValue){
  617. if(recode.rate != newValue.value){
  618. recode.rate = newValue.value
  619. items.push({rateIndex:Index,rate:recode});
  620. }
  621. }
  622. }
  623. }
  624. }
  625. });
  626. projectObj.project.FeeRate.batchUpdateFeeRate(items,feeRateObject.activateFeeRate);
  627. },
  628. loadPageContent:function(){
  629. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  630. var usageProjects = feeRateFile.usageProjects;
  631. $('#feeRateFileName').text(feeRateFile.name);
  632. $('#feeRateLibName').text(feeRateFile.libName);
  633. $('#projectCount').text(usageProjects.length);
  634. },
  635. loadFeeRateSelection:function() {
  636. if(!this.selectionLoad){
  637. var selectedID=0;
  638. _.forEach(projectObj.project.FeeRate.datas,function (data) {
  639. var option = $("<option>").val(data.ID).text(data.libName);
  640. $('#inlineFormCustomSelect').append(option);
  641. if(data.status=='activate'){
  642. selectedID=data.ID;
  643. }
  644. })
  645. $('#inlineFormCustomSelect').val(selectedID);
  646. }
  647. },
  648. getFeeRateStandards:function (callback) {
  649. CommonAjax.post('/feeRates/getFeeRateStandards', {"projectID": projectObj.project.ID()}, function (data) {
  650. if (data) {
  651. callback(data);
  652. }
  653. });
  654. },
  655. changeFeeRateStandard:function(newVal){
  656. $.bootstrapLoading.start();
  657. var callback=function () {
  658. feeRateObject.reFreshRateViews();
  659. projectObj.project.FeeRate.onFeeRateFileChange();
  660. $.bootstrapLoading.end();
  661. };
  662. projectObj.project.FeeRate.changeFeeRateStandard(newVal,callback);
  663. },
  664. checkFeeRateName:function (newVal) {
  665. if(!newVal||newVal==""){
  666. $('#saveAsConfirm').attr("disabled","disabled");
  667. $('#nameError').text("请输入文件名称。").show();
  668. return;
  669. }
  670. var callback=function (data) {
  671. if(data){
  672. $('#saveAsConfirm').attr("disabled","disabled");
  673. $('#nameError').text("已存在同名费率文件。").show();
  674. $('#valid_name').val('');
  675. }else {
  676. $('#valid_name').val(newVal);
  677. $('#saveAsConfirm').removeAttr("disabled");
  678. $('#nameError').hide();
  679. }
  680. };
  681. projectObj.project.FeeRate.checkFeeRateName(newVal,callback);
  682. },
  683. feeRateFileSaveAs:function (newName) {
  684. if(!newName||newName==""){
  685. $('#saveAsConfirm').attr("disabled","disabled");
  686. $('#nameError').text("请输入文件名称。").show();
  687. return;
  688. }
  689. var valideName = $('#valid_name').val();
  690. if(valideName==''||valideName!==newName){
  691. var callback=function (data) {
  692. if(data){
  693. $('#saveAsConfirm').attr("disabled","disabled");
  694. $('#nameError').text("已存在同名费率文件。").show();
  695. $('#valid_name').val('');
  696. }else {
  697. feeRateObject.submitSaveAs(newName);
  698. }
  699. }
  700. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  701. }else {
  702. feeRateObject.submitSaveAs(newName);
  703. }
  704. },
  705. submitSaveAs:function (newName) {
  706. var me = this;
  707. projectObj.project.FeeRate.feeRateFileSaveAs(newName,function (result) {
  708. me.activateFeeRate = result;
  709. me.loadPageContent();
  710. $('#copy-lv').modal('hide');
  711. socket.emit('feeRateChangeNotify', projectObj.project.FeeRate.getActivateFeeRateFileID());
  712. $.bootstrapLoading.end();
  713. });
  714. },
  715. getChangeInfo:function () {
  716. var me = this;
  717. var callback=function (data) {
  718. me.changeInfo=data;
  719. me.loadChangePageContent(data);
  720. console.log(data);
  721. };
  722. projectObj.project.FeeRate.getChangeInfo(callback);
  723. },
  724. loadChangePageContent:function (data) {
  725. $('#currentProject').text(data.currentProject.name);
  726. $('#currentOptions').empty();
  727. _.forEach(data.currentProject.currentOptions,function (s) {
  728. var option = $("<option>").val(s.ID).text(s.name);
  729. $('#currentOptions').append(option);
  730. })
  731. $('#currentOptions').val(projectObj.project.FeeRate.getActivateFeeRateFileID());
  732. $('#otherProject').empty();
  733. _.forEach(data.others,function (p) {
  734. var option = $("<option>").val(p.ID).text(p.name);
  735. $('#otherProject').append(option);
  736. });
  737. $('#otherFeeRateOption').empty();
  738. if(data.others.length>0){
  739. _.forEach(data.others[0].optionList,function (f) {
  740. var option = $("<option>").val(f.ID).text(f.name);
  741. $('#otherFeeRateOption').append(option);
  742. });
  743. }
  744. },
  745. changeFeeRateFileFromCurrent:function(){
  746. $.bootstrapLoading.start();
  747. var newVal = $("#currentOptions").val();
  748. if($("#currentOptions").val()==this.activateFeeRate.ID){
  749. return;
  750. }
  751. var name =$("#currentOptions").find("option:selected").text();
  752. var newFeeRateFile = {
  753. id:newVal,
  754. name:name
  755. }
  756. var callback=function () {
  757. //feeRateObject.createSpreadView();
  758. feeRateObject.reFreshRateViews();
  759. projectObj.project.FeeRate.onFeeRateFileChange();
  760. $.bootstrapLoading.end();
  761. }
  762. projectObj.project.FeeRate.changeFeeRateFileFromCurrent(newFeeRateFile,callback);
  763. },
  764. changeFeeRateFileFromOthers:function () {
  765. var feeRateFileID = $("#otherFeeRateOption").val();
  766. var name =$("#otherFeeRateOption").find("option:selected").text();
  767. if(null===feeRateFileID){
  768. alert("请选择一个费率文件!");
  769. return;
  770. }
  771. var currentOption = _.find(this.changeInfo.currentProject.currentOptions,{name:name})
  772. if(currentOption){
  773. $("#rename-lv").modal({show:true});
  774. $("#newFeeRateID").val(feeRateFileID);
  775. $("#newFeeRateName").val(name);
  776. }else {
  777. this.changeFeeRateFileConfirm(feeRateFileID,name);
  778. }
  779. },
  780. changeFeeRateFileConfirm:function(feeRateFileID,name){
  781. $.bootstrapLoading.start();
  782. var callback=function () {
  783. feeRateObject.reFreshRateViews();
  784. projectObj.project.FeeRate.onFeeRateFileChange();
  785. $.bootstrapLoading.end();
  786. }
  787. projectObj.project.FeeRate.changeFeeRateFileFromOthers(feeRateFileID,name,callback);
  788. },
  789. setFeeRateCellCol:function (sheet,col) {
  790. sheet.getRange(-1, col, -1, 1).cellType(this.getFeeRateEditCellType());
  791. },
  792. onCellClick:function (sender,args) {
  793. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  794. feeRateObject.feeRateSelection=data[args.row];
  795. },
  796. onCellDoubleClick:function (sender,args) {
  797. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  798. feeRateObject.feeRateSelection=data[args.row];
  799. feeRateObject.submitFeeRateBySelect();
  800. },
  801. checkSelectedFeeRate:function () {
  802. var validate = false;
  803. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  804. if(feeRateObject.feeRateSelection!=null){
  805. var children=_.filter(data,{'ParentID':feeRateObject.feeRateSelection.ID});
  806. validate=children&&children.length==0;
  807. }
  808. return validate;
  809. },
  810. submitFeeRateFromBill:function () {
  811. var rate = feeRateObject.feeRateSelection;
  812. var selected = projectObj.project.mainTree.selected;
  813. $.bootstrapLoading.start();
  814. projectObj.project.FeeRate.submitFeeRateFromBill(rate,selected.data,function (data) {
  815. selected.data.feeRateID=rate.ID.toString();
  816. selected.data.feeRate=scMathUtil.roundToString(rate.rate,getDecimal("feeRate"));
  817. selected.changed = true;
  818. projectObj.project.calcProgram.calcAndSave(selected);
  819. //projectObj.mainController.refreshTreeNode([selected]);
  820. $("#fee_rate_tree").modal('hide');
  821. $.bootstrapLoading.end();
  822. });
  823. },
  824. submitFeeRateFromCalc:function () {
  825. var rate = feeRateObject.feeRateSelection;
  826. var calInfo = calcProgramManage.getSelectionInfo();
  827. calInfo.calcItem.feeRateID=rate.ID;
  828. calInfo.calcItem.feeRate=null;
  829. var data={'projectID': projectObj.project.ID(),'templatesID': calInfo.template.ID,'calcItem': calInfo.calcItem};
  830. $.bootstrapLoading.start();
  831. calcProgramManage.saveCalcItem(data,function (result) {
  832. calInfo.calcItem.feeRate=rate.rate;
  833. projectObj.project.calcProgram.compileAllTemps();
  834. projectObj.project.calcProgram.calcAllNodesAndSave();
  835. calcProgramManage.refreshDetailSheet();
  836. $("#fee_rate_tree").modal('hide');
  837. $.bootstrapLoading.end();
  838. });
  839. console.log(calInfo);
  840. },
  841. submitFeeRateBySelect:function () {
  842. var validate = this.checkSelectedFeeRate();
  843. if(validate){
  844. if($('#edit_from').val()=='calc_detail'){
  845. this.submitFeeRateFromCalc();
  846. }else {
  847. this.submitFeeRateFromBill();
  848. }
  849. }else {
  850. //$("#fee_rate_tree").modal('hide');
  851. }
  852. }
  853. }
  854. function getPopoverContent() {
  855. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  856. var usageProjects = feeRateFile.usageProjects;
  857. var popover_content = "";
  858. _.forEach(usageProjects,function (p,index) {
  859. if(index>0){
  860. popover_content+='<br>';
  861. }
  862. popover_content+=p.name;
  863. })
  864. return popover_content;
  865. }
  866. $(function(){
  867. $('#pop-lv').popover({
  868. placement:"bottom",
  869. html:true,
  870. trigger:"hover | focus",
  871. content:getPopoverContent
  872. }
  873. );
  874. $('#tab_fee_rate').on('shown.bs.tab', function (e) {
  875. sessionStorage.setItem('mainTab', '#tab_fee_rate');
  876. let me = feeRateObject;
  877. $(e.relatedTarget.hash).removeClass('active');
  878. if(me.mainFeeRateSpread == null){
  879. me.initFeeRateSpread(0);
  880. }
  881. me.showMainFeeRateData();
  882. me.loadPageContent();
  883. });
  884. $('#setNewFeeRate').bind('click', function () {
  885. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  886. var usageProjects = feeRateFile.usageProjects;
  887. var listString ='';
  888. _.forEach(usageProjects,function (u) {
  889. listString+="<li>"+u.name+"</li>"
  890. })
  891. $("#usageProjectList").html(listString);
  892. $("#set-lv-feeRateName").text(feeRateFile.name);
  893. $("#set-use-feeRateName").text(feeRateFile.name);
  894. feeRateObject.getFeeRateStandards(function (data) {
  895. $('#standardSelect').empty();
  896. _.forEach(data,function (s) {
  897. var option = $("<option>").val(s.ID).text(s.libName);
  898. $('#standardSelect').append(option);
  899. })
  900. $('#standardSelect').val(feeRateFile.libID);
  901. });
  902. });
  903. $('#changeConfirm').bind('click', function (){
  904. var newVal=$('#standardSelect').val();
  905. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  906. if(newVal&&newVal!=feeRateFile.libID){
  907. feeRateObject.changeFeeRateStandard(newVal);
  908. }
  909. });
  910. $('#saveAs').bind('click', function (){
  911. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  912. $('#copyFeeRateName').val(feeRateFile.name+'副本');
  913. $('#valid_name').val(feeRateFile.name+'副本');
  914. $('#nameError').hide();
  915. });
  916. $('#saveAsConfirm').bind('click',function () {
  917. feeRateObject.feeRateFileSaveAs($('#copyFeeRateName').val());
  918. })
  919. $('#copyFeeRateName').change(function () {
  920. feeRateObject.checkFeeRateName(this.value);
  921. });
  922. $('#newFeeRateName').change(function () {
  923. var newName = $(this).val();
  924. if(!newName||newName==""){
  925. $('#renameConfirm').attr("disabled","disabled");
  926. $('#renameError').text("请输入文件名称。").show();
  927. return;
  928. }
  929. var callback=function (data) {
  930. if(data){
  931. $('#renameConfirm').attr("disabled","disabled");
  932. $('#renameError').text("本建设项目中已存在同名费率文件。").show();
  933. }else {
  934. $('#renameConfirm').removeAttr("disabled");
  935. $('#renameError').hide();
  936. }
  937. };
  938. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  939. });
  940. $('#changeFeeRateConfirm').bind('click',function (){
  941. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  942. if(radioV==='0'){
  943. feeRateObject.changeFeeRateFileFromCurrent();
  944. }else {
  945. feeRateObject.changeFeeRateFileFromOthers();
  946. }
  947. })
  948. $('#changFeeRateFile').bind('click',function (){
  949. $("input[name='chaneg-lv-Radio']")[0].checked=true;
  950. $("#fromProject").show();
  951. $("#fromOther").hide();
  952. feeRateObject.getChangeInfo();
  953. })
  954. $('#otherProject').change(function(){
  955. var newVal = $(this).val();
  956. var projects = feeRateObject.changeInfo.others;
  957. var selected = _.find(projects,{ID:parseInt(newVal)});
  958. $('#otherFeeRateOption').empty();
  959. _.forEach(selected.optionList,function (f) {
  960. var option = $("<option>").val(f.ID).text(f.name);
  961. $('#otherFeeRateOption').append(option);
  962. });
  963. })
  964. $('#renameConfirm').bind('click',function (){
  965. var feeRateFileID= $("#newFeeRateID").val();
  966. var name = $("#newFeeRateName").val();
  967. feeRateObject.changeFeeRateFileConfirm(feeRateFileID,name);
  968. })
  969. $('#inlineFormCustomSelect').change(function(){
  970. var updateTask = [];
  971. var selectID = $(this).val();
  972. var oldValue=0;
  973. _.forEach(projectObj.project.FeeRate.datas,function (feeRate) {
  974. if(feeRate.status=='activate'){
  975. oldValue=feeRate.ID;
  976. }
  977. if(feeRate.ID ==selectID){
  978. feeRate.status='activate';
  979. }else {
  980. feeRate.status='disable';
  981. }
  982. updateTask.push({query:{ID:feeRate.feeRateID},doc:{status:feeRate.status}});
  983. })
  984. projectObj.project.FeeRate.updateStatusBySelected(updateTask);
  985. feeRateObject.createSpreadView();
  986. subRateObject.destorySpreadView();
  987. socket.emit('changeActivateFeeRate',{oldRoom:oldValue,newRoom:selectID});
  988. })
  989. $('#fee_rate_tree').on('shown.bs.modal', function (e) {
  990. if(feeRateObject.feeRateSpreads==null){
  991. feeRateObject.createSheet();
  992. }
  993. feeRateObject.feeRateSelection=null;
  994. feeRateObject.showSelectTree(feeRateObject.feeRateSheet,feeRateObject.sheetSetting,projectObj.project.FeeRate.getActivateFeeRate().rates);
  995. });
  996. $('#fee_rate_tree').on('hidden.bs.modal', function (e) {
  997. if(feeRateObject.feeRateSpreads){
  998. feeRateObject.feeRateSpreads.destroy();
  999. feeRateObject.feeRateSpreads=null;
  1000. $('#edit_from').val('');
  1001. $('#edit_row').val('');
  1002. }
  1003. });
  1004. $('#fee_selected_conf').bind('click',function (){
  1005. feeRateObject.submitFeeRateBySelect();
  1006. })
  1007. })
  1008. function changeFRadioClick() {
  1009. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  1010. if(radioV==='0'){
  1011. $("#fromProject").show();
  1012. $("#fromOther").hide();
  1013. }else {
  1014. $("#fromProject").hide();
  1015. $("#fromOther").show();
  1016. }
  1017. }