@php use Illuminate\Support\Collection; @endphp

	KPI	At {{$quator}}
Infra and HR	# of training centres/college tie-ups across locations	{{count($boaCenters)}}
	# of training rooms available	{{(isset($infraDetails->no_of_training_rooms)?$infraDetails->no_of_training_rooms:'')}}
	Capacity of training rooms	{{(isset($infraDetails->capacity_of_training)?$infraDetails->capacity_of_training:'')}}
	Staff recruited across designations	{{(isset($infraDetails->staff_recruited)?$infraDetails->staff_recruited:'')}}
	# of ToT sessions organized	{{(isset($infraDetails->no_of_tot)?$infraDetails->no_of_tot:'')}}
		M	F	T
Summary of project status	# of new trainees enrolled	{{count($studentDetails->where('gender', 'male'))}}	{{count($studentDetails->where('gender', 'female'))}}	{{count($studentDetails)}}
	# of trainees undergoing training	{{count($studentDetails->where('gender', 'male')->where('batch_status','running'))}}	{{count($studentDetails->where('gender', 'female')->where('batch_status','running'))}}	{{count($studentDetails->where('batch_status','running'))}}
	# of dropouts	{{count($studentDetails->where('gender', 'male')->where('enroll_status','dropped out'))}}	{{count($studentDetails->where('gender', 'female')->where('enroll_status','dropped out'))}}	{{count($studentDetails->where('enroll_status','dropped out'))}}
	# of trainees completed training	{{count($studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->where('batch_status','complete'))}}	{{count($studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->where('batch_status','complete'))}}	{{count($studentDetails->where('enroll_status','enrolled')->where('batch_status','complete'))}}
	# of trainees certified	{{count($studentDetails->where('gender', 'male')->where('final_exam_marks','>=',50)->where('batch_status','complete'))}}	{{count($studentDetails->where('gender', 'female')->where('final_exam_marks','>=',50)->where('batch_status','complete'))}}	{{count($studentDetails->where('final_exam_marks','>=',50)->where('batch_status','complete'))}}
	# of trainees placed			0

Training process	# of training batches (Ongoing/Completed)	{{count($studentDetails->unique('batch_code')->whereIn('batch_status', ['complete', 'running']))}}
	Average attendance	{{ (isset($infraDetails->average_attendance)?$infraDetails->average_attendance:'') }}
	Capacity of training rooms	{{ (isset($infraDetails->capacity_of_training)?$infraDetails->capacity_of_training:'') }}
	# of training days	{{ (isset($infraDetails->no_of_training_days)?$infraDetails->no_of_training_days:'') }}
	# of theory training sessions	{{ (isset($infraDetails->no_of_theory_training_sessions)?$infraDetails->no_of_theory_training_sessions:'') }}
	# of practical training sessions attended	{{ (isset($infraDetails->no_of_practical_training_sessions)?$infraDetails->no_of_practical_training_sessions:'') }}
	# of soft skills/life skills sessions	{{ (isset($infraDetails->no_of_soft_skills_sessions)?$infraDetails->no_of_soft_skills_sessions:'') }}
	# industrial visits organized	{{ (isset($infraDetails->no_of_industrial_visit_organized)?$infraDetails->no_of_industrial_visit_organized:'') }}
	# of candidates attending industrial visits	{{count($boa_placement_info->where('industry_visit_status', 'y')->where('gender', 'male'))}}	{{count($boa_placement_info->where('industry_visit_status', 'y')->where('gender', 'female'))}}	{{count($boa_placement_info->where('industry_visit_status', 'y'))}}

