@extends('layouts.app')

@section('content')
<div class="container">
    <div class="row">
        <div class="col-md-12">
            <div class="d-flex justify-content-between align-items-center mb-4">
                <h2>Petty Cash Reports</h2>
                <a href="{{ route('petty-cash.index') }}" class="btn btn-secondary">Back to Funds</a>
            </div>

            <!-- Filters -->
            <div class="card mb-4">
                <div class="card-header">
                    <h5>Report Filters</h5>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('petty-cash.report') }}">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="fund_id">Fund</label>
                                    <select class="form-control" id="fund_id" name="fund_id">
                                        <option value="">All Funds</option>
                                        @foreach($funds as $fund)
                                            <option value="{{ $fund->id }}" {{ request('fund_id') == $fund->id ? 'selected' : '' }}>
                                                {{ $fund->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group">
                                    <label for="type">Type</label>
                                    <select class="form-control" id="type" name="type">
                                        <option value="">All Types</option>
                                        <option value="expense" {{ request('type') == 'expense' ? 'selected' : '' }}>Expense</option>
                                        <option value="replenishment" {{ request('type') == 'replenishment' ? 'selected' : '' }}>Replenishment</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group">
                                    <label for="start_date">Start Date</label>
                                    <input type="date" class="form-control" id="start_date" name="start_date" value="{{ request('start_date') }}">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group">
                                    <label for="end_date">End Date</label>
                                    <input type="date" class="form-control" id="end_date" name="end_date" value="{{ request('end_date') }}">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>&nbsp;</label><br>
                                    <button type="submit" class="btn btn-primary">Generate Report</button>
                                    <a href="{{ route('petty-cash.report') }}" class="btn btn-outline-secondary">Clear</a>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- Summary -->
            @if($transactions->count() > 0)
                <div class="row mb-4">
                    <div class="col-md-4">
                        <div class="card bg-danger text-white">
                            <div class="card-body">
                                <h5>Total Expenses</h5>
                                <h3>${{ number_format($summary['total_expenses'], 2) }}</h3>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <h5>Total Replenishments</h5>
                                <h3>${{ number_format($summary['total_replenishments'], 2) }}</h3>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <h5>Transaction Count</h5>
                                <h3>{{ $summary['transaction_count'] }}</h3>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Transactions Table -->
                <div class="card">
                    <div class="card-header">
                        <h5>Transaction Details</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-sm">
                                <thead>
                                    <tr>
                                        <th>Date</th>
                                        <th>Fund</th>
                                        <th>Type</th>
                                        <th>Description</th>
                                        <th>Expense Item</th>
                                        <th>Supplier</th>
                                        <th>Amount</th>
                                        <th>Created By</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($transactions as $transaction)
                                        <tr>
                                            <td>{{ $transaction->transaction_date->format('M d, Y') }}</td>
                                            <td>{{ $transaction->fund?->name }} {{ $transaction->type }}</td>
                                            <td>
                                                <span class="badge bg-{{ $transaction->type === 'expense' ? 'danger' : 'success' }}">
                                                    {{ ucfirst($transaction->type) }}
                                                </span>
                                            </td>
                                            <td>{{ $transaction->description }}</td>
                                            <td>{{ $transaction->expenseItem->name ?? '-' }}</td>
                                            <td>{{ $transaction->supplier->name ?? '-' }}</td>
                                            <td>${{ number_format($transaction->amount, 2) }}</td>
                                            <td>{{ $transaction->creator->name }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            @else
                <div class="alert alert-info text-center">
                    <h4>No transactions found</h4>
                    <p>Try adjusting your filter criteria.</p>
                </div>
            @endif
        </div>
    </div>
</div>
@endsection