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

try {
    $pdo = db();
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Default users
    $users = [
        [
            'username' => 'admin',
            'password' => password_hash('admin_password', PASSWORD_DEFAULT),
            'full_name' => 'Admin User',
            'department' => 'RSS SA',
            'position' => 'System Administrator',
            'role' => 'admin'
        ],
        [
            'username' => 'requester',
            'password' => password_hash('requester_password', PASSWORD_DEFAULT),
            'full_name' => 'Regular User',
            'department' => 'RSS JP Sales',
            'position' => 'Sales Rep',
            'role' => 'requester'
        ]
    ];

    $stmt = $pdo->prepare(
        "INSERT INTO users (username, password, full_name, department, position, role) 
         VALUES (:username, :password, :full_name, :department, :position, :role)
         ON DUPLICATE KEY UPDATE password=VALUES(password), full_name=VALUES(full_name), role=VALUES(role);"
    );

    foreach ($users as $user) {
        $stmt->execute([
            ':username' => $user['username'],
            ':password' => $user['password'],
            ':full_name' => $user['full_name'],
            ':department' => $user['department'],
            ':position' => $user['position'],
            ':role' => $user['role']
        ]);
        echo "User '{$user['username']}' seeded successfully.\n";
    }

} catch (PDOException $e) {
    die("Error seeding users: " . $e->getMessage());
}