system_status.php

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

$page_title = "System Status Check";
$tests = [];

// Database Connection Test
try {
    $stmt = $pdo->query("SELECT 1");
    $tests['database'] = ['status' => 'success', 'message' => 'Database connection successful'];
} catch (Exception $e) {
    $tests['database'] = ['status' => 'error', 'message' => 'Database connection failed: ' . $e->getMessage()];
}

// Tables Check
$required_tables = ['events', 'donations', 'products', 'orders', 'order_items', 'event_registrations'];
$existing_tables = [];
try {
    $stmt = $pdo->query("SHOW TABLES");
    $tables = $stmt->fetchAll(PDO::FETCH_COLUMN);
    
    foreach ($required_tables as $table) {
        if (in_array($table, $tables)) {
            $existing_tables[$table] = 'exists';
        } else {
            $existing_tables[$table] = 'missing';
        }
    }
    $tests['tables'] = ['status' => 'success', 'data' => $existing_tables];
} catch (Exception $e) {
    $tests['tables'] = ['status' => 'error', 'message' => $e->getMessage()];
}

// Sample Data Check
try {
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM events");
    $event_count = $stmt->fetch()['count'];
    
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM products");
    $product_count = $stmt->fetch()['count'];
    
    $tests['sample_data'] = [
        'status' => 'success',
        'events' => $event_count,
        'products' => $product_count
    ];
} catch (Exception $e) {
    $tests['sample_data'] = ['status' => 'error', 'message' => $e->getMessage()];
}

// File Structure Check
$required_files = [
    'charity/index.php',
    'charity/donate.php',
    'charity/process_donate.php',
    'shop/index.php',
    'shop/checkout.php',
    'shop/process_order.php',
    'assets/css/main.css',
    'includes/config.php'
];

$file_status = [];
foreach ($required_files as $file) {
    $file_status[$file] = file_exists($file) ? 'exists' : 'missing';
}
$tests['files'] = ['status' => 'success', 'data' => $file_status];

// Payment Configuration Check
$momo_config = [
    'endpoint' => 'https://test-payment.momo.vn/v2/gateway/api/create',
    'partner_code' => 'MOMOBKUN20180529',
    'access_key' => 'klm05TvNBzhg7h7j'
];

$vnpay_config = [
    'vnp_TmnCode' => 'VNPAYTEST',
    'vnp_HashSecret' => 'RAOEXHYVSDDIIENYWSLDIIZTANXUXZFJ'
];

$tests['payment_config'] = [
    'status' => 'success',
    'momo' => $momo_config,
    'vnpay' => $vnpay_config
];

// MoMo API Test (simple connectivity)
function testMoMoAPI() {
    $endpoint = "https://test-payment.momo.vn/v2/gateway/api/create";
    
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $endpoint);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_TIMEOUT, 10);
    curl_setopt($ch, CURLOPT_NOBODY, true);
    
    $result = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
    
    return [
        'reachable' => $result !== false,
        'http_code' => $httpCode
    ];
}

$tests['momo_connectivity'] = [
    'status' => 'info',
    'data' => testMoMoAPI()
];

include 'includes/header.php';
?>

