sub_view.js 17 KB

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