package com.fzzy.async.fzzy40.repository; import com.fzzy.async.fzzy40.entity.Fz40SecSnapDepot; 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; /** * 仓内视频图像 * * @author czt * @date 2024-01-02 */ public interface Fzzy40Sync1307Rep extends JpaRepository { /** * 根据信息获取仓内抓拍信息 * * @param deptId * @param startTime * @param endTime * @return */ @Query("from Fz40SecSnapDepot where deptId=:deptId and updateTime >=:startTime and updateTime <=:endTime order by id ") List listSnapDepotData(@Param("deptId") String deptId, @Param("startTime") Date startTime, @Param("endTime") Date endTime); }