WtAlysisDayService.java 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. package com.gyee.runeconomy.service;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.gyee.runeconomy.model.auto.ProEconWtAlysisDay;
  5. import com.gyee.runeconomy.service.auto.IProEconWtAlysisDayService;
  6. import com.gyee.runeconomy.util.StringUtils;
  7. import org.springframework.stereotype.Service;
  8. import javax.annotation.Resource;
  9. import java.text.ParseException;
  10. import java.text.SimpleDateFormat;
  11. import java.util.Date;
  12. @Service
  13. public class WtAlysisDayService {
  14. @Resource
  15. private IProEconWtAlysisDayService proEconWtAlysisDayService;
  16. public Page<ProEconWtAlysisDay> wtAlysisDayList(Integer pageNum, Integer pageSize, String wtId, String beginDate, String endDate) {
  17. if (StringUtils.empty(pageNum)) {
  18. pageNum = 1;
  19. }
  20. if (StringUtils.empty(pageSize)) {
  21. pageSize = 10;
  22. }
  23. //构造分页构造器
  24. Page<ProEconWtAlysisDay> pageInfo = new Page<>(pageNum, pageSize);
  25. if (StringUtils.notEmp(wtId) && StringUtils.notEmp(beginDate) && StringUtils.notEmp(endDate)) {
  26. String format = "yyyy-MM-dd";
  27. SimpleDateFormat df = new SimpleDateFormat(format);
  28. Date begin = null;
  29. Date end = null;
  30. try {
  31. begin = df.parse(beginDate);
  32. end = df.parse(endDate);
  33. } catch (ParseException e) {
  34. e.printStackTrace();
  35. }
  36. //构造条件构造器
  37. LambdaQueryWrapper<ProEconWtAlysisDay> queryWrapper = new LambdaQueryWrapper<>();
  38. //添加过滤条件
  39. queryWrapper.eq(ProEconWtAlysisDay::getWindturbineId, wtId).
  40. ge(ProEconWtAlysisDay::getRecordDate, begin).
  41. le(ProEconWtAlysisDay::getRecordDate, end);
  42. queryWrapper.orderByAsc(ProEconWtAlysisDay::getRecordDate);
  43. //执行查询
  44. proEconWtAlysisDayService.page(pageInfo, queryWrapper);
  45. }
  46. return pageInfo;
  47. }
  48. }