@extends('admin.layouts.app')
@section('title','Donation Report')
@section('breadcrumb') <span>/</span> <a href="{{ route('admin.reports.index') }}" style="color:inherit;text-decoration:none;">Reports</a> <span>/</span> Donations @endsection

@section('content')
<div class="page-header">
    <div><h1>Donation Report</h1><p class="page-subtitle">
        @if($from || $to) {{ $from?->format('d M Y') ?? 'Beginning' }} — {{ $to?->format('d M Y') ?? 'Till Date' }}
        @else All Time @endif
    </p></div>
    <div class="d-flex gap-2">
        @if(auth()->user()->hasPermission('reports.export'))
        <div class="dropdown">
            <button class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown">
                <i class="fas fa-download me-2"></i>Export
            </button>
            <ul class="dropdown-menu">
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','donations') }}?{{ request()->getQueryString() }}&format=pdf"><i class="fas fa-file-pdf text-danger me-2"></i>PDF</a></li>
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','donations') }}?{{ request()->getQueryString() }}&format=csv"><i class="fas fa-file-csv text-success me-2"></i>CSV</a></li>
                <li><a class="dropdown-item" href="{{ route('admin.reports.export','donations') }}?{{ request()->getQueryString() }}&format=xlsx"><i class="fas fa-file-excel text-success me-2"></i>Excel</a></li>
            </ul>
        </div>
        @endif
        <button onclick="window.print()" class="btn btn-outline-secondary"><i class="fas fa-print me-2"></i>Print</button>
    </div>
</div>

<!-- Filters -->
<div class="card mb-4">
    <div class="card-body py-3">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-2">
                <select name="date_range" class="form-select">
                    <option value="">All Time</option>
                    <option value="today"      {{ request('date_range')==='today'?'selected':'' }}>Today</option>
                    <option value="this_week"  {{ request('date_range')==='this_week'?'selected':'' }}>This Week</option>
                    <option value="this_month" {{ request('date_range')==='this_month'?'selected':'' }}>This Month</option>
                    <option value="last_month" {{ request('date_range')==='last_month'?'selected':'' }}>Last Month</option>
                    <option value="this_year"  {{ request('date_range')==='this_year'?'selected':'' }}>This Year</option>
                    <option value="custom"     {{ request('date_range')==='custom'?'selected':'' }}>Custom</option>
                </select>
            </div>
            <div class="col-md-2"><input type="date" name="from" class="form-control" value="{{ request('from') }}" placeholder="From Date"></div>
            <div class="col-md-2"><input type="date" name="to"   class="form-control" value="{{ request('to') }}"   placeholder="To Date"></div>
            <div class="col-md-2">
                <select name="payment_status" class="form-select">
                    <option value="">All Status</option>
                    @foreach(['completed','pending','failed','refunded'] as $s)
                    <option value="{{ $s }}" {{ request('payment_status')===$s?'selected':'' }}>{{ ucfirst($s) }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2"><input type="text" name="purpose" class="form-control" placeholder="Purpose..." value="{{ request('purpose') }}"></div>
            <div class="col-md-2 d-flex gap-1">
                <button class="btn btn-primary flex-grow-1"><i class="fas fa-filter me-1"></i>Filter</button>
                <a href="{{ route('admin.reports.donations') }}" class="btn btn-outline-secondary">Clear</a>
            </div>
        </form>
    </div>
</div>

<!-- Summary Cards -->
<div class="row g-3 mb-4">
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #2563eb;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Collected</div><div style="font-size:20px;font-weight:700;">₹{{ number_format($summary['total_amount'],2) }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #22c55e;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Records</div><div style="font-size:20px;font-weight:700;">{{ $summary['total_count'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #16a34a;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Completed</div><div style="font-size:20px;font-weight:700;">{{ $summary['completed_count'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #f59e0b;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Avg Donation</div><div style="font-size:20px;font-weight:700;">₹{{ number_format($summary['avg_donation'],0) }}</div></div></div>
</div>

<!-- Table -->
<div class="card">
    <div class="card-header d-flex align-items-center justify-content-between">
        <h6 class="mb-0 fw-700"><i class="fas fa-hand-holding-heart text-primary me-2"></i>Donation Records</h6>
        <span class="badge bg-primary">{{ $records->count() }} records</span>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0" id="reportTable">
                <thead style="background:#f8fafc;">
                    <tr>
                        <th class="ps-3">S.N.</th><th>Donation ID</th><th>Donor Name</th>
                        <th>Mobile</th><th>Amount</th><th>Purpose</th>
                        <th>Gateway</th><th>Status</th><th>Date</th><th>Receipt</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($records as $i => $d)
                    <tr>
                        <td class="ps-3 text-muted">{{ $i+1 }}</td>
                        <td><code style="font-size:11px;">{{ $d->donation_id }}</code></td>
                        <td style="font-weight:600;font-size:13px;">{{ $d->donor_name }}</td>
                        <td style="font-size:12px;">{{ $d->donor_mobile }}</td>
                        <td style="font-weight:700;color:#16a34a;">₹{{ number_format($d->amount,2) }}</td>
                        <td style="font-size:12px;">{{ $d->purpose ?? 'General' }}</td>
                        <td><span class="badge bg-light text-dark border">{{ ucfirst($d->payment_gateway) }}</span></td>
                        <td>{!! $d->payment_status_badge !!}</td>
                        <td style="font-size:12px;color:#64748b;">{{ $d->donation_date->format('d M Y') }}</td>
                        <td style="font-size:11px;">{{ $d->receipt_number }}</td>
                    </tr>
                    @empty
                    <tr><td colspan="10" class="text-center py-4 text-muted">No donations found for this filter</td></tr>
                    @endforelse
                </tbody>
                @if($records->count())
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="4" class="ps-3" style="font-weight:700;">TOTAL</td>
                        <td style="font-weight:700;color:#16a34a;">₹{{ number_format($records->where('payment_status','completed')->sum('amount'),2) }}</td>
                        <td colspan="5"></td>
                    </tr>
                </tfoot>
                @endif
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() {
    $('#reportTable').DataTable({
        ...window.dtDefaults,
        dom: 'Bfrtip',
        buttons: [
            { extend:'copy', className:'btn btn-sm btn-outline-secondary' },
            { extend:'csv',  className:'btn btn-sm btn-outline-success',  text:'CSV' },
            { extend:'excel',className:'btn btn-sm btn-outline-success',  text:'Excel' },
            { extend:'pdf',  className:'btn btn-sm btn-outline-danger',   text:'PDF' },
            { extend:'print',className:'btn btn-sm btn-outline-secondary', text:'Print' },
        ],
        paging: false,
        info: false,
    });
});
</script>
@endpush