From ee9688b912bb993b54252a26f8ad9e0e04df21c3 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 21 六月 2024 18:11:21 +0800
Subject: [PATCH] 修改bug

---
 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/listener/RedisListener.java                             |    4 
 ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml                                         |   15 -----
 ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionVideoServiceImpl.java       |    1 
 ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionGoodsServiceImpl.java             |    9 +-
 ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionBannerServiceImpl.java      |    1 
 ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/CouponServiceImpl.java               |    1 
 ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/MemberInvoiceServiceImpl.java                |    4 
 ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/ArticleCommentsServiceImpl.java          |    1 
 ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionSalesroomServiceImpl.java         |   31 ++++++++-
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsFlavorTypeServiceImpl.java              |    3 
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java                     |   21 +++++-
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsCategoryServiceImpl.java                |    3 
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsBrandServiceImpl.java                   |    3 
 ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionWishListServiceImpl.java    |    2 
 ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/IAuctionSalesroomService.java                 |    4 
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsInfoTitleServiceImpl.java               |    1 
 ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/controller/management/MgtAuctionScreenController.java |   12 +++
 ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java                     |    1 
 ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/SensitiveWordsServiceImpl.java           |    3 
 ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSeriesServiceImpl.java                  |    3 
 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java                    |    7 ++
 21 files changed, 86 insertions(+), 44 deletions(-)

diff --git a/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/ArticleCommentsServiceImpl.java b/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/ArticleCommentsServiceImpl.java
index d0acc66..799d9df 100644
--- a/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/ArticleCommentsServiceImpl.java
+++ b/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/ArticleCommentsServiceImpl.java
@@ -109,6 +109,7 @@
         page = this.lambdaQuery()
                 .eq(ArticleComments::getArticleId, query.getArticleId())
                 .in(StringUtils.isNotEmpty(memberIdSet), ArticleComments::getMemberId, memberIdSet)
