| | |
|---|
| | | <select id="selectIndexEasyPhotoBaseData" |
|---|
| | | resultType="com.panzhihua.common.model.vos.community.bigscreen.BigScreenEasyPhotoStatisticsInfo"> |
|---|
| | | SELECT |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id IN (1,3,4,5,6,7,8)) AS eventDealTotal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 7) AS eventTFDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 4) AS eventZADeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 5) AS eventMDDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 3) AS eventTSDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 6) AS eventMSDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 8) AS eventFJDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1) AS otherDeal |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id IN (1552663338578743296,1552663345243492353,1552663345524510720,1552663345570648064,1552663345683894273,1552663345751003136,1552663345885220866)) AS eventDealTotal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345751003136) AS eventTFDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345524510720) AS eventZADeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345570648064) AS eventMDDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345243492353) AS eventTSDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345683894273) AS eventMSDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663345885220866) AS eventFJDeal, |
|---|
| | | (SELECT COUNT(id) FROM com_act_easy_photo WHERE community_id = ${communityId} AND `status` IN(4,5) AND del_tag = 0 AND classify_id = 1552663338578743296) AS otherDeal |
|---|
| | | </select> |
|---|
| | | <select id="getEasyPhotoAddPolylineData" |
|---|
| | | resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO"> |
|---|
