<?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 'user_save';
	$GLOBALS['mysql']->insert("UPDATE tourenliste SET fahrer='".$_POST['user']."' WHERE id='".$_POST['tourID']."'");
	$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_POST['user']."'");
	$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']="Fahrer ".$row_fahrer['name']." für Tour ".$row_tourx['tour']." gespeichert.";
	$back['success'] = true;
	$back['alt'] = 5;
	echo json_encode($back);
break;

case 'load_free_cars';
default:

//--------------------- freie Fahrzeuge Nachts
$key=0;
//-- trp nachts

$ex = explode("-",$_POST['date']);

$tempcar = $GLOBALS['mysql']->query("SELECT f.kz, f.hersteller, f.`name`,IF(fp.tag, 1, 0) as hasPlaner,IF(tl.gewicht, 1, 0) as hasTour FROM fahrzeuge f LEFT JOIN tourenliste tl ON (tl.jahr = ".$ex[0]." and tl.monat = ".$ex[1]." and tl.tag = ".$ex[2]." and f.id = tl.auto) LEFT JOIN fplaner fp ON (fp.jahr = ".$ex[0]." and fp.monat = ".$ex[1]." and fp.tag = ".$ex[2]." AND fp.fid = f.id) WHERE f.aktiv=1 and f.besitz<3 and f.typ>2 GROUP BY f.id ORDER BY f.id"); 
while($row = $tempcar->fetch_assoc()) {
	if($row["hasPlaner"] == 0 AND $row["hasTour"] == 0) {
		$seite['trp'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
	}
}

//$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=8 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) {
//		if($pauto['num_rows']== 0) {		
//			$seite['trp'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
//		}
//	}
//}
echo json_encode($seite);


endswitch;
	

?>