| No | Kode | Nama | Kontak | Posisi | Status | Tgl Apply | Pendidikan | Pengalaman | Gaji Harapan |
|---|---|---|---|---|---|---|---|---|---|
| {{ $index + 1 }} | {{ $candidate->candidate_code }} |
{{ $candidate->personalData->full_name ?? 'N/A' }} {{ $candidate->personalData->birth_place ?? '' }} @if($candidate->personalData->birth_date) ({{ \Carbon\Carbon::parse($candidate->personalData->birth_date)->age }} thn) @endif |
📧 {{ Str::limit($candidate->personalData->email ?? 'N/A', 20) }}
📱 {{ $candidate->personalData->phone_number ?? 'N/A' }}
|
{{ Str::limit($candidate->position_applied, 25) }} | {{ ucfirst($candidate->application_status) }} | {{ $candidate->created_at->format('d/m/y') }} |
@php
$latestEducation = $candidate->formalEducation->sortByDesc('end_year')->first();
@endphp
@if($latestEducation)
{{ $latestEducation->education_level }} {{ Str::limit($latestEducation->institution_name, 20) }} {{ $latestEducation->major ? Str::limit($latestEducation->major, 15) : '' }} @else - @endif |
@php
$latestWork = $candidate->workExperiences->sortByDesc('end_year')->first();
$totalYears = 0;
foreach($candidate->workExperiences as $exp) {
$start = $exp->start_year;
$end = $exp->end_year ?? date('Y');
$totalYears += ($end - $start);
}
@endphp
@if($latestWork)
{{ Str::limit($latestWork->position, 20) }} {{ Str::limit($latestWork->company_name, 20) }} Total: {{ $totalYears }} thn @else Fresh Graduate @endif |
@if($candidate->expected_salary) {{ number_format($candidate->expected_salary / 1000000, 1) }}jt @else Nego @endif |