@if(count($students) >0)
@foreach($students as $key=>$row) @endforeach
Sl Student Information Education English Test Others Proposal Summary Status
{{$key+1}}
@if($row->student_details->nationality) Flag @endif
{{cn($row,'student_details.first_name','')}} {{cn($row,'student_details.last_name','')}}
Applied : {{utc_to_ltz($row->submitted_date, 'd M Y g:i A', local_tz($user))}}
{{cn($row,'institutes.institution','')}}
Passing Year : {{cn($row,'institutes.passing_year','N/A')}}
{{cn($row,'institutes.result','')}} (GPA)
{{cn($row,'scores.test_name','N/A')}} • {{cn($row,'scores.overall_score','')}}
@php $work_history_first =$row->work_experience_date()->whereNotNull('start_date')->oldest()->first(); $work_history_last =$row->work_experience_date()->latest()->first(); if($work_history_first && $work_history_last && $work_history_last->end_date){ $diff_in_days =diff_in_days($work_history_first->start_date,$work_history_last->end_date); }elseif($work_history_first){ $diff_in_days =diff_in_days($work_history_first->start_date, now()); }else{ $diff_in_days =0; } $years = ($diff_in_days / 365) ; $years = floor($years); $month = ($diff_in_days % 365) / 30.5; $month = floor($month); $days = ($diff_in_days % 365) % 30.5; @endphp
{{$years}} years
Pub : @if($row->student_details->is_publication==1) Yes @else No @endif
Con : @if($row->student_details->is_attended_conference==1) Yes @else No @endif
@php $hashids = new \Hashids\Hashids('application', 25); @endphp
{{cn($row,'proposal.title','')}}
{{cn($row,'proposal.methology','')}} @php $proposal =\DB::table('proposal')->where( 'student_id',$row->student_id )->first(); if(isset($proposal)){ $department =\DB::table('departments')->where( 'id',$proposal->department )->first(); } @endphp @if(isset($department)) . {{ $department->name }} @endif . {{cn($row,'proposal.status','')}}
@if($row->accepted_status==1 && $row->proposal_status ==1) @elseif($row->accepted_status==1 && $row->proposal_status ==2) @elseif($row->accepted_status==1 && $row->proposal_status ==3) @elseif($row->accepted_status==1 && $row->proposal_status ==4) @elseif($row->accepted_status==1 && $row->proposal_status ==5) @elseif($row->accepted_status==1 && $row->proposal_status ==6) @else @endif @if($row->proposal_status_date)
{{utc_to_ltz($row->proposal_status_date, 'd M Y g:i A', local_tz($user))}} @endif
{{-- {{ $students->appends(request()->query())->links('paginator') }} --}} @else
No data available.
@endif