package com.sunda.spmsorder.entity.vo;

import com.github.crab2died.annotation.ExcelField;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * 全生命周期报表Excel导出类
 * @author hzc
 *
 */
@Data
public class OrderKeyDatesReportVO {

	//工厂名称(中文)	工厂  车间名称(CN)	车间代码	车需求申请人	车间请购单创建日期	内部订单号	车间请购单号	车间请购单标题	车间请购单行号	工厂请购单创建日期	工厂需求申请人	工厂请购单号	工厂请购单行号	物料编码	物料描述	单位	申请数量	批准数量	安全库存数量	工厂下物料总库存	在途库存	紧急程度	运输方式	OA流程Id	国内交货单号	箱码	箱码明细行号	国内收货数量	装箱单号	是否海运	箱码状态	箱状态	OA审批日期	国内到货日期	国内出库日期	海外到货日期	耗费时间


	@ApiModelProperty(value = "工厂名称(中文)")
	@ExcelField(title = "werksNameZh", order = 1)
	String werksNameZh;

	@ApiModelProperty(value = "工厂")
	@ExcelField(title = "werks", order = 2)
	String werks;

	@ApiModelProperty(value = "车间名称(CN)")
	@ExcelField(title = "workshopNameZh", order = 3)
	String workshopNameZh;

	@ApiModelProperty(value = "车间代码")
	@ExcelField(title = "workshopCode", order = 4)
	String workshopCode;

	@ApiModelProperty(value = "车间需求申请人")
	@ExcelField(title = "orderWorkshopUsername", order = 5)
	String orderWorkshopUsername;

	@ApiModelProperty(value = "车间请购单创建日期")
	@ExcelField(title = "orderWorkshopApplicationDate", order = 6)
	String orderWorkshopApplicationDate;

	@ApiModelProperty(value = "内部订单号")
	@ExcelField(title = "orderWerksFieldForOa", order = 7)
	String orderWerksFieldForOa;

	@ApiModelProperty(value = "车间请购单号")
	@ExcelField(title = "orderWorkshopId", order = 8)
	String orderWorkshopId;

	@ApiModelProperty(value = "车间请购单标题")
	@ExcelField(title = "orderWorkshopSubject", order = 9)
	String orderWorkshopSubject;

	@ApiModelProperty(value = "车间请购单行号")
	@ExcelField(title = "orderWorkshopRowId", order = 10)
	String orderWorkshopRowId;

	@ApiModelProperty(value = "工厂请购单创建日期")
	@ExcelField(title = "orderWerksApplicationDate", order = 11)
	String orderWerksApplicationDate;

	@ApiModelProperty(value = "工厂需求申请人")
	@ExcelField(title = "orderWerksUsername", order = 12)
	String orderWerksUsername;

	@ApiModelProperty(value = "工厂请购单号")
	@ExcelField(title = "orderWerksId", order = 13)
	String orderWerksId;

	@ApiModelProperty(value = "工厂请购单行号")
	@ExcelField(title = "orderWerksRowId", order = 14)
	String orderWerksRowId;

	@ApiModelProperty(value = "物料编码")
	@ExcelField(title = "materialNo", order = 15)
	String materialNo;

	@ApiModelProperty(value = "物料描述")
	@ExcelField(title = "materialZhDesc", order = 16)
	String materialZhDesc;

	@ApiModelProperty(value = "单位")
	@ExcelField(title = "basicUnit", order = 17)
	String basicUnit;

	@ApiModelProperty(value = "申请数量")
	@ExcelField(title = "requestQty", order = 18)
	String requestQty;

	@ApiModelProperty(value = "批准数量")
	@ExcelField(title = "approvalQty", order = 19)
	String approvalQty;

	@ApiModelProperty(value = "安全库存数量")
	@ExcelField(title = "safetyQtyBasicUnit", order = 20)
	String safetyQtyBasicUnit;

	@ApiModelProperty(value = "工厂下物料总库存")
	@ExcelField(title = "werksInventory", order = 21)
	String werksInventory;

	@ApiModelProperty(value = "在途库存")
	@ExcelField(title = "wayQuantity", order = 22)
	String wayQuantity;

	@ApiModelProperty(value = "紧急程度")
	@ExcelField(title = "urgency", order = 23)
	String urgency;

	@ApiModelProperty(value = "运输方式")
	@ExcelField(title = "orderWerksShippingFangshi", order = 24)
	String orderWerksShippingFangshi;

	@ApiModelProperty(value = "OA流程Id")
	@ExcelField(title = "oaProcessId", order = 25)
	String oaProcessId;

	@ApiModelProperty(value = "国内交货单号")
	@ExcelField(title = "deliveryNote", order = 26)
	String deliveryNote;

	@ApiModelProperty(value = "箱码")
	@ExcelField(title = "boxNote", order = 27)
	String boxNote;

	@ApiModelProperty(value = "箱码明细行号")
	@ExcelField(title = "boxNoteItem", order = 28)
	String boxNoteItem;

	@ApiModelProperty(value = "国内收货数量")
	@ExcelField(title = "domesticQtyReceived", order = 29)
	String domesticQtyReceived;

	@ApiModelProperty(value = "装箱单号")
	@ExcelField(title = "packageList", order = 30)
	String packageList;

	@ApiModelProperty(value = "是否海运")
	@ExcelField(title = "shippingType", order = 31)
	String shippingType;

	@ApiModelProperty(value = "箱码状态")
	@ExcelField(title = "boxStatus", order = 32)
	String boxStatus;

