package com.zy.asrs.entity; import com.baomidou.mybatisplus.annotations.TableField; import com.baomidou.mybatisplus.annotations.TableId; import com.baomidou.mybatisplus.annotations.TableName; import com.baomidou.mybatisplus.enums.IdType; import com.core.common.Cools; import com.core.common.SpringUtils; import com.zy.asrs.service.*; import com.zy.system.entity.User; import com.zy.system.service.UserService; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.text.SimpleDateFormat; import java.util.Date; @Data @TableName("asr_wrk_mast_log") public class WrkMastLog implements Serializable { private static final long serialVersionUID = 1L; /** * 编号 */ @ApiModelProperty(value = "编号") @TableId(value = "id", type = IdType.AUTO) private Long id; /** * 工作号 */ @ApiModelProperty(value = "工作号") @TableField("wrk_no") private Integer wrkNo; @ApiModelProperty(value = "") @TableField("inv_wh") private String invWh; @ApiModelProperty(value = "") private Date ymd; @ApiModelProperty(value = "") private String mk; @ApiModelProperty(value = "") @TableField("whs_type") private Integer whsType; /** * 工作状态 */ @ApiModelProperty(value = "工作状态") @TableField("wrk_sts") private Long wrkSts; /** * 入出库类型 */ @ApiModelProperty(value = "入出库类型") @TableField("io_type") private Integer ioType; /** * 堆垛机号 */ @ApiModelProperty(value = "堆垛机号") @TableField("crn_no") private Integer crnNo; @ApiModelProperty(value = "") @TableField("sheet_no") private String sheetNo; /** * 优先级 */ @ApiModelProperty(value = "优先级") @TableField("io_pri") private Double ioPri; @ApiModelProperty(value = "") @TableField("wrk_date") private Date wrkDate; /** * 目标库位 */ @ApiModelProperty(value = "目标库位") @TableField("loc_no") private String locNo; /** * 目标站 */ @ApiModelProperty(value = "目标站") @TableField("sta_no") private Integer staNo; /** * 源站 */ @ApiModelProperty(value = "源站") @TableField("source_sta_no") private Integer sourceStaNo; /** * 源库位 */ @ApiModelProperty(value = "源库位") @TableField("source_loc_no") private String sourceLocNo; @ApiModelProperty(value = "") @TableField("loc_sts") private String locSts; /** * 拣料 */ @ApiModelProperty(value = "拣料") private String picking; @ApiModelProperty(value = "") @TableField("link_mis") private String linkMis; @ApiModelProperty(value = "") @TableField("online_yn") private String onlineYn; @ApiModelProperty(value = "") @TableField("upd_mk") private String updMk; /** * 退出 */ @ApiModelProperty(value = "退出") @TableField("exit_mk") private String exitMk; @ApiModelProperty(value = "") @TableField("plt_type") private Integer pltType; /** * 空板 */ @ApiModelProperty(value = "空板") @TableField("empty_mk") private String emptyMk; /** * 工作时间 */ @ApiModelProperty(value = "工作时间") @TableField("io_time") private Date ioTime; @ApiModelProperty(value = "") @TableField("ctn_type") private Integer ctnType; @ApiModelProperty(value = "") private String packed; @ApiModelProperty(value = "") @TableField("ove_mk") private String oveMk; @ApiModelProperty(value = "") @TableField("mtn_type") private Double mtnType; @ApiModelProperty(value = "") @TableField("user_no") private String userNo; /** * 堆垛机启动时间 */ @ApiModelProperty(value = "堆垛机启动时间") @TableField("crn_str_time") private Date crnStrTime; /** * 堆垛机停止时间 */ @ApiModelProperty(value = "堆垛机停止时间") @TableField("crn_end_time") private Date crnEndTime; /** * 拣料时间 */ @ApiModelProperty(value = "拣料时间") @TableField("plc_str_time") private Date plcStrTime; @ApiModelProperty(value = "") @TableField("crn_pos_time") private Date crnPosTime; @ApiModelProperty(value = "") @TableField("load_time") private Double loadTime; @ApiModelProperty(value = "") @TableField("exp_time") private Double expTime; @ApiModelProperty(value = "") @TableField("ref_wrkno") private Double refWrkno; @ApiModelProperty(value = "") @TableField("ref_iotime") private Date refIotime; /** * 修改人员 */ @ApiModelProperty(value = "修改人员") @TableField("modi_user") private Long modiUser; /** * 修改时间 */ @ApiModelProperty(value = "修改时间") @TableField("modi_time") private Date modiTime; /** * 创建者 */ @ApiModelProperty(value = "创建者") @TableField("appe_user") private Long appeUser; /** * 添加时间 */ @ApiModelProperty(value = "添加时间") @TableField("appe_time") private Date appeTime; @ApiModelProperty(value = "") @TableField("pause_mk") private String pauseMk; @ApiModelProperty(value = "") @TableField("error_time") private Date errorTime; @ApiModelProperty(value = "") @TableField("error_memo") private String errorMemo; @ApiModelProperty(value = "") @TableField("ctn_kind") private Integer ctnKind; @ApiModelProperty(value = "") @TableField("manu_type") private String manuType; @ApiModelProperty(value = "") @TableField("memo") private String memo; @ApiModelProperty(value = "") @TableField("sc_weight") private Double scWeight; @ApiModelProperty(value = "") @TableField("log_mk") private String logMk; @ApiModelProperty(value = "") @TableField("log_err_time") private Date logErrTime; @ApiModelProperty(value = "") @TableField("log_err_memo") private String logErrMemo; /** * 条码 */ @ApiModelProperty(value = "条码") private String barcode; @ApiModelProperty(value = "") @TableField("Pdc_type") private String PdcType; @ApiModelProperty(value = "") @TableField("ctn_no") private String ctnNo; /** * 满板 */ @ApiModelProperty(value = "满板") @TableField("full_plt") private String fullPlt; /** * 穿梭车 */ @ApiModelProperty(value = "两向穿梭车") @TableField("ste_no") private Integer steNo; /** * 穿梭车 */ @ApiModelProperty(value = "四向穿梭车") @TableField("shuttle_no") private Integer shuttleNo; /** * 结束时间 */ @ApiModelProperty(value = "结束时间") @TableField("end_time") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date endTime; public WrkMastLog() { } public String getWrkNo$() { WrkMastService service = SpringUtils.getBean(WrkMastService.class); WrkMast wrkMast = service.selectById(this.wrkNo); if (!Cools.isEmpty(wrkMast)) { return String.valueOf(wrkMast.getWrkNo()); } return null; } public String getYmd$() { if (Cools.isEmpty(this.ymd)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ymd); } public String getWrkSts$() { BasWrkStatusService service = SpringUtils.getBean(BasWrkStatusService.class); BasWrkStatus basWrkStatus = service.selectById(this.wrkSts); if (!Cools.isEmpty(basWrkStatus)) { return String.valueOf(basWrkStatus.getWrkDesc()); } return null; } public String getIoType$() { BasWrkIotypeService service = SpringUtils.getBean(BasWrkIotypeService.class); BasWrkIotype basWrkIotype = service.selectById(this.ioType); if (!Cools.isEmpty(basWrkIotype)) { return String.valueOf(basWrkIotype.getIoDesc()); } return null; } public String getCrnNo$() { BasCrnpService service = SpringUtils.getBean(BasCrnpService.class); BasCrnp basCrnp = service.selectById(this.crnNo); if (!Cools.isEmpty(basCrnp)) { return String.valueOf(basCrnp.getCrnNo()); } return null; } public String getWrkDate$() { if (Cools.isEmpty(this.wrkDate)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.wrkDate); } public String getLocNo$() { LocMastService service = SpringUtils.getBean(LocMastService.class); LocMast locMast = service.selectById(this.locNo); if (!Cools.isEmpty(locMast)) { return String.valueOf(locMast.getLocNo()); } return null; } public String getStaNo$() { BasDevpService service = SpringUtils.getBean(BasDevpService.class); BasDevp basDevp = service.selectById(this.staNo); if (!Cools.isEmpty(basDevp)) { return String.valueOf(basDevp.getDevNo()); } return null; } public String getSourceStaNo$() { BasDevpService service = SpringUtils.getBean(BasDevpService.class); BasDevp basDevp = service.selectById(this.sourceStaNo); if (!Cools.isEmpty(basDevp)) { return String.valueOf(basDevp.getDevNo()); } return null; } public String getSourceLocNo$() { LocMastService service = SpringUtils.getBean(LocMastService.class); LocMast locMast = service.selectById(this.sourceLocNo); if (!Cools.isEmpty(locMast)) { return String.valueOf(locMast.getLocNo()); } return null; } public String getIoTime$() { if (Cools.isEmpty(this.ioTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ioTime); } public String getCrnStrTime$() { if (Cools.isEmpty(this.crnStrTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.crnStrTime); } public String getCrnEndTime$() { if (Cools.isEmpty(this.crnEndTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.crnEndTime); } public String getPlcStrTime$() { if (Cools.isEmpty(this.plcStrTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.plcStrTime); } public String getCrnPosTime$() { if (Cools.isEmpty(this.crnPosTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.crnPosTime); } public String getRefIotime$() { if (Cools.isEmpty(this.refIotime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.refIotime); } public String getModiUser$() { UserService service = SpringUtils.getBean(UserService.class); User user = service.selectById(this.modiUser); if (!Cools.isEmpty(user)) { return String.valueOf(user.getUsername()); } return null; } public String getModiTime$() { if (Cools.isEmpty(this.modiTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.modiTime); } public String getAppeUser$() { UserService service = SpringUtils.getBean(UserService.class); User user = service.selectById(this.appeUser); if (!Cools.isEmpty(user)) { return String.valueOf(user.getUsername()); } return null; } public String getAppeTime$() { if (Cools.isEmpty(this.appeTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime); } public String getErrorTime$() { if (Cools.isEmpty(this.errorTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.errorTime); } public String getLogErrTime$() { if (Cools.isEmpty(this.logErrTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.logErrTime); } public String getEndTime$() { if (Cools.isEmpty(this.endTime)) { return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.endTime); } /** * 获取持续时间 */ public String getDurationTime() { if (Cools.isEmpty(this.ioTime)) { return ""; } Date endDate = new Date(); if (!Cools.isEmpty(this.endTime)) { endDate = this.endTime; } //用来获取两个时间相差的毫秒数 long l = this.ioTime.getTime() - endDate.getTime(); //分别计算相差的天、小时、分、秒 long day = l / (24 * 60 * 60 * 1000); long hour = (l / (60 * 60 * 1000) - day * 24); long min = ((l / (60 * 1000)) - day * 24 * 60 - hour * 60); long s = (l / 1000 - day * 24 * 60 * 60 - hour * 60 * 60 - min * 60); return Math.abs(day) + "天" + Math.abs(hour) + "小时" + Math.abs(min) + "分" + Math.abs(s) + "秒"; } }