@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) == 0) @else @endif