sub_view.js 11 KB

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