package com.ruoyi.inspect.pojo; import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; import com.alibaba.excel.annotation.ExcelProperty; import com.baomidou.mybatisplus.annotation.*; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.time.LocalDate; import java.time.LocalDateTime; /** * 检验下单 * @TableName ins_order */ @Data @TableName("ins_order") @ExcelIgnoreUnannotated public class InsOrder implements Serializable { @Schema(description = "主键") @TableId(type = IdType.AUTO) private Integer id; @ExcelProperty(index = 0, value = "委托编号") @Schema(description = "委托编号") private String entrustCode; @Schema(description = "外部委托编号") private String outEntrustCode; @Schema(description = "检验类别") private String orderType; @Schema(description = "下单客户") private String custom; @ExcelProperty(index = 1, value = "委托单位") @Schema(description = "委托单位") private String company; @Schema(description = "联系方式") private String phone; @Schema(description = "工厂域") private String code; @Schema(description = "紧急程度 (0普通 1优先 2紧急)") private Integer type; @ExcelProperty(index = 9, value = "约定时间%") @Schema(description = "约定时间") @TableField(fill = FieldFill.INSERT) @JsonFormat(pattern = "yyyy-MM-dd") private LocalDate appointed; @Schema(description = "检验结果, 0 不合格, 1合格") private Integer insResult; @Schema(description = "样品处理方式") private Integer processing; @Schema(description = "是否留样") private Integer isLeave; @Schema(description = "状态:-1:原材料撤回 0:待审核 1:样品接收/检验处理 2:退回 3:撤销 4:已检验 5:作废") private Integer state; @ExcelProperty(index = 7, value = "备注") @Schema(description = "备注") private String remark; @Schema(description = "备注英文") private String remarkEn; @Schema(description = "OTC订单号") private String otcCode; @Schema(description = "下单人") @TableField(fill = FieldFill.INSERT) private Integer createUser; @Schema(description = "下单时间") @TableField(fill = FieldFill.INSERT) @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime createTime; @Schema(description = "下发时间") @TableField(fill = FieldFill.INSERT) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime sendTime; @Schema(description = "") @TableField(fill = FieldFill.INSERT_UPDATE) private Integer updateUser; @Schema(description = "修改时间") @TableField(fill = FieldFill.INSERT_UPDATE) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime updateTime; @Schema(description = "下单人id") private Integer userId; @Schema(description = "是否有配套样品") private Integer mating; @Schema(description = "检验状态(0:待检验 1:检验中 2:已检验 3:待复核 4:复核未通过 5:复核通过)") private Integer insState; @Schema(description = "检验工厂") private String factory; @Schema(description = "实验室名称") private String laboratory; @Schema(description = "样品类型") private String sampleType; @Schema(description = "样品名称") private String sample; @Schema(description = "检验时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private LocalDateTime insTime; @Schema(description = "退回理由") private String tell; @Schema(description = "报告发送方式 1: 自取, 0:其他") private Integer send; @Schema(description = "来样方式") private String formType; @Schema(description = "审核时间") private LocalDateTime examineTime; @Schema(description = "工程名称") private String engineering; @Schema(description = "工程名称英文") private String engineeringEn; @Schema(description = "生产单位") private String production; @Schema(description = "生产单位英文") private String productionEn; @Schema(description = "客户单位id") private Long companyId; @Schema(description = "委托人id") private Integer prepareUserId; @ExcelProperty(index = 12, value = "委托人") @Schema(description = "委托人") private String prepareUser; @Schema(description = "委托人英文") private String prepareUserEn; @Schema(description = "委托人工号") private String prepareCode; @Schema(description = "是否审核撤销") private Integer isRevocation; @Schema(description = "审核撤销的项目id") private String revocationInsProductIds; @Schema(description = "是否为原材料 1 是 0 否") private Integer typeSource; @Schema(description = "原材料id") private Long ifsInventoryId; @Schema(description = "抽查数量") private String testQuantity; @Schema(description = "零件描述") private String partDetail; @Schema(description = "是否是免检, 0否 1是") private Integer isExemption; @Schema(description = "温度") private String temperature; @Schema(description = "湿度") private String humidity; @TableField(exist = false) @Schema(description = "当前填写环境条件的模板ID") private Integer templateId; @Schema(description = "样品状态") private String sampleStatus; @Schema(description = "送样日期") @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private LocalDate sampleDate; @Schema(description = "生产日期") @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private LocalDate productionDate; @Schema(description = "生产批号") private String productionBatch; @Schema(description = "季度抽样项目id") private Integer quarterItemId; @Schema(description = "样品名称(报告展示字段)") private String sampleView; @Schema(description = "样品名称引文(报告展示字段)") private String sampleViewEn; @Schema(description = "是否是第一次提交0否1是") private Integer isFirstSubmit; @Schema(description = "第一次提交时间") private LocalDateTime firstSubmitDate; @Schema(description = "首次保存检验模板值时间") private LocalDateTime firstInspectDate; @Schema(description = "分包内容 0无 1有") private Integer subcontractType; @Schema(description = "分包单位信息") private String subcontractCompany; @Schema(description = "样品处置 1委托方取回 2检测方处置") private Integer sampleDisposal; @Schema(description = "对结果评价 0否 1是") private Integer resultEvaluation; @Schema(description = "报告交付方式 1自取 2快递 3电子传送") private Integer reportDelivery; @Schema(description = "报告寄送地址") private String reportAddress; @Schema(description = "收件人及电话") private String reportReceiver; @Schema(description = "样机员(除了其他成品外这个字段必选,用于企业微信推送)") @TableField(exist = false) private Integer issueUser; }