<?php
$_SESSION['m1']=1; $_SESSION['m2']=8;
if($_SESSION['benutzer']==12) { $planer="T. Muerbe"; }
else if($_SESSION['benutzer']==13) { $planer="Anett"; }
else if($_SESSION['benutzer']==18) { $planer="Joerg Basse"; }
else if($_SESSION['benutzer']==44) { $planer="I. Steinmacher"; }
else $planer="Frank"; 


//	error_reporting(E_ALL); ini_set('display_errors', 1);

$jahr1 = date("Y"); 
$monat1 = date("m");
$tag1 = date("d");
//else

// 1. Tag !!!!!!!!!!!!


$tmp_tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1."' and monat='".$monat1."' and jahr='".$jahr1."' ORDER BY typ");
while($row = $tmp_tour1->fetch_assoc()) {
//        $tag_tour2[$key]['tid']=$key;
	$row_tour1 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
//	$n8_tour2[$key]['id']=$row['id'];
	$n8_tour1[$key]['tour']=$row_tour1['tour'];
	$n8_tour1[$key]['time']=$row['time'];	
	$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
	$n8_tour1[$key]['fahrer']=$row_fahrer1['name'];
	$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$n8_tour1[$key]['kennz']=$row_auto1['kz'];


//	$n8_tour2[$key]['auto_id']=$row['auto'];
//	$row_auto_array = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE aktiv>0 AND typ>1 ORDER BY kz");
//	$n8_tour2[$key]['infotext']=$row['infotext'];
//	$row_fahrer_array = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE  lvz>0 AND aktiv>0 ORDER BY name");
//	$n8_tour2[$key]['auto_array']=$row_auto_array;

	$key++;
}	
$template->assign('n8_tour1', $n8_tour1);	

// 2. Tag !!!!!!!!!!!!
$tagstring2 = strtotime("+1 day"); 
$tag2 = date("d",$tagstring2); $monat2 = date("m",$tagstring2); $jahr2 = date("Y",$tagstring2); $key=0;
//// 2. Tag
$tmp_tour2 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2."' and monat='".$monat2."' and jahr='".$jahr2."' ORDER BY typ");
while($row = $tmp_tour2->fetch_assoc()) {
//  $tag_tour2[$key]['tid']=$key;
	$row_tour2 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
//	$n8_tour2[$key]['id']=$row['id'];
	$n8_tour2[$key]['tour']=$row_tour2['tour'];
	$n8_tour2[$key]['time']=$row['time'];	
	$row_fahrer2 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
	$n8_tour2[$key]['fahrer']=$row_fahrer2['name'];
	$n8_tour2[$key]['fahrer_array']=$row_fahrer_array;
	$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$n8_tour2[$key]['kennz']=$row_auto2['kz'];


//	$n8_tour2[$key]['auto_id']=$row['auto'];
//	$row_auto_array = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge WHERE aktiv>0 AND typ>1 ORDER BY kz");
//	$n8_tour2[$key]['infotext']=$row['infotext'];
//	$row_fahrer_array = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE  lvz>0 AND aktiv>0 ORDER BY name");
//	$n8_tour2[$key]['auto_array']=$row_auto_array;

	$key++;
}	
$template->assign('n8_tour2', $n8_tour2);	


	$action='list';
