75 lines
2.1 KiB
PHP
75 lines
2.1 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use App\Models\Site;
|
|
use App\Models\SslCertificate;
|
|
use Illuminate\Http\Request;
|
|
|
|
class SslCertificateController extends Controller
|
|
{
|
|
/**
|
|
* Display SSL certificate overview for all sites
|
|
*/
|
|
public function index()
|
|
{
|
|
$sites = Site::where('user_id', auth()->id())
|
|
->with(['sslCertificates' => function ($query) {
|
|
$query->latest()->limit(1);
|
|
}])
|
|
->get();
|
|
|
|
// Get SSL statistics
|
|
$stats = [
|
|
'total_sites' => $sites->count(),
|
|
'valid_certs' => 0,
|
|
'expiring_soon' => 0,
|
|
'expired' => 0,
|
|
];
|
|
|
|
foreach ($sites as $site) {
|
|
$latestCert = $site->sslCertificates->first();
|
|
if ($latestCert) {
|
|
if ($latestCert->expires_at) {
|
|
$daysUntilExpiry = now()->diffInDays($latestCert->expires_at, false);
|
|
|
|
if ($daysUntilExpiry < 0) {
|
|
$stats['expired']++;
|
|
} elseif ($daysUntilExpiry <= 30) {
|
|
$stats['expiring_soon']++;
|
|
} else {
|
|
$stats['valid_certs']++;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// Get recent SSL checks across all sites
|
|
$recentCertificates = SslCertificate::whereHas('site', function ($query) {
|
|
$query->where('user_id', auth()->id());
|
|
})
|
|
->with('site')
|
|
->latest()
|
|
->limit(50)
|
|
->get();
|
|
|
|
return view('ssl.index', compact('sites', 'stats', 'recentCertificates'));
|
|
}
|
|
|
|
/**
|
|
* Display SSL certificate details for a specific site
|
|
*/
|
|
public function show(Site $site)
|
|
{
|
|
$this->authorize('view', $site);
|
|
|
|
$sslCertificates = $site->sslCertificates()
|
|
->orderBy('created_at', 'desc')
|
|
->paginate(50);
|
|
|
|
$latestCert = $site->sslCertificates()->latest()->first();
|
|
|
|
return view('ssl.show', compact('site', 'sslCertificates', 'latestCert'));
|
|
}
|
|
}
|