From 5aeb1fd2d825392fb0b2ac00e6edf16a2cdbc5b7 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 월, 13 12월 2021 14:53:07 +0900 Subject: [PATCH] 이슈 검색시 하위 이슈도 검색되는 오류수정 --- src/main/java/kr/wisestone/owl/vo/IssueVo.java | 9 +++++++++ src/main/resources/mybatis/query-template/issue-template.xml | 10 ++++++++++ src/main/webapp/scripts/app/issue/issueList.controller.js | 8 ++++++++ 3 files changed, 27 insertions(+), 0 deletions(-) diff --git a/src/main/java/kr/wisestone/owl/vo/IssueVo.java b/src/main/java/kr/wisestone/owl/vo/IssueVo.java index 264c5d3..aa34bb3 100644 --- a/src/main/java/kr/wisestone/owl/vo/IssueVo.java +++ b/src/main/java/kr/wisestone/owl/vo/IssueVo.java @@ -56,6 +56,7 @@ private String modifyByName; // 蹂�寃쎌옄 �젙蹂� - �씠�뒋 蹂�寃� �젙蹂� �긽�꽭 �솗�씤�뿉�꽌 �궗�슜 private WorkflowStatusVo workflowStatusVo; private IssueVo parentIssueVo; + private Long parentIssueId; private int downIssueCount; private int downIssueAllCount; private List<Long> workflowDepartmentIds; // �썙�겕�뵆濡쒖슦�뿉 �꽕�젙�븳 �떞�떦遺��꽌 ID @@ -521,4 +522,12 @@ this.issueTableConfigVos.add(issueTableConfigVo); } } + + public Long getParentIssueId() { + return parentIssueId; + } + + public void setParentIssueId(Long parentIssueId) { + this.parentIssueId = parentIssueId; + } } diff --git a/src/main/resources/mybatis/query-template/issue-template.xml b/src/main/resources/mybatis/query-template/issue-template.xml index 5c3a3c7..d4dea19 100644 --- a/src/main/resources/mybatis/query-template/issue-template.xml +++ b/src/main/resources/mybatis/query-template/issue-template.xml @@ -552,6 +552,7 @@ FROM issue issue LEFT OUTER JOIN issue_department isd ON issue.id = isd.issue_id LEFT OUTER JOIN issue_status iss ON iss.id = issue.issue_status_id + LEFT OUTER JOIN user_department ud ON ud.department_id = isd.department_id WHERE 1=1 AND issue.parent_issue_id IS NULL <if test="title != null and !title.equals('') "> @@ -649,6 +650,15 @@ </choose> <choose> + <when test="departmentIds.size != 0 and myDepartmentIds != null and myDepartmentIds.size != 0"> + AND isd.department_id IN + <foreach collection="myDepartmentIds" item="item" index="index" separator="," open="(" close=")"> + #{item} + </foreach> + </when> + </choose> + + <choose> <when test="registerIds.size != 0"> AND issue.register_id IN <foreach collection="registerIds" item="item" index="index" separator="," open="(" close=")"> diff --git a/src/main/webapp/scripts/app/issue/issueList.controller.js b/src/main/webapp/scripts/app/issue/issueList.controller.js index ed3d50f..ca0df09 100644 --- a/src/main/webapp/scripts/app/issue/issueList.controller.js +++ b/src/main/webapp/scripts/app/issue/issueList.controller.js @@ -624,6 +624,14 @@ if (result.data.message.status === "success") { if (result.data.data != null && result.data.data.length > 0) { + for (var i = 0; i < result.data.data.length; i++) { + if (result.data.data[i].parentIssueId != null) { + result.data.data.splice(i, 1); + } + } + } + + if (result.data.data != null && result.data.data.length > 0) { $scope.vm.issueTypeId = result.data.data[0].issueTypeId; $scope.vm.projectKey = result.data.data[0].projectKey; $scope.vm.issueNumber = result.data.data[0].issueNumber; -- Gitblit v1.8.0