@if(isset($data)) @foreach($data as $key=>$value) @endforeach @endif

Training Type

Status

{{$value->training_type_name}}

@php $sql = 'SELECT TI.TRAINING_TITLE, TI.TRAINING_ID FROM TIMS.TRAINING_INFO ti WHERE TI.TRAINING_TYPE_ID = :p_training_type_id'; $training_status = \Illuminate\Support\Facades\DB::select($sql, ['p_training_type_id'=>$value->training_type_id]); @endphp @foreach($training_status as $list) @endforeach Training Batch Info Batch Start Date End Date {{ $list->training_title }} @php $sql = 'SELECT BATCH_ID, TRAINING_END_DATE, TRAINING_START_DATE, SCHEDULE_ID FROM TIMS.TRAINING_SCHEDULE_MST WHERE TRAINING_ID = :p_training_id'; $training_batch = \Illuminate\Support\Facades\DB::select($sql, ['p_training_id'=>$list->training_id]); $baseUrl = request()->root(); @endphp @if(count($training_batch) > 0) @foreach($training_batch as $b_list) @endforeach @else @endif {{ $b_list->batch_id }} {{ \Carbon\Carbon::parse($b_list->training_end_date)->format('d-M-Y') }} {{ \Carbon\Carbon::parse($b_list->training_start_date)->format('d-M-Y') }} No Batch Found!