@php use Illuminate\Support\Collection; @endphp

Final CG DA Report - downloaded from CMIS3.0 on {{$today}}

@foreach($studentDetails->unique('batch_id') as $details) @endforeach

Batch Code	Course	Start date	End date	Incepted	Under training	Training completed	Placed	Training Dropout	Placement Dropout	Placed in CG	Placement Rate (%)	Male	Female	Total	Student taking Online classes	No. of volunteers engaged ( CG)	Exams Yet to complete	Final date of exam completion
{{ $details->batch_code }}	{{ $details->module_name }} ({{ $details->module_code }})	{{date('d-m-Y',strtotime($details->batch_start_date))}}	@if($details->actual_end_date!=null) {{date('d-m-Y',strtotime($details->actual_end_date))}} @else {{date('d-m-Y',strtotime($details->end_date))}} @endif	{{$studentDetails->where('batch_id', $details->batch_id)->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->where('batch_status', 'running')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->where('batch_status', 'complete')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('isPlaced', 2)->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status', 'dropped out')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('isPlaced', 3)->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('status', 'dropped out')->count()}}	@php $total_placed = $studentDetails->where('batch_id', $details->batch_id)->where('isPlaced', 2)->count(); $total_student_completed = $studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->where('batch_status', 'complete')->count(); if($total_placed > 0 && $total_student_completed > 0) { $count = (($total_placed * 100) / $total_student_completed); } else { $count = 0; } @endphp {{str_replace(".00", "", (string)number_format ($count, 2, ".", ""))}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('gender', 'male')->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('gender', 'female')->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('batch_id', $details->batch_id)->where('enroll_status','enrolled')->where('final_exam_marks', '=', NULL)->where('batch_status', 'complete')->count()}}	{{(isset($details->assesment_date)?date('d-m-Y', strtotime($details->assesment_date)):'Not decided yet')}}
Total:			{{$studentDetails->count()}}	{{$studentDetails->where('enroll_status','enrolled')->where('batch_status', 'running')->count()}}	{{$studentDetails->where('enroll_status','enrolled')->where('batch_status', 'complete')->count()}}	{{$studentDetails->where('isPlaced', 2)->count()}}	{{$studentDetails->where('enroll_status', 'dropped out')->count()}}	{{$studentDetails->where('isPlaced', 3)->count()}}	0	@php $total_placed = $studentDetails->where('isPlaced', 2)->count(); $total_student_completed = $studentDetails->where('enroll_status','enrolled')->where('batch_status', 'complete')->count(); if($total_placed > 0 && $total_student_completed > 0) { $count = (($total_placed * 100) / $total_student_completed); } else { $count = 0; } @endphp {{str_replace(".00", "", (string)number_format ($count, 2, ".", ""))}}	{{$studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('enroll_status','enrolled')->count()}}	{{$studentDetails->where('enroll_status','enrolled')->where('final_exam_marks', '=', NULL)->where('batch_status', 'complete')->count()}}