+                .orderByDesc(ArticleComments::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             result = PageDTO.empty(page);
diff --git a/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/SensitiveWordsServiceImpl.java b/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/SensitiveWordsServiceImpl.java
index 467c655..422346b 100644
--- a/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/SensitiveWordsServiceImpl.java
+++ b/ruoyi-modules/ruoyi-article/src/main/java/com/ruoyi/article/service/impl/SensitiveWordsServiceImpl.java
@@ -69,7 +69,8 @@
         PageDTO<MgtSensitiveWordsVO> pageVO;
         Page<SensitiveWords> page = this.lambdaQuery()
                 .like(StringUtils.isNotBlank(query.getWord()), SensitiveWords::getWord,
-                        query.getWord()).page(new Page<>(query.getPageCurr(), query.getPageSize()));
+                        query.getWord()).orderByDesc(SensitiveWords::getCreateTime)
+                .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             pageVO = PageDTO.empty(page);
         } else {
diff --git a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/controller/management/MgtAuctionScreenController.java b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/controller/management/MgtAuctionScreenController.java
index 299ef25..9dcaac1 100644
--- a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/controller/management/MgtAuctionScreenController.java
+++ b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/controller/management/MgtAuctionScreenController.java
@@ -134,7 +134,11 @@
     @ApiOperation("结束当前拍卖商品")
     public R<?> stopCurrentGoods(
             @ApiParam(name = "id", value = "拍卖场商品id", required = true) @PathVariable("id") Long id) {
-        auctionSalesroomService.stopCurrentGoods(id);
+        try {
+            auctionSalesroomService.stopCurrentGoods(id);
+        } catch (JsonProcessingException e) {
+            throw new RuntimeException(e);
+        }
         return R.ok();
     }
 
@@ -147,7 +151,11 @@
     @ApiOperation("开始下一拍卖商品")
     public R<?> startNextGoods(
             @ApiParam(name = "id", value = "拍卖场商品id", required = true) @PathVariable("id") Long id) {
-        auctionSalesroomService.startNextGoods(id);
+        try {
+            auctionSalesroomService.startNextGoods(id);
+        } catch (JsonProcessingException e) {
+            throw new RuntimeException(e);
+        }
         return R.ok();
     }
 
diff --git a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/IAuctionSalesroomService.java b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/IAuctionSalesroomService.java
index e1755ac..84a83ab 100644
--- a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/IAuctionSalesroomService.java
+++ b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/IAuctionSalesroomService.java
@@ -163,14 +163,14 @@
      *
      * @param id 拍卖场商品id
      */
-    void stopCurrentGoods(Long id);
+    void stopCurrentGoods(Long id) throws JsonProcessingException;
 
     /**
      * 开始下一拍卖商品
      *
      * @param id 拍卖场商品id
      */
-    void startNextGoods(Long id);
+    void startNextGoods(Long id) throws JsonProcessingException;
 
     /**
      * 播放视频
diff --git a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionGoodsServiceImpl.java b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionGoodsServiceImpl.java
index 82f5b98..c87da9f 100644
--- a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionGoodsServiceImpl.java
+++ b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionGoodsServiceImpl.java
@@ -141,6 +141,7 @@
                         query.getListingStatus())
                 .eq(StringUtils.isNotNull(query.getStartStatus()), AuctionGoods::getStartStatus,
                         query.getStartStatus())
+                .orderByDesc(AuctionGoods::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
@@ -597,8 +598,8 @@
         if (StringUtils.isNotNull(auctionGoods) && auctionGoods.getListingStatus().equals(
                 ListingStatusEnum.ON_SHELVES) && auctionGoods.getStartStatus()
                 .equals(AuctionStartStatusEnum.IN_AUCTION)) {
-            this.lambdaUpdate().set(AuctionGoods::getStartStatus, AuctionStartStatusEnum.ENDED)
-                    .eq(AuctionGoods::getId, id);
+            auctionGoods.setStartStatus(AuctionStartStatusEnum.ENDED);
+            this.updateById(auctionGoods);
             // TODO 退保证金
             orderClient.returnBondByAuctionGoodsId(id, SecurityConstants.INNER);
 
@@ -620,8 +621,8 @@
         if (StringUtils.isNotNull(auctionGoods) && auctionGoods.getListingStatus().equals(
                 ListingStatusEnum.ON_SHELVES) && auctionGoods.getStartStatus()
                 .equals(AuctionStartStatusEnum.IN_PREVIEW)) {
-            this.lambdaUpdate().set(AuctionGoods::getStartStatus, AuctionStartStatusEnum.IN_AUCTION)
-                    .eq(AuctionGoods::getId, id);
+            auctionGoods.setStartStatus(AuctionStartStatusEnum.IN_AUCTION);
+            this.updateById(auctionGoods);
             Map<String, Object> map = new ConcurrentHashMap<>();
             map.put("notification_type", NotificationTypeConstant.AUCTION_GOODS);
             map.put("notification_time", DateUtils.dateTimeNow("yyyy-MM-dd HH:mm:ss"));
diff --git a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionSalesroomServiceImpl.java b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionSalesroomServiceImpl.java
index b6e2eaa..62fc9d7 100644
--- a/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionSalesroomServiceImpl.java
+++ b/ruoyi-modules/ruoyi-auction/src/main/java/com/ruoyi/auction/service/impl/AuctionSalesroomServiceImpl.java
@@ -765,7 +765,9 @@
                                 query.getEndTime()), AuctionSalesroom::getStartTime,
                         query.getStartTime(),
                         query.getEndTime())
+                .orderByDesc(AuctionSalesroom::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
+
         List<AuctionSalesroom> records = page.getRecords();
         if (StringUtils.isNull(records)) {
             return PageDTO.empty(page);
@@ -1069,6 +1071,7 @@
                 .between(StringUtils.isNotNull(query.getStartTime()) && StringUtils.isNotNull(
                                 query.getEndTime()), AuctionSalesroom::getStartTime, query.getStartTime(),
                         query.getEndTime())
+                .orderByAsc(AuctionSalesroom::getStartTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         List<AuctionSalesroom> records = page.getRecords();
         if (StringUtils.isNull(records)) {
@@ -1271,13 +1274,22 @@
      * @param id 拍卖场商品id
      */
     @Override
-    public void stopCurrentGoods(Long id) {
+    public void stopCurrentGoods(Long id) throws JsonProcessingException {
         AuctionSalesroomGoods auctionSalesroomGoods = auctionSalesroomGoodsMapper.selectById(id);
         if (StringUtils.isNull(auctionSalesroomGoods)) {
             throw new ServiceException("拍卖商品不存在");
         }
         auctionSalesroomGoods.setStatus(AuctionGoodsStatusEnum.ENDED);
         auctionSalesroomGoodsMapper.updateById(auctionSalesroomGoods);
+        Map<String, Object> map = new ConcurrentHashMap<>();
+        map.put("notification_type", NotificationTypeConstant.AUCTION_SALESROOM_GOODS);
+        map.put("auctionSalesroomId", auctionSalesroomGoods.getAuctionSalesroomId().toString());
+        map.put("auctionSalesroomGoodsId", auctionSalesroomGoods.getId().toString());
+        map.put("AuctionTypeEnum", auctionSalesroomGoods.getStatus());
+        map.put("message_type", "stop");
+        map.put("type", "2");
+        String msg = objectMapper.writeValueAsString(map);
+        sysUserClient.pushAll(msg, SecurityConstants.INNER);
     }
 
     /**
@@ -1286,13 +1298,22 @@
      * @param id 拍卖场商品id
      */
     @Override
-    public void startNextGoods(Long id) {
+    public void startNextGoods(Long id) throws JsonProcessingException {
         AuctionSalesroomGoods auctionSalesroomGoods = auctionSalesroomGoodsMapper.selectById(id);
         if (StringUtils.isNull(auctionSalesroomGoods)) {
             throw new ServiceException("拍卖商品不存在");
         }
         auctionSalesroomGoods.setStatus(AuctionGoodsStatusEnum.IN_PROGRESS);
         auctionSalesroomGoodsMapper.updateById(auctionSalesroomGoods);
+        Map<String, Object> map = new ConcurrentHashMap<>();
+        map.put("notification_type", NotificationTypeConstant.AUCTION_SALESROOM_GOODS);
+        map.put("auctionSalesroomId", auctionSalesroomGoods.getAuctionSalesroomId().toString());
+        map.put("auctionSalesroomGoodsId", auctionSalesroomGoods.getId().toString());
+        map.put("AuctionTypeEnum", auctionSalesroomGoods.getStatus());
+        map.put("message_type", "start");
+        map.put("type", "2");
+        String msg = objectMapper.writeValueAsString(map);
+        sysUserClient.pushAll(msg, SecurityConstants.INNER);
     }
 
     /**
@@ -1352,8 +1373,8 @@
 
         Map<String, Object> map = new ConcurrentHashMap<>();
         map.put("notification_type", NotificationTypeConstant.AUCTION_SALESROOM);
-        map.put("auctionSalesroomId", auctionSalesroom.getId());
-        map.put("AuctionTypeEnum",auctionSalesroom.getStatus());
+        map.put("auctionSalesroomId", auctionSalesroom.getId().toString());
+        map.put("AuctionTypeEnum", auctionSalesroom.getStatus());
         map.put("message_type", "start");
         map.put("type", "1");
         String msg = objectMapper.writeValueAsString(map);
@@ -1405,7 +1426,7 @@
         }
         Map<String, Object> map = new ConcurrentHashMap<>();
         map.put("notification_type", NotificationTypeConstant.AUCTION_SALESROOM);
-        map.put("auctionSalesroomId", auctionSalesroom.getId());
+        map.put("auctionSalesroomId", auctionSalesroom.getId().toString());
         map.put("AuctionTypeEnum",auctionSalesroom.getStatus());
         map.put("message_type", "end");
         map.put("type", "1");
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsBrandServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsBrandServiceImpl.java
index 77b6135..2dd1b72 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsBrandServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsBrandServiceImpl.java
@@ -8,9 +8,9 @@
 import com.ruoyi.goods.controller.management.dto.GoodsBrandDTO;
 import com.ruoyi.goods.controller.management.dto.GoodsBrandQuery;
 import com.ruoyi.goods.controller.management.vo.GoodsBrandVO;
-import com.ruoyi.system.api.domain.GoodsBrand;
 import com.ruoyi.goods.mapper.GoodsBrandMapper;
 import com.ruoyi.goods.service.IGoodsBrandService;
+import com.ruoyi.system.api.domain.GoodsBrand;
 import java.util.List;
 import org.springframework.stereotype.Service;
 
@@ -50,6 +50,7 @@
         Page<GoodsBrand> page = this.lambdaQuery()
                 .like(StringUtils.isNotEmpty(query.getBrandName()), GoodsBrand::getBrandName,
                         query.getBrandName())
+                .orderByDesc(GoodsBrand::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsCategoryServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsCategoryServiceImpl.java
index 6e48584..be04a69 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsCategoryServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsCategoryServiceImpl.java
@@ -8,9 +8,9 @@
 import com.ruoyi.goods.controller.management.dto.GoodsCategoryDTO;
 import com.ruoyi.goods.controller.management.dto.GoodsCategoryQuery;
 import com.ruoyi.goods.controller.management.vo.GoodsCategoryVO;
-import com.ruoyi.system.api.domain.GoodsCategory;
 import com.ruoyi.goods.mapper.GoodsCategoryMapper;
 import com.ruoyi.goods.service.IGoodsCategoryService;
+import com.ruoyi.system.api.domain.GoodsCategory;
 import java.util.List;
 import org.springframework.stereotype.Service;
 
@@ -48,6 +48,7 @@
         Page<GoodsCategory> page = this.lambdaQuery()
                 .like(StringUtils.isNotEmpty(query.getCategoryName()),
                         GoodsCategory::getCategoryName, query.getCategoryName())
+                .orderByDesc(GoodsCategory::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsFlavorTypeServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsFlavorTypeServiceImpl.java
index faabb23..f191f59 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsFlavorTypeServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsFlavorTypeServiceImpl.java
@@ -8,9 +8,9 @@
 import com.ruoyi.goods.controller.management.dto.GoodsFlavorTypeDTO;
 import com.ruoyi.goods.controller.management.dto.GoodsFlavorTypeQuery;
 import com.ruoyi.goods.controller.management.vo.GoodsFlavorTypeVO;
-import com.ruoyi.system.api.domain.GoodsFlavorType;
 import com.ruoyi.goods.mapper.GoodsFlavorTypeMapper;
 import com.ruoyi.goods.service.IGoodsFlavorTypeService;
+import com.ruoyi.system.api.domain.GoodsFlavorType;
 import java.util.List;
 import org.springframework.stereotype.Service;
 
@@ -48,6 +48,7 @@
         Page<GoodsFlavorType> page = this.lambdaQuery()
                 .like(StringUtils.isNotEmpty(query.getFlavorTypeName()),
                         GoodsFlavorType::getFlavorTypeName, query.getFlavorTypeName())
+                .orderByDesc(GoodsFlavorType::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsInfoTitleServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsInfoTitleServiceImpl.java
index b94249f..5399efa 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsInfoTitleServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsInfoTitleServiceImpl.java
@@ -36,6 +36,7 @@
         Page<GoodsInfoTitle> page = this.lambdaQuery()
                 .like(StringUtils.isNotEmpty(query.getTitleName()), GoodsInfoTitle::getTitleName,
                         query.getTitleName())
+                .orderByDesc(GoodsInfoTitle::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSeriesServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSeriesServiceImpl.java
index 0d4a323..6684581 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSeriesServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSeriesServiceImpl.java
@@ -8,9 +8,9 @@
 import com.ruoyi.goods.controller.management.dto.GoodsSeriesDTO;
 import com.ruoyi.goods.controller.management.dto.GoodsSeriesQuery;
 import com.ruoyi.goods.controller.management.vo.GoodsSeriesVO;
-import com.ruoyi.system.api.domain.GoodsSeries;
 import com.ruoyi.goods.mapper.GoodsSeriesMapper;
 import com.ruoyi.goods.service.IGoodsSeriesService;
+import com.ruoyi.system.api.domain.GoodsSeries;
 import java.util.List;
 import org.springframework.stereotype.Service;
 
@@ -50,6 +50,7 @@
         Page<GoodsSeries> page = this.lambdaQuery()
                 .like(StringUtils.isNotEmpty(query.getSeriesName()), GoodsSeries::getSeriesName,
                         query.getSeriesName())
+                .orderByDesc(GoodsSeries::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java
index 938eca7..8c568ef 100644
--- a/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java
+++ b/ruoyi-modules/ruoyi-goods/src/main/java/com/ruoyi/goods/service/impl/GoodsSkuServiceImpl.java
@@ -27,7 +27,13 @@
 import com.ruoyi.goods.service.IGoodsInfoTitleValueService;
 import com.ruoyi.goods.service.IGoodsSkuService;
 import com.ruoyi.goods.service.IMemberGoodsCollectionService;
-import com.ruoyi.system.api.domain.*;
+import com.ruoyi.system.api.domain.GoodsBrand;
+import com.ruoyi.system.api.domain.GoodsCategory;
+import com.ruoyi.system.api.domain.GoodsFlavorType;
+import com.ruoyi.system.api.domain.GoodsGroupPurchase;
+import com.ruoyi.system.api.domain.GoodsSeckill;
+import com.ruoyi.system.api.domain.GoodsSeries;
+import com.ruoyi.system.api.domain.GoodsSku;
 import com.ruoyi.system.api.domain.dto.GoodsStockUpdDTO;
 import com.ruoyi.system.api.domain.dto.HomeGoodsSkuDTO;
 import com.ruoyi.system.api.domain.dto.ListStatusDTO;
@@ -36,16 +42,19 @@
 import com.ruoyi.system.api.domain.vo.OrderVO;
 import com.ruoyi.system.api.domain.vo.getHomeGoodsSkuXxiVO;
 import com.ruoyi.system.api.feignClient.GoodsSkuClient;
-
+import com.ruoyi.system.api.feignClient.OrderClient;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
-import java.util.*;
+import java.util.ArrayList;
+import java.util.Collections;
+import java.util.Comparator;
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
 import java.util.concurrent.TimeUnit;
 import java.util.stream.Collectors;
 import javax.annotation.Resource;
-
-import com.ruoyi.system.api.feignClient.OrderClient;
 import lombok.RequiredArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
 import org.redisson.api.RLock;
@@ -187,6 +196,7 @@
                 ), GoodsSku::getListingStatus, query.getListingStatus())
                 .eq(query.getQueryType().equals(1), GoodsSku::getListingStatus,
                         ListingStatusEnum.ON_SHELVES)
+                .orderByDesc(GoodsSku::getSortNum)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         return PageDTO.of(page, GoodsSkuVO.class);
     }
@@ -505,6 +515,7 @@
         return homeGoodsSkuXxiVOS;
     }
 
+    @Override
     public List<getHomeGoodsSkuXxiVO> getMsHomeGoodsSkuXxi(HomeGoodsSkuDTO homeGoodsSkuDTO) {
         List<getHomeGoodsSkuXxiVO> homeGoodsSkuXxiVOS=new ArrayList<>();
         GoodsSeckill goodsSeckill = goodsSeckillMapper.selectById(homeGoodsSkuDTO.getGoodsSkuId());
diff --git a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java
index 97b5f5a..4c67702 100644
--- a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java
+++ b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java
@@ -513,6 +513,7 @@
                 .like(StringUtils.isNotBlank(query.getRealName()), Member::getRealName,
                         query.getRealName())
                 .like(StringUtils.isNotBlank(query.getPhone()), Member::getPhone, query.getPhone())
+                .orderByDesc(Member::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page.getTotal(), page.getPages());
diff --git a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/MemberInvoiceServiceImpl.java b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/MemberInvoiceServiceImpl.java
index c357396..4f0fdee 100644
--- a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/MemberInvoiceServiceImpl.java
+++ b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/MemberInvoiceServiceImpl.java
@@ -25,7 +25,6 @@
 import com.ruoyi.system.api.feignClient.GoodsSkuClient;
 import com.ruoyi.system.api.feignClient.MemberClient;
 import io.seata.common.util.StringUtils;
-
 import java.math.BigDecimal;
 import java.util.List;
 import java.util.Map;
@@ -140,7 +139,8 @@
                 .in(com.ruoyi.common.core.utils.StringUtils.isNotEmpty(memberIdSet),
                         MemberInvoice::getMemberId, memberIdSet)
                 .eq(query.getInvoiceStatus() != null, MemberInvoice::getInvoiceStatus,
-                        query.getInvoiceStatus()).page(page);
+                        query.getInvoiceStatus()).orderByDesc(MemberInvoice::getCreateTime)
+                .page(page);
         if (page.getRecords().isEmpty()) {
             return PageDTO.empty(page);
         }
diff --git a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
index af34e27..0567732 100644
--- a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
+++ b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
@@ -44,21 +44,6 @@
   </select>
 
 
-  <select id="getOrderByGroupPurchaseId" resultType="com.ruoyi.system.api.domain.Order">
-    SELECT
-    o.*
-    FROM
-    t_order o
-    <where>
-      o.goods_sku_id = #{goodsSkuId}
-      AND o.order_status = 2
-      AND o.order_from = 3
-      AND o.del_flag=0
-      AND   o.member_id=#{memberId}
-    </where>
-  </select>
-
-
   <select id="getOrderByGroupPurchaseList" resultType="com.ruoyi.system.api.domain.vo.OrderVO">
     SELECT
     o.*,
diff --git a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/CouponServiceImpl.java b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/CouponServiceImpl.java
index 96880f7..e890ccb 100644
--- a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/CouponServiceImpl.java
+++ b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/CouponServiceImpl.java
@@ -76,6 +76,7 @@
                         query.getCouponType())
                 .eq(StringUtils.isNotNull(query.getDistributionMethod()),
                         Coupon::getDistributionMethod, query.getDistributionMethod())
+                .orderByDesc(Coupon::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
diff --git a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionBannerServiceImpl.java b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionBannerServiceImpl.java
index 9ab37bc..7555764 100644
--- a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionBannerServiceImpl.java
+++ b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionBannerServiceImpl.java
@@ -47,6 +47,7 @@
                         PromotionBanner::getListingStatus, query.getListingStatus())
                 .like(StringUtils.isNotBlank(query.getBannerName()), PromotionBanner::getBannerName,
                         query.getBannerName())
+                .orderByDesc(PromotionBanner::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
diff --git a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionVideoServiceImpl.java b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionVideoServiceImpl.java
index b5712c5..e98741f 100644
--- a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionVideoServiceImpl.java
+++ b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionVideoServiceImpl.java
@@ -36,6 +36,7 @@
         Page<PromotionVideo> page = this.lambdaQuery()
                 .like(StringUtils.isNotBlank(query.getVideoName()), PromotionVideo::getVideoName,
                         query.getVideoName())
+                .orderByDesc(PromotionVideo::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
diff --git a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionWishListServiceImpl.java b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionWishListServiceImpl.java
index 797afe7..f4c0722 100644
--- a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionWishListServiceImpl.java
+++ b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/service/impl/PromotionWishListServiceImpl.java
@@ -112,7 +112,7 @@
                 .eq(StringUtils.isNotNull(query.getReplyStatus()),
                         PromotionWishList::getReplyStatus, query.getReplyStatus())
                 .in(StringUtils.isNotEmpty(memberIdSet), PromotionWishList::getMemberId,
-                        memberIdSet).page(page);
+                        memberIdSet).orderByDesc(PromotionWishList::getCreateTime).page(page);
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
         }
diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/listener/RedisListener.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/listener/RedisListener.java
index 89d7bcb..f5f5840 100644
--- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/listener/RedisListener.java
+++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/listener/RedisListener.java
@@ -64,10 +64,10 @@
                         //自动结束团购任务
                         autoEndGroupPurchase(id);
                     } else if (DelayTaskEnum.AUCTION_GOODS_START_TASK.getCode().equals(operation)) {
-                        // 自动开始团购任务
+                        // 自动开始拍卖商品任务
                         autoStartAuctionGoods(id);
                     } else if (DelayTaskEnum.AUCTION_GOODS_END_TASK.getCode().equals(operation)) {
-                        // 自动结束团购任务
+                        // 自动结束拍卖商品任务
                         autoEndAuctionGoods(id);
                     }else if(DelayTaskEnum.ORDER_AUTOMATIC_CANCEL.getCode().equals(operation)){
                         //自动取消订单
diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
index a4c03f9..22c9d1d 100644
--- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
+++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
@@ -28,6 +28,7 @@
 import com.ruoyi.system.service.ISysConfigService;
 import com.ruoyi.system.service.ISysUserService;
 import java.util.ArrayList;
+import java.util.Date;
 import java.util.List;
 import java.util.stream.Collectors;
 import javax.validation.Validator;
@@ -585,7 +586,7 @@
                 .select(SysUser::getUserId, SysUser::getNickName, SysUser::getPhonenumber)
                 .like(StringUtils.isNotBlank(query.getNickName()
                 ), SysUser::getNickName, query.getNickName()).eq(SysUser::getUserType, "04")
-                .eq(SysUser::getDelFlag, "0")
+                .eq(SysUser::getDelFlag, "0").orderByDesc(SysUser::getCreateTime)
                 .page(new Page<>(query.getPageCurr(), query.getPageSize()));
         if (StringUtils.isEmpty(page.getRecords())) {
             return PageDTO.empty(page);
@@ -611,6 +612,8 @@
             user.setUserName(dto.getPhonenumber());
             user.setPassword(SecurityUtils.encryptPassword(dto.getPassword()));
             user.setUserType("04");
+            user.setCreateTime(new Date());
+            user.setCreateBy(SecurityUtils.getUsername());
             this.save(user);
         } else {
             // 编辑
@@ -621,6 +624,8 @@
             user.setNickName(dto.getNickName());
             user.setPhonenumber(dto.getPhonenumber());
             user.setUserName(dto.getPhonenumber());
+            user.setUpdateTime(new Date());
+            user.setUpdateBy(SecurityUtils.getUsername());
             if (StringUtils.isNotBlank(dto.getPassword())) {
                 user.setPassword(SecurityUtils.encryptPassword(dto.getPassword()));
             }

--
Gitblit v1.7.1