diff options
| author | Philip Häusler <msquare@notrademark.de> | 2013-12-30 15:40:07 +0100 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2013-12-30 15:40:07 +0100 |
| commit | 8c2157c5462ef27c1b9c587ae0b112ea1925b7db (patch) | |
| tree | bf0eb26629ee2e279429d9df72008ae9e2593272 /includes | |
| parent | 493a29ea884580dba853c1542159b5bf478356ad (diff) | |
shirt statistics
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/pages/admin_active.php | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/includes/pages/admin_active.php b/includes/pages/admin_active.php index 41fa69a8..ac8a53c2 100644 --- a/includes/pages/admin_active.php +++ b/includes/pages/admin_active.php @@ -125,6 +125,14 @@ function admin_active() { $matched_users[] = $usr; } + + $shirt_statistics = sql_select(" + SELECT `Size`, count(`Size`) AS `count` + FROM `User` + WHERE `Tshirt`=1 + GROUP BY `Size` + ORDER BY `count` DESC"); + return page(array( form(array( form_text('search', _("Search angel:"), $search), @@ -144,7 +152,12 @@ function admin_active() { 'force_active' => _("Forced"), 'tshirt' => _("T-shirt?"), 'actions' => "" - ), $matched_users) + ), $matched_users), + '<h2>' . _("Given shirts") . '</h2>', + table(array( + 'Size' => _("Size"), + 'count' => _("Count") + ), $shirt_statistics) )); } ?> |