@php $certificateRequests = $certificateRequests ?? collect(); $certificateRequestsByCourse = $certificateRequests->groupBy('staff_scheduled_id'); $paidCourses = $courses->filter(fn($item) => $item->finanaceStudentInvoice?->payment_status === 'paid'); $paidCertificateCourses = $paidCourses ->pluck('course') ->filter() ->unique('id') ->values(); @endphp

Certificate Details

Available certificates, completed hours, and hard copy requests.

@forelse ($paidCourses as $item) @php $course = $item->course; $scheduledSessions = $course?->scheduled_sessions ?? collect(); $courseCertificateRequests = $course ? $certificateRequestsByCourse->get($course->id, collect()) : collect(); $totalHours = $scheduledSessions->sum(function ($session) { $start = \Carbon\Carbon::createFromFormat('H:i:s', $session->start_time); $end = \Carbon\Carbon::createFromFormat('H:i:s', $session->end_time); return abs($end->diffInMinutes($start) / 60); }); @endphp @if ($course && $course->trackLevel) @endif @empty @endforelse

Level	Hours	Action
{{ $course->trackLevel->name_en ?? 'N/A' }}	{{ $totalHours ?? '0' }} Hours	{{-- Download Certificate --}} @if ($courseCertificateRequests->isNotEmpty()) @endif
No certificate details available.

@foreach ($paidCertificateCourses as $course) @if ($course && $course->trackLevel) @endif @endforeach @foreach ($paidCertificateCourses as $historyCourse) @php $courseCertificateRequests = $historyCourse ? $certificateRequestsByCourse->get($historyCourse->id, collect()) : collect(); @endphp @if ($historyCourse)

@if ($courseCertificateRequests->isEmpty())

No certificate requests found.

@else

@foreach ($courseCertificateRequests as $certificateRequest) @php $invoice = $certificateRequest->invoice; $transaction = $invoice?->lastTransaction; $course = $certificateRequest->staffScheduled; $demoSchedule = $certificateRequest->demoSchedule; $demoReport = $demoSchedule?->teacherFeedback?->result; $demoResult = $demoReport; $demoResultPillClass = match ($demoResult) { 'pass', 'passed', 'success', 'accepted' => 'ui-pill--success', 'fail', 'failed', 'rejected' => 'ui-pill--danger', default => 'ui-pill--neutral', }; $certificateStatus = strtolower((string) ($certificateRequest->status ?? 'pending')); $softCertificateFile = $certificateRequest->soft_certificate_file; $canViewSoftCertificate = strtolower((string) $certificateRequest->delivery_type) === 'soft' && in_array($certificateStatus, ['accepted', 'approved', 'done', 'completed', 'closed'], true) && filled($softCertificateFile); $softCertificateUrl = $canViewSoftCertificate ? (\Illuminate\Support\Str::startsWith($softCertificateFile, ['http://', 'https://']) ? $softCertificateFile : rtrim((string) config('app.Retention_URL'), '/') . '/' . ltrim($softCertificateFile, '/')) : null; @endphp @endforeach

#	Certificate	Preferred Exam Date	Name	Course	Delivery	Shipping Address	Price	Payment	Status	Demo Status	Demo Result	Soft Certificate	Requested At
{{ $certificateRequest->id }}	{{ ucfirst($certificateRequest->certificate_type ?? 'N/A') }}	@if (strtolower((string) $certificateRequest->certificate_type) === 'pearson') {{ $certificateRequest->preferred_exam_date ? \Carbon\Carbon::parse($certificateRequest->preferred_exam_date)->format('d M Y') : 'N/A' }} @else N/A @endif	{{ $certificateRequest->certificate_name ?? 'N/A' }}	{{ $course?->track?->name_en ?? $course?->course_name_en ?? 'N/A' }} @if ($course?->trackLevel) {{ $course->trackLevel->name_en }} @endif	{{ ucfirst($certificateRequest->delivery_type ?? 'N/A') }}	@if (strtolower((string) $certificateRequest->delivery_type) === 'hard') {{ $certificateRequest->shipping_address ?? 'N/A' }} @else N/A @endif	${{ number_format((float) ($certificateRequest->certificate_price ?? $invoice?->net_price ?? 0), 2) }}	{{ ucfirst($invoice?->payment_type ?? $transaction?->payment_type ?? 'N/A') }} {{ ucfirst(str_replace('_', ' ', $invoice?->payment_status ?? $transaction?->status ?? 'pending')) }}	{{ ucfirst(str_replace('_', ' ', $certificateRequest->status ?? 'pending')) }}	@if ($demoSchedule) {{ ucfirst(str_replace('_', ' ', $demoSchedule->status ?? 'scheduled')) }} @else Not booked @endif	@if ($demoReport != '' \|\| !is_null($demoReport)) {{ $demoReport }} @elseif ($demoSchedule) Waiting result @else N/A @endif	@if ($softCertificateUrl) Download @elseif (strtolower((string) $certificateRequest->delivery_type) === 'soft') Available after acceptance @else N/A @endif	{{ optional($certificateRequest->created_at)->format('d M Y h:i A') ?? 'N/A' }}

