From 9dbd1b03adca3920a249b9079153d5f53d01a47d Mon Sep 17 00:00:00 2001
From: aijinhui <aijinhui>
Date: 星期三, 01 十一月 2023 15:25:03 +0800
Subject: [PATCH] 清淤数据逻辑
---
ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdSyCarLockServiceImpl.java | 168 +++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 159 insertions(+), 9 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 055a6f3..9b0600d 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
@@ -1,42 +1,192 @@
package com.ruoyi.sy.service.impl;
+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
+ */
@Service
public class ArdSyCarLockServiceImpl implements ArdSyCarLockService {
+
+ @Autowired
+ private ArdSyCarMapper ardSyCarMapper;
+ @Autowired
+ private SysDeptMapper sysDeptMapper;
+ @Autowired
+ private ArdSyCarRtuMapper rtuMapper;
+ @Autowired
+ private ArdSyCarLockMapper lockMapper;
+
+
@Override
public List<CarVo> car() {
- return null;
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ 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) {
- return 0;
+ 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() {
- return null;
+ QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
+ queryWrapper.ne("reserved_1","");
+ List<ArdSyCar> ardSyCars = ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
}
@Override
- public int delCar(String CarId) {
- return 0;
+ 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 List<CarLockVo> carLock(String carId) {
- return null;
+ 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 int addUpdLock(ArdSyCarLock ardSyCarLock) {
- return 0;
+ 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","").ne("car_id",list);
+ List<ArdSyCar> ardSyCars = ardSyCarMapper.selectList(queryWrapper);
+ return carAnalysis(ardSyCars);
+ }
+
+
+ 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();
+ 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());
+ list.add(carVo);
+ }
+ return list;
+ }
+
}
--
Gitblit v1.9.3