@extends('layouts.main', [
    'title' => 'Laporan Pendapatan Bulanan',
])

@push('scripts')
<script>
    function openCetakPreview(){
        //get current url
        const url = window.location.href;
        const base64url = btoa(url.replace("/pendapatan-bulanan","/pendapatan-bulanan/pdf"));
        let newUrl = "{{url('cetak-preview')}}?url="+base64url;
        //open new tab

        window.open(newUrl, '_blank');
    }
</script>
@endpush

@section('content')
    <section class="section main-section">
        <div class="card mb-4">
            <div class="card-content">
                <form action="">
                    <div class="field">
                        <label class="label">Periode</label>
                        <div class="field-body">
                            <div class="flex gap-2 flex-col md:flex-row items-center">
                                <div class=" w-full">
                                    <div class="control">
                                        <input class="input" id="periode_awal" name="periode_awal" type="date"
                                            placeholder="Periode Awal" value="{{ old('periode_awal', @$periode_awal) }}">

                                    </div>
                                    @error('periode_awal')
                                        <p class="help is-danger text-red-500">{{ $message }}</p>
                                    @enderror
                                </div>
                                <div>
                                    S/D
                                </div>
                                <div class=" w-full">
                                    <div class="control">
                                        <input class="input" id="periode_akhir" name="periode_akhir" type="date"
                                            placeholder="Periode Akhir" value="{{ old('periode_akhir', @$periode_akhir) }}">

                                    </div>
                                    @error('periode_akhir')
                                        <p class="help is-danger text-red-500">{{ $message }}</p>
                                    @enderror
                                </div>
                            </div>
                        </div>
                    </div>
                  

                  
                    <div class="flex gap-2">
                        <div class="control">
                            <button type="submit" class="button green">
                                Filter
                            </button>
                        </div>
                        <div class="control">
                            <button type="button" onclick="openCetakPreview()" class="button blue">
                                Cetak
                            </button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
        <div class="card  mb-6">
            <header class="card-header">
                <p class="card-header-title">
                    <span class="icon"><i class="mdi mdi-account-multiple"></i></span>
                    Laporan Pendapatan Bulanan
                </p>

            </header>
            <div class="card-content table-responsive">
                <table class="mb-4">
                    <thead>
                        <tr>
                            <th rowspan="2">
                                Bulan
                            </th>
                            <th rowspan="2">
                                Jumlah
                            </th>
                            <th colspan="{{ count($jenis) }}" class="text-center">
                                Tunai
                            </th>
                            <th colspan="{{ count($jenis) }}" class="text-center">
                                Transfer
                            </th>
                            <th rowspan="2">
                                Total
                            </th>

                        </tr>
                        <tr>
                            @foreach ($jenis as $item)
                                <th>
                                    {{ $item->nama_jenis_pembayaran }}
                                </th>
                            @endforeach
                            @foreach ($jenis as $item)
                                <th>
                                    {{ $item->nama_jenis_pembayaran }}
                                </th>
                            @endforeach
                          
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $totalTunai = 0;
                            $totalTransfer = 0;
                        @endphp
                        @foreach ($pendapatans as $item)
                            @php
                                $total = 0;
                            @endphp
                          
                            <tr>
                                <td>
                                    {{Helper::bulanIndo($item->bulan)}} / {{$item->tahun}}
                                </td>
                                <td>
                                    {{$item->jumlah_pembayaran}} x pembayaran
                                </td>
                                @foreach ($jenis as $itemJenis)
                                    @php
                                        $tunai = $detailTunais->where('bulan',$item->bulan)->where('jenis_pembayaran_id',$itemJenis->id)->sum('nominal_pembayaran');
                                        $totalTunai += $tunai;
                                        $total += $tunai;
                                    @endphp
                                    <td>
                                        {{ number_format($tunai) }}
                                    </td>
                                @endforeach
                                @foreach ($jenis as $itemJenis)
                                    @php
                                        $transfer = $detailTransfers->where('bulan',$item->bulan)->where('jenis_pembayaran_id',$itemJenis->id)->sum('nominal_pembayaran');
                                        $totalTransfer += $transfer;
                                        $total += $transfer;
                                    @endphp
                                    <td>
                                        {{ number_format($transfer) }}
                                    </td>
                                @endforeach
                                <td>
                                    {{ number_format($total) }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="2">
                                Total
                            </th>
                            @foreach ($jenis as $itemJenis)
                                <th>
                                    {{ number_format($detailTunais->where('jenis_pembayaran_id',$itemJenis->id)->sum('nominal_pembayaran')) }}
                                </th>
                            @endforeach
                            @foreach ($jenis as $itemJenis)
                                <th>
                                    {{ number_format($detailTransfers->where('jenis_pembayaran_id',$itemJenis->id)->sum('nominal_pembayaran')) }}
                                </th>
                            @endforeach
                            <th>
                                {{ number_format($totalTunai+$totalTransfer) }}
                            </th>
                        </tr>
                    </tfoot>
                   
                </table>

                <button type="button" onclick="openCetakPreview()" class="button blue">
                    Cetak
                </button>
            </div>
            
        </div>
    </section>
@endsection