需求:
- 从数据库查询时间配置, 如果时间从今天开始, 要排除掉今天已过去的时间 !
- 先看下结果
现在是15:30
{
"status": "200",
"msg": "成功",
"data": [
{
"days": "2021-11-25",
"list": [
{
"days": "16:00",
"status": "1"
},
{
"days": "17:00",
"status": "1"
},
{
"days": "18:00",
"status": "1"
}
]
},
{
"days": "2021-11-26",
"list": [
{
"days": "08:00",
"status": "1"
},
{
"days": "09:00",
"status": "1"
},
{
"days": "10:00",
"status": "1"
},
{
"days": "11:00",
"status": "1"
},
{
"days": "12:00",
"status": "1"
},
{
"days": "13:00",
"status": "1"
},
{
"days": "14:00",
"status": "1"
},
{
"days": "15:00",
"status": "1"
},
{
"days": "16:00",
"status": "1"
},
{
"days": "17:00",
"status": "1"
},
{
"days": "18:00",
"status": "1"
}
]
}
],
"error": "Success",
"timestamp": 1637825763797
}
上代码
- 返回的实体类
@Data
public class TimeDto {
@ApiModelProperty("显示日期")
private String days;
@ApiModelProperty("时间段")
private List<TimeRangeDto> list;
}
- 时间段的实体类
@Data
public class TimeRangeDto {
@ApiModelProperty("时间段")
private String days;
@ApiModelProperty("是否可选 0否1是")
private String status; // 目前都是1
}
- 实现代码
public List<TimeDto> selectTimeRange() {
List<TimeDto> list = new ArrayList<>();
Date date = new Date();
String dateString = DateUtils.dateFormat(date, DateUtils.DATE_TIME_SECOND_PATTERN);
//简单的查询需要配置的时间设置,不付代码
Setting Setting = SettingMapper.selectInfo();
// 这里的时间格式是: 08:00这样的
List<TimeRangeDto> timeRangeList = getTimeRangeList(Integer.valueOf(Setting.getTimeFrom().split(":")[0])
, Integer.valueOf(omcSetting.getTimeTo().split(":")[0]), 1); // 最后一个参数是时间间隔
// 获取时间段数据,数据库存的int
for(int i = Setting.getDayFrom(); i <= Setting.getDayTo(); i++) {
TimeDto timeDto = new TimeDto();
String days = DateUtils.dateFormat(DateUtils.addDays(i, date), DateUtils.DATE_PATTERN); // DateUtils.DATE_PATTERN 格式: yyyy-MM-dd HH:mm:ss
timeDto.setDays(fullDays);
if(i == 0){
List<TimeRangeDto> timeRangeListToady = new ArrayList<>();
// 今天需要判断时间段是否超过 , 时间格式: yyyy-MM-dd HH:mm:ss
int minTime = Integer.valueOf(dateString.substring(11, 13));
for (TimeRangeDto timeRangeDto : timeRangeList) {
if(Integer.valueOf(timeRangeDto.getDays().split(" - ")[0].split(":")[0]) > minTime){
timeRangeListToady.add(timeRangeDto);
}
}
timeDto.setList(timeRangeListToady);
if(timeRangeListToady.size() > 0){
list.add(timeDto);
}
}else{
timeDto.setList(timeRangeList);
}
if(i != 0){
list.add(timeDto);
}
}
return list;
}
- getTimeRangeList方法
ublic List<TimeRangeDto> getTimeRangeList(int start, int end, int interval){ // 最后一个参数是时间间隔
List<TimeRangeDto> list = new ArrayList<>();
for (int i = start; i <= end; i += invaral) {
TimeRangeDto timeRangeDto = new TimeRangeDto();
timeRangeDto.setStatus("1");
timeRangeDto.setDays(((i < 10 ? ("0" + i) : i) + ":00"));
list.add(timeRangeDto);
}
return list;
}
- 工具类, dateFormat, 局部的,应该够用
import org.apache.commons.lang3.StringUtils;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
public class DateUtils {
public static final String DATE_TIME_SECOND_PATTERN = "yyyy-MM-dd HH:mm:ss";
public static final String DATE_PATTERN = "yyyy-MM-dd";
public static String dateFormat(Date date, String dateFormat) {
if (date == null) {
return "";
} else {
SimpleDateFormat format = new SimpleDateFormat(dateFormat);
try {
return format.format(date);
} catch (Exception var4) {
return "";
}
}
}
public static Date addDays(int days, Date stamp) {
Long milliseconds = (long)(days * 24 * 60 * 60 * 1000);
return new Date(stamp.getTime() + milliseconds);
}
}
拿去耍 ! ! !