package com.java110.dto.msg;

import lombok.Data;

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

/**
 * 维修资金支取信息表
 * 对应表：maintenance_payment
 */
@Data
@Entity
@Table(name = "maintenance_payment", schema = "your_schema_name") // 替换为实际数据库schema
public class MaintenancePaymentPo {

    /**
     * 主键ID
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", nullable = 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 Integer serialNumber;

    /**
     * 项目编码
     */
    @Column(name = "project_code", length = 50)
    private String projectCode;

    /**
     * 项目名称
     */
    @Column(name = "project_name", length = 255)
    private String projectName;

    /**
     * 年份
     */
    @Column(name = "year")
    private Integer year;

    /**
     * 月份
     */
    @Column(name = "month")
    private Integer month;

    /**
     * 日
     */
    @Column(name = "day")
    private Integer day;

    /**
     * 日期
     */
    @Column(name = "date")
    private Date date;

    /**
     * 工程内容
     */
    @Column(name = "project_content", columnDefinition = "TEXT")
    private String projectContent;

    /**
     * 管理处金额
     */
    @Column(name = "management_office_amount", precision = 18, scale = 2)
    private BigDecimal managementOfficeAmount;

    /**
     * 管理处是否已盖章（是/否）
     */
    @Column(name = "management_office_seal", length = 2)
    private String managementOfficeSeal;

    /**
     * 业委会金额
     */
    @Column(name = "owners_committee_amount", precision = 18, scale = 2)
    private BigDecimal ownersCommitteeAmount;

    /**
     * 审价金额
     */
    @Column(name = "audit_amount", precision = 18, scale = 2)
    private BigDecimal auditAmount;

    /**
     * 业委会是否已盖章（是/否）
     */
    @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 Date availableWithdrawalDate;

    /**
     * 质保期（第二个）
     */
    @Column(name = "quality_guarantee_period2", length = 50)
    private String qualityGuaranteePeriod2;

    /**
     * 质保金占比
     */
    @Column(name = "quality_guarantee_ratio", precision = 5, scale = 2)
    private BigDecimal qualityGuaranteeRatio;

    /**
     * 质保金金额（元）
     */
    @Column(name = "quality_guarantee_amount", precision = 18, scale = 2)
    private BigDecimal qualityGuaranteeAmount;

    /**
     * 已到账质保金
     */
    @Column(name = "received_quality_guarantee", precision = 18, scale = 2)
    private BigDecimal 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 BigDecimal quota;

    /**
     * 业委会大会决议（是/否）
     */
    @Column(name = "owners_committee_resolution", length = 2)
    private String ownersCommitteeResolution;

    /**
     * 业委会征询表（是否）
     */
    @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 BigDecimal 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;

    /**
     * 起始（年月日）
     */
    @Column(name = "start_date")
    private Date startDate;

    /**
     * 终止（年月日）
     */
    @Column(name = "end_date")
    private Date endDate;

    /**
     * 管理费占比
     */
    @Column(name = "management_fee_ratio", precision = 5, scale = 2)
    private BigDecimal managementFeeRatio;

    /**
     * 第一次拟付金额
     */
    @Column(name = "first_planned_payment_amount", precision = 18, scale = 2)
    private BigDecimal firstPlannedPaymentAmount;

    /**
     * 拟付日期
     */
    @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 BigDecimal actualPaymentAmount;

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

    /**
     * 支付公司名称/或个人名字
     */
    @Column(name = "payee_name", length = 255)
    private String payeeName;

    /**
     * 个人身份证号码（如果是个人）
     */
    @Column(name = "id_card_number", length = 18)
    private String idCardNumber;

    /**
     * 开户银行
     */
    @Column(name = "bank_name", length = 100)
    private String bankName;

    /**
     * 开户账号
     */
    @Column(name = "bank_account", length = 64)
    private String bankAccount;

    /**
     * 备注
     */
    @Column(name = "remarks", columnDefinition = "TEXT")
    private String remarks;

    /**
     * 验收日期
     */
    @Column(name = "acceptance_date")
    private Date acceptanceDate;

    /**
     * 审计情况：年/月
     */
    @Column(name = "audit_date", length = 7)
    private String auditDate;
}