@page "/workorders/selectedlist" @using Blazored.Toast.Services @using MaasOffline.Models.DTOs @using MaasOffline.Models.Entities @using Microsoft.AspNetCore.Components.Web @inject NavigationManager navigationManager @inject IOfflineStorageService StorageService @inject IToastService ToastService @inject IJSRuntime JSRuntime @inject ILogger _logger @inject IWorkOrderApiService WorkOrderService @inject IIndexedDbService IndexedDbService Work Orders List

Work Orders List

@if (isInitialized) {
}
@if (_isLoading) { } else {

Work Orders (Count: @filteredWorkOrders.Count)

@if (showWorkOrderId) { } else { } @foreach (var workOrder in filteredWorkOrders) { @if (showWorkOrderId) { } else { } }
WO # @(RenderSortIndicator(nameof(WorkOrderDto.Id))) Inv # @(RenderSortIndicator(nameof(WorkOrderDto.Title))) Sec @(RenderSortIndicator(nameof(WorkOrderDto.PhaseSection))) Site @(RenderSortIndicator(nameof(WorkOrderDto.SiteNumber))) Cat @(RenderSortIndicator(nameof(WorkOrderDto.CategoryName))) Status @(RenderSortIndicator(nameof(WorkOrderDto.StatusName)))
@workOrder.Id @(Int32.TryParse(workOrder.Title, out x) ? workOrder.Title : "") @workOrder.PhaseSection
@if (selectedRowId == workOrder.Id && rowLoading) { } @workOrder.SiteNumber
@workOrder.CategoryName @workOrder.StatusName @GetStatusInitial(workOrder.StatusName) @if (workOrderAttachments.ContainsKey(workOrder.Id) && workOrderAttachments[workOrder.Id] > 0) { }
}
@code { // Data private List workOrders = new(); private List filteredWorkOrders = new(); private WorkOrderList searchCriteria = new(); private List categories = new(); private WorkOrderFilters filters = new(); // Selected WorkOrder List private List selectedWorkOrders = new(); private List phaseSections = new(); private List siteNumbers = new(); private List filteredPhaseSections = new(); private List filteredSiteNumbers = new(); // UI state private bool _isLoading = false; private bool isFilterVisible = false; // hidden by default private bool isFilterApplying = false; private int? selectedRowId = null; private bool rowLoading = false; private string siteSearchText = string.Empty; private bool isSiteDropdownVisible = false; private bool isNewWorkOrder = false; // Column visibility toggle - true shows Work Order ID, false shows Invoice Number private bool showWorkOrderId = true; // Default to showing Work Order ID // Sorting state private string currentSortField = nameof(WorkOrderDto.Id); private bool isAscending = true; int x = 0; // Sync Options private SyncOptions syncOptions { get; set; } = new(); // Users List private List assignedToUsers { get; set; } = new(); // isForMeOn private bool isForMeOn { get; set; } = false; private bool isInitialized { get; set; } = false; // All Assigned WorkOrders public List allAssignedWorkOrders { get; set; } = new(); // Attachment counts per work order private Dictionary workOrderAttachments = new(); // Render sort indicator private RenderFragment RenderSortIndicator(string field) = > builder = > { if (field == currentSortField) { builder .OpenElement(0, "span"); builder .AddAttribute(1, "class", "sort-indicator"); builder .AddContent(2, isAscending ? " ▲" : " ▼"); builder .CloseElement(); } } ; private List FilteredSiteSuggestions = > siteNumbers .Where(s => string.IsNullOrWhiteSpace(siteSearchText) || s.Contains(siteSearchText, StringComparison.OrdinalIgnoreCase)) .OrderBy(s => s) .ToList(); protected override async Task OnInitializedAsync() { _isLoading = true; try { // Load user column preferences await LoadColumnPreferences(); syncOptions = await StorageService.GetSyncOptionsAsync(); _logger .LogInformation("Loading work orders"); workOrders = await StorageService.GetWorkOrderUpdatesAsync(); var lookupData = await StorageService.GetLookupDataAsync(); // Populate category names from lookup data if (lookupData?.Categories != null && lookupData.Categories.Any()) { _logger .LogInformation($"Found {lookupData.Categories.Count()} categories in lookup data"); var categoryDict = lookupData.Categories.ToDictionary(c => c.Id, c => c.CategoryName); int populatedCount = 0; int skippedCount = 0; foreach (var workOrder in workOrders) { if (categoryDict.TryGetValue(workOrder.CategoryId, out var categoryName)) { workOrder .CategoryName = categoryName; populatedCount ++; } else { _logger .LogWarning($"Category ID {workOrder.CategoryId} not found in lookup data for WorkOrder {workOrder.Id}"); workOrder .CategoryName = "Unknown Category"; skippedCount ++; } } _logger.LogInformation($"Category population complete: {populatedCount} populated, {skippedCount} skipped"); } else { _logger .LogWarning("No lookup data or categories found"); foreach (var workOrder in workOrders) { workOrder .CategoryName = "No Categories Available"; } } // Load attachment counts await LoadAttachmentCounts(); // Initial list: optionally scoped to current user isForMeOn = await StorageService.GetUserPreferences(); if (isForMeOn) { filteredWorkOrders = workOrders .Where(w => w.EmployeeId == syncOptions.EmployeeId) .OrderBy(w => w.PhaseSection) .ThenBy(w => w.SiteNumber) .ToList(); allAssignedWorkOrders .Clear(); allAssignedWorkOrders .AddRange(filteredWorkOrders); } else { filteredWorkOrders = workOrders.OrderBy(w => w.PhaseSection).ThenBy(w => w.SiteNumber).ToList(); } // Load saved filters (use the field, not a local shadow) var filtersFromStorage = await StorageService.GetFilters(); if (filtersFromStorage != null) { filters = filtersFromStorage; if (filters.CategoryId > 0 || !string.IsNullOrWhiteSpace(filters.PhaseSection) || !string.IsNullOrWhiteSpace(filters.SiteNumber)) { searchCriteria .CategoryId = filters.CategoryId; searchCriteria .PhaseSection = filters.PhaseSection; searchCriteria .SiteNumber = filters.SiteNumber; currentSortField = string.IsNullOrWhiteSpace(filters.CurrentSortField) ? currentSortField : filters.CurrentSortField; isAscending = filters.IsAscending; SortTable(currentSortField); // will persist state await FilterWorkOrders(); } isFilterVisible = filters.IsFilterVisible; } await LoadDropdownData(); filteredPhaseSections = phaseSections; filteredSiteNumbers = siteNumbers; siteSearchText = searchCriteria.SiteNumber; isInitialized = true; } catch (Exception ex) { _logger .LogError(ex, "Failed to load work orders"); ShowToast("Failed to load work orders", false); } finally { _isLoading = false; } } private async Task LoadAttachmentCounts() { try { workOrderAttachments .Clear(); // Local attachments from IndexedDB: WOImages var localImages = await IndexedDbService.GetAllAsync("WOImages"); if (localImages != null) { var localCounts = localImages .Where(img => img.WorkOrderId > 0) .GroupBy(img => img.WorkOrderId) .ToDictionary(g => g.Key, g => g.Count()); foreach (var kvp in localCounts) workOrderAttachments[kvp.Key] = kvp.Value; } // Server attachments mirrored in IndexedDB: WOImagesFromDb var serverImages = await IndexedDbService.GetAllAsync("WOImagesFromDb"); if (serverImages != null) { var serverCounts = serverImages .Where(img => img.WorkOrderId > 0) .GroupBy(img => img.WorkOrderId) .ToDictionary(g => g.Key, g => g.Count()); foreach (var kvp in serverCounts) { if (workOrderAttachments.ContainsKey(kvp.Key)) workOrderAttachments[kvp.Key] += kvp.Value; else workOrderAttachments[kvp.Key] = kvp.Value; } } _logger.LogInformation($"Loaded attachment counts for {workOrderAttachments.Count} work orders"); } catch (Exception ex) { _logger .LogError(ex, "Failed to load attachment counts"); } } private void ViewAttachments(int workOrderId) { navigationManager .NavigateTo($"/view-attachment/{workOrderId}"); } private async Task LoadDropdownData() { try { var lookupData = await StorageService.GetLookupDataAsync(); if (lookupData != null) { categories = lookupData.Categories.ToList(); if (lookupData.Memberships != null) { phaseSections = lookupData.Memberships .Where(m => !string.IsNullOrWhiteSpace(m.Section)) .Select(m => m.Section) .Distinct() .OrderBy(s => s) .ToList(); } else { phaseSections = workOrders .Where(w => !string.IsNullOrEmpty(w.PhaseSection)) .Select(w => w.PhaseSection) .Distinct() .OrderBy(p => p) .ToList(); } } siteNumbers = workOrders .Where(w => !string.IsNullOrEmpty(w.SiteNumber)) .Select(w => w.SiteNumber) .Distinct() .OrderBy(s => s) .ToList(); } catch (Exception ex) { _logger .LogError(ex, "Failed to load filter options"); ShowToast("Failed to load filter options", false); } } private async Task OnCategoryChanged(ChangeEventArgs e) { searchCriteria .CategoryId = Convert.ToInt32(e.Value); UpdateFilteredDropdowns(searchCriteria.CategoryId); await FilterWorkOrders(); } private async Task OnSectionChanged(ChangeEventArgs e) { searchCriteria .PhaseSection = Convert.ToString(e.Value) ?? ""; await FilterWorkOrders(); } private void UpdateFilteredDropdowns(int categoryId) { try { var categoryWorkOrders = categoryId == -1 ? workOrders : workOrders.Where(w => w.CategoryId == categoryId); filteredPhaseSections = phaseSections; filteredSiteNumbers = categoryWorkOrders .Where(w => !string.IsNullOrEmpty(w.SiteNumber)) .Select(w => w.SiteNumber) .Distinct() .OrderBy(s => s) .ToList(); } catch (Exception ex) { _logger .LogError(ex, "Failed to update dropdowns"); ShowToast("Failed to update dropdowns", false); } } private Task OnSiteSearchInput(ChangeEventArgs e) { siteSearchText = e?.Value?.ToString() ?? string.Empty; return Task.CompletedTask; } private async Task ApplySiteFilter() { searchCriteria .SiteNumber = (siteSearchText ?? string.Empty).Trim(); await FilterWorkOrders(); } private async Task ClearSiteFilter() { siteSearchText = string.Empty; searchCriteria .SiteNumber = string.Empty; await FilterWorkOrders(); } private async Task OnSiteKeyDown(KeyboardEventArgs e) { if (string.Equals(e?.Key, "Enter", StringComparison.OrdinalIgnoreCase)) await ApplySiteFilter(); } private async Task FilterWorkOrders() { _isLoading = true; isFilterApplying = true; try { // Apply filters var query = BuildFilterQuery(); // Apply current sort ApplySorting(ref query); filteredWorkOrders = query.ToList(); // Persist filters filters.CategoryId = searchCriteria.CategoryId; filters .PhaseSection = searchCriteria.PhaseSection; filters .SiteNumber = searchCriteria.SiteNumber; filters .IsFilterVisible = (searchCriteria.CategoryId != -1 || !string.IsNullOrWhiteSpace(searchCriteria.PhaseSection) || !string.IsNullOrWhiteSpace(searchCriteria.SiteNumber)); await StorageService.SaveFilters(filters); ShowToast("Filters applied successfully"); } catch (Exception ex) { _logger .LogError(ex, "Error applying filters"); ShowToast("Error applying filters", false); } finally { _isLoading = false; isFilterApplying = false; } } private void SortTable(string field) { if (currentSortField == field) { isAscending = !isAscending; } else { currentSortField = field; isAscending = true; } filters.CurrentSortField = currentSortField; filters.IsAscending = isAscending; // persist the actual direction StorageService.SaveFilters(filters); // Re-sort the filtered list var query = filteredWorkOrders.AsQueryable(); ApplySorting(ref query); filteredWorkOrders = query.ToList(); } private void ApplySorting(ref IQueryable query) { switch (currentSortField) { case nameof(WorkOrderDto.Id): query = isAscending ? query.OrderBy(w => w.Id) : query.OrderByDescending(w => w.Id); break; case nameof(WorkOrderDto.Title): query = isAscending ? query.OrderBy(w => w.Title) : query.OrderByDescending(w => w.Title); break; case nameof(WorkOrderDto.PhaseSection): query = isAscending ? query.OrderBy(w => w.PhaseSection) : query.OrderByDescending(w => w.PhaseSection); break; case nameof(WorkOrderDto.SiteNumber): query = isAscending ? query.OrderBy(w => w.SiteNumber) : query.OrderByDescending(w => w.SiteNumber); break; case nameof(WorkOrderDto.CategoryName): query = isAscending ? query.OrderBy(w => w.CategoryName) : query.OrderByDescending(w => w.CategoryName); break; case nameof(WorkOrderDto.StatusName): query = isAscending ? query.OrderBy(w => w.StatusName) : query.OrderByDescending(w => w.StatusName); break; default: query = query.OrderBy(w => w.PhaseSection).ThenBy(w => w.SiteNumber); break; } } private IQueryable BuildFilterQuery() { IQueryable query = isForMeOn ? allAssignedWorkOrders.AsQueryable() : workOrders.AsQueryable(); if (searchCriteria.CategoryId > 0) query = query.Where(w => w.CategoryId == searchCriteria.CategoryId); if (!string.IsNullOrWhiteSpace(searchCriteria.PhaseSection)) query = query.Where(w => w.PhaseSection.Equals(searchCriteria.PhaseSection, StringComparison.OrdinalIgnoreCase)); if (!string.IsNullOrWhiteSpace(searchCriteria.SiteNumber)) { var term = searchCriteria.SiteNumber.Trim(); query = query.Where(w => !string.IsNullOrEmpty(w.SiteNumber) && w.SiteNumber.IndexOf(term, StringComparison.OrdinalIgnoreCase) >= 0); } return query; } private void ShowToast(string message, bool isSuccess = true) { if (isSuccess) ToastService.ShowSuccess(message); else ToastService.ShowError(message); } private string GetStatusColor(string? status) = > status?.ToLower() switch { "completed" => "success", "in progress" => "warning", "pending" => "secondary", _ => "secondary" } ; private void GoToAddWorkOrderPage() = > navigationManager.NavigateTo(AppConstants.Routes.addWorkOrder); private async Task EditWorkOrder(WorkOrderDto workOrder) { if (workOrder != null) { selectedRowId = workOrder.Id; rowLoading = true; StateHasChanged(); await Task.Delay(500); navigationManager .NavigateTo(AppConstants.Routes.addWorkOrder + $"/{workOrder.Id}"); } } private void ToggleFilter() = > isFilterVisible = !isFilterVisible; private async Task SaveColumnPreferences() { try { await JSRuntime.InvokeVoidAsync("localStorage.setItem", "showWorkOrderId", showWorkOrderId.ToString()); } catch (Exception ex) { _logger .LogError(ex, "Failed to save column preferences"); } } private async Task LoadColumnPreferences() { try { var savedShowWorkOrderId = await JSRuntime.InvokeAsync("localStorage.getItem", "showWorkOrderId"); if (!string.IsNullOrEmpty(savedShowWorkOrderId)) showWorkOrderId = bool.Parse(savedShowWorkOrderId); } catch (Exception ex) { _logger .LogError(ex, "Failed to load column preferences"); } } private async Task OnDisplayToggleChanged(bool value) { showWorkOrderId = value; await SaveColumnPreferences(); } private async Task OnDisplaySelectChanged(ChangeEventArgs e) { if (bool.TryParse(e.Value?.ToString(), out var value)) { showWorkOrderId = value; await SaveColumnPreferences(); } } private string GetRowClasses(int rowId) { var classes = new List(); if (selectedRowId == rowId) { classes .Add("selected-row"); if (rowLoading) classes.Add("row-loading"); } return string.Join(" ", classes); } private async Task ResetFilters() { searchCriteria .CategoryId = -1; searchCriteria .PhaseSection = ""; searchCriteria .SiteNumber = ""; siteSearchText = ""; await FilterWorkOrders(); } private async Task ClearAndHideFilters() { await ResetFilters(); isFilterVisible = false; } private async Task ForMeClick() { isForMeOn = true; await StorageService.SaveUserPreferences(isForMeOn); var allWorkOrders = await StorageService.GetWorkOrderUpdatesAsync(); filteredWorkOrders = allWorkOrders .Where(w => w.EmployeeId == syncOptions.EmployeeId) .OrderBy(w => w.PhaseSection) .ThenBy(w => w.SiteNumber) .ToList(); allAssignedWorkOrders .Clear(); allAssignedWorkOrders .AddRange(filteredWorkOrders); var lookupData = await StorageService.GetLookupDataAsync(); if (lookupData?.Categories != null && lookupData.Categories.Any()) { var categoryDict = lookupData.Categories.ToDictionary(c => c.Id, c => c.CategoryName); foreach (var workOrder in filteredWorkOrders) workOrder.CategoryName = categoryDict.GetValueOrDefault(workOrder.CategoryId, "Unknown Category"); } } private async Task TurnOffForMe() { isForMeOn = false; await StorageService.SaveUserPreferences(isForMeOn); workOrders = await StorageService.GetWorkOrderUpdatesAsync(); filteredWorkOrders = workOrders.OrderBy(w => w.PhaseSection).ThenBy(w => w.SiteNumber).ToList(); } private string GetStatusInitial(string? status) { if (string.IsNullOrWhiteSpace(status)) return ""; return status.Trim().Substring(0, 1).ToUpper(); } }