sub_view.js 12 KB

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