douwaif22244 2018-07-18 22:49
浏览 25
已采纳

laravel使用具有特定角色的get()

6 projects and there is user model and this is a method in user model

public function setPasswordAttribute($password)
{
    $this->attributes['password'] = bcrypt($password);
}

Everything is working fine when I am using get() in laravel like this

User::get();

It returns all users. My question is, is there a way to write method in the model that can return users with conditions, not all users, like this

public function setRoleToGetData()
{
  $user  = Auth::user()->getSex // getSex is method in the model 
  if($user == 1)
    return users in the whole program like this 
    User::where('user_sex','=',1)->get();
  else
    // return the reverse 
}

i dont want to write where('user_sex','=',1) in every time i want to get users thanks

  • 写回答

1条回答 默认 最新

  • douye2036 2018-07-18 22:57
    关注

    You are probably looking for scopes.

    https://laravel.com/docs/5.6/eloquent#local-scopes

    From the docs:

    Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application

    Example:

    public function scopePopular($query)
    {
        return $query->where('votes', '>', 100);
    }
    

    Then use as

    SomeModel::popular()->get();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 java报错:使用mybatis plus查询一个只返回一条数据的sql,却报错返回了1000多条
  • ¥15 Python报错怎么解决
  • ¥15 simulink如何调用DLL文件
  • ¥15 关于用pyqt6的项目开发该怎么把前段后端和业务层分离
  • ¥30 线性代数的问题,我真的忘了线代的知识了
  • ¥15 有谁能够把华为matebook e 高通骁龙850刷成安卓系统,或者安装安卓系统
  • ¥188 需要修改一个工具,懂得汇编的人来。
  • ¥15 livecharts wpf piechart 属性
  • ¥20 数学建模,尽量用matlab回答,论文格式
  • ¥15 昨天挂载了一下u盘,然后拔了