| Conditions | 1 | 
| Paths | 1 | 
| Total Lines | 12 | 
| Code Lines | 7 | 
| Lines | 0 | 
| Ratio | 0 % | 
| Changes | 1 | ||
| Bugs | 0 | Features | 0 | 
| 1 | <?php  | 
            ||
| 15 | public function index()  | 
            ||
| 16 |     { | 
            ||
| 17 |         $countries = Country::whereHas('spots', function ($query) { | 
            ||
| 18 |             $query->where('is_approved', true); | 
            ||
| 19 | })  | 
            ||
| 20 |         ->withCount(['spots' => function ($query) { | 
            ||
| 21 |             $query->where('is_approved', true); | 
            ||
| 22 | }])  | 
            ||
| 23 |         ->orderBy('name_pt', 'ASC') | 
            ||
| 24 | ->get();  | 
            ||
| 25 | |||
| 26 |         return view('countries.index', compact('countries')); | 
            ||
| 27 | }  | 
            ||
| 49 |