From 7bcab93f6e19b0f46417bd789fc36fc7e34186d4 Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期二, 10 九月 2024 17:53:37 +0800
Subject: [PATCH] 1.只有上架的商品才排序
---
src/main/resources/mapper/flower/FlowerMapper.xml | 3 +++
src/main/java/com/mzl/flower/service/flower/FlowerService.java | 6 ++++++
src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java | 2 ++
3 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java b/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java
index 6294161..52e4a21 100644
--- a/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java
@@ -55,4 +55,6 @@
void restoreFlowerBatch(@Param("list") List<Long> ids);
List<Flower> getDeletdFlowByIds(@Param("list") List<Long> ids);
+
+ void updateTypeRankNull(@Param("category") Long category, @Param("level") String level);
}
diff --git a/src/main/java/com/mzl/flower/service/flower/FlowerService.java b/src/main/java/com/mzl/flower/service/flower/FlowerService.java
index 73ab692..d7b2ea7 100644
--- a/src/main/java/com/mzl/flower/service/flower/FlowerService.java
+++ b/src/main/java/com/mzl/flower/service/flower/FlowerService.java
@@ -138,10 +138,13 @@
}
try{
+ flowerMapper.updateTypeRankNull(flower.getCategory(),flower.getLevel());
+
QueryWrapper<Flower> queryWrapper=new QueryWrapper<>();
queryWrapper.lambda().eq(Flower::getDeleted,false)
.eq(Objects.nonNull(flower.getCategory()),Flower::getCategory,flower.getCategory())
.eq(StringUtils.isNotEmpty(flower.getLevel()),Flower::getLevel,flower.getLevel())
+ .eq(Flower::getStatus,"UP")
.orderByAsc(Flower::getPrice);
final List<Flower> flowerList = flowerMapper.selectList(queryWrapper);
@@ -454,6 +457,9 @@
//清除购物车商品
cartMapper.delete(new QueryWrapper<Cart>().eq("flower_id", id));
}
+
+ //更新排名
+ updateFlowTypeRank(null,f.getCategory(),f.getLevel());
}
public void deleteFlower(Long id){
diff --git a/src/main/resources/mapper/flower/FlowerMapper.xml b/src/main/resources/mapper/flower/FlowerMapper.xml
index 64eb0c7..308869c 100644
--- a/src/main/resources/mapper/flower/FlowerMapper.xml
+++ b/src/main/resources/mapper/flower/FlowerMapper.xml
@@ -421,4 +421,7 @@
#{id}
</foreach>
</update>
+ <update id="updateTypeRankNull">
+ update t_flower set type_rank=null where category=#{category} and level=#{level}
+ </update>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3