Laravel - Find value is available in relationship

Question

I need to check if the given user_id, location_id, and sub_location_id is belongs to the user on user_locations table. Based on this I need to give login permission to the user for the specific site.

Currently, I have the written code like below. But, don't know how to check the condition.

User::select('id')->with('user_locations:location')->where('user_id',$request->user_id)->get();

I need to put these conditions

is user found and active?
if user active. Then find the given sub location is tagged for the user.
if sub location found, then is the sub location active?

Below are the table structure.

Users Table

id (PK, AI),
user_id (UQ),
password,
status, ("Y"=> Active, "N"=> Inactive)
//other fields

public function user_locations(): HasMany
{
  return $this->hasMany(user_locations::class);
}

User_Locations Table

id (PK, AI),
user_id (FK),
location_id (FK),
sub_location_id (FK),
status ("Y"=> Active, "N"=> Inactive)

public function user(): BelongsTo
{
  return $this->belongsTo(User::class);
}

You need to get the model of user with user_locations or just check if there is user with these conditions or not? — EchoAro
– EchoAro, Commented Aug 10, 2022 at 12:12
I just need to check if there is a user with the corresponding location or not, to allow the user to move forward to the login process. — Lokesh M
– Lokesh M, Commented Aug 10, 2022 at 12:14
And how many levels can be in locations? I mean each location has one sub_location or sub_location can be its own sub_location too? — EchoAro
– EchoAro, Commented Aug 10, 2022 at 12:18

EchoAro · Accepted Answer · 2022-08-10 12:24:40Z

1

I think you need to check relation existing

You can try this way for find user model

User::select('id')
        ->with('user_locations:location')
        ->where('user_id',$request->user_id)
        ->where('status','Y')
        ->whereHas('user_locations', function ($q) use ($request) {
            $q->where('user_locations.user_id', $request->user_id);
            $q->where('user_locations.status', 'Y');
        })
        ->get();

If you want just to check user existing you can try this

       User::where('user_id',$request->user_id)
        ->where('status','Y')
        ->whereHas('user_locations', function ($q) use ($request) {
            $q->where('user_locations.user_id', $request->user_id);
            $q->where('user_locations.status', 'Y');
        })
        ->exists();

You can read mode about this here

answered Aug 10, 2022 at 12:24

EchoAro

8381 gold badge8 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lokesh M Over a year ago

$q->where('user_locations.user_id', $request->user_id); is not working because in user_locations table we have mapped only user's auto increment id (int). But, we are getting the user_id (string) from the user.

Lokesh M Over a year ago

I have tried like this but it's not working. $user = User::where('user_id',$request->user_id) ->where('status','Y') ->whereHas('user_locations', function ($q) use ($request) { $q->where('user_locations.user_id', 'users.id'); $q->where('user_locations.location_master', $request->location); $q->where('user_locations.status', 'Y'); })->exists();

Lokesh M Over a year ago

I just removed $q->where('user_locations.user_id', $request->user_id); and it's working fine. Thank you so much.

Collectives™ on Stack Overflow

Laravel - Find value is available in relationship

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related