select * from sys_user where username = #{username} and del_flag = 0 select * from sys_user where del_flag = 0 and id in (select user_id from sys_user_depart where dep_id=#{departId}) and username = #{username} select d.depart_name,ud.user_id from sys_user_depart ud,sys_depart d where d.id = ud.dep_id and ud.user_id in #{id} select * from sys_user where del_flag = 0 and id in (select user_id from sys_user_depart where dep_id in #{id} ) and username = #{username} select * from sys_user where del_flag = 0 and id in (select user_id from sys_user_role where role_id=#{roleId}) and username = #{username} UPDATE sys_user SET org_code = #{orgCode} where username = #{username} select * from sys_user where phone = #{phone} and del_flag = 0 select * from sys_user where email = #{email} and del_flag = 0 FROM sys_depart INNER JOIN sys_user_depart ON sys_user_depart.dep_id = sys_depart.id INNER JOIN sys_user ON sys_user.id = sys_user_depart.user_id WHERE sys_user.del_flag = 0 AND sys_depart.org_code LIKE '${orgCode}%' AND sys_user.realname LIKE concat(concat('%',#{userParams.realname}),'%') AND sys_user.work_no LIKE concat(concat('%',#{userParams.workNo}),'%') SELECT sys_user.id AS id, sys_user.realname AS realname, sys_user.avatar AS avatar, sys_user.work_no AS workNo, sys_user.post AS post, sys_user.telephone AS telephone, sys_user.email AS email, sys_user.phone AS phone, sys_depart.id AS departId, sys_depart.depart_name AS departName ORDER BY sys_depart.org_code ASC SELECT COUNT(1) delete from sys_user_role where role_id in #{id} delete from sys_role_permission where role_id in #{id} SELECT * FROM sys_user ${ew.customSqlSegment} UPDATE sys_user SET del_flag = 0, update_by = #{entity.updateBy}, update_time = #{entity.updateTime} WHERE del_flag = 1 AND id IN (${userIds}) DELETE FROM sys_user WHERE del_flag = 1 AND id IN (${userIds}) UPDATE sys_user SET ${fieldName} = NULL WHERE ${fieldName} = '' select * from sys_user where del_flag = 0 and id in (select user_id from sys_user_depart where dep_id in #{id} ) and username != #{username}