From eab3b913e90f709ccd7186d0fb77b095cd229c0d Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 12 1월 2022 16:01:49 +0900
Subject: [PATCH] ISP/호스팅 삭제 시 업체에 설정 되어있을경우 삭제 불가
---
src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java | 6 ++++++
1 files changed, 6 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 3520b7e..640eb73 100644
--- a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
+++ b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
@@ -4,9 +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