@extends('layouts.master')

@section('title')
    Transaction Report
@endsection

@section('css')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css" />
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
@endsection

@section('content')
<div class="bg-white px-4 py-3">
    <!-- Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h4 class="mb-0">Transaction Report</h4>
        <a href="{{ route('reports.transaction.export', request()->query()) }}" class="btn btn-success">
            <i class="fas fa-download"></i> Export Report
        </a>
    </div>

    <!-- Filters -->
    <div class="card mb-4">
        <div class="card-body">
            <form action="{{ route('reports.transaction') }}" method="GET">
                <div class="row g-3">
                    <!-- Date Range -->
                    <div class="col-md-3">
                        <label class="form-label">From Date</label>
                        <input type="date" name="date_from" class="form-control"
                               value="{{ $filters['date_from'] }}">
                    </div>
                    <div class="col-md-3">
                        <label class="form-label">To Date</label>
                        <input type="date" name="date_to" class="form-control"
                               value="{{ $filters['date_to'] }}">
                    </div>

                    <!-- Tenant Filter -->
                    <div class="col-md-2">
                        <label class="form-label">Tenant</label>
                        <select name="tenant_id" class="form-select">
                            <option value="">All Tenants</option>
                            @foreach($tenants as $tenant)
                                <option value="{{ $tenant->id }}"
                                    {{ $filters['tenant_id'] == $tenant->id ? 'selected' : '' }}>
                                    {{ $tenant->tenant_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <!-- Plan Filter -->
                    <div class="col-md-2">
                        <label class="form-label">Plan</label>
                        <select name="plan_id" class="form-select">
                            <option value="">All Plans</option>
                            @foreach($plans as $plan)
                                <option value="{{ $plan->id }}"
                                    {{ $filters['plan_id'] == $plan->id ? 'selected' : '' }}>
                                    {{ $plan->plan_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <!-- Search -->
                    <div class="col-md-2">
                        <label class="form-label">Search</label>
                        <input type="text" name="search" class="form-control"
                               placeholder="Search..." value="{{ $filters['search'] }}">
                    </div>
                </div>

                <div class="mt-3">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-filter"></i> Apply Filters
                    </button>
                    <a href="{{ route('reports.transaction') }}" class="btn btn-secondary">
                        <i class="fas fa-redo"></i> Reset
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Results Table -->
    <div class="table-responsive">
        <table class="table table-bordered table-hover">
            <thead class="table-light">
                <tr>
                    <th>S.No</th>
                    <th>Payment Date</th>
                    <th>Tenant ID</th>
                    <th>Tenant</th>
                    <th>Plan</th>
                    <th>Price</th>
                    <th>Time Period</th>
                    <th>Status</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                @forelse($transactions as $index => $transaction)
                    <tr>
                        <td>{{ $transactions->firstItem() + $index }}</td>
                        <td>{{ \Carbon\Carbon::parse($transaction->payment_date)->format('d-m-Y') }}</td>
                        <td>{{ $transaction->tenant_id }}</td>
                        <td>{{ $transaction->tenant_name }}</td>
                        <td>{{ $transaction->plan_name }}</td>
                        <td>₹{{ number_format($transaction->price, 2) }}</td>
                        <td>
                            {{ \Carbon\Carbon::parse($transaction->start_date)->format('d-m-Y') }} to
                            {{ \Carbon\Carbon::parse($transaction->end_date)->format('d-m-Y') }}
                        </td>
                        <td>
                            <span class="badge bg-{{ $transaction->payment_status == 'paid' ? 'success' : 'warning' }}">
                                {{ ucfirst($transaction->payment_status) }}
                            </span>
                        </td>
                        <td>
                            <a href="{{ route('invoice.view', $transaction->id) }}"
                               class="btn btn-sm btn-info" target="_blank">
                                <i class="fas fa-eye"></i> View
                            </a>
                            <a href="{{ route('invoice.download', $transaction->id) }}"
                               class="btn btn-sm btn-success">
                                <i class="fas fa-download"></i> Download
                            </a>
                        </td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="9" class="text-center text-muted py-4">
                            No transaction records found
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>

    <!-- Pagination -->
    <div class="d-flex justify-content-center mt-4">
        {{ $transactions->appends(request()->query())->links() }}
    </div>
</div>
@endsection

@section('scripts')
<script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
<script>
    flatpickr('input[type="date"]', {
        dateFormat: "Y-m-d",
        maxDate: "today"
    });
</script>
@endsection