Laravel Eloquent How can I select and manipulate rows in pivot table?

Question

I have three database tables called user(id,name), group(id,name) and user_group(user_id, group_id,valid_before) with relations many to many.

class User extends Model
{
    protected $table = 'user';

    public function groups()
    {
    return $this->belongsToMany(Group::class, 'user_group')
        ->withPivot('valid_before');
    } 
}

class Group extends Model
{
    protected $table = 'group';

    public $timestamps = false;

    public function user()
    {
        return $this->belongsToMany(User::class, 'user_group');
    }
}

User can be member of some group until time moment 'valid_before'. If 'valid_before' is less than current time, the user must be excluded from the group and corresponding row in pivot table must be deleted. How can I select in pivot table rows where strtotime($validBefore) < strtotime($date) and then delete them using Eloquent?

phpdroid phpdroid · Accepted Answer · 2019-09-20T07:39:54

use cronjob then simply use detach($group_id) like below:-

$user = User::find($id);
if(time_exceeded($user->id))  //checks if user should stay in a group
$user->groups()->detach($group_id);

use this link for refernce

Laravel Eloquent How can I select and manipulate rows in pivot table?

1 Answers