using FreeSql.DataAnnotations;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Store.Contracts.Shops;

/// <summary>
/// 买手每日统计表
/// </summary>
[Table(Name = "wxxd.buyer_daily_stats")]
public class BuyerDailyStatsEntity
{
	/// <summary>
	/// 自增主键
	/// </summary>
	[Column(Name = "id", IsPrimary = true, IsIdentity = true)]
	public long Id { get; set; }

	/// <summary>
	/// 店铺ID
	/// </summary>
	[Column(Name = "shop_id")]
	public string ShopId { get; set; }

	/// <summary>
	/// 买手ID
	/// </summary>
	[Column(Name = "buyer_id")]
	public string BuyerId { get; set; }

	/// <summary>
	/// 采购订单创建日期
	/// </summary>
	[Column(Name = "stat_date")]
	public DateTime StatDate { get; set; }

	/// <summary>
	/// 采购单数
	/// </summary>
	[Column(Name = "purchase_count")]
	public int PurchaseCount { get; set; }

	/// <summary>
	/// 总花费金额
	/// </summary>
	[Column(Name = "total_purchase")]
	public long TotalPurchase { get; set; }
	/// <summary>
	/// 售后中买手总金额
	/// </summary>
	public long TotalRefund => DoneRefund + PendingRefund + RejectedRefund;
	/// <summary>
	/// 已成功退款金额
	/// </summary>
	[Column(Name = "done_refund")]
	public long DoneRefund { get; set; }

	/// <summary>
	/// 未退回金额
	/// </summary>
	[Column(Name = "pending_refund")]
	public long PendingRefund { get; set; }

	/// <summary>
	/// 被拒绝金额
	/// </summary>
	[Column(Name = "rejected_refund")]
	public long RejectedRefund { get; set; }

	/// <summary>
	/// 创建时间
	/// </summary>
	[Column(Name = "created_at", ServerTime = DateTimeKind.Local, CanUpdate = false)]
	public DateTime CreatedAt { get; set; }

	/// <summary>
	/// 最后刷新时间
	/// </summary>
	[Column(Name = "updated_at", ServerTime = DateTimeKind.Local)]
	public DateTime UpdatedAt { get; set; }
}