| | |
| | | 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, "|") + "'"; |
| | | } |
| | | |
| | | /** |
| | |
| | | } |
| | | |
| | | /** |
| | | * 设置 右like |
| | | * 设置 右like * |
| | | */ |
| | | 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)); |
| | |
| | | } |
| | | |
| | | 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; |
| | | } |