App\Http\Controllers\Admin\EnrollmentController

Complexity

Total Complexity

10

Size/Duplication

Total Lines	124
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	import()	0	3	1
A	export()	0	19	1
B	storeImport()	0	70	7

<?php

namespace App\Http\Controllers\Admin;

use App\Judite\Models\User;
use App\Judite\Models\Shift;
use App\Judite\Models\Course;
use App\Judite\Models\Student;
use App\Judite\Models\Enrollment;
use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;
use Maatwebsite\Excel\Facades\Excel;
use App\Exceptions\InvalidFieldValueException;
use App\Exceptions\InvalidImportFileException;
use App\Http\Requests\Enrollment\ImportRequest;

class EnrollmentController extends Controller
{
    /**
     * Create a new controller instance.
     */
    public function __construct()
    {
        $this->middleware('auth');
        $this->middleware('can.admin');
    }

    /**
     * Exports the list of students enrolled in each course.
     *
     * @return \Illuminate\Http\Response
     */
    public function export()
    {
        // Get the list of students enrolled on each course
        $enrollments = DB::transaction(function () {
            $enrollments = Enrollment::with('student', 'course')
                ->get()
                ->sortByDesc('courses.name');

            return $enrollments;
        });

        // Export to CSV
        $result = Excel::create('enrollments', function ($excel) use ($enrollments) {
            $excel->sheet('Enrollments', function ($sheet) use ($enrollments) {
                $sheet->loadView('enrollments.export', compact('enrollments'));
            });
        });

        return $result->export('csv');
    }

    /**
     * Store the enrollments imported in the request.
     *
     * @param \App\Http\Requests\Enrollment\ImportRequest $request
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function storeImport(ImportRequest $request)
    {
        try {
            $file = $request->enrollments;
            $path = $file->path();

            Excel::load($path, function ($reader) {
                DB::transaction(function () use ($reader) {
                    // Loop for all the rows of the table
                    $reader->each(function ($row, $index) {
                        $index += 2; // Skip header

                        // Get the models of the given ids
                        // Check if the given student number exists
                        $student = Student::whereNumber($row->student_id)->first();
                        if ($student === null) {
                            $user = User::make([
                                'name' => $row->student_name ?? $row->student_id,
                                'email' => strtolower($row->student_email ?? $row->student_id.'@alunos.uminho.pt'),
                                'password' => bcrypt(str_random(8)),
                            ]);
                            $user->verification_token = str_random(32);
                            $user->save();
                            $student = $user->student()->create(['student_number' => strtolower($row->student_id)]);
                        }

                        // Check if the given course id exists
                        $course = Course::whereCode($row->course_id)->first();
                        if ($course === null) {
                            $exception = new InvalidFieldValueException();
                            $exception->setField('Course ID', $row->course_id, "The course {$row->course_id} does not exist. (at line {$index})");
                            throw $exception;
                        }

                        // Check if the enrollment exists
                        $enrollment = Enrollment::where([
                            'course_id' => $course->id,
                            'student_id' => $student->id,
                        ])->first();

                        if ($enrollment === null) {
                            $enrollment = $student->enroll($course);
                        }

                        // Check if the given shift tag exists in the associated course
                        if ($row->shift !== null) {
                            $shift = $course->getShiftByTag($row->shift);

                            if ($shift === null) {
                                $shift = Shift::make(['tag' => $row->shift]);
                                $course->addShift($shift);
                            }

                            $enrollment->shift()->associate($shift);
                        } else {
                            $enrollment->shift()->dissociate();
                        }

                        // Add the shift to the enrollment
                        $enrollment->save();
                    });
                });
            });

            flash('The enrollments file was successfully imported.')->success();
        } catch (InvalidImportFileException $e) {
            flash($e->getMessage())->error();
        }

        return redirect()->route('enrollments.import');
    }

    /**
     * Show the form for importing enrollments.
     *
     * @return \Illuminate\View\View
     */
    public function import()
    {
        return view('enrollments.import');
    }
}