UserCollectQuestionService.java 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. package com.qxgmat.service;
  2. import com.github.pagehelper.Page;
  3. import com.nuliji.tools.AbstractService;
  4. import com.nuliji.tools.Transform;
  5. import com.nuliji.tools.exception.ParameterException;
  6. import com.nuliji.tools.exception.SystemException;
  7. import com.nuliji.tools.mybatis.Example;
  8. import com.qxgmat.data.dao.UserCollectQuestionMapper;
  9. import com.qxgmat.data.dao.entity.UserCollectQuestion;
  10. import com.qxgmat.data.relation.UserCollectQuestionRelationMapper;
  11. import com.qxgmat.service.inline.QuestionNoService;
  12. import com.qxgmat.service.inline.QuestionService;
  13. import com.qxgmat.service.inline.SentenceQuestionService;
  14. import com.qxgmat.service.inline.TextbookQuestionService;
  15. import org.slf4j.Logger;
  16. import org.slf4j.LoggerFactory;
  17. import org.springframework.stereotype.Service;
  18. import org.springframework.transaction.annotation.Transactional;
  19. import javax.annotation.Resource;
  20. import java.util.ArrayList;
  21. import java.util.Collection;
  22. import java.util.Date;
  23. import java.util.List;
  24. @Service
  25. public class UserCollectQuestionService extends AbstractService {
  26. private static final Logger logger = LoggerFactory.getLogger(UserCollectQuestionService.class);
  27. @Resource
  28. private QuestionService questionService;
  29. @Resource
  30. private QuestionNoService questionNoService;
  31. @Resource
  32. private SentenceQuestionService sentenceQuestionService;
  33. @Resource
  34. private TextbookQuestionService textbookQuestionService;
  35. @Resource
  36. private UserCollectQuestionMapper userCollectQuestionMapper;
  37. @Resource
  38. private UserCollectQuestionRelationMapper userCollectQuestionRelationMapper;
  39. /**
  40. * 获取用户题目收藏列表
  41. * @param page
  42. * @param size
  43. * @param userId
  44. * @return
  45. */
  46. public Page<UserCollectQuestion> listExercise(int page, int size, Integer userId, String keyword, String[] questionTypes, Integer[] structIds, Date startTime, Date endTime, String order){
  47. Page<UserCollectQuestion> p = page(()->{
  48. userCollectQuestionRelationMapper.listExercise(userId, keyword, questionTypes, structIds, startTime, endTime, order);
  49. }, page, size);
  50. Collection ids = Transform.getIds(p, UserCollectQuestion.class, "id");
  51. // 获取详细数据
  52. List<UserCollectQuestion> list = select(ids);
  53. Transform.replace(p, list, UserCollectQuestion.class, "id");
  54. return p;
  55. }
  56. /**
  57. * 获取用户题目收藏列表
  58. * @param page
  59. * @param size
  60. * @param userId
  61. * @return
  62. */
  63. public Page<UserCollectQuestion> listExamination(int page, int size, Integer userId, String keyword, String[] questionTypes, Integer[] structIds, Integer libraryId, String year, Date startTime, Date endTime, String order){
  64. Page<UserCollectQuestion> p = page(()->{
  65. userCollectQuestionRelationMapper.listExamination(userId, keyword, questionTypes, structIds, libraryId, year, startTime, endTime, order);
  66. }, page, size);
  67. Collection ids = Transform.getIds(p, UserCollectQuestion.class, "id");
  68. // 获取详细数据
  69. List<UserCollectQuestion> list = select(ids);
  70. Transform.replace(p, list, UserCollectQuestion.class, "id");
  71. return p;
  72. }
  73. /**
  74. * 查询用户收藏情况
  75. * @param userId
  76. * @param questionId
  77. * @return
  78. */
  79. public UserCollectQuestion getByUserAndQuestion(Integer userId, Integer questionId){
  80. Example example = new Example(UserCollectQuestion.class);
  81. example.and(
  82. example.createCriteria()
  83. .andEqualTo("userId", userId)
  84. .andEqualTo("questionId", questionId)
  85. );
  86. UserCollectQuestion in = one(userCollectQuestionMapper, example);
  87. return in;
  88. }
  89. /**
  90. * 查询用户收藏情况:批量
  91. * @param userId
  92. * @param ids
  93. * @return
  94. */
  95. public List<UserCollectQuestion> listByUserAndQuestions(Integer userId, Collection ids){
  96. if (ids == null || ids.size() == 0) return new ArrayList<>();
  97. Example example = new Example(UserCollectQuestion.class);
  98. example.and(
  99. example.createCriteria()
  100. .andEqualTo("userId", userId)
  101. .andIn("questionId", ids)
  102. );
  103. return select(userCollectQuestionMapper, example);
  104. }
  105. /**
  106. * 收藏题目编号:包含题目id
  107. * @param entity
  108. * @return
  109. */
  110. @Transactional
  111. public UserCollectQuestion addQuestion(UserCollectQuestion entity){
  112. Example example = new Example(UserCollectQuestion.class);
  113. example.and(
  114. example.createCriteria()
  115. .andEqualTo("userId", entity.getUserId())
  116. .andEqualTo("questionId", entity.getQuestionId())
  117. );
  118. UserCollectQuestion in = one(userCollectQuestionMapper, example);
  119. if (in != null){
  120. return in;
  121. }
  122. int result = insert(userCollectQuestionMapper, entity);
  123. questionService.accumulationCollect(entity, 1);
  124. questionNoService.accumulationCollect(entity, 1);
  125. return entity;
  126. }
  127. /**
  128. * 取消收藏题目编号
  129. * @param userId
  130. * @param questionId
  131. * @return
  132. */
  133. @Transactional
  134. public boolean deleteQuestion(Integer userId, Integer questionId){
  135. Example example = new Example(UserCollectQuestion.class);
  136. example.and(
  137. example.createCriteria()
  138. .andEqualTo("userId", userId)
  139. .andEqualTo("questionId", questionId)
  140. );
  141. UserCollectQuestion in = one(userCollectQuestionMapper, example);
  142. if (in == null){
  143. return true;
  144. }
  145. boolean result = delete(in.getId());
  146. questionService.accumulationCollect(in, -1);
  147. questionNoService.accumulationCollect(in, -1);
  148. return result;
  149. }
  150. public UserCollectQuestion add(UserCollectQuestion collect){
  151. int result = insert(userCollectQuestionMapper, collect);
  152. collect = one(userCollectQuestionMapper, collect.getId());
  153. if(collect == null){
  154. throw new SystemException("收藏添加失败");
  155. }
  156. return collect;
  157. }
  158. public UserCollectQuestion edit(UserCollectQuestion collect){
  159. UserCollectQuestion in = one(userCollectQuestionMapper, collect.getId());
  160. if(in == null){
  161. throw new ParameterException("收藏不存在");
  162. }
  163. int result = update(userCollectQuestionMapper, collect);
  164. return collect;
  165. }
  166. public boolean delete(Number id){
  167. UserCollectQuestion in = one(userCollectQuestionMapper, id);
  168. if(in == null){
  169. throw new ParameterException("收藏不存在");
  170. }
  171. int result = delete(userCollectQuestionMapper, id);
  172. return result > 0;
  173. }
  174. public UserCollectQuestion get(Number id){
  175. UserCollectQuestion in = one(userCollectQuestionMapper, id);
  176. if(in == null){
  177. throw new ParameterException("收藏不存在");
  178. }
  179. return in;
  180. }
  181. public Page<UserCollectQuestion> select(int page, int pageSize){
  182. return select(userCollectQuestionMapper, page, pageSize);
  183. }
  184. public Page<UserCollectQuestion> select(Integer[] ids){
  185. return page(()->select(userCollectQuestionMapper, ids), 1, ids.length);
  186. }
  187. public List<UserCollectQuestion> select(Collection ids){
  188. return select(userCollectQuestionMapper, ids);
  189. }
  190. }