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