package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.entity.AutomessageSysUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 用户表 后台用户+小程序用户(SysUser)表数据库访问层
 * projectName 成都呐喊信息技术有限公司-智慧社区项目
 * description: 用户表 后台用户+小程序用户相关功能
 *
 * @author yh
 * @since 2022-10-21 09:36:09
 */
@Mapper
public interface AutomessageSysUserDao extends BaseMapper<AutomessageSysUser> {


    /**
     * 通过id查询
     * @param id
     * @return
     */
    @Select("SELECT a.* FROM automessage_sys_user a WHERE a.phonenumber = (SELECT u.phone FROM sys_user u WHERE u.user_id = #{id})")
    AutomessageSysUser selectAutomessageSysUserById(@Param("id") Long id);

}