| | |
| | | <if test="query.reportUserName != null and query.reportUserName != ''"> |
| | | and t2.report_user_name like concat("%",#{query.reportUserName},"%") |
| | | </if> |
| | | <if test="query.status != null"> |
| | | and t2.status = #{query.status} |
| | | </if> |
| | | <if test="query.reportUserPhone != null and query.reportUserPhone != ''"> |
| | | and t2.report_user_phone like concat("%",#{query.reportUserPhone},"%") |
| | | </if> |
| | |
| | | <if test="null != query.systemRoleId"> |
| | | and a.system_role_id = #{query.systemRoleId} |
| | | </if> |
| | | <if test="null != query.accountLevel and 1 == query.accountLevel "> |
| | | and h.level = #{query.accountLevel} |
| | | </if> |
| | | <if test="null != query.accountLevel and 2 == query.accountLevel and query.type==2 and query.code != null and query.code !='' "> |
| | | and h.level >= #{query.accountLevel} and h.districts_code = #{query.code} |
| | | </if> |