Spaces:
Runtime error
Runtime error
task-tracking-system / TaskTrackingSystem.WebApp /Components /Pages /Features /Reports /TimeTrackingReport.razor
| @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)); | |
| } | |
| } | |