Laravel hasOne relationship where condition same table field

I have 5 tables retailers, doctors, softwareproviders, members and contactpersons. contactpersons table associated with other 4 tables using type and refid.

retailers

id	name	contactno	mem_type
2	karthik	855550	1

members

id	name	contactno
6	naveen	855550

contactpersons

id	type	refid	name
1	1	2	ruban
1	2	6	aron

type 1 - retailers, 2 - members, 3 - doctors, 4 - softwareproviders

In contactpersons model how to make hasone relationship with other tables

public function retailersinfo(){

  return $this->hasOne('App\Retailers','id','refid');
}

we need to add type condition (where condition =1).

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2IT27WS
via IFTTT