| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/emaji/app/Http/Controllers/Admin/ |
Upload File : |
<?php
namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use App\Models\CredentialMapping;
use App\Models\Issuer;
use App\Models\Profession;
use App\Models\Qualification;
use Illuminate\Http\Request;
use Illuminate\Validation\Rule;
class CredentialMappingController extends Controller
{
/**
* Display qualifications with their credential mappings.
*/
public function index(Request $request)
{
$filter = $request->query('filter', 'all');
// Get summative qualification IDs from professions
$summativeQualIds = Profession::whereNotNull('summative_qualification_id')
->pluck('summative_qualification_id')
->unique();
// Build query for qualifications
$query = Qualification::with(['credentialMappings.issuer'])
->withCount('credentialMappings');
// Apply filter
switch ($filter) {
case 'summative':
$query->whereIn('id', $summativeQualIds);
break;
case 'esco':
$query->where('external_source', 'esco')
->orWhere('external_source', 'skillwallet');
break;
case 'language':
$query->where('type', Qualification::TYPE_LANGUAGE);
break;
default:
// All: summative + ESCO + languages
$query->where(function ($q) use ($summativeQualIds) {
$q->whereIn('id', $summativeQualIds)
->orWhere('external_source', 'esco')
->orWhere('external_source', 'skillwallet')
->orWhere('type', Qualification::TYPE_LANGUAGE);
});
}
$qualifications = $query->orderBy('title')->get();
// Add type labels for display
$qualifications->each(function ($qual) use ($summativeQualIds) {
if ($summativeQualIds->contains($qual->id)) {
$qual->type_label = 'Summative';
$qual->type_color = 'primary';
} elseif ($qual->type === Qualification::TYPE_LANGUAGE) {
$qual->type_label = 'Language';
$qual->type_color = 'info';
} else {
$qual->type_label = 'ESCO';
$qual->type_color = 'success';
}
});
return view('admin.credential-mappings.index', compact('qualifications', 'filter'));
}
/**
* Show form to create a new credential mapping.
*/
public function create(Request $request)
{
$qualificationId = $request->query('qualification_id');
$filter = $request->query('filter', 'all');
// Get summative qualification IDs
$summativeQualIds = Profession::whereNotNull('summative_qualification_id')
->pluck('summative_qualification_id')
->unique();
// Get qualifications for dropdown (summative + ESCO + languages)
$qualifications = Qualification::where(function ($q) use ($summativeQualIds) {
$q->whereIn('id', $summativeQualIds)
->orWhere('external_source', 'esco')
->orWhere('external_source', 'skillwallet')
->orWhere('type', Qualification::TYPE_LANGUAGE);
})
->orderBy('title')
->get();
// Group by type for the select
$groupedQualifications = [
'Summative Qualifications' => $qualifications->filter(fn($q) => $summativeQualIds->contains($q->id)),
'Languages' => $qualifications->filter(fn($q) => $q->type === Qualification::TYPE_LANGUAGE),
'ESCO Skills' => $qualifications->filter(fn($q) =>
!$summativeQualIds->contains($q->id) &&
$q->type !== Qualification::TYPE_LANGUAGE &&
in_array($q->external_source, ['esco', 'skillwallet'])
),
];
// Get all issuers for dropdown
$issuers = Issuer::orderBy('name')->get();
return view('admin.credential-mappings.create', compact(
'groupedQualifications',
'issuers',
'qualificationId',
'filter'
));
}
/**
* Store a new credential mapping.
*/
public function store(Request $request)
{
$validated = $request->validate([
'qualification_id' => ['required', 'exists:qualifications,id'],
'issuer_id' => ['required', 'exists:issuers,id'],
'achievement_id' => [
'required',
'string',
'max:500',
Rule::unique('credential_mappings', 'achievement_id')
->where('issuer_id', $request->issuer_id),
],
'level' => ['nullable', 'string', 'max:10', 'in:A1,A2,B1,B2,C1,C2'],
'valid_from' => ['nullable', 'date'],
'valid_to' => ['nullable', 'date', 'after_or_equal:valid_from'],
'notes' => ['nullable', 'string', 'max:1000'],
'redirect_filter' => ['nullable', 'string', 'in:all,summative,esco,language'],
], [
'achievement_id.unique' => 'This achievement ID is already mapped for this issuer.',
]);
$redirectFilter = $validated['redirect_filter'] ?? 'all';
unset($validated['redirect_filter']);
// Use achievement_id as credential_identifier for backwards compatibility
$validated['credential_identifier'] = $validated['achievement_id'];
CredentialMapping::create($validated);
return redirect()->route('admin.credential-mappings.index', ['filter' => $redirectFilter])
->with('success', 'Credential mapping created successfully.');
}
/**
* Delete a credential mapping.
*/
public function destroy(CredentialMapping $mapping)
{
$qualificationTitle = $mapping->qualification?->title ?? 'Unknown';
$mapping->delete();
return redirect()->route('admin.credential-mappings.index')
->with('success', "Credential mapping for '{$qualificationTitle}' deleted.");
}
}