RepairUserServiceImpl.java 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. package com.repair.services.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.baomidou.mybatisplus.core.metadata.IPage;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.repair.model.pojo.RepairUser;
  6. import com.repair.mapper.RepairUserMapper;
  7. import com.repair.model.pojo.RepairWorkType;
  8. import com.repair.model.result.PageUtils;
  9. import com.repair.model.vo.*;
  10. import com.repair.services.RepairUserService;
  11. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  12. import org.apache.ibatis.annotations.Param;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.stereotype.Service;
  15. import org.springframework.util.StringUtils;
  16. import java.util.List;
  17. /**
  18. * <p>
  19. * 服务实现类
  20. * </p>
  21. *
  22. * @author ceshi
  23. * @since 2023-07-11
  24. */
  25. @Service
  26. public class RepairUserServiceImpl extends ServiceImpl<RepairUserMapper, RepairUser> implements RepairUserService {
  27. @Autowired
  28. private RepairUserMapper repairUserMapper;
  29. @Override
  30. public int insertRepairUser(RepairUser ru) {
  31. int result = repairUserMapper.insert(ru);
  32. return ru.getId();
  33. }
  34. @Override
  35. public int updateRepairUser(RepairUser ru) {
  36. int result = repairUserMapper.updateById(ru);
  37. return result;
  38. }
  39. @Override
  40. public PageUtils<RepairUser> queryPageRepairUser(int currentPage, int pageCount) {
  41. //ru.user_zzid = 1 or ru.user_zzid = 2
  42. Page<RepairUser> page = new Page<>(currentPage, pageCount);
  43. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  44. queryWrapper.and(e -> e.eq("user_zzid", 1)
  45. .or()
  46. .eq("user_zzid", 2));
  47. IPage<RepairUser> result = repairUserMapper.selectPage(page, queryWrapper);
  48. return new PageUtils(result);
  49. }
  50. @Override
  51. public PageUtils<RepairUser> queryPageUserBySchoolId(int currentPage, int pageCount, int schoolId) {
  52. //(ru.user_zzid = 1 or ru.user_zzid = 2) and school_Id = X
  53. Page<RepairUser> page = new Page<>(currentPage, pageCount);
  54. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  55. queryWrapper.eq("school_id",schoolId);
  56. queryWrapper.and(e -> e.eq("user_zzid", 1)
  57. .or()
  58. .eq("user_zzid", 2));
  59. IPage<RepairUser> result = repairUserMapper.selectPage(page, queryWrapper);
  60. return new PageUtils(result);
  61. }
  62. @Override
  63. public List<RepairUser> queryRepairUsers() {
  64. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  65. queryWrapper.and(e -> e.eq("user_zzid", 1)
  66. .or()
  67. .eq("user_zzid", 2));
  68. List<RepairUser> result = repairUserMapper.selectList(queryWrapper);
  69. return result;
  70. }
  71. @Override
  72. public PageUtils<RepairUserVo> queryPageRepairUser(int currentPage, int pageCount, String keyWork, Integer teamId, Integer schoolId) {
  73. Page<RepairUserVo> page = new Page<>();
  74. page.setCurrent(currentPage);
  75. page.setSize(pageCount);
  76. IPage<RepairUserVo> datas = repairUserMapper.queryUserPageList(page, schoolId == null ? null : String.valueOf(schoolId), teamId == null ? null : String.valueOf(teamId), keyWork);
  77. return new PageUtils(datas);
  78. }
  79. @Override
  80. public int deleteRepairUserById(int id) {
  81. int result = repairUserMapper.deleteById(id);
  82. return result;
  83. }
  84. @Override
  85. public RepairUser getRepairById(int id) {
  86. RepairUser result = repairUserMapper.selectById(id);
  87. return result;
  88. }
  89. @Override
  90. public RepairUser getRepairByCardNumber(String CardNumber) {
  91. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  92. queryWrapper.eq("card_number", CardNumber);
  93. RepairUser result = repairUserMapper.selectOne(queryWrapper);
  94. return result;
  95. }
  96. @Override
  97. public List<RepairUser> getRepairs(List<Integer> ids) {
  98. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  99. queryWrapper.in("id", ids);
  100. List<RepairUser> result = repairUserMapper.selectList(queryWrapper);
  101. return result;
  102. }
  103. @Override
  104. public List<RepairUser> getRepairByUserZZ(List<Integer> userZZId, Integer schoolId) {
  105. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  106. queryWrapper.in("user_zzid", userZZId);
  107. if (schoolId != null) {
  108. queryWrapper.eq("school_id", schoolId);
  109. }
  110. List<RepairUser> result = repairUserMapper.selectList(queryWrapper);
  111. return result;
  112. }
  113. @Override
  114. public List<RepairLogisticsVo> queryLogisticsList(Integer recordId) {
  115. List<RepairLogisticsVo> result = repairUserMapper.queryLogisticsList(recordId);
  116. return result;
  117. }
  118. @Override
  119. public UserDataVo queryUserData(Integer userId, String dateNow) {
  120. UserDataVo result = repairUserMapper.queryUserData(userId, dateNow);
  121. return result;
  122. }
  123. @Override
  124. public PageUtils<CollaboratorVo> queryCollaborator(int currentPage, int pageCount, Integer userId, Integer schoolId, String keyWord) {
  125. Page<CollaboratorVo> page = new Page<>();
  126. page.setCurrent(currentPage);
  127. page.setSize(pageCount);
  128. IPage<CollaboratorVo> result = repairUserMapper.queryCollaborator(page, userId, schoolId, keyWord);
  129. return new PageUtils(result);
  130. }
  131. @Override
  132. public List<AddressBookVo> queryAddressBook(Integer userId, Integer schoolId, String keyWord) {
  133. List<AddressBookVo> result = repairUserMapper.queryAddressBook(userId, schoolId, keyWord);
  134. return result;
  135. }
  136. @Override
  137. public PageUtils<AddressBookVo> queryUserPageBySchoolId(int currentPage, int pageCount, Integer schoolId) {
  138. Page<AddressBookVo> page = new Page<>();
  139. page.setCurrent(currentPage);
  140. page.setSize(pageCount);
  141. IPage<AddressBookVo> result = repairUserMapper.queryUserPageBySchoolId(page, schoolId);
  142. return new PageUtils(result);
  143. }
  144. @Override
  145. public List<AutoDispatchUserVo> autoDispatchUser(Integer schoolId, String dateNow, Integer articleId, Integer buildId) {
  146. List<AutoDispatchUserVo> result = repairUserMapper.autoDispatchUser(schoolId, dateNow, articleId, buildId, null);
  147. return result;
  148. }
  149. @Override
  150. public PageUtils<AutoDispatchUserVo> autoDispatchUser(int currentPage, int pageCount, Integer schoolId, String dateNow, Integer articleId, Integer buildId, String keyWord) {
  151. Page<AutoDispatchUserVo> page = new Page<>();
  152. page.setCurrent(currentPage);
  153. page.setSize(pageCount);
  154. IPage<AutoDispatchUserVo> result = repairUserMapper.autoDispatchUser(page, schoolId, dateNow, articleId, buildId, keyWord);
  155. return new PageUtils(result);
  156. }
  157. @Override
  158. public PageUtils<RepairWorkTypeVo> queryCollaboratorUser(int currentPage, int pageCount, Integer schoolId, Integer userId, String dateNow) {
  159. Page<RepairWorkTypeVo> page = new Page<>();
  160. page.setCurrent(currentPage);
  161. page.setSize(pageCount);
  162. IPage<RepairWorkTypeVo> result = repairUserMapper.queryCollaboratorUser(page, schoolId, userId, dateNow);
  163. return new PageUtils(result);
  164. }
  165. @Override
  166. public PageUtils<PositiveReviewVo> queryPositiveReviewPage(int currentPage, int pageCount, Integer schoolId) {
  167. Page<PositiveReviewVo> page = new Page<>();
  168. page.setCurrent(currentPage);
  169. page.setSize(pageCount);
  170. IPage<PositiveReviewVo> result = repairUserMapper.queryPositiveReviewPage(page, schoolId);
  171. return new PageUtils(result);
  172. }
  173. @Override
  174. public List<AutoDispatchUserVo> dropDown(Integer buildId, Integer articleId, Integer schoolId) {
  175. List<AutoDispatchUserVo> vos=repairUserMapper.dropDown(buildId,articleId,schoolId);
  176. return vos;
  177. }
  178. @Override
  179. public RepairUser queryUserByOpenid(String openId) {
  180. QueryWrapper<RepairUser> queryWrapper = new QueryWrapper<>();
  181. queryWrapper.eq("openid", openId);
  182. RepairUser rus = repairUserMapper.selectOne(queryWrapper);
  183. return rus;
  184. }
  185. }