用户筛选查询更新

whyczh

2021-05-11 184f766bcd42f1aef306b3725ed66de205743985

用户筛选查询更新

 src/main/java/com/whyc/service/UserService.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.api.R;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.whyc.dto.Response;
@@ -81,10 +82,10 @@

    public Response<IPage<User>> getPageByCondition(int pageNum,int pageSize,User user){
        QueryWrapper<User> queryWrapper = new QueryWrapper<>(user);
        queryWrapper.or().like(!user.getSearch().isEmpty(),"name",user.getSearch());
        queryWrapper.or().like(!user.getSearch().isEmpty(),"real_name",user.getSearch());
        queryWrapper.or().like(!user.getSearch().isEmpty(),"phone",user.getSearch());
        queryWrapper.or().like(!user.getSearch().isEmpty(),"email",user.getSearch());
        queryWrapper.or().like(StringUtils.isNotEmpty(user.getSearch()) ,"name",user.getSearch());
        queryWrapper.or().like(StringUtils.isNotEmpty(user.getSearch()),"real_name",user.getSearch());
        queryWrapper.or().like(StringUtils.isNotEmpty(user.getSearch()),"phone",user.getSearch());
        queryWrapper.or().like(StringUtils.isNotEmpty(user.getSearch()),"email",user.getSearch());
        IPage<User> page = userMapper.selectPage(new Page<>(pageNum,pageSize),queryWrapper);
        return new Response<IPage<User>>().set(1,page);
    }