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 org.springframework.format.annotation.DateTimeFormat;
|
|
import java.io.Serializable;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.List;
|
|
@Data
|
@TableName("\"SOURCE\".\"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 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= "备注")
|
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;
|
|
/**
|
* wms任务号
|
*/
|
@ApiModelProperty(value= "wms任务号")
|
@TableField("wms_wrk_no")
|
private String taskNo;
|
|
/**
|
* 结束时间
|
*/
|
@ApiModelProperty(value= "结束时间")
|
@TableField("end_time")
|
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
|
private Date endTime;
|
|
//命令list
|
@TableField(exist = false)
|
private List<CommandInfo> children;
|
|
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 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 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 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) + "秒";
|
}
|
|
}
|
