实验课排课

2022SC@SDUSC

实验排课算法思想：

1.根据实验课老师提交的申请意向星期节次，优先安排

2.根据时间，检测班级时间冲突和实验室使用冲突。

3.若冲突，则推荐可用时间并默认选择靠前时间。

4.若实验室所有时间都冲突，则安排失败。

其他功能同考务。

代码实现：

package org.jeecg.modules.demo.test.controller;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.aspect.annotation.AutoLog;
import org.jeecg.common.system.base.controller.JeecgController;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.modules.demo.atupai.entity.Timetable;
import org.jeecg.modules.demo.atupai.service.ITimetableService;
import org.jeecg.modules.demo.atupai.service.ILesInfoService;
import org.jeecg.modules.demo.test.entity.Extarrangement;
import org.jeecg.modules.demo.test.entity.Extcourse;
import org.jeecg.modules.demo.test.entity.Extroom;
import org.jeecg.modules.demo.Excourse.entity.ExtApply;
import org.jeecg.modules.demo.Excourse.service.IExtApplyService;
import org.jeecg.modules.demo.test.service.IExtarrangementService;
import org.jeecg.modules.demo.test.service.IExtcourseService;
import org.jeecg.modules.demo.test.service.IExtroomService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

/**
 * @Description: 实验申请排课
 * @Author: jeecg-boot
 * @Date:   2022-05-14
 * @Version: V1.0
 */
@Api(tags="实验申请排课")
@RestController
@RequestMapping("/test/shiyananpai")
@Slf4j
public class ExtarrangementController extends JeecgController<Extarrangement, IExtarrangementService> {
	 @Autowired
	 private IExtarrangementService extarrangementService;
	 @Autowired
	 private ILesInfoService lesInfoService;
	@Autowired
	private ITimetableService timetableService;
	@Autowired
	private IExtroomService extroomService;
    @Autowired
    private IExtcourseService extcourseService;
	@Autowired
	private IExtApplyService extApplyService;

	/**
	 * 分页列表查询
	 *
	 * @param extarrangement
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	//@AutoLog(value = "实验申请排课-分页列表查询")
	@ApiOperation(value="实验申请排课-分页列表查询", notes="实验申请排课-分页列表查询")
	@GetMapping(value = "/list")
	public Result<IPage<Extarrangement>> queryPageList(Extarrangement extarrangement,
													   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
													   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
													   HttpServletRequest req) {
		QueryWrapper<Extarrangement> queryWrapper = QueryGenerator.initQueryWrapper(extarrangement, req.getParameterMap());
		Page<Extarrangement> page = new Page<Extarrangement>(pageNo, pageSize);
		IPage<Extarrangement> pageList = extarrangementService.page(page, queryWrapper);
		return Result.OK(pageList);
	}
    @AutoLog(value = "关联流程")
	@ApiOperation(value="关联流程", notes="关联流程")
	@RequestMapping(value = "/relationAct",method = RequestMethod.GET)
	public Result<?> relationAct(HttpServletRequest request,HttpServletResponse response){
		String dataId = request.getParameter("dataId");
		extarrangementService.relationAct(dataId);
		return Result.OK();
	}


	@RequestMapping(value = "/getAllList", method = {RequestMethod.GET})
	public Result<?> getAllList() {
		List<Extarrangement> allList = this.extarrangementService.getAllList();
		return Result.OK(allList);
	}


	/**
	 *   添加
	 *
	 * @param extarrangement
	 * @return
	 */
	@AutoLog(value = "实验申请排课-添加")
	@ApiOperation(value="实验申请排课-添加", notes="实验申请排课-添加")
	@PostMapping(value = "/add")
	public Result<String> add(@RequestBody Extarrangement extarrangement) {
		extarrangementService.save(extarrangement);
		return Result.OK("添加成功！");
	}

	/**
	 *  编辑
	 *
	 * @param extarrangement
	 * @return
	 */
	@AutoLog(value = "实验申请排课-编辑")
	@ApiOperation(value="实验申请排课-编辑", notes="实验申请排课-编辑")
	@RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
	public Result<String> edit(@RequestBody Extarrangement extarrangement) throws Exception {
		Extarrangement exrarrangementori= extarrangementService.getById(extarrangement.getId());
		//逻辑：取消安排再手动安排
		if (exrarrangementori== extarrangement)
		   {
			   extarrangementService.updateById(extarrangement);
		    return Result.OK("编辑成功!");}
		else { if (exrarrangementori.getAnpai()!=null&&exrarrangementori.getAnpai().equals("已安排"))
			    return Result.error("请先取消安排");
			  else {//取属性
			String courseid= extarrangement.getCourseid();
			String coursename= extarrangement.getCoursename();
			String courseord= extarrangement.getCourseord();
			String extarrangementAnpaishijian= extarrangement.getAnpaishijian();
			String []arrange=extarrangementAnpaishijian.split("\\+");
			String classes= extarrangement.getClasses();
			String roominfo= extarrangement.getTestclassroom();
			String weektime= extarrangement.getTestweek();
			String []week=weektime.split("-");
			List <String>searchclass = getclass(classes);
			int weekfirst=Integer.parseInt(week[0]);
			int weeklast=Integer.parseInt(week[1]);
			int sign=0;
			String consion="";
			String concourse="";
			//判断每个班级申请时间是否有课；
			for (String evearrange:arrange)
			{ String []testtime=evearrange.split(",");
				for (String classtime:searchclass)
			  {
				List<String> time= null;
				try {
					time= timetableService.selectWeek(classtime,testtime[0],testtime[1]);

				} catch (Exception e) {
					e.printStackTrace();
				}
				if (time!=null)
				{ //考虑之后发现形势与政策应该不会比安排时间早，所以不考虑
					for(String courseweek:time)
					{  if (!courseweek.contains(","))
					{
						String[] range = courseweek.split("-");
						if (!(weeklast < Integer.parseInt(range[0]) || weekfirst > Integer.parseInt(range[1])))
						{   sign = 1;
							consion=classtime;
							try {
								concourse= timetableService.selectName(classtime,testtime[0],testtime[1]).get(0);
							} catch (Exception e) {
								e.printStackTrace();
							}
							break;
						}
					}
					}
				}
			}
			}
			String con="";
			String cons="";
			if (sign==1)
				return Result.error("与"+consion+concourse+"冲突,安排失败");
			else {
				   int vas=0;
				   Extroom extroom = new Extroom();
				   for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						extroom = extroomService.selectByShiyanshiWeek(roominfo, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					   for (String evearr :arrange)
					   { String []testtime=evearr.split(",");
					       if (!shiyanshikeyong(extroom, testtime[0], testtime[1]))
						   { vas = 1;
						      con=testtime[0];
							    cons=testtime[1];
						   }
					   }
				   }
				   if (vas==1)
					   return Result.error(con+cons+"该实验室已有安排,安排失败");
				   else{ int err=0;
					   Extroom room = new Extroom();
					   for (int j = weekfirst; j < weeklast + 1; j++) {
						   try {
							   room = extroomService.selectByShiyanshiWeek(roominfo, j);
						   } catch (Exception e) {
							   e.printStackTrace();
						   }
						   for (String ceshianpai:arrange)
						   { String []ceshitime=ceshianpai.split(",");
							   if (!shiyanshikeyongupdate(room, ceshitime[0], ceshitime[1]))
							    err=1;
						   }
					   }
					   if (err==0){
					   for (String eveanpai:arrange) {
						   String[] set = eveanpai.split(",");
						   for(String banjieve:searchclass) {
							   Timetable xinzengshiyanshi = new Timetable();
							   List<Timetable> natural=timetableService.selectGrade(eveanpai,courseid,courseord,coursename);
							   xinzengshiyanshi.setGrade(natural.get(0).getGrade());
							   xinzengshiyanshi.setAttribute(natural.get(0).getAttribute());
							   xinzengshiyanshi.setMajor(natural.get(0).getMajor());
							   xinzengshiyanshi.setTeacherid(extarrangement.getTestteacherid());
							   xinzengshiyanshi.setTeacher(extarrangement.getTestteacher());
							   xinzengshiyanshi.setWeekday(set[0]);
							   xinzengshiyanshi.setWeekdaytime(set[1]);
							   xinzengshiyanshi.setCourseid(courseid);
							   xinzengshiyanshi.setCoursename(coursename);
							   xinzengshiyanshi.setNature("实验课");
							   xinzengshiyanshi.setCourseord(courseord);
							   xinzengshiyanshi.setClasses(banjieve);
							   xinzengshiyanshi.setWeektime(weektime);
							   xinzengshiyanshi.setClassroom(roominfo);
							   timetableService.save(xinzengshiyanshi); }
					   }
					   extarrangement.setAnpai("已安排");
					   extarrangementService.updateById(extarrangement);
					   return Result.OK("编辑成功!");}
			       else  return Result.error("编辑失败!");
		}}}}
	}

