check_installation.php

#!/usr/bin/env php
<?php

echo "AdminLogPanel - Installation Check\n";
echo "===================================\n\n";

$errors = [];
$warnings = [];
$success = [];

// Check PHP version
echo "Checking PHP version... ";
if (version_compare(PHP_VERSION, '7.4.0', '>=')) {
    echo "✓ " . PHP_VERSION . "\n";
    $success[] = "PHP version OK";
} else {
    echo "✗ " . PHP_VERSION . " (requires 7.4+)\n";
    $errors[] = "PHP version too old";
}

// Check required extensions
echo "Checking PHP extensions:\n";

$required_extensions = ['pdo', 'pdo_pgsql', 'json'];
foreach ($required_extensions as $ext) {
    echo "  - $ext: ";
    if (extension_loaded($ext)) {
        echo "✓\n";
        $success[] = "$ext extension loaded";
    } else {
        echo "✗ (required)\n";
        $errors[] = "$ext extension not loaded";
    }
}

// Check directory structure
echo "\nChecking directory structure:\n";

$required_dirs = [
    'public_www',
    'public_www/config',
    'public_www/controllers',
    'public_www/models',
    'public_www/middleware',
    'public_www/views',
    'worker',
    'worker/test'
];

foreach ($required_dirs as $dir) {
    echo "  - $dir: ";
    if (is_dir(__DIR__ . '/' . $dir)) {
        echo "✓\n";
        $success[] = "$dir exists";
    } else {
        echo "✗\n";
        $errors[] = "$dir not found";
    }
}

// Check required files
echo "\nChecking required files:\n";

$required_files = [
    'database.sql',
    'public_www/index.php',
    'public_www/config/database.php',
    'public_www/config/router.php',
    'public_www/models/Account.php',
    'public_www/models/DataLog.php',
    'public_www/controllers/AuthController.php',
    'public_www/controllers/AdminController.php',
    'public_www/controllers/UserController.php',
    'public_www/middleware/AuthMiddleware.php',
    'public_www/views/index.html',
    'public_www/views/app.js',
    'worker/worker.php',
    'worker/GeoIP.php'
];

foreach ($required_files as $file) {
    echo "  - $file: ";
    if (file_exists(__DIR__ . '/' . $file)) {
        echo "✓\n";
        $success[] = "$file exists";
    } else {
        echo "✗\n";
        $errors[] = "$file not found";
    }
}

// Check test data
echo "\nChecking test data:\n";
$test_dirs = glob(__DIR__ . '/worker/test/*', GLOB_ONLYDIR);
echo "  - Test folders: " . count($test_dirs) . " found\n";

if (count($test_dirs) > 0) {
    $success[] = "Test data present";

    foreach ($test_dirs as $test_dir) {
        $info = $test_dir . '/info.txt';
        $country = $test_dir . '/country.txt';

        if (!file_exists($info) || !file_exists($country)) {
            $warnings[] = basename($test_dir) . " missing required files";
        }
    }
} else {
    $warnings[] = "No test data folders found";
}

// Try to connect to database
echo "\nChecking database connection:\n";

$db_host = getenv('DB_HOST') ?: 'localhost';
$db_port = getenv('DB_PORT') ?: '5432';
$db_name = getenv('DB_NAME') ?: 'adminlogpanel';
$db_user = getenv('DB_USER') ?: 'postgres';

echo "  - Host: $db_host:$db_port\n";
echo "  - Database: $db_name\n";
echo "  - User: $db_user\n";
echo "  - Connecting: ";

try {
    require_once __DIR__ . '/public_www/config/database.php';
    $db = Database::getInstance()->getConnection();
    echo "✓\n";
    $success[] = "Database connection successful";

    // Check tables
    echo "\nChecking database tables:\n";

    $stmt = $db->query("SELECT tablename FROM pg_tables WHERE schemaname = 'public' ORDER BY tablename");
    $tables = $stmt->fetchAll(PDO::FETCH_COLUMN);

    $required_tables = ['accounts', 'data_logs'];

    foreach ($required_tables as $table) {
        echo "  - $table: ";
        if (in_array($table, $tables)) {
            echo "✓\n";
            $success[] = "$table table exists";
        } else {
            echo "✗\n";
            $errors[] = "$table table not found";
        }
    }

    // Check accounts
    echo "\nChecking default accounts:\n";
    $stmt = $db->query("SELECT login, is_admin FROM accounts ORDER BY id");
    $accounts = $stmt->fetchAll();

    if (count($accounts) >= 2) {
        foreach ($accounts as $account) {
            echo "  - {$account['login']} (" . ($account['is_admin'] ? 'admin' : 'user') . "): ✓\n";
        }
        $success[] = "Default accounts present";
    } else {
        $warnings[] = "Less than 2 accounts found";
    }

} catch (Exception $e) {
    echo "✗\n";
    echo "  Error: " . $e->getMessage() . "\n";
    $errors[] = "Database connection failed: " . $e->getMessage();
}

// Summary
echo "\n===================================\n";
echo "Summary:\n";
echo "  ✓ Success: " . count($success) . "\n";
echo "  ⚠ Warnings: " . count($warnings) . "\n";
echo "  ✗ Errors: " . count($errors) . "\n";

if (count($warnings) > 0) {
    echo "\nWarnings:\n";
    foreach ($warnings as $warning) {
        echo "  ⚠ $warning\n";
    }
}

if (count($errors) > 0) {
    echo "\nErrors:\n";
    foreach ($errors as $error) {
        echo "  ✗ $error\n";
    }
    echo "\nPlease fix the errors before running the application.\n";
    exit(1);
} else {
    echo "\n✓ Installation check passed!\n";
    echo "\nNext steps:\n";
    echo "  1. Run: ./start_server.sh\n";
    echo "  2. Open: http://localhost:8000\n";
    echo "  3. Login with: admin / password\n";
    echo "  4. Generate test data: cd worker && php worker.php 50\n";
    exit(0);
}