Placement details	# of candidates who completed pre-placement counseling	{{count($studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->where('batch_status','complete')->where('final_exam_marks','>=',50))}}	{{count($studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->where('batch_status','complete')->where('final_exam_marks','>=',50))}}	{{count($studentDetails->where('enroll_status','enrolled')->where('batch_status','complete')->where('final_exam_marks','>=',50))}}
	# of employers (companies) who conducted interviewed
	# of candidates interviewed	{{count($boa_placement_info->where('gender', 'male')->where('intv_atten','y'))}}	{{count($boa_placement_info->where('gender', 'female')->where('intv_atten','y'))}}	{{count($boa_placement_info->where('intv_atten','y'))}}
	# of candidates placed in formal employment	{{count($boa_placement_info->where('gender', 'male')->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed']))}}	{{count($boa_placement_info->where('gender', 'female')->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed']))}}	{{count($boa_placement_info->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed']))}}
	# of candidates self-employed	{{count($boa_placement_info->where('gender', 'male')->where('nature_of_employment', 'Self-employed/Business'))}}	{{count($boa_placement_info->where('gender', 'female')->where('nature_of_employment', 'Self-employed/Business'))}}	{{count($boa_placement_info->where('nature_of_employment', 'Self-employed/Business'))}}
	% job placement rate (Placed/Completed*100)	@php $completed = count($studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->where('batch_status','complete')); $placed = count($boa_placement_info->where('gender', 'male')->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed'])); //$count = ($completed / $placed) * 100; if($completed > 0 && $placed > 0) { $count = ($placed / $completed ) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->where('batch_status','complete')); $placed = count($boa_placement_info->where('gender', 'female')->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed'])); //$count = ($completed / $placed) * 100; if($completed > 0 && $placed > 0) { $count = ($placed / $completed ) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('enroll_status','enrolled')->where('batch_status','complete')); $placed = count($boa_placement_info->whereIn('nature_of_employment',['Placed by Anudip', 'Self-placed'])); //$count = ($completed / $placed) * 100; if($completed > 0 && $placed > 0) { $count = ($placed / $completed ) * 100; } else { $count = 0; } @endphp {{$count}}
	Average annual income of salaried candidates	{{$boa_placement_info->whereIn('nature_of_employment', ['Self-placed', 'Placed by Anudip'])->where('gender', 'male')->avg('annual_salary')}}	{{$boa_placement_info->whereIn('nature_of_employment', ['Self-placed', 'Placed by Anudip'])->where('gender', 'female')->avg('annual_salary')}}	{{$boa_placement_info->whereIn('nature_of_employment', ['Self-placed', 'Placed by Anudip'])->avg('annual_salary')}}
	Average annual income of self-employed candidates	{{$boa_placement_info->where('gender', 'male')->where('nature_of_employment', 'Self-employed/Business')->avg('annual_salary')}}	{{$boa_placement_info->where('gender', 'female')->where('nature_of_employment', 'Self-employed/Business')->avg('annual_salary')}}	{{$boa_placement_info->where('nature_of_employment', 'Self-employed/Business')->avg('annual_salary')}}
	Average annual income across candidates	{{$boa_placement_info->where('gender', 'male')->avg('annual_salary')}}	{{$boa_placement_info->where('gender', 'female')->avg('annual_salary')}}	{{$boa_placement_info->avg('annual_salary')}}

Post-placement support	% candidates retained in employment 3-months post placement	@php $completed = count($studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('gender', 'male')->where('emp_three_months','y')); //$count = ($completed / $retained) * 100; if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('gender', 'female')->where('emp_three_months','y')); //$count = ($completed / $retained) * 100; if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('emp_three_months','y')); //$count = ($completed / $retained) * 100; if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}
	% candidates retained in employment 6-months post placement	@php $completed = count($studentDetails->where('gender', 'male')->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('gender', 'male')->where('emp_six_months','y')); if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('gender', 'female')->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('gender', 'female')->where('emp_six_months','y')); if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}	@php $completed = count($studentDetails->where('enroll_status','enrolled')->where('batch_status','complete')); $retained = count($boa_placement_info->where('emp_six_months','y')); //$count = ($completed / $retained) * 100; if($completed > 0 && $retained > 0) { $count = ( $retained / $completed) * 100; } else { $count = 0; } @endphp {{$count}}