App\Models\Enrollment

Complexity

Total Complexity

46

Size/Duplication

Total Lines	289
Duplicated Lines	0 %

Importance

Changes	4
Bugs	2	Features	0

36 Methods

Rating	Name	Duplication	Size	Complexity
A	course()	0	3	1
A	result()	0	5	1
A	payments()	0	3	1
A	scopePending()	0	6	1
A	scopePeriod()	0	4	1
A	enrollmentStatus()	0	3	1
A	changeCourse()	0	4	1
A	markAsUnpaid()	0	9	2
A	user()	0	3	1
A	boot()	0	11	2
A	scopeWithoutChildren()	0	11	1
A	scopeNoresult()	0	3	1
A	scopeParent()	0	5	1
A	scopeReal()	0	5	1
A	isPaid()	0	3	1
A	student()	0	3	1
A	comments()	0	3	1
A	markAsPaid()	0	9	2
A	childrenEnrollments()	0	3	1
A	getChildrenAttribute()	0	3	1
A	getStudentAgeAttribute()	0	3	1
A	getPriceAttribute()	0	10	2
A	getAttendanceRatioAttribute()	0	8	2
A	cancel()	0	23	5
A	getBalanceAttribute()	0	8	2
A	skill_evaluations()	0	3	1
A	getChildrenCountAttribute()	0	3	1
A	getProductCodeAttribute()	0	3	1
A	getStudentBirthdateAttribute()	0	3	1
A	getAbsenceCountAttribute()	0	6	1
A	getResultNameAttribute()	0	3	1
A	getStudentEmailAttribute()	0	3	1
A	getStatusAttribute()	0	3	1
A	getDateAttribute()	0	3	1
A	getStudentNameAttribute()	0	3	1
A	grades()	0	3	1

<?php

namespace App\Models;

use App\Models\Skills\SkillEvaluation;
use Backpack\CRUD\app\Models\Traits\CrudTrait;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Facades\App;
use Spatie\Activitylog\Traits\LogsActivity;

class Enrollment extends Model
{
    use CrudTrait;

The trait Backpack\CRUD\app\Models\Traits\CrudTrait requires some properties which are not provided by App\Models\Enrollment: $fakeColumns, $identifiableAttribute, $Type

    use SoftDeletes;
    use LogsActivity;

    protected $guarded = ['id'];
    protected $appends = ['result_name', 'product_code', 'price'];
    protected $with = ['student', 'course', 'childrenEnrollments', 'payments'];
    protected static $logUnguarded = true;

    protected static function boot()
    {
        parent::boot();

        // when creating a new enrollment, also add past attendance
        static::created(function (self $enrollment) {
            $events = $enrollment->course->events->where('start', '<', (new Carbon())->toDateString());
            foreach ($events as $event) {
                $event->attendance()->create([
                    'student_id' => $enrollment->student_id,
                    'attendance_type_id' => 3,
                ]);
            }
        });
    }

    /**
     * return all pending enrollments, without the child enrollments.
     */
    public function scopeParent($query)
    {
        return $query
        ->where('parent_id', null)
        ->get();
    }

    public function scopeReal($query)
    {
        return $query
            ->whereDoesntHave('childrenEnrollments')
            ->get();
    }

    public function scopeWithoutChildren($query)
    {
        return $query
            ->where(function ($query) {
                $query->whereDoesntHave('childrenEnrollments')
                ->where('parent_id', null);
            })
            ->orWhere(function ($query) {
                $query->where('parent_id', null);
            })
            ->get();
    }

    /** only pending enrollments */
    public function scopePending($query)
    {
        return $query
            ->where('status_id', 1)
            ->where('parent_id', null)
            ->get();
    }

    public function scopeNoresult($query)
    {
        return $query->doesntHave('result');
    }

    public function scopePeriod(Builder $query, $period)
    {
        return $query->whereHas('course', function ($q) use ($period) {
            $q->where('period_id', $period);
        });
    }

    /** FUNCTIONS */
    public function changeCourse(Course $newCourse)
    {
        $this->course_id = $newCourse->id;
        $this->save();
    }

    public function markAsPaid()
    {
        $this->status_id = 2;
        $this->save();

        // also mark children as paid
        foreach ($this->childrenEnrollments as $child) {
            $child->status_id = 2;
            $child->save();
        }
    }

    public function markAsUnpaid()
    {
        $this->status_id = 1;
        $this->save();

        // also mark children as unpaid
        foreach ($this->childrenEnrollments as $child) {
            $child->status_id = 1;
            $child->save();
        }
    }

