| | |
|---|
| | | </select> |
|---|
| | | <select id="getIndexResidentActBaseData" |
|---|
| | | resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO"> |
|---|
| | | SELECT filed, num, ROUND(num/total,2) AS percent FROM |
|---|
| | | SELECT filed, num, IF(total = 0,0,ROUND(num/total,2)) AS percent FROM |
|---|
| | | (SELECT t1.activity_type AS filed, COUNT(t2.id) AS num |
|---|
| | | FROM com_act_activity t1 |
|---|
| | | LEFT JOIN (SELECT * FROM com_act_act_sign WHERE `status` = 1) t2 ON t1.id = t2.activity_id |
|---|
| | |
|---|
| | | `position`, |
|---|
| | | 3 AS equipmentStatus |
|---|
| | | FROM com_property_equipment |
|---|
| | | WHERE serial_no NOT IN( |
|---|
| | | WHERE community_id = #{communityId} AND serial_no NOT IN( |
|---|
| | | SELECT DISTINCT(t1.serial_no) |
|---|
| | | FROM com_property_alarm t1 |
|---|
| | | LEFT JOIN com_property_equipment t2 ON t1.serial_no = t2.serial_no |
|---|
