package com.cyksj.model.manage.views;

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

import java.math.BigDecimal;
import java.util.Date;

/*
 *项目名: netflix
 *文件名: OrderDonSearchView
 *创建者: JavaZou
 *创建时间:2023/7/28 16:21
 */
@Getter
@Setter
@SearchBean(tables = "(select * from upgrade_order_don :orderId:) o left join upgrade_package up on o.package_id = up.id " +
		"left join goods_don g on g.id = up.goods_id " +
		"left join goods_don_sku gs on gs.id = o.sku_id ")
public class UpgradeOrderDonSearchView {
	@DbField("o.id")
	private Long id;

	@DbField("up.name")
	private String name;

	@DbField("up.price")
	private BigDecimal price;

	@DbField("up.num")
	private Integer num;

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

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

	@DbField("gs.spec_val")
	private String specVal;

	@DbField("o.money")
	private BigDecimal money;

	@DbField("o.balance")
	private BigDecimal balance;

	@DbField("o.refund_money")
	private BigDecimal refundMoney;

	@DbField("o.refund_balance")
	private BigDecimal refundBalance;

	@DbField("o.status")
	private UpgradeOrderDon.Status status;

	@DbField("o.type")
	private UpgradeOrderDon.Type type;

	@DbField("o.created_time")
	private Date createdTime;

	@DbField("o.pay_time")
	private Date payTime;

}