From 9ccd0bc5786cbb1bca2c9fda28f0cd730126656d Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 13 三月 2024 09:21:38 +0800
Subject: [PATCH] 合并
---
ycl-server/src/main/resources/mapper/zgyw/TContractMapper.xml | 86 ++++
ycl-server/src/main/java/com/ycl/platform/service/impl/TContractServiceImpl.java | 94 +++++
ycl-server/src/main/java/com/ycl/platform/mapper/TContractMapper.java | 62 +++
ycl-server/src/main/java/com/ycl/platform/service/ITContractService.java | 62 +++
ycl-server/src/main/java/com/ycl/platform/controller/TContractController.java | 99 +++++
ycl-pojo/src/main/java/com/ycl/platform/domain/vo/TMonitorVO.java | 522 +++++++++++++++++++++++++++++
ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TContract.java | 135 +++++++
7 files changed, 1,060 insertions(+), 0 deletions(-)
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TContract.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TContract.java
new file mode 100644
index 0000000..5c7e9ad
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/TContract.java
@@ -0,0 +1,135 @@
+package com.ycl.platform.domain.entity;
+
+import annotation.Excel;
+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_contract
+ *
+ * @author ruoyi
+ * @date 2024-03-12
+ */
+public class TContract extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 涓婚敭 */
+ private Long id;
+
+ /** 鍏徃id */
+ @Excel(name = "鍏徃id")
+ private Long companyId;
+
+ /** 鍏徃鍚� */
+ @Excel(name = "鍏徃鍚�")
+ private String companyName;
+
+ /** 瀵规帴鍏畨閮ㄩ棬id */
+ @Excel(name = "瀵规帴鍏畨閮ㄩ棬id")
+ private Long deptId;
+
+ /** 閮ㄩ棬鍚嶇О */
+ @Excel(name = "閮ㄩ棬鍚嶇О")
+ private String deptName;
+
+ /** 鍚堝悓鏄庣粏json */
+ @Excel(name = "鍚堝悓鏄庣粏json")
+ private String detail;
+
+ /** 寮�濮嬫椂闂� */
+ @Excel(name = "寮�濮嬫椂闂�")
+ private Date startTime;
+
+ /** 鎴鏃堕棿 */
+ @Excel(name = "鎴鏃堕棿")
+ private Date endTime;
+
+ public Date getStartTime() {
+ return startTime;
+ }
+
+ public void setStartTime(Date startTime) {
+ this.startTime = startTime;
+ }
+
+ public Date getEndTime() {
+ return endTime;
+ }
+
+ public void setEndTime(Date endTime) {
+ this.endTime = endTime;
+ }
+
+ public void setId(Long id)
+ {
+ this.id = id;
+ }
+
+ public Long getId()
+ {
+ return id;
+ }
+ public void setCompanyId(Long companyId)
+ {
+ this.companyId = companyId;
+ }
+
+ public Long getCompanyId()
+ {
+ return companyId;
+ }
+ public void setCompanyName(String companyName)
+ {
+ this.companyName = companyName;
+ }
+
+ public String getCompanyName()
+ {
+ return companyName;
+ }
+ public void setDeptId(Long deptId)
+ {
+ this.deptId = deptId;
+ }
+
+ public Long getDeptId()
+ {
+ return deptId;
+ }
+ public void setDeptName(String deptName)
+ {
+ this.deptName = deptName;
+ }
+
+ public String getDeptName()
+ {
+ return deptName;
+ }
+ public void setDetail(String detail)
+ {
+ this.detail = detail;
+ }
+
+ public String getDetail()
+ {
+ return detail;
+ }
+
+ @Override
+ public String toString() {
+ return "TContract{" +
+ "id=" + id +
+ ", companyId=" + companyId +
+ ", companyName='" + companyName + '\'' +
+ ", deptId=" + deptId +
+ ", deptName='" + deptName + '\'' +
+ ", detail='" + detail + '\'' +
+ ", startTime=" + startTime +
+ ", endTime=" + endTime +
+ '}';
+ }
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/TMonitorVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/TMonitorVO.java
new file mode 100644
index 0000000..6d3d648
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/TMonitorVO.java
@@ -0,0 +1,522 @@
+package com.ycl.platform.domain.vo;
+
+import annotation.Excel;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ycl.system.entity.BaseEntity;
+
+import java.util.Date;
+
+
+/**
+ * 璁惧璧勪骇瀵硅薄 t_monitor
+ *
+ * @author ruoyi
+ * @date 2024-03-04
+ */
+public class TMonitorVO extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** $column.columnComment */
+ private Long id;
+
+ /** 璁惧缂栫爜 */
+ @Excel(name = "璁惧缂栫爜")
+ private String serialNumber;
+
+ /** 璁惧鍚嶇О */
+ @Excel(name = "璁惧鍚嶇О")
+ private String name;
+
+ /** 鐩戞帶鐐逛綅绫诲瀷 [1.涓�绫昏棰戠洃鎺х偣;2.浜岀被瑙嗛鐩戞帶鐐�;3.涓夌被瑙嗛鐩戞帶鐐�;4.鍏畨鍐呴儴瑙嗛鐩戞帶鐐�;9.鍏朵粬鐐逛綅;] */
+ @Excel(name = "鐩戞帶鐐逛綅绫诲瀷 [1.涓�绫昏棰戠洃鎺х偣;2.浜岀被瑙嗛鐩戞帶鐐�;3.涓夌被瑙嗛鐩戞帶鐐�;4.鍏畨鍐呴儴瑙嗛鐩戞帶鐐�;9.鍏朵粬鐐逛綅;]")
+ private Long siteType;
+
+ /** 鎽勫儚鏈篗ac鍦板潃 */
+ @Excel(name = "鎽勫儚鏈篗ac鍦板潃")
+ private String macAddr;
+
+ /** 鎽勫儚鏈篒PV4鎴朓PV6鍦板潃 */
+ @Excel(name = "鎽勫儚鏈篒PV4鎴朓PV6鍦板潃")
+ private String ip;
+
+ /** 鎽勫儚鏈哄姛鑳界被鍨媅1.瑙嗛鐩戞帶;2.杞﹁締璇嗗埆;3.浜哄憳璇嗗埆;] 鏁版嵁鏍煎紡[濉叆澶氫釜鍊煎苟浠�/闅斿紑銆備緥濡� 1/2] */
+ @Excel(name = "鎽勫儚鏈哄姛鑳界被鍨媅1.瑙嗛鐩戞帶;2.杞﹁締璇嗗埆;3.浜哄憳璇嗗埆;] 鏁版嵁鏍煎紡[濉叆澶氫釜鍊煎苟浠�/闅斿紑銆備緥濡� 1/2]")
+ private String cameraFunType;
+
+ /** 璁惧缁忓害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁� */
+ @Excel(name = "璁惧缁忓害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁�")
+ private String longitude;
+
+ /** 璁惧缁村害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁� */
+ @Excel(name = "璁惧缁村害锛岃嚦灏戜繚鐣欏叚浣嶅皬鏁�")
+ private String latitude;
+
+ /** 鎽勫儚鏈洪噰闆嗗尯鍩熷弬鑰冨瓧鍏歌〃锛屾暟鎹閫変互/闅斿紑 */
+ @Excel(name = "鎽勫儚鏈洪噰闆嗗尯鍩熷弬鑰冨瓧鍏歌〃锛屾暟鎹閫変互/闅斿紑")
+ private String cameraCaptureArea;
+
+ /** 璁惧鐘舵�� 1/2 鍙敤/涓嶅彲鐢� */
+ @Excel(name = "璁惧鐘舵�� 1/2 鍙敤/涓嶅彲鐢�")
+ private Long onState;
+
+ /** 琛屾斂鍖哄煙 */
+ @Excel(name = "琛屾斂鍖哄煙")
+ private String civilCode;
+
+ /** 鏄惁闆嗘垚璁惧锛�0/1 涓嶆槸/鏄� */
+ @Excel(name = "鏄惁闆嗘垚璁惧锛�0/1 涓嶆槸/鏄�")
+ private Long integratedDevice;
+
+ /** 鎽勫儚鏈哄搧鐗� [1.娴峰悍濞佽;2.澶у崕;3.澶╁湴浼熶笟;4.绉戣揪;5.瀹夎澹�;6.鍗氫笘;7.浜氬畨;8.鑻遍鎷�;9.瀹囪;10.娴蜂俊;11.涓槦鐢靛瓙;12.鏄庢櫙;13.鑱旀兂;14.涓叴;15.绱㈠凹;16.涓夋槦;99.鍏跺畠; */
+ @Excel(name = "鎽勫儚鏈哄搧鐗� [1.娴峰悍濞佽;2.澶у崕;3.澶╁湴浼熶笟;4.绉戣揪;5.瀹夎澹�;6.鍗氫笘;7.浜氬畨;8.鑻遍鎷�;9.瀹囪;10.娴蜂俊;11.涓槦鐢靛瓙;12.鏄庢櫙;13.鑱旀兂;14.涓叴;15.绱㈠凹;16.涓夋槦;99.鍏跺畠;")
+ private Long cameraBrand;
+
+ /** 瀹夎鍦板潃 */
+ @Excel(name = "瀹夎鍦板潃")
+ private String address;
+
+ /** 鑱旂綉灞炴�� 0/1 宸茶仈缃�/鏈仈缃� */
+ @Excel(name = "鑱旂綉灞炴�� 0/1 宸茶仈缃�/鏈仈缃�")
+ private Long netWorking;
+
+ /** 鎵�灞炶緰鍖哄叕瀹夋満鍏� */
+ @Excel(name = "鎵�灞炶緰鍖哄叕瀹夋満鍏�")
+ private String publicSecurity;
+
+ /** 瀹夎鏃堕棿 yyyy-MM-dd HH:mm:ss */
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @Excel(name = "瀹夎鏃堕棿 yyyy-MM-dd HH:mm:ss", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
+ private Date installedTime;
+
+ /** 绠＄悊鍗曚綅 */
+ @Excel(name = "绠＄悊鍗曚綅")
+ private String managementUnit;
+
+ /** 绠＄悊鍗曚綅鑱旂郴鏂瑰紡 */
+ @Excel(name = "绠＄悊鍗曚綅鑱旂郴鏂瑰紡")
+ private String muContactInfo;
+
+ /** 褰曡薄淇濆瓨澶╂暟 0 - 2147483647 */
+ @Excel(name = "褰曡薄淇濆瓨澶╂暟 0 - 2147483647")
+ private Long storageDays;
+
+ /** 鐩戣鏂逛綅 [1.涓�;2.瑗�;3.鍗�;4.鍖�;5.涓滃崡;6.涓滃寳;7.瑗垮崡;8.瑗垮寳;9.鍏ㄥ悜;] */
+ @Excel(name = "鐩戣鏂逛綅 [1.涓�;2.瑗�;3.鍗�;4.鍖�;5.涓滃崡;6.涓滃寳;7.瑗垮崡;8.瑗垮寳;9.鍏ㄥ悜;]")
+ private Long monitorAzimuth;
+
+ /** 鎽勫儚鏈哄満鏅璁剧収鐗嘦RL */
+ @Excel(name = "鎽勫儚鏈哄満鏅璁剧収鐗嘦RL")
+ private String scenePhotoAddr;
+
+ /** 璁惧鍨嬪彿 */
+ @Excel(name = "璁惧鍨嬪彿")
+ private String model;
+
+ /** 鐐逛綅淇楃О */
+ @Excel(name = "鐐逛綅淇楃О")
+ private String siteVulgo;
+
+ /** 鎽勫儚鏈虹被鍨� [1.鐞冩満;2.鍗婄悆;3.鍥哄畾鏋満;4.閬ユ帶鏋満;5.鍗″彛鏋満;99.鏈煡; */
+ @Excel(name = "鎽勫儚鏈虹被鍨� [1.鐞冩満;2.鍗婄悆;3.鍥哄畾鏋満;4.閬ユ帶鏋満;5.鍗″彛鏋満;99.鏈煡;")
+ private Long cameraType;
+
+ /** 琛ュ厜灞炴�1.鏃犺ˉ鍏�;2.绾㈠琛ュ厜;3.鐧藉厜琛ュ厜;9.鍏朵粬琛ュ厜;] */
+ @Excel(name = "琛ュ厜灞炴�1.鏃犺ˉ鍏�;2.绾㈠琛ュ厜;3.鐧藉厜琛ュ厜;9.鍏朵粬琛ュ厜;] ")
+ private Long cameraLightType;
+
+ /** 鎽勫儚鏈虹紪鐮佹牸寮� [1.MPEG-4;2.H.264;3.SVAC;4.H.265;] */
+ @Excel(name = "鎽勫儚鏈虹紪鐮佹牸寮� [1.MPEG-4;2.H.264;3.SVAC;4.H.265;]")
+ private Long encodedFormat;
+
+ /** 鎵�灞為儴闂�/琛屼笟 鍙栧�艰寖鍥�(澶氶��) : [1.鍏畨鏈哄叧;2.鐜繚閮ㄩ棬;3.鏂囧崥閮ㄩ棬;4.鍖荤枟閮ㄩ棬;5.鏃呮父绠＄悊;6.鏂伴椈骞跨數;7.椋熷搧鍖昏嵂鐩戠潱绠＄悊閮ㄩ棬;8.鏁欒偛绠＄悊閮ㄩ棬;9.妫�瀵熼櫌;10.娉曢櫌;11.閲戣瀺閮ㄩ棬;12.浜ら�氶儴闂�;13.浣忔埧鍜屽煄涔″缓璁鹃儴闂�;14.姘村埄閮ㄩ棬;15.鏋椾笟閮ㄩ棬;16.瀹夊叏鐢熶骇鐩戠潱閮ㄩ棬;17.甯傛斂甯傚濮�;18.鍥藉湡灞�;] 鏁版嵁鏍煎紡[濉叆澶氫釜鍊煎苟浠�/闅斿紑銆備緥濡� 1/2] */
+ @Excel(name = "鎵�灞為儴闂�/琛屼笟 鍙栧�艰寖鍥�(澶氶��) : [1.鍏畨鏈哄叧;2.鐜繚閮ㄩ棬;3.鏂囧崥閮ㄩ棬;4.鍖荤枟閮ㄩ棬;5.鏃呮父绠＄悊;6.鏂伴椈骞跨數;7.椋熷搧鍖昏嵂鐩戠潱绠＄悊閮ㄩ棬;8.鏁欒偛绠＄悊閮ㄩ棬;9.妫�瀵熼櫌;10.娉曢櫌;11.閲戣瀺閮ㄩ棬;12.浜ら�氶儴闂�;13.浣忔埧鍜屽煄涔″缓璁鹃儴闂�;14.姘村埄閮ㄩ棬;15.鏋椾笟閮ㄩ棬;16.瀹夊叏鐢熶骇鐩戠潱閮ㄩ棬;17.甯傛斂甯傚濮�;18.鍥藉湡灞�;] 鏁版嵁鏍煎紡[濉叆澶氫釜鍊煎苟浠�/闅斿紑銆備緥濡� 1/2]")
+ private String cameraDept;
+
+ /** 琛屼笟缂栫爜 [00.绀句細娌诲畨璺潰鎺ュ叆;01.绀句細娌诲畨绀惧尯鎺ュ叆;02.绀句細娌诲畨鍐呴儴鎺ュ叆;03.绀句細娌诲畨鍏朵粬鎺ュ叆;04.浜ら�氳矾闈㈡帴鍏�;05.浜ら�氬崱鍙ｆ帴鍏�;06.浜ら�氬唴閮ㄦ帴鍏�;07.浜ら�氬叾浠栨帴鍏�;08.鍩庡競绠＄悊鎺ュ叆;09.鍗敓鐜繚鎺ュ叆;10.鍟嗘娴峰叧鎺ュ叆;11.鏁欒偛閮ㄩ棬鎺ュ叆;] */
+ @Excel(name = "琛屼笟缂栫爜 [00.绀句細娌诲畨璺潰鎺ュ叆;01.绀句細娌诲畨绀惧尯鎺ュ叆;02.绀句細娌诲畨鍐呴儴鎺ュ叆;03.绀句細娌诲畨鍏朵粬鎺ュ叆;04.浜ら�氳矾闈㈡帴鍏�;05.浜ら�氬崱鍙ｆ帴鍏�;06.浜ら�氬唴閮ㄦ帴鍏�;07.浜ら�氬叾浠栨帴鍏�;08.鍩庡競绠＄悊鎺ュ叆;09.鍗敓鐜繚鎺ュ叆;10.鍟嗘娴峰叧鎺ュ叆;11.鏁欒偛閮ㄩ棬鎺ュ叆;]")
+ private String hybm;
+
+ /** 绫诲瀷缂栫爜 : [131.鎽勫儚鏈虹紪鐮�;132.缃戠粶鎽勫儚鏈虹紪鐮�;] */
+ @Excel(name = "绫诲瀷缂栫爜 : [131.鎽勫儚鏈虹紪鐮�;132.缃戠粶鎽勫儚鏈虹紪鐮�;]")
+ private Long lxbm;
+
+ @Excel(name = "寮傚父鍘熷洜")
+ private String reason;
+
+ @Excel(name = "鏄惁鐢熸垚寮傚父宸ュ崟")
+ private Long defaultOrder;
+
+ @Excel(name ="寮傚父鎭㈠鏍囪瘑")
+ private Long recovery;
+
+ @Excel(name = "寮傚父鎭㈠鏃堕棿")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date recoveryTime;
+
+ private String deptName;
+
+ public String getDeptName() {
+ return deptName;
+ }
+
+ public void setDeptName(String deptName) {
+ this.deptName = deptName;
+ }
+
+ public Long getDefaultOrder() {
+ return defaultOrder;
+ }
+
+ public void setDefaultOrder(Long defaultOrder) {
+ this.defaultOrder = defaultOrder;
+ }
+
+ public void setInstalledTime(Date installedTime) {
+ this.installedTime = installedTime;
+ }
+
+ public Date getInstalledTime() {
+ return installedTime;
+ }
+
+ public Date getRecoveryTime() {
+ return recoveryTime;
+ }
+
+ public void setRecoveryTime(Date recoveryTime) {
+ this.recoveryTime = recoveryTime;
+ }
+
+ public Long getRecovery() {
+ return recovery;
+ }
+
+ public void setRecovery(Long recovery) {
+ this.recovery = recovery;
+ }
+
+ public String getReason() {
+ return reason;
+ }
+
+ public void setReason(String reason) {
+ this.reason = reason;
+ }
+
+
+
+ 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 setSiteType(Long siteType)
+ {
+ this.siteType = siteType;
+ }
+
+ public Long getSiteType()
+ {
+ return siteType;
+ }
+ 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 setCameraFunType(String cameraFunType)
+ {
+ this.cameraFunType = cameraFunType;
+ }
+
+ public String getCameraFunType()
+ {
+ return cameraFunType;
+ }
+ 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 setCameraCaptureArea(String cameraCaptureArea)
+ {
+ this.cameraCaptureArea = cameraCaptureArea;
+ }
+
+ public String getCameraCaptureArea()
+ {
+ return cameraCaptureArea;
+ }
+ 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 setIntegratedDevice(Long integratedDevice)
+ {
+ this.integratedDevice = integratedDevice;
+ }
+
+ public Long getIntegratedDevice()
+ {
+ return integratedDevice;
+ }
+ public void setCameraBrand(Long cameraBrand)
+ {
+ this.cameraBrand = cameraBrand;
+ }
+
+ public Long getCameraBrand()
+ {
+ return cameraBrand;
+ }
+ public void setAddress(String address)
+ {
+ this.address = address;
+ }
+
+ public String getAddress()
+ {
+ return address;
+ }
+ public void setNetWorking(Long netWorking)
+ {
+ this.netWorking = netWorking;
+ }
+
+ public Long getNetWorking()
+ {
+ return netWorking;
+ }
+ public void setPublicSecurity(String publicSecurity)
+ {
+ this.publicSecurity = publicSecurity;
+ }
+
+ public String getPublicSecurity()
+ {
+ return publicSecurity;
+ }
+
+ 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 setMonitorAzimuth(Long monitorAzimuth)
+ {
+ this.monitorAzimuth = monitorAzimuth;
+ }
+
+ public Long getMonitorAzimuth()
+ {
+ return monitorAzimuth;
+ }
+ public void setScenePhotoAddr(String scenePhotoAddr)
+ {
+ this.scenePhotoAddr = scenePhotoAddr;
+ }
+
+ public String getScenePhotoAddr()
+ {
+ return scenePhotoAddr;
+ }
+ public void setModel(String model)
+ {
+ this.model = model;
+ }
+
+ public String getModel()
+ {
+ return model;
+ }
+ public void setSiteVulgo(String siteVulgo)
+ {
+ this.siteVulgo = siteVulgo;
+ }
+
+ public String getSiteVulgo()
+ {
+ return siteVulgo;
+ }
+ public void setCameraType(Long cameraType)
+ {
+ this.cameraType = cameraType;
+ }
+
+ public Long getCameraType()
+ {
+ return cameraType;
+ }
+ public void setCameraLightType(Long cameraLightType)
+ {
+ this.cameraLightType = cameraLightType;
+ }
+
+ public Long getCameraLightType()
+ {
+ return cameraLightType;
+ }
+ public void setEncodedFormat(Long encodedFormat)
+ {
+ this.encodedFormat = encodedFormat;
+ }
+
+ public Long getEncodedFormat()
+ {
+ return encodedFormat;
+ }
+ public void setCameraDept(String cameraDept)
+ {
+ this.cameraDept = cameraDept;
+ }
+
+ public String getCameraDept()
+ {
+ return cameraDept;
+ }
+ public void setHybm(String hybm)
+ {
+ this.hybm = hybm;
+ }
+
+ public String getHybm()
+ {
+ return hybm;
+ }
+ public void setLxbm(Long lxbm)
+ {
+ this.lxbm = lxbm;
+ }
+
+ public Long getLxbm()
+ {
+ return lxbm;
+ }
+
+ @Override
+ public String toString() {
+ return "TMonitorVO{" +
+ "id=" + id +
+ ", serialNumber='" + serialNumber + '\'' +
+ ", name='" + name + '\'' +
+ ", siteType=" + siteType +
+ ", macAddr='" + macAddr + '\'' +
+ ", ip='" + ip + '\'' +
+ ", cameraFunType='" + cameraFunType + '\'' +
+ ", longitude='" + longitude + '\'' +
+ ", latitude='" + latitude + '\'' +
+ ", cameraCaptureArea='" + cameraCaptureArea + '\'' +
+ ", onState=" + onState +
+ ", civilCode='" + civilCode + '\'' +
+ ", integratedDevice=" + integratedDevice +
+ ", cameraBrand=" + cameraBrand +
+ ", address='" + address + '\'' +
+ ", netWorking=" + netWorking +
+ ", publicSecurity='" + publicSecurity + '\'' +
+ ", installedTime=" + installedTime +
+ ", managementUnit='" + managementUnit + '\'' +
+ ", muContactInfo='" + muContactInfo + '\'' +
+ ", storageDays=" + storageDays +
+ ", monitorAzimuth=" + monitorAzimuth +
+ ", scenePhotoAddr='" + scenePhotoAddr + '\'' +
+ ", model='" + model + '\'' +
+ ", siteVulgo='" + siteVulgo + '\'' +
+ ", cameraType=" + cameraType +
+ ", cameraLightType=" + cameraLightType +
+ ", encodedFormat=" + encodedFormat +
+ ", cameraDept='" + cameraDept + '\'' +
+ ", hybm='" + hybm + '\'' +
+ ", lxbm=" + lxbm +
+ ", reason='" + reason + '\'' +
+ ", defaultOrder=" + defaultOrder +
+ ", recovery=" + recovery +
+ ", recoveryTime=" + recoveryTime +
+ ", deptName='" + deptName + '\'' +
+ '}';
+ }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/TContractController.java b/ycl-server/src/main/java/com/ycl/platform/controller/TContractController.java
new file mode 100644
index 0000000..8922753
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/TContractController.java
@@ -0,0 +1,99 @@
+package com.ycl.platform.controller;
+
+import annotation.Log;
+import com.ycl.platform.domain.entity.TContract;
+import com.ycl.platform.service.ITContractService;
+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 ruoyi
+ * @date 2024-03-12
+ */
+@RestController
+@RequestMapping("/system/contract")
+public class TContractController extends BaseController
+{
+ @Autowired
+ private ITContractService tContractService;
+
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆戝垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:list')")
+ @GetMapping("/list")
+ public TableDataInfo list(TContract tContract)
+ {
+ startPage();
+ List<TContract> list = tContractService.selectTContractList(tContract);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭銆愯濉啓鍔熻兘鍚嶇О銆戝垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:export')")
+ @Log(title = "銆愯濉啓鍔熻兘鍚嶇О銆�", businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, TContract tContract)
+ {
+ List<TContract> list = tContractService.selectTContractList(tContract);
+ ExcelUtil<TContract> util = new ExcelUtil<TContract>(TContract.class);
+ util.exportExcel(response, list, "銆愯濉啓鍔熻兘鍚嶇О銆戞暟鎹�");
+ }
+
+ /**
+ * 鑾峰彇銆愯濉啓鍔熻兘鍚嶇О銆戣缁嗕俊鎭�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:query')")
+ @GetMapping(value = "/{id}")
+ public AjaxResult getInfo(@PathVariable("id") Long id)
+ {
+ return success(tContractService.selectTContractById(id));
+ }
+
+ /**
+ * 鏂板銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:add')")
+ @Log(title = "銆愯濉啓鍔熻兘鍚嶇О銆�", businessType = BusinessType.INSERT)
+ @PostMapping
+ public AjaxResult add(@RequestBody TContract tContract)
+ {
+ return toAjax(tContractService.insertTContract(tContract));
+ }
+
+ /**
+ * 淇敼銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:edit')")
+ @Log(title = "銆愯濉啓鍔熻兘鍚嶇О銆�", businessType = BusinessType.UPDATE)
+ @PutMapping
+ public AjaxResult edit(@RequestBody TContract tContract)
+ {
+ return toAjax(tContractService.updateTContract(tContract));
+ }
+
+ /**
+ * 鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ @PreAuthorize("@ss.hasPermi('system:contract:remove')")
+ @Log(title = "銆愯濉啓鍔熻兘鍚嶇О銆�", businessType = BusinessType.DELETE)
+ @DeleteMapping("/{ids}")
+ public AjaxResult remove(@PathVariable Long[] ids)
+ {
+ return toAjax(tContractService.deleteTContractByIds(ids));
+ }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/TContractMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/TContractMapper.java
new file mode 100644
index 0000000..b98b665
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/TContractMapper.java
@@ -0,0 +1,62 @@
+package com.ycl.platform.mapper;
+
+import com.ycl.platform.domain.entity.TContract;
+
+import java.util.List;
+
+/**
+ * 銆愯濉啓鍔熻兘鍚嶇О銆慚apper鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2024-03-12
+ */
+public interface TContractMapper
+{
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ public TContract selectTContractById(Long id);
+
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆戝垪琛�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆戦泦鍚�
+ */
+ public List<TContract> selectTContractList(TContract tContract);
+
+ /**
+ * 鏂板銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ public int insertTContract(TContract tContract);
+
+ /**
+ * 淇敼銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ public int updateTContract(TContract tContract);
+
+ /**
+ * 鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 缁撴灉
+ */
+ public int deleteTContractById(Long id);
+
+ /**
+ * 鎵归噺鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteTContractByIds(Long[] ids);
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/ITContractService.java b/ycl-server/src/main/java/com/ycl/platform/service/ITContractService.java
new file mode 100644
index 0000000..dae7f78
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/ITContractService.java
@@ -0,0 +1,62 @@
+package com.ycl.platform.service;
+
+import com.ycl.platform.domain.entity.TContract;
+
+import java.util.List;
+
+/**
+ * 銆愯濉啓鍔熻兘鍚嶇О銆慡ervice鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2024-03-12
+ */
+public interface ITContractService
+{
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ public TContract selectTContractById(Long id);
+
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆戝垪琛�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆戦泦鍚�
+ */
+ public List<TContract> selectTContractList(TContract tContract);
+
+ /**
+ * 鏂板銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ public int insertTContract(TContract tContract);
+
+ /**
+ * 淇敼銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ public int updateTContract(TContract tContract);
+
+ /**
+ * 鎵归噺鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑銆愯濉啓鍔熻兘鍚嶇О銆戜富閿泦鍚�
+ * @return 缁撴灉
+ */
+ public int deleteTContractByIds(Long[] ids);
+
+ /**
+ * 鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆戜俊鎭�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 缁撴灉
+ */
+ public int deleteTContractById(Long id);
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/TContractServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/TContractServiceImpl.java
new file mode 100644
index 0000000..dcf3c45
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/TContractServiceImpl.java
@@ -0,0 +1,94 @@
+package com.ycl.platform.service.impl;
+
+import com.ycl.platform.domain.entity.TContract;
+import com.ycl.platform.mapper.TContractMapper;
+import com.ycl.platform.service.ITContractService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+/**
+ * 銆愯濉啓鍔熻兘鍚嶇О銆慡ervice涓氬姟灞傚鐞�
+ *
+ * @author ruoyi
+ * @date 2024-03-12
+ */
+@Service
+public class TContractServiceImpl implements ITContractService
+{
+ @Autowired
+ private TContractMapper tContractMapper;
+
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ @Override
+ public TContract selectTContractById(Long id)
+ {
+ return tContractMapper.selectTContractById(id);
+ }
+
+ /**
+ * 鏌ヨ銆愯濉啓鍔熻兘鍚嶇О銆戝垪琛�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 銆愯濉啓鍔熻兘鍚嶇О銆�
+ */
+ @Override
+ public List<TContract> selectTContractList(TContract tContract)
+ {
+ return tContractMapper.selectTContractList(tContract);
+ }
+
+ /**
+ * 鏂板銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ @Override
+ public int insertTContract(TContract tContract)
+ {
+ return tContractMapper.insertTContract(tContract);
+ }
+
+ /**
+ * 淇敼銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param tContract 銆愯濉啓鍔熻兘鍚嶇О銆�
+ * @return 缁撴灉
+ */
+ @Override
+ public int updateTContract(TContract tContract)
+ {
+ return tContractMapper.updateTContract(tContract);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteTContractByIds(Long[] ids)
+ {
+ return tContractMapper.deleteTContractByIds(ids);
+ }
+
+ /**
+ * 鍒犻櫎銆愯濉啓鍔熻兘鍚嶇О銆戜俊鎭�
+ *
+ * @param id 銆愯濉啓鍔熻兘鍚嶇О銆戜富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteTContractById(Long id)
+ {
+ return tContractMapper.deleteTContractById(id);
+ }
+}
diff --git a/ycl-server/src/main/resources/mapper/zgyw/TContractMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/TContractMapper.xml
new file mode 100644
index 0000000..712d66b
--- /dev/null
+++ b/ycl-server/src/main/resources/mapper/zgyw/TContractMapper.xml
@@ -0,0 +1,86 @@
+<?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.TContractMapper">
+
+ <resultMap type="com.ycl.platform.domain.entity.TContract" id="TContractResult">
+ <result property="id" column="id" />
+ <result property="companyId" column="company_id" />
+ <result property="companyName" column="company_name" />
+ <result property="deptId" column="dept_id" />
+ <result property="deptName" column="dept_name" />
+ <result property="detail" column="detail" />
+ <result property="startTime" column="start_time" />
+ <result property="endTime" column="end_time" />
+ </resultMap>
+
+ <sql id="selectTContractVo">
+ select id, company_id, company_name, dept_id, dept_name, detail ,start_time,end_time from t_contract
+ </sql>
+
+ <select id="selectTContractList" parameterType="com.ycl.platform.domain.entity.TContract" resultMap="TContractResult">
+ <include refid="selectTContractVo"/>
+ <where>
+ <if test="companyId != null "> and company_id = #{companyId}</if>
+ <if test="companyName != null and companyName != ''"> and company_name like concat('%', #{companyName}, '%')</if>
+ <if test="deptId != null "> and dept_id = #{deptId}</if>
+ <if test="deptName != null and deptName != ''"> and dept_name like concat('%', #{deptName}, '%')</if>
+ <if test="detail != null and detail != ''"> and detail = #{detail}</if>
+ <if test="startTime != null"> and start_time = #{startTime}</if>
+ <if test="endTime != null"> and end_time = #{endTime}</if>
+ </where>
+ </select>
+
+ <select id="selectTContractById" parameterType="Long" resultMap="TContractResult">
+ <include refid="selectTContractVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertTContract" parameterType="com.ycl.platform.domain.entity.TContract" useGeneratedKeys="true" keyProperty="id">
+ insert into t_contract
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="companyId != null">company_id,</if>
+ <if test="companyName != null">company_name,</if>
+ <if test="deptId != null">dept_id,</if>
+ <if test="deptName != null">dept_name,</if>
+ <if test="detail != null">detail,</if>
+ <if test="startTime != null">start_time,</if>
+ <if test="endTime != null">end_time,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="companyId != null">#{companyId},</if>
+ <if test="companyName != null">#{companyName},</if>
+ <if test="deptId != null">#{deptId},</if>
+ <if test="deptName != null">#{deptName},</if>
+ <if test="detail != null">#{detail},</if>
+ <if test="startTime != null">#{startTime},</if>
+ <if test="endTime != null">#{endTime},</if>
+ </trim>
+ </insert>
+
+ <update id="updateTContract" parameterType="com.ycl.platform.domain.entity.TContract">
+ update t_contract
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="companyId != null">company_id = #{companyId},</if>
+ <if test="companyName != null">company_name = #{companyName},</if>
+ <if test="deptId != null">dept_id = #{deptId},</if>
+ <if test="deptName != null">dept_name = #{deptName},</if>
+ <if test="detail != null">detail = #{detail},</if>
+ <if test="startTime != null">start_time = #{startTime},</if>
+ <if test="endTime != null">end_time = #{endTime},</if>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteTContractById" parameterType="Long">
+ delete from t_contract where id = #{id}
+ </delete>
+
+ <delete id="deleteTContractByIds" parameterType="String">
+ delete from t_contract 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