package com.doumee.service.business.impl;

import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.RoomRecordMapper;
import com.doumee.dao.business.join.RoomRecordJoinMapper;
import com.doumee.dao.business.model.Bookings;
import com.doumee.dao.business.model.Devices;
import com.doumee.dao.business.model.RoomRecord;
import com.doumee.dao.business.model.Rooms;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.service.business.RoomRecordService;
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.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.List;

/**
 * 会议室开门记录表Service实现
 * @author 江蹄蹄
 * @date 2023/05/05 18:25
 */
@Service
public class RoomRecordServiceImpl implements RoomRecordService {

    @Autowired
    private RoomRecordMapper roomRecordMapper;
    @Autowired
    private RoomRecordJoinMapper roomRecordJoinMapper;

    @Override
    public Integer create(RoomRecord roomRecord) {
        roomRecordMapper.insert(roomRecord);
        return roomRecord.getId();
    }

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

    @Override
    public void delete(RoomRecord roomRecord) {
        UpdateWrapper<RoomRecord> deleteWrapper = new UpdateWrapper<>(roomRecord);
        roomRecordMapper.delete(deleteWrapper);
    }

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

    @Override
    public void updateById(RoomRecord roomRecord) {
        roomRecordMapper.updateById(roomRecord);
    }

    @Override
    public void updateByIdInBatch(List<RoomRecord> roomRecords) {
        if (CollectionUtils.isEmpty(roomRecords)) {
            return;
        }
        for (RoomRecord roomRecord: roomRecords) {
            this.updateById(roomRecord);
        }
    }

    @Override
    public RoomRecord findById(Integer id) {
        return roomRecordMapper.selectById(id);
    }

    @Override
    public RoomRecord findOne(RoomRecord roomRecord) {
        QueryWrapper<RoomRecord> wrapper = new QueryWrapper<>(roomRecord);
        return roomRecordMapper.selectOne(wrapper);
    }

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

        MPJLambdaWrapper<RoomRecord> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        queryWrapper.selectAll(RoomRecord.class)
                .selectAs(Rooms::getName,RoomRecord::getRoomName)
                .selectAs(SystemUser::getRealname,RoomRecord::getUserName)
                .selectAs(Bookings::getName,RoomRecord::getMeeting)
                .leftJoin(Rooms.class,Rooms::getId,RoomRecord::getRoomId)
                .leftJoin(Bookings.class,Bookings::getId,RoomRecord::getObjId)
                .leftJoin(SystemUser.class,SystemUser::getId,RoomRecord::getUserId);

        queryWrapper.like(pageWrap.getModel().getUserName() != null,SystemUser::getRealname, pageWrap.getModel().getUserName());
        queryWrapper.like(pageWrap.getModel().getRoomId() != null,Rooms::getId, pageWrap.getModel().getRoomId());
        queryWrapper.like(pageWrap.getModel().getMeeting() != null,Bookings::getName, pageWrap.getModel().getMeeting());
        queryWrapper.like(pageWrap.getModel().getObjType() != null,RoomRecord::getObjType, pageWrap.getModel().getObjType());
        if (pageWrap.getModel().getStartDate() != null) {
            queryWrapper.ge(RoomRecord::getCreateDate, pageWrap.getModel().getStartDate());
        }

        if (pageWrap.getModel().getEndDate() != null) {
            queryWrapper.le(RoomRecord::getCreateDate, pageWrap.getModel().getEndDate());
        }
        queryWrapper.orderByDesc(RoomRecord::getCreateDate);
        return PageData.from(roomRecordJoinMapper.selectJoinPage(page, RoomRecord.class,queryWrapper));
    }

    @Override
    public long count(RoomRecord roomRecord) {
        QueryWrapper<RoomRecord> wrapper = new QueryWrapper<>(roomRecord);
        return roomRecordMapper.selectCount(wrapper);
    }
}