clarification of sprache
[fsinf/pub/w2c.git] / funcs.php
index b58749ed96a1217e043ebf1fdcdd21447fc64d25..fad9d0a0cf14a102f60eb532441e3d12f18e4c2a 100644 (file)
--- a/funcs.php
+++ b/funcs.php
@@ -7,13 +7,14 @@
 
 require_once('./settings.php');
 require_once('./db_funcs.php');
+require_once('./html_funcs.php');
 
 function login(){
-//  if(!isset($_SERVER['HTTPS'])){
-//    $url = 'https://'.$_SERVER["HTTP_HOST"].$_SERVER['REQUEST_URI'];
-//    header('Location: '.$url, true, 301);
-//    exit('<h1>Redirecting to: <a href="'.$url.'">'.$url.'</a></h1>');
-//  }
+  if(!isset($_SERVER['HTTPS'])){
+    $url = 'https://'.$_SERVER["HTTP_HOST"].$_SERVER['REQUEST_URI'];
+    header('Location: '.$url, true, 301);
+    exit('<h1>Redirecting to: <a href="'.$url.'">'.$url.'</a></h1>');
+  }
   $uinfo = db_get_uinfo($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
   if($uinfo['lvl'] >= 1){
     $GLOBALS['uname'] = $uinfo['uname'];
@@ -21,68 +22,71 @@ function login(){
   }else{
     header('WWW-Authenticate: Basic realm="WelcomeTUcode login"');
     header('HTTP/1.0 401 Unauthorized');
-    exit('Nicht eingeloggt. Falsche Anmeldedaten?');
+    exit(html_top("Anmeldesystem").html_linkbox().'<span class="statusERR">Nicht eingeloggt. Falsche Anmeldedaten?</span>'.html_bottom());
   }
 }
 
 function list_anmeldungen(){
   $liste = db_list_anmeldungen();
-  $ret = '<table border=1 class="sortable"><tr><th>Aktion</th><th>id</th><th>Anmeldung bei</th><th>Nachname(n)</th><th>Vorname(n)</th><th>Geboren</th><th>Nationalität</th><th>Sprachkenntnis</th>'.
-    '<th>Vorwissen</th><th>Analphabet</th><th>fotoerlaubnis</th><th>Videoerlaubnis</th><th>Bemerkung</th></tr>'."\n";
+  $ret = '<table id="sortable"><thead><tr><th>Aktion</th><th>id</th><th>Anmeldung bei</th><th>Nachname(n)</th><th>Vorname(n)</th><th>Geboren</th>'.
+    '<th>Nationalität</th><th>Sprachkenntnis</th><th>Vorwissen</th><th>Analphabet</th><th>Foto-</th><th>Videoerlaubnis</th>'.
+       '<th>Status</th><th>Bemerkung</th><th>Termin</th></tr></thead><tbody>'."\n";
   foreach ($liste as &$person) {
-    $ret .='<tr id="pers_'.$person['id'].'"><td><a href="./person.php?id='.$person['id'].'">Bearbeiten</a></td><td>'.$person['id'].'</td><td>'.$person['uname'].'</td>'.
-       '<td>'.$person['nname'].'</td><td>'.$person['vname'].'</td><td>'.$person['gebdatum'].'</td><td>'.$person['nationaliaet'].'</td>'.
-       '<td>'.$person['sprachen'].'</td><td>'.$person['vorwissen'].'</td><td>'.$person['analphabet'].'</td><td>'.$person['fotoerlaubnis'].'</td>'.
-       '<td>'.$person['videoerlaubnis'].'</td><td>'.$person['bemerkungen'].'</td></tr>'."\n";
-/*    echo '<div class="person" id="pers_'.$person['id'].'" style="border:1px solid black;"><div id="pers_'.$person['id'].'_vname">'.$person['vname'].'</div>
-       <div id="pers_'.$person['id'].'_nname">'.$person['nname'].'</div> <div id="pers_'.$person['id'].'_gebdatum">'.$person['gebdatum'].'</div>
-       <div id="pers_'.$person['id'].'_nationaliaet">'.$person['nationaliaet'].'</div> <div id="pers_'.$person['id'].'_sprachen">'.$person['sprachen'].'</div>
-       <div id="pers_'.$person['id'].'_vorwissen">'.$person['vorwissen'].'</div> <div id="pers_'.$person['id'].'_analphabet">'.$person['analphabet'].'</div>
-       <div id="pers_'.$person['id'].'_fotoerlaubnis">'.$person['fotoerlaubnis'].'</div> <div id="pers_'.$person['id'].'_videoerlaubnis">'.$person['videoerlaubnis'].'</div>
-       <div class="bemerkung" id="pers_'.$person['id'].'_bemerkungen">'.$person['bemerkungen'].'</div>
-       </div>';*/
+    $ret .='<tr id="pers_'.$person['id'].'"><td><a href="./person.php?id='.$person['id'].'">Bearbeiten</a></td><td>'.$person['id'].'</td>';
+       $ret .='<td>'.$person['uname'].'</td><td>'.$person['nname'].'</td><td>'.$person['vname'].'</td><td><nobr>'.$person['gebdatum'].'</nobr></td>';
+       $ret .='<td>'.$person['nationaliaet'].'</td><td>'.$person['sprachen'].'</td><td>'.$person['vorwissen'].'</td><td>'.$person['analphabet'].'</td>';
+       $ret .='<td>'.$person['fotoerlaubnis'].'</td><td>'.$person['videoerlaubnis'].'</td><td>'.$person['status'].'</td><td>'.$person['bemerkungen'].'</td>';
+       $ret .='<td>'.$person['termin'].'</td></tr>'."\n";
   }
-  return $ret.'</table>'."\n";
+  return $ret.'</tbody></table>'."\n";
 }
 
 function store_person(){
-  if(!isset($_REQUEST['delete']) && !isset($_REQUEST['save'])) return 0;
+  if(!isset($_REQUEST['delete']) && !isset($_REQUEST['save']))return;
 
 //var_export($_REQUEST);
 
   if(isset($_REQUEST['delete']))return db_delete_person($_REQUEST['id']);
   if(isset($_REQUEST['save'])){
 
-    if(!isset($_REQUEST['vname']))return '-vname- not set!';
+    if(!isset($_REQUEST['vname']))throw new Exception('NOT_SET vname');
     $pdata['vname']=$_REQUEST['vname'];
 
-    if(!isset($_REQUEST['nname']))return '-nname- not set!';
+    if(!isset($_REQUEST['nname']))throw new Exception('NOT_SET nname');
     $pdata['nname']=$_REQUEST['nname'];
 
-    if(!isset($_REQUEST['gebdatum']))return '-gebdatum- not set!';
+    if($pdata['vname'] == '' && $pdata['nname'] == '')throw new Exception('NO_NAME');
+
+    if(!isset($_REQUEST['gebdatum']))throw new Exception('NOT_SET gebdatum');
     $pdata['gebdatum']=$_REQUEST['gebdatum'];
        
-    if(!isset($_REQUEST['nationaliaet']))return '-nationaliaet- not set!';
+    if(!isset($_REQUEST['nationaliaet']))throw new Exception('NOT_SET nationalitaet');
     $pdata['nationaliaet']=$_REQUEST['nationaliaet'];
 
-    if(!isset($_REQUEST['sprachen']))return '-sprachen- not set!';
+    if(!isset($_REQUEST['sprachen']))throw new Exception('NOT_SET sprachen');
     $pdata['sprachen']=$_REQUEST['sprachen'];
 
-    if(!isset($_REQUEST['vorwissen']))return '-vorwissen- not set!';
+    if(!isset($_REQUEST['vorwissen']))throw new Exception('NOT_SET vorwissen');
     $pdata['vorwissen']=$_REQUEST['vorwissen'];
        
-    if(!isset($_REQUEST['analphabet']))return '-analphabet- not set!';
+    if(!isset($_REQUEST['analphabet']))$_REQUEST['analphabet'] = '0';
     $pdata['analphabet']=$_REQUEST['analphabet'];
 
-    if(!isset($_REQUEST['fotoerlaubnis']))return '-fotoerlaubnis- not set!';
+    if(!isset($_REQUEST['fotoerlaubnis']))$_REQUEST['fotoerlaubnis'] = '0';
     $pdata['fotoerlaubnis']=$_REQUEST['fotoerlaubnis'];
 
-    if(!isset($_REQUEST['videoerlaubnis']))return '-videoerlaubnis- not set!';
+    if(!isset($_REQUEST['videoerlaubnis']))$_REQUEST['videoerlaubnis'] = '0';
     $pdata['videoerlaubnis']=$_REQUEST['videoerlaubnis'];
 
-    if(!isset($_REQUEST['bemerkungen']))return '-bemerkungen- not set!';
+    if(!isset($_REQUEST['bemerkungen']))throw new Exception('NOT_SET bemerkungen');
     $pdata['bemerkungen']=$_REQUEST['bemerkungen'];
 
+    if(!isset($_REQUEST['termin']))throw new Exception('NOT_SET termin');
+    $pdata['termin']=$_REQUEST['termin'];
+
+    if(!isset($_REQUEST['status']))throw new Exception('NOT_SET status');
+    $pdata['status']=$_REQUEST['status'];
+
     return db_store_person($_REQUEST['id'], $pdata);
   }
 }
@@ -92,39 +96,3 @@ function get_person($id){
   return db_get_person($id);
 }
 
-function html_top($title = ""){
-       return <<<EOF
-<!DOCTYPE html>
-<html lang="de" dir="ltr">
-<head>
-<meta charset="utf-8">
-<title>$title</title>
-<link rel="stylesheet" href="style.css">
-<script src="sorttable.js"></script>
-</head>
-<body id="welcometucode">
-EOF;
-}
-
-function html_bottom(){
-       return <<<EOF
-</body>
-</html>
-EOF;
-}
-
-function html_linkbox($current = "") {
-       $items = array(
-               'index' => "Home",
-               'list' => "Anmeldungen",
-               'calendar' => "Kalender",
-               'stats' => "Stats"
-       );
-       $out = '<div id="menu" class="align-center"><h1>Anmeldesystem</h1><ul class="menulist">';
-       foreach ($items as $file => $name) {
-               $activeitem = ($current === $file) ? ' menuactive' : '';
-               $out .= '<li class="menuitem'.$activeitem.'"><a href="./'.$file.'.php">'.$name.'</a></li>';
-       }
-       $out .= '</ul></div>';
-       return $out;
-}