@php
$onAir = DB::connection('mysql_site_' . session('serverID'))->select("SELECT * FROM schedules WHERE 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();
if(isset($onAir_program->user_id)){
$onAir_user = DB::connection('mysql_site_' . session('serverID'))->table('schedules_users')->where('site_id', '=', session('siteID'))->where('id','=',$onAir_program->user_id)->get()->first();
}else{
$onAir_user = '';
}
}
@endphp
@if(count($onAir) == 0)
Online agora
Nenhum locutor está online neste momento.
@else
@isset($onAir_user->avatar)
@endif
Online agora
{{ (isset($onAir_user) ? $onAir_user : '---') }}
@endif
