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; //更新人
|
|
|
}
|
