| | |
|---|
| | | @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(case when u.is_partymember=1 then u.user_id else null end )partymemberUser,\n" + |
|---|
| | | "COUNT(DISTINCT case when u.is_partymember=1 then u.user_id else null end )partymemberUser,\n" + |
|---|
| | | "COUNT(h.id)house\n" + |
|---|
| | | "FROM\n" + |
|---|
| | | "sys_user u\n" + |
|---|
| | |
|---|
| | | "SELECT \n" + |
|---|
| | | "u.id+100000000 'order',\n" + |
|---|
| | | "u.door_number doorNumber,\n" + |
|---|
| | | "u.is_rent isRent,\n" + |
|---|
| | | "if(u.is_rent=1,'租住','自主')isRent,\n" + |
|---|
| | | "u.name,\n" + |
|---|
| | | "u.nation,\n" + |
|---|
| | | "case u.political_outlook when 1 then '党员' when 2 then '团员' else '群众' end politicalOutlook,\n" + |
|---|
