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

تعليقات

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

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

How to Create Treeview with Bootstrap and jQuery

How to Change Apache and MySQL Port Number in XAMPP Localhost