ExperienceSkillsController::indexForApplicant() - Code Metrics - Inspection of "Merge pull request #5319 from GCTC-NTGC/release/v1..." - GCTC-NTGC/TalentCloud - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( b25be8...d8e2f1 )

by Tristan
created 2021-03-02 19:28 UTC
ExperienceSkillsController::indexForApplicant() A

↳ Parent: ExperienceSkillsController
Complexity

Conditions	1
Paths	1
Size

Total Lines	4
Code Lines	2
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
eloc	2
c	0
b	0
f	0
dl	0
loc	4
rs	10
cc	1
nc	1
nop	1
<?php
namespace App\Http\Controllers\Api;

use App\Http\Controllers\Controller;
use App\Http\Requests\BatchStoreExperienceSkill;
use App\Http\Requests\BatchUpdateExperienceSkill;
use App\Http\Requests\StoreExperienceSkill;
use App\Models\Applicant;
use App\Models\ExperienceSkill;
use App\Models\Experience;
use Illuminate\Http\Request;
use Illuminate\Http\Resources\Json\JsonResource;
use Illuminate\Support\Facades\DB;

class ExperienceSkillsController extends Controller
{
    public function indexForApplicant(Applicant $applicant)
    {
        $experienceSkills = $applicant->experienceSkillsQuery()->get();
        return JsonResource::collection($experienceSkills);
    }

    public function store(StoreExperienceSkill $request)
    {
        $validatedData = $request->validated();
        // Restore soft deleted experienceSkill if it exists, otherwise create a new one.
        $softDeletedExperienceSkill = ExperienceSkill::onlyTrashed()
            ->where([
            ['skill_id', $validatedData['skill_id']],
            ['experience_id', $validatedData['experience_id']],
            ['experience_type', $validatedData['experience_type']]
        ])->first();

        // Attach skill to applicant if not already attached.
        $experience = new Experience();
        $experienceInstance = $experience->getExperienceInstance($validatedData['experience_type'], $validatedData['experience_id']);
        $applicantInstance = $experience->getApplicantInstance($experienceInstance);
        if ($applicantInstance !== null) {
            $skillApplicantRelationshipExists = $applicantInstance->skills()
            ->where('skills.id', $validatedData['skill_id'])
            ->exists();
            if ($skillApplicantRelationshipExists !== true) {
                $applicantInstance->skills()->attach($validatedData['skill_id']);
            }
        }

        if ($softDeletedExperienceSkill) {
            if ($validatedData['justification'] !== null && $validatedData['justification'] !== '') {
                $softDeletedExperienceSkill->justification = $validatedData['justification'];
            }
            $softDeletedExperienceSkill->restore();
            $softDeletedExperienceSkill->save();
            return new JsonResource($softDeletedExperienceSkill->fresh());
        } else {
            $experienceSkill = new ExperienceSkill($validatedData);
            $experienceSkill->skill_id = $validatedData['skill_id'];
            $experienceSkill->experience_id = $validatedData['experience_id'];
            $experienceSkill->experience_type = $validatedData['experience_type'];
            $experienceSkill->justification = $validatedData['justification'];
            $experienceSkill->save();
            return new JsonResource($experienceSkill->fresh());
        }
    }

    public function update(Request $request, ExperienceSkill $experienceSkill)
    {
        $validatedData = $request->validate([
            'justification' => 'nullable|string',
        ]);
        $experienceSkill->fill($validatedData);
        $experienceSkill->save();
        return new JsonResource($experienceSkill->fresh());
    }

    public function destroy(ExperienceSkill $experienceSkill)
    {
        $experienceSkill->delete();
    }

