sub_view.js 12 KB

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