<?php
declare(strict_types=1);

Auth::requireRole('admin');
Csrf::check();

$id = (int) post('id', 0);

$inUse = (int) Database::scalar('SELECT COUNT(*) FROM company_tags WHERE tag_id = :id', ['id' => $id]);
if ($inUse > 0) {
    Flash::add('error', "That keyword is on {$inUse} companies. Remove it from them first.");
    redirect('tags', 'index');
}

$tag = Database::one('SELECT name_en FROM tags WHERE id = :id', ['id' => $id]);
if ($tag !== null) {
    Database::run('DELETE FROM tags WHERE id = :id', ['id' => $id]);
    Audit::log('delete', 'tag', $id, ['name' => $tag['name_en']]);
}

redirect('tags', 'index');