	@ApiModelProperty(value = "箱状态")
	@ExcelField(title = "boxStatusDesc", order = 33)
	String boxStatusDesc;

	@ApiModelProperty(value = "OA审批日期")
	@ExcelField(title = "oaApprovalDate", order = 34)
	String oaApprovalDate;

	@ApiModelProperty(value = "国内到货日期")
	@ExcelField(title = "domesticArrivalDate", order = 35)
	String domesticArrivalDate;

	@ApiModelProperty(value = "国内出库日期")
	@ExcelField(title = "domesticDeliveryDate", order = 36)
	String domesticDeliveryDate;

	@ApiModelProperty(value = "海外到货日期")
	@ExcelField(title = "overseaArrivalDate", order = 37)
	String overseaArrivalDate;

	@ApiModelProperty(value = "耗费时间")
	@ExcelField(title = "daysSpent", order = 38)
	String daysSpent;

	@ApiModelProperty(value = "需求状态")
	@ExcelField(title = "prStatus", order = 39)
	String prStatus;

	@ApiModelProperty(value = "线下合同号")
	@ExcelField(title = "internalOrderNo", order = 40)
	String internalOrderNo;

	@ApiModelProperty(value = "采购专员")
	@ExcelField(title = "fbk32", order = 41)
	String fbk32;

	@ApiModelProperty(value = "采购工程师")
	@ExcelField(title = "fbk29", order = 42)
	String fbk29;

	@ApiModelProperty(value = "SRM采购订单号")
	@ExcelField(title = "srmOrderNo", order = 43)
	String srmOrderNo;

	@ApiModelProperty(value = "SAP采购订单号")
	@ExcelField(title = "sapOrderNo", order = 44)
	String sapOrderNo;

	@ApiModelProperty(value = "采购订单创建时间")
	@ExcelField(title = "poCreateDate", order = 45)
	String poCreateDate;

	@ApiModelProperty(value = "定商定价时间")
	@ExcelField(title = "priceReviewTime", order = 46)
	String priceReviewTime;

	@ApiModelProperty(value = "解锁原因")
	@ExcelField(title = "priceReviewTime", order = 47)
	String unlockReason;

	@ApiModelProperty(value = "装箱单行号")
	@ExcelField(title = "packageListItem", order = 47)
	String packageListItem;

	@ApiModelProperty(value = "国内拆箱数量")
	@ExcelField(title = "gnsjsl", order = 48)
	String gnsjsl;

	@ApiModelProperty(value = "柜号")
	@ExcelField(title = "zaituCabno", order = 49)
	String zaituCabno;

	@ApiModelProperty(value = "海外采购订单")
	@ExcelField(title = "zaituEbeln", order = 50)
	String zaituEbeln;

	@ApiModelProperty(value = "采购订单行号")
	@ExcelField(title = "zaituEbelp", order = 51)
	String zaituEbelp;

	@ApiModelProperty(value = "预计到港日期")
	@ExcelField(title = "zaituDgdat", order = 52)
	String zaituDgdat;

	@ApiModelProperty(value = "海外交货单")
	@ExcelField(title = "zaituVbeln", order = 53)
	String zaituVbeln;

	@ApiModelProperty(value = "海外交货单行号")
	@ExcelField(title = "zaituPosnr", order = 54)
	String zaituPosnr;

	@ApiModelProperty(value = "国内发货数量")
	@ExcelField(title = "zaituMenge", order = 55)
	String zaituMenge;

	@ApiModelProperty(value = "海外收货数量")
	@ExcelField(title = "zaituWamng", order = 56)
	String zaituWamng;


//	{
//		"orderWerksJustification": "1",
//			"materialNo": "130013984",
//			"orderWerksShippingFangshi": "0",
//			"overseaArrivalDate": null,
//			"orderWerksUsername": "黄志聪(Crede Huang)",
//			"approvalQty": 2,
//			"domesticArrivalDate": null,
//			"werksInventory": 0,
//			"orderWorkshopSubject": "TF01-机电车间-彭勇忠(Shane Peng)-2022-07-21",
//			"orderWerksUserid": "0113390",
//			"orderWorkshopUsername": "彭勇忠(Shane Peng)",
//			"orderWorkshopRowId": 10,
//			"orderWerksShippingType": null,
//			"requestQty": 2,
//			"boxNote": null,
//			"whsOutUuid": null,
//			"materialZhDesc": "雨鞋 绿色43 SUNDABEST 15PAA/CTN",
//			"materialEnDesc": "RAIN SHOSE GREEN 43",
//			"safetyQtyBasicUnit": 0,
//			"urgency": "0",
//			"oaProcessId": "0703",
//			"orderWorkshopApplicationDate": "2022-07-21",
//			"boxNoteItem": null,
//			"orderWorkshopId": "TF01-EL-20220721-001",
//			"wayQuantity": 0,
//			"deliveryNote": null,
//			"workshopNameZh": null,
//			"orderWerksFieldForOa": null,
//			"basicUnit": "PAA",
//			"domesticQtyReceived": null,
//			"orderWerksApplicationDate": "2022-08-04",
//			"oaApprovalDate": "2022-08-06",
//			"packageList": null,
//			"boxStatus": "1",
//			"rowId": 1,
//			"werks": "CN01",
//			"werksNameZh": "广州市森大贸易有限公司",
//			"daysSpent": null,
//			"orderWorkshopUserid": "0113509",
//			"orderWerksRowId": 10,
//			"domesticDeliveryDate": null,
//			"operationType": null,
//			"workshopCode": "EL",
//			"boxStatusDesc": "箱码待生成",
//			"orderWerksId": "-2022-001"
//	}


}