From facf9495e8e73c72b63996f416874657f30068bd Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期六, 27 九月 2025 13:19:01 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/timer/LedWebsocket.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/timer/LedWebsocket.java b/src/main/java/com/zy/asrs/timer/LedWebsocket.java
index 3cdd235..2afa501 100644
--- a/src/main/java/com/zy/asrs/timer/LedWebsocket.java
+++ b/src/main/java/com/zy/asrs/timer/LedWebsocket.java
@@ -112,7 +112,7 @@
}
//浠撳簱鏁版嵁
EntityWrapper<LocDetl> locDetlEntityWrapper = new EntityWrapper<>();
- locDetlEntityWrapper.setSqlSelect("matnr,COUNT(*) as matnrCount").groupBy("matnr");
+ locDetlEntityWrapper.setSqlSelect("TOP 5 matnr,SUM(anfme) as matnrCount").groupBy("matnr").orderBy("matnrCount",false);
List<Map<String, Object>> selectMap = locDetlService.selectMaps(locDetlEntityWrapper);
Date now = new Date();
--
Gitblit v1.9.1