ScheduleController.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299
  1. package com.xjrsoft.module.schedule.controller;
  2. import cn.dev33.satoken.annotation.SaCheckPermission;
  3. import cn.dev33.satoken.stp.StpUtil;
  4. import cn.hutool.core.util.ObjectUtil;
  5. import cn.hutool.core.util.StrUtil;
  6. import com.alibaba.excel.support.ExcelTypeEnum;
  7. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  8. import com.google.gson.JsonArray;
  9. import com.google.gson.JsonObject;
  10. import com.google.gson.JsonParser;
  11. import com.xjrsoft.common.enums.DeleteMark;
  12. import com.xjrsoft.common.enums.EnabledMark;
  13. import com.xjrsoft.common.model.result.RT;
  14. import com.xjrsoft.module.base.entity.BaseSemester;
  15. import com.xjrsoft.module.base.service.IBaseSemesterService;
  16. import com.xjrsoft.module.courseTable.entity.CourseTable;
  17. import com.xjrsoft.module.courseTable.service.ICourseTableService;
  18. import com.xjrsoft.module.schedule.dto.CourseTableAdjustDto;
  19. import com.xjrsoft.module.schedule.dto.CourseTableDto;
  20. import com.xjrsoft.module.schedule.dto.CourseTablePreCheckDto;
  21. import com.xjrsoft.module.schedule.dto.ScheduleWeekExportQueryDto;
  22. import com.xjrsoft.module.schedule.entity.CourseReceiveMsg;
  23. import com.xjrsoft.module.schedule.service.ICourseReceiveMsgService;
  24. import com.xjrsoft.module.schedule.util.ScheduleUtil;
  25. import com.xjrsoft.module.schedule.vo.CourseListVo;
  26. import com.xjrsoft.module.schedule.vo.CourseTableVo;
  27. import com.xjrsoft.module.student.entity.BaseStudentSchoolRoll;
  28. import com.xjrsoft.module.student.service.IBaseStudentSchoolRollService;
  29. import com.xjrsoft.module.teacher.entity.BaseTeacher;
  30. import com.xjrsoft.module.teacher.entity.XjrUser;
  31. import com.xjrsoft.module.teacher.service.IBaseTeacherService;
  32. import com.xjrsoft.module.teacher.service.ITeacherbaseManagerService;
  33. import io.swagger.annotations.Api;
  34. import io.swagger.annotations.ApiOperation;
  35. import lombok.AllArgsConstructor;
  36. import org.springframework.http.ResponseEntity;
  37. import org.springframework.web.bind.annotation.GetMapping;
  38. import org.springframework.web.bind.annotation.PostMapping;
  39. import org.springframework.web.bind.annotation.RequestBody;
  40. import org.springframework.web.bind.annotation.RequestMapping;
  41. import org.springframework.web.bind.annotation.RequestParam;
  42. import org.springframework.web.bind.annotation.RestController;
  43. import javax.validation.Valid;
  44. import java.io.ByteArrayOutputStream;
  45. import java.time.DayOfWeek;
  46. import java.time.Duration;
  47. import java.time.LocalDateTime;
  48. import java.time.ZoneId;
  49. import java.time.format.DateTimeFormatter;
  50. import java.util.Date;
  51. import java.util.List;
  52. /**
  53. * @title: 课表
  54. * @Author dzx
  55. * @Date: 2023-12-27
  56. * @Version 1.0
  57. */
  58. @RestController
  59. @RequestMapping("/schedule" + "/schedule")
  60. @Api(value = "/schedule" + "/schedule",tags = "课表代码")
  61. @AllArgsConstructor
  62. public class ScheduleController {
  63. private final ICourseReceiveMsgService courseReceiveMsgService;
  64. // private final IJianyueDataService jianyueDataService;
  65. private final ICourseTableService courseTableService;
  66. private final IBaseStudentSchoolRollService baseStudentSchoolRollService;
  67. private final IBaseTeacherService baseTeacherService;
  68. private final ITeacherbaseManagerService teacherService;
  69. private final IBaseSemesterService semesterService;
  70. @GetMapping(value = "/receive-msg")
  71. @ApiOperation(value="接收消息")
  72. @SaCheckPermission("room:detail")
  73. public RT<CourseReceiveMsg> receiveMsg(@RequestParam String schoolId, @RequestParam String eduYearSerialNo, @RequestParam String startDate, @RequestParam String endDate) throws Exception {
  74. CourseReceiveMsg courseReceiveMsg = new CourseReceiveMsg();
  75. courseReceiveMsg.setCreateDate(new Date());
  76. courseReceiveMsg.setSchoolId(schoolId);
  77. courseReceiveMsg.setEduYearSerialNo(eduYearSerialNo);
  78. courseReceiveMsg.setStartDate(startDate);
  79. courseReceiveMsg.setEndDate(endDate);
  80. courseReceiveMsg.setDeleteMark(DeleteMark.NODELETE.getCode());
  81. courseReceiveMsg.setEnabledMark(EnabledMark.ENABLED.getCode());
  82. courseReceiveMsgService.save(courseReceiveMsg);
  83. return RT.ok(courseReceiveMsg);
  84. }
  85. @GetMapping(value = "/course-table")
  86. @ApiOperation(value="课表接口(PC端)")
  87. @SaCheckPermission("room:detail")
  88. public RT<CourseTableVo> courseInfo(CourseTableDto dto){
  89. CourseTableVo list = courseTableService.getList(dto);
  90. return RT.ok(list);
  91. }
  92. @GetMapping(value = "/course-table-day")
  93. @ApiOperation(value="今日课表接口(手机端)")
  94. @SaCheckPermission("room:detail")
  95. public RT<CourseTableVo> courseInfoDay(CourseTableDto dto){
  96. LocalDateTime now = LocalDateTime.now();
  97. DayOfWeek dayOfWeek = now.getDayOfWeek();
  98. dto.setWeekDay(dayOfWeek.getValue());
  99. dto.setToDay(now);
  100. if(ObjectUtil.isNotNull(dto.getStudentId())){
  101. List<BaseStudentSchoolRoll> schoolRolls = baseStudentSchoolRollService.list(
  102. new QueryWrapper<BaseStudentSchoolRoll>().lambda().eq(BaseStudentSchoolRoll::getUserId, dto.getStudentId())
  103. );
  104. if(schoolRolls != null && !schoolRolls.isEmpty()){
  105. dto.setCourseType("class");
  106. dto.setClassId(schoolRolls.get(0).getClassId());
  107. }
  108. }else{
  109. // 查询登录者身份
  110. long loginIdAsLong = StpUtil.getLoginIdAsLong();
  111. List<BaseStudentSchoolRoll> schoolRolls = baseStudentSchoolRollService.list(
  112. new QueryWrapper<BaseStudentSchoolRoll>().lambda().eq(BaseStudentSchoolRoll::getUserId, loginIdAsLong)
  113. );
  114. if(schoolRolls != null && !schoolRolls.isEmpty()){
  115. dto.setCourseType("class");
  116. dto.setClassId(schoolRolls.get(0).getClassId());
  117. }
  118. List<BaseTeacher> teachers = baseTeacherService.list(new QueryWrapper<BaseTeacher>().lambda().eq(BaseTeacher::getUserId, loginIdAsLong));
  119. if(teachers != null && !teachers.isEmpty()){
  120. dto.setCourseType("teacher");
  121. dto.setTeacherId(loginIdAsLong);
  122. }
  123. }
  124. CourseTableVo list = courseTableService.getList(dto);
  125. return RT.ok(list);
  126. }
  127. @GetMapping(value = "/current-week")
  128. @ApiOperation(value="获取当前周次")
  129. @SaCheckPermission("room:detail")
  130. public RT<Integer> currentWeek(CourseTableDto dto){
  131. List<BaseSemester> semesterList = semesterService.list(new QueryWrapper<BaseSemester>().lambda().orderByDesc(BaseSemester::getStartDate));
  132. BaseSemester baseSemester = semesterList.get(0);
  133. LocalDateTime now = LocalDateTime.now();
  134. //计算本周是第几周
  135. LocalDateTime startDateTime = LocalDateTime.ofInstant(baseSemester.getStartDate().toInstant(), ZoneId.systemDefault());
  136. LocalDateTime endDateTime = LocalDateTime.ofInstant(baseSemester.getEndDate().toInstant(), ZoneId.systemDefault());
  137. Duration between = Duration.between(startDateTime, endDateTime);
  138. long days = between.toDays();
  139. int weeks = (int) Math.ceil((double) days / 7);
  140. if (dto.getWeek() == null) {
  141. for (int i = 0; i < weeks; i++) {
  142. LocalDateTime startDate = startDateTime.plusDays(i * 6).withHour(0).withMinute(0).withSecond(0).withNano(0);
  143. LocalDateTime endDate = startDateTime.plusDays((i + 1) * 6).withHour(23).withMinute(59).withSecond(59).withNano(9999);
  144. if (now.isAfter(startDate) && now.isBefore(endDate)) {
  145. return RT.ok(i + 1);
  146. }
  147. }
  148. }
  149. return RT.error("未能查询到当前周次");
  150. }
  151. @GetMapping(value = "/adjust-list")
  152. @ApiOperation(value = "可以调课的课程")
  153. @SaCheckPermission("evaluateobject:detail")
  154. public RT<List<CourseListVo>> adjustList(CourseTableAdjustDto dto){
  155. // if(dto.getAdjustDate() == null || dto.getTeacherId() == null){
  156. // return RT.error("请传入调整日期和教师id");
  157. // }
  158. // List<CourseListVo> list = courseTableService.getAdjustList(dto);
  159. // if(list.isEmpty()){
  160. // return RT.error("暂无可调课程");
  161. // }
  162. return RT.ok();
  163. }
  164. @GetMapping(value = "/pre-check")
  165. @ApiOperation(value = "预检查")
  166. @SaCheckPermission("evaluateobject:detail")
  167. public RT<String> preCheck(CourseTablePreCheckDto dto) throws Exception {
  168. if(dto.getPreCheckType() != null){
  169. if(dto.getPreCheckType() == 1){
  170. CourseTable courseTable = courseTableService.getById(dto.getCourseId());
  171. CourseTable swapCourseTable = courseTableService.getById(dto.getSwapCourseId());
  172. JsonObject preCheck = getExtendPreCheck(dto, courseTable, swapCourseTable);
  173. if(preCheck.get("code").getAsInt() != 0){
  174. return RT.error(preCheck.get("msg").getAsString());
  175. }
  176. }else if(dto.getPreCheckType() == 2){
  177. CourseTable courseTable = courseTableService.getById(dto.getCourseId());
  178. JsonObject jsonObject = substitutePreTestin(dto, courseTable);
  179. if(jsonObject.get("code").getAsInt() != 0){
  180. return RT.error(jsonObject.get("msg").getAsString());
  181. }
  182. }
  183. }
  184. return RT.ok("ok");
  185. }
  186. /**
  187. * 顶课预检查
  188. * @param dto
  189. * @param courseTable
  190. * @return 检查结果
  191. */
  192. JsonObject substitutePreTestin(CourseTablePreCheckDto dto, CourseTable courseTable) throws Exception {
  193. JsonParser jsonParser = new JsonParser();
  194. String url = ScheduleUtil.apiUrl + "RescheduleApply/Extend/Substitute/PreTesting";
  195. JsonObject jsonObject = new JsonObject();
  196. jsonObject.addProperty("timetableId", courseTable.getJianyueId());
  197. jsonObject.addProperty("isCycles", Boolean.FALSE);
  198. JsonArray extendIds = new JsonArray();
  199. extendIds.add(dto.getSubTeacherId());
  200. jsonObject.add("extendIds", extendIds);
  201. //获取时间戳
  202. long timestamp = System.currentTimeMillis();
  203. //生成签名
  204. String sign = ScheduleUtil.createSign(timestamp);
  205. String result = ScheduleUtil.doPost(url, jsonObject.toString(), sign, timestamp);
  206. if(StrUtil.isEmpty(result)){
  207. return null;
  208. }
  209. return jsonParser.parse(result).getAsJsonObject();
  210. }
  211. /**
  212. * 调课预检查
  213. * @param courseTable 需要调整的课程
  214. * @param swapCourseTable 对调的课程
  215. * @return 检查结果
  216. */
  217. JsonObject getExtendPreCheck(CourseTablePreCheckDto dto, CourseTable courseTable, CourseTable swapCourseTable) throws Exception {
  218. JsonParser jsonParser = new JsonParser();
  219. String url = ScheduleUtil.apiUrl + "RescheduleApply/Extend/PreTesting";
  220. JsonObject jsonObject = new JsonObject();
  221. jsonObject.addProperty("timetableId", courseTable.getJianyueId());
  222. jsonObject.addProperty("isCycles", Boolean.FALSE);
  223. // jsonObject.addProperty("startDate", "2024-01-01");
  224. // jsonObject.addProperty("endDate", "2024-01-31");
  225. // jsonObject.addProperty("dayOfweek", 5);
  226. jsonObject.addProperty("numberOfday", swapCourseTable.getTimeNumber());
  227. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
  228. jsonObject.addProperty("date", dto.getSwapDate().format(formatter));
  229. jsonObject.addProperty("reschduleId", courseTable.getJianyueId());
  230. //获取时间戳
  231. long timestamp = System.currentTimeMillis();
  232. //生成签名
  233. String sign = ScheduleUtil.createSign(timestamp);
  234. String result = ScheduleUtil.doPost(url, jsonObject.toString(), sign, timestamp);
  235. if(StrUtil.isEmpty(result)){
  236. return null;
  237. }
  238. return jsonParser.parse(result).getAsJsonObject();
  239. }
  240. @PostMapping("/schedule-week-export-query")
  241. @ApiOperation(value = "按周导出课表")
  242. public ResponseEntity<byte[]> scheduleWeekExportQuery(@Valid @RequestBody ScheduleWeekExportQueryDto dto) {
  243. // @GetMapping("/schedule-week-export-query")
  244. // @ApiOperation(value = "按周导出课表")
  245. // public ResponseEntity<byte[]> textbookClaimExportQuery(@Valid ScheduleWeekExportQueryDto dto) {
  246. ByteArrayOutputStream bot = courseTableService.listScheduleWeekExportQuery(dto);
  247. return RT.fileStream(bot.toByteArray(), "scheduleWeek" + ExcelTypeEnum.XLSX.getValue());
  248. }
  249. @GetMapping(value = "/login-url")
  250. @ApiOperation(value = "获取单点登录地址")
  251. @SaCheckPermission("evaluateobject:detail")
  252. public RT<String> getAccessToken() throws Exception {
  253. XjrUser xjrUser = teacherService.getById(StpUtil.getLoginIdAsLong());
  254. long timeMillis = System.currentTimeMillis();
  255. String sign = ScheduleUtil.createSign(timeMillis);
  256. JsonObject jsonObject = new JsonObject();
  257. jsonObject.addProperty("mobileNo", xjrUser.getMobile());
  258. String url = ScheduleUtil.apiUrl + "auth/user/token";
  259. try {
  260. String result = ScheduleUtil.doPost(url, jsonObject.toString(), sign, timeMillis);
  261. JsonParser parser = new JsonParser();
  262. JsonObject resultJson = parser.parse(result).getAsJsonObject();
  263. if(resultJson.get("code").getAsInt() != 0){
  264. return RT.error("无登录权限");
  265. }
  266. JsonObject dataJson = resultJson.get("data").getAsJsonObject();
  267. String loginUrl = ScheduleUtil.hostUrl + "?access_token=" + dataJson.get("access_token").getAsString();
  268. return RT.ok(loginUrl);
  269. }catch (Exception e){
  270. return RT.error(e.getMessage());
  271. }
  272. }
  273. }