From 23e276a6e6789b38ea342ecc309b74f87344e131 Mon Sep 17 00:00:00 2001
From: zhou zhou <3272660260@qq.com>
Date: 星期四, 20 十一月 2025 09:56:31 +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