';
$html .= '| ' . date("Y-m-d", $shift['start']) . ' | ';
$html .= '' . date("H:i", $shift['start']) . ' - ' . date("H:i", $shift['end']) . ' | ';
$html .= '' . $shift['Name'] . ' | ';
$html .= '' . $shift['name'];
$needed_angel_types_source = sql_select("SELECT DISTINCT `AngelTypes`.* FROM `ShiftEntry` JOIN `AngelTypes` ON `ShiftEntry`.`TID`=`AngelTypes`.`id` WHERE `ShiftEntry`.`SID`=" . sql_escape($shift['SID']) . " ORDER BY `AngelTypes`.`name`");
foreach($needed_angel_types_source as $needed_angel_type) {
$html .= '
' . $needed_angel_type['name'] . ': ';
$users_source = sql_select("SELECT `User`.* FROM `ShiftEntry` JOIN `User` ON `ShiftEntry`.`UID`=`User`.`UID` WHERE `ShiftEntry`.`SID`=" . sql_escape($shift['SID']) . " AND `ShiftEntry`.`TID`=" . sql_escape($needed_angel_type['id']));
$shift_entries = array();
foreach($users_source as $user_source) {
$shift_entries[] = $user_source['Nick'];
}
$html .= join(", ", $shift_entries);
$timesum += ($shift['end'] - $shift['start']) / (60*60);
}
$html .= ' | ';
$html .= '' . $shift['Comment'] . ' | ';
$html .= '';
if ($id == $user['UID'])
$html .= img_button(page_link_to('user_myshifts') . '&edit=' . $shift['id'], 'pencil', 'edit');
if (($shift['start'] - time() > $LETZTES_AUSTRAGEN * 3600) || in_array('user_shifts_admin', $privileges))
$html .= img_button(page_link_to('user_myshifts') . (($id != $user['UID'])? '&id=' . $id : '') . '&cancel=' . $shift['id'], 'cross', 'sign_off');
$html .= ' | ';
$html .= '
';
}
if ($html == "")
$html = '