| | |
| | | <if test="query.phone != null and query.phone != ''"> |
| | | and phone like concat('%',#{query.phone},'%') |
| | | </if> |
| | | <if test="query.status != null"> |
| | | and status = #{query.status} |
| | | </if> |
| | | <if test="query.roleType != null and query.roleType == 1"> |
| | | and audit_status in (1,3) |
| | | <if test="query.auditStatus != null"> |
| | | and audit_status = #{query.auditStatus} |
| | | </if> |
| | | <if test="query.branchId != null and query.branchId != ''"> |
| | | and province_branch_id = #{query.branchId} |
| | | </if> |
| | | and audit_status in (1,3) |
| | | AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()} |
| | | </where> |
| | | ORDER BY create_time DESC |
| | |
| | | <if test="query.phone != null and query.phone != ''"> |
| | | and phone like concat('%',#{query.phone},'%') |
| | | </if> |
| | | <if test="query.status != null"> |
| | | and status = #{query.status} |
| | | </if> |
| | | <if test="query.roleType != null and query.roleType == 1"> |
| | | and audit_status in (1,3) |
| | | <if test="query.auditStatus != null"> |
| | | and audit_status = #{query.auditStatus} |
| | | </if> |
| | | <if test="query.branchId != null and query.branchId != ''"> |
| | | and province_branch_id = #{query.branchId} |
| | | </if> |
| | | and audit_status in (1,3) |
| | | AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()} |
| | | </where> |
| | | ORDER BY create_time DESC |