@extends('dashboard.layouts.main')

@section('container')
    <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
      <h1 class="h2">Rekap Sampah Tidak Terkelola per Bank - Tahun {{ $tahun }}</h1>
      
      <form method="GET" action="{{ route('rekap_sampah_tidak_terkelola.rekap') }}">
          <div class="input-group">
              <label class="input-group-text" for="tahun">Tahun</label>
              <select class="form-select" name="tahun" id="tahun" onchange="this.form.submit()">
                  @foreach($list_tahun as $t)
                      <option value="{{ $t }}" {{ $t == $tahun ? 'selected' : '' }}>{{ $t }}</option>
                  @endforeach
              </select>
          </div>
      </form>
    </div>

    @if(session()->has('success'))
        <div class="alert alert-success col-lg-6" role="alert">
            {{ session('success') }}
        </div>
    @endif

    <div class="table-responsive col-lg-12">
        <table class="table table-bordered table-striped">
            <thead class="text-center">
                <tr>
                    <th scope="col" class="text-center">No.</th>
                    <th scope="col">Nama Bank</th>
                    <th scope="col">Januari</th>
                    <th scope="col">Februari</th>
                    <th scope="col">Maret</th>
                    <th scope="col">April</th>
                    <th scope="col">Mei</th>
                    <th scope="col">Juni</th>
                    <th scope="col">Juli</th>
                    <th scope="col">Agustus</th>
                    <th scope="col">September</th>
                    <th scope="col">Oktober</th>
                    <th scope="col">November</th>
                    <th scope="col">Desember</th>
                    <th scope="col">Total</th>
                    <th scope="col" class="text-center">Aksi</th>
                </tr>
            </thead>
            <tbody>
                @foreach($banks as $bank)
                    @php
                        $bulan = ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'];
                        $total = 0;
                    @endphp
                    <tr>
                        <td class="text-center">{{ $loop->iteration + ($banks->currentPage() - 1) * $banks->perPage() }}</td>
                        <td>{{ $bank->nama_banks }}</td>

                        @foreach($bulan as $b)
                            @php
                                $masuk = $bank->sampah_masuk->where('bulan', $b)->sum('jml_masuk');
                                $terkelola = $bank->sampah_terkelola->where('bulan', $b)->sum('jml_terkelola');
                                $tidak_terkelola = $masuk - $terkelola;
                                $total += $tidak_terkelola;
                            @endphp
                            <td class="text-end">{{ number_format($tidak_terkelola, 0, ',', '.') }} kg</td>
                        @endforeach

                        <td class="text-end fw-bold">{{ number_format($total, 0, ',', '.') }} kg</td>
                      
                        <td class="text-center">
                            <a href="{{ route('rekap_sampah_tidak_terkelola.detail', ['tahun' => $tahun, 'bank_id' => $bank->id]) }}" class="btn btn-sm btn-success">Detail</a>
                        </td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    <div class="mt-3">
        {{ $banks->links() }}
    </div>
@endsection