Level 60
Sale::with('customer')->where('user_id', 2)->get();
Feb 21, 2021
5
Level 1
How to get All Consumer Data ?
This is my Sales Table.
id | sales | consumer_id | user_id
1 | 23 | 1 | 2
2 | 43 | 2 | 2
3 | 38 | 2 | 2
4 | 198 | 1 | 3
This is my Consumers Table
id | name |
1 | arju |
2 | kara |
3 | pemb |
4 | dran |
This is my Sales model look like
public function consumer()
{
return $this->belongsTo('App\Consumer', 'consumer_id');
}
Suppose My User Id is 2.I want to get all consumer where my user_id is 2 in sales table.If my user_id is 1 the i need all consumer from sale table where user_id 1.So how should do it
Level 1
I tried like this.It worked.
$sales=Sale::with('customer')->where('user_id', 2)->groupBy('consumer_id')->get();
$consumers=[];
foreach($sales as $sale){
array_push($consumers,$sale->consumer);
}
Level 75
Have you ever read a documentation?
1 like
Level 1
Yes I tried this.but i donot know whtether this method is good or not
$sales=Sale::with('customer')->where('user_id', 2)->groupBy('consumer_id')->get();
$consumers=[];
foreach($sales as $sale){
array_push($consumers,$sale->consumer);
}
Level 75
$customers = Customer::whereHas('sales', function ($query) {
$query->where('user_id', 2);
})->get();
Please or to participate in this conversation.