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.mapper.BasWrkIotypeMapper; import com.zy.asrs.mapper.BasWrkStatusMapper; 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 java.io.Serializable; import java.text.SimpleDateFormat; import java.util.Date; @Data @TableName("asr_wrk_mast") public class WrkMast implements Serializable { private static final long serialVersionUID = 1L; /** * 工作号 */ @ApiModelProperty(value= "工作号") @TableId(value = "wrk_no", type = IdType.INPUT) @TableField("wrk_no") private Long 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; /** * RGV号 */ @ApiModelProperty(value= "RGV") @TableField("rgv_no") private Integer rgvNo; /** * 徐工汉云拆垛标记 0: 初始 1、未拆已上报 2: 已拆 3:已处理可下一步(转历史档) */ @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; /** * RGV源站 */ @ApiModelProperty(value= "RGV源站") @TableField("rgv_ssta_no") private Integer rgvSstaNo; /** * RGV目标站 */ @ApiModelProperty(value= "RGV目标站") @TableField("rgv_dsta_no") private Integer rgvDstaNo; @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= "备注") 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("work_no_other") private Integer workNoOther; public String getWrkSts$(){ BasWrkStatusMapper mapper = SpringUtils.getBean(BasWrkStatusMapper.class); BasWrkStatus entity = mapper.selectById(this.wrkSts); if (entity != null) { return entity.getWrkDesc(); } return null; } public String getIoType$(){ BasWrkIotypeMapper mapper = SpringUtils.getBean(BasWrkIotypeMapper.class); BasWrkIotype entity = mapper.selectById(this.ioType); if (entity != null) { return entity.getIoDesc(); } 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 getWrkDate$(){ if (Cools.isEmpty(this.wrkDate)){ return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.wrkDate); } 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 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 Date getAppeTime() { return appeTime; } 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 void setErrorMemo(String errorMemo) { if (errorMemo.length() > 255) { errorMemo = errorMemo.substring(0, 150); } this.errorMemo = errorMemo; } public String getLogErrTime$(){ if (Cools.isEmpty(this.logErrTime)){ return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.logErrTime); } public Integer getIoTypeMes$(){ if (this.ioType != 101){ return 3; } else { return 1; } } public Integer getStaNoCs(){ switch (staNo){ case 120: return 102; case 124: return 104; case 128: return 106; case 132: return 108; case 133: return 110; case 102: return 120; case 104: return 124; case 106: return 128; case 108: return 132; case 110: return 133; } return 0; } public Integer getSourceNoCs(){ switch (sourceStaNo){ case 101: return 119; case 103: return 123; case 105: return 127; case 107: return 131; case 109: return 132; case 119: return 101; case 123: return 103; case 127: return 105; case 131: return 107; case 132: return 109; } return 0; } }