I have an appointments
table and an appointment_members
table and my users need to be able to get a collection of appointments
by searching with a "member_id"
, which could be a Person
, Incident
or CustomerID
. The appointment_members
table has member_id
and appointment_id
columns, so the member_type
(also a column) is irrelevant. This all set up by a previous dev and what is missing are the relationships on the Eloquent models. I'm just creating a simple GET route that needs to return any/all appointments by that member_id. Each row has one appointment, so if I were to pass in a member_id
that returned 10 results, some could have appts and others not, but at the end of the day I just need a collection of appts that are related to that member_id
. Here's a screenshot of the appointment_members
table:
If I create a simple hasOne
relationship to appointments on appointment_members:
public function appointments()
{
return $this->HasOne(Appointment::class, 'id', 'appointment_id');
}
I can get a collection of appointment_members
with it's respective appointment
, but not sure how I boil it down to just getting the appointments
.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire