83 lines
No EOL
2.7 KiB
PHP
83 lines
No EOL
2.7 KiB
PHP
<?php
|
|
|
|
|
|
if(isset($_GET['a']))
|
|
$action=$_GET['a'];
|
|
else
|
|
$action='load_free_cars';
|
|
switch($action):
|
|
|
|
case 'save_id';
|
|
// echo "<pre>"; print_r($_POST); echo "</pre>";
|
|
$_SESSION['fazplz']=$_POST['faz'];
|
|
$GLOBALS['mysql']->insert("UPDATE var_temp SET wert='".$_POST['faz']."' WHERE id=2");
|
|
|
|
$back['lastnote']=$_POST['faz'];
|
|
$back['success'] = true;
|
|
$back['alt'] = 5;
|
|
echo json_encode($back);
|
|
|
|
break;
|
|
|
|
case 'info_save';
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET infotext='".$_POST['info']."' WHERE id='".$_POST['tourID']."'");
|
|
$back['success'] = true;
|
|
$back['lastnote']="Information: ".$_POST['info']." hinzugefügt.";
|
|
$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;
|
|
//-- caddy nachts
|
|
$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<6"); // LIKE = % (egal was da steht)
|
|
$pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
|
|
if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
|
|
$seite['caddy'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
|
|
}
|
|
}
|
|
|
|
//-- trp nachts
|
|
$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<6");
|
|
$pauto = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE timestamp LIKE '".$_POST['date']." %' and fid='".$row['id']."'");
|
|
if($istabfrage['num_rows']== 0 && $pauto['num_rows']== 0) {
|
|
$seite['trp'][$key]=$row['kz']." (".$row['hersteller']." ".$row['name'].")"; $key++;
|
|
}
|
|
}
|
|
|
|
echo json_encode($seite);
|
|
|
|
|
|
endswitch;
|
|
|
|
|
|
|
|
?>
|