package com.ruoyi.cwgl.domain; import java.math.BigDecimal; import java.util.Date; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.common.annotation.Excel; import com.baomidou.mybatisplus.annotation.TableField; import java.util.Date; import lombok.Data; /** * 待入账业务对象 pending_settlement_business * * @author ruoyi * @date 2025-08-07 */ @Data public class PendingSettlementBusiness{ /** ID */ @TableField("id") private Integer id; /** 客户订单号 */ @Excel(name = "客户订单号") @TableField("booking_no") private String bookingNo; /** 客户id */ @Excel(name = "客户id") @TableField("customer_id") private String customerId; /** 承运商id */ @Excel(name = "承运商id") @TableField("carrier_id") private String carrierId; /** 项目名称 */ @Excel(name = "项目名称") @TableField("project_name") private String projectName; /** 调度单号 */ @Excel(name = "调度单号") @TableField("dispatch_no") private String dispatchNo; /** 下单时间 */ @Excel(name = "下单时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("created_time") private Date createdTime; /** 运输方式 */ @Excel(name = "运输方式") @TableField("transport_mode") private String transportMode; /** 服务产品 */ @Excel(name = "服务产品") @TableField("product_id") private String productId; /** 客户名称 */ @Excel(name = "客户名称") @TableField("customer_name") private String customerName; /** 运营模式(自营/外协) */ @Excel(name = "运营模式", readConverterExp = "自=营/外协") @TableField("operation_mode") private String operationMode; /** 承运商 */ @Excel(name = "承运商") @TableField("carrier_name") private String carrierName; /** 出发地 */ @Excel(name = "出发地") @TableField("departure_location") private String departureLocation; /** 目的地 */ @Excel(name = "目的地") @TableField("arrival_location") private String arrivalLocation; /** 运输工具ID */ @Excel(name = "运输工具ID") @TableField("vehicle_id") private String vehicleId; /** 车牌 */ @Excel(name = "车牌") @TableField("license_plate_number") private String licensePlateNumber; /** 车型 */ @Excel(name = "车型") @TableField("vehicle_type") private String vehicleType; /** 主驾驶员 */ @Excel(name = "主驾驶员") @TableField("main_driver") private String mainDriver; /** 副驾驶员 */ @Excel(name = "副驾驶员") @TableField("assistant_driver") private String assistantDriver; /** 提送货点数 */ @Excel(name = "提送货点数") @TableField("point_num") private Integer pointNum; /** 业务联系人 */ @Excel(name = "业务联系人") @TableField("business_contact") private String businessContact; /** 预估总收入 */ @Excel(name = "预估总收入") @TableField("estimated_total_income") private BigDecimal estimatedTotalIncome; /** 预估总成本 */ @Excel(name = "预估总成本") @TableField("estimated_total_cost") private BigDecimal estimatedTotalCost; /** 预估利润 */ @Excel(name = "预估利润") @TableField("estimated_profit") private BigDecimal estimatedProfit; /** 电子锁 */ @Excel(name = "电子锁") @TableField("electronic_lock") private String electronicLock; /** 复磅重量 */ @Excel(name = "复磅重量") @TableField("re_weighing_weight") private BigDecimal reWeighingWeight; /** 件数 */ @Excel(name = "件数") @TableField("quantity") private Integer quantity; /** 实际出发时间 */ @Excel(name = "实际出发时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("actual_departure_time") private Date actualDepartureTime; /** 要求到达时间 */ @Excel(name = "要求到达时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("required_arrival_time") private Date requiredArrivalTime; /** 实际到达时间 */ @Excel(name = "实际到达时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("actual_arrival_time") private Date actualArrivalTime; /** 是否回程 */ @Excel(name = "是否回程") @TableField("be_return") private String beReturn; /** 实发件数 */ @Excel(name = "实发件数") @TableField("dispatch_quantity") private Integer dispatchQuantity; /** 实发重量(千克) */ @Excel(name = "实发重量", readConverterExp = "千=克") @TableField("dispatch_weight") private BigDecimal dispatchWeight; /** 实发体积(立方) */ @Excel(name = "实发体积(立方)") @TableField("dispatch_volume") private BigDecimal dispatchVolume; /** 空载里程(公里) */ @Excel(name = "空载里程", readConverterExp = "公=里") @TableField("empty_mileage") private BigDecimal emptyMileage; /** 空载油耗(升) */ @Excel(name = "空载油耗", readConverterExp = "升=") @TableField("empty_fuel") private BigDecimal emptyFuel; /** 重载里程(公里) */ @Excel(name = "重载里程", readConverterExp = "公=里") @TableField("heavy_mileage") private BigDecimal heavyMileage; /** 重载油耗(升) */ @Excel(name = "重载油耗", readConverterExp = "重载油耗(升)") @TableField("heavy_fuel") private BigDecimal heavyFuel; /** 是否按班次 */ @Excel(name = "是否按班次") @TableField("be_scheduled") private String beScheduled; /** 快递单号 */ @Excel(name = "快递单号") @TableField("tracking_no") private String trackingNo; /** 铅封号 */ @Excel(name = "铅封号") @TableField("seal_no") private String sealNo; /** 班次号 */ @Excel(name = "班次号") @TableField("schedule_no") private String scheduleNo; /** 运输状态 */ @Excel(name = "运输状态") @TableField("transport_status") private String transportStatus; /** 预估账单ID */ @Excel(name = "预估账单ID") @TableField("estimated_bill_id") private String estimatedBillId; /** 结算账单ID */ @Excel(name = "结算账单ID") @TableField("settlement_bill_id") private String settlementBillId; /** 结算状态 */ @Excel(name = "结算状态") @TableField("settlement_status") private String settlementStatus; /** 创建时间 */ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("create_time") private Date createTime; /** 更新时间 */ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @TableField("update_time") private Date updateTime; }