add:会员成长记录；个人会员信息查看

cloudroam

2024-08-27 d845b016623f7f6314aab739b485fe5d3400bb22

 src/main/java/com/mzl/flower/mapper/member/MemberMapper.java

@@ -6,6 +6,8 @@
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;


/**
 * @author fanghaowei
@@ -21,4 +23,11 @@
    @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);

}