package com.ruoyi.business.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ruoyi.business.entity.TimingTask;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.time.LocalDateTime;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 定时巡检任务表 Mapper 接口
|
* </p>
|
*
|
* @author ld
|
* @since 2025-06-30
|
*/
|
@Mapper
|
public interface TimingTaskMapper extends BaseMapper<TimingTask> {
|
|
@Select("SELECT * FROM timing_task WHERE next_execution_time <= #{currentTime}")
|
List<TimingTask> selectActiveTasks(@Param("currentTime") LocalDateTime currentTime);}
|
