| | |
| | | + " order by a.create_at desc" + "</script>") |
| | | IPage<ComActVO> pageCommunity(Page page, @Param("pageComActDTO") PageComActDTO pageComActDTO); |
| | | |
| | | @Update("update sys_user u set u.password=#{password} where u.account=#{account} and u.type=3 and u.community_id = #{communityId}") |
| | | @Update("update sys_user u set u.password=#{password} where u.account=#{account} and u.type=3 and u.community_id = ${communityId}") |
| | | void updateAccountPassword(@Param("password") String password, @Param("account") String account, |
| | | @Param("communityId") Long communityId); |
| | | |
| | |
| | | + "left join com_mng_struct_area_province as cmsap on cmsap.province_adcode = ca.province_code\n" |
| | | + "left join com_mng_struct_area_city as cmsac on cmsac.city_adcode = ca.city_code\n" |
| | | + "left join com_mng_struct_area_district as cmsad on cmsad.district_adcode = ca.area_code\n" |
| | | + "left join com_street as cs on cs.street_id = ca.street_id\n" + "where ca.community_id = #{communityId}") |
| | | + "left join com_street as cs on cs.street_id = ca.street_id\n" + "where ca.community_id = ${communityId}") |
| | | ComPopulationActVO getPopulationActById(@Param("communityId") Long communityId); |
| | | |
| | | @Select("select `name`,street_id from com_street where area_code = '510423'") |
| | |
| | | @Select("select community_id,name,lng,lat from com_act where state = 0 and area_code = '510423' ") |
| | | List<EventGridCommunityAdminVO> getWestCommunityLists(); |
| | | |
| | | @Select("select account,plaintext_password as password from com_act where community_id = #{communityId}") |
| | | @Select("select account,plaintext_password as password from com_act where community_id = ${communityId}") |
| | | ComActPasswordVo getCommunityPassword(@Param("communityId") Long communityId); |
| | | } |