| | |
| | | and t3.mediator like concat('%', #{terms.mediator}, '%') |
| | | </if> |
| | | <if test="terms.canal != null and terms.canal !=''"> |
| | | and t1.canal = #{terms.canal} |
| | | and t2.canal = #{terms.canal} |
| | | </if> |
| | | <if test="terms.mediResult != null and terms.mediResult !=''"> |
| | | and t1.medi_result = #{terms.mediResult} |
| | | and t3.medi_result = #{terms.mediResult} |
| | | </if> |
| | | <if test="terms.caseLevel != null and terms.caseLevel !=''"> |
| | | and t1.case_level = #{terms.caseLevel} |
| | | and t2.case_level = #{terms.caseLevel} |
| | | </if> |
| | | <if test="terms.caseType != null and terms.caseType !=''"> |
| | | and t1.case_type = #{terms.caseType} |
| | | and t2.case_type = #{terms.caseType} |
| | | </if> |
| | | <if test="terms.status != null and terms.status !=''"> |
| | | and t2.status = #{terms.status} |