package com.fzzy.async.whhpjl.entity;

import com.alibaba.fastjson.annotation.JSONField;
import com.bstek.dorado.annotation.PropertyDef;
import com.fzzy.api.Constant;
import com.fzzy.otherview.whhpjl.dto.ShareApi2013Dd;
import com.fzzy.otherview.whhpjl.dto.ShareApi2013Dm;
import com.fzzy.otherview.whhpjl.dto.ShareApi2013Syy;
import com.fzzy.otherview.whhpjl.dto.ShareApi2013Xmf;
import lombok.Data;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * 质量管理，2023年5月26日 根据新国粮规优化调整
 *
 * @author chen
 */
@Data
@Entity
@Table(name = "D_M_QUALITY")
public class Fz40WhjlMQuality implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "ID_", length = 40)
    @PropertyDef(label = "主键ID", description = "ZJ+检验类别+年月日时分秒")
    private String id;

    @Column(name = "COMPANY_ID_", length = 10)
    @PropertyDef(label = "组织编码")
    private String companyId;

    @Column(name = "DEPT_ID_", length = 40)
    @PropertyDef(label = "库区编码")
    private String deptId;

    @Column(name = "DEPOT_ID_", length = 50)
    @PropertyDef(label = "仓库编码")
    private String depotId;

    @Column(name = "FOOD_VARIETY_", length = 10)
    @PropertyDef(label = "粮食品种")
    private String foodVariety;

    @Column(name = "FOOD_LEVEL_", length = 10)
    @PropertyDef(label = "粮食等级")
    private String foodLevel;

    @PropertyDef(label = "入库日期")
    @Column(name = "STORE_DATE_")
    private Date storeDate;

    @Column(name = "TYPE_", length = 10)
    @PropertyDef(label = "检验类别", description = "01：入仓验收 02：出仓检验 03：3 月末普检04：9 月末普检 05：入仓初检 06：月度检查 07：3 月末库内普查 08：9 月末库内普查")
    private String type;

    @Column(name = "TIME_")
    @PropertyDef(label = "检验时间")
    private Date time;

    @Column(name = "UNIT_", length = 50)
    @PropertyDef(label = "检验单位")
    private String unit;

    @Column(name = "USER_", length = 50)
    @PropertyDef(label = "检验人", description = "检验人员姓名，若有多个保管员")
    private String user;

    @Column(name = "STANDARD_", length = 4)
    @PropertyDef(label = "检验依据", description = "1-国标，0-其他")
    private String standard;


    @PropertyDef(label = "指标类别", description = "1: 质量指标检验2：储存品质检验3：食品安全检验 如果同时检验了多个，用#隔开，例如：1#2#3")
    @Column(name = "zblb", length = 8)
    private String zblb;

    @Column(name = "RESULT_", length = 40)
    @PropertyDef(label = "检验结论", description = "1、质量指标填写/达标/不达标 2、储存品质指标填写“宜存”、轻度不宜存”、“重度不宜存”3、食品安全指标填写“合格”、不合格” 多项指标时以#分隔，例如：达标|综合判定#宜存#合格 ")
    private String result;

    @Column(name = "spaqzbsfhg", length = 40)
    @PropertyDef(label = "食品安全指标是否合格", description = "0-不合格，1-合格")
    private String spaqzbsfhg;

    @JSONField(format = "yyyy-MM-dd")
    @PropertyDef(label = "签发日期")
    @Column(name = "qfrq")
    private Date qfrq;

    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @PropertyDef(label = "报告出具时间")
    @Column(name = "bgcjsj")
    private Date bgcjsj;

    @PropertyDef(label = "审核人姓名")
    @Column(name = "shrxm", length = 64)
    private String shrxm;

    @PropertyDef(label = "扦样单编号")
    @Column(name = "qydbh", length = 64)
    private String qydbh;

    @Column(name = "CHECK_TIME_")
    @PropertyDef(label = "扦样时间", required = true)
    private Date checkTime;

    @Column(name = "CHECK_AREA_", length = 50)
    @PropertyDef(label = "扦样区域")
    private String checkArea;

    @Column(name = "CHECK_USER_", length = 50)
    @PropertyDef(label = "扦样人", required = true)
    private String checkUser;

    @PropertyDef(label = "监督人姓名")
    @Column(name = "jdrxm", length = 64)
    private String jdrxm;

    @PropertyDef(label = "样品编号")
    @Column(name = "ypbh", length = 64)
    private String ypbh;

    @PropertyDef(label = "样品数量", required = true)
    @Column(name = "ypsl", precision = 20, scale = 6)
    private Double ypsl;

    @PropertyDef(label = "代表数量")
    @Column(name = "dbsl", precision = 20, scale = 6)
    private Double dbsl;

    @PropertyDef(label = "样品等级")
    @Column(name = "ypdj", length = 2)
    private String ypdj;

    @Column(name = "NORMAL_YEAR_", length = 10)
    @PropertyDef(label = "是否正常存储年限")
    private String normalYear;

    @Column(name = "REMARK_", length = 200)
    @PropertyDef(label = "备注", description = "备注信息")
    private String remark;

    @Column(name = "UPDATE_TIME_")
    @PropertyDef(label = "数据更新时间")
    private Date updateTime;


    /**
     * --------附件--------
     **/
    @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;

    /************
     * 黄陂军粮用-省质检中心报告
     ************/

    @Column(name = "PROV_RESERVE_", length = 1)
    @PropertyDef(label = "是否为省级质检中心报告", description = "Y-是，N-否")
    private String provReserve = Constant.YN_N;

    @Column(name = "QLY_ORG_REPORTID_", length = 20)
    @PropertyDef(label = "质检报告id")
    private String qlyOrgReportId;  //质检报告id

    @Column(name = "ORDER_ID_", length = 20)
    @PropertyDef(label = "订单表ID")
    private String orderId;  //订单表ID

    @Column(name = "SAMPLE_ID_", length = 20)
    @PropertyDef(label = "样品表ID")
    private String sampleId;  //样品表ID

    @Column(name = "ORG_ID_", length = 20)
    @PropertyDef(label = "机构表ID")
    private String orgId;  //机构表ID

    @Column(name = "QUALITY_ORG_ID_", length = 50)
    @PropertyDef(label = "质检机构编号")
    private String qualityOrgId;  //质检机构编号

    @Column(name = "QUALITY_ORG_NAME_", length = 50)
    @PropertyDef(label = "质检机构名称")
    private String qualityOrgName;  //质检机构名称

    @Column(name = "GYSXYDM_", length = 50)
    @PropertyDef(label = "供应商信用代码")
    private String gysxydm;  //供应商信用代码

    @Column(name = "JLQYBH_", length = 50)
    @PropertyDef(label = "军粮企业编号")
    private String jlqybh;  //军粮企业编号

    @Column(name = "JLQYMC_", length = 50)
    @PropertyDef(label = "军粮企业名称")
    private String jlqymc;  //军粮企业名称

    @Column(name = "KDBM_", length = 20)
    @PropertyDef(label = "库点编码")
    private String kdbm;  //库点编码

    @Column(name = "KDMC_", length = 50)
    @PropertyDef(label = "库点名称")
    private String kdmc;  //库点名称

    @Column(name = "DELECTION_TYPE_", length = 20)
    @PropertyDef(label = "检测报告类型")
    private String delectionType;  //检测报告类型

    @Column(name = "DELETCTION_NUMBER_", length = 50)
    @PropertyDef(label = "检测报告编号")
    private String deletctionNumber;  //检测报告编号

    @Column(name = "JLCPMC_", length = 50)
    @PropertyDef(label = "军粮产品名称")
    private String jlcpmc;  //军粮产品名称

    @Column(name = "JLLSPZ_", length = 50)
    @PropertyDef(label = "军粮粮食品种")
    private String jllspz;  //军粮粮食品种

    @Column(name = "LOT_NUMBER_", length = 50)
    @PropertyDef(label = "批号")
    private String lotNumber;  //批号

    @Column(name = "SPECIFICATION_MODEL_", length = 50)
    @PropertyDef(label = "规格型号")
    private String specificationModel;  //规格型号

    @Column(name = "CYSM_", length = 200)
    @PropertyDef(label = "抽样说明")
    private String cysm;  //抽样说明

    @JSONField(format = "yyyy-MM-dd")
    @Column(name = "REGISTRATION_", length = 20)
    @PropertyDef(label = "登记时间")
    private String registration;  //登记时间

    @Column(name = "INSPECT_PLAN_", length = 200)
    @PropertyDef(label = "检验方案")
    private String inspectPlan;  //检验方案

    @Column(name = "PRODUCT_TYPE_", length = 20)
    @PropertyDef(label = "产品类型")
    private String productType;  //产品类型

    @Column(name = "CYJS_", length = 20)
    @PropertyDef(label = "抽样基数")
    private String cyjs;  //抽样基数

    @Column(name = "CYSL_", length = 20)
    @PropertyDef(label = "抽样数量")
    private String cysl;  //抽样数量

    @Column(name = "SAMPLER_", length = 50)
    @PropertyDef(label = "抽样人")
    private String sampler;  //抽样人

    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @Column(name = "SAMPLER_TIME_", length = 20)
    @PropertyDef(label = "抽样时间")
    private String samplerTime;  //抽样时间

    @Column(name = "SAMPLER_AREA_", length = 200)
    @PropertyDef(label = "抽样地点")
    private String samplerArea;  //抽样地点

    @JSONField(format = "yyyy-MM-dd")
    @Column(name = "CREATE_TIME_", length = 20)
    @PropertyDef(label = "生产日期")
    private Date createTime;  //生产日期

    @Column(name = "IS_ACTIVE_", length = 1)
    @PropertyDef(label = "是否有效")
    private String isActive;  //是否有效

    @Column(name = "REPORT_FILE_", length = 200)
    @PropertyDef(label = "质检报告文件")
    private String reportFile;  //质检报告文件

    @Column(name = "CREATE_DATE_", length = 40)
    @PropertyDef(label = "创建时间")
    private String createDate;  //创建时间

    @Column(name = "CREATE_BY_", length = 50)
    @PropertyDef(label = "创建人")
    private String createBy;  //创建人

    @Column(name = "UPDATE_DATE_", length = 40)
    @PropertyDef(label = "更新时间")
    private String updateDate;  //更新时间

    @Column(name = "UPDATE_BY_", length = 50)
    @PropertyDef(label = "更新人")
    private String updateBy;  //更新人


}