<?php

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

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

class UserExperienceType extends Model
{

    public $table = 'user_experience_types';

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

    public $timestamps = false;


    /**
     * GetUserExperienceTypes function gets the experience types of a specified user
     * and return it.
     *
     * @param  int user_id
     * @return \App\Models\UserExperienceType
     */
    public static function getUserExperienceTypes($user_id)
    {
        return self::select('user_experience_types.*', 'experience_types.experience_type')
            ->join(
                'experience_types',
                'experience_types.id',
                '=',
                'user_experience_types.experience_type_id'
            )
            ->where('user_experience_types.user_id', '=', $user_id)->get();
    }
    //  end getUserExperienceTypes()
}
//  end class