<?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;
	

?>