package com.ruoyi.tms.domain;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.common.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
@TableName("tms_dispatch_fee_summary_vi")
public class TmsDispatchFeeSummaryVi {

    /** 派车单ID */
    @TableId
    private Long dispatchId;
    /** 下单时间 */
    @Excel(name = "日期",dateFormat = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date orderTime;
    @TableField(exist = false)
    private String orderTimeBegin;
    @TableField(exist = false)
    private String orderTimeEnd;


    /** 客户名称 */
    @Excel(name = "客户")
    private String customerName;

    /** 项目名称 */
    @Excel(name = "项目名称")
    private String projectName;
    //运输路线
    @TableField(exist = false)
    private String address;

    /** 发货区域 */
    @Excel(name = "装货地区域")
    private String shipperRegionLabel;
    /** 发货地址 */
    @Excel(name = "装货地地址")
    private String shipperAddress;



    /** 收货区域 */
    @Excel(name = "卸货地区域")
    private String receiverRegionLabel;

    /** 收货地址 */
    @Excel(name = "卸货地地址")
    private String receiverAddress;


    /** 要求车型 */
    @Excel(name = "下单车型",dictType="vehicle_type")
    private String requiredVehicleTypes;

    /** 派车单号 */
    @Excel(name = "调度单号")
    private String dispatchNo;



    /** 派车单状态 */
    @Excel(name = "状态",dictType="tms_dispatch_order_status")
    private Integer status;


    /** 承运商名称（按自营/非自营逻辑） */
    @Excel(name = "承运商")
    private String providerName;



    /** 车牌 */
    @Excel(name = "车牌")
    private String licensePlate;
    @Excel(name = "香港车牌")
    private String licenseHk;
    @Excel(name = "澳门车牌")
    private String licenseMo;


    /** 主司机 */
    @Excel(name = "司机")
    private String mainDriverName;

    /** 实际车型 */
    @Excel(name = "承运车型",dictType="vehicle_type")
    private String actualVehicleType;



    /** 货架号 */
    @Excel(name = "托架")
    private String shelfCode;

    /** 柜号 */
    @Excel(name = "柜号")
    private String containerNo;




    /** 口岸 */
    @Excel(name = "口岸")
    private String port;
    /** 无缝供应商名称 */
    @Excel(name = "无缝供应商")
    private String seamlessSupplierName;

    /** 无缝号 */
    @Excel(name = "无缝号")
    private String seamlessNumber;

    /** 无缝供应商 */
    private Integer seamlessSupplierId;

    /** 是否查验 */
    @Excel(name = "查验",dictType = "sys_number_is")
    private Integer iscc;

    /** 报关服务商 */
    @Excel(name = "报关服务商")
    private String customsServiceProviderName;
    /** 装卸服务商 */
    @Excel(name = "装卸服务商")
    private String loadingServiceProviderName;



    /* ================= 应付 ================= */
    @Excel(name = "应付运费（人民币）",scale = 4)
    private BigDecimal pShippingFeeRmb;
    @Excel(name = "应付运费（港币）",scale = 4)
    private BigDecimal pShippingFeeHkd;
    @Excel(name = "应付增值服务（人民币）",scale = 4)
    private BigDecimal pServerFeeRmb;
    @Excel(name = "应付增值服务（港币）",scale = 4)
    private BigDecimal pServerFeeHkd;
    @Excel(name = "应付实报实销（人民币）",scale = 4)
    private BigDecimal pActualFeeRmb;
    @Excel(name = "应付实报实销（港币）",scale = 4)
    private BigDecimal pActualFeeHkd;

    /** 应付合计（人民币） */
    @Excel(name = "应付小计（人民币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal pTotalRmb;
    @Excel(name = "应付小计（港币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal pTotalHkd;



    /* ================= 应收 ================= */
    @Excel(name = "应收运费（人民币）",scale = 4)
    private BigDecimal rShippingFeeRmb;
    @Excel(name = "应收运费（港币）",scale = 4)
    private BigDecimal rShippingFeeHkd;
    @Excel(name = "应收增值服务（人民币）",scale = 4)
    private BigDecimal rServerFeeRmb;
    @Excel(name = "应收增值服务（港币）",scale = 4)
    private BigDecimal rServerFeeHkd;
    @Excel(name = "应收实报实销（人民币）",scale = 4)
    private BigDecimal rActualFeeRmb;
    @Excel(name = "应收实报实销（港币）",scale = 4)
    private BigDecimal rActualFeeHkd;

    /** 应收合计（人民币） */
    @Excel(name = "应收小计（人民币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal rTotalRmb;
    @Excel(name = "应收小计（港币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal rTotalHkd;


    /* ================= 毛利 ================= */

    /** 毛利（人民币） */
    @Excel(name = "毛利（人民币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal grossProfitRmb;
    /** 毛利（港币） */
    @Excel(name = "毛利（港币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal grossProfitHkd;
    /** 毛利率（人民币） */
    @Excel(name = "毛利率（人民币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal grossProfitRadioRmb;
    /** 毛利率（港币） */
    @Excel(name = "毛利率（港币）",scale = 4)
    @TableField(exist = false)
    private BigDecimal grossProfitRadioHkd;




}