SmartVisitorServiceImpl.java 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. package com.template.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.template.common.utils.TimeExchange;
  6. import com.template.mapper.SmartVisitorMapper;
  7. import com.template.model.pojo.SmartVisitor;
  8. import com.template.model.pojo.SmartVisitor;
  9. import com.template.mapper.SmartVisitorMapper;
  10. import com.template.model.result.PageUtils;
  11. import com.template.model.vo.SmartVisitorScreenVo;
  12. import com.template.model.vo.VisitorPageVo;
  13. import com.template.services.SmartVisitorService;
  14. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  15. import org.springframework.beans.factory.annotation.Autowired;
  16. import org.springframework.stereotype.Service;
  17. import org.springframework.util.StringUtils;
  18. import java.util.Date;
  19. import java.util.List;
  20. /**
  21. * <p>
  22. * 服务实现类
  23. * </p>
  24. *
  25. * @author ceshi
  26. * @since 2023-12-04
  27. */
  28. @Service
  29. public class SmartVisitorServiceImpl extends ServiceImpl<SmartVisitorMapper, SmartVisitor> implements SmartVisitorService {
  30. @Autowired
  31. private SmartVisitorMapper smartVisitorMapper;
  32. @Override
  33. public int insertSmartVisitor(SmartVisitor sa) {
  34. int result = smartVisitorMapper.insert(sa);
  35. return result;
  36. }
  37. @Override
  38. public int updateSmartVisitor(SmartVisitor sa) {
  39. int result = smartVisitorMapper.updateById(sa);
  40. return result;
  41. }
  42. @Override
  43. public PageUtils<SmartVisitor> queryPageSmartVisitors(int currentPage, int pageCount, String name) {
  44. Page<SmartVisitor> page = new Page<>(currentPage, pageCount);
  45. QueryWrapper<SmartVisitor> queryWrapper = new QueryWrapper<>();
  46. //queryWrapper.like(StringUtils.hasText(name), "name", name);
  47. IPage<SmartVisitor> result = smartVisitorMapper.selectPage(page, queryWrapper);
  48. return new PageUtils<>(result);
  49. }
  50. @Override
  51. public int deleteSmartVisitorById(int id) {
  52. int result = smartVisitorMapper.deleteById(id);
  53. return result;
  54. }
  55. @Override
  56. public SmartVisitor getSmartById(int id) {
  57. SmartVisitor result = smartVisitorMapper.selectById(id);
  58. return result;
  59. }
  60. @Override
  61. public boolean insertVisitorBatch(List<SmartVisitor> visitors) {
  62. boolean result = this.saveBatch(visitors);
  63. return result;
  64. }
  65. @Override
  66. public PageUtils<VisitorPageVo> smartVisitorPageByUserId(int currentPage, int pageCount, Integer userId, Integer statu, String createStartTime, String createEndTime, String keyWord, String visitorStartTime, String visitorEndTime) {
  67. Page<VisitorPageVo> page = new Page<>();
  68. page.setCurrent(currentPage);
  69. page.setSize(pageCount);
  70. IPage<VisitorPageVo> datas = smartVisitorMapper.queryVisitorPage(page, userId, statu, createStartTime, createEndTime, keyWord, visitorStartTime, visitorEndTime);
  71. return new PageUtils(datas);
  72. }
  73. @Override
  74. public Integer queryVisitorCount(String cardNo, String startTime, String endTime) {
  75. Integer result = smartVisitorMapper.queryVisitorCount(cardNo, startTime, endTime);
  76. return result;
  77. }
  78. @Override
  79. public PageUtils<SmartVisitor> queryVisitorPageDatas(int currentPage, int pageCount, Integer type, List<Integer> studentIds, String isAdmin) {
  80. Page<SmartVisitor> page = new Page<>();
  81. page.setCurrent(currentPage);
  82. page.setSize(pageCount);
  83. IPage<SmartVisitor> datas = smartVisitorMapper.queryVisitorPageDatas(page, type, studentIds, isAdmin);
  84. return new PageUtils(datas);
  85. }
  86. @Override
  87. public SmartVisitor querySmartVisitorByCode(String visitorCode) {
  88. QueryWrapper<SmartVisitor> queryWrapper = new QueryWrapper<>();
  89. queryWrapper.eq(StringUtils.hasText(visitorCode), "visitor_code", visitorCode);
  90. SmartVisitor result = smartVisitorMapper.selectOne(queryWrapper);
  91. return result;
  92. }
  93. @Override
  94. public SmartVisitor queryParentVisitor(Integer userId) {
  95. QueryWrapper<SmartVisitor> queryWrapper = new QueryWrapper<>();
  96. String nowTime = TimeExchange.getTime();
  97. queryWrapper.le("visitor_time", nowTime);//<=
  98. queryWrapper.ge("visitor_deadline", nowTime);//>=
  99. queryWrapper.eq("user_id", userId);
  100. queryWrapper.eq("statu",3);//必须是已推送的
  101. queryWrapper.orderByAsc("visitor_time");
  102. List<SmartVisitor> resultDatas = smartVisitorMapper.selectList(queryWrapper);
  103. return resultDatas != null && resultDatas.size() > 0 ? resultDatas.get(0) : null;
  104. }
  105. @Override
  106. public PageUtils<SmartVisitor> getPage(int currentPage, int pageCount,Integer type, String keyWord, Integer status, String startTime, String endTime, String visitorStartTime, String visitorEndTime) {
  107. Page<SmartVisitor> page = new Page<>();
  108. page.setCurrent(currentPage);
  109. page.setSize(pageCount);
  110. IPage<VisitorPageVo> datas = smartVisitorMapper.getPage(page,type,keyWord,status,startTime,endTime,visitorStartTime,visitorEndTime);
  111. return new PageUtils(datas);
  112. }
  113. @Override
  114. public PageUtils<SmartVisitorScreenVo> getScreenPage(int currentPage, int pageCount, String phone, String status) {
  115. Page<SmartVisitorScreenVo> page = new Page<>();
  116. page.setCurrent(currentPage);
  117. page.setSize(pageCount);
  118. IPage<SmartVisitorScreenVo> datas = smartVisitorMapper.getScreenPage(page,phone,status);
  119. return new PageUtils(datas);
  120. }
  121. }