    /**
     * Create many new ExperienceSkills at once.
     *
     * @param BatchStoreExperienceSkill $request
     * @return void
     */
    public function batchStore(BatchStoreExperienceSkill $request)
    {
        $validatedResult = $request->validated();
        $newExperienceSkills = collect($validatedResult);
        $newExperienceSkills = /** @scrutinizer ignore-call */ collect($validatedResult);
        $response = [];

        DB::transaction(function () use ($newExperienceSkills, &$response) {
            foreach ($newExperienceSkills as $newExperienceSkill) {
                // Restore soft deleted experienceSkill if it exists, otherwise create a new one.
                $softDeletedExperienceSkill = ExperienceSkill::withTrashed()
                    ->where([
                    ['skill_id', $newExperienceSkill['skill_id']],
                    ['experience_id', $newExperienceSkill['experience_id']],
                    ['experience_type', $newExperienceSkill['experience_type']]
                ])->first();
                if ($softDeletedExperienceSkill) {
                    $softDeletedExperienceSkill->restore();
                    if ($newExperienceSkill['justification'] !== null && $newExperienceSkill['justification'] !== '') {
                        $softDeletedExperienceSkill->justification = $newExperienceSkill['justification'];
                    }
                    $softDeletedExperienceSkill->save();
                    array_push($response, $softDeletedExperienceSkill);
                } else {
                    $experienceSkill = new ExperienceSkill($newExperienceSkill);
                    $experienceSkill->skill_id = $newExperienceSkill['skill_id'];
                    $experienceSkill->experience_id = $newExperienceSkill['experience_id'];
                    $experienceSkill->experience_type = $newExperienceSkill['experience_type'];
                    $experienceSkill->justification = $newExperienceSkill['justification'];
                    $experienceSkill->save();
                    $experienceSkill->fresh();
                    array_push($response, $experienceSkill);
                }

                // Attach skill to applicant if not already attached.
                $experience = new Experience();
                $experienceInstance = $experience->getExperienceInstance($newExperienceSkill['experience_type'], $newExperienceSkill['experience_id']);
                $applicantInstance = $experience->getApplicantInstance($experienceInstance);
                if ($applicantInstance !== null) {
                    $skillApplicantRelationshipExists = $applicantInstance->skills()
                    ->where('skills.id', $newExperienceSkill['skill_id'])
                    ->exists();
                    if (!$skillApplicantRelationshipExists) {
                        $applicantInstance->skills()->attach($newExperienceSkill['skill_id']);
                    }
                }
            }
        }, 3); // Retry transaction up to three times if deadlock occurs.

        return JsonResource::collection($response);
    }

    /**
     * Update many existing ExperienceSkills at once.
     *
     * @param BatchUpdateExperienceSkill $request
     * @return void
     */
    public function batchUpdate(BatchUpdateExperienceSkill $request)
    {
        $validatedResult = $request->validated();
        $inputData = collect($validatedResult);
        $inputData = /** @scrutinizer ignore-call */ collect($validatedResult);
        $experienceSkills = ExperienceSkill::whereIn('id', $inputData->pluck('id')->all())->get();

        DB::transaction(function () use ($experienceSkills, $inputData) {
            foreach ($experienceSkills as $experienceSkill) {
                $updatedExperienceSkill = $inputData->firstWhere('id', $experienceSkill->id);
                $experienceSkill->fill($updatedExperienceSkill);
                $experienceSkill->save();
            }
        }, 3); // Retry transaction up to three times if deadlock occurs.

        return JsonResource::collection($experienceSkills->fresh());
    }

    public function batchDestroy(Request $request)
    {
        $experienceSkillIds = $request->validate([
            '*.id' => 'required|exists:App\Models\ExperienceSkill,id',
        ]);
        $experienceSkills = ExperienceSkill::whereIn('id', $experienceSkillIds);
        foreach ($experienceSkills as $experienceSkill) {
            $this->authorize('delete', $experienceSkill);
        }
        $experienceSkills->delete();
        return response()->json(['success' => 'success'], 200);
        return /** @scrutinizer ignore-call */ response()->json(['success' => 'success'], 200);
    }
}

GCTC-NTGC / TalentCloud

Push — master ( b25be8...d8e2f1 )

ExperienceSkillsController::indexForApplicant() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
