From 257766aa7e8a88b2b371fc6f8f52751af7d84eda Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 수, 08 12월 2021 21:54:40 +0900 Subject: [PATCH] 연관 ,하위 이슈 요청 횟수 수정 --- src/main/java/kr/wisestone/owl/service/impl/IssueTableConfigServiceImpl.java | 192 ++++++++++++++--------------------------------- 1 files changed, 58 insertions(+), 134 deletions(-) diff --git a/src/main/java/kr/wisestone/owl/service/impl/IssueTableConfigServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/IssueTableConfigServiceImpl.java index 8f99a4e..dcdbf65 100644 --- a/src/main/java/kr/wisestone/owl/service/impl/IssueTableConfigServiceImpl.java +++ b/src/main/java/kr/wisestone/owl/service/impl/IssueTableConfigServiceImpl.java @@ -1,15 +1,13 @@ package kr.wisestone.owl.service.impl; import kr.wisestone.owl.constant.Constants; -import kr.wisestone.owl.domain.Issue; -import kr.wisestone.owl.domain.IssueTableConfig; -import kr.wisestone.owl.domain.User; -import kr.wisestone.owl.domain.Workspace; +import kr.wisestone.owl.domain.*; import kr.wisestone.owl.repository.IssueTableConfigRepository; import kr.wisestone.owl.service.IssueService; import kr.wisestone.owl.service.IssueTableConfigService; import kr.wisestone.owl.service.UserService; import kr.wisestone.owl.service.WorkspaceService; +import kr.wisestone.owl.util.ConvertUtil; import kr.wisestone.owl.util.MapUtil; import org.slf4j.Logger; import org.slf4j.LoggerFactory; @@ -18,6 +16,7 @@ import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import java.util.List; import java.util.Map; @Service @@ -34,170 +33,95 @@ @Autowired private UserService userService; - @Autowired - private IssueService issueService; - @Override protected JpaRepository<IssueTableConfig, Long> getRepository() { return this.issueTableConfigRepository; } - @Override - public void multipleCode() { - - } - Long issueId; + Long issueTypeId; int issueTableType = 0; //issueTableType 珥덇린媛� �꽕�젙 + + // add 以묐났肄붾뱶 �젣嫄� + public IssueTableConfig addIssueTableConfig(Map<String, Object> params, Long issueTypeId, int issueTableType) { + String issueTableConfigs = MapUtil.getString(params, "issueTableConfigs"); + IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, issueTableType); + + // �븘吏� �뀒�씠釉� 而щ읆 �꽕�젙�쓣 �븯吏� �븡�븯�쓣 寃쎌슦 + if (issueTableConfig == null) { + issueTableConfig = new IssueTableConfig(); + Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); + User user = this.userService.getUser(this.webAppUtil.getLoginId()); + issueTableConfig.setWorkspace(workspace); + issueTableConfig.setUser(user); + issueTableConfig.setIssueTypeId(issueTypeId); + issueTableConfig.setIssueTableType(issueTableType); + issueTableConfig.setIssueTableConfigs(issueTableConfigs); + }else { + issueTableConfig.setIssueTableConfigs(issueTableConfigs); + } + return this.issueTableConfigRepository.saveAndFlush(issueTableConfig); + } // �씠�뒋 �뀒�씠釉� 而щ읆 �꽕�젙 �젙蹂대�� ���옣�븳�떎. @Override @Transactional public IssueTableConfig addIssueTableConfig(Map<String, Object> params) { - String issueTableConfigs = MapUtil.getString(params, "issueTableConfigs"); - issueId = (long) -1; - issueTableType = 1; - - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 紐⑸줉 �뀒�씠釉� 而щ읆 �꽕�젙�쓣 議고쉶�븳�떎. - IssueTableConfig saveIssueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); - // �븘吏� �뀒�씠釉� 而щ읆 �꽕�젙�쓣 �븯吏� �븡�븯�쓣 寃쎌슦 - if (saveIssueTableConfig == null && saveIssueTableType == null) { - IssueTableConfig issueTableConfig = new IssueTableConfig(); - Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); - User user = this.userService.getUser(this.webAppUtil.getLoginId()); - Issue issue = this.issueService.getIssue(issueId); - issueTableConfig.setWorkspace(workspace); - issueTableConfig.setUser(user); - issueTableConfig.setIssue(issue); - issueTableConfig.setIssueTableType(issueTableType); - issueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(issueTableConfig); - } - else { - saveIssueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(saveIssueTableConfig); - } + issueTypeId = MapUtil.getLong(params, "issueTypeId"); + issueTableType = 1; //硫붿씤 + return this.addIssueTableConfig(params, issueTypeId, issueTableType); } - + // �뿰愿� �씠�뒋 �뀒�씠釉� �꽕�젙 �젙蹂� ���옣 @Override public IssueTableConfig addRelationIssueTableConfig(Map<String, Object> params) { - String issueTableConfigs = MapUtil.getString(params, "issueTableConfigs"); - - issueId = MapUtil.getLong(params, "issueId"); - issueTableType = 2; - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 紐⑸줉 �뀒�씠釉� 而щ읆 �꽕�젙�쓣 議고쉶�븳�떎. - IssueTableConfig saveIssueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); - - // �븘吏� �뀒�씠釉� 而щ읆 �꽕�젙�쓣 �븯吏� �븡�븯�쓣 寃쎌슦 - if (saveIssueTableConfig == null && saveIssueTableType == null) { - IssueTableConfig issueTableConfig = new IssueTableConfig(); - Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); - User user = this.userService.getUser(this.webAppUtil.getLoginId()); - Issue issue = this.issueService.getIssue(issueId); - issueTableConfig.setWorkspace(workspace); - issueTableConfig.setUser(user); - issueTableConfig.setIssue(issue); - issueTableConfig.setIssueTableType(issueTableType); - issueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(issueTableConfig); - }else { - saveIssueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(saveIssueTableConfig); - } + issueTypeId = MapUtil.getLong(params, "issueTypeId"); + issueTableType = 2; //�뿰愿� + return this.addIssueTableConfig(params, issueTypeId, issueTableType); } - + // �븯�쐞 �씠�뒋 �뀒�씠釉� �꽕�젙 �젙蹂� ���옣 @Override public IssueTableConfig addDownIssueTableConfig(Map<String, Object> params) { - String issueTableConfigs = MapUtil.getString(params, "issueTableConfigs"); - - issueId = MapUtil.getLong(params, "issueId"); - issueTableType = 3; - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 紐⑸줉 �뀒�씠釉� 而щ읆 �꽕�젙�쓣 議고쉶�븳�떎. - IssueTableConfig saveIssueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); - - // �븘吏� �뀒�씠釉� 而щ읆 �꽕�젙�쓣 �븯吏� �븡�븯�쓣 寃쎌슦 - if (saveIssueTableConfig == null && saveIssueTableType == null) { - IssueTableConfig issueTableConfig = new IssueTableConfig(); - Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); - User user = this.userService.getUser(this.webAppUtil.getLoginId()); - Issue issue = this.issueService.getIssue(issueId); - issueTableConfig.setWorkspace(workspace); - issueTableConfig.setUser(user); - issueTableConfig.setIssue(issue); - issueTableConfig.setIssueTableType(issueTableType); - issueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(issueTableConfig); - }else { - saveIssueTableConfig.setIssueTableConfigs(issueTableConfigs); - return this.issueTableConfigRepository.saveAndFlush(saveIssueTableConfig); - } + issueTypeId = MapUtil.getLong(params, "issueTypeId"); + issueTableType = 3; //�븯�쐞 + return this.addIssueTableConfig(params, issueTypeId, issueTableType); } + // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 �뀒�씠釉� �꽕�젙�쓣 議고쉶�븳�떎. @Override @Transactional(readOnly = true) - public IssueTableConfig findByUserIdAndWorkspaceId() { - return this.issueTableConfigRepository.findByUserIdAndWorkspaceId(this.webAppUtil.getLoginId(), - this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); + public IssueTableConfig findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(Long issueTypeId, int issueTableType) { + List<IssueTableConfig> issueTableConfigList = this.issueTableConfigRepository.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(this.webAppUtil.getLoginId(), + this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId(), issueTypeId, issueTableType); + + if (issueTableConfigList != null && issueTableConfigList.size() > 0) { + return issueTableConfigList.get(0); + } + return null; } + //�씠�뒋���엯 Id�� IssueTableType 議고쉶 @Override @Transactional(readOnly = true) - public IssueTableConfig findByIssueIdAndIssueTableType(Long issueId, int issueTableType) { - return this.issueTableConfigRepository.findByIssueIdAndIssueTableType(issueId, issueTableType); + public IssueTableConfig findByIssueTypeIdAndIssueTableType(Long issueTypeId, int issueTableType) { + List<IssueTableConfig> issueTableConfigs = this.issueTableConfigRepository.findByIssueTypeIdAndIssueTableType(issueTypeId, issueTableType); + if (issueTableConfigs != null && issueTableConfigs.size() > 0){ + return issueTableConfigs.get(0); + } + return null; } - // ���옣�맂 �씠�뒋 �뀒�씠釉� �꽕�젙�쓣 議고쉶�븳�떎. @Override - @Transactional(readOnly = true) - public void detailIssueTableConfig(Map<String, Object> resJsonData) { - issueId = (long) -1; - issueTableType = 1; - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 寃��깋 議곌굔�쓣 議고쉶�븳�떎. - IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); + public void detailIssueTableConfig(Map<String, Object> params, Map<String, Object> resJsonData) { + Long issueTypeId = MapUtil.getLong(params,"issueTypeId"); + int issueTableType = MapUtil.getInteger(params,"issueTableType"); - if (issueTableConfig != null && saveIssueTableType != null) { + IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, issueTableType); + + if (issueTableConfig != null) { resJsonData.put(Constants.RES_KEY_CONTENTS, issueTableConfig.getIssueTableConfigs()); } else { resJsonData.put(Constants.RES_KEY_CONTENTS, ""); } } - - // ���옣�맂 �뿰愿� �씠�뒋 �뀒�씠釉� �꽕�젙 議고쉶 - @Override - public void detailRelationIssueTableConfig(Long issueId, Map<String, Object> resJsonData) { - issueTableType = 2; - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 寃��깋 議곌굔�쓣 議고쉶�븳�떎. - IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); - - if (issueTableConfig != null && saveIssueTableType != null) { - resJsonData.put(Constants.RES_KEY_CONTENTS, issueTableConfig.getIssueTableConfigs()); - } - else { - resJsonData.put(Constants.RES_KEY_CONTENTS, ""); - } - } - - // ���옣�맂 �븯�쐞 �씠�뒋 �뀒�씠釉� �꽕�젙 議고쉶 - @Override - public void detailDownIssueTableConfig(Long issueId, Map<String, Object> resJsonData) { - issueTableType = 3; - // �빐�떦 �뾽臾� 怨듦컙�뿉�꽌 �궗�슜�옄�쓽 �씠�뒋 寃��깋 議곌굔�쓣 議고쉶�븳�떎. - IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceId(); - IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType); - - if (issueTableConfig != null && saveIssueTableType != null) { - resJsonData.put(Constants.RES_KEY_CONTENTS, issueTableConfig.getIssueTableConfigs()); - } - else { - resJsonData.put(Constants.RES_KEY_CONTENTS, ""); - } - } - - } -- Gitblit v1.8.0