ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Common/ConfigConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Common;

public sealed class ConfigConfiguration : IEntityTypeConfiguration<Config>
{
    public void Configure(EntityTypeBuilder<Config> builder)
    {
        builder.ToTable(nameof(Config), x => x.HasComment("운영 정보 설정 값"));

        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.LastUpdatedAt).IsRequired().HasComment("마지막 수정일시");
        builder.Property(x => x.RowVersion).IsRowVersion().HasComment("동시성 제어용");

        builder.OwnsOne(x => x.Basic, owned =>
        {
            owned.Property(x => x.SiteName).HasMaxLength(100).HasColumnName("Basic_SiteName").HasComment("사이트 이름");
            owned.Property(x => x.SiteURL).HasMaxLength(100).HasColumnName("Basic_SiteURL").HasComment("사이트 주소");
            owned.Property(x => x.RootID).HasMaxLength(100).HasColumnName("Basic_RootID").HasComment("최고 관리자 ID");
            owned.Property(x => x.FromEmail).HasMaxLength(100).HasColumnName("Basic_FromEmail").HasComment("송수신 이메일");
            owned.Property(x => x.FromName).HasMaxLength(30).HasColumnName("Basic_FromName").HasComment("송수신자 이름");
            owned.Property(x => x.SmtpServer).HasMaxLength(200).HasColumnName("Basic_SmtpServer").HasComment("SMTP Server");
            owned.Property(x => x.SmtpPort).HasColumnName("Basic_SmtpPort").HasComment("SMTP Port");
            owned.Property(x => x.SmtpEnableSSL).HasColumnName("Basic_SmtpEnableSSL").HasComment("SMTP Enable SSL");
            owned.Property(x => x.SmtpUsername).HasMaxLength(100).HasColumnName("Basic_SmtpUsername").HasComment("SMTP Username");
            owned.Property(x => x.SmtpPassword).HasMaxLength(200).HasColumnName("Basic_SmtpPassword").HasComment("SMTP Password");
            owned.Property(x => x.AdminWhiteIPList).HasMaxLength(1000).HasColumnName("Basic_AdminWhiteIPList").HasComment("관리자단 접근 가능 IP");
            owned.Property(x => x.FrontWhiteIPList).HasMaxLength(1000).HasColumnName("Basic_FrontWhiteIPList").HasComment("사용자단 접근 가능 IP");
            owned.Property(x => x.BlockAlertTitle).HasMaxLength(200).HasColumnName("Basic_BlockAlertTitle").HasComment("차단 시 안내문 제목");
            owned.Property(x => x.BlockAlertContent).HasMaxLength(5000).HasColumnName("Basic_BlockAlertContent").HasComment("차단 시 안내문 내용");
            owned.Property(x => x.IsMaintenance).HasColumnName("Basic_IsMaintenance").HasComment("점검 여부");
            owned.Property(x => x.MaintenanceContent).HasMaxLength(5000).HasColumnName("Basic_MaintenanceContent").HasComment("점검 내용");
            owned.Property(x => x.NoteDailySendLimit).HasColumnName("Basic_NoteDailySendLimit").HasDefaultValue(3).HasComment("쪽지 일일 발송 제한 (사용자 1인당, 시스템 제외)");
        });

        builder.OwnsOne(x => x.Images, owned =>
        {
            owned.Property(x => x.Favicon).HasMaxLength(255).HasColumnName("Images_Favicon").HasComment("Favicon");
            owned.Property(x => x.LogoSquare).HasMaxLength(255).HasColumnName("Images_LogoSquare").HasComment("Logo-square");
            owned.Property(x => x.LogoHorizontal).HasMaxLength(255).HasColumnName("Images_LogoHorizontal").HasComment("Logo-horizontal");
            owned.Property(x => x.OgDefault).HasMaxLength(255).HasColumnName("Images_OgDefault").HasComment("og-default");
            owned.Property(x => x.TwitterImage).HasMaxLength(255).HasColumnName("Images_TwitterImage").HasComment("Twitter-image");
            owned.Property(x => x.AppleTouchIcon).HasMaxLength(255).HasColumnName("Images_AppleTouchIcon").HasComment("Apple-touch-icon");
            owned.Property(x => x.AppIcon_192).HasMaxLength(255).HasColumnName("Images_AppIcon_192").HasComment("App-icon-192");
            owned.Property(x => x.AppIcon_512).HasMaxLength(255).HasColumnName("Images_AppIcon_512").HasComment("App-icon-512");
        });

