Merge remote-tracking branch 'origin/master'
| | |
| | | and jp.source = #{place.source} |
| | | </if> |
| | | <if test="place.isPerfect==1"> |
| | | and |
| | | ( |
| | | jp.place_name is null |
| | | or jp.image_urls is null |
| | | or jppl.poi_code is null |
| | | or bu.real_name is null |
| | | or bu.phone is null |
| | | ) |
| | | and jpe.confirm_flag = 4 |
| | | </if> |
| | | <if test="place.isPerfect==2"> |
| | | and jp.place_name != "" |
| | | and jp.image_urls != "" |
| | | and jppl.poi_code is not null |
| | | and bu.real_name != "" |
| | | and bu.phone != "" |
| | | and jpe.confirm_flag >= 1 and jpe.confirm_flag < 4 |
| | | </if> |
| | | <if test="place.regionCode != null and place.regionCode !='' "> |
| | | and jg.community_code like concat('%',#{place.regionCode},'%') |