package com.doumee.service.business.impl;

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.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.LoginUserInfo;
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.ProjectMapper;
import com.doumee.dao.business.ProjectPermissonJoinMapper;
import com.doumee.dao.business.ProjectPermissonMapper;
import com.doumee.dao.business.model.Project;
import com.doumee.dao.business.model.ProjectPermisson;
import com.doumee.dao.system.SystemUserMapper;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.service.business.ProjectPermissonService;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
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/04/23 15:32
 */
@Service
public class ProjectPermissonServiceImpl implements ProjectPermissonService {

    @Autowired
    private ProjectPermissonMapper projectPermissonMapper;

    @Autowired
    private ProjectMapper projectMapper;

    @Autowired
    private SystemUserMapper systemUserMapper;

    @Autowired
    ProjectPermissonJoinMapper projectPermissonJoinMapper;

    @Override
    public Integer create(ProjectPermisson projectPermisson) {
        LoginUserInfo userInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();

        QueryWrapper<Project> projectWrapper = new QueryWrapper<>();
        projectWrapper.lambda().eq(Project::getId,projectPermisson.getProjectId())
                        .eq(Project::getSjId,userInfo.getId()).last("limit 1");
        Project project = projectMapper.selectOne(projectWrapper);

        if (Objects.isNull(project)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"用户无权操作该项目");
        }

