@extends('layouts.master')
@push('css')
    <link href="{{ asset('assets/libs/sweetalert2/sweetalert2.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ asset('assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css') }}" rel="stylesheet">
@endpush
@section('content')
    <div class="row">
        <div class="card">
            <div class="card-body">
                {!! Form::open(['url' => url()->current(), 'method' => 'GET']) !!}
                <div class="row">

                    <div class="col-md-3">
                        <div class="mb-3">
                            <label>Cari</label>
                            {!! Form::text('cari', Request::get('cari'), ['class' => 'form-control', 'placeholder' => 'Cari...']) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <label for="divisi_id">Departemen</label>
                        <select name="divisi_id" id="divisi_id" class="form-control">
                            <option value="">Semua Departemen</option>
                            @foreach ($divisis as $item)
                                <option value="{{ $item->id }}"
                                    {{ Request::get('divisi_id') == $item->id ? 'selected' : '' }}>
                                    {{ $item->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label for="perusahaan_id">Perusahaan</label>
                        <select name="perusahaan_id" id="perusahaan_id" class="form-control">
                            <option value="">Semua Perusahaan</option>
                            @foreach ($perusahaans as $item)
                                <option value="{{ $item->id }}"
                                    {{ Request::get('perusahaan_id') == $item->id ? 'selected' : '' }}>
                                    {{ $item->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label>Dari tanggal</label>
                            {!! Form::date('dari_tanggal', Request::get('dari_tanggal'), [
                                'class' => 'form-control',
                                'data-provide' => 'datepicker',
                                'data-date-format' => 'yyyy-mm-dd',
                                'data-date-autoclose' => 'true',
                                'placeholder' => 'yyyy-mm-dd',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label>Sampai tanggal</label>
                            {!! Form::date('sampai_tanggal', Request::get('sampai_tanggal'), [
                                'class' => 'form-control',
                                'data-date-autoclose' => 'true',
                                'placeholder' => 'yyyy-mm-dd',
                                'data-date-format' => 'yyyy-mm-dd',
                                'data-provide' => 'datepicker',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-2">
                        <label for="jumlah_baris">Jumlah Baris</label>
                        <select name="jumlah_baris" id="jumlah_baris" class="form-control">
                            <option value="10">10</option>
                            <option value="20">20</option>
                            <option value="50">50</option>
                            <option value="100">100</option>
                            <option value="0">Semua Baris</option>
                        </select>
                    </div>
                    <div class="col-md-2">
                        <div class="mb-3">
                            <label style="color:transparent;">.</label>
                            <div>
                                <input type="submit" name="Cetak" class="btn btn-warning" value="Cetak">
                                <button class="btn btn-primary" value="wait_proses"><i class="fa fa-search"></i>
                                    Cari</button>
                            </div>
                        </div>
                    </div>


                </div>
                {!! Form::close() !!}

                @if (Session::has('message'))
                    <div class="alert alert-{{ Session::get('message.type') }}">{!! Session::get('message.text') !!}</div>
                @endif
                <div class="row">
                    <div class="col-md-12 table-responsive">
                        <table class="table table-bordered table-hover">
                            <thead>
                                {{-- <tr>
                                    <th>No</th>
                                    <th>Perihal</th>
                                    <th>Jumlah</th>
                                    <th>User</th>
                                    <th>Budgeting</th>
                                    <th>Penggunaan Data</th>
                                    <th>BANK</th>
                                    <th>No Rekening</th>
                                </tr> --}}
                                <tr>
                                    <th>No</th>
                                    <th>NO SPD</th>
                                    <th>Deskripsi</th>
                                    <th>Jumlah - PPh</th>
                                    <th>PPh</th>

                                    <th>Sisa Bayar</th>
                                    <th style="min-width: 200px;">Tanggal Pembayaran</th>
                                    <th>Departemen</th>
                                    <th>Kode Budgeting</th>
                                    <th>Bank</th>
                                    <th>No Rekening</th>
                                    <th>Nama Rekening</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $total = 0;
                                    $totalPph = 0;
                                @endphp

                                @foreach ($query as $permintaan)
                                    @php
                                        $total += $permintaan->groupItem[0]->total_bayaran;
                                        $totalPph += $permintaan->groupItem[0]->nominal_pph;
                                        $sisaBayar = $permintaan->total_sisa;
                                    @endphp
                                    <tr @if ($sisaBayar > 0) class="bg-warning" @endif>
                                        @if ($jumlah_baris != 0)
                                            <td>{{ $loop->iteration + $query->firstItem() - 1 }}</td>
                                        @else
                                            <td>{{ $loop->iteration }}</td>
                                        @endif

                                        <td>{{ $permintaan->tmp_nomor_surat }}</td>
                                        <td>{{ $permintaan->groupItem[0]->item[0]->label }}</td>
                                        <td>{{ number_format($permintaan->groupItem->sum('total_bayaran') + (@$permintaan->groupItem->sum('total_biaya_lainnya') ?? 0)) }}
                                        </td>
                                        <td>{{ number_format($permintaan->groupItem[0]->nominal_pph) }}</td>
                                        <td>{{ number_format($sisaBayar) }}</td>
                                        <td>
                                            <ul>
                                                @foreach ($permintaan->pembayarans as $pembayaran)
                                                    <li>{{ date('d-m-Y', strtotime($pembayaran->tanggal_pembayaran)) }} <a
                                                            rel="stylesheet"
                                                            href="{{ asset('storage-file/' . $pembayaran->bukti_pembayaran) }}"
                                                            target="_blank" class="btn btn-success btn-sm m-1"
                                                            title="Bukti Pembayaran"><i class="fa fa-image"></i></a></li>
                                                @endforeach
                                            </ul>
                                        </td>
                                        <td>{{ $permintaan->divisi->name }}</td>
                                        <td>{{ $permintaan->groupItem[0]->item[0]->budget->kode_budget }}</td>
                                        <td>{{ $permintaan->groupItem[0]->item[0]->bank->nama_bank }}</td>
                                        <td>{{ $permintaan->groupItem[0]->item[0]->rek_tujuan }}</td>
                                        <td>{{ $permintaan->groupItem[0]->item[0]->nama_rek }}</td>
                                    </tr>
                                    {{-- <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $permintaan->perihal }}</td>
                                        <td>{{ number_format($permintaan->total) }}</td>
                                        @php
                                            $total += $permintaan->total;
                                        @endphp
                                        <td>{{ $permintaan->peminta->name }}</td>
                                        <td></td>
                                        <td>{{ $permintaan->selesai }}</td>
                                        <td colspan="2"></td>
        
        
                                    </tr>
        
                                    @foreach ($permintaan->groupItem as $group)
                                        @foreach ($group->item as $item)
                                            <tr>
                                                <td colspan="2">
        
                                                </td>
        
        
                                                <td>
                                                    {{ number_format($item->nominal) }}
                                                </td>
                                                <td>
        
                                                </td>
                                                <td>
                                                    {{ $item->budget->kode_budget }}
                                                </td>
                                                <td>
                                                    {{ $item->keterangan }}
                                                </td>
                                                <td>
                                                    {{ $item->bank->nama_bank }}
                                                </td>
                                                <td>
                                                    {{ $item->rek_tujuan }}
                                                </td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="3"></td>
                                            <td colspan="2">
                                                PPN : <b>{{ $group->nominal_ppn }}</b>
                                            </td>
                                            <td colspan="3">
                                                PPH : <b>{{ $group->nominal_pph }}</b>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td colspan="8">
                                                <hr>
                                            </td>
                                        </tr>
                                    @endforeach --}}
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="3">
                                        TOTAL :
                                    </th>
                                    <th>
                                        {{ number_format($total) }}
                                    </th>
                                    <th>
                                        {{ number_format($totalPph) }}
                                    </th>
                                    <th colspan="7"></th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
                <div align="right">
                    @if ($jumlah_baris != 0)
                        {!! $query->links() !!}
                    @endif
                </div>
            </div>
        </div>
    </div>
@endsection