package com.ruoyi.sales.dto;
|
|
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
/**
|
* <br>
|
* 销售发货历史数据导入-未发货
|
* </br>
|
*
|
* @author deslrey
|
* @version 1.0
|
* @since 2026/4/22 11:47
|
*/
|
@Data
|
public class SalesNotShippingImportDto {
|
|
// --- 基本信息 ---
|
@Excel(name = "自序")
|
private Long sequence;
|
|
@Excel(name = "分厂")
|
private String branchFactory;
|
|
@Excel(name = "订单类型")
|
private String orderType;
|
|
@Excel(name = "报表日期", width = 30, dateFormat = "yyyy/MM/dd HH:mm:ss")
|
private Date reportDate;
|
|
@Excel(name = "订单编号")
|
private String orderNo;
|
|
@Excel(name = "合同编号")
|
private String contractNo;
|
|
@Excel(name = "对方单号")
|
private String customerOrderNo;
|
|
@Excel(name = "订单序号")
|
private String orderSortNo;
|
|
@Excel(name = "楼层编号")
|
private String floorNo;
|
|
// --- 产品信息 ---
|
@Excel(name = "产品名称")
|
private String productName;
|
|
@Excel(name = "客户编号")
|
private String customerCode;
|
|
@Excel(name = "客户名称")
|
private String customerName;
|
|
@Excel(name = "工程编号")
|
private String projectNo;
|
|
@Excel(name = "项目名称")
|
private String projectName;
|
|
@Excel(name = "结算币种")
|
private String currency;
|
|
@Excel(name = "业务员")
|
private String salesman;
|
|
@Excel(name = "交货期限", width = 30, dateFormat = "yyyy/MM/dd HH:mm:ss")
|
private Date deliveryDeadline;
|
|
// --- 规格与数量 ---
|
@Excel(name = "宽")
|
private BigDecimal width;
|
|
@Excel(name = "高")
|
private BigDecimal height;
|
|
@Excel(name = "数量")
|
private BigDecimal quantity;
|
|
@Excel(name = "实际单片面积")
|
private BigDecimal actualSingleArea;
|
|
@Excel(name = "实际面积")
|
private BigDecimal actualTotalArea;
|
|
@Excel(name = "结算单片面积")
|
private BigDecimal settlementSingleArea;
|
|
@Excel(name = "结算面积")
|
private BigDecimal settlementTotalArea;
|
|
// --- 金额与费用 ---
|
@Excel(name = "单价")
|
private BigDecimal unitPrice;
|
|
@Excel(name = "玻璃金额")
|
private BigDecimal glassAmount;
|
|
@Excel(name = "其它加工费")
|
private BigDecimal otherProcessFee;
|
|
// --- 工艺参数 ---
|
@Excel(name = "周长")
|
private BigDecimal perimeter;
|
|
@Excel(name = "磨边长度")
|
private BigDecimal grindingLength;
|
|
@Excel(name = "磨边等级")
|
private String grindingLevel;
|
|
@Excel(name = "加工要求")
|
private String processRequirement;
|
|
@Excel(name = "图号")
|
private String drawingNo;
|
|
@Excel(name = "示意图号")
|
private String sketchNo;
|
|
@Excel(name = "模板图号")
|
private String templateNo;
|
|
@Excel(name = "R")
|
private String radiusR;
|
|
@Excel(name = "形状")
|
private String shape;
|
|
@Excel(name = "异形参数")
|
private String irregularParam;
|
|
@Excel(name = "胶深")
|
private String glueDepth;
|
|
// --- 物流与流程 ---
|
@Excel(name = "送货地址")
|
private String deliveryAddress;
|
|
@Excel(name = "制单员")
|
private String creator;
|
|
@Excel(name = "审核人")
|
private String auditor;
|
|
@Excel(name = "产品大类")
|
private String productCategory;
|
|
@Excel(name = "产品子类")
|
private String productSubCategory;
|
|
@Excel(name = "付款条件")
|
private String paymentTerms;
|
|
@Excel(name = "付款方式")
|
private String paymentMethod;
|
|
@Excel(name = "备注")
|
private String remark;
|
|
@Excel(name = "玻璃厚度")
|
private BigDecimal glassThickness;
|
|
@Excel(name = "总厚度")
|
private BigDecimal totalThickness;
|
|
@Excel(name = "重箱")
|
private BigDecimal heavyBox;
|
|
@Excel(name = "订单工艺流程")
|
private String processFlow;
|
|
@Excel(name = "审核后备注")
|
private String auditRemark;
|
|
@Excel(name = "打孔")
|
private BigDecimal drilling;
|
|
@Excel(name = "挖缺")
|
private BigDecimal notching;
|
|
@Excel(name = "安全角")
|
private BigDecimal safetyCorner;
|
|
@Excel(name = "磨边(异形)")
|
private BigDecimal grindingIrregular;
|
}
|
