From 1f69ad0de4a0abf9b50599146d8f9b6a22e803a3 Mon Sep 17 00:00:00 2001
From: huangzhen <867217663@qq.com>
Date: Thu, 19 Oct 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