jinpengyong
2021-08-06 c9570f9f0e7f0e615e68b3d471307fd74d10e8be
update
1 files modified
3 ■■■■ changed files
screen-api/src/main/resources/mapper/UserMapper.xml 3 ●●●● patch | view | raw | blame | history
screen-api/src/main/resources/mapper/UserMapper.xml
@@ -42,10 +42,11 @@
        FROM `user` u
        LEFT JOIN
            (SELECT ug.user_id,g.id,g.group_name FROM `user_group` ug ,`group` g WHERE ug.group_id=g.id   AND g.is_delete = 0
            AND ug.is_delete = 0) a
            AND ug.is_delete = '0') a
        ON a.user_id=u.id
        LEFT JOIN `organization` o ON o.id=u.organization_id
        WHERE u.account = #{account}
        AND u.is_delete = '0'
    </select>
</mapper>