        QueryWrapper<SystemUser> userWrapper = new QueryWrapper<>();
        userWrapper.lambda().eq(SystemUser::getParentId,userInfo.getId())
                            .eq(SystemUser::getId,projectPermisson.getObjId()).last("limit 1");
        SystemUser user = systemUserMapper.selectOne(userWrapper);
        if (Objects.isNull(user)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"用户无权操作该用户");
        }

        QueryWrapper<ProjectPermisson> projectPermissonWrapper = new QueryWrapper<>();
        projectPermissonWrapper.lambda().eq(ProjectPermisson::getProjectId,projectPermisson.getProjectId())
                                        .eq(ProjectPermisson::getType, Constants.ZERO)
                                        .eq(ProjectPermisson::getObjId,projectPermisson.getObjId()).last("limit 1");
        ProjectPermisson projectPermisson1 = projectPermissonMapper.selectOne(projectPermissonWrapper);
        if (Objects.nonNull(projectPermisson1)){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"子账号已经关联用户");
        }

        ProjectPermisson insert = new ProjectPermisson();
        insert.setCreator(userInfo.getId());
        insert.setCreateDate(new Date());
        insert.setEditor(userInfo.getId());
        insert.setEditDate(new Date());
        insert.setProjectId(projectPermisson.getProjectId());
        insert.setObjId(projectPermisson.getObjId());
        insert.setType(Constants.ZERO);
        projectPermissonMapper.insert(projectPermisson);
        return projectPermisson.getId();
    }

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

    @Override
    public void delete(ProjectPermisson projectPermisson) {
        UpdateWrapper<ProjectPermisson> deleteWrapper = new UpdateWrapper<>(projectPermisson);
        projectPermissonMapper.delete(deleteWrapper);
    }

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

    @Override
    public void updateById(ProjectPermisson projectPermisson) {
        projectPermissonMapper.updateById(projectPermisson);
    }

    @Override
    public void updateByIdInBatch(List<ProjectPermisson> projectPermissons) {
        if (CollectionUtils.isEmpty(projectPermissons)) {
            return;
        }
        for (ProjectPermisson projectPermisson: projectPermissons) {
            this.updateById(projectPermisson);
        }
    }

    @Override
    public ProjectPermisson findById(Integer id) {
        return projectPermissonMapper.selectById(id);
    }

    @Override
    public ProjectPermisson findOne(ProjectPermisson projectPermisson) {
        QueryWrapper<ProjectPermisson> wrapper = new QueryWrapper<>(projectPermisson);
        return projectPermissonMapper.selectOne(wrapper);
    }

    @Override
    public List<ProjectPermisson> findList(ProjectPermisson projectPermisson) {
        QueryWrapper<ProjectPermisson> wrapper = new QueryWrapper<>(projectPermisson);
        return projectPermissonMapper.selectList(wrapper);
    }
  
    @Override
    public PageData<ProjectPermisson> findPage(PageWrap<ProjectPermisson> pageWrap) {
        LoginUserInfo userInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
        IPage<ProjectPermisson> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<ProjectPermisson> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        if (pageWrap.getModel().getId() != null) {
            queryWrapper.eq(ProjectPermisson::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getCreator() != null) {
            queryWrapper.eq(ProjectPermisson::getCreator, pageWrap.getModel().getCreator());
        }
        if (pageWrap.getModel().getCreateDate() != null) {
            queryWrapper.ge(ProjectPermisson::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
            queryWrapper.le(ProjectPermisson::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
        }
        if (pageWrap.getModel().getEditor() != null) {
            queryWrapper.eq(ProjectPermisson::getEditor, pageWrap.getModel().getEditor());
        }
        if (pageWrap.getModel().getEditDate() != null) {
            queryWrapper.ge(ProjectPermisson::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
            queryWrapper.le(ProjectPermisson::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
        }
        if (pageWrap.getModel().getIsdeleted() != null) {
            queryWrapper.eq(ProjectPermisson::getIsdeleted, pageWrap.getModel().getIsdeleted());
        }
        if (pageWrap.getModel().getRemark() != null) {
            queryWrapper.eq(ProjectPermisson::getRemark, pageWrap.getModel().getRemark());
        }
        if (pageWrap.getModel().getProjectId() != null) {
            queryWrapper.eq(ProjectPermisson::getProjectId, pageWrap.getModel().getProjectId());
        }
        if (pageWrap.getModel().getObjId() != null) {
            queryWrapper.eq(ProjectPermisson::getObjId, pageWrap.getModel().getObjId());
        }
        if (pageWrap.getModel().getType() != null) {
            queryWrapper.eq(ProjectPermisson::getType, pageWrap.getModel().getType());
        }
        if (pageWrap.getModel().getSortnum() != null) {
            queryWrapper.eq(ProjectPermisson::getSortnum, pageWrap.getModel().getSortnum());
        }
        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
                queryWrapper.orderByDesc(sortData.getProperty());
            } else {
                queryWrapper.orderByAsc(sortData.getProperty());
            }
        }
        queryWrapper.selectAll(ProjectPermisson.class);
        queryWrapper.selectAs(Project::getName,ProjectPermisson::getProjectName);
        queryWrapper.selectAs(SystemUser::getRealname,ProjectPermisson::getRealname);
        queryWrapper.selectAs(SystemUser::getMobile,ProjectPermisson::getMobile);
        queryWrapper.leftJoin(Project.class,Project::getId,ProjectPermisson::getProjectId);
        queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,ProjectPermisson::getObjId);

        queryWrapper
                .eq(Project::getSjId,userInfo.getId())
                .like(StringUtils.isNotBlank(pageWrap.getModel().getProjectName()),Project::getName,pageWrap.getModel().getProjectName());
        if(StringUtils.isNotBlank(pageWrap.getModel().getQueryContent()) || StringUtils.isNotBlank(pageWrap.getModel().getQueryContent())){

            queryWrapper.and(wrapper ->wrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getQueryContent()),SystemUser::getRealname,pageWrap.getModel().getQueryContent())
                    .or()
                    .like(StringUtils.isNotBlank(pageWrap.getModel().getQueryContent()),SystemUser::getMobile,pageWrap.getModel().getQueryContent())
            );
        }


        return PageData.from(projectPermissonJoinMapper.selectJoinPage(page,ProjectPermisson.class , queryWrapper));
    }

    @Override
    public long count(ProjectPermisson projectPermisson) {
        QueryWrapper<ProjectPermisson> wrapper = new QueryWrapper<>(projectPermisson);
        return projectPermissonMapper.selectCount(wrapper);
    }
}