From 1f69ad0de4a0abf9b50599146d8f9b6a22e803a3 Mon Sep 17 00:00:00 2001 From: huangzhen <867217663@qq.com> Date: 星期四, 19 十月 2023 08:57:03 +0800 Subject: [PATCH] 第一版-20231019 --- src/main/java/com/gkhy/fourierSpecialGasMonitor/service/impl/GasFluxServiceImpl.java | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/gkhy/fourierSpecialGasMonitor/service/impl/GasFluxServiceImpl.java b/src/main/java/com/gkhy/fourierSpecialGasMonitor/service/impl/GasFluxServiceImpl.java index 0b80e0d..a7b2426 100644 --- a/src/main/java/com/gkhy/fourierSpecialGasMonitor/service/impl/GasFluxServiceImpl.java +++ b/src/main/java/com/gkhy/fourierSpecialGasMonitor/service/impl/GasFluxServiceImpl.java @@ -120,4 +120,26 @@ List<GasFlux> gasFluxes = gasFluxRepository.findAll(specification); return gasFluxes; } + + @Override + public List<GasFlux> listYesterdayTenAmToSixPm() { + // 获取昨天的上午十点 + LocalDateTime yesterdayStart = LocalDateTime.now() + .minusDays(1) // 减去一天,获取昨天的日期 + .with(LocalTime.of(10, 0)); // 设置时间为上午十点 + // 获取昨天的下午6点 + LocalDateTime yesterdayEnd = LocalDateTime.now() + .minusDays(1) // 减去一天,获取昨天的日期 + .with(LocalTime.of(18, 0)); // 设置时间为下午6点 + Specification<GasFlux> specification = new Specification<GasFlux>() { + @Override + public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) { + Set<Predicate> predicateList = new HashSet<>(); + predicateList.add(criteriaBuilder.between(root.get("time").as(LocalDateTime.class),yesterdayStart,yesterdayEnd)); + return criteriaBuilder.and(predicateList.toArray(new Predicate[predicateList.size()])); + } + }; + List<GasFlux> gasFluxes = gasFluxRepository.findAll(specification); + return gasFluxes; + } } -- Gitblit v1.9.2