sub_view.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583
  1. /**
  2. * Created by CSL on 2017-07-04.
  3. */
  4. //modified by zhong on 2017-08-30
  5. // Tab panes 下有多个Spread时,相互之间不能正确显示。改成一个Spread下多个Sheet。
  6. //特征及内容spread,解决不能正确显示spread
  7. //zhang 5-31 删除附注条件、辅助定额tab,增加子目换算tab
  8. let subSpread = null;
  9. let subObj = {
  10. initSubSpread:function () {
  11. contentOprObj.buildSheet($("#jobSpread")[0]);
  12. //sheetCommonObj.bindEscKey(contentOprObj.workBook, [{sheet: contentOprObj.workBook.getSheet(0), editStarting: contentOprObj.onEditStart, editEnded: contentOprObj.onEditEnded}]);
  13. sheetCommonObj.spreadDefaultStyle(contentOprObj.workBook);
  14. characterOprObj.buildSheet($("#itemSpread")[0]);
  15. //sheetCommonObj.bindEscKey(characterOprObj.workBook, [{sheet: characterOprObj.workBook.getSheet(0), editStarting: characterOprObj.onEditStart, editEnded: characterOprObj.onEditEnded}]);
  16. sheetCommonObj.spreadDefaultStyle(characterOprObj.workBook);
  17. $("#tzjnrCon").hide();
  18. $("#subSpread").show();
  19. subSpread = sheetCommonObj.createSpread($("#subSpread")[0], 4);
  20. sheetCommonObj.spreadDefaultStyle(subSpread);
  21. subSpread.options.allowUserDragDrop = false;
  22. subSpread.options.allowUserDragFill = false;
  23. subSpread.getSheet(2).name('JSCX');
  24. pageCCOprObj.active = false;
  25. // 工料机
  26. gljOprObj.initSheet(subSpread.getSheet(0));
  27. //sheetCommonObj.shieldAllCells(subSpread.getSheet(0), gljOprObj.setting);
  28. SheetDataHelper.protectdSheet(subSpread.getSheet(0));
  29. // assistOprObj.initSheet(subSpread.getSheet(1));
  30. // sheetCommonObj.shieldAllCells(subSpread.getSheet(1), assistOprObj.setting);
  31. if(!projectReadOnly){
  32. gljContextMenu.loadGLJSpreadContextMenu();
  33. }
  34. //工程量明细
  35. gljOprObj.initDetailSheet(subSpread.getSheet(1));
  36. SheetDataHelper.protectdSheet(subSpread.getSheet(1));
  37. //安装增加费
  38. installationFeeObj.initRationInstallSheet(subSpread.getSheet(3));
  39. SheetDataHelper.protectdSheet(subSpread.getSheet(3));
  40. //绑定esc
  41. let subEscSheets = [];
  42. subEscSheets.push({sheet: subSpread.getSheet(0), editStarting: gljOprObj.editChecking, editEnded: gljOprObj.onEditEnded});//定额工料机
  43. subEscSheets.push({sheet: subSpread.getSheet(1), editStarting: gljOprObj.editChecking, editEnded: gljOprObj.onEditEnded});//工程量明细
  44. subEscSheets.push({sheet: subSpread.getSheet(3), editStarting: installationFeeObj.rationInstSheeteditChecking, editEnded: null});//定额安装增加费
  45. sheetCommonObj.bindEscKey(subSpread, subEscSheets);
  46. if(projectReadOnly){
  47. disableSpread(subSpread);
  48. disableSpread(contentOprObj.workBook);
  49. disableSpread(characterOprObj.workBook);
  50. }
  51. },
  52. initNavItem:function (node) {
  53. /* 1、造价书选中行类别是“大项费用”、“分部”、“分项”、“清单”时,显示按钮“工程量明细”、“计算程序”、“特征及内容”,默认打开“计算程序”。
  54. 2、选中行类别是“定额”、“量价”、“人材机”时,显示按钮“人材机”、“子目换算”、“工程量明细”、“计算程序”、“安装增加费”,默认打开“人材机”。
  55. */
  56. if (!node) {
  57. return;
  58. }
  59. $('.sub-item').removeClass('active');
  60. if(node.sourceType == ModuleNames.ration){
  61. //GLJ_div //ZMHS_div
  62. $("#GLJ_div").show();
  63. $("#ZMHS_div").show();
  64. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  65. $("#TZJNR_div").hide();
  66. $("#linkGLJ").addClass();
  67. $(gljOprObj.rationTab).click();
  68. }else {
  69. $("#GLJ_div").hide();
  70. $("#ZMHS_div").hide();
  71. $("#AZZJF_div").hide();
  72. $("#TZJNR_div").show();
  73. $(gljOprObj.billsTab).click();
  74. }
  75. projectObj.mainSpread.focus();
  76. }
  77. };
  78. $("#linkGLJ").click(function(){
  79. $("#subItems").children().hide();//控制显示subSpread,隐藏特征及内容spread
  80. //show
  81. MaterialController.showReplaceDiv();
  82. $("#subSpread").show();
  83. pageCCOprObj.active = false;
  84. subSpread.options.allowUserDragFill = false;
  85. refreshSubSpread();
  86. subSpread.setActiveSheetIndex(0);
  87. gljOprObj.activeTab='#linkGLJ';
  88. gljOprObj.setNodeShowTab();
  89. });
  90. $("#linkAZZJF").click(function(){
  91. $("#subItems").children().hide();
  92. MaterialController.hideReplaceDiv();
  93. $("#subSpread").show();
  94. pageCCOprObj.active = false;
  95. refreshSubSpread();
  96. subSpread.setActiveSheetIndex(3);
  97. gljOprObj.activeTab='#linkAZZJF';
  98. gljOprObj.setNodeShowTab();
  99. });
  100. $("#linkGCLMX").click(function(){
  101. $("#subItems").children().hide();
  102. MaterialController.hideReplaceDiv();
  103. $("#subSpread").show();
  104. subSpread.options.allowUserDragFill = true;
  105. pageCCOprObj.active = false;
  106. refreshSubSpread();
  107. subSpread.setActiveSheetIndex(1);
  108. gljOprObj.activeTab='#linkGCLMX';
  109. gljOprObj.setNodeShowTab();
  110. });
  111. $("#linkJSCX").click(function(){ // 计算程序
  112. $("#subItems").children().hide();
  113. MaterialController.hideReplaceDiv();
  114. $("#subSpread").show();
  115. pageCCOprObj.active = false;
  116. refreshSubSpread();
  117. subSpread.setActiveSheetIndex(2);
  118. calcProgramObj.initSheet(subSpread.getSheet(2));
  119. if (!projectObj.mainController.tree.selected)
  120. projectObj.mainController.tree.selected = projectObj.mainController.tree.firstNode();
  121. let sel = projectObj.mainController.tree.selected;
  122. calcProgramObj.refreshCalcProgram(sel, 3);
  123. gljOprObj.activeTab='#linkJSCX';
  124. gljOprObj.setNodeShowTab();
  125. });
  126. $("#linkZMHS").click(function(){ // 子目换算
  127. $("#subItems").children().hide();
  128. $("#tabZMHS").show();
  129. pageCCOprObj.active = false;
  130. refreshSubSpread();
  131. gljOprObj.activeTab='#linkZMHS';
  132. gljOprObj.setNodeShowTab();
  133. });
  134. //特征及内容各模块宽度自适应
  135. function adaptiveTzjnrWidth() {
  136. if(gljOprObj.activeTab !== '#linkTZJNR'){
  137. return;
  138. }
  139. //排版规则工具条宽度
  140. const typeSettingWidth = 30;
  141. let tzjnrWidth = $('#tzjnrCon').width() + 30;
  142. //let tzjnrWidth = $(window).width() - $('.main-nav').width() - $('.main-side').width();
  143. if($('#add-rule').is(':visible')){
  144. $('#jobDiv').css('width', tzjnrWidth / 3);
  145. $('#itemDiv').css('width', tzjnrWidth / 3);
  146. $('#add-rule').css('width', tzjnrWidth / 3);
  147. } else{
  148. $('#jobDiv').css('width', tzjnrWidth / 2);
  149. $('#itemDiv').css('width', tzjnrWidth / 2 - typeSettingWidth);
  150. $('#openTypeSetting').css('width', typeSettingWidth);
  151. }
  152. pageCCOprObj.resizeWidth();
  153. refreshSubSpread();
  154. }
  155. //特征及内容
  156. $("#linkTZJNR").click(function () {
  157. gljOprObj.activeTab='#linkTZJNR';
  158. $("#subItems").children().hide();
  159. $("#tzjnrCon").show();
  160. adaptiveTzjnrWidth();
  161. pageCCOprObj.resizeWidth();
  162. $("#add-rule p").not(":first").css('margin-bottom', 4);
  163. pageCCOprObj.active = true;
  164. refreshSubSpread();
  165. contentOprObj.workBook.getActiveSheet().showColumn(0, GC.Spread.Sheets.HorizontalPosition.left);
  166. characterOprObj.workBook.getActiveSheet().showColumn(0, GC.Spread.Sheets.HorizontalPosition.left);
  167. let selectedNode = projectObj.mainController.tree.selected;
  168. if (projectObj.project.property.addRule !== undefined) {
  169. setRule(projectObj.project.property.addRule);
  170. }
  171. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  172. pageCCOprObj.setCacheAndShow(selectedNode);
  173. gljOprObj.setNodeShowTab();
  174. });
  175. //打开排版规则
  176. $('#openTypeSetting').click(function () {
  177. $('#add-rule').show();
  178. $(this).hide();
  179. adaptiveTzjnrWidth();
  180. });
  181. //关闭排版规则
  182. $('#closeTypeSetting').click(function () {
  183. $('#add-rule').hide();
  184. $('#openTypeSetting').show();
  185. adaptiveTzjnrWidth();
  186. });
  187. //应用到选中清单、应用到所有,添加位置列如果隐藏了,则重新显示
  188. function colSettingAddPosition(addPosition){
  189. let settingMapping = {1: 'itemCharacterText', 2: 'name', 3: 'jobContentText', 4: 'both'};
  190. let settingInfo = settingMapping[addPosition];
  191. if(!settingInfo){
  192. return;
  193. }
  194. let fields = [];
  195. if(settingInfo === 'both'){
  196. fields = [settingMapping['1'], settingMapping['3']];
  197. }
  198. else{
  199. fields = [settingInfo];
  200. }
  201. let needToUpdate = false;
  202. let showItemCharacter = false;
  203. for(let field of fields){
  204. let colVisible = colSettingObj.getVisible(field);
  205. if(field === settingMapping['1'] && !colVisible){
  206. showItemCharacter = true;
  207. }
  208. if(!colVisible){
  209. colSettingObj.setVisible(field, true);
  210. needToUpdate = true;
  211. }
  212. }
  213. if(showItemCharacter){
  214. switchTznrHtml(false);
  215. }
  216. if(needToUpdate){
  217. colSettingObj.updateColSetting(true);
  218. }
  219. }
  220. //如果,添加内容为定额子目时进行定额的增删改,更新相关其清单
  221. function updateBillsOprRation() {
  222. const setting = getAddRuleSetting();
  223. if(setting && setting.addContent && setting.addContent === '5'){
  224. $('#use-to-current').click();
  225. }
  226. }
  227. // 应用到选中清单
  228. let isSaving = false;
  229. $("#use-to-current").click(function() {
  230. if($(this).hasClass('disabled')){
  231. return false;
  232. }
  233. if(projectReadOnly){
  234. return false;
  235. }
  236. if (isSaving) {
  237. return false;
  238. }
  239. const setting = getAddRuleSetting();
  240. colSettingAddPosition(setting.position);
  241. isSaving = true;
  242. const self = $(this);
  243. self.attr('disabled', 'disabled');
  244. let selectedNode = projectObj.mainController.tree.selected;
  245. function findBill(node){
  246. while(node && node.sourceType !== projectObj.project.Bills.getSourceType()){
  247. node = node.parent;
  248. }
  249. return node;
  250. }
  251. let billsNode = findBill(selectedNode);
  252. // 操作内容
  253. pageCCOprObj.setCharacterBySetting(billsNode, setting);
  254. // 防止连续点击1秒后才能再次发起请求
  255. setTimeout(function() {
  256. isSaving = false;
  257. self.removeAttr('disabled');
  258. }, 1000);
  259. });
  260. //todo: 优化成批量
  261. function addRuleUseToBills(setting, nodes) {
  262. pageCCOprObj.bulkSetCharacterBySetting(nodes, setting);
  263. }
  264. // 应用到所有的清单
  265. $("#use-to-all").click(function() {
  266. if($(this).hasClass('disabled')){
  267. return false;
  268. }
  269. if(projectReadOnly){
  270. return false;
  271. }
  272. let treeNode = projectObj.mainController.tree;
  273. const setting = getAddRuleSetting();
  274. colSettingAddPosition(setting.position);
  275. if (treeNode.items === undefined || treeNode.items.length <= 0) {
  276. return false;
  277. }
  278. // 处理
  279. addRuleUseToBills(setting, treeNode.items);
  280. });
  281. function saveAddRule(){
  282. let setting = getAddRuleSetting();
  283. let toUpdate = false;
  284. if(!projectObj.project.property.addRule){
  285. toUpdate = true;
  286. }
  287. else {
  288. for(let attr in setting){
  289. if(setting[attr] !== projectObj.project.property.addRule[attr]){
  290. toUpdate = true;
  291. break;
  292. }
  293. }
  294. }
  295. if(toUpdate){
  296. projectObj.project.property.addRule = setting;
  297. projectObj.project.saveProperty('addRule', setting);
  298. }
  299. }
  300. // 添加位置选择
  301. $("#add-position").change(function() {
  302. const selected = $(this).children(":selected").val();
  303. const addContentEle = $("#add-content");
  304. const displayFormatEle = $("#display-format");
  305. const characterFormatEle = $("#character-format");
  306. const serialTypeEle = $("#serial-type");
  307. switch (selected) {
  308. case '4':
  309. // 分别添加到对应列
  310. // 当“添加位置”是“分别添加到对应列”,则“添加内容”恢复默认“无”,且灰显;“显示格式”恢复默认“换行分隔”,且灰显。
  311. addContentEle.val('');
  312. addContentEle.attr('disabled', 'disabled');
  313. displayFormatEle.val(1);
  314. characterFormatEle.val(2);
  315. serialTypeEle.val(1);
  316. break;
  317. default:
  318. addContentEle.removeAttr('disabled');
  319. displayFormatEle.removeAttr('disabled');
  320. characterFormatEle.removeAttr('disabled');
  321. addContentEle.val(1);
  322. break;
  323. }
  324. saveAddRule();
  325. });
  326. // 添加内容选择
  327. $("#add-content").change(function() {
  328. const selected = $(this).children(":selected").val();
  329. const characterFormatEle = $("#character-format");
  330. const childDisplayFormatEle = $("#child-display-format");
  331. const serialTypeEle = $("#serial-type");
  332. switch (selected) {
  333. case '5':
  334. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  335. characterFormatEle.attr('disabled', 'disabled');
  336. characterFormatEle.val(2);
  337. // 当“添加内容”是“定额子目”,则“子目生成方式”有效可选;否则灰显,不需选择。
  338. childDisplayFormatEle.removeAttr('disabled');
  339. serialTypeEle.val('');
  340. serialTypeEle.attr('disabled', 'disabled');
  341. break;
  342. case '':
  343. characterFormatEle.attr('disabled', 'disabled');
  344. break;
  345. case '1':
  346. case '2':
  347. case '3':
  348. characterFormatEle.removeAttr('disabled');
  349. if (serialTypeEle.val() === '') {
  350. serialTypeEle.val(1);
  351. }
  352. serialTypeEle.removeAttr('disabled');
  353. childDisplayFormatEle.attr('disabled', 'disabled');
  354. break;
  355. case '4':
  356. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  357. characterFormatEle.attr('disabled', 'disabled');
  358. characterFormatEle.val(2);
  359. default:
  360. serialTypeEle.removeAttr('disabled');
  361. if (serialTypeEle.val() === '') {
  362. serialTypeEle.val(1);
  363. }
  364. childDisplayFormatEle.attr('disabled', 'disabled');
  365. break;
  366. }
  367. saveAddRule();
  368. });
  369. //显示格式
  370. $('#display-format').change(function () {
  371. saveAddRule();
  372. });
  373. //特征生成方式
  374. $('#character-format').change(function () {
  375. saveAddRule();
  376. });
  377. // 子目生成方式选择事件
  378. $("#child-display-format").change(function() {
  379. const selected = $(this).children(":selected").val();
  380. const serialTypeEle = $("#serial-type");
  381. // 如果是编号+定额名称则序号格式不能选择
  382. if (selected === '1') {
  383. // 默认选中数字显示模式
  384. serialTypeEle.val("");
  385. serialTypeEle.attr('disabled', 'disabled');
  386. } else {
  387. serialTypeEle.val(1);
  388. serialTypeEle.removeAttr('disabled');
  389. }
  390. saveAddRule();
  391. });
  392. //序号格式
  393. $('#serial-type').change(function () {
  394. saveAddRule();
  395. });
  396. /**
  397. * 获取添加规则的设置
  398. *
  399. * @return {Object} - 返回设置内容
  400. */
  401. function getAddRuleSetting() {
  402. // 添加位置
  403. const position = $("#add-position").val();
  404. // 添加内容
  405. const addContent = $("#add-content").val();
  406. // 显示格式
  407. const displayFormat = $("#display-format").val();
  408. // 特征生成方式
  409. const characterFormat = $("#character-format").val();
  410. // 子目生成方式
  411. const childDisplayFormat = $("#child-display-format").val();
  412. // 序号格式
  413. const serialType = $("#serial-type").val();
  414. const setting = {
  415. serialType,
  416. characterFormat,
  417. addContent,
  418. position,
  419. displayFormat,
  420. childDisplayFormat,
  421. };
  422. return setting;
  423. }
  424. /**
  425. * 根据配置设置规则
  426. *
  427. * @param {Object} setting - 数据库中读取的数据
  428. * @return {void}
  429. */
  430. function setRule(setting) {
  431. if (Object.keys(setting).length <= 0) {
  432. return;
  433. }
  434. $("#add-position").val(setting.position);
  435. $("#add-position").change();
  436. $("#add-content").val(setting.addContent);
  437. $("#add-content").change();
  438. $("#display-format").val(setting.displayFormat);
  439. $("#character-format").val(setting.characterFormat);
  440. $("#child-display-format").val(setting.childDisplayFormat);
  441. $("#child-display-format").change();
  442. $("#serial-type").val(setting.serialType);
  443. if(projectReadOnly){
  444. disableTools();
  445. }
  446. }
  447. function activeSubSheetIs(idx){
  448. let rst = subSpread.getActiveSheetIndex() == idx;
  449. return rst;
  450. }
  451. function activeSubSheetIsCalcProgram(){
  452. return subSpread.getActiveSheetIndex() == subSheetIndex.ssiCalcProgram;
  453. }
  454. //弹出清单规则或定额库后导致subSpread和特征及内容spread显示出问题
  455. function refreshSubSpread(){
  456. if(pageCCOprObj.active){
  457. contentOprObj.workBook.refresh();
  458. characterOprObj.workBook.refresh();
  459. } else{
  460. if(subSpread) subSpread.refresh();
  461. if(MaterialController.spread) MaterialController.spread.refresh();
  462. }
  463. if($('#linkZMHS').hasClass('active')) zmhs_obj.refresh();
  464. }
  465. let subViewObj = {
  466. linkTabClick: function () {
  467. $("#subItems").children().hide();
  468. $($(this).attr('href')).show();
  469. },
  470. loadComments: function (node) {
  471. let comments = [];
  472. let commentText = '';
  473. if (node) {
  474. if (node.sourceType === projectObj.project.Bills.getSourceType() &&
  475. (node.data.type === billType.FX || node.data.type === billType.BX || node.data.type === billType.BILL)) {
  476. if(node.data.ruleText && node.data.ruleText !== ''){
  477. comments.push('工程量计算规则:');
  478. comments.push(node.data.ruleText);
  479. }
  480. if(node.data.comments && node.data.comments !== ''){
  481. comments.push('清单注释:');
  482. comments.push(node.data.comments);
  483. }
  484. } else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  485. if(node.data.content && node.data.content !== ''){
  486. comments.push('工作内容:');
  487. comments.push(node.data.content);
  488. }
  489. if(node.data.annotation && node.data.annotation !== ''){
  490. comments.push('附注:');
  491. comments.push(node.data.annotation);
  492. }
  493. }
  494. commentText = comments.join('\n');
  495. }
  496. $('#comments>textarea').val(commentText);
  497. },
  498. saveComments: function (node) {
  499. let text = $('#comments>textarea').val();
  500. if (node && node.sourceType === projectObj.project.Bills.getSourceType()) {
  501. if (node.data.comments !== text) {
  502. projectObj.project.Bills.updateField(node.source, "comments", text);
  503. }
  504. } else if (node && node.sourceType === projectObj.project.Ration.getSourceType()) {
  505. if (node.data.comments !== text) {
  506. projectObj.project.Ration.updateField(node.source, "comments", text);
  507. }
  508. }
  509. }
  510. }
  511. $("#linkComments").click(subViewObj.linkTabClick);
  512. $('#linkGLJ').on('shown.bs.tab', function () {
  513. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  514. });
  515. $('#linkZMHS').on('shown.bs.tab', function (e) {
  516. if(zmhs_obj.coeSpread == null || zmhs_obj.assSpread == null){
  517. zmhs_obj.initSpread();
  518. }
  519. zmhs_obj.refresh();
  520. zmhs_obj.showZMHSData();
  521. });
  522. $('#linkComments').on('shown.bs.tab', function () {
  523. subViewObj.loadComments(projectObj.project.mainTree.selected);
  524. });
  525. $('#linkGCLMX').on('shown.bs.tab', function () {
  526. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  527. });
  528. $('#linkAZZJF').on('shown.bs.tab', function () {
  529. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  530. });