数据中心优化

xiangpei

2024-09-03 6c5d7fa4635b06d30840c39f96bd381b65cb56e7

数据中心优化

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java

@@ -65,4 +65,7 @@
    /** 数据中心对应的接口地址 */
    private String apiUrl;

    /** 排序值 */
    private Integer orderNum;

}

 ycl-server/src/main/java/com/ycl/platform/controller/DataCenterController.java

@@ -127,6 +127,18 @@
    }

    /**
     * 视频：录像可用率
     *
     * @param query
     * @return
     */
    @PostMapping("/videoAvailabilityRate")
    public Result videoAvailabilityRate(@RequestBody DataCenterQuery query) {
        query.setTime();
        return dataCenterService.videoAvailabilityRate(query);
    }

    /**
     * 视频：重点点位录像可用率
     *
     * @param query

 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java

@@ -197,9 +197,9 @@
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<RecordMetaDSumResult> resultList = mongoTemplate.find(query, RecordMetaDSumResult.class);
        // 统计数
        long one = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("1")), OneMachineFileResult.class);
        long two = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("2")), OneMachineFileResult.class);
        long three = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("-1")), OneMachineFileResult.class);
        long one = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("1")), RecordMetaDSumResult.class);
        long two = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("2")), RecordMetaDSumResult.class);
        long three = mongoTemplate.count(new Query().addCriteria(Criteria.where("recordStatus").is("-1")), RecordMetaDSumResult.class);
        HashMap<String, Object> map = new HashMap<>();
        map.put("count", Arrays.asList(one, two, three));
        map.put("list", resultList);
@@ -257,15 +257,15 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        List<RecordMetaDSumResult> resultList = mongoTemplate.find(query, RecordMetaDSumResult.class);
        // 统计数
        long nonNetwork = mongoTemplate.count(new Query().addCriteria(Criteria.where("LWSX").is("0")), OneMachineFileResult.class);
        long network = mongoTemplate.count(new Query().addCriteria(Criteria.where("LWSX").is("1")), OneMachineFileResult.class);
        long video = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/1/")), OneMachineFileResult.class);
        long car = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/2/")), OneMachineFileResult.class);
        long face = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/3/")), OneMachineFileResult.class);
        long nonNetwork = mongoTemplate.count(new Query().addCriteria(Criteria.where("LWSX").is("0")), RecordMetaDSumResult.class);
        long network = mongoTemplate.count(new Query().addCriteria(Criteria.where("LWSX").is("1")), RecordMetaDSumResult.class);
        long video = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/1/")), RecordMetaDSumResult.class);
        long car = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/2/")), RecordMetaDSumResult.class);
        long face = mongoTemplate.count(new Query().addCriteria(Criteria.where("SXJGNLX").regex("/3/")), RecordMetaDSumResult.class);
        HashMap<String, Object> map = new HashMap<>();
        map.put("count", Arrays.asList(nonNetwork, network, video, car, face));
        map.put("list", resultList);

 ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml

@@ -37,6 +37,8 @@
            <if test="state != null "> and state = #{state}</if>
            <if test="deleted != null  and deleted != ''"> and deleted = #{deleted}</if>
        </where>
        ORDER BY
            order_num
    </select>

    <select id="selectCheckRuleById"  resultMap="CheckRuleResult">