中小学教师课程排课系统 毕业设计 JAVA+Vue+SpringBoot+MySQL（二）

@RequestMapping(value = "/getByPage", method = RequestMethod.GET)
@ApiOperation(value = "查询课程")
public Result<IPage<Curriculum>> getByPage(@ModelAttribute Curriculum curriculum ,@ModelAttribute PageVo page){
    QueryWrapper<Curriculum> qw = new QueryWrapper<>();
    if(!ZwzNullUtils.isNull(curriculum.getTitle())) {
        qw.like("title",curriculum.getTitle());
    }
    if(!ZwzNullUtils.isNull(curriculum.getStatus())) {
        qw.like("status",curriculum.getStatus());
    }
    IPage<Curriculum> data = iCurriculumService.page(PageUtil.initMpPage(page),qw);
    return new ResultUtil<IPage<Curriculum>>().setData(data);
}

@RequestMapping(value = "/insert", method = RequestMethod.POST)
@ApiOperation(value = "新增课程")
public Result<Curriculum> insert(Curriculum curriculum){
    iCurriculumService.saveOrUpdate(curriculum);
    return new ResultUtil<Curriculum>().setData(curriculum);
}

@RequestMapping(value = "/getCardList", method = RequestMethod.GET)
@ApiOperation(value = "查询全部排课")
public Result<List<TeachingScheduleVo>> getCardList(){
    List<TeachingScheduleVo> ans = new ArrayList<>();
    QueryWrapper<TeachingSchedule> qw1 = new QueryWrapper<>();
    qw1.eq("x",1);
    qw1.orderByAsc("y");
    ans.add(new TeachingScheduleVo(1,iTeachingScheduleService.list(qw1)));
    QueryWrapper<TeachingSchedule> qw2 = new QueryWrapper<>();
    qw2.eq("x",2);
    qw2.orderByAsc("y");
    ans.add(new TeachingScheduleVo(2,iTeachingScheduleService.list(qw2)));
    QueryWrapper<TeachingSchedule> qw3 = new QueryWrapper<>();
    qw3.eq("x",3);
    qw3.orderByAsc("y");
    ans.add(new TeachingScheduleVo(3,iTeachingScheduleService.list(qw3)));
    QueryWrapper<TeachingSchedule> qw4 = new QueryWrapper<>();
    qw4.eq("x",4);
    qw4.orderByAsc("y");
    ans.add(new TeachingScheduleVo(4,iTeachingScheduleService.list(qw4)));
    QueryWrapper<TeachingSchedule> qw5 = new QueryWrapper<>();
    qw5.eq("x",5);
    qw5.orderByAsc("y");
    ans.add(new TeachingScheduleVo(5,iTeachingScheduleService.list(qw5)));
    QueryWrapper<TeachingSchedule> qw6 = new QueryWrapper<>();
    qw6.eq("x",6);
    qw6.orderByAsc("y");
    ans.add(new TeachingScheduleVo(6,iTeachingScheduleService.list(qw6)));
    QueryWrapper<TeachingSchedule> qw7 = new QueryWrapper<>();
    qw7.eq("x",7);
    qw7.orderByAsc("y");
    ans.add(new TeachingScheduleVo(7,iTeachingScheduleService.list(qw7)));
    return new ResultUtil<List<TeachingScheduleVo>>().setData(ans);
}

@RequestMapping(value = "/getByPage", method = RequestMethod.GET)
@ApiOperation(value = "查询排课申请")
public Result<IPage<TeachingApply>> getByPage(@ModelAttribute TeachingApply teachingApply ,@ModelAttribute PageVo page){
    QueryWrapper<TeachingApply> qw = new QueryWrapper<>();
    User currUser = securityUtil.getCurrUser();
    QueryWrapper<User> userQw = new QueryWrapper<>();
    userQw.eq("id",currUser.getId());
    userQw.inSql("id","SELECT user_id FROM a_user_role WHERE del_flag = 0 AND role_id = '496138616573952'");
    if(iUserService.count(userQw) < 1L) {
        qw.eq("user_id",currUser.getId());
    }
    if(!ZwzNullUtils.isNull(teachingApply.getUserName())) {
        qw.like("user_name",teachingApply.getUserName());
    }
    if(!ZwzNullUtils.isNull(teachingApply.getCurriculumName())) {
        qw.like("curriculum_name",teachingApply.getCurriculumName());
    }
    if(!ZwzNullUtils.isNull(teachingApply.getScheduleName())) {
        qw.like("schedule_name",teachingApply.getScheduleName());
    }
    IPage<TeachingApply> data = iTeachingApplyService.page(PageUtil.initMpPage(page),qw);
    return new ResultUtil<IPage<TeachingApply>>().setData(data);
}

