operation order desc

robinji0 · robinji0 · commit 3b1c197425ac · 2023-11-30T17:57:42.000+08:00
diff --git a/chat2db-server/chat2db-server-domain/chat2db-server-domain-api/src/main/java/ai/chat2db/server/domain/api/param/operation/OperationPageQueryParam.java b/chat2db-server/chat2db-server-domain/chat2db-server-domain-api/src/main/java/ai/chat2db/server/domain/api/param/operation/OperationPageQueryParam.java
@@ -40,7 +40,12 @@ public class OperationPageQueryParam extends PageQueryParam {
     /**
      * orderBy modify time desc
      */
-    private boolean orderByDesc;
+    private Boolean orderByDesc;
+
+    /**
+     * orderBy create time desc
+     */
+    private Boolean orderByCreateDesc;
 
     /**
      * operation type
diff --git a/chat2db-server/chat2db-server-domain/chat2db-server-domain-core/src/main/java/ai/chat2db/server/domain/core/impl/OperationServiceImpl.java b/chat2db-server/chat2db-server-domain/chat2db-server-domain-core/src/main/java/ai/chat2db/server/domain/core/impl/OperationServiceImpl.java
@@ -143,10 +143,11 @@ public PageResult<Operation> queryPage(OperationPageQueryParam param) {
         Integer offset = param.getPageSize();
         Page<OperationSavedDO> page = new Page<>(start, offset);
         page.setOptimizeCountSql(false);
-        if (param.isOrderByDesc()) {
+        if (Objects.nonNull(param.getOrderByDesc()) && param.getOrderByDesc()) {
             queryWrapper.orderByDesc("gmt_modified");
-        } else {
-            queryWrapper.orderByAsc("gmt_modified");
+        }
+        if (Objects.nonNull(param.getOrderByCreateDesc()) && param.getOrderByCreateDesc()) {
+            queryWrapper.orderByDesc("gmt_create");
         }
         IPage<OperationSavedDO> iPage = operationSavedMapper.selectPage(page, queryWrapper);
         List<Operation> userSavedDdlDOS = operationConverter.do2dto(iPage.getRecords());
diff --git a/chat2db-server/chat2db-server-web/chat2db-server-web-api/src/main/java/ai/chat2db/server/web/api/controller/operation/saved/request/OperationQueryRequest.java b/chat2db-server/chat2db-server-web/chat2db-server-web-api/src/main/java/ai/chat2db/server/web/api/controller/operation/saved/request/OperationQueryRequest.java
@@ -42,6 +42,11 @@ public class OperationQueryRequest extends PageQueryRequest {
      */
     private Boolean orderByDesc;
 
+    /**
+     * orderBy create time desc
+     */
+    private Boolean orderByCreateDesc;
+
     /**
      * operation type
      */
