summaryrefslogtreecommitdiff
path: root/includes/pages
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2015-08-14 14:16:09 +0200
committerPhilip Häusler <msquare@notrademark.de>2015-08-14 14:16:09 +0200
commit28788e6702987ebe3234e6af29575d595997a324 (patch)
treeabe5b22ded56db7b68a5fc358d16c980bbac48c3 /includes/pages
parente8daa4d2ce91a5376b3770a8cd60385339b67a81 (diff)
put shirt statistics into one table
Diffstat (limited to 'includes/pages')
-rw-r--r--includes/pages/admin_active.php58
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)
));
}
?>