StatisticsServiceImpl.java 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. package com.ruoyi.demo.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.github.pagehelper.PageHelper;
  4. import com.github.pagehelper.PageInfo;
  5. import com.ruoyi.demo.entity.Statistics;
  6. import com.ruoyi.demo.entity.bo.PlanBo;
  7. import com.ruoyi.demo.entity.vo.PlanHomeVo;
  8. import com.ruoyi.demo.entity.vo.ScanListVo;
  9. import com.ruoyi.demo.mapper.StatisticsMapper;
  10. import com.ruoyi.demo.service.StatisticsService;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Service;
  13. import org.springframework.transaction.annotation.Transactional;
  14. import java.time.LocalDateTime;
  15. import java.time.ZoneId;
  16. import java.util.ArrayList;
  17. import java.util.List;
  18. @Service
  19. @Transactional
  20. public class StatisticsServiceImpl implements StatisticsService {
  21. @Autowired
  22. StatisticsMapper statisticsMapper;
  23. @Override
  24. public PageInfo<List<ScanListVo>> getScanList(PlanBo bo) {
  25. PageHelper.startPage(bo.getPageNum(),bo.getPageSize(),true);
  26. QueryWrapper<Statistics> queryWrapper = new QueryWrapper<>();
  27. if (bo.getStartTime() != null)
  28. queryWrapper.apply("DATE_FORMAT(`time`,'%Y-%m-%d %H:%i:%s') >= DATE_FORMAT({0},'%Y-%m-%d %H:%i:%s')",bo.getStartTime());
  29. if (bo.getEndTime() != null)
  30. queryWrapper.apply("DATE_FORMAT(`time`,'%Y-%m-%d %H:%i:%s') <= DATE_FORMAT({0},'%Y-%m-%d %H:%i:%s')",bo.getEndTime());
  31. List<Statistics> list = statisticsMapper.selectList(queryWrapper);
  32. List<ScanListVo> vos = new ArrayList<>();
  33. for (Statistics statistics : list){
  34. vos.add(new ScanListVo(statistics));
  35. }
  36. return new PageInfo(vos);
  37. }
  38. @Override
  39. public PlanHomeVo getScanTotal() {
  40. PlanHomeVo vo = new PlanHomeVo();
  41. vo.setTotal(statisticsMapper.selectTotal());
  42. vo.setTime(LocalDateTime.now(ZoneId.of("Asia/Shanghai")));
  43. return vo;
  44. }
  45. @Override
  46. public int add(Statistics bo) {
  47. return statisticsMapper.insert(bo);
  48. }
  49. }