sub_view.js 18 KB

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