@RequestMapping(value = "/work", method = RequestMethod.GET)
@ApiOperation(value = "自动排课")
public Result<Object> work(){
    List<TeachingApply> applyList = iTeachingApplyService.list();
    List<TeachingApplyVo> ans = new ArrayList<>();
    // 分离用户的排课申请
    for (TeachingApply a : applyList) {
        boolean flag = true;
        for (TeachingApplyVo vo : ans) {
            if(Objects.equals(a.getUserId(),vo.getUserId())) {
                vo.getList().add(a);
                flag = false;
                break;
            }
        }
        if(flag) {
            TeachingApplyVo vo = new TeachingApplyVo();
            vo.setUserId(a.getUserId());
            vo.setUserName(a.getUserName());
            List<TeachingApply> aList = new ArrayList<>();
            aList.add(a);
            vo.setList(aList);
            vo.setFlag(0);
            ans.add(vo);
        }
    }
    // 课位初始化
    List<TeachingSchedule> scheduleList = iTeachingScheduleService.list();
    for (TeachingSchedule s : scheduleList) {
        s.setCurId("");
        s.setCurName("");
        s.setTeacherName("");
    }
    // 根据排课申请数量升序排列，尽可能满足多的教师完成排课
    Collections.sort(ans, new Comparator<TeachingApplyVo>() {
        @Override
        public int compare(TeachingApplyVo o1, TeachingApplyVo o2) {
            return o1.getList().size() - o2.getList().size();
        }
    });
    for(int i = 0; i < ans.size(); i ++) {
        List<TeachingSchedule> tempList = new ArrayList<>();
        for (TeachingSchedule s : scheduleList) {
            tempList.add(s);
        }
        // 判断能否满足排课
        boolean flagSum = true;
        for (TeachingApply a : ans.get(i).getList()) {
            boolean flag = true;
            for (TeachingSchedule teachingSchedule : tempList) {
                if(Objects.equals(a.getScheduleId(),teachingSchedule.getId()) && ZwzNullUtils.isNull(teachingSchedule.getCurId())) {
                    // 排课成功
                    teachingSchedule.setCurId(a.getCurriculumId());
                    teachingSchedule.setCurName(a.getCurriculumName());
                    teachingSchedule.setTeacherName(a.getUserName());
                    a.setStatus("排课成功");
                    flag = false;
                    break;
                }
            }
            if(flag) {
                // 排课失败,下一位
                flagSum = false;
                break;
            }
        }
        if(flagSum) {
            // 如果全部课程可以排课，则保存
            scheduleList = new ArrayList<>();
            for (TeachingSchedule vo : tempList) {
                scheduleList.add(vo);
            }
            ans.get(i).setFlag(1);
        } else {
            // 否则不保存
        }
    }
    // 未完成排课的，按顺序能排上的排上
    for (TeachingApplyVo vo : ans) {
        if(Objects.equals(1,vo.getFlag())) {
            continue;
        }
        for (TeachingApply a : vo.getList()) {
            for (TeachingSchedule teachingSchedule : scheduleList) {
                if(Objects.equals(a.getScheduleId(),teachingSchedule.getId()) && ZwzNullUtils.isNull(teachingSchedule.getCurId())) {
                    // 补排课成功
                    teachingSchedule.setCurId(a.getCurriculumId());
                    teachingSchedule.setCurName(a.getCurriculumName());
                    teachingSchedule.setTeacherName(a.getUserName());
                    a.setStatus("排课成功");
                    break;
                }
            }
        }
    }
    // 保存排课数据
    for (TeachingSchedule teachingSchedule : scheduleList) {
        iTeachingScheduleService.saveOrUpdate(teachingSchedule);
    }
    // 保存申请数据
    for (TeachingApplyVo vo : ans) {
        for (TeachingApply a : vo.getList()) {
            if(!Objects.equals("排课成功",a.getStatus())) {
                a.setStatus("排课失败");
            }
            iTeachingApplyService.saveOrUpdate(a);
        }
    }
    return ResultUtil.success();
}