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

// Debug payment 3583
$stmt = $pdo->prepare('SELECT * FROM payments WHERE id = 3583');
$stmt->execute();
$payment = $stmt->fetch(PDO::FETCH_ASSOC);

echo "Payment 3583:\n";
print_r($payment);

// Check if it's linked to an allocation
if ($payment && !empty($payment['allocation_id'])) {
    echo "\nAllocation linked to payment:\n";
    $stmt2 = $pdo->prepare('SELECT * FROM allocations WHERE id = ?');
    $stmt2->execute([$payment['allocation_id']]);
    $allocation = $stmt2->fetch(PDO::FETCH_ASSOC);
    print_r($allocation);
    
    // Check installments for this allocation
    echo "\nInstallments for this allocation:\n";
    $stmt3 = $pdo->prepare('SELECT * FROM installments WHERE allocation_id = ?');
    $stmt3->execute([$payment['allocation_id']]);
    $installments = $stmt3->fetchAll(PDO::FETCH_ASSOC);
    print_r($installments);
} else {
    echo "\nNo allocation linked to this payment.\n";
}

// Check if payment is linked to user
if ($payment && !empty($payment['user_id'])) {
    echo "\nUser linked to payment:\n";
    $stmt4 = $pdo->prepare('SELECT id, username, email FROM users WHERE id = ?');
    $stmt4->execute([$payment['user_id']]);
    $user = $stmt4->fetch(PDO::FETCH_ASSOC);
    print_r($user);
}

echo "\nDone.\n";