GiftCardGoodsSkuFrontView.java 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. package com.cyksj.model.views;
  2. import com.ejlchina.searcher.bean.DbField;
  3. import com.ejlchina.searcher.bean.DbIgnore;
  4. import com.ejlchina.searcher.bean.SearchBean;
  5. import com.fasterxml.jackson.annotation.JsonInclude;
  6. import lombok.Getter;
  7. import lombok.Setter;
  8. import java.math.BigDecimal;
  9. /*
  10. *项目名: netflix
  11. *文件名: GiftCardGoodsSkuFrontView
  12. *创建者: JavaZou
  13. *创建时间:2023/8/28 16:36
  14. */
  15. @Getter
  16. @Setter
  17. @SearchBean(tables = "gift_card_goods_sku gc left join goods_don g on g.id = gc.gc_goods_id" +
  18. " left join goods_don_sku sku on sku.id = gc.gc_sku_id",
  19. where = "gc.status is true and gc.deleted is true")
  20. @JsonInclude(JsonInclude.Include.NON_NULL)
  21. public class GiftCardGoodsSkuFrontView {
  22. @DbField("gc.id")
  23. private Long id;
  24. @DbField("gc.goods_id")
  25. private Long goodsId;
  26. @DbField("gc.gc_type")
  27. private Integer gcType;
  28. @DbField("gc.price")
  29. private BigDecimal price;
  30. @DbField("sku.price")
  31. private BigDecimal sPrice;
  32. @DbField("gc.gc_goods_id")
  33. private Long gcGoodsId;
  34. @DbField("gc.gc_sku_id")
  35. private Long gcSkuId;
  36. @DbField("g.title")
  37. private String gcGoodsTitle;
  38. @DbField("sku.spec_val")
  39. private String gcSpecVal;
  40. @DbField("gc.cash")
  41. private BigDecimal cash;
  42. @DbField("gc.logo")
  43. private String logo;
  44. @DbIgnore
  45. private Integer gcNum;
  46. @DbIgnore
  47. private String gcShowType;
  48. @DbIgnore
  49. private String gcImg;
  50. }