package com.zy.asrs.entity;

import com.alibaba.excel.annotation.ExcelProperty;
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 io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.text.SimpleDateFormat;
import java.util.Date;

@Data
@TableName("asr_pla_detl")
public class Pla {
    @ApiModelProperty(value= "ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    //入库时间
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date pakinTime;

    //主体
    @ExcelProperty(value = "主体")
    @TableField("owner")
    private String owner;

    //主体
    @ExcelProperty(value = "物资类别")
    @TableField("type")
    private String type;

    //生产订单编号
    @ExcelProperty(value = "生产订单编号")
    @TableField("pro_order_no")
    private String proOrderNo;

    //车间
    @ExcelProperty(value = "生产车间")
    @TableField("workshop")
    private String workshop;

    //生产线
    @ExcelProperty(value = "生产线")
    @TableField("line")
    private String line;

    //生产线
    @ExcelProperty(value = "存货编码")
    @TableField("matnr")
    private String matnr;

    //牌号
    @ExcelProperty(value = "牌号")
    @TableField("brand")
    private String brand;

    //批号
    @TableField("batch")
    @ExcelProperty(value = "批号")
    private String batch;

    //包装号
    @TableField("package_no")
    @ExcelProperty(value = "包装号")
    private Integer packageNo;

    //牌号
    @ExcelProperty(value = "关联牌号")
    @TableField("new_brand")
    private String newBrand;

    //批号
    @TableField("new_batch")
    @ExcelProperty(value = "关联批号")
    private String newBatch;

    //包装号
    @TableField("new_package_no")
    @ExcelProperty(value = "关联包装号")
    private Integer newPackageNo;

    //包装号
    @ExcelProperty(value = "生产日期")
    @TableField("pro_date")
    private String proDate;

    //重量
    @TableField("weight")
    @ExcelProperty(value = "重量KG")
    private Double weight;

    @ApiModelProperty(value= "单位")
    //@ExcelProperty(value = "单位")
    @TableField("unit")
    private String unit;

    //包装类型
    @TableField("package_type")
    @ExcelProperty(value = "包装类型")
    private String packageType;

    //托盘类型
    @TableField("zpallet_type")
    @ExcelProperty(value = "托盘类型")
    private String zpalletType;

    //缠膜
    @TableField("film_wrap")
    @ExcelProperty(value = "缠膜")
    private String filmWrap;

    //熔指
    @TableField("finger_melting")
    @ExcelProperty(value = "熔指,g/10min")
    private Double fingerMelting;

    //水分
    @TableField("water")
    @ExcelProperty(value = "水分,ppm")
    private Double water;

    //熔点
    @TableField("fusing_point")
    @ExcelProperty(value = "熔点,℃")
    private Double fusingPoint;

    //挥发份1
    @TableField("vadf1")
    @ExcelProperty(value = "挥发段,%")
    private Double vadf1;

    //挥发份2
    @TableField("vadf2")
    @ExcelProperty(value = "分解段,%")
    private Double vadf2;

    //黄度
    @TableField("yellowness")
    @ExcelProperty(value = "黄度")
    private Double yellowness;

    //不透明度
    @TableField("opacity")
    @ExcelProperty(value = "不透明度,%")
    private Double opacity;

    //L值
    @TableField("l")
    @ExcelProperty(value = "L*")
    private Double l;

    //a值
    @TableField("a")
    @ExcelProperty(value = "a*")
    private Double a;

    //b值
    @TableField("b")
    @ExcelProperty(value = "b*")
    private Double b;

    //填充
    @TableField("fill_in")
    @ExcelProperty(value = "填充,%")
    private Double fillIn;

    @ExcelProperty(value = "拉伸强度,MPa")
    private String str1;

    @ExcelProperty(value = "断裂伸长率,%")
    private String str2;

    @ExcelProperty(value = "缺口冲击,KJ/m2")
    private String str3;

    @ExcelProperty(value = "维卡,℃")
    private String str4;

    @ExcelProperty(value = "半结晶时间,min")
    private String str5;

    @ExcelProperty(value = "结晶度.%")
    private String str6;

//    @ExcelProperty(value = "填充")
    private String str7;
//
//    @ExcelProperty(value = "填充")
    private String str8;


    //质量状态
    @TableField("mass_state")
    @ExcelProperty(value = "质量状态")
    private String massState;

    //质量问题
    @TableField("problem")
    @ExcelProperty(value = "备注")
    private String problem;

    //应用方向
    @ExcelProperty(value = "应用方向")
    @TableField("direction")
    private String direction;

    //存放位置
    @ExcelProperty(value = "存放位置")
    @TableField("position")
    private String position;

    //剩余重量
    @TableField("weight_anfme")
    @ExcelProperty(value = "入库量")
    private Double weightAnfme = 0.0;
    //待出库数量
    @TableField("qty_anfme")
    private Double qtyAnfme = 0.0;

    //仓库
    @TableField("stash")
    //@ExcelProperty(value = "仓库")
    private String stash;

    //库位
    @TableField("loc_no")
    @ExcelProperty(value = "库位")
    private String locNo;

    //状态
    @TableField("status")
    private String status;

    //步骤
    @TableField("step")
    private Integer step;

    @TableField("create_time")
    private Date createTime;

    @TableField("modify_time")
    private Date modifyTime;

    @TableField("create_user")
    private String createUser;

    @TableField("modify_user")
    private String modifyUser;

    @TableField("order_no")
    private String orderNo;

    @TableField("pakout_time")
    private String pakoutTime;

    @TableField("order_weight")
    private Double orderWeight;

    @TableField("handler_by")
    private String handlerBy;

    @TableField("transfer")
    private String transfer;

    @TableField("customer")
    private String customer;

    @TableField("allocate")
    private String allocate;

    @TableField("memo")
    private String memo;

    @TableField("stock_freeze")
    private Integer stockFreeze;

    @TableField("stock_freeze_by")
    private String stockFreezeBy;

    @TableField("stock_freeze_date")
    private Date stockFreezeDate;

    public String getCreateTime$() {
        if (Cools.isEmpty(this.createTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd").format(this.createTime);
    }

    public String getPackageNo$(){
        if(Cools.isEmpty(packageNo)){
            return null;
        }
        if(packageNo < 10){
            return "00" + packageNo;
        }else if(packageNo < 100){
            return "0" + packageNo;
        }else {
            return packageNo + "";
        }

    }

    public String getPakinTime$() {
        if (Cools.isEmpty(this.pakinTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.pakinTime);
    }

    public String getStockFreezeDate$() {
        if (Cools.isEmpty(this.stockFreezeDate)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.stockFreezeDate);
    }
}