From 6e09aa2c20ff596c2dfae165d94a9af8ce281030 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Fri, 05 Jun 2026 10:12:12 +0800
Subject: [PATCH] 1
---
trading-order-huobi/src/main/java/com.yami.trading.huobi/data/internal/DataDBServiceImpl.java | 86 ++++++++++++++++++++++---------------------
1 files changed, 44 insertions(+), 42 deletions(-)
diff --git a/trading-order-huobi/src/main/java/com.yami.trading.huobi/data/internal/DataDBServiceImpl.java b/trading-order-huobi/src/main/java/com.yami.trading.huobi/data/internal/DataDBServiceImpl.java
index 9b42c5b..eb73aa7 100644
--- a/trading-order-huobi/src/main/java/com.yami.trading.huobi/data/internal/DataDBServiceImpl.java
+++ b/trading-order-huobi/src/main/java/com.yami.trading.huobi/data/internal/DataDBServiceImpl.java
@@ -119,10 +119,10 @@
LocalDate yesterday = LocalDate.now(ZoneId.of("America/New_York")).minusDays(1);
// 4. 判断是否为昨天
- boolean isYesterday = tsDate.equals(yesterday);
- if (isYesterday) {
- return realtime;
- }
+ boolean isYesterday = tsDate.equals(yesterday);
+ if (isYesterday) {
+ return realtime;
+ }
}
// 没缓存重新保存
// 计算当天0点的时间戳(毫秒级)
@@ -144,63 +144,65 @@
public BeforeClose getBeforeClose(String symbol, String line, Long ts, Realtime realtime) {
BeforeClose beforeClose = (BeforeClose) redisTemplate.opsForValue().get(RedisKeys.REAL_TIME_BEFORE_CLOSE + symbol + line);
- //超出时间重新计算
- if (beforeClose == null || ts > beforeClose.getTs()) {
+ long queryTs = normalizeToMillis(ts);
+ if (beforeClose == null || queryTs > beforeClose.getTs()) {
long currentTimeStamp = System.currentTimeMillis();
RequestDataHelper.set("symbol", symbol);
QueryWrapper<Realtime> queryWrapper = new QueryWrapper<Realtime>()
.eq("symbol", symbol)
- .ge("ts", ts)
+ .ge("ts", queryTs)
.le("ts", currentTimeStamp)
- .select("MAX(close) as maxClose", "MIN(close) as minClose");
+ .select("MAX(CAST(close AS DECIMAL(20,8))) as maxClose",
+ "MIN(CAST(close AS DECIMAL(20,8))) as minClose");
Map<String, Object> resultMap = realtimeService.getMap(queryWrapper);
RequestDataHelper.clear();
beforeClose = new BeforeClose();
- BigDecimal maxClose = extractAggregateValue(resultMap, "maxClose");
- BigDecimal minClose = extractAggregateValue(resultMap, "minClose");
- mergeRealtimeIntoBeforeClose(beforeClose, maxClose, minClose, realtime);
- beforeClose.setTs(ts);
+ beforeClose.setTs(queryTs);
+ if (resultMap != null && !resultMap.isEmpty()) {
+ beforeClose.setMaxClose(convertToBigDecimal(resultMap.get("maxClose")));
+ beforeClose.setMinClose(convertToBigDecimal(resultMap.get("minClose")));
+ }
redisTemplate.opsForValue().set(RedisKeys.REAL_TIME_BEFORE_CLOSE + symbol + line, beforeClose);
- } else if (realtime != null) {
- mergeRealtimeIntoBeforeClose(beforeClose, beforeClose.getMaxClose(), beforeClose.getMinClose(), realtime);
- redisTemplate.opsForValue().set(RedisKeys.REAL_TIME_BEFORE_CLOSE + symbol + line, beforeClose);
+ }
+
+ mergeRealtimeIntoBeforeClose(beforeClose, realtime, symbol, line);
+ if (!isValidBeforeClose(beforeClose)) {
+ return null;
}
return beforeClose;
}
- private void mergeRealtimeIntoBeforeClose(BeforeClose beforeClose, BigDecimal maxClose, BigDecimal minClose, Realtime realtime) {
- BigDecimal max = maxClose;
- BigDecimal min = minClose;
- if (realtime != null && realtime.getClose() != null) {
- BigDecimal latest = realtime.getClose();
- if (max == null || max.compareTo(BigDecimal.ZERO) <= 0) {
- max = latest;
- } else {
- max = max.max(latest);
+ private void mergeRealtimeIntoBeforeClose(BeforeClose beforeClose, Realtime realtime, String symbol, String line) {
+ if (realtime == null || realtime.getClose() == null || realtime.getClose().compareTo(BigDecimal.ZERO) <= 0) {
+ return;
+ }
+ BigDecimal close = realtime.getClose();
+ if (!isValidBeforeClose(beforeClose)) {
+ beforeClose.setMaxClose(close);
+ beforeClose.setMinClose(close);
+ } else {
+ if (close.compareTo(beforeClose.getMaxClose()) > 0) {
+ beforeClose.setMaxClose(close);
}
- if (min == null || min.compareTo(BigDecimal.ZERO) <= 0) {
- min = latest;
- } else {
- min = min.min(latest);
+ if (beforeClose.getMinClose().compareTo(BigDecimal.ZERO) <= 0
+ || close.compareTo(beforeClose.getMinClose()) < 0) {
+ beforeClose.setMinClose(close);
}
}
- beforeClose.setMaxClose(max == null ? BigDecimal.ZERO : max);
- beforeClose.setMinClose(min == null ? BigDecimal.ZERO : min);
+ redisTemplate.opsForValue().set(RedisKeys.REAL_TIME_BEFORE_CLOSE + symbol + line, beforeClose);
}
- private BigDecimal extractAggregateValue(Map<String, Object> resultMap, String key) {
- if (resultMap == null || resultMap.isEmpty()) {
- return null;
+ private boolean isValidBeforeClose(BeforeClose beforeClose) {
+ return beforeClose != null
+ && beforeClose.getMaxClose() != null && beforeClose.getMaxClose().compareTo(BigDecimal.ZERO) > 0
+ && beforeClose.getMinClose() != null && beforeClose.getMinClose().compareTo(BigDecimal.ZERO) > 0;
+ }
+
+ private long normalizeToMillis(Long ts) {
+ if (ts == null) {
+ return System.currentTimeMillis();
}
- if (resultMap.containsKey(key)) {
- return convertToBigDecimal(resultMap.get(key));
- }
- for (Map.Entry<String, Object> entry : resultMap.entrySet()) {
- if (entry.getKey() != null && entry.getKey().equalsIgnoreCase(key)) {
- return convertToBigDecimal(entry.getValue());
- }
- }
- return null;
+ return String.valueOf(ts).length() <= 10 ? ts * 1000 : ts;
}
// 辅助方法:统一转换为BigDecimal,避免类型错误
--
Gitblit v1.9.3