sub_view.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  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. characterOprObj.buildSheet($("#itemSpread")[0]);
  14. sheetCommonObj.bindEscKey(characterOprObj.workBook, [{sheet: characterOprObj.workBook.getSheet(0), editStarting: characterOprObj.onEditStart, editEnded: characterOprObj.onEditEnded}]);
  15. $("#tzjnrCon").hide();
  16. $("#subSpread").show();
  17. subSpread = sheetCommonObj.createSpread($("#subSpread")[0], 4);
  18. subSpread.options.allowUserDragDrop = false;
  19. subSpread.options.allowUserDragFill = false;
  20. subSpread.getSheet(2).name('JSCX');
  21. pageCCOprObj.active = false;
  22. // 工料机
  23. gljOprObj.initSheet(subSpread.getSheet(0));
  24. //sheetCommonObj.shieldAllCells(subSpread.getSheet(0), gljOprObj.setting);
  25. SheetDataHelper.protectdSheet(subSpread.getSheet(0));
  26. // assistOprObj.initSheet(subSpread.getSheet(1));
  27. // sheetCommonObj.shieldAllCells(subSpread.getSheet(1), assistOprObj.setting);
  28. if(!projectReadOnly){
  29. gljContextMenu.loadGLJSpreadContextMenu();
  30. }
  31. //工程量明细
  32. gljOprObj.initDetailSheet(subSpread.getSheet(1));
  33. SheetDataHelper.protectdSheet(subSpread.getSheet(1));
  34. //安装增加费
  35. installationFeeObj.initRationInstallSheet(subSpread.getSheet(3));
  36. SheetDataHelper.protectdSheet(subSpread.getSheet(3));
  37. //绑定esc
  38. let subEscSheets = [];
  39. subEscSheets.push({sheet: subSpread.getSheet(0), editStarting: gljOprObj.editChecking, editEnded: gljOprObj.onEditEnded});//定额工料机
  40. subEscSheets.push({sheet: subSpread.getSheet(1), editStarting: gljOprObj.editChecking, editEnded: gljOprObj.onEditEnded});//工程量明细
  41. subEscSheets.push({sheet: subSpread.getSheet(3), editStarting: installationFeeObj.rationInstSheeteditChecking, editEnded: null});//定额安装增加费
  42. sheetCommonObj.bindEscKey(subSpread, subEscSheets);
  43. if(projectReadOnly){
  44. disableSpread(subSpread);
  45. disableSpread(contentOprObj.workBook);
  46. disableSpread(characterOprObj.workBook);
  47. }
  48. }
  49. };
  50. $("#linkGLJ").click(function(){
  51. $("#subItems").children().hide();//控制显示subSpread,隐藏特征及内容spread
  52. $("#subSpread").show();
  53. pageCCOprObj.active = false;
  54. subSpread.options.allowUserDragFill = false;
  55. refreshSubSpread();
  56. subSpread.setActiveSheetIndex(0);
  57. gljOprObj.activeTab='#linkGLJ';
  58. // for test
  59. //subSpread.getActiveSheet().setValue(0, 0, "工料机");
  60. });
  61. $("#linkAZZJF").click(function(){
  62. $("#subItems").children().hide();
  63. $("#subSpread").show();
  64. pageCCOprObj.active = false;
  65. refreshSubSpread();
  66. subSpread.setActiveSheetIndex(3);
  67. gljOprObj.activeTab='#linkAZZJF';
  68. });
  69. $("#linkGCLMX").click(function(){
  70. $("#subItems").children().hide();
  71. $("#subSpread").show();
  72. subSpread.options.allowUserDragFill = true;
  73. pageCCOprObj.active = false;
  74. refreshSubSpread();
  75. subSpread.setActiveSheetIndex(1);
  76. gljOprObj.activeTab='#linkGCLMX';
  77. });
  78. $("#linkJSCX").click(function(){ // 计算程序
  79. $("#subItems").children().hide();
  80. $("#subSpread").show();
  81. pageCCOprObj.active = false;
  82. refreshSubSpread();
  83. subSpread.setActiveSheetIndex(2);
  84. calcProgramObj.initSheet(subSpread.getSheet(2));
  85. if (!projectObj.mainController.tree.selected)
  86. projectObj.mainController.tree.selected = projectObj.mainController.tree.firstNode();
  87. let sel = projectObj.mainController.tree.selected;
  88. calcProgramObj.refreshCalcProgram(sel, 3);
  89. gljOprObj.activeTab='#linkJSCX';
  90. });
  91. $("#linkZMHS").click(function(){ // 子目换算
  92. $("#subItems").children().hide();
  93. $("#tabZMHS").show();
  94. pageCCOprObj.active = false;
  95. refreshSubSpread();
  96. gljOprObj.activeTab='#linkZMHS';
  97. });
  98. tabZMHS
  99. //特征及内容
  100. $("#linkTZJNR").click(function () {
  101. $("#subItems").children().hide();
  102. $("#tzjnrCon").show();
  103. $("#add-rule").show();
  104. $("#add-rule p").not(":first").css('margin-bottom', 4);
  105. pageCCOprObj.active = true;
  106. refreshSubSpread();
  107. let selectedNode = projectObj.mainController.tree.selected;
  108. if (projectObj.project.property.addRule !== undefined) {
  109. setRule(projectObj.project.property.addRule);
  110. }
  111. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  112. pageCCOprObj.setCacheAndShow(selectedNode);
  113. /* if(selectedNode && selectedNode.sourceType === projectObj.project.Bills.getSourceType()){
  114. pageCCOprObj.setCacheAndShow(selectedNode);
  115. }
  116. else{
  117. pageCCOprObj.clearData();
  118. }*/
  119. gljOprObj.activeTab='#linkTZJNR';
  120. });
  121. // 应用到选中清单
  122. let isSaving = false;
  123. $("#use-to-current").click(function() {
  124. if(projectReadOnly){
  125. return false;
  126. }
  127. if (isSaving) {
  128. return false;
  129. }
  130. const setting = getAddRuleSetting();
  131. isSaving = true;
  132. const self = $(this);
  133. self.attr('disabled', 'disabled');
  134. let selectedNode = projectObj.mainController.tree.selected;
  135. function findBill(node){
  136. while(node && node.sourceType !== projectObj.project.Bills.getSourceType()){
  137. node = node.parent;
  138. }
  139. return node;
  140. }
  141. let billsNode = findBill(selectedNode);
  142. // 操作内容
  143. pageCCOprObj.setCharacterBySetting(billsNode, setting);
  144. // 防止连续点击1秒后才能再次发起请求
  145. setTimeout(function() {
  146. isSaving = false;
  147. self.removeAttr('disabled');
  148. }, 1000);
  149. });
  150. // 应用到所有的清单
  151. $("#use-to-all").click(function() {
  152. if(projectReadOnly){
  153. return false;
  154. }
  155. let treeNode = projectObj.mainController.tree;
  156. const setting = getAddRuleSetting();
  157. if (treeNode.items === undefined || treeNode.items.length <= 0) {
  158. return false;
  159. }
  160. // 处理结果
  161. for (const item of treeNode.items) {
  162. if (item.data.jobContent === undefined || item.data.jobContent.length <= 0 ||
  163. item.data.itemCharacter === undefined || item.data.itemCharacter.length <= 0 || item.data.code === undefined) {
  164. continue;
  165. }
  166. pageCCOprObj.setCharacterBySetting(item, setting);
  167. }
  168. });
  169. function saveAddRule(){
  170. let setting = getAddRuleSetting();
  171. let toUpdate = false;
  172. if(!projectObj.project.property.addRule){
  173. toUpdate = true;
  174. }
  175. else {
  176. for(let attr in setting){
  177. if(setting[attr] !== projectObj.project.property.addRule[attr]){
  178. toUpdate = true;
  179. break;
  180. }
  181. }
  182. }
  183. if(toUpdate){
  184. projectObj.project.property.addRule = setting;
  185. projectObj.project.saveProperty('addRule', setting);
  186. }
  187. }
  188. // 添加位置选择
  189. $("#add-position").change(function() {
  190. const selected = $(this).children(":selected").val();
  191. const addContentEle = $("#add-content");
  192. const displayFormatEle = $("#display-format");
  193. const characterFormatEle = $("#character-format");
  194. const serialTypeEle = $("#serial-type");
  195. switch (selected) {
  196. case '4':
  197. // 分别添加到对应列
  198. // 当“添加位置”是“分别添加到对应列”,则“添加内容”恢复默认“无”,且灰显;“显示格式”恢复默认“换行分隔”,且灰显。
  199. addContentEle.val('');
  200. addContentEle.attr('disabled', 'disabled');
  201. displayFormatEle.val(1);
  202. characterFormatEle.val(2);
  203. serialTypeEle.val(1);
  204. break;
  205. default:
  206. addContentEle.removeAttr('disabled');
  207. displayFormatEle.removeAttr('disabled');
  208. characterFormatEle.removeAttr('disabled');
  209. addContentEle.val(1);
  210. break;
  211. }
  212. saveAddRule();
  213. });
  214. // 添加内容选择
  215. $("#add-content").change(function() {
  216. const selected = $(this).children(":selected").val();
  217. const characterFormatEle = $("#character-format");
  218. const childDisplayFormatEle = $("#child-display-format");
  219. const serialTypeEle = $("#serial-type");
  220. switch (selected) {
  221. case '5':
  222. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  223. characterFormatEle.attr('disabled', 'disabled');
  224. characterFormatEle.val(2);
  225. // 当“添加内容”是“定额子目”,则“子目生成方式”有效可选;否则灰显,不需选择。
  226. childDisplayFormatEle.removeAttr('disabled');
  227. serialTypeEle.val('');
  228. serialTypeEle.attr('disabled', 'disabled');
  229. break;
  230. case '':
  231. characterFormatEle.attr('disabled', 'disabled');
  232. break;
  233. case '1':
  234. case '2':
  235. case '3':
  236. characterFormatEle.removeAttr('disabled');
  237. if (serialTypeEle.val() === '') {
  238. serialTypeEle.val(1);
  239. }
  240. serialTypeEle.removeAttr('disabled');
  241. childDisplayFormatEle.attr('disabled', 'disabled');
  242. break;
  243. case '4':
  244. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  245. characterFormatEle.attr('disabled', 'disabled');
  246. characterFormatEle.val(2);
  247. default:
  248. serialTypeEle.removeAttr('disabled');
  249. if (serialTypeEle.val() === '') {
  250. serialTypeEle.val(1);
  251. }
  252. childDisplayFormatEle.attr('disabled', 'disabled');
  253. break;
  254. }
  255. saveAddRule();
  256. });
  257. //显示格式
  258. $('#display-format').change(function () {
  259. saveAddRule();
  260. });
  261. //特征生成方式
  262. $('#character-format').change(function () {
  263. saveAddRule();
  264. });
  265. // 子目生成方式选择事件
  266. $("#child-display-format").change(function() {
  267. const selected = $(this).children(":selected").val();
  268. const serialTypeEle = $("#serial-type");
  269. // 如果是编号+定额名称则序号格式不能选择
  270. if (selected === '1') {
  271. // 默认选中数字显示模式
  272. serialTypeEle.val("");
  273. serialTypeEle.attr('disabled', 'disabled');
  274. } else {
  275. serialTypeEle.val(1);
  276. serialTypeEle.removeAttr('disabled');
  277. }
  278. saveAddRule();
  279. });
  280. //序号格式
  281. $('#serial-type').change(function () {
  282. saveAddRule();
  283. });
  284. /**
  285. * 获取添加规则的设置
  286. *
  287. * @return {Object} - 返回设置内容
  288. */
  289. function getAddRuleSetting() {
  290. // 添加位置
  291. const position = $("#add-position").val();
  292. // 添加内容
  293. const addContent = $("#add-content").val();
  294. // 显示格式
  295. const displayFormat = $("#display-format").val();
  296. // 特征生成方式
  297. const characterFormat = $("#character-format").val();
  298. // 子目生成方式
  299. const childDisplayFormat = $("#child-display-format").val();
  300. // 序号格式
  301. const serialType = $("#serial-type").val();
  302. const setting = {
  303. serialType,
  304. characterFormat,
  305. addContent,
  306. position,
  307. displayFormat,
  308. childDisplayFormat,
  309. };
  310. return setting;
  311. }
  312. /**
  313. * 根据配置设置规则
  314. *
  315. * @param {Object} setting - 数据库中读取的数据
  316. * @return {void}
  317. */
  318. function setRule(setting) {
  319. if (Object.keys(setting).length <= 0) {
  320. return;
  321. }
  322. $("#add-position").val(setting.position);
  323. $("#add-position").change();
  324. $("#add-content").val(setting.addContent);
  325. $("#add-content").change();
  326. $("#display-format").val(setting.displayFormat);
  327. $("#character-format").val(setting.characterFormat);
  328. $("#child-display-format").val(setting.childDisplayFormat);
  329. $("#child-display-format").change();
  330. $("#serial-type").val(setting.serialType);
  331. if(projectReadOnly){
  332. disableTools();
  333. }
  334. }
  335. function activeSubSheetIs(idx){
  336. let rst = subSpread.getActiveSheetIndex() == idx;
  337. return rst;
  338. }
  339. function activeSubSheetIsCalcProgram(){
  340. return subSpread.getActiveSheetIndex() == subSheetIndex.ssiCalcProgram;
  341. }
  342. //弹出清单规则或定额库后导致subSpread和特征及内容spread显示出问题
  343. function refreshSubSpread(){
  344. if(pageCCOprObj.active){
  345. contentOprObj.workBook.refresh();
  346. characterOprObj.workBook.refresh();
  347. }
  348. else{
  349. subSpread?subSpread.refresh():'';
  350. }
  351. }
  352. let subViewObj = {
  353. linkTabClick: function () {
  354. $("#subItems").children().hide();
  355. $($(this).attr('href')).show();
  356. },
  357. loadComments: function (node) {
  358. let comments = [];
  359. let commentText = '';
  360. if (node) {
  361. if (node.sourceType === projectObj.project.Bills.getSourceType() &&
  362. (node.data.type === billType.FX || node.data.type === billType.BX || node.data.type === billType.BILL)) {
  363. if(node.data.comments && node.data.comments !== ''){
  364. comments.push('清单注释:');
  365. comments.push(node.data.comments);
  366. }
  367. if(node.data.ruleText && node.data.ruleText !== ''){
  368. comments.push('工程量计算规则:');
  369. comments.push(node.data.ruleText);
  370. }
  371. } else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  372. if(node.data.content && node.data.content !== ''){
  373. comments.push('工作内容:');
  374. comments.push(node.data.content);
  375. }
  376. if(node.data.annotation && node.data.annotation !== ''){
  377. comments.push('附注:');
  378. comments.push(node.data.annotation);
  379. }
  380. }
  381. commentText = comments.join('\n');
  382. }
  383. $('#comments>textarea').val(commentText);
  384. },
  385. saveComments: function (node) {
  386. let text = $('#comments>textarea').val();
  387. if (node && node.sourceType === projectObj.project.Bills.getSourceType()) {
  388. if (node.data.comments !== text) {
  389. projectObj.project.Bills.updateField(node.source, "comments", text);
  390. }
  391. } else if (node && node.sourceType === projectObj.project.Ration.getSourceType()) {
  392. if (node.data.comments !== text) {
  393. projectObj.project.Ration.updateField(node.source, "comments", text);
  394. }
  395. }
  396. }
  397. }
  398. $("#linkComments").click(subViewObj.linkTabClick);
  399. $('#linkGLJ').on('shown.bs.tab', function () {
  400. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  401. });
  402. $('#linkZMHS').on('shown.bs.tab', function (e) {
  403. if(zmhs_obj.coeSpread == null || zmhs_obj.assSpread == null){
  404. zmhs_obj.initSpread();
  405. }
  406. zmhs_obj.refresh();
  407. zmhs_obj.showZMHSData();
  408. });
  409. $('#linkComments').on('shown.bs.tab', function () {
  410. subViewObj.loadComments(projectObj.project.mainTree.selected);
  411. });
  412. $('#linkGCLMX').on('shown.bs.tab', function () {
  413. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  414. });
  415. $('#linkAZZJF').on('shown.bs.tab', function () {
  416. gljOprObj.showDataIfRationSelect(projectObj.project.mainTree.selected, '111111');
  417. });