@extends('layouts.admin')
@section('title','Marketing statistics')
@section('admin-content')
<div class="admin-heading"><div><div class="eyebrow">CAMPAIGN PERFORMANCE</div><h1>Marketing statistics<span class="gold">.</span></h1><p>Participation, verified purchases and rewards at a glance.</p></div><a class="button small secondary" href="{{ route('admin.marketing-statistics',array_merge(request()->except('page'),['from'=>$from->toDateString(),'to'=>$to->toDateString(),'export'=>'csv'])) }}">Export CSV</a></div>
<form method="get" action="{{ route('admin.marketing-statistics') }}" class="marketing-filters panel"><label>From<input type="date" name="from" value="{{ $from->toDateString() }}" max="{{ today()->toDateString() }}" required></label><label>To<input type="date" name="to" value="{{ $to->toDateString() }}" max="{{ today()->toDateString() }}" required></label><label>State<select name="state"><option value="">All states</option>@foreach(\App\Services\MalaysiaStates::OPTIONS as $state)<option @selected(($d['state']??'')===$state)>{{ $state }}</option>@endforeach</select></label><label>Branch<select name="branch_id"><option value="">All branches</option>@foreach($branches as $branch)<option value="{{ $branch->id }}" @selected((string)($d['branch_id']??'')===(string)$branch->id)>{{ $branch->code }} — {{ $branch->name }}{{ $branch->active?'':' (inactive)' }}</option>@endforeach</select></label><button type="submit" class="button small">Apply</button><a class="nav-link" href="{{ route('admin.marketing-statistics') }}">Last 30 days</a></form>
<p class="marketing-note">Receipts submitted {{ $from->format('d M Y') }}–{{ $to->format('d M Y') }}, Malaysia time (UTC+8). Outcomes are current as of {{ now()->format('d M Y, H:i') }}. Filters apply to receipt submission date, not purchase, approval or email date. Older branch names without a linked store are included only when no state or branch is selected.</p>
<div class="marketing-cards">
@foreach(['Participants'=>(int)$counts->participants,'Receipts submitted'=>(int)$counts->submitted,'Approved receipts'=>(int)$counts->approved,'Spins played'=>$spinCount,'TNG PINs issued'=>$issued,'TNG value issued'=>'MYR '.number_format($issuedValue,2)] as $label=>$value)<article class="panel"><span>{{ $label }}</span><strong>{{ is_int($value)?number_format($value):$value }}</strong></article>@endforeach
</div>
<div class="marketing-grid"><article class="panel"><h2>Verified purchase value</h2>@forelse($money as $currency=>$amount)<p class="marketing-value">{{ $currency }} {{ number_format($amount['cents']/100,2) }}</p><p>Average recorded approved purchase: {{ $currency }} {{ number_format($amount['cents']/100/$amount['count'],2) }} · {{ $amount['count'] }} receipts</p>@empty<p>No recorded approved purchase amounts.</p>@endforelse<small>{{ $missingAmounts }} approved receipts have no recorded amount. Values represent approved receipt purchases; they do not establish sales caused by this campaign.</small></article>
<article class="panel"><h2>New and returning participants</h2><dl class="marketing-metrics"><div><dt>First-time participants</dt><dd>{{ (int)$counts->participants-$returning }}</dd></div><div><dt>Returning participants</dt><dd>{{ $returning }}</dd></div></dl><small>A participant has a verified customer account linked to a receipt in this selection. Returning means they submitted a receipt before this date range, across any branch. This is participation history, not account registration.</small></article></div>
<article class="panel"><h2>Daily receipt activity</h2><p>Submitted receipts and their currently approved outcomes, grouped by submission day.</p><div class="marketing-legend"><span>● Submitted</span><span>● Approved</span></div>
@php($maximum=max(1,max(array_column($series,'submitted'))))
<div class="marketing-chart"><svg role="img" aria-label="Daily receipt submissions and current approvals" viewBox="0 0 {{ max(660,count($series)*12) }} 230" style="min-width:{{ max(660,count($series)*12) }}px"><title>Daily receipt activity</title>
@foreach($series as $index=>$point)@php($step=max(660,count($series)*12)/count($series))<rect x="{{ $index*$step+1 }}" y="{{ 185-160*$point['submitted']/$maximum }}" width="{{ max(2,$step/2-2) }}" height="{{ 160*$point['submitted']/$maximum }}" fill="#498f88"><title>{{ $point['day'] }}: {{ $point['submitted'] }} submitted</title></rect><rect x="{{ $index*$step+$step/2 }}" y="{{ 185-160*$point['approved']/$maximum }}" width="{{ max(2,$step/2-2) }}" height="{{ 160*$point['approved']/$maximum }}" fill="#b38327"><title>{{ $point['day'] }}: {{ $point['approved'] }} approved</title></rect>@if($index%max(1,(int)ceil(count($series)/6))===0)<text x="{{ $index*$step }}" y="210" fill="currentColor" font-size="11">{{ substr($point['day'],5) }}</text>@endif @endforeach
</svg></div><details><summary>View daily figures</summary><div class="table-wrap"><table><thead><tr><th>Submission date</th><th>Submitted</th><th>Currently approved</th></tr></thead><tbody>@foreach($series as $point)<tr><td>{{ $point['day'] }}</td><td>{{ $point['submitted'] }}</td><td>{{ $point['approved'] }}</td></tr>@endforeach</tbody></table></div></details></article>
<div class="marketing-grid"><article class="panel"><h2>Customer journey</h2><p>Number of receipts reaching each milestone.</p>@foreach(['Submitted'=>(int)$counts->submitted,'Email verified'=>(int)$counts->verified,'At least one spin played'=>$played,'At least one confirmed result'=>$won] as $label=>$value)<div class="marketing-funnel"><span>{{ $label }}</span><strong>{{ $value }}</strong><meter min="0" max="{{ max(1,(int)$counts->submitted) }}" value="{{ $value }}">{{ $value }}</meter></div>@endforeach<small>Receipts can be approved before or after spinning. Confirmed wheel results can include a no-prize outcome.</small></article>
<article class="panel"><h2>Receipt review</h2><dl class="marketing-metrics"><div><dt>Pending review</dt><dd>{{ (int)$counts->pending }}</dd></div><div><dt>Approval rate among decisions</dt><dd>{{ $counts->approved+$counts->rejected ? number_format(100*$counts->approved/($counts->approved+$counts->rejected),1).'%' : '—' }}</dd></div><div><dt>Average submission-to-review time</dt><dd>{{ $reviewCount?number_format($reviewMinutes/$reviewCount/60,1).' hours':'—' }}</dd></div></dl><small>Approval rate excludes pending, expired and unverified receipts. Review time uses records with a recorded review timestamp.</small><h3>Common rejection reasons</h3>@forelse($reasons as $reason)<p>{{ $reason->reason ?: 'Not recorded' }} <strong>({{ $reason->total }})</strong></p>@empty<p>No rejected receipts in this selection.</p>@endforelse</article></div>
<article class="panel"><h2>Branch comparison</h2><p>Top 20 recorded branch labels by receipt submissions. CSV includes every branch.</p><div class="table-wrap"><table><thead><tr><th>Branch</th><th>Participants</th><th>Receipts</th><th>Approved</th><th>Verified value</th></tr></thead><tbody>@forelse($branchRows->take(20) as $row)<tr><td>{{ $row->branch }}</td><td>{{ $row->participants }}</td><td>{{ $row->receipts }}</td><td>{{ $row->approved }}</td><td>@forelse(($branchMoney[($row->branch_id??'legacy').'|'.$row->branch]??[]) as $currency=>$cents)<div>{{ $currency }} {{ number_format($cents/100,2) }}</div>@empty — @endforelse</td></tr>@empty<tr><td colspan="5">No receipt activity in this selection.</td></tr>@endforelse</tbody></table></div><small>Participants can appear in more than one branch. Historical branch labels are preserved.</small></article>
<div class="marketing-grid"><article class="panel"><h2>Wheel results</h2><div class="table-wrap"><table><thead><tr><th>Reward / outcome</th><th>Results</th><th>Confirmed</th></tr></thead><tbody>@forelse($rewards as $reward)<tr><td>{{ $reward->prize_name }}</td><td>{{ $reward->wins }}</td><td>{{ $reward->confirmed }}</td></tr>@empty<tr><td colspan="3">No spins for these receipts.</td></tr>@endforelse</tbody></table></div><small>TNG issuance is counted only once per assigned PIN. It does not confirm redemption.</small><p>Currently available PINs across the whole campaign: <strong>{{ $available }}</strong></p></article>
<article class="panel"><h2>Email and marketing audience</h2><dl class="marketing-metrics">@foreach(['Email sent'=>'sent','Pending'=>'queued','Sending'=>'sending','Failed'=>'failed'] as $label=>$key)<div><dt>{{ $label }}</dt><dd>{{ $email[$key]??0 }}</dd></div>@endforeach<div><dt>Email offers opted in</dt><dd>{{ (int)$audience->email }}</dd></div><div><dt>WhatsApp/SMS offers opted in</dt><dd>{{ (int)$audience->mobile }}</dd></div><div><dt>Spin sign-in links used</dt><dd>{{ (int)$links->used }}</dd></div><div><dt>Unused expired sign-in links</dt><dd>{{ (int)$links->expired }}</dd></div></dl><small>Email counts cover approval/reward email jobs for the selected receipts. Sent means accepted by the configured mail transport, not confirmed inbox delivery. Retry attempts are not extra emails in this count. Offer opt-ins are current consent for these participants. Link counts include replacement links and do not measure email opens.</small></article></div>
@endsection
@push('scripts')<link rel="stylesheet" href="{{ asset('wheel/marketing-statistics.css') }}">@endpush