package com.doumee.service.business.impl;

import com.doumee.biz.system.SystemDictDataBiz;
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.ProjectScoreMapper;
import com.doumee.dao.business.model.ProjectScore;
import com.doumee.service.business.ProjectScoreService;
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;
import java.util.Objects;

/**
 * 项目角色评分设置表Service实现
 * @author 江蹄蹄
 * @date 2023/05/29 10:50
 */
@Service
public class ProjectScoreServiceImpl implements ProjectScoreService {

    @Autowired
    private ProjectScoreMapper projectScoreMapper;

    @Autowired
    private SystemDictDataBiz systemDictDataBiz;


    @Override
    public Integer create(ProjectScore projectScore) {
        QueryWrapper<ProjectScore> wrapper = new QueryWrapper<>();
        wrapper.lambda().eq(ProjectScore::getProjectId,projectScore.getProjectId())
                        .eq(ProjectScore::getRoleType,projectScore.getRoleType());

        ProjectScore projectScore1 = projectScoreMapper.selectOne(wrapper.last("limit 1"));

        if (!Objects.isNull(projectScore1)){
            throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"评分配置已经存在");
        }
        projectScore.setStatus(Constants.ONE);
        projectScoreMapper.insert(projectScore);
        return projectScore.getId();
    }

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

    @Override
    public void delete(ProjectScore projectScore) {
        UpdateWrapper<ProjectScore> deleteWrapper = new UpdateWrapper<>(projectScore);
        projectScoreMapper.delete(deleteWrapper);
    }

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

    @Override
    public void updateById(ProjectScore projectScore) {
        projectScoreMapper.updateById(projectScore);
    }

    @Override
    public void updateByIdInBatch(List<ProjectScore> projectScores) {
        if (CollectionUtils.isEmpty(projectScores)) {
            return;
        }
        for (ProjectScore projectScore: projectScores) {
            this.updateById(projectScore);
        }
    }

    @Override
    public ProjectScore findById(Integer id) {
        return projectScoreMapper.selectById(id);
    }

    @Override
    public ProjectScore findOne(ProjectScore projectScore) {
        QueryWrapper<ProjectScore> wrapper = new QueryWrapper<>(projectScore);
        return projectScoreMapper.selectOne(wrapper.last("limit 1"));
    }

    @Override
    public List<ProjectScore> findList(ProjectScore projectScore) {
        QueryWrapper<ProjectScore> wrapper = new QueryWrapper<>(projectScore);
        wrapper.select("*,(select REALNAME from system_user su where su.id = EDITOR) as editorRealName ");
        List<ProjectScore> projectScores = projectScoreMapper.selectList(wrapper);
        String path =systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode();
        String projectFile = systemDictDataBiz.queryByCode(Constants.OSS, Constants.PROJECT_FILE).getCode();
        projectScores.forEach(s->{
            s.setFileUrl(path+projectFile+s.getFileUrl());
        });
        return projectScores;
    }
  
    @Override
    public PageData<ProjectScore> findPage(PageWrap<ProjectScore> pageWrap) {
        IPage<ProjectScore> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        QueryWrapper<ProjectScore> queryWrapper = new QueryWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        if (pageWrap.getModel().getId() != null) {
            queryWrapper.lambda().eq(ProjectScore::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getCreator() != null) {
            queryWrapper.lambda().eq(ProjectScore::getCreator, pageWrap.getModel().getCreator());
        }
        if (pageWrap.getModel().getCreateDate() != null) {
            queryWrapper.lambda().ge(ProjectScore::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
            queryWrapper.lambda().le(ProjectScore::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
        }
        if (pageWrap.getModel().getEditor() != null) {
            queryWrapper.lambda().eq(ProjectScore::getEditor, pageWrap.getModel().getEditor());
        }
        if (pageWrap.getModel().getEditDate() != null) {
            queryWrapper.lambda().ge(ProjectScore::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
            queryWrapper.lambda().le(ProjectScore::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
        }
        if (pageWrap.getModel().getIsdeleted() != null) {
            queryWrapper.lambda().eq(ProjectScore::getIsdeleted, pageWrap.getModel().getIsdeleted());
        }
        if (pageWrap.getModel().getName() != null) {
            queryWrapper.lambda().eq(ProjectScore::getName, pageWrap.getModel().getName());
        }
        if (pageWrap.getModel().getRemark() != null) {
            queryWrapper.lambda().eq(ProjectScore::getRemark, pageWrap.getModel().getRemark());
        }
        if (pageWrap.getModel().getRoleType() != null) {
            queryWrapper.lambda().eq(ProjectScore::getRoleType, pageWrap.getModel().getRoleType());
        }
        if (pageWrap.getModel().getProjectId() != null) {
            queryWrapper.lambda().eq(ProjectScore::getProjectId, pageWrap.getModel().getProjectId());
        }
        if (pageWrap.getModel().getSortnum() != null) {
            queryWrapper.lambda().eq(ProjectScore::getSortnum, pageWrap.getModel().getSortnum());
        }
        if (pageWrap.getModel().getRate() != null) {
            queryWrapper.lambda().eq(ProjectScore::getRate, pageWrap.getModel().getRate());
        }
        if (pageWrap.getModel().getType() != null) {
            queryWrapper.lambda().eq(ProjectScore::getType, pageWrap.getModel().getType());
        }
        if (pageWrap.getModel().getFileUrl() != null) {
            queryWrapper.lambda().eq(ProjectScore::getFileUrl, pageWrap.getModel().getFileUrl());
        }
        if (pageWrap.getModel().getStatus() != null) {
            queryWrapper.lambda().eq(ProjectScore::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(projectScoreMapper.selectPage(page, queryWrapper));
    }

    @Override
    public long count(ProjectScore projectScore) {
        QueryWrapper<ProjectScore> wrapper = new QueryWrapper<>(projectScore);
        return projectScoreMapper.selectCount(wrapper);
    }
}