OWL ITS + 탐지시스템(인터넷 진흥원)
jhjang
2021-10-14 d680ff9fa4298ad3c0cd12f5f9d87f6c51110480
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
package kr.wisestone.owl.repository;
 
import kr.wisestone.owl.domain.Workspace;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import java.util.Date;
import java.util.List;
 
public interface WorkspaceRepository extends JpaRepository<Workspace, Long> {
    @Query(name="Workspace.findSubscribeImmediateExpireDate")
    List<Workspace> findSubscribeImmediateExpireDate(@Param("todayFrom") Date todayFrom, @Param("todayTo") Date todayTo);
 
    @Query(name="Workspace.findExpireDate")
    List<Workspace> findExpireDate(@Param("todayFrom") Date todayFrom, @Param("todayTo") Date todayTo);
 
    @Query(name = "Workspace.findByUserId")
    List<Workspace> findByUserId(@Param("userId") Long userId);
}