From 5eff686e04c7395c2ff75b0861507d3ec15b0c3e Mon Sep 17 00:00:00 2001
From: sgj <1442489573@qq.com>
Date: 星期三, 24 十二月 2025 10:58:20 +0800
Subject: [PATCH] ai事件、智能抓拍修改

---
 fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java |   32 ++++++++++++++++++++------------
 1 files changed, 20 insertions(+), 12 deletions(-)

diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java
index 2a4acd5..6c7cd7a 100644
--- a/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java
@@ -7,6 +7,7 @@
 import com.fzzy.igds.domain.SnapRecord;
 import com.fzzy.igds.mapper.SnapRecordMapper;
 import com.fzzy.igds.utils.ContextUtil;
+import com.fzzy.igds.utils.DateUtil;
 import com.ruoyi.common.utils.StringUtils;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.stereotype.Service;
@@ -44,20 +45,21 @@
         param.setCompanyId(ContextUtil.getCompanyId());
         queryWrapper.eq("company_id", param.getCompanyId());
 
+        //搴撳尯妫�绱�
         if (StringUtils.isNotBlank(param.getDeptId())) {
             queryWrapper.eq("dept_id", param.getDeptId());
         }
-
-        if (StringUtils.isNotBlank(param.getDepotId())) {
-            queryWrapper.eq("depot_id", param.getDepotId());
-        }
-        //鏍囩妫�绱�
+        // 鏀跺偍鍏徃妫�绱�
         if (StringUtils.isNotBlank(param.getKey())) {
-            queryWrapper.like("tags", param.getKey());
+            queryWrapper.apply("dept_id IN (SELECT dept_id FROM sys_dept WHERE parent_id = {0})", param.getKey());
         }
         //鎶撴媿鏃堕棿妫�绱�
         if (param.getStart() != null && param.getEnd() != null) {
             queryWrapper.between("snap_time", param.getStart(), param.getEnd());
+        }
+        //鏍囩妫�绱�
+        if (StringUtils.isNotBlank(param.getName())) {
+            queryWrapper.like("tags", param.getName());
         }
 
         queryWrapper.orderByDesc("create_time");
@@ -72,14 +74,20 @@
      * @author sgj
      * @date 2025/12/10
      */
-    public List<SnapRecord> listAll(IgdsBaseParam param) {
-
-        if (null == param)
-            return snapRecordMapper.selectList(null);
+    public List<SnapRecord> getListByParam(IgdsBaseParam param) {
+        if (null == param){
+            param = new IgdsBaseParam();
+        }
 
         QueryWrapper<SnapRecord> queryWrapper = new QueryWrapper<>();
-        if (StringUtils.isNotEmpty(param.getName())) {
-            queryWrapper.like("name", param.getName());
+        if (StringUtils.isNotBlank(param.getDeptId())) {
+            queryWrapper.likeRight("dept_id", param.getDeptId());
+        }
+        if (null != param.getStart()) {
+            queryWrapper.ge("snap_time", DateUtil.getCurZero(param.getStart()));
+        }
+        if (null != param.getEnd()) {
+            queryWrapper.le("snap_time", DateUtil.getNextZero(param.getEnd()));
         }
         return snapRecordMapper.selectList(queryWrapper);
     }

--
Gitblit v1.9.3