@if(count($students) >0)
Sl | Student Information | Education | English Test | Others | Proposal Summary | Status |
---|---|---|---|---|---|---|
{{$key+1}} |
@if($row->student_details->nationality)
@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 |