<?php
// Regenerate NDA HTML files with embedded signature images

require_once __DIR__ . '/app/database.php';
require_once __DIR__ . '/app/pdf-generator.php';

$db = new SQLite3(__DIR__ . '/private/aha_training.db');

// Get all NDA records
$result = $db->query("SELECT * FROM nda_records ORDER BY signed_at ASC");

$regenerated = 0;
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
    echo "Regenerating NDA for {$row['name']}...\n";

    // Prepare data for PDF generation
    $pdfData = [
        'name' => $row['name'],
        'email' => $row['email'],
        'signature_type' => $row['signature_type'],
        'signature_display' => $row['signature_type'] === 'typed' ? $row['signature_data'] : '[Drawn signature]',
        'signature_image' => $row['signature_type'] === 'drawn' ? __DIR__ . '/private/nda_records/' . $row['signature_data'] : null,
        'ip_address' => $row['ip_address'],
        'location' => $row['location'],
        'fingerprint' => $row['fingerprint'],
        'nda_hash' => $row['nda_hash'],
        'timestamp' => $row['signed_at']
    ];

    // Generate PDF (will overwrite existing file)
    $pdfGen = new NDAPDFGenerator();
    try {
        $pdfFilename = $pdfGen->generateNDAPDF($pdfData);
        echo "  ✓ Regenerated: $pdfFilename\n";
        $regenerated++;
    } catch (Exception $e) {
        echo "  ✗ Error: " . $e->getMessage() . "\n";
    }
}

$db->close();

echo "\n✓ Regenerated $regenerated NDA files\n";