app人员查询

aijinhui

2023-11-06 492bae41a21616852b8007660c679fcd37e7ea2a

 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;