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/IssueServiceImpl.java |  214 +++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 191 insertions(+), 23 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
index bb52d12..8e77478 100644
--- a/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
+++ b/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
@@ -17,7 +17,10 @@
 import kr.wisestone.owl.exception.OwlRuntimeException;
 import kr.wisestone.owl.mapper.IssueMapper;
 import kr.wisestone.owl.mapper.ProjectMapper;
+import kr.wisestone.owl.repository.IssueRelationRepository;
 import kr.wisestone.owl.repository.IssueRepository;
+import kr.wisestone.owl.repository.UserDepartmentRepository;
+import kr.wisestone.owl.repository.WorkflowDepartmentRepository;
 import kr.wisestone.owl.service.*;
 import kr.wisestone.owl.util.*;
 import kr.wisestone.owl.util.DateUtil;
@@ -55,6 +58,9 @@
 
     @Autowired
     private ProjectService projectService;
+
+    @Autowired
+    private IssueTableConfigService issueTableConfigService;
 
     @Autowired
     private IssueStatusService issueStatusService;
@@ -153,6 +159,9 @@
     private IssueRelationService issueRelationService;
 
     @Autowired
+    private IssueRelationRepository issueRelationRepository;
+
+    @Autowired
     private ExcelView excelView;
 
     @Autowired
@@ -163,6 +172,12 @@
 
     @Autowired
     private SimpMessagingTemplate simpMessagingTemplate;
+
+    @Autowired
+    private UserDepartmentRepository userDepartmentRepository;
+
+    @Autowired
+    private WorkflowDepartmentRepository workflowDepartmentRepository;
 
     @Override
     protected JpaRepository<Issue, Long> getRepository() {
@@ -214,7 +229,6 @@
             }
         }
 
-
         // �봽濡쒖젥�듃 �엯�젰
         Project project = issueType.getProject();
         if (project == null){
@@ -235,12 +249,19 @@
                 issueForm.setSeverityId(issueApiDefault.getSeverity().getId());
             }
 
-            // 以묐났 媛� �븯�쐞 �씠�뒋濡� 泥섎━�븯湲�
+            // 以묐났 媛� �긽�쐞 �씠�뒋�쓽 �븯�쐞 �씠�뒋濡� 泥섎━�븯湲�
             CustomFieldApiOverlapForm customFieldApiOverlapForm = new CustomFieldApiOverlapForm();
             customFieldApiOverlapForm.setUserId(user.getId());
             customFieldApiOverlapForm.setIssueTypeId(issueForm.getIssueTypeId());
 
