101 lines
4.6 KiB
PHP
101 lines
4.6 KiB
PHP
<?php
|
|
$_SESSION['m1']=4; $_SESSION['m2']=3;
|
|
// Melde alle PHP Fehler (siehe Changelog)
|
|
// error_reporting(E_ALL);
|
|
ini_set('display_errors',1);
|
|
|
|
$anzeige=0;
|
|
//-----------------------------
|
|
if(isset($_POST['toursave'])) {
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET tour='".$_POST['tour']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET tour2='".$_POST['tour2']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET tour3='".$_POST['tour3']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET aktiv='".$_POST['aktiv']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET typ='".$_POST['ttyp']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET infotitel='".$_POST['infotitel']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET s_auto='".$_POST['eauto']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET s_fahrer='".$_POST['efahrer']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET exemplare='".$_POST['exemplare']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET retyp='".$_POST['retyp']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET km='".$_POST['km']."' WHERE id='".$_GET['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET preis='".$_POST['preis']."' WHERE id='".$_GET['id']."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE touren SET kalzeit='".$_POST['kalzeit']."' WHERE id='".$_GET['id']."'"); //startzeit
|
|
if(isset($_POST['kalzeit'])) {
|
|
$GLOBALS['mysql']->insert("UPDATE touren SET kalzeit='".$_POST['kalzeit']."' WHERE id='".$_GET['id']."'");
|
|
}
|
|
if($_POST['bedarf']>0) { $GLOBALS['mysql']->insert("UPDATE touren SET kaltyp='".$_POST['ttyp']."' WHERE id='".$_GET['id']."'"); }
|
|
|
|
$success[]="Tourdaten gespeichert."; $template->assign('success', $success);
|
|
}
|
|
//------------------ Tour Übericht auslesen neu
|
|
|
|
|
|
//------------------ Tour Übericht auslesen
|
|
$key=0; $wert=0;
|
|
$vt = $GLOBALS['mysql']->query_id("SELECT * FROM touren ORDER BY id");
|
|
$tmp0 = $GLOBALS['mysql']->query("SELECT *,COUNT(tl.id) as anz FROM tourentyp tt LEFT JOIN tourenliste tl ON(tt.tid = tl.typ) WHERE tt.taktiv = 1 AND tl.typ = tt.tid GROUP BY tt.tid");
|
|
while($row = $tmp0->fetch_assoc()) {
|
|
$tid=$row['tid'];
|
|
$tmenge= $row['anz'];
|
|
$tag_tour[$key]['menge']=$tmenge;
|
|
if($tmenge>0) {
|
|
$tag_tour[$key]['typ']=$row['tid'];
|
|
$tag_tour[$key]['raute']="#".$row['tid'];
|
|
$tag_tour[$key]['name1']=$row['tname'];
|
|
$tag_tour[$key]['aktiv']=$row['taktiv'];
|
|
|
|
$tag_tour[$key]['name2']=$row['tinfotitel'];
|
|
unset ($row0); unset ($tdata);
|
|
|
|
$tmp8 = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ='".$row['tid']."' order by id"); $wert=0;
|
|
while($row0= $tmp8->fetch_assoc()) {
|
|
$tag_tour[$key]['preis']=$row0['preis'];
|
|
$tdata[$wert]['id']=$row0['id'];
|
|
$tdata[$wert]['tour']=$row0['tour'];
|
|
$tdata[$wert]['aktiv']=$row0['aktiv'];
|
|
$tdata[$wert]['infotitel']=$row0['infotitel'];
|
|
$wert++;
|
|
$tag_tour[$key]['tdata']=$tdata;
|
|
$tag_tour[$key]['col']=0;
|
|
if(isset($_GET['id'])) {
|
|
/*
|
|
$tmpa = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$_GET['id']."'"); //abfrage touren typ anzeige
|
|
$tag_tour[$key]['col']=$tmpa['typ'];
|
|
*/
|
|
$tag_tour[$key]['col']=$vt[$_GET['id']]['typ'];
|
|
}
|
|
}
|
|
|
|
}
|
|
$key++;
|
|
}
|
|
|
|
$template->assign('tag_tour', $tag_tour); // echo'<pre>'; print_r($tag_tour); echo'</pre>';
|
|
//--------------------- Fahrer und Auto Array
|
|
$fahrer_array = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER BY name");
|
|
$auto_array = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE aktiv>0 AND typ>0 ORDER BY kz");
|
|
//--------------------- Fahrer und Auto Array
|
|
$auswahltyp = $GLOBALS['mysql']->query_array("SELECT * FROM tourentyp WHERE taktiv>0 ORDER BY tid");
|
|
$auftraggeber = $GLOBALS['mysql']->query_array("SELECT * FROM firmen ORDER BY id");
|
|
|
|
//------------------------------------------------------------
|
|
// echo "<pre>"; print_r($tag_tour); echo "</pre>";
|
|
//------------------------------------------------------------
|
|
if(isset($_GET['id'])) {
|
|
$tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$_GET['id']."'");
|
|
$anzeige = $_GET['id'];
|
|
$template->assign('tour', $tour);
|
|
|
|
|
|
$template->assign('auswahltyp', $auswahltyp);
|
|
$template->assign('auftraggeber', $auftraggeber);
|
|
$template->assign('auto_array', $auto_array);
|
|
$template->assign('fahrer_array', $fahrer_array);
|
|
|
|
}
|
|
$template->assign('anzeige', $anzeige);
|
|
$template->assign('content', 'tpl/v_touren.tpl');
|
|
?>
|
|
|
|
|
|
|