Share Link via Laravel Raw

User.php

<?php

namespace App;

use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class User extends Authenticatable
{
    /**
     * 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',
    ];
    public function bookmarks()
    {
        return $this->hasMany(Bookmark::class);
    }

    public  static function allUserCategories(){
        return  $categories=DB::table('bookmarks')->select ('category')->distinct()->get();
    }
    public  static function allUserLink(){
        $bookmarks=DB::table('bookmarks')->where('user_id', Auth::user()->id)->get();

        return  $bookmarks;
    }
    public  static function userMessage(){
        return  $categories=DB::table('bookmarks')->select ('category')->distinct()->get();
    }
    public  static function userThumbnail(){
        return  $categories=DB::table('bookmarks')->select ('id')->distinct()->get();
    }
    public  static function userHistory(){
        return  $categories=DB::table('bookmarks')->select ('created_at')->distinct()->get();
    }
    public static function  updateUserThumbnail($column, $value){
        $user = Auth::user();
        $user->$column = $value;
        $user->save();
    }

}