-            List<IssueVo> issueVos = this.findIssue(issueApiForm, user.getId());
+            // �긽�쐞�씪媛먯뿉 �궗�슜�븷 以묐났媛� �꽕�젙
+            List<CustomFieldApiOverlap> customFieldApiOverlaps = this.customFieldApiOverlapService.find(user.getId(), issueApiForm.getIssueTypeId());
+            for(int i=0; i < customFieldApiOverlaps.size() ; i++ ){
+                CustomFieldApiOverlap customFieldApiOverlap = customFieldApiOverlaps.get(i);
+                issueApiForm.addUseIssueCustomFieldId(customFieldApiOverlap.getCustomField().getId());
+            }
+
+            List<IssueVo> issueVos = this.findIssue(issueApiForm, customFieldApiOverlaps, user.getId());
             int size = issueVos.size();
             if (size == 1) {
                 issueForm.setParentIssueId(issueVos.get(0).getId());
@@ -276,25 +297,46 @@
     //  API 瑜� �넻�빐 �씠�뒋 異붽�.
     @Override
     @Transactional
-    public Issue addApiIssue(IssueApiForm issueApiForm) {
+    public List<Issue> addApiIssue(IssueApiForm issueApiForm) throws CloneNotSupportedException {
         User user = convertToUser(issueApiForm.getToken());
         IssueForm issueForm = this.convertToIssueForm(issueApiForm, user);
 
-        return addIssue(user, issueForm, issueApiForm.getMultipartFiles());
+        List<Issue> issues = Lists.newArrayList();
+        if (issueForm.getParentIssueId() != null) {
+            issues.add(addIssue(user, issueForm, issueApiForm.getMultipartFiles()));
+        } else {
+            // �긽�쐞 �씠�뒋 異붽�
+            IssueForm parentIssueForm = issueForm.clone();
+            parentIssueForm.setUseIssueCustomFields(issueApiForm.getUseIssueCustomFieldIds());
+            Issue issue = addIssue(user, parentIssueForm, null);
+            issues.add(issue);
+            // �븯�쐞 �씠�뒋 異붽�
+            issueForm.setParentIssueId(issue.getId());
+            issues.add(addIssue(user, issueForm, issueApiForm.getMultipartFiles()));
+        }
+
+        return issues;
     }
 
-
+    // �긽�쐞 �씠�뒋 媛��졇�삤湲�
+    private IssueVo getParentIssueVo(Long parentIssueId) {
+        if (parentIssueId != null) {
+            Issue parentIssue = this.getIssue(parentIssueId);
+            return ConvertUtil.copyProperties(parentIssue, IssueVo.class);
+        }
+        return null;
+    }
 
     // 以묐났�맂 �긽�쐞 �씠�뒋 寃��깋
-    private List<IssueVo> findIssue(IssueApiForm issueApiForm, Long userId) {
-
-        List<CustomFieldApiOverlap> customFieldApiOverlaps = this.customFieldApiOverlapService.find(userId, issueApiForm.getIssueTypeId());
+    private List<IssueVo> findIssue(IssueApiForm issueApiForm, List<CustomFieldApiOverlap> customFieldApiOverlaps, Long userId) {
 
         List<IssueVo> resultIssueVos = new ArrayList<>();
+
         if (customFieldApiOverlaps != null && customFieldApiOverlaps.size() > 0) {
             for (CustomFieldApiOverlap customFieldApiOverlap : customFieldApiOverlaps) {
                 for (IssueCustomFieldValueForm issueCustomFieldValue : issueApiForm.getIssueCustomFieldValues()) {
                     IssueCustomFieldValueCondition issueCustomFieldValueCondition = new IssueCustomFieldValueCondition();
+                    issueCustomFieldValueCondition.setUseParentIssueId(true);
                     if (customFieldApiOverlap.getCustomField().getId().equals(issueCustomFieldValue.getCustomFieldId())) {
                         issueCustomFieldValueCondition.setUseValue(issueCustomFieldValue.getUseValue());
 
@@ -353,7 +395,7 @@
         //  �궇吏� �쑀�슚�꽦 泥댄겕
         this.checkStartCompleteDate(issueForm.getStartDate(), issueForm.getCompleteDate());
         //  �떞�떦 遺��꽌 �쑀�슚�꽦 泥댄겕
-        this.verifyIssueDepartment(project, issueForm);
+        //this.verifyIssueDepartment(project, issueForm);
 
         //  �씠�뒋 �긽�깭 �쑀�삎�씠 '��湲�' �씤 �씠�뒋 �긽�깭 媛��졇�삤湲�
         IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
@@ -439,7 +481,7 @@
         //  �궇吏� �쑀�슚�꽦 泥댄겕
         this.checkStartCompleteDate(issueForm.getStartDate(), issueForm.getCompleteDate());
         //  �떞�떦 遺��꽌 �쑀�슚�꽦 泥댄겕
-        this.verifyIssueDepartment(project, issueForm);
+        //this.verifyIssueDepartment(project, issueForm);
 
         //  �씠�뒋 �긽�깭 �쑀�삎�씠 '��湲�' �씤 �씠�뒋 �긽�깭 媛��졇�삤湲�
         IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
@@ -644,11 +686,41 @@
         }
     }
 
+    void SetMyDepartmentId(IssueCondition issueCondition){
+        Long loginId = issueCondition.getLoginUserId();
+        List<Long> myDepartmentIds = Lists.newArrayList();
+        List<UserDepartment> myDepartments = this.userDepartmentRepository.findByUserId(loginId);
+
+        if(myDepartments != null && myDepartments.size() > 0){
+            for(UserDepartment myDepartment : myDepartments){
+                myDepartmentIds.add(myDepartment.getDepartmentId());
+            }
+        }
+        issueCondition.setMyDepartmentIds(myDepartmentIds);
+    }
+
+    void SetWorkflowDepartment(List<IssueVo> issueVos){
+        for(IssueVo issueVo : issueVos){
+            Long issueTypeId = issueVo.getIssueTypeId();
+            IssueType issueType = this.issueTypeService.getIssueType(issueTypeId);
+            Long workflowId = issueType.getWorkflow().getId();
+            List<WorkflowDepartment> workflowDepartmentList = this.workflowDepartmentRepository.findByWorkflowId(workflowId);
+            List<Long> workflowDepartmentIds = Lists.newArrayList();
+            if(workflowDepartmentList != null && workflowDepartmentList.size()>0){
+                for(WorkflowDepartment workflowDepartment : workflowDepartmentList){
+                    workflowDepartmentIds.add(workflowDepartment.getDepartment().getId());
+                }
+            }
+            if(issueVo.getIssueTypeId().equals(issueTypeId)){
+                issueVo.setWorkflowDepartmentIds(workflowDepartmentIds);
+            }
+        }
+    }
+
     //  �씠�뒋 紐⑸줉�쓣 議고쉶�븳�떎.
     @Override
     @Transactional(readOnly = true)
-    public List<IssueVo> findIssue(Map<String, Object> resJsonData,
-                                   IssueCondition issueCondition, Pageable pageable) {
+    public List<IssueVo> findIssue(Map<String, Object> resJsonData, IssueCondition issueCondition, Pageable pageable) {
 
         //  寃��깋 議곌굔�쓣 留뚮뱺�떎
         if (!this.makeIssueSearchCondition(issueCondition, Lists.newArrayList("01", "02", "03"), pageable)) {
@@ -674,12 +746,26 @@
         List<String> issueKeys = Lists.newArrayList(issueIds);
         issueCondition.setIssueIds(issueKeys);
 
-        List<Map<String, Object>> results = this.issueMapper.find(issueCondition);
+        issueCondition.setLoginUserId(this.webAppUtil.getLoginId());
+        issueCondition.setWorkspaceId(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId());
+        User user = this.webAppUtil.getLoginUserObject();
+
+        List<Map<String, Object>> results = Lists.newArrayList();
+        Long totalCount = 0L;
+
+        if (this.userWorkspaceService.checkWorkspaceManager(user)) {
+            results = this.issueMapper.find(issueCondition);
+            totalCount = this.issueMapper.count(issueCondition);
+        } else{
+            this.SetMyDepartmentId(issueCondition);
+            results = this.issueMapper.findByDepartment(issueCondition);
+            totalCount = this.issueMapper.countByDepartment(issueCondition);
+        }
+
 
         //  �뒠�떇 �쟾 - 0.8, 0.9, 0.9, 0.9, 0.9
         /*StopWatch serviceStart = new StopWatch();
         serviceStart.start();*/
-        Long totalCount = this.issueMapper.count(issueCondition);
         //  �뒠�떇 �쟾 - 1.1, 1.1, 1.3, 1.2
 
         /*serviceStart.stop();
@@ -689,10 +775,10 @@
         //  �씠�뒋 �븘�씠�뵒 珥덇린�솕
         issueCondition.setIssueIds(Lists.newArrayList());
         //  Map �뿉 �엳�뒗 �뜲�씠�꽣瑜� IssueVo �뜲�씠�꽣濡� 蹂��솚�븳�떎.
-        User user = this.webAppUtil.getLoginUserObject();
         this.setMapToIssueVo(results, issueVos, issueCondition, user);
 
         this.setCountDownIssues(results, issueVos);
+        this.SetWorkflowDepartment(issueVos); //�썙�겕�뵆濡쒖슦�뿉 �꽕�젙�븳 �떞�떦遺��꽌 媛��졇�삤湲�
 
         resJsonData.put(Constants.RES_KEY_CONTENTS, issueVos);
         resJsonData.put(Constants.REQ_KEY_PAGE_VO, new ResPage(pageable.getPageNumber(), pageable.getPageSize(),
@@ -703,21 +789,33 @@
         return issueVos;
     }
 
-    private void setCountDownIssues(List<Map<String, Object>> results, List<IssueVo> issueVos) {
+    @Override
+    @Transactional(readOnly = true)
+    public void setCountDownIssues(List<Map<String, Object>> results, List<IssueVo> issueVos) {
         for (Map<String, Object> result : results){
             List<Issue> downIssues = this.issueRepository.findByParentIssueId((Long) result.get("id")); //�븯�쐞�씠�뒋 媛��졇�삤湲�
             if(downIssues != null && downIssues.size() > 0){ //�긽�쐞�씠�뒋 媛�吏�怨� �엳�뒗 �븷�뱾�씠 �엳�쑝硫�
-                int downIssueCount = 0;
+                int downIssueAllCount = 0;// �븯�쐞�씠�뒋 �쟾泥� 移댁슫�듃
+                int downIssueCount = 0;// �븯�쐞�씠�뒋 誘몄셿猷� 移댁슫�듃
                 for(Issue downIssue : downIssues){
-                    downIssueCount ++;
+                    downIssueAllCount ++;
                     Long parentIssueId = downIssue.getParentIssue().getId();
                     Issue parentIssue = this.getIssue(parentIssueId);
                     IssueVo parentIssueVo = ConvertUtil.copyProperties(parentIssue, IssueVo.class);
-                    parentIssueVo.setDownIssueCount(downIssueCount);
+                    parentIssueVo.setDownIssueAllCount(downIssueAllCount);
+
+                    IssueStatus downIssueStatus = this.issueStatusService.getIssueStatus(downIssue.getIssueStatus().getId());
+                    IssueVo downIssueVo = ConvertUtil.copyProperties(downIssue, IssueVo.class);
+                    downIssueVo.setIssueStatusType(downIssueStatus.getIssueStatusType().toString());
+
+                    if(!downIssueVo.getIssueStatusType().equals("CLOSE")){ //誘몄셿猷� �븯�쐞�씠�뒋 泥댄겕
+                        downIssueCount ++;
+                    }
 
                     for(IssueVo issueVo : issueVos){
                         if(issueVo.getId().equals(parentIssueVo.getId())){
-                            issueVo.setDownIssueCount(parentIssueVo.getDownIssueCount());
+                            issueVo.setDownIssueCount(downIssueCount);
+                            issueVo.setDownIssueAllCount(parentIssueVo.getDownIssueAllCount());
                         }
                     }
                 }
@@ -1131,6 +1229,7 @@
 
                 case "02": //  �봽濡쒖젥�듃, �씠�뒋 �쑀�삎, �씠�뒋 �긽�깭,  �슦�꽑�닚�쐞, 以묒슂�룄, �떞�떦�옄, 泥⑤��뙆�씪, �궗�슜�옄 �젙�쓽 �븘�뱶 �젙蹂�, �뙎湲�, 湲곕줉�쓣 �뀑�똿�븳�떎.
                     this.setIssueDetail(issueVo, issue);    //  �씠�뒋 �긽�꽭 �젙蹂대�� �뀑�똿�븳�떎.
+                    this.setIssueTableConfigs(issue, issueVo);
                     issueVo.setProjectVo(ConvertUtil.copyProperties(issue.getProject(), ProjectVo.class));
                     break;
             }
@@ -1141,6 +1240,26 @@
 
         resJsonData.put(Constants.RES_KEY_CONTENTS, issueVo);
     }
+
+    // �뀒�씠釉� �꽕�젙 �뀑�똿
+    private void setIssueTableConfigs(Issue issue, IssueVo issueVo) {
+        Long IssueTypeId = issue.getIssueType().getId();
+
+        for (int tableConfigType : IssueTableConfig.IssueTableTypes) {
+            if (tableConfigType != IssueTableConfig.ISSUE_TABLE_TYPE_MAIN) {
+                issueVo.addIssueTableConfigVo(createIssueTableConfigVo(IssueTypeId, tableConfigType));
+            }
+        }
+    }
+
+    private IssueTableConfigVo createIssueTableConfigVo(Long issueTypeId, int tableConfigType) {
+        IssueTableConfig issueTableConfig = this.issueTableConfigService.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, tableConfigType);
+        if (issueTableConfig != null) {
+            return ConvertUtil.copyProperties(issueTableConfig, IssueTableConfigVo.class);
+        }
+        return new IssueTableConfigVo();
+    }
+
 
     // �븯�쐞 �씠�뒋 �젙蹂대�� �뀑�똿�븳�떎
     private void setDownIssues(Issue issue, IssueVo issueVo) {
@@ -1362,12 +1481,20 @@
     @Override
     @Transactional
     public List<IssueVo> findIssue(IssueApiForm issueApiform) {
+
         List<IssueCustomFieldValueForm> issueCustomFieldValueForms = issueApiform.getIssueCustomFieldValues();
         List<IssueVo> resultIssueVos = new ArrayList<>();
 
         IssueCustomFieldValueCondition issueCustomFieldValueCondition = new IssueCustomFieldValueCondition();
+        issueCustomFieldValueCondition.setUseParentIssueId(false);
         if (issueCustomFieldValueForms.size() > 0) {
             for (IssueCustomFieldValueForm issueCustomFieldValueForm : issueCustomFieldValueForms) {
+
+                CustomField customField = this.customFieldService.getCustomField(issueCustomFieldValueForm.getCustomFieldId());
+                CustomFieldType customFieldType = CustomFieldType.DATETIME;
+                if (customFieldType.equals(customField.getCustomFieldType())) {
+                    continue;
+                }
 //                issueCustomFieldValueCondition.addUseValue(issueCustomFieldValueForm.getUseValue());
                 issueCustomFieldValueCondition.setUseValue(issueCustomFieldValueForm.getUseValue());
                 List<Map<String, Object>> results = this.issueMapper.findByCustomFieldValue(issueCustomFieldValueCondition);
@@ -1377,6 +1504,8 @@
                     resultIssueVos.clear();
                     for (Map<String, Object> result : results) {
                         IssueVo issueVo = ConvertUtil.convertMapToClass(result, IssueVo.class);
+
+                        issueVo.setParentIssueVo(this.getParentIssueVo(MapUtil.getLong(result, "parentIssueId")));
 
                         if (findIssueVos.size() == 0) {
                             resultIssueVos.add(issueVo);
@@ -1408,6 +1537,15 @@
     }
 
 
+    // �븯�쐞 �씠�뒋媛� 紐⑤몢 醫낅즺 泥섎━ �릺�뿀�쓣 寃쎌슦 �긽�쐞�씠�뒋�룄 �셿猷� 泥섎━
+    private void setParentIssueComplete(Issue parentIssue) {
+        if (parentIssue != null) {
+            this.issueMapper.findNotCompleteByParentIssueId(parentIssue.getId());
+
+        }
+    }
+
+
     // �씠�뒋瑜� �닔�젙�븳�떎(api�슜)
     @Override
     @Transactional
@@ -1419,8 +1557,27 @@
         if (issueVos != null && issueVos.size() > 0) {
             List<Issue> issue = Lists.newArrayList();
             for (IssueVo issueVo : issueVos) {
+                IssueVo parentIssueVo = issueVo.getParentIssueVo();
                 issueForm.setId(issueVo.getId());
-                issue.add(this.modifyIssueForApi(user, issueForm, files));
+
+                // �옄�룞 醫낅즺 �긽�깭 �꽕�젙�씠 �릺�뼱 �엳吏� �븡�쑝硫� �삤瑜섎컻�깮
+                Issue modifyIssue = this.modifyIssueForApi(user, issueForm, files);
+                Issue parentIssue = modifyIssue.getParentIssue();
+                IssueType issueType = modifyIssue.getIssueType();
+                IssueStatus issueStatus = issueType.getIssueStatus();
+                if (issueStatus == null) {
+                    throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_COMPLETE_ISSUE_STATUS_NOT_EXIST));
+                }
+
+                if (parentIssue != null) {
+                    List<Map<String, Object>> results = this.issueMapper.findNotCompleteByParentIssueId(parentIssue.getId());
+                    // �븯�쐞 �씪媛먯씠 紐⑤몢 醫낅즺 �긽�깭�씪�븣 �긽�쐞 �씪媛먮룄 醫낅즺 泥섎━
+                    if (results == null || results.size() == 0) {
+                        parentIssue.setIssueStatus(issueType.getIssueStatus());
+                    }
+                }
+
+                issue.add(modifyIssue);
             }
             return issue;
         } else {
@@ -1465,7 +1622,7 @@
         //  �떞�떦�옄 �쑀�슚�꽦 泥댄겕
         //this.verifyIssueAssignee(project, issueForm);
         //  �떞�떦遺��꽌 �쑀�슚�꽦 泥댄겕
-        this.verifyIssueDepartment(project, issueForm);
+        //this.verifyIssueDepartment(project, issueForm);
 
         CheckIssueData checkIssueData = new CheckIssueData();
         checkIssueData.setIssue(issue);
@@ -1967,6 +2124,17 @@
             this.attachedFileService.removeAttachedFiles(attachedFileIds);
         }
 
+        // 吏��슱 �씠�뒋媛� �뿰愿��씠�뒋�씤吏� 泥댄겕 �썑 �뿰愿��씠�뒋 �뀒�씠釉붿뿉�꽌�룄 �궘�젣�븳�떎.
+        List<IssueRelation> issueRelationList = this.issueRelationRepository.findByRelationIssueId(issueId);
+        if (issueRelationList != null && issueRelationList.size() > 0) {
+            for(IssueRelation issueRelation : issueRelationList){
+                StringBuilder sb = new StringBuilder();
+                issueHistoryService.detectRelationIssue(IssueHistoryType.DELETE, issueRelation, sb);
+                issueHistoryService.addIssueHistory(issueRelation.getIssue(), IssueHistoryType.MODIFY, sb.toString());
+                this.issueRelationRepository.delete(issueRelation);
+            }
+        }
+
         //  �씠�뒋 �깮�꽦, �궘�젣�떆 �삁�빟 �씠硫붿씪�뿉 �벑濡앺빐�넃�뒗�떎.
         this.reservationIssueEmail(issue, EmailType.ISSUE_REMOVE);
         //  �씠�뒋 �궘�젣

--
Gitblit v1.8.0