screen-api/src/main/resources/mapper/UserMapper.xml | ●●●●● 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>