	/**
	 *   通过id删除
	 *
	 * @param id
	 * @return
	 */
	@AutoLog(value = "实验申请排课-通过id删除")
	@ApiOperation(value="实验申请排课-通过id删除", notes="实验申请排课-通过id删除")
	@DeleteMapping(value = "/delete")
	public Result<String> delete(@RequestParam(name="id",required=true) String id) {
		extarrangementService.removeById(id);
		return Result.OK("删除成功!");
	}

	 /**
	  *   初始化
	  *
	  * @param id
	  * @return
	  */

	 @GetMapping(value = "/chushihua")
	 public Result<String> chushihua(@RequestParam(name="id",required=true) String id) {
		 try {
			 extarrangementService.deleteFromTable();
		 } catch (Exception e) {
			 e.printStackTrace();
		 }
		 List<ExtApply> allcourse= null;
		 try {
			 allcourse = extApplyService.selectAll();
		 } catch (Exception e) {
			 e.printStackTrace();
		 }
		 for(ExtApply course:allcourse)
		 { Extarrangement extarrangement =new Extarrangement();
		    extarrangement.setTid(course.getTid());
		 	extarrangement.setTerm(course.getTerm());
		 	extarrangement.setCourseid(course.getCourseid());
		 	extarrangement.setCourseord(course.getCourseord());
		 	extarrangement.setCoursename(course.getCoursename());
		 	extarrangement.setTeacher(course.getTeaName());
			 extarrangement.setTestteacherid(course.getTestteacher());
			 if (course.getType().equals("实验教师"))
		 	     extarrangement.setTestteacher(course.getExname());
			 if (course.getType().equals("任课教师"))
				 extarrangement.setTestteacherid(course.getTeaName());
			 if (course.getType().equals("任课教师、实验教师"))
				 extarrangement.setTestteacher(course.getExname()+","+course.getExname());
		 	extarrangement.setType(course.getType());
		 	extarrangement.setZhujiao(course.getZhujiao());
		 	extarrangement.setTestweek(course.getTestweek());
		 	extarrangement.setTestclassroom(course.getTestclassroom());
		 	extarrangement.setWeektime(Integer.parseInt(course.getWeektime()));
		 	extarrangement.setTestweekday(course.getTestweekday());
		 	extarrangement.setTestjieci(course.getTestjieci());
		 	extarrangement.setClasses(course.getClasses());
		 	extarrangementService.save(extarrangement);
		 }
		 return Result.OK("初始化成功!");
	 }

