From 8bc919a3a4ad7f690ad5269628f4405df1a896b8 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期四, 18 十二月 2025 15:03:19 +0800
Subject: [PATCH] #

---
 zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/LocMapper.java |    5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)

diff --git a/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/LocMapper.java b/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/LocMapper.java
index 266f5ee..c7384cd 100644
--- a/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/LocMapper.java
+++ b/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/LocMapper.java
@@ -2,6 +2,8 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.zy.acs.manager.manager.entity.Loc;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
 
 import java.util.List;
 import java.util.Map;
@@ -12,4 +14,7 @@
 
     List<Map<String, Object>> selectDigitalLocWhichNeedShow();
 
+    @Select("SELECT * FROM man_loc WHERE loc_sts = #{locSts} ORDER BY RAND() LIMIT 1")
+    Loc selectRandOneByLocSts(@Param("locSts") Long locSts);
+
 }

--
Gitblit v1.9.1