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

try {
    $pdo = db();
    // Drop and recreate table
    $sql = file_get_contents(__DIR__ . '/migrations/001_create_users_table.sql');
    $pdo->exec($sql);
    echo "Table 'users' created successfully.\n";

    // New users
    $users = [
        ['Admin', 'admin', 'password123', 'Admin'],
        ['Rumaiz', 'rumaiz', 'Rumaiz4556', 'Manager'],
        ['Nadeeni', 'nadeeni', 'Nadz1234', 'Manager'],
        ['Kaveesh', 'kaveesh', 'Kaveesh123', 'Staff'],
        ['Sarani', 'sarani', 'Sarani789', 'Staff'],
        ['Nazeeha', 'nazeeha', 'Nazeeha1234', 'Staff'],
        ['Thiwanka', 'thiwanka', 'Thiwanka567', 'Staff'],
        ['Customer Service', 'customerservice', 'Coho2646', 'Staff'],
        ['Siranjeewan', 'siranjeewan', 'Siranjeewan123', 'Rider'],
        ['Rozan', 'rozan', 'Rozan123', 'Rider'],
        ['Coho Rider', 'cohorider', 'Coho123456', 'Rider'],
    ];

    $stmt = $pdo->prepare(
        'INSERT INTO users (full_name, username, password, role) VALUES (?, ?, ?, ?)'
    );

    foreach ($users as $user) {
        $fullName = $user[0];
        $username = $user[1];
        $password = password_hash($user[2], PASSWORD_DEFAULT);
        $role = $user[3];
        $stmt->execute([$fullName, $username, $password, $role]);
    }

    echo "Users inserted successfully.\n";
    echo "Migration completed successfully.\n";

} catch (PDOException $e) {
    die("Migration failed: " . $e->getMessage() . "\n");
}