	/**
	 *   安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/anpai")
	public Result<String> anpai(@RequestParam(name="id",required=true) String id) throws Exception {
		Extarrangement extarrangement = extarrangementService.getById(id);
		String courseid= extarrangement.getCourseid();
		String coursename= extarrangement.getCoursename();
		String courseord= extarrangement.getCourseord();
        String testweekday= extarrangement.getTestweekday();
        String testweek= extarrangement.getTestweek();
        String testweekdaytime= extarrangement.getTestjieci();
        String classes= extarrangement.getClasses();
        String testroom= extarrangement.getTestclassroom();
        String []weekset=testweek.split("-");
		String []weekdaytimeset=testweekdaytime.split(",");
		List <String>searchclass = getclass(classes);
		int weekfirst=Integer.parseInt(weekset[0]);
		int weeklast=Integer.parseInt(weekset[1]);
		String atu="";
			int sign=0;
		String consion="";
		String concourse="";
			//判断每个班级申请时间是否有课；
		for (String jiecishenqing:weekdaytimeset)
		{for (String banjishijian:searchclass)
			{
				List<String> time= null;
				try {
					time= timetableService.selectWeek(banjishijian,testweekday,jiecishenqing);

				} catch (Exception e) {
					e.printStackTrace();
				}
				if (time!=null)
				{ //考虑之后发现形势与政策应该不会比安排时间早，所以不考虑
					for(String eveweek:time)
					{  if (!eveweek.contains(","))
					  {
						String[] range = eveweek.split("-");
						if (!(weeklast < Integer.parseInt(range[0]) || weekfirst > Integer.parseInt(range[1])))
						{sign = 1;
						 consion=banjishijian;
							try {
								concourse= timetableService.selectName(banjishijian,testweekday,jiecishenqing).get(0);
							} catch (Exception e) {
								e.printStackTrace();
							}
							break;
						}
					  }
					}
				}
			}
		}
		 String []weekdayno={"星期一","星期二","星期三","星期四","星期五","星期六","星期日"};
		 String []weekdaytimesetno={"1-2","3-4","5-6","7-8","9-10"};
		 List<String> timevas= new ArrayList();
		for(String eveweekday:weekdayno)
		{  for(String eveweekdaytime:weekdaytimesetno)
		{  int dot=0;
			for (String eveclass:searchclass)
			{  	List<String> time= new ArrayList<>();
				try {
					time = timetableService.selectWeek(eveclass,eveweekday,eveweekdaytime);
				} catch (Exception e) {
					e.printStackTrace();
				}
				if (time!=null)
				{
					System.out.println(eveclass+eveweekday+eveweekdaytime);//考虑之后发现形势与政策应该不会比安排时间早，所以不考虑
					for(String eveweek:time)
					{ if (!eveweek.contains(","))
					{
						String[] range=eveweek.split("-");
						if (!(weeklast < Integer.parseInt(range[0]) || weekfirst > Integer.parseInt(range[1])))
							dot = 1;
					}
					}
				}
			}
			System.out.println(dot);
			if (dot==0)
				timevas.add(eveweekday+","+eveweekdaytime);
		}
		}
		//申请时间不冲突
			if (sign==0)
			{   if (extarrangement.getWeektime()==2)
				atu=testweekday+","+weekdaytimeset[0];
				if (extarrangement.getWeektime()==4)
				atu=testweekday+","+weekdaytimeset[0]+"+"+testweekday+","+weekdaytimeset[1];
			}
			//冲突
			if (sign==1)
			{
				if (extarrangement.getWeektime()==2)
					atu=timevas.get(0);
				if (extarrangement.getWeektime()==4)
					atu=timevas.get(0)+"+"+timevas.get(1);

			}
			//判断实验室是否有占用，先可用后更新，避免部分更新总体不可用
        //周学时为2
        if(extarrangement.getWeektime()==2)
		{   int vas=0;
			String[] set = atu.split(",");
			Extroom extroom = new Extroom();
			for (int j = weekfirst; j < weeklast + 1; j++) {
				try {
					extroom = extroomService.selectByShiyanshiWeek(testroom, j);
				} catch (Exception e) {
					e.printStackTrace();
				}
				if (!shiyanshikeyong(extroom, set[0], set[1]))
					vas = 1; }
			if (vas==1&&sign==1)
			{ for (int h=1;h<timevas.size();h++)
			   {    int judge=0;
			   	   String[] setsecong = timevas.get(h).split(",");
				   Extroom room = new Extroom();
				   for (int j = weekfirst; j < weeklast + 1; j++) {
					   try {
						   room = extroomService.selectByShiyanshiWeek(testroom, j);
					   } catch (Exception e) {
						   e.printStackTrace();
					   }
					   if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
						   judge=1; }
				   if (judge==0)
				   { int err=0;
					   for (int j = weekfirst; j < weeklast + 1; j++) {
						   try {
							   room = extroomService.selectByShiyanshiWeek(testroom, j);
						   } catch (Exception e) {
							   e.printStackTrace();
						   }
						   if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
							   err=1; }
					   if (err==0){
				   	atu=timevas.get(h);
				   	break; }}
			   }
			}
            if (vas==1&&sign==0)
            { for (int h=0;h<timevas.size();h++)
             {    int judge=0;
                String[] setsecong = timevas.get(h).split(",");
                Extroom room = new Extroom();
                for (int j = weekfirst; j < weeklast + 1; j++) {
                    try {
                        room = extroomService.selectByShiyanshiWeek(testroom, j);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                    if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
                        judge=1; }
                if (judge==0)
                { int err=0;
                    for (int j = weekfirst; j < weeklast + 1; j++) {
                        try {
                            room = extroomService.selectByShiyanshiWeek(testroom, j);
                        } catch (Exception e) {
                            e.printStackTrace();
                        }
                        if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
                            err=1; }
                    if (err==0){
                        atu=timevas.get(h);
                        break; }}
             }
            }
            if (vas==0){
                Extroom room = new Extroom();
                for (int j = weekfirst; j < weeklast + 1; j++) {
                    try {
                        room = extroomService.selectByShiyanshiWeek(testroom, j);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                    if (!shiyanshikeyongupdate(room, set[0], set[1]))
                        return Result.error("发生错误");
                          }
                       }
		}

		if(extarrangement.getWeektime()==4)
		{  List<String> arranhelist= new ArrayList();
			int vas=0;
			String []arr=atu.split("\\+");
			for (String evearr:arr)
			{ String[] set = evearr.split(",");
			  Extroom extroom = new Extroom();
			  for (int j = weekfirst; j < weeklast + 1; j++) {
				try {
					extroom = extroomService.selectByShiyanshiWeek(testroom, j);
				} catch (Exception e) {
					e.printStackTrace();
				}
				if (!shiyanshikeyong(extroom, set[0], set[1]))
					vas = 1; }
			 if (vas==0)
			  { int err=0;
			  	for (int j = weekfirst; j < weeklast + 1; j++) {
				  try {
					  extroom = extroomService.selectByShiyanshiWeek(testroom, j);
				  } catch (Exception e) {
					  e.printStackTrace();
				  }
				  if (!shiyanshikeyongupdate(extroom, set[0], set[1]))
					  err = 1; }
			  	if (err==0)
			  	arranhelist.add(evearr);}
			}
			if (arranhelist.size()==1&&sign==0)
			{ for (int h=0;h<timevas.size();h++)
			  {    int judge=0;
				String[] setsecong = timevas.get(h).split(",");
				Extroom room = new Extroom();
				for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						room = extroomService.selectByShiyanshiWeek(testroom, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
						judge=1; }
				if (judge==0)
				{   int err=0;
					for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						room = extroomService.selectByShiyanshiWeek(testroom, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
						err=1; }
					if (err==0)
					{ arranhelist.add(timevas.get(h));
					break; }}
			  }
			}

			if (arranhelist.size()==0&&sign==0)
			{ for (int h=0;h<timevas.size();h++)
			  {    int judge=0;
				String[] setsecong = timevas.get(h).split(",");
				Extroom room = new Extroom();
				for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						room = extroomService.selectByShiyanshiWeek(testroom, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
						judge=1; }
				if (judge==0)
				{  int err=0;
					for (int j = weekfirst; j < weeklast + 1; j++) {
						try {
							room = extroomService.selectByShiyanshiWeek(testroom, j);
						} catch (Exception e) {
							e.printStackTrace();
						}
						if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
							err=1; }
					if (err==0){
				   arranhelist.add(timevas.get(h));
				if (arranhelist.size()==2)
					break;}}
			  }
			}
			if (arranhelist.size()==1&&sign==1)
			{ for (int h=2;h<timevas.size();h++)
			  {    int judge=0;
				String[] setsecong = timevas.get(h).split(",");
				Extroom room = new Extroom();
				for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						room = extroomService.selectByShiyanshiWeek(testroom, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
						judge=1; }
				if (judge==0){int err=0;
					for (int j = weekfirst; j < weeklast + 1; j++) {
						try {
							room = extroomService.selectByShiyanshiWeek(testroom, j);
						} catch (Exception e) {
							e.printStackTrace();
						}
						if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
							err=1; }
					if (err==0){
					arranhelist.add(timevas.get(h));
				if (arranhelist.size()==2)
					break;
			  }}}
			}

			if (arranhelist.size()==0&&sign==1)
			{ for (int h=2;h<timevas.size();h++)
			  {    int judge=0;
				String[] setsecong = timevas.get(h).split(",");
				Extroom room = new Extroom();
				for (int j = weekfirst; j < weeklast + 1; j++) {
					try {
						room = extroomService.selectByShiyanshiWeek(testroom, j);
					} catch (Exception e) {
						e.printStackTrace();
					}
					if (!shiyanshikeyong(room, setsecong[0], setsecong[1]))
						judge=1; }
				if (judge==0){int err=0;
					for (int j = weekfirst; j < weeklast + 1; j++) {
						try {
							room = extroomService.selectByShiyanshiWeek(testroom, j);
						} catch (Exception e) {
							e.printStackTrace();
						}
						if (!shiyanshikeyongupdate(room, setsecong[0], setsecong[1]))
							err=1; }
					if (err==0){
					arranhelist.add(timevas.get(h));
				if (arranhelist.size()==2)
					break;
			  }}}
			}
			atu=arranhelist.get(0)+"+"+arranhelist.get(1);
		}
		//加入课表
			String []arr=atu.split("\\+");
			for (String evearr:arr) {
				String[] set = evearr.split(",");
				for(String banjieve:searchclass) {
					Timetable xinzengshiyanshi = new Timetable();
					List<Timetable> natural=timetableService.selectGrade(banjieve,courseid,courseord,coursename);
					xinzengshiyanshi.setGrade(natural.get(0).getGrade());
					xinzengshiyanshi.setAttribute(natural.get(0).getAttribute());
					xinzengshiyanshi.setMajor(natural.get(0).getMajor());
					xinzengshiyanshi.setTeacherid(extarrangement.getTestteacherid());
					xinzengshiyanshi.setTeacher(extarrangement.getTestteacher());
					xinzengshiyanshi.setWeekday(set[0]);
					xinzengshiyanshi.setWeekdaytime(set[1]);
					xinzengshiyanshi.setCourseid(courseid);
					xinzengshiyanshi.setCoursename(coursename);
					xinzengshiyanshi.setNature("实验课");
					xinzengshiyanshi.setCourseord(courseord);
					xinzengshiyanshi.setClasses(banjieve);
					xinzengshiyanshi.setClassroom(testroom);
					xinzengshiyanshi.setWeektime(testweek);
					timetableService.save(xinzengshiyanshi);}
			}
		  if (sign==0){
				extarrangement.setAnpai("已安排");
				extarrangement.setAnpaishijian(atu);
				extarrangementService.updateById(extarrangement);
		       return Result.OK("安排成功");}
		  else {
			  extarrangement.setAnpai("已安排");
			    extarrangement.setAnpaishijian(atu);
				extarrangementService.updateById(extarrangement);
				return Result.OK("与"+consion+concourse+"冲突,已更换时间");
				}
	}


		/**
	 *   取消安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/cancelanpai")
	public Result<String> cancelanpai( @RequestParam(name="id",required=true) String id) throws Exception {
		Extarrangement extarrangement = extarrangementService.getById(id);
		String courseid= extarrangement.getCourseid();
		String coursename= extarrangement.getCoursename();
		String courseord= extarrangement.getCourseord();
		String testweek= extarrangement.getTestweek();
		String testweekdaytime= extarrangement.getTestjieci();
		String classes= extarrangement.getClasses();
		String testroom= extarrangement.getTestclassroom();
		String arrtime= extarrangement.getAnpaishijian();
		String []week=testweek.split("-");
		List <String>searchclass = getclass(classes);
		int weekfirst=Integer.parseInt(week[0]);
		int weeklast=Integer.parseInt(week[1]);
		if (extarrangement.getAnpai() == null)
			return Result.error("未安排");
		if (extarrangement.getAnpai() != null && (!extarrangement.getAnpai().equals("已安排")))
			return Result.error("未安排");
		else
		{
			if (extarrangement.getQueren() != null && extarrangement.getQueren().equals("已确认"))
				return Result.error("已确认，不能取消");
			else
			{   int cancel = 0;
				int roomcancel=0;
				String []canceltime=arrtime.split("\\+");
				for (String cancelweekday:canceltime)
				{  String []set=cancelweekday.split(",");
				   for (int i = weekfirst; i < weeklast + 1; i++)
				   { Extroom extroom = extroomService.selectByShiyanshiWeek(testroom, i);
					if (shiyanshicancelupdate(extroom, set[0],set[1]))
						roomcancel = 1;}
				   if (roomcancel == 1)
				   { for(String eveclass : searchclass)
				     {
						 timetableService.deleteByShiyanke(eveclass,set[0],set[1],courseid,courseord,coursename);}
					  cancel=1;
				   }
				}
			  if(cancel==1)
			  { extarrangement.setAnpai("");
			  	extarrangement.setAnpaishijian("");
			  	extarrangementService.updateById(extarrangement);
			  	return Result.OK("取消成功");}
			  else
				return Result.error("取消失败");
		     }
	        }
	}
	/**
	 *   撤销安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/revokeanpai")
	public Result<String> revokeanpai( @RequestParam(name="id",required=true) String id) throws Exception {
		Extarrangement extarrangement = extarrangementService.getById(id);
		if (extarrangement.getAnpai() == null || !extarrangement.getAnpai().equals("已安排"))
			return Result.error("未安排");
		else {
			if (extarrangement.getQueren() != null && extarrangement.getQueren().equals("已确认"))
				return Result.error("已确认");
			else {
				extarrangement.setTongzhi("");
				extarrangementService.updateById(extarrangement);
				return Result.OK("消息反馈成功");
			}

		}
	}

	/**
	 *   确认安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/commitanpai")
	public Result<String> commitanpai( @RequestParam(name="id",required=true) String id) throws Exception {
		Extarrangement extarrangement = extarrangementService.getById(id);
		if (extarrangement.getAnpai() == null || !extarrangement.getAnpai().equals("已安排"))
			return Result.error("未安排");
		else {
			if (extarrangement.getQueren() != null && extarrangement.getQueren().equals("已确认"))
				return Result.error("已确认");
			else {
				extarrangement.setQueren("已确认");
				extarrangementService.updateById(extarrangement);
				return Result.OK("确认成功");
			}

		}
	}

	/**
	 *   通知安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/tongzhianpai")
	public Result<String> tongzhianpai( @RequestParam(name="id",required=true) String id){
		Extarrangement extarrangement = extarrangementService.getById(id);
		extarrangementService.relationAct(id);
		if (extarrangement.getAnpai() == null || !extarrangement.getAnpai().equals("已安排"))
			return Result.error("未安排");
		else
		{ extarrangement.setTongzhi("已通知");
		  extarrangementService.updateById(extarrangement);
			return Result.OK("确认成功");
		}
	}


	/**
	 *   发布安排
	 *
	 * @param id
	 * @return
	 */

