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.浜ら�氬崱鍙f帴鍏�;06.浜ら�氬唴閮ㄦ帴鍏�;07.浜ら�氬叾浠栨帴鍏�;08.鍩庡競绠$悊鎺ュ叆;09.鍗敓鐜繚鎺ュ叆;10.鍟嗘娴峰叧鎺ュ叆;11.鏁欒偛閮ㄩ棬鎺ュ叆;] */
+    @Excel(name = "琛屼笟缂栫爜 [00.绀句細娌诲畨璺潰鎺ュ叆;01.绀句細娌诲畨绀惧尯鎺ュ叆;02.绀句細娌诲畨鍐呴儴鎺ュ叆;03.绀句細娌诲畨鍏朵粬鎺ュ叆;04.浜ら�氳矾闈㈡帴鍏�;05.浜ら�氬崱鍙f帴鍏�;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