| | |
| | | @Select("SELECT \n" + |
| | | "COUNT(DISTINCT u.user_id)allUser,\n" + |
| | | "(select COUNT(m.id) from com_mng_volunteer_mng m where m.community_id=#{communityId} and m.`state`=2)volunteerUser,\n" + |
| | | "COUNT(DISTINCT case when u.is_partymember=1 then u.user_id else null end )partymemberUser,\n" + |
| | | " (select count(id) from com_pb_member cpm where cpm.audit_result = 1 and cpm.community_id = #{communityId}) partymemberUser,\n" + |
| | | "COUNT(h.id)house\n" + |
| | | "FROM\n" + |
| | | "sys_user u\n" + |
| | |
| | | " card_photo_front = #{userArchivesVO.cardPhotoFront} \n" + |
| | | ", card_photo_back = #{userArchivesVO.cardPhotoBack} \n" + |
| | | ",family_book = #{userArchivesVO.familyBook} \n" + |
| | | ",job = #{userArchivesVO.job} \n" + |
| | | " where user_id = #{userArchivesVO.userId}") |
| | | void updateUserArchives(@Param("userArchivesVO") UpdateUserArchivesVO userArchivesVO); |
| | | |