I am trying to get record with where condition in laravel elquent query. Here is my relationship method.
public function OrdersReferrals(){
return $this->hasMany('App\Order','referred_by');
}
public function referrals()
{
return $this->hasMany('App\User','referred_by')->with('referrals','OrdersReferrals');
}
Here Is My controller Query
$userData=User::with('adminuserrreferrals')->where('id',$id)->where('payout_status','pending')->get();
Problem Is that this query, Where condition is work for only user table. while I need this ->where('payout_status','pending') for Orders Table .
Let me know if any possible solution PLease
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire