App\Models\Institution_class

Complexity

Total Complexity

4

Size/Duplication

Total Lines	72
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

4 Methods

Rating	Name	Duplication	Size	Complexity
A	institution()	0	2	1
A	class_teacher()	0	2	1
A	getShiftClasses()	0	9	1
A	getGradeClasses()	0	8	1

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Institution_class extends Base_Model  {

    public const CREATED_AT = 'created';
    public const UPDATED_AT = 'modified';



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

    /**
     * Attributes that should be mass-assignable.
     *
     * @var array
     */
    protected $fillable = ['name', 'no_of_students', 'class_number', 'total_male_students', 'total_female_students', 'staff_id', 'secondary_staff_id', 'institution_shift_id', 'institution_id', 'academic_period_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 = [];

//    protected

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

    public function class_teacher(){
        return $this->belongsTo('App\Models\Security_group_user','staff_id','security_user_id');
    }

    public function institution(){
        return $this->belongsTo('App\Models\Institution','institution_id');
    }


    public function getShiftClasses($shift){
        return self::query()
            ->select('institution_classes.id','institution_classes.institution_id','institution_classes.institution_shift_id',
                'institution_classes.name','institution_classes.no_of_students','institution_classes.class_number','institution_class_grades.education_grade_id')
            ->where('institution_shift_id',$shift)
//            ->where('academic_period_id',$academicPeriod)
            ->join('institution_class_grades','institution_classes.id','institution_class_grades.institution_class_id')
            ->groupBy('institution_classes.id')
            ->get()->toArray();
    }

    public static function getGradeClasses($education_grade_id,$institution_id){
        return self::query()
        ->select('institution_classes.id','institution_classes.institution_id','institution_classes.institution_shift_id',
            'institution_classes.name','institution_classes.no_of_students','institution_classes.class_number','institution_class_grades.education_grade_id')
        ->where('institution_class_grades.education_grade_id',$education_grade_id)
        ->where('institution_classes.institution_id',$institution_id)
        ->join('institution_class_grades','institution_classes.id','institution_class_grades.institution_class_id')
        ->get()->toArray();
    }

}