Index: app/Http/Controllers/DestinationController.php =================================================================== --- app/Http/Controllers/DestinationController.php (revision c30fbbf27a9b3ab3595c7580b5e31bd77ed02ff4) +++ app/Http/Controllers/DestinationController.php (revision 2bae0729ebe0d522717fa0b505b381bb9eee648e) @@ -105,4 +105,17 @@ } + public function cheapActivitiesChart(): \Illuminate\Contracts\View\View + { + $data = DB::table('travel_sage.destinacii as d') + ->join('travel_sage.aktivnosti as a', 'd.iddest', '=', 'a.iddest') + ->select('d.imelokacija', + DB::raw('COUNT(CASE WHEN a.iznos < 500 THEN 1 END) * 100.0 / COUNT(*) as procent_cheap') + ) + ->groupBy('d.iddest', 'd.imelokacija') + ->orderByDesc('procent_cheap') + ->get(); + + return view('cheap-chart', compact('data')); + } Index: resources/views/cheap-chart.blade.php =================================================================== --- resources/views/cheap-chart.blade.php (revision 2bae0729ebe0d522717fa0b505b381bb9eee648e) +++ resources/views/cheap-chart.blade.php (revision 2bae0729ebe0d522717fa0b505b381bb9eee648e) @@ -0,0 +1,114 @@ + + + + + Процент на евтини активности + + + + +
+
+

Дестинации со најголем процент на достапни (евтини) активности

+

Ова е приказ на процентот евтини активности по дестинација. Графикот покажува колку од активностите во + одредена локација се достапни по најниски цени.

+
+ +
+ + + + Index: routes/web.php =================================================================== --- routes/web.php (revision c30fbbf27a9b3ab3595c7580b5e31bd77ed02ff4) +++ routes/web.php (revision 2bae0729ebe0d522717fa0b505b381bb9eee648e) @@ -30,4 +30,5 @@ Route::get('/explore', [DestinationController::class, 'explore'])->name('explore'); +Route::get('/cheap-chart', [DestinationController::class, 'cheapActivitiesChart'])->name('cheap.chart');