From fb611e8f45ac022c2d3611f586e85cbdd06dbbc0 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期五, 12 一月 2024 19:13:58 +0800 Subject: [PATCH] 新增财务数据同步 --- src/main/java/com/fzzy/push/nx2023/NX2023ApiRemoteService.java | 4 src/main/java/com/fzzy/async/fzzy40/entity/Fz40CashFlow.java | 351 ++++++++++++ src/main/resources/application-pro5016.yml | 2 src/main/java/com/fzzy/async/fzzy40/entity/Fz40Profit.java | 391 +++++++++++++ src/main/java/com/fzzy/async/fzzy40/Fzzy40SyncService14.java | 14 src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1503.java | 82 ++ src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1501Rep.java | 28 src/main/java/com/fzzy/api/view/repository/Api1501Rep.java | 3 src/main/java/com/fzzy/api/view/repository/Api1503Rep.java | 3 src/main/java/com/fzzy/push/nx2023/dto/Nx2023Api1307.java | 3 src/main/java/com/fzzy/api/view/repository/Api1502Rep.java | 3 src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1502.java | 82 ++ src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1502Rep.java | 26 src/main/java/com/fzzy/async/fzzy40/entity/Fz40AssetsLiability.java | 598 ++++++++++++++++++++ src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1501.java | 82 ++ src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1503Rep.java | 26 16 files changed, 1,694 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/Api1501Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1501Rep.java index 64a77fa..5195377 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1501Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1501Rep.java @@ -32,4 +32,7 @@ @Query("from Api1501 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") List<Api1501> findPushDataTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + + @Query("from Api1501 where id =:id ") + List<Api1501> findDateById(@Param("id") String id); } diff --git a/src/main/java/com/fzzy/api/view/repository/Api1502Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1502Rep.java index ce00c76..749e644 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1502Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1502Rep.java @@ -32,4 +32,7 @@ */ @Query("from Api1502 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") List<Api1502> findPushDataTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + + @Query("from Api1502 where id =:id ") + List<Api1502> findDateById(@Param("id") String id); } diff --git a/src/main/java/com/fzzy/api/view/repository/Api1503Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1503Rep.java index 74d5137..563d648 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1503Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1503Rep.java @@ -33,4 +33,7 @@ */ @Query("from Api1503 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") List<Api1503> findPushDataTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + + @Query("from Api1503 where id =:id ") + List<Api1503> findDateById(@Param("id") String id); } diff --git a/src/main/java/com/fzzy/async/fzzy40/Fzzy40SyncService14.java b/src/main/java/com/fzzy/async/fzzy40/Fzzy40SyncService14.java index d94af34..7560abc 100644 --- a/src/main/java/com/fzzy/async/fzzy40/Fzzy40SyncService14.java +++ b/src/main/java/com/fzzy/async/fzzy40/Fzzy40SyncService14.java @@ -3,8 +3,7 @@ import com.fzzy.api.data.ApiParam; import com.fzzy.api.data.SyncProtocol; import com.fzzy.api.service.SyncService14; -import com.fzzy.async.fzzy40.impl.Fzzy40Sync1403; -import com.fzzy.async.fzzy40.impl.Fzzy40Sync1404; +import com.fzzy.async.fzzy40.impl.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; @@ -19,6 +18,12 @@ private Fzzy40Sync1403 fzzy40Sync1403; @Autowired private Fzzy40Sync1404 fzzy40Sync1404; + @Autowired + private Fzzy40Sync1501 fzzy40Sync1501; + @Autowired + private Fzzy40Sync1502 fzzy40Sync1502; + @Autowired + private Fzzy40Sync1503 fzzy40Sync1503; @Override public String getProtocol() { @@ -34,6 +39,11 @@ //杞崲璁″垝鏄庣粏鍚屾 fzzy40Sync1404.syncData(param.getKqdm(), param.getDeptId(), param.getStart(), param.getEnd()); + //鍚屾璐㈠姟淇℃伅 + fzzy40Sync1501.syncData(param.getKqdm(), param.getDeptId(), param.getStart(), param.getEnd()); + fzzy40Sync1502.syncData(param.getKqdm(), param.getDeptId(), param.getStart(), param.getEnd()); + fzzy40Sync1503.syncData(param.getKqdm(), param.getDeptId(), param.getStart(), param.getEnd()); + } } diff --git a/src/main/java/com/fzzy/async/fzzy40/entity/Fz40AssetsLiability.java b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40AssetsLiability.java new file mode 100644 index 0000000..6512514 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40AssetsLiability.java @@ -0,0 +1,598 @@ +package com.fzzy.async.fzzy40.entity; + +import com.bstek.dorado.annotation.PropertyDef; +import lombok.Data; + +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Id; +import javax.persistence.Table; +import java.io.Serializable; +import java.util.Date; + +/** + * 璐㈠姟绠$悊-璧勪骇璐熷�� + * + * @author czt + * @date 2023-04-10 10:40 + */ +@Data +@Entity +@Table(name = "D_FINANCE_ASSETS_Liability") +public class Fz40AssetsLiability implements Serializable { + + private static final long serialVersionUID = 1L; + + @Id + @PropertyDef(label = "id" ) + @Column(name = "ID_", length = 40) + private String id; + + @Column(name = "COMPANY_ID_", length = 10) + @PropertyDef(label = "缁勭粐缂栫爜") + private String companyId; + + @Column(name = "DEPT_ID_", length = 30) + @PropertyDef(label = "鎵�灞炲垎搴�") + private String deptId; + + @PropertyDef(label = "鎶ヨ〃鏃堕棿" ) + @Column(name = "bbsj") + private Date bbsj; + + @PropertyDef(label = "璐у竵璧勯噾鏈熸湯浣欓(鍏�)" ) + @Column(name = "hbjjqmye") + private Double hbjjqmye; + + @PropertyDef(label = "璐у竵璧勯噾骞村垵浣欓(鍏�)" ) + @Column(name = "hbjjncye") + private Double hbjjncye; + + @PropertyDef(label = "浜ゆ槗鎬ч噾铻嶈祫浜ф湡鏈綑棰�(鍏�)" ) + @Column(name = "jyxjrzcqmye") + private Double jyxjrzcqmye; + + @PropertyDef(label = "浜ゆ槗鎬ч噾铻嶈祫浜у勾鍒濅綑棰�(鍏�)" ) + @Column(name = "jyxjrzcncye") + private Double jyxjrzcncye; + + @PropertyDef(label = "琛嶇敓閲戣瀺璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "ysjrzcqmye") + private Double ysjrzcqmye; + + @PropertyDef(label = "琛嶇敓閲戣瀺璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "ysjrzcncye") + private Double ysjrzcncye; + + @PropertyDef(label = "搴旀敹绁ㄦ嵁鏈熸湯浣欓(鍏�)" ) + @Column(name = "yspjqmye") + private Double yspjqmye; + + @PropertyDef(label = "搴旀敹绁ㄦ嵁骞村垵浣欓(鍏�)" ) + @Column(name = "yspjncye") + private Double yspjncye; + + @PropertyDef(label = "搴旀敹璐︽鏈熸湯浣欓(鍏�)" ) + @Column(name = "yszkqmye") + private Double yszkqmye; + + @PropertyDef(label = "搴旀敹璐︽骞村垵浣欓(鍏�)" ) + @Column(name = "yszkncye") + private Double yszkncye; + + @PropertyDef(label = "棰勪粯娆鹃」鏈熸湯浣欓(鍏�)" ) + @Column(name = "yuskxqmye") + private Double yuskxqmye; + + @PropertyDef(label = "棰勪粯娆鹃」骞村垵浣欓(鍏�)" ) + @Column(name = "yuskxncye") + private Double yuskxncye; + + @PropertyDef(label = "鍏朵粬搴旀敹娆炬湡鏈綑棰�(鍏�)" ) + @Column(name = "qtyszkqmye") + private Double qtyszkqmye; + + @PropertyDef(label = "鍏朵粬搴旀敹娆惧勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtyszkncye") + private Double qtyszkncye; + + @PropertyDef(label = "瀛樿揣鏈熸湯浣欓(鍏�)" ) + @Column(name = "chqmye") + private Double chqmye; + + @PropertyDef(label = "瀛樿揣骞村垵浣欓(鍏�)" ) + @Column(name = "chncye") + private Double chncye; + + @PropertyDef(label = "鍚堝悓璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "htzcqmye") + private Double htzcqmye; + + @PropertyDef(label = "鍚堝悓璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "htzcncye") + private Double htzcncye; + + @PropertyDef(label = "鎸佹湁寰呭敭璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "cydszcqmye") + private Double cydszcqmye; + + @PropertyDef(label = "鎸佹湁寰呭敭璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "cydszcncye") + private Double cydszcncye; + + @PropertyDef(label = "涓�骞村唴鍒版湡鐨勯潪娴佸姩璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "ynndqfldzcqmye") + private Double ynndqfldzcqmye; + + @PropertyDef(label = "涓�骞村唴鍒版湡鐨勯潪娴佸姩璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "ynndqfldzcncye") + private Double ynndqfldzcncye; + + @PropertyDef(label = "鍏朵粬娴佸姩璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtldzcqmye") + private Double qtldzcqmye; + + @PropertyDef(label = "鍏朵粬娴佸姩璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "qtldzcncye") + private Double qtldzcncye; + + @PropertyDef(label = "娴佸姩璧勪骇鍚堣鏈熸湯浣欓(鍏�)" ) + @Column(name = "ldzchjqmye") + private Double ldzchjqmye; + + @PropertyDef(label = "娴佸姩璧勪骇鍚堣骞村垵浣欓(鍏�)" ) + @Column(name = "ldzchjncye") + private Double ldzchjncye; + + @PropertyDef(label = "鍊哄埜鎶曡祫鏈熸湯浣欓(鍏�)" ) + @Column(name = "zjtzqmye") + private Double zjtzqmye; + + @PropertyDef(label = "鍊哄埜鎶曡祫骞村垵浣欓(鍏�)" ) + @Column(name = "zjtzncye") + private Double zjtzncye; + + @PropertyDef(label = "鍏朵粬鍊哄埜鎶曡祫鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtzqtzqmye") + private Double qtzqtzqmye; + + @PropertyDef(label = "鍏朵粬鍊哄埜鎶曡祫骞村垵浣欓(鍏�)" ) + @Column(name = "qtzqtzncye") + private Double qtzqtzncye; + + @PropertyDef(label = "闀挎湡搴旀敹娆炬湡鏈綑棰�(鍏�)" ) + @Column(name = "cqyskqmye") + private Double cqyskqmye; + + @PropertyDef(label = "闀挎湡搴旀敹娆惧勾鍒濅綑棰�(鍏�)" ) + @Column(name = "cqyskncye") + private Double cqyskncye; + + @PropertyDef(label = "闀挎湡鑲℃潈鎶曡祫鏈熸湯浣欓(鍏�)" ) + @Column(name = "cqgqtzqmye") + private Double cqgqtzqmye; + + @PropertyDef(label = "闀挎湡鑲℃潈鎶曡祫骞村垵浣欓(鍏�)" ) + @Column(name = "cqgqtzncye") + private Double cqgqtzncye; + + @PropertyDef(label = "鍏朵粬鏉冪泭宸ュ叿鎶曡祫鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtqygjtzqmye") + private Double qtqygjtzqmye; + + @PropertyDef(label = "鍏朵粬鏉冪泭宸ュ叿鎶曡祫骞村垵浣欓(鍏�)" ) + @Column(name = "qtqygjtzncye") + private Double qtqygjtzncye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄩ噾铻嶈祫浜ф湡鏈綑棰�(鍏�)" ) + @Column(name = "qtfldjrzcqmye") + private Double qtfldjrzcqmye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄩ噾铻嶈祫浜у勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtfldjrzcncye") + private Double qtfldjrzcncye; + + @PropertyDef(label = "鎶曡祫鎬ф埧鍦颁骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "tzxfdcqmye") + private Double tzxfdcqmye; + + @PropertyDef(label = "鎶曡祫鎬ф埧鍦颁骇骞村垵浣欓(鍏�)" ) + @Column(name = "tzxfdcncye") + private Double tzxfdcncye; + + @PropertyDef(label = "鍥哄畾璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "gdzcqmye") + private Double gdzcqmye; + + @PropertyDef(label = "鍥哄畾璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "gdzcncye") + private Double gdzcncye; + + @PropertyDef(label = "鍦ㄥ缓宸ョ▼鏈熸湯浣欓(鍏�)" ) + @Column(name = "zjgcqmye") + private Double zjgcqmye; + + @PropertyDef(label = "鍦ㄥ缓宸ョ▼骞村垵浣欓(鍏�)" ) + @Column(name = "zjgcncye") + private Double zjgcncye; + + @PropertyDef(label = "鐢熶骇鎬х敓鐗╄祫浜ф湡鏈綑棰�(鍏�)" ) + @Column(name = "scxswzcqmye") + private Double scxswzcqmye; + + @PropertyDef(label = "鐢熶骇鎬х敓鐗╄祫浜у勾鍒濅綑棰�(鍏�)" ) + @Column(name = "scxswzcncye") + private Double scxswzcncye; + + @PropertyDef(label = "娌规皵璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "yqzcqmye") + private Double yqzcqmye; + + @PropertyDef(label = "娌规皵璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "yqzcncye") + private Double yqzcncye; + + @PropertyDef(label = "鏃犲舰璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "wxzcqmye") + private Double wxzcqmye; + + @PropertyDef(label = "鏃犲舰璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "wxzcncye") + private Double wxzcncye; + + @PropertyDef(label = "寮�鍙戞敮鍑烘湡鏈綑棰�(鍏�)" ) + @Column(name = "kfzcqmye") + private Double kfzcqmye; + + @PropertyDef(label = "寮�鍙戞敮鍑哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "kfzcncye") + private Double kfzcncye; + + @PropertyDef(label = "鍟嗚獕鏈熸湯浣欓(鍏�)" ) + @Column(name = "syqmye") + private Double syqmye; + + @PropertyDef(label = "鍟嗚獕骞村垵浣欓(鍏�)" ) + @Column(name = "syncye") + private Double syncye; + + @PropertyDef(label = "闀挎湡寰呮憡璐圭敤鏈熸湯浣欓(鍏�)" ) + @Column(name = "cqdtfyqmye") + private Double cqdtfyqmye; + + @PropertyDef(label = "闀挎湡寰呮憡璐圭敤骞村垵浣欓(鍏�)" ) + @Column(name = "cqdtfyncye") + private Double cqdtfyncye; + + @PropertyDef(label = "閫掑欢鎵�寰楃◣璧勪骇鏈熸湯浣欓(鍏�)" ) + @Column(name = "dysdszcqmye") + private Double dysdszcqmye; + + @PropertyDef(label = "閫掑欢鎵�寰楃◣璧勪骇骞村垵浣欓(鍏�)" ) + @Column(name = "dysdszcncye") + private Double dysdszcncye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄨ祫浜ф湡鏈綑棰�(鍏�)" ) + @Column(name = "qtfldzcqmye") + private Double qtfldzcqmye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄨ祫浜у勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtfldzcncye") + private Double qtfldzcncye; + + @PropertyDef(label = "闈炴祦鍔ㄨ祫浜у悎璁℃湡鏈綑棰�(鍏�)" ) + @Column(name = "fldzcqmye") + private Double fldzcqmye; + + @PropertyDef(label = "闈炴祦鍔ㄨ祫浜у悎璁″勾鍒濅綑棰�(鍏�)" ) + @Column(name = "fldzcncye") + private Double fldzcncye; + + @PropertyDef(label = "璧勪骇鎬昏鏈熸湯浣欓(鍏�)" ) + @Column(name = "zczjqmye") + private Double zczjqmye; + + @PropertyDef(label = "璧勪骇鎬昏骞村垵浣欓(鍏�)" ) + @Column(name = "zczjncye") + private Double zczjncye; + + @PropertyDef(label = "鐭湡鍊熸鏈熸湯浣欓(鍏�)" ) + @Column(name = "dqjkmye") + private Double dqjkmye; + + @PropertyDef(label = "鐭湡鍊熸骞村垵浣欓(鍏�)" ) + @Column(name = "dqjkncye") + private Double dqjkncye; + + @PropertyDef(label = "浜ゆ槗鎬ч噾铻嶈礋鍊烘湡鏈綑棰�(鍏�)" ) + @Column(name = "jyxjrfzqmye") + private Double jyxjrfzqmye; + + @PropertyDef(label = "浜ゆ槗鎬ч噾铻嶈礋鍊哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "jyxjrfzncye") + private Double jyxjrfzncye; + + @PropertyDef(label = "琛嶇敓閲戣瀺璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "ysjrfzqmye") + private Double ysjrfzqmye; + + @PropertyDef(label = "琛嶇敓閲戣瀺璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "ysjrfzncye") + private Double ysjrfzncye; + + @PropertyDef(label = "搴斾粯绁ㄦ嵁鏈熸湯浣欓(鍏�)" ) + @Column(name = "ldfzyspjqmye") + private Double ldfzyspjqmye; + + @PropertyDef(label = "搴斾粯绁ㄦ嵁骞村垵浣欓(鍏�)" ) + @Column(name = "ldfzyspjncye") + private Double ldfzyspjncye; + + @PropertyDef(label = "搴斾粯璐︽鏈熸湯浣欓(鍏�)" ) + @Column(name = "ldfzyszkqmye") + private Double ldfzyszkqmye; + + @PropertyDef(label = "搴斾粯璐︽骞村垵浣欓(鍏�)" ) + @Column(name = "ldfzyszkncye") + private Double ldfzyszkncye; + + @PropertyDef(label = "棰勬敹娆鹃」鏈熸湯浣欓(鍏�)" ) + @Column(name = "ldfzyuskxqmye") + private Double ldfzyuskxqmye; + + @PropertyDef(label = "棰勬敹娆鹃」骞村垵浣欓(鍏�)" ) + @Column(name = "ldfzyuskxncye") + private Double ldfzyuskxncye; + + @PropertyDef(label = "鍚堝悓璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "htfzqmye") + private Double htfzqmye; + + @PropertyDef(label = "鍚堝悓璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "htfzncye") + private Double htfzncye; + + @PropertyDef(label = "搴斾粯鑱屽伐钖叕鏈熸湯浣欓(鍏�)" ) + @Column(name = "yfzgxcqmye") + private Double yfzgxcqmye; + + @PropertyDef(label = "搴斾粯鑱屽伐钖叕骞村垵浣欓(鍏�)" ) + @Column(name = "yfzgxcncye") + private Double yfzgxcncye; + + @PropertyDef(label = "搴斾氦绋庤垂鏈熸湯浣欓(鍏�)" ) + @Column(name = "yjsfqmye") + private Double yjsfqmye; + + @PropertyDef(label = "搴斾氦绋庤垂骞村垵浣欓(鍏�)" ) + @Column(name = "yjsfncye") + private Double yjsfncye; + + @PropertyDef(label = "鍏朵粬搴斾粯娆炬湡鏈綑棰�(鍏�)" ) + @Column(name = "qtyfkqmye") + private Double qtyfkqmye; + + @PropertyDef(label = "鍏朵粬搴斾粯娆惧勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtyfkncye") + private Double qtyfkncye; + + @PropertyDef(label = "鎸佹湁寰呭敭璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "cydsfzqmye") + private Double cydsfzqmye; + + @PropertyDef(label = "鎸佹湁寰呭敭璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "cydsfzncye") + private Double cydsfzncye; + + @PropertyDef(label = "涓�骞村唴鍒版湡鐨勯潪娴佸姩璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "ynddqfldfzqmye") + private Double ynddqfldfzqmye; + + @PropertyDef(label = "涓�骞村唴鍒版湡鐨勯潪娴佸姩璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "ynddqfldfzncye") + private Double ynddqfldfzncye; + + @PropertyDef(label = "鍏朵粬娴佸姩璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "qtldfzqmye") + private Double qtldfzqmye; + + @PropertyDef(label = "鍏朵粬娴佸姩璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtldfzncye") + private Double qtldfzncye; + + @PropertyDef(label = "娴佸姩璐熷�哄悎璁℃湡鏈綑棰�(鍏�)" ) + @Column(name = "ldfzhjqmye") + private Double ldfzhjqmye; + + @PropertyDef(label = "娴佸姩璐熷�哄悎璁″勾鍒濅綑棰�(鍏�)" ) + @Column(name = "ldfzhjncye") + private Double ldfzhjncye; + + @PropertyDef(label = "闀挎湡鍊熸鏈熸湯浣欓(鍏�)" ) + @Column(name = "cqjkqmye") + private Double cqjkqmye; + + @PropertyDef(label = "闀挎湡鍊熸骞村垵浣欓(鍏�)" ) + @Column(name = "cqjkncye") + private Double cqjkncye; + + @PropertyDef(label = "搴斾粯鍊哄埜鏈熸湯浣欓(鍏�)" ) + @Column(name = "yfzqqmye") + private Double yfzqqmye; + + @PropertyDef(label = "搴斾粯鍊哄埜骞村垵浣欓(鍏�)" ) + @Column(name = "yfzqncye") + private Double yfzqncye; + + @PropertyDef(label = "鍏朵腑锛氫紭鍏堣偂鏈熸湯浣欓(鍏�)" ) + @Column(name = "yfzqyxgqmye") + private Double yfzqyxgqmye; + + @PropertyDef(label = "鍏朵腑锛氫紭鍏堣偂骞村垵浣欓(鍏�)" ) + @Column(name = "yfzqyxgncye") + private Double yfzqyxgncye; + + @PropertyDef(label = "姘哥画鍊烘湡鏈綑棰�(鍏�)" ) + @Column(name = "yfzqyxzqmye") + private Double yfzqyxzqmye; + + @PropertyDef(label = "姘哥画鍊哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "yfzqyxzncye") + private Double yfzqyxzncye; + + @PropertyDef(label = "闀挎湡搴斾粯娆炬湡鏈綑棰�(鍏�)" ) + @Column(name = "cqyfkqmye") + private Double cqyfkqmye; + + @PropertyDef(label = "闀挎湡搴斾粯娆惧勾鍒濅綑棰�(鍏�)" ) + @Column(name = "cqyfkncye") + private Double cqyfkncye; + + @PropertyDef(label = "棰勮璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "ysfzqmye") + private Double ysfzqmye; + + @PropertyDef(label = "棰勮璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "ysfzncye") + private Double ysfzncye; + + @PropertyDef(label = "閫掑欢鏀剁泭鏈熸湯浣欓(鍏�)" ) + @Column(name = "dysyqmye") + private Double dysyqmye; + + @PropertyDef(label = "閫掑欢鏀剁泭骞村垵浣欓(鍏�)" ) + @Column(name = "dysyncye") + private Double dysyncye; + + @PropertyDef(label = "閫掑欢鎵�寰楃◣璐熷�烘湡鏈綑棰�(鍏�)" ) + @Column(name = "dysdsfzqmye") + private Double dysdsfzqmye; + + @PropertyDef(label = "閫掑欢鎵�寰楃◣璐熷�哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "dysdsfzncye") + private Double dysdsfzncye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄨ礋鍊烘湡鏈綑棰�(鍏�)" ) + @Column(name = "qtfldfzqmye") + private Double qtfldfzqmye; + + @PropertyDef(label = "鍏朵粬闈炴祦鍔ㄨ礋鍊哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtfldfzncye") + private Double qtfldfzncye; + + @PropertyDef(label = "闈炴祦鍔ㄨ礋鍊哄悎璁℃湡鏈綑棰�(鍏�)" ) + @Column(name = "fldfzhjqmye") + private Double fldfzhjqmye; + + @PropertyDef(label = "闈炴祦鍔ㄨ礋鍊哄悎璁″勾鍒濅綑棰�(鍏�)" ) + @Column(name = "fldfzhjncye") + private Double fldfzhjncye; + + @PropertyDef(label = "璐熷�哄悎璁℃湡鏈綑棰�(鍏�)" ) + @Column(name = "fzhjqmye") + private Double fzhjqmye; + + @PropertyDef(label = "璐熷�哄悎璁″勾鍒濅綑棰�(鍏�)" ) + @Column(name = "fzhjncye") + private Double fzhjncye; + + @PropertyDef(label = "瀹炴敹璧勬湰(鎴栬偂鏈�)鏈熸湯浣欓(鍏�)" ) + @Column(name = "sszbqmye") + private Double sszbqmye; + + @PropertyDef(label = "瀹炴敹璧勬湰(鎴栬偂鏈�)骞村垵浣欓(鍏�)" ) + @Column(name = "sszbncye") + private Double sszbncye; + + @PropertyDef(label = "鍏朵粬鏉冪泭宸ュ叿鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtqygjqmye") + private Double qtqygjqmye; + + @PropertyDef(label = "鍏朵粬鏉冪泭宸ュ叿骞村垵浣欓(鍏�)" ) + @Column(name = "qtqygjncye") + private Double qtqygjncye; + + @PropertyDef(label = "鍏朵腑锛氫紭鍏堣偂鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtqygjyxgqmye") + private Double qtqygjyxgqmye; + + @PropertyDef(label = "鍏朵腑锛氫紭鍏堣偂骞村垵浣欓(鍏�)" ) + @Column(name = "qtqygjyxgncye") + private Double qtqygjyxgncye; + + @PropertyDef(label = "姘哥画鍊烘湡鏈綑棰�(鍏�)" ) + @Column(name = "qtqygjyxzqmye") + private Double qtqygjyxzqmye; + + @PropertyDef(label = "姘哥画鍊哄勾鍒濅綑棰�(鍏�)" ) + @Column(name = "qtqygjyxzncye") + private Double qtqygjyxzncye; + + @PropertyDef(label = "璧勬湰鍏Н鏈熸湯浣欓(鍏�)" ) + @Column(name = "zbgjqmye") + private Double zbgjqmye; + + @PropertyDef(label = "璧勬湰鍏Н骞村垵浣欓(鍏�)" ) + @Column(name = "zbgjncye") + private Double zbgjncye; + + @PropertyDef(label = "鍑忥細搴撳瓨鑲℃湡鏈綑棰�(鍏�)" ) + @Column(name = "jkcgqmye") + private Double jkcgqmye; + + @PropertyDef(label = "鍑忥細搴撳瓨鑲″勾鍒濅綑棰�(鍏�)" ) + @Column(name = "jkcgncye") + private Double jkcgncye; + + @PropertyDef(label = "鍏朵粬缁煎悎鏀剁泭鏈熸湯浣欓(鍏�)" ) + @Column(name = "qtzhsyqmye") + private Double qtzhsyqmye; + + @PropertyDef(label = "鍏朵粬缁煎悎鏀剁泭骞村垵浣欓(鍏�)" ) + @Column(name = "qtzhsyncye") + private Double qtzhsyncye; + + @PropertyDef(label = "涓撻」鍌ㄥ鏈熸湯浣欓(鍏�)" ) + @Column(name = "zxcbqmye") + private Double zxcbqmye; + + @PropertyDef(label = "涓撻」鍌ㄥ骞村垵浣欓(鍏�)" ) + @Column(name = "zxcbncye") + private Double zxcbncye; + + @PropertyDef(label = "鐩堜綑鍏Н鏈熸湯浣欓(鍏�)" ) + @Column(name = "yygjqmye") + private Double yygjqmye; + + @PropertyDef(label = "鐩堜綑鍏Н骞村垵浣欓(鍏�)" ) + @Column(name = "yygjncye") + private Double yygjncye; + + @PropertyDef(label = "鏈垎閰嶅埄娑︽湡鏈綑棰�(鍏�)" ) + @Column(name = "wfplrqmye") + private Double wfplrqmye; + + @PropertyDef(label = "鏈垎閰嶅埄娑﹀勾鍒濅綑棰�(鍏�)" ) + @Column(name = "wfplrncye") + private Double wfplrncye; + + @PropertyDef(label = "鎵�鏈夎�呮潈鐩�(鎴栬偂涓滄潈鐩�)鍚堣鏈熸湯浣欓(鍏�)" ) + @Column(name = "syzqyqmye") + private Double syzqyqmye; + + @PropertyDef(label = "鎵�鏈夎�呮潈鐩�(鎴栬偂涓滄潈鐩�)鍚堣骞村垵浣欓(鍏�)" ) + @Column(name = "syzqyncye") + private Double syzqyncye; + + @PropertyDef(label = "璐熷�哄拰鎵�鏈夎�呮潈鐩�(鎴栬偂涓滅泭)鎬昏鏈熸湯浣欓(鍏�)" ) + @Column(name = "fzhsyzqyqmye") + private Double fzhsyzqyqmye; + + @PropertyDef(label = "璐熷�哄拰鎵�鏈夎�呮潈鐩�(鎴栬偂涓滅泭)鎬昏骞村垵浣欓(鍏�)" ) + @Column(name = "fzhsyzqyncye") + private Double fzhsyzqyncye; + + @PropertyDef(label = "鏈�鍚庢洿鏂版椂闂�" ) + @Column(name = "zhgxsj") + private Date zhgxsj; +} diff --git a/src/main/java/com/fzzy/async/fzzy40/entity/Fz40CashFlow.java b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40CashFlow.java new file mode 100644 index 0000000..3f7d765 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40CashFlow.java @@ -0,0 +1,351 @@ +package com.fzzy.async.fzzy40.entity; + +import com.bstek.dorado.annotation.PropertyDef; +import lombok.Data; + +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Id; +import javax.persistence.Table; +import java.io.Serializable; +import java.util.Date; + +/** + * 璐㈠姟绠$悊-鐜伴噾娴� + * + * @author czt + * @date 2023-04-10 10:30 + */ +@Data +@Entity +@Table(name = "D_FINANCE_CASH_FLOW") +public class Fz40CashFlow implements Serializable { + + private static final long serialVersionUID = 1L; + + @Id + @Column(name = "ID_", length = 40) + @PropertyDef(label = "涓婚敭") + private String id; + + @Column(name = "COMPANY_ID_", length = 10) + @PropertyDef(label = "缁勭粐缂栫爜") + private String companyId; + + @Column(name = "DEPT_ID_", length = 40) + @PropertyDef(label = "鎵�灞炲垎搴�") + private String deptId; + + @PropertyDef(label = "鎶ヨ〃鏃堕棿" ) + @Column(name = "bbsj") + private Date bbsj; + + @PropertyDef(label = "涓�銆佺粡钀ユ椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺鏈湀鏁�(鍏�)" ) + @Column(name = "jyhdxjllbys") + private Double jyhdxjllbys; + + @PropertyDef(label = "涓�銆佺粡钀ユ椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺鏈勾绱鏁�(鍏�)" ) + @Column(name = "jyhdxjllbnljs") + private Double jyhdxjllbnljs; + + @PropertyDef(label = "閿�鍞晢鍝併�佹彁渚涘姵鍔℃敹鍒扮殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "xssplwxjbys") + private Double xssplwxjbys; + + @PropertyDef(label = "閿�鍞晢鍝併�佹彁渚涘姵鍔℃敹鍒扮殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "xssplwxjbnljs") + private Double xssplwxjbnljs; + + @PropertyDef(label = "鏀跺埌鐨勭◣璐硅繑杩樻湰鏈堟暟(鍏�)" ) + @Column(name = "sffhbys") + private Double sffhbys; + + @PropertyDef(label = "鏀跺埌鐨勭◣璐硅繑杩樻湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "sffhbnljs") + private Double sffhbnljs; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庣粡钀ユ椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "qtjyhdxjbys") + private Double qtjyhdxjbys; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庣粡钀ユ椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "qtjyhdxjbnljs") + private Double qtjyhdxjbnljs; + + @PropertyDef(label = "缁忚惀娲诲姩鐜伴噾娴佸叆灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "jyhdxjlrbys") + private Double jyhdxjlrbys; + + @PropertyDef(label = "缁忚惀娲诲姩鐜伴噾娴佸叆灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "jyhdxjlrbnljs") + private Double jyhdxjlrbnljs; + + @PropertyDef(label = "璐拱鍟嗗搧銆佹帴鍙楀姵鍔℃敮浠樼殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "gmsplwzfbys") + private Double gmsplwzfbys; + + @PropertyDef(label = "璐拱鍟嗗搧銆佹帴鍙楀姵鍔℃敮浠樼殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "gmsplwzfbnljs") + private Double gmsplwzfbnljs; + + @PropertyDef(label = "鏀粯缁欒亴宸ュ強涓鸿亴宸ユ敮浠樼殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "zfzgxjbys") + private Double zfzgxjbys; + + @PropertyDef(label = "鏀粯缁欒亴宸ュ強涓鸿亴宸ユ敮浠樼殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "zfzgxjbnljs") + private Double zfzgxjbnljs; + + @PropertyDef(label = "鏀粯鐨勫悇椤圭◣璐规湰鏈堟暟(鍏�)" ) + @Column(name = "zfxxsfbys") + private Double zfxxsfbys; + + @PropertyDef(label = "鏀粯鐨勫悇椤圭◣璐规湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "zfxxsfbnljs") + private Double zfxxsfbnljs; + + @PropertyDef(label = "鏀粯鍏朵粬涓庣粡钀ユ椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "zfqtjyhdxjbys") + private Double zfqtjyhdxjbys; + + @PropertyDef(label = "鏀粯鍏朵粬涓庣粡钀ユ椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "zfqtjyhdxjbnljs") + private Double zfqtjyhdxjbnljs; + + @PropertyDef(label = "缁忚惀娲诲姩鐜伴噾娴佸嚭灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "jyhdxjlcbys") + private Double jyhdxjlcbys; + + @PropertyDef(label = "缁忚惀娲诲姩鐜伴噾娴佸嚭灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "jyhdxjlcbnljs") + private Double jyhdxjlcbnljs; + + @PropertyDef(label = "缁忚惀娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "jyhdxjlljebys") + private Double jyhdxjlljebys; + + @PropertyDef(label = "缁忚惀娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "jyhdxjlljebnljs") + private Double jyhdxjlljebnljs; + + @PropertyDef(label = "浜屻�佹姇璧勬椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺锛氭湰鏈堟暟(鍏�)" ) + @Column(name = "tzhdxjllbys") + private Double tzhdxjllbys; + + @PropertyDef(label = "浜屻�佹姇璧勬椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺锛氭湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "tzhdxjllbnljs") + private Double tzhdxjllbnljs; + + @PropertyDef(label = "鏀跺洖鎶曡祫鏀跺埌鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "shtzxjbys") + private Double shtzxjbys; + + @PropertyDef(label = "鏀跺洖鎶曡祫鏀跺埌鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "shtzxjbnljs") + private Double shtzxjbnljs; + + @PropertyDef(label = "鍙栧緱鎶曡祫鏀剁泭鏀跺埌鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "qdtzsyxjbys") + private Double qdtzsyxjbys; + + @PropertyDef(label = "鍙栧緱鎶曡祫鏀剁泭鏀跺埌鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "qdtzsyxjbnljs") + private Double qdtzsyxjbnljs; + + @PropertyDef(label = "澶勭疆鍥哄畾璧勪骇銆佹棤褰㈣祫浜у拰鍏朵粬闀挎湡璧勪骇鏀跺洖鐨勭幇閲戝噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "czgdzcdxjjebys") + private Double czgdzcdxjjebys; + + @PropertyDef(label = "澶勭疆鍥哄畾璧勪骇銆佹棤褰㈣祫浜у拰鍏朵粬闀挎湡璧勪骇鏀跺洖鐨勭幇閲戝噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "czgdzcdxjjebnljs") + private Double czgdzcdxjjebnljs; + + @PropertyDef(label = "澶勭疆瀛愬叕鍙稿強鍏朵粬钀ヤ笟鍗曚綅鏀跺埌鐨勭幇閲戝噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "czqtdwxjjebys") + private Double czqtdwxjjebys; + + @PropertyDef(label = "澶勭疆瀛愬叕鍙稿強鍏朵粬钀ヤ笟鍗曚綅鏀跺埌鐨勭幇閲戝噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "czqtdwxjjebnljs") + private Double czqtdwxjjebnljs; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庢姇璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "sdqttzxjbys") + private Double sdqttzxjbys; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庢姇璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "sdqttzxjbnljs") + private Double sdqttzxjbnljs; + + @PropertyDef(label = "鎶曡祫娲诲姩鐜伴噾娴佸叆灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "tzhdxjlrbys") + private Double tzhdxjlrbys; + + @PropertyDef(label = "鎶曡祫娲诲姩鐜伴噾娴佸叆灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "tzhdxjlrbnljs") + private Double tzhdxjlrbnljs; + + @PropertyDef(label = "璐缓鍥哄畾璧勪骇銆佹棤褰㈣祫浜у拰鍏朵粬闀挎湡璧勪骇鏀粯鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "gjgdzcdxjbys") + private Double gjgdzcdxjbys; + + @PropertyDef(label = "璐缓鍥哄畾璧勪骇銆佹棤褰㈣祫浜у拰鍏朵粬闀挎湡璧勪骇鏀粯鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "gjgdzcdxjbnljs") + private Double gjgdzcdxjbnljs; + + @PropertyDef(label = "鎶曡祫鏀粯鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "tzzfxjbys") + private Double tzzfxjbys; + + @PropertyDef(label = "鎶曡祫鏀粯鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "tzzfxjbnljs") + private Double tzzfxjbnljs; + + @PropertyDef(label = "鍙栧緱瀛愬叕鍙稿強鍏朵粬钀ヤ笟鍗曚綅鏀粯鐨勭幇閲戝噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "qdzgsdzfxjjebys") + private Double qdzgsdzfxjjebys; + + @PropertyDef(label = "鍙栧緱瀛愬叕鍙稿強鍏朵粬钀ヤ笟鍗曚綅鏀粯鐨勭幇閲戝噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "qdzgsdzfxjjebnljs") + private Double qdzgsdzfxjjebnljs; + + @PropertyDef(label = "鏀粯鍏朵粬涓庢姇璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "zfqttzxjbys") + private Double zfqttzxjbys; + + @PropertyDef(label = "鏀粯鍏朵粬涓庢姇璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "zfqttzxjbnljs") + private Double zfqttzxjbnljs; + + @PropertyDef(label = "鎶曡祫娲诲姩鐜伴噾娴佸嚭灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "tzhdxjlcbys") + private Double tzhdxjlcbys; + + @PropertyDef(label = "鎶曡祫娲诲姩鐜伴噾娴佸嚭灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "tzhdxjlcbnljs") + private Double tzhdxjlcbnljs; + + @PropertyDef(label = "鎶曡祫娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "tzhdcsxjlljebys") + private Double tzhdcsxjlljebys; + + @PropertyDef(label = "鎶曡祫娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "tzhdcsxjlljebnljs") + private Double tzhdcsxjlljebnljs; + + @PropertyDef(label = "涓夈�佺璧勬椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺锛氭湰鏈堟暟(鍏�)" ) + @Column(name = "cchdxjllbys") + private Double cchdxjllbys; + + @PropertyDef(label = "涓夈�佺璧勬椿鍔ㄤ骇鐢熺殑鐜伴噾娴侀噺锛氭湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "cchdxjllbnljs") + private Double cchdxjllbnljs; + + @PropertyDef(label = "鍚告敹鎶曡祫鏀跺埌鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "xstzxjbys") + private Double xstzxjbys; + + @PropertyDef(label = "鍚告敹鎶曡祫鏀跺埌鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "xstzxjbnljs") + private Double xstzxjbnljs; + + @PropertyDef(label = "鍙栧緱鍊熸鏀跺埌鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "qdjkxjbys") + private Double qdjkxjbys; + + @PropertyDef(label = "鍙栧緱鍊熸鏀跺埌鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "qdjkxjbnljs") + private Double qdjkxjbnljs; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庣璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "sdqtczxjbys") + private Double sdqtczxjbys; + + @PropertyDef(label = "鏀跺埌鍏朵粬涓庣璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "sdqtczxjbnljs") + private Double sdqtczxjbnljs; + + @PropertyDef(label = "绛硅祫娲诲姩鐜伴噾娴佸叆灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "czhdxjlrbys") + private Double czhdxjlrbys; + + @PropertyDef(label = "绛硅祫娲诲姩鐜伴噾娴佸叆灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "czhdxjlrbnljs") + private Double czhdxjlrbnljs; + + @PropertyDef(label = "鍋胯繕鍊哄姟鏀粯鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "chzwzfxjbys") + private Double chzwzfxjbys; + + @PropertyDef(label = "鍋胯繕鍊哄姟鏀粯鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "chzwzfxjbnljs") + private Double chzwzfxjbnljs; + + @PropertyDef(label = "鍒嗛厤鑲″埄銆佸埄娑︽垨鍋夸粯鍒╂伅鏀粯鐨勭幇閲戞湰鏈堟暟(鍏�)" ) + @Column(name = "fpgldxjbys") + private Double fpgldxjbys; + + @PropertyDef(label = "鍒嗛厤鑲″埄銆佸埄娑︽垨鍋夸粯鍒╂伅鏀粯鐨勭幇閲戞湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "fpgldxjbnljs") + private Double fpgldxjbnljs; + + @PropertyDef(label = "鏀粯鍏朵粬涓庣璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈湀鏁�(鍏�)" ) + @Column(name = "zfqtdxjbys") + private Double zfqtdxjbys; + + @PropertyDef(label = "鏀粯鍏朵粬涓庣璧勬椿鍔ㄦ湁鍏崇殑鐜伴噾鏈勾绱鏁�(鍏�)" ) + @Column(name = "zfqtdxjbnljs") + private Double zfqtdxjbnljs; + + @PropertyDef(label = "绛硅祫娲诲姩鐜伴噾娴佸嚭灏忚鏈湀鏁�(鍏�)" ) + @Column(name = "czhdxjlcbys") + private Double czhdxjlcbys; + + @PropertyDef(label = "绛硅祫娲诲姩鐜伴噾娴佸嚭灏忚鏈勾绱鏁�(鍏�)" ) + @Column(name = "czhdxjlcbnljs") + private Double czhdxjlcbnljs; + + @PropertyDef(label = "绛硅祫娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "cchdxjlljebys") + private Double cchdxjlljebys; + + @PropertyDef(label = "绛硅祫娲诲姩浜х敓鐨勭幇閲戞祦閲忓噣棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "cchdxjlljebnljs") + private Double cchdxjlljebnljs; + + @PropertyDef(label = "鍥涖�佹眹鐜囧彉鍔ㄥ鐜伴噾鍙婄幇閲戠瓑浠风墿鐨勫奖鍝嶆湰鏈堟暟(鍏�)" ) + @Column(name = "hlbdxjyxbys") + private Double hlbdxjyxbys; + + @PropertyDef(label = "鍥涖�佹眹鐜囧彉鍔ㄥ鐜伴噾鍙婄幇閲戠瓑浠风墿鐨勫奖鍝嶆湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "hlbdxjyxbnljs") + private Double hlbdxjyxbnljs; + + @PropertyDef(label = "浜斻�佺幇閲戝強鐜伴噾绛変环鐗╁噣澧炲姞棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "xjdjwjzebys") + private Double xjdjwjzebys; + + @PropertyDef(label = "浜斻�佺幇閲戝強鐜伴噾绛変环鐗╁噣澧炲姞棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "xjdjwjzebnljs") + private Double xjdjwjzebnljs; + + @PropertyDef(label = "鍔狅細鏈熷垵鐜伴噾鍙婄幇閲戠瓑浠风墿浣欓鏈湀鏁�(鍏�)" ) + @Column(name = "qcxjdjwyebys") + private Double qcxjdjwyebys; + + @PropertyDef(label = "鍔狅細鏈熷垵鐜伴噾鍙婄幇閲戠瓑浠风墿浣欓鏈勾绱鏁�(鍏�)" ) + @Column(name = "qcxjdjwyebnljs") + private Double qcxjdjwyebnljs; + + @PropertyDef(label = "鍏�佹湡鏈幇閲戝強鐜伴噾绛変环鐗╀綑棰濇湰鏈堟暟(鍏�)" ) + @Column(name = "qmxjdjwyebys") + private Double qmxjdjwyebys; + + @PropertyDef(label = "鍏�佹湡鏈幇閲戝強鐜伴噾绛変环鐗╀綑棰濇湰骞寸疮璁℃暟(鍏�)" ) + @Column(name = "qmxjdjwyebnljs") + private Double qmxjdjwyebnljs; + + @PropertyDef(label = "鏈�鍚庢洿鏂版椂闂�" ) + @Column(name = "zhgxsj") + private Date zhgxsj; + +} diff --git a/src/main/java/com/fzzy/async/fzzy40/entity/Fz40Profit.java b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40Profit.java new file mode 100644 index 0000000..cef616e --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/entity/Fz40Profit.java @@ -0,0 +1,391 @@ +package com.fzzy.async.fzzy40.entity; + +import com.bstek.dorado.annotation.PropertyDef; +import lombok.Data; + +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Id; +import javax.persistence.Table; +import java.io.Serializable; +import java.util.Date; + +/** + * 璐㈠姟绠$悊-鍒╂鼎 + * + * @author czt + * @date 2023-04-10 10:50 + */ +@Data +@Entity +@Table(name = "D_FINANCE_PROFIT") +public class Fz40Profit implements Serializable { + + private static final long serialVersionUID = 1L; + + @Id + @PropertyDef(label = "id" ) + @Column(name = "ID_", length = 40) + private String id; + + @Column(name = "COMPANY_ID_", length = 10) + @PropertyDef(label = "缁勭粐缂栫爜") + private String companyId; + + @Column(name = "DEPT_ID_", length = 30) + @PropertyDef(label = "鎵�灞炲垎搴�") + private String deptId; + + @PropertyDef(label = "鎶ヨ〃鏃堕棿" ) + @Column(name = "bbsj") + private Date bbsj; + + @PropertyDef(label = "涓�銆佽惀涓氭敹鍏ユ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "yyzsrbqye") + private Double yyzsrbqye; + + @PropertyDef(label = "涓�銆佽惀涓氭敹鍏ユ湰骞寸疮璁�(鍏�)" ) + @Column(name = "yyzsrbnlj") + private Double yyzsrbnlj; + + @PropertyDef(label = "鍑忥細钀ヤ笟鎴愭湰鏈湡浣欓(鍏�)" ) + @Column(name = "yycbbqye") + private Double yycbbqye; + + @PropertyDef(label = "鍑忥細钀ヤ笟鎴愭湰鏈勾绱(鍏�)" ) + @Column(name = "yycbbnlj") + private Double yycbbnlj; + + @PropertyDef(label = "绋庨噾鍙婇檮鍔犳湰鏈熶綑棰�(鍏�)" ) + @Column(name = "sjjfjbqye") + private Double sjjfjbqye; + + @PropertyDef(label = "绋庨噾鍙婇檮鍔犳湰骞寸疮璁�(鍏�)" ) + @Column(name = "sjjfjbnlj") + private Double sjjfjbnlj; + + @PropertyDef(label = "閿�鍞垂鐢ㄦ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "xsfybqye") + private Double xsfybqye; + + @PropertyDef(label = "閿�鍞垂鐢ㄦ湰骞寸疮璁�(鍏�)" ) + @Column(name = "xsfybnlj") + private Double xsfybnlj; + + @PropertyDef(label = "绠$悊璐圭敤鏈湡浣欓(鍏�)" ) + @Column(name = "glfybqye") + private Double glfybqye; + + @PropertyDef(label = "绠$悊璐圭敤鏈勾绱(鍏�)" ) + @Column(name = "glfybnlj") + private Double glfybnlj; + + @PropertyDef(label = "鐮斿彂璐圭敤鏈湡浣欓(鍏�)" ) + @Column(name = "yffybqye") + private Double yffybqye; + + @PropertyDef(label = "鐮斿彂璐圭敤鏈勾绱(鍏�)" ) + @Column(name = "yffybnlj") + private Double yffybnlj; + + @PropertyDef(label = "璐㈠姟璐圭敤鏈湡浣欓(鍏�)" ) + @Column(name = "cwfybqye") + private Double cwfybqye; + + @PropertyDef(label = "璐㈠姟璐圭敤鏈勾绱(鍏�)" ) + @Column(name = "cwfybnlj") + private Double cwfybnlj; + + @PropertyDef(label = "鍏朵腑锛氬埄鎭垂鐢ㄦ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "lxfybqye") + private Double lxfybqye; + + @PropertyDef(label = "鍏朵腑锛氬埄鎭垂鐢ㄦ湰骞寸疮璁�(鍏�)" ) + @Column(name = "lxfybnlj") + private Double lxfybnlj; + + @PropertyDef(label = "鍒╂伅鏀跺叆鏈湡浣欓(鍏�)" ) + @Column(name = "lxsrbqye") + private Double lxsrbqye; + + @PropertyDef(label = "鍒╂伅鏀跺叆鏈勾绱(鍏�)" ) + @Column(name = "lxsrbnlj") + private Double lxsrbnlj; + + @PropertyDef(label = "鍔狅細鍏朵粬鏀剁泭鏈湡浣欓(鍏�)" ) + @Column(name = "qtsybqye") + private Double qtsybqye; + + @PropertyDef(label = "鍔狅細鍏朵粬鏀剁泭鏈勾绱(鍏�)" ) + @Column(name = "qtsybnlj") + private Double qtsybnlj; + + @PropertyDef(label = "鎶曡祫鏀剁泭(鎹熷け浠モ��-鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "tzsybqye") + private Double tzsybqye; + + @PropertyDef(label = "鎶曡祫鏀剁泭(鎹熷け浠モ��-鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "tzsybnlj") + private Double tzsybnlj; + + @PropertyDef(label = "鍏朵腑锛氬鑱旇惀浼佷笟鍜屽悎钀ヤ紒涓氱殑鎶曡祫鏀剁泭鏈湡浣欓(鍏�)" ) + @Column(name = "lyqytzsybqye") + private Double lyqytzsybqye; + + @PropertyDef(label = "鍏朵腑锛氬鑱旇惀浼佷笟鍜屽悎钀ヤ紒涓氱殑鎶曡祫鏀剁泭鏈勾绱(鍏�)" ) + @Column(name = "lyqytzsybnlj") + private Double lyqytzsybnlj; + + @PropertyDef(label = "鍏厑浠峰�煎彉鍔ㄦ敹鐩�(鎹熷け浠モ��-鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "gyjzbdsybqye") + private Double gyjzbdsybqye; + + @PropertyDef(label = "鍏厑浠峰�煎彉鍔ㄦ敹鐩�(鎹熷け浠モ��-鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "gyjzbdsybnlj") + private Double gyjzbdsybnlj; + + @PropertyDef(label = "璧勪骇鍑忓�兼崯澶�(鎹熷け浠モ��-鈥濆~鍒�)鏈湡浣欓(鍏�)" ) + @Column(name = "zcjzssbqye") + private Double zcjzssbqye; + + @PropertyDef(label = "鏈勾绱(鍏�)" ) + @Column(name = "zcjzssbnlj") + private Double zcjzssbnlj; + + @PropertyDef(label = "璧勪骇澶勭疆鏀剁泭(鎹熷け浠モ��-鈥濆~鍒�)鏈湡浣欓(鍏�)" ) + @Column(name = "zcczsybqye") + private Double zcczsybqye; + + @PropertyDef(label = "璧勪骇澶勭疆鏀剁泭(鎹熷け浠モ��-鈥濆~鍒�)鏈勾绱(鍏�)" ) + @Column(name = "zcczsybnlj") + private Double zcczsybnlj; + + @PropertyDef(label = "浜屻�佽惀涓氬埄娑�(浜忔崯浠モ�滐紞鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "yylrbqye") + private Double yylrbqye; + + @PropertyDef(label = "浜屻�佽惀涓氬埄娑�(浜忔崯浠モ�滐紞鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "yylrbnlj") + private Double yylrbnlj; + + @PropertyDef(label = "鍔狅細钀ヤ笟澶栨敹鍏ユ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "yywsrbqye") + private Double yywsrbqye; + + @PropertyDef(label = "鍔狅細钀ヤ笟澶栨敹鍏ユ湰骞寸疮璁�(鍏�)" ) + @Column(name = "yywsrbnlj") + private Double yywsrbnlj; + + @PropertyDef(label = "鍑忥細钀ヤ笟澶栨敮鍑烘湰鏈熶綑棰�(鍏�)" ) + @Column(name = "yywzcbqye") + private Double yywzcbqye; + + @PropertyDef(label = "鍑忥細钀ヤ笟澶栨敮鍑烘湰骞寸疮璁�(鍏�)" ) + @Column(name = "yywzcbnlj") + private Double yywzcbnlj; + + @PropertyDef(label = "涓夈�佸埄娑︽�婚(浜忔崯鎬婚浠モ�滐紞鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "lrzebqye") + private Double lrzebqye; + + @PropertyDef(label = "涓夈�佸埄娑︽�婚(浜忔崯鎬婚浠モ�滐紞鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "lrzebnlj") + private Double lrzebnlj; + + @PropertyDef(label = "鍑忥細鎵�寰楃◣璐圭敤鏈湡浣欓(鍏�)" ) + @Column(name = "sdsfybqye") + private Double sdsfybqye; + + @PropertyDef(label = "鍑忥細鎵�寰楃◣璐圭敤鏈勾绱(鍏�)" ) + @Column(name = "sdsfybnlj") + private Double sdsfybnlj; + + @PropertyDef(label = "鍥涖�佸噣鍒╂鼎(鍑�浜忔崯浠モ�滐紞鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "jlrbqye") + private Double jlrbqye; + + @PropertyDef(label = "鍥涖�佸噣鍒╂鼎(鍑�浜忔崯浠モ�滐紞鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "jlrbnlj") + private Double jlrbnlj; + + @PropertyDef(label = "鎸佺画缁忚惀鍑�鍒╂鼎(鍑�浜忔崯浠モ��-鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "cxjyjlrbqye") + private Double cxjyjlrbqye; + + @PropertyDef(label = "鎸佺画缁忚惀鍑�鍒╂鼎(鍑�浜忔崯浠モ��-鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "cxjyjlrbnlj") + private Double cxjyjlrbnlj; + + @PropertyDef(label = "缁堟缁忚惀鍑�鍒╂鼎(鍑�浜忔崯浠モ��-鈥濆彿濉垪)鏈湡浣欓(鍏�)" ) + @Column(name = "zzjyjlrbqye") + private Double zzjyjlrbqye; + + @PropertyDef(label = "缁堟缁忚惀鍑�鍒╂鼎(鍑�浜忔崯浠モ��-鈥濆彿濉垪)鏈勾绱(鍏�)" ) + @Column(name = "zzjyjlrbnlj") + private Double zzjyjlrbnlj; + + @PropertyDef(label = "浜斻�佸叾浠栫患鍚堟敹鐩婄殑绋庡悗鍑�棰濇湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qtzhsyjebqye") + private Double qtzhsyjebqye; + + @PropertyDef(label = "浜斻�佸叾浠栫患鍚堟敹鐩婄殑绋庡悗鍑�棰濇湰骞寸疮璁�(鍏�)" ) + @Column(name = "qtzhsyjebnlj") + private Double qtzhsyjebnlj; + + @PropertyDef(label = "(涓�)涓嶈兘閲嶅垎绫昏繘鎹熺泭鐨勫叾浠栫患鍚堟敹鐩婃湰鏈熶綑棰�(鍏�)" ) + @Column(name = "bnflzhsybqye") + private Double bnflzhsybqye; + + @PropertyDef(label = "(涓�)涓嶈兘閲嶅垎绫昏繘鎹熺泭鐨勫叾浠栫患鍚堟敹鐩婃湰骞寸疮璁�(鍏�)" ) + @Column(name = "bnflzhsybnlj") + private Double bnflzhsybnlj; + + @PropertyDef(label = "1.閲嶆柊璁¢噺璁惧畾鍙楃泭璁″垝鍙樺姩棰濇湰鏈熶綑棰�(鍏�)" ) + @Column(name = "cxjlbdebqye") + private Double cxjlbdebqye; + + @PropertyDef(label = "1.閲嶆柊璁¢噺璁惧畾鍙楃泭璁″垝鍙樺姩棰濇湰骞寸疮璁�(鍏�)" ) + @Column(name = "cxjlbdebnlj") + private Double cxjlbdebnlj; + + @PropertyDef(label = "2.鏉冪泭娉曚笅涓嶈兘杞崯鐩婄殑鍏朵粬缁煎悎鏀剁泭鏈湡浣欓(鍏�)" ) + @Column(name = "qyfbnzsybqye") + private Double qyfbnzsybqye; + + @PropertyDef(label = "2.鏉冪泭娉曚笅涓嶈兘杞崯鐩婄殑鍏朵粬缁煎悎鏀剁泭鏈勾绱(鍏�)" ) + @Column(name = "qyfbnzsybnlj") + private Double qyfbnzsybnlj; + + @PropertyDef(label = "3.鍏朵粬鏉冪泭宸ュ叿鎶曡祫鍏厑浠峰�煎彉鍔ㄦ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qtqygjjzbdbqye") + private Double qtqygjjzbdbqye; + + @PropertyDef(label = "3.鍏朵粬鏉冪泭宸ュ叿鎶曡祫鍏厑浠峰�煎彉鍔ㄦ湰骞寸疮璁�(鍏�)" ) + @Column(name = "qtqygjjzbdbnlj") + private Double qtqygjjzbdbnlj; + + @PropertyDef(label = "4.浼佷笟鑷韩淇$敤椋庨櫓鍏厑浠峰�煎彉鍔ㄦ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qyxyfxbdbqye") + private Double qyxyfxbdbqye; + + @PropertyDef(label = "4.浼佷笟鑷韩淇$敤椋庨櫓鍏厑浠峰�煎彉鍔ㄦ湰骞寸疮璁�(鍏�)" ) + @Column(name = "qyxyfxbdbnlj") + private Double qyxyfxbdbnlj; + + @PropertyDef(label = "5.鍏朵粬鏈湡浣欓(鍏�)" ) + @Column(name = "bnflzhsyqtbqye") + private Double bnflzhsyqtbqye; + + @PropertyDef(label = "5.鍏朵粬鏈勾绱(鍏�)" ) + @Column(name = "bnflzhsyqtbnlj") + private Double bnflzhsyqtbnlj; + + @PropertyDef(label = "1.鏉冪泭娉曚笅鍙浆鎹熺泭鐨勫叾浠栫患鍚堟敹鐩婃湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qyfkzsybqye") + private Double qyfkzsybqye; + + @PropertyDef(label = "1.鏉冪泭娉曚笅鍙浆鎹熺泭鐨勫叾浠栫患鍚堟敹鐩婃湰骞寸疮璁�(鍏�)" ) + @Column(name = "qyfkzsybnlj") + private Double qyfkzsybnlj; + + @PropertyDef(label = "2.鍏朵粬鍊烘潈鎶曡祫鍏厑浠峰�煎彉鍔ㄦ湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qtzqjzbdbqye") + private Double qtzqjzbdbqye; + + @PropertyDef(label = "2.鍏朵粬鍊烘潈鎶曡祫鍏厑浠峰�煎彉鍔ㄦ湰骞寸疮璁�(鍏�)" ) + @Column(name = "qtzqjzbdbnlj") + private Double qtzqjzbdbnlj; + + @PropertyDef(label = "3.鍙緵鍑哄敭閲戣瀺璧勪骇鍏厑浠峰�煎彉鍔ㄦ崯鐩婃湰鏈熶綑棰�(鍏�)" ) + @Column(name = "kgcszcbdsybqye") + private Double kgcszcbdsybqye; + + @PropertyDef(label = "3.鍙緵鍑哄敭閲戣瀺璧勪骇鍏厑浠峰�煎彉鍔ㄦ崯鐩婃湰骞寸疮璁�(鍏�)" ) + @Column(name = "kgcszcbdsybnlj") + private Double kgcszcbdsybnlj; + + @PropertyDef(label = "4.閲戣瀺璧勪骇閲嶅垎绫昏鍏ュ叾浠栫患鍚堟敹鐩婄殑閲戦鏈湡浣欓(鍏�)" ) + @Column(name = "jrzcflsyjebqye") + private Double jrzcflsyjebqye; + + @PropertyDef(label = "4.閲戣瀺璧勪骇閲嶅垎绫昏鍏ュ叾浠栫患鍚堟敹鐩婄殑閲戦鏈勾绱(鍏�)" ) + @Column(name = "jrzcflsyjebnlj") + private Double jrzcflsyjebnlj; + + @PropertyDef(label = "5.鎸佹湁鑷冲埌鏈熸姇璧勯噸鍒嗙被涓哄彲渚涘嚭鍞噾铻嶈祫浜ф崯鐩婃湰鏈熶綑棰�(鍏�)" ) + @Column(name = "cydqtzzcsybqye") + private Double cydqtzzcsybqye; + + @PropertyDef(label = "5.鎸佹湁鑷冲埌鏈熸姇璧勯噸鍒嗙被涓哄彲渚涘嚭鍞噾铻嶈祫浜ф崯鐩婃湰骞寸疮璁�(鍏�)" ) + @Column(name = "cydqtzzcsybnlj") + private Double cydqtzzcsybnlj; + + @PropertyDef(label = "6.鍏朵粬鍊烘潈鎶曡祫淇$敤鍑忓�煎噯澶囨湰鏈熶綑棰�(鍏�)" ) + @Column(name = "qtzqtzjzbqye") + private Double qtzqtzjzbqye; + + @PropertyDef(label = "6.鍏朵粬鍊烘潈鎶曡祫淇$敤鍑忓�煎噯澶囨湰骞寸疮璁�(鍏�)" ) + @Column(name = "qtzqtzjzbnlj") + private Double qtzqtzjzbnlj; + + @PropertyDef(label = "7.鐜伴噾娴侀噺濂楁湡鎹熺泭鐨勬湁鏁堥儴鍒嗘湰鏈熶綑棰�(鍏�)" ) + @Column(name = "zjllsybqye") + private Double zjllsybqye; + + @PropertyDef(label = "7.鐜伴噾娴侀噺濂楁湡鎹熺泭鐨勬湁鏁堥儴鍒嗘湰骞寸疮璁�(鍏�)" ) + @Column(name = "zjllsybnlj") + private Double zjllsybnlj; + + @PropertyDef(label = "8.澶栧竵璐㈠姟鎶ヨ〃鎶樼畻宸鏈湡浣欓(鍏�)" ) + @Column(name = "wbcwbbcebqye") + private Double wbcwbbcebqye; + + @PropertyDef(label = "8.澶栧竵璐㈠姟鎶ヨ〃鎶樼畻宸鏈勾绱(鍏�)" ) + @Column(name = "wbcwbbcebnlj") + private Double wbcwbbcebnlj; + + @PropertyDef(label = "9.鍏朵粬鏈湡浣欓(鍏�)" ) + @Column(name = "cflsybqye") + private Double cflsybqye; + + @PropertyDef(label = "9.鍏朵粬鏈勾绱(鍏�)" ) + @Column(name = "cflsybnlj") + private Double cflsybnlj; + + @PropertyDef(label = "鍏�佺患鍚堟敹鐩婃�婚鏈湡浣欓(鍏�)" ) + @Column(name = "zhsyzebqye") + private Double zhsyzebqye; + + @PropertyDef(label = "鍏�佺患鍚堟敹鐩婃�婚鏈勾绱(鍏�)" ) + @Column(name = "zhsyzebnlj") + private Double zhsyzebnlj; + + @PropertyDef(label = "涓冦�佹瘡鑲℃敹鐩婏細鏈湡浣欓(鍏�)" ) + @Column(name = "mgsybqye") + private Double mgsybqye; + + @PropertyDef(label = "涓冦�佹瘡鑲℃敹鐩婏細鏈勾绱(鍏�)" ) + @Column(name = "mgsybnlj") + private Double mgsybnlj; + + @PropertyDef(label = "(涓�)鍩烘湰姣忚偂鏀剁泭鏈湡浣欓(鍏�)" ) + @Column(name = "jbmgsybqye") + private Double jbmgsybqye; + + @PropertyDef(label = "(涓�)鍩烘湰姣忚偂鏀剁泭鏈勾绱(鍏�)" ) + @Column(name = "jbmgsybnlj") + private Double jbmgsybnlj; + + @PropertyDef(label = "(浜�)绋�閲婃瘡鑲℃敹鐩婃湰鏈熶綑棰�(鍏�)" ) + @Column(name = "xsmgsybqye") + private Double xsmgsybqye; + + @PropertyDef(label = "(浜�)绋�閲婃瘡鑲℃敹鐩婃湰骞寸疮璁�(鍏�)" ) + @Column(name = "xsmgsybnlj") + private Double xsmgsybnlj; + + @PropertyDef(label = "鏈�鍚庢洿鏂版椂闂�" ) + @Column(name = "zhgxsj") + private Date zhgxsj; + +} \ No newline at end of file diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1501.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1501.java new file mode 100644 index 0000000..4ccdda2 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1501.java @@ -0,0 +1,82 @@ +package com.fzzy.async.fzzy40.impl; + +import com.fzzy.api.Constant; +import com.fzzy.api.entity.Api1501; +import com.fzzy.api.entity.ApiLog; +import com.fzzy.api.utils.ContextUtil; +import com.fzzy.api.view.repository.Api1501Rep; +import com.fzzy.api.view.repository.ApiLogRep; +import com.fzzy.async.fzzy40.entity.Fz40AssetsLiability; +import com.fzzy.async.fzzy40.repository.Fzzy40Sync1501Rep; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Component; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-璧勪骇璐熷�� + * + * @author czt + * @date 2024-01-12 18:55 + */ +@Slf4j +@Component +public class Fzzy40Sync1501 { + + @Autowired + private Fzzy40Sync1501Rep fzzy40Sync1501Rep; + @Autowired + private Api1501Rep api1501Rep; + @Autowired + private ApiLogRep apiLogRep; + + /** + * 鍚屾骞跺皝瑁呬繚瀛樿川妫�鏁版嵁 + * + * @param deptId 绯荤粺瀵瑰簲搴撳尯缂栫爜 + * @param start 璧峰鏃堕棿 + * @param end 鎴鏃堕棿 + */ + public void syncData(String kqdm, String deptId, Date start, Date end) { + log.info("-------------1501鎺ュ彛鏁版嵁寮�濮嬪悓姝�------------------"); + //鍚屾鏁版嵁锛屽彧璁板綍澶辫触鐨勪俊鎭� + ApiLog apiLog = new ApiLog(); + apiLog.setType(ApiLog.TYPE_SYNC); + apiLog.setKqdm(kqdm); + apiLog.setUploadTime(new Date()); + apiLog.setInteId(Constant.API_CODE_1304); + apiLog.setStatus(99); + apiLog.setId(ContextUtil.getUUID()); + try { + List<Fz40AssetsLiability> list = fzzy40Sync1501Rep.findDateByTime(start, end); + + if (null == list || list.isEmpty()) { + return; + } + + Api1501 api1501; + List<Api1501> api1501List; + for (Fz40AssetsLiability sysData : list) { + api1501 = new Api1501(); + BeanUtils.copyProperties(sysData, api1501); + api1501.setDwdm(kqdm.substring(0, 18)); + api1501.setKqdm(kqdm); + + api1501List = api1501Rep.findDateById(api1501.getId()); + if(null == api1501List || api1501List.isEmpty()){ + api1501.setCzbz(Constant.CZBZ_I); + }else { + api1501.setCzbz(api1501List.get(0).getCzbz()); + } + api1501Rep.save(api1501); + } + } catch (Exception e) { + log.error("---鍚屾澶辫触----{}", e); + apiLog.setResult("鍚屾澶辫触锛�" + e.getMessage()); + apiLogRep.save(apiLog); + } + } + +} \ No newline at end of file diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1502.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1502.java new file mode 100644 index 0000000..27a7876 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1502.java @@ -0,0 +1,82 @@ +package com.fzzy.async.fzzy40.impl; + +import com.fzzy.api.Constant; +import com.fzzy.api.entity.Api1502; +import com.fzzy.api.entity.ApiLog; +import com.fzzy.api.utils.ContextUtil; +import com.fzzy.api.view.repository.Api1502Rep; +import com.fzzy.api.view.repository.ApiLogRep; +import com.fzzy.async.fzzy40.entity.Fz40CashFlow; +import com.fzzy.async.fzzy40.repository.Fzzy40Sync1502Rep; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Component; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-鐜伴噾娴� + * + * @author czt + * @date 2024-01-12 18:55 + */ +@Slf4j +@Component +public class Fzzy40Sync1502 { + + @Autowired + private Fzzy40Sync1502Rep fzzy40Sync1502Rep; + @Autowired + private Api1502Rep api1502Rep; + @Autowired + private ApiLogRep apiLogRep; + + /** + * 鍚屾骞跺皝瑁呬繚瀛樿川妫�鏁版嵁 + * + * @param deptId 绯荤粺瀵瑰簲搴撳尯缂栫爜 + * @param start 璧峰鏃堕棿 + * @param end 鎴鏃堕棿 + */ + public void syncData(String kqdm, String deptId, Date start, Date end) { + log.info("-------------1502鎺ュ彛鏁版嵁寮�濮嬪悓姝�------------------"); + //鍚屾鏁版嵁锛屽彧璁板綍澶辫触鐨勪俊鎭� + ApiLog apiLog = new ApiLog(); + apiLog.setType(ApiLog.TYPE_SYNC); + apiLog.setKqdm(kqdm); + apiLog.setUploadTime(new Date()); + apiLog.setInteId(Constant.API_CODE_1304); + apiLog.setStatus(99); + apiLog.setId(ContextUtil.getUUID()); + try { + List<Fz40CashFlow> list = fzzy40Sync1502Rep.findDateByTime(start, end); + + if (null == list || list.isEmpty()) { + return; + } + + Api1502 api1502; + List<Api1502> api1502List; + for (Fz40CashFlow sysData : list) { + api1502 = new Api1502(); + BeanUtils.copyProperties(sysData, api1502); + api1502.setDwdm(kqdm.substring(0, 18)); + api1502.setKqdm(kqdm); + + api1502List = api1502Rep.findDateById(api1502.getId()); + if(null == api1502List || api1502List.isEmpty()){ + api1502.setCzbz(Constant.CZBZ_I); + }else { + api1502.setCzbz(api1502List.get(0).getCzbz()); + } + api1502Rep.save(api1502); + } + } catch (Exception e) { + log.error("---鍚屾澶辫触----{}", e); + apiLog.setResult("鍚屾澶辫触锛�" + e.getMessage()); + apiLogRep.save(apiLog); + } + } + +} \ No newline at end of file diff --git a/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1503.java b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1503.java new file mode 100644 index 0000000..3a5fb1d --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/impl/Fzzy40Sync1503.java @@ -0,0 +1,82 @@ +package com.fzzy.async.fzzy40.impl; + +import com.fzzy.api.Constant; +import com.fzzy.api.entity.Api1503; +import com.fzzy.api.entity.ApiLog; +import com.fzzy.api.utils.ContextUtil; +import com.fzzy.api.view.repository.Api1503Rep; +import com.fzzy.api.view.repository.ApiLogRep; +import com.fzzy.async.fzzy40.entity.Fz40Profit; +import com.fzzy.async.fzzy40.repository.Fzzy40Sync1503Rep; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Component; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-鍒╂鼎 + * + * @author czt + * @date 2024-01-12 18:55 + */ +@Slf4j +@Component +public class Fzzy40Sync1503 { + + @Autowired + private Fzzy40Sync1503Rep fzzy40Sync1503Rep; + @Autowired + private Api1503Rep api1503Rep; + @Autowired + private ApiLogRep apiLogRep; + + /** + * 鍚屾骞跺皝瑁呬繚瀛樿川妫�鏁版嵁 + * + * @param deptId 绯荤粺瀵瑰簲搴撳尯缂栫爜 + * @param start 璧峰鏃堕棿 + * @param end 鎴鏃堕棿 + */ + public void syncData(String kqdm, String deptId, Date start, Date end) { + log.info("-------------1503鎺ュ彛鏁版嵁寮�濮嬪悓姝�------------------"); + //鍚屾鏁版嵁锛屽彧璁板綍澶辫触鐨勪俊鎭� + ApiLog apiLog = new ApiLog(); + apiLog.setType(ApiLog.TYPE_SYNC); + apiLog.setKqdm(kqdm); + apiLog.setUploadTime(new Date()); + apiLog.setInteId(Constant.API_CODE_1304); + apiLog.setStatus(99); + apiLog.setId(ContextUtil.getUUID()); + try { + List<Fz40Profit> list = fzzy40Sync1503Rep.findDateByTime(start, end); + + if (null == list || list.isEmpty()) { + return; + } + + Api1503 api1503; + List<Api1503> api1503List; + for (Fz40Profit sysData : list) { + api1503 = new Api1503(); + BeanUtils.copyProperties(sysData, api1503); + api1503.setDwdm(kqdm.substring(0, 18)); + api1503.setKqdm(kqdm); + + api1503List = api1503Rep.findDateById(api1503.getId()); + if(null == api1503List || api1503List.isEmpty()){ + api1503.setCzbz(Constant.CZBZ_I); + }else { + api1503.setCzbz(api1503List.get(0).getCzbz()); + } + api1503Rep.save(api1503); + } + } catch (Exception e) { + log.error("---鍚屾澶辫触----{}", e); + apiLog.setResult("鍚屾澶辫触锛�" + e.getMessage()); + apiLogRep.save(apiLog); + } + } + +} \ No newline at end of file diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1501Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1501Rep.java new file mode 100644 index 0000000..df456b6 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1501Rep.java @@ -0,0 +1,28 @@ +package com.fzzy.async.fzzy40.repository; + +import com.fzzy.async.fzzy40.entity.Fz40AssetsLiability; +import com.fzzy.async.fzzy40.entity.Fz40InoutPlan; +import org.springframework.data.jpa.repository.JpaRepository; +import org.springframework.data.jpa.repository.Query; +import org.springframework.data.repository.query.Param; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-璧勪骇璐熷�� + * + * @author czt + * @date 2024-01-12 09:55 + */ +public interface Fzzy40Sync1501Rep extends JpaRepository<Fz40AssetsLiability, String> { + + /** + * + * @param start + * @param end + * @return + */ + @Query("from Fz40AssetsLiability where zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") + List<Fz40AssetsLiability> findDateByTime(@Param("start") Date start, @Param("end") Date end); + +} diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1502Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1502Rep.java new file mode 100644 index 0000000..cfcca82 --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1502Rep.java @@ -0,0 +1,26 @@ +package com.fzzy.async.fzzy40.repository; + +import com.fzzy.async.fzzy40.entity.Fz40CashFlow; +import org.springframework.data.jpa.repository.JpaRepository; +import org.springframework.data.jpa.repository.Query; +import org.springframework.data.repository.query.Param; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-鐜伴噾娴� + * + * @author czt + * @date 2024-01-12 09:55 + */ +public interface Fzzy40Sync1502Rep extends JpaRepository<Fz40CashFlow, String> { + + /** + * + * @param start + * @param end + * @return + */ + @Query("from Fz40CashFlow where zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") + List<Fz40CashFlow> findDateByTime(@Param("start") Date start, @Param("end") Date end); +} diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1503Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1503Rep.java new file mode 100644 index 0000000..c747d7c --- /dev/null +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1503Rep.java @@ -0,0 +1,26 @@ +package com.fzzy.async.fzzy40.repository; + +import com.fzzy.async.fzzy40.entity.Fz40Profit; +import org.springframework.data.jpa.repository.JpaRepository; +import org.springframework.data.jpa.repository.Query; +import org.springframework.data.repository.query.Param; +import java.util.Date; +import java.util.List; + +/** + * 璐㈠姟绠$悊-鍒╂鼎 + * + * @author czt + * @date 2024-01-12 09:55 + */ +public interface Fzzy40Sync1503Rep extends JpaRepository<Fz40Profit, String> { + + /** + * + * @param start + * @param end + * @return + */ + @Query("from Fz40Profit where zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") + List<Fz40Profit> findDateByTime(@Param("start") Date start, @Param("end") Date end); +} diff --git a/src/main/java/com/fzzy/push/nx2023/NX2023ApiRemoteService.java b/src/main/java/com/fzzy/push/nx2023/NX2023ApiRemoteService.java index a01ceba..e446b22 100644 --- a/src/main/java/com/fzzy/push/nx2023/NX2023ApiRemoteService.java +++ b/src/main/java/com/fzzy/push/nx2023/NX2023ApiRemoteService.java @@ -251,8 +251,10 @@ return api1306; } if (NX2023Constant.NX_2023_API_CODE_1307.equals(inteId)) { + Api1307 apiData = (Api1307) data; Nx2023Api1307 api1307 = new Nx2023Api1307(); - BeanUtils.copyProperties(data, api1307); + BeanUtils.copyProperties(apiData, api1307); + api1307.setCntxwjl(FileUtils.fileToByteString(apiData.getWjdz())); return api1307; } if (NX2023Constant.NX_2023_API_CODE_1308.equals(inteId)) { diff --git a/src/main/java/com/fzzy/push/nx2023/dto/Nx2023Api1307.java b/src/main/java/com/fzzy/push/nx2023/dto/Nx2023Api1307.java index a6a29b5..067ecc2 100644 --- a/src/main/java/com/fzzy/push/nx2023/dto/Nx2023Api1307.java +++ b/src/main/java/com/fzzy/push/nx2023/dto/Nx2023Api1307.java @@ -27,6 +27,9 @@ @PropertyDef(label = "璐т綅浠g爜" ) private String hwdm; + @PropertyDef(label = "浠撳唴鍥惧儚鏂囦欢娴�" ) + private String cntxwjl; + @JSONField(format = "yyyy-MM-dd HH:mm:ss") @PropertyDef(label = "鎶撴媿鏃堕棿" ) private Date zpsj; diff --git a/src/main/resources/application-pro5016.yml b/src/main/resources/application-pro5016.yml index 2711c6e..80ee9a6 100644 --- a/src/main/resources/application-pro5016.yml +++ b/src/main/resources/application-pro5016.yml @@ -15,7 +15,7 @@ driver-class-name: com.mysql.jdbc.Driver #娆℃暟鎹簮 secondary: - url: jdbc:mysql://127.0.0.1:3306/igds_master?useUnicode=true&characterEncoding=utf-8 + url: jdbc:mysql://127.0.0.1:3306/igds_master_v40?useUnicode=true&characterEncoding=utf-8 username: root password: Abc123.. driver-class-name: com.mysql.jdbc.Driver -- Gitblit v1.9.3