From 4d02466fed4f3ea012a80c3359cde9af0737141f Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期一, 21 十一月 2022 20:01:12 +0800 Subject: [PATCH] add 增加 skywalking 集成 默认注释不开启 --- ruoyi-common/src/main/java/com/ruoyi/common/core/domain/PageQuery.java | 67 +++++++++++++++++++++------------ 1 files changed, 43 insertions(+), 24 deletions(-) diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/PageQuery.java b/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/PageQuery.java index 5ffd588..60abde6 100644 --- a/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/PageQuery.java +++ b/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/PageQuery.java @@ -1,15 +1,17 @@ package com.ruoyi.common.core.domain; +import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjectUtil; import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.ruoyi.common.exception.ServiceException; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.sql.SqlUtil; -import io.swagger.annotations.ApiModelProperty; import lombok.Data; -import lombok.experimental.Accessors; import java.io.Serializable; +import java.util.ArrayList; +import java.util.List; /** * 鍒嗛〉鏌ヨ瀹炰綋绫� @@ -18,7 +20,6 @@ */ @Data -@Accessors(chain = true) public class PageQuery implements Serializable { private static final long serialVersionUID = 1L; @@ -26,25 +27,21 @@ /** * 鍒嗛〉澶у皬 */ - @ApiModelProperty("鍒嗛〉澶у皬") private Integer pageSize; /** * 褰撳墠椤垫暟 */ - @ApiModelProperty("褰撳墠椤垫暟") private Integer pageNum; /** * 鎺掑簭鍒� */ - @ApiModelProperty("鎺掑簭鍒�") private String orderByColumn; /** * 鎺掑簭鐨勬柟鍚慸esc鎴栬�卆sc */ - @ApiModelProperty(value = "鎺掑簭鐨勬柟鍚�", example = "asc,desc") private String isAsc; /** @@ -64,30 +61,52 @@ pageNum = DEFAULT_PAGE_NUM; } Page<T> page = new Page<>(pageNum, pageSize); - OrderItem orderItem = buildOrderItem(); - if (ObjectUtil.isNotNull(orderItem)) { - page.addOrder(orderItem); + List<OrderItem> orderItems = buildOrderItem(); + if (CollUtil.isNotEmpty(orderItems)) { + page.addOrder(orderItems); } return page; } - private OrderItem buildOrderItem() { - // 鍏煎鍓嶇鎺掑簭绫诲瀷 - if ("ascending".equals(isAsc)) { - isAsc = "asc"; - } else if ("descending".equals(isAsc)) { - isAsc = "desc"; + /** + * 鏋勫缓鎺掑簭 + * + * 鏀寔鐨勭敤娉曞涓�: + * {isAsc:"asc",orderByColumn:"id"} order by id asc + * {isAsc:"asc",orderByColumn:"id,createTime"} order by id asc,create_time asc + * {isAsc:"desc",orderByColumn:"id,createTime"} order by id desc,create_time desc + * {isAsc:"asc,desc",orderByColumn:"id,createTime"} order by id asc,create_time desc + */ + private List<OrderItem> buildOrderItem() { + if (StringUtils.isBlank(orderByColumn) || StringUtils.isBlank(isAsc)) { + return null; } - if (StringUtils.isNotBlank(orderByColumn)) { - String orderBy = SqlUtil.escapeOrderBySql(orderByColumn); - orderBy = StringUtils.toUnderScoreCase(orderBy); - if ("asc".equals(isAsc)) { - return OrderItem.asc(orderBy); - } else if ("desc".equals(isAsc)) { - return OrderItem.desc(orderBy); + String orderBy = SqlUtil.escapeOrderBySql(orderByColumn); + orderBy = StringUtils.toUnderScoreCase(orderBy); + + // 鍏煎鍓嶇鎺掑簭绫诲瀷 + isAsc = StringUtils.replaceEach(isAsc, new String[]{"ascending", "descending"}, new String[]{"asc", "desc"}); + + String[] orderByArr = orderBy.split(","); + String[] isAscArr = isAsc.split(","); + if (isAscArr.length != 1 && isAscArr.length != orderByArr.length) { + throw new ServiceException("鎺掑簭鍙傛暟鏈夎"); + } + + List<OrderItem> list = new ArrayList<>(); + // 姣忎釜瀛楁鍚勮嚜鎺掑簭 + for (int i = 0; i < orderByArr.length; i++) { + String orderByStr = orderByArr[i]; + String isAscStr = isAscArr.length == 1 ? isAscArr[0] : isAscArr[i]; + if ("asc".equals(isAscStr)) { + list.add(OrderItem.asc(orderByStr)); + } else if ("desc".equals(isAscStr)) { + list.add(OrderItem.desc(orderByStr)); + } else { + throw new ServiceException("鎺掑簭鍙傛暟鏈夎"); } } - return null; + return list; } } -- Gitblit v1.9.3