<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<meta charset="UTF-8">
<?php
// echo'<pre>'; print_r($ljahr); echo'</pre>';	
$_SESSION['m1']=8; $_SESSION['m2']=2;
error_reporting(E_ALL); 	ini_set('display_errors',0);
 
$anzeige=0; if(isset($_GET['id'])) { $anzeige=$_GET['id']; }
$jahr = (int)date('Y');

//----------------------------------------------------------------------------------------------------------------
//----- neuer MA
if(isset($_POST['neu'])) { 
$check = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id < 999 ORDER BY id DESC");
$check['id']++;
$GLOBALS['mysql']->insert("INSERT INTO fahrzeuge (id,name,mail,handy,aktiv) VALUES('".$check['id']."','".$_POST['name']."','".$_POST['mail']."','".$_POST['handy']."',1)"); }
//----- Car ändern speichern
if(isset($_POST['save'])) {
	$s_vid=$_POST['vid'];
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET kz='".$_POST['kz']."' WHERE id='".$s_vid."'"); 
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET hersteller='".$_POST['hersteller']."' WHERE id='".$s_vid."'"); 
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET name='".$_POST['name']."' WHERE id='".$s_vid."'"); 
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET kba2='".$_POST['kba2']."' WHERE id='".$s_vid."'"); 
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET kba3='".$_POST['kba3']."' WHERE id='".$s_vid."'"); 
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET fin='".$_POST['fin']."' WHERE id='".$s_vid."'"); 	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET ezltag='".$_POST['ezltag']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET ezlmonat='".$_POST['ezlmonat']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET ezljahr='".$_POST['ezljahr']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET jbtag='".$_POST['jbtag']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET jbmonat='".$_POST['jbmonat']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET jbjahr='".$_POST['jbjahr']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET typ='".$_POST['typ']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET aktiv='".$_POST['aktiv']."' WHERE id='".$s_vid."'");	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET besitz='".$_POST['besitz']."' WHERE id='".$s_vid."'");	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET typ='".$_POST['typ']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET osorte='".$_POST['osorte']."' WHERE id='".$s_vid."'");	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET besitz='".$_POST['besitz']."' WHERE id='".$s_vid."'");	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET reifen='".$_POST['reifen']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET ccm='".$_POST['ccm']."' WHERE id='".$s_vid."'");
		$newdate=mktime(0, 0, 0, $_POST['humonat'], 1,$_POST['hujahr']); // hu datum monat in timestamp
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET hudate='".$newdate."' WHERE id='".$s_vid."'");	
	$newdate=mktime(0, 0, 0, $_POST['sanimonat'], 1,$_POST['sanijahr']); // sani datum monat in timestamp
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET sanidate='".$newdate."' WHERE id='".$s_vid."'");																				
	$fkw=0; $fps=0; 
	if($_POST['kw']>0) {
		$fkw=$_POST['kw'];
		$fps=($fkw*1.35962);
	} else {
		$fps=$_POST['ps'];
		$fkw=($fps*0.735499);
	}
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET kw='".$fkw."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET ps='".$fps."' WHERE id='".$s_vid."'");		
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET lvzkarte='".$_POST['lvzkarte']."' WHERE id='".$s_vid."'");																	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET tankpin='".$_POST['tankpin']."' WHERE id='".$s_vid."'");																	
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET zfeld1='".$_POST['zfeld1']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET zfeld2='".$_POST['zfeld2']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET zfeld3='".$_POST['zfeld3']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET zfeld4='".$_POST['zfeld4']."' WHERE id='".$s_vid."'");
	$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET sfk='".$_POST['sfk']."' WHERE id='".$s_vid."'");	

//	$fahrzeug = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$s_vid."'");	
//	$template->assign('fahrzeug', $fahrzeug);																																							
}


//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
$oel = $GLOBALS['mysql']->query_array("SELECT * FROM oel");	
$typ = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeugtyp");	
$besitzer = $GLOBALS['mysql']->query_array("SELECT * FROM besitzer");	
if($anzeige>0) { $fahrzeug = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$anzeige."'"); $template->assign('fahrzeug', $fahrzeug);	}
$madata1 = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE typ=1 AND aktiv>1 ORDER by kz");	
$madata2 = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE typ=2 AND aktiv>1 ORDER by kz");	
$madata3 = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE typ>2 AND aktiv>1 ORDER by kz");	
$template->assign('madata1', $madata1);	
$template->assign('madata2', $madata2);	
$template->assign('madata3', $madata3);	
$template->assign('anzeige',$anzeige);	
$template->assign('besitzer', $besitzer);	
$template->assign('typ', $typ);	
$template->assign('oel', $oel);	

$template->assign('content', 'tpl/c_sonstige.tpl');		

?>