ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Store/OrderConfiguration.cs

using Domain.Entities.Store;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Store;

public sealed class OrderConfiguration : IEntityTypeConfiguration<Order>
{
    public void Configure(EntityTypeBuilder<Order> builder)
    {
        builder.ToTable(nameof(Order), t => t.HasComment("상점 주문 헤더"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);
        builder.HasOne(x => x.Channel).WithMany().HasForeignKey(x => x.ChannelID).OnDelete(DeleteBehavior.NoAction);

        builder.HasMany(x => x.Items).WithOne(x => x.Order).HasForeignKey(x => x.OrderID).OnDelete(DeleteBehavior.Cascade);
        builder.Navigation(x => x.Items).HasField("_items").UsePropertyAccessMode(PropertyAccessMode.Field);

        builder.HasMany(x => x.Refunds).WithOne(x => x.Order).HasForeignKey(x => x.OrderID).OnDelete(DeleteBehavior.Cascade);
        builder.Navigation(x => x.Refunds).HasField("_refunds").UsePropertyAccessMode(PropertyAccessMode.Field);

        builder.Property(x => x.OrderNumber).HasMaxLength(20).IsRequired().HasComment("주문 번호 (UNIQUE)");
        builder.Property(x => x.MemberID).IsRequired();
        builder.Property(x => x.ChannelID).HasComment("후원 채널 (선택)");
        builder.Property(x => x.TotalAmount).IsRequired().HasComment("총 결제 금액");
        builder.Property(x => x.PlatformFeeAmount).IsRequired().HasComment("dpot 몫");
        builder.Property(x => x.GameRevenueAmount).IsRequired().HasComment("게임사 정산 큐 적재 금액");
        builder.Property(x => x.ChannelRewardAmount).IsRequired().HasComment("채널주 StoreRevenue 입금 금액");
        builder.Property(x => x.Status).HasConversion<int>().IsRequired().HasComment("주문 상태");
        builder.Property(x => x.CancelReason).HasMaxLength(500);
        builder.Property(x => x.RefundReason).HasMaxLength(500);
        builder.Property(x => x.CreatedAt).IsRequired();
        builder.Property(x => x.PaidAt);
        builder.Property(x => x.RowVersion).IsRowVersion();

        builder.HasIndex(x => x.OrderNumber).IsUnique();
        builder.HasIndex(x => new { x.MemberID, x.Status, x.CreatedAt });
        builder.HasIndex(x => new { x.Status, x.CreatedAt });
        builder.HasIndex(x => x.ChannelID);
    }
}