@page "/reports/timesheet"
@using Microsoft.AspNetCore.Authorization
@using TaskTrackingSystem.Shared
@using TaskTrackingSystem.Shared.Models.Issue
@using TaskTrackingSystem.Shared.Models.User
@using TaskTrackingSystem.Shared.Models.Project
@using System.Text
@rendermode @(new InteractiveServerRenderMode(prerender: false))
@attribute [Authorize]
@inject ApiClientService ApiClient
@inject IJSRuntime JS
@inject AuthenticationStateProvider AuthStateProvider
@inject MenuAuthorizationService MenuAuthorization

<PageTitle>@AppLocalization.Text("report.timeTrackingTitle", "Time & Effort Tracking Report")</PageTitle>

<div class="space-y-6">
    <!-- Page Header -->
    <div class="flex flex-col md:flex-row md:items-center md:justify-between gap-4">
        <div>
            <h2 class="text-3xl font-bold tracking-tight text-slate-900">@AppLocalization.Text("report.timeTrackingHeading", "Time & Effort Tracking")</h2>
            <p class="text-slate-500 mt-1">@AppLocalization.Text("report.timeTrackingDesc", "Review estimated hours, completion timelines, and resource effort distribution across issues.")</p>
        </div>
        <div class="flex items-center space-x-3">
            <div class="inline-flex rounded-lg border border-slate-200 bg-white p-0.5 shadow-sm">
                <button @onclick="() => SetView(false)" class="inline-flex items-center rounded-md px-3 py-1.5 text-xs font-semibold @(!isChartView ? "bg-violet-600 text-white" : "text-slate-600 hover:text-slate-900") transition-colors">
                    <i data-lucide="list" class="h-3.5 w-3.5 mr-1"></i> @AppLocalization.Text("common.listView", "List View")
                </button>
                <button @onclick="() => SetView(true)" class="inline-flex items-center rounded-md px-3 py-1.5 text-xs font-semibold @(isChartView ? "bg-violet-600 text-white" : "text-slate-600 hover:text-slate-900") transition-colors">
                    <i data-lucide="bar-chart-3" class="h-3.5 w-3.5 mr-1"></i> @AppLocalization.Text("common.chartView", "Chart View")
                </button>
            </div>
            <button @onclick="DownloadExcel" class="inline-flex items-center rounded-lg border border-slate-200 bg-white px-4 py-2 text-sm font-medium text-slate-700 hover:bg-slate-50 transition-colors shadow-sm">
                <i data-lucide="download" class="h-4 w-4 mr-2"></i> @AppLocalization.Text("common.exportExcel", "Export Excel")
            </button>
            <button @onclick="DownloadPdf" class="inline-flex items-center rounded-lg border border-slate-200 bg-white px-4 py-2 text-sm font-medium text-slate-700 hover:bg-slate-50 transition-colors shadow-sm">
                <i data-lucide="file-text" class="h-4 w-4 mr-2"></i> @AppLocalization.Text("common.exportPdf", "Export PDF")
            </button>
        </div>
    </div>

    <!-- Stats summary -->
    @if (!isLoading)
    {
        <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4">
            <div class="rounded-xl border border-violet-100 bg-violet-50 p-5 shadow-sm">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-xs font-semibold uppercase tracking-wider text-violet-500">@AppLocalization.Text("report.totalEstimatedEffort", "Total Estimated Effort")</p>
                        <p class="mt-1 text-3xl font-bold text-violet-700">@AppLocalization.Number(totalHours, "N1") @AppLocalization.Text("common.hoursAbbrev", "hrs")</p>
                    </div>
                    <span class="flex h-11 w-11 items-center justify-center rounded-xl bg-violet-100">
                        <i data-lucide="clock" class="h-6 w-6 text-violet-600"></i>
                    </span>
                </div>
            </div>
            <div class="rounded-xl border border-emerald-100 bg-emerald-50 p-5 shadow-sm">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-xs font-semibold uppercase tracking-wider text-emerald-500">@AppLocalization.Text("common.actualHours", "Actual Hours")</p>
                        <p class="mt-1 text-3xl font-bold text-emerald-700">@AppLocalization.Number(actualHours, "N1") @AppLocalization.Text("common.hoursAbbrev", "hrs")</p>
                    </div>
                    <span class="flex h-11 w-11 items-center justify-center rounded-xl bg-emerald-100">
                        <i data-lucide="check-circle-2" class="h-6 w-6 text-emerald-600"></i>
                    </span>
                </div>
            </div>
            <div class="rounded-xl border border-amber-100 bg-amber-50 p-5 shadow-sm">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-xs font-semibold uppercase tracking-wider text-amber-500">@AppLocalization.Text("report.variance", "Variance")</p>
                        <p class="mt-1 text-3xl font-bold text-amber-700">@AppLocalization.LocalizeDigits(varianceHours.ToString("+0.0;-0.0;0.0", System.Globalization.CultureInfo.InvariantCulture)) @AppLocalization.Text("common.hoursAbbrev", "hrs")</p>
                    </div>
                    <span class="flex h-11 w-11 items-center justify-center rounded-xl bg-amber-100">
                        <i data-lucide="timer" class="h-6 w-6 text-amber-600"></i>
                    </span>
                </div>
            </div>
            <div class="rounded-xl border border-rose-100 bg-rose-50 p-5 shadow-sm">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-xs font-semibold uppercase tracking-wider text-rose-500">@AppLocalization.Text("report.utilization", "Utilization")</p>
                        <p class="mt-1 text-3xl font-bold text-rose-700">@AppLocalization.Number(utilizationPercent, "N0")%</p>
                    </div>
                    <span class="flex h-11 w-11 items-center justify-center rounded-xl bg-rose-100">
                        <i data-lucide="alert-triangle" class="h-6 w-6 text-rose-600"></i>
                    </span>
                </div>
            </div>
        </div>
    }

    <!-- Filters -->
    <div class="rounded-xl border border-slate-200 bg-white p-6 shadow-sm">
        <div class="flex flex-col gap-4">
            <div class="flex flex-wrap items-end gap-4">
                <div class="flex-1 min-w-[200px]">
                    <label class="block text-xs font-medium text-slate-500 mb-1.5">@AppLocalization.Text("common.searchByIssueAssignee", "Search Issues / Assignee")</label>
                <input @bind="searchInput" @bind:event="oninput" type="text" placeholder="@AppLocalization.Text("common.searchIssues", "Search issue title, description or assignee...")"
                           class="w-full rounded-lg border border-slate-200 px-3 py-2 text-sm text-slate-900 placeholder:text-slate-400 focus:outline-none focus:ring-2 focus:ring-violet-600 focus:border-transparent transition-all" />
                </div>
                <div>
                    <label class="block text-xs font-medium text-slate-500 mb-1.5">@AppLocalization.Text("common.project", "Project")</label>
                    <select @bind="filterProjectId" class="rounded-lg border border-slate-200 px-3 py-2 text-sm text-slate-900 focus:outline-none focus:ring-2 focus:ring-violet-600 focus:border-transparent transition-all">
                        <option value="0">@AppLocalization.Text("common.allProjects", "All Projects")</option>
                        @foreach (var proj in allProjects)
                        {
                            <option value="@proj.Id">@Content.GetProjectName(proj)</option>
                        }
                    </select>
                </div>
                <div>
                    <label class="block text-xs font-medium text-slate-500 mb-1.5">@AppLocalization.Text("common.status", "Issue Status")</label>
                    <select @bind="filterStatus" class="rounded-lg border border-slate-200 px-3 py-2 text-sm text-slate-900 focus:outline-none focus:ring-2 focus:ring-violet-600 focus:border-transparent transition-all">
                        <option value="0">@AppLocalization.Text("common.all", "All Statuses")</option>
                        <option value="Todo">@AppLocalization.StatusLabel(AppTaskStatus.Todo)</option>
                        <option value="InProgress">@AppLocalization.StatusLabel(AppTaskStatus.InProgress)</option>
                        <option value="Done">@AppLocalization.StatusLabel(AppTaskStatus.Done)</option>
                    </select>
                </div>
                <button @onclick="ApplyFilters" class="inline-flex items-center rounded-lg bg-violet-600 px-5 py-2 text-sm font-medium text-white hover:bg-violet-700 transition-colors shadow-sm">
                    <i data-lucide="search" class="h-4 w-4 mr-2"></i> @AppLocalization.Text("action.search", "Search")
                </button>
            <button @onclick="ResetFilters" title="@AppLocalization.Text("action.reset", "Reset")" aria-label="@AppLocalization.Text("action.reset", "Reset")" class="inline-flex items-center justify-center rounded-lg border border-slate-200 bg-white p-2 text-slate-600 hover:bg-slate-50 transition-colors shadow-sm">
                <i data-lucide="rotate-ccw" class="h-4 w-4"></i>
                </button>
            </div>
            
            <div class="flex flex-wrap items-center gap-6 border-t border-slate-100 pt-3">
                <label class="flex items-center space-x-2 text-sm font-medium text-slate-700 cursor-pointer select-none">
                    <input type="checkbox" @bind="filterAssignToMe" class="h-4 w-4 rounded border-slate-300 text-violet-600 focus:ring-violet-500" />
                    <span>@AppLocalization.Text("report.assignedToMe", "Assigned to me")</span>
                </label>
                <label class="flex items-center space-x-2 text-sm font-medium text-slate-700 cursor-pointer select-none">
                    <input type="checkbox" @bind="filterAssignToMyTeam" class="h-4 w-4 rounded border-slate-300 text-violet-600 focus:ring-violet-500" />
                    <span>@AppLocalization.Text("report.assignedToMyTeam", "Assigned to my team")</span>
                </label>
            </div>
        </div>
    </div>

    @if (isLoading)
    {
        <LoadingSpinner Message="@AppLocalization.Text("report.loadingTimesheet", "Loading timesheet data...")" />
    }
    else
    {
        @if (isChartView)
        {
            <div class="grid grid-cols-1 gap-5 xl:grid-cols-12 font-sans">
                <div class="xl:col-span-5">
                    <MetricComparisonCard Title="@AppLocalization.Text("report.estVsActualEffort", "Estimated vs actual effort")"
                                          Subtitle="@AppLocalization.Text("report.estVsActualEffortDesc", "Are plans matching delivery effort?")"
                                          PrimaryLabel="@AppLocalization.Text("report.actual", "Actual")"
                                          PrimaryValue="@($"{AppLocalization.Number(actualHours)} {AppLocalization.Text("common.hoursAbbrev", "hrs")}")"
                                          SecondaryLabel="@AppLocalization.Text("report.estimated", "Estimated")"
                                          SecondaryValue="@($"{AppLocalization.Number(totalHours)} {AppLocalization.Text("common.hoursAbbrev", "hrs")}")"
                                          Segments="EffortComparisonSegments"
                                          Insight="@EffortVarianceInsight" />
                </div>
                <div class="xl:col-span-3">
                    <RadialMetricCard Title="@AppLocalization.Text("report.utilizationGauge", "Utilization gauge")"
                                      Subtitle="@AppLocalization.Text("report.utilizationGaugeDesc", "Actual hours as a share of estimated effort.")"
                                      Percent="@utilizationPercent"
                                       Value="@($"{AppLocalization.Number(varianceHours)} {AppLocalization.Text("common.hoursAbbrev", "hrs")}")"
                                      ValueLabel="@AppLocalization.Text("report.varianceLabel", "variance")"
                                      CenterLabel="@AppLocalization.Text("report.usedLabel", "used")"
                                      Color="@UtilizationColor"
                                      Insight="@UtilizationInsight" />
                </div>
                <div class="xl:col-span-4">
                    <ReportChartCard Title="@AppLocalization.Text("report.estimateAccuracy", "Estimate accuracy")" Subtitle="@AppLocalization.Text("report.estimateAccuracyDesc", "How many items stayed within estimate?")" Value="@AppLocalization.Number(OnOrUnderEstimateCount)" ValueLabel="@AppLocalization.Text("report.onOrUnder", "on / under")" Insight="@EstimateAccuracyInsight">
                        <DonutStatusChart Items="EstimateAccuracyDonutItems" CenterLabel="@AppLocalization.Text("report.issuesLabel", "issues")" />
                    </ReportChartCard>
                </div>
                <div class="xl:col-span-7">
                    <ReportChartCard Title="@AppLocalization.Text("report.effortByProject", "Effort by project")" Subtitle="@AppLocalization.Text("report.effortByProjectDesc", "Actual hours distributed across active projects.")" Insight="@AppLocalization.Text("report.effortByProjectInsight", "Use this to spot projects consuming more delivery capacity than expected.")">
                        <StackedProgressBar Segments="ProjectEffortSegments" AriaLabel="Effort by project" />
                    </ReportChartCard>
                </div>
                <div class="xl:col-span-5">
                    <ReportChartCard Title="@AppLocalization.Text("report.effortLeaderboard", "Effort leaderboard")" Subtitle="@AppLocalization.Text("report.effortLeaderboardDesc", "People carrying the most tracked effort.")" Insight="@AppLocalization.Text("report.effortLeaderboardInsight", "Names highlight capacity allocation, not performance judgement.")">
                        <TopRiskList Items="EmployeeEffortLeaders" EmptyText="@AppLocalization.Text("report.noEmployeeEffort", "No employee effort data available.")" />
                    </ReportChartCard>
                </div>
            </div>
        }
        else
        {
        <!-- Table -->
        <div class="rounded-xl border border-slate-200 bg-white shadow-sm overflow-hidden">
            <div class="px-6 py-4 border-b border-slate-100 flex items-center justify-between">
                <h3 class="text-sm font-semibold text-slate-700">
                    @AppLocalization.Text("pagination.showing", "Showing") <span class="text-violet-600 font-bold">@AppLocalization.Number(FilteredIssues.Count())</span> @AppLocalization.Text("report.timesheetEntries", "timesheet issue entry(s)")
                </h3>
            </div>
            <table class="w-full">
                <thead>
                    <tr class="border-b border-slate-100 bg-slate-50/60">
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.index", "No.")</th>
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.issue", "Issue")</th>
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.taskProject", "Task & Project")</th>
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.assignee", "Assignee")</th>
                            <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.estimatedHours", "Est. Hours")</th>
                            <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.actualHours", "Actual Hours")</th>
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.dueDate", "Due Date")</th>
                        <th class="px-6 py-3 text-left text-xs font-semibold text-slate-500 uppercase tracking-wider">@AppLocalization.Text("common.status", "Status")</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-slate-100">
                    @if (PagedIssues.Any())
                    {
                        @foreach (var entry in PagedIssues.Select((issue, index) => (issue, index)))
                        {
                            var issue = entry.issue;
                            <tr class="hover:bg-slate-50/50 transition-colors">
                                <td class="px-6 py-4 text-sm font-semibold text-slate-500">@AppLocalization.Number((currentPage - 1) * pageSize + entry.index + 1)</td>
                                <td class="px-6 py-4">
                                    <div>
                                        <p class="text-sm font-semibold text-slate-900">@Content.GetIssueTitle(issue)</p>
                                        @if (!string.IsNullOrEmpty(Content.GetIssueDescription(issue)))
                                        {
                                            <p class="text-xs text-slate-400 mt-0.5 truncate max-w-[200px]">@Content.GetIssueDescription(issue)</p>
                                        }
                                    </div>
                                </td>
                                <td class="px-6 py-4">
                                    <div class="text-sm text-slate-800 font-medium">@Content.GetText(issue.TaskTitle, issue.TaskTitleMy)</div>
                                    <div class="text-xs text-slate-400 mt-0.5">@Content.GetText(issue.ProjectName, issue.ProjectNameMy)</div>
                                </td>
                                <td class="px-6 py-4">
                                    @if (Content.GetText(issue.AssignedToName, issue.AssignedToNameMy) is { Length: > 0 } assigneeName)
                                    {
                                        <div class="flex items-center gap-2">
                                            <span class="flex h-7 w-7 items-center justify-center rounded-full bg-violet-100 text-violet-700 text-xs font-bold">
                                                @assigneeName[0].ToString().ToUpper()
                                            </span>
                                            <span class="text-sm text-slate-700">@Content.GetText(issue.AssignedToName, issue.AssignedToNameMy)</span>
                                        </div>
                                    }
                                    else
                                    {
                                        <span class="text-xs text-slate-400">@AppLocalization.Text("common.unassigned", "Unassigned")</span>
                                    }
                                </td>
                                <td class="px-6 py-4 text-sm font-semibold text-slate-800">
                                    @AppLocalization.Number(issue.EstimatedHours ?? 0, "N1") @AppLocalization.Text("common.hoursAbbrev", "hrs")
                                </td>
                                <td class="px-6 py-4 text-sm font-semibold @(GetVariance(issue) > 0 ? "text-rose-600" : "text-emerald-600")">
                                    @AppLocalization.Number(issue.ActualHours ?? 0, "N1") @AppLocalization.Text("common.hoursAbbrev", "hrs")
                                </td>
                                <td class="px-6 py-4 text-sm text-slate-600">
                                    @DisplayFormats.Date(issue.DueDate)
                                </td>
                                <td class="px-6 py-4">
                                    @{
                                        var (statusLabel, statusClass) = issue.StatusId switch {
                                            AppTaskStatus.InProgress => (AppLocalization.StatusLabel(AppTaskStatus.InProgress), "bg-blue-50 text-blue-700"),
                                            AppTaskStatus.Done => (AppLocalization.StatusLabel(AppTaskStatus.Done), "bg-emerald-50 text-emerald-700"),
                                            _ => (AppLocalization.StatusLabel(AppTaskStatus.Todo), "bg-slate-100 text-slate-600")
                                        };
                                    }
                                    <span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium @statusClass">@statusLabel</span>
                                </td>
                            </tr>
                        }
                    }
                    else
                    {
                        <EmptyState ColSpan="8" Icon="clock" Title="@AppLocalization.Text("report.noEffortEntries", "No effort entries")" Subtitle="@AppLocalization.Text("report.noEffortEntriesDesc", "No timesheet effort entries matched your filters.")" />
                    }
                </tbody>
            </table>

            <!-- Pagination -->
            <Pagination CurrentPage="currentPage"
                        TotalPages="TotalPages"
                        PageSize="pageSize"
                        TotalCount="FilteredIssues.Count()"
                        OnPageChanged="HandlePageChanged"
                        OnPageSizeChanged="HandlePageSizeChanged" />
        </div>
        }
    }
