package com.ssm.manage.query;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.ssm.manage.page.BasePage;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Column;
import javax.persistence.Id;
import java.math.BigDecimal;
import java.util.Date;

@Setter
@Getter
@ToString
@JsonIgnoreProperties(ignoreUnknown = true)
public class ModifyCourseRecordRequest extends BasePage {
    /**
     * 主键ID
     */
    @Id
    private Long id;

    /**
     * 账户修改单据号
     */
    @Column(name = "doc_num")
    private String docNum;

    /**
     * 会员ID
     */
    @Column(name = "member_id")
    private Long memberId;

    /**
     * 会员名称
     */
    @Column(name = "member_name")
    private String memberName;

    /**
     * 会员卡
     */
    private String card;

    /**
     * 门店ID
     */
    @Column(name = "store_id")
    private Long storeId;

    /**
     * 门店名称
     */
    @Column(name = "store_name")
    private String storeName;

    /**
     * 开卡单号
     */
    @Column(name = "course_num")
    private String courseNum;

    /**
     * 开卡疗程ID
     */
    @Column(name = "course_project_id")
    private Long courseProjectId;

    /**
     * 开卡疗程名称
     */
    @Column(name = "course_project_name")
    private String courseProjectName;

    /**
     * 开卡疗程金额
     */
    @Column(name = "course_project_money")
    private BigDecimal courseProjectMoney;

    /**
     * 开卡疗程次数
     */
    @Column(name = "course_count")
    private Integer courseCount;

    /**
     * 开卡标准次数
     */
    @Column(name = "course_standard_count")
    private Integer courseStandardCount;

    /**
     * 开卡标准金额
     */
    @Column(name = "course_standard_money")
    private BigDecimal courseStandardMoney;

    /**
     * 最近消费时间
     */
    @Column(name = "last_consume_time")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date lastConsumeTime;

    /**
     * 开卡剩余次数
     */
    @Column(name = "course_rest_count")
    private Integer courseRestCount;

    /**
     * 开卡可用次数
     */
    @Column(name = "course_consume_count")
    private Integer courseConsumeCount;

    /**
     * 账户类型0:疗程/1:促销/2:促销赠品
     */
    @Column(name = "course_type")
    private String courseType;

    /**
     * 0:锁定/1:正常
     */
    private Integer state;

    /**
     * 账户到期时间
     */
    @Column(name = "end_time")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date endTime;

    /**
     * 修改人名称
     */
    @Column(name = "update_by")
    private String updateBy;

    /**
     * 修改人ID
     */
    @Column(name = "update_id")
    private Long updateId;

    /**
     * 修改时间
     */
    @Column(name = "update_time")
    private Date updateTime;

    /**
     * 账户ID
     */
    @Column(name = "account_id")
    private Long accountId;

    /**
     * 账户修改人名称
     */
    @Column(name = "modify_by")
    private String modifyBy;

    /**
     * 账户修改人ID
     */
    @Column(name = "modify_id")
    private Long modifyId;

    /**
     * 账户修改时间
     */
    @Column(name = "modify_time")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date modifyTime;

    /**
     * 新会员ID
     */
    @Column(name = "member_id_new")
    private Long memberIdNew;

    /**
     * 新会员名称
     */
    @Column(name = "member_name_new")
    private String memberNameNew;

    /**
     * 新会员卡
     */
    @Column(name = "card_new")
    private String cardNew;

    /**
     * 新门店ID
     */
    @Column(name = "store_id_new")
    private Long storeIdNew;

    /**
     * 新门店名称
     */
    @Column(name = "store_name_new")
    private String storeNameNew;

    /**
     * 新开卡单号
     */
    @Column(name = "course_num_new")
    private String courseNumNew;

    /**
     * 新开卡疗程ID
     */
    @Column(name = "course_project_id_new")
    private Long courseProjectIdNew;

    /**
     * 新开卡疗程名称
     */
    @Column(name = "course_project_name_new")
    private String courseProjectNameNew;

    /**
     * 新开卡疗程金额
     */
    @Column(name = "course_project_money_new")
    private BigDecimal courseProjectMoneyNew;

    /**
     * 新开卡疗程次数
     */
    @Column(name = "course_count_new")
    private Integer courseCountNew;

    /**
     * 新开卡标准次数
     */
    @Column(name = "course_standard_count_new")
    private Integer courseStandardCountNew;

    /**
     * 新开卡标准金额
     */
    @Column(name = "course_standard_money_new")
    private BigDecimal courseStandardMoneyNew;

    /**
     * 新最近消费时间
     */
    @Column(name = "last_consume_time_new")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date lastConsumeTimeNew;

    /**
     * 新开卡剩余次数
     */
    @Column(name = "course_rest_count_new")
    private Integer courseRestCountNew;

    /**
     * 新开卡可用次数
     */
    @Column(name = "course_consume_count_new")
    private Integer courseConsumeCountNew;

    /**
     * 新账户类型0:疗程/1:促销/2:促销赠品
     */
    @Column(name = "course_type_new")
    private String courseTypeNew;

    /**
     * 新0:锁定/1:正常
     */
    @Column(name = "state_new")
    private Integer stateNew;

    /**
     * 新账户到期时间
     */
    @Column(name = "end_time_new")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date endTimeNew;

    /**
     * 新修改人名称
     */
    @Column(name = "update_by_new")
    private String updateByNew;

    /**
     * 新修改人ID
     */
    @Column(name = "update_id_new")
    private Long updateIdNew;

    /**
     * 新修改时间
     */
    @Column(name = "update_time_new")
    private Date updateTimeNew;

    /**
     * 新账户ID
     */
    @Column(name = "account_id_new")
    private Long accountIdNew;

    /**
     * 开卡剩余次数修改
     */
    @Column(name = "course_rest_count_modify")
    private Integer courseRestCountModify;

    /**
     * 开卡可用次数修改
     */
    @Column(name = "course_consume_count_modify")
    private Integer courseConsumeCountModify;

    /**
     * 修改说明
     */
    @Column(name = "explain_modify")
    private String explainModify;

    private String staffPhone;
}
