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

package com.cyksj.model.views;

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

import java.math.BigDecimal;

/**
 * 项目名: yhlxj2
 * 文件名: GoodsDonSkuSubsidyDetailView
 * 创建者: JavaZou
 * 创建时间:2024/4/11 14:53
 */
@Getter
@Setter
@SearchBean(tables = "goods_don_sku_subsidy gs inner join goods_don_sku sku on sku.id = gs.sku_id",
		where = "gs.deleted is true and sku.status is true",
		orderBy = "sku.sorted asc")
@JsonInclude(JsonInclude.Include.NON_NULL)
public class GoodsDonSkuSubsidyDetailView {

	/**
	 * 规格补贴id
	 */
	@DbField("gs.id")
	private Long subsidyId;

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

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


	@DbField("sku.sub_title")
	private String subTitle;

	/**
	 * 商品规格 ids
	 */
	@DbField("sku.spec_ids")
	private String specIds;

	/**
	 * 商品规格 value
	 */
	@DbField("sku.spec_val")
	private String specVal;

	/**
	 * 商品规格 json
	 */
	@DbField("sku.spec_json")
	private String specJson;

	/**
	 * 规格说明信息
	 */
	@DbField("sku.notify_text")
	private String notifyText;

	/**
	 * H5标签
	 */
	@DbField("sku.mobile_tags")
	private String mobileTags;

	/**
	 * 规格背景图
	 */
	@DbField("sku.img")
	private String img;

	/**
	 * 规格框提示
	 */
	@DbField("sku.small_msg")
	private String smallMsg;

	/**
	 * 商品预览图
	 */
	@DbField("gs.picture")
	private String subsidyPicture;

	/**
	 * 商品预览图
	 */
	@DbField("sku.picture")
	private String picture;

	/**
	 * 商品详情图
	 */
	@DbField("sku.detail")
	private String detail;

	/**
	 * 标签
	 */
	@DbField("sku.tags")
	private String tags;

	/**
	 * 价格
	 */
	@DbField("gs.price")
	private BigDecimal price;

	/**
	 * 原价
	 */
	@DbField("sku.price")
	private BigDecimal oriPrice;

	/**
	 * 月数
	 */
	@DbField("sku.months")
	private Integer months;

	/**
	 * 天数
	 */
	@DbField("sku.days")
	private Integer days;

	/**
	 * 排序
	 */
	@DbField("sku.sorted")
	private Integer sorted;
}