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 | 67 +++++++++++++++++++++++++++++++++ 1 files changed, 67 insertions(+), 0 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 cc3f651..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,15 +2,18 @@ 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; @@ -34,10 +37,19 @@ @Autowired private ArdSyCarLockMapper lockMapper; + @Override public List<CarVo> car() { 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); } @@ -68,6 +80,9 @@ @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); @@ -117,6 +132,57 @@ 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++) { @@ -129,6 +195,7 @@ SysDept sysDept = sysDeptMapper.selectById(ardSyCar.getDeptId()); carVo.setDeptName(sysDept.getDeptName()); carVo.setRtu(ardSyCar.getReserved1()); + carVo.setCarModel(ardSyCar.getCarModel()); list.add(carVo); } return list; -- Gitblit v1.9.3