1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / devscfvi / AblePro /
Filename : test_screenshots.php
back
<?php
// test_screenshots.php
// Quick test to verify screenshot functionality

require_once 'config.php';

header('Content-Type: text/html; charset=utf-8');

echo "<h1>Screenshot Column Test</h1>";

try {
    $pdo = getDBConnection();
    
    // Test 1: Check if columns exist
    echo "<h2>Test 1: Column Structure</h2>";
    $stmt = $pdo->query("SHOW COLUMNS FROM crypto_trades WHERE Field LIKE '%screenshot%'");
    $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    if (count($columns) > 0) {
        echo "✅ Screenshot columns found:<br>";
        echo "<table border='1' cellpadding='5'>";
        echo "<tr><th>Field</th><th>Type</th><th>Null</th><th>Default</th></tr>";
        foreach ($columns as $col) {
            echo "<tr>";
            echo "<td>{$col['Field']}</td>";
            echo "<td>{$col['Type']}</td>";
            echo "<td>{$col['Null']}</td>";
            echo "<td>" . ($col['Default'] ?? 'NULL') . "</td>";
            echo "</tr>";
        }
        echo "</table>";
    } else {
        echo "❌ No screenshot columns found!<br>";
        echo "Run this SQL:<br>";
        echo "<pre>ALTER TABLE crypto_trades 
ADD COLUMN entry_screenshot VARCHAR(255) DEFAULT NULL,
ADD COLUMN exit_screenshot VARCHAR(255) DEFAULT NULL;</pre>";
    }
    
    // Test 2: Try to insert a test screenshot path
    echo "<h2>Test 2: Insert Test</h2>";
    $testPath = '/uploads/screenshots/test_' . time() . '.jpg';
    
    $stmt = $pdo->prepare("
        INSERT INTO crypto_trades 
        (coin, position_size, entry_price, stop_loss_percent, take_profit_percent, 
         quantity, sl_price, tp_price, loss_amount, profit_amount, reward_risk_ratio, 
         fees, order_type, entry_screenshot)
        VALUES ('TEST', 100, 50000, 0.5, 1.5, 0.002, 49750, 50750, 25, 75, 3, 0.5, 'market', ?)
    ");
    
    $result = $stmt->execute([$testPath]);
    
    if ($result) {
        $testId = $pdo->lastInsertId();
        echo "✅ Test trade inserted with ID: $testId<br>";
        
        // Verify it was saved
        $stmt = $pdo->prepare("SELECT id, coin, entry_screenshot FROM crypto_trades WHERE id = ?");
        $stmt->execute([$testId]);
        $trade = $stmt->fetch(PDO::FETCH_ASSOC);
        
        echo "Retrieved data:<br>";
        echo "- ID: {$trade['id']}<br>";
        echo "- Coin: {$trade['coin']}<br>";
        echo "- Entry Screenshot: " . ($trade['entry_screenshot'] ?? 'NULL') . "<br>";
        
        if ($trade['entry_screenshot'] === $testPath) {
            echo "<strong style='color:green'>✅ Screenshot path saved correctly!</strong><br>";
        } else {
            echo "<strong style='color:red'>❌ Screenshot path NOT saved!</strong><br>";
        }
        
        // Clean up test trade
        $pdo->prepare("DELETE FROM crypto_trades WHERE id = ?")->execute([$testId]);
        echo "<br><em>Test trade deleted</em><br>";
        
    } else {
        echo "❌ Failed to insert test trade<br>";
        print_r($stmt->errorInfo());
    }
    
    // Test 3: Check recent trades
    echo "<h2>Test 3: Recent Trades</h2>";
    $stmt = $pdo->query("
        SELECT id, coin, entry_screenshot, exit_screenshot, created_at 
        FROM crypto_trades 
        ORDER BY created_at DESC 
        LIMIT 5
    ");
    $trades = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    echo "<table border='1' cellpadding='5'>";
    echo "<tr><th>ID</th><th>Coin</th><th>Entry Screenshot</th><th>Exit Screenshot</th><th>Created</th></tr>";
    foreach ($trades as $trade) {
        echo "<tr>";
        echo "<td>{$trade['id']}</td>";
        echo "<td>{$trade['coin']}</td>";
        echo "<td>" . ($trade['entry_screenshot'] ?? '<em>NULL</em>') . "</td>";
        echo "<td>" . ($trade['exit_screenshot'] ?? '<em>NULL</em>') . "</td>";
        echo "<td>{$trade['created_at']}</td>";
        echo "</tr>";
    }
    echo "</table>";
    
    echo "<h2>Summary</h2>";
    echo "<p>If columns exist and test passed, the issue is in the frontend JavaScript.</p>";
    echo "<p>Check browser console for: <code>console.log(calculatorState.entryScreenshot)</code></p>";
    
} catch (Exception $e) {
    echo "<p style='color:red'>❌ Error: " . $e->getMessage() . "</p>";
}
?>