querydsl个人使用记录

最新推荐文章于 2021-07-29 11:30:17 发布

无名小仙男

最新推荐文章于 2021-07-29 11:30:17 发布

阅读量256

点赞数

分类专栏： querydsl

本文链接：https://blog.csdn.net/zxl8876/article/details/103991991

版权

querydsl 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

暂时没有找到解决方案：
1.查菜单时递归查询/oracle树查询，暂时不能满足
解决方案（遍历拼接多个or orgId in(’’)条件）：

private void getDepOrgIdIn(QMedDepInfo qMedDepInfo, JPAQuery<DictAuditDto> jpaQuery, List<String> orgIdList) {
		SysUserDto currentSysUser = JwtUtil.getCurrentSysUser();
		if (CommonUtils.isEmpty(orgIdList))
			orgIdList = currentSysUser.getOrgIdList();
		// jpaQuery.where(qMedDepInfo.id.orgId.in(orgIdList));
		int psize = 1000;
		if (orgIdList.size() > psize) {
			int size = (orgIdList.size() / psize);
			int yu = orgIdList.size() % psize;
			size = (yu == 0) ? size : ++size;
			String[] notIn = new String[] { "111" };
			BooleanExpression in = qMedDepInfo.id.orgId.notIn(notIn);
			for (int i = 0; i < size; i++) {
				// 获取1000条,拼接in条件
				int start = i * psize;
				int end = i * psize + psize;
				if (yu != 0 && i == size - 1) {
					end = i * psize + yu;
				}
				List<String> newList = orgIdList.subList(start, end);
				in = in.or(qMedDepInfo.id.orgId.in(newList));
			}
			jpaQuery.where(in);
		} else {
			jpaQuery.where(qMedDepInfo.id.orgId.in(orgIdList));
		}
	}