getConnection();
$query = "
-- Report
SELECT
u.name,
u.surname,
(SELECT t.created FROM token t WHERE t.user_id = u.id ORDER BY t.created ASC LIMIT 1) AS started_app,
CASE WHEN p.will_be_present IS NULL THEN '⏳' ELSE (
CASE WHEN p.will_be_present THEN '✅' ELSE '❌' END
) END as will_be_present,
p.created as when_user_answered,
p.notes
FROM `user` u
LEFT JOIN presence p
ON p.user_id = u.id
GROUP BY u.id
ORDER BY when_user_answered DESC, started_app DESC
";
$stmt = $db->prepare($query);
if (!$stmt->execute()) {
echo("Error running query!
");
exit;
}
?>
Wedding report
Wedding report
| Name | Surname | Used app | Will be present | When answered | Notes |
fetch(PDO::FETCH_ASSOC)){
?>
|
|
|
|
|
|