阅读 204

queryWrapper in like

 

 

//构建条件
        QueryWrapper wrapper = new QueryWrapper<>();
//        wrapper.eq("deleted","0");

        String username = userAuthUtil.getUserName().get();
        if(!username.equals("admin")){
            Long user_id = userAuthUtil.getUserId().get();
            List erpGroupMemberList = erpGroupMemberService.getErpGroupMemberByUserId(user_id);

//            Long[] id_arr = new Long[erpGroupMemberList.size()];
//            for(int i=0;i//                id_arr[i]=erpGroupMemberList.get(i).getGroupId();
//            }
//            List  idList=Arrays.asList(id_arr);

//            List idList = new ArrayList<>();
//            erpGroupMemberList .forEach(n -> idList.add(n.getGroupId()));
//            wrapper.in("id", idList);

//            queryWrapper.and(Wrapper -> Wrapper.eq(PcmArticle::getAuState, "1").or().eq(PcmArticle::getAuState, "2"));
//            QueryWrapper like_wrapper = new QueryWrapper<>();
//            for(int i=0;i//                Long group_id = erpGroupMemberList.get(i).getGroupId();
//                ErpGroup erpGroup = baseMapper.selectById(group_id);
//                String group_path = erpGroup.getPath();
//                if(like_wrapper.isEmptyOfWhere()){
//                    like_wrapper.likeRight("path",erpGroup.getPath());
//                }else{
//                    like_wrapper.or().likeRight("path",erpGroup.getPath());
//                }
//            }
//            wrapper.and((Consumer>) like_wrapper);

            wrapper.and(wr->{
//                String[] deviceIds = StringUtils.split(deviceIdArr, ",");
//                Arrays.stream(deviceIds).forEach(e->{
//                    wr.eq("id", e).or();
//                });

//                for(int i=0;i
////                    ErpGroup erpGroup = baseMapper.selectById( erpGroupMemberList.get(i).getGroupId());
////                    if(wr.isEmptyOfWhere()){
////                        wr.likeRight("path",erpGroup.getPath());
////                    }else{
////                        wr.or().likeRight("path",erpGroup.getPath());
////                    }
////                }
                erpGroupMemberList.forEach(e->{
                    wr.likeRight("path",baseMapper.selectById(e.getGroupId()).getPath()).or();
                });
            });

        }

        Long id = erpGroupQuery.getId();
        if(id != null) wrapper.eq("id", id);
        if (!StringUtils.isEmpty(erpGroupQuery.getCode())){
            wrapper.eq("code", erpGroupQuery.getCode());
        }
        if (!StringUtils.isEmpty(erpGroupQuery.getName())){
            wrapper.eq("name", erpGroupQuery.getName());
        }
        Long parentId = erpGroupQuery.getParentId();
        if(parentId != null) wrapper.eq("parent_id", parentId);
        if (!StringUtils.isEmpty(erpGroupQuery.getPath())){
            wrapper.like("name", erpGroupQuery.getPath());
        }
        if (!StringUtils.isEmpty(erpGroupQuery.getType())){
            wrapper.eq("type", erpGroupQuery.getType());
        }
        Integer groupType = erpGroupQuery.getGroupType();
        if(groupType != null) wrapper.eq("group_type", groupType);
        if (!StringUtils.isEmpty(erpGroupQuery.getDescription())){
            wrapper.eq("description", erpGroupQuery.getDescription());
        }
        Long ownership = erpGroupQuery.getOwnership();
        if(ownership != null) wrapper.eq("ownership", ownership);
        Boolean status = erpGroupQuery.getStatus();
        if(status != null) wrapper.eq("status", status);
        return baseMapper.selectList(wrapper);

 

原文:https://www.cnblogs.com/mingforyou/p/14678617.html

文章分类
代码人生
版权声明:本站是系统测试站点,无实际运营。本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 XXXXXXo@163.com 举报,一经查实,本站将立刻删除。
相关推荐