<?php
declare(strict_types=1);

Auth::requireRole('analyst');

$tags = Database::all(
    'SELECT t.*, (SELECT COUNT(*) FROM company_tags ct WHERE ct.tag_id = t.id) AS companies
       FROM tags t ORDER BY t.sort_order, t.name_en'
);

$editId = get_int('edit');
$editing = null;
if ($editId !== null) {
    $editing = Database::one('SELECT * FROM tags WHERE id = :id', ['id' => $editId]);
}

$PAGE_TITLE    = t('tags_title');
$PAGE_SUBTITLE = t('tags_subtitle');

require BASE_DIR . '/includes/layout/header.php';
?>

<div class="grid grid-main">

  <section class="panel">
    <div class="panel-head"><h2 class="panel-title"><?= e(t('tags_title')) ?> · <?= count($tags) ?></h2></div>
    <div class="panel-body is-flush">
      <div class="table-wrap">
        <table class="data">
          <thead>
            <tr>
              <th><?= e(t('name')) ?></th>
              <th><?= e(t('tag_group')) ?></th>
              <th><?= e(t('tag_core')) ?></th>
              <th class="num"><?= e(t('companies_count')) ?></th>
              <th></th>
            </tr>
          </thead>
          <tbody>
          <?php foreach ($tags as $tag): ?>
            <tr>
              <td class="cell-name">
                <span class="chip-dot" style="display:inline-block;background:<?= e($tag['color'] ?: '#6b7c8d') ?>"></span>
                <?= e($tag['name_en']) ?>
                <?php if ($tag['name_he']): ?><span class="cell-meta"><?= e($tag['name_he']) ?></span><?php endif; ?>
              </td>
              <td class="small muted"><?= e($tag['tag_group']) ?></td>
              <td><?= $tag['is_core_competition'] ? '<span class="chip is-core">' . e(t('core_only')) . '</span>' : '' ?></td>
              <td class="num">
                <a href="<?= e(url('companies', 'list', ['tag' => $tag['slug']])) ?>"><?= (int) $tag['companies'] ?></a>
              </td>
              <td class="num nowrap">
                <a class="btn btn-sm btn-ghost" href="<?= e(url('tags', 'index', ['edit' => $tag['id']])) ?>"><?= e(t('edit')) ?></a>
                <?php if (Auth::isAdmin() && (int) $tag['companies'] === 0): ?>
                  <form method="post" action="<?= e(url('tags', 'delete')) ?>" style="display:inline"
                        onsubmit="return confirm('<?= e(t('confirm_delete')) ?>')">
                    <?= Csrf::field() ?>
                    <input type="hidden" name="id" value="<?= (int) $tag['id'] ?>">
                    <button class="btn btn-sm btn-ghost btn-danger" type="submit">×</button>
                  </form>
                <?php endif; ?>
              </td>
            </tr>
          <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div>
  </section>

  <section class="panel">
    <div class="panel-head">
      <h2 class="panel-title"><?= e($editing ? t('edit') : t('add')) ?></h2>
    </div>
    <div class="panel-body">
      <form method="post" action="<?= e(url('tags', 'save')) ?>" class="stack">
        <?= Csrf::field() ?>
        <?php if ($editing): ?><input type="hidden" name="id" value="<?= (int) $editing['id'] ?>"><?php endif; ?>

        <div class="field">
          <label class="label" for="name_en"><?= e(t('tag_name_en')) ?></label>
          <input type="text" id="name_en" name="name_en" required maxlength="96"
                 value="<?= e($editing['name_en'] ?? '') ?>">
        </div>

        <div class="field">
          <label class="label" for="name_he"><?= e(t('tag_name_he')) ?></label>
          <input type="text" id="name_he" name="name_he" maxlength="96"
                 value="<?= e($editing['name_he'] ?? '') ?>">
        </div>

        <div class="field">
          <label class="label" for="tag_group"><?= e(t('tag_group')) ?></label>
          <select id="tag_group" name="tag_group">
            <?php foreach (['product', 'technology', 'domain'] as $g): ?>
              <option value="<?= e($g) ?>" <?= ($editing['tag_group'] ?? 'product') === $g ? 'selected' : '' ?>>
                <?= e(ucfirst($g)) ?>
              </option>
            <?php endforeach; ?>
          </select>
        </div>

        <div class="field">
          <label class="label" for="color"><?= e(t('tag_color')) ?></label>
          <input type="text" id="color" name="color" maxlength="7" placeholder="#4a2d7a"
                 value="<?= e($editing['color'] ?? '') ?>">
        </div>

        <div class="field">
          <label class="label" for="sort_order">Order</label>
          <input type="number" id="sort_order" name="sort_order" min="0" max="9999"
                 value="<?= e((string) ($editing['sort_order'] ?? 100)) ?>">
        </div>

        <label class="check">
          <input type="checkbox" name="is_core_competition" value="1"
            <?= !empty($editing['is_core_competition']) ? 'checked' : '' ?>>
          <?= e(t('tag_core')) ?>
        </label>

        <div class="form-actions">
          <button type="submit" class="btn btn-primary"><?= e(t('save')) ?></button>
          <?php if ($editing): ?>
            <a class="btn" href="<?= e(url('tags', 'index')) ?>"><?= e(t('cancel')) ?></a>
          <?php endif; ?>
        </div>
      </form>
    </div>
  </section>

</div>

<?php require BASE_DIR . '/includes/layout/footer.php'; ?>
