App\Models\Institution_class_subject

Complexity

Total Complexity

11

Size/Duplication

Total Lines	120
Duplicated Lines	0 %

Importance

Changes	1
Bugs	1	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	isDuplicated()	0	3	1
A	getStudentOptionalSubject()	0	17	3
A	getInstitutionClassSubjects()	0	5	1
A	institutionMandatorySubject()	0	5	1
A	institutionOptionalSubject()	0	5	1
A	boot()	0	5	1
A	institutionSubject()	0	3	1
A	getAllSubjects()	0	8	1
A	getMandatorySubjects()	0	11	1

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Webpatser\Uuid\Uuid;

class Institution_class_subject extends Base_Model  {

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'institution_class_subjects';

    /**
     * Attributes that should be mass-assignable.
     *
     * @var array
     */
    protected $fillable = ['status', 'institution_class_id', 'institution_subject_id', 'modified_user_id', 'modified', 'created_user_id', 'created'];

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = [];

    /**
     * The attributes that should be casted to native types.
     *
     * @var array
     */
    protected $casts = [];

    /**
     * The attributes that should be mutated to dates.
     *
     * @var array
     */
    protected $dates = ['modified', 'created'];

    public function institutionMandatorySubject(){
        return $this->belongsTo('App\Models\Institution_subject','institution_subject_id','id')
        ->with('institutionGradeSubject')
        ->whereHas('institutionGradeSubject', function ($query) {
                $query->where('auto_allocation',1);
        });
    }

    public function institutionOptionalSubject(){
        return $this->belongsTo('App\Models\Institution_subject','institution_subject_id','id')
        ->with('institutionGradeSubject')
        ->whereHas('institutionGradeSubject', function ($query) {
                $query->where('auto_allocation',0);
        });

    }

    public static function boot()
    {
        parent::boot();
        self::creating(function ($model) {
            $model->id = (string) Uuid::generate(4);
        });
    }

    public function institutionSubject(){
        return $this->belongsTo('App\Models\Institution_subject','institution_subject_id','id')
        ->with('institutionGradeSubject');
    }


    public static function getMandatorySubjects($institutionClass){
        $institutionGrade = Institution_class_grade::where('institution_class_id', '=', $institutionClass)->first();
        $mandatorySubject = Institution_class_subject::with(['institutionSubject'])
            ->whereHas('institutionSubject', function ($query) use ($institutionGrade) {
                $query->whereHas('institutionGradeSubject',function($query){
                    $query->where('auto_allocation',1);
                })->where('education_grade_id', $institutionGrade->education_grade_id);

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

            })
            ->where('institution_class_id', '=', $institutionClass)
            ->get()->toArray();
        return $mandatorySubject;
    }

    public static function getAllSubjects($institutionClass){
        $allSubjects = Institution_class_subject::with(['institutionSubject'])
        ->whereHas('institutionSubject', function ($query) use ($institutionClass) {
            $query->whereHas('institutionGradeSubject')->where('education_grade_id', $institutionClass['education_grade_id']);
        })
        ->where('institution_class_id', '=', $institutionClass['id'])
        ->get()->toArray();
        return $allSubjects;
    }

    public static function getStudentOptionalSubject($subjects, $student, $row, $institution) {

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

        $data = [];
        foreach ($subjects as $subject) {
            $subjectId = Institution_class_subject::with(['institutionSubject'])
                ->whereHas('institutionSubject', function ($query) use ($row, $subject, $student) {
                    $query->whereHas('institutionGradeSubject',function($query){
                        $query->where('auto_allocation',0);
                    })
                        ->where('name', '=', $row[$subject])
                        ->where('education_grade_id', '=', $student->education_grade_id);
                })
                ->where('institution_class_id', '=', $student->institution_class_id)
                ->get()->toArray();
            if (!empty($subjectId))
                $data[] = $subjectId[0];
        }
        return $data;
    }

    public function getInstitutionClassSubjects($academicPeriodId,$classIds){

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

        return self::query()
            ->whereIn('institution_class_id',$classIds)
            ->get()
            ->toArray();
    }

    public function isDuplicated($subject){
        return self::query()->where('institution_subject_id',$subject['institution_subject_id'])
            ->where('institution_class_id',$subject['institution_class_id'])->get()->toArray();
    }
}