From ab41793cfc9a4faa608d95dc84d3a5ba79fe5948 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Wed, 28 May 2025 10:45:36 +0800 Subject: [PATCH] refactor(mall): 调整轮播图查询排序逻辑 - 移除按 created_time排序的逻辑 - 添加按 sort 字段升序排序的逻辑 - 保留按 is_top 字段升序排序的逻辑 --- src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java index c8b1298..babed24 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java @@ -10,5 +10,11 @@ List<MallOrderItem> selectItemByGoodsIdUnCancel(@Param("goodsId") Long goodsId, @Param("memberId") Long memberId); - List<MallOrderItem> selectListByStateAndOrderId(@Param("state")Integer i, @Param("orderId")Long orderId); + List<MallOrderItem> selectItemBySkuIdUnCancel(@Param("skuId") Long skuId, @Param("memberId") Long memberId); + + List<MallOrderItem> selectListByNotInStateAndOrderId(@Param("state")Integer i, @Param("orderId")Long orderId); + + void updateStateByOrderId(@Param("state")Integer i, @Param("orderId")Long id); + + List<MallOrderItem> selectListByOrderId(@Param("orderId")Long id); } -- Gitblit v1.9.1