id()) ->withCount('brokenLinks') ->get(); // Get broken link statistics $stats = [ 'total_sites' => $sites->count(), 'sites_with_broken_links' => $sites->where('broken_links_count', '>', 0)->count(), 'total_broken_links' => $sites->sum('broken_links_count'), 'sites_clean' => $sites->where('broken_links_count', 0)->count(), ]; // Get recent broken links across all sites $recentBrokenLinks = BrokenLink::whereHas('site', function ($query) { $query->where('user_id', auth()->id()); }) ->with('site') ->latest() ->limit(50) ->get(); return view('broken-links.index', compact('sites', 'stats', 'recentBrokenLinks')); } /** * Display broken links for a specific site */ public function show(Site $site) { $this->authorize('view', $site); $brokenLinks = $site->brokenLinks() ->orderBy('created_at', 'desc') ->paginate(50); $stats = [ 'total_broken_links' => $brokenLinks->total(), 'unique_urls' => $site->brokenLinks()->distinct('url')->count('url'), ]; return view('broken-links.show', compact('site', 'brokenLinks', 'stats')); } }