package com.ruoyi.sy.service.impl;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.sy.domain.ArdSyCar;
import com.ruoyi.sy.domain.ArdSyCarLock;
import com.ruoyi.sy.domain.ArdSyCarRtu;
import com.ruoyi.sy.mapper.ArdSyCarLockMapper;
import com.ruoyi.sy.mapper.ArdSyCarMapper;
import com.ruoyi.sy.mapper.ArdSyCarRtuMapper;
import com.ruoyi.sy.param.AddRtuParam;
import com.ruoyi.sy.param.LockTypeParam;
import com.ruoyi.sy.service.ArdSyCarLockService;
import com.ruoyi.sy.vo.CarVo;
import com.ruoyi.sy.vo.RtuVo;
import com.ruoyi.system.mapper.SysDeptMapper;
import com.ruoyi.utils.mqtt.MqttOnce;
import lombok.extern.slf4j.Slf4j;
import org.eclipse.paho.client.mqttv3.MqttException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.text.DecimalFormat;
import java.util.*;

/**
 * @author Administrator
 */
@Slf4j
@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() {
        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(AddRtuParam addRtuParam) {
        ArdSyCarRtu ardSyCarRtu = new ArdSyCarRtu();
        ardSyCarRtu.setId(String.valueOf(UUID.randomUUID()));
        ardSyCarRtu.setCarId(addRtuParam.getCarId());
        ardSyCarRtu.setTopicPublish("/p"+addRtuParam.getCarId()+"/");
        ardSyCarRtu.setTopicSubscribe("/p"+addRtuParam.getCarId()+"/set/");
        ardSyCarRtu.setInstallType(addRtuParam.getInstallType());
        ardSyCarRtu.setUnloadType(addRtuParam.getUnloadType());
        int num = rtuMapper.insert(ardSyCarRtu);
        QueryWrapper<ArdSyCar> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("car_id",addRtuParam.getCarId());
        ArdSyCar ardSyCar = ardSyCarMapper.selectOne(queryWrapper);
        ardSyCar.setReserved1(ardSyCarRtu.getId());
        ardSyCarMapper.updateById(ardSyCar);
        MqttOnce mqttOnce = new MqttOnce();
        mqttOnce.subscribeCar(ardSyCarRtu);
        return num;
    }

    @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) {
//        List<ArdSyCarLock> locks = new ArrayList<>();
//        try {
//            QueryWrapper<ArdSyCarLock> queryWrapper = new QueryWrapper<>();
//            queryWrapper.eq("rtu_id",rtu);
//            locks = lockMapper.selectList(queryWrapper);
//        }catch (Exception e){
//
//        }
        return lockMapper.lockList(rtu);
    }

    @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);
    }

    @Override
    public List<ArdSyCarLock> data(String msg) {
        String pattern = "0.00"; // 指定保留两位小数的格式
        DecimalFormat decimalFormat = new DecimalFormat(pattern); //
        JSONObject jsonObject = JSONObject.parseObject(msg);
        List<ArdSyCarLock> lockList = new ArrayList<>();
        ArdSyCarLock ardSyCarLock1 = new ArdSyCarLock();
        ardSyCarLock1.setRelay("A01");
        ardSyCarLock1.setRelayInfo(String.valueOf(jsonObject.getInteger("A01")));
        ardSyCarLock1.setCurrents("C01");
        ardSyCarLock1.setCurrentInfo(decimalFormat.format(jsonObject.getDouble("C01")));
        lockList.add(ardSyCarLock1);
        ArdSyCarLock ardSyCarLock2 = new ArdSyCarLock();
        ardSyCarLock2.setRelay("A02");
        ardSyCarLock2.setRelayInfo(String.valueOf(jsonObject.getInteger("A02")));
        ardSyCarLock2.setCurrents("C02");
        ardSyCarLock2.setCurrentInfo(decimalFormat.format(jsonObject.getDouble("C02")));
        lockList.add(ardSyCarLock2);
        return lockList;
    }

    @Override
    public int updLock(ArdSyCarLock ardSyCarLock) {
        return lockMapper.updateById(ardSyCarLock);
    }

    @Override
    public ArdSyCarLock getCurrentInfo(String Rtu, String currents) {
        QueryWrapper<ArdSyCarLock> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("rtu_id",Rtu).eq("currents",currents);
        return lockMapper.selectOne(queryWrapper);
    }

    @Override
    public AjaxResult seal(LockTypeParam lockTypeParam) {
        QueryWrapper<ArdSyCarRtu> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("carId",lockTypeParam.getCarId());
        ArdSyCarRtu ardSyCarRtu = rtuMapper.selectOne(queryWrapper);
        MqttOnce mqttOnce = new MqttOnce();
        //1解封
        if(lockTypeParam.getType()==1){
            Map<String,Object> map = new HashMap<>();
            map.put("A01", 110000);//导通第一路继电器
            map.put("A02", 110000);//导通第二路继电器
            map.put("res", String.valueOf(System.currentTimeMillis()));
            try {
                return AjaxResult.success(mqttOnce.publishCar(lockTypeParam.getCarId(),ardSyCarRtu.getTopicPublish(),String.valueOf(new com.alibaba.fastjson2.JSONObject(map)),"解封"));
            } catch (MqttException e) {
                log.debug("解封指令发生失败"+e);
            }
        }
        //0施封
        if(lockTypeParam.getType()==0){
            //锁开关状态
            int lockCloseNum = 0;
            //查询锁信息
            List<ArdSyCarLock> ardSyCarLocks = carLock(ardSyCarRtu.getId());
            for (int j = 0; j < ardSyCarLocks.size(); j++) {
                ArdSyCarLock ardSyCarLock = ardSyCarLocks.get(j);
                String currents = ardSyCarLock.getCurrents();
                String currentInfo = ardSyCarLock.getCurrentInfo();
                //电流值为4.0是关锁状态
                if(currentInfo.equals(4.00)){
                    lockCloseNum += 1;
                }else {
                    String key = "";
                    if(currents.equals("C01")){
                        key = "D03";
                    }else if(currents.equals("C02")){
                        key = "D04";
                    }
                    Map<String,Object> map = new HashMap();
                    map.put(key, 0.01);
                    map.put("res", String.valueOf(System.currentTimeMillis()));
                    try {
                        mqttOnce.publishCar("carId",ardSyCarRtu.getTopicPublish(),String.valueOf(new com.alibaba.fastjson2.JSONObject(map)),"开锁："+currents);
                    } catch (MqttException e) {
                        log.debug("开锁指令发生失败"+e);
                    }
                    while(true){
                        ArdSyCarLock ardSyCarLock1 = getCurrentInfo(ardSyCarRtu.getId(),currents);
                        String currentInfo1 = ardSyCarLock1.getCurrentInfo();
                        if(currentInfo1.equals(4.00)){
                            lockCloseNum +=1;
                            break;
                        }
                    }
                }
            }
            if(lockCloseNum == 2){
                Map<String,Object> map = new HashMap<>();
                map.put("A01", 100000);//断开第一路继电器
                map.put("A02", 100000);//断开第二路继电器
                map.put("res", String.valueOf(System.currentTimeMillis()));
                try {
                    return AjaxResult.success(mqttOnce.publishCar(lockTypeParam.getCarId(),ardSyCarRtu.getTopicPublish(),String.valueOf(new com.alibaba.fastjson2.JSONObject(map)),"施封"));
                } catch (MqttException e) {
                    log.debug("施封指令发生失败"+e);
                }
            }
        }
        return AjaxResult.success();
    }

    @Override
    public AjaxResult onOff(LockTypeParam lockTypeParam) {
        QueryWrapper<ArdSyCarRtu> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("car_id",lockTypeParam.getCarId());
        ArdSyCarRtu ardSyCarRtu = rtuMapper.selectOne(queryWrapper);
        ArdSyCarLock ardSyCarLock = lockMapper.selectById(lockTypeParam.getLockId());
        String relay = ardSyCarLock.getRelayInfo();
        if(relay.equals("1")){
            AjaxResult.error(0,"该锁处于解封状态,远程无法操控,请先执行施封操作!");
        }
        String key = "";
        String currentInfo = ardSyCarLock.getCurrentInfo();
        if(currentInfo.equals("C01")){
            key = "D03";
        }else if(currentInfo.equals("C02")){
            key = "D04";
        }
        Number lockState = (Number) lockTypeParam.getNum();
        if(lockState.equals(100)){
            lockState = 99.99;
        }else if(lockState.equals(0)){
            lockState = 0.01;
        }else{
            lockState = lockState.doubleValue() + 0.01;
        }
        Map<String,Object> map = new HashMap();
        map.put(key, lockState);//范围是0.01到99.99
        map.put("res", String.valueOf(System.currentTimeMillis()));
        MqttOnce mqttOnce = new MqttOnce();
        try {
            return AjaxResult.success(mqttOnce.publishCar("carId",ardSyCarRtu.getTopicPublish(),String.valueOf(new com.alibaba.fastjson2.JSONObject(map)),"开关锁指令"+lockState));
        } catch (MqttException e) {
            log.debug("开关锁指令发送失败"+e);
        }
        return AjaxResult.success();
    }

    @Override
    public List<ArdSyCarLock> lockIng(String carId) {
        QueryWrapper<ArdSyCarRtu> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("car_id",carId);
        ArdSyCarRtu ardSyCarRtu = rtuMapper.selectOne(queryWrapper);
        return lockMapper.lockList(ardSyCarRtu.getId());
    }


    //车辆列表封装
    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());
            carVo.setCarModel(ardSyCar.getCarModel());
            list.add(carVo);
        }
        return list;
    }

}