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.shop_daily_stats")]
public class ShopDailyStatsEntity
{
	/// <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>
	/// 销售订单创建日期
	/// </summary>
	[Column(Name = "stat_date")]
	public DateTime StatDate { get; set; }

	/// <summary>
	/// 订单数
	/// </summary>
	[Column(Name = "order_count")]
	public int OrderCount { get; set; }

	/// <summary>
	/// 销售总额
	/// </summary>
	[Column(Name = "sales_amount")]
	public long SalesAmount { get; set; }

	/// <summary>
	/// 利润
	/// </summary>
	[Column(Name = "profit_amount")]
	public long ProfitAmount { get; set; }

	/// <summary>
	/// 平台佣金
	/// </summary>
	[Column(Name = "platform_fee")]
	public long PlatformFee { get; set; }

	/// <summary>
	/// 退款订单数
	/// </summary>
	[Column(Name = "refund_order_count")]
	public int RefundOrderCount { get; set; }

	/// <summary>
	/// 已成功退款金额
	/// </summary>
	[Column(Name = "refund_done")]
	public long RefundDone { get; set; }

	/// <summary>
	/// 退款处理中金额
	/// </summary>
	[Column(Name = "refund_pending")]
	public long RefundPending { 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; }
}