summaryrefslogtreecommitdiff
path: root/includes/pages
diff options
context:
space:
mode:
Diffstat (limited to 'includes/pages')
-rw-r--r--includes/pages/admin_arrive.php68
1 files changed, 56 insertions, 12 deletions
diff --git a/includes/pages/admin_arrive.php b/includes/pages/admin_arrive.php
index 399cb335..60e1fe2c 100644
--- a/includes/pages/admin_arrive.php
+++ b/includes/pages/admin_arrive.php
@@ -31,6 +31,7 @@ function admin_arrive() {
}
$users = sql_select("SELECT * FROM `User` ORDER BY `Nick`");
+ $arrival_count_at_day = array();
$table = "";
$users_matched = array();
if ($search == "")
@@ -49,20 +50,36 @@ function admin_arrive() {
if (! $match)
continue;
}
- $table .= '<tr>';
- $table .= '<td>' . User_Nick_render($usr) . '</td>';
+
$usr['nick'] = User_Nick_render($usr);
- $usr['planned_arrival_date'] = date('Y-m-d', $usr['planned_arrival_date']);
- $usr['arrival_date'] = $usr['arrival_date'] > 0 ? date('Y-m-d', $usr['arrival_date']) : "-";
+ $usr['rendered_planned_arrival_date'] = date('Y-m-d', $usr['planned_arrival_date']);
+ $usr['rendered_arrival_date'] = $usr['arrival_date'] > 0 ? date('Y-m-d', $usr['arrival_date']) : "-";
$usr['arrived'] = $usr['Gekommen'] == 1 ? _("yes") : "";
$usr['actions'] = $usr['Gekommen'] == 1 ? '<a href="' . page_link_to('admin_arrive') . '&reset=' . $usr['UID'] . '&search=' . $search . '">' . _("reset") . '</a>' : '<a href="' . page_link_to('admin_arrive') . '&arrived=' . $usr['UID'] . '&search=' . $search . '">' . _("arrived") . '</a>';
- if ($usr['Gekommen'] == 1)
- $table .= '<td>yes</td><td><a href="' . page_link_to('admin_arrive') . '&reset=' . $usr['UID'] . '&search=' . $search . '">reset</a></td>';
- else
- $table .= '<td></td><td><a href="' . page_link_to('admin_arrive') . '&arrived=' . $usr['UID'] . '&search=' . $search . '">arrived</a></td>';
- $table .= '</tr>';
+
+ $day = $usr['arrival_date'] > 0 ? date('Y-m-d', $usr['arrival_date']) : date('Y-m-d', $usr['planned_arrival_date']);
+ if (! isset($arrival_count_at_day[$day]))
+ $arrival_count_at_day[$day] = 0;
+ $arrival_count_at_day[$day] ++;
+
$users_matched[] = $usr;
}
+
+ ksort($arrival_count_at_day);
+
+ $arrival_count = array();
+ $arrival_sums = array();
+ $arrival_sum = 0;
+ foreach ($arrival_count_at_day as $day => $count) {
+ $arrival_sum += $count;
+ $arrival_sums[$day] = $arrival_sum;
+ $arrival_count[] = array(
+ 'day' => $day,
+ 'count' => $count,
+ 'sum' => $arrival_sum
+ );
+ }
+
return page_with_title(admin_arrive_title(), array(
msg(),
form(array(
@@ -71,11 +88,38 @@ function admin_arrive() {
)),
table(array(
'nick' => _("Nickname"),
- 'planned_arrival_date' => _("Planned date"),
+ 'rendered_planned_arrival_date' => _("Planned date"),
'arrived' => _("Arrived?"),
- 'arrival_date' => _("Arrival date"),
+ 'rendered_arrival_date' => _("Arrival date"),
'actions' => ""
- ), $users_matched)
+ ), $users_matched),
+ heading(_("Arrival statistics"), 2),
+ table(array(
+ 'day' => _("Date"),
+ 'count' => _("arrived"),
+ 'sum' => _("arrived sum")
+ ), $arrival_count),
+ '<canvas id="daily_arrives" style="width: 100%; height: 300px;"></canvas>
+ <script type="text/javascript">
+ $(function(){
+ var ctx = $("#daily_arrives").get(0).getContext("2d");
+ new Chart(ctx).Bar(' . json_encode(array(
+ 'labels' => array_keys($arrival_count_at_day),
+ 'datasets' => array(
+ array(
+ 'label' => _("arrived"),
+ 'fillColor' => "#444",
+ 'data' => array_values($arrival_count_at_day)
+ ),
+ array(
+ 'label' => _("arrived sum"),
+ 'fillColor' => "#888",
+ 'data' => array_values($arrival_sums)
+ )
+ )
+ )) . ');
+ });
+ </script>'
));
}
?>