@extends('layouts.admin') @section('title','Report Center') @section('heading','Report Center')
@section('content')
<div class="grid"><div class="card metric"><small>Loyalty accounts</small><strong>{{ number_format($loyalty['accounts']) }}</strong></div><div class="card metric"><small>Outstanding points</small><strong>{{ number_format($loyalty['outstanding_points']) }}</strong></div><div class="card metric"><small>Completed redemptions</small><strong>{{ number_format($loyalty['completed_redemptions']) }}</strong></div><div class="card metric"><small>Redeemed points</small><strong>{{ number_format($loyalty['redeemed_points']) }}</strong></div></div>
<div class="grid two"><section class="card"><h2>Generate secure export</h2><p>Large reports run on the <code>exports</code> queue. Files are private, requester-only and expire after seven days.</p><form method="post" action="{{ route('admin.reports.store') }}">@csrf<div class="form-grid"><label>Dataset<select name="type" required><option value="orders">Orders</option><option value="transactions">Financial transactions</option><option value="loyalty_redemptions">Loyalty redemptions</option></select></label><label>Status<input name="status" maxlength="30" placeholder="Optional"></label><label>Transaction type<select name="transaction_type"><option value="">Any</option>@foreach(['adjustment','transfer','payment','refund','wallet_top_up','loyalty_redemption'] as $x)<option>{{ $x }}</option>@endforeach</select></label><label>Currency<input name="currency" maxlength="3" placeholder="INR"></label><label>From<input type="date" name="from"></label><label>To<input type="date" name="to"></label></div><button class="btn btn-primary">Queue export</button></form></section><section class="card"><h2>Operational guarantees</h2><ul><li>CSV formula injection is neutralized.</li><li>Rows are streamed in bounded chunks.</li><li>Filters and requester are snapshotted.</li><li>Downloads, retries and deletion are audited.</li><li>Expired files are removed by the scheduler.</li></ul></section></div>
<section class="card"><div class="section-head"><div><h2>Your exports</h2><p>Only exports requested by your account appear here.</p></div><a class="btn" href="{{ route('admin.reports.index') }}">Refresh</a></div><div class="table-wrap"><table><thead><tr><th>Requested</th><th>Dataset</th><th>Filters</th><th>Status</th><th>Result</th><th>Expires</th><th>Actions</th></tr></thead><tbody>@forelse($exports as $x)<tr><td>{{ $x->created_at->format('d M Y H:i') }}</td><td><strong>{{ ucfirst($x->type) }}</strong><br><small>{{ str($x->public_id)->limit(12) }}</small></td><td><small>{{ collect($x->filters)->map(fn($v,$k)=>"$k=$v")->join(' · ') ?: 'All records' }}</small></td><td><span class="badge {{ $x->status==='completed'?'approved':($x->status==='failed'?'rejected':'pending') }}">{{ $x->status }}</span>@if($x->failure_message)<br><small>{{ Str::limit($x->failure_message,100) }}</small>@endif</td><td>{{ number_format($x->row_count) }} rows<br><small>{{ $x->size_bytes ? number_format($x->size_bytes/1024,1).' KB' : 'Pending' }} · {{ $x->download_count }} downloads</small></td><td>{{ $x->expires_at->format('d M Y H:i') }}@if($x->expires_at->isPast())<br><span class="badge rejected">Expired</span>@endif</td><td><div class="actions">@if($x->status==='completed'&&!$x->expires_at->isPast())<a class="btn btn-primary" href="{{ route('admin.reports.download',$x->public_id) }}">Download</a>@endif @if($x->status==='failed'&&!$x->expires_at->isPast())<form method="post" action="{{ route('admin.reports.retry',$x->public_id) }}">@csrf<button class="btn">Retry</button></form>@endif @if($x->status!=='processing')<form method="post" action="{{ route('admin.reports.destroy',$x->public_id) }}" onsubmit="return confirm('Delete this export and its file?')">@csrf @method('delete')<button class="btn">Delete</button></form>@endif</div></td></tr>@empty<tr><td colspan="7" class="empty">No queued exports yet.</td></tr>@endforelse</tbody></table></div>{{ $exports->links() }}</section>
@endsection