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;

    /**
     * 质保金占比
     */
    @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 advancedPayment;
    private String payableAmountD;
}