From 602293e65fa4323e4528b3e54776da5223ae4d4a Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期六, 24 八月 2024 14:03:24 +0800 Subject: [PATCH] 大屏考核视频字段 --- ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml | 2 ycl-server/src/main/java/com/ycl/task/ContractResultTask.java | 4 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java | 380 ++++++---------------------------------------- ycl-server/src/main/resources/mapper/zgyw/CheckIndexVideoMapper.xml | 65 +------ ycl-common/src/main/java/enumeration/ErrorType.java | 4 5 files changed, 72 insertions(+), 383 deletions(-) diff --git a/ycl-common/src/main/java/enumeration/ErrorType.java b/ycl-common/src/main/java/enumeration/ErrorType.java index a1500f6..91b3cf1 100644 --- a/ycl-common/src/main/java/enumeration/ErrorType.java +++ b/ycl-common/src/main/java/enumeration/ErrorType.java @@ -15,7 +15,6 @@ DEVICE_OFFLINE("DEVICEOFFLINE", "璁惧绂荤嚎"), VIDEO_LOSS("VIDEOMISS", "褰曞儚缂哄け"), VIDEO_NONE("NOVIDEO", "鏃犲綍鍍�"), - PIC_URLABNORMAL("PICURLABNORMAL","鍥剧墖璁块棶寮傚父"), POINT_INFO_ERROR("POINTINFOERRO", "鐐逛綅淇℃伅閿欒"), POINT_INFO_MISS("POINTINFOMISS", "鐐逛綅淇℃伅涓嶅叏"), SIGNAL_LOSS("SIGNALMISS", "淇″彿缂哄け"), @@ -28,9 +27,10 @@ UNKNOWN("UNKNOWN", "鏈煡"), CLOCK_SKEW("CLOCKSKEW", "鏃堕挓鍋忓樊"), OSD_ERROR("OSD", "osd寮傚父"), + PIC_URLABNORMAL("PICURLABNORMAL","鍥剧墖璁块棶寮傚父"), MONITOR_UNQUALIFY("MONITORUNQUALIFY", "涓�鏈轰竴妗d笉鍚堟牸"), - VIDEO_ORPIC_UNNORMAL("VIDEOORPICUNNORMAL", "瑙嗛鎷夋祦銆佸浘鐗囪幏鍙栧紓甯�"), PIC_UNUSEFUL("PICUNUSEFUL", "澶у浘涓嶅彲鐢�"), + VIDEO_ORPIC_UNNORMAL("VIDEOORPICUNNORMAL", "瑙嗛鎷夋祦銆佸浘鐗囪幏鍙栧紓甯�"), ; private String value; diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java index 777d77e..90f71f6 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableName; import com.ycl.platform.base.CheckIndex; +import lombok.Data; import java.math.BigDecimal; import java.util.Date; @@ -17,383 +18,110 @@ * @date 2024-04-29 */ @TableName("t_check_index_video") -public class CheckIndexVideo extends CheckIndex -{ +@Data +public class CheckIndexVideo extends CheckIndex { private static final long serialVersionUID = 1L; - /** 骞冲彴鍦ㄧ嚎鐜� */ + /** + * 骞冲彴鍦ㄧ嚎鐜� + */ @Excel(name = "骞冲彴鍦ㄧ嚎鐜�") @TableField("platform_online") private BigDecimal platformOnline; - /** 涓�鏈轰竴妗e悎鏍肩巼 */ + /** + * 涓�鏈轰竴妗e悎鏍肩巼 + */ @Excel(name = "涓�鏈轰竴妗e悎鏍肩巼") @TableField("monitor_qualification") private BigDecimal monitorQualification; - /** 妗f鑰冩牳姣� */ + /** + * 妗f鑰冩牳姣� + */ @Excel(name = "涓�鏈轰竴妗f敞鍐岀巼") @TableField("monitor_registration") private BigDecimal monitorRegistration; - /** 妗f鑰冩牳姣� */ + /** + * 妗f鑰冩牳姣� + */ @Excel(name = "妗f鑰冩牳姣�") @TableField("archives_rate") private BigDecimal archivesRate; - /** 鐐逛綅鍦ㄧ嚎鐜� */ + /** + * 鐐逛綅鍦ㄧ嚎鐜� + */ @Excel(name = "鐐逛綅鍦ㄧ嚎鐜�") @TableField("site_online") private BigDecimal siteOnline; - /** 褰曡薄鍙敤鐜� */ + /** + * 褰曡薄鍙敤鐜� + */ @Excel(name = "褰曡薄鍙敤鐜�") @TableField("video_available") private BigDecimal videoAvailable; - /** 鏍囨敞姝g‘鐜� */ + /** + * 鏍囨敞姝g‘鐜� + */ @Excel(name = "鏍囨敞姝g‘鐜�") @TableField("annotation_accuracy") private BigDecimal annotationAccuracy; - /** 鏍℃椂鍑嗙‘鐜� */ + /** + * 鏍℃椂鍑嗙‘鐜� + */ @Excel(name = "鏍℃椂鍑嗙‘鐜�") @TableField("timing_accuracy") private BigDecimal timingAccuracy; - /** 閲嶇偣鐐逛綅鍦ㄧ嚎鐜� */ + /** + * 閲嶇偣鐐逛綅鍦ㄧ嚎鐜� + */ @Excel(name = "閲嶇偣鐐逛綅鍦ㄧ嚎鐜�") @TableField("key_site_online") private BigDecimal keySiteOnline; - /** 閲嶇偣鐐逛綅褰曡薄鍙敤鐜� */ - @Excel(name = "閲嶇偣鐐逛綅褰曡薄鍙敤鐜�",width = 25) + /** + * 閲嶇偣鐐逛綅褰曡薄鍙敤鐜� + */ + @Excel(name = "閲嶇偣鐐逛綅褰曡薄鍙敤鐜�", width = 25) @TableField("key_video_available") private BigDecimal keyVideoAvailable; - /** 閲嶇偣鐐逛綅鏍囨敞姝g‘鐜� */ - @Excel(name = "閲嶇偣鐐逛綅鏍囨敞姝g‘鐜�",width = 25) + /** + * 閲嶇偣鐐逛綅鏍囨敞姝g‘鐜� + */ + @Excel(name = "閲嶇偣鐐逛綅鏍囨敞姝g‘鐜�", width = 25) @TableField("key_annotation_accuracy") private BigDecimal keyAnnotationAccuracy; - /** 閲嶇偣鐐逛綅鎸夋椂姝g‘鐜� */ - @Excel(name = "閲嶇偣鐐逛綅鎸夋椂姝g‘鐜�",width = 25) + /** + * 閲嶇偣鐐逛綅鎸夋椂姝g‘鐜� + */ + @Excel(name = "閲嶇偣鐐逛綅鎸夋椂姝g‘鐜�", width = 25) @TableField("key_timing_accuracy") private BigDecimal keyTimingAccuracy; - /** 閲嶇偣鎸囨尌鍥惧儚鍏畨閮ㄥ贰妫�缁撴灉 */ - @Excel(name = "閲嶇偣鎸囨尌鍥惧儚鍏畨閮ㄥ贰妫�缁撴灉",width = 25) - @TableField("key_command_image_inspection") - private BigDecimal keyCommandImageInspection; - - /** 閲嶇偣鎸囨尌鍥惧儚鐩綍鏍� */ - @Excel(name = "閲嶇偣鎸囨尌鍥惧儚鐩綍鏍�",width = 25) - @TableField("key_command_image_directory_tree") - private BigDecimal keyCommandImageDirectoryTree; - - /** 鍦ㄧ嚎妫�鏌ュ钩鍙伴儴缃插強杩愯鐜� */ - @Excel(name = "鍦ㄧ嚎妫�鏌ュ钩鍙伴儴缃插強杩愯鐜�",width = 25) - @TableField("online_inspection_platform") - private BigDecimal onlineInspectionPlatform; - - /** 瑙嗛浼犺緭缃戣祫浜у噯纭巼 */ - @Excel(name = "瑙嗛浼犺緭缃戣祫浜у噯纭巼",width = 25) - @TableField("video_transmission_assets_accuracy") - private BigDecimal videoTransmissionAssetsAccuracy; - - /** 瑙嗛浼犺緭缃戣祫浜у急鍙d护寰楀垎姣旂巼 */ - @Excel(name = "瑙嗛浼犺緭缃戣祫浜у急鍙d护寰楀垎姣旂巼",width = 25) - @TableField("video_transmission_assets_weak_password_score") - private BigDecimal videoTransmissionAssetsWeakPasswordScore; - - /** 瑙嗛浼犺緭缃戝嵄闄╄祫浜у緱鍒嗘瘮閲� */ - @Excel(name = "瑙嗛浼犺緭缃戝嵄闄╄祫浜у緱鍒嗘瘮閲�",width = 25) - @TableField("video_transmission_dangerous_assets_score") - private BigDecimal videoTransmissionDangerousAssetsScore; - - /** 瑙嗛浼犺緭缃戣竟鐣屽畬鏁存�ф娴嬫墸鍒嗛」 */ - @Excel(name = "瑙嗛浼犺緭缃戣竟鐣屽畬鏁存�ф娴嬫墸鍒嗛」",width = 25) - @TableField("video_transmission_boundary_integrity_detection") - private BigDecimal videoTransmissionBoundaryIntegrityDetection; - - /** 瑙嗛浼犺緭缃戣竟鐣屽畬鏁存�ф娴嬫墸鍒嗛」 */ - @Excel(name = "閲嶇偣鎸囨尌鍥惧儚鍦ㄧ嚎鐜�",width = 25) + /** + * 閲嶇偣鎸囨尌鍥惧儚鍦ㄧ嚎鐜� + */ + @Excel(name = "閲嶇偣鎸囨尌鍥惧儚鍦ㄧ嚎鐜�", width = 25) @TableField("key_command_image_online") private BigDecimal keyCommandImageOnline; - /** 鏈堣繍琛岀巼 */ - @Excel(name = "鏈堣繍琛岀巼") - @TableField("operating_rate") - private BigDecimal operatingRate; + + /** + * 瑙嗛鍥惧儚璧勬簮瀹夊叏绠$悊 + */ + @Excel(name = "瑙嗛鍥惧儚璧勬簮瀹夊叏绠$悊", width = 25) + @TableField("image_resource_security") + private BigDecimal imageResourceSecurity; + @ExcelIgnore @TableField(exist = false) private List<String> quarter; - - public List<String> getQuarter() { - return quarter; - } - - public void setQuarter(List<String> quarter) { - this.quarter = quarter; - } - - public BigDecimal getPlatformOnline() { - return platformOnline; - } - - public void setPlatformOnline(BigDecimal platformOnline) { - this.platformOnline = platformOnline; - } - - public BigDecimal getMonitorQualification() { - return monitorQualification; - } - - public void setMonitorQualification(BigDecimal monitorQualification) { - this.monitorQualification = monitorQualification; - } - - public BigDecimal getMonitorRegistration() { - return monitorRegistration; - } - - public void setMonitorRegistration(BigDecimal monitorRegistration) { - this.monitorRegistration = monitorRegistration; - } - - public BigDecimal getArchivesRate() { - return archivesRate; - } - - public void setArchivesRate(BigDecimal archivesRate) { - this.archivesRate = archivesRate; - } - - public BigDecimal getSiteOnline() { - return siteOnline; - } - - public void setSiteOnline(BigDecimal siteOnline) { - this.siteOnline = siteOnline; - } - - public BigDecimal getVideoAvailable() { - return videoAvailable; - } - - public void setVideoAvailable(BigDecimal videoAvailable) { - this.videoAvailable = videoAvailable; - } - - public BigDecimal getAnnotationAccuracy() { - return annotationAccuracy; - } - - public void setAnnotationAccuracy(BigDecimal annotationAccuracy) { - this.annotationAccuracy = annotationAccuracy; - } - - public BigDecimal getTimingAccuracy() { - return timingAccuracy; - } - - public void setTimingAccuracy(BigDecimal timingAccuracy) { - this.timingAccuracy = timingAccuracy; - } - - public BigDecimal getKeySiteOnline() { - return keySiteOnline; - } - - public void setKeySiteOnline(BigDecimal keySiteOnline) { - this.keySiteOnline = keySiteOnline; - } - - public BigDecimal getKeyVideoAvailable() { - return keyVideoAvailable; - } - - public void setKeyVideoAvailable(BigDecimal keyVideoAvailable) { - this.keyVideoAvailable = keyVideoAvailable; - } - - public BigDecimal getKeyAnnotationAccuracy() { - return keyAnnotationAccuracy; - } - - public void setKeyAnnotationAccuracy(BigDecimal keyAnnotationAccuracy) { - this.keyAnnotationAccuracy = keyAnnotationAccuracy; - } - - public BigDecimal getKeyCommandImageOnline() { - return keyCommandImageOnline; - } - - public void setKeyCommandImageOnline(BigDecimal keyCommandImageOnline) { - this.keyCommandImageOnline = keyCommandImageOnline; - } - - public BigDecimal getKeyTimingAccuracy() { - return keyTimingAccuracy; - } - - public void setKeyTimingAccuracy(BigDecimal keyTimingAccuracy) { - this.keyTimingAccuracy = keyTimingAccuracy; - } - - public BigDecimal getKeyCommandImageInspection() { - return keyCommandImageInspection; - } - - public void setKeyCommandImageInspection(BigDecimal keyCommandImageInspection) { - this.keyCommandImageInspection = keyCommandImageInspection; - } - - public BigDecimal getKeyCommandImageDirectoryTree() { - return keyCommandImageDirectoryTree; - } - - public void setKeyCommandImageDirectoryTree(BigDecimal keyCommandImageDirectoryTree) { - this.keyCommandImageDirectoryTree = keyCommandImageDirectoryTree; - } - - public BigDecimal getOnlineInspectionPlatform() { - return onlineInspectionPlatform; - } - - public void setOnlineInspectionPlatform(BigDecimal onlineInspectionPlatform) { - this.onlineInspectionPlatform = onlineInspectionPlatform; - } - - public BigDecimal getVideoTransmissionAssetsAccuracy() { - return videoTransmissionAssetsAccuracy; - } - - public void setVideoTransmissionAssetsAccuracy(BigDecimal videoTransmissionAssetsAccuracy) { - this.videoTransmissionAssetsAccuracy = videoTransmissionAssetsAccuracy; - } - - public BigDecimal getVideoTransmissionAssetsWeakPasswordScore() { - return videoTransmissionAssetsWeakPasswordScore; - } - - public void setVideoTransmissionAssetsWeakPasswordScore(BigDecimal videoTransmissionAssetsWeakPasswordScore) { - this.videoTransmissionAssetsWeakPasswordScore = videoTransmissionAssetsWeakPasswordScore; - } - - public BigDecimal getVideoTransmissionDangerousAssetsScore() { - return videoTransmissionDangerousAssetsScore; - } - - public void setVideoTransmissionDangerousAssetsScore(BigDecimal videoTransmissionDangerousAssetsScore) { - this.videoTransmissionDangerousAssetsScore = videoTransmissionDangerousAssetsScore; - } - - public BigDecimal getVideoTransmissionBoundaryIntegrityDetection() { - return videoTransmissionBoundaryIntegrityDetection; - } - - public void setVideoTransmissionBoundaryIntegrityDetection(BigDecimal videoTransmissionBoundaryIntegrityDetection) { - this.videoTransmissionBoundaryIntegrityDetection = videoTransmissionBoundaryIntegrityDetection; - } - - public BigDecimal getOperatingRate() { - return operatingRate; - } - - public void setOperatingRate(BigDecimal operatingRate) { - this.operatingRate = operatingRate; - } - - @Override - public Long getId() { - return super.getId(); - } - - @Override - public void setId(Long id) { - super.setId(id); - } - - @Override - public String getDate() { - return super.getDate(); - } - - @Override - public void setDate(String date) { - super.setDate(date); - } - - @Override - public Date getCreateTime() { - return super.getCreateTime(); - } - - @Override - public void setCreateTime(Date createTime) { - super.setCreateTime(createTime); - } - - @Override - public Long getDeptId() { - return super.getDeptId(); - } - - @Override - public void setDeptId(Long deptId) { - super.setDeptId(deptId); - } - - @Override - public String getDeptName() { - return super.getDeptName(); - } - - @Override - public void setDeptName(String deptName) { - super.setDeptName(deptName); - } - - @Override - public Short getExamineTag() { - return super.getExamineTag(); - } - - @Override - public void setExamineTag(Short examineTag) { - super.setExamineTag(examineTag); - } - - @Override - public String toString() { - return "CheckIndexVideo{" + - "id=" + id + - ", date='" + date + '\'' + - ", createTime=" + createTime + - ", deptId=" + deptId + - ", deptName='" + deptName + '\'' + - ", examineTag=" + examineTag + - ", platformOnline=" + platformOnline + - ", monitorQualification=" + monitorQualification + - ", monitorRegistration=" + monitorRegistration + - ", archivesRate=" + archivesRate + - ", siteOnline=" + siteOnline + - ", videoAvailable=" + videoAvailable + - ", annotationAccuracy=" + annotationAccuracy + - ", timingAccuracy=" + timingAccuracy + - ", keySiteOnline=" + keySiteOnline + - ", keyVideoAvailable=" + keyVideoAvailable + - ", keyAnnotationAccuracy=" + keyAnnotationAccuracy + - ", keyTimingAccuracy=" + keyTimingAccuracy + - ", keyCommandImageInspection=" + keyCommandImageInspection + - ", keyCommandImageDirectoryTree=" + keyCommandImageDirectoryTree + - ", onlineInspectionPlatform=" + onlineInspectionPlatform + - ", videoTransmissionAssetsAccuracy=" + videoTransmissionAssetsAccuracy + - ", videoTransmissionAssetsWeakPasswordScore=" + videoTransmissionAssetsWeakPasswordScore + - ", videoTransmissionDangerousAssetsScore=" + videoTransmissionDangerousAssetsScore + - ", videoTransmissionBoundaryIntegrityDetection=" + videoTransmissionBoundaryIntegrityDetection + - ", operatingRate=" + operatingRate + - '}'; - } } diff --git a/ycl-server/src/main/java/com/ycl/task/ContractResultTask.java b/ycl-server/src/main/java/com/ycl/task/ContractResultTask.java index e15e890..339f924 100644 --- a/ycl-server/src/main/java/com/ycl/task/ContractResultTask.java +++ b/ycl-server/src/main/java/com/ycl/task/ContractResultTask.java @@ -10,7 +10,6 @@ import com.ycl.utils.DateUtils; import com.ycl.utils.bean.BeanUtils; import lombok.Data; -import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; import org.springframework.transaction.annotation.Transactional; @@ -24,8 +23,8 @@ * @since 2024/4/28 涓嬪崍 4:14 */ -@Component @Data +@Component("contractResultTask") public class ContractResultTask { private final ITContractService contractService; @@ -38,7 +37,6 @@ /** * 姣忎釜鏈�1鍙锋墽琛岋紝缁熻鑰冩牳缁撴灉 */ - @Scheduled(cron = "0 0 0 1 * ?") @Transactional // @PostConstruct //鍚姩鏃舵墽琛屼竴娆� public void contractResultTask() { diff --git a/ycl-server/src/main/resources/mapper/zgyw/CheckIndexVideoMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/CheckIndexVideoMapper.xml index 6f11cfc..ce044f0 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/CheckIndexVideoMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/CheckIndexVideoMapper.xml @@ -21,18 +21,12 @@ <result property="keyVideoAvailable" column="key_video_available" /> <result property="keyAnnotationAccuracy" column="key_annotation_accuracy" /> <result property="keyTimingAccuracy" column="key_timing_accuracy" /> - <result property="keyCommandImageInspection" column="key_command_image_inspection" /> - <result property="keyCommandImageDirectoryTree" column="key_command_image_directory_tree" /> - <result property="onlineInspectionPlatform" column="online_inspection_platform" /> - <result property="videoTransmissionAssetsAccuracy" column="video_transmission_assets_accuracy" /> - <result property="videoTransmissionAssetsWeakPasswordScore" column="video_transmission_assets_weak_password_score" /> - <result property="videoTransmissionDangerousAssetsScore" column="video_transmission_dangerous_assets_score" /> - <result property="videoTransmissionBoundaryIntegrityDetection" column="video_transmission_boundary_integrity_detection" /> - <result property="operatingRate" column="operating_rate" /> + <result property="keyCommandImageOnline" column="key_command_image_online" /> + <result property="imageResourceSecurity" column="image_resource_security" /> </resultMap> <sql id="selectCheckIndexVideoVo"> - select id, dept_id, create_time, examine_tag, platform_online, monitor_qualification, monitor_registration, archives_rate, site_online, video_available, annotation_accuracy, timing_accuracy, key_site_online, key_video_available, key_annotation_accuracy, key_timing_accuracy, key_command_image_inspection, key_command_image_directory_tree, online_inspection_platform, video_transmission_assets_accuracy, video_transmission_assets_weak_password_score, video_transmission_dangerous_assets_score, video_transmission_boundary_integrity_detection, operating_rate from t_check_index_video + select id, dept_id, create_time, examine_tag, platform_online, monitor_qualification, monitor_registration, archives_rate, site_online, video_available, annotation_accuracy, timing_accuracy, key_site_online, key_video_available, key_annotation_accuracy, key_timing_accuracy, key_command_image_online,image_resource_security from t_check_index_video </sql> <select id="selectCheckIndexVideoList" parameterType="CheckIndexVideo" resultMap="CheckIndexVideoResult"> @@ -56,14 +50,8 @@ <if test="keyVideoAvailable != null "> and key_video_available = #{keyVideoAvailable}</if> <if test="keyAnnotationAccuracy != null "> and key_annotation_accuracy = #{keyAnnotationAccuracy}</if> <if test="keyTimingAccuracy != null "> and key_timing_accuracy = #{keyTimingAccuracy}</if> - <if test="keyCommandImageInspection != null "> and key_command_image_inspection = #{keyCommandImageInspection}</if> - <if test="keyCommandImageDirectoryTree != null "> and key_command_image_directory_tree = #{keyCommandImageDirectoryTree}</if> - <if test="onlineInspectionPlatform != null "> and online_inspection_platform = #{onlineInspectionPlatform}</if> - <if test="videoTransmissionAssetsAccuracy != null "> and video_transmission_assets_accuracy = #{videoTransmissionAssetsAccuracy}</if> - <if test="videoTransmissionAssetsWeakPasswordScore != null "> and video_transmission_assets_weak_password_score = #{videoTransmissionAssetsWeakPasswordScore}</if> - <if test="videoTransmissionDangerousAssetsScore != null "> and video_transmission_dangerous_assets_score = #{videoTransmissionDangerousAssetsScore}</if> - <if test="videoTransmissionBoundaryIntegrityDetection != null "> and video_transmission_boundary_integrity_detection = #{videoTransmissionBoundaryIntegrityDetection}</if> - <if test="operatingRate != null "> and operating_rate = #{operatingRate}</if> + <if test="keyCommandImageOnline != null "> and key_command_image_online = #{keyCommandImageOnline}</if> + <if test="imageResourceSecurity != null "> and image_resource_security = #{imageResourceSecurity}</if> <if test="deptIds != null ">and tciv.dept_id in <foreach collection="deptIds" separator="," open="(" close=")" item="deptId"> #{deptId} @@ -95,15 +83,9 @@ <if test="keyVideoAvailable != null">key_video_available,</if> <if test="keyAnnotationAccuracy != null">key_annotation_accuracy,</if> <if test="keyTimingAccuracy != null">key_timing_accuracy,</if> - <if test="keyCommandImageInspection != null">key_command_image_inspection,</if> - <if test="keyCommandImageDirectoryTree != null">key_command_image_directory_tree,</if> - <if test="onlineInspectionPlatform != null">online_inspection_platform,</if> - <if test="videoTransmissionAssetsAccuracy != null">video_transmission_assets_accuracy,</if> - <if test="videoTransmissionAssetsWeakPasswordScore != null">video_transmission_assets_weak_password_score,</if> - <if test="videoTransmissionDangerousAssetsScore != null">video_transmission_dangerous_assets_score,</if> - <if test="videoTransmissionBoundaryIntegrityDetection != null">video_transmission_boundary_integrity_detection,</if> - <if test="operatingRate != null">operating_rate,</if> - </trim> + <if test="keyCommandImageOnline != null">key_command_image_online,</if> + <if test="imageResourceSecurity != null">image_resource_security,</if> + </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="deptId != null">#{deptId},</if> <if test="createTime != null">#{createTime},</if> @@ -120,14 +102,8 @@ <if test="keyVideoAvailable != null">#{keyVideoAvailable},</if> <if test="keyAnnotationAccuracy != null">#{keyAnnotationAccuracy},</if> <if test="keyTimingAccuracy != null">#{keyTimingAccuracy},</if> - <if test="keyCommandImageInspection != null">#{keyCommandImageInspection},</if> - <if test="keyCommandImageDirectoryTree != null">#{keyCommandImageDirectoryTree},</if> - <if test="onlineInspectionPlatform != null">#{onlineInspectionPlatform},</if> - <if test="videoTransmissionAssetsAccuracy != null">#{videoTransmissionAssetsAccuracy},</if> - <if test="videoTransmissionAssetsWeakPasswordScore != null">#{videoTransmissionAssetsWeakPasswordScore},</if> - <if test="videoTransmissionDangerousAssetsScore != null">#{videoTransmissionDangerousAssetsScore},</if> - <if test="videoTransmissionBoundaryIntegrityDetection != null">#{videoTransmissionBoundaryIntegrityDetection},</if> - <if test="operatingRate != null">#{operatingRate},</if> + <if test="keyCommandImageOnline != null">#{keyCommandImageOnline},</if> + <if test="imageResourceSecurity != null">#{imageResourceSecurity},</if> </trim> </insert> @@ -149,14 +125,8 @@ <if test="keyVideoAvailable != null">key_video_available = #{keyVideoAvailable},</if> <if test="keyAnnotationAccuracy != null">key_annotation_accuracy = #{keyAnnotationAccuracy},</if> <if test="keyTimingAccuracy != null">key_timing_accuracy = #{keyTimingAccuracy},</if> - <if test="keyCommandImageInspection != null">key_command_image_inspection = #{keyCommandImageInspection},</if> - <if test="keyCommandImageDirectoryTree != null">key_command_image_directory_tree = #{keyCommandImageDirectoryTree},</if> - <if test="onlineInspectionPlatform != null">online_inspection_platform = #{onlineInspectionPlatform},</if> - <if test="videoTransmissionAssetsAccuracy != null">video_transmission_assets_accuracy = #{videoTransmissionAssetsAccuracy},</if> - <if test="videoTransmissionAssetsWeakPasswordScore != null">video_transmission_assets_weak_password_score = #{videoTransmissionAssetsWeakPasswordScore},</if> - <if test="videoTransmissionDangerousAssetsScore != null">video_transmission_dangerous_assets_score = #{videoTransmissionDangerousAssetsScore},</if> - <if test="videoTransmissionBoundaryIntegrityDetection != null">video_transmission_boundary_integrity_detection = #{videoTransmissionBoundaryIntegrityDetection},</if> - <if test="operatingRate != null">operating_rate = #{operatingRate},</if> + <if test="keyCommandImageOnline != null">key_command_image_online = #{keyCommandImageOnline},</if> + <if test="imageResourceSecurity != null">image_resource_security = #{imageResourceSecurity},</if> </trim> where id = #{id} </update> @@ -190,15 +160,8 @@ IFNULL(ROUND(AVG(key_video_available * 100), 0), 0) AS key_video_available, IFNULL(ROUND(AVG(key_annotation_accuracy * 100), 0), 0) AS key_annotation_accuracy, IFNULL(ROUND(AVG(key_timing_accuracy * 100), 0), 0) AS key_timing_accuracy, - IFNULL(ROUND(AVG(key_command_image_inspection * 100), 0), 0) AS key_command_image_inspection, - IFNULL(ROUND(AVG(key_command_image_directory_tree * 100), 0), 0) AS key_command_image_directory_tree, - IFNULL(ROUND(AVG(online_inspection_platform * 100), 0), 0) AS online_inspection_platform, - IFNULL(ROUND(AVG(video_transmission_assets_accuracy * 100), 0), 0) AS video_transmission_assets_accuracy, - IFNULL(ROUND(AVG(video_transmission_assets_weak_password_score * 100), 0), 0) AS video_transmission_assets_weak_password_score, - IFNULL(ROUND(AVG(video_transmission_dangerous_assets_score * 100), 0), 0) AS video_transmission_dangerous_assets_score, - IFNULL(ROUND(AVG(video_transmission_boundary_integrity_detection * 100), 0), 0) AS video_transmission_boundary_integrity_detection, - IFNULL(ROUND(AVG(operating_rate * 100), 0), 0) AS operating_rate, - IFNULL(ROUND(AVG(key_command_image_online * 100), 0), 0) AS key_command_image_online + IFNULL(ROUND(AVG(key_command_image_online * 100), 0), 0) AS key_command_image_online, + IFNULL(ROUND(AVG(image_resource_security * 100), 0), 0) AS image_resource_security FROM t_check_index_video <where> diff --git a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml index 6ac03ab..2bce97b 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml @@ -212,6 +212,6 @@ LEFT JOIN t_work_order_error_type woet ON woet.work_order_no = wo.work_order_no LEFT JOIN t_work_order_auditing_record woar ON woar.work_order_id = wo.id WHERE wo.deleted = 0 AND wo.status = #{status} AND woar.result = #{auditStatus} - AND wo.deduct = 0 AND woar.create_time between #{startTime} and #{endTime} + AND wo.deduct = 0 AND woar.create_time between #{startTime} and #{endTime} </select> </mapper> -- Gitblit v1.8.0