Example\Models\Course

Complexity

Total Complexity

3

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	studentsThatFinished()	0	20	1
A	studentsWhoPrefer()	0	13	1
A	__construct()	0	3	1

<?php

namespace Example\Models;

use CoffeeCode\DataLayer\DataLayer;

class Course extends DataLayer
{
    /**
     * Course constructor.
     */
    public function __construct()
    {
        parent::__construct("courses", ["name"], "id", false);
    }

    /**
     * @return array|null
     */
    public function studentsWhoPrefer(): ?array
    {
        $students = new Student();
        return $this
            ->select("*, courses.name as course_name")
            ->join(
                $students, 
                'courses.id', '=', 'students.preferred_course')
            ->where(
                'courses.id = :id', 
                "id={$this->id}")

The property id does not exist on Example\Models\Course. Since you implemented __get, consider adding a @property annotation.

            ->limit(5)
            ->fetch(true);
    }

    /**
     * @return array|null
     */
    public function studentsThatFinished(): ?array
    {
        $students = new Student();
        $studentCourse = new StudentCourse();

        return $this
            ->select()
            ->join(
                $studentCourse,
                "courses.id", "=", "student_course.idcourse"
            )
            ->join(
                $students,
                "students.id", "=", "student_course.idstudent"
            )
            ->where(
                "courses.id = :id",
                "id={$this->id}"

The property id does not exist on Example\Models\Course. Since you implemented __get, consider adding a @property annotation.

            )
            ->fetch(true);
    }
}