<?php

/**
 * UserSubjectExpertiseModel class file
 *
 * PHP Version 7.2
 *
 * @category Model
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

namespace App\Models;
  
use Illuminate\Database\Eloquent\Model;
use DB;

/**
 * UserSubjectExpertiseModel class
 *
 * The class manage User Subject Expertise related queries
 *
 * @category UserSubjectExpertiseModel
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

class UserSubjectExpertise extends Model
{

    public $table = 'user_subject_expertises';

    public $fillable = [
        'user_id',
        'subject_id',
        'expertise_id',
    ];

    public $timestamps = false;


    /**
     * GetUserSubjectExpertise function gets the subject expertise of a
     * specified user and return it.
     *
     * @param  int user_id
     * @return \App\Models\UserSubjectExpertise
     */
    public static function getUserSubjectExpertise($user_id)
    {
        return self::select(
            'user_subject_expertises.*',
            'subjects.subject',
            'expertises.expertise_level'
        )->join(
            'subjects',
            'subjects.id',
            '=',
            'user_subject_expertises.subject_id'
        )->join(
            'expertises',
            'expertises.id',
            '=',
            'user_subject_expertises.expertise_id'
        )->where(
            'user_subject_expertises.user_id',
            $user_id
        )->get()->toArray();
    }
    //  end getUserSubjectExpertise()
}
//  end class