From e8f734121a04baa8fe89740ec5bd9ee4f9459d3f Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期三, 26 二月 2025 09:42:27 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10105/r/YiWuProject

---
 hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageServiceImpl.java |   22 +++++++++++++---------
 1 files changed, 13 insertions(+), 9 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageServiceImpl.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageServiceImpl.java
index e1dc32f..7d726bc 100644
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageServiceImpl.java
+++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageServiceImpl.java
@@ -21,6 +21,7 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
+import javax.annotation.Resource;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
@@ -37,11 +38,8 @@
 @Service
 public class EdgStorageCageServiceImpl extends MPJBaseServiceImpl<EdgStorageCageMapper, EdgStorageCage> implements EdgStorageCageService {
 
-    @Autowired
+    @Resource
     EdgStorageCageDetailsMapper edgStorageCageDetailsMapper;
-    @Autowired
-    UpPattenUsageMapper upPattenUsageMapper;
-
     @Autowired
     DamageService damageService;
 
@@ -72,11 +70,17 @@
      */
     @Override
     public List<EdgStorageCageVO> selectEdgStorageCagesByDeviceId(int deviceId) {
-        List<EdgStorageCageVO> storageCageVOS = this.selectJoinList(EdgStorageCageVO.class, new MPJLambdaWrapper<EdgStorageCage>().leftJoin(EdgStorageCageDetails.class, on -> on
-                .eq(EdgStorageCageDetails::getDeviceId, EdgStorageCage::getDeviceId)
-                .eq(EdgStorageCageDetails::getSlot, EdgStorageCage::getSlot)
-                .eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN))
-                .eq(EdgStorageCage::getDeviceId, deviceId));
+        List<EdgStorageCageVO> storageCageVOS = this.selectJoinList(EdgStorageCageVO.class, new MPJLambdaWrapper<EdgStorageCage>()
+                .selectAll(EdgStorageCage.class)
+                .selectCollection(EdgStorageCageDetails.class, EdgStorageCageVO::getDetails)
+                .leftJoin(EdgStorageCageDetails.class, on -> on
+                        .eq(EdgStorageCageDetails::getDeviceId, EdgStorageCage::getDeviceId)
+                        .eq(EdgStorageCageDetails::getSlot, EdgStorageCage::getSlot)
+                        .eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN))
+                .eq(EdgStorageCage::getDeviceId, deviceId)
+                .orderByAsc(EdgStorageCage::getSlot)
+                .orderByAsc(EdgStorageCageDetails::getId)
+        );
         return storageCageVOS;
     }
 

--
Gitblit v1.8.0