<div class="container my-5">
    <div class="row">
        <div class="col-12">
            <div class="card shadow-lg border-0">
                <div class="card-header bg-gradient-primary text-white">
                    <h2 class="mb-0"><i class="fas fa-cogs me-2"></i>System Status Check</h2>
                    <p class="mb-0 opacity-75">Comprehensive system health and configuration check</p>
                </div>
                <div class="card-body p-4">
                    
                    <!-- Database Test -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-database me-2"></i>Database Connection
                            <?php if ($tests['database']['status'] == 'success'): ?>
                                <span class="badge bg-success">OK</span>
                            <?php else: ?>
                                <span class="badge bg-danger">ERROR</span>
                            <?php endif; ?>
                        </h4>
                        <div class="alert alert-<?= $tests['database']['status'] == 'success' ? 'success' : 'danger' ?>">
                            <?= $tests['database']['message'] ?>
                        </div>
                    </div>

                    <!-- Tables Check -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-table me-2"></i>Database Tables
                            <?php if ($tests['tables']['status'] == 'success'): ?>
                                <span class="badge bg-success">OK</span>
                            <?php else: ?>
                                <span class="badge bg-danger">ERROR</span>
                            <?php endif; ?>
                        </h4>
                        <?php if ($tests['tables']['status'] == 'success'): ?>
                            <div class="row">
                                <?php foreach ($tests['tables']['data'] as $table => $status): ?>
                                    <div class="col-md-4 mb-2">
                                        <div class="d-flex align-items-center">
                                            <i class="fas fa-<?= $status == 'exists' ? 'check text-success' : 'times text-danger' ?> me-2"></i>
                                            <span><?= $table ?></span>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        <?php else: ?>
                            <div class="alert alert-danger"><?= $tests['tables']['message'] ?></div>
                        <?php endif; ?>
                    </div>

                    <!-- Sample Data -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-chart-bar me-2"></i>Sample Data
                            <span class="badge bg-info">INFO</span>
                        </h4>
                        <?php if ($tests['sample_data']['status'] == 'success'): ?>
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="stats-mini">
                                        <i class="fas fa-calendar-alt text-primary"></i>
                                        <span><strong><?= $tests['sample_data']['events'] ?></strong> Events</span>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="stats-mini">
                                        <i class="fas fa-box text-success"></i>
                                        <span><strong><?= $tests['sample_data']['products'] ?></strong> Products</span>
                                    </div>
                                </div>
                            </div>
                        <?php else: ?>
                            <div class="alert alert-warning"><?= $tests['sample_data']['message'] ?></div>
                        <?php endif; ?>
                    </div>

                    <!-- File Structure -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-folder me-2"></i>File Structure
                            <span class="badge bg-success">OK</span>
                        </h4>
                        <div class="row">
                            <?php foreach ($tests['files']['data'] as $file => $status): ?>
                                <div class="col-md-6 mb-2">
                                    <div class="d-flex align-items-center">
                                        <i class="fas fa-<?= $status == 'exists' ? 'check text-success' : 'times text-danger' ?> me-2"></i>
                                        <span class="text-muted"><?= $file ?></span>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                        </div>
                    </div>

                    <!-- Payment Configuration -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-credit-card me-2"></i>Payment Configuration
                            <span class="badge bg-info">CONFIGURED</span>
                        </h4>
                        <div class="row">
                            <div class="col-md-6">
                                <h6><i class="fab fa-cc-visa me-2"></i>MoMo Configuration</h6>
                                <ul class="list-unstyled">
                                    <li><i class="fas fa-check text-success me-2"></i>Endpoint: Configured</li>
                                    <li><i class="fas fa-check text-success me-2"></i>Partner Code: <?= $tests['payment_config']['momo']['partner_code'] ?></li>
                                    <li><i class="fas fa-check text-success me-2"></i>Access Key: Configured</li>
                                    <li><i class="fas fa-info text-info me-2"></i>Request Type: captureWallet (QR Code)</li>
                                </ul>
                            </div>
                            <div class="col-md-6">
                                <h6><i class="fab fa-cc-visa me-2"></i>VNPay Configuration</h6>
                                <ul class="list-unstyled">
                                    <li><i class="fas fa-check text-success me-2"></i>TMN Code: <?= $tests['payment_config']['vnpay']['vnp_TmnCode'] ?></li>
                                    <li><i class="fas fa-check text-success me-2"></i>Hash Secret: Configured</li>
                                </ul>
                            </div>
                        </div>
                    </div>

                    <!-- MoMo Connectivity -->
                    <div class="status-section mb-4">
                        <h4 class="mb-3">
                            <i class="fas fa-wifi me-2"></i>MoMo API Connectivity
                            <?php if ($tests['momo_connectivity']['data']['reachable']): ?>
                                <span class="badge bg-success">REACHABLE</span>
                            <?php else: ?>
                                <span class="badge bg-warning">UNREACHABLE</span>
                            <?php endif; ?>
                        </h4>
                        <div class="alert alert-<?= $tests['momo_connectivity']['data']['reachable'] ? 'success' : 'warning' ?>">
                            MoMo API Endpoint: <?= $tests['momo_connectivity']['data']['reachable'] ? 'Reachable' : 'Not Reachable' ?>
                            (HTTP Code: <?= $tests['momo_connectivity']['data']['http_code'] ?>)
                        </div>
                    </div>

                    <!-- Action Links -->
                    <div class="status-section">
                        <h4 class="mb-3"><i class="fas fa-tools me-2"></i>Quick Actions</h4>
                        <div class="row">
                            <div class="col-md-3 mb-2">
                                <a href="charity/test_momo_simple.php" class="btn btn-outline-primary w-100" target="_blank">
                                    <i class="fas fa-mobile-alt me-2"></i>Test MoMo QR
                                </a>
                            </div>
                            <div class="col-md-3 mb-2">
                                <a href="charity/debug_momo.php" class="btn btn-outline-info w-100" target="_blank">
                                    <i class="fas fa-bug me-2"></i>MoMo Debug
                                </a>
                            </div>
                            <div class="col-md-3 mb-2">
                                <a href="shop/test_system.php" class="btn btn-outline-success w-100" target="_blank">
                                    <i class="fas fa-shopping-cart me-2"></i>Test Shop
                                </a>
                            </div>
                            <div class="col-md-3 mb-2">
                                <a href="index.php" class="btn btn-primary w-100">
                                    <i class="fas fa-home me-2"></i>Main Site
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<style>
.status-section {
    border-left: 4px solid #e9ecef;
    padding-left: 20px;
    margin-left: 10px;
}

.stats-mini {
    display: flex;
    align-items: center;
    gap: 10px;
    padding: 10px;
    background: #f8f9fa;
    border-radius: 8px;
}

.stats-mini i {
    font-size: 1.5rem;
}
</style>

<?php include 'includes/footer.php'; ?>