CourseStudentOnlineService.java 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. package com.qxgmat.service.inline;
  2. import com.github.pagehelper.Page;
  3. import com.nuliji.tools.AbstractService;
  4. import com.nuliji.tools.exception.ParameterException;
  5. import com.nuliji.tools.exception.SystemException;
  6. import com.nuliji.tools.mybatis.Example;
  7. import com.qxgmat.data.dao.CourseStudentOnlineMapper;
  8. import com.qxgmat.data.dao.entity.CourseStudentOnline;
  9. import com.qxgmat.data.dao.entity.CourseTime;
  10. import com.qxgmat.data.relation.CourseStudentOnlineRelationMapper;
  11. import com.qxgmat.data.relation.entity.CourseStudentNumberRelation;
  12. import org.slf4j.Logger;
  13. import org.slf4j.LoggerFactory;
  14. import org.springframework.stereotype.Service;
  15. import javax.annotation.Resource;
  16. import java.util.Collection;
  17. import java.util.List;
  18. import java.util.Map;
  19. @Service
  20. public class CourseStudentOnlineService extends AbstractService {
  21. private static final Logger logger = LoggerFactory.getLogger(CourseStudentOnlineService.class);
  22. @Resource
  23. private CourseStudentOnlineMapper courseStudentOnlineMapper;
  24. @Resource
  25. private CourseStudentOnlineRelationMapper courseStudentOnlineRelationMapper;
  26. public Page<CourseStudentOnline> listAdmin(int page, int size, Integer courseId, Integer timeId){
  27. Example example = new Example(CourseStudentOnline.class);
  28. if(courseId != null){
  29. example.and(
  30. example.createCriteria()
  31. .andEqualTo("courseId", courseId)
  32. );
  33. }
  34. if(timeId != null){
  35. example.and(
  36. example.createCriteria()
  37. .andEqualTo("timeId", timeId)
  38. );
  39. }
  40. return select(courseStudentOnlineMapper, example, page, size);
  41. }
  42. public List<CourseStudentNumberRelation> groupByCourse(Collection ids){
  43. return courseStudentOnlineRelationMapper.groupByTime(ids);
  44. }
  45. public CourseStudentOnline getByUserAndTime(Integer userId, Integer timeId){
  46. Example example = new Example(CourseStudentOnline.class);
  47. example.and(
  48. example.createCriteria()
  49. .andEqualTo("userId", userId)
  50. .andEqualTo("timeId", timeId)
  51. );
  52. return one(courseStudentOnlineMapper, example);
  53. }
  54. public CourseStudentOnline addStudent(CourseStudentOnline course){
  55. CourseStudentOnline in = getByUserAndTime(course.getUserId(), course.getTimeId());
  56. if(in != null){
  57. throw new ParameterException("已添加");
  58. }
  59. return add(course);
  60. }
  61. public CourseStudentOnline add(CourseStudentOnline course){
  62. int result = insert(courseStudentOnlineMapper, course);
  63. course = one(courseStudentOnlineMapper, course.getId());
  64. if(course == null){
  65. throw new SystemException("课时添加失败");
  66. }
  67. return course;
  68. }
  69. public CourseStudentOnline edit(CourseStudentOnline course){
  70. CourseStudentOnline in = one(courseStudentOnlineMapper, course.getId());
  71. if(in == null){
  72. throw new ParameterException("课时不存在");
  73. }
  74. int result = update(courseStudentOnlineMapper, course);
  75. return course;
  76. }
  77. public boolean delete(Number id){
  78. CourseStudentOnline in = one(courseStudentOnlineMapper, id);
  79. if(in == null){
  80. throw new ParameterException("课时不存在");
  81. }
  82. int result = delete(courseStudentOnlineMapper, id);
  83. return result > 0;
  84. }
  85. public CourseStudentOnline get(Number id){
  86. CourseStudentOnline in = one(courseStudentOnlineMapper, id);
  87. if(in == null){
  88. throw new ParameterException("课时不存在");
  89. }
  90. return in;
  91. }
  92. public Page<CourseStudentOnline> select(int page, int pageSize){
  93. return select(courseStudentOnlineMapper, page, pageSize);
  94. }
  95. public Page<CourseStudentOnline> select(Integer[] ids){
  96. return page(()->select(courseStudentOnlineMapper, ids), 1, ids.length);
  97. }
  98. public List<CourseStudentOnline> select(Collection ids){
  99. return select(courseStudentOnlineMapper, ids);
  100. }
  101. }