From a8ab035ff7230b4cc4e218f531ac81c1e3f08398 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期三, 03 七月 2024 11:40:40 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/DolphinEnglish

---
 ruoyi-service/ruoyi-goods/src/main/java/com/ruoyi/goods/controller/TGoodsController.java |   25 +++++++++++++++++++------
 1 files changed, 19 insertions(+), 6 deletions(-)

diff --git a/ruoyi-service/ruoyi-goods/src/main/java/com/ruoyi/goods/controller/TGoodsController.java b/ruoyi-service/ruoyi-goods/src/main/java/com/ruoyi/goods/controller/TGoodsController.java
index 2330d59..a9a60a1 100644
--- a/ruoyi-service/ruoyi-goods/src/main/java/com/ruoyi/goods/controller/TGoodsController.java
+++ b/ruoyi-service/ruoyi-goods/src/main/java/com/ruoyi/goods/controller/TGoodsController.java
@@ -98,6 +98,10 @@
             wrapper.eq("typeIds",substring);
         }
         wrapper.eq("isDelete", 0);
+        // sort排序
+        wrapper.orderByAsc("CASE WHEN sort IS NULL THEN 1 ELSE 0 END")
+                .orderByAsc("sort")
+                .orderByDesc("createTime");
         return R.ok(goodsService.page(new PageInfo<>(goodQuery.getPageNumber(), goodQuery.getPageSize()), wrapper));
     }
 
@@ -123,7 +127,10 @@
             wrapper.eq("typeIds",substring);
         }
         wrapper.eq("isDelete", 0);
-        wrapper.orderByAsc("sort");
+        // sort排序
+        wrapper.orderByAsc("CASE WHEN sort IS NULL THEN 1 ELSE 0 END")
+                .orderByAsc("sort")
+                .orderByDesc("createTime");
         return R.ok(goodsService.page(new PageInfo<>(goodQuery.getPageNumber(), goodQuery.getPageSize()), wrapper));
     }
 
@@ -770,6 +777,13 @@
                 .eq(Recipient::getUserId, tokenService.getLoginUserStudy().getUserid())
                 .eq(Recipient::getIsDefault, 1)
                 .eq(Recipient::getDisabled, 0).one();
+        if (null == recipient) {
+            recipient = recipientService.lambdaQuery()
+                    .eq(Recipient::getUserId, tokenService.getLoginUserStudy().getUserid())
+                    .eq(Recipient::getDisabled, 0)
+                    .orderByDesc(Recipient::getCreateTime)
+                    .last("limit 1").one();
+        }
         GoodDetailVO goodDetailVO = goodsService.redeemNow(goodId, recipient);
         LocalDateTime currentDateTime = LocalDateTime.now();
         // 格式化日期和时间信息
@@ -806,12 +820,11 @@
                 .eq(Recipient::getIsDefault, 1).one();
         if (recipient == null) {
             // 随便取一条地址数据
-            List<Recipient> list = recipientService.lambdaQuery()
+            recipient = recipientService.lambdaQuery()
                     .eq(Recipient::getUserId, tokenService.getLoginUser1().getUserid())
-                    .list();
-            if (!list.isEmpty()) {
-                recipient = list.get(0);
-            }
+                    .orderByDesc(Recipient::getCreateTime)
+                    .eq(Recipient::getDisabled, 0).last("limit 1")
+                    .one();
         }
         GoodDetailVO goodDetailVO = goodsService.redeemNow(goodId, recipient);
         LocalDateTime currentDateTime = LocalDateTime.now();

--
Gitblit v1.7.1