| | |
| | | AND type=4 |
| | | </if> |
| | | <if test="comEvent.level == 2"> |
| | | AND type=1 AND center_id=#{comEvent.searchId} |
| | | AND center_id=#{comEvent.searchId} AND current_process_type=1 |
| | | </if> |
| | | <if test="comEvent.level == 3"> |
| | | AND type=3 AND request_user_community in (select community_id from com_act where street_id=#{comEvent.searchId}) |
| | | AND request_user_community in (select community_id from com_act where street_id=#{comEvent.searchId}) AND current_process_type=3 |
| | | </if> |
| | | <if test="comEvent.level == 4"> |
| | | AND type=2 AND request_user_community=#{comEvent.searchId} |
| | | AND request_user_community=#{comEvent.searchId} AND current_process_type=2 |
| | | </if> |
| | | </if> |
| | | </if> |
| | |
| | | </if> |
| | | <if test="comEvent.level != null and comEvent.level != ''"> |
| | | <if test="comEvent.level == 2"> |
| | | AND center_id=#{comEvent.searchId} |
| | | AND center_id=#{comEvent.searchId} AND current_process_type=1 |
| | | </if> |
| | | <if test="comEvent.level == 3"> |
| | | AND request_user_community in(select community_id from com_act where street_id = #{comEvent.searchId}) |
| | | AND request_user_community in(select community_id from com_act where street_id = #{comEvent.searchId}) AND current_process_type=3 |
| | | </if> |
| | | <if test="comEvent.level == 4"> |
| | | AND request_user_community=#{comEvent.searchId} |
| | | AND request_user_community=#{comEvent.searchId} AND current_process_type=2 |
| | | </if> |
| | | </if> |
| | | </where> |