Relationship laravel : count data

Model Category:

public function product()
{
return $this->hasMany(products::class);
}

Model product:

public function category()
{
return $this->belongsTo(Category::class);
}

I handle in controller:

$result = Category::select(['id', 'name'])
->with(['product:category_id, status'])
->where('order', 1)
->get();

Result when I print out raw data :

[
'id' => 1,
'name' => 'Hot'
'product' => [
'status' => 1,
'category_id' => 1
]
]
[
'id' => 2,
'name' => 'New'
'product' => [
'status' => 2,
'category_id' => 2
]
]
..........

I got the list of category id and name, and got the product data array based on relationship. In my product table, There is a status column with values ​​equal to 1,2,3.

Now I want to count how many status = 1 and how many status = [2, 3] through the product array I get using that relationship?



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

تعليقات

المشاركات الشائعة من هذه المدونة

How to Create Treeview with Bootstrap and jQuery

Api routes not found when hosted laravel application on server

How to Add Images to Dropdown List using jQuery