| | |
| | | + " LEFT JOIN com_mng_population AS cmp ON cmp.id = cmphu.popul_id " |
| | | + " left join com_mng_population_community_tags AS cmpct on cmp.id = cmpct.population_id " + "WHERE " |
| | | + " cmphu.house_id = #{houseId} " + "<if test='relation != null '>" + " AND cmphu.relation = #{relation} " |
| | | + " </if> " + "<if test='relationId != null '>" + " AND cmphu.relation_id = #{relationId} " + " group by id </if> " |
| | | + " </if> " + "<if test='relationId != null '>" + " AND cmphu.relation_id = #{relationId} " + "</if> group by id " |
| | | + " </script>") |
| | | List<PopulationListVO> getGridVillageBuildingPopulationList(@Param("houseId") Long houseId, |
| | | @Param("relation") Integer relation, @Param("relationId") Integer relationId); |