        builder.OwnsOne(x => x.Meta, owned =>
        {
            owned.Property(x => x.Keywords).HasMaxLength(255).HasColumnName("Meta_Keywords").HasComment("Meta Keywords");
            owned.Property(x => x.Description).HasMaxLength(255).HasColumnName("Meta_Description").HasComment("Meta Description");
            owned.Property(x => x.Author).HasMaxLength(255).HasColumnName("Meta_Author").HasComment("Meta Author");
            owned.Property(x => x.Viewport).HasMaxLength(255).HasColumnName("Meta_Viewport").HasComment("Meta Viewport");
            owned.Property(x => x.ApplicationName).HasMaxLength(255).HasColumnName("Meta_ApplicationName").HasComment("Meta Application Name");
            owned.Property(x => x.Generator).HasMaxLength(255).HasColumnName("Meta_Generator").HasComment("Meta Generator");
            owned.Property(x => x.Robots).HasMaxLength(255).HasColumnName("Meta_Robots").HasComment("Meta Robots");
        });

        builder.OwnsOne(x => x.Company, owned =>
        {
            owned.Property(x => x.Name).HasMaxLength(70).HasColumnName("Company_Name").HasComment("상호 명");
            owned.Property(x => x.RegNo).HasMaxLength(100).HasColumnName("Company_RegNo").HasComment("사업자 등록 번호");
            owned.Property(x => x.Address).HasMaxLength(255).HasColumnName("Company_Address").HasComment("사업장 소재지");
            owned.Property(x => x.ZipCode).HasMaxLength(8).HasColumnName("Company_ZipCode").HasComment("사업장 주소(우편번호)");
            owned.Property(x => x.Owner).HasMaxLength(50).HasColumnName("Company_Owner").HasComment("대표자 명");
            owned.Property(x => x.Tel).HasMaxLength(20).HasColumnName("Company_Tel").HasComment("대표 전화번호");
            owned.Property(x => x.Fax).HasMaxLength(20).HasColumnName("Company_Fax").HasComment("FAX");
            owned.Property(x => x.RetailSaleNo).HasMaxLength(20).HasColumnName("Company_RetailSaleNo").HasComment("통신판매업 신고번호");
            owned.Property(x => x.AddedSaleNo).HasMaxLength(20).HasColumnName("Company_AddedSaleNo").HasComment("부가통신 사업자번호");
            owned.Property(x => x.Hosting).HasMaxLength(100).HasColumnName("Company_Hosting").HasComment("호스팅 서비스");
            owned.Property(x => x.AdminName).HasMaxLength(70).HasColumnName("Company_AdminName").HasComment("정보관리책임자");
            owned.Property(x => x.AdminEmail).HasMaxLength(100).HasColumnName("Company_AdminEmail").HasComment("정보관리책임자 이메일");
            owned.Property(x => x.SiteUrl).HasMaxLength(200).HasColumnName("Company_SiteUrl").HasComment("사이트 주소");
            owned.Property(x => x.BankCode).HasMaxLength(10).HasColumnName("Company_BankCode").HasComment("입금계좌 - 은행");
            owned.Property(x => x.BankOwner).HasMaxLength(70).HasColumnName("Company_BankOwner").HasComment("입금계좌 - 예금주");
            owned.Property(x => x.BankNumber).HasMaxLength(100).HasColumnName("Company_BankNumber").HasComment("입금계좌 - 계좌번호");
        });

