function admin_arrive()
{
$msg = "";
$search = "";
if (isset($_REQUEST['search'])) {
$search = strip_request_item('search');
}
if (isset($_REQUEST['reset']) && preg_match("/^[0-9]*\$/", $_REQUEST['reset'])) {
$id = $_REQUEST['reset'];
$user_source = User($id);
if ($user_source != null) {
sql_query("UPDATE `User` SET `Gekommen`=0, `arrival_date` = NULL WHERE `UID`='" . sql_escape($id) . "' LIMIT 1");
engelsystem_log("User set to not available: " . User_Nick_render($user_source));
$msg = success(_("Reset done. Angel is not available."), true);
} else {
$msg = error(_("Angel not found."), true);
}
} elseif (isset($_REQUEST['arrived']) && preg_match("/^[0-9]*\$/", $_REQUEST['arrived'])) {
$id = $_REQUEST['arrived'];
$user_source = User($id);
if ($user_source != null) {
sql_query("UPDATE `User` SET `Gekommen`=1, `arrival_date`='" . time() . "' WHERE `UID`='" . sql_escape($id) . "' LIMIT 1");
engelsystem_log("User is available: " . User_Nick_render($user_source));
$msg = success(_("Angel has been marked as available."), true);
} else {
$msg = error(_("Angel not found."), true);
}
}
$users = sql_select("SELECT * FROM `User` ORDER BY `Nick`");
$arrival_count_at_day = [];
$planned_arrival_count_at_day = [];
$planned_departure_count_at_day = [];
$table = "";
$users_matched = [];
if ($search == "") {
$tokens = [];
} else {
$tokens = explode(" ", $search);
}
foreach ($users as $usr) {
if (count($tokens) > 0) {
$match = false;
$index = join(" ", $usr);
foreach ($tokens as $t) {
if (stristr($index, trim($t))) {
$match = true;
break;
}
}
if (!$match) {
continue;
}
}
$usr['nick'] = User_Nick_render($usr);
if ($usr['planned_departure_date'] != null) {
$usr['rendered_planned_departure_date'] = date('Y-m-d', $usr['planned_departure_date']);
} else {
$usr['rendered_planned_departure_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 . '">' . _("available") . '</a>';
if ($usr['arrival_date'] > 0) {
$day = date('Y-m-d', $usr['arrival_date']);
if (!isset($arrival_count_at_day[$day])) {
$arrival_count_at_day[$day] = 0;
}
$arrival_count_at_day[$day]++;
}
if ($usr['planned_arrival_date'] != null) {
$day = date('Y-m-d', $usr['planned_arrival_date']);
if (!isset($planned_arrival_count_at_day[$day])) {
$planned_arrival_count_at_day[$day] = 0;
}
$planned_arrival_count_at_day[$day]++;
}
if ($usr['planned_departure_date'] != null && $usr['Gekommen'] == 1) {
$day = date('Y-m-d', $usr['planned_departure_date']);
if (!isset($planned_departure_count_at_day[$day])) {
$planned_departure_count_at_day[$day] = 0;
}
$planned_departure_count_at_day[$day]++;
}
$users_matched[] = $usr;
}
ksort($arrival_count_at_day);
ksort($planned_arrival_count_at_day);
ksort($planned_departure_count_at_day);
$arrival_at_day = [];
$arrival_sum = 0;
foreach ($arrival_count_at_day as $day => $count) {
$arrival_sum += $count;
$arrival_at_day[$day] = ['day' => $day, 'count' => $count, 'sum' => $arrival_sum];
}
$planned_arrival_sum_at_day = [];
$planned_arrival_sum = 0;
foreach ($planned_arrival_count_at_day as $day => $count) {
$planned_arrival_sum += $count;
$planned_arrival_at_day[$day] = ['day' => $day, 'count' => $count, 'sum' => $planned_arrival_sum];
}
$planned_departure_at_day = [];
$planned_departure_sum = 0;
foreach ($planned_departure_count_at_day as $day => $count) {
$planned_departure_sum += $count;
$planned_departure_at_day[$day] = ['day' => $day, 'count' => $count, 'sum' => $planned_departure_sum];
}
return page_with_title(admin_arrive_title(), array(msg(), form(array(form_text('search', _("Search"), $search), form_submit('submit', _("Search")))), table(array('nick' => _("Nickname"), 'rendered_planned_arrival_date' => _("Planned start of availability"), 'arrived' => _("Available?"), 'rendered_arrival_date' => _("Start of availability"), 'rendered_planned_departure_date' => _("Planned end of availability"), 'actions' => ""), $users_matched), div('row', [div('col-md-4', [heading(_("Planned start of availability statistics"), 2), bargraph('planned_arrives', 'day', ['count' => _("available"), 'sum' => _("available sum")], ['count' => '#090', 'sum' => '#888'], $planned_arrival_at_day), table(['day' => _("Date"), 'count' => _("Count"), 'sum' => _("Sum")], $planned_arrival_at_day)]), div('col-md-4', [heading(_("Availability statistics"), 2), bargraph('arrives', 'day', ['count' => _("available"), 'sum' => _("available sum")], ['count' => '#090', 'sum' => '#888'], $arrival_at_day), table(['day' => _("Date"), 'count' => _("Count"), 'sum' => _("Sum")], $arrival_at_day)]), div('col-md-4', [heading(_("Planned end of availability statistics"), 2), bargraph('planned_departures', 'day', ['count' => _("available"), 'sum' => _("available sum")], ['count' => '#090', 'sum' => '#888'], $planned_departure_at_day), table(['day' => _("Date"), 'count' => _("Count"), 'sum' => _("Sum")], $planned_departure_at_day)])])));
}
echo "<option>{$i}</option>";
}
echo "</select>\n";
}
echo "</td>\n";
echo "</tr></table>\n";
/* Waiting list */
echo "</td><td width=50%>\n";
if ($waiting) {
/* Entire event count */
echo "<table><tr>\n";
echo "<td>Waiting: {$waiting}</td>";
/* Bar graph */
echo "</tr><tr>\n";
echo "<td>";
bargraph($waiting, "green");
echo "</td>\n";
/* Personal count */
echo "</tr><tr>\n";
echo "<td>";
if ($userix) {
echo "You are on the waiting list {$mywaiting} time" . ($mywaiting != 1 ? "s" : "") . ".";
}
echo " </td>\n";
echo "</tr></table>\n";
echo "\n";
}
echo "</td>\n";
echo "</tr></table>\n";
/* Per-event data */
echo "<input type='hidden' name='eventix{$ix}' value='{$eventix}'>\n";
$barfragwidth = 8;
}
if ($row->capacity > 60) {
$barfragwidth = 4;
}
if ($row->capacity > 80) {
$barfragwidth = 3;
}
echo "</tr><tr>\n";
echo "<td></td>";
echo "<td colspan=3>";
bargraph2($row->reserved, "green", $row->released, "yellow", $row->capacity, "white", $barfragwidth);
echo "</td>";
echo "<td>";
if ($row->waiting) {
bargraph($row->waiting, "red");
}
echo "</td>\n";
/* Personal event counts */
echo "</tr><tr>\n";
echo "<td></td>\n";
echo "<td colspan=3 align='center' class='barlabel'>";
if ($userix) {
echo "You have {$myreserved} reservation" . ($myreserved != 1 ? "s" : "") . " for this event.";
}
echo "</td>";
echo "<td class='barlabel'>";
if ($userix && $mywaiting > 0) {
echo "You are on the<br/>waiting list {$mywaiting} time" . ($mywaiting != 1 ? "s" : "") . ".";
}
echo " </td>\n";
<table width=100%> <tr> <td colspan=2 align=center><h3>Reserved Curling - Mon Jan 9, 2011</h2></td> </tr><tr> <td width=50%> <table width=100%><tr> <td width=50% align=left>Reserved: 17 curlers</td><td width=50% align=right>Openings: 7</td> </tr><tr> <td colspan=2 width=1%><?php bargraph(17, "red", 24, "white"); ?> </td> <td><input type="button" name="event1" value="Make Reservation"></td> </tr></table> </td><td width=50%> <table width=100%><tr> <td>Waiting list: 14 curlers</td> </tr><tr> <td> <?php bargraph(14, "yellow"); ?> <input type="button" name="event1" value="Add to Waiting List"> </td> </tr></table> </tr> </table> </body> </html>
