@extends('layouts.app')
@section('title', 'Laporan Arus Kas')
@section('page_title', 'Laporan Arus Kas')

@section('content')
<section class="bg-white text-sm">
    
    
    <div class="flex flex-col md:flex-row md:justify-between md:items-center mb-2 pt-6">
        <div class="w-full md:w-auto space-x-4 mb-4 md:mb-0">
            {{-- Form filter periode --}}
            <form action="{{ route('laporan.arus-kas') }}" method="GET" class="flex flex-col md:flex-row items-end space-y-4 md:space-y-0 md:space-x-4">
                <div>
                    <label for="periode_id" class="block text-gray-700 font-bold mb-2">Periode Akuntansi</label>
                    <select  name="periode_id" id="periode_id" class="form-select  shadow-sm w-full md:w-auto">
                        @foreach ($periodes as $periode)
                            <option value="{{ $periode->id }}" {{ $periode->id == $periodeDipilih->id ? 'selected' : '' }}>
                                {{ \Carbon\Carbon::parse($periode->tanggal_mulai)->format('d M Y') }} s/d {{ \Carbon\Carbon::parse($periode->tanggal_selesai)->format('d M Y') }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <button type="submit" class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-2 px-4 ">
                    Tampilkan
                </button>
            </form>
        </div>

        <div class="w-full md:w-auto flex flex-col md:flex-row items-end space-y-4 md:space-y-0 md:space-x-4">
            {{-- Tombol PDF dan Excel --}}
            <a href="{{ route('laporan.arus-kas.pdf', ['periode_id' => $periodeDipilih->id]) }}" class="w-full md:w-auto bg-red-500 hover:bg-red-700 text-white font-bold py-2 px-4  text-center">
                Cetak PDF
            </a>
            <a href="{{ route('laporan.arus-kas.excel', ['periode_id' => $periodeDipilih->id]) }}" class="w-full md:w-auto bg-green-500 hover:bg-green-700 text-white font-bold py-2 px-4  text-center">
                Export Excel
            </a>
        </div>
    </div>

    

    <div class="bg-white  pt-6">
        <h2 class="text-xl font-bold mb-4">Laporan Arus Kas</h2>
        <div class="mb-4">
            <p><strong>Periode:</strong> {{ \Carbon\Carbon::parse($periodeDipilih->tanggal_mulai)->format('d M Y') }} s/d {{ \Carbon\Carbon::parse($periodeDipilih->tanggal_selesai)->format('d M Y') }}</p>
            <p><strong>Saldo Awal:</strong> Rp {{ number_format($saldo_awal, 2) }}</p>
        </div>

        @php
            $saldo_saat_ini = $saldo_awal;
        @endphp

        <div class="overflow-x-auto">
            <table class="min-w-full leading-normal">
                <thead class="bg-blue-700 text-white">
                    <tr>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            NO
                        </th>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            Tanggal
                        </th>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            Keterangan
                        </th>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            Masuk
                        </th>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            Keluar
                        </th>
                        <th class="px-5 py-3  text-left text-xs font-semibold uppercase tracking-wider">
                            Saldo
                        </th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($laporan_harian as $tanggal => $transaksis)
                        @foreach ($transaksis as $transaksi)
                            @php
                                if ($transaksi->jenis_transaksi == 'masuk') {
                                    $saldo_saat_ini += $transaksi->nominal;
                                } else {
                                    $saldo_saat_ini -= $transaksi->nominal;
                                }
                            @endphp
                            <tr>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    {{ $loop->iteration }}
                                </td>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    {{ \Carbon\Carbon::parse($transaksi->tanggal_transaksi)->format('d M Y') }}
                                </td>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    {{ $transaksi->keterangan }}
                                </td>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    @if ($transaksi->jenis_transaksi == 'masuk')
                                        Rp {{ number_format($transaksi->nominal, 2) }}
                                    @else
                                        -
                                    @endif
                                </td>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    @if ($transaksi->jenis_transaksi == 'keluar')
                                        Rp {{ number_format($transaksi->nominal, 2) }}
                                    @else
                                        -
                                    @endif
                                </td>
                                <td class="px-5 py-2 border-b border-gray-200 bg-white text-sm">
                                    Rp {{ number_format($saldo_saat_ini, 2) }}
                                </td>
                            </tr>
                        @endforeach
                    @endforeach
                </tbody>
            </table>
        </div>
        <div class="mt-4 text-right">
            <p class="text-sm font-bold">Saldo Akhir: Rp {{ number_format($saldo_saat_ini, 2) }}</p>
        </div>
    </div>
</section>
@endsection