| | |
| | | String localCity = comActAcidRecordVO.getLocalCity(); |
| | | String relationName = "panzhihua"; |
| | | if (isNotEmpty(localCity)) { |
| | | if (StringUtils.inStringIgnoreCase(localCity, "东区,炳草岗街道,红星社区", "盐边县,红果彝族乡,红星社区", |
| | | "仁和区,大河中路街道,阳光社区", "盐边县,红格镇,阳光社区", "米易县,攀莲镇,城南社区", "盐边县,桐子林镇,城南社区", |
| | | "米易县,攀莲镇,城北社区", "盐边县,桐子林镇,城北社区")) { |
| | | relationName = localCity; |
| | | } else { |
| | | relationName = localCity.substring(localCity.lastIndexOf(",") + 1); |
| | | } |
| | | relationName = localCity; |
| | | } else { |
| | | String realAddress = comActAcidRecordVO.getRealAddress(); |
| | | if (realAddress.contains("攀枝花")) { |
| | |
| | | AND t1.`type` = #{commonPage.type} |
| | | </if> |
| | | <if test="commonPage.relationName !=null and commonPage.relationName !='' and commonPage.relationName !='panzhihua'"> |
| | | and t1.relation_name = #{commonPage.relationName} |
| | | and t1.relation_name like concat('%',#{commonPage.relationName},'%') |
| | | </if> |
| | | </where> |
| | | GROUP BY t1.id |