花城 【小程序】统计排行添加是否是问题清单标识5

lidongdong

2024-07-11 eef6d2bcdb29348efe4ef17bc45a4c6886b487b1

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/AutomessageSysUserDao.java

@@ -23,7 +23,7 @@
     * @param id
     * @return
     */
    @Select("select * from automessage_sys_user where id = #{id}")
    @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);

}