doucan4815 2018-02-02 15:49
浏览 918
已采纳

Laravel _如何将查询注入Auth :: user()

I'm making a blog with laravel. When I look into user authentication, I have a few issues here. I have 2 tables, one is users: id, name, ... the other is role: user_id, privilege .. I need to check whether a user is admin or not, I will need a function like isAdmin() or a $isAdmin attribute. This is my function placed in the app/providers/AuthServiceProvider.php:

private static $isAdmin;

public static function isAdmin() {
    if (isset(self::$isAdmin)) {
        return self::$isAdmin;
    }
    $user_privilege = DB::table('role')
        ->select('privilege')
        ->where([
            ['privilege', '=', 'admin'],
            ['user_id', '=', Auth::user()->id],
        ])
        ->get()
        ->first();
    self::$isAdmin = isset($user_privilege->privilege);
    return self::$isAdmin;
}

This code works fine, but this will require two queries to the database to check the user's admin rights. So I wanted to find a way to inject a query into Auth :: user () so that only one query would retrieve all the stuff I wanted. I'm a beginner with laravel. Can you help me?

  • 写回答

2条回答 默认 最新

  • doushi3803 2018-02-02 15:59
    关注

    I assume that user can have only one role. You can create isAdmin() method in the User model:

    public function isAdmin()
    {
        return auth()->user()->role->privilege === 'admin';
    }
    

    Define the relationship if you didn't do that yet:

    public function role()
    {
        return $this->hasOne(Role::class);
    }
    

    Then use it with auth()->user()->isAdmin().

    If a user can have many roles:

    public function isAdmin()
    {
        auth()->user()->loadMissing('roles');
        return auth()->user()->roles->contains('admin');
    }
    

    And the relationship:

    public function roles()
    {
        return $this->hasMany(Role::class);
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 主要进行描述非满管状态下,管路的摩阻系数是怎么变化的,在管路长度方向上是怎么分布的(标签-matlab)
  • ¥15 multisim设计求解如图
  • ¥15 动态多目标优化,求解定义的问题的POF和POS公式
  • ¥30 实验 :UML2.0 行为建模
  • ¥15 设计一种优化调度算法并结合论文中的案例给出调度计划
  • ¥15 py文件打包exe报错TypeError:expected str,bytes or os.PathLike object,not_io.BytesIO
  • ¥15 Java编写学籍信息管理系统
  • ¥15 IPXE网刻客户机找不到服务端
  • ¥15 小贝360-4 配二个 华772S 设置WⅰFi5G 连接
  • ¥15 vs2022的QT报错,好像是缺少winextras