@if($from && $to) @foreach(\App\Models\User::where('is_instructor',1)->where('active',1)->where('job_type','Full_Time')->get() as $instructor) @php //$courses = $instructor->courses->where('start_date','>=',$from)->where('end_date','<=',$to)->where('course_status_id','!=',3); $daysOfMonth = \Carbon\CarbonPeriod::create($from, $to); @endphp

{{__('messages.Name')}}: {{$instructor->name}}

{{__('hr_messages.Salary')}}: {{$instructor->price}}

{{__('messages.num_of_courses')}}: {{$instructor->num_of_courses}}

@php $last_course_sessions_count =0; $arr = []; @endphp @foreach($daysOfMonth as $day) @php $course_sessions_count = $instructor->course_sessions->where('session_date',$day->format('Y-m-d'))->count(); if ($course_sessions_count == 0 && ($day->format('l') == 'Friday' ||$day->format('l') == 'Saturday' )) { continue; } if ($loop->first) { $arr[]=["start_date" => $day->format('Y-m-d'), "end_date" => $day->format('Y-m-d'), "course_sessions_count" => $course_sessions_count]; }else if ($course_sessions_count == $last_course_sessions_count) { $arr[count($arr)-1]['end_date'] = $day->format('Y-m-d'); }else{ $start_date = $day->format('Y-m-d'); $end_date = $day->format('Y-m-d'); $arr[]=["start_date" => $day->format('Y-m-d'), "end_date" => $day->format('Y-m-d'), "course_sessions_count" => $course_sessions_count]; } $last_course_sessions_count = $course_sessions_count; @endphp @endforeach @foreach ($arr as $item)

{{$item["start_date"]}} : {{$item["end_date"]}}

@endforeach

@endforeach @endif