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

package com.cyksj.model.views;

import com.cyksj.model.entity.GoodsDonSku;
import com.cyksj.model.entity.GoodsDonSpec;
import com.cyksj.model.entity.OrderComment;
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;
import java.util.List;

/*
 *项目名: netflix
 *文件名: GoodsDonPopularizeView
 *创建者: JavaZou
 *创建时间:2023/1/10 13:42
 */
@Getter
@Setter
@SearchBean(tables = "goods_don g")
public class GoodsDonPopularizeView {
	@DbField("g.id")
	private Long id;

	/**
	 * 商品名称
	 */
	@DbField("g.title")
	private String title;

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

	/**
	 * 缩略图
	 */
	@DbField("g.logo")
	private String logo;

	/**
	 * 背景图
	 */
	@DbField("g.img")
	private String img;

	/**
	 * 描述
	 */
	@DbField("g.remark")
	private String remark;

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

	@DbField("g.second_type")
	private Integer secondType;

	/**
	 * true 上架 / false 下架
	 */
	@DbField("g.status")
	private Boolean status;

	/**
	 * true 存在 / false 删除
	 */
	@DbField("g.deleted")
	private Boolean deleted;

	/**
	 * 最低规格价格
	 */
	@DbIgnore
	private BigDecimal price;

	/**
	 * 最低规格月份
	 */
	@DbIgnore
	private Integer months;

	/**
	 * 已售
	 */
	@DbField("select count(*) from order_don od where od.status not in ('close','noPayment') and od.goods_id = g.id")
	private Integer sold;

	/**
	 * 购买通知信息
	 */
	@DbIgnore
	private String notifyMsg;

	@DbIgnore
	private List<GoodsDonSku> skuList;

	@DbIgnore
	private GoodsDonSpec specs;

	/**
	 * 评论列表
	 */
	@DbIgnore
	private List<OrderComment> orderComments;
}