<?php
require 'includes/db.php';

$users = [
    [
        'name' => 'System Admin',
        'email' => 'admin@aiben.com',
        'role' => 'admin'
    ],
    [
        'name' => 'Contact Centre',
        'email' => 'care@aiben.com',
        'role' => 'contact_rep'
    ],
    [
        'name' => 'Finance Manager',
        'email' => 'finance@aiben.com',
        'role' => 'finance'
    ],
    [
        'name' => 'Operations Officer',
        'email' => 'ops@aiben.com',
        'role' => 'operations'
    ],
    [
        'name' => 'Top Agent',
        'email' => 'agent@aiben.com',
        'role' => 'agent'
    ],
    [
        'name' => 'Valued Client',
        'email' => 'client@aiben.com',
        'role' => 'client'
    ]
];

$password = 'password123';
$hashed_password = password_hash($password, PASSWORD_DEFAULT);

echo "Setting up test users with password: $password\n";
echo "------------------------------------------------\n";

foreach ($users as $u) {
    // Check if user exists
    $stmt = $pdo->prepare("SELECT id FROM users WHERE email = ?");
    $stmt->execute([$u['email']]);
    $exists = $stmt->fetch();

    if ($exists) {
        // Update existing user
        $stmt = $pdo->prepare("UPDATE users SET password = ?, role = ?, name = ? WHERE email = ?");
        $stmt->execute([$hashed_password, $u['role'], $u['name'], $u['email']]);
        echo "[UPDATED] " . str_pad($u['role'], 12) . " : " . $u['email'] . "\n";
    } else {
        // Create new user
        $stmt = $pdo->prepare("INSERT INTO users (name, email, password, role) VALUES (?, ?, ?, ?)");
        $stmt->execute([$u['name'], $u['email'], $hashed_password, $u['role']]);
        echo "[CREATED] " . str_pad($u['role'], 12) . " : " . $u['email'] . "\n";
    }
}

echo "------------------------------------------------\n";
echo "Done.\n";
?>