ProjectServiceImpl.java

package com.subsidy.service.impl;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.subsidy.common.configure.VODConfig;
import com.subsidy.common.constant.*;
import com.subsidy.common.exception.HttpException;
import com.subsidy.dto.project.*;
import com.subsidy.mapper.*;
import com.subsidy.model.*;
import com.subsidy.service.ProjectService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.subsidy.util.ConstantUtils;
import com.subsidy.util.Localstorage;
import com.subsidy.util.PDFUtil;
import com.subsidy.util.Signature;
import com.subsidy.util.excel.ExcelUtil;
import com.subsidy.vo.college.MatchCollegeVodsVO;
import com.subsidy.vo.project.*;
import com.tencentcloudapi.common.Credential;
import com.tencentcloudapi.common.profile.ClientProfile;
import com.tencentcloudapi.common.profile.HttpProfile;
import com.tencentcloudapi.vod.v20180717.VodClient;
import com.tencentcloudapi.vod.v20180717.models.MediaProcessTaskInput;
import com.tencentcloudapi.vod.v20180717.models.ProcessMediaRequest;
import com.tencentcloudapi.vod.v20180717.models.ProcessMediaResponse;
import com.tencentcloudapi.vod.v20180717.models.TranscodeTaskInput;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.time.LocalDateTime;
import java.util.*;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author Tuyp
 * @since 2025-01-07
 */
@Service
public class ProjectServiceImpl extends ServiceImpl<ProjectMapper, ProjectDO> implements ProjectService {

    @Autowired
    private ProjectMembersMapper projectMembersMapper;

    @Autowired
    private MatchDictMapper matchDictMapper;

    @Autowired
    private TeacherMapper teacherMapper;

    @Autowired
    private CollegesDictMapper collegesDictMapper;

    @Autowired
    private VODConfig vodConfig;

    public ProjectDO createProject(UpdateProjectDTO projectDO) throws Exception {
        //高教 职教
        CollegesDictDO collegesDictDO = teacherMapper.teacherCollege(projectDO.getTeacherId());
        if ("大学专科".equals(collegesDictDO.getEducation())) {
            projectDO.setProjectGroup("职教组");
        } else {
            projectDO.setProjectGroup("高教组");
        }
        projectDO.setCollegeId(collegesDictDO.getId());

        /**
         * 查看这一届有没有填写过
         */
        ProjectDO projectDO1 = this.baseMapper.selectOne(new QueryWrapper<ProjectDO>()
                .lambda()
                .eq(ProjectDO::getMatchId, projectDO.getMatchId())
                .eq(ProjectDO::getTeacherId, projectDO.getTeacherId()));
        if (null == projectDO1) {
            projectDO.setProjectSchedule(ProjectSchedule.REGISTER);
            projectDO.setProjectStatus(ProjectStatus.UN_SUBMITTED);
            this.baseMapper.insert(projectDO);

            TeacherDO teacherDO = teacherMapper.selectById(projectDO.getTeacherId());
            ProjectMembersDO projectMembersDO = new ProjectMembersDO();
            projectMembersDO.setProjectId(projectDO.getId());
            projectMembersDO.setRole(Role.LEADER);
            projectMembersDO.setUserName(teacherDO.getUserName());
            projectMembersDO.setBirthDate(PDFUtil.idCard2BirthDate(teacherDO.getIdCard()));
            projectMembersDO.setPosition(teacherDO.getPosition());
            projectMembersDO.setEducation(teacherDO.getEducation());
            projectMembersDO.setTitle(teacherDO.getTitle());
            projectMembersDO.setMajor(teacherDO.getMajor());
            projectMembersDO.setCourseTarget(projectDO.getCourseTarget());
            projectMembersDO.setSemester(projectDO.getSemester());
            projectMembersDO.setStartDate(projectDO.getStartDate());
            projectMembersDO.setEndDate(projectDO.getEndDate());
            projectMembersDO.setTeachHours(projectDO.getTeachHours());
            projectMembersDO.setTeachGrade(projectDO.getTeachGrade());
            projectMembersDO.setClassTotalNum(projectDO.getClassTotalNum());
            projectMembersMapper.insert(projectMembersDO);
        } else {
            if (!"填写中".equals(ProjectStatus.UN_SUBMITTED)) {
                throw new HttpException(10008);
            }
            BeanUtils.copyProperties(projectDO, projectDO1);
            if (StringUtils.isNotEmpty(projectDO.getAttachment())) {
                projectDO1.setProjectReview(ProjectReview.TO_REVIEWED);
                projectDO1.setProjectAssigned(ProjectReview.UNASSIGNED);
                projectDO1.setProjectStatus(ProjectStatus.TO_REVIEW);
            }

            ProjectMembersDO projectMembersDO = projectMembersMapper.selectOne(new QueryWrapper<ProjectMembersDO>()
            .lambda()
            .eq(ProjectMembersDO::getProjectId,projectDO1.getId())
            .eq(ProjectMembersDO::getRole,Role.LEADER));

            if (StringUtils.isNotEmpty(projectDO.getSemester())){
                projectMembersDO.setSemester(projectDO.getSemester());
            }

            if (StringUtils.isNotEmpty(projectDO.getStartDate())){
                projectMembersDO.setStartDate(projectDO.getStartDate());
            }
            if (StringUtils.isNotEmpty(projectDO.getEndDate())){
                projectMembersDO.setEndDate(projectDO.getEndDate());
            }
            if (null != projectDO.getTeachHours()){
                projectMembersDO.setTeachHours(projectDO.getTeachHours());
            }
            if (StringUtils.isNotEmpty(projectDO.getTeachGrade())){
                projectMembersDO.setTeachGrade(projectDO.getTeachGrade());
            }
            if (null != projectDO.getClassTotalNum()){
                projectMembersDO.setClassTotalNum(projectDO.getClassTotalNum());
            }

            if (null != projectDO.getCourseTarget()){
                projectMembersDO.setCourseTarget(projectDO.getCourseTarget());
            }
            projectMembersMapper.updateById(projectMembersDO);

            if (null != projectDO.getProjectMembersDOS()) {
                projectMembersMapper.delete(new QueryWrapper<ProjectMembersDO>()
                        .lambda()
                        .eq(ProjectMembersDO::getProjectId, projectDO.getId())
                        .eq(ProjectMembersDO::getRole, Role.MEMBER));

                List<ProjectMembersDO> projectMembersDOS = projectDO.getProjectMembersDOS();
                for (ProjectMembersDO pmd : projectMembersDOS) {
                    pmd.setProjectId(projectDO1.getId());
                    pmd.setRole(Role.MEMBER);
                    projectMembersMapper.insert(pmd);
                }
            }
            this.baseMapper.updateById(projectDO1);
        }

        return projectDO;
    }

