glj_view_contextMenu.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527
  1. /**
  2. * Created by chen on 2017/7/25.
  3. */
  4. var gljContextMenu = {
  5. selectedRow :null,
  6. selectedCol:null,
  7. clipboard:null,
  8. loadGLJSpreadContextMenu: function () {
  9. $.contextMenu({
  10. selector: '#subSpread',
  11. build: this.onbuild,
  12. items: {
  13. "replace_glj": {
  14. name: '替换',
  15. icon: 'fa-sign-in',
  16. disabled: function () {
  17. var sheetData = gljOprObj.sheetData;
  18. if(gljOprObj.isInstallationNode(projectObj.project.mainTree.selected)){
  19. return true;
  20. }
  21. if(subSpread.getActiveSheetIndex()==0&&sheetData!=null&&sheetData.length>0&&gljContextMenu.selectedRow<sheetData.length){
  22. if(sheetData[gljContextMenu.selectedRow].isMixRatio==true){
  23. return true;
  24. }
  25. return false;
  26. }
  27. return true;
  28. },
  29. callback: function () {
  30. getGLJData('replace');
  31. },
  32. visible: function(key, opt){
  33. return subSpread.getActiveSheet().name()=='ration_glj';
  34. }
  35. },
  36. "add_glj": {
  37. name: '添加',
  38. icon: 'fa-sign-in',
  39. disabled: function () {
  40. var selected = projectObj.project.mainTree.selected;
  41. var sheetData = gljOprObj.sheetData;
  42. if(selected){
  43. if(selected.sourceType!=ModuleNames.ration){
  44. return true;
  45. }else if(selected.data.type!=rationType.ration){
  46. return true;
  47. }
  48. }
  49. if(subSpread.getActiveSheetIndex()==0&&sheetData!=null&&sheetData.length>0&&gljContextMenu.selectedRow<sheetData.length){
  50. if(sheetData[gljContextMenu.selectedRow].isMixRatio==true){
  51. return true;
  52. }
  53. }
  54. return false;
  55. },
  56. callback:function () {
  57. getGLJData('add');
  58. },
  59. visible: function(key, opt){
  60. return subSpread.getActiveSheet().name()=='ration_glj';
  61. }
  62. },
  63. "delete_glj": {
  64. name: '删除',
  65. icon: 'fa-remove',
  66. disabled: function () {
  67. var sheetData = gljOprObj.sheetData;
  68. if(gljOprObj.isInstallationNode(projectObj.project.mainTree.selected)){
  69. return true;
  70. }
  71. if(subSpread.getActiveSheetIndex()==0&&sheetData!=null&&sheetData.length>0&&gljContextMenu.selectedRow<sheetData.length){
  72. if( sheetData[gljContextMenu.selectedRow].isMixRatio==true){
  73. return true;
  74. }
  75. return false;
  76. }else {
  77. return true;
  78. }
  79. },
  80. callback: function () {
  81. var sheetData = gljOprObj.sheetData;
  82. var deleteRow = sheetData[gljContextMenu.selectedRow];
  83. projectObj.project.ration_glj.updataOrdelete(deleteRow);
  84. },
  85. visible: function(key, opt){
  86. return subSpread.getActiveSheet().name()=='ration_glj';
  87. }
  88. },
  89. "m_replace_glj": {
  90. name: '批量替换',
  91. icon: 'fa-sign-in',
  92. disabled: function () {
  93. let sheetData = gljOprObj.sheetData;
  94. if(gljOprObj.isInstallationNode(projectObj.project.mainTree.selected)){
  95. return true;
  96. }
  97. if(subSpread.getActiveSheetIndex()==0&&sheetData!=null&&sheetData.length>0&&gljContextMenu.selectedRow<sheetData.length){
  98. if(sheetData[gljContextMenu.selectedRow].isMixRatio==true){
  99. return true;
  100. }
  101. return false;
  102. }
  103. return true;
  104. },
  105. callback: function () {
  106. getGLJData('m_replace');
  107. },
  108. visible: function(key, opt){
  109. return subSpread.getActiveSheet().name()=='ration_glj';
  110. }
  111. },
  112. "add_to_lib": {
  113. name: '保存到我的人材机库',
  114. icon: 'fa-sign-in',
  115. disabled: function () {
  116. var sheetData = gljOprObj.sheetData;
  117. if(gljOprObj.isInstallationNode(projectObj.project.mainTree.selected)){
  118. return true;
  119. }
  120. if(subSpread.getActiveSheetIndex()==0&&sheetData!=null&&sheetData.length>0&&gljContextMenu.selectedRow<sheetData.length){
  121. var recode = sheetData[gljContextMenu.selectedRow];
  122. if(!(recode.isMixRatio!=true&&recode.isAdd==true)){
  123. return true
  124. }
  125. return false;
  126. // disable= recode.isMixRatio!=true&&recode.isAdd==true?false:true
  127. }
  128. return true;
  129. },
  130. callback: function () {
  131. var sheetData = gljOprObj.sheetData;
  132. var recode = sheetData[gljContextMenu.selectedRow];
  133. showGLJClassTree(recode);
  134. },
  135. visible: function(key, opt){
  136. return subSpread.getActiveSheet().name()=='ration_glj';
  137. }
  138. },
  139. "insert_detail": {
  140. name: '插入行',
  141. icon: 'fa-sign-in',
  142. disabled: function () {
  143. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  144. var sheetData = gljOprObj.detailData;
  145. if(gljOprObj.detailSheetReadonly()){
  146. return true
  147. }else {
  148. return gljContextMenu.selectedRow>sheetData.length;
  149. }
  150. }
  151. return false
  152. },
  153. callback: function () {
  154. projectObj.project.quantity_detail.insertQuantityDetail(gljContextMenu.selectedRow);
  155. },
  156. visible: function(key, opt){
  157. return subSpread.getActiveSheet().name()=='quantity_detail';
  158. }
  159. },
  160. "delete_detail": {
  161. name: '删除行',
  162. icon: 'fa-remove',
  163. disabled: function () {
  164. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  165. var sheetData = gljOprObj.detailData;
  166. return gljContextMenu.selectedRow>sheetData.length-1;
  167. }
  168. return false
  169. },
  170. callback:function () {
  171. projectObj.project.quantity_detail.deleteQuantityDetail(gljContextMenu.selectedRow);
  172. },
  173. visible: function(key, opt){
  174. return subSpread.getActiveSheet().name()=='quantity_detail';
  175. }
  176. },
  177. "move_up": {
  178. name: '上移',
  179. icon: 'fa-arrow-up',
  180. disabled: function () {
  181. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  182. var sheetData = gljOprObj.detailData;
  183. return gljContextMenu.selectedRow==0||gljContextMenu.selectedRow>sheetData.length-1;
  184. }
  185. return false;
  186. },
  187. callback: function () {
  188. projectObj.project.quantity_detail.moveUp(gljContextMenu.selectedRow);
  189. },
  190. visible: function(key, opt){
  191. return subSpread.getActiveSheet().name()=='quantity_detail';
  192. }
  193. },
  194. "move_down": {
  195. name: '下移',
  196. icon: 'fa-arrow-down',
  197. disabled: function () {
  198. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  199. var sheetData = gljOprObj.detailData;
  200. return gljContextMenu.selectedRow>sheetData.length-2;
  201. }
  202. return false;
  203. },
  204. callback: function () {
  205. projectObj.project.quantity_detail.moveDown(gljContextMenu.selectedRow);
  206. },
  207. visible: function(key, opt){
  208. return subSpread.getActiveSheet().name()=='quantity_detail';
  209. }
  210. },
  211. "copy": {
  212. name: '复制',
  213. icon: 'fa-files-o',
  214. disabled: function () {
  215. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  216. let sheet = subSpread.getActiveSheet();
  217. let sheetData = gljOprObj.detailData;
  218. let value = sheet.getCell(gljContextMenu.selectedRow,gljContextMenu.selectedCol).value();
  219. if(gljContextMenu.selectedRow>sheetData.length-1||value==null){
  220. return true;
  221. }
  222. if(gljOprObj.detailSetting.header[gljContextMenu.selectedCol].dataCode == 'isSummation'){//累加列恢显
  223. return true;
  224. }
  225. }
  226. return false;
  227. },
  228. callback: function () {
  229. gljContextMenu.clipboard={
  230. row:gljContextMenu.selectedRow,
  231. col:gljContextMenu.selectedCol
  232. };
  233. },
  234. visible: function(key, opt){
  235. return subSpread.getActiveSheet().name()=='quantity_detail';
  236. }
  237. },
  238. "paste": {
  239. name: '粘贴',
  240. icon: 'fa-clipboard',
  241. disabled: function () {
  242. if(subSpread.getActiveSheet().name()=='quantity_detail'){
  243. let sheetData = gljOprObj.detailData;
  244. let dataCode = gljOprObj.detailSetting.header[gljContextMenu.selectedCol].dataCode;
  245. if(gljContextMenu.selectedRow>sheetData.length||gljContextMenu.clipboard==null){
  246. return true;
  247. }
  248. //结果列和累加列灰显
  249. if(dataCode == 'result' || dataCode == 'isSummation'){
  250. return true;
  251. }
  252. }
  253. return false;
  254. },
  255. callback: function () {
  256. var sheet = subSpread.getActiveSheet();
  257. var c=gljContextMenu.clipboard;
  258. console.log(sheet.getCell(c.row,c.col).value());
  259. var args={
  260. 'row':gljContextMenu.selectedRow,
  261. 'col':gljContextMenu.selectedCol,
  262. 'editingText':sheet.getCell(c.row,c.col).value()
  263. }
  264. gljOprObj.onEditDetailSheet(args);
  265. },
  266. visible: function(key, opt){
  267. return subSpread.getActiveSheet().name()=='quantity_detail';
  268. }
  269. },
  270. "modify_rule": {
  271. name: '修改规则',
  272. icon: 'fa-sign-in',
  273. disabled: function () {//当选中空行或者ruleID为空的情况下,灰显
  274. if(subSpread.getActiveSheet().name()=='rationInstallSheet'){
  275. let sheetData = installationFeeObj.rationInstallData;
  276. if(gljContextMenu.selectedRow>sheetData.length-1){
  277. return true
  278. }
  279. let ri = sheetData[gljContextMenu.selectedRow];
  280. if(!ri.ruleId||ri.ruleId==''){
  281. return true;
  282. }
  283. }
  284. return false;
  285. },
  286. callback: function () {
  287. $("#modify_feeRule").modal({show:true});
  288. },
  289. visible: function(key, opt){
  290. return subSpread.getActiveSheet().name()=='rationInstallSheet';
  291. }
  292. },
  293. "apply_to_FX": {
  294. name: '应用到当前分项',
  295. icon: 'fa-sign-in',
  296. disabled: function () {
  297. if(subSpread.getActiveSheet().name()=='rationInstallSheet'){
  298. let sheetData = installationFeeObj.rationInstallData;
  299. if(gljContextMenu.selectedRow>sheetData.length-1){
  300. return true;
  301. }
  302. if(sheetData[gljContextMenu.selectedRow].unifiedSetting == 1){
  303. return true;
  304. }
  305. }
  306. return false;
  307. },
  308. callback: function () {
  309. installationFeeObj.applyRuleTo('FX',gljContextMenu.selectedRow);
  310. },
  311. visible: function(key, opt){
  312. return subSpread.getActiveSheet().name()=='rationInstallSheet';
  313. }
  314. },
  315. "apply_to_FB": {
  316. name: '应用到当前分部',
  317. icon: 'fa-sign-in',
  318. disabled: function () {
  319. if(subSpread.getActiveSheet().name()=='rationInstallSheet'){
  320. let sheetData = installationFeeObj.rationInstallData;
  321. if(gljContextMenu.selectedRow>sheetData.length-1){
  322. return true;
  323. }
  324. if(sheetData[gljContextMenu.selectedRow].unifiedSetting == 1){
  325. return true;
  326. }
  327. }
  328. return false;
  329. },
  330. callback: function () {
  331. installationFeeObj.applyRuleTo('FB',gljContextMenu.selectedRow);
  332. },
  333. visible: function(key, opt){
  334. return subSpread.getActiveSheet().name()=='rationInstallSheet';
  335. }
  336. },
  337. "apply_to_PRO": {
  338. name: '应用到当前项目',
  339. icon: 'fa-sign-in',
  340. disabled: function () {
  341. if(subSpread.getActiveSheet().name()=='rationInstallSheet'){
  342. let sheetData = installationFeeObj.rationInstallData;
  343. if(gljContextMenu.selectedRow>sheetData.length-1){
  344. return true;
  345. }
  346. if(sheetData[gljContextMenu.selectedRow].unifiedSetting == 1){
  347. return true;
  348. }
  349. }
  350. return false;
  351. },
  352. callback: function () {
  353. installationFeeObj.applyRuleTo('PJ',gljContextMenu.selectedRow);
  354. },
  355. visible: function(key, opt){
  356. return subSpread.getActiveSheet().name()=='rationInstallSheet';
  357. }
  358. }
  359. }
  360. });
  361. },
  362. onbuild:function ($trigger, e) {
  363. var target = SheetDataHelper.safeRightClickSelection($trigger, e, subSpread);
  364. gljContextMenu.selectedRow = target.row;
  365. gljContextMenu.selectedCol = target.col;
  366. if(subSpread.getActiveSheet().name() == 'ration_glj'){
  367. gljOprObj.sheetInitSelection({row: target.row, col: target.col});
  368. }
  369. //controller.setTreeSelected(controller.tree.items[target.row]);
  370. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  371. },
  372. initGLJSelectView: function () {
  373. if (gljOprObj.gljLibSpresd == undefined) {
  374. gljOprObj.gljLibSpresd = sheetCommonObj.buildSheet($('#gljLibSheet')[0], gljOprObj.gljLibSheetSetting, gljOprObj.stdGLJ.length + gljOprObj.complementaryGLJs.length);
  375. sheetCommonObj.spreadDefaultStyle(gljOprObj.gljLibSpresd);
  376. gljOprObj.gljLibSpresd.bind(GC.Spread.Sheets.Events.ButtonClicked, gljOprObj.onButtonClick);
  377. gljOprObj.gljLibSheet = gljOprObj.gljLibSpresd.getSheet(0);
  378. gljOprObj.gljLibSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, gljOprObj.onSelectionChanged);
  379. gljOprObj.gljLibSheet.setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  380. gljOprObj.gljLibSheet.options.isProtected = true;
  381. gljOprObj.gljLibSheet.name('glj_lib');
  382. }
  383. gljOprObj.gljLibSheetData = gljOprObj.AllRecode;
  384. let gljClass = 0, selectMap = {};
  385. if ($('#actionType').val() == 'add' || $('#actionType').val() == 'insert' || $('#actionType').val() == 'insertEquipment') {//插入,添加
  386. gljOprObj.GLJSelection = [];
  387. } else if($('#actionType').val() =='m_replace' || $('#actionType').val() == 'replace'){//替换、批量替换
  388. let selected = gljOprObj.sheetData[gljContextMenu.selectedRow];
  389. let connect_key = gljOprObj.getIndex(selected, gljKeyArray);
  390. gljOprObj.GLJSelection = [connect_key];
  391. selectMap[connect_key] = true;
  392. gljOprObj.filterLibGLJByType();
  393. }else if($('#actionType').val() =='addMix'|| $('#actionType').val() =='unitPriceAddMix'){//添加组成物
  394. gljOprObj.GLJSelection = [];
  395. projectGljObject.filterLibGLJForMixRatio();
  396. }
  397. for(let item of gljOprObj.gljLibSheetData){
  398. let item_key = gljOprObj.getIndex(item, gljLibKeyArray);
  399. if(selectMap[item_key]){
  400. item.select = 1 ;
  401. gljClass = item.gljClass;
  402. } else {
  403. item.select = 0;
  404. }
  405. }
  406. //替换,焦点定位至当前选中人材机
  407. if($('#actionType').val() =='m_replace' || $('#actionType').val() == 'replace'){
  408. gljOprObj.locateZTree(gljClass);
  409. let selected = gljOprObj.sheetData[gljContextMenu.selectedRow];
  410. let index = _.findIndex(gljOprObj.gljLibSheetData, {code: selected.code});
  411. gljOprObj.gljLibSheet.showRow(index, GC.Spread.Sheets.VerticalPosition.center);
  412. gljOprObj.gljLibSheet.setActiveCell(index, 0);
  413. gljOprObj.initSelection({row: index});
  414. gljOprObj.gljLibSpresd.focus(true);
  415. } else if ($('#actionType').val() === 'insertEquipment') {//右键插入设备,人材机选择窗口,应默认固定到分类"养护管理设备"。
  416. let locateClass = gljOprObj.treeData.std.find(function (stdClass) {
  417. return stdClass.Name === '养护管理设备';
  418. });
  419. if (locateClass) {
  420. gljClass = locateClass.ID;
  421. gljOprObj.locateZTree(gljClass);
  422. gljOprObj.gljLibSheet.showRow(0, GC.Spread.Sheets.VerticalPosition.top);
  423. gljOprObj.gljLibSheet.setActiveCell(0, 0);
  424. gljOprObj.initSelection({row: 0});
  425. }
  426. } else if ($('#actionType').val() === 'add') {
  427. gljOprObj.locateZTree(null);
  428. gljOprObj.gljLibSheet.showRow(0, GC.Spread.Sheets.VerticalPosition.top);
  429. gljOprObj.gljLibSheet.setActiveCell(0, 0);
  430. gljOprObj.initSelection({row: 0});
  431. } else {
  432. gljOprObj.showLibGLJSheetData();
  433. }
  434. }
  435. }
  436. function initLibOptions(libData) {
  437. const html = libData.reduce((acc, lib) => acc += `<option ${lib.isDefault ? 'selected="selected"' : ''} value="${lib.gljLibId}">${lib.name}</option>`, '');
  438. $('#glj-lib-select').html(html);
  439. }
  440. function getActionUrl(actionType) {
  441. const rootUrl = `/rationGlj/getGLJData/${commonConstants.COMPILATION}`
  442. switch (actionType) {
  443. case 'add':
  444. case 'addMix':
  445. case 'unitPriceAddMix':
  446. case 'insertEquipment':
  447. return `${rootUrl}/0/true`;
  448. case 'replace':
  449. case 'm_replace':
  450. const selected = gljOprObj.sheetData[gljContextMenu.selectedRow];
  451. const gljLibId = selected.repositoryId || commonConstants.COMPLEMENTARY_LIB;
  452. return `${rootUrl}/${gljLibId}/true`;
  453. case 'change': // 更改选择库
  454. const selectGLJLibID = $('#glj-lib-select').val();
  455. return `${rootUrl}/${selectGLJLibID}/false`;
  456. }
  457. }
  458. function getGLJData(actionType, isInitial = true,getLibFunc) {
  459. const url = getActionUrl(actionType);
  460. if (actionType === 'change') {
  461. actionType = $('#actionType').val();
  462. }
  463. $('#actionType').val(actionType);
  464. $.bootstrapLoading.start();
  465. if(!getLibFunc)getLibFunc = projectObj.project.ration_glj.getGLJData;
  466. getLibFunc(url, function (result) {
  467. // 目前只有浙江2015需要特殊处理处理
  468. if (gljOprObj.sortSelectViewGLJ) {
  469. gljOprObj.sortSelectViewGLJ(result.datas.stdGLJ);
  470. gljOprObj.sortSelectViewGLJ(result.datas.complementaryGLJs);
  471. } else {
  472. result.datas.stdGLJ = _.sortBy(result.datas.stdGLJ, 'code');
  473. result.datas.complementaryGLJs = _.sortBy(result.datas.complementaryGLJs, 'code');
  474. }
  475. gljOprObj.stdGLJ=result.datas.stdGLJ;
  476. gljOprObj.complementaryGLJs=result.datas.complementaryGLJs;
  477. for(let compleGlj of gljOprObj.complementaryGLJs){
  478. //是否新增
  479. compleGlj.isComplementary = true;
  480. }
  481. gljOprObj.AllRecode=gljOprObj.stdGLJ.concat(gljOprObj.complementaryGLJs);
  482. //gljOprObj.AllRecode=gljOprObj.stdGLJ;
  483. gljOprObj.distTypeTree=gljOprObj.getComboData(result.datas.distTypeTree);
  484. gljOprObj.treeData = result.datas.treeData;
  485. if (gljOprObj.treeData.std.length) {
  486. gljOprObj.initClassTree('std', gljOprObj.treeData.std, !isInitial);
  487. } else if (gljOprObj.treeData.comple.length) {
  488. gljOprObj.initClassTree('comple', gljOprObj.treeData.comple, !isInitial);
  489. }
  490. if (isInitial) {
  491. initLibOptions(result.datas.libData);
  492. $('#modalCon').width($(window).width()*0.5);
  493. if(actionType == "m_replace"){
  494. $('#glj_selected_conf').hide();
  495. $('#replace_next_btn').show();
  496. }else {
  497. $('#glj_selected_conf').show();
  498. $('#replace_next_btn').hide();
  499. }
  500. $("#glj_tree_div").modal({show:true});
  501. setTimeout(function(){
  502. gljOprObj.gljLibSpresd?gljOprObj.gljLibSpresd.refresh():'';
  503. }, 200);
  504. } else {
  505. gljContextMenu.initGLJSelectView();
  506. }
  507. $.bootstrapLoading.end();
  508. })
  509. }
  510. function showGLJClassTree(record) {
  511. let engineerID = projectObj.project.projectInfo.property.engineering_id;
  512. CommonAjax.post('/rationGlj/getGLJClass/'+engineerID,record, function (data) {
  513. if(data.exist==true){
  514. alert("当前人材机已存在。");
  515. }else {
  516. gljOprObj.selectedGLJClass = record;
  517. $("#glj_class_div").modal({show:true});
  518. zTreeHelper.createTree(data.items, gljOprObj.gljTreeSetting, "classTree", gljOprObj);
  519. }
  520. })
  521. }