package cn.gistack.sm.sjztmd.mapper;
|
|
import cn.gistack.sm.sjztmd.entity.YwFloodReportInfo;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.Date;
|
|
/**
|
* @Author AIX
|
* @Date 2024/7/8 12:34
|
* @Version 1.0
|
*/
|
public interface YwFloodReportInfoMapper extends BaseMapper<YwFloodReportInfo> {
|
|
@Select("SELECT * FROM ywxt.yw_flood_report_info WHERE create_time >= #{oneDayBefore} ORDER BY create_time ASC LIMIT 1")
|
YwFloodReportInfo getLatestReport(@Param("oneDayBefore") String oneDayBefore);
|
|
}
|