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.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" +
		" left join user_plat_distribute_rate ud on ud.goods_id = g.id :uid:",
		where = "g.status is true and g.deleted is true",
		orderBy = "dp.update_time desc")
public class DistributePosterGoodsFrontView {
	@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("ifnull(ud.rate,g.rate)")
	private Integer rate;

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

	@DbField("ud.distribute_id")
	private Long distributeId;

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