@extends('admin.layouts.app')

@section('title', 'Cash Flow Statement')

@section('content')
<div class="mb-6 flex justify-between items-center">
    <div>
        <h1 class="text-2xl font-bold text-gray-800">Cash Flow Statement</h1>
        <p class="text-gray-500 text-sm mt-1">{{ Carbon\Carbon::create($year, $month, 1)->format('F Y') }}</p>
    </div>
    <form method="GET" class="flex items-center space-x-2">
        <select name="year" class="border rounded-lg px-3 py-2" onchange="this.form.submit()">
            @for($y = now()->year; $y >= now()->year - 5; $y--)
            <option value="{{ $y }}" {{ $y == $year ? 'selected' : '' }}>{{ $y }}</option>
            @endfor
        </select>
        <select name="month" class="border rounded-lg px-3 py-2" onchange="this.form.submit()">
            @for($m = 1; $m <= 12; $m++)
            <option value="{{ $m }}" {{ $m == $month ? 'selected' : '' }}>{{ Carbon\Carbon::create($year, $m, 1)->format('F') }}</option>
            @endfor
        </select>
    </form>
</div>

<div class="grid grid-cols-1 lg:grid-cols-3 gap-6 mb-6">
    <div class="bg-white rounded-lg shadow p-6">
        <p class="text-gray-500 text-sm">Total Cash In</p>
        <p class="text-2xl font-bold text-green-600">₦{{ number_format($totalCashIn, 0) }}</p>
    </div>
    <div class="bg-white rounded-lg shadow p-6">
        <p class="text-gray-500 text-sm">Total Cash Out</p>
        <p class="text-2xl font-bold text-red-600">₦{{ number_format($totalCashOut, 0) }}</p>
    </div>
    <div class="bg-white rounded-lg shadow p-6">
        <p class="text-gray-500 text-sm">Net Cash Flow</p>
        <p class="text-2xl font-bold {{ $netCashFlow >= 0 ? 'text-green-600' : 'text-red-600' }}">₦{{ number_format($netCashFlow, 0) }}</p>
    </div>
</div>

<div class="grid grid-cols-1 lg:grid-cols-2 gap-6">
    <div class="bg-white rounded-lg shadow p-6">
        <h3 class="text-lg font-bold text-gray-800 mb-4">Cash Inflows</h3>
        <table class="w-full">
            <tbody class="divide-y">
                <tr>
                    <td class="px-4 py-3">Room Revenue</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($roomRevenue, 0) }}</td>
                </tr>
                <tr>
                    <td class="px-4 py-3">POS Revenue</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($posRevenue, 0) }}</td>
                </tr>
                <tr>
                    <td class="px-4 py-3">Folio Payments</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($folioPayments, 0) }}</td>
                </tr>
                <tr>
                    <td class="px-4 py-3">Invoice Payments</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($invoicePayments, 0) }}</td>
                </tr>
                <tr class="bg-green-50">
                    <td class="px-4 py-3 font-bold">Total Cash In</td>
                    <td class="px-4 py-3 text-right font-bold text-green-600">₦{{ number_format($totalCashIn, 0) }}</td>
                </tr>
            </tbody>
        </table>
    </div>

    <div class="bg-white rounded-lg shadow p-6">
        <h3 class="text-lg font-bold text-gray-800 mb-4">Cash Outflows</h3>
        <table class="w-full">
            <tbody class="divide-y">
                <tr>
                    <td class="px-4 py-3">Approved Expenses</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($expenses, 0) }}</td>
                </tr>
                <tr>
                    <td class="px-4 py-3">Petty Cash Disbursements</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($pettyCashOut, 0) }}</td>
                </tr>
                <tr>
                    <td class="px-4 py-3">Accounts Payable Payments</td>
                    <td class="px-4 py-3 text-right font-medium">₦{{ number_format($apPayments, 0) }}</td>
                </tr>
                <tr class="bg-red-50">
                    <td class="px-4 py-3 font-bold">Total Cash Out</td>
                    <td class="px-4 py-3 text-right font-bold text-red-600">₦{{ number_format($totalCashOut, 0) }}</td>
                </tr>
            </tbody>
        </table>
    </div>
</div>

<div class="bg-white rounded-lg shadow p-6 mt-6">
    <h3 class="text-lg font-bold text-gray-800 mb-4">Yearly Cash Flow</h3>
    <div class="overflow-x-auto">
        <table class="w-full">
            <thead class="bg-gray-50">
                <tr>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500 uppercase">Month</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500 uppercase">Cash In</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500 uppercase">Cash Out</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500 uppercase">Net Flow</th>
                </tr>
            </thead>
            <tbody class="divide-y">
                @foreach($monthlyFlow as $data)
                <tr>
                    <td class="px-4 py-3">{{ $data['month'] }}</td>
                    <td class="px-4 py-3 text-right">₦{{ number_format($data['cash_in'], 0) }}</td>
                    <td class="px-4 py-3 text-right">₦{{ number_format($data['cash_out'], 0) }}</td>
                    <td class="px-4 py-3 text-right font-medium {{ $data['net'] >= 0 ? 'text-green-600' : 'text-red-600' }}">
                        ₦{{ number_format($data['net'], 0) }}
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection