84 lines
1.9 KiB
C#
84 lines
1.9 KiB
C#
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; }
|
|
} |