From f29339d03169792e15efe804743b5aed70a1c0a1 Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期四, 29 八月 2024 17:38:00 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v2' into master-v2 --- src/main/java/com/mzl/flower/mapper/member/MemberMapper.java | 19 ++++++++++++++++--- 1 files changed, 16 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java b/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java index 82051de..9c8ddf6 100644 --- a/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java +++ b/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java @@ -1,10 +1,15 @@ package com.mzl.flower.mapper.member; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.mzl.flower.dto.request.menber.MemberQueryDTO; +import com.mzl.flower.dto.response.member.MemberVO; import com.mzl.flower.entity.menber.Member; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; + +import java.util.List; /** @@ -18,8 +23,16 @@ @Repository public interface MemberMapper extends BaseMapper<Member> { - @SuppressWarnings("AlibabaAbstractMethodOrInterfaceMethodMustUseJavadoc") - @Select("select * from t_member where level_name = #{levelName} and deleted = '0' limit 1") - Member getMemberByName(@Param("levelName") String levelName); + @Select("select * from t_member where name = #{name} and deleted = '0' limit 1") + Member getMemberByName(@Param("name") String name); + + @Select("select * from t_member where start_point <= #{growthValue} and end_point > #{growthValue} and deleted = '0' limit 1") + Member getMemberByGrowthValue(@Param("growthValue") Integer growthValue); + + //获取成长值大于当前值的会员 + @Select("select * from t_member where start_point > #{growthValue} and deleted = '0' ") + List<Member> getgtMembersByGrowthValue(@Param("growthValue") Integer growthValue); + + List<MemberVO> queryPage(@Param("dto") MemberQueryDTO dto, Page page); } -- Gitblit v1.9.3