| | |
|---|
| | | SELECT |
|---|
| | | count( id ) AS examineNum, |
|---|
| | | ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 2 AND community_id = #{communityId} AND del_tag = 0 ) AS verificationNum, |
|---|
| | | ( SELECT count( id ) FROM com_act_easy_photo WHERE `is_publicity` = 1 AND community_id = #{communityId} AND del_tag = 0 ) AS rejectNum, |
|---|
| | | ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` in (2,4) AND `is_publicity` = 1 AND community_id = #{communityId} AND del_tag = 0 ) AS rejectNum, |
|---|
| | | ( SELECT count( id ) FROM com_act_easy_photo WHERE `status` = 4 AND community_id = #{communityId} AND del_tag = 0 ) AS completeNum, |
|---|
| | | (select count(id) from com_act_easy_photo where `status` in (2,4) AND community_id = #{communityId} and del_tag = 0 and activity_type = 1) as yzAllTotal, |
|---|
| | | (select count(id) from com_act_easy_photo where `status` in (2,4) AND community_id = #{communityId} and del_tag = 0 and activity_type = 1 and examine_at between timestamp(date_add(curdate(), interval - 0 day)) and now()) as yzDayTotal, |
|---|
