src/main/java/kr/wisestone/owl/constant/MsgConstants.java
@@ -237,10 +237,12 @@ public static final String HOSTING_NOT_EXIST = "HOSTING_NOT_EXIST"; // 호스팅이 존재하지 않습니다. public static final String HOSTING_CODE_NOT_ENTER = "HOSTING_CODE_NOT_ENTER"; // 호스팅의 코드는 필수 입력 값입니다. public static final String HOSTING_REMOVE_NOT_SELECT = "HOSTING_REMOVE_NOT_SELECT"; // 삭제할 호스팅이 선택되지 않았습니다. public static final String HOSTING_EXIST_COMPANY = "HOSTING_EXIST_COMPANY"; // 업체에 설정되어있는 호스팅이 존재합니다. public static final String ISP_NOT_EXIST = "ISP_NOT_EXIST"; // ISP가 존재하지 않습니다. public static final String ISP_CODE_NOT_ENTER = "ISP_CODE_NOT_ENTER"; // ISP의 코드는 필수 입력 값입니다. public static final String ISP_REMOVE_NOT_SELECT = "ISP_REMOVE_NOT_SELECT"; // 삭제할 ISP가 선택되지 않았습니다. public static final String ISP_EXIST_COMPANY = "ISP_EXIST_COMPANY"; // 업체에 설정되어있는 ISP가 존재합니다. public static final String PROJECT_NOT_INCLUDE_DEPARTMENT = "PROJECT_NOT_INCLUDE_DEPARTMENT"; // 선택한 부서 중 프로젝트에 참여하고 있지 않은 부서가 있습니다. public static final String EMAIL_TEMPLATE_NOT_EXIST = "EMAIL_TEMPLATE_NOT_EXIST"; // 이메일 템플릿을 찾을수 없습니다. 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); } src/main/java/kr/wisestone/owl/service/CompanyFieldService.java
@@ -21,6 +21,10 @@ CompanyField getCompany(Long id); List<CompanyField> findByIsp(Long id); List<CompanyField> findByHosting(Long id); void detailCompany(Map<String, Object> resJsonData, CompanyFieldCondition make); void modifyCompany(CompanyFieldForm make); src/main/java/kr/wisestone/owl/service/impl/CompanyFieldServiceImpl.java
@@ -320,6 +320,18 @@ return companyFieldVos; } // ISP ID 로 조회한다 @Override public List<CompanyField> findByIsp(Long id) { return this.companyFieldRepository.findByIspId(id); } // HOSTING ID 로 조회한다 @Override public List<CompanyField> findByHosting(Long id) { return this.companyFieldRepository.findByHostingId(id); } // 업체 ID 로 조회한다 @Override public CompanyField getCompany(Long id) { src/main/java/kr/wisestone/owl/service/impl/HostingFieldServiceImpl.java
@@ -9,6 +9,7 @@ import kr.wisestone.owl.exception.OwlRuntimeException; import kr.wisestone.owl.mapper.HostingFieldMapper; import kr.wisestone.owl.repository.HostingFieldRepository; import kr.wisestone.owl.service.CompanyFieldService; import kr.wisestone.owl.service.HostingFieldService; import kr.wisestone.owl.service.WorkspaceService; import kr.wisestone.owl.util.ConvertUtil; @@ -44,6 +45,9 @@ @Autowired private WorkspaceService workspaceService; @Autowired private CompanyFieldService companyFieldService; @Autowired private ExcelView excelView; @@ -127,11 +131,16 @@ public void remove(HostingFieldForm HostingFieldForm) { if (HostingFieldForm.getRemoveIds().size() < 1) { throw new OwlRuntimeException( this.messageAccessor.getMessage(MsgConstants.COMPANY_REMOVE_NOT_SELECT)); this.messageAccessor.getMessage(MsgConstants.HOSTING_REMOVE_NOT_SELECT)); } for (Long id : HostingFieldForm.getRemoveIds()) { List<CompanyField> companyField = this.companyFieldService.findByHosting(id); if (companyField != null && companyField.size() > 0) { throw new OwlRuntimeException( this.messageAccessor.getMessage(MsgConstants.HOSTING_EXIST_COMPANY)); } else { this.hostingFieldRepository.deleteById(id); } } this.hostingFieldRepository.flush(); } src/main/java/kr/wisestone/owl/service/impl/IspFieldServiceImpl.java
@@ -9,6 +9,7 @@ import kr.wisestone.owl.exception.OwlRuntimeException; import kr.wisestone.owl.mapper.IspFieldMapper; import kr.wisestone.owl.repository.IspFieldRepository; import kr.wisestone.owl.service.CompanyFieldService; import kr.wisestone.owl.service.IspFieldService; import kr.wisestone.owl.service.WorkspaceService; import kr.wisestone.owl.util.ConvertUtil; @@ -44,6 +45,9 @@ @Autowired private WorkspaceService workspaceService; @Autowired private CompanyFieldService companyFieldService; @Autowired private ExcelView excelView; @@ -132,7 +136,13 @@ this.messageAccessor.getMessage(MsgConstants.ISP_REMOVE_NOT_SELECT)); } for (Long id : IspFieldForm.getRemoveIds()) { List<CompanyField> companyField = this.companyFieldService.findByIsp(id); if (companyField != null && companyField.size() > 0) { throw new OwlRuntimeException( this.messageAccessor.getMessage(MsgConstants.ISP_EXIST_COMPANY)); } else { this.ispFieldRepository.deleteById(id); } } this.ispFieldRepository.flush(); } src/main/webapp/WEB-INF/i18n/messages_ko_KR.properties
@@ -215,5 +215,12 @@ COMPANYFIELD_NOT_URL = URL\uC774 \uC785\uB825\uB418\uC9C0 \uC54A\uC558\uC2B5\uB2C8\uB2E4. COMPANYFIELD_USED_URL = URL\uC774 \uC774\uBBF8 \uC0AC\uC6A9\uB418\uACE0 \uC788\uC2B5\uB2C8\uB2E4. HOSTING_NOT_EXIST = \uD638\uC2A4\uD305\uC774 \uC874\uC7AC\uD558\uC9C0 \uC54A\uC2B5\uB2C8\uB2E4. HOSTING_CODE_NOT_ENTER = \uD638\uC2A4\uD305\uC758 \uCF54\uB4DC\uB294 \uD544\uC218 \uC785\uB825 \uAC12\uC785\uB2C8\uB2E4. ISP_CODE_NOT_ENTER = ISP\uC758 \uCF54\uB4DC\uB294 \uD544\uC218 \uC785\uB825 \uAC12\uC785\uB2C8\uB2E4. HOSTING_REMOVE_NOT_SELECT = \uC0AD\uC81C\uD560 \uD638\uC2A4\uD305\uC774 \uC120\uD0DD\uB418\uC9C0 \uC54A\uC558\uC2B5\uB2C8\uB2E4. HOSTING_EXIST_COMPANY = \uC5C5\uCCB4\uC5D0 \uC124\uC815\uB418\uC5B4\uC788\uB294 \uD638\uC2A4\uD305\uC774 \uC874\uC7AC\uD569\uB2C8\uB2E4. ISP_NOT_EXIST = ISP\uAC00 \uC874\uC7AC\uD558\uC9C0 \uC54A\uC2B5\uB2C8\uB2E4. ISP_CODE_NOT_ENTER = ISP\uC758 \uCF54\uB4DC\uB294 \uD544\uC218 \uC785\uB825 \uAC12\uC785\uB2C8\uB2E4. ISP_EXIST_COMPANY = \uC5C5\uCCB4\uC5D0 \uC124\uC815\uB418\uC5B4\uC788\uB294 ISP\uAC00 \uC874\uC7AC\uD569\uB2C8\uB2E4. ISP_REMOVE_NOT_SELECT = \uC0AD\uC81C\uD560 ISP\uAC00 \uC120\uD0DD\uB418\uC9C0 \uC54A\uC558\uC2B5\uB2C8\uB2E4.
