@extends('layouts.app')
@section('content')
<!--begin::Content-->

<div class="modal fade" tabindex="-1" id="show">
  <div class="modal-dialog modal-xl" id="show-app">
  </div>
</div>

<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
  <!--begin::Post-->
  <div class="post d-flex flex-column-fluid" id="kt_post">
    <!--begin::Container-->
    <div id="kt_content_container" class="container-xxl">
      <!--begin::Row-->
      <div class="row g-5 g-xl-8">
        <div class="col-xl-12">
          <!--begin::List Widget 3-->
          <div class="card card-xl-stretch mb-xl-8">
            <!--begin::Header-->
            <div class="card-header py-5">
              <h3 class="card-title align-items-start flex-column">
                <span class="card-label fw-bolder fs-3 mb-1">Pelaporan Monev Eksekusi</span>
                <span class="text-muted mt-1 fw-bold fs-7">Monitoring Pelaksanaan Bulanan</span>
              </h3>
            </div>
            <!--end::Header-->

            <div class="card-header border-0 py-5">
              <form autocomplete="off">
                <div class="d-md-flex justify-content-md-start" data-kt-customer-table-toolbar="base">
                  <div class="me-md-3">
                    <label class="col-form-label">Pilih : </label>
                  </div>
                  <div class="me-md-3 mb-3 mb-md-0">
                    <select class="form-select" name="pilihbulan">
                      @php
                      $bulan =
                      ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember','Semua Bulan']
                      @endphp
                      @for ($i = 1; $i <= 13; $i++) <option value="{{$i < 10 ? '0'.$i:$i}}" @if ($bulanaktif==$i ) @php
                        $bulanaktif_nama=$bulan[$i-1]; @endphp selected @endif>
                        {{$bulan[$i-1]}}</option>
                        @endfor
                    </select>
                  </div>
                  <div class="me-md-3 mb-3 mb-md-0">
                    <select class="form-select" name="pilihtahun">
                      @for ($i = $tahunpertama; $i <= $tahunterakhir; $i++) <option value="{{$i}}" {{$tahun==$i
                        ? 'selected' :''}}>{{$i}}</option>
                        @endfor
                    </select>
                  </div>
                  <div class="d-flex me-md-3 mb-3 mb-md-0">
                    <button type="submit" class="btn btn-primary fw-bolder me-2"><i class="fas fa-search"></i>Lihat
                      Data</button>
                  </div>
                </div>
              </form>
            </div>
            @php
              if($bulanaktif < 13)
              {
                $bulan_nama = \Carbon\Carbon::createFromFormat('!m',$bulanaktif)->isoFormat('MMMM');
              } else {
                $bulan_nama = 'Semua';
              }
            @endphp
            <!--begin::Body-->
            <div class="card-body">
              <div
                class="alert bg-light-info border border-info border border-dashed d-flex flex-column flex-sm-row w-100 p-5 mb-10">
                <!--begin::Content-->
                <div class="d-flex">
                  <div class="d-flex flex-column pe-0 pe-sm-10">
                    <span class="text-muted fs-7 fw-bold">Bulan</span>
                    <h5 class="mb-1">{{$bulan_nama}}</h5>
                  </div>
                  <div class="d-flex flex-column pe-0 pe-sm-10">
                    <span class="text-muted fs-7 fw-bold">Periode</span>
                    <h5 class="mb-1">{{$tahun}}</h5>
                  </div>
                </div>
                <!--end::Content-->
              </div>
              <div class="table-responsive">
                <table class="table table-row-dashed table-row-gray-300 gy-2 gs-7">
                  <thead>
                    <tr class="fw-bolder text-gray-800 border-bottom border-gray-200 bg-light">
                      <th class="min-w-300px w-300px">Tanggal</th>
                      <th class="min-w-50px w-50px text-center">Jumlah</th>
                      <th class="min-w-50px w-50px text-center">Aanmaning</th>
                      <th class="min-w-50px w-50px text-center">Belum</th>
                      <th class="min-w-50px w-50px text-center">Sudah</th>
                      <th class="min-w-50px w-50px text-center">Dibuat</th>
                      <th class="min-w-50px w-50px text-center">Disahkan</th>
                      <th class="min-w-50px w-50px text-center">Diketahui</th>
                      <th>Berkas</th>
                    </tr>
                  </thead>
                  <tbody id="table_body">
                    @if($bulanaktif < 13)

                      <tr class="py-5 fw-bolder">
                          <td colspan="5" class="pt-5 pb-2">{{$bulan_nama}} {{$tahun}}</td>
                      </tr>

                      @foreach($satker as $sat)
                        <tr>
                          @php
                              $row_laporan = \App\Models\Pme\Pn\Laporan::where('bulan',$bulanaktif)->where('tahun',$tahun)->where('satker_id', $sat->id)->where('status_data', 'AKTIF')->first();
                          @endphp

                          <td class="fs-7 ps-16">{{$sat->nama}}</td>
                          @if($row_laporan)
                              <td class="fs-7 text-center">
                                  {{$row_laporan->jumlah}}
                              </td>
                              <td class="fs-7 text-center">
                                  {{$row_laporan->aanmaning}}
                              </td>
                              <td class="fs-7 text-center">
                                  {{$row_laporan->belum}}
                              </td>
                              <td class="fs-7 text-center">
                                  {{$row_laporan->sudah}}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->dibuat_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i><br>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->dibuat_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->disahkan_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->disahkan_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->diketahui_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->diketahui_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td>
                                  <button type="button" class="btn btn-sm btn-info btnshow py-0"
                                      data-id="{{$row_laporan->id}}">Berkas</button>
                              </td>
                          @else
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7">-</td>
                          @endif
                        </tr>
                      @endforeach
                    @else
                      @php
                      $list_bulan = ['01','02','03','04','05','06','07','08','09','10','11','12'];
                      @endphp

                      @foreach ($list_bulan as $bulan)
                    
                      @php
                        $bulan_nama_detail = \Carbon\Carbon::createFromFormat('!m',$bulan)->isoFormat('MMMM');
                    @endphp

                        <tr class="py-5 fw-bolder">
                          <td colspan="5" class="pt-5 pb-2">{{$bulan_nama_detail}} {{$tahun}}</td>
                        </tr>
                  
                        @foreach($satker as $sat)
                          <tr>

                          @php
                              $row_laporan = \App\Models\Pme\Pn\Laporan::where('bulan',$bulan)->where('tahun',$tahun)->where('satker_id', $sat->id)->where('status_data', 'AKTIF')->first();
                          @endphp
                          <td class="fs-7 ps-16">{{$sat->nama}}</td>
                          @if($row_laporan)
                              <td class="fs-7 text-center">
                                  {{$row_laporan->jumlah}}
                              </td>
                              <td class="fs-7 text-center">
                                  {{$row_laporan->aanmaning}}
                              </td>
                              <td class="fs-7 text-center">
                                  {{$row_laporan->belum}}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->dibuat_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i><br>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->dibuat_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->disahkan_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->disahkan_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td class="fs-7 text-center">
                                  {!! $row_laporan->diketahui_validasi == 'SUDAH' ? '<i class="fas fa-check text-success"></i>'.\Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $row_laporan->diketahui_tanggal)->format('d/m/Y') : '<i class="fas fa-times text-danger"></i>'!!}
                              </td>
                              <td>
                                  <button type="button" class="btn btn-sm btn-info btnshow py-0"
                                      data-id="{{$row_laporan->id}}">Berkas</button>
                              </td>
                          @else
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7 text-center">-</td>
                              <td class="fs-7">-</td>
                          @endif
                     
                      </tr>
                      @endforeach
                    @endforeach
                  @endif
                  </tbody>
                </table>
              </div>
            </div>
            <!--end::Body-->
          </div>
          <!--end:List Widget 3-->
        </div>
      </div>
      <!--end::Row-->
    </div>
    <!--end::Container-->
  </div>
  <!--end::Post-->
</div>
<!--end::Content-->
@endsection


@section('js')

<script>
    function show(url, dataid){
        axios.get(url, {
            params: {
                'data_id': dataid,
            }
        }).then(function (response){
            $('#show-app').html(response.data);
            $("#show").modal('show');
        });
    };

    $('#show').on('hidden.bs.modal', function () {
        $('#show-app').empty();
    });

    $(document).ready(function(){

        $('#table_body').on('click','.btnshow',function(e){
          btn = $(this);
          show('{{ route("pme.pt.monitoring.show") }}', btn.data('id'));
        });
    });


</script>

@stop