Advanced Search

Overview

C.A.R. 911 provides comprehensive search and filtering capabilities across all major resources. You can combine multiple filters to narrow down results and find exactly what you need.

Equipment Search

Search and filter equipment with multiple criteria:

Text Search

Search across multiple fields simultaneously:

// Export: app/Exports/EquiposExport.php:121-129
if (!empty($filters['texto'])) {
    $texto = $filters['texto'];
    $query->where(function ($q) use ($texto) {
        $q->where('equipos.issi', 'like', '%' . $texto . '%')
            ->orWhere('equipos.tei', 'like', '%' . $texto . '%')
            ->orWhere('recursos.nombre', 'like', '%' . $texto . '%')
            ->orWhere('destino.nombre', 'like', '%' . $texto . '%');
    });
}

Equipment Filters

Filter by Equipment Type

Select specific equipment types:

// Export: app/Exports/EquiposExport.php:131-133
if (!empty($filters['equipo_id'])) {
    $query->whereIn('equipos.id', $filters['equipo_id']);
}

Filter by Resource

Find equipment assigned to specific resources:

// Export: app/Exports/EquiposExport.php:135-137
if (!empty($filters['recurso_id'])) {
    $query->whereIn('flota_general.recurso_id', $filters['recurso_id']);
}

Filter by Terminal Type

Search by terminal type:

// Export: app/Exports/EquiposExport.php:175-177
if (!empty($filters['tipo_terminal_id'])) {
    $query->whereIn('equipos.tipo_terminal_id', $filters['tipo_terminal_id']);
}

Filter by State

Find equipment in specific states:

// Export: app/Exports/EquiposExport.php:179-181
if (!empty($filters['estado_id'])) {
    $query->whereIn('equipos.estado_id', $filters['estado_id']);
}

Hierarchical Destination Search

The system supports hierarchical searching through organizational units:

When you filter by destination, the system automatically includes all child destinations in the hierarchy.

Current Destination Filter

Find equipment currently assigned to a destination or its children:

// Export: app/Exports/EquiposExport.php:139-158
if (!empty($filters['destino_actual_id'])) {
    $todosLosDestinosActuales = collect();
    
    foreach ($filters['destino_actual_id'] as $destinoId) {
        $destinosHijos = Destino::obtenerTodosLosHijos($destinoId);
        $todosLosDestinosActuales = $todosLosDestinosActuales->merge($destinosHijos);
    }
    
    $destinosActualesIds = $todosLosDestinosActuales->unique()->values()->all();
    
    if (!empty($destinosActualesIds)) {
        $query->whereExists(function ($subQuery) use ($destinosActualesIds) {
            $subQuery->select(DB::raw(1))
                ->from('historico as historico_actual')
                ->whereColumn('historico_actual.equipo_id', 'equipos.id')
                ->whereIn('historico_actual.destino_id', $destinosActualesIds)
                ->whereNull('historico_actual.fecha_desasignacion');
        });
    }
}

Historical Destination Filter

Search by any historical assignment:

// Export: app/Exports/EquiposExport.php:160-173
if (!empty($filters['destino_id'])) {
    $todosLosDestinos = collect();
    
    foreach ($filters['destino_id'] as $destinoId) {
        $destinosHijos = Destino::obtenerTodosLosHijos($destinoId);
        $todosLosDestinos = $todosLosDestinos->merge($destinosHijos);
    }
    
    $destinosIds = $todosLosDestinos->unique()->values()->all();
    
    if (!empty($destinosIds)) {
        $query->whereIn('flota_general.destino_id', $destinosIds);
    }
}

Date Range Filtering

Search by assignment date ranges:

// Export: app/Exports/EquiposExport.php:183-198
if (!empty($filters['fecha_rango'])) {
    $partes = explode(' - ', $filters['fecha_rango']);
    
    if (count($partes) === 2) {
        $fechaInicio = Carbon::parse($partes[0])->startOfDay();
        $fechaFin = Carbon::parse($partes[1])->endOfDay();
        
        $query->whereExists(function ($subQuery) use ($fechaInicio, $fechaFin) {
            $subQuery->select(DB::raw(1))
                ->from('historico as historico_fecha')
                ->whereColumn('historico_fecha.equipo_id', 'equipos.id')
                ->whereBetween('historico_fecha.fecha_asignacion', 
                              [$fechaInicio, $fechaFin])
                ->whereNull('historico_fecha.fecha_desasignacion');
        });
    }
}

Task Search

Filter tasks by multiple criteria:

Task Name Filter

// Controller: app/Http/Controllers/TareaController.php:35-40
if ($request->filled('nombre')) {
    $nombre = $request->nombre;
    $query->whereHas('tarea', function ($q) use ($nombre) {
        $q->where('nombre', 'like', '%' . $nombre . '%');
    });
}

Task Status Filter

// Controller: app/Http/Controllers/TareaController.php:42-44
if ($request->filled('estado')) {
    $query->where('estado', $request->estado);
}

Task Date Filters

Scheduled Date Range

Filter by when tasks are scheduled:

// Controller: app/Http/Controllers/TareaController.php:55-61
if ($request->filled('fecha_programada_desde')) {
    $query->whereDate('fecha_programada', '>=', 
                     $request->fecha_programada_desde);
}

if ($request->filled('fecha_programada_hasta')) {
    $query->whereDate('fecha_programada', '<=', 
                     $request->fecha_programada_hasta);
}