    public ProjectDO updateProject(UpdateProjectDTO updateProjectDTO) throws Exception {
        ProjectDO projectDO = this.baseMapper.selectById(updateProjectDTO.getId());
//        BeanUtils.copyProperties(updateProjectDTO, projectDO);
//        if (StringUtils.isNotEmpty(updateProjectDTO.getAttachment())) {
//            projectDO.setProjectReview("待评审");
//        }
//        if (StringUtils.isNotEmpty(updateProjectDTO.getVodUrl())) {
//            //判断时间
//            MatchDictDO matchDictDO = matchDictMapper.selectById(projectDO.getMatchId());
//            SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//            if (new Date().before(simpleDateFormat.parse(matchDictDO.getVodStartTime())) || new Date().after(simpleDateFormat.parse(matchDictDO.getVodEndTime()))) {
//                throw new HttpException(10007);
//            }
//
//            projectDO.setVodUrl(updateProjectDTO.getVodUrl());
//            projectDO.setUploadDate(LocalDateTime.now().toString().replace(("T"), " "));
//        }
//        this.updateById(projectDO);
//
//        if (null != updateProjectDTO.getProjectMembersDOS()) {
//            projectMembersMapper.delete(new QueryWrapper<ProjectMembersDO>()
//                    .lambda()
//                    .eq(ProjectMembersDO::getProjectId, updateProjectDTO.getId()));
//
//            List<ProjectMembersDO> projectMembersDOS = updateProjectDTO.getProjectMembersDOS();
//            for (ProjectMembersDO pmd : projectMembersDOS) {
//                projectMembersMapper.insert(pmd);
//            }
//        }
        return projectDO;
    }

