package com.zy.asrs.entity;
|
|
import com.alibaba.excel.annotation.ExcelIgnore;
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.format.DateTimeFormat;
|
import com.alibaba.excel.annotation.write.style.ColumnWidth;
|
import com.core.common.Cools;
|
import com.core.common.SpringUtils;
|
import com.zy.asrs.service.BasLocType1Service;
|
import com.zy.system.entity.User;
|
import com.zy.system.service.UserService;
|
import lombok.Data;
|
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
|
/**
|
* 入库明细统计
|
*
|
* @author admin
|
* @date 2018年11月26日
|
*/
|
@Data
|
public class ViewWorkInBean {
|
|
|
@ExcelIgnore
|
private Integer pageNumber;
|
|
@ExcelIgnore
|
private Integer pageSize;
|
|
@ExcelIgnore
|
private int stay_time;
|
|
@ExcelIgnore
|
private String begin_date;
|
|
@ExcelIgnore
|
private String end_date;
|
|
@ExcelIgnore
|
private String query_date;
|
|
@ExcelIgnore
|
private Integer row;
|
|
@ExcelIgnore
|
private String crn_str_time;
|
|
@ExcelIgnore
|
private String crn_end_time;
|
|
@ColumnWidth(15)
|
@ExcelProperty(value = "销售单号")
|
private String three_code;
|
|
@ExcelIgnore
|
@ExcelProperty(value = "工作号")
|
private Integer wrk_no;
|
|
@ColumnWidth(20)
|
@ExcelProperty(value = "入库时间")
|
private Date io_time;
|
|
@ColumnWidth(20)
|
@ExcelProperty(value = "库位号")
|
private String loc_no;
|
|
@ExcelProperty(value = "货架条码")
|
private String supp_code;
|
|
@ExcelProperty(value = "货架条码")
|
private String zpallet;
|
|
|
@ExcelIgnore
|
private Long loc_type1;
|
|
@ExcelProperty(value = "库位类型")
|
private String loc_type1$;
|
|
@ExcelProperty(value = "楼层")
|
private Integer floor;
|
|
|
@ExcelProperty(value = "数量")
|
private Double anfme;
|
|
@ColumnWidth(15)
|
@ExcelProperty(value = "物料号")
|
private String matnr;
|
|
@ColumnWidth(35)
|
@ExcelProperty(value = "物料名称")
|
private String maktx;
|
|
@ExcelProperty(value = "序列码")
|
private String batch;
|
|
@ExcelProperty(value = "单据编号")
|
private String order_no;
|
|
@ExcelProperty(value = "规格")
|
private String specs;
|
|
@ExcelProperty(value = "批次")
|
private String model;
|
|
@ExcelIgnore
|
private String color;
|
|
@ExcelProperty(value = "品牌")
|
private String brand;
|
|
@ExcelProperty(value = "单位")
|
private String unit;
|
|
@ExcelIgnore
|
private Double price;
|
|
@ExcelProperty(value = "sku")
|
private String sku;
|
|
@ExcelIgnore
|
private Double units;
|
|
@ExcelProperty(value = "条码")
|
private String barcode;
|
|
@ExcelIgnore
|
private String origin;
|
|
@ExcelIgnore
|
@ExcelProperty(value = "厂家")
|
private String manu;
|
|
@ExcelProperty(value = "单据时间")
|
private String manu_date;
|
|
@ExcelProperty(value = "品项数")
|
private String item_num;
|
|
@ExcelProperty(value = "安全库存量")
|
private Double safe_qty;
|
|
@ExcelProperty(value = "重量")
|
private Double weight;
|
@ExcelIgnore
|
@ExcelProperty(value = "长度")
|
private Double length;
|
@ExcelIgnore
|
@ExcelProperty(value = "体积")
|
private Double volume;
|
|
|
@ExcelProperty(value = "供应商")
|
private String supp;
|
|
|
@ExcelIgnore
|
@ExcelProperty(value = "是否批次 1: 是 0: 否 ")
|
private Integer be_batch;
|
|
@ExcelIgnore
|
@ExcelProperty(value = "保质期")
|
private String dead_time;
|
@ExcelIgnore
|
private String deadTime = dead_time;
|
@ExcelIgnore
|
@ExcelProperty(value = "预警天数")
|
private Integer dead_warn;
|
@ExcelIgnore
|
private Integer deadWarn = this.dead_warn;
|
@ExcelIgnore
|
@ExcelProperty(value = "制购 1: 制造 2: 采购 3: 外协 ")
|
private Integer source;
|
@ExcelIgnore
|
@ExcelProperty(value = "要求检验 1: 是 0: 否 ")
|
private Integer inspect;
|
@ExcelIgnore
|
@ExcelProperty(value = "危险品 1: 是 0: 否 ")
|
private Integer danger;
|
|
@ExcelProperty(value = "修改人员")
|
private Long modi_user;
|
|
@ExcelProperty(value = "修改时间")
|
private Date modi_time;
|
|
@ExcelProperty(value = "创建者")
|
private Long appe_user;
|
|
@ExcelProperty(value = "添加时间")
|
private Date appe_time;
|
|
@ExcelProperty(value = "备注")
|
private String memo;
|
|
@ExcelIgnore
|
@ExcelProperty(value = "工作号")
|
// 工作号
|
private Integer wrkNo;
|
@ExcelIgnore
|
@DateTimeFormat(value = "yyyy-MM-dd HH:mm:ss")
|
@ExcelProperty(value = "工作时间")
|
// 工作时间
|
private Date ioTime;
|
@ExcelIgnore
|
@ExcelProperty(value = "单据编号")
|
//单据编号
|
private String orderNo;
|
@ExcelIgnore
|
@ExcelProperty(value = "单据时间")
|
//单据时间
|
private String manuDate;
|
@ExcelIgnore
|
@ExcelProperty(value = "品项数")
|
//品项数
|
private String itemNum;
|
@ExcelIgnore
|
@ExcelProperty(value = "安全库存量")
|
//安全库存量
|
private Double safeQty;
|
@ExcelIgnore
|
@ExcelProperty(value = "销售单号")
|
//三方编码
|
private String threeCode;
|
@ExcelIgnore
|
@ExcelProperty(value = "供应商编码")
|
//供应商编码
|
private String suppCode;
|
@ExcelIgnore
|
@ExcelProperty(value = "师傅批次")
|
//是否批次 1: 是 0: 否
|
private Integer beBatch;
|
@ExcelIgnore
|
@ExcelProperty(value = "修改人员")
|
// 修改人员
|
private Long modiUser;
|
@ExcelIgnore
|
@ExcelProperty(value = "修改时间")
|
// 修改时间
|
private Date modiTime;
|
@ExcelIgnore
|
@ExcelProperty(value = "创建者")
|
// 创建者
|
private Long appeUser;
|
@ExcelIgnore
|
@ExcelProperty(value = "添加时间")
|
// 添加时间
|
private Date appeTime;
|
|
public void sype() {
|
// 工作号
|
wrkNo = wrk_no;
|
// 工作时间
|
ioTime = io_time;
|
//单据编号
|
orderNo = order_no;
|
//单据时间
|
manuDate = manu_date;
|
//品项数
|
itemNum = item_num;
|
//安全库存量
|
safeQty = safe_qty;
|
//三方编码
|
threeCode = three_code;
|
//供应商编码
|
suppCode = supp_code;
|
//是否批次 1: 是 0: 否
|
beBatch = be_batch;
|
// 修改人员
|
modiUser = modi_user;
|
// 修改时间
|
modiTime = modi_time;
|
// 创建者
|
appeUser = appe_user;
|
// 添加时间
|
appeTime = appe_time;
|
}
|
|
public String getLoc_type1$() {
|
BasLocType1Service service = SpringUtils.getBean(BasLocType1Service.class);
|
BasLocType1 basLocType1 = service.selectById(this.loc_type1);
|
if (!Cools.isEmpty(basLocType1)) {
|
return String.valueOf(basLocType1.getLocDesc());
|
}
|
return null;
|
}
|
|
public String getModiUser$() {
|
UserService service = SpringUtils.getBean(UserService.class);
|
User user = service.selectById(this.modi_user);
|
if (!Cools.isEmpty(user)) {
|
return String.valueOf(user.getUsername());
|
}
|
return null;
|
}
|
|
public String getAppeUser$() {
|
UserService service = SpringUtils.getBean(UserService.class);
|
User user = service.selectById(this.appe_user);
|
if (!Cools.isEmpty(user)) {
|
return String.valueOf(user.getUsername());
|
}
|
return null;
|
}
|
|
public String getIoTime$() {
|
if (Cools.isEmpty(this.io_time)) {
|
return "";
|
}
|
return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.io_time);
|
}
|
|
public void setQuery_date(String query_date) {
|
this.query_date = query_date;
|
if (query_date.contains(" - ")) {
|
String[] dates = query_date.split(" - ");
|
this.begin_date = dates[0];
|
this.end_date = dates[1];
|
|
}
|
}
|
|
}
|
