FaqService.java 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  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.module.InsideModule;
  8. import com.qxgmat.data.dao.FaqMapper;
  9. import com.qxgmat.data.dao.entity.Faq;
  10. import org.slf4j.Logger;
  11. import org.slf4j.LoggerFactory;
  12. import org.springframework.stereotype.Service;
  13. import javax.annotation.Resource;
  14. import java.util.Collection;
  15. import java.util.List;
  16. @Service
  17. public class FaqService extends AbstractService {
  18. private static final Logger logger = LoggerFactory.getLogger(FaqService.class);
  19. @Resource
  20. private FaqMapper faqMapper;
  21. public Page<Faq> listAdmin(int page, int size, Boolean user, String channel, String position, Integer answerStatus, Boolean isSpecial){
  22. Example example = new Example(Faq.class);
  23. if (user != null){
  24. example.and(user ? example.createCriteria().andGreaterThan("userId", 0):
  25. example.createCriteria().andEqualTo("user", 0)
  26. );
  27. }
  28. if (channel != null){
  29. example.and(
  30. example.createCriteria().andEqualTo("channel", channel)
  31. );
  32. if (position != null){
  33. example.and(
  34. example.createCriteria().andEqualTo("position", position)
  35. );
  36. }
  37. }
  38. if (answerStatus != null){
  39. example.and(
  40. example.createCriteria().andEqualTo("answerStatus", answerStatus)
  41. );
  42. }
  43. if(isSpecial != null){
  44. example.and(
  45. example.createCriteria().andEqualTo("isSpecial", isSpecial ? 1 : 0)
  46. );
  47. }
  48. return select(faqMapper, example, page, size);
  49. }
  50. public Page<Faq> list(int page, int size, String channel, String position){
  51. Example example = new Example(Faq.class);
  52. if (channel != null){
  53. example.and(
  54. example.createCriteria().andEqualTo("channel", channel)
  55. );
  56. if (position != null){
  57. example.and(
  58. example.createCriteria().andEqualTo("position", position)
  59. );
  60. }
  61. }
  62. example.and(
  63. example.createCriteria()
  64. .orEqualTo("isShow", 1)
  65. );
  66. return select(faqMapper, example, page, size);
  67. }
  68. public Faq add(Faq faq){
  69. int result = insert(faqMapper, faq);
  70. faq = one(faqMapper, faq.getId());
  71. if(faq == null){
  72. throw new SystemException("faq添加失败");
  73. }
  74. return faq;
  75. }
  76. public Faq edit(Faq faq){
  77. Faq in = one(faqMapper, faq.getId());
  78. if(in == null){
  79. throw new ParameterException("faq不存在");
  80. }
  81. int result = update(faqMapper, faq);
  82. return faq;
  83. }
  84. public boolean delete(Number id){
  85. Faq in = one(faqMapper, id);
  86. if(in == null){
  87. throw new ParameterException("faq不存在");
  88. }
  89. int result = delete(faqMapper, id);
  90. return result > 0;
  91. }
  92. public Faq get(Number id){
  93. Faq in = one(faqMapper, id);
  94. if(in == null){
  95. throw new ParameterException("faq不存在");
  96. }
  97. return in;
  98. }
  99. public Page<Faq> select(int page, int pageSize){
  100. return select(faqMapper, page, pageSize);
  101. }
  102. public Page<Faq> select(Integer[] ids){
  103. return page(()->select(faqMapper, ids), 1, ids.length);
  104. }
  105. public List<Faq> select(Collection ids){
  106. return select(faqMapper, ids);
  107. }
  108. }