From 492bae41a21616852b8007660c679fcd37e7ea2a Mon Sep 17 00:00:00 2001
From: aijinhui <aijinhui>
Date: 星期一, 06 十一月 2023 10:16:34 +0800
Subject: [PATCH] app人员查询
---
ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java | 184 +++++++++++++++++++++++++++++++++++++++------
1 files changed, 157 insertions(+), 27 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java
index b66c268..f16e24a 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java
@@ -2,18 +2,25 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.common.core.domain.entity.SysDept;
+import com.ruoyi.sy.domain.ArdAccessFence;
import com.ruoyi.sy.domain.ArdSyCar;
import com.ruoyi.sy.domain.ArdSyCarLock;
+import com.ruoyi.sy.domain.ArdSyCarRtu;
+import com.ruoyi.sy.mapper.ArdAccessFenceMapper;
+import com.ruoyi.sy.mapper.ArdSyCarLockMapper;
import com.ruoyi.sy.mapper.ArdSyCarMapper;
+import com.ruoyi.sy.mapper.ArdSyCarRtuMapper;
import com.ruoyi.sy.service.ArdSyCarLockService;
import com.ruoyi.sy.vo.CarLockVo;
import com.ruoyi.sy.vo.CarVo;
+import com.ruoyi.sy.vo.RtuVo;
import com.ruoyi.system.mapper.SysDeptMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
+import java.util.UUID;
/**
* @author Administrator
@@ -25,13 +32,159 @@
private ArdSyCarMapper ardSyCarMapper;
@Autowired
private SysDeptMapper sysDeptMapper;
+ @Autowired
+ private ArdSyCarRtuMapper rtuMapper;
+ @Autowired
+ private ArdSyCarLockMapper lockMapper;
+
@Override
public List<CarVo> car() {
- List<CarVo> list = new ArrayList<>();
QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
- queryWrapper.isNull("reserved_1");
+ queryWrapper.isNull("reserved_1").or().eq("reserved_1","");
List<ArdSyCar> ardSyCars= ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
+ }
+
+ @Override
+ public List<CarVo> carAddOne(String carId) {
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.isNull("reserved_1").or().eq("reserved_1","").or().eq("car_id",carId);
+ List<ArdSyCar> ardSyCars= ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
+ }
+
+ @Override
+ public int addRtu(String carId) {
+ ArdSyCarRtu ardSyCarRtu = new ArdSyCarRtu();
+ ardSyCarRtu.setId(String.valueOf(UUID.randomUUID()));
+ ardSyCarRtu.setCarId(carId);
+ ardSyCarRtu.setTopicPublish("/p"+carId+"/");
+ ardSyCarRtu.setTopicSubscribe("/p"+carId+"/set/");
+ rtuMapper.insert(ardSyCarRtu);
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("car_id",carId);
+ ArdSyCar ardSyCar = ardSyCarMapper.selectOne(queryWrapper);
+ ardSyCar.setReserved1(ardSyCarRtu.getId());
+ return ardSyCarMapper.updateById(ardSyCar);
+ }
+
+ @Override
+ public List<CarVo> carList() {
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.ne("reserved_1","");
+ List<ArdSyCar> ardSyCars = ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
+ }
+
+ @Override
+ public int delCar(String id) {
+ rtuMapper.deleteById(id);
+ QueryWrapper<ArdSyCarLock> queryWrapper1 = new QueryWrapper<>();
+ queryWrapper1.eq("rtu_id",id);
+ lockMapper.delete(queryWrapper1);
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("reserved_1",id);
+ ArdSyCar ardSyCar = ardSyCarMapper.selectOne(queryWrapper);
+ ardSyCar.setReserved1("");
+ return ardSyCarMapper.updateById(ardSyCar);
+ }
+
+ @Override
+ public CarVo carOne(String carId) {
+ CarVo carVo = new CarVo();
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("car_id",carId);
+ ArdSyCar ardSyCar= ardSyCarMapper.selectOne(queryWrapper);
+ carVo.setCarId(ardSyCar.getCarId());
+ carVo.setCarPicture(ardSyCar.getCarPicture());
+ carVo.setCarType(ardSyCar.getCarType());
+ carVo.setDeptId(ardSyCar.getDeptId());
+ SysDept sysDept = sysDeptMapper.selectById(ardSyCar.getDeptId());
+ carVo.setDeptName(sysDept.getDeptName());
+ carVo.setRtu(ardSyCar.getReserved1());
+ return carVo;
+ }
+
+ @Override
+ public List<ArdSyCarLock> carLock(String rtu) {
+ QueryWrapper<ArdSyCarLock> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("rtu_id",rtu);
+ return lockMapper.selectList(queryWrapper);
+ }
+
+ @Override
+ public int addUpdLock(List<ArdSyCarLock> ardSyCarLock) {
+ int num = 0;
+ if(ardSyCarLock.size()>0){
+ String rtu = ardSyCarLock.get(0).getRtuId();
+ QueryWrapper<ArdSyCarLock> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("rtu_id",rtu);
+ lockMapper.delete(queryWrapper);
+ for (int i = 0; i < ardSyCarLock.size(); i++) {
+ ArdSyCarLock lock = ardSyCarLock.get(i);
+ if(lock.getId()==null){
+ lock.setId(String.valueOf(UUID.randomUUID()));
+ }
+ num += lockMapper.insert(lock);
+ }
+ }
+ return num;
+ }
+
+ @Override
+ public RtuVo updRtu(String carId) {
+ QueryWrapper<ArdSyCarRtu> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("car_id",carId);
+ ArdSyCarRtu ardSyCarRtu = rtuMapper.selectOne(queryWrapper);
+ RtuVo rtuVo = new RtuVo();
+ QueryWrapper<ArdSyCar> queryWrapper1 = new QueryWrapper<>();
+ queryWrapper1.eq("car_id",carId);
+ ArdSyCar ardSyCar= ardSyCarMapper.selectOne(queryWrapper1);
+ rtuVo.setCarId(ardSyCar.getCarId());
+ rtuVo.setCarPicture(ardSyCar.getCarPicture());
+ rtuVo.setCarType(ardSyCar.getCarType());
+ rtuVo.setDeptId(ardSyCar.getDeptId());
+ SysDept sysDept = sysDeptMapper.selectById(ardSyCar.getDeptId());
+ rtuVo.setDeptName(sysDept.getDeptName());
+ rtuVo.setRtu(ardSyCar.getReserved1());
+ rtuVo.setTopicPublish(ardSyCarRtu.getTopicPublish());
+ rtuVo.setTopicSubscribe(ardSyCarRtu.getTopicSubscribe());
+ return rtuVo;
+ }
+
+ @Override
+ public int updRtuCar(ArdSyCarRtu ardSyCarRtu) {
+ rtuMapper.updateById(ardSyCarRtu);
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("car_id",ardSyCarRtu.getCarId());
+ ArdSyCar ardSyCar = ardSyCarMapper.selectOne(queryWrapper);
+ ardSyCar.setReserved1(ardSyCarRtu.getId());
+ return ardSyCarMapper.updateById(ardSyCar);
+ }
+
+ @Override
+ public List<CarVo> queryCar(List<String> list) {
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.ne("reserved_1","").notIn("car_id",list);
+ List<ArdSyCar> ardSyCars = ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
+ }
+
+ @Override
+ public List<CarVo> addCarBefore(String id) {
+ QueryWrapper<ArdSyCar> ardSyCarQueryWrapper = new QueryWrapper<>();
+ ardSyCarQueryWrapper.eq("car_id",id);
+ List<ArdSyCar> carList = ardSyCarMapper.selectList(ardSyCarQueryWrapper);
+ return carAnalysis(carList);
+ }
+
+
+
+
+ //杞﹁締鍒楄〃灏佽
+ public List<CarVo> carAnalysis(List<ArdSyCar> ardSyCars){
+ List<CarVo> list = new ArrayList<>();
for (int i = 0; i < ardSyCars.size(); i++) {
ArdSyCar ardSyCar = ardSyCars.get(i);
CarVo carVo = new CarVo();
@@ -41,34 +194,11 @@
carVo.setDeptId(ardSyCar.getDeptId());
SysDept sysDept = sysDeptMapper.selectById(ardSyCar.getDeptId());
carVo.setDeptName(sysDept.getDeptName());
+ carVo.setRtu(ardSyCar.getReserved1());
+ carVo.setCarModel(ardSyCar.getCarModel());
list.add(carVo);
}
return list;
- }
-
- @Override
- public int addRtu(String carId) {
- return 0;
- }
-
- @Override
- public List<CarVo> carList() {
- return null;
- }
-
- @Override
- public int delCar(String CarId) {
- return 0;
- }
-
- @Override
- public List<CarLockVo> carLock(String carId) {
- return null;
- }
-
- @Override
- public int addUpdLock(List<ArdSyCarLock> ardSyCarLock) {
- return 0;
}
}
--
Gitblit v1.9.3