| | |
| | | left join allocation_extension t1 on t1.allocation_id = allocation.allocation_id and t1.is_del =0 and t1.is_invalid = 0 and t1.state = 30 |
| | | <where> |
| | | 1 = 1 and allocation.is_del = 0 |
| | | <if test="allocation.unitId != null and allocation.unitId != 0"> |
| | | <if test="allocation.unitId != null"> |
| | | and allocation.unit_id = #{allocation.unitId} |
| | | </if> |
| | | <if test="allocation.polluteType != null and allocation.polluteType != 0"> |
| | |
| | | <if test="allocation.changeType != null and allocation.changeType != 0"> |
| | | and allocation.change_type = #{allocation.changeType} |
| | | </if> |
| | | <if test="allocation.isInvalid != null and allocation.isInvalid != 0"> |
| | | <if test="allocation.isInvalid != null"> |
| | | and allocation.is_invalid = #{allocation.isInvalid} |
| | | </if> |
| | | <if test="allocation.startTime != null and allocation.startTime != '' "> |