package com.doumee.service.business.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Constants;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.DevicesMapper;
import com.doumee.dao.business.join.DevicesJoinMapper;
import com.doumee.dao.business.model.Devices;
import com.doumee.dao.business.model.Rooms;
import com.doumee.service.business.DevicesService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.Date;
import java.util.List;
import java.util.Objects;

/**
 * 设备管理信息表Service实现
 * @author 江蹄蹄
 * @date 2023/05/04 18:18
 */
@Service
public class DevicesServiceImpl implements DevicesService {

    @Autowired
    private DevicesMapper devicesMapper;

    @Autowired
    private DevicesJoinMapper devicesJoinMapper;

    @Override
    public Integer create(Devices devices) {

        LambdaQueryWrapper<Devices> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(Devices::getCode,devices.getCode());
        Devices devices1 = devicesMapper.selectOne(wrapper);
        if (Objects.nonNull(devices1)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"设备已经存在，请重新输入");
        }
        Devices insert = new Devices();
        insert.setCreator(devices.getCreator());
        insert.setEditor(devices.getEditor());
        insert.setName(devices.getName());
        insert.setCode(devices.getCode());
        insert.setRoomId(devices.getRoomId());
        insert.setStatus(Constants.ZERO);
        devicesMapper.insert(insert);
        return devices.getId();
    }

    @Override
    public void deleteById(Integer id) {
        devicesMapper.deleteById(id);
    }

    @Override
    public void delete(Devices devices) {
        UpdateWrapper<Devices> deleteWrapper = new UpdateWrapper<>(devices);
        devicesMapper.delete(deleteWrapper);
    }

    @Override
    public void deleteByIdInBatch(List<Integer> ids) {
        if (CollectionUtils.isEmpty(ids)) {
            return;
        }
        devicesMapper.deleteBatchIds(ids);
    }

    @Override
    public void updateById(Devices devices) {

        LambdaQueryWrapper<Devices> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(Devices::getId,devices.getId());
        Devices devices1 = devicesMapper.selectOne(wrapper);
        if (Objects.isNull(devices1)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"设备不存在，请重新输入");
        }
        wrapper.clear();
        wrapper.eq(Devices::getCode,devices.getCode()).last("limit 1");
        Devices devices2 = devicesMapper.selectOne(wrapper);
        if (Objects.nonNull(devices2) && !devices2.getId().equals(devices.getId())){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"设备已经存在，请重新输入");
        }
        Devices update = new Devices();
        update.setId(devices.getId());
        update.setEditor(devices.getEditor());
        update.setEditDate(new Date());
        update.setName(devices.getName());
        update.setCode(devices.getCode());
        update.setRoomId(devices.getRoomId());
        update.setStatus(devices.getStatus());
        devicesMapper.updateById(update);
    }
    @Override
    public  void doHeartDeal(String devicenumber){
        if(StringUtils.isBlank(devicenumber)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"设备信息不能为空");
        }
        Devices update = new Devices();
        update.setCode(devicenumber);
        update.setIsdeleted(Constants.ZERO);
        Devices devices1 = devicesMapper.selectOne(new QueryWrapper<>(update).last(" limit 1"));
        if (Objects.isNull(devices1)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"设备不存在，请重新输入");
        }
        update.setId(devices1.getId());
        update.setHeartTime(new Date());
        devicesMapper.updateById(update);
    }

    @Override
    public void updateByIdInBatch(List<Devices> devicess) {
        if (CollectionUtils.isEmpty(devicess)) {
            return;
        }
        for (Devices devices: devicess) {
            this.updateById(devices);
        }
    }

    @Override
    public Devices findById(Integer id) {
        return devicesMapper.selectById(id);
    }

    @Override
    public Devices findOne(Devices devices) {
        QueryWrapper<Devices> wrapper = new QueryWrapper<>(devices);
        return devicesMapper.selectOne(wrapper.last(" limit 1"));
    }

    @Override
    public List<Devices> findList(Devices devices) {
        QueryWrapper<Devices> wrapper = new QueryWrapper<>(devices);
        return devicesMapper.selectList(wrapper);
    }
  
    @Override
    public PageData<Devices> findPage(PageWrap<Devices> pageWrap) {
        IPage<Devices> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());

        MPJLambdaWrapper<Devices> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        queryWrapper.selectAll(Devices.class)
                    .selectAs(Rooms::getName,Devices::getRoomName)
                    .leftJoin(Rooms.class,Rooms::getId,Devices::getRoomId);

        if (pageWrap.getModel().getId() != null) {
            queryWrapper.eq(Devices::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getCreator() != null) {
            queryWrapper.eq(Devices::getCreator, pageWrap.getModel().getCreator());
        }
        if (pageWrap.getModel().getCreateDate() != null) {
            queryWrapper.ge(Devices::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
            queryWrapper.le(Devices::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
        }
        if (pageWrap.getModel().getEditor() != null) {
            queryWrapper.eq(Devices::getEditor, pageWrap.getModel().getEditor());
        }
        if (pageWrap.getModel().getEditDate() != null) {
            queryWrapper.ge(Devices::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
            queryWrapper.le(Devices::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
        }
        if (pageWrap.getModel().getIsdeleted() != null) {
            queryWrapper.eq(Devices::getIsdeleted, pageWrap.getModel().getIsdeleted());
        }
        if (pageWrap.getModel().getRemark() != null) {
            queryWrapper.eq(Devices::getRemark, pageWrap.getModel().getRemark());
        }
        if (pageWrap.getModel().getName() != null) {
            queryWrapper.eq(Devices::getName, pageWrap.getModel().getName());
        }
        if (pageWrap.getModel().getCode() != null) {
            queryWrapper.eq(Devices::getCode, pageWrap.getModel().getCode());
        }
        if (pageWrap.getModel().getRoomId() != null) {
            queryWrapper.eq(Devices::getRoomId, pageWrap.getModel().getRoomId());
        }
        if (pageWrap.getModel().getStatus() != null) {
            queryWrapper.eq(Devices::getStatus, pageWrap.getModel().getStatus());
        }
        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
                queryWrapper.orderByDesc(sortData.getProperty());
            } else {
                queryWrapper.orderByAsc(sortData.getProperty());
            }
        }
        return PageData.from(devicesJoinMapper.selectJoinPage(page, Devices.class,queryWrapper));
    }

    @Override
    public long count(Devices devices) {
        QueryWrapper<Devices> wrapper = new QueryWrapper<>(devices);
        return devicesMapper.selectCount(wrapper);
    }
}