<?php
declare(strict_types=1);

$me = Auth::requireRole('admin');
Csrf::check();

$id       = post('id') ? (int) post('id') : null;
$fullName = trim((string) post('full_name', ''));
$username = trim((string) post('username', ''));
$email    = trim((string) post('email', ''));
$role     = in_array(post('role'), ['viewer', 'analyst', 'admin'], true) ? (string) post('role') : 'viewer';
$isActive = post('is_active') === '1' ? 1 : 0;

if ($fullName === '' || $username === '') {
    Flash::add('error', t('full_name') . ' / ' . t('username') . ': ' . t('required'));
    redirect('users', 'index');
}

if ($email !== '' && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
    Flash::add('error', t('email') . ': not a valid address.');
    redirect('users', 'index');
}

$taken = Database::scalar(
    'SELECT 1 FROM users WHERE username = :u' . ($id ? ' AND id <> :id' : '') . ' LIMIT 1',
    $id ? ['u' => $username, 'id' => $id] : ['u' => $username]
);
if ($taken !== null) {
    Flash::add('error', 'That username is already taken.');
    redirect('users', 'index');
}

// An admin must not lock themselves out or drop the last admin account.
if ($id !== null && $id === (int) $me['id'] && ($role !== 'admin' || $isActive === 0)) {
    Flash::add('error', 'You cannot remove your own admin access.');
    redirect('users', 'index');
}

if ($id !== null && $role !== 'admin') {
    $admins = (int) Database::scalar(
        "SELECT COUNT(*) FROM users WHERE role = 'admin' AND is_active = 1 AND id <> :id",
        ['id' => $id]
    );
    if ($admins === 0) {
        Flash::add('error', 'There must be at least one active admin.');
        redirect('users', 'index');
    }
}

if ($id === null) {
    Database::run(
        'INSERT INTO users (username, full_name, email, role, is_active)
         VALUES (:u, :n, :e, :r, :a)',
        ['u' => $username, 'n' => $fullName, 'e' => $email ?: null, 'r' => $role, 'a' => $isActive]
    );
    $newId = Database::lastId();
    Audit::log('create', 'user', $newId, ['username' => $username, 'role' => $role]);
    Flash::add('ok', t('user_saved') . ' ' . t('no_password_set') . '.');
    redirect('users', 'index', ['edit' => $newId]);
}

Database::run(
    'UPDATE users SET username = :u, full_name = :n, email = :e, role = :r, is_active = :a
      WHERE id = :id',
    ['u' => $username, 'n' => $fullName, 'e' => $email ?: null, 'r' => $role, 'a' => $isActive, 'id' => $id]
);

Audit::log('update', 'user', $id, ['username' => $username, 'role' => $role, 'active' => $isActive]);
Flash::add('ok', t('user_saved'));
redirect('users', 'index');