    public OneProjectVO oneProject(ProjectDO projectDO) {

        OneProjectVO oneProjectVO = new OneProjectVO();
        ProjectDO projectDO1 = this.baseMapper.selectById(projectDO.getId());
        BeanUtils.copyProperties(projectDO1, oneProjectVO);

        List<ProjectMembersDO> projectMembersDOS = projectMembersMapper.selectList(new QueryWrapper<ProjectMembersDO>()
                .lambda()
                .eq(ProjectMembersDO::getProjectId, projectDO.getId()));
        oneProjectVO.setProjectMembersDOS(projectMembersDOS);
        TeacherDO teacherDO = teacherMapper.selectById(projectDO1.getTeacherId());
        BeanUtils.copyProperties(teacherDO, oneProjectVO);
        return oneProjectVO;
    }

    public OneProjectVO oneProjectByTeacherId(ProjectDO projectDO) {

        OneProjectVO oneProjectVO = new OneProjectVO();
        ProjectDO projectDO1 = this.baseMapper.selectOne(new QueryWrapper<ProjectDO>()
                .lambda()
                .eq(ProjectDO::getTeacherId, projectDO.getTeacherId())
                .eq(ProjectDO::getMatchId, projectDO.getMatchId()));
        if (null != projectDO1) {

            List<ProjectMembersDO> projectMembersDOS = projectMembersMapper.selectList(new QueryWrapper<ProjectMembersDO>()
                    .lambda()
                    .eq(ProjectMembersDO::getProjectId, projectDO1.getId())
                    .eq(ProjectMembersDO::getRole, Role.MEMBER));
            oneProjectVO.setProjectMembersDOS(projectMembersDOS);
            TeacherDO teacherDO = teacherMapper.selectById(projectDO1.getTeacherId());
            BeanUtils.copyProperties(teacherDO, oneProjectVO);
            BeanUtils.copyProperties(projectDO1, oneProjectVO);
        }
        return oneProjectVO;
    }

    public OneProjectVO teacherProject(ProjectDO projectDO) {

        OneProjectVO oneProjectVO = new OneProjectVO();
        ProjectDO projectDO1 = this.baseMapper.selectOne(new QueryWrapper<ProjectDO>()
                .lambda()
                .eq(ProjectDO::getMatchId, projectDO.getMatchId())
                .eq(ProjectDO::getTeacherId, projectDO.getTeacherId()));
        if (null != projectDO1) {
            BeanUtils.copyProperties(projectDO1, oneProjectVO);

            List<ProjectMembersDO> projectMembersDOS = projectMembersMapper.selectList(new QueryWrapper<ProjectMembersDO>()
                    .lambda()
                    .eq(ProjectMembersDO::getProjectId, projectDO.getId()));
            oneProjectVO.setProjectMembersDOS(projectMembersDOS);
            TeacherDO teacherDO = teacherMapper.selectById(projectDO1.getTeacherId());
            CollegesDictDO collegesDictDO = collegesDictMapper.selectById(teacherDO.getCollegeId());
            oneProjectVO.setCollegeName(collegesDictDO.getName());
            oneProjectVO.setUserName(teacherDO.getUserName());
            return oneProjectVO;
        } else {
            return new OneProjectVO();
        }
    }

    public void downloadPdf(ProjectDO projectDO) {

        ProjectDO projectDO1 = this.baseMapper.selectById(projectDO.getId());

        MatchDictDO matchDictDO = matchDictMapper.selectById(projectDO1.getMatchId());

        TeacherDO teacherDO = teacherMapper.selectById(projectDO1.getTeacherId());

        CollegesDictDO collegesDictDO = collegesDictMapper.selectById(teacherDO.getCollegeId());

        List<ProjectMembersDO> projectMembersDOS = projectMembersMapper.selectList(new QueryWrapper<ProjectMembersDO>()
                .lambda()
                .eq(ProjectMembersDO::getProjectId, projectDO.getId()));

        PDFUtil.create(projectDO1, matchDictDO, teacherDO, projectMembersDOS, collegesDictDO);
    }

