陕西2025版接口调整5-新增功能数据同步,包含4.0版本和6.1版本
| | |
| | | public class Fzzy40SyncService12 implements SyncService12 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1109 fzzySync1109; |
| | | @Autowired |
| | | private Fzzy40Sync1201 fzzySync1201; |
| | | @Autowired |
| | | private Fzzy40Sync1202 fzzySync1202; |
| | |
| | | @Autowired |
| | | private Fzzy40Sync1209 fzzySync1209; |
| | | @Autowired |
| | | private Fzzy40Sync1211 fzzySync1211; |
| | | @Autowired |
| | | private Fzzy40Sync1210 fzzySync1210; |
| | | @Autowired |
| | | private Fzzy40Sync1211 fzzySync1211; |
| | | @Autowired |
| | | private Fzzy40Sync1212 fzzySync1212; |
| | | @Autowired |
| | | private Fzzy40Sync1213 fzzySync1213; |
| | | @Autowired |
| | | private Fzzy40Sync1109 fzzySync1109; |
| | | private Fzzy40Sync1214 fzzySync1214; |
| | | @Autowired |
| | | private Fzzy40Sync1215 fzzySync1215; |
| | | @Autowired |
| | | private Fzzy40Sync1216 fzzySync1216; |
| | | @Autowired |
| | | private Fzzy40Sync1217 fzzySync1217; |
| | | @Autowired |
| | | private Fzzy40Sync1218 fzzySync1218; |
| | | @Autowired |
| | | private Fzzy40Sync1219 fzzySync1219; |
| | | @Autowired |
| | | private Fzzy40Sync2102 fzzySync2102; |
| | | |
| | |
| | | //åä»åå
¥ä¿¡æ¯åæ¥ |
| | | fzzySync2102.syncData(kqdm, deptId, start, end); |
| | | } |
| | | //é西çå¹³å°2025ç |
| | | if (StringUtils.isNotEmpty(param.getPushProtocol()) && PushProtocol.SB_SX_2025.getCode().equals(param.getPushProtocol())) { |
| | | //å¨å¤ç²®ç©ºä»éªæ¶è¡¨ |
| | | fzzySync1214.syncData(kqdm, deptId, start, end); |
| | | //å¨å¤æ²¹ç©ºç½éªæ¶è¡¨ |
| | | fzzySync1215.syncData(kqdm, deptId, start, end); |
| | | //å¨å¤ç²®åä»éªæ¶è¡¨ |
| | | fzzySync1216.syncData(kqdm, deptId, start, end); |
| | | //è½®æ¢éªæ¶ä¿¡æ¯ |
| | | fzzySync1217.syncData(kqdm, deptId, start, end); |
| | | //å
¥åºææ¬æ ¸å®è¡¨ |
| | | fzzySync1218.syncData(kqdm, deptId, start, end); |
| | | //å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | fzzySync1219.syncData(kqdm, deptId, start, end); |
| | | } |
| | | |
| | | } |
| | | |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description 空ä»éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:06 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_DEPOT_EMPTY_CHECK") |
| | | public class Fz40DepotEmptyCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "kcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "空ä»éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "kcysdh", length = 14) |
| | | private String kcysdh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "æååç§ä»£ç ") |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "ç²®é£ç级代ç ") |
| | | @Column(name = "lsdjdm", length = 3) |
| | | private String lsdjdm; |
| | | |
| | | @PropertyDef(label = "设计ä»å®¹") |
| | | @Column(name = "sjcr", precision = 20, scale = 3) |
| | | private Double sjcr; |
| | | |
| | | @PropertyDef(label = "å®é
å¨ç²®åç§æå¤§ä»å®¹") |
| | | @Column(name = "sjclzdcr", precision = 20, scale = 3) |
| | | private Double sjclzdcr; |
| | | |
| | | @PropertyDef(label = "æå¨ç²®æ°é") |
| | | @Column(name = "jysj", precision = 20, scale = 3) |
| | | private Double jysj; |
| | | |
| | | @PropertyDef(label = "å¨åæ¹å¼", description = "1-å
è£
2-æ£è£
3-å
å´æ£å") |
| | | @Column(name = "jydw", length = 1) |
| | | private String jydw; |
| | | |
| | | @PropertyDef(label = "仿¿å°åªå®å¥½æ
åµ") |
| | | @Column(name = "dpwhqk", length = 128) |
| | | private String dpwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿å¢ä½å®å¥½æ
åµ") |
| | | @Column(name = "qtwhqk", length = 128) |
| | | private String qtwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿å±é¢å®å¥½æ
åµ") |
| | | @Column(name = "wmwhqk", length = 128) |
| | | private String wmwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿é¨çªå®å¥½æ
åµ") |
| | | @Column(name = "mcwhqk", length = 128) |
| | | private String mcwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿æ¯å¦æ
èªæ¹å仿¿ç»æ") |
| | | @Column(name = "sfszgd", length = 128) |
| | | private String sfszgd; |
| | | |
| | | @PropertyDef(label = "é²éç½å®å¥½æ
åµ") |
| | | @Column(name = "fqwwhqk", length = 128) |
| | | private String fqwwhqk; |
| | | |
| | | @PropertyDef(label = "é²è«çº¿å®å¥½æ
åµ") |
| | | @Column(name = "fcxwhqk", length = 128) |
| | | private String fcxwhqk; |
| | | |
| | | @PropertyDef(label = "é²é¼ æ¿å®å¥½æ
åµ") |
| | | @Column(name = "fsbwhqk", length = 128) |
| | | private String fsbwhqk; |
| | | |
| | | @PropertyDef(label = "éé£ææ¯ææ®µ") |
| | | @Column(name = "tfjssd", length = 128) |
| | | private String tfjssd; |
| | | |
| | | @PropertyDef(label = "éé£ç³»ç»æ¯å¦å®å¥½") |
| | | @Column(name = "tfxtsfwh", length = 128) |
| | | private String tfxtsfwh; |
| | | |
| | | @PropertyDef(label = "çè¸ææ¯ææ®µ") |
| | | @Column(name = "xzjssd", length = 128) |
| | | private String xzjssd; |
| | | |
| | | @PropertyDef(label = "ç²®æ
æ£æµææ®µ") |
| | | @Column(name = "lqjcsd", length = 128) |
| | | private String lqjcsd; |
| | | |
| | | @PropertyDef(label = "ç²®æ
æ£æµç³»ç»æ¯å¦å®å¥½") |
| | | @Column(name = "lqjcxtsfwh", length = 128) |
| | | private String lqjcxtsfwh; |
| | | |
| | | @PropertyDef(label = "ä»é¨æ¡£ç²®è®¾æ½æ¯å¦å®å¥½") |
| | | @Column(name = "cmdlsssfwh", length = 128) |
| | | private String cmdlsssfwh; |
| | | |
| | | @PropertyDef(label = "æ¯å¦æ¸
æ¶") |
| | | @Column(name = "sfqx", length = 128) |
| | | private String sfqx; |
| | | |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @PropertyDef(label = "æ´æ¹æè§") |
| | | @Column(name = "zgyj", length = 128) |
| | | private String zgyj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description å
¥åºææ¬æ ¸å® |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:18 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_COST_VERIFY") |
| | | public class Fz40InoutCostVerify implements Serializable { |
| | | |
| | | public static String SORT_PROP = "rkhddh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "å
¥åºæ ¸å®åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "rkhddh", length = 14) |
| | | private String rkhddh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "æå±ååº") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "å¨ç²®åç§ä»£ç " ) |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "æ ¸å®åä»·" ) |
| | | @Column(name = "hddj", precision = 20, scale = 3) |
| | | private Double hddj; |
| | | |
| | | @PropertyDef(label = "æ ¸å®æ°é" ) |
| | | @Column(name = "hdsl", precision = 20, scale = 3) |
| | | private Double hdsl; |
| | | |
| | | @PropertyDef(label = "ç²®é£æ§è´¨" ) |
| | | @Column(name = "lsxz", length = 3) |
| | | private String lsxz; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥åä½" ) |
| | | @Column(name = "tbdw", length = 512) |
| | | private String tbdw; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å¡«æ¥æ¶é´") |
| | | @Column(name = "tbsj") |
| | | private Date tbsj; |
| | | |
| | | @PropertyDef(label = "åä½è´è´£äºº") |
| | | @Column(name = "dwfzr", length = 512) |
| | | private String dwfzr; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥äºº") |
| | | @Column(name = "tbr", length = 512) |
| | | private String tbr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "REMARKS_", length = 512) |
| | | private String remarks; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description å
¥åºææ¬æ ¸å®æç» |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:20 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_COST_VERIFY_ITEM") |
| | | public class Fz40InoutCostVerifyItem implements Serializable { |
| | | |
| | | public static String SORT_PROP = "rkhddh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "å
¥åºæ ¸å®åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "rkhddh", length = 14) |
| | | private String rkhddh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "å¨ç²®åç§ä»£ç " ) |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "贷款éé¢" ) |
| | | @Column(name = "dkje", precision = 20, scale = 3) |
| | | private Double dkje; |
| | | |
| | | @PropertyDef(label = "æ¶è·å¹´åº¦" ) |
| | | @Column(name = "shnd", length = 4) |
| | | private String shnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥åä½" ) |
| | | @Column(name = "tbdw", length = 512) |
| | | private String tbdw; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å¡«æ¥æ¶é´") |
| | | @Column(name = "tbsj") |
| | | private Date tbsj; |
| | | |
| | | @PropertyDef(label = "åä½è´è´£äºº") |
| | | @Column(name = "dwfzr", length = 512) |
| | | private String dwfzr; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥äºº") |
| | | @Column(name = "tbr", length = 512) |
| | | private String tbr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "REMARKS_", length = 512) |
| | | private String remarks; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description åä»éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:13 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_STOCK_CHECK") |
| | | public class Fz40InoutStockCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "dcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "åä»éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "dcysdh", length = 14) |
| | | private String dcysdh; |
| | | |
| | | @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 = "ccdw", length = 256) |
| | | private String ccdw; |
| | | |
| | | @PropertyDef(label = "计åæå·") |
| | | @Column(name = "jhwh", length = 14) |
| | | private String jhwh; |
| | | |
| | | @PropertyDef(label = "ååºè´§ä½" ) |
| | | @Column(name = "dchwbm", length = 30) |
| | | private String dchwbm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£åç§ä»£ç " ) |
| | | @Column(name = "dclspzdm", length = 7) |
| | | private String dclspzdm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£ç级代ç " ) |
| | | @Column(name = "dclsdjdm", length = 2) |
| | | private String dclsdjdm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£ç产年度" ) |
| | | @Column(name = "dclsscnd", length = 4) |
| | | private String dclsscnd; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£æ°é(å¨)" ) |
| | | @Column(name = "dclssl", precision = 20, scale = 3) |
| | | private Double dclssl; |
| | | |
| | | @PropertyDef(label = "åå
¥è´§ä½" ) |
| | | @Column(name = "drhwdm", length = 30) |
| | | private String drhwbm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£åç§ä»£ç " ) |
| | | @Column(name = "drlspzdm", length = 7) |
| | | private String drlspzdm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£ç级代ç " ) |
| | | @Column(name = "drlsdjdm", length = 2) |
| | | private String drlsdjdm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£æ°é(å¨)" ) |
| | | @Column(name = "drlssl", precision = 20, scale = 3) |
| | | private Double drlssl; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£åºåææ¬(å
/å¨)" ) |
| | | @Column(name = "drlskccb", precision = 20, scale = 3) |
| | | private Double drlskccb; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£ç产年度" ) |
| | | @Column(name = "drlsscnd", length = 4) |
| | | private String drlsscnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "åä»å®ææ¶é´") |
| | | @Column(name = "wcsj") |
| | | private Date wcsj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd") |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description 空ç½éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:09 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_OIL_EMPTY_CHECK") |
| | | public class Fz40OilEmptyCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "kgysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "空ç½éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "kgysdh", length = 14) |
| | | private String kgysdh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "æååç§ä»£ç ") |
| | | @Column(name = "ncpzdm", length = 7) |
| | | private String ncpzdm; |
| | | |
| | | @PropertyDef(label = "设计ç容") |
| | | @Column(name = "sjgr", precision = 20, scale = 3) |
| | | private Double sjgr; |
| | | |
| | | @PropertyDef(label = "å®é
卿²¹åç§æå¤§ç½å®¹") |
| | | @Column(name = "sjcyzdgr", precision = 20, scale = 3) |
| | | private Double sjcyzdgr; |
| | | |
| | | @PropertyDef(label = "æå¨æ²¹æ°é") |
| | | @Column(name = "jysj", precision = 20, scale = 3) |
| | | private Double jysj; |
| | | |
| | | @PropertyDef(label = "æ¯å¦æ
èªæ¹åæ²¹ç½ç»æ") |
| | | @Column(name = "sfszgdygjg", length = 128) |
| | | private String sfszgdygjg; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½ææ æ¸æ¼éè") |
| | | @Column(name = "ygywslxs", length = 128) |
| | | private String ygywslxs; |
| | | |
| | | @PropertyDef(label = "ç½åºææ å¼è£ã䏿²ç°è±¡") |
| | | @Column(name = "gjywklxcxx", length = 128) |
| | | private String gjywklxcxx; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½å°åªæ¯å¦å®å
¨ç¡¬å") |
| | | @Column(name = "ygdpsfwqyh", length = 128) |
| | | private String ygdpsfwqyh; |
| | | |
| | | @PropertyDef(label = "æ¤æ²¹å ¤æ¯å¦åå¨å¼è£ç¼ºå£çæ
åµ") |
| | | @Column(name = "hydsfzc", length = 128) |
| | | private String hydsfzc; |
| | | |
| | | @PropertyDef(label = "ç½åºå
ææ°´ææ é鍿§å¶") |
| | | @Column(name = "gtfmsfzc", length = 128) |
| | | private String gtfmsfzc; |
| | | |
| | | @PropertyDef(label = "ç½å
æ¯å¦æ¸
æ´") |
| | | @Column(name = "gnsfqj", length = 128) |
| | | private String gnsfqj; |
| | | |
| | | @PropertyDef(label = "ç¬æ¢¯æ¯å¦å®å
¨") |
| | | @Column(name = "ptsfaq", length = 128) |
| | | private String ptsfaq; |
| | | |
| | | @PropertyDef(label = "çé¡¶å®å
¨æ¤æ æ¯å¦å®å¥½") |
| | | @Column(name = "gdaqhlsfwh", length = 128) |
| | | private String gdaqhlsfwh; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½åºæ¯å¦å¤äºä½æ´¼ç¹") |
| | | @Column(name = "gqsfcydwd", length = 128) |
| | | private String gqsfcydwd; |
| | | |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @PropertyDef(label = "æ´æ¹æè§") |
| | | @Column(name = "zgyj", length = 128) |
| | | private String zgyj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:16 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_PLAN_CHECK") |
| | | public class Fz40PlanCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "dcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "è½®æ¢éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "dcysdh", length = 14) |
| | | private String dcysdh; |
| | | |
| | | @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 = "ccdw", length = 256) |
| | | private String ccdw; |
| | | |
| | | @PropertyDef(label = "计åæå·") |
| | | @Column(name = "jhwh", length = 14) |
| | | private String jhwh; |
| | | |
| | | @PropertyDef(label = "计åå®æè´§ä½ç¼ç " ) |
| | | @Column(name = "dchwbm", length = 30) |
| | | private String dchwbm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£åç§ä»£ç " ) |
| | | @Column(name = "dclspzdm", length = 7) |
| | | private String dclspzdm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£ç级代ç " ) |
| | | @Column(name = "dclsdjdm", length = 2) |
| | | private String dclsdjdm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£ç产年度" ) |
| | | @Column(name = "dclsscnd", length = 4) |
| | | private String dclsscnd; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£æ°é(å¨)" ) |
| | | @Column(name = "dclssl", precision = 20, scale = 3) |
| | | private Double dclssl; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡è´§ä½ç¼ç " ) |
| | | @Column(name = "drhwbm", length = 30) |
| | | private String drhwbm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£åç§ä»£ç " ) |
| | | @Column(name = "drlspzdm", length = 7) |
| | | private String drlspzdm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£ç级代ç " ) |
| | | @Column(name = "drlsdjdm", length = 2) |
| | | private String drlsdjdm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£æ°é(å¨)" ) |
| | | @Column(name = "drlssl", precision = 20, scale = 3) |
| | | private Double drlssl; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£åºåææ¬(å
/å¨)" ) |
| | | @Column(name = "drlskccb", precision = 20, scale = 3) |
| | | private Double drlskccb; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£ç产年度" ) |
| | | @Column(name = "drlsscnd", length = 4) |
| | | private String drlsscnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å®é
æ§è¡å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å®é
æ§è¡å®ææ¶é´") |
| | | @Column(name = "wcsj") |
| | | private Date wcsj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd") |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1214; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1214Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40DepotEmptyCheck; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1214Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:26 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1214 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1214Rep fzzy40Sync1214Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1214Rep api1214Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1214æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40DepotEmptyCheck> list = fzzy40Sync1214Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1214 apiData; |
| | | Api1105 api1105; |
| | | List<Api1214> api1214List; |
| | | for (Fz40DepotEmptyCheck depotEmptyCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(depotEmptyCheck.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1214(); |
| | | BeanUtils.copyProperties(depotEmptyCheck, apiData); |
| | | |
| | | apiData.setBizId(depotEmptyCheck.getKcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, depotEmptyCheck.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | //ç²®é£ç级 |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, depotEmptyCheck.getLsdjdm()); |
| | | apiData.setLsdjdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1214List = api1214Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1214List || api1214List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1214List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1214Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1215; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1215Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40OilEmptyCheck; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1215Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ç½éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:30 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1215 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1215Rep fzzy40Sync1215Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1215Rep api1215Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1215æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40OilEmptyCheck> list = fzzy40Sync1215Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1215 apiData; |
| | | Api1105 api1105; |
| | | List<Api1215> api1215List; |
| | | for (Fz40OilEmptyCheck oilEmptyCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(oilEmptyCheck.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1215(); |
| | | BeanUtils.copyProperties(oilEmptyCheck, apiData); |
| | | apiData.setBizId(oilEmptyCheck.getKgysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, oilEmptyCheck.getNcpzdm().substring(0, 3)); |
| | | apiData.setNcpzdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1215List = api1215Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1215List || api1215List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1215List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1215Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1216; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1216Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutStockCheck; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1216Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-åä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:32 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1216 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1216Rep fzzy40Sync1216Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1216Rep api1216Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1216æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40InoutStockCheck> list = fzzy40Sync1216Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1216 apiData; |
| | | Api1105 api1105In; |
| | | Api1105 api1105Out; |
| | | List<Api1216> api1216List; |
| | | for (Fz40InoutStockCheck inoutStockCheck : list) { |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105Out = commonService.getApi1105Cache(inoutStockCheck.getDchwbm()); |
| | | if (null == api1105Out) { |
| | | continue; |
| | | } |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105In = commonService.getApi1105Cache(inoutStockCheck.getDrhwbm()); |
| | | if (null == api1105In) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1216(); |
| | | BeanUtils.copyProperties(inoutStockCheck, apiData); |
| | | apiData.setBizId(inoutStockCheck.getDcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setDchwbm(api1105Out.getHwdm()); |
| | | apiData.setDrhwbm(api1105In.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutStockCheck.getDclspzdm().substring(0, 3)); |
| | | apiData.setDclspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, inoutStockCheck.getDclsdjdm()); |
| | | apiData.setDclsdjdm(mappingCode); |
| | | |
| | | //ç²®é£åç§ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutStockCheck.getDrlspzdm().substring(0, 3)); |
| | | apiData.setDrlspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, inoutStockCheck.getDrlsdjdm()); |
| | | apiData.setDrlsdjdm(mappingCode); |
| | | |
| | | api1216List = api1216Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1216List || api1216List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1216List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1216Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1217; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1217Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40PlanCheck; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1217Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:43 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1217 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1217Rep fzzy40Sync1217Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1217Rep api1217Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1217æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40PlanCheck> list = fzzy40Sync1217Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1217 apiData; |
| | | Api1105 api1105In; |
| | | Api1105 api1105Out; |
| | | List<Api1217> api1217List; |
| | | for (Fz40PlanCheck planCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105Out = commonService.getApi1105Cache(planCheck.getDchwbm()); |
| | | if (null == api1105Out) { |
| | | continue; |
| | | } |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105In = commonService.getApi1105Cache(planCheck.getDrhwbm()); |
| | | if (null == api1105In) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1217(); |
| | | BeanUtils.copyProperties(planCheck, apiData); |
| | | apiData.setBizId(planCheck.getDcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setDchwbm(api1105Out.getHwdm()); |
| | | apiData.setDrhwbm(api1105In.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, planCheck.getDclspzdm().substring(0, 3)); |
| | | apiData.setDclspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, planCheck.getDclsdjdm()); |
| | | apiData.setDclsdjdm(mappingCode); |
| | | |
| | | //ç²®é£åç§ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, planCheck.getDrlspzdm().substring(0, 3)); |
| | | apiData.setDrlspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, planCheck.getDrlsdjdm()); |
| | | apiData.setDrlsdjdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1217List = api1217Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1217List || api1217List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1217List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1217Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1218; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1218Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutCostVerify; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1218Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:15 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1218 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1218Rep fzzy40Sync1218Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1218Rep api1218Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1218æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40InoutCostVerify> list = fzzy40Sync1218Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1218 apiData; |
| | | Api1105 api1105; |
| | | List<Api1218> api1218List; |
| | | for (Fz40InoutCostVerify inoutCostVerify : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(inoutCostVerify.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1218(); |
| | | BeanUtils.copyProperties(inoutCostVerify, apiData); |
| | | apiData.setBizId(inoutCostVerify.getRkhddh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutCostVerify.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSXZ, inoutCostVerify.getLsxz()); |
| | | apiData.setLsxz(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1218List = api1218Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1218List || api1218List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1218List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1218Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1219; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1219Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutCostVerifyItem; |
| | | import com.fzzy.async.fzzy40.repository.Fzzy40Sync1219Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:17 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy40Sync1219 { |
| | | |
| | | @Autowired |
| | | private Fzzy40Sync1219Rep fzzy40Sync1219Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1219Rep api1219Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1219æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz40InoutCostVerifyItem> list = fzzy40Sync1219Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1219 apiData; |
| | | Api1105 api1105; |
| | | List<Api1219> api1219List; |
| | | for (Fz40InoutCostVerifyItem inoutCostVerifyItem : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(inoutCostVerifyItem.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1219(); |
| | | BeanUtils.copyProperties(inoutCostVerifyItem, apiData); |
| | | apiData.setBizId(inoutCostVerifyItem.getRkhddh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutCostVerifyItem.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1219List = api1219Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1219List || api1219List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1219List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1219Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | |
| | | import com.fzzy.async.fzzy40.entity.Fz40DepotEmptyCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:06 |
| | | */ |
| | | public interface Fzzy40Sync1214Rep extends JpaRepository<Fz40DepotEmptyCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·å空ä»éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40DepotEmptyCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40DepotEmptyCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | |
| | | import com.fzzy.async.fzzy40.entity.Fz40OilEmptyCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ç½éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:10 |
| | | */ |
| | | public interface Fzzy40Sync1215Rep extends JpaRepository<Fz40OilEmptyCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·å空ç½éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40OilEmptyCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40OilEmptyCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutStockCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-åä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:12 |
| | | */ |
| | | public interface Fzzy40Sync1216Rep extends JpaRepository<Fz40InoutStockCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·ååä»éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40InoutStockCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40InoutStockCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | |
| | | import com.fzzy.async.fzzy40.entity.Fz40PlanCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:13 |
| | | */ |
| | | public interface Fzzy40Sync1217Rep extends JpaRepository<Fz40PlanCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åè½®æ¢éªæ¶ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40PlanCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40PlanCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | ; |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutCostVerify; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:15 |
| | | */ |
| | | public interface Fzzy40Sync1218Rep extends JpaRepository<Fz40InoutCostVerify, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åå
¥åºææ¬æ ¸å®è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40InoutCostVerify where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40InoutCostVerify> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy40.repository; |
| | | |
| | | import com.fzzy.async.fzzy40.entity.Fz40InoutCostVerifyItem; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:17 |
| | | */ |
| | | public interface Fzzy40Sync1219Rep extends JpaRepository<Fz40InoutCostVerifyItem, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åå
¥åºææ¬æ ¸å®æç»è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz40InoutCostVerifyItem where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz40InoutCostVerifyItem> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| | |
| | | @Autowired |
| | | private Fzzy61Sync1109 fzzySync1109; |
| | | @Autowired |
| | | private Fzzy61Sync1214 fzzySync1214; |
| | | @Autowired |
| | | private Fzzy61Sync1215 fzzySync1215; |
| | | @Autowired |
| | | private Fzzy61Sync1216 fzzySync1216; |
| | | @Autowired |
| | | private Fzzy61Sync1217 fzzySync1217; |
| | | @Autowired |
| | | private Fzzy61Sync1218 fzzySync1218; |
| | | @Autowired |
| | | private Fzzy61Sync1219 fzzySync1219; |
| | | @Autowired |
| | | private Fzzy61Sync2102 fzzySync2102; |
| | | |
| | | @Override |
| | |
| | | fzzySync2102.syncData(kqdm, deptId, start, end); |
| | | } |
| | | |
| | | //é西çå¹³å°2025ç |
| | | if (StringUtils.isNotEmpty(param.getPushProtocol()) && PushProtocol.SB_SX_2025.getCode().equals(param.getPushProtocol())) { |
| | | //å¨å¤ç²®ç©ºä»éªæ¶è¡¨ |
| | | fzzySync1214.syncData(kqdm, deptId, start, end); |
| | | //å¨å¤æ²¹ç©ºç½éªæ¶è¡¨ |
| | | fzzySync1215.syncData(kqdm, deptId, start, end); |
| | | //å¨å¤ç²®åä»éªæ¶è¡¨ |
| | | fzzySync1216.syncData(kqdm, deptId, start, end); |
| | | //è½®æ¢éªæ¶ä¿¡æ¯ |
| | | fzzySync1217.syncData(kqdm, deptId, start, end); |
| | | //å
¥åºææ¬æ ¸å®è¡¨ |
| | | fzzySync1218.syncData(kqdm, deptId, start, end); |
| | | //å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | fzzySync1219.syncData(kqdm, deptId, start, end); |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description 空ä»éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:06 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_DEPOT_EMPTY_CHECK") |
| | | public class Fz61DepotEmptyCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "kcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "空ä»éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "kcysdh", length = 14) |
| | | private String kcysdh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "æååç§ä»£ç ") |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "ç²®é£ç级代ç ") |
| | | @Column(name = "lsdjdm", length = 3) |
| | | private String lsdjdm; |
| | | |
| | | @PropertyDef(label = "设计ä»å®¹") |
| | | @Column(name = "sjcr", precision = 20, scale = 3) |
| | | private Double sjcr; |
| | | |
| | | @PropertyDef(label = "å®é
å¨ç²®åç§æå¤§ä»å®¹") |
| | | @Column(name = "sjclzdcr", precision = 20, scale = 3) |
| | | private Double sjclzdcr; |
| | | |
| | | @PropertyDef(label = "æå¨ç²®æ°é") |
| | | @Column(name = "jysj", precision = 20, scale = 3) |
| | | private Double jysj; |
| | | |
| | | @PropertyDef(label = "å¨åæ¹å¼", description = "1-å
è£
2-æ£è£
3-å
å´æ£å") |
| | | @Column(name = "jydw", length = 1) |
| | | private String jydw; |
| | | |
| | | @PropertyDef(label = "仿¿å°åªå®å¥½æ
åµ") |
| | | @Column(name = "dpwhqk", length = 128) |
| | | private String dpwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿å¢ä½å®å¥½æ
åµ") |
| | | @Column(name = "qtwhqk", length = 128) |
| | | private String qtwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿å±é¢å®å¥½æ
åµ") |
| | | @Column(name = "wmwhqk", length = 128) |
| | | private String wmwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿é¨çªå®å¥½æ
åµ") |
| | | @Column(name = "mcwhqk", length = 128) |
| | | private String mcwhqk; |
| | | |
| | | @PropertyDef(label = "仿¿æ¯å¦æ
èªæ¹å仿¿ç»æ") |
| | | @Column(name = "sfszgd", length = 128) |
| | | private String sfszgd; |
| | | |
| | | @PropertyDef(label = "é²éç½å®å¥½æ
åµ") |
| | | @Column(name = "fqwwhqk", length = 128) |
| | | private String fqwwhqk; |
| | | |
| | | @PropertyDef(label = "é²è«çº¿å®å¥½æ
åµ") |
| | | @Column(name = "fcxwhqk", length = 128) |
| | | private String fcxwhqk; |
| | | |
| | | @PropertyDef(label = "é²é¼ æ¿å®å¥½æ
åµ") |
| | | @Column(name = "fsbwhqk", length = 128) |
| | | private String fsbwhqk; |
| | | |
| | | @PropertyDef(label = "éé£ææ¯ææ®µ") |
| | | @Column(name = "tfjssd", length = 128) |
| | | private String tfjssd; |
| | | |
| | | @PropertyDef(label = "éé£ç³»ç»æ¯å¦å®å¥½") |
| | | @Column(name = "tfxtsfwh", length = 128) |
| | | private String tfxtsfwh; |
| | | |
| | | @PropertyDef(label = "çè¸ææ¯ææ®µ") |
| | | @Column(name = "xzjssd", length = 128) |
| | | private String xzjssd; |
| | | |
| | | @PropertyDef(label = "ç²®æ
æ£æµææ®µ") |
| | | @Column(name = "lqjcsd", length = 128) |
| | | private String lqjcsd; |
| | | |
| | | @PropertyDef(label = "ç²®æ
æ£æµç³»ç»æ¯å¦å®å¥½") |
| | | @Column(name = "lqjcxtsfwh", length = 128) |
| | | private String lqjcxtsfwh; |
| | | |
| | | @PropertyDef(label = "ä»é¨æ¡£ç²®è®¾æ½æ¯å¦å®å¥½") |
| | | @Column(name = "cmdlsssfwh", length = 128) |
| | | private String cmdlsssfwh; |
| | | |
| | | @PropertyDef(label = "æ¯å¦æ¸
æ¶") |
| | | @Column(name = "sfqx", length = 128) |
| | | private String sfqx; |
| | | |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @PropertyDef(label = "æ´æ¹æè§") |
| | | @Column(name = "zgyj", length = 128) |
| | | private String zgyj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description å
¥åºææ¬æ ¸å® |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:18 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_COST_VERIFY") |
| | | public class Fz61InoutCostVerify implements Serializable { |
| | | |
| | | public static String SORT_PROP = "rkhddh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "å
¥åºæ ¸å®åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "rkhddh", length = 14) |
| | | private String rkhddh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "æå±ååº") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "å¨ç²®åç§ä»£ç " ) |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "æ ¸å®åä»·" ) |
| | | @Column(name = "hddj", precision = 20, scale = 3) |
| | | private Double hddj; |
| | | |
| | | @PropertyDef(label = "æ ¸å®æ°é" ) |
| | | @Column(name = "hdsl", precision = 20, scale = 3) |
| | | private Double hdsl; |
| | | |
| | | @PropertyDef(label = "ç²®é£æ§è´¨" ) |
| | | @Column(name = "lsxz", length = 3) |
| | | private String lsxz; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥åä½" ) |
| | | @Column(name = "tbdw", length = 512) |
| | | private String tbdw; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å¡«æ¥æ¶é´") |
| | | @Column(name = "tbsj") |
| | | private Date tbsj; |
| | | |
| | | @PropertyDef(label = "åä½è´è´£äºº") |
| | | @Column(name = "dwfzr", length = 512) |
| | | private String dwfzr; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥äºº") |
| | | @Column(name = "tbr", length = 512) |
| | | private String tbr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "REMARKS_", length = 512) |
| | | private String remarks; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description å
¥åºææ¬æ ¸å®æç» |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:20 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_COST_VERIFY_ITEM") |
| | | public class Fz61InoutCostVerifyItem implements Serializable { |
| | | |
| | | public static String SORT_PROP = "rkhddh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "å
¥åºæ ¸å®åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "rkhddh", length = 14) |
| | | private String rkhddh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "å¨ç²®åç§ä»£ç " ) |
| | | @Column(name = "lspzdm", length = 7) |
| | | private String lspzdm; |
| | | |
| | | @PropertyDef(label = "贷款éé¢" ) |
| | | @Column(name = "dkje", precision = 20, scale = 3) |
| | | private Double dkje; |
| | | |
| | | @PropertyDef(label = "æ¶è·å¹´åº¦" ) |
| | | @Column(name = "shnd", length = 4) |
| | | private String shnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥åä½" ) |
| | | @Column(name = "tbdw", length = 512) |
| | | private String tbdw; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å¡«æ¥æ¶é´") |
| | | @Column(name = "tbsj") |
| | | private Date tbsj; |
| | | |
| | | @PropertyDef(label = "åä½è´è´£äºº") |
| | | @Column(name = "dwfzr", length = 512) |
| | | private String dwfzr; |
| | | |
| | | @PropertyDef(label = "å¡«æ¥äºº") |
| | | @Column(name = "tbr", length = 512) |
| | | private String tbr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "REMARKS_", length = 512) |
| | | private String remarks; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description åä»éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:13 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_INOUT_STOCK_CHECK") |
| | | public class Fz61InoutStockCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "dcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "åä»éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "dcysdh", length = 14) |
| | | private String dcysdh; |
| | | |
| | | @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 = "ccdw", length = 256) |
| | | private String ccdw; |
| | | |
| | | @PropertyDef(label = "计åæå·") |
| | | @Column(name = "jhwh", length = 14) |
| | | private String jhwh; |
| | | |
| | | @PropertyDef(label = "ååºè´§ä½" ) |
| | | @Column(name = "dchwbm", length = 30) |
| | | private String dchwbm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£åç§ä»£ç " ) |
| | | @Column(name = "dclspzdm", length = 7) |
| | | private String dclspzdm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£ç级代ç " ) |
| | | @Column(name = "dclsdjdm", length = 2) |
| | | private String dclsdjdm; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£ç产年度" ) |
| | | @Column(name = "dclsscnd", length = 4) |
| | | private String dclsscnd; |
| | | |
| | | @PropertyDef(label = "ååºç²®é£æ°é(å¨)" ) |
| | | @Column(name = "dclssl", precision = 20, scale = 3) |
| | | private Double dclssl; |
| | | |
| | | @PropertyDef(label = "åå
¥è´§ä½" ) |
| | | @Column(name = "drhwdm", length = 30) |
| | | private String drhwbm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£åç§ä»£ç " ) |
| | | @Column(name = "drlspzdm", length = 7) |
| | | private String drlspzdm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£ç级代ç " ) |
| | | @Column(name = "drlsdjdm", length = 2) |
| | | private String drlsdjdm; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£æ°é(å¨)" ) |
| | | @Column(name = "drlssl", precision = 20, scale = 3) |
| | | private Double drlssl; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£åºåææ¬(å
/å¨)" ) |
| | | @Column(name = "drlskccb", precision = 20, scale = 3) |
| | | private Double drlskccb; |
| | | |
| | | @PropertyDef(label = "åå
¥ç²®é£ç产年度" ) |
| | | @Column(name = "drlsscnd", length = 4) |
| | | private String drlsscnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "åä»å®ææ¶é´") |
| | | @Column(name = "wcsj") |
| | | private Date wcsj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd") |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description 空ç½éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:09 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_OIL_EMPTY_CHECK") |
| | | public class Fz61OilEmptyCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "kgysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "空ç½éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "kgysdh", length = 14) |
| | | private String kgysdh; |
| | | |
| | | @Column(name = "COMPANY_ID_", length = 10) |
| | | @PropertyDef(label = "ç»ç»ç¼ç ") |
| | | private String companyId; |
| | | |
| | | @Column(name = "DEPT_ID_", length = 20) |
| | | @PropertyDef(label = "åºåºä»£ç ") |
| | | private String deptId; |
| | | |
| | | @Column(name = "DEPOT_ID_", length = 30) |
| | | @PropertyDef(label = "ä»åºç¼ç ", description = "ç®å䏿µ·ä½¿ç¨") |
| | | private String depotId; |
| | | |
| | | @PropertyDef(label = "æååç§ä»£ç ") |
| | | @Column(name = "ncpzdm", length = 7) |
| | | private String ncpzdm; |
| | | |
| | | @PropertyDef(label = "设计ç容") |
| | | @Column(name = "sjgr", precision = 20, scale = 3) |
| | | private Double sjgr; |
| | | |
| | | @PropertyDef(label = "å®é
卿²¹åç§æå¤§ç½å®¹") |
| | | @Column(name = "sjcyzdgr", precision = 20, scale = 3) |
| | | private Double sjcyzdgr; |
| | | |
| | | @PropertyDef(label = "æå¨æ²¹æ°é") |
| | | @Column(name = "jysj", precision = 20, scale = 3) |
| | | private Double jysj; |
| | | |
| | | @PropertyDef(label = "æ¯å¦æ
èªæ¹åæ²¹ç½ç»æ") |
| | | @Column(name = "sfszgdygjg", length = 128) |
| | | private String sfszgdygjg; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½ææ æ¸æ¼éè") |
| | | @Column(name = "ygywslxs", length = 128) |
| | | private String ygywslxs; |
| | | |
| | | @PropertyDef(label = "ç½åºææ å¼è£ã䏿²ç°è±¡") |
| | | @Column(name = "gjywklxcxx", length = 128) |
| | | private String gjywklxcxx; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½å°åªæ¯å¦å®å
¨ç¡¬å") |
| | | @Column(name = "ygdpsfwqyh", length = 128) |
| | | private String ygdpsfwqyh; |
| | | |
| | | @PropertyDef(label = "æ¤æ²¹å ¤æ¯å¦åå¨å¼è£ç¼ºå£çæ
åµ") |
| | | @Column(name = "hydsfzc", length = 128) |
| | | private String hydsfzc; |
| | | |
| | | @PropertyDef(label = "ç½åºå
ææ°´ææ é鍿§å¶") |
| | | @Column(name = "gtfmsfzc", length = 128) |
| | | private String gtfmsfzc; |
| | | |
| | | @PropertyDef(label = "ç½å
æ¯å¦æ¸
æ´") |
| | | @Column(name = "gnsfqj", length = 128) |
| | | private String gnsfqj; |
| | | |
| | | @PropertyDef(label = "ç¬æ¢¯æ¯å¦å®å
¨") |
| | | @Column(name = "ptsfaq", length = 128) |
| | | private String ptsfaq; |
| | | |
| | | @PropertyDef(label = "çé¡¶å®å
¨æ¤æ æ¯å¦å®å¥½") |
| | | @Column(name = "gdaqhlsfwh", length = 128) |
| | | private String gdaqhlsfwh; |
| | | |
| | | @PropertyDef(label = "æ²¹ç½åºæ¯å¦å¤äºä½æ´¼ç¹") |
| | | @Column(name = "gqsfcydwd", length = 128) |
| | | private String gqsfcydwd; |
| | | |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @PropertyDef(label = "æ´æ¹æè§") |
| | | @Column(name = "zgyj", length = 128) |
| | | private String zgyj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.entity; |
| | | |
| | | import com.alibaba.fastjson.annotation.JSONField; |
| | | import com.bstek.dorado.annotation.PropertyDef; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.*; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/04 20:16 |
| | | */ |
| | | @Data |
| | | @Entity |
| | | @Table(name = "D_PLAN_CHECK") |
| | | public class Fz61PlanCheck implements Serializable { |
| | | |
| | | public static String SORT_PROP = "dcysdh"; |
| | | |
| | | @Id |
| | | @PropertyDef(label = "è½®æ¢éªæ¶åå·", description = "éªæ¶ç³è¯·æ¥æyyyyMMdd + 4ä½é¡ºåºå·") |
| | | @Column(name = "dcysdh", length = 14) |
| | | private String dcysdh; |
| | | |
| | | @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 = "ccdw", length = 256) |
| | | private String ccdw; |
| | | |
| | | @PropertyDef(label = "计åæå·") |
| | | @Column(name = "jhwh", length = 14) |
| | | private String jhwh; |
| | | |
| | | @PropertyDef(label = "计åå®æè´§ä½ç¼ç " ) |
| | | @Column(name = "dchwbm", length = 30) |
| | | private String dchwbm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£åç§ä»£ç " ) |
| | | @Column(name = "dclspzdm", length = 7) |
| | | private String dclspzdm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£ç级代ç " ) |
| | | @Column(name = "dclsdjdm", length = 2) |
| | | private String dclsdjdm; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£ç产年度" ) |
| | | @Column(name = "dclsscnd", length = 4) |
| | | private String dclsscnd; |
| | | |
| | | @PropertyDef(label = "计åå®æç²®é£æ°é(å¨)" ) |
| | | @Column(name = "dclssl", precision = 20, scale = 3) |
| | | private Double dclssl; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡è´§ä½ç¼ç " ) |
| | | @Column(name = "drhwbm", length = 30) |
| | | private String drhwbm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£åç§ä»£ç " ) |
| | | @Column(name = "drlspzdm", length = 7) |
| | | private String drlspzdm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£ç级代ç " ) |
| | | @Column(name = "drlsdjdm", length = 2) |
| | | private String drlsdjdm; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£æ°é(å¨)" ) |
| | | @Column(name = "drlssl", precision = 20, scale = 3) |
| | | private Double drlssl; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£åºåææ¬(å
/å¨)" ) |
| | | @Column(name = "drlskccb", precision = 20, scale = 3) |
| | | private Double drlskccb; |
| | | |
| | | @PropertyDef(label = "å®é
æ§è¡ç²®é£ç产年度" ) |
| | | @Column(name = "drlsscnd", length = 4) |
| | | private String drlsscnd; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å®é
æ§è¡å
¥åºæ¶é´") |
| | | @Column(name = "rksj") |
| | | private Date rksj; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "å®é
æ§è¡å®ææ¶é´") |
| | | @Column(name = "wcsj") |
| | | private Date wcsj; |
| | | |
| | | @PropertyDef(label = "éªæ¶ç»è®º") |
| | | @Column(name = "ysjl", length = 128) |
| | | private String ysjl; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd") |
| | | @PropertyDef(label = "éªæ¶æ¶é´") |
| | | @Column(name = "yssj") |
| | | private Date yssj; |
| | | |
| | | @PropertyDef(label = "æ¿å¨åä½è´è´£äºº") |
| | | @Column(name = "ccdwfzr", length = 128) |
| | | private String ccdwfzr; |
| | | |
| | | @PropertyDef(label = "éªæ¶äºº") |
| | | @Column(name = "ysr", length = 128) |
| | | private String ysr; |
| | | |
| | | @PropertyDef(label = "夿³¨") |
| | | @Column(name = "bz", length = 200) |
| | | private String bz; |
| | | |
| | | @JSONField(format = "yyyy-MM-dd HH:mm:ss") |
| | | @PropertyDef(label = "æåæ´æ°æ¶é´") |
| | | @Column(name = "zhgxsj") |
| | | private Date zhgxsj; |
| | | |
| | | /** |
| | | * --------éä»¶-------- |
| | | **/ |
| | | @Column(name = "FILE_ID_", length = 30) |
| | | @PropertyDef(label = "ç
§çid") |
| | | private String fileId; |
| | | |
| | | @Column(name = "FILE_NAME_", length = 50) |
| | | @PropertyDef(label = "ç
§çåç§°") |
| | | private String fileName; |
| | | |
| | | @Column(name = "FILE_TIME_") |
| | | @PropertyDef(label = "ç
§çä¸ä¼ æ¶é´") |
| | | private Date fileTime; |
| | | |
| | | //å
¨è·¯å¾ |
| | | @Transient |
| | | private String imgFilePath; |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1214; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1214Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61DepotEmptyCheck; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1214Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:26 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1214 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1214Rep fzzy61Sync1214Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1214Rep api1214Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1214æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61DepotEmptyCheck> list = fzzy61Sync1214Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1214 apiData; |
| | | Api1105 api1105; |
| | | List<Api1214> api1214List; |
| | | for (Fz61DepotEmptyCheck depotEmptyCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(depotEmptyCheck.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1214(); |
| | | BeanUtils.copyProperties(depotEmptyCheck, apiData); |
| | | |
| | | apiData.setBizId(depotEmptyCheck.getKcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, depotEmptyCheck.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | //ç²®é£ç级 |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, depotEmptyCheck.getLsdjdm()); |
| | | apiData.setLsdjdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1214List = api1214Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1214List || api1214List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1214List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1214Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1215; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1215Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61OilEmptyCheck; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1215Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ç½éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:30 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1215 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1215Rep fzzy61Sync1215Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1215Rep api1215Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1215æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61OilEmptyCheck> list = fzzy61Sync1215Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | Api1215 apiData; |
| | | Api1105 api1105; |
| | | List<Api1215> api1215List; |
| | | for (Fz61OilEmptyCheck oilEmptyCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(oilEmptyCheck.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | apiData = new Api1215(); |
| | | BeanUtils.copyProperties(oilEmptyCheck, apiData); |
| | | apiData.setBizId(oilEmptyCheck.getKgysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, oilEmptyCheck.getNcpzdm().substring(0, 3)); |
| | | apiData.setNcpzdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1215List = api1215Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1215List || api1215List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1215List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1215Rep.save(apiData); |
| | | } |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1216; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1216Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutStockCheck; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1216Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-åä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:32 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1216 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1216Rep fzzy61Sync1216Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1216Rep api1216Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1216æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61InoutStockCheck> list = fzzy61Sync1216Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1216 apiData; |
| | | Api1105 api1105In; |
| | | Api1105 api1105Out; |
| | | List<Api1216> api1216List; |
| | | for (Fz61InoutStockCheck inoutStockCheck : list) { |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105Out = commonService.getApi1105Cache(inoutStockCheck.getDchwbm()); |
| | | if (null == api1105Out) { |
| | | continue; |
| | | } |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105In = commonService.getApi1105Cache(inoutStockCheck.getDrhwbm()); |
| | | if (null == api1105In) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1216(); |
| | | BeanUtils.copyProperties(inoutStockCheck, apiData); |
| | | apiData.setBizId(inoutStockCheck.getDcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setDchwbm(api1105Out.getHwdm()); |
| | | apiData.setDrhwbm(api1105In.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutStockCheck.getDclspzdm().substring(0, 3)); |
| | | apiData.setDclspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, inoutStockCheck.getDclsdjdm()); |
| | | apiData.setDclsdjdm(mappingCode); |
| | | |
| | | //ç²®é£åç§ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutStockCheck.getDrlspzdm().substring(0, 3)); |
| | | apiData.setDrlspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, inoutStockCheck.getDrlsdjdm()); |
| | | apiData.setDrlsdjdm(mappingCode); |
| | | |
| | | api1216List = api1216Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1216List || api1216List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1216List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1216Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1217; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1217Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61PlanCheck; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1217Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:43 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1217 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1217Rep fzzy61Sync1217Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1217Rep api1217Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1217æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61PlanCheck> list = fzzy61Sync1217Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1217 apiData; |
| | | Api1105 api1105In; |
| | | Api1105 api1105Out; |
| | | List<Api1217> api1217List; |
| | | for (Fz61PlanCheck planCheck : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105Out = commonService.getApi1105Cache(planCheck.getDchwbm()); |
| | | if (null == api1105Out) { |
| | | continue; |
| | | } |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105In = commonService.getApi1105Cache(planCheck.getDrhwbm()); |
| | | if (null == api1105In) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1217(); |
| | | BeanUtils.copyProperties(planCheck, apiData); |
| | | apiData.setBizId(planCheck.getDcysdh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setDchwbm(api1105Out.getHwdm()); |
| | | apiData.setDrhwbm(api1105In.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, planCheck.getDclspzdm().substring(0, 3)); |
| | | apiData.setDclspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, planCheck.getDclsdjdm()); |
| | | apiData.setDclsdjdm(mappingCode); |
| | | |
| | | //ç²®é£åç§ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, planCheck.getDrlspzdm().substring(0, 3)); |
| | | apiData.setDrlspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, planCheck.getDrlsdjdm()); |
| | | apiData.setDrlsdjdm(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1217List = api1217Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1217List || api1217List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1217List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1217Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1218; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1218Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutCostVerify; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1218Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:15 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1218 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1218Rep fzzy61Sync1218Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1218Rep api1218Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1218æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61InoutCostVerify> list = fzzy61Sync1218Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1218 apiData; |
| | | Api1105 api1105; |
| | | List<Api1218> api1218List; |
| | | for (Fz61InoutCostVerify inoutCostVerify : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(inoutCostVerify.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1218(); |
| | | BeanUtils.copyProperties(inoutCostVerify, apiData); |
| | | apiData.setBizId(inoutCostVerify.getRkhddh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutCostVerify.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | //ç²®é£æ§è´¨ |
| | | mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSXZ, inoutCostVerify.getLsxz()); |
| | | apiData.setLsxz(mappingCode); |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1218List = api1218Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1218List || api1218List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1218List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1218Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.impl; |
| | | |
| | | import com.fzzy.api.Constant; |
| | | import com.fzzy.api.entity.Api1105; |
| | | import com.fzzy.api.entity.Api1219; |
| | | import com.fzzy.api.entity.ApiLog; |
| | | import com.fzzy.api.service.ApiCommonService; |
| | | import com.fzzy.api.service.ApiTriggerService; |
| | | import com.fzzy.api.utils.ContextUtil; |
| | | import com.fzzy.api.view.repository.Api1219Rep; |
| | | import com.fzzy.api.view.repository.ApiLogRep; |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutCostVerifyItem; |
| | | import com.fzzy.async.fzzy61.repository.Fzzy61Sync1219Rep; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:17 |
| | | */ |
| | | @Slf4j |
| | | @Component |
| | | public class Fzzy61Sync1219 { |
| | | |
| | | @Autowired |
| | | private Fzzy61Sync1219Rep fzzy61Sync1219Rep; |
| | | @Autowired |
| | | private ApiTriggerService apiTriggerService; |
| | | @Autowired |
| | | private Api1219Rep api1219Rep; |
| | | @Autowired |
| | | private ApiCommonService commonService; |
| | | @Autowired |
| | | private ApiLogRep apiLogRep; |
| | | |
| | | /** |
| | | * 忥å°ä»ç¡®è®¤ä¿¡æ¯ |
| | | * |
| | | * @param deptId |
| | | * @param start |
| | | * @param end |
| | | */ |
| | | public void syncData(String kqdm, String deptId, Date start, Date end) { |
| | | |
| | | log.info("-------------1219æ¥å£æ°æ®å¼å§åæ¥------------------"); |
| | | |
| | | //åæ¥æ°æ®ï¼åªè®°å½å¤±è´¥çä¿¡æ¯ |
| | | ApiLog apiLog = new ApiLog(); |
| | | apiLog.setType(ApiLog.TYPE_SYNC); |
| | | apiLog.setKqdm(deptId); |
| | | apiLog.setUploadTime(new Date()); |
| | | apiLog.setInteId(Constant.API_CODE_1208); |
| | | apiLog.setStatus(99); |
| | | apiLog.setId(ContextUtil.getUUID()); |
| | | try { |
| | | List<Fz61InoutCostVerifyItem> list = fzzy61Sync1219Rep.listData(deptId, start, end); |
| | | if (null == list || list.isEmpty()) { |
| | | log.info("-------------没æè·åå°å°ä»ç¡®è®¤ä¿¡æ¯------------------"); |
| | | return; |
| | | } |
| | | |
| | | Api1219 apiData; |
| | | Api1105 api1105; |
| | | List<Api1219> api1219List; |
| | | for (Fz61InoutCostVerifyItem inoutCostVerifyItem : list) { |
| | | |
| | | //è·åè´§ä½ä¿¡æ¯ |
| | | api1105 = commonService.getApi1105Cache(inoutCostVerifyItem.getDepotId()); |
| | | if (null == api1105) { |
| | | continue; |
| | | } |
| | | |
| | | apiData = new Api1219(); |
| | | BeanUtils.copyProperties(inoutCostVerifyItem, apiData); |
| | | apiData.setBizId(inoutCostVerifyItem.getRkhddh()); |
| | | apiData.setKqdm(kqdm); |
| | | apiData.setHwdm(api1105.getHwdm()); |
| | | |
| | | //ç²®é£åç§ |
| | | String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, inoutCostVerifyItem.getLspzdm().substring(0, 3)); |
| | | apiData.setLspzdm(mappingCode); |
| | | |
| | | |
| | | apiData.setZhgxsj(new Date()); |
| | | |
| | | api1219List = api1219Rep.getDataByBizId(apiData.getBizId()); |
| | | if (null == api1219List || api1219List.isEmpty()) { |
| | | apiData.setCzbz(Constant.CZBZ_I); |
| | | } else { |
| | | apiData.setCzbz(api1219List.get(0).getCzbz()); |
| | | } |
| | | |
| | | //ä¿åæ°æ® |
| | | api1219Rep.save(apiData); |
| | | } |
| | | |
| | | } catch (Exception e) { |
| | | log.error("---åæ¥å¤±è´¥----{}", e); |
| | | apiLog.setResult("åæ¥å¤±è´¥ï¼" + e.getMessage()); |
| | | apiLogRep.save(apiLog); |
| | | } |
| | | } |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61DepotEmptyCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:06 |
| | | */ |
| | | public interface Fzzy61Sync1214Rep extends JpaRepository<Fz61DepotEmptyCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·å空ä»éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61DepotEmptyCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61DepotEmptyCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61OilEmptyCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-空ç½éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:10 |
| | | */ |
| | | public interface Fzzy61Sync1215Rep extends JpaRepository<Fz61OilEmptyCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·å空ç½éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61OilEmptyCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61OilEmptyCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutStockCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-åä»éªæ¶è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:12 |
| | | */ |
| | | public interface Fzzy61Sync1216Rep extends JpaRepository<Fz61InoutStockCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·ååä»éªæ¶è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61InoutStockCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61InoutStockCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61PlanCheck; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-è½®æ¢éªæ¶ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:13 |
| | | */ |
| | | public interface Fzzy61Sync1217Rep extends JpaRepository<Fz61PlanCheck, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åè½®æ¢éªæ¶ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61PlanCheck where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61PlanCheck> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutCostVerify; |
| | | 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; |
| | | |
| | | ; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:15 |
| | | */ |
| | | public interface Fzzy61Sync1218Rep extends JpaRepository<Fz61InoutCostVerify, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åå
¥åºææ¬æ ¸å®è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61InoutCostVerify where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61InoutCostVerify> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.fzzy.async.fzzy61.repository; |
| | | |
| | | import com.fzzy.async.fzzy61.entity.Fz61InoutCostVerifyItem; |
| | | 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; |
| | | |
| | | /** |
| | | * @Description ç²®é£è´é-å
¥åºææ¬æ ¸å®æç»è¡¨ |
| | | * @Author CZT |
| | | * @Date 2025/11/08 10:17 |
| | | */ |
| | | public interface Fzzy61Sync1219Rep extends JpaRepository<Fz61InoutCostVerifyItem, String> { |
| | | |
| | | /** |
| | | * æ ¹æ®åºåºç¼ç åæ¶é´è·åå
¥åºææ¬æ ¸å®æç»è¡¨ä¿¡æ¯ |
| | | * |
| | | * @return |
| | | */ |
| | | @Query("from Fz61InoutCostVerifyItem where deptId=:deptId and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") |
| | | List<Fz61InoutCostVerifyItem> listData(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | |
| | | } |