| package com.mzl.flower.mapper.member; | 
|   | 
| import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
| import com.mzl.flower.entity.menber.MemberDowngradeRecord; | 
| import org.apache.ibatis.annotations.Param; | 
| import org.apache.ibatis.annotations.Select; | 
| import org.springframework.stereotype.Repository; | 
|   | 
|   | 
|   | 
| /** | 
|  * @author fanghaowei | 
|  * @version version2.0 | 
|  * @className MemberMapper | 
|  * @date 2024/9/2 | 
|  * @description 会员降级mapper | 
|  */ | 
| @SuppressWarnings("ALL") | 
| @Repository | 
| public interface MemberDowngradeRecordMapper extends BaseMapper<MemberDowngradeRecord> { | 
|   | 
|     @Select("select count(1) from t_member_downgrade_record where user_id = #{userId} and deleted = '0' ") | 
|     Integer getMemberByName(@Param("userId") String userId); | 
| } |