package com.ruoyi.sales.dto; import com.ruoyi.framework.aspectj.lang.annotation.Excel; import lombok.Data; import java.math.BigDecimal; import java.util.Date; /** *
* 销售发货历史数据导入-未发货 *
* * @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; }