HomeController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Route;
use Illuminate\Support\Str;
use Illuminate\View\View;
use SlProjects\LaravelRequestLogger\app\Models\LoggedRequest;

class HomeController extends Controller
{
    public function index(Request $request): View
    {
        $request->validate([
            'start_date' => 'nullable|date',
            'end_date' => 'nullable|date',
        ]);

        $routes = Route::getRoutes()->getRoutes();

        $individualExcludedRoutes = [];
        foreach ($routes as $route) {
            if (Str::startsWith($route->uri, ['login', 'register', 'password', 'admin', 'forgot-password'])) {
                $individualExcludedRoutes[] = config('app.url').'/'.$route->uri;
            }
        }

        $visits = LoggedRequest::select([
            'logged_requests.url_id',
            'logged_requests.ip_address_id',
            'ip_address_metadata.country_code',
            'logged_requests.created_at',
            'urls.url'])
            ->distinct('logged_requests.url_id', 'logged_requests.ip_address_id')
            ->join('urls', 'logged_requests.url_id', '=', 'urls.id')
            ->join('user_agent_metadata', 'logged_requests.user_agent_id', '=', 'user_agent_metadata.user_agent_id')
            ->join('ip_address_metadata', 'logged_requests.ip_address_id', '=', 'ip_address_metadata.ip_address_id')
            ->whereLike('urls.url', config('app.url').'%')
            ->whereNotIn('urls.url', $individualExcludedRoutes)
            ->where('user_agent_metadata.is_bot', false)
            ->where('status_code', 200)
            ->whereNull('logged_requests.user_id')
            ->get();

        $now = now();
        $totalVisitsPastTwentyFourHours = $visits->where('created_at', '>=', $now->copy()->subDay())->count();
        $totalVisitsPastSevenDays = $visits->where('created_at', '>=', $now->copy()->subDays(7))->count();
        $totalVisitsPastThirtyDays = $visits->where('created_at', '>=', $now->copy()->subDays(30))->count();
        $totalVisitsAllTime = $visits->count();

        $periods = [
            now()->format('Y-m-d') => 'Aujourd\'hui',
            now()->subDay()->format('Y-m-d') => 'Hier',
            now()->subDays(7)->format('Y-m-d') => 'Les 7 derniers jours',
            now()->subDays(30)->format('Y-m-d') => 'Les 30 derniers jours',
            now()->startOfMonth()->format('Y-m-d') => 'Ce mois-ci',
            $visits->min('created_at')->format('Y-m-d') => 'Depuis le début',
        ];

        $startDate = $request->input('start_date', now()->subDays(30)->format('Y-m-d'));
        $dateEnd = $request->input('end_date', now()->format('Y-m-d'));

        $selectedPeriod = $startDate;

        // Now, all the stats are calculated for the selected period
        $visitsPerDay = $visits->where('created_at', '>=', $startDate)
            ->where('created_at', '<=', $dateEnd)