| | |
| | | @Select("<script> select ca.`name`,ca.street_id,ca.community_id,cs.`name` as streetName " + |
| | | "from com_act as ca " + |
| | | "left join com_street as cs on cs.street_id = ca.street_id " + |
| | | "where ca.state = 0 and ca.name like '%#{name}%' <if test='areaCode !=null'> and cs.area_code = #{areaCode} </if> </script> ") |
| | | "where ca.state = 0 and ca.name like '%#{name}%' <if test='areaCode !=null and areaCode !='''> and cs.area_code = #{areaCode} </if> </script> ") |
| | | List<CommunitySwitchAllAppletsVO> getCommunityListByName(@Param("name") String name,@Param("areaCode") String areaCode); |
| | | |
| | | @Select("SELECT c.community_id, c.`name`, c.street_id, cs.`name` as streetName," + |