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

5 Free Black and White Social Media Icons Sets with CSS and HTML

How to Add Images to Dropdown List using jQuery