| | |
|---|
| | | + "</script>") |
|---|
| | | List<ComMngPopulationVO> listPopulation(ComMngPopulationDTO populationVO); |
|---|
| | | |
|---|
| | | |
|---|
| | | List<ComMngPopulationDO> selectListIds(); |
|---|
| | | |
|---|
| | | @Select("select id,user_id,relationship,`name`,id_card,phone,age,health,job,create_at,update_at,card_photo_front,card_photo_back,family_book from com_mng_family_info where user_id=#{userId} order by create_at desc ") |
|---|
| | | List<ComMngFamilyInfoVO> listFamilyByUserId(Long userId); |
|---|
| | | |
|---|
| | |
|---|
| | | " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmp.sex is not null and cmpct.community_id = ${communityId} GROUP BY cmp.sex") |
|---|
| | | List<IndexPopulationSexStatisticsVO> getScreenIndexByPopulationSex(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " |
|---|
| | | + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " |
|---|
| | | + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " |
|---|
| | | + " e.happen_time DESC " + " LIMIT 8") |
|---|
| | | // @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " |
|---|
| | | // + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " |
|---|
| | | // + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " |
|---|
| | | // + " e.happen_time DESC " + " LIMIT 8") |
|---|
| | | List<IndexEventListStatisticsVO> getScreenIndexByEventList(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " count( id ) AS microWishTotal, " |
|---|
