Laravel Eloquent withSum() and withCount() Tutorial

Laravel Eloquent withSum() and withCount() Tutorial

Laravel eloquent query withSum and withCount of related table. In this example you will learn eloquent withcount and withsum().

Now, this tutorial will show you very easy example of how to use withSum() and withCount() with laravel relationship eloquent using Category and Product table.

As well as, you can use withSum() and withCount() with laravel 6, laravel 7 and laravel 8 version.

Laravel Eloquent withsum and withcount with relationships tutorial

Category Model:

First of all, create category model and add the following code into it:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

<?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);       }   }

Product Model:

Now, create product model and add the following code into it:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

<?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 relationship with withSum() Example:

You can use withSum() eloquent in laravel as follow:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

<?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);       }   }

Result:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Array   (       [0] => Array           (               [id] => 1               [name] => Mobile               [products_sum_price] => 330           )       [1] => Array           (               [id] => 2               [name] => Laptop               [products_sum_price] => 410           )   )

Laravel relationship with withCount() Example:

You can use withCount() eloquent in laravel as follow:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

<?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);       }   }

Result:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Array   (       [0] => Array           (               [id] => 1               [name] => Mobile               [products_count] => 3           )       [1] => Array           (               [id] => 2               [name] => Laptop               [products_count] => 2           )   )

Read More

Laravel 8 Find Nearest Location By Latitude and Longitude

Laravel 8 Find Nearest Location By Latitude and Longitude

Laravel 8 – find nearest location by latitude and longitude. In this tutorial you will learn How to find nearest location using latitude and longitude in laravel.

Sometimes, you may find the nearest location using latitude and longitude in laravel 8,7,6 app . So, this tutorial will help you step by step to find nearest location using your current latitude and longitude in laravel 8 app.

As well as, fine neareby place using latitude and longitude query in laravel eloquent. you can use the following example for get nearest geolocation by mysql radius query in laravel 5, laravel 6, laravel 7 and laravel 8.

How to find nearest location using latitude and longitude in laravel

• Step 1 – Install Laravel 8 App
• Step 2 – Connecting App to Database
• Step 3 – Add Route
• Step 4 – Generate Controller by Command
• Step 5 – Run Development Server
• Step 6 – Test This App

Step 1 – Install Laravel 8 App

First of all, Execute the following command on the terminal to install/download laravel 8 application in your system(server):

composer create-project --prefer-dist laravel/laravel blog

Step 2 – Connecting App to Database

After that, open “.env” file and update the database name, username and password in the env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

Recommended:-Laravel 8 Auto Load More Data On Page Scroll

Step 3 – Add Route

In this step, add routes in the web.php file. Go to app/routes/web.php file and following routes in web.php file:

use App\Http\Controllers\LocationController;
Route::get('near-places', [LocationController::class, 'index']);

Step 4 – Generate Controller by Command

In this step, execute the following command on terminal to create a controller name GoogleController. So you need to use the below command and create Controller :

php artisan make:controller LocationController

After successfully create controller go to app/controllers/LocationController.php and update the following code :

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

<?php   namespace App\Http\Controllers;   use Illuminate\Http\Request;   use DB;   class LocationController extends Controller {     // ---------------- [ Load View ] ----------------     public function index(Request $request) {                   $lat = YOUR_CURRENT_LATTITUDE;         $lon = YOUR_CURRENT_LONGITUDE;                      $data = DB::table("users")             ->select("users.id"                 ,DB::raw("6371 * acos(cos(radians(" . $lat . "))                 * cos(radians(users.lat))                 * cos(radians(users.lon) - radians(" . $lon . "))                 + sin(radians(" .$lat. "))                 * sin(radians(users.lat))) AS distance"))                 ->groupBy("users.id")                 ->get();         dd($data);     } }

Recommended:- Laravel 8 Livewire Load More OnScroll Tutorial Example

Step 5 – Run Development Server

In this step, execute the following command on the terminal to start development server. Use the php artisan serve command and start your server :

 php artisan serve
 If you want to run the project diffrent port so use this below command 
 php artisan serve --port=8080  

Step 6 – Test This App

Open your browser and hit the following url on it:

 http://localhost:8000/near-places

Read More