Laravel Eloquent withCount() and withSum() Example

Laravel withCount and sumSum eloquent example; Through this tutorial, i am going to show you how to use withSum and withCount eloquent with relationship in laravel apps.

Let’s create category and product models and create relationship between these models; is as follows:

Create eloquent relationship in category model; as follows:

<?php
 
   
 
namespace App\Models;
 
   
 
use Illuminate\Database\Eloquent\Factories\HasFactory;
 
use Illuminate\Database\Eloquent\Model;
 
   
 
class Category extends Model
 
{
 
    use HasFactory;
 
   
 
    /**
 
     * Get the comments for the blog post.
 
     */
 
    public function products()
 
    {
 
        return $this->hasMany(Product::class);
 
    }
 
}

Then create product model and add the following code into it; is as follows:

<?php
 
   
 
namespace App\Models;
 
  
 
use Illuminate\Database\Eloquent\Factories\HasFactory;
 
use Illuminate\Database\Eloquent\Model;
 
   
 
class Product extends Model
 
{
 
    use HasFactory;
 
   
 
    protected $fillable = [
 
        'name', 'price'
 
    ];
 
}

Laravel withSum() with Relationship Example

Let’s take example using withsum() with relationship eloquent in laravel apps; is as follows:

<?php
 
   
 
namespace App\Http\Controllers;
 
   
 
use App\Models\Category;
 
   
 
class MyController extends Controller
 
{
 
    /**
 
     * Write code on Method
 
     *
 
     * @return response()
 
     */
 
    public function index()
 
    {
 
        $categories = Category::select("id", "name")
 
                        ->withSum('products', 'price')
 
                        ->get()
 
                        ->toArray();
 
  
 
        dd($categories);
 
    }
 
}

Laravel withCount() with Relationship Example

Let’s take example using withCount() with relationship eloquent in laravel apps; is as follows:

<?php
 
   
 
namespace App\Http\Controllers;
 
   
 
use App\Models\Category;
 
   
 
class MyController extends Controller
 
{
 
    /**
 
     * Write code on Method
 
     *
 
     * @return response()
 
     */
 
    public function index()
 
    {
 
        $categories = Category::select("id", "name")
 
                        ->withCount('products')
 
                        ->get()
 
                        ->toArray();
 
  
 
        dd($categories);
 
    }
 
}

Recommended Laravel Tutorials

Leave a Comment