Bring Existing and Non-existent Records

Question

Bring Existing and Non-existent Records

Asked 8 years, 1 month ago

Viewed 51 times

1

I got the next thing:

$consulta   = Dealer::find(1);

No Model

# Serviços
public function dealer_servicos(){
    return $this->hasMany('App\DealerService', 'id_concessionaria');
}

So if I do:

@foreach($consulta->dealer_servicos as $value => $res)
   {!! $res->servico !!}
@endforeach

Brings me all the services that the dealership HAS.

It has as I use the same methodology to bring the services that the concessionaire HAS NOT ? That is, to simulate the LEFT OUTER JOIN.

I need all the records in the same query.

It has, if you create a table of all the services that the dealership should have and then select all those items and remove the ones that the dealership already has.

– Reginaldo Rigo

2016/05/25 at 12:23
That already exists, my son.

– Diego Souza

2016/05/25 at 12:27
1

Possible duplicate of How to get records from a table when there is no relationship with another table in Laravel?

– Wallace Maxters

2016/05/25 at 13:07

1 answer

Browser other questions tagged mysql laravel

You are not signed in. Login or sign up in order to post.

by Wallace Maxters • **102,340** points · Answer 1 · 2016-05-25T13:03:34+00:00

I’m realizing you’re wearing one hasMany from Dealer to Dealerservice. I believe you will probably have a relationship to Dealer inside DealerService.

So you can use the method whereDoesntHave to do this.

$dealer = Dealer::find(1);

$dealerServices = DealerService::whereDoesntHave('dealers', function ($query) use($dealer)
{
        $query->where(['id' => $dealer->id]);

})->get();

If you notice, you will notice that the small difference is that this query should be made "out of the relationship".

Expressing in words, the method whereDoesntHave is intended to make a "When Dealerservice has no relationship with Dealer id 1".