package com.ruoyi.cwgl.domain.vo; import com.baomidou.mybatisplus.annotation.TableField; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.common.annotation.Excel; import lombok.Data; import org.apache.poi.ss.usermodel.IndexedColors; import java.math.BigDecimal; import java.util.Date; /** * 调度单对象 dispatch_order * * @author ruoyi * @date 2025-07-29 */ @Data public class DispatchOrderVo { @Excel(name = "序号") private Integer id; @Excel(name = "系统调度单号") private String dispatchNo; @Excel(name = "系统子单号") private String subOrderNo; @Excel(name = "订单日期", width = 30, dateFormat = "yyyy-MM-dd") private Date createTime; @Excel(name = "客户名称") private String customerName; @Excel(name = "项目名称") private String projectName; @Excel(name = "业务类型") private String businessType; @Excel(name = "大陆车牌") private String licensePlateNumber; @Excel(name = "港澳车牌") private String hkPlateNo; @Excel(name = "大陆司机") private String mainDriverName; @Excel(name = "港澳司机") private String hkDriver; @Excel(name = "托架/柜号") private String vehiclePlateId; @Excel(name = "订单需求车型") private String vehicleType; @Excel(name = "运输供应商") private String transportSupplier; @Excel(name = "无缝申报单位") private String seamlessDeclarationUnit; @Excel(name = "无缝号") private String seamlessNo; @Excel(name = "装货地点") private String loadingPlace; @Excel(name = "通关口岸") private String customsPort; @Excel(name = "卸货地点") private String unloadingPlaces; @Excel(name = "多点卸货数量") private Integer unloadingPointCount; @Excel(name = "构件号") private String componentNo; @Excel(name = "构件尺寸") private String componentSize; @Excel(name = "卸货时间", width = 30, dateFormat = "yyyy-MM-dd") private Date unloadingTime; @Excel(name = "国内骑司及超时情况") private String delayStatus; @Excel(name = "备注") private String remark; // ------------------- 客户费用(人民币) ------------------- @Excel(name = "客户港车运费(人民币)",defaultValue = "0",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerHkFeeRmb; @Excel(name = "客户大陆车运费(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMainlandFeeRmb; @Excel(name = "客户报关费(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerCustomFeeRmb; @Excel(name = "客户多点装货(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMultiLoadFeeRmb; @Excel(name = "客户超宽费(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerOverWidthFeeRmb; @Excel(name = "客户压夜超时(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerOvernightFeeRmb; @Excel(name = "客户杂费(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMiscFeeRmb; @Excel(name = "客户合计(人民币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerTotalRmb; // ------------------- 客户费用(港币) ------------------- @Excel(name = "客户港车运费(港币)",defaultValue = "0",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerHkFeeHkd; @Excel(name = "客户大陆车运费(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMainlandFeeHkd; @Excel(name = "客户报关费(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerCustomFeeHkd; @Excel(name = "客户多点装货(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMultiLoadFeeHkd; @Excel(name = "客户超宽费(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerOverWidthFeeHkd; @Excel(name = "客户压夜超时(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerOvernightFeeHkd; @Excel(name = "客户杂费(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerMiscFeeHkd; @Excel(name = "客户合计(港币)",backgroundColor = IndexedColors.DARK_YELLOW) private BigDecimal customerTotalHkd; // ------------------- 供应商费用 ------------------- @Excel(name = "供应商名称",backgroundColor = IndexedColors.GREY_25_PERCENT) private String carrierName; // 人民币 @Excel(name = "供应商港车运费(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierHkFeeRmb; @Excel(name = "供应商大陆车运费(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMainlandFeeRmb; @Excel(name = "供应商报关费(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierCustomFeeRmb; @Excel(name = "供应商多点装货(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMultiLoadFeeRmb; @Excel(name = "供应商超宽费(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierOverWidthFeeRmb; @Excel(name = "供应商压夜超时(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierOvernightFeeRmb; @Excel(name = "供应商杂费(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMiscFeeRmb; @Excel(name = "供应商合计(人民币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierTotalRmb; // 港币 @Excel(name = "供应商港车运费(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierHkFeeHkd; @Excel(name = "供应商大陆车运费(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMainlandFeeHkd; @Excel(name = "供应商报关费(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierCustomFeeHkd; @Excel(name = "供应商多点装货(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMultiLoadFeeHkd; @Excel(name = "供应商超宽费(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierOverWidthFeeHkd; @Excel(name = "供应商压夜超时(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierOvernightFeeHkd; @Excel(name = "供应商杂费(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierMiscFeeHkd; @Excel(name = "供应商合计(港币)",backgroundColor = IndexedColors.GREY_25_PERCENT) private BigDecimal supplierTotalHkd; }