List not found. It may have expired or the link is wrong.
'); } $activityIds = array_map('intval', explode(',', $row['activity_ids'])); if (empty($activityIds)) { die('No activities stored for this hash.
'); } // Fetch the selected activity names for display $ph = implode(',', array_fill(0, count($activityIds), '?')); $stmt = $pdo->prepare(" SELECT a.activityName FROM activities a WHERE a.activityID IN ($ph) ORDER BY a.activityName "); $stmt->execute($activityIds); $activityNames = $stmt->fetchAll(PDO::FETCH_COLUMN); // Get all items for these activities, deduplicated, grouped by item_group. // When the same item is mapped to multiple selected activities with different // quantities, take the MAX so we reflect the highest need across activities. $stmt = $pdo->prepare(" SELECT ig.groupID, ig.groupName, ig.sortOrder AS groupSort, i.itemID, i.itemName, i.sortOrder AS itemSort, MAX(aim.quantity) AS quantity FROM activity_item_map aim JOIN items i ON i.itemID = aim.itemID JOIN item_groups ig ON ig.groupID = i.groupID WHERE aim.activityID IN ($ph) GROUP BY ig.groupID, ig.groupName, ig.sortOrder, i.itemID, i.itemName, i.sortOrder ORDER BY ig.sortOrder, ig.groupID, i.sortOrder, i.itemID "); $stmt->execute($activityIds); $allItems = $stmt->fetchAll(); // Group items by item_group $grouped = []; foreach ($allItems as $item) { $gid = $item['groupID']; if (!isset($grouped[$gid])) { $grouped[$gid] = ['name' => $item['groupName'], 'items' => []]; } $grouped[$gid]['items'][] = [ 'id' => $item['itemID'], 'name' => $item['itemName'], 'quantity' => (int)$item['quantity'], ]; } $pageUrl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $totalItems = count($allItems); ?>