@extends('emails.app') @section('title', 'Daily Odds Status Report - ' . $targetDate) @section('content')

Daily Odds Audit Report

Target Date: {{ $targetDate }} (UTC) • Generated: {{ now('UTC')->format('Y-m-d H:i:s') }} UTC

Total GoalServe
{{ $stats['total_goalserve'] ?? 0 }}
Scheduled Fixtures
Active With Odds
{{ $stats['total_with_odds'] ?? 0 }}
Odds Attached
Missing Odds
{{ $stats['total_missing'] ?? 0 }}
Needs Attention
WagerWise Other
{{ $stats['total_unmatched_wagerwise'] ?? 0 }}
Unmatched In DB

1. GoalServe Matches Missing Odds ({{ $withoutOdds->count() }})

Needs Coverage
@if($withoutOdds->isEmpty())
✓ Excellent: All GoalServe matches for {{ $targetDate }} have active odds attached from WagerWise or The Odds API. Zero missing odds.
@else @foreach($withoutOdds as $m) @endforeach
Sport Match IDs Home Team Away Team Kickoff (UTC) Status
{{ strtoupper($m->sport?->slug ?? $m->sport?->name ?? 'N/A') }}
DB: #{{ $m->id }}
Feed: {{ $m->provider_match_id }}
{{ $m->home_team_name }} {{ $m->away_team_name }} {{ $m->match_utc_datetime ? \Carbon\Carbon::parse($m->match_utc_datetime)->format('M d, H:i') : ($m->match_date . ' ' . $m->match_time) }} UTC {{ $m->match_status ?: 'Not Started' }}
@endif

2. GoalServe Matches With Active Odds ({{ $withOdds->count() }})

Verified In DB
@if($withOdds->isEmpty())
No matches have active odds for {{ $targetDate }} yet.
@else @foreach($withOdds as $m) @php $isNotStarted = in_array(strtolower((string)$m->match_status), ['not started', 'scheduled', 'ns']); @endphp @endforeach
Sport Match IDs Home Team Away Team Kickoff (UTC) Status Best Odds
{{ strtoupper($m->sport?->slug ?? $m->sport?->name ?? 'N/A') }}
DB: #{{ $m->id }}
Feed: {{ $m->provider_match_id }}
{{ $m->home_team_name }} {{ $m->away_team_name }} {{ $m->match_utc_datetime ? \Carbon\Carbon::parse($m->match_utc_datetime)->format('M d, H:i') : ($m->match_date . ' ' . $m->match_time) }} UTC {{ $m->match_status ?: 'Not Started' }} @if($m->best_home_price || $m->best_away_price)
H: ${{ number_format((float)$m->best_home_price, 2) }}
A: ${{ number_format((float)$m->best_away_price, 2) }}
@else Markets Active @endif
@endif

3. WagerWise Other Fixtures Not Matched in DB ({{ count($unmatchedWagerWise) }})

Feed Odds Available
@if(empty($unmatchedWagerWise))
No unattached WagerWise fixtures detected for this date.
@else @foreach($unmatchedWagerWise as $u) @endforeach
Sport WagerWise ID Feed Home Team Feed Away Team Kickoff (UTC) Unmatched Reason
{{ strtoupper($u['league'] ?? 'WAGERWISE') }} {{ $u['id'] }} {{ $u['home'] }} {{ $u['away'] }} {{ $u['commence_utc'] ?? 'TBD' }} {{ $u['reason'] ?? 'Not found in DB' }}
@endif
This automated audit is generated daily at midnight (UTC) for LikelySports administrators.
@endsection