package com.cyksj.model.views;

import com.cyksj.model.entity.HomeManagementConfig;
import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

import java.util.Date;

/*
 *项目名: netflix
 *文件名: HomeManagementConfigView
 *创建者: JavaZou
 *创建时间:2023/8/17 17:53
 */
@Getter
@Setter
@SearchBean(tables = "(select * from home_management_config where deleted is true)hc" +
		" left join goods_don g on g.id = hc.goods_id")
public class HomeManagementConfigView {
	@DbField("hc.id")
	private Long id;

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

	@DbField("hc.pic")
	private String pic;

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

	@DbField("hc.url")
	private String url;

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

	@DbField("hc.type")
	private HomeManagementConfig.Type type;

	@DbField("hc.tag")
	private String tag;

	@DbField("hc.sorted")
	private Integer sorted;

	@DbField("hc.status")
	private Boolean status;

	@DbField("select count(*) from home_management_config_user_click_record hcr where hcr.config_id = hc.id")
	private Integer click;

	@DbField("select count(*) from home_management_config_order_record hor left join order_don o on o.id = hor.order_id where o.status not in ('close','noPayment')")
	private Integer orderNum;

	@DbField("hc.created_time")
	private Date createdTime;
}