ActivityFeedbackService.java 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234
  1. package platform.modules.sys.service;
  2. import com.github.pagehelper.PageHelper;
  3. import com.github.pagehelper.PageInfo;
  4. import org.springframework.beans.factory.annotation.Autowired;
  5. import org.springframework.stereotype.Service;
  6. import org.springframework.transaction.annotation.Transactional;
  7. import platform.common.base.service.BaseService;
  8. import platform.common.util.ShiroUtils;
  9. import platform.modules.government.dto.FeedbackQuery;
  10. import platform.modules.government.entity.User;
  11. import platform.modules.sys.dao.ActivityFeedbackDao;
  12. import platform.modules.sys.entity.ActivityFeedback;
  13. import java.math.BigDecimal;
  14. import java.util.*;
  15. @Service
  16. @Transactional
  17. public class ActivityFeedbackService extends BaseService<ActivityFeedback> {
  18. @Autowired
  19. private ActivityFeedbackDao activityFeedbackDao;
  20. public Integer saveActivityFeedback(ActivityFeedback activityFeedback) {
  21. User currUser = ShiroUtils.getUserEntity();
  22. activityFeedback.setUser_id(currUser.getId() + "");
  23. activityFeedback.setUser_type(currUser.getUser_type().toString());
  24. return this.saveSelective(activityFeedback);
  25. }
  26. @Transactional(readOnly = true)
  27. public PageInfo<ActivityFeedback> findAvtivityPage(Integer pageNum, Integer pageSize, Integer id) throws Exception {
  28. PageHelper.startPage(pageNum, pageSize);
  29. List<ActivityFeedback> list = activityFeedbackDao.findPage(id);
  30. return new PageInfo<ActivityFeedback>(list);
  31. }
  32. @Transactional(readOnly = true)
  33. public List<ActivityFeedback> findAvtivityList(Integer id) throws Exception {
  34. List<ActivityFeedback> list = activityFeedbackDao.findPage(id);
  35. return list;
  36. }
  37. /**
  38. * 获取反馈列表
  39. *
  40. * @param query
  41. * @return
  42. */
  43. public PageInfo<ActivityFeedback> findFeedbackList(FeedbackQuery query) {
  44. PageHelper.startPage(query.getPageNum(), query.getPageSzie());
  45. List<ActivityFeedback> commentList = activityFeedbackDao.findFeedbackList(query);
  46. return new PageInfo<>(commentList);
  47. }
  48. /**
  49. * 获取各反馈类型数
  50. *
  51. * @param query
  52. * @return
  53. */
  54. public List<ActivityFeedback> findFeedbackTypelist(FeedbackQuery query) {
  55. List<ActivityFeedback> feedbacks = activityFeedbackDao.findFeedbackTypelist(query);
  56. return feedbacks;
  57. }
  58. /**
  59. * 获取反馈类型数
  60. *
  61. * @param query
  62. * @return
  63. */
  64. public ActivityFeedback findCountByFeedbackType(FeedbackQuery query) {
  65. ActivityFeedback feedback = activityFeedbackDao.findCountByFeedbackType(query);
  66. return feedback;
  67. }
  68. /**
  69. * 获取综合星级
  70. *
  71. * @param activity_id
  72. * @return
  73. */
  74. public Double findAvgStar(Integer activity_id) {
  75. Double avgStar = activityFeedbackDao.findAvgStar(activity_id);
  76. return new BigDecimal(avgStar).setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
  77. }
  78. /**
  79. * 获取用户反馈
  80. *
  81. * @param id
  82. * @param userId
  83. * @return
  84. */
  85. public ActivityFeedback findUserFeedback(Integer id, int userId) {
  86. List<ActivityFeedback> feedbacks = activityFeedbackDao.findUserFeedback(id, userId);
  87. if (feedbacks.size() > 0) {
  88. return feedbacks.get(0);
  89. }
  90. return new ActivityFeedback();
  91. }
  92. /**
  93. * @Author: huZhiHao
  94. * @Description: 获取列表
  95. * @Date: 2020/1/7
  96. * @Params: [activityId, userId, isPublic, isView]
  97. * @Return: java.util.List<platform.modules.sys.entity.ActivityFeedback>
  98. **/
  99. @Transactional(readOnly = true)
  100. public List<ActivityFeedback> feedbackList(String activityId, String isPublic, String isView, String minScore, String maxScore) {
  101. List<ActivityFeedback> feedbacks = activityFeedbackDao.feedbackList(activityId, isPublic, isView, minScore, maxScore);
  102. return feedbacks;
  103. }
  104. /**
  105. * @Author: huZhiHao
  106. * @Description: 保存
  107. * @Date: 2020/1/7
  108. * @Params: [activityFeedback]
  109. * @Return: java.lang.Integer
  110. **/
  111. public Integer feedbackSave(ActivityFeedback activityFeedback) {
  112. Integer score_1 = activityFeedback.getScore_1();
  113. Integer score_2 = activityFeedback.getScore_2();
  114. Integer score_3 = activityFeedback.getScore_3();
  115. Integer score = 0;
  116. if (score_1 != null) score += score_1 * 4;
  117. if (score_2 != null) score += score_2 * 4;
  118. if (score_3 != null) score += score_3 * 12;
  119. activityFeedback.setScore(score);
  120. activityFeedback.setFeedback_time(new Date());
  121. return this.saveSelective(activityFeedback);
  122. }
  123. /**
  124. * @Author: huZhiHao
  125. * @Description: 更新
  126. * @Date: 2020/1/7
  127. * @Params: [activityFeedback]
  128. * @Return: java.lang.Integer
  129. **/
  130. public Integer feedbackUpdate(ActivityFeedback activityFeedback) {
  131. if (activityFeedback.getIs_top() != null && activityFeedback.getIs_top()) {
  132. activityFeedback.setIs_view(true);
  133. ActivityFeedback temp1 = this.findById(activityFeedback.getId());
  134. ActivityFeedback query = new ActivityFeedback();
  135. query.setActivity_id(temp1.getActivity_id());
  136. query.setIs_top(true);
  137. ActivityFeedback temp2 = this.findOne(query);
  138. if(temp2!=null){
  139. temp2.setIs_top(false);
  140. this.updateSelective(temp2);
  141. }
  142. }
  143. if (activityFeedback.getIs_view() != null && !activityFeedback.getIs_view()) {
  144. activityFeedback.setIs_top(false);
  145. }
  146. return this.updateSelective(activityFeedback);
  147. }
  148. /**
  149. * @Author: huZhiHao
  150. * @Description: 获取详情
  151. * @Date: 2020/1/7
  152. * @Params: [activityId, userId]
  153. * @Return: platform.modules.sys.entity.ActivityFeedback
  154. *
  155. * @return*/
  156. @Transactional(readOnly = true)
  157. public List<ActivityFeedback> feedbackGet(String activityId, String userId) {
  158. ActivityFeedback activityFeedback = new ActivityFeedback();
  159. activityFeedback.setActivity_id(activityId);
  160. activityFeedback.setUser_id(userId);
  161. return this.findListByWhere(activityFeedback);
  162. }
  163. /**
  164. * @Author: huZhiHao
  165. * @Description: 获取分页
  166. * @Date: 2020/1/7
  167. * @Params: [activityId, pageNum, pageSize]
  168. * @Return: com.github.pagehelper.PageInfo<platform.modules.sys.entity.ActivityFeedback>
  169. **/
  170. @Transactional(readOnly = true)
  171. public PageInfo<ActivityFeedback> feedbackPage(String activityId, String minScore, String maxScore, Integer pageNum, Integer pageSize) {
  172. PageHelper.startPage(pageNum, pageSize);
  173. List<ActivityFeedback> page = activityFeedbackDao.feedbackPage(activityId, minScore, maxScore);
  174. return new PageInfo<ActivityFeedback>(page);
  175. }
  176. @Transactional(readOnly = true)
  177. public Map getScoreCount(String activityId, String isPublic, String isView, String minScore, String maxScore) {
  178. int score100_80 = 0, score80_60 = 0, score60_40 = 0, score40_20 = 0, score20_0 = 0;
  179. List<ActivityFeedback> feedbacks = activityFeedbackDao.feedbackList(activityId, isPublic, isView, minScore, maxScore);
  180. for (ActivityFeedback feedback : feedbacks) {
  181. Integer score = feedback.getScore();
  182. if (score != null) {
  183. if (score > 80) {
  184. score100_80++;
  185. } else if (score > 60) {
  186. score80_60++;
  187. } else if (score > 40) {
  188. score60_40++;
  189. } else if (score > 20) {
  190. score40_20++;
  191. } else if (score >= 0) {
  192. score20_0++;
  193. }
  194. }
  195. }
  196. Map<String, Integer> map = new HashMap();
  197. map.put("score100_80", score100_80);
  198. map.put("score80_60", score80_60);
  199. map.put("score60_40", score60_40);
  200. map.put("score40_20", score40_20);
  201. map.put("score20_0", score20_0);
  202. map.put("score_all", feedbacks.size());
  203. return map;
  204. }
  205. }