Edit File: FriendRequest.php
<?php namespace App\Models; use Illuminate\Database\Eloquent\Model; class FriendRequest extends Model { protected $fillable = ['user_id', 'friend_id', 'is_accepted']; public function sender() { return $this->belongsTo(User::class, 'user_id'); } public function receiver() { return $this->belongsTo(User::class, 'friend_id'); } // Scopes public function scopePending($q) { return $q->where('is_accepted', false); } public function scopeAccepted($q) { return $q->where('is_accepted', true); } public function scopeWhereFriend($query) { return $query->where(function ($subQuery) { $subQuery->where('user_id', auth()->id()) ->orWhere('friend_id', auth()->id()); })->where('is_accepted', true); } // Scopes }
Back to File Manager