Laravel, check if data/record exists in any related table

Question

Maybe someone will help me.

DB structure:

users
id, name

storage_items
id, name, user_id

archive_objects
id, name, user_id

In User model i have:

public function storageItem()
{
    return $this->hasOne(StorageItem::class);
}

public function archiveObject()
{
    return $this->hasOne(ArchiveObject::class);
}

I need check if data/record exists in any related table.

Something like this:

if (User::has('storageItem')->orHas('archiveObject')->find(1)->count()) {
    //exists
}

This works:

if (User::has('storageItem')->find(1)->count()) {
    //exists
}

and this too:

if (User::has('archiveObject')->find(1)->count()) {
    //exists
}

but that are two queries, i need one beautiful query :)

As a result, i need that when i click button "Delete user", before deleting, i check if data/record exists in any related table, if true, it will show warning message about deleting related data/record (from storage_items or archive_objects), else it will delete just user (from users).

you can use trigger from the backend to do that...

Eko Junaidi Salam
– Eko Junaidi Salam

2016-03-22 00:17:24 +00:00
Commented Mar 22, 2016 at 0:17 — Eko Junaidi Salam
– Eko Junaidi Salam, Commented Mar 22, 2016 at 0:17

repkins · Accepted Answer · 2016-03-23 12:45:13Z

1

Try this:

User::where(function($query) { 
    $query->has('storageItem')
        ->orHas('archiveObject');
})->find(1);

answered Mar 23, 2016 at 12:45

repkins

285 bronze badges

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

1 Comment

Globax Over a year ago

Woohoo, thank you dude, it works perfectly! And ir more better than my own solution :D $users = User::has('storageItem')->orHas('archiveObject')->get()->pluck('id')->toArray(); if (in_array(2, $users )) { //exists }

Qazi · Accepted Answer · 2016-03-22 03:43:19Z

0

try this has and orWhereHas

eg:

if (User::has('archiveObject')-orWhereHas('storageItem')->find(1)->count()) {
    //exists
}

answered Mar 22, 2016 at 3:43

Qazi

5,1458 gold badges45 silver badges63 bronze badges

Comments

Globax · Accepted Answer · 2016-03-22 22:01:55Z

0

I had tried another code

User::whereHas('archiveObject', function() {})->orWhereHas('storageItem', function() {})->find(2)

but it is similar with this

User::has('archiveObject')->orHas('storageItem')->find(2)

i have this result

{
    "id": 1,
    "username": "admin",
    "created_at": "2016-02-05 11:45:12",
    "updated_at": "2016-03-20 15:12:15"
}

instead of this

{}

Result with "id": 1, i should have with this

User::has('archiveObject')->orHas('storageItem')->find(1)

answered Mar 22, 2016 at 22:01

Globax

231 silver badge4 bronze badges

Collectives™ on Stack Overflow

Laravel, check if data/record exists in any related table

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related