fee_rate_view.js 41 KB

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