package com.northglass.repository;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.Rank;
|
|
|
public interface RankDao extends JpaRepository<Rank, Long> {
|
|
@Query("select r from Rank r where r.endtime >= ?1 and r.endtime <= ?2")
|
public List<Rank> findRanksByStartTimeAndCompleteTime(Date create_time,Date end_time);
|
|
@Query("select r from Rank r where r.shelfRack.id= ?1 and flag='0'")
|
public Rank findbyShelfRack(Long id);
|
|
@Query("select r from Rank r where r.endtime >= ?1 and r.endtime <= ?2 order by r.endtime desc")
|
public List<Rank> findalltime(Date create_time,Date end_time);
|
|
@Query("select r from Rank r where r.endtime >= ?1 and r.endtime <= ?2 and r.batchId=?3 order by r.endtime desc")
|
public List<Rank> findalltimebatchid(Date create_time,Date end_time,String batchid);
|
|
}
|
