diff options
| author | Philip Häusler <msquare@notrademark.de> | 2015-08-14 14:16:09 +0200 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2015-08-14 14:16:09 +0200 |
| commit | 28788e6702987ebe3234e6af29575d595997a324 (patch) | |
| tree | abe5b22ded56db7b68a5fc358d16c980bbac48c3 /includes | |
| parent | e8daa4d2ce91a5376b3770a8cd60385339b67a81 (diff) | |
put shirt statistics into one table
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/pages/admin_active.php | 58 |
1 files changed, 22 insertions, 36 deletions
diff --git a/includes/pages/admin_active.php b/includes/pages/admin_active.php index 78796391..e3fa0996 100644 --- a/includes/pages/admin_active.php +++ b/includes/pages/admin_active.php @@ -145,26 +145,22 @@ function admin_active() { $matched_users[] = $usr; } - - $given_shirt_statistics = sql_select(" - SELECT `Size`, count(`Size`) AS `count` - FROM `User` - WHERE `Tshirt`=1 - GROUP BY `Size` - ORDER BY `Size` DESC"); - $given_shirt_statistics[] = array( - 'Size' => '<b>' . _("Sum") . '</b>', - 'count' => '<b>' . sql_select_single_cell("SELECT count(*) FROM `User` WHERE `Tshirt`=1") . '</b>' - ); - $needed_shirt_statistics = sql_select(" - SELECT `Size`, count(`Size`) AS `count` - FROM `User` - GROUP BY `Size` - ORDER BY `Size` DESC"); - $needed_shirt_statistics[] = array( - 'Size' => '<b>' . _("Sum") . '</b>', - 'count' => '<b>' . sql_select_single_cell("SELECT count(*) FROM `User` WHERE `Tshirt`=1") . '</b>' - ); + + $shirt_statistics = []; + foreach ($tshirt_sizes as $size => $_) { + if ($size != '') { + $shirt_statistics[] = [ + 'size' => $size, + 'needed' => sql_select_single_cell("SELECT count(*) FROM `User` WHERE `Size`='" . sql_escape($size) . "' AND `Gekommen`=1"), + 'given' => sql_select_single_cell("SELECT count(*) FROM `User` WHERE `Size`='" . sql_escape($size) . "' AND `Tshirt`=1") + ]; + } + } + $shirt_statistics[] = [ + 'size' => '<b>' . _("Sum") . '</b>', + 'needed' => '<b>' . User_arrived_count() . '</b>', + 'given' => '<b>' . sql_select_single_cell("SELECT count(*) FROM `User` WHERE `Tshirt`=1") . '</b>' + ]; return page_with_title(admin_active_title(), array( form(array( @@ -187,22 +183,12 @@ function admin_active() { 'tshirt' => _("T-shirt?"), 'actions' => "" ), $matched_users), - div('row', [ - div('col-md-6', [ - '<h2>' . _("Needed shirts") . '</h2>' , - table(array( - 'Size' => _("Size"), - 'count' => _("Count") - ), $needed_shirt_statistics) - ]), - div('col-md-6', [ - '<h2>' . _("Given shirts") . '</h2>', - table(array( - 'Size' => _("Size"), - 'count' => _("Count") - ), $given_shirt_statistics) - ]) - ]) + '<h2>' . _("Shirt statistics") . '</h2>', + table(array( + 'size' => _("Size"), + 'needed' => _("Needed shirts"), + 'given' => _("Given shirts") + ), $shirt_statistics) )); } ?> |