CourseExperienceService.java 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  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.constants.enums.status.DirectionStatus;
  8. import com.qxgmat.data.constants.enums.user.DataType;
  9. import com.qxgmat.data.dao.CourseDataMapper;
  10. import com.qxgmat.data.dao.CourseExperienceMapper;
  11. import com.qxgmat.data.dao.entity.CourseData;
  12. import com.qxgmat.data.dao.entity.CourseExperience;
  13. import org.slf4j.Logger;
  14. import org.slf4j.LoggerFactory;
  15. import org.springframework.stereotype.Service;
  16. import javax.annotation.Resource;
  17. import java.util.Collection;
  18. import java.util.List;
  19. @Service
  20. public class CourseExperienceService extends AbstractService {
  21. private static final Logger logger = LoggerFactory.getLogger(CourseExperienceService.class);
  22. @Resource
  23. private CourseExperienceMapper courseExperienceMapper;
  24. public Page<CourseExperience> listAdmin(int page, int size, Integer userId, String keyword, String order, DirectionStatus direction){
  25. Example example = new Example(CourseExperience.class);
  26. if(userId != null){
  27. example.and(
  28. example.createCriteria()
  29. .andEqualTo("userId", userId)
  30. );
  31. }
  32. if(keyword != null){
  33. example.and(
  34. example.createCriteria()
  35. .orLike("title", "%"+keyword+"%")
  36. .orLike("content", "%"+keyword+"%")
  37. );
  38. }
  39. if(order == null || order.isEmpty()) order = "id";
  40. switch(direction){
  41. case ASC:
  42. example.orderBy(order).asc();
  43. break;
  44. case DESC:
  45. default:
  46. example.orderBy(order).desc();
  47. }
  48. return select(courseExperienceMapper, example, page, size);
  49. }
  50. public Page<CourseExperience> list(int page, int size, String prepareStatus, String prepareExaminationTime, String experienceScore, String experiencePercent, String order, DirectionStatus direction){
  51. Example example = new Example(CourseExperience.class);
  52. if(prepareStatus != null){
  53. example.and(
  54. example.createCriteria()
  55. .andEqualTo("prepareStatus", prepareStatus)
  56. );
  57. }
  58. if(prepareExaminationTime != null){
  59. example.and(
  60. example.createCriteria()
  61. .andEqualTo("prepareExaminationTime", prepareExaminationTime)
  62. );
  63. }
  64. if(experienceScore != null){
  65. example.and(
  66. example.createCriteria()
  67. .andEqualTo("experienceScore", experienceScore)
  68. );
  69. }
  70. if(experiencePercent != null){
  71. example.and(
  72. example.createCriteria()
  73. .andEqualTo("experiencePercent", experiencePercent)
  74. );
  75. }
  76. if(order == null || order.isEmpty()) order = "id";
  77. switch(direction){
  78. case ASC:
  79. example.orderBy(order).asc();
  80. break;
  81. case DESC:
  82. default:
  83. example.orderBy(order).desc();
  84. }
  85. return select(courseExperienceMapper, example, page, size);
  86. }
  87. public CourseExperience add(CourseExperience courseData){
  88. int result = insert(courseExperienceMapper, courseData);
  89. courseData = one(courseExperienceMapper, courseData.getId());
  90. if(courseData == null){
  91. throw new SystemException("心经添加失败");
  92. }
  93. return courseData;
  94. }
  95. public CourseExperience edit(CourseExperience courseData){
  96. CourseExperience in = one(courseExperienceMapper, courseData.getId());
  97. if(in == null){
  98. throw new ParameterException("心经不存在");
  99. }
  100. int result = update(courseExperienceMapper, courseData);
  101. return courseData;
  102. }
  103. public boolean delete(Number id){
  104. CourseExperience in = one(courseExperienceMapper, id);
  105. if(in == null){
  106. throw new ParameterException("心经不存在");
  107. }
  108. int result = delete(courseExperienceMapper, id);
  109. return result > 0;
  110. }
  111. public CourseExperience get(Number id){
  112. CourseExperience in = one(courseExperienceMapper, id);
  113. if(in == null){
  114. throw new ParameterException("心经不存在");
  115. }
  116. return in;
  117. }
  118. public Page<CourseExperience> select(int page, int pageSize){
  119. return select(courseExperienceMapper, page, pageSize);
  120. }
  121. public Page<CourseExperience> select(Integer[] ids){
  122. return page(()->select(courseExperienceMapper, ids), 1, ids.length);
  123. }
  124. public List<CourseExperience> select(Collection ids){
  125. return select(courseExperienceMapper, ids);
  126. }
  127. }