<?php

namespace App\Http\Controllers\Security;

use App\Http\Controllers\Controller;
use App\Models\SecurityScan;
use App\Models\SecurityScore;
use Inertia\Inertia;

class SecurityDashboardController extends Controller
{
    public function index()
    {
        $scans = SecurityScan::orderByDesc('created_at')->paginate(15);
        $scores = SecurityScore::selectRaw('AVG(score) as avg, MIN(score) as min, MAX(score) as max')->first();
        $stats = SecurityScan::whereIn('status', ['completed'])->selectRaw('
            SUM(critical_count) as critical,
            SUM(high_count) as high,
            SUM(medium_count) as medium,
            SUM(low_count) as low
        ')->first();

        return Inertia::render('Security/Index', [
            'scans'  => $scans,
            'scores' => $scores,
            'stats'  => $stats,
        ]);
    }

    public function vulnerabilities()
    {
        return Inertia::render('Security/Vulnerabilities');
    }

    public function compliance()
    {
        return Inertia::render('Security/Compliance');
    }
}