package com.gkhy.testFourierSpecialGasMonitor.repository;

import com.gkhy.testFourierSpecialGasMonitor.entity.GasWarnLog;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.stereotype.Repository;

import java.time.LocalDateTime;
import java.util.List;

/**
 * @author Mr.huang
 * @decription
 * @date 2023/8/9 16:47
 */
@Repository
public interface GasWarnLogRepository extends JpaRepository<GasWarnLog,Long>, JpaSpecificationExecutor<GasWarnLog> {

    GasWarnLog findByIdAndStatus(Long id,Byte status);

    List<GasWarnLog> findAllByWarnTimeBetweenOrderByWarnTimeDesc(LocalDateTime startTime,LocalDateTime endTime);
}