package com.zy.asrs.entity; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.util.Date; @Data @TableName("asr_wrk_analysis") public class WrkAnalysis implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "工作号") @TableId(value = "wrk_no", type = IdType.INPUT) private Integer wrkNo; @ApiModelProperty(value = "WMS任务号") @TableField("wms_wrk_no") private String wmsWrkNo; @ApiModelProperty(value = "入出库类型") @TableField("io_type") private Integer ioType; @ApiModelProperty(value = "最终工作状态") @TableField("final_wrk_sts") private Long finalWrkSts; @ApiModelProperty(value = "源站") @TableField("source_sta_no") private Integer sourceStaNo; @ApiModelProperty(value = "目标站") @TableField("sta_no") private Integer staNo; @ApiModelProperty(value = "源库位") @TableField("source_loc_no") private String sourceLocNo; @ApiModelProperty(value = "目标库位") @TableField("loc_no") private String locNo; @ApiModelProperty(value = "堆垛机号") @TableField("crn_no") private Integer crnNo; @ApiModelProperty(value = "双工位堆垛机号") @TableField("dual_crn_no") private Integer dualCrnNo; @ApiModelProperty(value = "RGV号") @TableField("rgv_no") private Integer rgvNo; @ApiModelProperty(value = "创建时间") @TableField("appe_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date appeTime; @ApiModelProperty(value = "完成时间") @TableField("finish_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date finishTime; @ApiModelProperty(value = "总耗时毫秒") @TableField("total_duration_ms") private Long totalDurationMs; @ApiModelProperty(value = "站点开始时间") @TableField("station_start_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date stationStartTime; @ApiModelProperty(value = "站点结束时间") @TableField("station_end_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date stationEndTime; @ApiModelProperty(value = "站点耗时毫秒") @TableField("station_duration_ms") private Long stationDurationMs; @ApiModelProperty(value = "堆垛机开始时间") @TableField("crane_start_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date craneStartTime; @ApiModelProperty(value = "堆垛机结束时间") @TableField("crane_end_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date craneEndTime; @ApiModelProperty(value = "堆垛机耗时毫秒") @TableField("crane_duration_ms") private Long craneDurationMs; @ApiModelProperty(value = "是否故障") @TableField("has_fault") private Integer hasFault; @ApiModelProperty(value = "故障次数") @TableField("fault_count") private Integer faultCount; @ApiModelProperty(value = "故障耗时毫秒") @TableField("fault_duration_ms") private Long faultDurationMs; @ApiModelProperty(value = "单堆垛机故障次数") @TableField("crn_fault_count") private Integer crnFaultCount; @ApiModelProperty(value = "单堆垛机故障耗时毫秒") @TableField("crn_fault_duration_ms") private Long crnFaultDurationMs; @ApiModelProperty(value = "双工位堆垛机故障次数") @TableField("dual_crn_fault_count") private Integer dualCrnFaultCount; @ApiModelProperty(value = "双工位堆垛机故障耗时毫秒") @TableField("dual_crn_fault_duration_ms") private Long dualCrnFaultDurationMs; @ApiModelProperty(value = "RGV故障次数") @TableField("rgv_fault_count") private Integer rgvFaultCount; @ApiModelProperty(value = "RGV故障耗时毫秒") @TableField("rgv_fault_duration_ms") private Long rgvFaultDurationMs; @ApiModelProperty(value = "数据完整性") @TableField("metric_completeness") private String metricCompleteness; @ApiModelProperty(value = "创建时间") @TableField("create_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date createTime; @ApiModelProperty(value = "更新时间") @TableField("update_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date updateTime; }