学生报到系统 毕业设计

package com.soft.service.impl; import cn.afterturn.easypoi.excel.ExcelImportUtil; import cn.afterturn.easypoi.excel.entity.ExportParams; import cn.afterturn.easypoi.excel.entity.ImportParams; import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult; import cn.afterturn.easypoi.exception.excel.ExcelImportException; import com.alibaba.fastjson.JSONObject; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.soft.bean.DormitoryFields; import com.soft.bean.Page; import com.soft.bean.ResponseInfo; import com.soft.bean.vo.BuildingVO; import com.soft.bean.vo.RoomVO; import com.soft.bean.vo.StudentVO; import com.soft.common.util.DataValidUtil; import com.soft.common.util.ExcelUtil; import com.soft.constant.BuildingTypeConstant; import com.soft.constant.EntityStateConstant; import com.soft.constant.ResponseMessageConstant; import com.soft.entity.Dictionary; import com.soft.entity.Room; import com.soft.mapper.BuildingMapper; import com.soft.mapper.RoomMapper; import com.soft.service.*; import com.soft.service.handle.ArrangeDormitoryImportHandle; import org.apache.commons.collections4.ListUtils; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.io.File; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Map; /** * * 宿舍管理 * */ @Transactional @Service public class RoomServiceImpl implements RoomService, BaseService { @Resource private RoomMapper roomMapper; @Resource private BuildingMapper buildingMapper; @Resource private BuildingService buildingService; @Resource private StudentService studentService; @Resource private TeacherService teacherService; @Resource private ArrangeDormitoryImportHandle arrangeImportHandle; /** * 根据id查询 * * @param buildingId id * @return {id:'',name:'楼层+号码'} */ @Override public List<Map<String, Object>> selectMapById(Long buildingId) { return roomMapper.selectMapById(buildingId); } /** * 检查是不是满了,满了会把状态改成 28 已满状态 * * @param roomId id */ @Override public void checkFull(Long roomId) { Map<String,Object> room = roomMapper.selectByPrimaryKey(roomId); if (null != room) { BuildingVO building = JSONObject.parseObject(JSONObject.toJSONString(room.get("building")), BuildingVO.class); // 已使用 int usedCount = 0; // 办公楼 if (BuildingTypeConstant.OFFICE.getKey() == Integer.parseInt(building.getBuildingType().get("id").toString())) { usedCount = teacherService.selectCountByRoom(roomId); } else if (BuildingTypeConstant.DORMITORY.getKey() == Integer.parseInt(building.getBuildingType().get("id").toString())) { usedCount = studentService.selectCountByRoom(roomId); } else { // TODO 教室 } // 类型 Dictionary type = JSONObject.parseObject(JSONObject.toJSONString(room.get("type")), Dictionary.class); int allowCount = Integer.parseInt(type.getName()); if (usedCount >= allowCount) { roomMapper.updateState(roomId, EntityStateConstant.RoomState.FULL.getValue(), new Date()); } } } /** * 宿舍管理查询列表 * * @param floor 楼层 * @param building 楼id * @param state 状态 * @param teacherId 管理id * @param page 分页 * @return PageInfo<RoomVO> */ @Override public PageInfo<RoomVO> queryList(Integer floor, Long building, Integer state, Long teacherId, Page page) { List<Long> buildings = new ArrayList<Long>(); // 前台传来的id为空，查询此管理员所有的楼 if (DataValidUtil.isEmpty(building)) { List<Map<String, Object>> manageBuilding = buildingService.selectByTypeAndManage(teacherId); if (null == manageBuilding || manageBuilding.size() == 0) { buildings.add(-1L); } else { for (Map<String, Object> map : manageBuilding) { buildings.add(Long.valueOf(map.get("id").toString())); } } } else { buildings.add(building); } PageHelper.startPage(page.getPageNo(), page.getPageSize()); List<RoomVO> list = roomMapper.queryList(floor, buildings, state); for (RoomVO room : list) { int count = studentService.selectCountByRoom(room.getId()); if (count > 0) { room.setUsed(true); } room.setList(getBedNumList(room)); room.setFreeCount(Integer.parseInt(room.getType().get("name").toString()) - count); } return new PageInfo<RoomVO>(list); } /** * @param type 类型 * @param campus 校区 * @param building 楼 * @param page 分页 * @return PageInfo<RoomVO> */ @Override public PageInfo<RoomVO> queryListForManage(Integer type, Long campus, Long building, Page page) { List<Long> buildings = new ArrayList<>(); List<RoomVO> roomVOS; if (!DataValidUtil.isEmpty(building)) { buildings.add(building); PageHelper.startPage(page.getPageNo(), page.getPageSize()); roomVOS = roomMapper.queryList(null, buildings, null); } else { List<Map<String, Object>> list = buildingService.selectByTypeAndCampus(campus, type); if (null == list || list.size() == 0) { PageHelper.startPage(page.getPageNo(), page.getPageSize()); return new PageInfo<>(new ArrayList<>()); } for (Map<String, Object> map : list) { buildings.add(Long.valueOf(map.get("id").toString())); } PageHelper.startPage(page.getPageNo(), page.getPageSize()); roomVOS = roomMapper.queryList(null, buildings, null); } for (RoomVO roomVO : roomVOS) { int count = 0; Integer buildingType = Integer.parseInt(roomVO.getBuilding().getBuildingType().get("id").toString()); if (BuildingTypeConstant.DORMITORY.getKey() == buildingType.intValue()) { count = studentService.selectCountByRoom(roomVO.getId()); roomVO.setFreeCount(Integer.parseInt(roomVO.getType().get("name").toString()) - count); } else if (BuildingTypeConstant.OFFICE.getKey() == buildingType.intValue()) { count = teacherService.selectCountByRoom(roomVO.getId()); roomVO.setFreeCount(Integer.parseInt(roomVO.getType().get("name").toString()) - count); } else { // TODO 教室 } if (count > 0) { roomVO.setUsed(true); } } return new PageInfo<>(roomVOS); } /** * 更改状态 * * @param roomId id * @param state 状态 * @return {"code":200/500, "msg":"返回消息", "data":null} */ @Override public ResponseInfo modifyState(Long roomId, int state) { if (DataValidUtil.isEmpty(roomId)) { return this.getResult(FAIL, ERROR_PARAM); } Map<String, Object> room = roomMapper.selectByPrimaryKey(roomId); if (null == room) { return this.getResult(FAIL, ERROR_PARAM); } BuildingVO b