From 10215da99ee763cf72897c747f82efd4f9a513ad Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期四, 12 九月 2024 20:32:56 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v2' into master-v2 --- src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java b/src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java index 2d04c6d..d09649d 100644 --- a/src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java +++ b/src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java @@ -11,6 +11,7 @@ import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; +import java.time.LocalDate; import java.util.List; @@ -32,4 +33,7 @@ List<UserGrowthRecordVO> queryUserPage(@Param("dto") UserMemberRecordQueryDTO dto, Page page); + @Select("SELECT * from t_member_growth_record WHERE user_id = #{userId} and deleted = '0' and record_date = #{localDate} and type= 'reduce' and source = 'downgrading'") + List<MemberGrowthRecordVO> selectDowngradingByUserId(@Param("userId") String userId, LocalDate localDate); + } -- Gitblit v1.9.3