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