        builder.OwnsOne(x => x.Account, owned =>
        {
            owned.Property(x => x.IsRegisterBlock).HasColumnName("Account_IsRegisterBlock").HasComment("회원가입 차단");
            owned.Property(x => x.IsRegisterEmailAuth).HasColumnName("Account_IsRegisterEmailAuth").HasComment("회원가입 시 이메일 인증");
            owned.Property(x => x.PasswordMinLength).HasColumnName("Account_PasswordMinLength").HasComment("비밀번호 최소 길이");
            owned.Property(x => x.PasswordUppercaseLength).HasColumnName("Account_PasswordUppercaseLength").HasComment("비밀번호 최소 대문자 수");
            owned.Property(x => x.PasswordNumbersLength).HasColumnName("Account_PasswordNumbersLength").HasComment("비밀번호 최소 숫자 수");
            owned.Property(x => x.PasswordSpecialcharsLength).HasColumnName("Account_PasswordSpecialcharsLength").HasComment("비밀번호 최소 특수문자 수");
            owned.Property(x => x.DeniedEmailList).HasColumnName("Account_DeniedEmailList").HasComment("금지 이메일");
            owned.Property(x => x.DeniedNameList).HasColumnName("Account_DeniedNameList").HasComment("금지 별명");
            owned.Property(x => x.ChangeEmailDay).HasColumnName("Account_ChangeEmailDay").HasComment("이메일 갱신 주기(일)");
            owned.Property(x => x.ChangeNameDay).HasColumnName("Account_ChangeNameDay").HasComment("별명 갱신 주기(일)");
            owned.Property(x => x.ChangeSummaryDay).HasColumnName("Account_ChangeSummaryDay").HasComment("한마디 갱신 주기(일)");
            owned.Property(x => x.ChangeIntroDay).HasColumnName("Account_ChangeIntroDay").HasComment("자기소개 갱신 주기(일)");
            owned.Property(x => x.ChangePasswordDay).HasColumnName("Account_ChangePasswordDay").HasComment("비밀번호 갱신 주기(일)");
            owned.Property(x => x.MaxLoginTryCount).HasColumnName("Account_MaxLoginTryCount").HasComment("로그인 시도 제한 횟수");
            owned.Property(x => x.MaxLoginTryLimitSecond).HasColumnName("Account_MaxLoginTryLimitSecond").HasComment("로그인 시도 제한 시간(초)");
        });

        builder.OwnsOne(x => x.EmailTemplate, owned =>
        {
            owned.Property(x => x.RegisterEmailFormTitle).HasColumnName("EmailTemplate_RegisterEmailFormTitle").HasComment("회원가입 시 - 제목");
            owned.Property(x => x.RegisterEmailFormContent).HasColumnName("EmailTemplate_RegisterEmailFormContent").HasComment("회원가입 시 - 내용");
            owned.Property(x => x.RegistrationEmailFormTitle).HasColumnName("EmailTemplate_RegistrationEmailFormTitle").HasComment("회원가입 완료 - 제목");
            owned.Property(x => x.RegistrationEmailFormContent).HasColumnName("EmailTemplate_RegistrationEmailFormContent").HasComment("회원가입 완료 - 내용");
            owned.Property(x => x.ResetPasswordEmailFormTitle).HasColumnName("EmailTemplate_ResetPasswordEmailFormTitle").HasComment("비밀번호 재설정 - 제목");
            owned.Property(x => x.ResetPasswordEmailFormContent).HasColumnName("EmailTemplate_ResetPasswordEmailFormContent").HasComment("비밀번호 재설정 - 내용");
            owned.Property(x => x.ChangedPasswordEmailFormTitle).HasColumnName("EmailTemplate_ChangedPasswordEmailFormTitle").HasComment("비밀번호 변경 완료 - 제목");
            owned.Property(x => x.ChangedPasswordEmailFormContent).HasColumnName("EmailTemplate_ChangedPasswordEmailFormContent").HasComment("비밀번호 변경 완료 - 내용");
            owned.Property(x => x.WithdrawEmailFormTitle).HasColumnName("EmailTemplate_WithdrawEmailFormTitle").HasComment("회원탈퇴 시 - 제목");
            owned.Property(x => x.WithdrawEmailFormContent).HasColumnName("EmailTemplate_WithdrawEmailFormContent").HasComment("회원탈퇴 시 - 내용");
            owned.Property(x => x.WithdrawVerifyEmailFormTitle).HasColumnName("EmailTemplate_WithdrawVerifyEmailFormTitle").HasComment("회원탈퇴 인증 - 제목");
            owned.Property(x => x.WithdrawVerifyEmailFormContent).HasColumnName("EmailTemplate_WithdrawVerifyEmailFormContent").HasComment("회원탈퇴 인증 - 내용");
            owned.Property(x => x.EmailVerifyFormTitle).HasColumnName("EmailTemplate_EmailVerifyFormTitle").HasComment("이메일 변경 시 - 제목");
            owned.Property(x => x.EmailVerifyFormContent).HasColumnName("EmailTemplate_EmailVerifyFormContent").HasComment("이메일 변경 시 - 내용");
            owned.Property(x => x.ChangedEmailFormTitle).HasColumnName("EmailTemplate_ChangedEmailFormTitle").HasComment("이메일 변경 완료 - 제목");
            owned.Property(x => x.ChangedEmailFormContent).HasColumnName("EmailTemplate_ChangedEmailFormContent").HasComment("이메일 변경 완료 - 내용");
        });

