| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="indexDynamic" resultType="com.panzhihua.common.model.vos.community.bigscreen.IndexDynamic"> |
|---|
| | | |
|---|
| | | SELECT count( id ) AS microWish, |
|---|
| | | IFNULL(( SELECT count( id ) FROM com_act_activity WHERE community_id = camw.community_id AND volunteer_max = 0),0) AS residentActivity, |
|---|
| | | IFNULL(( SELECT count( id ) FROM com_act_activity WHERE community_id = camw.community_id AND volunteer_max != 0),0) AS volunteerActivity, |
|---|
| | | IFNULL(( SELECT count( id ) FROM com_act_easy_photo WHERE status in (1,2,4) and del_tag = 0 AND community_id = camw.community_id ),0) AS easyPhoto, |
|---|
| | | IFNULL(( SELECT count( id ) FROM com_pb_activity WHERE STATUS = 5 AND community_id = camw.community_id ),0) AS partyActivity, |
|---|
| | | IFNULL(( SELECT count( id ) FROM com_act_questnaire WHERE community_id = camw.community_id and is_hide=0 ),0) AS questionnaire, |
|---|
