20231207_qiuyh_调整巡检

邱宇豪

2023-12-07 ed5d721437f2bf4780810c67662b6959fa9cb8a0

20231207_qiuyh_调整巡检

 hd/pipe/secure/src/main/resources/mapping/RegionInspectionRecordMapper.xml

@@ -169,6 +169,7 @@
                a.regionInspectionId,
                a.inspectionTime,
                a.task,
                a.standard,
                a.region,
                a.realName,
                IF(a.completeRegionNum = a.needRegionNum,"已完成","待巡检") statusName,
@@ -179,6 +180,7 @@
                             t.regionInspectionId,
                             MIN(t.inspectionTime) inspectionTime,
                             tri.task task,
                             tri.standard standard,
                             GROUP_CONCAT(DISTINCT trhi.region) region,
                             spu.real_name realName,
                             SUM(t.`status`)/(SELECT count(regionInspectionId) FROM t_region_inspection_hazard_inform WHERE regionInspectionId =  t.regionInspectionId) completeRegionNum,