package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.DbIgnore;
import com.ejlchina.searcher.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;
import java.util.Date;

/**
 * @author chan
 * @date 2022/9/27 11:54 AM
 */
@SearchBean(tables = "groups_relation gr left join groups_trips gt on gt.id = gr.groups_id " +
        "left join account a on a.id = gt.account_id " +
        "left join goods_don_sku sku on gt.sku_id = sku.id " +
        "left join goods_don g on g.id = sku.goods_id " )
@Getter
@Setter
public class RenewalView {

    @DbField("g.id")
    private Long goodsId;

    @DbField("sku.id")
    private Long skuId;

    @DbField("sku.months")
    private Integer months;

    @JsonIgnore
    @DbField("sku.num")
    private Long skuNum;

    @DbField("sku.price")
    private BigDecimal price;

    @DbField("gr.id")
    private Long relationId;

    @DbField("gr.num")
    private Integer num;

    @DbField("gr.groups_id")
    private Long groupId;

    @DbField("g.title")
    private String title;

    @DbField("g.logo")
    private String logo;

    @DbField("g.img")
    private String img;

    /**
     * 二级分类
     * 虚物品 1邀请制 2非邀请制
     */
    @DbField("g.second_type")
    private Integer secondType;

    @DbField("gr.user_id")
    private Long userId;

    @DbField("gr.expiry_time")
    private Date expiryTime;

    @DbField("gr.status")
    private String status;

    @DbField("a.account")
    private String account;

    @DbField("a.password")
    private String password;

    @DbField("a.api_key")
    private String apiKey;

    @DbField("gr.verify_code")
    private String verifyCode;

    @DbIgnore
    private GoodsDonViews goodsDonViews;
}