I am fetching products and in the response, i want the category it belongs to to appear in the response. When i log the response, it looks like the below
Response
[{"items_receive":"280","category":null},`{"items_receive":"100","category":null}]`
Product.php
public function category()
{
return $this->belongsTo(Category::class);
}
public function getSummary()
{
return Product::with('category')->selectRaw('SUM(items_receive) as
items_total)
->where('user_id',Auth::user()->id)
->groupBy('category_id')
->get();
}
Category.php
public function products()
{
return $this->hasMany(Product::class);
}
Controller.php
public function index(Product $product)
{
$product->getSummary();
}
question from:
https://stackoverflow.com/questions/66050665/how-to-get-category-a-product-belongs-to-laravel-6 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…