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 SalesShippingImportDto {

    @Excel(name = "自序")
    private Long sequence;

    @Excel(name = "分厂")
    private String branchFactory;

    @Excel(name = "价格审核")
    private String priceAudit;

    @Excel(name = "订单类型")
    private String orderType;

    @Excel(name = "报表日期", width = 30, dateFormat = "yyyy/MM/dd HH:mm:ss")
    private Date reportDate;

    @Excel(name = "发货编号")
    private String shippingNo;

    @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 paymentTerms;

    @Excel(name = "业务员")
    private String salesman;

    @Excel(name = "车号")
    private String carNo;

    @Excel(name = "订单编号")
    private String orderNo;

    @Excel(name = "合同编号")
    private String contractNo;

    @Excel(name = "对方单号")
    private String customerOrderNo;

    @Excel(name = "产品大类")
    private String productCategory;

    @Excel(name = "产品子类")
    private String productSubCategory;

    @Excel(name = "产品名称")
    private String productName;

    @Excel(name = "数量")
    private BigDecimal quantity;

    @Excel(name = "单价")
    private BigDecimal unitPrice;

    @Excel(name = "实际面积")
    private BigDecimal actualArea;

    @Excel(name = "结算面积")
    private BigDecimal settlementArea;

    @Excel(name = "玻璃金额")
    private BigDecimal glassAmount;

    @Excel(name = "其他加工费")
    private BigDecimal otherProcessFee;

    @Excel(name = "金额")
    private BigDecimal totalAmount;

    @Excel(name = "重箱")
    private String heavyBox;

    @Excel(name = "重量")
    private BigDecimal weight;

    @Excel(name = "单据加工要求")
    private String orderProcessRequirement;

    @Excel(name = "单据备注")
    private String orderRemark;

    @Excel(name = "审核后备注")
    private String auditRemark;

    @Excel(name = "送货地址")
    private String deliveryAddress;

    @Excel(name = "制单员")
    private String creator;

    @Excel(name = "玻璃厚度")
    private String glassThickness;

    @Excel(name = "成品厚度")
    private String productThickness;

    @Excel(name = "mm平方")
    private BigDecimal mmSquare;

    @Excel(name = "产品简称")
    private String productShortName;

    @Excel(name = "运输方式")
    private String transportType;

    @Excel(name = "价格审核人")
    private String priceAuditor;

    @Excel(name = "价格审核日期", width = 30, dateFormat = "yyyy/MM/dd")
    private Date priceAuditDate;

    @Excel(name = "联系人")
    private String contactPerson;

    @Excel(name = "联系电话")
    private String contactPhone;

    @Excel(name = "一级地区")
    private String regionLevel1;

    @Excel(name = "二级地区")
    private String regionLevel2;

    @Excel(name = "打孔")
    private Integer holeCount;

    @Excel(name = "挖缺")
    private Integer notchCount;

    @Excel(name = "安全角")
    private Integer safetyCornerCount;

    @Excel(name = "磨边(异形)")
    private String irregularGrinding;
}