查询在一段时间内的数据

时间内的数据"/>

查询在一段时间内的数据

根据id 和开始结束时间查询该id的sjsj在startTime 和 endTime 之间的数据

public class ThirdServiceImlpl extends ServiceImpl<ThirdMapper, ThirdYc> implements IThirdService {@Overridepublic List<Third> selectByycidBysjsj(PoiParam poiParam) {QueryWrapper<Third> queryWrapper = new QueryWrapper<>();queryWrapper.lambda().eq(Third::getYcid, poiParam.getId()).orderByDesc(Third::getSjsj);if (StrUtil.isNotBlank(poiParam.getStartTime())) {queryWrapper.lambda().ge(Third::getSjsj, poiParam.getStartTime());}if (StrUtil.isNotBlank(poiParam.getEndTime())) {queryWrapper.lambda().le(Third::getSjsj,poiParam.getEndTime());}return baseMapper.selectList(queryWrapper);}
}