<?php
require_once 'config/database.php';

echo "Testing transaction verification functionality...\n";

// Check if we have any pending transactions
$stmt = $pdo->query("SELECT COUNT(*) as count FROM bank_transactions WHERE status = 'pending'");
$result = $stmt->fetch();
echo "Pending transactions: " . $result['count'] . "\n";

// Check if we have any verified transactions
$stmt = $pdo->query("SELECT COUNT(*) as count FROM bank_transactions WHERE status = 'verified'");
$result = $stmt->fetch();
echo "Verified transactions: " . $result['count'] . "\n";

// Check if we have any fee payments
$stmt = $pdo->query("SELECT COUNT(*) as count FROM fee_payments");
$result = $stmt->fetch();
echo "Fee payments: " . $result['count'] . "\n";

echo "Test completed.\n";
?>