| | |
|---|
| | | log.info("启动统计人员工作量任务"); |
|---|
| | | OthStatisticWorkloadMapper workloadMapper = SpringContextUtil.getBean(OthStatisticWorkloadMapper.class); |
|---|
| | | //找到最大一条日期记录 |
|---|
| | | Date maxDate = workloadMapper.selectMaxDate(); |
|---|
| | | DateTimeFormatter formatter = DateTimeFormatter.ISO_DATE; |
|---|
| | | LocalDate maxLocalDate = LocalDate.parse(workloadMapper.selectMaxDate(), formatter); |
|---|
| | | //往后循环天数汇总 //循环统计 |
|---|
| | | LocalDate maxLocalDate = null; |
|---|
| | | /* LocalDate maxLocalDate = null; |
|---|
| | | if (maxDate == null) { |
|---|
| | | maxLocalDate = LocalDate.now().minusDays(2); |
|---|
| | | } else { |
|---|
| | | maxLocalDate = maxDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDate(); |
|---|
| | | } |
|---|
| | | }*/ |
|---|
| | | |
|---|
| | | LocalDate today = LocalDate.now(); |
|---|
| | | LocalDate statisticDate = maxLocalDate.plusDays(1); |
|---|
| | |
|---|
| | | daysBetween = 30; |
|---|
| | | statisticDate = today.minusDays(daysBetween); |
|---|
| | | } |
|---|
| | | |
|---|
| | | for (int i = 1; i <= daysBetween; i++) { |
|---|
| | | Date startDt = Date.from(LocalDateTime.of(statisticDate, LocalTime.of(0, 0, 0)).atZone(ZoneId.systemDefault()).toInstant()); |
|---|
| | | Date endDt = Date.from(LocalDateTime.of(statisticDate, LocalTime.of(23, 59, 59)).atZone(ZoneId.systemDefault()).toInstant()); |
|---|
