112 lines
5.8 KiB
PHP
112 lines
5.8 KiB
PHP
<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 tankkarte='".$_POST['tankkarte']."' 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=0 ORDER by kz");
|
|
$madata2 = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE typ=2 AND aktiv=0 ORDER by kz");
|
|
$madata3 = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE typ>2 AND aktiv=0 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_inaktiv.tpl');
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|