require_once '../core/DB.php';
require_once '../vendor/fpdf/fpdf.php';

$db = DB::connect();
$logId = $_GET['log_id'];

$q = $db->prepare("
 SELECT l.log_ref, v.name, v.police_station, c.location, b.name AS branch
 FROM cctv_logs l
 JOIN visitors v ON v.id=l.visitor_id
 JOIN cameras c ON c.id=l.camera_id
 JOIN branches b ON b.id=l.branch_id
 WHERE l.id=?
");
$q->execute([$logId]);
$data = $q->fetch();

$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',14);
$pdf->Cell(0,10,'CCTV FOOTAGE ACCESS REQUEST',0,1,'C');

$pdf->SetFont('Arial','',11);
$pdf->MultiCell(0,8,"
Branch: {$data['branch']}
Log Ref: {$data['log_ref']}

Requested By: {$data['name']}
Police Station: {$data['police_station']}

Camera Location: {$data['location']}
");

$pdf->Cell(0,10,'Authorized Signature: ____________',0,1);

$pdf->Output();