package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.*;
import com.whyc.pojo.db_batt.PowerInf;
import com.whyc.pojo.db_batt.StationInf;
import com.whyc.pojo.db_batt.StationPowerRelation;
import com.whyc.pojo.db_power_alarm.PowerAlarm;
import com.whyc.pojo.db_real_batt.RtData;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
public class PowerInfService {
    @Autowired(required = false)
    private PowerInfMapper mapper;

    @Autowired(required = false)
    private RtDataMapper rtDataMapper;

    @Autowired(required = false)
    private PowerRealRt1Mapper realRt1Mapper;

    @Autowired(required = false)
    private PowerRealRt2Mapper realRt2Mapper;

    @Autowired(required = false)
    private PowerRealRt3Mapper realRt3Mapper;

    @Autowired(required = false)
    private PowerAlarmMapper pAlarmMapper;

    @Autowired
    private StationPowerRelationService stationPowerRelationService;

    @Autowired
    private StationInfService stationInfService;

    //根据id获取电源信息
    public  Map<String,Object> getInfById(int powerId) {
        Map<String,Object> map=new HashMap<>();
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("power_id",powerId);
        wrapper.last("limit 1");
        PowerInf pinf=mapper.selectOne(wrapper);
        Integer devType=pinf.getDevType();
        map.put("devType",devType);
        if(devType!=3){//第三种不包含单体实时
            List<RtData> list=getBattRt(pinf.getBattGroupId());
            map.put("battRt",list);
        }
        Object obj=getRealRt(powerId,devType);
        map.put("realRt"+devType,obj);

        List<PowerAlarm> powerAlarmList=pAlarmMapper.getResPowerAlm(powerId);
        map.put("powerAlarm",powerAlarmList);
        return map;
    }
    //获取电电源信息
    private Object getRealRt(int powerId,int devType) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("power_id",powerId);
        wrapper.last("limit 1");
        Object obj=null;
        if(devType==1){
            obj=realRt1Mapper.selectOne(wrapper);
        }
        if(devType==2){
            obj=realRt2Mapper.selectOne(wrapper);
        }
        if(devType==3){
            obj=realRt3Mapper.selectOne(wrapper);
        }
        return obj;
    }

    //获取电源电池组信息
    private List<RtData> getBattRt(int binfId) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("binf_id",binfId);
        List<RtData> list=rtDataMapper.selectList(wrapper);
        return list;
    }

    @Transactional
    public Response add(PowerInf powerInf) {
        powerInf.setCreateTime(new Date());
        //对powerInf的 devType进行判断
        //如果devType=3,battGroupId为0
        //如果devType!=3,battGroupId为数据库中最大值+1
        Integer devType = powerInf.getDevType();
        if(devType == 3){
            powerInf.setBattGroupId(0);
        }else{
            powerInf.setBattGroupId(mapper.selectMaxBattGroupId()+1);
        }
        //如果没指定channelCount,默认为1
        if(powerInf.getChannelCount() == null){
            powerInf.setChannelCount(1);
        }
        mapper.insert(powerInf);

        //电源id获取
        int powerId = powerInf.getPowerId();
        //对站点名称进行查询,如果存在则直接绑定关系
        //如果不存在,则新增后,再绑定关系
        StationInf stationInf = stationInfService.getByStationName(powerInf.getStationName());
        Integer stationId = stationInf.getSinfId();
        if(stationInf == null) {
            StationInf stationNew = new StationInf();
            stationNew.setSinfName(powerInf.getStationName());
            int stationIdInDB = stationInfService.getMaxStationId();
            stationId = stationIdInDB + 1;
            stationNew.setSinfId(stationId);
            stationInfService.add(stationNew);
        }
        //站点和电源id关联
        stationPowerRelationService.add(stationId,powerId);
        return new Response().setII(1,"新增完成");
    }

    @Transactional
    public Response delete(int powerId) {
        mapper.deleteById(powerId);
        //删除跟电源相关的所有关联
        stationPowerRelationService.deleteByPowerId(powerId);
        return new Response().setII(1,"删除完成");
    }

    public Response update(PowerInf powerInf) {
        powerInf.setUpdateTime(new Date());
        mapper.updateById(powerInf);
        return new Response().setII(1,"修改完成");
    }

    public Response getPage(int pageNum, int pageSize) {
        PageHelper helper = new PageHelper();
        helper.startPage(pageNum,pageSize);
        /*QueryWrapper<PowerInf> queryWrapper = Wrappers.query();
        queryWrapper.orderByAsc("power_id");

        List<PowerInf> powerInfs = mapper.selectList(queryWrapper);*/
        List<PowerInf> powerInfs = mapper.getList();
        PageInfo<PowerInf> pageInfo = new PageInfo<>(powerInfs);
        return new Response().set(1,pageInfo);

    }

    public Response getById(int powerId) {
        //PowerInf powerInf = mapper.selectById(powerId);
        PowerInf powerInf = mapper.getById(powerId);
        return new Response().set(1,powerInf);
    }

    public Response getProducerList() {
        List<String> producerList = mapper.getProducerList();
        return new Response().set(1,producerList);
    }

    public PowerInf getByBattGroupId(Integer battGroupId) {
        QueryWrapper<PowerInf> query = Wrappers.query();
        query.eq("binf_id",battGroupId);
        query.last(" limit 1");
        return mapper.selectOne(query);
    }
}