    public function isPaid()
    {
        return $this->status_id == 2;
    }

    /** RELATIONS */
    public function student()
    {
        return $this->belongsTo(Student::class, 'student_id');
    }

    public function user()
    {
        return $this->student->user();
    }

    public function course()
    {
        return $this->belongsTo(Course::class, 'course_id');
    }

    public function payments()
    {
        return $this->hasMany(Payment::class);
    }

    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }

    public function result()
    {
        return $this->hasOne(Result::class)
            ->with('result_name')
            ->with('comments');
    }

    public function childrenEnrollments()
    {
        return $this->hasMany(self::class, 'parent_id');
    }

    public function enrollmentStatus()
    {
        return $this->belongsTo(EnrollmentStatusType::class, 'status_id');
    }

    public function grades()
    {
        return $this->hasMany(Grade::class);
    }

    /* Accessors */

    public function getResultNameAttribute()
    {
        return $this->result->result_name->name ?? '-';
    }

    public function skill_evaluations()
    {
        return $this->hasMany(SkillEvaluation::class);
    }

    public function getStudentNameAttribute()
    {
        return $this->student['name'];
    }

    /*     public function getStudentIdAttribute()
        {
            return $this->student['id'];
        } */

    public function getStudentAgeAttribute()
    {
        return $this->student->age;

The property age does not seem to exist on App\Models\Student. Are you sure there is no database migration missing?

    }

    public function getStudentBirthdateAttribute()
    {
        return $this->student->birthdate;
    }

    public function getStudentEmailAttribute()
    {
        return $this->student['email'];
    }

    public function getDateAttribute()
    {
        return Carbon::parse($this->created_at, 'UTC')->locale(App::getLocale())->isoFormat('LL');
    }

    public function getChildrenCountAttribute()
    {
        return self::where('parent_id', $this->id)->count();
    }

    public function getChildrenAttribute()
    {
        return self::where('parent_id', $this->id)->with('course')->get();
    }

    public function getStatusAttribute()
    {
        return $this->enrollmentStatus->name;
    }

    public function getProductCodeAttribute()
    {
        return $this->course->rhythm->product_code ?? ' ';
    }

    public function getAttendanceRatioAttribute()
    {
        $courseEventIds = $this->course->events->pluck('id');
        $attendances = $this->student->attendance()->with('event')->get()->whereIn('event_id', $courseEventIds);
        if ($attendances->count() > 0) {
            return round(100 * (($attendances->where('attendance_type_id', 1)->count() + $attendances->where('attendance_type_id', 2)->count() * 0.75) / $attendances->count()));
        } else {
            return;
        }
    }

    public function getAbsenceCountAttribute()
    {
        $courseEventIds = $this->course->events->pluck('id');
        $attendances = $this->student->attendance()->with('event')->get()->whereIn('event_id', $courseEventIds);

        return $attendances->where('attendance_type_id', 3)->count() + $attendances->where('attendance_type_id', 4)->count();
    }

    public function getPriceAttribute()
    {
        // if the enrollment has a price, we always consider it first
        if ($this->total_price !== null) {
            return $this->total_price;
        } else {
            // otherwise retrieve the default price category for the student
            $price_category = $this->student->price_category ?? 'priceA';

The property price_category does not seem to exist on App\Models\Student. Are you sure there is no database migration missing?

            return $this->course->$price_category ?? 0;
        }
    }

    public function getBalanceAttribute()
    {
        $balance = $this->price;
        foreach ($this->payments as $payment) {
            $balance -= $payment->value;
        }

        return $balance;
    }

    public function cancel()
    {
        // if the enrollment had children, delete them entirely
        if ($this->childrenEnrollments && ($this->childrenEnrollments->count() > 0)) {
            foreach ($this->childrenEnrollments as $child) {
                $child->delete();
            }
        }

        // delete attendance records related to the enrollment
        $attendances = $this->course->attendance->where('student_id', $this->student->id);
        Attendance::destroy($attendances->map(function ($item, $key) {

The parameter $key is not used and could be removed.

            return $item->id;
        }));

        foreach ($this->course->children as $child) {
            $attendances = $child->attendance->where('student_id', $this->student->id);
            Attendance::destroy($attendances->map(function ($item, $key) {

The parameter $key is not used and could be removed.

                return $item->id;
            }));
        }

        $this->delete();
    }
}