package com.java110.po.importFee;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 第五次拟付实付记录表实体类
 * 对应表：mp_fifth_payment_record
 */
@Data
@Entity
@Table(name = "mp_fifth_payment_record")
public class MpFifthPaymentRecord {

    /**
     * 主键ID
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", nullable = false, updatable = false)
    private String id;

    /**
     * 打印记录ID/唯一标识
     */
    @Column(name = "mp_id", length = 50)
    private String mpId;

    /**
     * 第五次拟付金额
     */
    @Column(name = "fifth_planned_payment_amount", precision = 18, scale = 2)
    private String fifthPlannedPaymentAmount;

    /**
     * 拟付日期
     */
    @Column(name = "planned_payment_date")
    private String plannedPaymentDate;

    /**
     * 类别
     */
    @Column(name = "category", length = 100)
    private String category;

    private String paymentTarget;

    private Integer paymentCount;
    /**
     * 报销人
     */
    @Column(name = "reimburser", length = 100)
    private String reimburser;

    /**
     * 实付金额
     */
    @Column(name = "actual_payment_amount", precision = 18, scale = 2)
    private String actualPaymentAmount;

    /**
     * 实付日期
     */
    @Column(name = "actual_payment_date")
    private String actualPaymentDate;

    // 以下为补充字段（如果需要）
    private int row;
    private int page;
    
    /**
     * 开始日期（查询用）
     */
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Transient
    private Date startDate;
    
    /**
     * 结束日期（查询用）
     */
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Transient
    private Date endDate;
    
    /**
     * 差额（实付 - 拟付）
     */
    @Transient
    private String paymentDifference;
    
    /**
     * 状态（计算字段）
     */
    @Transient
    private String paymentStatus;
    
    /**
     * 备注
     */
    @Transient
    private String remarks;
    
    /**
     * 支付方式
     */
    @Transient
    private String paymentMethod;
    
    /**
     * 银行账号
     */
    @Transient
    private String bankAccount;
    
    /**
     * 开户行
     */
    @Transient
    private String openingBank;
}