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