sub_view.js 13 KB

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