<?php

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

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

class UserExperience extends Model
{

    public $table = 'user_experiences';

    public $fillable = [
        'user_id',
        'experience_id',
    ];

    public $timestamps = false;


    /**
     * GetUserExperience function gets the experience of specified user
     * and return it.
     *
     * @param  int user_id
     * @return \App\Models\UserExperience
     */
    public static function getUserExperience($user_id)
    {
        return self::select('user_experiences.*', 'experiences.experience')->join(
            'experiences',
            'experiences.id',
            '=',
            'user_experiences.experience_id'
        )
            ->where('user_experiences.user_id', '=', $user_id)->first();
    }
    //  end getUserExperience()
}
//  end class