From 0345d3175861c5612e937487770a5ba4e8468b14 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期六, 10 五月 2025 09:49:52 +0800 Subject: [PATCH] 收货单打印功能优化 --- rsf-server/src/main/java/com/vincent/rsf/server/common/domain/PageParam.java | 81 ++++++++++++++++++++++++---------------- 1 files changed, 49 insertions(+), 32 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/common/domain/PageParam.java b/rsf-server/src/main/java/com/vincent/rsf/server/common/domain/PageParam.java index ea2e93f..e116812 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/common/domain/PageParam.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/common/domain/PageParam.java @@ -71,7 +71,7 @@ } public QueryWrapper<T> buildWrapper(boolean like, List<String> fields) { - return this.buildWrapper(like, null,"create_time", fields); + return this.buildWrapper(like, null, "create_time", fields); } @SuppressWarnings("all") @@ -98,10 +98,13 @@ if (this.isToUnderlineCase) { key = Utils.toSymbolCase(key, '_'); } + String finalKey = key; if (like && key.contains(timeField)) { - queryWrapper.like("`" + key + "`", val); + queryWrapper.and(wrapper -> wrapper.like("`" + finalKey + "`", val)); +// queryWrapper.like("`" + key + "`", val); } else { - queryWrapper.eq("`" + key + "`", val); + queryWrapper.and(wrapper -> wrapper.eq("`" + finalKey + "`", val)); +// queryWrapper.eq("`" + key + "`", val); } } } @@ -130,41 +133,42 @@ if (!Cools.isEmpty(where.getCondition()) && !Cools.isEmpty(cls)) { List<String> columns = new ArrayList<>(); - for (Field field : Cools.getAllFields(cls)){ + for (Field field : Cools.getAllFields(cls)) { if (Modifier.isFinal(field.getModifiers()) || Modifier.isStatic(field.getModifiers()) - || Modifier.isTransient(field.getModifiers())){ + || Modifier.isTransient(field.getModifiers())) { continue; } - if (field.isAnnotationPresent(TableField.class)){ + if (field.isAnnotationPresent(TableField.class)) { TableField annotation = field.getAnnotation(TableField.class); if (!annotation.exist()) { continue; } } - String column = Utils.toSymbolCase(field.getName(), '_'); + String column = Utils.toSymbolCase(field.getName(), '_'); columns.add(column); } if (!columns.isEmpty()) { - for (int i=0;i<columns.size();i++){ - String column = columns.get(i); - String condition = where.getCondition(); - - if (i == 0) { - queryWrapper.and(wrapper -> wrapper.like("`" + column + "`", condition)); - } else { - queryWrapper.or().like("`" + column + "`", condition); + queryWrapper.and(wrapper -> { + for (int i = 0; i < columns.size(); i++) { + String column = columns.get(i); + String condition = where.getCondition(); + if (i == 0) { + wrapper.or().like("`" + column + "`", condition); + } else { + wrapper.or().like("`" + column + "`", condition); + } } - } + }); } } return queryWrapper; } @SuppressWarnings("all") - public QueryWrapper<T> buildWrapper(boolean like, Consumer<QueryWrapper<T>> consumer,String timeField, List<String> fields) { + public QueryWrapper<T> buildWrapper(boolean like, Consumer<QueryWrapper<T>> consumer, String timeField, List<String> fields) { QueryWrapper<T> queryWrapper = new QueryWrapper<>(); Map<String, Object> map = where.getMap(); for (String key : map.keySet()) { @@ -188,9 +192,9 @@ key = Utils.toSymbolCase(key, '_'); } if (like && !fields.contains(key)) { - queryWrapper.like("`" + key + "`", val); + queryWrapper.like("`" + key + "`", val); } else { - queryWrapper.eq("`" + key + "`", val); + queryWrapper.eq("`" + key + "`", val); } } } @@ -219,34 +223,47 @@ if (!Cools.isEmpty(where.getCondition()) && !Cools.isEmpty(cls)) { List<String> columns = new ArrayList<>(); - for (Field field : Cools.getAllFields(cls)){ + for (Field field : Cools.getAllFields(cls)) { if (Modifier.isFinal(field.getModifiers()) || Modifier.isStatic(field.getModifiers()) - || Modifier.isTransient(field.getModifiers())){ + || Modifier.isTransient(field.getModifiers())) { continue; } - if (field.isAnnotationPresent(TableField.class)){ + if (field.isAnnotationPresent(TableField.class)) { TableField annotation = field.getAnnotation(TableField.class); if (!annotation.exist()) { continue; } } - String column = Utils.toSymbolCase(field.getName(), '_'); + String column = Utils.toSymbolCase(field.getName(), '_'); columns.add(column); } +// if (!columns.isEmpty()) { +// for (int i=0;i<columns.size();i++){ +// String column = columns.get(i); +// String condition = where.getCondition(); +// +// if (i == 0) { +// queryWrapper.and(wrapper -> wrapper.like("`" + column + "`", condition)); +// } else { +// queryWrapper.or().like("`" + column + "`", condition); +// } +// } +// } if (!columns.isEmpty()) { - for (int i=0;i<columns.size();i++){ - String column = columns.get(i); - String condition = where.getCondition(); - - if (i == 0) { - queryWrapper.and(wrapper -> wrapper.like("`" + column + "`", condition)); - } else { - queryWrapper.or().like("`" + column + "`", condition); + queryWrapper.and(wrapper -> { + for (int i = 0; i < columns.size(); i++) { + String column = columns.get(i); + String condition = where.getCondition(); + if (i == 0) { + wrapper.or().like("`" + column + "`", condition); + } else { + wrapper.or().like("`" + column + "`", condition); + } } - } + }); } } return queryWrapper; -- Gitblit v1.9.1