//	$saso_kw = $GLOBALS['mysql']->query_array("SELECT * FROM tourenliste WHERE tag='".$heute_tag."' and monat='".$heute_monat."' and jahr='".$heute_jahr."'");
//	$template->assign('option1', $option1);	
/*	
	if(isset($_POST['savetour'])) {
		$GLOBALS['mysql']->insert("UPDATE tourenliste SET fahrer='".$_POST['Fahrer'][$_POST['savetour']]."' WHERE id='".$_POST['savetour']."'"); 
		$GLOBALS['mysql']->insert("UPDATE tourenliste SET auto='".$_POST['Fahrzeug'][$_POST['savetour']]."' WHERE id='".$_POST['savetour']."'"); 
		$GLOBALS['mysql']->insert("UPDATE tourenliste SET infotext='".$_POST['infotext'][$_POST['savetour']]."',logid='".time()."' WHERE id='".$_POST['savetour']."'"); 

		$row_date = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['savetour']."'");
		$heute_jahr = $row_date['jahr'];
		$heute_monat = $row_date['monat'];
		$heute_tag = $row_date['tag'];
//		echo $heute_tag - $heute_monat - $heute_jahr ;  
		$success[]="Tour wurde ge&auml;ndert."; $template->assign('success', $success);	
	}	
	if(isset($_POST['smssenden'])) {
		include_once('lib/class.mysms.php');
		if($_SESSION['benutzer']==18) { 
			$api_key = 'OvHiwonvVKneoYttEOE64g'; 
			$mysms = new mysms($api_key);
			$login_data = array('msisdn' => '491783481356', 'password' => 'laden');
		} else {
			$api_key = 'EPOcWC8smWfdOWNHzSLANw'; 
			$mysms = new mysms($api_key);
			$login_data = array('msisdn' => '491786828700', 'password' => 'maxdata-01');
		}
		$login = $mysms->ApiCall('json', '/user/login', $login_data);  
		$user_info = json_decode($login); 
		$_SESSION['AuthToken'] = $user_info->authToken; 
		$mysms->setAuthToken($user_info->authToken);
		$tourid=$_POST['sendtour'];
		$row_smstour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$tourid."'");
        $sms_tour=$row_smstour['tour'];
        $sms_tag=$row_smstour['tag'];
        $sms_monat=$row_smstour['monat'];
        $sms_jahr=$row_smstour['jahr'];
        $sms_auto=$row_smstour['auto'];
        $row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$sms_auto."'"); 
        $sms_autoname=$row_autox['kz'];
		$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_smstour['fahrer']."'"); 
		$sms_nummer[0]=$row_fahrerx['handy'];
		$MessageText = "Aenderungen fuer den ".$sms_tag.".".$sms_monat.".".$sms_jahr." * Tour: ".$sms_tour." mit ".$sms_autoname.". Danke ".$_SESSION['bname'];	
		$req_data = array('authToken' => $_SESSION['AuthToken'],'recipients' => $sms_nummer,'message' => $MessageText,'encoding' => 0,'smsConnectorId' => 0,'store'=>true); //providing 
		$ergebnis = $mysms->ApiCall('json', '/remote/sms/send', $req_data); //calling method ->ApiCall
		$template->assign('success', $ergebnis);	
	}	
	if(isset($_POST['dasdatum'])) {
		$datum_arr = explode('.',$_POST['dasdatum']); 
		$timestamp1 = mktime(0,0,0, $datum_arr[1] , $datum_arr[0] ,$datum_arr[2]);

		$heute_jahr = $datum_arr[2];
		$heute_monat = $datum_arr[1];
		$heute_tag = $datum_arr[0];		
	}
//------------------ GH	
	$key=0;
	$tag_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$heute_tag."' and monat='".$heute_monat."' and jahr='".$heute_jahr."' and typ=3 ORDER BY id");
	while($row = $tag_tour->fetch_assoc()) {
//        $tag_tour2[$key]['tid']=$key;
		$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
        $tag_tour2[$key]['id']=$row['id'];
        $tag_tour2[$key]['tour']=$row_tour['tour'];
        $row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
        $tag_tour2[$key]['fahrer']=$row_fahrerx['name'];
        $tag_tour2[$key]['fahrer_id']=$row_fahrerx['id'];
        $row_fahrer_array = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE  gh>0 AND aktiv>0 ORDER BY name");
        $tag_tour2[$key]['fahrer_array']=$row_fahrer_array;
		$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
        $tag_tour2[$key]['kennz']=$row_autox['kz'];
        $tag_tour2[$key]['auto_id']=$row['auto'];
        $row_auto_array = $GLOBALS['mysql']->query_array("SELECT * FROM fahrzeuge"); 
        $tag_tour2[$key]['auto_array']=$row_auto_array;
        $tag_tour2[$key]['infotext']=$row['infotext'];
        $key++;
	}
	
	
*/	
//------------------ LVZ
	$key=0;
//---------------------------		
$heute = "$heute_tag.$heute_monat.$heute_jahr"; 	
$template->assign('datum', $heute);	   

$template->assign('content', 'tpl/ptagcopy.tpl');	
?>