| | |
| | | xou.nick_name, xou.phone_number, xou.avatar,xou.unique_number |
| | | from xp_qualification_audit xqa |
| | | left join xp_operations_user xou on xqa.operations_user_id = xou.id |
| | | left join xp_operations_role xor on xou.id = xor.operations_user_id |
| | | left join xp_operations_role xore on xou.id = xore.operations_user_id |
| | | where xqa.is_deleted = 0 |
| | | <if test="query.nickName != null and query.nickName != ''"> |
| | | and xou.nick_name like concat('%',#{query.nickName},'%') |
| | |
| | | and xou.phone_number like concat('%',#{query.phoneNumber},'%') |
| | | </if> |
| | | <if test="query.roleId != null"> |
| | | and xor.role_id = #{query.roleId} |
| | | and xore.role_id = #{query.roleId} |
| | | </if> |
| | | <if test="query.auditStatus != null"> |
| | | and xqa.audit_status = #{query.auditStatus} |