CODEWITHSUNDEEP
phpmysqllaraveleloquentview
Tudor Ciotlos
Tudor Ciotlos

Reputation: 1845

Using Laravels Eloquent with database views

I have two database tables, expenses and incomes and I created a MySQL view, transactions, which basically is an UNION between the two tables, selecting the fields I am interested in.

The transactions view contains the following columns:

I created an Eloquent Model for the view, called Transactions.

The problem is when I want to retrieve transactions based on certain criteria. E.g. I want to get all transactions for a User. Normally, if transactions was a table, I would define a foreign key relationship and I would simply call $user->hasMany('App\Models\Transaction').

Since foreign keys are not possible for views, I tried using the 'where' method: Transaction::where('user_id', $user->id). This query does not return anything, neither do any other queries I tested. The only method that returned data is Transaction::all(), but this doesn't help me very much.

What am I doing wrong?

Upvotes: 2

Views: 2532

Answers (1)

Jose Rojas
Jose Rojas

Reputation: 3520

For where statement in Eloquent you must to end up with get, try this:

$transactions = Transaction::where('user_id', $user->id)->get();

Upvotes: 3

Related Questions