@if(isset($data)) @foreach($data as $key=>$value) @php $sql = 'SELECT TI.TRAINING_TITLE, TI.TRAINING_ID FROM TIMS.TRAINING_INFO ti WHERE TI.TRAINING_ID IN (SELECT DISTINCT TRAINING_ID FROM TIMS.TRAINING_SCHEDULE_MST WHERE SCHEDULE_STATUS_ID != 4) AND TI.TRAINING_TYPE_ID = :p_training_type_id AND TI.TRAINING_ID != 23090911092857'; $training_status = \Illuminate\Support\Facades\DB::select($sql, ['p_training_type_id'=>$value->training_type_id]); @endphp @if(count($training_status) > 0) @endif @endforeach @endif

Training Type	Training	Batch Info
		Batch	Start Date	End Date
{{$value->training_type_name}}	@foreach($training_status as $list) @endforeach {{ $list->training_title }} @php $sql = 'SELECT BATCH_ID, TRAINING_END_DATE, TRAINING_START_DATE, SCHEDULE_ID FROM TIMS.TRAINING_SCHEDULE_MST WHERE SCHEDULE_STATUS_ID != 4 AND 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_start_date)->format('d-M-Y') }} {{ \Carbon\Carbon::parse($b_list->training_end_date)->format('d-M-Y') }} No Batch Found!