1.只有上架的商品才排序

陶杰

2024-09-10 7bcab93f6e19b0f46417bd789fc36fc7e34186d4

1.只有上架的商品才排序

 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);
}

 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){

 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>