steven/jb-data.de
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
jb-data.de/scripts/ajax/isaso.php
steven 72a26edcff init
2025-08-11 22:23:30 +02:00

281 lines
14 KiB
PHP
Raw Permalink Blame History

<?php
if(isset($_GET['a']))
$action=$_GET['a'];
else
$action='load_saso';
switch($action):
//----------------------------------------------------------------------------------------------------------------
//---------------------------------------------- Zeit speichern laden --------------------------------------------
case 'time_save';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$_POST['zeit']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Uhrzeit auf ".$_POST['time']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//----------------------------------------------------------------------------------------------------------------
//---------------------------------------------- exemplare speichern laden ---------------------------------------
case 'save_exemplare';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$_POST['exemplare']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Exemplare auf ".$_POST['exemplare']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//----------------------------------------------------------------------------------------------------------------
case 'save_amtsblatt';
$tourx = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'");
if($tourx['amtsblatt']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET amtsblatt='0' WHERE id='".$_POST['tourID']."'");
} else {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET amtsblatt='1' WHERE id='".$_POST['tourID']."'");
}
$back['tour'] = $_POST['tourID'];
$back['lastnote']=$tour['tour']." Amtsblatt/Mitnahme markiert";
$back['success'] = true;
echo json_encode($back);
break;
//---------------------------------------------- ges.Gewicht speichern -------------------------------------
case 'save_gewicht';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$_POST['gewicht']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Rampengewicht auf ".$_POST['gewicht']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- saso.Gewicht speichern -------------------------------------
case 'save_gewicht3';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht3='".$_POST['gewicht3']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Rampengewicht auf ".$_POST['gewicht3']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- saso. END_Gewicht speichern ---------------------------------
case 'save_gewicht9';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht9='".$_POST['gewicht3']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Rampengewicht auf ".$_POST['gewicht9']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- Amtsblatt Menge speichern ---------------------------------
case 'save_abst';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET amtsblatt='".$_POST['abst']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Amtsblatt Exemplare auf ".$_POST['abst']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- ges.Gewicht4 Car gewicht speichern -------------------------
case 'save_gewicht4';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$_POST['gewicht4']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Gesamtgewicht Tour auf ".$_POST['gewicht4']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- pakete ahrzeugpakete speichern -------------------------------------
case 'save_pakete';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$_POST['pakete']."' WHERE id='".$_POST['tourID']."'");
$abn_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'");
$cargewicht=$_POST['pakete']*$abn_tour['gewicht2'];
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$cargewicht."' WHERE id='".$_POST['tourID']."'");
$tid=$abn_tour['tour']-9;
$pppp=ceil($abn_tour['Pakete']-$_POST['pakete']);
$cargewicht=$pppp*$abn_tour['gewicht2'];
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$cargewicht."' WHERE tour='".$tid."' and kw='".$abn_tour['kw']."' and jahr='".$abn_tour['jahr']."' ");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$pppp."' WHERE tour='".$tid."' and kw='".$abn_tour['kw']."' and jahr='".$abn_tour['jahr']."' ");
$back['success'] = true;
$back['lastnote']="Für die Tour wurden die Pakete auf ".$_POST['pakete']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- pakete2 ahrzeugpakete speichern laden -------------------------------------
case 'save_pakete2';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$_POST['pakete2']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Paket auf dem Fahrzeug auf ".$_POST['pakete2']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- Norm speichern laden -------------------------------------
case 'save_norm';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$_POST['norm']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Normplan auf ".$_POST['norm']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//---------------------------------------------- Rampe speichern laden -------------------------------------
case 'save_rampe';
$GLOBALS['mysql']->insert("UPDATE tourenliste SET rampe='".$_POST['rampe']."' WHERE id='".$_POST['tourID']."'");
$back['success'] = true;
$back['lastnote']="Rampe auf ".$_POST['rampe']." geändert.";
$back['alt'] = 5;
echo json_encode($back);
break;
//----------------------------------------------------------------------------------------------------------------
//---------------------------------------------- SaSo laden ------------------------------------------------------
case 'load_saso';
default:
//--------- jahrauswahl
if(isset($jahr)) {
$pjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr+1) - 4*86400));
$ijahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr) - 4*86400));
$mjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr-1) - 4*86400));
if($_GET['wahl']==1){ if($_GET['kw']==1) { $kw=$mjahr; $jahr=$_GET['jahr']-1;} else { $kw=$_GET['kw']-1; $jahr=$_GET['jahr'];}}
elseif($_GET['wahl']==2){ if($_GET['kw']==$ijahr) { $kw=1; $jahr=$_GET['jahr']+1; } else { $kw=$_GET['kw']+1; $jahr=$_GET['jahr']; }
} else {
$jahr = (int)date('Y');
$kw = (int)date('W');
}
} else {
$jahr = (int)date('Y');
$kw = (int)date('W');
}
//------------------------------------------------------------------------------------------------------------------------------------------------------
if(isset($_POST['delete2'])) {
if($_POST['delete2']>1000) {
$GLOBALS['mysql']->query("DELETE FROM tourenliste WHERE id='".$_POST['delete2']."'");
}
}
//------------------------------------------------------------------------------------------------------------------------------------------------------
//------------------------- Paketmenge und Cargewichte berechnen ---------------------------------------------------------------------------------------
//$saso_fail = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and typ=8 AND tour>1000 ORDER BY zeit"); $key=0;
//-------------------------------------------------------------------------------------- Auslesen Touren
$saso_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and typ=8 AND zeit >= 19 ORDER BY zeit"); $key=0;
while($row = $saso_tour->fetch_assoc()) {
$saso_tour2[$key]['zeit'] = $row['zeit'];
$saso_tour2[$key]['id'] = $row['id'];
$saso_tour2[$key]['utyp'] = $row['utyp'];
$saso_tour2[$key]['tid'] = $key;
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='" . $row['tour'] . "'");
$saso_tour2[$key]['tourid'] = $row['tour'];
$saso_tour2[$key]['tour'] = $row_tour['tour'];
$saso_tour2[$key]['tname'] = $row_tour['tour3'];
if ($row['exemplare'] <1) {
$saso_tour2[$key]['exemplare'] = $row_tour['exemplare'];
} else {
$saso_tour2[$key]['exemplare'] = $row['exemplare'];
}
$saso_tour2[$key]['gewicht'] = $row['gewicht'];
$saso_tour2[$key]['gewicht4'] = $row['gewicht4'];
//------------------------------- Pakete anhand der
if ($row['Pakete'] <1) {
$saso_tour2[$key]['pakete'] = ceil($saso_tour2[$key]['exemplare']/ $row['Norm']);
} else {
$saso_tour2[$key]['pakete'] = $row['Pakete'];
}
$saso_tour2[$key]['pakete2']=$row['pakete2'];
$saso_tour2[$key]['gewicht2']=$row['gewicht']/$row['Pakete'];
//$saso_tour2[$key]['gewicht3']=ceil($gewicht3);
if($row['tour']<1000) {
$temp_tour=$row['tour']+7200;
$saso_temp = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tour='".$temp_tour."'");
if($saso_temp['num_rows']>0) {
$saso_tour2[$key]['pakete2']=$row['Pakete'];
$saso_temp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tour='".$temp_tour."'");
while($rowtemp = $saso_temp->fetch_assoc()) {
$saso_tour2[$key]['pakete2']=$saso_tour2[$key]['pakete2']-$rowtemp['pakete2'];
}
}
}
$saso_tour2[$key]['gewicht3']=ceil($saso_tour2[$key]['gewicht2']*$saso_tour2[$key]['pakete2']);
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Pakete='".$saso_tour2[$key]['pakete']."' WHERE id='".$row['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht2='".$saso_tour2[$key]['gewicht2']."' WHERE id='".$row['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht3='".$saso_tour2[$key]['gewicht3']."' WHERE id='".$row['id']."'");
$saso_tour2[$key]['rampe']=$row['rampe'];
$saso_tour2[$key]['norm']=$row['Norm']; if($row['Norm']<1) {$normtest=1;}
$key++;
}
$saso_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and typ=8 AND zeit <= 19 ORDER BY zeit");
while($row = $saso_tour->fetch_assoc()) {
$saso_tour2[$key]['zeit'] = $row['zeit'];
$saso_tour2[$key]['id'] = $row['id'];
$saso_tour2[$key]['utyp'] = $row['utyp'];
$saso_tour2[$key]['tid'] = $key;
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='" . $row['tour'] . "'");
$saso_tour2[$key]['tourid'] = $row['tour'];
$saso_tour2[$key]['tour'] = $row_tour['tour'];
$saso_tour2[$key]['tname'] = $row_tour['tour3'];
if ($row['exemplare'] <1) {
$saso_tour2[$key]['exemplare'] = $row_tour['exemplare'];
} else {
$saso_tour2[$key]['exemplare'] = $row['exemplare'];
}
$saso_tour2[$key]['gewicht'] = $row['gewicht'];
$saso_tour2[$key]['gewicht4'] = $row['gewicht4'];
$pakete2=$row['pakete2'];
//------------------------------- Pakete anhand der
if ($row['Pakete'] <1) {
$saso_tour2[$key]['pakete'] = ceil($saso_tour2[$key]['exemplare']/ $row['Norm']);
} else {
$saso_tour2[$key]['pakete'] = $row['Pakete'];
}
$saso_tour2[$key]['gewicht2']=$row['gewicht']/$row['Pakete'];
//$saso_tour2[$key]['gewicht3']=ceil($gewicht3);
if($row['tour']<1000) {
$temp_tour=$row['tour']+7200;
$saso_temp = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tour='".$temp_tour."'");
if($saso_temp['num_rows']>0) {
$pakete2=$row['Pakete'];
$saso_temp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tour='".$temp_tour."'");
while($rowtemp = $saso_temp->fetch_assoc()) {
$pakete2=$pakete2-$rowtemp['pakete2'];
}
$saso_tour2[$key]['pakete2']=$pakete2;
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$pakete2."' WHERE id='".$row['id']."'");
}
}
$saso_tour2[$key]['$pakete2']=$pakete2;
$saso_tour2[$key]['gewicht3']=ceil($saso_tour2[$key]['gewicht2']*$pakete2);
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Pakete='".$saso_tour2[$key]['pakete']."' WHERE id='".$row['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$pakete2."' WHERE id='".$row['id']."'"); echo $pakete2;
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht2='".$saso_tour2[$key]['gewicht2']."' WHERE id='".$row['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht3='".$saso_tour2[$key]['gewicht3']."' WHERE id='".$row['id']."'");
$saso_tour2[$key]['rampe']=$row['rampe'];
$saso_tour2[$key]['norm']=$row['Norm']; if($row['Norm']<1) {$normtest=1;}
$key++;
}
//-----------------------------------------------
// echo "<pre>"; print_r($saso_tour2); echo "</pre>";
//-----------------------------------------------
//$tourplus = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=8 and id>8000 ORDER BY id");
//-----------------------------------------------
$template->assign('saso_tour2', $saso_tour2);
$template->assign('jahr', $jahr);
$template->assign('kw', $kw);
// $template->assign('datum', $datum);
$template->assign('content', 'tpl/ajax/isaso.tpl');
// echo json_encode($ersatz);
endswitch;
?>
Reference in a new issue View git blame Copy permalink