@php $setData = DB::connection('mysql_site_' . session('serverID'))->table('settings')->where('site_id', '=', session('siteID'))->get()->first(); $social = DB::connection('mysql_site_' . session('serverID'))->table('social')->where('site_id', '=', session('siteID'))->get()->first(); parse_str($data, $output); @endphp @if($setData->cover) @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 = null; 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(); } } @endphp