From 6fb2c7199bf50c524cdf0b8d3ec8b2644eb116d8 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期一, 24 三月 2025 17:06:25 +0800
Subject: [PATCH] 查询锁的蓝牙开启时间段记录
---
src/main/java/com/whyc/service/LockBlService.java | 34 +++++++++++++++++++---------------
1 files changed, 19 insertions(+), 15 deletions(-)
diff --git a/src/main/java/com/whyc/service/LockBlService.java b/src/main/java/com/whyc/service/LockBlService.java
index 9f1fa6a..0823877 100644
--- a/src/main/java/com/whyc/service/LockBlService.java
+++ b/src/main/java/com/whyc/service/LockBlService.java
@@ -2,13 +2,17 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.LockBlMapper;
import com.whyc.pojo.db_area.LockBl;
+import com.whyc.pojo.db_area.LockInf;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -17,26 +21,26 @@
@Autowired(required = false)
private LockBlMapper mapper;
+ @Autowired(required = false)
+ private AreaInfService areaInfService;
+
//璁惧畾閿佺殑钃濈墮寮�鍚椂闂存
public Response setLockBl( List<LockBl> list) {
for (LockBl lockBl : list) {
lockBl.setCreateTime(new Date());
- //鍒ゆ柇鏄惁瀛樺湪锛氬瓨鍦ㄤ慨鏀癸紝涓嶅瓨鍦ㄦ坊鍔�
- QueryWrapper wrapper = new QueryWrapper();
- wrapper.eq("lock_id", lockBl.getLockId());
- wrapper.last("limit 1");
- LockBl bl = mapper.selectOne(wrapper);
- if (bl == null) {
- mapper.insert(lockBl);
- } else {
- UpdateWrapper wrapper1=new UpdateWrapper();
- wrapper1.set("start_time",lockBl.getStartTime());
- wrapper1.set("stop_time",lockBl.getStopTime());
- wrapper1.set("create_time",new Date());
- wrapper1.eq("lock_id",lockBl.getLockId());
- mapper.update((LockBl) ActionUtil.objeNull,wrapper1);
- }
+ lockBl.setType(1);//榛樿寮�鍚�
+ mapper.insert(lockBl);
}
return new Response().set(1,true,"璁惧畾閿佺殑钃濈墮寮�鍚椂闂存");
}
+ //鏌ヨ閿佺殑钃濈墮寮�鍚椂闂存璁板綍
+ public Response getLockBl(Integer areaId, String lockName, Integer type, Integer pageNum, Integer pageSize) {
+ List<Integer> areaList=new ArrayList();
+ areaList.add(areaId);
+ areaInfService.getAllAreaId(areaId,areaList);
+ PageHelper.startPage(pageNum,pageSize);
+ List<LockBl> list=mapper.getLockBl(lockName,type,areaList);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list!=null,pageInfo,"鏌ヨ閿佺殑钃濈墮寮�鍚椂闂存璁板綍");
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1