Топ 5 дестинации со најмногу настани

Index: app/Http/Controllers/DestinationController.php =================================================================== --- app/Http/Controllers/DestinationController.php (revision 76c01d0688a7f7f821dd459c3352d4b0db619f13) +++ app/Http/Controllers/DestinationController.php (revision ed3943e86fa2ef819299ad98978fe91616c3ee28) @@ -8,4 +8,5 @@ use Illuminate\Foundation\Application; use Illuminate\Http\Request; +use Illuminate\Support\Facades\DB; class DestinationController extends Controller @@ -42,4 +43,27 @@ } + public function topLocationsCarousel(): View|Factory|Application + { + $locations = DB::table('travel_sage.destinacii')->pluck('imelokacija'); + + $locationCounts = []; + + foreach ($locations as $location) { + $lowerLocation = mb_strtolower($location, 'UTF-8'); + + $count = DB::table('travel_sage.nastani') + ->whereRaw('LOWER(naziv) LIKE ?', ['%' . $lowerLocation . '%']) + ->orWhereRaw('LOWER(detali) LIKE ?', ['%' . $lowerLocation . '%']) + ->count(); + + $locationCounts[$location] = $count; + } + + arsort($locationCounts); + + $top5Locations = collect(array_slice($locationCounts, 0, 5, true)); + + return view('index', ['topLocations' => $top5Locations]); + } public function search(Request $request): Application|Factory|View Index: resources/views/carousel.blade.php =================================================================== --- resources/views/carousel.blade.php (revision ed3943e86fa2ef819299ad98978fe91616c3ee28) +++ resources/views/carousel.blade.php (revision ed3943e86fa2ef819299ad98978fe91616c3ee28) @@ -0,0 +1,150 @@ + + + + + + Топ 5 дестинации со најмногу настани + + + + + +

Топ 5 дестинации со најмногу организирани настани

+ +

+ @php + $locations = collect($topLocations); + $chunks = $locations->chunk(3); + $lastChunk = $chunks->last(); + + if ($lastChunk->count() < 3) { + $needed = 3 - $lastChunk->count(); + + $existingLocations = $lastChunk->keys()->all(); + $remainingLocations = $locations->reject(function($value, $key) use ($existingLocations) { + return in_array($key, $existingLocations); + }); + + if ($remainingLocations->count() < $needed) { + $toAdd = $remainingLocations; + } else { + $toAdd = $remainingLocations->random($needed); + } + + $lastChunk = $lastChunk->union($toAdd); + + $chunks->pop(); + $chunks->push($lastChunk); + } + @endphp + +

+ @foreach($chunks as $chunk) +

+ @foreach($chunk as $location => $count) +

+ {{ $location }} +

Број на настани: {{ $count }}

+ + Повеќе + +

+ @endforeach +

+ + + + Index: resources/views/index.blade.php =================================================================== --- resources/views/index.blade.php (revision 76c01d0688a7f7f821dd459c3352d4b0db619f13) +++ resources/views/index.blade.php (revision ed3943e86fa2ef819299ad98978fe91616c3ee28) @@ -125,4 +125,5 @@ +@include('carousel', ['topLocations' => $topLocations]) @include('footer') Index: routes/web.php =================================================================== --- routes/web.php (revision 76c01d0688a7f7f821dd459c3352d4b0db619f13) +++ routes/web.php (revision ed3943e86fa2ef819299ad98978fe91616c3ee28) @@ -14,7 +14,5 @@ use \App\Http\Controllers\WeatherConditionController; -Route::get('/', function () { - return view('index'); -}); +Route::get('/', [DestinationController::class, 'topLocationsCarousel'])->name('home'); Route::get('/login', function () { @@ -30,5 +28,4 @@ Route::get('/destinations/{imelokacija}/travel-packages', [PackageController::class, 'travelPackages'])->name('travelPackages.index'); Route::get('/weather/{imelokacija}', [WeatherConditionController::class, 'show'])->name('weather.show'); - Route::get('/login', [AuthController::class, 'showLoginForm'])->name('login');