| | |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * @author fanghaowei |
|---|
| | |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | } |
|---|
