<?php

/**
 * UserSkillModel 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;

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

class UserSkill extends Model
{

    public $table = 'user_skills';

    public $fillable = [
        'user_id',
        'language_id',
        'proficiency_id',
    ];

    public $timestamps = false;


    /**
     * GetUserSkills function gets the skills of a specified user
     * and return it.
     *
     * @param  int user_id
     * @return \App\Models\UserSkill
     */
    public static function getUserSkills($user_id)
    {
        return self::select('user_skills.*', 'languages.language_l', 'proficiencys.proficiency')
            ->join('languages', 'languages.id', '=', 'user_skills.language_id')
            ->join('proficiencys', 'proficiencys.id', '=', 'user_skills.proficiency_id')
            ->where('user_skills.user_id', $user_id)->get()->toArray();
    }
    //  end getUserSkills()
}
//  end class