毕设管理系统后端代码.zip

package com.katle.design.service.impl; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.katle.design.dao.*; import com.katle.design.dto.DefenceGroupDTO; import com.katle.design.dto.IdAndNameDTO; import com.katle.design.dto.TitleIdDTO; import com.katle.design.entities.*; import com.katle.design.service.ProcessDocService; import com.katle.design.vo.*; import javafx.scene.control.ChoiceBox; import javafx.scene.control.RadioMenuItem; import javafx.scene.control.TitledPane; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.shiro.authc.UsernamePasswordToken; import org.springframework.core.task.TaskExecutor; import org.springframework.stereotype.Service; import org.springframework.transaction.support.TransactionTemplate; import sun.misc.OSEnvironment; import javax.annotation.Resource; import java.nio.file.OpenOption; import java.util.*; import static com.sun.xml.internal.ws.spi.db.BindingContextFactory.LOGGER; @Service public class ProcessDocServiceImpl implements ProcessDocService { @Resource private UserMapper userMapper; @Resource private TitlesMapper titlesMapper; @Resource private TaskFileMapper taskFileMapper; @Resource private ChooseMapper chooseMapper; @Resource private OpenDefenceMapper openDefenceMapper; @Resource private StartFileMapper startFileMapper; @Resource private MiddleFileMapper middleFileMapper; @Resource private TranslationFileMapper translationFileMapper; @Resource private LiteratureFileMapper literatureFileMapper; @Resource private OriginalFileMapper originalFileMapper; @Resource private ThesisFileMapper thesisFileMapper; @Resource private GuidanceFileMapper guidanceFileMapper; @Resource private PlanFileMapper planFileMapper; @Resource private RoleMapper roleMapper; @Resource private ScoreMapper scoreMapper; /** * 根据管理员id和相应的年份选择获取相应的任务书 * @param userId * @param schoolYear * @return */ @Override public Map<String,Object> getTaskList(int page,int limit,Long userId, String schoolYear) { User admin = userMapper.selectByPrimaryKey(userId); TaskFileExample taskFileExample = new TaskFileExample(); TaskFileExample.Criteria criteria = taskFileExample.createCriteria(); criteria.andTaskYearEqualTo(schoolYear); PageHelper.startPage(page,limit); List<TaskFile> taskFiles = taskFileMapper.selectByExample(taskFileExample); List<TaskListVO> taskList = new ArrayList<>(); for(TaskFile item:taskFiles){ TaskListVO task = new TaskListVO(); Choose choose = chooseMapper.selectByPrimaryKey(item.getUserId()); Titles titles = titlesMapper.selectByPrimaryKey(choose.getTitleId()); User teach = userMapper.selectByPrimaryKey(titles.getUserId()); String checkName; if(item.getTaskCheckman() == null){ checkName = null; }else{ User checkMan = userMapper.selectByPrimaryKey(item.getTaskCheckman()); checkName = checkMan.getUsername(); } String adminCollege = admin.getCollege(); String teachCollege = teach.getCollege(); LOGGER.info(checkName); if(item.getTaskName() != null && adminCollege.equals(teachCollege)){ task.setUserId(item.getUserId()); task.setTitleId(titles.getTitleId()); task.setTitleName(titles.getTitleName()); task.setTitleMajor(titles.getTitleMajor()); task.setTaskName(item.getTaskName()); task.setTaskPath(item.getTaskPath()); task.setTaskCheck(item.getTaskCheck()); task.setTaskOpinion(item.getTaskOpinion()); task.setTaskCheckman(checkName); task.setUsername(teach.getUsername()); task.setPosition(teach.getPosition()); taskList.add(task); } } PageInfo pageInfoTask = new PageInfo(taskFiles); Map<String,Object> map = new HashMap<>(); map.put("pageInfoTask",pageInfoTask); map.put("taskList",taskList); return map; } /** * 根据审核状态查询任务书 * @param page * @param limit * @param userId * @param schoolYear * @param * @return */ @Override public Map<String, Object> searchTaskList(int page, int limit, Long userId, String schoolYear, String taskCheck) { PageHelper.startPage(page,limit); User admin = userMapper.selectByPrimaryKey(userId); TaskFileExample taskFileExample = new TaskFileExample(); TaskFileExample.Criteria criteria = taskFileExample.createCriteria(); criteria.andTaskYearEqualTo(schoolYear); if(taskCheck.equals("待审核")){ criteria.andTaskCheckEqualTo(0); }else if(taskCheck.equals("审核通过")){ criteria.andTaskCheckEqualTo(1); }else if(taskCheck.equals("审核不通过")){ criteria.andTaskCheckEqualTo(2); } List<TaskFile> taskFiles = taskFileMapper.selectByExample(taskFileExample); List<TaskListVO> taskListVO = new ArrayList<>(); for(TaskFile item: taskFiles){ TaskListVO taskList = new TaskListVO(); Choose choose = chooseMapper.selectByPrimaryKey(item.getUserId()); Titles titles = titlesMapper.selectByPrimaryKey(choose.getTitleId()); User teach = userMapper.selectByPrimaryKey(titles.getUserId()); String checkMan; if(item.getTaskCheck() == null){ checkMan = null; }else{ User check = userMapper.selectByPrimaryKey(item.getUserId()); checkMan = check.getUsername(); } LOGGER.info(checkMan); if(admin.getCollege().equals(teach.getCollege()) && item.getTaskName() != null){ taskList.setUserId(item.getUserId()); taskList.setTitleId(titles.getTitleId()); taskList.setTitleName(titles.getTitleName()); taskList.setTitleMajor(titles.getTitleMajor()); taskList.setTaskName(item.getTaskName()); taskList.setTaskPath(item.getTaskPath()); taskList.setTaskCheck(item.getTaskCheck()); taskList.setTaskCheckman(checkMan); taskList.setTaskOpinion(item.getTaskOpinion()); taskList.setUsername(teach.getUsername()); taskList.setPosition(teach.getPosition()); taskListVO.add(taskList); } } PageInfo pageInfoSearchTask = new PageInfo(taskFiles); Map<String,Object> map = new HashMap<>(); map.put("pageInfoSearchTask",pageInfoSearchTask); map.put("taskListSearch",taskListVO); return map; } /** * 根获取的userId指定任务书的审核教师 * @param idAndNameDTO * @return */ @Override public boolean setTaskCheckMan(IdAndNameDTO idAndNameDTO) { Long[] userId = idAndNameDTO.getId(); try { for(Long id:userId){ TaskFile taskFile = taskFileMapper.selectByPrimaryKey(id); taskFile.setTaskCheckman(idAndNameDTO.getTeachId()); taskFileMapper.updateByPrimaryKeySelective(taskFile); } return true; }catch (Exception e){ return false; } } /** * 审核任务书 * @param userId * @param checkValue * @return */ @Override public boolean checkTaskFile(Long userId, String checkValue) { TaskFile ta