package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.DbIgnore;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Data;

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

/**
 * @author zwhui
 * @date 2024/4/28 17:43
 */
@Data
@SearchBean(tables = "midjourney_user mu left join groups_relation gr on mu.relation_id = gr.id " +
        " left join groups_trips gt on gt.id = gr.groups_id" +
        " left join goods_don_sku sku on sku.id = gt.sku_id")
public class MidjourneyUserView {


    @DbField("mu.id")
    private Long id;

    @DbField("mu.relation_id")
    private Long relationId;

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

    @DbField("mu.mj_fast_num")
    private Integer mjUserFastNum;

    @DbField("mu.mj_relax_num")
    private Integer mjUserRelaxNum;

    /**
     * sku mj fast次数
     */
    @DbField("sku.mj_fast_num")
    private Integer mjFastNum;

    /**
     * sku mj relax次数
     */
    @DbField("sku.mj_relax_num")
    private Integer mjRelaxNum;

    @DbField("mu.expire_time")
    private Date expireTime;

    @DbField("gt.sku_id")
    private Long skuId;

    /**
     * mj 套餐包最低单价
     */
    @DbIgnore
    private BigDecimal mjPackagePrice;
}