From 571503a6f8d3ef2eb3d6929d4a584644fff7c896 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 금, 14 1월 2022 15:53:04 +0900
Subject: [PATCH] 이슈 업체 메일 보내기 수정

---
 src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java |    7 +++++++
 1 files changed, 7 insertions(+), 0 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
index d8fff79..640eb73 100644
--- a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
+++ b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
@@ -4,8 +4,15 @@
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.repository.query.Param;
 
+import java.util.List;
+
 public interface CompanyFieldRepository extends JpaRepository<CompanyField, Long> {
 
     CompanyField findByUrl(@Param("url") String url);
 
+    CompanyField findByUrlAndIdNot(@Param("url") String url, @Param("id") Long id);
+
+    List<CompanyField> findByIspId(@Param("isp_id") Long id);
+
+    List<CompanyField> findByHostingId(@Param("hosting_id") Long id);
 }

--
Gitblit v1.8.0