</div>

@code {
    private bool isLoading = true;
    private bool isChartView = false;
    private List<IssueDto> allIssues = new();
    private List<ProjectDto> allProjects = new();

    // Filters
    private string searchInput = "";
    private string appliedSearch = "";
    private long filterProjectId = 0;
    private long appliedProjectId = 0;
    private string filterStatus = "0";
    private string appliedStatus = "0";
    private bool filterAssignToMe = false;
    private bool filterAssignToMyTeam = false;

    // Current User & Team
    private long currentUserId = 0;
    private List<long> myTeamUserIds = new();

    // Pagination
    private int currentPage = 1;
    private int pageSize = 10;

    // Metrics
    private decimal totalHours = 0;
    private decimal actualHours = 0;
    private decimal varianceHours = 0;
    private double utilizationPercent = 0;

    private int TotalPages => (int)Math.Ceiling((double)FilteredIssues.Count() / pageSize);

    private IEnumerable<IssueDto> FilteredIssues
    {
        get
        {
            var result = allIssues.AsEnumerable();

            if (appliedProjectId > 0)
                result = result.Where(i => i.ProjectId == appliedProjectId);

            if (appliedStatus != "0" && Enum.TryParse<AppTaskStatus>(appliedStatus, out var status))
                result = result.Where(i => i.StatusId == status);

            if (!string.IsNullOrWhiteSpace(appliedSearch))
            {
                var q = appliedSearch.Trim().ToLower();
                result = result.Where(i =>
                    ContainsSearch(i.Title, i.TitleMy, q) ||
                    ContainsSearch(i.Description, i.DescriptionMy, q) ||
                    ContainsSearch(i.AssignedToName, i.AssignedToNameMy, q) ||
                    ContainsSearch(i.TaskTitle, i.TaskTitleMy, q)
                );
            }

            if (filterAssignToMe || filterAssignToMyTeam)
            {
                result = result.Where(i => 
                    (filterAssignToMe && i.AssignedTo == currentUserId) || 
                    (filterAssignToMyTeam && i.AssignedTo.HasValue && myTeamUserIds.Contains(i.AssignedTo.Value))
                );
            }

            return result.OrderBy(i => i.Title);
        }
    }

    private static bool ContainsSearch(string? english, string? burmese, string search)
        => (!string.IsNullOrWhiteSpace(english) && english.Contains(search, StringComparison.OrdinalIgnoreCase))
           || (!string.IsNullOrWhiteSpace(burmese) && burmese.Contains(search, StringComparison.OrdinalIgnoreCase));

    private IEnumerable<IssueDto> PagedIssues => FilteredIssues.Skip((currentPage - 1) * pageSize).Take(pageSize);

    protected override async Task OnInitializedAsync()
    {
        var client = ApiClient.CreateClient();
        try
        {
            var issuesTask = client.GetFromJsonAsync<Result<List<IssueDto>>>("Report/issues", Serialization.CaseInsensitive);
            var projectsTask = client.GetFromJsonAsync<List<ProjectDto>>("Project", Serialization.CaseInsensitive);
            
            // Get current user ID
            var authState = await AuthStateProvider.GetAuthenticationStateAsync();
            var user = authState.User;
            if (user.Identity?.IsAuthenticated == true)
            {
                var idStr = user.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier)?.Value;
                if (long.TryParse(idStr, out var parsedId))
                {
                    currentUserId = parsedId;
                }
            }

            // Get team IDs
            try
            {
                var teamTask = client.GetFromJsonAsync<List<long>>("User/my-team-user-ids", Serialization.CaseInsensitive);
                await Task.WhenAll(issuesTask, projectsTask, teamTask);
                myTeamUserIds = teamTask.Result ?? new();
            }
            catch
            {
                await Task.WhenAll(issuesTask, projectsTask);
            }

            var issuesResult = issuesTask.Result;
            if (issuesResult?.IsSuccess == true && issuesResult.Value != null)
            {
                allIssues = issuesResult.Value;
            }
            allProjects = projectsTask.Result ?? new();

            ComputeMetrics();
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Error fetching timesheet data: {ex.Message}");
        }
        finally
        {
            isLoading = false;
        }
    }

    protected override async Task OnAfterRenderAsync(bool firstRender)
    {
        await JS.InvokeVoidAsync("initIcons");
    }

    private void SetView(bool chartView)
    {
        isChartView = chartView;
    }

    private void ComputeMetrics()
    {
        var today = DateTime.Today;
        var list = FilteredIssues.ToList();
        totalHours = list.Sum(i => i.EstimatedHours ?? 0);
        actualHours = list.Sum(i => i.ActualHours ?? 0);
        varianceHours = actualHours - totalHours;
        utilizationPercent = totalHours > 0 ? Math.Round((double)(actualHours / totalHours) * 100, 1) : 0;
    }

    private static decimal GetVariance(IssueDto issue) => (issue.ActualHours ?? 0) - (issue.EstimatedHours ?? 0);

    private int OnOrUnderEstimateCount => FilteredIssues.Count(i => (i.ActualHours ?? 0) <= (i.EstimatedHours ?? 0));
    private int OverEstimateCount => FilteredIssues.Count(i => (i.ActualHours ?? 0) > (i.EstimatedHours ?? 0));
    private string UtilizationColor => utilizationPercent > 115 ? "#ef4444" : utilizationPercent > 95 ? "#f59e0b" : "#10b981";
    private string EffortVarianceInsight => varianceHours > 0
        ? AppLocalization.Text("report.actualEffortAboveEstimate", "Actual effort is {hours}h above estimate.").Replace("{hours}", AppLocalization.Number(varianceHours))
        : AppLocalization.Text("report.actualEffortUnderEstimate", "Actual effort is {hours}h under estimate.").Replace("{hours}", AppLocalization.Number(Math.Abs(varianceHours)));
    private string UtilizationInsight => utilizationPercent > 115
        ? AppLocalization.Text("report.utilizationAbovePlan", "Utilization is above plan; review estimates and blockers.")
        : utilizationPercent < 70 ? AppLocalization.Text("report.utilizationBelowPlan", "Tracked actual effort is below plan; confirm work is being logged.") : AppLocalization.Text("report.utilizationCloseToPlan", "Utilization is close to the planning range.");
    private string EstimateAccuracyInsight => OverEstimateCount > OnOrUnderEstimateCount
        ? AppLocalization.Text("report.accuracyExceedingEstimate", "More issues are exceeding estimate than staying within it.")
        : AppLocalization.Text("report.accuracyWithinEstimate", "Most issues are within or under their estimates.");

    private List<StackedSegment> EffortComparisonSegments => new()
    {
        new(AppLocalization.Text("report.actual", "Actual"), (double)Math.Max(0, actualHours), "#3b82f6"),
        new(AppLocalization.Text("report.remainingEstimate", "Remaining estimate"), (double)Math.Max(0, totalHours - actualHours), "#dbeafe")
    };

    private List<ReportChartItem> EstimateAccuracyDonutItems => new()
    {
        new(AppLocalization.Text("report.onOrUnder", "On / Under"), OnOrUnderEstimateCount, "#10b981"),
        new(AppLocalization.Text("report.overLabel", "Over"), OverEstimateCount, "#ef4444")
    };

    private List<StackedSegment> ProjectEffortSegments => FilteredIssues
        .GroupBy(i => Content.GetText(i.ProjectName, i.ProjectNameMy))
        .OrderByDescending(g => g.Sum(i => i.ActualHours ?? 0))
        .Take(6)
        .Select((g, index) => new StackedSegment(g.Key, (double)g.Sum(i => i.ActualHours ?? 0), ChartPalette[index % ChartPalette.Length]))
        .ToList();

    private List<TopRiskItem> EmployeeEffortLeaders => FilteredIssues
        .GroupBy(i => string.IsNullOrWhiteSpace(Content.GetText(i.AssignedToName, i.AssignedToNameMy)) ? AppLocalization.Text("common.unassigned", "Unassigned") : Content.GetText(i.AssignedToName, i.AssignedToNameMy))
        .Select(g =>
        {
            var actual = g.Sum(i => i.ActualHours ?? 0);
            var estimated = g.Sum(i => i.EstimatedHours ?? 0);
            var score = estimated > 0 ? Math.Min(100, (double)(actual / estimated) * 100) : Math.Min(100, (double)actual * 10);
            var tone = score > 115 ? "rose" : score > 90 ? "amber" : "blue";

            return new TopRiskItem(
                g.Key,
                $"{AppLocalization.Number(actual)} {AppLocalization.Text("common.hoursAbbrev", "hrs")} {AppLocalization.Text("report.actual", "actual").ToLowerInvariant()} · {AppLocalization.Number(estimated)} {AppLocalization.Text("common.hoursAbbrev", "hrs")} {AppLocalization.Text("report.estimated", "estimated").ToLowerInvariant()}",
                score,
                $"{AppLocalization.Number(g.Count())} {AppLocalization.Text("report.issuesLabel", "issues")}",
                tone,
                $"{AppLocalization.Number(g.Count(i => (i.ActualHours ?? 0) > (i.EstimatedHours ?? 0)))} {AppLocalization.Text("report.overEstimateDesc", "over estimate")}");
        })
        .OrderByDescending(item => item.Score)
        .Take(5)
        .ToList();

    private static readonly string[] ChartPalette = ["#7c3aed", "#3b82f6", "#06b6d4", "#10b981", "#f59e0b", "#ef4444"];

    private List<ProgressListChartItem> EstimatedVsActualItems => new[]
    {
        new ProgressListChartItem(AppLocalization.Text("report.estimated", "Estimated"), (double)totalHours, $"{AppLocalization.Number(totalHours)}", "#7c3aed"),
        new ProgressListChartItem(AppLocalization.Text("report.actual", "Actual"), (double)actualHours, $"{AppLocalization.Number(actualHours)}", "#06b6d4")
    }.ToList();

    private double EstimatedVsActualMax => GetMax(EstimatedVsActualItems);

    private List<ProgressListChartItem> EffortByProjectItems => FilteredIssues
        .GroupBy(i => Content.GetText(i.ProjectName, i.ProjectNameMy))
        .OrderByDescending(g => g.Sum(i => i.ActualHours ?? 0))
        .Take(5)
        .Select(g =>
        {
            var hours = (double)g.Sum(i => i.ActualHours ?? 0);
            return new ProgressListChartItem(g.Key, hours, $"{AppLocalization.Number(hours, "N1")}", "#7c3aed");
        })
        .ToList();

    private double EffortByProjectMax => GetMax(EffortByProjectItems);

    private List<ProgressListChartItem> EffortByEmployeeItems => FilteredIssues
        .GroupBy(i => string.IsNullOrWhiteSpace(Content.GetText(i.AssignedToName, i.AssignedToNameMy)) ? AppLocalization.Text("common.unassigned", "Unassigned") : Content.GetText(i.AssignedToName, i.AssignedToNameMy))
        .OrderByDescending(g => g.Sum(i => i.ActualHours ?? 0))
        .Take(5)
        .Select(g =>
        {
            var hours = (double)g.Sum(i => i.ActualHours ?? 0);
            return new ProgressListChartItem(g.Key, hours, $"{AppLocalization.Number(hours)}", "#7c3aed");
        })
        .ToList();

    private double EffortByEmployeeMax => GetMax(EffortByEmployeeItems);

    private List<ProgressListChartItem> EstimateAccuracyItems => new[]
    {
        new ProgressListChartItem(AppLocalization.Text("report.onOrUnder", "On / Under"), FilteredIssues.Count(i => (i.ActualHours ?? 0) <= (i.EstimatedHours ?? 0)), AppLocalization.Number(FilteredIssues.Count(i => (i.ActualHours ?? 0) <= (i.EstimatedHours ?? 0))), "#10b981"),
        new ProgressListChartItem(AppLocalization.Text("report.overLabel", "Over"), FilteredIssues.Count(i => (i.ActualHours ?? 0) > (i.EstimatedHours ?? 0)), AppLocalization.Number(FilteredIssues.Count(i => (i.ActualHours ?? 0) > (i.EstimatedHours ?? 0))), "#ef4444")
    }.ToList();

    private double EstimateAccuracyMax => GetMax(EstimateAccuracyItems);

    private static double GetMax(IEnumerable<ProgressListChartItem> items)
    {
        return Math.Max(1, items.Select(item => item.Value).DefaultIfEmpty(0).Max());
    }

    private Task ApplyFilters()
    {
        appliedSearch = searchInput;
        appliedProjectId = filterProjectId;
        appliedStatus = filterStatus;
        currentPage = 1;
        ComputeMetrics();
        return Task.CompletedTask;
    }

    private Task ResetFilters()
    {
        searchInput = "";
        appliedSearch = "";
        filterProjectId = 0;
        appliedProjectId = 0;
        filterStatus = "0";
        appliedStatus = "0";
        filterAssignToMe = false;
        filterAssignToMyTeam = false;
        currentPage = 1;
        ComputeMetrics();
        return Task.CompletedTask;
    }

    private Task HandlePageChanged(int page)
    {
        currentPage = page;
        return Task.CompletedTask;
    }

    private Task HandlePageSizeChanged(int size)
    {
        pageSize = size;
        currentPage = 1;
        return Task.CompletedTask;
    }

    private async Task DownloadExcel()
    {
        var rows = FilteredIssues.Select(issue =>
        {
            var statusLabel = AppLocalization.StatusLabel(issue.StatusId);

            return new object?[]
            {
                Content.GetText(issue.Title, issue.TitleMy),
                Content.GetText(issue.TaskTitle, issue.TaskTitleMy),
                Content.GetText(issue.ProjectName, issue.ProjectNameMy),
                string.IsNullOrWhiteSpace(Content.GetText(issue.AssignedToName, issue.AssignedToNameMy)) ? "Unassigned" : Content.GetText(issue.AssignedToName, issue.AssignedToNameMy),
                issue.EstimatedHours ?? 0,
                issue.DueDate,
                statusLabel
            };
        });

        var workbookBytes = SpreadsheetReportBuilder.BuildTableWorkbook(
            "Time Effort Tracking",
            "Timesheet Effort Report",
            new[] { "Issue", "Task", "Project", "Assignee", "Estimated Effort (Hours)", "Due Date", "Status" },
            rows,
            new[]
            {
                $"Search: {(string.IsNullOrWhiteSpace(appliedSearch) ? "All" : appliedSearch)}",
                $"Project: {(appliedProjectId > 0 && allProjects.FirstOrDefault(p => p.Id == appliedProjectId) is { } project ? Content.GetProjectName(project) : "All")}",
                $"Status: {(appliedStatus != "0" ? appliedStatus : "All")}",
                $"Assigned To Me: {(filterAssignToMe ? "Yes" : "No")}",
                $"Assigned To My Team: {(filterAssignToMyTeam ? "Yes" : "No")}",
                $"Generated: {DisplayFormats.Date(DateTime.Today)}"
            });

        await JS.InvokeVoidAsync(
            "downloadFileFromBase64",
            $"TimesheetEffortReport_{DateTime.Today:yyyyMMdd}.xlsx",
            "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            Convert.ToBase64String(workbookBytes));
    }

    private async Task DownloadPdf()
    {
        var summaryLines = new List<string>
        {
            $"Search: {(string.IsNullOrWhiteSpace(appliedSearch) ? "All" : appliedSearch)}",
            $"Project: {(appliedProjectId > 0 && allProjects.FirstOrDefault(p => p.Id == appliedProjectId) is { } project ? Content.GetProjectName(project) : "All")}",
            $"Status: {(appliedStatus != "0" ? appliedStatus : "All")}",
            $"Assigned To Me: {(filterAssignToMe ? "Yes" : "No")}",
            $"Assigned To My Team: {(filterAssignToMyTeam ? "Yes" : "No")}",
            $"Total Effort: {totalHours.ToString("N1")} hrs",
            $"Actual Hours: {actualHours.ToString("N1")} hrs",
            $"Generated: {DisplayFormats.Date(DateTime.Today)}"
        };

        var rows = FilteredIssues.Select(issue =>
        {
            var statusLabel = AppLocalization.StatusLabel(issue.StatusId);

            return new[]
            {
                Content.GetText(issue.Title, issue.TitleMy),
                Content.GetText(issue.TaskTitle, issue.TaskTitleMy),
                Content.GetText(issue.ProjectName, issue.ProjectNameMy),
                string.IsNullOrWhiteSpace(Content.GetText(issue.AssignedToName, issue.AssignedToNameMy)) ? "Unassigned" : Content.GetText(issue.AssignedToName, issue.AssignedToNameMy),
                (issue.EstimatedHours ?? 0).ToString("N1") + " hrs",
                DisplayFormats.Date(issue.DueDate),
                statusLabel
            };
        });

        var pdfBytes = SimplePdfReportBuilder.BuildTableReport(
            "Timesheet Effort Tracking Report",
            summaryLines,
            new[] { "Issue", "Task", "Project", "Assignee", "Est. Effort", "Due Date", "Status" },
            rows);

        await JS.InvokeVoidAsync(
            "downloadFileFromBase64",
            $"TimesheetEffortReport_{DateTime.Today:yyyyMMdd}.pdf",
            "application/pdf",
            Convert.ToBase64String(pdfBytes));
    }
}