{{ $prize->name }}
{{ $available }} available · {{ DB::table('digital_reward_pins')->where('prize_id',$prize->id)->where('status','reserved')->count() }} reserved · {{ DB::table('digital_reward_pins')->where('prize_id',$prize->id)->where('status','issued')->count() }} issued · {{ DB::table('digital_reward_pins')->where('prize_id',$prize->id)->whereIn('status',['available','reserved','expired'])->where('expires_on','<=',today()->toDateString())->count() }} expired
@if($available<=5)Low stock: {{ $available }} usable PINs remain. Add more purchased PINs. At zero, this prize cannot be won.
@endif