	@GetMapping(value = "/fabuanpai")
	public Result<String> fabuanpai( @RequestParam(name="id",required=true) String id) throws Exception {
		Extarrangement extarrangement = extarrangementService.getById(id);
		if (extarrangement.getAnpai() == null || !extarrangement.getAnpai().equals("已安排"))
			return Result.error("未安排");
		else {
			if (extarrangement.getQueren() == null ||! extarrangement.getQueren().equals("已确认"))
				return Result.error("任课教师还未确认");
			else {
				extarrangement.setFabu("已发布");
				Extcourse extcourse =new Extcourse();
				extcourse.setClasses(extarrangement.getClasses());
				extcourse.setCourseid(extarrangement.getCourseid());
				extcourse.setCoursename(extarrangement.getCoursename());
				extcourse.setCourseord(extarrangement.getCourseord());
				extcourse.setTerm(extarrangement.getTerm());
				extcourse.setCoursetype("实验课");
				extcourse.setStudentid(extarrangement.getZhujiao());
				extcourse.setTeacher(extarrangement.getTeacher());
				extcourse.setTeachtype(extarrangement.getType());
				extcourse.setTestclassroom(extarrangement.getTestclassroom());
				extcourse.setTestteacherid(extarrangement.getTestteacherid());
				extcourse.setTestteacher(extarrangement.getTestteacher());
				extcourse.setTesttime(extarrangement.getAnpaishijian());
				extcourse.setTestweek(extarrangement.getTestweek());
				extarrangementService.updateById(extarrangement);
				extcourseService.save(extcourse);
            return Result.OK("发布成功");
			}

		}
	}

