sub_view.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343
  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. contentOprObj.buildSheet($("#jobSpread")[0]);
  8. characterOprObj.buildSheet($("#itemSpread")[0]);
  9. $("#tzjnrCon").hide();
  10. $("#subSpread").show();
  11. var subSpread = sheetCommonObj.createSpread($("#subSpread")[0], 6);
  12. subSpread.getSheet(4).name('JSCX');
  13. pageCCOprObj.active = false;
  14. // 工料机
  15. gljOprObj.initSheet(subSpread.getSheet(0));
  16. //sheetCommonObj.shieldAllCells(subSpread.getSheet(0), gljOprObj.setting);
  17. SheetDataHelper.protectdSheet(subSpread.getSheet(0));
  18. // assistOprObj.initSheet(subSpread.getSheet(1));
  19. // sheetCommonObj.shieldAllCells(subSpread.getSheet(1), assistOprObj.setting);
  20. //附注条件
  21. gljOprObj.initCoeSheet(subSpread.getSheet(2));
  22. SheetDataHelper.protectdSheet(subSpread.getSheet(2));
  23. //辅助定额
  24. gljOprObj.initAssSheet(subSpread.getSheet(1));
  25. SheetDataHelper.protectdSheet(subSpread.getSheet(1));
  26. //工程量明细
  27. gljOprObj.initDetailSheet(subSpread.getSheet(3));
  28. SheetDataHelper.protectdSheet(subSpread.getSheet(3));
  29. //安装增加费
  30. installationFeeObj.initRationInstallSheet(subSpread.getSheet(5));
  31. SheetDataHelper.protectdSheet(subSpread.getSheet(5));
  32. gljContextMenu.loadGLJSpreadContextMenu();
  33. $("#linkGLJ").click(function(){
  34. $("#subItems").children().hide();//控制显示subSpread,隐藏特征及内容spread
  35. $("#subSpread").show();
  36. pageCCOprObj.active = false;
  37. refreshSubSpread();
  38. subSpread.setActiveSheetIndex(0);
  39. gljOprObj.activeTab='#linkGLJ';
  40. // for test
  41. //subSpread.getActiveSheet().setValue(0, 0, "工料机");
  42. });
  43. $("#linkFZDE").click(function(){
  44. $("#subItems").children().hide();
  45. $("#subSpread").show();
  46. pageCCOprObj.active = false;
  47. refreshSubSpread();
  48. subSpread.setActiveSheetIndex(1);
  49. gljOprObj.activeTab='#linkFZDE';
  50. });
  51. $("#linkFZTJ").click(function(){
  52. $("#subItems").children().hide();
  53. $("#subSpread").show();
  54. pageCCOprObj.active = false;
  55. refreshSubSpread();
  56. subSpread.setActiveSheetIndex(2);
  57. gljOprObj.activeTab='#linkFZTJ';
  58. });
  59. $("#linkAZZJF").click(function(){
  60. $("#subItems").children().hide();
  61. $("#subSpread").show();
  62. pageCCOprObj.active = false;
  63. refreshSubSpread();
  64. subSpread.setActiveSheetIndex(5);
  65. gljOprObj.activeTab='#linkAZZJF';
  66. });
  67. $("#linkGCLMX").click(function(){
  68. $("#subItems").children().hide();
  69. $("#subSpread").show();
  70. pageCCOprObj.active = false;
  71. refreshSubSpread();
  72. subSpread.setActiveSheetIndex(3);
  73. gljOprObj.activeTab='#linkGCLMX';
  74. });
  75. $("#linkJSCX").click(function(){ // 计算程序
  76. $("#subItems").children().hide();
  77. $("#subSpread").show();
  78. pageCCOprObj.active = false;
  79. refreshSubSpread();
  80. subSpread.setActiveSheetIndex(4);
  81. calcProgramObj.initSheet(subSpread.getSheet(4));
  82. if (!projectObj.mainController.tree.selected)
  83. projectObj.mainController.tree.selected = projectObj.mainController.tree.firstNode();
  84. let sel = projectObj.mainController.tree.selected;
  85. calcProgramObj.showData(sel);
  86. gljOprObj.activeTab='#linkJSCX';
  87. });
  88. //特征及内容
  89. $("#linkTZJNR").click(function () {
  90. $("#subItems").children().hide();
  91. $("#tzjnrCon").show();
  92. $("#add-rule").show();
  93. $("#add-rule p").not(":first").css('margin-bottom', 4);
  94. pageCCOprObj.active = true;
  95. refreshSubSpread();
  96. let selectedNode = projectObj.mainController.tree.selected;
  97. if (projectObj.project.property.addRule !== undefined) {
  98. setRule(projectObj.project.property.addRule);
  99. }
  100. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  101. if(selectedNode && selectedNode.sourceType === projectObj.project.Bills.getSourceType()){
  102. pageCCOprObj.setCacheAndShow(selectedNode);
  103. }
  104. else{
  105. pageCCOprObj.clearData();
  106. }
  107. gljOprObj.activeTab='#linkTZJNR';
  108. });
  109. // 应用到选中清单
  110. let isSaving = false;
  111. $("#use-to-current").click(function() {
  112. if (isSaving) {
  113. return false;
  114. }
  115. const setting = getAddRuleSetting();
  116. isSaving = true;
  117. const self = $(this);
  118. self.attr('disabled', 'disabled');
  119. let selectedNode = projectObj.mainController.tree.selected;
  120. // 操作内容
  121. pageCCOprObj.setCharacterBySetting(selectedNode, setting);
  122. // 防止连续点击1秒后才能再次发起请求
  123. setTimeout(function() {
  124. isSaving = false;
  125. self.removeAttr('disabled');
  126. }, 1000);
  127. });
  128. // 应用到所有的清单
  129. $("#use-to-all").click(function() {
  130. let treeNode = projectObj.mainController.tree;
  131. const setting = getAddRuleSetting();
  132. if (treeNode.items === undefined || treeNode.items.length <= 0) {
  133. return false;
  134. }
  135. // 处理结果
  136. for (const item of treeNode.items) {
  137. if (item.data.jobContent === undefined || item.data.jobContent.length <= 0 ||
  138. item.data.itemCharacter === undefined || item.data.itemCharacter.length <= 0 || item.data.code === undefined) {
  139. continue;
  140. }
  141. pageCCOprObj.setCharacterBySetting(item, setting);
  142. }
  143. });
  144. // 添加位置选择
  145. $("#add-position").change(function() {
  146. const selected = $(this).children(":selected").val();
  147. const addContentEle = $("#add-content");
  148. const displayFormatEle = $("#display-format");
  149. const characterFormatEle = $("#character-format");
  150. const serialTypeEle = $("#serial-type");
  151. switch (selected) {
  152. case '4':
  153. // 分别添加到对应列
  154. // 当“添加位置”是“分别添加到对应列”,则“添加内容”恢复默认“无”,且灰显;“显示格式”恢复默认“换行分隔”,且灰显。
  155. addContentEle.val('');
  156. addContentEle.attr('disabled', 'disabled');
  157. displayFormatEle.val(1);
  158. characterFormatEle.val(2);
  159. serialTypeEle.val(1);
  160. break;
  161. default:
  162. addContentEle.removeAttr('disabled');
  163. displayFormatEle.removeAttr('disabled');
  164. characterFormatEle.removeAttr('disabled');
  165. addContentEle.val(1);
  166. break;
  167. }
  168. });
  169. // 添加内容选择
  170. $("#add-content").change(function() {
  171. const selected = $(this).children(":selected").val();
  172. const characterFormatEle = $("#character-format");
  173. const childDisplayFormatEle = $("#child-display-format");
  174. const serialTypeEle = $("#serial-type");
  175. switch (selected) {
  176. case '5':
  177. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  178. characterFormatEle.attr('disabled', 'disabled');
  179. characterFormatEle.val(2);
  180. // 当“添加内容”是“定额子目”,则“子目生成方式”有效可选;否则灰显,不需选择。
  181. childDisplayFormatEle.removeAttr('disabled');
  182. serialTypeEle.val('');
  183. serialTypeEle.attr('disabled', 'disabled');
  184. break;
  185. case '1':
  186. case '2':
  187. case '3':
  188. characterFormatEle.removeAttr('disabled');
  189. if (serialTypeEle.val() === '') {
  190. serialTypeEle.val(1);
  191. }
  192. serialTypeEle.removeAttr('disabled');
  193. childDisplayFormatEle.attr('disabled', 'disabled');
  194. break;
  195. case '4':
  196. // 当“添加内容”是“定额子目”或“工作内容”,则“特征生成方式”灰显,不需选择;否则有效可选。
  197. characterFormatEle.attr('disabled', 'disabled');
  198. characterFormatEle.val(2);
  199. default:
  200. serialTypeEle.removeAttr('disabled');
  201. if (serialTypeEle.val() === '') {
  202. serialTypeEle.val(1);
  203. }
  204. childDisplayFormatEle.attr('disabled', 'disabled');
  205. break;
  206. }
  207. });
  208. // 子目生成方式选择事件
  209. $("#child-display-format").change(function() {
  210. const selected = $(this).children(":selected").val();
  211. const serialTypeEle = $("#serial-type");
  212. // 如果是编号+定额名称则序号格式不能选择
  213. if (selected === '1') {
  214. // 默认选中数字显示模式
  215. serialTypeEle.val("");
  216. serialTypeEle.attr('disabled', 'disabled');
  217. } else {
  218. serialTypeEle.val(1);
  219. serialTypeEle.removeAttr('disabled');
  220. }
  221. });
  222. /**
  223. * 获取添加规则的设置
  224. *
  225. * @return {Object} - 返回设置内容
  226. */
  227. function getAddRuleSetting() {
  228. // 添加位置
  229. const position = $("#add-position").val();
  230. // 添加内容
  231. const addContent = $("#add-content").val();
  232. // 显示格式
  233. const displayFormat = $("#display-format").val();
  234. // 特征生成方式
  235. const characterFormat = $("#character-format").val();
  236. // 子目生成方式
  237. const childDisplayFormat = $("#child-display-format").val();
  238. // 序号格式
  239. const serialType = $("#serial-type").val();
  240. const setting = {
  241. serialType,
  242. characterFormat,
  243. addContent,
  244. position,
  245. displayFormat,
  246. childDisplayFormat,
  247. };
  248. return setting;
  249. }
  250. /**
  251. * 根据配置设置规则
  252. *
  253. * @param {Object} setting - 数据库中读取的数据
  254. * @return {void}
  255. */
  256. function setRule(setting) {
  257. if (Object.keys(setting).length <= 0) {
  258. return;
  259. }
  260. $("#add-position").val(setting.position);
  261. $("#add-position").change();
  262. $("#add-content").val(setting.addContent);
  263. $("#add-content").change();
  264. $("#display-format").val(setting.displayFormat);
  265. $("#character-format").val(setting.characterFormat);
  266. $("#child-display-format").val(setting.childDisplayFormat);
  267. $("#child-display-format").change();
  268. $("#serial-type").val(setting.serialType);
  269. }
  270. function activeSubSheetIs(idx){
  271. let rst = subSpread.getActiveSheetIndex() == idx;
  272. return rst;
  273. }
  274. //弹出清单规则或定额库后导致subSpread和特征及内容spread显示出问题
  275. function refreshSubSpread(){
  276. if(pageCCOprObj.active){
  277. contentOprObj.workBook.refresh();
  278. characterOprObj.workBook.refresh();
  279. }
  280. else{
  281. subSpread.refresh();
  282. }
  283. }
  284. let subViewObj = {
  285. linkTabClick: function () {
  286. $("#subItems").children().hide();
  287. $($(this).attr('href')).show();
  288. },
  289. loadComments: function (node) {
  290. if (node) {
  291. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  292. $('#comments>textarea').val(node.data.comments)
  293. } else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
  294. $('#comments>textarea').val(node.data.content);
  295. }
  296. }
  297. },
  298. saveComments: function (node) {
  299. let text = $('#comments>textarea').val();
  300. if (node && node.sourceType === projectObj.project.Bills.getSourceType()) {
  301. if (node.data.comments !== text) {
  302. projectObj.project.Bills.updateField(node.source, "comments", text);
  303. }
  304. } else if (node && node.sourceType === projectObj.project.Ration.getSourceType()) {
  305. if (node.data.comments !== text) {
  306. projectObj.project.Ration.updateField(node.source, "comments", text);
  307. }
  308. }
  309. }
  310. }
  311. $("#linkComments").click(subViewObj.linkTabClick);