From c9a45ec5524b67a1236fc9d944f602c820f27069 Mon Sep 17 00:00:00 2001
From: sgj <1442489573@qq.com>
Date: 星期一, 09 三月 2026 11:59:29 +0800
Subject: [PATCH] 获取缓存仓库，代码优化
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SecCameraService.java | 46 ++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 44 insertions(+), 2 deletions(-)
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SecCameraService.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SecCameraService.java
index 2203fde..9ef68de 100644
--- a/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SecCameraService.java
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SecCameraService.java
@@ -6,6 +6,7 @@
import com.fzzy.igds.domain.Camera;
import com.fzzy.igds.mapper.CameraMapper;
import com.fzzy.igds.utils.ContextUtil;
+import com.fzzy.igds.utils.DateUtil;
import com.ruoyi.common.core.redis.RedisCache;
import com.ruoyi.common.utils.StringUtils;
import lombok.extern.slf4j.Slf4j;
@@ -50,7 +51,7 @@
if(StringUtils.isNotBlank(param.getSpdwlx())){
queryWrapper.eq("spdwlx", param.getSpdwlx());
}
-
+ queryWrapper.orderByAsc("order_num");
cameraMapper.selectPage(page, queryWrapper);
}
@@ -73,6 +74,30 @@
}
/**
+ * 鑾峰彇鏇存柊鐩戞帶鏁伴噺
+ * @param deptId
+ * @param start
+ * @param end
+ * @return
+ */
+ public int getUpdateCount(String deptId, Date start, Date end) {
+
+ QueryWrapper<Camera> queryWrapper = new QueryWrapper<>();
+
+ if(StringUtils.isNotBlank(deptId)){
+ queryWrapper.eq("dept_id", deptId);
+ }
+ if (null != start) {
+ queryWrapper.ge("update_time", start);
+ }
+ if (null != end) {
+ queryWrapper.le("update_time", end);
+ }
+
+ return cameraMapper.selectCount(queryWrapper);
+ }
+
+ /**
* 淇濆瓨鏁版嵁
* @param data
*/
@@ -86,14 +111,31 @@
if (data.getChanNum() == 0) {
data.setChanNum(1);
}
+ data.setUpdateBy(ContextUtil.getLoginUserName());
+ data.setUpdateTime(new Date());
if(StringUtils.isEmpty(data.getId())){
data.setId(ContextUtil.generateId());
data.setCreateBy(ContextUtil.getLoginUserName());
data.setCreateTime(new Date());
+ cameraMapper.insert(data);
+ }else {
+ cameraMapper.updateById(data);
}
+ }
+
+ /**
+ * 杩滅▼鎷夊彇鐩戞帶淇℃伅鍚庢洿鏂�
+ * @param data
+ */
+ public void pullUpdateCamera(Camera data) {
data.setUpdateBy(ContextUtil.getLoginUserName());
data.setUpdateTime(new Date());
- cameraMapper.insert(data);
+ int i = cameraMapper.updateById(data);
+ if(i == 0){
+ data.setCreateBy(ContextUtil.getLoginUserName());
+ data.setCreateTime(new Date());
+ cameraMapper.insert(data);
+ }
}
/**
--
Gitblit v1.9.3