yhlxj/netflix-dao/src/main/java/com/cyksj/model/views/DistributePosterGoodsFrontView.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 lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;

/**
 * 项目名: yhlxj
 * 文件名: DistributePosterGoodsFrontView
 * 创建者: JavaZou
 * 创建时间:2024/6/24 14:36
 */

@Getter
@Setter
@SearchBean(tables = "distribute_poster_goods dp inner join goods_don g on g.id = dp.goods_id",
		where = "dp.status is true and g.status is true and g.deleted is true",
		orderBy = "dp.update_time desc")
public class DistributePosterGoodsFrontView {
	@DbField("dp.id")
	private Long id;

	@DbField("g.id")
	private Long goodsId;

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

	/**
	 * 推广名称
	 */
	@DbField("dp.name")
	private String name;

	@DbField("dp.img")
	private String img;

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

	@DbField("g.rate")
	private Integer rate;

	@DbField("g.is_sku_distribute")
	private Boolean isSkuRate;

	@DbField("g.min_price")
	private BigDecimal price;

	@DbField("dp.sku_ids")
	private String skuIds;

	/**
	 * 海报记录id
	 */
	@DbIgnore
	private Long rid;
}