package com.zhitan.engine.repository;
|
|
import com.zhitan.engine.entity.ElectricityPriceDate;
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
import org.springframework.data.repository.query.Param;
|
import org.springframework.stereotype.Repository;
|
|
import java.time.LocalDate;
|
import java.util.List;
|
|
/**
|
* 尖峰平谷电价时间段数据访问层
|
*/
|
@Repository
|
public interface ElectricityPriceDateRepository extends JpaRepository<ElectricityPriceDate, String> {
|
|
/**
|
* 查询指定日期生效的电价配置
|
*
|
* @param date 日期
|
* @return 电价配置时间段
|
*/
|
@Query("SELECT e FROM ElectricityPriceDate e WHERE :date BETWEEN e.beginDate AND e.endDate")
|
List<ElectricityPriceDate> findEffectiveByDate(@Param("date") LocalDate date);
|
|
/**
|
* 查询当前生效的电价配置
|
*
|
* @return 电价配置时间段
|
*/
|
@Query("SELECT e FROM ElectricityPriceDate e WHERE CURRENT_DATE BETWEEN e.beginDate AND e.endDate")
|
List<ElectricityPriceDate> findCurrentEffective();
|
}
|