@php
  $honor_collection = collect($honors);
  $header = $honor_collection->transform(function ($item, $key) {
              $collect = collect($item->detail);
              return $collect->pluck('nama_honor');
          })->flatten(1)->unique();
@endphp
<div class="row">
  <div class="col-12 text-center">
    <h4>
      REKAPITULASI HONOR DOSEN 
      @if ($request->input('perguruan_tinggi') == 'Semua')
        STIE {{{'&'}}} STMIK JAYAKARTA
      @else
        {{strtoupper($request->input('perguruan_tinggi'))}}
      @endif BULAN {{ strtoupper($request->input('bulan')) }} {{ $request->input('tahun') }}
    </h4>
  </div>
  <div class="col-12">
    <div class="table-responsive">
      <table class="table table-bordered table-hover">
        <thead>
          <tr>
            <th class="align-middle text-center" rowspan="2">No</th>
            <th class="align-middle text-center" rowspan="2">Nama Dosen</th>
            <th class="align-middle text-center" rowspan="2">Semester</th>
            <th class="align-middle text-center" rowspan="2">Tahun Akademik</th>
            <th class="align-middle text-center" rowspan="2">Jumlah SKS</th>
            <th class="text-center" colspan="9">Jadwal Mengajar</th>
            <th class="text-center" colspan="3">Honor Dosen</th>
            @foreach ($header as $element)
            <th class="text-center" rowspan="2">{{$element}}</th>
            @endforeach
            <th class="text-center" rowspan="2">Total Honor Dosen</th>
          </tr>
          <tr>
            <th class="align-middle text-center">Program Studi</th>
            <th class="align-middle text-center">Kode</th>
            <th class="align-middle text-center">Mata Kuliah</th>
            <th class="align-middle text-center">SKS</th>
            <th class="align-middle text-center">Hari</th>
            <th class="align-middle text-center">Jam</th>
            <th class="align-middle text-center">Ruangan</th>
            <th class="align-middle text-center">Jenis Kelas</th>
            <th class="align-middle text-center">Tgl Mengajar</th>
            {{-- <th class="align-middle text-center">Honor</th> --}}
            <th class="align-middle text-center">Satuan</th>
            <th class="align-middle text-center">Tatap Muka</th>
            <th class="align-middle text-center">Total</th>
          </tr>
        </thead>
        <tbody>
          @if (count($honors) > 0)
            @for ($i = 1; $i <= count($honors); $i++)
              @php
                $honor = $honors[$i-1];
                $count_honor = count($honor->detail);
                $collection = collect($honor->mata_kuliah);
                if ($collection) {
                  $count_honor_mengajar = $collection->sum(function ($gaji) {
                                              return count($gaji['detail']);
                                          });
                } else {
                  $count_honor_mengajar = 0;
                }
                $total_count_honor = $count_honor_mengajar;
                $span_head = $total_count_honor == 0 ? 1 : $total_count_honor;
              @endphp
              @php
                $show_header = true;
              @endphp
              @if ($count_honor + $total_count_honor > 0)
                @php
                  $x = 0;
                @endphp
                <tr>
                  <th class="align-middle text-center" rowspan="{{ $span_head}}">{{ $i }}</th>
                  <td class="align-middle" rowspan="{{ $span_head}}">{{ $honor->dosen->nama }}</td>
                  <td class="align-middle text-center" rowspan="{{ $span_head}}">{{ $honor->semester == 'Odd' ? 'Ganjil' : 'Genap' }}</td>
                  <td class="align-middle text-center" rowspan="{{ $span_head}}">{{ $honor->tahun_ajaran }}</td>
                  @if ($count_honor_mengajar > 0)
                    @php
                      $total_sks = 0;
                      foreach ($honor->mata_kuliah as $jadwal) {
                        if (count($jadwal->detail) > 0) {
                          foreach ($jadwal->detail as $honor_mengajar) {
                            $total_sks = $total_sks + $jadwal->jumlah_sks;
                          }
                        }
                      }
                    @endphp
                    <td class="align-middle text-center" rowspan="{{ $span_head}}">{{$total_sks}}</td>
                  @else
                    <td class="align-middle text-center" rowspan="{{ $span_head}}">0</td>
                  @endif
                  @if ($count_honor_mengajar > 0)
                    @foreach ($honor->mata_kuliah as $jadwal)
                      @if (count($jadwal->detail) > 0)
                        @php
                          $x++;
                        @endphp
                        @if ($x > 1)
                          <tr>
                        @endif
                        <td class="align-middle" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->program_studi }}</td>
                        <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->kode_mata_kuliah }}</td>
                        <td class="align-middle" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->nama_mata_kuliah }}</td>
                        <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->jumlah_sks }}</td>
                        <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->jadwal_hari }}</td>
                        <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->jadwal_jam }}</td>
                        <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->nomor_ruangan }}</td>
                        <td class="align-middle" rowspan="{{ count($jadwal->detail) }}">{{ $jadwal->jenis_kelas }}</td>
                        @foreach ($jadwal->detail as $honor_mengajar)
                          @if ($loop->first)
                              <td class="align-middle">{{ \Carbon\Carbon::parse($honor_mengajar->tgl_mengajar)->format('d/m/Y') }}</td>
                              {{-- <td class="align-middle">{{ $honor_mengajar->nama_honor }}</td> --}}
                              <td class="align-middle text-right" rowspan="{{ count($jadwal->detail) }}">{{ number_format($honor_mengajar->nominal, 0, ',', '.') }}</td>
                              <td class="align-middle text-center" rowspan="{{ count($jadwal->detail) }}">{{ count($jadwal->detail) }}</td>
                              @php
                                $total_honor_mengajar_permatkul = collect($jadwal->detail)->sum('total');
                              @endphp
                              <td class="align-middle text-right" rowspan="{{ count($jadwal->detail) }}"><strong>{{ number_format($total_honor_mengajar_permatkul, 0, ',', '.') }}</strong></td>
                              @if ($show_header)
                                @foreach ($header as $key => $element)
                                    @php
                                        $found = $honor->detail->where('nama_honor', $element)->first();
                                    @endphp
                                    @if ($found)
                                        <td class="align-middle text-right" rowspan="{{ $span_head }}"><strong>{{ number_format($found->total, 0, ',', '.') }}</strong></td>
                                    @else
                                        <td rowspan="{{ $span_head }}"></td>
                                    @endif
                                @endforeach
                                <td class="align-middle text-right" rowspan="{{$span_head}}"><strong>{{ number_format($honor->total_honor_mengajar + $honor->total_honor, 0, ',', '.') }}</strong></td>
                                @php
                                  $show_header = false;
                                @endphp
                              @endif
                            </tr>
                          @else
                            <tr>
                              <td class="align-middle">{{ \Carbon\Carbon::parse($honor_mengajar->tgl_mengajar)->format('d/m/Y') }}</td>
                              {{-- <td class="align-middle">{{ $honor_mengajar->nama_honor }}</td> --}}
                              {{-- <td class="align-middle text-right">{{ number_format($honor_mengajar->nominal, 0, ',', '.') }}</td>
                              <td class="align-middle text-center">{{ $honor_mengajar->jumlah }}</td>
                              <td class="align-middle text-right"><strong>{{ number_format($honor_mengajar->total, 0, ',', '.') }}</strong></td> --}}
                            </tr>
                          @endif
                        @endforeach
                      @endif
                    @endforeach
                  @else
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        @if ($show_header)
                          @foreach ($header as $key => $element)
                              @php
                                  $found = $honor->detail->where('nama_honor', $element)->first();
                              @endphp
                              @if ($found)
                                  <td class="align-middle text-right" rowspan="{{$span_head}}"><strong>{{ number_format($found->total, 0, ',', '.') }}</strong></td>
                              @else
                                  <td></td>
                              @endif
                          @endforeach
                          <td class="align-middle text-right" rowspan="{{$span_head}}"><strong>{{ number_format($honor->total_honor_mengajar + $honor->total_honor - $honor->pajak_21, 0, ',', '.') }}</strong></td>
                          @php
                            $show_header = false;
                          @endphp
                        @endif
                    </tr>
                  @endif
                {{-- <tr>
                  <td class="align-middle text-right" colspan="8"><h5>Total Honor Dosen {{ $honor->status }}</h5></td>
                  <td class="align-middle text-right" colspan="5"><h5>{{ number_format($honor->total_honor_mengajar + $honor->total_honor, 0, ',', '.') }}</h5></td>
                </tr> --}}
              @endif
            @endfor
          @else
            <td class="text-center" colspan="{{18 + count($header)}}">
              Tidak ada data ditemukan
            </td>
          @endif
        </tbody>
      </table>
    </div>
  </div>
</div>

<style type="text/css">
  table th,td {
    white-space: nowrap !important;
  }
</style>