User

User.php

<?php

namespace App;

use Illuminate\Support\Facades\DB;
use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];


    /**
     * savedNumbersGamesIds
     *
     * @param  mixed $gameAlias
     * @return object or null
     */
    public function savedNumbersGamesIds(string $gameAlias)
    {
        return DB::table("user_{$gameAlias}_draws")->select('id')->where('user_id', $this->id)->first();
    }

    public function savedGames(string $gameAlias)
    {
        return DB::table("user_{$gameAlias}_draws")
            ->where('user_id', $this->id)
            ->where('alias', $gameAlias)
            ->first();
    }

    public function megamillionsNumbers()
    {
        return $this->hasMany('App\UserMegamillionsDraw');
    }

    public function powerballNumbers()
    {
        return $this->hasMany('App\UserPowerballDraw');
    }

}