Class AnalyticsController

backend/Controllers/AnalyticsController.cs:11–265

namespace Backend.Controllers;

[ApiController]
[Route("api/[controller]")]
[Authorize]
public class AnalyticsController : ControllerBase
{
    private readonly AppDbContext _db;

    public AnalyticsController(AppDbContext db)
    {
        _db = db;
    }

    [HttpGet("board/{boardId}")]
    public async Task<IActionResult> GetBoardAnalytics(int boardId)
    {
        // 1. Verify User has access to the board
        var userId = GetUserId();
        var board = await _db.Boards.FindAsync(boardId);
        if (board == null) return NotFound();

        var hasAccess = board.OwnerId == userId ||
                        await _db.BoardMembers.AnyAsync(m => m.BoardId == boardId && m.UserId == userId && m.Status == "Accepted") ||
                        await _db.WorkspaceMembers.AnyAsync(wm => wm.WorkspaceId == board.WorkspaceId && wm.UserId == userId && wm.Status == "Accepted");

        if (!hasAccess) return Forbid();

        // 2. Aggregate Task Data with basic projections
        var taskData = await _db.TaskCards
            .AsNoTracking()
            .Where(t => t.Column.BoardId == boardId)
            .Select(t => new
            {
                t.Id,
                t.ColumnId,
                t.CreatedAt,
                TimeLogs = t.TimeLogs.Select(tl => new { tl.DurationMinutes, Username = tl.User.Username })
            })
            .ToListAsync();

        int totalTasks = taskData.Count;

        // Let's assume the right-most column means "Done", or any column named "Done" / "Completed"
        // Since we don't have a strict strict "Done" flag on the Task itself mapping to Agile,
        // Let's find columns containing 'Done' or 'Complete'
        var doneColumnIds = await _db.Columns
            .AsNoTracking()
            .Where(c => c.BoardId == boardId && (c.Name.ToLower().Contains("done") || c.Name.ToLower().Contains("complete")))
            .Select(c => c.Id)
            .ToListAsync();

        int completedTasks = taskData.Count(t => doneColumnIds.Contains(t.ColumnId));
        int pendingTasks = totalTasks - completedTasks;

        // 3. User Time Tracking Aggregation
        var userTimeData = taskData
            .SelectMany(t => t.TimeLogs)
            .Where(tl => tl.DurationMinutes.HasValue)
            .GroupBy(tl => tl.Username ?? "Unknown")