	/**
	 *  批量删除
	 *
	 * @param ids
	 * @return
	 */
	@AutoLog(value = "实验申请排课-批量删除")
	@ApiOperation(value="实验申请排课-批量删除", notes="实验申请排课-批量删除")
	@DeleteMapping(value = "/deleteBatch")
	public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
		this.extarrangementService.removeByIds(Arrays.asList(ids.split(",")));
		return Result.OK("批量删除成功!");
	}

	/**
	 * 通过id查询
	 *
	 * @param id
	 * @return
	 */
	//@AutoLog(value = "实验申请排课-通过id查询")
	@ApiOperation(value="实验申请排课-通过id查询", notes="实验申请排课-通过id查询")
	@GetMapping(value = "/queryById")
	public Result<Extarrangement> queryById(@RequestParam(name="id",required=true) String id) {
		Extarrangement extarrangement = extarrangementService.getById(id);
		if(extarrangement ==null) {
			return Result.error("未找到对应数据",null);
		}
		return Result.OK(extarrangement);
	}

    /**
    * 导出excel
    *
    * @param request
    * @param extarrangement
    */
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, Extarrangement extarrangement) {
        return super.exportXls(request, extarrangement, Extarrangement.class, "实验申请排课");
    }

    /**
      * 通过excel导入数据
    *
    * @param request
    * @param response
    * @return
    */
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        return super.importExcel(request, response, Extarrangement.class);
    }

	public List<String> getclass(String classes){
		String []classesset=classes.split(",");//大数据19.[1-2]班,软件19.[1-8]班,网安工学19班,通过“,”分割
		String [] classes_spilt;//通过“-”分割，
		String []search;
		List <String>classessearch = new ArrayList();
		String join;
		String anti="";
		String firstclass="";
		String lastclass="";
		int first;
		int last;
		for (String eveclass : classesset)
		{
			if (eveclass.contains("-"))
			{
				classes_spilt = eveclass.split("-");
				for (String classfirst : classes_spilt)
				{
					if (classfirst.contains("["))
					{
						search = classfirst.split("\\[");
						join = search[0] + search[1];
						anti=search[0];
						firstclass=search[1];
					}
				}
				lastclass=classes_spilt[1].substring(0,1);
				first=Integer.parseInt(firstclass);
				last=Integer.parseInt(lastclass);
				for (int i=first;i<last+1;i++)
				{ classessearch.add(anti+i); }

			} else {
				classessearch.add(eveclass);
			}
		}
		return classessearch;

	}

	public boolean shiyanshicancelupdate(Extroom extroom, String weekday, String weekdaytime){
		int judge=0;
		if(weekday.equals("星期一")&&weekdaytime.equals("1-2"))
		{extroom.setMonfir("闲");
			judge=1;}
		if(weekday.equals("星期一")&&weekdaytime.equals("3-4"))
		{extroom.setMonsec("闲");
			judge=1;}
		if(weekday.equals("星期一")&&weekdaytime.equals("5-6"))
		{extroom.setMonthi("闲");
			judge=1;}
		if(weekday.equals("星期一")&&weekdaytime.equals("7-8"))
		{extroom.setMonthr("闲");
			judge=1;}
		if(weekday.equals("星期一")&&weekdaytime.equals("9-10"))
		{extroom.setMonfri("闲");
			judge=1;}
		if(weekday.equals("星期二")&&weekdaytime.equals("1-2"))
		{extroom.setTuefir("闲");
			judge=1;}
		if(weekday.equals("星期二")&&weekdaytime.equals("3-4"))
		{extroom.setTuesec("闲");
			judge=1;}
		if(weekday.equals("星期二")&&weekdaytime.equals("5-6"))
		{extroom.setTuethi("闲");
			judge=1;}
		if(weekday.equals("星期二")&&weekdaytime.equals("7-8"))
		{extroom.setTuethr("闲");
			judge=1;}
		if(weekday.equals("星期二")&&weekdaytime.equals("9-10"))
		{extroom.setTuefri("闲");
			judge=1;}
		if(weekday.equals("星期三")&&weekdaytime.equals("1-2"))
		{	extroom.setWenfir("闲");
			judge=1;}
		if(weekday.equals("星期三")&&weekdaytime.equals("3-4"))
		{	extroom.setWensec("闲");
			judge=1;}
		if(weekday.equals("星期三")&&weekdaytime.equals("5-6"))
		{	extroom.setWenthi("闲");
			judge=1;}
		if(weekday.equals("星期三")&&weekdaytime.equals("7-8"))
		{extroom.setWenthr("闲");
			judge=1;}
		if(weekday.equals("星期三")&&weekdaytime.equals("9-10"))
		{extroom.setWenfri("闲");
			judge=1;}
		if(weekday.equals("星期四")&&weekdaytime.equals("1-2"))
		{ extroom.setThufir("闲");
			judge=1;}
		if(weekday.equals("星期四")&&weekdaytime.equals("3-4"))
		{extroom.setThusec("闲");
			judge=1;}
		if(weekday.equals("星期四")&&weekdaytime.equals("5-6"))
		{extroom.setThuthi("闲");
			judge=1;}
		if(weekday.equals("星期四")&&weekdaytime.equals("7-8"))
		{extroom.setThuthr("闲");
			judge=1;}
		if(weekday.equals("星期四")&&weekdaytime.equals("9-10"))
		{extroom.setThufri("闲");
			judge=1;}
		if(weekday.equals("星期五")&&weekdaytime.equals("1-2"))
		{extroom.setFrifir("闲");
			judge=1;}
		if(weekday.equals("星期五")&&weekdaytime.equals("3-4"))
		{	extroom.setFrisec("闲");
			judge=1;}
		if(weekday.equals("星期五")&&weekdaytime.equals("5-6"))
		{extroom.setFrithi("闲");
			judge=1;}
		if(weekday.equals("星期五")&&weekdaytime.equals("7-8"))
		{	extroom.setFrithr("闲");
			judge=1;}
		if(weekday.equals("星期五")&&weekdaytime.equals("9-10"))
		{extroom.setFrifri("闲");
			judge=1;}
		if(weekday.equals("星期六")&&weekdaytime.equals("1-2"))
		{extroom.setSatfir("闲");
			judge=1;}
		if(weekday.equals("星期六")&&weekdaytime.equals("3-4"))
		{	extroom.setSatsec("闲");
			judge=1;}
		if(weekday.equals("星期六")&&weekdaytime.equals("5-6"))
		{extroom.setSatthi("闲");
			judge=1;}
		if(weekday.equals("星期六")&&weekdaytime.equals("7-8"))
		{	extroom.setSatthr("闲");
			judge=1;}
		if(weekday.equals("星期六")&&weekdaytime.equals("9-10"))
		{extroom.setSatfri("闲");
			judge=1;}
		if(weekday.equals("星期日")&&weekdaytime.equals("1-2"))
		{	extroom.setSunfir("闲");
			judge=1;}
		if(weekday.equals("星期日")&&weekdaytime.equals("3-4"))
		{	extroom.setSunsec("闲");
			judge=1;}
		if(weekday.equals("星期日")&&weekdaytime.equals("5-6"))
		{extroom.setSunthi("闲");
			judge=1;}
		if(weekday.equals("星期日")&&weekdaytime.equals("7-8"))
		{	extroom.setSunthr("闲");
			judge=1;}
		if(weekday.equals("星期日")&&weekdaytime.equals("9-10"))
		{	extroom.setSunfri("闲");
			judge=1;}
		if(judge==1)
		{   extroomService.updateById(extroom);
			return true;}
		else
			return false;
	}


	public boolean shiyanshikeyong(Extroom extroom, String weekday, String weekdaytime){
		int judge=0;
		if(weekday.equals("星期一")&&weekdaytime.equals("1-2")&& extroom.getMonfir()!=null&&extroom.getMonfir().equals("闲"))
			judge=1;
		if(weekday.equals("星期一")&&weekdaytime.equals("3-4")&& extroom.getMonsec()!=null&& extroom.getMonsec().equals("闲"))
			judge=1;
		if(weekday.equals("星期一")&&weekdaytime.equals("5-6")&& extroom.getMonthi()!=null&& extroom.getMonthi().equals("闲"))
			judge=1;
		if(weekday.equals("星期一")&&weekdaytime.equals("7-8")&& extroom.getMonthr()!=null&& extroom.getMonthr().equals("闲"))
			judge=1;
		if(weekday.equals("星期一")&&weekdaytime.equals("9-10")&& extroom.getMonfri()!=null&& extroom.getMonfri().equals("闲"))
			judge=1;
		if(weekday.equals("星期二")&&weekdaytime.equals("1-2")&& extroom.getTuefir()!=null&& extroom.getTuefir().equals("闲"))
			judge=1;
		if(weekday.equals("星期二")&&weekdaytime.equals("3-4")&& extroom.getTuesec()!=null&& extroom.getTuesec().equals("闲"))
			judge=1;
		if(weekday.equals("星期二")&&weekdaytime.equals("5-6")&& extroom.getTuethi()!=null&& extroom.getTuethi().equals("闲"))
			judge=1;
		if(weekday.equals("星期二")&&weekdaytime.equals("7-8")&& extroom.getTuethr()!=null&& extroom.getTuethr().equals("闲"))
			judge=1;
		if(weekday.equals("星期二")&&weekdaytime.equals("9-10")&& extroom.getTuefri()!=null&& extroom.getTuefri().equals("闲"))
			judge=1;
		if(weekday.equals("星期三")&&weekdaytime.equals("1-2")&& extroom.getWenfir()!=null&& extroom.getWenfir().equals("闲"))
			judge=1;
		if(weekday.equals("星期三")&&weekdaytime.equals("3-4")&& extroom.getWensec()!=null&& extroom.getWensec().equals("闲"))
			judge=1;
		if(weekday.equals("星期三")&&weekdaytime.equals("5-6")&& extroom.getWenthi()!=null&& extroom.getWenthi().equals("闲"))
			judge=1;
		if(weekday.equals("星期三")&&weekdaytime.equals("7-8")&& extroom.getWenthr()!=null&& extroom.getWenthr().equals("闲"))
			judge=1;
		if(weekday.equals("星期三")&&weekdaytime.equals("9-10")&& extroom.getWenfri()!=null&& extroom.getWenfri().equals("闲"))
			judge=1;
		if(weekday.equals("星期四")&&weekdaytime.equals("1-2")&& extroom.getThufir()!=null&& extroom.getThufir().equals("闲"))
			judge=1;
		if(weekday.equals("星期四")&&weekdaytime.equals("3-4")&& extroom.getThusec()!=null&& extroom.getThusec().equals("闲"))
			judge=1;
		if(weekday.equals("星期四")&&weekdaytime.equals("5-6")&& extroom.getThuthi()!=null&& extroom.getThuthi().equals("闲"))
			judge=1;
		if(weekday.equals("星期四")&&weekdaytime.equals("7-8")&& extroom.getThuthr()!=null&& extroom.getThuthr().equals("闲"))
			judge=1;
		if(weekday.equals("星期四")&&weekdaytime.equals("9-10")&& extroom.getThufri()!=null&&extroom.getThufri().equals("闲"))
			judge=1;
		if(weekday.equals("星期五")&&weekdaytime.equals("1-2")&& extroom.getFrifir()!=null &&extroom.getFrifir().equals("闲"))
			judge=1;
		if(weekday.equals("星期五")&&weekdaytime.equals("3-4")&& extroom.getFrisec()!=null&& extroom.getFrisec().equals("闲"))
			judge=1;
		if(weekday.equals("星期五")&&weekdaytime.equals("5-6")&& extroom.getFrithi()!=null&& extroom.getFrithi().equals("闲"))
			judge=1;
		if(weekday.equals("星期五")&&weekdaytime.equals("7-8")&& extroom.getFrithr()!=null&& extroom.getFrithr().equals("闲"))
			judge=1;
		if(weekday.equals("星期五")&&weekdaytime.equals("9-10")&& extroom.getFrifri()!=null&& extroom.getFrifri().equals("闲"))
			judge=1;
		if(weekday.equals("星期六")&&weekdaytime.equals("1-2")&& extroom.getSatfir()!=null&& extroom.getSatfir().equals("闲"))
			judge=1;
		if(weekday.equals("星期六")&&weekdaytime.equals("3-4")&& extroom.getSatsec()!=null&& extroom.getSatsec().equals("闲"))
			judge=1;
		if(weekday.equals("星期六")&&weekdaytime.equals("5-6")&& extroom.getSatthi()!=null&& extroom.getSatthi().equals("闲"))
			judge=1;
		if(weekday.equals("星期六")&&weekdaytime.equals("7-8")&& extroom.getSatthr()!=null&& extroom.getSatthr().equals("闲"))
			judge=1;
		if(weekday.equals("星期六")&&weekdaytime.equals("9-10")&& extroom.getSatfri()!=null&& extroom.getSatfri().equals("闲"))
			judge=1;
		if(weekday.equals("星期日")&&weekdaytime.equals("1-2")&& extroom.getSunfir()!=null&& extroom.getSunfir().equals("闲"))
			judge=1;
		if(weekday.equals("星期日")&&weekdaytime.equals("3-4")&& extroom.getSunsec()!=null&& extroom.getSunsec().equals("闲"))
			judge=1;
		if(weekday.equals("星期日")&&weekdaytime.equals("5-6")&& extroom.getSunthi()!=null&& extroom.getSunthi().equals("闲"))
			judge=1;
		if(weekday.equals("星期日")&&weekdaytime.equals("7-8")&& extroom.getSunthr()!=null&&extroom.getSunthr().equals("闲"))
			judge=1;
		if(weekday.equals("星期日")&&weekdaytime.equals("9-10")&& extroom.getSunfri()!=null&& extroom.getSunfri().equals("闲"))
			judge=1;
		if(judge==1)
			return true;
		else
			return false;
	}



	public boolean shiyanshikeyongupdate(Extroom extroom, String weekday, String weekdaytime){
		int judge=0;
		if(weekday.equals("星期一")&&weekdaytime.equals("1-2")&& extroom.getMonfir()!=null&&extroom.getMonfir().equals("闲"))
		{   judge=1;
			extroom.setMonfir("占");}
		if(weekday.equals("星期一")&&weekdaytime.equals("3-4")&& extroom.getMonsec()!=null&& extroom.getMonsec().equals("闲"))
		{	judge=1;
			extroom.setMonsec("占");}
		if(weekday.equals("星期一")&&weekdaytime.equals("5-6")&& extroom.getMonthi()!=null&& extroom.getMonthi().equals("闲"))
		{   judge=1;
			extroom.setMonthi("占");}
		if(weekday.equals("星期一")&&weekdaytime.equals("7-8")&& extroom.getMonthr()!=null&& extroom.getMonthr().equals("闲"))
		{	judge=1;
			extroom.setMonthr("占");}
		if(weekday.equals("星期一")&&weekdaytime.equals("9-10")&& extroom.getMonfri()!=null&& extroom.getMonfri().equals("闲"))
		{	judge=1;
			extroom.setMonfri("占");}
		if(weekday.equals("星期二")&&weekdaytime.equals("1-2")&& extroom.getTuefir()!=null&& extroom.getTuefir().equals("闲"))
		{	judge=1;
			extroom.setTuefir("占");}
		if(weekday.equals("星期二")&&weekdaytime.equals("3-4")&& extroom.getTuesec()!=null&& extroom.getTuesec().equals("闲"))
		{	judge=1;
			extroom.setTuesec("占");}
		if(weekday.equals("星期二")&&weekdaytime.equals("5-6")&& extroom.getTuethi()!=null&& extroom.getTuethi().equals("闲"))
		{	judge=1;
			extroom.setTuethi("占");}
		if(weekday.equals("星期二")&&weekdaytime.equals("7-8")&& extroom.getTuethr()!=null&& extroom.getTuethr().equals("闲"))
		{	judge=1;
			extroom.setTuethr("占");}
		if(weekday.equals("星期二")&&weekdaytime.equals("9-10")&& extroom.getTuefri()!=null&& extroom.getTuefri().equals("闲"))
		{	judge=1;
			extroom.setTuefri("占");}
		if(weekday.equals("星期三")&&weekdaytime.equals("1-2")&& extroom.getWenfir()!=null&& extroom.getWenfir().equals("闲"))
		{	judge=1;
			extroom.setWenfir("占");}
		if(weekday.equals("星期三")&&weekdaytime.equals("3-4")&& extroom.getWensec()!=null&& extroom.getWensec().equals("闲"))
		{	judge=1;
			extroom.setWensec("占");}
		if(weekday.equals("星期三")&&weekdaytime.equals("5-6")&& extroom.getWenthi()!=null&& extroom.getWenthi().equals("闲"))
		{	judge=1;
			extroom.setWenthi("占");}
		if(weekday.equals("星期三")&&weekdaytime.equals("7-8")&& extroom.getWenthr()!=null&& extroom.getWenthr().equals("闲"))
		{	judge=1;
			extroom.setWenthr("占");}
		if(weekday.equals("星期三")&&weekdaytime.equals("9-10")&& extroom.getWenfri()!=null&& extroom.getWenfri().equals("闲"))
		{	judge=1;
			extroom.setWenfri("占");}
		if(weekday.equals("星期四")&&weekdaytime.equals("1-2")&& extroom.getThufir()!=null&& extroom.getThufir().equals("闲"))
		{	judge=1;
			extroom.setThufir("占");}
		if(weekday.equals("星期四")&&weekdaytime.equals("3-4")&& extroom.getThusec()!=null&& extroom.getThusec().equals("闲"))
		{	judge=1;
			extroom.setThusec("占");}
		if(weekday.equals("星期四")&&weekdaytime.equals("5-6")&& extroom.getThuthi()!=null&& extroom.getThuthi().equals("闲"))
		{	judge=1;
			extroom.setThuthi("占");}
		if(weekday.equals("星期四")&&weekdaytime.equals("7-8")&& extroom.getThuthr()!=null&& extroom.getThuthr().equals("闲"))
		{	judge=1;
			extroom.setThuthr("占");}
		if(weekday.equals("星期四")&&weekdaytime.equals("9-10")&& extroom.getThufri()!=null&&extroom.getThufri().equals("闲"))
		{	judge=1;
			extroom.setThufri("占");}
		if(weekday.equals("星期五")&&weekdaytime.equals("1-2")&& extroom.getFrifir()!=null &&extroom.getFrifir().equals("闲"))
		{	judge=1;
			extroom.setFrifir("占");}
		if(weekday.equals("星期五")&&weekdaytime.equals("3-4")&& extroom.getFrisec()!=null&& extroom.getFrisec().equals("闲"))
		{	judge=1;
			extroom.setFrisec("占");}
		if(weekday.equals("星期五")&&weekdaytime.equals("5-6")&& extroom.getFrithi()!=null&& extroom.getFrithi().equals("闲"))
		{	judge=1;
			extroom.setFrithi("占");}
		if(weekday.equals("星期五")&&weekdaytime.equals("7-8")&& extroom.getFrithr()!=null&& extroom.getFrithr().equals("闲"))
		{	judge=1;
			extroom.setFrithr("占");}
		if(weekday.equals("星期五")&&weekdaytime.equals("9-10")&& extroom.getFrifri()!=null&& extroom.getFrifri().equals("闲"))
		{	judge=1;
			extroom.setFrifri("占");}
		if(weekday.equals("星期六")&&weekdaytime.equals("1-2")&& extroom.getSatfir()!=null&& extroom.getSatfir().equals("闲"))
		{	judge=1;
			extroom.setSatfir("占");}
		if(weekday.equals("星期六")&&weekdaytime.equals("3-4")&& extroom.getSatsec()!=null&& extroom.getSatsec().equals("闲"))
		{	judge=1;
			extroom.setSatsec("占");}
		if(weekday.equals("星期六")&&weekdaytime.equals("5-6")&& extroom.getSatthi()!=null&& extroom.getSatthi().equals("闲"))
		{	judge=1;
			extroom.setSatthi("占");}
		if(weekday.equals("星期六")&&weekdaytime.equals("7-8")&& extroom.getSatthr()!=null&& extroom.getSatthr().equals("闲"))
		{	judge=1;
			extroom.setSatthr("占");}
		if(weekday.equals("星期六")&&weekdaytime.equals("9-10")&& extroom.getSatfri()!=null&& extroom.getSatfri().equals("闲"))
		{	judge=1;
			extroom.setSatfri("占");}
		if(weekday.equals("星期日")&&weekdaytime.equals("1-2")&& extroom.getSunfir()!=null&& extroom.getSunfir().equals("闲"))
		{	judge=1;
			extroom.setSunfir("占");}
		if(weekday.equals("星期日")&&weekdaytime.equals("3-4")&& extroom.getSunsec()!=null&& extroom.getSunsec().equals("闲"))
		{	judge=1;
			extroom.setSunsec("占");}
		if(weekday.equals("星期日")&&weekdaytime.equals("5-6")&& extroom.getSunthi()!=null&& extroom.getSunthi().equals("闲"))
		{	judge=1;
			extroom.setSunthi("占");}
		if(weekday.equals("星期日")&&weekdaytime.equals("7-8")&& extroom.getSunthr()!=null&&extroom.getSunthr().equals("闲"))
		{	judge=1;
			extroom.setSunthr("占");}
		if(weekday.equals("星期日")&&weekdaytime.equals("9-10")&& extroom.getSunfri()!=null&& extroom.getSunfri().equals("闲"))
		{	judge=1;
			extroom.setSunfri("占");}
		if(judge==1)
		{   extroomService.updateById(extroom);
			return true;}
		else
			return false;
	}
}