​

Participant Filtering and Search System - Supervisor Role

​

Implementation Summary

A complete participant filtering and search system optimized for the supervisor role has been implemented, with the following features:

​

Implemented Features

​

1. Dynamic Status Filter

• Dropdown with all available statuses
• Participant count per status
• Filtering without reloading the page (AJAX)
• Button to clear filters

​

2. Participant Search

• Real-time search by name, email, or locator
• 500ms debounce to optimize queries
• Search within the JSON details field
• Button to clear search

​

3. Optimized Pagination

• Limit of 50 participants per page
• Dynamic navigation without reload
• Real-time updated pagination information

​

4. Filtered Export

• “Status” field included in the export options
• Export respects applied filters: only exports filtered participants
• Readable format: “PAGADO” for status “OK”
• Descriptive file names with applied filters
• Integration with the existing optimized export system

​

5. Performance Optimizations

​

Backend:

• Optimized queries: Only selects necessary fields
• Statistics cache: 5-minute cache for status counts
• Database indexes: Composite indexes for fast queries
• LEFT JOIN: To avoid data loss if there is no associated order
• Optimized search: Specific indexes for locator searches

​

Frontend:

• Asynchronous loading: Filters applied via AJAX
• Search debounce: 500ms to avoid excessive queries
• Loading indicators: Visual feedback during operations
• Dynamic update: No page reloads
• Error handling: Notifications for the user

​

Files Modified

​

1. Controller

• app/Http/Controllers/Eventos/EventosController.php
  • indexParticipants() method optimized with search
  • Support for AJAX requests
  • Status statistics cache
  • Export with applied filters

​

2. View

• resources/views/eventos/participants/index.blade.php
  • Status filter and search interface
  • Dynamic table with JavaScript
  • Export modal updated with filter information

​

3. Export

• app/Exports/ParticipantsExportOptimized.php
  • Status field included in export
  • Support for status and search filters
  • Optimized data mapping

​

4. Routes

• routes/eventos.php
  • New route for AJAX filtering

​

5. Database

• New migration: 2025_09_23_235950_add_indexes_to_eventos_x_usuarios_for_status_filter.php
  • Composite indexes for filter optimization
• New migration: 2025_09_24_000517_add_search_indexes_to_eventos_x_usuarios.php
  • Indexes for search optimization

​

Technical Features

​

Optimizations for Large Datasets:

1. Pagination: Maximum 50 records per page
2. Indexes: Optimized queries with composite indexes
3. Cache: Statistics cached for 5 minutes
4. Specific select: Only necessary fields in queries
5. LEFT JOIN: Avoids data loss

​

User Interface:

1. No reloads: Fully dynamic filtering
2. Visual feedback: Loading indicators and states
3. Contextual information: Counters and statistics
4. Responsive: Works on mobile devices

​

Usage

1. Access participants: Supervisors are automatically redirected
2. Filter by status: Use the “Filter by Status” dropdown
3. Search participants: Use the “Search participants” field (name, email, locator)
4. Clear filters: “Clear Filters” button (removes filters and search)
5. Export filtered: The modal shows which filters are applied and exports only those results
6. Navigate pages: Dynamic pagination at the bottom

​

Performance

• Optimized queries for events with 30,000+ participants
• Intelligent cache reduces repetitive queries
• Efficient pagination avoids server overload
• Database indexes speed up status filtering

​

Compatibility

• Compatible with the existing optimized export system
• Maintains drawer functionality to view details
• Integrated with the existing notification system
• Works with the export validation middleware