package doumeemes.service.system.impl;

import doumeemes.core.model.PageData;
import doumeemes.core.model.PageWrap;
import doumeemes.core.utils.Utils;
import doumeemes.dao.system.SystemUserExternalMapper;
import doumeemes.dao.system.model.SystemUserExternal;
import doumeemes.service.system.SystemUserExternalService;
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 org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.List;

/**
 * 系统-用户外部系统账号关联表Service实现
 * @author 江蹄蹄
 * @date 2022/04/20 11:17
 */
@Service
public class SystemUserExternalServiceImpl implements SystemUserExternalService {

    @Autowired
    private SystemUserExternalMapper systemUserExternalMapper;

    @Override
    public Integer create(SystemUserExternal systemUserExternal) {
        systemUserExternalMapper.insert(systemUserExternal);
        return systemUserExternal.getId();
    }

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

    @Override
    public void delete(SystemUserExternal systemUserExternal) {
        UpdateWrapper<SystemUserExternal> deleteWrapper = new UpdateWrapper<>(systemUserExternal);
        systemUserExternalMapper.delete(deleteWrapper);
    }

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

    @Override
    public void updateById(SystemUserExternal systemUserExternal) {
        systemUserExternalMapper.updateById(systemUserExternal);
    }

    @Override
    public void updateByIdInBatch(List<SystemUserExternal> systemUserExternals) {
        if (CollectionUtils.isEmpty(systemUserExternals)) {
            return;
        }
        for (SystemUserExternal systemUserExternal: systemUserExternals) {
            this.updateById(systemUserExternal);
        }
    }

    @Override
    public SystemUserExternal findById(Integer id) {
        return systemUserExternalMapper.selectById(id);
    }

    @Override
    public SystemUserExternal findOne(SystemUserExternal systemUserExternal) {
        QueryWrapper<SystemUserExternal> wrapper = new QueryWrapper<>(systemUserExternal);
        return systemUserExternalMapper.selectOne(wrapper);
    }

    @Override
    public List<SystemUserExternal> findList(SystemUserExternal systemUserExternal) {
        QueryWrapper<SystemUserExternal> wrapper = new QueryWrapper<>(systemUserExternal);
        return systemUserExternalMapper.selectList(wrapper);
    }
  
    @Override
    public PageData<SystemUserExternal> findPage(PageWrap<SystemUserExternal> pageWrap) {
        IPage<SystemUserExternal> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        QueryWrapper<SystemUserExternal> queryWrapper = new QueryWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        if (pageWrap.getModel().getId() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getDeleted() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getDeleted, pageWrap.getModel().getDeleted());
        }
        if (pageWrap.getModel().getCreateUser() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getCreateUser, pageWrap.getModel().getCreateUser());
        }
        if (pageWrap.getModel().getCreateTime() != null) {
            queryWrapper.lambda().ge(SystemUserExternal::getCreateTime, Utils.Date.getStart(pageWrap.getModel().getCreateTime()));
            queryWrapper.lambda().le(SystemUserExternal::getCreateTime, Utils.Date.getEnd(pageWrap.getModel().getCreateTime()));
        }
        if (pageWrap.getModel().getUpdateUser() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getUpdateUser, pageWrap.getModel().getUpdateUser());
        }
        if (pageWrap.getModel().getUpdateTime() != null) {
            queryWrapper.lambda().ge(SystemUserExternal::getUpdateTime, Utils.Date.getStart(pageWrap.getModel().getUpdateTime()));
            queryWrapper.lambda().le(SystemUserExternal::getUpdateTime, Utils.Date.getEnd(pageWrap.getModel().getUpdateTime()));
        }
        if (pageWrap.getModel().getUserId() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getUserId, pageWrap.getModel().getUserId());
        }
        if (pageWrap.getModel().getSystemId() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getSystemId, pageWrap.getModel().getSystemId());
        }
        if (pageWrap.getModel().getAccountId() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getAccountId, pageWrap.getModel().getAccountId());
        }
        if (pageWrap.getModel().getDetails() != null) {
            queryWrapper.lambda().eq(SystemUserExternal::getDetails, pageWrap.getModel().getDetails());
        }
        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
                queryWrapper.orderByDesc(sortData.getProperty());
            } else {
                queryWrapper.orderByAsc(sortData.getProperty());
            }
        }
        return PageData.from(systemUserExternalMapper.selectPage(page, queryWrapper));
    }

    @Override
    public long count(SystemUserExternal systemUserExternal) {
        QueryWrapper<SystemUserExternal> wrapper = new QueryWrapper<>(systemUserExternal);
        return systemUserExternalMapper.selectCount(wrapper);
    }
}