PackIt/admin/item_groups.php

<?php
require_once __DIR__ . '/auth.php';
require_once __DIR__ . '/layout.php';
require_admin();

$pdo = get_pdo();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'] ?? '';
    if ($action === 'add') {
        $name  = trim($_POST['groupName'] ?? '');
        $order = (int)($_POST['sortOrder'] ?? 0);
        if ($name !== '') {
            $pdo->prepare("INSERT INTO item_groups (groupName, sortOrder) VALUES (?,?)")->execute([$name, $order]);
            flash('success', "Group '$name' added.");
        } else { flash('error', 'Name required.'); }
    }
    if ($action === 'edit') {
        $id = (int)$_POST['groupID'];
        $name  = trim($_POST['groupName'] ?? '');
        $order = (int)($_POST['sortOrder'] ?? 0);
        if ($name !== '') {
            $pdo->prepare("UPDATE item_groups SET groupName=?,sortOrder=? WHERE groupID=?")->execute([$name,$order,$id]);
            flash('success', 'Group updated.');
        } else { flash('error', 'Name required.'); }
    }
    if ($action === 'delete') {
        $id = (int)$_POST['groupID'];
        $pdo->prepare("DELETE FROM item_groups WHERE groupID=?")->execute([$id]);
        flash('success', 'Group deleted.');
    }
    header('Location: item_groups.php'); exit;
}

$groups = $pdo->query("SELECT * FROM item_groups ORDER BY sortOrder, groupID")->fetchAll();

$editing = null;
if (isset($_GET['edit'])) {
    $stmt = $pdo->prepare("SELECT * FROM item_groups WHERE groupID=?");
    $stmt->execute([(int)$_GET['edit']]);
    $editing = $stmt->fetch();
}

admin_head('Item Groups', 'item_groups.php');
show_alerts();
?>
<h1>Item Groups</h1>
<div class="card">
  <h2><?= $editing ? 'Edit Group' : 'Add New Group' ?></h2>
  <form method="POST">
    <input type="hidden" name="action" value="<?= $editing ? 'edit' : 'add' ?>">
    <?php if ($editing): ?>
    <input type="hidden" name="groupID" value="<?= $editing['groupID'] ?>">
    <?php endif; ?>
    <div class="form-row">
      <div>
        <label>Group Name</label>
        <input type="text" name="groupName"
               value="<?= htmlspecialchars($editing['groupName'] ?? '') ?>"
               placeholder="e.g. Clothing" required>
      </div>
      <div>
        <label>Sort Order</label>
        <input type="number" name="sortOrder"
               value="<?= (int)($editing['sortOrder'] ?? 0) ?>" min="0">
      </div>
    </div>
    <div style="display:flex;gap:.5rem;">
      <button type="submit" class="btn btn-primary"><?= $editing ? '💾 Save' : '➕ Add Group' ?></button>
      <?php if ($editing): ?><a href="item_groups.php" class="btn btn-secondary">Cancel</a><?php endif; ?>
    </div>
  </form>
</div>

<table class="tbl">
  <thead><tr><th>#</th><th>Name</th><th>Sort</th><th>Items</th><th></th></tr></thead>
  <tbody>
  <?php foreach ($groups as $g):
    $stmt = $pdo->prepare("SELECT COUNT(*) FROM items WHERE groupID=?");
    $stmt->execute([$g['groupID']]);
    $cnt = $stmt->fetchColumn();
  ?>
  <tr>
    <td style="color:var(--muted)"><?= $g['groupID'] ?></td>
    <td><?= htmlspecialchars($g['groupName']) ?></td>
    <td><?= $g['sortOrder'] ?></td>
    <td><span class="badge badge-group"><?= $cnt ?></span></td>
    <td style="display:flex;gap:.4rem;justify-content:flex-end;">
      <a href="?edit=<?= $g['groupID'] ?>" class="btn btn-sm btn-teal">Edit</a>
      <form method="POST" onsubmit="return confirm('Delete group and ALL its items?')">
        <input type="hidden" name="action" value="delete">
        <input type="hidden" name="groupID" value="<?= $g['groupID'] ?>">
        <button class="btn btn-sm btn-danger">Delete</button>
      </form>
    </td>
  </tr>
  <?php endforeach; ?>
  </tbody>
</table>
<?php admin_foot(); ?>