package com.ruoyi.demo.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.ruoyi.demo.entity.DlUser; import com.ruoyi.demo.entity.bo.PlanBo; import com.ruoyi.demo.entity.vo.DlUserListVo; import com.ruoyi.demo.mapper.DlUserMapper; import com.ruoyi.demo.service.DlUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.ArrayList; import java.util.List; @Service @Transactional public class DlUserServiceImpl implements DlUserService { @Autowired DlUserMapper dlUserMapper; @Override public PageInfo> getList(PlanBo bo) { PageHelper.startPage(bo.getPageNum(),bo.getPageSize(),true); QueryWrapper queryWrapper = new QueryWrapper<>(); if (bo.getText() != null) queryWrapper.and(dlUserQueryWrapper -> { dlUserQueryWrapper.like("user_id",bo.getText()) .or() .like("user_name",bo.getText()) .or() .like("user_telephone",bo.getText()); }); if (bo.getStartTime() != null) queryWrapper.and(dlUserQueryWrapper -> { dlUserQueryWrapper.apply("end_time >= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getStartTime()) .or() .apply("start_time >= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getStartTime()); }); if (bo.getEndTime() != null) queryWrapper.and(dlUserQueryWrapper -> { dlUserQueryWrapper.apply("end_time <= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getEndTime()) .or() .apply("start_time <= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getEndTime()); }); queryWrapper.eq("deleted","0"); List dlUsers = dlUserMapper.selectList(queryWrapper); List vos = new ArrayList<>(); for (DlUser user : dlUsers){ vos.add(new DlUserListVo(user)); } return new PageInfo(vos); } }