Completion Date Range

Filter by when tasks were completed:

// Controller: app/Http/Controllers/TareaController.php:96-102
if ($request->filled('fecha_realizada_desde')) {
    $query->whereDate('fecha_realizada', '>=', 
                     $request->fecha_realizada_desde);
}

if ($request->filled('fecha_realizada_hasta')) {
    $query->whereDate('fecha_realizada', '<=', 
                     $request->fecha_realizada_hasta);
}

Task Assignment Filter

// Controller: app/Http/Controllers/TareaController.php:46-48
if ($request->filled('realizado_por')) {
    $query->where('realizado_por', $request->realizado_por);
}

Audit Log Search

Search audit logs with comprehensive filters:

Combined Filters

Text Search

Search in action descriptions and changes:

// Controller: app/Http/Controllers/AuditoriaController.php:28-33
if ($texto) {
    $query->where(function ($q) use ($texto) {
        $q->where('accion', 'LIKE', '%' . $texto . '%')
            ->orWhere('cambios', 'LIKE', '%' . $texto . '%');
    });
}

Table Filter

Filter by affected table:

// Controller: app/Http/Controllers/AuditoriaController.php:36-38
if ($tabla) {
    $query->where('nombre_tabla', $tabla);
}

User Filter

Filter by who made changes:

// Controller: app/Http/Controllers/AuditoriaController.php:40-43
if ($usuario) {
    $query->where('user_id', $usuario);
}

Date Range

Filter by when changes occurred:

// Controller: app/Http/Controllers/AuditoriaController.php:45-51
if ($fecha_desde) {
    $query->whereDate('created_at', '>=', $fecha_desde);
}
if ($fecha_hasta) {
    $query->whereDate('created_at', '<=', $fecha_hasta);
}

Advanced Search Route

Access the advanced search interface:

// Routes: routes/web.php:111-112
Route::get('/busqueda-avanzada', 
    [FlotaGeneralController::class, 'busquedaAvanzada'])
    ->name('flota.busquedaAvanzada');

Route::get('/busqueda-avanzada/export-excel', 
    [FlotaGeneralController::class, 'exportExcelBusquedaAvanzada'])
    ->name('flota.busquedaAvanzada.export');

Search with Relationships

The equipment search joins multiple tables for comprehensive results:

// Export: app/Exports/EquiposExport.php:51-88
$query = Equipo::select(
    'equipos.id',
    DB::raw("CONCAT(tipo_terminales.marca, ' ', tipo_terminales.modelo) AS terminal"),
    'estados.nombre as estado',
    'equipos.provisto as provisto',
    'destino.nombre as dependencia',
    'equipos.nombre_issi as id_issi',
    'equipos.issi as issi',
    'equipos.tei as tei',
    'recursos.nombre as recurso',
    'destino_padre.nombre as dependencia_superior',
    'historico.fecha_asignacion',
    'flota_general.ticket_per',
    'vehiculos.marca as vehiculo_marca',
    'vehiculos.modelo as vehiculo_modelo',
    'vehiculos.dominio as vehiculo_patente',
    'flota_general.observaciones as observaciones_flota'
)
->leftJoin('flota_general', 'equipos.id', '=', 'flota_general.equipo_id')
->leftJoin('recursos', 'flota_general.recurso_id', '=', 'recursos.id')
->leftJoin('destino', 'flota_general.destino_id', '=', 'destino.id')
->leftJoin('destino as destino_padre', 'destino.parent_id', '=', 'destino_padre.id')
->leftJoin('vehiculos', 'recursos.vehiculo_id', '=', 'vehiculos.id')
->leftJoin('tipo_terminales', 'equipos.tipo_terminal_id', '=', 'tipo_terminales.id')
->leftJoin('estados', 'equipos.estado_id', '=', 'estados.id');

All search filters support wildcards and partial matches, making it easy to find resources even with incomplete information.

Pagination

Search results are paginated for performance:

// Controller: app/Http/Controllers/TareaController.php:109-111
$items = $query
    ->paginate(15)
    ->appends($request->query());

All filters persist through pagination by appending query parameters to pagination links.

Get Started

Core Features

User Management

Command Center

Guides

Overview

Equipment Search

Text Search

Equipment Filters

Hierarchical Destination Search

Current Destination Filter

Historical Destination Filter

Date Range Filtering

Task Search

Task Name Filter

Task Status Filter

Task Date Filters

Task Assignment Filter

Audit Log Search

Combined Filters

Advanced Search Route

Search with Relationships

Build docs developers (and LLMs) love

Get Started

Core Features

User Management

Command Center

Guides

​Overview

​Equipment Search

​Text Search

​Equipment Filters

​Hierarchical Destination Search

​Current Destination Filter

​Historical Destination Filter

​Date Range Filtering

​Task Search

​Task Name Filter

​Task Status Filter

​Task Date Filters

​Task Assignment Filter

​Audit Log Search

​Combined Filters

​Advanced Search Route

​Search with Relationships

​Pagination

Build docs developers (and LLMs) love

Overview

Equipment Search

Text Search

Equipment Filters

Hierarchical Destination Search

Current Destination Filter

Historical Destination Filter

Date Range Filtering

Task Search

Task Name Filter

Task Status Filter

Task Date Filters

Task Assignment Filter

Audit Log Search

Combined Filters

Advanced Search Route

Search with Relationships

Pagination