@foreach ($courseCertificateRequests as $certificateRequest) @php $invoice = $certificateRequest->invoice; $transaction = $invoice?->lastTransaction; $course = $certificateRequest->staffScheduled; $demoSchedule = $certificateRequest->demoSchedule; $demoReport = $demoSchedule?->teacherFeedback?->result; $demoResult = $demoReport; $demoTester = $demoReport?->tester ?? $demoSchedule?->staff; $demoTesterName = $demoTester ? ($demoTester->full_name ?: trim(($demoTester->first_name ?? '') . ' ' . ($demoTester->last_name ?? ''))) : null; $demoResultPillClass = match ($demoResult) { 'pass', 'passed', 'success', 'accepted' => 'ui-pill--success', 'fail', 'failed', 'rejected' => 'ui-pill--danger', default => 'ui-pill--neutral', }; $certificateStatus = strtolower((string) ($certificateRequest->status ?? 'pending')); $softCertificateFile = $certificateRequest->soft_certificate_file; $canViewSoftCertificate = strtolower((string) $certificateRequest->delivery_type) === 'soft' && in_array($certificateStatus, ['accepted', 'approved', 'done', 'completed', 'closed'], true) && filled($softCertificateFile); $softCertificateUrl = $canViewSoftCertificate ? (\Illuminate\Support\Str::startsWith($softCertificateFile, ['http://', 'https://']) ? $softCertificateFile : rtrim((string) config('app.Retention_URL'), '/') . '/' . ltrim($softCertificateFile, '/')) : null; @endphp

Request #{{ $certificateRequest->id }}

{{ ucfirst($certificateRequest->certificate_type ?? 'Certificate') }} certificate request details

{{ ucfirst(str_replace('_', ' ', $certificateRequest->status ?? 'pending')) }}

Certificate Name {{ $certificateRequest->certificate_name ?? 'N/A' }}

Certificate Type {{ ucfirst($certificateRequest->certificate_type ?? 'N/A') }}

Delivery Type {{ ucfirst($certificateRequest->delivery_type ?? 'N/A') }}

@if (strtolower((string) $certificateRequest->certificate_type) === 'pearson')

Preferred Exam Date {{ $certificateRequest->preferred_exam_date ? \Carbon\Carbon::parse($certificateRequest->preferred_exam_date)->format('d M Y') : 'N/A' }}

@endif

Shipping Address @if (strtolower((string) $certificateRequest->delivery_type) === 'hard') {{ $certificateRequest->shipping_address ?? 'N/A' }} @else N/A @endif

Soft Certificate File @if ($softCertificateUrl) Download soft certificate @elseif (strtolower((string) $certificateRequest->delivery_type) === 'soft') Available after request acceptance @else N/A @endif

Course {{ $course?->track?->name_en ?? $course?->course_name_en ?? 'N/A' }}

Level {{ $course?->trackLevel?->name_en ?? 'N/A' }}

Demo Status {{ $demoSchedule ? ucfirst(str_replace('_', ' ', $demoSchedule->status ?? 'scheduled')) : 'Not booked' }}

Demo Result @if ($demoReport != '' || !is_null($demoReport)) {{ ucfirst(str_replace('_', ' ', $demoReport)) }} @elseif ($demoSchedule) Waiting result @else N/A @endif

Demo Date {{ $demoSchedule?->start_date ? \Carbon\Carbon::parse($demoSchedule->start_date)->format('d M Y') : 'N/A' }}

Demo Course {{ $demoSchedule?->track?->name_en ?? $demoSchedule?->course_name_en ?? 'N/A' }}

Demo Level {{ $demoSchedule?->trackLevel?->name_en ?? 'N/A' }}

Demo Tester {{ $demoTesterName ?: 'N/A' }}

@if ($demoSchedule?->meeting_url)

Demo Meeting Link Open meeting link

@endif

Price ${{ number_format((float) ($certificateRequest->certificate_price ?? $invoice?->net_price ?? 0), 2) }}

Invoice Number {{ $invoice?->invoice_number ?? 'N/A' }}

Payment Status {{ ucfirst(str_replace('_', ' ', $invoice?->payment_status ?? 'pending')) }}

Payment Method {{ ucfirst($invoice?->payment_type ?? $transaction?->payment_type ?? 'N/A') }}

Transaction Status {{ ucfirst(str_replace('_', ' ', $transaction?->status ?? 'pending')) }}

Country {{ $certificateRequest->country ?? 'N/A' }}

Email {{ $certificateRequest->email ?? 'N/A' }}

Request Note {{ $certificateRequest->request_note ?? 'N/A' }}

@if ($transaction?->payment_url)

Payment Link Open payment link

@endif

@endforeach

@endif

@endif @endforeach

ID	Type	Teacher's Name	Completed Date	Completed Time
{{ $item->course->id ?? 'N/A' }}	{{ $item->course->track_type_id ?? 'N/A' }}	{{ optional($item->course?->teacher)->full_name ?? 'N/A' }}	{{ \Carbon\Carbon::parse($item->course?->start_date)->format('d-M-Y') ?? 'N/A' }}	{{ \Carbon\Carbon::parse($item->course?->start_date)->format('h:i A') ?? 'N/A' }}
No feedback found.