From bdb1efdc604fce543e21152b4263a9362f64389f Mon Sep 17 00:00:00 2001 From: minhee <alsdldlfrl@gmail.com> Date: 목, 10 3월 2022 15:35:19 +0900 Subject: [PATCH] - api 이슈 추가 시 입력한 ip에 속해있는 업체정보를 가진 이슈의 하위로 입력되도록 수정 - issue_company 테이블에 ip 컬럼 추가 및 이슈 추가/수정 시 ip 대역대 항목 추가 --- src/main/java/kr/wisestone/owl/mapper/IssueMapper.java | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git a/src/main/java/kr/wisestone/owl/mapper/IssueMapper.java b/src/main/java/kr/wisestone/owl/mapper/IssueMapper.java index 060e7dd..5e17cf5 100644 --- a/src/main/java/kr/wisestone/owl/mapper/IssueMapper.java +++ b/src/main/java/kr/wisestone/owl/mapper/IssueMapper.java @@ -1,6 +1,8 @@ package kr.wisestone.owl.mapper; import kr.wisestone.owl.web.condition.IssueCondition; +import kr.wisestone.owl.web.condition.IssueCustomFieldValueCondition; +import kr.wisestone.owl.web.condition.IssueTypeCondition; import kr.wisestone.owl.web.form.IssueForm; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; @@ -14,6 +16,10 @@ @Repository public interface IssueMapper { List<Map<String, Object>> find(IssueCondition issueCondition); + + List<Map<String, Object>> findByDepartment(IssueCondition issueCondition); + + List<Map<String, Object>> findByCustomFieldValue(IssueCustomFieldValueCondition issueCustomFieldValueCondition); Long count(IssueCondition issueCondition); @@ -29,6 +35,8 @@ List<Map<String, Object>> findIssueUser(IssueCondition issueCondition); + List<Map<String, Object>> findIssueDepartment(IssueCondition issueCondition); + Long countByIssueTypeId(Long issueTypeId); Long countByIssueStatusId(Long issueStatusId); @@ -38,4 +46,13 @@ List<Map<String, Object>> findByProjectId(Long projectId); List<Map<String, Object>> getAllTaskUser(IssueCondition taskCondition); + + Long countByIssueTypeIdAndDate(IssueTypeCondition issueTypeCondition); + + Long countByDepartment(IssueCondition issueCondition); + + List<Map<String, Object>> findNotCompleteByParentIssueId(IssueCondition issueCondition); + + List<Map<String, Object>> findByCustomFieldValueOfIp(IssueCustomFieldValueCondition issueCustomFieldValueCondition); } + -- Gitblit v1.8.0