package com.ruoyi.purchase.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

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

/**
 * 采购台账对象 purchase_ledger
 *
 * @author ruoyi
 * @date 2025-05-09
 */
@TableName("purchase_ledger")
@Data
public class PurchaseLedger {
    private static final long serialVersionUID = 1L;

    /**
     * 自增主键ID
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 采购合同号
     */
    @Excel(name = "采购合同号")
    private String purchaseContractNumber;

    /**
     * 供应商名称id
     */
    private Long supplierId;

    /**
     * 供应商名称
     */
    @Excel(name = "供应商名称")
    private String supplierName;

    /**
     * 录入人姓名id
     */
    private Long recorderId;

    /**
     * 录入人姓名
     */
    @Excel(name = "录入人姓名")
    private String recorderName;

    /**
     * 销售合同号
     */
    @Excel(name = "销售合同号")
    private String salesContractNo;

    /**
     * 项目名称
     */
    @Excel(name = "项目名称")
    private String projectName;

    /**
     * 录入日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Excel(name = "录入日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date entryDate;

    /**
     * 申请提交时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date applicationSubmitTime;


    /**
     * 签订日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "签订日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date executionDate;

    /**
     * 备注
     */
    @Excel(name = "备注")
    private String remarks;

    /**
     * 附件材料路径或名称
     */
//    @Excel(name = "附件材料路径或名称")
    private String attachmentMaterials;

    /**
     * 记录创建时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "记录创建时间", width = 30, dateFormat = "yyyy-MM-dd")
    private Date createdAt;

    /**
     * 记录最后更新时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "记录最后更新时间", width = 30, dateFormat = "yyyy-MM-dd")
    private Date updatedAt;

    /**
     * 关联销售台账主表主键
     */
    private Long salesLedgerId;

    @TableField(fill = FieldFill.INSERT)
    private Long tenantId;

    /**
     * 合同金额（产品含税总价）
     */
    private BigDecimal contractAmount;

    /**
     * 实际合同金额（扣减退货后）
     */
    @Schema(description = "实际合同金额")
    private BigDecimal netContractAmount;
//
//    /**
//     * 业务员
//     */
//    @Excel(name = "业务员")
//    private String businessPerson;
//
//    /**
//     * 业务员id
//     */
//    private Long businessPersonId;

    /**
     * 业务员手机号
     */
    private String phoneNumber;

    @Schema(description = "文件类型  取 4")
    @TableField(exist = false)
    private Integer type;

    @Schema(description = "付款方式")
    private String paymentMethod;

    /**
     * 采购类别：客存、代储、采购入库、采购直销
     */
    @Schema(description = "采购类别")
    @Excel(name = "采购类别")
    private String purchaseCategory;

    /**
     * 采购油品：汽#92、汽#95、柴#0、柴#-35
     */
    @Schema(description = "采购油品")
    @Excel(name = "采购油品")
    private String purchaseOilProduct;

    /**
     * 物流方式：厂家配送、委外物流、客户自提
     */
    @Schema(description = "物流方式")
    @Excel(name = "物流方式")
    private String logisticsMethod;

    /**
     * 提货方式：暂不提货、提货
     */
    @Schema(description = "提货方式")
    @Excel(name = "提货方式")
    private String pickupMethod;

    /**
     * 采购油库id
     */
    @Schema(description = "采购油库id")
    private Long oilDepotId;

    /**
     * 采购油库名称
     */
    @Schema(description = "采购油库名称")
    @Excel(name = "采购油库")
    private String oilDepotName;

    /**
     * 客户名称
     */
    @Schema(description = "客户名称")
    private String customerName;

    /**
     * 最佳到站日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Schema(description = "最佳到站日期")
    private Date bestArrivalDate;

    /**
     * 采购数量（吨）
     */
    @Schema(description = "采购数量（吨）")
    private Integer purchaseQuantity;

    /**
     * 采购申请订单状态：已申请，未装车 / 以出厂，未入库 / 已入库
     */
    @Schema(description = "采购申请订单状态")
    private String purchaseOrderStatus;
    @Schema(description = "审批状态  1-待审核，2-审批中，3-审批通过，4-审批失败,5表示是模板")
    @Excel(name = "审批状态", readConverterExp = "1=待审核,2=审批中,3=审批通过,4=审批失败")
    private Integer approvalStatus;

    @Schema(description = "模板名称")
    private String templateName;
    @Schema(description = "审批人id")
    private String approveUserIds;

    @Schema(description = "创建用户")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @TableField(fill = FieldFill.INSERT)
    private Long deptId;
}