坐标集合字段

zhanghua

2023-03-17 680ead20fbd8c2e2eb7665e493d7ede20061ac7b

坐标集合字段

 ycl-platform/src/main/java/com/ycl/vo/cockpit/statisticsEvents/GridMapVO.java

@@ -23,6 +23,9 @@
    @ApiModelProperty(value = "网格上报事件数量")
    private Integer handCount;

    @ApiModelProperty(value = "坐标集合")
    private String region;

    public Integer getHandCount() {
        return this.eventCount - this.aiCount;
    }

 ycl-platform/src/main/resources/mapper/equipment/OrgGridMapper.xml

@@ -23,6 +23,7 @@
                SELECT
                    og.id,
                    og.`name`,
                    og.region,
                    COUNT( DISTINCT v.id ) eventCount ,
                    sum(case WHEN v.video_point_id is not null then 1 else 0 END ) aiCount
                FROM