    @Override
    public IPage getSeedTrackProjectPage(ProjectListPageDTO projectListPageDTO) {
        Page page = new Page(projectListPageDTO.getPageNum(), projectListPageDTO.getPageSize());
        MatchDictDO matchDictDO = matchDictMapper.selectOne(new QueryWrapper<MatchDictDO>()
                .lambda()
                .eq(MatchDictDO::getStatus, 1));
        IPage<SeedTrackProjectPageVO> iPage = this.baseMapper.getSeedTrackProjectPage(page, matchDictDO.getId(), projectListPageDTO.getProjectGroup(), projectListPageDTO.getCourseName());
        return iPage;
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void pass(ApproveDTO approveDTO) {
        ProjectDO projectDO = this.baseMapper.selectById(approveDTO.getId());
        if (projectDO == null) {
            throw new HttpException(10046);
        }

        ProjectDO project = new ProjectDO();
        project.setId(projectDO.getId());

        if (ProjectStatus.SCHOOL_NOT_PASSED.equals(projectDO.getProjectStatus())){
            throw new HttpException(10032);
        }

        if (ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
            project.setProjectSchedule(ProjectSchedule.SEMI_FINAL_REVIEW);
        } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
                && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
            project.setProjectSchedule(ProjectSchedule.SEMI_FINAL_REVIEW);
            project.setProjectStatus(ProjectReview.TO_REVIEWED);
            project.setProjectReview(ProjectReview.TO_SCORE);
        } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
                && ProjectSchedule.SEMI_FINAL_REVIEW.equals(projectDO.getProjectSchedule())) {
            /**
             * 复赛通过  ---> 决赛审核
             */
            if (approveDTO.getProjectStatus() == 1) {
                project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                project.setProjectStatus(ProjectReview.TO_REVIEWED);
                project.setProjectReview(ProjectReview.TO_SCORE);
                project.setProjectAssigned(ProjectReview.UNASSIGNED);
            }
        } else {
            /**
             * 决赛通过  ---> 决赛通过
             */
            if (approveDTO.getProjectStatus() == 5) {
                project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                project.setProjectStatus(ProjectStatus.REMATCH_FINALS_GOLD_AWARD);
            } else if (approveDTO.getProjectStatus() == 3) {
                project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                project.setProjectStatus(ProjectStatus.REMATCH_SILVER_AWARD);
            } else if (approveDTO.getProjectStatus() == 4) {
                project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                project.setProjectStatus(ProjectStatus.REMATCH_BRONZE_AWARD);
            } else if (approveDTO.getProjectStatus() == 2) {
                project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                project.setProjectStatus(ProjectStatus.REMATCH_WINNING_AWARD);
            }
        }
        this.baseMapper.updateById(project);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void batchPass(ApproveDTO approveDTO) {
        for (Long id : approveDTO.getIds()) {
            ProjectDO projectDO = this.baseMapper.selectById(id);
            if (projectDO == null) {
                throw new HttpException(10046);
            }

            ProjectDO project = new ProjectDO();
            project.setId(projectDO.getId());

            if (ProjectStatus.SCHOOL_NOT_PASSED.equals(projectDO.getProjectStatus())){
                throw new HttpException(10032);
            }

            if (ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
                project.setProjectSchedule(ProjectSchedule.SEMI_FINAL_REVIEW);
            } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
                    && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
                project.setProjectSchedule(ProjectSchedule.SEMI_FINAL_REVIEW);
                project.setProjectStatus(ProjectReview.TO_REVIEWED);
                project.setProjectReview(ProjectReview.TO_SCORE);
            } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
                    && ProjectSchedule.SEMI_FINAL_REVIEW.equals(projectDO.getProjectSchedule())) {
                /**
                 * 复赛通过  ---> 决赛审核
                 */
                if (approveDTO.getProjectStatus() == 1) {
                    project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                    project.setProjectStatus(ProjectReview.TO_REVIEWED);
                    project.setProjectReview(ProjectReview.TO_SCORE);
                    project.setProjectAssigned(ProjectReview.UNASSIGNED);
                }
            } else {
                /**
                 * 决赛通过  ---> 决赛通过
                 */
                if (approveDTO.getProjectStatus() == 5) {
                    project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                    project.setProjectStatus(ProjectStatus.REMATCH_FINALS_GOLD_AWARD);
                } else if (approveDTO.getProjectStatus() == 3) {
                    project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                    project.setProjectStatus(ProjectStatus.REMATCH_SILVER_AWARD);
                } else if (approveDTO.getProjectStatus() == 4) {
                    project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                    project.setProjectStatus(ProjectStatus.REMATCH_BRONZE_AWARD);
                } else if (approveDTO.getProjectStatus() == 2) {
                    project.setProjectSchedule(ProjectSchedule.FINAL_REVIEW);
                    project.setProjectStatus(ProjectStatus.REMATCH_WINNING_AWARD);
                }
            }
            this.baseMapper.updateById(project);

        }
    }

    @Override
    public void exportProjectList(ProjectCollegeListDTO projectCollegeListDTO) {
        List<Map> data = new ArrayList<>();
        for (Long id : projectCollegeListDTO.getIds()) {
            ExportProjectDTO project = new ExportProjectDTO();
            ProjectDO projectDO = this.baseMapper.selectById(id);
            if (projectDO != null) {
                BeanUtils.copyProperties(projectDO, project);

                TeacherDO studentDO = teacherMapper.selectById(projectDO.getTeacherId());
                if (studentDO != null) {
                    project.setName(studentDO.getUserName());
                    project.setMajor(studentDO.getMajor());
                    project.setTelephone(studentDO.getTelephone());
                }

                MatchDictDO matchDictDO = matchDictMapper.selectById(projectDO.getMatchId());
                if (matchDictDO != null) {
                    project.setMatchName(matchDictDO.getMatchName());
                }

                List<ProjectMembersDO> memberDOS = projectMembersMapper.selectList(new QueryWrapper<ProjectMembersDO>()
                        .lambda()
                        .eq(ProjectMembersDO::getProjectId, projectDO.getId()));
                String teamMember = "";
                String teacher = "";
                for (ProjectMembersDO memberDO : memberDOS) {
                    teamMember += memberDO.getUserName() + ",";
                }
                if (StringUtils.isNotBlank(teamMember)) {
                    project.setTeamMembers(teamMember.substring(0, teamMember.length() - 1));
                } else {
                    project.setTeamMembers("");
                }
                data.add(JSON.parseObject(JSON.toJSONString(project), Map.class));
            }
        }
        ExcelUtil.writeExcel(ExcelUtil.getField(ExportProjectDTO.class), data);
    }

    public List<MatchCollegeVodsVO> matchCollegeVods(MatchCollegeVodsDTO matchCollegeVodsDTO) {
        return this.baseMapper.matchCollegeVods(matchCollegeVodsDTO.getCollegeId(), matchCollegeVodsDTO.getMatchId());
    }

    public RecentVodVO recentVod(ProjectDO projectDO) {
        List<RecentVodVO> recentVodVOS = this.baseMapper.recentVod(projectDO.getMatchId(), projectDO.getCollegeId());
        if (null != recentVodVOS  && recentVodVOS.size() > 0) {
            return recentVodVOS.get(0);
        } else {
            return new RecentVodVO();
        }
    }

    @Override
    public ProjectDataOverview getVocationalDataOverview(DataOverviewDTO dataOverviewDTO) {
        ProjectDataOverview projectDataOverview = new ProjectDataOverview();
        /*
            注册人数
         */
        Integer registeredNum = teacherMapper.selectCount(null);
        projectDataOverview.setRegisteredNum(registeredNum);

//        List<MatchDictDO> matchList = this.baseMapper.getList( dataOverviewDTO.getProjectGroup());

        List<ProjectDO> list = this.baseMapper.selectList(new QueryWrapper<ProjectDO>()
                .lambda()
                .ne(ProjectDO::getProjectStatus, ProjectStatus.UN_SUBMITTED)
                .eq(ProjectDO::getMatchId, dataOverviewDTO.getMatchId()));
        /*
            全部项目数量
         */
        projectDataOverview.setProjectNum(list.size());
        Integer schoolProjectNum = 0;
        Integer rematchProjectNum = 0;
        Integer finalProjectNum = 0;
        Integer preliminaryProjectNum = 0;

        Integer rematchBronzeAwardNum = 0;
        Integer rematchSilverAwardNum = 0;
        Integer rematchWinningAwardNum = 0;
        Integer finalsSilverAwardNum = 0;
        Integer finalsGoldAwardNum = 0;
        for (ProjectDO projectDO : list) {
            if (projectDO.getProjectSchedule().equals(ProjectSchedule.REGISTER)) {
                /*
                    校内赛项目数
                 */
                schoolProjectNum++;
            }
//            else if(projectDO.getProjectSchedule().equals(ProjectSchedule.PRELIMINARY_REVIEW)) {
//               /*
//                初赛项目数量
//                */
//                preliminaryProjectNum ++;
//            }
            else if (projectDO.getProjectSchedule().equals(ProjectSchedule.SEMI_FINAL_REVIEW)) {
                /*
                    复赛项目数
                 */
                rematchProjectNum++;
            } else if (projectDO.getProjectSchedule().equals(ProjectSchedule.FINAL_REVIEW)) {
                /*
                    决赛项目数
                 */
                finalProjectNum++;
            }

            if (projectDO.getProjectStatus().equals(ProjectStatus.REMATCH_BRONZE_AWARD)) {
                rematchBronzeAwardNum++;
            } else if (projectDO.getProjectStatus().equals(ProjectStatus.REMATCH_SILVER_AWARD)) {
                rematchSilverAwardNum++;
            } else if (projectDO.getProjectStatus().equals(ProjectStatus.REMATCH_WINNING_AWARD)) {
                rematchWinningAwardNum++;
            } else if (projectDO.getProjectStatus().equals(ProjectStatus.REMATCH_FINALS_GOLD_AWARD)) {
                finalsGoldAwardNum++;
            }
        }

        projectDataOverview.setRematchBronzeAwardNum(rematchBronzeAwardNum);
        projectDataOverview.setRematchSilverAwardNum(rematchSilverAwardNum);
        projectDataOverview.setRematchWinningAwardNum(rematchWinningAwardNum);
        projectDataOverview.setFinalsSilverAwardNum(finalsSilverAwardNum);
        projectDataOverview.setFinalsGoldAwardNum(finalsGoldAwardNum);
        projectDataOverview.setSchoolProjectNum(schoolProjectNum + preliminaryProjectNum + rematchProjectNum + finalProjectNum);
        projectDataOverview.setRematchProjectNum(rematchProjectNum + finalProjectNum);
        /*
            复赛比例
         */
        if (rematchProjectNum > 0 && schoolProjectNum > 0) {
            Double rematchProportion = new BigDecimal(rematchProjectNum + finalProjectNum).divide(new BigDecimal(preliminaryProjectNum + rematchProjectNum + finalProjectNum), 4, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100)).doubleValue();
            projectDataOverview.setRematchProportion(rematchProportion);
        } else {
            projectDataOverview.setRematchProportion(0.0);
        }

        projectDataOverview.setFinalProjectNum(finalProjectNum);
        /*
            决赛比例
         */
        if (finalProjectNum > 0 && rematchProjectNum > 0) {
            Double finalProportion = new BigDecimal(finalProjectNum).divide(new BigDecimal(rematchProjectNum + finalProjectNum), 4, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100)).doubleValue();
            projectDataOverview.setFinalProportion(finalProportion);
        } else {
            projectDataOverview.setFinalProportion(0.0);
        }

        return projectDataOverview;
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void withdrawn(ProjectDO projectDO) throws Exception {

        ProjectDO project = this.baseMapper.selectOne(new QueryWrapper<ProjectDO>()
                .lambda()
                .eq(ProjectDO::getId, projectDO.getId()));

        if (project == null) {
            throw new HttpException(10044);
        }

        if (!project.getProjectSchedule().equals(ProjectSchedule.REGISTER)) {
            throw new HttpException(10045);
        }

        if (project.getProjectStatus().equals(ProjectStatus.SCHOOL_NOT_PASSED)) {
            throw new HttpException(10045);
        }

        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");

        MatchDictDO matchDictDO = matchDictMapper.selectById(project.getMatchId());
        if (new Date().before(simpleDateFormat.parse(matchDictDO.getStartTime())) || new Date().after(simpleDateFormat.parse(matchDictDO.getEndTime()))) {
            throw new HttpException(10031);
        }

        ProjectDO pd = new ProjectDO();
        pd.setId(project.getId());
        pd.setProjectStatus(ProjectStatus.UN_SUBMITTED);
        this.baseMapper.updateById(pd);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void rollback(ProjectDO projectDO) throws Exception {
        ProjectDO project = this.baseMapper.selectById(projectDO.getId());
        if (project == null) {
            throw new HttpException(10046);
        }

        /**
         * 学生上报撤回 没有限制，项目不为空既可以撤回
         * 校内赛上报撤回，没有分配评委 + 没有评分
         */

        if (!project.getProjectStatus().equals(ProjectReview.TO_REVIEWED)) {
            throw new HttpException(10073);
        }

        if (project.getProjectAssigned() != null && !project.getProjectAssigned().equals(ProjectReview.UNASSIGNED)) {
            throw new HttpException(10073);
        }

        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");

        MatchDictDO matchDictDO = matchDictMapper.selectById(project.getMatchId());
        if (new Date().before(simpleDateFormat.parse(matchDictDO.getStartTime())) || new Date().after(simpleDateFormat.parse(matchDictDO.getEndTime()))) {
            throw new HttpException(10031);
        }

        ProjectDO p = new ProjectDO();
        p.setId(project.getId());

        if (ProjectSchedule.REGISTER.equals(project.getProjectSchedule())) {
            p.setProjectSchedule(ProjectSchedule.REGISTER);
        }
        if (ProjectSchedule.SEMI_FINAL_REVIEW.equals(project.getProjectSchedule())) {
            p.setProjectSchedule(ProjectSchedule.REGISTER);
        }

        if (project.getProjectSchedule().equals(ProjectSchedule.REGISTER)) {
            p.setProjectStatus(ProjectStatus.UN_SUBMITTED);
        }

        this.baseMapper.updateById(p);

    }

    @Override
    public VocationalNumVO getVocationalProjectNum(SeedTrackProjectNumDTO seedTrackProjectNumDTO) {
        CollegesDictDO collegesDictDO = collegesDictMapper.selectById(seedTrackProjectNumDTO.getId());

        List<ProjectDO> list = new ArrayList<ProjectDO>();
        if (null != seedTrackProjectNumDTO.getId()) {
            list = this.baseMapper.getSeedTrackProjectList(collegesDictDO.getId(), seedTrackProjectNumDTO.getMatchId(), seedTrackProjectNumDTO.getProjectGroup(), null);
        } else {
            list = this.baseMapper.getSeedTrackProjectList(null, seedTrackProjectNumDTO.getMatchId(), seedTrackProjectNumDTO.getProjectGroup(), null);
        }

        VocationalNumVO vocationalNumVO = new VocationalNumVO();
        Integer registerNum = 0;
        Integer rematchProjectNum = 0;
        Integer finalProjectNum = 0;
        if (list != null && list.size() > 0) {
            for (ProjectDO projectDO : list) {
                if (projectDO.getProjectSchedule().equals(ProjectSchedule.REGISTER)) {
                    registerNum++;
                } else if (projectDO.getProjectSchedule().equals(ProjectSchedule.SEMI_FINAL_REVIEW)) {
                    rematchProjectNum++;
                } else if (projectDO.getProjectSchedule().equals(ProjectSchedule.FINAL_REVIEW)) {
                    finalProjectNum++;
                }
            }
        }
        vocationalNumVO.setRegisterNum(registerNum);
        vocationalNumVO.setRematchNum(rematchProjectNum);
        vocationalNumVO.setFinalNum(finalProjectNum);
        return vocationalNumVO;
    }

    @Override
    public IPage getSeedTrackProjectList(ProjectListPageDTO projectListPageDTO) {

        Page page = new Page(projectListPageDTO.getPageNum(), projectListPageDTO.getPageSize());
        return this.baseMapper.getSeedTrackProjectPage1(page, projectListPageDTO.getMatchId(), projectListPageDTO.getProjectGroup(), MemberType.PRINCIPAL, projectListPageDTO.getCollegeId(),
                projectListPageDTO.getProjectSchedule(), projectListPageDTO.getProjectStatus(), projectListPageDTO.getName(), projectListPageDTO.getProjectProgress());

    }

    @Override
    public IPage getVocationalProjectPage(ProjectListPageDTO projectListPageDTO) {
        Page page = new Page(projectListPageDTO.getPageNum(), projectListPageDTO.getPageSize());
        Long matchId = null;
        if (projectListPageDTO.getMatchId() == null) {
            MatchDictDO matchDictDO = matchDictMapper.selectOne(new QueryWrapper<MatchDictDO>()
                    .lambda()
                    .eq(MatchDictDO::getStatus, 1));
            if (matchDictDO != null) {
                matchId = matchDictDO.getId();
            }
        } else {
            matchId = projectListPageDTO.getMatchId();
        }

        IPage<SeedTrackProjectPageVO> iPage = this.baseMapper.getSeedTrackProjectPage1(page, matchId, projectListPageDTO.getProjectGroup(), ProjectType.VOCATIONAL, null,
                projectListPageDTO.getProjectSchedule(), projectListPageDTO.getProjectStatus(), projectListPageDTO.getName(), projectListPageDTO.getProjectProgress());

        return iPage;
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void weedOut(ApproveDTO approveDTO) {
        ProjectDO projectDO = this.baseMapper.selectById(approveDTO.getId());

        if (projectDO == null) {
            throw new HttpException(10046);
        }

        if (!projectDO.getProjectStatus().equals(ProjectReview.TO_REVIEWED)) {
            throw new HttpException(10065);
        }

//        String projectStatus = "";
//        if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
//                && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
//            projectStatus = ProjectStatus.SCHOOL_NOT_PASSED;
//        } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
//                && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
//            projectStatus = ProjectStatus.SCHOOL_NOT_PASSED;
//        }

        //StudentDO studentDO = studentService.getById(projectDO.getProposerId());

        ProjectDO project = new ProjectDO();
        project.setId(projectDO.getId());
        project.setProjectStatus(ProjectStatus.SCHOOL_NOT_PASSED);
        project.setProjectSchedule(projectDO.getProjectSchedule());
        this.baseMapper.updateById(project);

    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void batchWeedOut(ApproveDTO approveDTO) {
        if (approveDTO.getIds() != null && approveDTO.getIds().size() > 0) {
            for (Long id : approveDTO.getIds()) {
                ProjectDO projectDO = this.baseMapper.selectById(id);
                if (projectDO == null) {
                    throw new HttpException(10046);
                }

                if (!projectDO.getProjectStatus().equals(ProjectReview.TO_REVIEWED)) {
                    throw new HttpException(10065);
                }

//                String projectStatus = "";

//                if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
//                        && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
//                    projectStatus = ProjectStatus.SCHOOL_NOT_PASSED;
//                } else if (ProjectReview.TO_REVIEWED.equals(projectDO.getProjectStatus())
//                        && ProjectSchedule.REGISTER.equals(projectDO.getProjectSchedule())) {
//                    projectStatus = ProjectStatus.SCHOOL_NOT_PASSED;
//                }

                //StudentDO studentDO = studentService.getById(projectDO.getProposerId());

                ProjectDO project = new ProjectDO();
                project.setId(projectDO.getId());
                project.setProjectStatus(ProjectStatus.SCHOOL_NOT_PASSED);
                project.setProjectSchedule(projectDO.getProjectSchedule());
                this.baseMapper.updateById(project);

            }
        }
    }


    public SignatureVO signature() {
//
        SignatureVO signatureVO = new SignatureVO();

        Signature signature = new Signature();
        signature.setSecretId(vodConfig.getSecretId());
        signature.setSecretKey(vodConfig.getSecretKey());
        signature.setCurrentTime(System.currentTimeMillis());
        signature.setRandom(new Random().nextInt(Integer.MAX_VALUE));
        signature.setSignValidDuration(3600 * 24 * 2);
        signature.setClassId(vodConfig.getClassId());
        String sign = "";
        try {
            sign = signature.getUploadSignature();
            signatureVO.setSign(sign);
        } catch (Exception ex) {
            ex.printStackTrace();
//            throw new MyException(ResultEnum.UNKNOWN_ERROR);
        }
        return signatureVO;
    }

    @Transactional(rollbackFor = Exception.class)
    public String uploadVods(ProjectDO projectDO) throws Exception {
        ProjectDO projectDO1 = this.baseMapper.selectById(projectDO.getId());
        projectDO1.setVodUrl(projectDO.getVodUrl());
        projectDO1.setUploadDate(LocalDateTime.now().toString().replace(("T"), " ").substring(0, 19));
        this.baseMapper.updateById(projectDO1);
        return ConstantUtils.SUCCESS_UPDATE;
    }

    @Transactional(rollbackFor = Exception.class)
    public String uploadVodsTimeLimit(ProjectDO projectDO) throws Exception {
        ProjectDO projectDO1 = this.baseMapper.selectById(projectDO.getId());
        projectDO1.setVodUrl(projectDO.getVodUrl());
        //判断时间
        MatchDictDO matchDictDO = matchDictMapper.selectById(projectDO1.getMatchId());
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
        if (null != matchDictDO.getVodStartTime() && new Date().before(simpleDateFormat.parse(matchDictDO.getVodStartTime()))) {
            throw new HttpException(10007);
        }
        if (null != matchDictDO.getVodEndTime() && new Date().after(simpleDateFormat.parse(matchDictDO.getVodEndTime()))) {
            throw new HttpException(10007);
        }
        projectDO1.setUploadDate(LocalDateTime.now().toString().replace(("T"), " ").substring(0, 19));
        this.baseMapper.updateById(projectDO1);
        return ConstantUtils.SUCCESS_UPDATE;
    }

}