@php
$onAir = DB::connection('mysql_site_' . session('serverID'))->select("SELECT * FROM schedules WHERE site_id = '".session('siteID')."' AND day = '".date('w')."' AND (CASE WHEN end_time < start_time THEN start_time <= '".date('H:i').":00' ELSE ('".date('H:i').":00' BETWEEN start_time AND end_time) END) LIMIT 1");
if(count($onAir)){
$onAir_program = DB::connection('mysql_site_' . session('serverID'))->table('schedules_programs')->where('site_id', '=', session('siteID'))->where('id','=',$onAir[0]->program_id)->get()->first();
$onAir_user = DB::connection('mysql_site_' . session('serverID'))->table('schedules_users')->where('site_id', '=', session('siteID'))->where('id','=',$onAir_program->user_id)->get()->first();
}
@endphp
@if(count($onAir))
{{ date('H:i',strtotime($onAir[0]->start_time)) }} - {{ date('H:i',strtotime($onAir[0]->end_time)) }}
{{ $onAir_program->name }}
{!! ($onAir_user ? 'com'.$onAir_user->name : '') !!}
@else
Nenhum programa disponÃvel no momento
@endif
 ? $onAir_user->avatar : 'no-cover.png')) }})