{{--

* {{__('messages.Please Select Branch and Course Level to get the Planning List')}}

--}}

{{__('messages.search')}} {{--

branch_id

.defer

.defer @foreach(\App\Models\Branch::all() as $branch) @endforeach

--}}

main_category_id {{-- .defer --}} {{__('messages.Main Category')}} @foreach(\App\Models\Category::where("active" ,1)->whereNull("category_id")->get() as $category) @endforeach

@if ($main_category_id)

category_id

category_changed

.defer

{{__('messages.Category')}} @foreach(\App\Models\Category::where("active" ,1)->where("category_id" ,$main_category_id )->get() as $category) @endforeach

@endif

product_id {{-- product_changed --}} .defer {{__('messages.Product')}} @foreach($products as $product) @endforeach

{{-- @if ($course_levels->count()>1)

course_level_id

.defer @foreach($course_levels as $courseLevel) @if ($product_id) @else @endif @endforeach

@endif --}}

{{--

--}}

# {{-- {{__('messages.Branch')}} --}} {{__('messages.Course Level')}} {{-- {{__('messages.Preferred Period')}} --}} {{__('messages.Payment Status')}}

{{-- @if ($course_level_id ) {{($checkAll)? count($selected_order_details) ." Rows":"Select Results"}}
@else --}} {{-- @endif --}}

@php $row_index =0; $now = \Carbon\Carbon::now(); @endphp @forelse ($order_details as $key =>$order_detail) @php // $order_detail->course_level $prev_level_ids =$order_detail->course_level->product->course_levels()->where("level_order" ,"<", $order_detail->course_level->level_order)->pluck("id"); // skip if the customer has previous levels waiting or open // $first_od =\App\Models\OrderDetail::where("customer_id",$order_detail->customer_id) // ->whereIn("status" ,["waiting"])->whereIn("course_level_id" , $prev_level_ids)->first(); $first_od_open_ids =\App\Models\OrderDetail::where("customer_id",$order_detail->customer_id) ->whereIn("status" ,["open"])->whereIn("course_level_id" , $prev_level_ids)->pluck("id"); // to remove not Confirmed open course customers $course_customer_prev_open_not_sure =null; if ( $first_od_open_ids->count()>0){ // Log::info("first_od_open_ids:" . json_encode( $first_od_open_ids)); $course_customer_prev_open_not_sure = \App\Models\CourseCustomer::whereIn("order_detail_id" , $first_od_open_ids ) ->where("customer_id",$order_detail->customer_id) ->whereIn("status" ,['waiting', 'Open']) ->whereIn("confirmation", ['Not Yet', 'Not Sure', 'Rejected']) ->first(); // Log::info("course_customer_prev_open_not_sure:" . json_encode( $course_customer_prev_open_not_sure)); if ( $course_customer_prev_open_not_sure) continue; } // if ($first_od){ // continue; // }else{ $row_index++; // } $the_direct_prev_level = $order_detail->course_level->product->course_levels()->where("level_order" , $order_detail->course_level->level_order -1)->first(); $course_customer_prev =null; if ( $the_direct_prev_level){ $the_prev_level_order_detail =\App\Models\OrderDetail::where("customer_id",$order_detail->customer_id)->where("status" ,"open")->where("course_level_id" , $the_direct_prev_level->id)->pluck("id"); // course_customer if ( $the_prev_level_order_detail->count()>0) { $course_customer_prev = \App\Models\CourseCustomer::whereIn("order_detail_id" , $the_prev_level_order_detail) ->where("customer_id",$order_detail->customer_id) ->where("status","Open") ->where("confirmation","Confirmed") ->first(); } } @endphp @if ( $course_customer_prev) @php $bgc= ""; if ($course_customer_prev->course->course_sessions()->where("status" ,"completed")->count() >= $course_customer_prev->course->course_sessions->count()/2 ) { $bgc="bg-green-300 hover:bg-green-400"; }else{ $bgc="bg-red-300 hover:bg-red-400"; } @endphp #{{$row_index}} {{-- {{__('messages.Branch')}}{{($order_detail->branch_id)?$order_detail->branch->name:"-"}} --}} {{__('messages.Course Level')}}{{$order_detail->course_level->product->name}} - {{$order_detail->course_level->name}} {{-- {{__('messages.Preferred Period')}}{{($order_detail->period_id)? $order_detail->period->name :""}} --}} {{__('messages.Payment Status')}}{{$order_detail->order->payment_status}}

@else

#{{$row_index}}

{{__('messages.Course Level')}}{{$order_detail->course_level->product->name}} - {{$order_detail->course_level->name}} {{-- {{__('messages.Preferred Period')}}{{($order_detail->period_id)? $order_detail->period->name :""}} --}} {{__('messages.Payment Status')}}{{$order_detail->order->payment_status}}

@endif @empty

@endforelse

#

{{__('messages.Class Room')}} {{-- {{__('messages.the_Period')}} --}} {{__('messages.Instructor')}}

@forelse ($courses as $key =>$course)

#{{$loop->iteration}}

{{($course->course_level->product)?$course->course_level->product->name:"-"}}-{{($course->course_level)?$course->course_level->name:"-"}}

{{__('messages.customers')}}{{$course->course_customers()->where("confirmation", "!=","Rejected")->count()}}

{{__('messages.Class Room')}}{{($course->class_room_id)?$course->class_room->name . " - " . $course->class_room->branch->name:"-"}} {{-- {{__('messages.the_Period')}}{{$course->from . '-' . $course->to}} --}} {{__('messages.Instructor')}}{{($course->instructor_id)?$course->instructor->name:"-"}}

@empty

@endforelse

{{__('messages.Planning List')}}

* {{__('messages.Please Select Branch and Course Level to get the Planning List')}}