From bfc1c1abd1d1deab45740806ce984b6774a319bd Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 05 二月 2024 11:01:13 +0800 Subject: [PATCH] 修改目录编码过滤功能 --- src/main/java/com/lf/server/service/show/DataLibService.java | 21 ++++++++++++++------- 1 files changed, 14 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/lf/server/service/show/DataLibService.java b/src/main/java/com/lf/server/service/show/DataLibService.java index e6f839b..7815f85 100644 --- a/src/main/java/com/lf/server/service/show/DataLibService.java +++ b/src/main/java/com/lf/server/service/show/DataLibService.java @@ -287,12 +287,19 @@ return null; } - List<String> list = Arrays.asList(codes.split(",")); + //List<String> list = Arrays.asList(codes.split(",")); //List<String> list = codesAsList(codes); //list = copeDirCodes(list); - setRightLike(list, field); + //setRightLike(list, field); - return "(" + StringHelper.join(list, " or ") + ")"; + //return "(" + StringHelper.join(list, " or ") + ")"; + + List<String> list = new ArrayList<>(); + for (String dir : codes.split(",")) { + list.add("^" + dir); + } + + return field + " ~ '" + StringHelper.join(list, "|") + "'"; } /** @@ -370,13 +377,13 @@ } /** - * 璁剧疆 鍙砽ike + * 璁剧疆 鍙砽ike * */ private static void setRightLike(List<String> list, String field) { - /*if (list.isEmpty()) { + if (list.isEmpty()) { list.add("1 = 2"); return; - }*/ + } for (int i = 0, c = list.size(); i < c; i++) { String str = String.format("%s like '%s%%'", field, list.get(i)); @@ -393,7 +400,7 @@ } if (!StringUtils.isEmpty(types)) { - List<KeyValueEntity> list = baseQueryService.selectDirsByTypes(types.split(","), dirs); + List<KeyValueEntity> list = baseQueryService.selectDirsByTypes(types.split(","), copeCodes(dirs, "code")); if (null == list || list.isEmpty()) { return null; } -- Gitblit v1.9.3