        builder.OwnsOne(x => x.External, owned =>
        {
            owned.Property(x => x.YouTubeApiKeyEnc).HasColumnName("External_YouTubeApiKeyEnc").HasComment("YouTube API Key (암호화 저장 권장)");
            owned.Property(x => x.YouTubeApiName).HasColumnName("External_YouTubeApiName").HasComment("YouTube API Name");
            owned.Property(x => x.GoogleClientId).HasColumnName("External_GoogleClientId").HasComment("Google Client ID");
            owned.Property(x => x.GoogleClientSecretEnc).HasColumnName("External_GoogleClientSecretEnc").HasComment("Google Client Secret (암호화 저장 권장)");
            owned.Property(x => x.GoogleAppId).HasColumnName("External_GoogleAppId").HasComment("Google APP ID");
        });

        builder.OwnsOne(x => x.Payment, owned => {
            owned.Property(x => x.DanalCardFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalCardFeeRate").HasComment("신용카드 수수료(%)");
            owned.Property(x => x.DanalCardFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalCardFeeAmount").HasComment("신용카드 수수료(원)");
            owned.Property(x => x.DanalKakaoPayFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalKakaoPayFeeRate").HasComment("카카오페이 수수료(%)");
            owned.Property(x => x.DanalKakaoPayFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalKakaoPayFeeAmount").HasComment("카카오페이 수수료(원)");
            owned.Property(x => x.DanalNaverPayFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalNaverPayFeeRate").HasComment("네이버페이 수수료(%)");
            owned.Property(x => x.DanalNaverPayFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalNaverPayFeeAmount").HasComment("네이버페이 수수료(원)");
            owned.Property(x => x.DanalTransferFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalTransferFeeRate").HasComment("계좌이체 수수료(%)");
            owned.Property(x => x.DanalTransferFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalTransferFeeAmount").HasComment("계좌이체 수수료(원)");
            owned.Property(x => x.DanalMobileFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalMobileFeeRate").HasComment("휴대폰 수수료(%)");
            owned.Property(x => x.DanalMobileFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalMobileFeeAmount").HasComment("휴대폰 수수료(원)");
            owned.Property(x => x.DanalVbankFeeRate).HasPrecision(5, 2).HasColumnName("Payment_DanalVbankFeeRate").HasComment("가상계좌 수수료(%)");
            owned.Property(x => x.DanalVbankFeeAmount).HasPrecision(18, 0).HasColumnName("Payment_DanalVbankFeeAmount").HasComment("가상계좌 수수료(원)");

            // HasDefaultValue(false) 제거 — EF Core 가 false 를 sentinel("값 미설정") 로 오인해서
            //   기존 row 의 true 를 false 로 UPDATE 하는 변경을 누락하던 버그 회피. (체크 해제 안 됨 증상)
            //   C# 클래스의 = false 가 INSERT 시 명시값을 보장하므로 DB DEFAULT 는 불필요.
            owned.Property(x => x.IsCardEnabled).HasColumnName("Payment_IsCardEnabled").HasComment("신용카드 사용 여부");
            owned.Property(x => x.IsKakaoPayEnabled).HasColumnName("Payment_IsKakaoPayEnabled").HasComment("카카오페이 사용 여부");
            owned.Property(x => x.IsNaverPayEnabled).HasColumnName("Payment_IsNaverPayEnabled").HasComment("네이버페이 사용 여부");
            owned.Property(x => x.IsTransferEnabled).HasColumnName("Payment_IsTransferEnabled").HasComment("계좌이체 사용 여부");
            owned.Property(x => x.IsMobileEnabled).HasColumnName("Payment_IsMobileEnabled").HasComment("휴대폰 사용 여부");
            owned.Property(x => x.IsVirtualAccountEnabled).HasColumnName("Payment_IsVirtualAccountEnabled").HasComment("가상계좌 사용 여부");
        });

        builder.OwnsOne(x => x.Crypto, owned =>
        {
            owned.Property(x => x.TickerRefreshSeconds).IsRequired().HasColumnName("Crypto_TickerRefreshSeconds").HasDefaultValue(5).HasComment("시세 업데이트 주기 (초)");
            owned.Property(x => x.SurgeThreshold).IsRequired().HasColumnType("decimal(5,2)").HasColumnName("Crypto_SurgeThreshold").HasDefaultValue(5.0m).HasComment("급등 임계값 (%)");
            owned.Property(x => x.PlungeThreshold).IsRequired().HasColumnType("decimal(5,2)").HasColumnName("Crypto_PlungeThreshold").HasDefaultValue(-5.0m).HasComment("급락 임계값 (%)");
            owned.Property(x => x.MainPageCoinCount).IsRequired().HasColumnName("Crypto_MainPageCoinCount").HasDefaultValue(10).HasComment("메인 페이지 기본 표시 코인 수");
        });

        builder.OwnsOne(x => x.Attendance, owned =>
        {
            // bool/int 의 HasDefaultValue 제거 — sentinel 충돌로 UPDATE 누락 방지. (Payment 이슈와 동일 원인)
            owned.Property(x => x.IsEnabled).HasColumnName("Attendance_IsEnabled").HasComment("출석 기능 활성화");
            owned.Property(x => x.BaseExp).HasColumnName("Attendance_BaseExp").HasComment("기본 경험치");
            owned.Property(x => x.BasePoint).HasColumnName("Attendance_BasePoint").HasComment("기본 포인트");
            owned.Property(x => x.UseStreakBonus).HasColumnName("Attendance_UseStreakBonus").HasComment("연속 출석 가중치 사용");
            owned.Property(x => x.StreakBonusPerDay).HasColumnName("Attendance_StreakBonusPerDay").HasComment("1일당 추가 경험치");
            owned.Property(x => x.StreakBonusPointPerDay).HasColumnName("Attendance_StreakBonusPointPerDay").HasComment("1일당 추가 포인트");
            owned.Property(x => x.StreakBonusMaxDays).HasColumnName("Attendance_StreakBonusMaxDays").HasComment("가중치 최대 적용 일수");
            owned.Property(x => x.UseRankBonus).HasColumnName("Attendance_UseRankBonus").HasComment("순위 보상 사용");
            owned.Property(x => x.RankBonusConfig).HasColumnName("Attendance_RankBonusConfig").HasMaxLength(2000).HasComment("순위별 보상 설정 (JSON)");
        });

        builder.OwnsOne(x => x.ChatExp, owned =>
        {
            owned.Property(x => x.ChatXpPerMessage).HasColumnName("ChatExp_ChatXpPerMessage").HasDefaultValue(1).HasComment("채팅 1건당 지급 XP");
            owned.Property(x => x.DonationXpPerAmount).HasColumnName("ChatExp_DonationXpPerAmount").HasDefaultValue(1000).HasComment("후원 N POINT당 1 XP");
            owned.Property(x => x.ChatXpSessionLimit).HasColumnName("ChatExp_ChatXpSessionLimit").HasDefaultValue(50).HasComment("방송 세션당 채팅 XP 상한");
            owned.Property(x => x.MinContentLength).HasColumnName("ChatExp_MinContentLength").HasDefaultValue(2).HasComment("XP 적립 최소 글자수");
            owned.Property(x => x.RateLimitSec).HasColumnName("ChatExp_RateLimitSec").HasDefaultValue(2).HasComment("채팅 쿨다운(초)");
            owned.Property(x => x.LeaderboardSize).HasColumnName("ChatExp_LeaderboardSize").HasDefaultValue(50).HasComment("리더보드 Top N");
            owned.Property(x => x.CrownTopN).HasColumnName("ChatExp_CrownTopN").HasDefaultValue(3).HasComment("크라운 뱃지 Top N");
            // HasDefaultValue(true) 는 더 위험 — 기본값이 true 인 bool 은 EF 가 true 를 sentinel 로 오인.
            // 사용자가 체크 해제 시 false 로 UPDATE 누락. C# 클래스 init 값으로 동일 default 효과 보장.
            owned.Property(x => x.UxShowLeaderboard).HasColumnName("ChatExp_UxShowLeaderboard").HasComment("watch에서 리더보드 노출");
            owned.Property(x => x.UxShowMyXpBadge).HasColumnName("ChatExp_UxShowMyXpBadge").HasComment("내 XP 뱃지 노출");
        });
    }
}