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

// List payments
echo "Payments:\n";
$stmt = $pdo->query("SELECT id, status, approved_by FROM payments LIMIT 5");
$payments = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($payments);

if (!empty($payments)) {
    $id = $payments[0]['id'];
    $new_status = 'verified';
    $user_id = 1; // Assuming admin user id 1

    echo "\nUpdating Payment ID $id to '$new_status' by User $user_id...\n";

    try {
        $pdo->beginTransaction();
        $stmt = $pdo->prepare("UPDATE payments SET status = ?, approved_by = ?, approval_date = NOW() WHERE id = ?");
        $result = $stmt->execute([$new_status, $user_id, $id]);
        
        echo "Execute result: " . ($result ? "True" : "False") . "\n";
        echo "Rows affected: " . $stmt->rowCount() . "\n";
        
        if ($stmt->rowCount() > 0) {
            $pdo->commit();
            echo "Committed.\n";
        } else {
            $pdo->rollBack();
            echo "Rolled back (no rows affected).\n";
        }
    } catch (Exception $e) {
        $pdo->rollBack();
        echo "Error: " . $e->getMessage() . "\n";
    }

    // Check result
    $stmt = $pdo->prepare("SELECT id, status, approved_by FROM payments WHERE id = ?");
    $stmt->execute([$id]);
    print_r($stmt->fetch(PDO::FETCH_ASSOC));
}
?>