Feedback Collection

submit_feedback.php?user_id={user_id}&game_id={game_id}

<!-- Star Rating UI (submit_feedback.php:106-116) -->
<div class="flex gap-4">
    <label class="cursor-pointer group">
        <input type="radio" name="rating" value="5" checked>
        <div class="w-14 h-14 rounded-2xl peer-checked:bg-amber-50 peer-checked:border-amber-400">
            <i data-lucide="star" class="w-7 h-7"></i>
        </div>
    </label>
</div>

Valoración Promedio: 4.2 ⭐⭐⭐⭐⭐
Total de Comentarios: 127 REGISTROS
Índice de Satisfacción: 84% [████████▌─]

?start_date=2024-01-01&end_date=2024-03-31

?client_id=42

?game_id=15

?rating=1  # Show only 1-star feedback

?client_id=10&game_id=25&rating=5&start_date=2024-01-01&end_date=2024-12-31

┌─────────────────────────────────────────────────────────────┐
│  👤 Juan Pérez                    📅 15 Mar, 2024            │
│  ⭐⭐⭐⭐⭐ • DILEMA: Ethics Challenge                        │
│  ┃ "Excellent content and engaging scenarios. The          │
│  ┃  dilemma really made me think about my decision-        │
│  ┃  making process in complex situations."                 │
│                                           🏢 Acme Corp      │
└─────────────────────────────────────────────────────────────┘

┌─────────────────────────────────┐
│       💬 (large icon)           │
│   Sin feedback aún              │
│                                 │
│   Cuando los participantes      │
│   dejen sus comentarios         │
│   aparecerán en esta sección.  │
└─────────────────────────────────┘

CREATE TABLE `de_app_feedback` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `userId` BIGINT NOT NULL,
  `gameId` BIGINT NOT NULL,
  `rating` INT NOT NULL,
  `comment` TEXT,
  `createdAt` DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

// Client association query (feedback.php:42-43)
(SELECT pm.meta_value FROM de_postmeta pm 
 WHERE pm.post_id = g.ID AND pm.meta_key = '_cliente_asociado' LIMIT 1) as client_id

// Access restriction (feedback.php:7-10)
if (!check_is_admin()) {
    header('Location: ' . SITE_URL . '/');
    exit;
}

// Feedback indicator in winners table (winners.php:213-218)
<?php if ($winner['has_feedback']): ?>
    <div class="bg-green-50 text-green-700">
        <i data-lucide="message-square"></i> Feedback OK
    </div>
    <div class="flex text-yellow-500">
        <!-- Star rating display -->
    </div>
<?php endif; ?>