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;
}