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];

        }
    }

}