| | |
| | | import java.time.ZoneId; |
| | | import java.time.ZonedDateTime; |
| | | import java.util.Date; |
| | | import java.util.HashSet; |
| | | import java.util.Objects; |
| | | import java.util.Set; |
| | | |
| | | import org.apache.commons.lang3.time.DateFormatUtils; |
| | | import org.springframework.lang.Nullable; |
| | |
| | | "yyyy/MM/dd", "yyyy/MM/dd HH:mm:ss", "yyyy/MM/dd HH:mm", "yyyy/MM", |
| | | "yyyy.MM.dd", "yyyy.MM.dd HH:mm:ss", "yyyy.MM.dd HH:mm", "yyyy.MM"}; |
| | | |
| | | private static String isHoliday = "1-1,1-28,1-29,1-30,1-31,2-1,2-2,2-3,2-4," |
| | | +"4-4,4-5,4-6,5-1,5-2,5-3,5-4,5-5,5-31,6-1,6-2,10-1,10-2,10-3," |
| | | +"10-4,10-5,10-6,10-7,10-8"; |
| | | |
| | | /** |
| | | * 获取两个时间内,除去周末周日以及法定节假日的 小时总数。 |
| | | * @param startDate |
| | | * @param endDate |
| | | * @return |
| | | */ |
| | | public static long getWorkingHours(Date startDate,Date endDate){ |
| | | |
| | | long workingHours = 0; |
| | | //转换日期格式 |
| | | LocalDateTime startTime = startDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); |
| | | LocalDateTime endTime = endDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); |
| | | if(startTime.isAfter(endTime)){ |
| | | throw new RuntimeException("开始时间不能晚于结束时间"); |
| | | } |
| | | LocalDateTime varTime = startTime; |
| | | //节假日日期(2025为列) |
| | | Set<LocalDate> holidays = new HashSet<>(); |
| | | String[] holiday = isHoliday.split(","); |
| | | for (String str : holiday) { |
| | | String[] md = str.split("-"); |
| | | int month = Integer.parseInt(md[0]); |
| | | int day = Integer.parseInt(md[1]); |
| | | holidays.add(LocalDate.of(2025,month,day)); |
| | | } |
| | | while (varTime.isBefore(endTime)){ |
| | | boolean isWorkDay = varTime.getDayOfWeek().getValue() < 6 |
| | | && !holidays.contains(varTime.toLocalDate()); |
| | | // 判断是否是工作日(非周末 + 非节假日) |
| | | if (isWorkDay){ |
| | | workingHours++; |
| | | } |
| | | varTime = varTime.plusHours(1); |
| | | } |
| | | return workingHours; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获取当前Date型日期 |
| | | * |