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