using Application.Abstractions.Data;
using Application.Abstractions.Messaging;
using Application.Features.Api.Feed.Shared;
using Microsoft.EntityFrameworkCore;

namespace Application.Features.Api.Feed.GetAll;

/// <summary>
/// "전체" 피드 — 삭제되지 않은 모든 FeedPost 를 최신순으로.
/// 팔로잉 필터/윈도우 없이 공개 피드 전체를 반환한다.
/// </summary>
public sealed class Handler(IAppDbContext db) : IQueryHandler<Query, Response>
{
    public async Task<Response> Handle(Query request, CancellationToken ct)
    {
        var query = db.FeedPost.AsNoTracking().Where(p => !p.IsDeleted);

        var total = await query.LongCountAsync(ct);
        var skip = (request.Page - 1) * request.PerPage;

        var rows = await query
            .OrderByDescending(p => p.CreatedAt)
            .Skip(skip)
            .Take(request.PerPage)
            .Select(p => new
            {
                p.ID,
                AuthorSID = p.Member.SID,
                AuthorName = p.Member.Name,
                AuthorThumb = p.Member.Thumb,
                AuthorSummary = p.Member.Summary,
                IsCreator = p.Member.IsCreator,
                ChannelSID = p.Member.Channel != null ? p.Member.Channel.SID : null,
                p.Content,
                p.Thumbnail,
                p.Images,
                p.Medias,
                p.Likes,
                p.Comments,
                p.Bookmarks,
                p.Views,
                Tags = p.FeedPostTag.Select(pt => new { pt.FeedTag.Name, pt.FeedTag.Slug }).ToList(),
                p.CreatedAt
            })
            .ToListAsync(ct);

        return new Response
        {
            Total = total,
            List = [..rows.Select(r => new FeedCardRow
            {
                PostID = r.ID,
                AuthorSID = r.AuthorSID,
                AuthorName = r.AuthorName,
                AuthorThumb = r.AuthorThumb,
                AuthorSummary = r.AuthorSummary,
                IsCreator = r.IsCreator,
                ChannelSID = r.ChannelSID,
                Subject = FeedContent.Excerpt(r.Content, 60),
                ContentExcerpt = FeedContent.Excerpt(r.Content, 200),
                Thumbnail = r.Thumbnail,
                Images = r.Images,
                Medias = r.Medias,
                Likes = r.Likes,
                Comments = r.Comments,
                Bookmarks = r.Bookmarks,
                Views = r.Views,
                Tags = [..r.Tags.Select(t => new FeedCardRow.TagRef { Name = t.Name, Slug = t.Slug })],
                CreatedAt = r.CreatedAt
            })]
        };
    }
}