fee_rate_view.js 37 KB

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