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 Long id;
|
|
/**
|
* 打印记录ID/唯一标识
|
*/
|
@Column(name = "mp_id", length = 50)
|
private String mpId;
|
|
/**
|
* 第五次拟付金额
|
*/
|
@Column(name = "fifth_planned_payment_amount", precision = 18, scale = 2)
|
private String fifthPlannedPaymentAmount;
|
|
/**
|
* 拟付日期
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Column(name = "planned_payment_date")
|
private Date plannedPaymentDate;
|
|
/**
|
* 类别
|
*/
|
@Column(name = "category", length = 100)
|
private String category;
|
|
/**
|
* 报销人
|
*/
|
@Column(name = "reimburser", length = 100)
|
private String reimburser;
|
|
/**
|
* 实付金额
|
*/
|
@Column(name = "actual_payment_amount", precision = 18, scale = 2)
|
private String actualPaymentAmount;
|
|
/**
|
* 实付日期
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Column(name = "actual_payment_date")
|
private Date 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;
|
}
|
