<?php


if(isset($_GET['a']))
		$action=$_GET['a'];
else
	$action='load_free_cars';
switch($action):

case 'car_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET auto='".$_POST['car']."' WHERE id='".$_POST['tourID']."'");

	$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$_POST['car']."'");
	$row_tourl = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'");
	$row_tourx = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row_tourl['tour']."'");
	$back['lastnote']="Fahrzeug ".$row_autox['kz']." für Tour ".$row_tourx['tour']." gespeichert.";
	$back['success'] = true;
	$back['alt'] = 5;
	echo json_encode($back);
	
break;

case 'info_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET infotext='".$_POST['info']."' WHERE id='".$_POST['tourID']."'");
	$back['success'] = true;
	$back['lastnote']="Information: ".$_POST['info']." hinzugefügt.";
	$back['alt'] = 5;
	echo json_encode($back);

	
break;

case 'user_save';
	$GLOBALS['mysql']->insert("UPDATE karten SET user='".$_POST['user']."' WHERE id='".$_POST['kID']."'");
	$back['lastnote']="Mitarbeiter für Karte gespeichert.";
	$back['success'] = true;
	
	
	$back['alt'] = 5;
	echo json_encode($back);

	
break;


case 'load_free_cars';
default:

//--------------------- freie Fahrzeuge Nachts
    $key=0;
    //-- pkw tags
    $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ=1 ORDER BY id");
    while($row = $tempcar->fetch_assoc()) {
        $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ>5 and typ>5 and typ!=18");  // LIKE = % (egal was da steht)
        $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
        if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
            $seite['pkwtag'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
        }
    }
    //-- caddy tags
    $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ=2 ORDER BY id");
    while($row = $tempcar->fetch_assoc()) {
        $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ>5 and typ>5 and typ!=18");  // LIKE = % (egal was da steht)
        $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
        if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
            $seite['caddytag'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
        }
    }
    //-- trp tags
    $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ>2 ORDER BY id");
    while($row = $tempcar->fetch_assoc()) {
        $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ>5 and typ>5 and typ!=18");
        $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
        if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
            $seite['trptag'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
        }
    }
    //-- caddy nachts
    $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ=2 ORDER BY id");
    while($row = $tempcar->fetch_assoc()) {
        $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ<6");  // LIKE = % (egal was da steht)
        $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
        if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
            $seite['caddy'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
        }
    }
    //-- trp nachts
    $tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv=1 and besitz<3 and typ>2 ORDER BY id");
    while($row = $tempcar->fetch_assoc()) {
        $istabfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE timestamp LIKE '".$_POST['date']." %' AND auto='".$row['id']."' and typ<6");
        $pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
        if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
            $seite['trp'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
        }
    }
echo json_encode($seite);


endswitch;
	

?>