Level 56
How do you differentiate between admin and agent?
Is there a column on the user table? If so how is it called?
Sep 25, 2022
4
Level 2
Gate and multi role
I have two users admin and agent and there is a transaction table.In admin panel i want to show all transactions while in agent panel i want to show only those transactions made by logged in agent. I am restricting agent by not showing him that row but on the other hand pagination is working. Like if 100 rows of transactions in which agents transactions are 5 admin see these hundred rows but agent will also see the pagination.
Level 2
@rodrigo.pedra by role. I have a column in users table whose value are "admin" and "agent"
Level 56
Try this:
Route::get('/transactions', function (Request $request) {
$transactions = Transaction::query()
->when(
$request->user()->role === 'agent',
fn ($query) => $query->where('user_id', $request->user()->id),
)
->latest()
->paginate();
return view('transactions', [
'transactions' => $transactions,
]);
});
The ->when() will only execute the callback if the first parameter evaluates to true.
Level 2
@rodrigo.pedra It works. <3
1 like
Please or to participate in this conversation.