fee_rate_view.js 57 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344
  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", showHint: true}
  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", showHint: true}
  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. console.log(data);
  140. let ch = GC.Spread.Sheets.SheetArea.viewport;
  141. let parentMap=_.groupBy(data, 'ParentID');
  142. let visibleMap = {};
  143. sheet.suspendPaint();
  144. sheet.suspendEvent();
  145. sheet.setRowCount(data.length);
  146. for (let col = 0; col < setting.header.length; col++) {
  147. let hAlign = "left", vAlign = "center";
  148. if (setting.header[col].hAlign) {
  149. hAlign = setting.header[col].hAlign;
  150. } else if (setting.header[col].dataType !== "String"){
  151. hAlign = "right";
  152. }
  153. vAlign = setting.header[col].vAlign?setting.header[col].vAlign:vAlign;
  154. sheetCommonObj.setAreaAlign(sheet.getRange(-1, col, -1, 1), hAlign, vAlign);
  155. if (setting.header[col].formatter) {
  156. sheet.setFormatter(-1, col, setting.header[col].formatter, GC.Spread.Sheets.SheetArea.viewport);
  157. }
  158. if (setting.header[col].showHint) {
  159. sheet.getRange(-1, col, -1, 1).cellType(TREE_SHEET_HELPER.getTipCellType(setting));
  160. }
  161. for (let row = 0; row < data.length; row++) {
  162. let val = data[row][setting.header[col].dataCode];
  163. if(val&&setting.header[col].dataType === "Number"){
  164. if(setting.header[col].hasOwnProperty('decimalField')){
  165. let decimal = getDecimal(setting.header[col].decimalField);
  166. val =scMathUtil.roundToString(val,decimal);
  167. sheet.setFormatter(-1, col,getFormatter(decimal), GC.Spread.Sheets.SheetArea.viewport);
  168. }else {
  169. val =scMathUtil.roundToString(val,2);
  170. }
  171. }
  172. sheet.setValue(row, col, val, ch);
  173. if(col==0){
  174. let treeType = sheetCommonObj.getTreeNodeCellType(data,row,parentMap);
  175. sheet.getCell(row, 0).cellType(treeType);
  176. visibleMap[data[row].ID] = treeType.collapsed;
  177. feeRateObject.setRowVisible(data,row,visibleMap,sheet);
  178. } else if (col === 1 && this.rateShouldMark(data[row], val)) {
  179. sheet.getCell(row, col).foreColor('red');
  180. }
  181. }
  182. }
  183. sheet.resumeEvent();
  184. sheet.resumePaint();
  185. },
  186. rateShouldMark: function (rateItem, val) {
  187. if (!rateItem) {
  188. return false;
  189. }
  190. if (rateItem.rate === null) {
  191. return false;
  192. }
  193. if (rateItem.sum) {
  194. return false;
  195. }
  196. if (rateItem.subFeeRate && rateItem.subFeeRate.recodes && rateItem.subFeeRate.recodes.length) {
  197. const selectedSubRateValues = [];
  198. rateItem.subFeeRate.recodes.forEach(record => {
  199. record.optionList.forEach(opt => {
  200. if (opt.selected) {
  201. selectedSubRateValues.push(opt.value);
  202. }
  203. });
  204. });
  205. const selectedID = selectedSubRateValues.join('-');
  206. const valInMap = rateItem.subFeeRate.valueMaps.find(item => item.ID === selectedID);
  207. return !!(valInMap && valInMap.value !== +val);
  208. } else {
  209. return commonUtil.isDef(rateItem.originalRate) && rateItem.originalRate !== +val;
  210. }
  211. },
  212. setRowVisible:function (data,row,visibleMap,sheet) {
  213. sheet.getRange(row , -1, 1, -1).visible(getVisible(data[row].ParentID));//显示或隐藏
  214. function getVisible(ParentID) {
  215. if(visibleMap[ParentID]) return false //如果父节点是缩起的,那就隐藏本身。
  216. if(visibleMap[ParentID] == false){//如果父节点不是缩起的,要再往父节点找看
  217. let pnode = _.find(data,{'ID':ParentID});
  218. if(pnode) return getVisible(pnode.ParentID);//如果有父节点,递归调用
  219. return true;//没有,返回显示
  220. }
  221. }
  222. },
  223. getFeeRateLevel:function (rate,data) {
  224. if(rate.ParentID){
  225. let prate = _.find(data,{'ID':rate.ParentID});
  226. return this.getFeeRateLevel(prate,data) + 1;
  227. }else {
  228. return 0
  229. }
  230. },
  231. initFeeRateEditDiv:function(optionValue){//“0” 手工输入; “1” 选择费率
  232. let radioValue = 1,feeRateValue;
  233. $("#customFeeRate").val("");//先清空输入
  234. if(!gljUtil.isDef(optionValue)){
  235. let fID = 0;
  236. if ($("#calc_program_manage").is(":visible")){
  237. fID = calcProgramManage.getSelectionInfo().calcItem.feeRateID;
  238. feeRateValue = calcProgramManage.getSelectionInfo().calcItem.feeRate;
  239. } else if ($("#zaojiashu").is(":visible")){
  240. fID = projectObj.project.mainTree.selected.data.feeRateID;
  241. feeRateValue = projectObj.project.mainTree.selected.data.feeRate;
  242. }
  243. if(fID){
  244. feeRateValue = projectObj.project.FeeRate.getFeeRateByID(fID).rate;
  245. }
  246. if(!fID&&gljUtil.isDef(feeRateValue)) radioValue = 0; //2019-04-18 只有在没有费率ID,但是有费率值的情况下才显示自定义费率页,其它所有的情况都显示费率选择页面
  247. if(!isNaN(feeRateValue))$("#customFeeRate").val(feeRateValue);
  248. }
  249. $("input[name='editFeeRateOptions'][value='"+radioValue+"']").prop("checked",true);
  250. if(radioValue == "0"){
  251. $("#selfDiv").show();
  252. $("#fee_rate_sheet").hide();
  253. }else {
  254. $("#selfDiv").hide();
  255. $("#fee_rate_sheet").show();
  256. }
  257. },
  258. locate: function(){ // CSL,2018.07.18
  259. let sheet = feeRateObject.feeRateSpreads.getSheet(0);
  260. let fID = 0;
  261. if ($("#calc_program_manage").is(":visible"))
  262. fID = calcProgramManage.getSelectionInfo().calcItem.feeRateID;
  263. else if ($("#zaojiashu").is(":visible"))
  264. fID = projectObj.project.mainTree.selected.data.feeRateID;
  265. let rates = projectObj.project.FeeRate.getActivateFeeRate().rates;
  266. let rowIdx = 0, pID = 0;
  267. if (fID){
  268. fID = parseInt(fID);
  269. rowIdx = _.findIndex(rates,{ID:fID});
  270. if(rowIdx != -1) pID = rates[rowIdx].ParentID;
  271. }
  272. // 费率现有可能有多层节点,所以要递归展开父节点
  273. if(pID) expandParent(pID,rates,sheet);
  274. sheet.setSelection(rowIdx, -1, 1, -1);
  275. sheet.showRow(rowIdx, GC.Spread.Sheets.VerticalPosition.center);
  276. feeRateObject.onCellClick({type: 'CellClick'}, {row:rowIdx});
  277. function expandParent(ID,datas,sheet) {//递归展开父节点
  278. let cellType = setCollapsed(ID);
  279. cellType.refreshChildrenVisible(sheet);
  280. function setCollapsed(parentID){
  281. let index = _.findIndex(datas,{'ID':parentID});
  282. let type = sheet.getCellType(index,0);
  283. type.collapsed = false;
  284. if(datas[index].ParentID){
  285. setCollapsed(datas[index].ParentID)
  286. }
  287. return type
  288. }
  289. }
  290. },
  291. getTreeNodeCellType:function (datas,row,parentMap) {// 2018-09-26 不用spreadjs默认的树结构,自定义控件
  292. var ns = GC.Spread.Sheets;
  293. let rectW = 10;
  294. let rectH = 10;
  295. let margin = 3;
  296. function TreeNodeCellType() {
  297. this.collapsed = true; //默认是折叠的
  298. this.rectInfo = {};
  299. }
  300. TreeNodeCellType.prototype = new ns.CellTypes.Text();
  301. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  302. let offset = 0;
  303. let step = 7;
  304. let level = getTreeLevel(datas[row],datas);//从0开始,取当前节点是第几级的
  305. let tem = offset+margin+ rectW/2+step;//两条线之间的间隔
  306. let t_offset = offset;
  307. let temParentID = datas[row].ParentID;
  308. for(let i = level;i>0;i--){//这里是画子节点前面的竖线,从第二级开始
  309. let temParent = getParent(temParentID,datas);
  310. if(temParent){//父节点有下一个兄弟节点才需要画
  311. if(hasNextBrother(parentMap,temParent)) sheetCommonObj.drawLine(ctx,x+t_offset+tem*i,y,x+t_offset+tem*i,y+h);
  312. temParentID = temParent.ParentID;
  313. }
  314. offset +=tem;
  315. }
  316. offset+=step;
  317. if(hasChildern(datas[row].ID,datas)){//如果是有子节点
  318. //第一条不用画方框头上那条竖线其它都要
  319. if(row !=0) sheetCommonObj.drawLine(ctx,x+offset+ rectW/2+margin,y,x+offset+ rectW/2+margin,y + Math.round(h / 2) - rectH / 2);
  320. //画方框下面的那条竖线,如果没有下一个兄弟节点,则不用画
  321. if(hasNextBrother(parentMap,datas[row])) sheetCommonObj.drawLine(ctx,x+offset+ rectW/2+margin,y + Math.round(h / 2) + rectH / 2,x+offset+ rectW/2+margin,y + h);
  322. sheetCommonObj.drowRect(ctx, x+offset, y, w, h,rectW,rectH,margin);
  323. sheetCommonObj.drowSymbol(ctx, x+offset, y, w, h,rectW,rectH,margin, this.collapsed);
  324. this.rectInfo = {x:x+offset+margin,rectW:rectW}//计录一下可点击位置
  325. }else {
  326. let hasNext = datas[row+1]?datas[row+1].ParentID == datas[row].ParentID:false;
  327. sheetCommonObj.drowSubItem(ctx, x, y, w, h, offset,hasNext,margin+ rectW/2);
  328. }
  329. offset += step;
  330. offset += rectW;
  331. x = x + offset;//设置偏移
  332. w = w - offset;
  333. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  334. };
  335. // override getHitInfo to allow cell type get mouse messages
  336. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  337. return {
  338. x: x,
  339. y: y,
  340. row: context.row,
  341. col: context.col,
  342. cellStyle: cellStyle,
  343. cellRect: cellRect,
  344. sheetArea: context.sheetArea
  345. };
  346. }
  347. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  348. ////方框外1像素内都有效
  349. if (!_.isEmpty(this.rectInfo)&&Math.floor(hitinfo.x) <= this.rectInfo.x+this.rectInfo.rectW+2 && Math.floor(hitinfo.x) >= this.rectInfo.x-2) {
  350. this.collapsed = !this.collapsed;
  351. this.refreshChildrenVisible(hitinfo.sheet);
  352. hitinfo.sheet.invalidateLayout();
  353. hitinfo.sheet.repaint();
  354. }
  355. };
  356. TreeNodeCellType.prototype.refreshChildrenVisible = function (sheet) {
  357. sheet.suspendPaint();
  358. sheet.suspendEvent();
  359. refreshVisible(datas[row]);
  360. sheet.resumeEvent();
  361. sheet.resumePaint();
  362. function refreshVisible(item){
  363. if(parentMap[item.ID]){
  364. for(let sub of parentMap[item.ID]){
  365. refreshVisible(sub)
  366. }
  367. }
  368. let visible = getVisible(item);
  369. let trow = datas.indexOf(item);
  370. sheet.getRange(trow , -1, 1, -1).visible(visible);
  371. }
  372. function getVisible(item) {
  373. if(item.ParentID){
  374. let parent = getParent(item.ParentID,datas);
  375. if(!parent) return true;
  376. let p_row= datas.indexOf(parent);
  377. let visible = !sheet.getCellType(p_row,0).collapsed;
  378. if(visible == true){ //如果是显示的,则要再往父节点的父节点检查,只要有一个节点是隐藏的,则都是隐藏
  379. return getVisible(parent);
  380. }else {
  381. return visible
  382. }
  383. }else {//如果parentID 为空则是最根节点
  384. return true;
  385. }
  386. }
  387. };
  388. return new TreeNodeCellType()
  389. function getTreeLevel(item,data) {
  390. if(item.ParentID){
  391. let pitem = _.find(data,{'ID':item.ParentID});
  392. return getTreeLevel(pitem,data) + 1;
  393. }else {
  394. return 0
  395. }
  396. }
  397. function hasChildern(ID,data) {//返回是否有子项
  398. let p = _.find(data,{'ParentID':ID});
  399. if(p) return true;
  400. return false
  401. }
  402. function getParent(ParentID,data) {
  403. let p = _.find(data,{'ID':ParentID});
  404. return p;
  405. }
  406. function hasNextBrother(parentMap,item){
  407. let children =parentMap[item.ParentID];
  408. if(children && children.indexOf(item) == children.length -1) return false;
  409. return true
  410. }
  411. },
  412. getFeeRateEditCellType:function () {
  413. var ns = GC.Spread.Sheets;
  414. function FeeRateEditCellType() {
  415. var init=false;
  416. }
  417. FeeRateEditCellType.prototype = new ns.CellTypes.Text();
  418. //2018-12-12 按新需求隐藏费率选择按钮
  419. /* FeeRateEditCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  420. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  421. if(feeRateObject.editingCell && !projectReadOnly){
  422. if(feeRateObject.editingCell.row==options.row&&feeRateObject.editingCell.col==options.col){
  423. var image = document.getElementById('f_btn'),imageMagin = 3;
  424. var imageHeight = h-2*imageMagin;
  425. var imageWidth = w*2/7;
  426. var imageX = x + w - imageWidth- imageMagin, imageY = y + h / 2 - imageHeight / 2;
  427. ctx.save();
  428. ctx.drawImage(image, imageX, imageY,imageWidth,imageHeight);
  429. ctx.beginPath();
  430. ctx.arc(imageX+imageWidth/2,imageY+imageHeight/2,1,0,360,false);
  431. ctx.arc(imageX+imageWidth/2-4,imageY+imageHeight/2,1,0,360,false);
  432. ctx.arc(imageX+imageWidth/2+4,imageY+imageHeight/2,1,0,360,false);
  433. ctx.fillStyle="black";//填充颜色,默认是黑色
  434. ctx.fill();//画实心圆
  435. ctx.closePath();
  436. ctx.restore();
  437. }
  438. }
  439. };
  440. FeeRateEditCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  441. return {
  442. x: x,
  443. y: y,
  444. row: context.row,
  445. col: context.col,
  446. cellStyle: cellStyle,
  447. cellRect: cellRect,
  448. sheetArea: context.sheetArea
  449. };
  450. };
  451. FeeRateEditCellType.prototype.processMouseDown = function (hitinfo) {
  452. let me=feeRateObject;
  453. if(me.editingCell && hitinfo.row==me.editingCell.row){
  454. var offset=hitinfo.cellRect.x+hitinfo.cellRect.width-6;
  455. var imageMagin=3;
  456. var imageHeight = hitinfo.cellRect.height-2*imageMagin;
  457. var imageWidth = hitinfo.cellRect.width*2/7;
  458. if(hitinfo.x<offset&&hitinfo.x>offset-imageWidth){
  459. if(!projectReadOnly && me.ifFeeRateEdit(hitinfo.row,hitinfo.sheet.name())){
  460. $('#calcBaseFeeRateConf').attr('toggle', 'feeRate');
  461. changeCalcBaseFeeRate('feeRate');
  462. $('#tabFeeRate').tab('show');
  463. me.showSelectModal(hitinfo);
  464. }
  465. }else {//鼠标点击其它地方,消失
  466. hideButton(hitinfo);
  467. }
  468. }
  469. };
  470. FeeRateEditCellType.prototype.processMouseEnter = function (hitinfo){
  471. let me=feeRateObject;
  472. me.pmLeave = false;
  473. if(me.editingCell==null){
  474. var showSelectBtn = true;
  475. if(hitinfo.sheet.name()!='calc_detail'){
  476. showSelectBtn=me.ifFeeRateEdit(hitinfo.row,hitinfo.sheet.name());
  477. }
  478. if(showSelectBtn){
  479. me.editingCell={
  480. row:hitinfo.row,
  481. col:hitinfo.col
  482. };
  483. hitinfo.sheet.invalidateLayout();
  484. hitinfo.sheet.repaint();
  485. }
  486. }
  487. };
  488. FeeRateEditCellType.prototype.processMouseLeave = function (hitinfo) {
  489. hideButton(hitinfo);
  490. };
  491. function hideButton(hitinfo) {
  492. if(!feeRateObject.pmLeave){
  493. feeRateObject.editingCell=null;
  494. hitinfo.sheet.invalidateLayout();
  495. hitinfo.sheet.repaint();
  496. feeRateObject.pmLeave = true;
  497. }
  498. }*/
  499. return new FeeRateEditCellType();
  500. },
  501. showSelectModal:function (hitinfo) {
  502. let project = projectObj.project;
  503. let field = projectObj.mainController.setting.cols[hitinfo.col].data.field;
  504. if(MainTreeCol.lockBillChecking(project.mainTree.selected,field)){ //锁定的清单不显示
  505. return;
  506. }
  507. //$("#fee_rate_tree").modal({show:true});
  508. $("#calcBaseFeeRate").modal({show:true});
  509. $('#edit_from').val(hitinfo.sheet.name());
  510. },
  511. getChildrenCount:function (id,data) {
  512. var me=this;
  513. var sum=0;
  514. var children=_.filter(data,{'ParentID':id});
  515. if(children&&children.length==0){
  516. return 0;
  517. }
  518. for(var i=0;i<children.length;i++){
  519. sum+=me.getChildrenCount(children[i].ID,data);
  520. }
  521. return children.length+sum;
  522. },
  523. ifFeeRateEdit:function (row,name) {
  524. if( name == 'mainSheet'){
  525. var selected = projectObj.project.mainTree.items[row];
  526. return selected&&MainTreeCol.readOnly.forFeeRate(selected)?false:true;
  527. }
  528. return true;
  529. },
  530. createSpreadView:function () {
  531. if (this.mainViews) {
  532. this.mainViews.destroy();
  533. this.mainViews = null;
  534. }
  535. if(subRateObject.views){
  536. subRateObject.views.destroy();
  537. subRateObject.views = null;
  538. }
  539. this.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  540. this.datas = this.activateFeeRate.rates;
  541. var rateColSetting = _.find(this.columns,{"id":"rate"});
  542. rateColSetting?rateColSetting.format=getFormatter(getDecimal("feeRate")):"";
  543. this.mainViews = new GC.Spread.Views.DataView($('#divFee')[0],
  544. this.dataSource, this.columns, new GC.Spread.Views.Plugins.GridLayout(this.options));
  545. this.mainViews["rowClick"].addHandler(subRateObject.reFreshRateViews);
  546. this.mainViews.invalidate();
  547. document.querySelector('#divFee').focus();
  548. },
  549. initFeeRateSpread:function (rowCount) {
  550. //初始化费用项表格
  551. this.mainFeeRateSpread = sheetCommonObj.buildSheet($('#divFee')[0], this.mainFeeRateSetting,rowCount);
  552. sheetCommonObj.spreadDefaultStyle(this.mainFeeRateSpread);
  553. this.mainFeeRateSpread.options.scrollbarMaxAlign = true;
  554. this.mainFeeRateSheet = this.mainFeeRateSpread.getSheet(0);
  555. if(!projectReadOnly){
  556. sheetCommonObj.lockCells(this.mainFeeRateSheet , this.mainFeeRateSetting);
  557. }
  558. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onMainFeeRateSheetValueChange);
  559. //this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onMainFeeRateSelectChanged);
  560. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMainFeeRateRangeChanged);
  561. this.mainFeeRateSheet.bind(GC.Spread.Sheets.Events.EditStarting, function (e,args) {
  562. let me =feeRateObject;
  563. if($.bootstrapLoading.isLoading()) args.cancel = true;
  564. if(!me.mainFeeRateEditChecking(args.row,args.col)){
  565. args.cancel = true;
  566. }
  567. });
  568. this.mainFeeRateSheet.name('mainFeeRateSheet');
  569. disableRightMenu("divFee",this.mainFeeRateSpread,this.rightClickCallback);
  570. //打开他人分享的项目、只读
  571. if(projectReadOnly){
  572. sheetCommonObj.disableSpread(this.mainFeeRateSpread);
  573. }
  574. },
  575. rightClickCallback:function (row) {
  576. let me = feeRateObject;
  577. me.onMainFeeRateSelect(row);
  578. },
  579. showMainFeeRateData:function () {
  580. let me = this;
  581. let selected = me.mainFeeRateSheet.getSelections()[0];
  582. me.activateFeeRate = projectObj.project.FeeRate.getActivateFeeRate();
  583. me.mainFeeRateData = projectObj.project.FeeRate.getActivateFeeRate().rates;
  584. me.mainFeeRateSheet.setRowCount(0);
  585. me.mainFeeRateSheet.setRowCount(me.mainFeeRateData.length);
  586. me.showFeeRateTree(me.mainFeeRateSheet,me.mainFeeRateSetting,me.mainFeeRateData);
  587. me.mainFeeRateSheet.setSelection(selected.row,selected.col,selected.rowCount,selected.colCount);
  588. },
  589. reFreshRateViews:function() {
  590. feeRateObject.loadPageContent();
  591. this.showMainFeeRateData();
  592. if(subRateObject.subRateSpread){//如果子费率没有初始化过的话,不需要显示。
  593. subRateObject.initSubRateSpread(this.mainFeeRateData[0]);
  594. }
  595. },
  596. mainFeeRateEditChecking:function (row,col) {//false 不能编辑,true 可以编辑
  597. let me =feeRateObject;
  598. let recode = me.mainFeeRateData[row];
  599. let dataCode = me.mainFeeRateSetting.header[col].dataCode;
  600. if(dataCode=="rate"&&me.getChildrenCount(recode.ID,me.mainFeeRateData)>0){//有子节点时不能编辑费率列
  601. return false;
  602. }
  603. return true;
  604. },
  605. onMainFeeRateSheetValueChange:function (e,info) {
  606. feeRateObject.updateFeerateWhenCellsChange([info]);
  607. },
  608. onMainFeeRateRangeChanged:function (e,info) {
  609. let me = feeRateObject;
  610. let changeCells = [];
  611. for(let c of info.changedCells){
  612. let tem = {
  613. row:c.row,
  614. col:c.col,
  615. newValue:info.sheet.getCell(c.row,c.col).value()
  616. };
  617. changeCells.push(tem);
  618. }
  619. me.updateFeerateWhenCellsChange(changeCells);
  620. },
  621. updateFeerateWhenCellsChange:function (cells) {// col,row,newValue
  622. let me = feeRateObject,updateDatas = [],feeRate = projectObj.project.FeeRate;//[{rateID:rateID,doc:doc}]
  623. let refreshA = [];//记录刷新条数的数组
  624. for(let c of cells){
  625. let temData = {};
  626. let recode = me.mainFeeRateData[c.row];
  627. let fieldID = me.mainFeeRateSetting.header[c.col].dataCode;
  628. let value = c.newValue;
  629. let oldValue = recode[fieldID];
  630. if(!me.mainFeeRateEditChecking(c.row, c.col)){
  631. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  632. continue;
  633. }else if(fieldID == 'rate'&&value !== null && value!==0){
  634. let checkResult = scMathUtil.isNumOrFormula(value);
  635. if(checkResult!=null && !isNaN(checkResult)){
  636. value = scMathUtil.roundForObj(checkResult,getDecimal("feeRate"));
  637. }else {
  638. alert('当前输入的数据类型不正确,请重新输入。');
  639. me.mainFeeRateSheet.setValue(c.row, c.col, oldValue);
  640. continue;
  641. }
  642. }
  643. if(recode[fieldID] == value){//没有改变
  644. continue;
  645. }
  646. temData[fieldID] = value ;
  647. updateDatas.push({rateID:recode.ID,doc:temData});
  648. refreshA.push({col:c.col,row:c.row,fieldID:fieldID,value:value,rateItem:recode,rateID:recode.ID});
  649. }
  650. if(updateDatas.length > 0){
  651. $.bootstrapLoading.start();
  652. feeRate.updateFeeRatesByIDs(updateDatas,function () {
  653. let feerateInfo = [];
  654. for(let r of refreshA){
  655. me.mainFeeRateSheet.setValue(r.row, r.col, r.value);
  656. if(r.fieldID == 'rate'){
  657. const foreColor = feeRateObject.rateShouldMark(r.rateItem, r.value) ? 'red' : 'black';
  658. me.mainFeeRateSheet.getCell(r.row, r.col).foreColor(foreColor);
  659. feerateInfo.push({rateID:r.rateID,value:r.value});
  660. }
  661. }
  662. if(feerateInfo.length > 0){
  663. feeRate.onFeeRatesChange(feerateInfo);
  664. }else {
  665. $.bootstrapLoading.end();
  666. }
  667. })
  668. }
  669. },
  670. onMainFeeRateSelectChanged:function (e, info) {
  671. let me = feeRateObject;
  672. let row = info.newSelections[0].row;
  673. me.onMainFeeRateSelect(row);
  674. },
  675. onMainFeeRateSelect:function (row) {
  676. let me = this;
  677. if(row!=-1){
  678. subRateObject.initSubRateSpread(me.mainFeeRateData[row]);
  679. }
  680. },
  681. updateBySelect:function (rate,selectMap,mapID) {
  682. let selected = this.mainFeeRateSheet.getSelections()[0];
  683. projectObj.project.FeeRate.backupDatas();
  684. let item = this.mainFeeRateData[selected.row];
  685. item.rate = rate;
  686. for(let key in selectMap){
  687. let recode = item.subFeeRate.recodes[key];
  688. let optionList = recode.optionList;
  689. for(let o of optionList){
  690. if(o.value==selectMap[key]){
  691. o.selected=true;
  692. }else {
  693. o.selected = false;
  694. }
  695. }
  696. }
  697. if($('#cascadeSet').prop('checked')){
  698. this.cascadeSetRates(item,selected.row,mapID,selectMap);
  699. }else {
  700. projectObj.project.FeeRate.batchUpdateFeeRate([{rateIndex:selected.row,rate:item}],feeRateObject.activateFeeRate);
  701. }
  702. },
  703. setRateFromSub:function (subRate,value,subList,editText,feeRateCoe) {//editText 下拉框选择的值,对于如“19.00”这样下拉选择项,value会变成19,所以在valueMap里找的时候要用editText去查找
  704. let me = feeRateObject,feeRate = projectObj.project.FeeRate;
  705. let rates = feeRate.getActivateFeeRate().rates;
  706. let updateDatas = [];
  707. //对于有子节点的记录和可输入的记录,只支持一个参数(因为还要内插法取费率值),如果要支持两个以上的参数,valueMap要再改下~~~~
  708. for(let r of rates){
  709. if(gljUtil.isDef(r.subFeeRate)){
  710. let valueArray=[];//用来存参数的值 //这里和养护的不一样,这里下拉框是{text:value}的形式,那里是直接下匹配
  711. let temP =null;//这个用来存储需要内插法记算的时候,同时,树节点的子节点改变也计在这里, 这样,改变temP的值,会体现在保存subRecode
  712. let match = false;
  713. let temR = _.cloneDeep(r);//临时存储
  714. for(let p of temR.subFeeRate.recodes){
  715. if(p.name == subRate.name){
  716. temP = p;
  717. match = true;
  718. }
  719. let setValue = false;
  720. for(let o of p.optionList){
  721. if(match == true) {//匹配上了,改对应的selected 为 true
  722. if(o.value == value){//这里和养护的不一样,这里下拉框是{text:value}的形式,那里是直接下匹配
  723. o.selected = true;
  724. valueArray.push(value);
  725. setValue = true;
  726. }else {
  727. o.selected = false;
  728. }
  729. }else {//没有匹配上的,直接取值就可以(这个是为多参数时用的,但是目前来看,不支持多参数,比较麻烦)
  730. if(o.selected == true) valueArray.push(o.value);
  731. }
  732. }
  733. if(match==true && setValue ==false) valueArray.push(value);//如果匹配上了,但是setValue为false,说明没有满足和选项,要用内插法或超出倍数算值
  734. }
  735. if(match == true){//说明要改rate的值,先从valueMap中去查
  736. if(subList && temP.subList && temP.subList.length > 0){
  737. temP.subList = subList;// 设置树节点的子节点的值
  738. }
  739. let doc = {"subFeeRate":temR.subFeeRate};
  740. let valueKey = valueArray.join('-');
  741. let valueMaps = r.subFeeRate.valueMaps;
  742. if(me.feeRateSpecialHandle){//不同编办特殊处理
  743. let sf = me.feeRateSpecialHandle(subRate,value);
  744. if(!_.isEmpty(sf)){
  745. valueKey = sf.valueKey;
  746. temP.value = sf.value;
  747. }
  748. }
  749. let rate = _.find(valueMaps,{"ID":valueKey});
  750. if(isDef(rate)) {//找到了,直接改费率值
  751. doc.rate = rate.value;
  752. } else {//没找到,用内插法或步长算值
  753. let ltRate = null;//
  754. let gtRate = null;
  755. temP.value = scMathUtil.roundForObj(value,getDecimal("feeRate")) ;
  756. for(let v of valueMaps){
  757. if(parseFloat(v.ID)<parseFloat(value)){
  758. ltRate = v;
  759. }else if( gtRate==null && parseFloat(v.ID)>parseFloat(value)){
  760. gtRate = v;
  761. }
  762. }
  763. if(gljUtil.isDef(ltRate)&&gljUtil.isDef(gtRate)){//已经找到前后的值了
  764. let step = scMathUtil.roundForObj(gtRate.value - ltRate.value,getDecimal("process"));
  765. let total = parseFloat(gtRate.ID) - parseFloat(ltRate.ID)
  766. doc.rate =getRateByStep(ltRate.value,total,parseFloat(value) - parseFloat(ltRate.ID),step);
  767. }else if(gljUtil.isDef(ltRate)&&gtRate == null){//说明是超出了选项的最大值
  768. let share = parseFloat(value) - parseFloat(ltRate.ID);//超出了多少
  769. doc.rate = getRateByStep(ltRate.value,temP.step,share,temP.amount)
  770. }else if(gljUtil.isDef(gtRate)&&ltRate==null){//说明是只有一个选项,且这个选项比输入的值大
  771. let step = parseFloat(gtRate.value)- 0;
  772. doc.rate = getRateByStep(0,gtRate.value,value,step)
  773. }
  774. }
  775. if(isDef(doc.rate)){
  776. if(feeRateCoe) doc.rate = scMathUtil.roundForObj(doc.rate * feeRateCoe,getDecimal("feeRate")); //如果是从乘系数过来的,乘以系数。
  777. updateDatas.push({rateID:r.ID,doc:doc});
  778. }
  779. }
  780. }
  781. }
  782. if(updateDatas.length > 0){
  783. $.bootstrapLoading.start();
  784. feeRate.updateFeeRatesByIDs(updateDatas,async function () {
  785. let feerateInfo = [];
  786. for(let u of updateDatas){
  787. feerateInfo.push({rateID:u.rateID,value:u.doc["rate"]});
  788. }
  789. subRateObject.showSubRateData();
  790. me.showMainFeeRateData();
  791. if(feerateInfo.length > 0){
  792. await feeRate.onFeeRatesChange(feerateInfo);
  793. }else {
  794. $.bootstrapLoading.end();
  795. }
  796. })
  797. }
  798. function getRateByStep(ltValue,total,share,step) { //min值 ,计算值的总区间, 区间中占比,步长--后端重选标准也要用到
  799. let p = scMathUtil.roundForObj(share/total,getDecimal("process"));
  800. let a = scMathUtil.roundForObj(step * p,getDecimal("process")) ;
  801. return scMathUtil.roundForObj(ltValue + a,getDecimal("feeRate"))
  802. }
  803. },
  804. cascadeSetRates:function(selectedItem,sourceRow,mapID,selectMap){
  805. let items=[];
  806. items.push({rateIndex:sourceRow,rate:selectedItem});
  807. _.forEach(this.mainFeeRateData,function (recode,Index) {
  808. if(Index!=sourceRow&&recode.subFeeRate){
  809. let valueMaps = recode.subFeeRate.valueMaps;
  810. let valueMap = _.find(valueMaps,{ID:mapID});
  811. if(valueMap){//选项完全一样的情况
  812. if(valueMap.value==recode.rate){
  813. return;
  814. }else {
  815. recode.rate = valueMap.value;
  816. _.forEach(selectMap,function (value,key) {
  817. let tempRecode = recode.subFeeRate.recodes[key];
  818. let optionList = tempRecode.optionList;
  819. for(let o of optionList){
  820. o.value===value? o.selected = true:o.selected = false;
  821. }
  822. });
  823. items.push({rateIndex:Index,rate:recode});
  824. }
  825. }else {//某条选项一样的情况
  826. let needUpdate = false;
  827. let selectList = mapID.split('-');
  828. let newList=[];
  829. _.forEach(recode.subFeeRate.recodes,function (r) {
  830. let oList = r.optionList, oldSelectIndex=0, hasChange=false;
  831. _.forEach(oList,function (o,key) {
  832. if(o.selected) oldSelectIndex = key;
  833. if(_.includes(selectList,o.value)){
  834. needUpdate=true;
  835. o.selected=true;
  836. hasChange=true;
  837. newList.push(o.value);
  838. }else {
  839. o.selected=false;
  840. }
  841. });
  842. if(!hasChange){
  843. oList[oldSelectIndex].selected=true;
  844. newList.push(oList[oldSelectIndex].value)
  845. }
  846. });
  847. if(needUpdate){
  848. let newValue = _.find(valueMaps,{ID:newList.join("-")})//取出费率值并更新
  849. if(newValue){
  850. if(recode.rate != newValue.value){
  851. recode.rate = newValue.value;
  852. items.push({rateIndex:Index,rate:recode});
  853. }
  854. }
  855. }
  856. }
  857. }
  858. });
  859. projectObj.project.FeeRate.batchUpdateFeeRate(items,feeRateObject.activateFeeRate);
  860. },
  861. loadPageContent:function(){
  862. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  863. var usageProjects = feeRateFile.usageProjects;
  864. $('#feeRateFileName').text(feeRateFile.name);
  865. $('#feeRateLibName').text(feeRateFile.libName);
  866. $('#projectCount').text(usageProjects.length);
  867. },
  868. loadFeeRateSelection:function() {
  869. if(!this.selectionLoad){
  870. var selectedID=0;
  871. _.forEach(projectObj.project.FeeRate.datas,function (data) {
  872. var option = $("<option>").val(data.ID).text(data.libName);
  873. $('#inlineFormCustomSelect').append(option);
  874. if(data.status=='activate'){
  875. selectedID=data.ID;
  876. }
  877. })
  878. $('#inlineFormCustomSelect').val(selectedID);
  879. }
  880. },
  881. getFeeRateStandards:function (callback) {
  882. CommonAjax.post('/feeRates/getFeeRateStandards', {"projectID": projectObj.project.ID()}, function (data) {
  883. if (data) {
  884. callback(data);
  885. }
  886. });
  887. },
  888. changeFeeRateStandard:function(newVal){
  889. $.bootstrapLoading.start();
  890. var callback=function () {
  891. feeRateObject.reFreshRateViews();
  892. $.bootstrapLoading.end();
  893. };
  894. projectObj.project.FeeRate.changeFeeRateStandard(newVal,callback);
  895. },
  896. checkFeeRateName:function (newVal) {
  897. if(!newVal||newVal==""){
  898. //$('#saveAsConfirm').attr("disabled","disabled");
  899. $('#nameError').text("请输入文件名称。").show();
  900. return;
  901. }
  902. var callback=function (data) {
  903. if(data){
  904. // $('#saveAsConfirm').attr("disabled","disabled");
  905. $('#nameError').text("已存在同名费率文件。").show();
  906. $('#valid_name').val('');
  907. }else {
  908. $('#valid_name').val(newVal);
  909. $('#saveAsConfirm').removeAttr("disabled");
  910. $('#nameError').hide();
  911. }
  912. };
  913. projectObj.project.FeeRate.checkFeeRateName(newVal,callback);
  914. },
  915. feeRateFileSaveAs:function (newName) {
  916. if(!newName||newName==""){
  917. // $('#saveAsConfirm').attr("disabled","disabled");
  918. $('#nameError').text("请输入文件名称。").show();
  919. return;
  920. }
  921. let callback=function (data) {
  922. if(data){
  923. // $('#saveAsConfirm').attr("disabled","disabled");
  924. $('#nameError').text("已存在同名费率文件。").show();
  925. $('#valid_name').val('');
  926. }else {
  927. feeRateObject.submitSaveAs(newName);
  928. }
  929. }
  930. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  931. /* let valideName = $('#valid_name').val();
  932. if(valideName==''||valideName!==newName){
  933. }else {
  934. feeRateObject.submitSaveAs(newName);
  935. }*/
  936. },
  937. submitSaveAs:function (newName) {
  938. let me = this;
  939. let FeeRate = projectObj.project.FeeRate;
  940. FeeRate.feeRateFileSaveAs(newName,function (result) {
  941. me.activateFeeRate = result;
  942. me.loadPageContent();
  943. $('#copy-lv').modal('hide');
  944. let data ={
  945. projectID:projectObj.project.ID(),
  946. oldRoom:socketObject.roomInfo.feeRate,
  947. newRoom: FeeRate.getActivateFeeRateFileID(),
  948. userID:userID,
  949. name:'feeRate'
  950. };
  951. socket.emit('changeNewRoom',data);
  952. socketObject.roomInfo.feeRate = FeeRate.getActivateFeeRateFileID();
  953. $.bootstrapLoading.end();
  954. });
  955. },
  956. getChangeInfo:function () {
  957. var me = this;
  958. var callback=function (data) {
  959. me.changeInfo=data;
  960. me.loadChangePageContent(data);
  961. };
  962. projectObj.project.FeeRate.getChangeInfo(callback);
  963. },
  964. loadChangePageContent:function (data) {
  965. $('#currentProject').text(data.currentProject.name);
  966. $('#currentOptions').empty();
  967. _.forEach(data.currentProject.currentOptions,function (s) {
  968. var option = $("<option>").val(s.ID).text(s.name);
  969. $('#currentOptions').append(option);
  970. })
  971. $('#otherProject').empty();
  972. _.forEach(data.others,function (p) {
  973. var option = $("<option>").val(p.ID).text(p.name);
  974. $('#otherProject').append(option);
  975. });
  976. $('#otherFeeRateOption').empty();
  977. if(data.others.length>0){
  978. _.forEach(data.others[0].optionList,function (f) {
  979. var option = $("<option>").val(f.ID).text(f.name);
  980. $('#otherFeeRateOption').append(option);
  981. });
  982. }
  983. },
  984. changeFeeRateFileFromCurrent:function(){
  985. $.bootstrapLoading.start();
  986. var newVal = $("#currentOptions").val();
  987. if(!$("#currentOptions").val()){
  988. if($.bootstrapLoading.isLoading()){
  989. $.bootstrapLoading.end();
  990. }
  991. alert('费率文件不可为空');
  992. return;
  993. }
  994. if($("#currentOptions").val()==this.activateFeeRate.ID){
  995. return;
  996. }
  997. var name =$("#currentOptions").find("option:selected").text();
  998. var newFeeRateFile = {
  999. id:newVal,
  1000. name:name
  1001. }
  1002. var callback=function () {
  1003. feeRateObject.reFreshRateViews();
  1004. projectObj.project.FeeRate.onFeeRateFileChange();
  1005. $.bootstrapLoading.end();
  1006. }
  1007. projectObj.project.FeeRate.changeFeeRateFileFromCurrent(newFeeRateFile,callback);
  1008. },
  1009. changeFeeRateFileFromOthers:function () {
  1010. var feeRateFileID = $("#otherFeeRateOption").val();
  1011. var name =$("#otherFeeRateOption").find("option:selected").text();
  1012. if(null===feeRateFileID){
  1013. alert("请选择一个费率文件!");
  1014. return;
  1015. }
  1016. var callback=function (data) {
  1017. if(data){
  1018. //$('#renameConfirm').attr("disabled","disabled");
  1019. $('#renameError').text("本建设项目中已存在同名费率文件。").show();
  1020. $('#rename-lv').modal('show');
  1021. $("#newFeeRateID").val(feeRateFileID);
  1022. $("#newFeeRateName").val(name);
  1023. }else {
  1024. //$('#renameConfirm').removeAttr("disabled");
  1025. $('#renameError').hide();
  1026. feeRateObject.changeFeeRateFileConfirm(feeRateFileID,name);
  1027. }
  1028. };
  1029. projectObj.project.FeeRate.checkFeeRateName(name,callback);
  1030. /* var currentOption = _.find(this.changeInfo.currentProject.currentOptions,{name:name})
  1031. if(currentOption){
  1032. $("#rename-lv").modal({show:true});
  1033. $("#newFeeRateID").val(feeRateFileID);
  1034. $("#newFeeRateName").val(name);
  1035. }else {
  1036. this.changeFeeRateFileConfirm(feeRateFileID,name);
  1037. }*/
  1038. },
  1039. changeFeeRateFileConfirm:function(feeRateFileID,name){
  1040. $.bootstrapLoading.start();
  1041. var callback=function () {
  1042. feeRateObject.reFreshRateViews();
  1043. projectObj.project.FeeRate.onFeeRateFileChange();
  1044. $.bootstrapLoading.end();
  1045. }
  1046. projectObj.project.FeeRate.changeFeeRateFileFromOthers(feeRateFileID,name,callback);
  1047. },
  1048. setFeeRateCellCol:function (sheet,col) {
  1049. sheet.getRange(-1, col, -1, 1).cellType(this.getFeeRateEditCellType());
  1050. },
  1051. onCellClick:function (sender,args) {
  1052. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  1053. feeRateObject.feeRateSelection=data[args.row];
  1054. },
  1055. onCellDoubleClick:function (sender,args) {
  1056. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  1057. feeRateObject.feeRateSelection=data[args.row];
  1058. feeRateObject.submitFeeRateBySelect();
  1059. },
  1060. checkSelectedFeeRate:function () {
  1061. var validate = false;
  1062. var data =projectObj.project.FeeRate.getActivateFeeRate().rates;
  1063. if(feeRateObject.feeRateSelection!=null){
  1064. var children=_.filter(data,{'ParentID':feeRateObject.feeRateSelection.ID});
  1065. validate=children&&children.length==0;
  1066. }
  1067. return validate;
  1068. },
  1069. submitFeeRateFromBill:function () {
  1070. var rate = feeRateObject.feeRateSelection;
  1071. var selected = projectObj.project.mainTree.selected;
  1072. if(selected.data.feeRateID === parseInt(rate.ID)) return $("#calcBaseFeeRate").modal('hide');
  1073. $.bootstrapLoading.start();
  1074. projectObj.project.FeeRate.submitFeeRateFromBill(rate,selected.data,function (data) {
  1075. selected.data.feeRateID= parseInt(rate.ID);
  1076. selected.data.feeRate=scMathUtil.roundToString(rate.rate,getDecimal("feeRate"));
  1077. selected.changed = true;
  1078. projectObj.project.calcProgram.calcAndSave(selected);
  1079. $("#calcBaseFeeRate").modal('hide');
  1080. $.bootstrapLoading.end();
  1081. });
  1082. },
  1083. submitFeeRateFromCalc:function () {
  1084. var rate = feeRateObject.feeRateSelection;
  1085. var calInfo = calcProgramManage.getSelectionInfo();
  1086. calInfo.calcItem.feeRateID=rate.ID;
  1087. calInfo.calcItem.feeRate=null;
  1088. var data={'projectID': projectObj.project.ID(),'templatesID': calInfo.template.ID,'calcItem': calInfo.calcItem};
  1089. $.bootstrapLoading.start();
  1090. calcProgramManage.saveCalcItem(data,function (result) {
  1091. calInfo.calcItem.feeRate=rate.rate;
  1092. projectObj.project.calcProgram.compileAllTemps();
  1093. projectObj.project.calcProgram.calcAllNodesAndSave();
  1094. calcProgramManage.refreshDetailSheet();
  1095. $("#calcBaseFeeRate").modal('hide');
  1096. $.bootstrapLoading.end();
  1097. });
  1098. console.log(calInfo);
  1099. },
  1100. submitFeeRateBySelect:function () {
  1101. var validate = this.checkSelectedFeeRate();
  1102. if(validate){
  1103. if($('#edit_from').val()=='calc_detail'){
  1104. this.submitFeeRateFromCalc();
  1105. }else {
  1106. this.submitFeeRateFromBill();
  1107. }
  1108. }else {
  1109. //$("#fee_rate_tree").modal('hide');
  1110. }
  1111. }
  1112. }
  1113. function getPopoverContent() {
  1114. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  1115. var usageProjects = feeRateFile.usageProjects;
  1116. let names = _.map(usageProjects,'name');
  1117. let popover_content = names.join('<br>');
  1118. return "费率的变化,将自动影响以下单位工程造价:<br>"+ popover_content;
  1119. }
  1120. $(function(){
  1121. $('#pop-lv').tooltip({
  1122. placement:"bottom",
  1123. html:true,
  1124. trigger:"hover | focus",
  1125. title:getPopoverContent
  1126. }
  1127. );
  1128. $('#tab_fee_rate').on('shown.bs.tab', function (e) {
  1129. sessionStorage.setItem('mainTab', '#tab_fee_rate');
  1130. let me = feeRateObject;
  1131. $(e.relatedTarget.hash).removeClass('active');
  1132. if(me.mainFeeRateSpread == null) me.initFeeRateSpread(0);
  1133. subRateObject.initSubRateSpread();
  1134. me.showMainFeeRateData();
  1135. me.loadPageContent();
  1136. });
  1137. $('#setNewFeeRate').bind('click', function () {
  1138. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  1139. var usageProjects = feeRateFile.usageProjects;
  1140. var listString ='';
  1141. _.forEach(usageProjects,function (u) {
  1142. listString+="<li>"+u.name+"</li>"
  1143. })
  1144. $("#usageProjectList").html(listString);
  1145. $("#set-lv-feeRateName").text(feeRateFile.name);
  1146. $("#set-use-feeRateName").text(feeRateFile.name);
  1147. feeRateObject.getFeeRateStandards(function (data) {
  1148. $('#standardSelect').empty();
  1149. _.forEach(data,function (s) {
  1150. var option = $("<option>").val(s.ID).text(s.libName);
  1151. $('#standardSelect').append(option);
  1152. })
  1153. $('#standardSelect').val(feeRateFile.libID);
  1154. });
  1155. });
  1156. $('#changeConfirm').bind('click', function (){
  1157. var newVal=$('#standardSelect').val();
  1158. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  1159. feeRateObject.changeFeeRateStandard(newVal);
  1160. //这里改成不判断了,只是点击确定了就重选
  1161. //if(newVal&&newVal!=feeRateFile.libID) feeRateObject.changeFeeRateStandard(newVal);
  1162. });
  1163. $('#saveAsFeeRate').bind('click', function (){
  1164. var feeRateFile = projectObj.project.FeeRate.getActivateFeeRate();
  1165. $('#copyFeeRateName').val(feeRateFile.name+'副本');
  1166. $('#valid_name').val(feeRateFile.name+'副本');
  1167. $('#nameError').hide();
  1168. });
  1169. $('#saveAsConfirm').bind('click',function () {
  1170. feeRateObject.feeRateFileSaveAs($('#copyFeeRateName').val());
  1171. })
  1172. $('#copyFeeRateName').change(function () {
  1173. feeRateObject.checkFeeRateName(this.value);
  1174. });
  1175. $('#newFeeRateName').change(function () {
  1176. var newName = $(this).val();
  1177. if(!newName||newName==""){
  1178. //$('#renameConfirm').attr("disabled","disabled");
  1179. $('#renameError').text("请输入文件名称。").show();
  1180. return;
  1181. }
  1182. var callback=function (data) {
  1183. if(data){
  1184. //$('#renameConfirm').attr("disabled","disabled");
  1185. $('#renameError').text("本建设项目中已存在同名费率文件。").show();
  1186. }else {
  1187. //$('#renameConfirm').removeAttr("disabled");
  1188. $('#renameError').hide();
  1189. }
  1190. };
  1191. projectObj.project.FeeRate.checkFeeRateName(newName,callback);
  1192. });
  1193. $('#changeFeeRateConfirm').bind('click',function (){
  1194. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  1195. if(radioV==='0'){
  1196. feeRateObject.changeFeeRateFileFromCurrent();
  1197. }else {
  1198. feeRateObject.changeFeeRateFileFromOthers();
  1199. }
  1200. })
  1201. $('#changFeeRateFile').bind('click',function (){
  1202. $("input[name='chaneg-lv-Radio']")[0].checked=true;
  1203. $("#fromProject").show();
  1204. $("#fromOther").hide();
  1205. feeRateObject.getChangeInfo();
  1206. })
  1207. $('#otherProject').change(function(){
  1208. var newVal = $(this).val();
  1209. var projects = feeRateObject.changeInfo.others;
  1210. var selected = _.find(projects,{ID:parseInt(newVal)});
  1211. $('#otherFeeRateOption').empty();
  1212. _.forEach(selected.optionList,function (f) {
  1213. var option = $("<option>").val(f.ID).text(f.name);
  1214. $('#otherFeeRateOption').append(option);
  1215. });
  1216. })
  1217. $('#renameConfirm').bind('click',function (){
  1218. var feeRateFileID= $("#newFeeRateID").val();
  1219. var name = $("#newFeeRateName").val();
  1220. var callback=function (data) {
  1221. if(data){
  1222. $('#renameError').text("已存在同名费率文件。").show();
  1223. $("#newFeeRateID").val(feeRateFileID);
  1224. $("#newFeeRateName").val(name);
  1225. }else {
  1226. $('#renameError').hide();
  1227. $('#rename-lv').modal('hide');
  1228. feeRateObject.changeFeeRateFileConfirm(feeRateFileID,name);
  1229. }
  1230. };
  1231. projectObj.project.FeeRate.checkFeeRateName(name,callback);
  1232. })
  1233. $('#inlineFormCustomSelect').change(function(){
  1234. var updateTask = [];
  1235. var selectID = $(this).val();
  1236. var oldValue=0;
  1237. _.forEach(projectObj.project.FeeRate.datas,function (feeRate) {
  1238. if(feeRate.status=='activate'){
  1239. oldValue=feeRate.ID;
  1240. }
  1241. if(feeRate.ID ==selectID){
  1242. feeRate.status='activate';
  1243. }else {
  1244. feeRate.status='disable';
  1245. }
  1246. updateTask.push({query:{ID:feeRate.feeRateID},doc:{status:feeRate.status}});
  1247. })
  1248. projectObj.project.FeeRate.updateStatusBySelected(updateTask);
  1249. feeRateObject.createSpreadView();
  1250. subRateObject.destorySpreadView();
  1251. socket.emit('changeActivateFeeRate',{oldRoom:oldValue,newRoom:selectID});
  1252. })
  1253. $('#calcBaseFeeRate').on('shown.bs.modal', function (e) {
  1254. let toggle = $('#calcBaseFeeRateConf').attr('toggle');
  1255. if(feeRateObject.feeRateSpreads==null){
  1256. feeRateObject.createSheet();
  1257. }
  1258. feeRateObject.initFeeRateEditDiv();
  1259. feeRateObject.feeRateSelection=null;
  1260. feeRateObject.showFeeRateTree(feeRateObject.feeRateSheet,feeRateObject.sheetSetting,projectObj.project.FeeRate.getActivateFeeRate().rates);
  1261. feeRateObject.locate();
  1262. feeRateObject.feeRateSpreads.refresh();
  1263. });
  1264. $('#tabFeeRate').on('shown.bs.tab', function () {
  1265. if(feeRateObject.feeRateSpreads){
  1266. feeRateObject.feeRateSpreads.refresh();
  1267. }
  1268. });
  1269. $('#calcBaseFeeRate').on('hidden.bs.modal', function (e) {
  1270. if(feeRateObject.feeRateSpreads){
  1271. feeRateObject.feeRateSpreads.destroy();
  1272. feeRateObject.feeRateSpreads=null;
  1273. $('#edit_from').val('');
  1274. $('#edit_row').val('');
  1275. }
  1276. });
  1277. //fee_selected_conf
  1278. $('#calcBaseFeeRateConf').bind('click',function (){
  1279. let toggle = $(this).attr('toggle');
  1280. if(!toggle || toggle !== 'feeRate'){
  1281. return;
  1282. }
  1283. feeRateObject.submitFeeRateBySelect();
  1284. });
  1285. $("input[name='editFeeRateOptions']").each(function(){
  1286. $(this).click(function(){
  1287. let optins = $(this).val();
  1288. if(optins == "0"){
  1289. $("#selfDiv").show();
  1290. $("#fee_rate_sheet").hide();
  1291. }else {
  1292. $("#selfDiv").hide();
  1293. $("#fee_rate_sheet").show(function () {
  1294. feeRateObject.feeRateSpreads.refresh();
  1295. });
  1296. }
  1297. });
  1298. });
  1299. })
  1300. function changeFRadioClick() {
  1301. var radioV= $("input[name='chaneg-lv-Radio']:checked").val();
  1302. if(radioV==='0'){
  1303. $("#fromProject").show();
  1304. $("#fromOther").hide();
  1305. }else {
  1306. $("#fromProject").hide();
  1307. $("#fromOther").show();
  1308. }
  1309. }