Gráficas

Estadísticas de Contenedores

Total {{ $selectedYear }}

{{ $totalContenedores }}

Promedio Mensual

{{ $promedioMensual }}

Año Seleccionado

{{ $selectedYear }}

Resumen {{ $selectedYear }}

Total contenedores: {{ $totalContenedores }}
Promedio mensual: {{ $promedioMensual }}
Meses con datos: {{ \App\Models\DetalleContenedor::whereYear('worked_at', $selectedYear) ->selectRaw('MONTH(worked_at) as month') ->groupBy(\DB::raw('MONTH(worked_at)')) ->count() }}/12

Años Disponibles

@php $years = \App\Models\DetalleContenedor::query() ->whereNotNull('worked_at') ->selectRaw('YEAR(worked_at) as year') ->groupBy('year') ->orderBy('year', 'desc') ->pluck('year'); @endphp @foreach($years as $year)
Año {{ $year }} {{ \App\Models\DetalleContenedor::whereYear('worked_at', $year)->count() }}
@endforeach