Relationship from query?

Hi there,

I've got this model method that I would like to convert into a proper relationship. Is that possible? Basically I want to convert the query into a HasOne...

    public function bestOffer()
    {
        return $this->hasMany(Offer::class)->orderBy('amount, 'desc')->limit(1);
    }

aurawindsurfing

6 years ago

Level 50

Hey @dermanomann

This does not really make sense. It obviously has many offers. You can delete all of the offers but one and just allow one, then turn your relationship into HasOne but is this really what you want?

public function offer()
    {
        return $this->hasOne(App\Offer);
    }

bobbybouwmann

6 years ago

Level 88

Yes you can, however you need to have a specific factor to select on

public function offer()
{
return $this->hasOne(App\Offer)->where('paid', 1);
}

Source: https://stackoverflow.com/questions/41673611/laravel-having-a-hasmany-as-well-as-a-hasone-relationship-on-the-same-mode

DerManoMann

6 years ago

Level 1

Yeah, that works. Cheers.

aurawindsurfing

6 years ago

Level 50

@BOBBYBOUWMANN - Oh wow! So it is bit like

 ->first();

Interesting!

bobbybouwmann

6 years ago

Level 88

@aurawindsurfing Yeah basically!

bobbybouwmann

6 years ago

Level 88

@dermanomann Which one works for you? :P

DerManoMann

6 years ago

Level 1

In the end I stuck with what I had - it works and is simple. Only thing that is annoying is to call ->get()->first(); when accessing it; ie: ->bestOffer()->get()->first() which doesn't look very nice.

Please or to participate in this conversation.