From 37f41a7c17d81a60092e9d69363905f21d9b1a49 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期二, 19 三月 2024 17:34:37 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java | 2 ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java | 62 ++ ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckResult.java | 4 ycl-server/src/main/resources/mapper/zgyw/TMonitorVideoMapper.xml | 161 ++++++ ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckTemplateVO.java | 3 ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java | 91 +++ ycl-pojo/src/main/java/com/ycl/platform/domain/form/CheckResultForm.java | 3 ycl-server/src/main/java/com/ycl/platform/service/CheckResultService.java | 8 ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckResultVO.java | 3 ycl-server/src/main/resources/application.yml | 2 ycl-server/src/main/resources/mapper/zgyw/TCheckPublishMapper.xml | 21 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java | 15 ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorVideoMapper.java | 62 ++ ycl-server/src/main/java/com/ycl/platform/service/ITMonitorVideoService.java | 62 ++ ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java | 91 +++ ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TMonitorVideo.java | 350 +++++++++++++ ycl-server/src/main/java/com/ycl/platform/controller/CheckResultController.java | 6 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TCheckPublish.java | 39 + ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java | 14 ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java | 62 ++ ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java | 3 ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml | 103 +++ ycl-server/src/main/java/com/ycl/platform/service/impl/CheckResultServiceImpl.java | 15 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckTemplate.java | 3 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java | 143 +++++ ycl-server/src/main/java/com/ycl/platform/controller/TMonitorVideoController.java | 98 +++ ycl-server/src/main/resources/mapper/zgyw/CheckResultMapper.xml | 4 ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorVideoServiceImpl.java | 94 +++ 28 files changed, 1,518 insertions(+), 6 deletions(-) diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckResult.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckResult.java index 8c265eb..a453458 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckResult.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckResult.java @@ -48,5 +48,9 @@ @TableField("check_time") private LocalDateTime checkTime; + @ApiModelProperty("鏄惁鍙戝竷") + @TableField("publish") + private Integer publish; + } diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java index 1ac07e1..7942e49 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java @@ -8,6 +8,8 @@ import lombok.Data; import lombok.experimental.Accessors; +import java.util.Date; + /** * 鑰冩牳瑙勫垯 * @@ -45,4 +47,17 @@ @ApiModelProperty("杩愮淮绫诲埆") @TableField("category") private Integer category; + + @ApiModelProperty("瀹℃牳鐘舵��") + @TableField("audit_state") + private Integer auditState; + @ApiModelProperty("瀹℃牳浜�") + @TableField("audit_user") + private String auditUser; + @ApiModelProperty("瀹℃牳鏃堕棿") + @TableField("audit_time") + private Date auditTime; + @ApiModelProperty("瀹℃牳鎰忚") + @TableField("audit_description") + private String auditDescription; } diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckTemplate.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckTemplate.java index 70472a5..8b022ec 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckTemplate.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckTemplate.java @@ -9,6 +9,7 @@ import lombok.experimental.Accessors; import java.math.BigDecimal; +import java.util.Date; /** * 鑰冩牳妯℃澘 @@ -47,4 +48,6 @@ @ApiModelProperty("鍗曚綅id") @TableField("unit_id") private Integer unitId; + + } diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TCheckPublish.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TCheckPublish.java index 8f2889e..fce5d43 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TCheckPublish.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TCheckPublish.java @@ -1,11 +1,14 @@ package com.ycl.platform.domain.entity; import annotation.Excel; +import com.fasterxml.jackson.annotation.JsonFormat; import com.ycl.system.entity.BaseEntity; +import lombok.Data; import org.apache.commons.lang.builder.ToStringBuilder; import org.apache.commons.lang.builder.ToStringStyle; import java.math.BigDecimal; +import java.util.Date; /** * 鑰冩牳鍙戝竷瀵硅薄 t_check_publish @@ -13,6 +16,7 @@ * @author ruoyi * @date 2024-03-07 */ +@Data public class TCheckPublish extends BaseEntity { private static final long serialVersionUID = 1L; @@ -53,10 +57,40 @@ private Long updateUser; /** 瀹℃牳鐘舵�� */ private Short auditState; - + @Excel(name = "瀹℃牳浜�") + private String auditUser; + @Excel(name = "瀹℃牳鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date auditTime; + @Excel(name = "瀹℃牳鎰忚") + private String auditDescription; /** 鎻忚堪 */ @Excel(name = "鎻忚堪") private String description; + + public String getAuditUser() { + return auditUser; + } + + public void setAuditUser(String auditUser) { + this.auditUser = auditUser; + } + + public Date getAuditTime() { + return auditTime; + } + + public void setAuditTime(Date auditTime) { + this.auditTime = auditTime; + } + + public String getAuditDescription() { + return auditDescription; + } + + public void setAuditDescription(String auditDescription) { + this.auditDescription = auditDescription; + } public Short getAuditState() { return auditState; @@ -186,6 +220,9 @@ ", updateUserName='" + updateUserName + '\'' + ", updateUser=" + updateUser + ", auditState=" + auditState + + ", auditUser='" + auditUser + '\'' + + ", auditTime=" + auditTime + + ", auditDescription='" + auditDescription + '\'' + ", description='" + description + '\'' + '}'; } diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TMonitorVideo.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TMonitorVideo.java new file mode 100644 index 0000000..8bd8d06 --- /dev/null +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TMonitorVideo.java @@ -0,0 +1,350 @@ +package com.ycl.platform.domain.entity; + +import annotation.Excel; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.ycl.system.entity.BaseEntity; +import org.apache.commons.lang.builder.ToStringBuilder; +import org.apache.commons.lang.builder.ToStringStyle; + +import java.util.Date; + +/** + * 璁惧璧勪骇瀵硅薄 t_monitor_video + * + * @author ruoyi + * @date 2024-03-19 + */ +public class TMonitorVideo extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** $column.columnComment */ + private Long id; + + /** 璁惧缂栫爜 */ + @Excel(name = "璁惧缂栫爜") + private String serialNumber; + + /** 璁惧鍚嶇О */ + @Excel(name = "璁惧鍚嶇О") + private String name; + + /** 鎽勫儚鏈篗ac鍦板潃 */ + @Excel(name = "鎽勫儚鏈篗ac鍦板潃") + private String macAddr; + + /** 鎽勫儚鏈篒PV4鎴朓PV6鍦板潃 */ + @Excel(name = "鎽勫儚鏈篒PV4鎴朓PV6鍦板潃") + private String ip; + + /** 璁惧缁忓害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁� */ + @Excel(name = "璁惧缁忓害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁�") + private String longitude; + + /** 璁惧缁村害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁� */ + @Excel(name = "璁惧缁村害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁�") + private String latitude; + + /** 璁惧鐘舵�� 1/2 鍙敤/涓嶅彲鐢� */ + @Excel(name = "璁惧鐘舵�� 1/2 鍙敤/涓嶅彲鐢�") + private Long onState; + + /** 琛屾斂鍖哄煙 */ + @Excel(name = "琛屾斂鍖哄煙") + private String civilCode; + + /** 瀹夎鍦板潃 */ + @Excel(name = "瀹夎鍦板潃") + private String address; + + /** 瀹夎鏃堕棿 yyyy-MM-dd HH:mm:ss */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = "瀹夎鏃堕棿 yyyy-MM-dd HH:mm:ss", width = 30, dateFormat = "yyyy-MM-dd") + private Date installedTime; + + /** 绠$悊鍗曚綅 */ + @Excel(name = "绠$悊鍗曚綅") + private String managementUnit; + + /** 绠$悊鍗曚綅鑱旂郴鏂瑰紡 */ + @Excel(name = "绠$悊鍗曚綅鑱旂郴鏂瑰紡") + private String muContactInfo; + + /** 褰曡薄淇濆瓨澶╂暟 0 - 2147483647 */ + @Excel(name = "褰曡薄淇濆瓨澶╂暟 0 - 2147483647") + private Long storageDays; + + /** 寮傚父鍘熷洜 */ + @Excel(name = "寮傚父鍘熷洜") + private String reason; + + /** 鏄惁鐢熸垚寮傚父宸ュ崟 */ + @Excel(name = "鏄惁鐢熸垚寮傚父宸ュ崟") + private Long defaultOrder; + + /** 寮傚父鎭㈠鏍囪瘑 */ + @Excel(name = "寮傚父鎭㈠鏍囪瘑 ") + private Long recovery; + + /** 寮傚父鎭㈠鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = "寮傚父鎭㈠鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd") + private Date recoveryTime; + + /** 鑰冩牳鏍囩 */ + @Excel(name = "鑰冩牳鏍囩") + private String tag; + + /** 鍖哄煙 */ + @Excel(name = "鍖哄煙") + private String region; + + /** 淇′护鏃跺欢 */ + @Excel(name = "淇′护鏃跺欢") + private Long sipDelay; + + /** 瑙嗛鏃跺欢 */ + @Excel(name = "瑙嗛鏃跺欢") + private Long videoDelay; + + /** 鍏抽敭甯ф椂寤� */ + @Excel(name = "鍏抽敭甯ф椂寤�") + private Long iframeDelay; + + public void setId(Long id) + { + this.id = id; + } + + public Long getId() + { + return id; + } + public void setSerialNumber(String serialNumber) + { + this.serialNumber = serialNumber; + } + + public String getSerialNumber() + { + return serialNumber; + } + public void setName(String name) + { + this.name = name; + } + + public String getName() + { + return name; + } + public void setMacAddr(String macAddr) + { + this.macAddr = macAddr; + } + + public String getMacAddr() + { + return macAddr; + } + public void setIp(String ip) + { + this.ip = ip; + } + + public String getIp() + { + return ip; + } + public void setLongitude(String longitude) + { + this.longitude = longitude; + } + + public String getLongitude() + { + return longitude; + } + public void setLatitude(String latitude) + { + this.latitude = latitude; + } + + public String getLatitude() + { + return latitude; + } + public void setOnState(Long onState) + { + this.onState = onState; + } + + public Long getOnState() + { + return onState; + } + public void setCivilCode(String civilCode) + { + this.civilCode = civilCode; + } + + public String getCivilCode() + { + return civilCode; + } + public void setAddress(String address) + { + this.address = address; + } + + public String getAddress() + { + return address; + } + public void setInstalledTime(Date installedTime) + { + this.installedTime = installedTime; + } + + public Date getInstalledTime() + { + return installedTime; + } + public void setManagementUnit(String managementUnit) + { + this.managementUnit = managementUnit; + } + + public String getManagementUnit() + { + return managementUnit; + } + public void setMuContactInfo(String muContactInfo) + { + this.muContactInfo = muContactInfo; + } + + public String getMuContactInfo() + { + return muContactInfo; + } + public void setStorageDays(Long storageDays) + { + this.storageDays = storageDays; + } + + public Long getStorageDays() + { + return storageDays; + } + public void setReason(String reason) + { + this.reason = reason; + } + + public String getReason() + { + return reason; + } + public void setDefaultOrder(Long defaultOrder) + { + this.defaultOrder = defaultOrder; + } + + public Long getDefaultOrder() + { + return defaultOrder; + } + public void setRecovery(Long recovery) + { + this.recovery = recovery; + } + + public Long getRecovery() + { + return recovery; + } + public void setRecoveryTime(Date recoveryTime) + { + this.recoveryTime = recoveryTime; + } + + public Date getRecoveryTime() + { + return recoveryTime; + } + + public void setRegion(String region) + { + this.region = region; + } + + public String getRegion() + { + return region; + } + public void setSipDelay(Long sipDelay) + { + this.sipDelay = sipDelay; + } + + public Long getSipDelay() + { + return sipDelay; + } + public void setVideoDelay(Long videoDelay) + { + this.videoDelay = videoDelay; + } + + public Long getVideoDelay() + { + return videoDelay; + } + public void setIframeDelay(Long iframeDelay) + { + this.iframeDelay = iframeDelay; + } + + public Long getIframeDelay() + { + return iframeDelay; + } + + public String getTag() { + return tag; + } + + public void setTag(String tag) { + this.tag = tag; + } + + @Override + public String toString() { + return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE) + .append("id", getId()) + .append("serialNumber", getSerialNumber()) + .append("name", getName()) + .append("macAddr", getMacAddr()) + .append("ip", getIp()) + .append("longitude", getLongitude()) + .append("latitude", getLatitude()) + .append("onState", getOnState()) + .append("civilCode", getCivilCode()) + .append("address", getAddress()) + .append("installedTime", getInstalledTime()) + .append("managementUnit", getManagementUnit()) + .append("muContactInfo", getMuContactInfo()) + .append("storageDays", getStorageDays()) + .append("reason", getReason()) + .append("defaultOrder", getDefaultOrder()) + .append("recovery", getRecovery()) + .append("recoveryTime", getRecoveryTime()) + .append("tag", getTag()) + .append("region", getRegion()) + .append("sipDelay", getSipDelay()) + .append("videoDelay", getVideoDelay()) + .append("iframeDelay", getIframeDelay()) + .toString(); + } +} diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java new file mode 100644 index 0000000..9ad0356 --- /dev/null +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java @@ -0,0 +1,143 @@ +package com.ycl.platform.domain.entity; + +import annotation.Excel; +import com.baomidou.mybatisplus.annotation.TableLogic; +import com.ycl.system.entity.BaseEntity; +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; + +/** + * 鍗″彛杩囪溅鏁版嵁涓�鑷存�у璞� t_vehicle_data_monitor + * + * @author gonghl + * @date 2024-03-19 + */ +public class VehicleDataMonitor extends BaseEntity { + private static final long serialVersionUID = 1L; + + /** + * $column.columnComment + */ + private Integer id; + + /** + * 鍦板尯缂栫爜 + */ + private String regionCode; + + /** + * 鍗″彛鍚嶇О + */ + @Excel(name = "鍗″彛鍚嶇О") + private String bayonetName; + + /** + * 鍗″彛缂栧彿 + */ + @Excel(name = "鍗″彛缂栧彿") + private String bayonetNumber; + + /** + * 杩囪溅鏁版嵁閲� + */ + @Excel(name = "杩囪溅鏁版嵁閲�") + private Integer vehicleDataNumber; + + /** + * 涓嶅敮涓�鏁版嵁 + */ + @Excel(name = "涓嶅敮涓�鏁版嵁 ") + private Integer notUniqueData; + + /** + * 涓嶅敮涓�鏁版嵁閲� + */ + @Excel(name = "涓嶅敮涓�鏁版嵁閲�") + private Integer notUniqueDataNumber; + + /** + * 閫昏緫鍒犻櫎 + */ + @TableLogic + private String deleted; + + public void setId(Integer id) { + this.id = id; + } + + public Integer getId() { + return id; + } + + public void setRegionCode(String regionCode) { + this.regionCode = regionCode; + } + + public String getRegionCode() { + return regionCode; + } + + public void setBayonetName(String bayonetName) { + this.bayonetName = bayonetName; + } + + public String getBayonetName() { + return bayonetName; + } + + public void setBayonetNumber(String bayonetNumber) { + this.bayonetNumber = bayonetNumber; + } + + public String getBayonetNumber() { + return bayonetNumber; + } + + public void setVehicleDataNumber(Integer vehicleDataNumber) { + this.vehicleDataNumber = vehicleDataNumber; + } + + public Integer getVehicleDataNumber() { + return vehicleDataNumber; + } + + public void setNotUniqueData(Integer notUniqueData) { + this.notUniqueData = notUniqueData; + } + + public Integer getNotUniqueData() { + return notUniqueData; + } + + public void setNotUniqueDataNumber(Integer notUniqueDataNumber) { + this.notUniqueDataNumber = notUniqueDataNumber; + } + + public Integer getNotUniqueDataNumber() { + return notUniqueDataNumber; + } + + public void setDeleted(String deleted) { + this.deleted = deleted; + } + + public String getDeleted() { + return deleted; + } + + @Override + public String toString() { + return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE) + .append("id", getId()) + .append("regionCode", getRegionCode()) + .append("bayonetName", getBayonetName()) + .append("bayonetNumber", getBayonetNumber()) + .append("vehicleDataNumber", getVehicleDataNumber()) + .append("notUniqueData", getNotUniqueData()) + .append("notUniqueDataNumber", getNotUniqueDataNumber()) + .append("createTime", getCreateTime()) + .append("updateTime", getUpdateTime()) + .append("deleted", getDeleted()) + .toString(); + } +} diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/form/CheckResultForm.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/CheckResultForm.java index a95fae8..adc6ffb 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/form/CheckResultForm.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/CheckResultForm.java @@ -51,6 +51,9 @@ @ApiModelProperty("鑰冩牳鏃堕棿") private LocalDateTime checkTime; + @ApiModelProperty("鏄惁鍙戝竷") + private Integer publish; + public static CheckResult getEntityByForm(@NonNull CheckResultForm form, CheckResult entity) { if(entity == null) { entity = new CheckResult(); diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java index a266cd1..be16f97 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java @@ -40,5 +40,7 @@ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date end; + /** 瀹℃牳鐘舵�� */ + private Integer auditState; } diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckResultVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckResultVO.java index 8193294..448e871 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckResultVO.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckResultVO.java @@ -50,6 +50,9 @@ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime checkTime; + /** 鏄惁鍙戝竷 */ + private Integer publish; + public static CheckResultVO getVoByEntity(@NonNull CheckResult entity, CheckResultVO vo) { if(vo == null) { vo = new CheckResultVO(); diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java index 8c95449..1fc81a3 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java @@ -1,7 +1,11 @@ package com.ycl.platform.domain.vo; +import com.baomidou.mybatisplus.annotation.TableField; +import com.fasterxml.jackson.annotation.JsonFormat; import com.ycl.platform.base.AbsVo; import com.ycl.platform.domain.entity.CheckRule; + +import java.util.Date; import java.util.List; import java.time.LocalDateTime; import org.springframework.lang.NonNull; @@ -37,7 +41,15 @@ private Integer faceChceckpointNum; private Integer category; - + /** 瀹℃牳鐘舵�� */ + private Integer auditState; + /** 瀹℃牳浜� */ + private String auditUser; + /** 瀹℃牳鏃堕棿 */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date auditTime; + /** 瀹℃牳鎰忚 */ + private String auditDescription; public static CheckRuleVO getVoByEntity(@NonNull CheckRule entity, CheckRuleVO vo) { if(vo == null) { vo = new CheckRuleVO(); diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckTemplateVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckTemplateVO.java index a6b65d2..258a480 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckTemplateVO.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckTemplateVO.java @@ -1,9 +1,11 @@ package com.ycl.platform.domain.vo; +import com.fasterxml.jackson.annotation.JsonFormat; import com.ycl.platform.base.AbsVo; import com.ycl.platform.domain.entity.CheckTemplate; import java.math.BigDecimal; +import java.util.Date; import java.util.List; import java.time.LocalDateTime; @@ -41,6 +43,7 @@ private List<RuleItemVO> ruleFormList; /** 鍗曚綅鍚� */ private String unitName; + public static CheckTemplateVO getVoByEntity(@NonNull CheckTemplate entity, CheckTemplateVO vo) { if(vo == null) { vo = new CheckTemplateVO(); diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/CheckResultController.java b/ycl-server/src/main/java/com/ycl/platform/controller/CheckResultController.java index 3c8fa6d..0ca4a47 100644 --- a/ycl-server/src/main/java/com/ycl/platform/controller/CheckResultController.java +++ b/ycl-server/src/main/java/com/ycl/platform/controller/CheckResultController.java @@ -50,6 +50,12 @@ return checkResultService.removeById(id); } + @PutMapping("/publish/{id}") + @ApiOperation(value = "ID鍙戝竷", notes = "ID鍙戝竷") + public Result publishById(@PathVariable("id") String id) { + return checkResultService.publishById(id); + } + @DeleteMapping("/batch") @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎") public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) { diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorVideoController.java b/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorVideoController.java new file mode 100644 index 0000000..3502fe1 --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorVideoController.java @@ -0,0 +1,98 @@ +package com.ycl.platform.controller; + +import annotation.Log; +import com.ycl.platform.domain.entity.TMonitorVideo; +import com.ycl.platform.service.ITMonitorVideoService; +import com.ycl.system.AjaxResult; +import com.ycl.system.controller.BaseController; +import com.ycl.system.page.TableDataInfo; +import com.ycl.utils.poi.ExcelUtil; +import enumeration.BusinessType; +import jakarta.servlet.http.HttpServletResponse; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + +/** + * 璁惧璧勪骇Controller + * + * @author ruoyi + * @date 2024-03-19 + */ +@RestController +@RequestMapping("/system/video") +public class TMonitorVideoController extends BaseController +{ + @Autowired + private ITMonitorVideoService tMonitorVideoService; + + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + */ + @PreAuthorize("@ss.hasPermi('system:video:list')") + @GetMapping("/list") + public TableDataInfo list(TMonitorVideo tMonitorVideo) + { + startPage(); + List<TMonitorVideo> list = tMonitorVideoService.selectTMonitorVideoList(tMonitorVideo); + return getDataTable(list); + } + + /** + * 瀵煎嚭璁惧璧勪骇鍒楄〃 + */ + @PreAuthorize("@ss.hasPermi('system:video:export')") + @Log(title = "璁惧璧勪骇", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, TMonitorVideo tMonitorVideo) + { + List<TMonitorVideo> list = tMonitorVideoService.selectTMonitorVideoList(tMonitorVideo); + ExcelUtil<TMonitorVideo> util = new ExcelUtil<TMonitorVideo>(TMonitorVideo.class); + util.exportExcel(response, list, "璁惧璧勪骇鏁版嵁"); + } + + /** + * 鑾峰彇璁惧璧勪骇璇︾粏淇℃伅 + */ + @PreAuthorize("@ss.hasPermi('system:video:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return success(tMonitorVideoService.selectTMonitorVideoById(id)); + } + + /** + * 鏂板璁惧璧勪骇 + */ + @PreAuthorize("@ss.hasPermi('system:video:add')") + @Log(title = "璁惧璧勪骇", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody TMonitorVideo tMonitorVideo) + { + return toAjax(tMonitorVideoService.insertTMonitorVideo(tMonitorVideo)); + } + + /** + * 淇敼璁惧璧勪骇 + */ + @PreAuthorize("@ss.hasPermi('system:video:edit')") + @Log(title = "璁惧璧勪骇", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody TMonitorVideo tMonitorVideo) + { + return toAjax(tMonitorVideoService.updateTMonitorVideo(tMonitorVideo)); + } + + /** + * 鍒犻櫎璁惧璧勪骇 + */ + @PreAuthorize("@ss.hasPermi('system:video:remove')") + @Log(title = "璁惧璧勪骇", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(tMonitorVideoService.deleteTMonitorVideoByIds(ids)); + } +} diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java b/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java new file mode 100644 index 0000000..744c8ae --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java @@ -0,0 +1,91 @@ +package com.ycl.platform.controller; + +import annotation.Log; +import com.ycl.platform.domain.entity.VehicleDataMonitor; +import com.ycl.platform.service.IVehicleDataMonitorService; +import com.ycl.system.AjaxResult; +import com.ycl.system.controller.BaseController; +import com.ycl.system.page.TableDataInfo; +import com.ycl.utils.poi.ExcelUtil; +import enumeration.BusinessType; +import jakarta.servlet.http.HttpServletResponse; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + +/** + * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ontroller + * + * @author gonghl + * @date 2024-03-19 + */ +@RestController +@RequestMapping("/platform/platform") +public class VehicleDataMonitorController extends BaseController { + @Autowired + private IVehicleDataMonitorService vehicleDataMonitorService; + + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:list')") + @GetMapping("/list") + public TableDataInfo list(VehicleDataMonitor vehicleDataMonitor) { + startPage(); + List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor); + return getDataTable(list); + } + + /** + * 瀵煎嚭鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:export')") + @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, VehicleDataMonitor vehicleDataMonitor) { + List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor); + ExcelUtil<VehicleDataMonitor> util = new ExcelUtil<VehicleDataMonitor>(VehicleDataMonitor.class); + util.exportExcel(response, list, "鍗″彛杩囪溅鏁版嵁涓�鑷存�ф暟鎹�"); + } + + /** + * 鑾峰彇鍗″彛杩囪溅鏁版嵁涓�鑷存�ц缁嗕俊鎭� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Integer id) { + return success(vehicleDataMonitorService.selectVehicleDataMonitorById(id)); + } + + /** + * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:add')") + @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody VehicleDataMonitor vehicleDataMonitor) { + return toAjax(vehicleDataMonitorService.insertVehicleDataMonitor(vehicleDataMonitor)); + } + + /** + * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:edit')") + @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody VehicleDataMonitor vehicleDataMonitor) { + return toAjax(vehicleDataMonitorService.updateVehicleDataMonitor(vehicleDataMonitor)); + } + + /** + * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + @PreAuthorize("@ss.hasPermi('platform:platform:remove')") + @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Integer[] ids) { + return toAjax(vehicleDataMonitorService.deleteVehicleDataMonitorByIds(ids)); + } +} diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorVideoMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorVideoMapper.java new file mode 100644 index 0000000..1e62c80 --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorVideoMapper.java @@ -0,0 +1,62 @@ +package com.ycl.platform.mapper; + +import com.ycl.platform.domain.entity.TMonitorVideo; + +import java.util.List; + +/** + * 璁惧璧勪骇Mapper鎺ュ彛 + * + * @author ruoyi + * @date 2024-03-19 + */ +public interface TMonitorVideoMapper +{ + /** + * 鏌ヨ璁惧璧勪骇 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 璁惧璧勪骇 + */ + public TMonitorVideo selectTMonitorVideoById(Long id); + + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 璁惧璧勪骇闆嗗悎 + */ + public List<TMonitorVideo> selectTMonitorVideoList(TMonitorVideo tMonitorVideo); + + /** + * 鏂板璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + public int insertTMonitorVideo(TMonitorVideo tMonitorVideo); + + /** + * 淇敼璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + public int updateTMonitorVideo(TMonitorVideo tMonitorVideo); + + /** + * 鍒犻櫎璁惧璧勪骇 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 缁撴灉 + */ + public int deleteTMonitorVideoById(Long id); + + /** + * 鎵归噺鍒犻櫎璁惧璧勪骇 + * + * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteTMonitorVideoByIds(Long[] ids); +} diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java new file mode 100644 index 0000000..36d9be1 --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java @@ -0,0 +1,62 @@ +package com.ycl.platform.mapper; + + +import com.ycl.platform.domain.entity.VehicleDataMonitor; + +import java.util.List; + +/** + * 鍗″彛杩囪溅鏁版嵁涓�鑷存�apper鎺ュ彛 + * + * @author gonghl + * @date 2024-03-19 + */ +public interface VehicleDataMonitorMapper { + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + public VehicleDataMonitor selectVehicleDataMonitorById(Integer id); + + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�ч泦鍚� + */ + public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor); + + /** + * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor); + + /** + * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor); + + /** + * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 缁撴灉 + */ + public int deleteVehicleDataMonitorById(Integer id); + + /** + * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteVehicleDataMonitorByIds(Integer[] ids); +} diff --git a/ycl-server/src/main/java/com/ycl/platform/service/CheckResultService.java b/ycl-server/src/main/java/com/ycl/platform/service/CheckResultService.java index b605bd8..d89025d 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/CheckResultService.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/CheckResultService.java @@ -70,4 +70,12 @@ * @return */ Result manualScore(ManualScoreForm form); + + /** + * id鍙戝竷 + * @param id + * @return + */ + Result publishById(String id); + } diff --git a/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorVideoService.java b/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorVideoService.java new file mode 100644 index 0000000..a2cae36 --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorVideoService.java @@ -0,0 +1,62 @@ +package com.ycl.platform.service; + +import com.ycl.platform.domain.entity.TMonitorVideo; + +import java.util.List; + +/** + * 璁惧璧勪骇Service鎺ュ彛 + * + * @author ruoyi + * @date 2024-03-19 + */ +public interface ITMonitorVideoService +{ + /** + * 鏌ヨ璁惧璧勪骇 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 璁惧璧勪骇 + */ + public TMonitorVideo selectTMonitorVideoById(Long id); + + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 璁惧璧勪骇闆嗗悎 + */ + public List<TMonitorVideo> selectTMonitorVideoList(TMonitorVideo tMonitorVideo); + + /** + * 鏂板璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + public int insertTMonitorVideo(TMonitorVideo tMonitorVideo); + + /** + * 淇敼璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + public int updateTMonitorVideo(TMonitorVideo tMonitorVideo); + + /** + * 鎵归噺鍒犻櫎璁惧璧勪骇 + * + * @param ids 闇�瑕佸垹闄ょ殑璁惧璧勪骇涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteTMonitorVideoByIds(Long[] ids); + + /** + * 鍒犻櫎璁惧璧勪骇淇℃伅 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 缁撴灉 + */ + public int deleteTMonitorVideoById(Long id); +} diff --git a/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java b/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java new file mode 100644 index 0000000..a43a9ce --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java @@ -0,0 +1,62 @@ +package com.ycl.platform.service; + + +import com.ycl.platform.domain.entity.VehicleDataMonitor; + +import java.util.List; + +/** + * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ervice鎺ュ彛 + * + * @author gonghl + * @date 2024-03-19 + */ +public interface IVehicleDataMonitorService { + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + public VehicleDataMonitor selectVehicleDataMonitorById(Integer id); + + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�ч泦鍚� + */ + public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor); + + /** + * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor); + + /** + * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor); + + /** + * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param ids 闇�瑕佸垹闄ょ殑鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿泦鍚� + * @return 缁撴灉 + */ + public int deleteVehicleDataMonitorByIds(Integer[] ids); + + /** + * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�т俊鎭� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 缁撴灉 + */ + public int deleteVehicleDataMonitorById(Integer id); +} diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckResultServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckResultServiceImpl.java index 7bd7801..870ff90 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckResultServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckResultServiceImpl.java @@ -1,5 +1,6 @@ package com.ycl.platform.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.ycl.exception.ServiceException; import com.ycl.platform.domain.entity.CheckResult; import com.ycl.platform.domain.form.ManualScoreForm; @@ -151,4 +152,18 @@ baseMapper.updateById(checkResult); return Result.ok(); } + + @Override + public Result publishById(String id) { + CheckResult checkResult = baseMapper.selectById(id); + if(Objects.equals(1, checkResult.getPublish())) { + checkResult.setPublish(0); + } else { + checkResult.setPublish(1); + } + if(baseMapper.updateById(checkResult) > 0) { + return Result.ok("鍙戝竷鎴愬姛"); + } + return Result.error("鍙戝竷澶辫触"); + } } diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java index c357e57..8374785 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java @@ -107,12 +107,13 @@ @Override public Result page(CheckRuleQuery query) { - IPage<CheckRule> page = new LambdaQueryChainWrapper<>(baseMapper) + IPage<CheckRule> page = new LambdaQueryChainWrapper<>(baseMapper) .like(StringUtils.hasText(query.getRuleName()), CheckRule::getRuleName, query.getRuleName()) .between(Objects.nonNull(query.getStart()) && Objects.nonNull(query.getEnd()), CheckRule::getCreateTime, DateUtils.getDayStart(query.getStart()), DateUtils.getDayEnd(query.getEnd())) + .eq(Objects.nonNull(query.getAuditState()),CheckRule::getAuditState, query.getAuditState()) .orderByDesc(CheckRule::getCreateTime) .page(PageUtil.getPage(query, CheckRule.class)); diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorVideoServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorVideoServiceImpl.java new file mode 100644 index 0000000..8f47bbb --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorVideoServiceImpl.java @@ -0,0 +1,94 @@ +package com.ycl.platform.service.impl; + +import com.ycl.platform.domain.entity.TMonitorVideo; +import com.ycl.platform.mapper.TMonitorVideoMapper; +import com.ycl.platform.service.ITMonitorVideoService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import java.util.List; + +/** + * 璁惧璧勪骇Service涓氬姟灞傚鐞� + * + * @author ruoyi + * @date 2024-03-19 + */ +@Service +public class TMonitorVideoServiceImpl implements ITMonitorVideoService +{ + @Autowired + private TMonitorVideoMapper tMonitorVideoMapper; + + /** + * 鏌ヨ璁惧璧勪骇 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 璁惧璧勪骇 + */ + @Override + public TMonitorVideo selectTMonitorVideoById(Long id) + { + return tMonitorVideoMapper.selectTMonitorVideoById(id); + } + + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 璁惧璧勪骇 + */ + @Override + public List<TMonitorVideo> selectTMonitorVideoList(TMonitorVideo tMonitorVideo) + { + return tMonitorVideoMapper.selectTMonitorVideoList(tMonitorVideo); + } + + /** + * 鏂板璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + @Override + public int insertTMonitorVideo(TMonitorVideo tMonitorVideo) + { + return tMonitorVideoMapper.insertTMonitorVideo(tMonitorVideo); + } + + /** + * 淇敼璁惧璧勪骇 + * + * @param tMonitorVideo 璁惧璧勪骇 + * @return 缁撴灉 + */ + @Override + public int updateTMonitorVideo(TMonitorVideo tMonitorVideo) + { + return tMonitorVideoMapper.updateTMonitorVideo(tMonitorVideo); + } + + /** + * 鎵归噺鍒犻櫎璁惧璧勪骇 + * + * @param ids 闇�瑕佸垹闄ょ殑璁惧璧勪骇涓婚敭 + * @return 缁撴灉 + */ + @Override + public int deleteTMonitorVideoByIds(Long[] ids) + { + return tMonitorVideoMapper.deleteTMonitorVideoByIds(ids); + } + + /** + * 鍒犻櫎璁惧璧勪骇淇℃伅 + * + * @param id 璁惧璧勪骇涓婚敭 + * @return 缁撴灉 + */ + @Override + public int deleteTMonitorVideoById(Long id) + { + return tMonitorVideoMapper.deleteTMonitorVideoById(id); + } +} diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java new file mode 100644 index 0000000..170339a --- /dev/null +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java @@ -0,0 +1,91 @@ +package com.ycl.platform.service.impl; + +import com.ycl.platform.domain.entity.VehicleDataMonitor; +import com.ycl.platform.mapper.VehicleDataMonitorMapper; +import com.ycl.platform.service.IVehicleDataMonitorService; +import com.ycl.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import java.util.List; + +/** + * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ervice涓氬姟灞傚鐞� + * + * @author gonghl + * @date 2024-03-19 + */ +@Service +public class VehicleDataMonitorServiceImpl implements IVehicleDataMonitorService { + @Autowired + private VehicleDataMonitorMapper vehicleDataMonitorMapper; + + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + @Override + public VehicleDataMonitor selectVehicleDataMonitorById(Integer id) { + return vehicleDataMonitorMapper.selectVehicleDataMonitorById(id); + } + + /** + * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + */ + @Override + public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor) { + return vehicleDataMonitorMapper.selectVehicleDataMonitorList(vehicleDataMonitor); + } + + /** + * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + @Override + public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) { + vehicleDataMonitor.setCreateTime(DateUtils.getNowDate()); + vehicleDataMonitor.setDeleted("0"); + return vehicleDataMonitorMapper.insertVehicleDataMonitor(vehicleDataMonitor); + } + + /** + * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * @return 缁撴灉 + */ + @Override + public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) { + vehicleDataMonitor.setUpdateTime(DateUtils.getNowDate()); + return vehicleDataMonitorMapper.updateVehicleDataMonitor(vehicleDataMonitor); + } + + /** + * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�� + * + * @param ids 闇�瑕佸垹闄ょ殑鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 缁撴灉 + */ + @Override + public int deleteVehicleDataMonitorByIds(Integer[] ids) { + return vehicleDataMonitorMapper.deleteVehicleDataMonitorByIds(ids); + } + + /** + * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�т俊鎭� + * + * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿� + * @return 缁撴灉 + */ + @Override + public int deleteVehicleDataMonitorById(Integer id) { + return vehicleDataMonitorMapper.deleteVehicleDataMonitorById(id); + } +} diff --git a/ycl-server/src/main/resources/application.yml b/ycl-server/src/main/resources/application.yml index d08e1c8..9ed432a 100644 --- a/ycl-server/src/main/resources/application.yml +++ b/ycl-server/src/main/resources/application.yml @@ -95,7 +95,7 @@ user: password: # 瀵嗙爜鏈�澶ч敊璇鏁� - maxRetryCount: 5 + maxRetryCount: 20 # 瀵嗙爜閿佸畾鏃堕棿锛堥粯璁�10鍒嗛挓锛� lockTime: 10 diff --git a/ycl-server/src/main/resources/mapper/zgyw/CheckResultMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/CheckResultMapper.xml index 1d4ff80..11aedde 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/CheckResultMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/CheckResultMapper.xml @@ -15,6 +15,7 @@ <result column="check_time" property="checkTime" /> <result column="frequency" property="frequency" /> <result column="examine_range" property="examineRange" /> + <result column="publish" property="publish" /> </resultMap> <select id="page" resultMap="BaseResultMap"> @@ -27,7 +28,8 @@ tcr.check_time, tcr.check_score, tcr.system_score, - tcr.manual_score + tcr.manual_score, + tcr.publish FROM t_check_result tcr INNER JOIN t_check_publish tcp ON tcr.check_publish_id = tcp.id diff --git a/ycl-server/src/main/resources/mapper/zgyw/TCheckPublishMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/TCheckPublishMapper.xml index 77d56b4..f5dadc8 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/TCheckPublishMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/TCheckPublishMapper.xml @@ -19,10 +19,16 @@ <result property="updateUserName" column="update_user_name" /> <result property="description" column="description" /> <result property="alarmScore" column="alarm_score" /> + <result property="auditState" column="audit_state" /> + <result property="auditUser" column="audit_user" /> + <result property="auditDescription" column="audit_description" /> + <result property="auditTime" column="audit_time" /> </resultMap> <sql id="selectTCheckPublishVo"> - select id , examine_name, template_id , examine_range , frequency , state , create_time , create_user , update_time , update_user , description,create_user_name,update_user_name,alarm_score from t_check_publish + select id , examine_name, template_id , examine_range , frequency , state , create_time , create_user , update_time , + update_user , description,create_user_name,update_user_name,alarm_score ,audit_state,audit_user,audit_description,audit_time + from t_check_publish </sql> <select id="selectTCheckPublishList" parameterType="com.ycl.platform.domain.entity.TCheckPublish" resultMap="TCheckPublishResult"> @@ -37,6 +43,7 @@ <if test="updateUser != null "> and update_user = #{updateUser}</if> <if test="description != null and description != ''"> and description = #{description}</if> <if test="alarmScore != null"> and alarm_score = #{alarmScore}</if> + <if test="auditState != null"> and audit_state = #{auditState}</if> </where> </select> @@ -62,6 +69,10 @@ <if test="updateUserName != null and updateUserName!= ''">update_user_name,</if> <if test="description != null">description,</if> <if test="alarmScore != null">alarm_score,</if> + <if test="auditState != null">alarm_state,</if> + <if test="auditUser != null and auditUser!=''">alarm_user,</if> + <if test="auditDescription != null auditDescription!=''">alarm_description,</if> + <if test="auditTime != null">alarm_time,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null">#{id},</if> @@ -78,6 +89,10 @@ <if test="updateUserName != null and updateUserName!= ''">#{updateUserName},</if> <if test="description != null">#{description},</if> <if test="alarmScore != null">#{alarmScore},</if> + <if test="auditState != null">#{alarmState),</if> + <if test="auditUser != null and auditUser!=''">#{auditUser},</if> + <if test="auditDescription != null auditDescription!=''">#{auditDescription},</if> + <if test="auditTime != null">#{auditTime},</if> </trim> </insert> @@ -97,6 +112,10 @@ <if test="updateUserName != null and updateUserName!= ''">update_user_name = #{updateUserName},</if> <if test="description != null">description = #{description},</if> <if test="alarmScore != null">alarm_score = #{alarmScore},</if> + <if test="auditState != null">audit_state = #{alarmState),</if> + <if test="auditUser != null and auditUser!=''">audit_user = #{auditUser},</if> + <if test="auditDescription != null auditDescription!=''">audit_description = #{auditDescription},</if> + <if test="auditTime != null">audit_time = #{auditTime},</if> </trim> where id = #{id} </update> diff --git a/ycl-server/src/main/resources/mapper/zgyw/TMonitorVideoMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/TMonitorVideoMapper.xml new file mode 100644 index 0000000..3747489 --- /dev/null +++ b/ycl-server/src/main/resources/mapper/zgyw/TMonitorVideoMapper.xml @@ -0,0 +1,161 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.ycl.platform.mapper.TMonitorVideoMapper"> + + <resultMap type="com.ycl.platform.domain.entity.TMonitorVideo" id="TMonitorVideoResult"> + <result property="id" column="id" /> + <result property="serialNumber" column="serial_number" /> + <result property="name" column="name" /> + <result property="macAddr" column="mac_addr" /> + <result property="ip" column="ip" /> + <result property="longitude" column="longitude" /> + <result property="latitude" column="latitude" /> + <result property="onState" column="on_state" /> + <result property="civilCode" column="civil_code" /> + <result property="address" column="address" /> + <result property="installedTime" column="installed_time" /> + <result property="managementUnit" column="management_unit" /> + <result property="muContactInfo" column="mu_contact_info" /> + <result property="storageDays" column="storage_days" /> + <result property="reason" column="reason" /> + <result property="defaultOrder" column="default_order" /> + <result property="recovery" column="recovery" /> + <result property="recoveryTime" column="recovery_time" /> + <result property="tag" column="tag" /> + <result property="region" column="region" /> + <result property="sipDelay" column="sipDelay" /> + <result property="videoDelay" column="videoDelay" /> + <result property="iframeDelay" column="iframeDelay" /> + </resultMap> + + <sql id="selectTMonitorVideoVo"> + select id, serial_number, name, mac_addr, ip, longitude, latitude, on_state, civil_code, address, installed_time, management_unit, mu_contact_info, storage_days, reason, default_order, recovery, recovery_time, tag, region, sipDelay, videoDelay, iframeDelay from t_monitor_video + </sql> + + <select id="selectTMonitorVideoList" resultMap="TMonitorVideoResult"> + <include refid="selectTMonitorVideoVo"/> + <where> + <if test="serialNumber != null and serialNumber != ''"> and serial_number = #{serialNumber}</if> + <if test="name != null and name != ''"> and name like concat('%', #{name}, '%')</if> + <if test="macAddr != null and macAddr != ''"> and mac_addr = #{macAddr}</if> + <if test="ip != null and ip != ''"> and ip = #{ip}</if> + <if test="longitude != null and longitude != ''"> and longitude = #{longitude}</if> + <if test="latitude != null and latitude != ''"> and latitude = #{latitude}</if> + <if test="onState != null "> and on_state = #{onState}</if> + <if test="civilCode != null and civilCode != ''"> and civil_code = #{civilCode}</if> + <if test="address != null and address != ''"> and address = #{address}</if> + <if test="installedTime != null "> and installed_time = #{installedTime}</if> + <if test="managementUnit != null and managementUnit != ''"> and management_unit = #{managementUnit}</if> + <if test="muContactInfo != null and muContactInfo != ''"> and mu_contact_info = #{muContactInfo}</if> + <if test="storageDays != null "> and storage_days = #{storageDays}</if> + <if test="reason != null and reason != ''"> and reason = #{reason}</if> + <if test="defaultOrder != null "> and default_order = #{defaultOrder}</if> + <if test="recovery != null "> and recovery = #{recovery}</if> + <if test="recoveryTime != null "> and recovery_time = #{recoveryTime}</if> + <if test="tag != null and tag !=''"> and tag = #{tag}</if> + <if test="region != null and region != ''"> and region = #{region}</if> + <if test="sipDelay != null "> and sipDelay = #{sipDelay}</if> + <if test="videoDelay != null "> and videoDelay = #{videoDelay}</if> + <if test="iframeDelay != null "> and iframeDelay = #{iframeDelay}</if> + </where> + </select> + + <select id="selectTMonitorVideoById" parameterType="Long" resultMap="TMonitorVideoResult"> + <include refid="selectTMonitorVideoVo"/> + where id = #{id} + </select> + + <insert id="insertTMonitorVideo" useGeneratedKeys="true" keyProperty="id"> + insert into t_monitor_video + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="serialNumber != null">serial_number,</if> + <if test="name != null">name,</if> + <if test="macAddr != null">mac_addr,</if> + <if test="ip != null">ip,</if> + <if test="longitude != null">longitude,</if> + <if test="latitude != null">latitude,</if> + <if test="onState != null">on_state,</if> + <if test="civilCode != null">civil_code,</if> + <if test="address != null">address,</if> + <if test="installedTime != null">installed_time,</if> + <if test="managementUnit != null">management_unit,</if> + <if test="muContactInfo != null">mu_contact_info,</if> + <if test="storageDays != null">storage_days,</if> + <if test="reason != null">reason,</if> + <if test="defaultOrder != null">default_order,</if> + <if test="recovery != null">recovery,</if> + <if test="recoveryTime != null">recovery_time,</if> + <if test="tag != null and tag !=''">tag,</if> + <if test="region != null">region,</if> + <if test="sipDelay != null">sipDelay,</if> + <if test="videoDelay != null">videoDelay,</if> + <if test="iframeDelay != null">iframeDelay,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="serialNumber != null">#{serialNumber},</if> + <if test="name != null">#{name},</if> + <if test="macAddr != null">#{macAddr},</if> + <if test="ip != null">#{ip},</if> + <if test="longitude != null">#{longitude},</if> + <if test="latitude != null">#{latitude},</if> + <if test="onState != null">#{onState},</if> + <if test="civilCode != null">#{civilCode},</if> + <if test="address != null">#{address},</if> + <if test="installedTime != null">#{installedTime},</if> + <if test="managementUnit != null">#{managementUnit},</if> + <if test="muContactInfo != null">#{muContactInfo},</if> + <if test="storageDays != null">#{storageDays},</if> + <if test="reason != null">#{reason},</if> + <if test="defaultOrder != null">#{defaultOrder},</if> + <if test="recovery != null">#{recovery},</if> + <if test="recoveryTime != null">#{recoveryTime},</if> + <if test="tag != null and tag !=''">#{tag},</if> + <if test="region != null">#{region},</if> + <if test="sipDelay != null">#{sipDelay},</if> + <if test="videoDelay != null">#{videoDelay},</if> + <if test="iframeDelay != null">#{iframeDelay},</if> + </trim> + </insert> + + <update id="updateTMonitorVideo" > + update t_monitor_video + <trim prefix="SET" suffixOverrides=","> + <if test="serialNumber != null">serial_number = #{serialNumber},</if> + <if test="name != null">name = #{name},</if> + <if test="macAddr != null">mac_addr = #{macAddr},</if> + <if test="ip != null">ip = #{ip},</if> + <if test="longitude != null">longitude = #{longitude},</if> + <if test="latitude != null">latitude = #{latitude},</if> + <if test="onState != null">on_state = #{onState},</if> + <if test="civilCode != null">civil_code = #{civilCode},</if> + <if test="address != null">address = #{address},</if> + <if test="installedTime != null">installed_time = #{installedTime},</if> + <if test="managementUnit != null">management_unit = #{managementUnit},</if> + <if test="muContactInfo != null">mu_contact_info = #{muContactInfo},</if> + <if test="storageDays != null">storage_days = #{storageDays},</if> + <if test="reason != null">reason = #{reason},</if> + <if test="defaultOrder != null">default_order = #{defaultOrder},</if> + <if test="recovery != null">recovery = #{recovery},</if> + <if test="recoveryTime != null">recovery_time = #{recoveryTime},</if> + <if test="tag != null and tag !=''">tag = #{tag},</if> + <if test="region != null">region = #{region},</if> + <if test="sipDelay != null">sipDelay = #{sipDelay},</if> + <if test="videoDelay != null">videoDelay = #{videoDelay},</if> + <if test="iframeDelay != null">iframeDelay = #{iframeDelay},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteTMonitorVideoById" parameterType="Long"> + delete from t_monitor_video where id = #{id} + </delete> + + <delete id="deleteTMonitorVideoByIds" parameterType="String"> + delete from t_monitor_video where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml new file mode 100644 index 0000000..e34e0fb --- /dev/null +++ b/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml @@ -0,0 +1,103 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper + PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.ycl.platform.mapper.VehicleDataMonitorMapper"> + + <resultMap type="com.ycl.platform.domain.entity.VehicleDataMonitor" id="VehicleDataMonitorResult"> + <result property="id" column="id"/> + <result property="regionCode" column="region_code"/> + <result property="bayonetName" column="bayonet_name"/> + <result property="bayonetNumber" column="bayonet_number"/> + <result property="vehicleDataNumber" column="vehicle_data_number"/> + <result property="notUniqueData" column="not_unique_data"/> + <result property="notUniqueDataNumber" column="not_unique_data_number"/> + <result property="createTime" column="create_time"/> + <result property="updateTime" column="update_time"/> + <result property="deleted" column="deleted"/> + </resultMap> + + <sql id="selectVehicleDataMonitorVo"> + select id, + region_code, + bayonet_name, + bayonet_number, + vehicle_data_number, + not_unique_data, + not_unique_data_number, + create_time, + update_time, + deleted + from t_vehicle_data_monitor + </sql> + + <select id="selectVehicleDataMonitorList" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" resultMap="VehicleDataMonitorResult"> + <include refid="selectVehicleDataMonitorVo"/> + <where> + deleted != 1 + <if test="regionCode != null and regionCode != ''">and region_code = #{regionCode}</if> + <if test="bayonetName != null and bayonetName != ''">and bayonet_name like concat('%', #{bayonetName}, '%')</if> + <if test="bayonetNumber != null and bayonetNumber != ''">and bayonet_number like concat('%', #{bayonetNumber}, '%')</if> + </where> + </select> + + <select id="selectVehicleDataMonitorById" parameterType="Integer" resultMap="VehicleDataMonitorResult"> + <include refid="selectVehicleDataMonitorVo"/> + where id = #{id} + </select> + + <insert id="insertVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" useGeneratedKeys="true" keyProperty="id"> + insert into t_vehicle_data_monitor + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="regionCode != null">region_code,</if> + <if test="bayonetName != null and bayonetName != ''">bayonet_name,</if> + <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number,</if> + <if test="vehicleDataNumber != null">vehicle_data_number,</if> + <if test="notUniqueData != null">not_unique_data,</if> + <if test="notUniqueDataNumber != null">not_unique_data_number,</if> + <if test="createTime != null">create_time,</if> + <if test="updateTime != null">update_time,</if> + <if test="deleted != null">deleted,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="regionCode != null">#{regionCode},</if> + <if test="bayonetName != null and bayonetName != ''">#{bayonetName},</if> + <if test="bayonetNumber != null and bayonetNumber != ''">#{bayonetNumber},</if> + <if test="vehicleDataNumber != null">#{vehicleDataNumber},</if> + <if test="notUniqueData != null">#{notUniqueData},</if> + <if test="notUniqueDataNumber != null">#{notUniqueDataNumber},</if> + <if test="createTime != null">#{createTime},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="deleted != null">#{deleted},</if> + </trim> + </insert> + + <update id="updateVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor"> + update t_vehicle_data_monitor + <trim prefix="SET" suffixOverrides=","> + <if test="regionCode != null">region_code = #{regionCode},</if> + <if test="bayonetName != null and bayonetName != ''">bayonet_name = #{bayonetName},</if> + <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number = #{bayonetNumber},</if> + <if test="vehicleDataNumber != null">vehicle_data_number = #{vehicleDataNumber},</if> + <if test="notUniqueData != null">not_unique_data = #{notUniqueData},</if> + <if test="notUniqueDataNumber != null">not_unique_data_number = #{notUniqueDataNumber},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="deleted != null">deleted = #{deleted},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteVehicleDataMonitorById" parameterType="Integer"> + delete + from t_vehicle_data_monitor + where id = #{id} + </delete> + + <delete id="deleteVehicleDataMonitorByIds" parameterType="String"> + delete from t_vehicle_data_monitor where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </delete> +</mapper> \ No newline at end of file -- Gitblit v1.8.0