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;
|
|
/**
|
* 维修资金支取信息表实体类
|
* 对应表：maintenance_payment
|
*/
|
@Data
|
@Entity
|
@Table(name = "maintenance_payment")
|
public class MaintenancePayment {
|
|
/**
|
* 主键ID
|
*/
|
@Id
|
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
@Column(name = "id", nullable = false, updatable = false)
|
private String id;
|
|
/**
|
* 辅助列
|
*/
|
@Column(name = "auxiliary_column", length = 50)
|
private String auxiliaryColumn;
|
|
/**
|
* 流转编号
|
*/
|
@Column(name = "flow_number", length = 50)
|
private String flowNumber;
|
|
/**
|
* 序号
|
*/
|
@Column(name = "serial_number")
|
private String serialNumber;
|
|
|
@Column(name = "payment_target")
|
private String paymentTarget;
|
|
/**
|
* 项目编码
|
*/
|
@Column(name = "project_code", length = 50)
|
private String projectCode;
|
|
/**
|
* 项目名称
|
*/
|
@Column(name = "project_name", length = 255)
|
private String projectName;
|
|
/**
|
* 年份
|
*/
|
@Column(name = "year")
|
private String year;
|
|
/**
|
* 月份
|
*/
|
@Column(name = "month")
|
private String month;
|
|
/**
|
* 日
|
*/
|
@Column(name = "day")
|
private String day;
|
|
/**
|
* 日期
|
*/
|
@Column(name = "date")
|
private String date;
|
|
/**
|
* 工程内容
|
*/
|
@Column(name = "project_content", columnDefinition = "TEXT")
|
private String projectContent;
|
|
/**
|
* 管理处金额
|
*/
|
@Column(name = "management_office_amount", precision = 18, scale = 2)
|
private String managementOfficeAmount;
|
|
/**
|
* 管理处是否已盖章（是/否）
|
*/
|
@Enumerated(EnumType.STRING)
|
@Column(name = "management_office_seal", length = 2)
|
private String managementOfficeSeal;
|
|
/**
|
* 业委会金额
|
*/
|
@Column(name = "owners_committee_amount", precision = 18, scale = 2)
|
private String ownersCommitteeAmount;
|
|
/**
|
* 审价金额
|
*/
|
@Column(name = "audit_amount", precision = 18, scale = 2)
|
private String auditAmount;
|
|
/**
|
* 业委会是否已盖章（是/否）
|
*/
|
@Enumerated(EnumType.STRING)
|
@Column(name = "owners_committee_seal", length = 2)
|
private String ownersCommitteeSeal;
|
|
/**
|
* 签报部门
|
*/
|
@Column(name = "report_department", length = 100)
|
private String reportDepartment;
|
|
/**
|
* 基金类型-一级分类
|
*/
|
@Column(name = "fund_type_level1", length = 100)
|
private String fundTypeLevel1;
|
|
/**
|
* 基金类型-二级分类
|
*/
|
@Column(name = "fund_type_level2", length = 100)
|
private String fundTypeLevel2;
|
|
/**
|
* 幢/全体
|
*/
|
@Column(name = "building_or_all", length = 50)
|
private String buildingOrAll;
|
|
/**
|
* 维修类型
|
*/
|
@Column(name = "maintenance_type", length = 100)
|
private String maintenanceType;
|
|
/**
|
* 质保期（第一个）
|
*/
|
@Column(name = "quality_guarantee_period1", length = 50)
|
private String qualityGuaranteePeriod1;
|
|
/**
|
* 公共收益金公布情况
|
*/
|
@Column(name = "public_income_announcement", length = 50)
|
private String publicIncomeAnnouncement;
|
|
/**
|
* 业委会公约
|
*/
|
@Column(name = "owners_committee_convention", columnDefinition = "TEXT")
|
private String ownersCommitteeConvention;
|
|
/**
|
* 支取存在问题
|
*/
|
@Column(name = "withdrawal_problem", columnDefinition = "TEXT")
|
private String withdrawalProblem;
|
|
/**
|
* 问题难度
|
*/
|
@Column(name = "problem_difficulty", length = 50)
|
private String problemDifficulty;
|
|
/**
|
* 可启动支取日期（年月日）
|
*/
|
@Column(name = "available_withdrawal_date")
|
private String availableWithdrawalDate;
|
|
/**
|
* 质保期（第二个）
|
*/
|
@Column(name = "quality_guarantee_period2", length = 50)
|
private String qualityGuaranteePeriod2;
|
|
|
private String managementFeeRatio;
|
/**
|
* 质保金占比
|
*/
|
@Column(name = "quality_guarantee_ratio", precision = 5, scale = 2)
|
private String qualityGuaranteeRatio;
|
|
/**
|
* 质保金金额（元）
|
*/
|
@Column(name = "quality_guarantee_amount", precision = 18, scale = 2)
|
private String qualityGuaranteeAmount;
|
|
/**
|
* 已到账质保金
|
*/
|
@Column(name = "received_quality_guarantee", precision = 18, scale = 2)
|
private String receivedQualityGuarantee;
|
|
/**
|
* 拟公布-起始（年月）
|
*/
|
@Column(name = "planned_announcement_start", length = 7)
|
private String plannedAnnouncementStart;
|
|
/**
|
* 拟公布-止（年月）
|
*/
|
@Column(name = "planned_announcement_end", length = 7)
|
private String plannedAnnouncementEnd;
|
|
/**
|
* 已公布-起始（年月）
|
*/
|
@Column(name = "published_announcement_start", length = 7)
|
private String publishedAnnouncementStart;
|
|
/**
|
* 已公布-止（年月）
|
*/
|
@Column(name = "published_announcement_end", length = 7)
|
private String publishedAnnouncementEnd;
|
|
/**
|
* 额度
|
*/
|
@Column(name = "quota", precision = 18, scale = 2)
|
private String quota;
|
|
/**
|
* 业委会大会决议（是/否）
|
*/
|
@Enumerated(EnumType.STRING)
|
@Column(name = "owners_committee_resolution", length = 2)
|
private String ownersCommitteeResolution;
|
|
/**
|
* 业委会征询表（是否）
|
*/
|
@Enumerated(EnumType.STRING)
|
@Column(name = "owners_committee_consultation", length = 2)
|
private String ownersCommitteeConsultation;
|
|
/**
|
* 支取遇到的问题
|
*/
|
@Column(name = "withdrawal_encountered_problem", columnDefinition = "TEXT")
|
private String withdrawalEncounteredProblem;
|
|
/**
|
* 缺支/欠款（元）
|
*/
|
@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 = "door_room_number", length = 100)
|
private String doorRoomNumber;
|
|
/**
|
* 业主地址
|
*/
|
@Column(name = "owner_address", length = 255)
|
private String ownerAddress;
|
|
/**
|
* 起始（年月日）
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Column(name = "start_date")
|
private Date startDate;
|
|
/**
|
* 终止（年月日）
|
*/
|
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
|
@Column(name = "end_date")
|
private Date endDate;
|
|
@Column(name = "specific_announcement_status", length = 255)
|
private String specificAnnouncementStatus;
|
|
|
private int row;
|
|
private int page;
|
|
private String payeeName; // 支付公司名称/或个人名字
|
private String idCardNumber; // 个人身份证号码（如果是个人）
|
private String bankName; // 开户银行
|
private String bankAccount; // 开户账号
|
private String remarks; // 备注
|
private String acceptanceDate; // 验收日期
|
private String auditDate; // 审计情况：年/月
|
private String dyhj; //打印合计
|
|
private String advancedPayment;
|
private String payableAmountD;
|
|
|
/**
|
* 到账合计金额 dzhj
|
*/
|
private String dzhj;
|
|
/**
|
* 维修基金到账率 wxjjdzl
|
*/
|
private String wxjjdzl;
|
|
/**
|
* 维修基金申请金额 wxjjsqje
|
*/
|
private String wxjjsqje;
|
|
/**
|
* 管理费占比 glfzb
|
*/
|
private String glfzb;
|
|
/**
|
* 应付金额A yfjeA
|
*/
|
private String yfjeA;
|
|
/**
|
* 第五次计划付款合计 nfhj
|
*/
|
private String nfhj;
|
|
/**
|
* 实际付款合计 sfhj
|
*/
|
private String sfhj;
|
|
/**
|
* 未付合计 wfhj
|
*/
|
private String wfhj;
|
|
/**
|
* 垫付金额 dfje
|
*/
|
private String dfje;
|
}
|
