package com.tourguide.modules.user.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tourguide.modules.user.entity.GuideApplication;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface GuideApplicationMapper extends BaseMapper<GuideApplication> {
    @Update("UPDATE guide_application SET id_card_no = NULL, id_card_front_url = NULL, " +
            "id_card_back_url = NULL, updated_at = NOW() WHERE id_card_no = #{idCardNo}")
    int clearIdentityByIdCard(@Param("idCardNo") String idCardNo);
}