sub_view.js 15 KB

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