if条件判断为空的时候需要将判断条件写成 ==0 才会执行
<select id="findAuditEnterpriseList" parameterType="java.util.HashMap" resultType="java.util.HashMap">
SELECT
roi.ID,roi.APP_USER_NAME,roi.ENTERPRISE_NAME,roi.CREDIT_NUMBER,roi.LEGAL_PERSON,
CASE roi.AUDIT_STATUS WHEN '0' THEN '未审核' WHEN '1' THEN '已审核' WHEN '9' THEN '驳回' END AUDIT_STATUS,
DATE_FORMAT(roi.CREAGE_TIME,'%Y-%m-%d %H:%i:%s') AS CREAGE_TIME
FROM app_user roi
WHERE 1 = 1
<if test="po.ENTERPRISE_TYPE == null or po.ENTERPRISE_TYPE == 0 ">AND (roi.USER_PART_TYPE = '12' OR roi.USER_PART_TYPE = '31')</if>
<if test="po.ENTERPRISE_TYPE != null and po.ENTERPRISE_TYPE != ''">and roi.USER_PART_TYPE= #{po.ENTERPRISE_TYPE, jdbcType=VARCHAR}</if>
<if test="po.AUDIT_STATUS != null and po.AUDIT_STATUS != ''" >and roi.AUDIT_STATUS=#{po.AUDIT_STATUS, jdbcType=VARCHAR}</if>
<if test="po.ENTERPRISE_NAME != null and po.ENTERPRISE_NAME != ''" >and roi.ENTERPRISE_NAME like concat('%',#{po.ENTERPRISE_NAME},'%')</if>
<if test="po.START_TIME != null and po.START_TIME !='' "><![CDATA[ and DATE_FORMAT(roi.CREAGE_TIME,'%Y-%m-%d') >=#{po.START_TIME, jdbcType=VARCHAR}]]></if>
<if test="po.END_TIME != null and po.END_TIME !='' "><![CDATA[and DATE_FORMAT(roi.CREAGE_TIME,'%Y-%m-%d') <= #{po.END_TIME, jdbcType=VARCHAR}]]></if>
ORDER BY roi.CREAGE_TIME DESC
</select>