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);
}