yhlxj/netflix-dao/src/main/java/com/cyksj/model/views/GiftCardGoodsSkuView.java

package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

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

/*
 *项目名: netflix
 *文件名: GiftCardGoodsSkuView
 *创建者: JavaZou
 *创建时间:2023/8/30 10:28
 */
@Getter
@Setter
@SearchBean(tables = "gift_card_goods_sku gc left join goods_don g on g.id = gc.gc_goods_id" +
		" left join goods_don_sku sku on sku.id = gc.gc_sku_id",
		where = "gc.deleted is true")
public class GiftCardGoodsSkuView {
	@DbField("gc.id")
	private Long id;

	@DbField("gc.goods_id")
	private Long goodsId;

	/**
	 * 礼品卡类型 1现金卡、2虚拟卡
	 */
	@DbField("gc.gc_type")
	private Integer gcType;

	@DbField("gc.gc_goods_id")
	private Long gcGoodsId;

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

	@DbField("gc.gc_sku_id")
	private Long gcSkuId;

	@DbField("sku.spec_val")
	private String gcSpecVal;

	/**
	 * 现金
	 */
	@DbField("gc.cash")
	private BigDecimal cash;

	/**
	 * 对应价格
	 */
	@DbField("gc.price")
	private BigDecimal price;

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

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

	@DbField("gc.status")
	private Boolean status;

	@DbField("gc.created_time")
	private Date createdTime;

	@DbField("gc.update_time")
	private Date updateTime;
}