204 lines
6.2 KiB
PHP
204 lines
6.2 KiB
PHP
<?php
|
|
//echo'<pre>'; print_r($fz); echo'</pre>';
|
|
if(isset($_GET['id']) && $_GET['id']>0) {
|
|
$fz = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$_GET['id']."'");
|
|
}
|
|
$typ=0; $template->assign('anz',9);
|
|
if(isset($_POST['update1'])) {
|
|
$now=time(); $typ=1;
|
|
$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,km)
|
|
VALUES(
|
|
'".$_GET['id']."',
|
|
'".$now."',
|
|
'".$_SESSION['benutzer']."',
|
|
'".$typ."',
|
|
'".$_POST['updatekm']."')
|
|
");
|
|
$success="km-Stand aktualisiert !"; $template->assign('success', $success);
|
|
}
|
|
if(isset($_POST['kontrolle'])) {
|
|
$now=time(); $typ=2;
|
|
$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
|
|
$bremse=0; $oel=0; $reifen=0; $ww=0;
|
|
if(isset($_POST['bremse'])) { $bremse=1; }
|
|
if(isset($_POST['oel'])) { $oel=1; }
|
|
if(isset($_POST['reifen'])) { $reifen=1; }
|
|
if(isset($_POST['ww'])) { $ww=1; }
|
|
|
|
$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,k_bremse,k_oel,k_reifen,k_ww,km)
|
|
VALUES(
|
|
'".$_GET['id']."',
|
|
'".$now."',
|
|
'".$_SESSION['benutzer']."',
|
|
'".$typ."',
|
|
'".$bremse."',
|
|
'".$oel."',
|
|
'".$reifen."',
|
|
'".$ww."',
|
|
'".$_POST['updatekm']."')
|
|
");
|
|
$success="kontrolle aktualisiert !"; $template->assign('success', $success);
|
|
}
|
|
if(isset($_POST['tanken'])) {
|
|
$now=time(); $typ=3;
|
|
$tankm=str_replace(',', '.',$_POST['tank']);
|
|
$km=str_replace('.', '',$_POST['updatekm']);
|
|
$tanks=str_replace(',', '.',$_POST['updatesum']);
|
|
$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,tank,tsumme,km)
|
|
VALUES(
|
|
'".$_GET['id']."',
|
|
'".$now."',
|
|
'".$_SESSION['benutzer']."',
|
|
'".$typ."',
|
|
'".$tankm."',
|
|
'".$tanks."',
|
|
'".$km."')
|
|
");
|
|
$success="km-Stand aktualisiert !"; $template->assign('success', $success);
|
|
}
|
|
if(isset($_POST['os'])) {
|
|
$now=time(); $typ=4;
|
|
$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$_POST['updatekm']."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,ow,km)
|
|
VALUES(
|
|
'".$_GET['id']."',
|
|
'".$now."',
|
|
'".$_SESSION['benutzer']."',
|
|
'".$typ."',
|
|
'".$_POST['os']."',
|
|
'".$_POST['updatekm']."')
|
|
");
|
|
$success="km-Stand aktualisiert !"; $template->assign('success', $success);
|
|
}
|
|
if(isset($_POST['at'])) {
|
|
$now = mktime(10, 0, 0,$_POST['tm'],$_POST['td'],$_POST['tj']);
|
|
$typ=3;
|
|
$tankm=str_replace(',', '.',$_POST['tank']);
|
|
$km=str_replace('.', '',$_POST['updatekm']);
|
|
$tanks=str_replace(',', '.',$_POST['updatesum']);
|
|
if ($fz['istkm']<$_POST['updatekm']) {
|
|
$GLOBALS['mysql']->insert("UPDATE fahrzeuge SET istkm='".$km."',istkmdate='".$now."' WHERE id='".$_GET['id']."'");
|
|
}
|
|
$GLOBALS['mysql']->insert("INSERT INTO fahrzeug_log (fid,date,benutzer,utyp,tank,tsumme,km)
|
|
VALUES(
|
|
'".$_GET['id']."',
|
|
'".$now."',
|
|
'".$_SESSION['benutzer']."',
|
|
'".$typ."',
|
|
'".$tankm."',
|
|
'".$tanks."',
|
|
'".$km."')
|
|
");
|
|
$success="km-Stand aktualisiert !"; $template->assign('success', $success);
|
|
}
|
|
//-------------------------------------------------------------------------------------
|
|
if(isset($_GET['delete']) && $_GET['delete']>0) {
|
|
$GLOBALS['mysql']->query("DELETE FROM fahrzeug_log WHERE id='".$_GET['delete']."'");
|
|
$error="Hinweis: Tankeintrag geloescht";
|
|
$template->assign('error', $error);
|
|
|
|
}
|
|
//-------------------------------------------------------------------------------------
|
|
|
|
if(isset($_GET['id']) && $_GET['id']>0) {
|
|
if (strlen($fz['kba3'])!=3) { $fz['kba3']=substr($fz['kba3'],0,3); }
|
|
$kb = $GLOBALS['mysql']->query_single("SELECT * FROM kba WHERE kba2='".$fz['kba2']."' and kba3='".$fz['kba3']."'");
|
|
$ol = $GLOBALS['mysql']->query_single("SELECT * FROM oel WHERE id='".$fz['osorte']."'");
|
|
//------ History
|
|
$his=$GLOBALS['mysql']->query("SELECT * FROM fahrzeug_log WHERE fid='".$_GET['id']."' ORDER BY date DESC LIMIT 0,50"); $key=0;
|
|
while($row = $his->fetch_assoc()) {
|
|
if ($row['date']>time()-(3600)) { $hist[$key]['anz']=1; } else { $hist[$key]['anz']=0; }
|
|
$hist[$key]['name'] = $_SESSION['ma_all'][$row['benutzer']]['name'];
|
|
$hist[$key]['fid'] = $row['fid'];
|
|
$hist[$key]['id'] = $row['id'];
|
|
$hist[$key]['utyp'] = $row['utyp'];
|
|
$hist[$key]['date'] = $row['date'];
|
|
$hist[$key]['kmst'] = $row['km'];
|
|
$hist[$key]['ow'] = $row['ow'];
|
|
$hist[$key]['sani'] = $row['sani'];
|
|
$hist[$key]['k_bremse'] = $row['k_bremse'];
|
|
$hist[$key]['k_reifen'] = $row['k_reifen'];
|
|
$hist[$key]['k_oel'] = $row['k_oel'];
|
|
$hist[$key]['k_ww'] = $row['k_ww'];
|
|
$hist[$key]['tank'] = $row['tank'];
|
|
$hist[$key]['tsumme'] = $row['tsumme'];
|
|
$hist[$key]['re_check'] = $row['re_check'];
|
|
if($row['utyp']==3) {
|
|
$dkm = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE date<'".$row['date']."' AND fid='".$_GET['id']."' AND utyp=3 ORDER BY date DESC LIMIT 1"); $hist[$key]['tanz']=0;
|
|
if($dkm['num_rows']!=0) {
|
|
$hist[$key]['dvb']=round(($row['tank']/($row['km']-$dkm['km']))*100, 1);
|
|
if($hist[$key]['dvb']<12) { $hist[$key]['tanz']=1; }
|
|
if($hist[$key]['dvb']>=12) { $hist[$key]['tanz']=2; }
|
|
if($hist[$key]['dvb']< 7) { $hist[$key]['tanz']=3; }
|
|
if($hist[$key]['dvb']>16) { $hist[$key]['tanz']=4; }
|
|
$hist[$key]['dvb']="Ø ".$hist[$key]['dvb']." ltr.";
|
|
}
|
|
}
|
|
$key++;
|
|
}
|
|
|
|
$template->assign('history', $hist);
|
|
$template->assign('typ', $typ);
|
|
$template->assign('oel', $ol);
|
|
$template->assign('kba', $kb);
|
|
$template->assign('fahrzeug', $fz);
|
|
$template->assign('anz', 1);
|
|
}
|
|
|
|
|
|
//menue
|
|
$fahrzeuge_a = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE aktiv>0 AND besitz<3 AND besitz>0 ORDER by kz");
|
|
//ölsorten
|
|
$oels = $GLOBALS['mysql']->query_array("SELECT * FROM oel ORDER by id");
|
|
|
|
|
|
|
|
$template->assign('owtime', strtotime("+1 years"));
|
|
$template->assign('zrtime', strtotime("+5 years"));
|
|
$template->assign('realtime', time());
|
|
$template->assign('typ', $typ);
|
|
$template->assign('oels', $oels);
|
|
$template->assign('monat', date('m'));
|
|
$template->assign('jahr', date('Y'));
|
|
|
|
$template->assign('fahrzeuge_a', $fahrzeuge_a);
|
|
|
|
$template->assign('content', 'tpl/w_fahrzeuge.tpl');
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|