| 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/Services/ |
Upload File : |
<?php
namespace App\Services;
use App\Models\Job;
use App\Models\Profession;
use App\Models\Training;
use Illuminate\Support\Collection;
class TrainingCatalogService
{
public function build(array $input): array
{
$limit = $input['limit'] ?? 200;
$includeDrafts = (bool) ($input['include_drafts'] ?? false);
$query = Training::with(['qualification', 'organization', 'languageModel'])
->orderBy('title');
if (!$includeDrafts) {
$query->where('status', 'published');
}
$requirementMap = null;
if (!empty($input['profession_uuid'])) {
$requirementMap = $this->professionRequirementMap($input['profession_uuid']);
$this->applyRequirementFilter($query, $requirementMap);
}
if (!empty($input['job_uuid'])) {
$requirementMap = $this->jobRequirementMap($input['job_uuid']);
$this->applyRequirementFilter($query, $requirementMap);
}
if (!empty($input['achievement_id'])) {
$achievementId = $input['achievement_id'];
$query->where(function ($subQuery) use ($achievementId) {
$subQuery->where('credential_identifier', $achievementId)
->orWhereHas('qualification', function ($qualQuery) use ($achievementId) {
$qualQuery->where('uuid', $achievementId);
});
});
}
$trainings = $query->limit($limit)->get();
return [
'trainings' => $trainings->map(function (Training $training) use ($requirementMap) {
$qualification = $training->qualification;
$requirementType = $this->resolveRequirementType($training, $requirementMap);
return [
'id' => $training->id,
'uuid' => $training->uuid,
'title' => $training->title,
'description' => $training->description,
'program_url' => $training->program_url,
'credential_identifier' => $training->credential_identifier,
'qualification' => $qualification ? [
'id' => $qualification->id,
'uuid' => $qualification->uuid,
'title' => $qualification->title,
'type' => $qualification->type,
] : null,
'organization' => $training->organization ? [
'id' => $training->organization->id,
'uuid' => $training->organization->uuid,
'name' => $training->organization->name,
] : null,
'language' => $training->languageModel ? [
'iso_639_1' => $training->languageModel->iso_639_1,
'name' => $training->languageModel->name,
] : null,
'is_digital' => (bool) $training->is_digital,
'is_free' => (bool) $training->is_free,
'price' => $training->price,
'currency' => $training->currency,
'status' => $training->status,
'requirement_type' => $requirementType,
];
})->values(),
];
}
private function professionRequirementMap(string $professionUuid): array
{
$profession = Profession::where('uuid', $professionUuid)
->with('qualificationRequirements.qualification')
->firstOrFail();
return $this->buildRequirementMap($profession->qualificationRequirements);
}
private function jobRequirementMap(string $jobUuid): array
{
$job = Job::where('uuid', $jobUuid)
->with('jobQualifications.qualification')
->firstOrFail();
return $this->buildRequirementMap($job->jobQualifications);
}
private function buildRequirementMap($requirements): array
{
$required = collect();
$optional = collect();
foreach ($requirements as $requirement) {
$qualification = $requirement->qualification;
if (!$qualification || !$qualification->uuid) {
continue;
}
$isRequired = is_null($requirement->required) ? true : (bool) $requirement->required;
if ($isRequired) {
$required->push($qualification->uuid);
} else {
$optional->push($qualification->uuid);
}
}
return [
'required' => $required->unique()->values(),
'optional' => $optional->unique()->values(),
];
}
private function applyRequirementFilter($query, array $requirementMap): void
{
$qualificationUuids = $requirementMap['required']
->merge($requirementMap['optional'])
->filter()
->unique()
->values();
if ($qualificationUuids->isEmpty()) {
return;
}
$query->where(function ($subQuery) use ($qualificationUuids) {
$subQuery->whereIn('credential_identifier', $qualificationUuids->all())
->orWhereHas('qualification', function ($qualQuery) use ($qualificationUuids) {
$qualQuery->whereIn('uuid', $qualificationUuids->all());
});
});
}
private function resolveRequirementType(Training $training, ?array $requirementMap): ?string
{
if (!$requirementMap) {
return null;
}
$qualificationUuid = $training->qualification?->uuid;
$credentialIdentifier = $training->credential_identifier;
if ($qualificationUuid && $requirementMap['required']->contains($qualificationUuid)) {
return 'required';
}
if ($credentialIdentifier && $requirementMap['required']->contains($credentialIdentifier)) {
return 'required';
}
if ($qualificationUuid && $requirementMap['optional']->contains($qualificationUuid)) {
return 'optional';
}
if ($credentialIdentifier && $requirementMap['optional']->contains($credentialIdentifier)) {
return 'optional';
}
return null;
}
}