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_payment_record
|
*/
|
@Data
|
@Entity
|
@Table(name = "mp_payment_record")
|
public class MpPaymentRecord {
|
|
/**
|
* 主键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 = "first_print_date")
|
private String firstPrintDate;
|
|
public void setFirstPrintDate(String firstPrintDate) {
|
if (firstPrintDate != null) {
|
firstPrintDate = firstPrintDate.split(" 00:00:00")[0];;
|
}
|
this.firstPrintDate = firstPrintDate;
|
}
|
|
/**
|
* 决议编号
|
*/
|
@Column(name = "resolution_number", length = 50)
|
private String resolutionNumber;
|
|
|
@Column(name = "snake_case")
|
private String snakeCase;
|
|
/**
|
* 打印金额
|
*/
|
@Column(name = "print_amount", precision = 18, scale = 2)
|
private String printAmount;
|
|
/**
|
* 到账日期
|
*/
|
@Column(name = "arrival_date")
|
private String arrivalDate;
|
|
public void setArrivalDate(String arrivalDate) {
|
if (arrivalDate != null) {
|
arrivalDate = arrivalDate.split(" 00:00:00")[0];
|
}
|
this.arrivalDate = arrivalDate;
|
}
|
|
/**
|
* 到账金额
|
*/
|
@Column(name = "arrival_amount", precision = 18, scale = 2)
|
private String arrivalAmount;
|
|
/**
|
* 支取人
|
*/
|
@Column(name = "withdrawer", length = 100)
|
private String withdrawer;
|
|
/**
|
* 缺支/欠款（元）
|
*/
|
@Column(name = "shortage_or_arrears", precision = 18, scale = 2)
|
private String shortageOrArrears;
|
|
/**
|
* 路名
|
*/
|
@Column(name = "road_name", length = 100)
|
private String roadName;
|
|
/**
|
* 弄
|
*/
|
@Column(name = "lane", length = 50)
|
private String lane;
|
|
/**
|
* 门
|
*/
|
@Column(name = "door", length = 50)
|
private String door;
|
|
/**
|
* 室
|
*/
|
@Column(name = "room", length = 50)
|
private String room;
|
|
/**
|
* 业主地址
|
*/
|
@Column(name = "owner_address", length = 255)
|
private String ownerAddress;
|
|
// 以下为补充字段（如果需要）
|
private int row;
|
private int page;
|
|
/**
|
* 支付公司名称/或个人名字
|
*/
|
@Transient
|
private String payeeName;
|
|
/**
|
* 个人身份证号码（如果是个人）
|
*/
|
@Transient
|
private String idCardNumber;
|
|
/**
|
* 开户银行
|
*/
|
@Transient
|
private String bankName;
|
|
/**
|
* 开户账号
|
*/
|
@Transient
|
private String bankAccount;
|
|
/**
|
* 备注
|
*/
|
@Transient
|
private String remarks;
|
|
/**
|
* 验收日期
|
*/
|
@Transient
|
private String acceptanceDate;
|
|
public void setAcceptanceDate(String acceptanceDate) {
|
if (acceptanceDate != null) {
|
acceptanceDate = acceptanceDate.split(" 00:00:00")[0];
|
}
|
this.acceptanceDate = acceptanceDate;
|
}
|
|
/**
|
* 审计情况：年/月
|
*/
|
@Transient
|
private String auditDate;
|
|
/**
|
* 项目编码（如有需要）
|
*/
|
@Transient
|
private String projectCode;
|
|
/**
|
* 项目名称（如有需要）
|
*/
|
@Transient
|
private String projectName;
|
|
/**
|
* 基金类型-一级分类（如有需要）
|
*/
|
@Transient
|
private String fundTypeLevel1;
|
|
/**
|
* 基金类型-二级分类（如有需要）
|
*/
|
@Transient
|
private String fundTypeLevel2;
|
|
/**
|
* 维修类型（如有需要）
|
*/
|
@Transient
|
private String maintenanceType;
|
|
/**
|
* 支取存在问题（如有需要）
|
*/
|
@Transient
|
private String withdrawalProblem;
|
|
/**
|
* 问题难度（如有需要）
|
*/
|
@Transient
|
private String problemDifficulty;
|
|
/**
|
* 可启动支取日期（如有需要）
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Transient
|
private Date availableWithdrawalDate;
|
|
/**
|
* 门室号（组合字段）
|
*/
|
@Transient
|
private String doorRoomNumber;
|
|
/**
|
* 起始（年月日）
|
*/
|
@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 Integer year;
|
|
/**
|
* 月份（如有需要）
|
*/
|
@Transient
|
private Integer month;
|
|
/**
|
* 日（如有需要）
|
*/
|
@Transient
|
private Integer day;
|
|
/**
|
* 日期（通用日期字段）
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Transient
|
private Date date;
|
|
private String printCount;
|
}
|
