From 363cf83f55c886bacb8ccab451071442a3313e67 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期五, 29 十一月 2024 04:04:40 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 business/src/main/java/com/ycl/domain/excel/ProjectExcelTemplate.java |  655 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 655 insertions(+), 0 deletions(-)

diff --git a/business/src/main/java/com/ycl/domain/excel/ProjectExcelTemplate.java b/business/src/main/java/com/ycl/domain/excel/ProjectExcelTemplate.java
new file mode 100644
index 0000000..58228b0
--- /dev/null
+++ b/business/src/main/java/com/ycl/domain/excel/ProjectExcelTemplate.java
@@ -0,0 +1,655 @@
+package com.ycl.domain.excel;
+
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.math.BigDecimal;
+import java.util.Date;
+
+/**
+ * 瀵煎嚭妯℃澘绫�
+ *
+ * @Author: ljx
+ * @CreateTime: 2024-10-18 10:19
+ */
+
+@Data
+public class ProjectExcelTemplate {
+    private static final long serialVersionUID = 1L;
+
+                                                /* 椤圭洰绠＄悊鍩虹淇℃伅琛� */
+
+    /**
+     * 椤圭洰鍚嶇О
+     */
+    @ExcelProperty(value = "椤圭洰鍚嶇О")
+    private String projectName;
+
+    /**
+     * 椤圭洰浠ｇ爜
+     */
+    @ExcelProperty(value = "椤圭洰浠ｇ爜")
+    private String projectCode;
+
+    /**
+     * 椤圭洰绫诲瀷
+     */
+    @ExcelProperty(value = "椤圭洰绫诲瀷")
+    private String projectType;
+
+    /**
+     * 椤圭洰鐘舵��
+     */
+    @ExcelProperty(value = "椤圭洰鐘舵��")
+    private String projectStatus;
+
+    /**
+     * 璧勯噾绫诲瀷
+     */
+    @ExcelProperty(value = "璧勯噾绫诲瀷")
+    private String fundType;
+
+    /**
+     * 鎶曡祫绫诲埆
+     */
+    @ExcelProperty(value = "鎶曡祫绫诲埆")
+    private String investType;
+
+    /**
+     * 閲嶇偣鍒嗙被
+     */
+    @ExcelProperty(value = "閲嶇偣鍒嗙被")
+    private String importanceType;
+
+    /**
+     * 椤圭洰闃舵
+     */
+    @ExcelProperty(value = "椤圭洰闃舵")
+    private String projectPhase;
+
+    /**
+     * 鏍囩
+     */
+    @ExcelProperty(value = "鏍囩")
+    private String tag;
+
+    /**
+     * 涓荤閮ㄩ棬
+     */
+    @ExcelProperty(value = "涓荤閮ㄩ棬")
+    private String competentDepartment;
+
+    /**
+     * 椤圭洰褰掑睘鍦�
+     */
+    @ExcelProperty(value = "椤圭洰褰掑睘鍦�")
+    private String projectLocation;
+
+    /**
+     * 缁忓害
+     */
+    @ExcelProperty(value = "缁忓害")
+    private String longitude;
+
+    /**
+     * 绾害
+     */
+    @ExcelProperty(value = "绾害")
+    private String latitude;
+
+    /**
+     * 绠＄悊褰掑彛
+     */
+    @ExcelProperty(value = "绠＄悊褰掑彛")
+    private String managementCentralization;
+
+    /**
+     * 椤圭洰鐢虫姤闃舵
+     */
+    @ExcelProperty(value = "椤圭洰鐢虫姤闃舵")
+    private String projectApplicationPhase;
+
+    /**
+     * 椤圭洰瀹℃壒绫诲瀷
+     */
+    @ExcelProperty(value = "椤圭洰瀹℃壒绫诲瀷")
+    private String projectApprovalType;
+
+    /**
+     * 鎶曡祫鐩綍
+     */
+    @ExcelProperty(value = "鎶曡祫鐩綍")
+    private String investmentCatalogue;
+
+    /**
+     * 瀹℃壒璁″垝涔�
+     */
+    @ExcelProperty(value = "瀹℃壒璁″垝涔︼紙闄勪欢鍚嶏級")
+    private String approvalPlan;
+
+    /**
+     * 鏄惁绔嬮」
+     */
+    @ExcelProperty(value = "鏄惁绔嬮」")
+    private String isSetProject;
+
+    /**
+     * 鎴愮珛鏃堕棿
+     */
+    @ExcelProperty(value = "鎴愮珛鏃堕棿")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private Date setTime;
+
+    /**
+     * 璧嬬爜鐘舵��
+     */
+    @ExcelProperty(value = "璧嬬爜鐘舵��")
+    private String assignmentStatus;
+
+    /**
+     * 琛屾斂鍖哄垝
+     */
+    @ExcelProperty(value = "琛屾斂鍖哄垝")
+    private String area;
+
+    /**
+     * 涓爣鏃堕棿
+     */
+    @ExcelProperty(value = "涓爣鏃堕棿")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private Date winTime;
+
+    /**
+     * 涓爣鍗曚綅
+     */
+    @ExcelProperty(value = "涓爣鍗曚綅")
+    private String winUnit;
+
+    /**
+     * 涓爣閲戦
+     */
+    @ExcelProperty(value = "涓爣閲戦")
+    private String winAmount;
+
+    /**
+     * 璇︾粏鍦板潃
+     */
+    @ExcelProperty(value = "璇︾粏鍦板潃")
+    private String address;
+
+    /**
+     * 寤鸿鍐呭
+     */
+    @ExcelProperty(value = "寤鸿鍐呭")
+    private String content;
+
+    /**
+     * 鑱旂郴鏂瑰紡
+     */
+    @ExcelProperty(value = "鑱旂郴鏂瑰紡")
+    private String contact;
+
+    /**
+     * 椤圭洰涓氫富鍗曚綅
+     */
+    @ExcelProperty(value = "椤圭洰涓氫富鍗曚綅")
+    private String projectOwnerUnit;
+
+    /**
+     * 璁″垝寮�宸ユ椂闂�
+     */
+    @ExcelProperty(value = "璁″垝寮�宸ユ椂闂�")
+    private Date planStartTime;
+
+    /**
+     * 璁″垝绔ｅ伐鏃堕棿
+     */
+    @ExcelProperty(value = "璁″垝绔ｅ伐鏃堕棿")
+    private Date planCompleteTime;
+
+    /**
+     * 椤圭洰鑱旂郴浜�
+     */
+    @ExcelProperty(value = "椤圭洰鑱旂郴浜�")
+    private String projectContactPerson;
+
+    /**
+     * 鏈勾璁″垝鎶曡祫
+     */
+    @ExcelProperty(value = "鏈勾璁″垝鎶曡祫")
+    private BigDecimal yearInvestAmount;
+
+
+                                        /* 鎶曡祫椤圭洰鍩虹淇℃伅琛� */
+
+    /**
+     * 寤鸿鍦扮偣鏄惁璺ㄥ煙
+     */
+    @ExcelProperty(value = "寤鸿鍦扮偣鏄惁璺ㄥ煙")
+    private String beCrossRegion;
+
+    /**
+     * 椤圭洰寤鸿鍦扮偣
+     */
+    @ExcelProperty(value = "寤鸿鍦扮偣")
+    private String constructionLocation;
+
+
+    /**
+     * 寤鸿璇︾粏鍦板潃
+     */
+    @ExcelProperty(value = "寤鸿璇︾粏鍦板潃")
+    private String detailedAddress;
+
+    /**
+     * 鏄惁鏄ˉ鐮侀」鐩�
+     */
+    @ExcelProperty(value = "鏄惁鏄ˉ鐮侀」鐩�")
+    private String beCompensationProject;
+
+    /**
+     * 琛ョ爜鍘熷洜
+     */
+    @ExcelProperty(value = "琛ョ爜鍘熷洜")
+    private String compensationReason;
+
+    /**
+     * 璁″垝寮�宸ユ椂闂�
+     */
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @ExcelProperty(value = "璁″垝寮�宸ユ椂闂�")
+    private Date plannedStartDate;
+
+    /**
+     * 鎷熷缓鎴愭椂闂�
+     */
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @ExcelProperty(value = "鎷熷缓鎴愭椂闂�")
+    private Date expectedCompletionDate;
+
+    /**
+     * 鍥芥爣琛屼笟鍒嗙被
+     */
+    @ExcelProperty(value = "鍥芥爣琛屼笟鍒嗙被")
+    private String nationalIndustryClassification;
+
+    /**
+     * 鎵�灞炶涓氬垎绫�
+     */
+    @ExcelProperty(value = "鎵�灞炶涓氬垎绫�")
+    private String industryClassification;
+
+    /**
+     * 椤圭洰寤鸿鎬ц川
+     */
+    @ExcelProperty(value = "椤圭洰寤鸿鎬ц川")
+    private String projectNature;
+
+    /**
+     * 椤圭洰灞炴��
+     */
+    @ExcelProperty(value = "椤圭洰灞炴��")
+    private String projectAttribute;
+
+    /**
+     * 鏄惁浣跨敤鍦熷湴
+     */
+    @ExcelProperty(value = "鏄惁浣跨敤鍦熷湴")
+    private String useEarth;
+
+    /**
+     * 涓昏寤鸿鍐呭鍙婅妯�
+     */
+    @ExcelProperty(value = "涓昏寤鸿鍐呭鍙婅妯�")
+    private String contentScale;
+
+    /**
+     * 寤虹骞冲彴浠ｇ爜
+     */
+    @ExcelProperty(value = "寤虹骞冲彴浠ｇ爜")
+    private String code;
+
+
+                                            /* 椤圭洰鎶曡祫鍙婅祫閲戞潵婧� */
+
+    /**
+     * 椤圭洰鎬绘姇璧勯
+     */
+    @ExcelProperty(value = "椤圭洰鎬绘姇璧勯")
+    private String totalInvestment;
+
+    /**
+     * 椤圭洰鏈噾
+     */
+    @ExcelProperty(value = "椤圭洰鏈噾")
+    private String principal;
+
+    /**
+     * 鏀垮簻鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "鏀垮簻鎶曡祫鎬婚")
+    private String governmentInvestmentTotal;
+
+    /**
+     * 涓ぎ鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "涓ぎ鎶曡祫鎬婚")
+    private String centralInvestmentTotal;
+
+    /**
+     * 涓ぎ棰勭畻鎶曡祫
+     */
+    @ExcelProperty(value = "涓ぎ棰勭畻鎶曡祫")
+    private String centralBudgetInvestment;
+
+    /**
+     * 涓ぎ璐㈡斂
+     */
+    @ExcelProperty(value = "涓ぎ璐㈡斂")
+    private String centralFiscalInvestment;
+
+    /**
+     * 涓ぎ涓撻」鍊哄埜绛归泦鐨勪笓椤瑰缓璁捐祫閲�
+     */
+    @ExcelProperty(value = "涓ぎ涓撻」鍊哄埜绛归泦鐨勪笓椤瑰缓璁捐祫閲�")
+    private String centralSpecialBondInvestment;
+
+    /**
+     * 涓ぎ涓撻」寤鸿鍩洪噾
+     */
+    @ExcelProperty(value = "涓ぎ涓撻」寤鸿鍩洪噾")
+    private String centralSpecialFundInvestment;
+
+    /**
+     * 鐪佺骇鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "鐪佺骇鎶曡祫鎬婚")
+    private String provincialInvestmentTotal;
+
+    /**
+     * 鐪侀绠楀唴鎶曡祫
+     */
+    @ExcelProperty(value = "鐪侀绠楀唴鎶曡祫")
+    private String provincialBudgetInvestment;
+
+    /**
+     * 鐪佽储鏀挎�у缓璁炬姇璧�
+     */
+    @ExcelProperty(value = "鐪佽储鏀挎�у缓璁炬姇璧�")
+    private String provincialFiscalInvestment;
+
+    /**
+     * 鐪佷笓椤瑰缓璁捐祫閲�
+     */
+    @ExcelProperty(value = "鐪佷笓椤瑰缓璁捐祫閲�")
+    private String provincialSpecialFundInvestment;
+
+    /**
+     * 甯傦紙宸烇級鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "甯傦紙宸烇級鎶曡祫鎬婚")
+    private String cityInvestmentTotal;
+
+    /**
+     * 甯傦紙宸烇級棰勭畻鍐呮姇璧�
+     */
+    @ExcelProperty(value = "甯傦紙宸烇級棰勭畻鍐呮姇璧�")
+    private String cityBudgetInvestment;
+
+    /**
+     * 甯傦紙宸烇級璐㈡斂鎬ф姇璧�
+     */
+    @ExcelProperty(value = "甯傦紙宸烇級璐㈡斂鎬ф姇璧�")
+    private String cityFiscalInvestment;
+
+    /**
+     * 甯傦紙宸烇級涓撻」璧勯噾
+     */
+    @ExcelProperty(value = "甯傦紙宸烇級涓撻」璧勯噾")
+    private String citySpecialFundInvestment;
+
+    /**
+     * 鍘匡紙甯傘�佸尯锛夋姇璧勬�婚
+     */
+    @ExcelProperty(value = "鍘匡紙甯傘�佸尯锛夋姇璧勬�婚")
+    private String countyInvestmentTotal;
+
+    /**
+     * 鍘匡紙甯傘�佸尯锛夐绠楀唴鎶曡祫
+     */
+    @ExcelProperty(value = "鍘匡紙甯傘�佸尯锛夐绠楀唴鎶曡祫")
+    private String countyBudgetInvestment;
+
+    /**
+     * 鍘匡紙甯傘�佸尯锛夎储鏀挎�у缓璁捐祫閲�
+     */
+    @ExcelProperty(value = "鍘匡紙甯傘�佸尯锛夎储鏀挎�у缓璁捐祫閲�")
+    private String countyFiscalInvestment;
+
+    /**
+     * 鍘匡紙甯傘�佸尯锛変笓椤硅祫閲�
+     */
+    @ExcelProperty(value = "鍘匡紙甯傘�佸尯锛変笓椤硅祫閲�")
+    private String countySpecialFundInvestment;
+
+    /**
+     * 鍥藉唴璐锋鎬婚
+     */
+    @ExcelProperty(value = "鍥藉唴璐锋鎬婚")
+    private String domesticLoanTotal;
+
+    /**
+     * 閾惰璐锋
+     */
+    @ExcelProperty(value = "閾惰璐锋")
+    private String bankLoan;
+
+    /**
+     * 澶栧晢鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "澶栧晢鎶曡祫鎬婚")
+    private String foreignInvestmentTotal;
+
+    /**
+     * 浼佷笟鑷鎬婚
+     */
+    @ExcelProperty(value = "浼佷笟鑷鎬婚")
+    private String enterpriseSelfRaisedTotal;
+
+    /**
+     * 鍏朵粬鎶曡祫鎬婚
+     */
+    @ExcelProperty(value = "鍏朵粬鎶曡祫鎬婚")
+    private String otherInvestmentTotal;
+
+
+                                        /* 椤圭洰锛堟硶浜猴級鍗曚綅鐧昏淇℃伅琛� */
+
+//    /**
+//     * 椤圭洰鎬绘姇璧勯(鏍规嵁鍓嶉潰鐨勬暟鎹～鍏�)
+//     */
+//    private BigDecimal totalInvestment;
+
+    /**
+     * 椤圭洰鍗曚綅
+     */
+    @ExcelProperty(value = "椤圭洰鍗曚綅")
+    private String projectUnit;
+
+    /**
+     * 椤圭洰鍗曚綅绫诲瀷
+     */
+    @ExcelProperty(value = "椤圭洰鍗曚綅绫诲瀷")
+    private String projectUnitType;
+
+    /**
+     * 鐧昏娉ㄥ唽绫诲瀷
+     */
+    @ExcelProperty(value = "鐧昏娉ㄥ唽绫诲瀷")
+    private String registrationType;
+
+    /**
+     * 鎺ц偂鎯呭喌
+     */
+    @ExcelProperty(value = "鎺ц偂鎯呭喌")
+    private String holdingSituation;
+
+    /**
+     * 璇佺収绫诲瀷
+     */
+    @ExcelProperty(value = "璇佺収绫诲瀷")
+    private String certificateType;
+
+    /**
+     * 璇佺収鍙风爜
+     */
+    @ExcelProperty(value = "璇佺収鍙风爜")
+    private String certificateNumber;
+
+    /**
+     * 娉ㄥ唽鍦板潃
+     */
+    @ExcelProperty(value = "娉ㄥ唽鍦板潃")
+    private String registeredAddress;
+
+    /**
+     * 娉ㄥ唽璧勯噾
+     */
+    @ExcelProperty(value = "娉ㄥ唽璧勯噾")
+    private BigDecimal registeredCapital;
+
+    /**
+     * 娉曚汉浠ｈ〃
+     */
+    @ExcelProperty(value = "娉曚汉浠ｈ〃")
+    private String legal_representative;
+
+    /**
+     * 鍥哄畾鐢佃瘽
+     */
+    @ExcelProperty(value = "鍥哄畾鐢佃瘽")
+    private String fixedPhone;
+
+    /**
+     * 娉曚汉韬唤璇�
+     */
+    @ExcelProperty(value = "娉曚汉韬唤璇�")
+    private String legalPersonIdcard;
+
+//    /**
+//     * 椤圭洰鑱旂郴浜猴紙鏍规嵁鍓嶉潰鐨勬暟鎹～鍏咃級
+//     */
+//    private String projectContactPerson;
+
+    /**
+     * 绉诲姩鐢佃瘽
+     */
+    @ExcelProperty(value = "绉诲姩鐢佃瘽")
+    private String phone;
+
+    /**
+     * 鑱旂郴浜鸿韩浠借瘉
+     */
+    @ExcelProperty(value = "鑱旂郴浜鸿韩浠借瘉")
+    private String contactIdcard;
+
+    /**
+     * 寰俊鍙�
+     */
+    @ExcelProperty(value = "寰俊鍙�")
+    private String wechat;
+
+    /**
+     * 鑱旂郴浜洪�氳鍦板潃
+     */
+    @ExcelProperty(value = "鑱旂郴浜洪�氳鍦板潃")
+    private String contactAddress;
+
+    /**
+     * 閭斂缂栫爜
+     */
+    @ExcelProperty(value = "閭斂缂栫爜")
+    private String postCode;
+
+    /**
+     * 鐢靛瓙閭
+     */
+    @ExcelProperty(value = "鐢靛瓙閭")
+    private String email;
+
+                                    /* 鎶曡祫椤圭洰浜т笟鏀跨瓥绗﹀悎鎯呭喌琛� */
+
+
+    /**
+     * 绗﹀悎浜т笟鏀跨瓥闄勪欢
+     */
+    @ExcelProperty(value = "绗﹀悎浜т笟鏀跨瓥(闄勪欢鍚�)")
+    private String policyComplianceAttachment;
+
+    /**
+     * 鏄惁灞炰簬銆婁骇涓氱粨鏋勮皟鏁存寚瀵肩洰褰曘�嬩笅鐨勯」鐩�
+     */
+    @ExcelProperty(value = "灞炰簬銆婁骇涓氱粨鏋勮皟鏁存寚瀵肩洰褰曘�嬩笅鐨勯」鐩�")
+    private String belongsToIndustryAdjustmentDirectory;
+
+    /**
+     * 鏄惁灞炰簬鏈垪鍏ャ�婁骇涓氱粨鏋勮皟鏁存寚瀵肩洰褰曘�嬬殑鍏佽绫婚」鐩�
+     */
+    @ExcelProperty(value = "灞炰簬鏈垪鍏ャ�婁骇涓氱粨鏋勮皟鏁存寚瀵肩洰褰曘�嬬殑鍏佽绫婚」鐩�")
+    private String belongsToAllowedProjects;
+
+    /**
+     * 鏄惁灞炰簬銆婅タ閮ㄥ湴鍖洪紦鍔辩被浜т笟鐩綍銆嬬殑椤圭洰
+     */
+    @ExcelProperty(value = "灞炰簬銆婅タ閮ㄥ湴鍖洪紦鍔辩被浜т笟鐩綍銆嬬殑椤圭洰")
+    private String belongsToWesternEncouragedDirectory;
+
+    /**
+     * 鏄惁涓嶅睘浜庝骇涓氭斂绛栫姝㈡姇璧勫缓璁炬垨瀹炶鏍稿噯銆佸鎵圭鐞嗙殑椤圭洰
+     */
+    @ExcelProperty(value = "涓嶅睘浜庝骇涓氭斂绛栫姝㈡姇璧勫缓璁炬垨瀹炶鏍稿噯銆佸鎵圭鐞嗙殑椤圭洰")
+    private String notBannedOrControlledProject;
+
+    /**
+     * 濉姤淇℃伅鏄惁鐪熷疄
+     */
+    @ExcelProperty(value = "濉姤淇℃伅鏄惁鐪熷疄")
+    private String informationIsTrue;
+
+    /**
+     * 涓撻」瑙勫垝澶嶅悎鎯呭喌
+     */
+    @ExcelProperty(value = "涓撻」瑙勫垝澶嶅悎鎯呭喌")
+    private String specialPlanningCompliance;
+
+    /**
+     * 椤圭洰鑳借�楁儏鍐�
+     */
+    @ExcelProperty(value = "椤圭洰鑳借�楁儏鍐�")
+    private String energyConsumption;
+
+    /**
+     * 椤圭洰骞寸患鍚堣兘婧愭秷璐归噺锛堟爣鍑嗙叅褰撻噺鍊硷級
+     */
+    @ExcelProperty(value = "椤圭洰骞寸患鍚堣兘婧愭秷璐归噺锛堟爣鍑嗙叅褰撻噺鍊硷級")
+    private BigDecimal annualEnergyConsumption;
+
+    /**
+     * 椤圭洰骞寸數鍔涙秷鑰楅噺锛堟爣鍑嗙叅褰撻噺鍊硷級
+     */
+    @ExcelProperty(value = "椤圭洰骞寸數鍔涙秷鑰楅噺锛堟爣鍑嗙叅褰撻噺鍊硷級")
+    private BigDecimal annualElectricityConsumption;
+
+
+    /* 鐩稿叧鏂囦功 */
+    @ExcelProperty(value = "鐩稿叧鏂囦功锛堥檮浠跺悕锛�")
+    private String documents;
+
+
+}

--
Gitblit v1.8.0