From 56c40ebd05a576e6f7c40ac10c78ac0463cf4074 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 19 1월 2022 11:41:13 +0900
Subject: [PATCH] 이슈 업체메일보내기 클릭 시 업체/isp/hosting 이메일 다 안가져오는 문제 해결("업체 선택" 항목은 제거 처리)
---
src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java | 10 ++++++++++
1 files changed, 10 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 afc7954..640eb73 100644
--- a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
+++ b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
@@ -2,7 +2,17 @@
import kr.wisestone.owl.domain.CompanyField;
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