blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
fuliqi
2024-09-04 d6e5a42f021b5e2612f970da21cccf386a4e6640 
 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java


@@ -57,7 +57,8 @@


    @Override


    public Result videoPointOnlineRate(DataCenterQuery params) {


        // 生成查询


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("arealayerName", "ipAddr", "deviceName", "deviceId");


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, null);




        // 先查总数再分页


        long total = mongoTemplate.count(query, VideoOnlineResult.class);


@@ -85,9 +86,9 @@


    public Result deptVideoPointOnlineRate(DataCenterQuery params) {


        // 先查出部级点位的国标


        List<String> deptGBList = pointMapper.getDeptPointGB(0);




        List<String> likeFileds = Arrays.asList("arealayerName", "ipAddr", "deviceName", "deviceId");


        // 生成查询


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, deptGBList);


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, deptGBList);




        // 先查总数再分页


        long total = mongoTemplate.count(query, VideoOnlineResult.class);


@@ -130,8 +131,8 @@


    public Result videoImportantPointOnlineRate(DataCenterQuery params) {


        // 先查出重点点位的国标


        List<String> deptGBList = pointMapper.getDeptPointGB(1);




        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, deptGBList);


        List<String> likeFileds = Arrays.asList("arealayerName", "ipAddr", "deviceName", "deviceId");


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, deptGBList);




        long total = mongoTemplate.count(query, VideoOnlineResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -177,8 +178,8 @@


    public Result videoImportantPointImageOnlineRate(DataCenterQuery params) {


        // 先查出重点指挥图像点位的国标


        List<String> deptGBList = pointMapper.getDeptPointGB(2);




        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, deptGBList);


        List<String> likeFileds = Arrays.asList("arealayerName", "ipAddr", "deviceName", "deviceId");


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, deptGBList);




        long total = mongoTemplate.count(query, VideoOnlineResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -223,8 +224,8 @@


     */


    @Override


    public Result videoOneMachineDocumentRegister(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("ip.showValue", "name.showValue", "serialNumber.showValue");


        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitorQualifyResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -272,8 +273,8 @@


     */


    @Override


    public Result videoOneMachineDocumentQualified(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("ip.showValue", "name.showValue", "serialNumber.showValue");


        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitorQualifyResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -322,7 +323,8 @@


    @Override


    public Result videoAssessmentFileRatio(DataCenterQuery params) {


        // TODO 新增一张表记录每次的档案考核


        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("ip.showValue", "name.showValue", "serialNumber.showValue");


        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitorQualifyResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -370,8 +372,8 @@


     */


    @Override


    public Result videoAvailabilityRate(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", null);


        List<String> likeFileds = Arrays.asList("deviceId", "deviceName");


        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", likeFileds, null);




        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);


        MongoUtil.setPage(query, params, "createTime");


@@ -417,8 +419,8 @@


    public Result deptVideoAvailabilityRate(DataCenterQuery params) {




        List<String> deptGBList = pointMapper.getDeptPointGB(0);




        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", deptGBList);


        List<String> likeFileds = Arrays.asList("deviceId", "deviceName");


        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", likeFileds, deptGBList);




        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);


        MongoUtil.setPage(query, params, "createTime");


@@ -467,8 +469,8 @@


    public Result videoImportantPointAvailabilityRate(DataCenterQuery params) {




        List<String> deptGBList = pointMapper.getDeptPointGB(1);




        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", deptGBList);


        List<String> likeFileds = Arrays.asList("deviceId", "deviceName");


        Query query = MongoUtil.getQuery(params, "deviceId", "createTime", likeFileds, deptGBList);




        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);


        MongoUtil.setPage(query, params, "createTime");


@@ -514,8 +516,8 @@


     */


    @Override


    public Result videoLabelingAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "deviceId", "", new ArrayList<>());


        List<String> likeFileds = Arrays.asList("deviceId", "deviceName");


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);


        List<RecordMetaDSumResult> resultList = mongoTemplate.find(query, RecordMetaDSumResult.class);


@@ -541,7 +543,8 @@


    public Result videoImportantPointLabelingAccuracy(DataCenterQuery params) {




        List<String> deptGBList = pointMapper.getDeptPointGB(1);


        Query query = MongoUtil.getQuery(params, "deviceNo", "checkTime", deptGBList);


        List<String> likeFileds = Arrays.asList("deviceNo", "osdName");


        Query query = MongoUtil.getQuery(params, "deviceNo", "checkTime", likeFileds, deptGBList);




        long total = mongoTemplate.count(query, OsdCheckResult.class);


        MongoUtil.setPage(query, params, "checkTime");


@@ -590,7 +593,8 @@


    @Override


    public Result videoCheckTimeAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "deviceId", "", new ArrayList<>());


        List<String> likeFileds = Arrays.asList("deviceId");


        Query query = MongoUtil.getQuery(params, "deviceId", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, OneMachineFileResult.class);


        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);


@@ -616,8 +620,8 @@


    public Result videoImportantPointCheckTimeAccuracy(DataCenterQuery params) {




        List<String> deptGBList = pointMapper.getDeptPointGB(1);




        Query query = MongoUtil.getQuery(params, "deviceNo", "checkTime", deptGBList);


        List<String> likeFileds = Arrays.asList("deviceNo", "osdName");


        Query query = MongoUtil.getQuery(params, "deviceNo", "checkTime", likeFileds, deptGBList);




        long total = mongoTemplate.count(query, OsdCheckResult.class);


        MongoUtil.setPage(query, params, "checkTime");


@@ -663,8 +667,8 @@


     */


    @Override


    public Result vehicleViewDockStable(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -711,8 +715,8 @@


     */


    @Override


    public Result vehiclePointOnlineRate(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -737,8 +741,8 @@


     */


    @Override


    public Result vehicleNetDeviceDirectoryConsistency(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("ip.showValue", "name.showValue", "serialNumber.showValue");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitorQualifyResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -786,8 +790,8 @@


     */


    @Override


    public Result vehicleCollectionConsistency(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "crossName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, CrossDetailResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -835,8 +839,8 @@


     */


    @Override


    public Result vehicleCollectionDataIntegrity(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, DataIntegrityMonitoringResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -860,8 +864,8 @@


     */


    @Override


    public Result vehicleCollectionDataCaptured(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, AttrRecognitionMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -881,8 +885,8 @@


     */


    @Override


    public Result vehicleClockAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, VehicleDeviceInspectionResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -930,8 +934,8 @@


     */


    @Override


    public Result vehicleTimelyUploadAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, SnapshotDelayMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -951,8 +955,8 @@


     */


    @Override


    public Result vehicleUrlAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, PicAccessResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -972,8 +976,8 @@


     */


    @Override


    public Result vehicleBigImgAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, new ArrayList<>());


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, VehicleDeviceSamplingResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -993,8 +997,8 @@


     */


    @Override


    public Result faceViewDockStable(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1041,8 +1045,8 @@


     */


    @Override


    public Result facePointOnlineRate(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1089,14 +1093,14 @@


     */


    @Override


    public Result faceDirectoryConsistency(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("serialNumber.showValue", "ip.showValue", "name.showValue");


        Query query = MongoUtil.getQuery(params, "serialNumber.showValue", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitorQualifyResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


        List<MonitorQualifyResult> resultList = mongoTemplate.find(query, MonitorQualifyResult.class);




// 统计数量


        // 统计数量


        MongoDatabase database = mongoTemplate.getDb();


        MongoCollection<Document> collection = database.getCollection("uy_monitor_qualify");




@@ -1138,8 +1142,8 @@


     */


    @Override


    public Result faceCollectionConsistency(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "crossName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, CrossDetailResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1187,8 +1191,8 @@


     */


    @Override


    public Result faceImgQualification(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "cameraName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, MonitoringDetailResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1236,8 +1240,8 @@


     */


    @Override


    public Result faceCapturesImagesAccuracy(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1284,8 +1288,8 @@


     */


    @Override


    public Result faceTimelyUpload(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);


@@ -1332,8 +1336,8 @@


     */


    @Override


    public Result faceAvailabilityOfLargeImg(DataCenterQuery params) {




        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, null);


        List<String> likeFileds = Arrays.asList("externalIndexCode", "deviceName");


        Query query = MongoUtil.getQuery(params, "externalIndexCode", TIME_FIELD, likeFileds, null);




        long total = mongoTemplate.count(query, FaceDeviceSamplingResult.class);


        MongoUtil.setPage(query, params, TIME_FIELD);