| | |
| | | al.setCount(alCount); |
| | | typeVO1s.add(al); |
| | | VideoAndAreaVO hand = new VideoAndAreaVO(); |
| | | hand.setName("人工上报"); |
| | | hand.setName("网格巡查"); |
| | | hand.setRatio(new BigDecimal(handCount * 1.0 / allCount).setScale(2, BigDecimal.ROUND_HALF_UP)); |
| | | hand.setCount(handCount); |
| | | typeVO1s.add(hand); |
| | |
| | | baseCase.setCommunityId(videoPoint.getCommunityId()); |
| | | baseCase.setSite(videoPoint.getAddress()); |
| | | baseCase.setGridId(videoPoint.getGridId()); |
| | | baseCase.setSite(videoPoint.getAddress()); |
| | | |
| | | baseCaseService.save(baseCase); |
| | | violations.setId(baseCase.getId()); |
| | |
| | | t1.alarm_time, |
| | | t1.longitude, |
| | | t1.latitude, |
| | | ( CASE WHEN t1.category = 1 THEN "违规" WHEN t1.category = 2 THEN "违建" ELSE "其他" END ) AS type, |
| | | ( CASE WHEN t1.event_source = 1 THEN "视频巡查" WHEN t1.event_source = 2 THEN "人工上报" ELSE "其他" END ) AS alarmAdvice, |
| | | ( CASE WHEN t1.event_source = 1 THEN "视频巡查" WHEN t1.event_source = 2 THEN "人工上报" ELSE "其他" END ) AS source, |
| | | -- ( CASE WHEN t1.category = 1 THEN "违规" WHEN t1.category = 2 THEN "违建" ELSE "其他" END ) AS type, |
| | | -- ( CASE WHEN t1.event_source = 1 THEN "视频巡查" WHEN t1.event_source = 2 THEN "网格巡查" ELSE "其他" END ) AS alarmAdvice, |
| | | dd.name AS type, |
| | | ( CASE WHEN t1.event_source = 1 THEN "视频巡查" WHEN t1.event_source = 2 THEN "网格巡查" ELSE "其他" END ) AS source, |
| | | t1.site AS address, |
| | | t2.description, |
| | | t3.`name` AS point, |
| | |
| | | WHEN t1.state = 7 THEN '处置' |
| | | WHEN t1.state = 8 THEN '核查' |
| | | WHEN t1.state = 9 THEN '结案' |
| | | END) `status` , |
| | | END) `alarmAdvice` , |
| | | pdd.`name` as grade |
| | | FROM |
| | | ums_base_case t1 |