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

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.JsonInclude;
import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;

/*
 *项目名: netflix
 *文件名: GiftCardGoodsSkuFrontView
 *创建者: JavaZou
 *创建时间:2023/8/28 16:36
 */
@Getter
@Setter
@SearchBean(tables = "gift_card_goods_sku gc inner join goods_don gcd on gcd.id = gc.goods_id" +
		" 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 = "gcd.status is true and gc.status is true and gc.deleted is true")
@JsonInclude(JsonInclude.Include.NON_NULL)
public class GiftCardGoodsSkuFrontView {
	@DbField("gc.id")
	private Long id;

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

	@DbField("gc.gc_type")
	private Integer gcType;

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

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

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

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

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

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

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

	@DbField("gc.cash")
	private BigDecimal cash;

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

	@DbIgnore
	private Integer gcNum;

	@DbIgnore
	private String gcShowType;

	@DbIgnore
	private String gcImg;
}