diff options
author | Philip Häusler <msquare@notrademark.de> | 2013-12-29 13:26:09 +0100 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2013-12-29 13:26:09 +0100 |
commit | 1174b11c0ad47f6677a38af023d20ac9c1d456e2 (patch) | |
tree | f881b52b32e3efbe9491080624c52d0b48ee52a1 | |
parent | 299652e070f4e44ff5e53043d02deb121561f950 (diff) |
display freeloads in angel list
-rw-r--r-- | includes/pages/admin_user.php | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/includes/pages/admin_user.php b/includes/pages/admin_user.php index 7b1fd22d..f3a6fa56 100644 --- a/includes/pages/admin_user.php +++ b/includes/pages/admin_user.php @@ -304,6 +304,7 @@ function admin_user() { 'Alter' => htmlspecialchars($angel['Alter']), 'email' => '<a href="mailto:' . htmlspecialchars($angel['email']) . '">' . htmlspecialchars($angel['email']) . '</a>' . $popup, 'Gekommen' => '<img src="pic/icons/' . ($angel['Gekommen'] == 1 ? 'tick' : 'cross') . '.png" alt="' . $angel['Gekommen'] . '">', + 'freeloads' => sql_select_single_cell("SELECT COUNT(*) FROM `ShiftEntry` WHERE `freeloaded` = 1 AND `UID` = " . sql_escape($angel['UID'])), 'Aktiv' => '<img src="pic/icons/' . ($angel['Aktiv'] == 1 ? 'tick' : 'cross') . '.png" alt="' . $angel['Aktiv'] . '">', 'force_active' => '<img src="pic/icons/' . ($angel['force_active'] == 1 ? 'tick' : 'cross') . '.png" alt="' . $angel['force_active'] . '">', 'Tshirt' => '<img src="pic/icons/' . ($angel['Tshirt'] == 1 ? 'tick' : 'cross') . '.png" alt="' . $angel['Tshirt'] . '">', @@ -315,11 +316,15 @@ function admin_user() { $angels = array_map('prepare_angel_table', $angels); $Gekommen = sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `Gekommen` = 1"); $Active = sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `Aktiv` = 1"); + $force_active_count = sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `force_active` = 1"); + $freeloads_count = sql_select_single_cell("SELECT COUNT(*) FROM `ShiftEntry` WHERE `freeloaded` = 1"); $Tshirt = sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `Tshirt` = 1"); $angels[] = array( 'Nick' => '<strong>Summe</strong>', 'Gekommen' => $Gekommen, 'Aktiv' => $Active, + 'force_active' => $force_active_count, + 'freeloads' => $freeloads_count, 'Tshirt' => $Tshirt ); $html .= table(array( @@ -329,6 +334,7 @@ function admin_user() { 'Alter' => '<a href="' . page_link_to("admin_user") . '&OrderBy=Alter">Alter</a>', 'email' => '<a href="' . page_link_to("admin_user") . '&OrderBy=email">E-Mail</a>', 'Gekommen' => '<div class="rotate"><a href="' . page_link_to("admin_user") . '&OrderBy=Gekommen">Gekommen</a></div>', + 'freeloads' => '<div class="rotate">' . _("Freeloads") . '</div>', 'Aktiv' => '<div class="rotate"><a href="' . page_link_to("admin_user") . '&OrderBy=Aktiv">Aktiv</a></div>', 'force_active' => '<div class="rotate"><a href="' . page_link_to("admin_user") . '&OrderBy=force_active">' . _("Forced") . '</a></div>', 'Tshirt' => '<div class="rotate"><a href="' . page_link_to("admin_user") . '&OrderBy=Tshirt">T-Shirt</a></div>', |