protarr

How to query the Email model with specific fields AND the name of the user (in another parent table), using one call to Model::where() like this:

$emails = Email::where('user_id', 1)->get(['id','user_id','email']); <- HOW TO ADD THE USER NAME TO THIS LIST?

I know I can retrieve the user name of individual records (using "belongsTo", mentioned below) like $emails[0]->user->name, but I am suposing that exists some way to do this without a loop.

Parent table:

user
    id
    name

Child table:

email
    id
    user_id
    email

On my Email model I have:

    public function user()
    {
        return $this->belongsTo('App\Models\User',  'user_id', 'id');
    }

Hi. I am using Laravel 8 with Jetstream (god, why) for the first time.

When session is lost and I authenticate again, I return to the route I were before the session was lost. What I want is to avoid this behaviour. After session lost and log in again, I need to be sent to a specific route (like '/', or HOME, for instance).

@michaloravec

I implemented your solution and it worked flawlessly. I will left here how I made it in case someone in the future needs it:

First I discovered that Laravel already have an event called Illuminate\Auth\Events\Login. This event only happens when the user successfully authenticates.

So I create an event listener like this:

$ php artisan make:listener UserLoggedInListener --event='Illuminate\Auth\Events\Login'

Then I registered the event and my listener on EventServiceProvider.php like this:

    protected $listen = [
        Login::class => [
            UserLoggedInListener::class,
        ]
    ];

And inside my listener UserLoggedInListener.php I put:

public function handle(Login $event)
{
    session(['my_variable' => 'my_value']);
}

Now I can access this variable anywhere the session is available: session()->get('my_variable').

Thank you very much.

Thank you. I forgot to mention I am using the new laravel jetstream for authentication. Description updated.

The session example isn't important. I just need to run something ONCE, just after the user logs in.

Laravel 8, using Jetstream

I need to store a variable into the session after the user logs in. The point is: How to do this once?

Currently I am setting this variable value when the user hits the home page, but when the user return to home page the variable is set again, overriding previous value. I can't put this in config because it's a calculated value.

I don't want to check if this variable exist in session every time the user hits the home page (the first route).

I want to avoid accessing the tables directly using the DB class.

Let's supose I have these 2 related tables.

user
  id
  name
  age
  
email
  id
  user_id
  email

I created a hasMany emails method on User model, so I can get the emails like: User::find(1)->emails. That's ok and it's working.

But what I really need in this example is to get some users and his respective emails in a plain collection or array, and I need the users that haven't emails too.

I could do User::where('age', 30)->get(), iterate over it and get the User::emails, but this approach isn't nice.

How to achieve this result, using Eloquent models, in a single list, like:

select 
  u.name,
  u.id as user_id,
  e.id as email_id,
  e.email
from user u
left join email e on u.id = e.user_id and u.age = 30

name   user_id    email_id    email
Jack   1          1           [email protected]
Jack   1          2           [email protected]
Anne   2          3           [email protected]
John   3          null        null
Karen  4          null        null

So, in this example, I need all users with age 30, even if they haven't any emails. And I need the result in a plain list as this query would return me.

Thank you.

I am using Laravel 8.

Suppose we have 3 tables. table_a, table_b and table_c.

A simple 3 levels of tables. Table A has many B and table B has many C.

table_a
  id
  name
  
table_b
  id
  table_a_id
  name
  
table_c
  id
  table_b_id
  name

I configured in TableA model a method tableB pointing to TableB model using hasMany. It works. I can retrieve the table_b records just using TableA::find(1)->tableB .

I configured in TableB model a method tableC pointing to TableC model using hasMany. It works. I can retrieve the table_c records just using TableB::find(1)->tableC .

Can I retrieve in one step all table_c records related to a table_a record ?

e.g.

Something like TableA::find(1)->... (i need the related records in table_c)

Thank you.