<?php
require_once __DIR__ . '/includes/db.php';
require_once __DIR__ . '/includes/functions.php';

try {
    echo "Updating schema for Payment Reminders...\n";
    
    // Add reminder fields to installments (this handles payment schedules)
    $pdo->exec("ALTER TABLE installments 
        ADD COLUMN IF NOT EXISTS reminder_7_sent BOOLEAN DEFAULT FALSE,
        ADD COLUMN IF NOT EXISTS reminder_2_sent BOOLEAN DEFAULT FALSE,
        ADD COLUMN IF NOT EXISTS reminder_due_sent BOOLEAN DEFAULT FALSE
    ");
    echo "Added reminder tracking columns to 'installments' table.\n";
    
    // If a payment_schedules table exists, we add columns there as well
    $hasPaySchedules = $pdo->query("SHOW TABLES LIKE 'payment_schedules'")->rowCount() > 0;
    if ($hasPaySchedules) {
        $pdo->exec("ALTER TABLE payment_schedules 
            ADD COLUMN IF NOT EXISTS reminder_7_sent BOOLEAN DEFAULT FALSE,
            ADD COLUMN IF NOT EXISTS reminder_2_sent BOOLEAN DEFAULT FALSE,
            ADD COLUMN IF NOT EXISTS reminder_due_sent BOOLEAN DEFAULT FALSE
        ");
        echo "Added reminder tracking columns to 'payment_schedules' table.\n";
    }

    echo "Schema update successful.\n";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}