Registrations for {{ $event->first()->title }}

@if($event->first()->event_type === 'sports') @elseif($event->first()->event_type === 'musical' || $event->first()->event_type === 'seminar') @endif @if($event->first()->event_type === 'sports') @foreach ($registrations as $registration) @php $contact=DB::table('teams')->where('id','=',$registration->team_id) ->get(); @endphp @php $category=DB::table('sports_categories')->where('id','=',$registration->category_id) ->get(); @endphp @endforeach @elseif($event->first()->event_type === 'musical' || $event->first()->event_type === 'seminar') @foreach ($attendee as $attendance) @endforeach @endif

Team Name	Players	Registration Date	Phone	Email	Category	Status	Actions
Name	Phone	Email	Department	Status	Actions
{{ $registration->team_name }}	@php $players=DB::table('players')->where('teamId','=',$registration->team_id) ->get(); @endphp @foreach($players as $player) {{ $player->player_name }}, @endforeach	{{ $registration->registration_time}}	{{ $contact[0]->phone }}	{{ $contact[0]->email }}	{{$category[0]->category_name}}	{{ ucfirst($registration->status) }}	@if($registration->status === 'pending') Approve Reject @endif
{{ $attendance->name }}	{{ $attendance->phone }}	{{ $attendance->email }}	{{ $attendance->department }}	{{ ucfirst($attendance->status) }}	@if($attendance->status === 'pending') Approve Reject @endif