From b8676fd2d275723e7f3512f3d052dd538cc727b1 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期三, 04 十二月 2024 18:12:37 +0800 Subject: [PATCH] fix:web首页供应商财务信息接口开发;web首页当天售后量统计处理 --- src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 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 ac840be..1cee2ea 100644 --- a/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java +++ b/src/main/java/com/mzl/flower/mapper/flower/FlowerMapper.java @@ -11,6 +11,7 @@ import com.mzl.flower.dto.response.flower.FlowerSupplierListDTO; import com.mzl.flower.entity.flower.Flower; import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; import java.util.List; @@ -42,4 +43,31 @@ Integer getUpFlowerStock(); List<FlowerListDTO> selectZoneFlowerList(Page page, @Param("condition") FlowerZoneQueryDTO dto); + + void updateFlowerCategoryInfo(Long category); + + List<Long> searchInvalidHistory(@Param("userId") String userId); + + + void updateBatchTypeRank(@Param("list") List<Flower> flowerList); + + void deleteBatchPhysics(@Param("list") List<Long> ids); + + 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); + + @Select("select * from t_flower where id = #{id}") + Flower selectFlowerById(Long id); + + @Select("<script>" + + "SELECT * FROM t_flower WHERE id IN " + + "<foreach item='id' collection='ids' open='(' separator=',' close=')'>" + + "#{id}" + + "</foreach>" + + "</script>") + List<Flower> selectFlowersByIds(@Param("ids") List<Long> ids); + } -- Gitblit v1.9.3