<?php

//	echo'<pre>'; print_r($row_nichtda); echo'</pre>';	

error_reporting(E_ALL); ini_set('display_errors',1); 
header('Content-Type: text/html; charset=utf-8');    
//----------------------------------------------------- 
$wochentag=date('w');
$jahr = (int)date('Y');
$kw = (int)date('W');
//----------------------------------------------------- 
//----------------------------------------------------- 
//-------------------- wiederkehrende abfragen -------------------------------------------------
$a_touren = $GLOBALS['a_touren'];
$a_fahrzg = $GLOBALS['a_fahrzg'];
$a_fahrer = $GLOBALS['a_fahrer'];
$a_planbz = $GLOBALS['a_planbz'];
$a_planbf = $GLOBALS['a_planbf'];
//----------------------------------------------------- 
//----------------------------------------------------- 
//----------------------------------------------------- 
//------------------------------------------------------------------------------------------------------------- 
//-------- Sachsen-Sonntag 2019 neu ----------------------------------------------------------------------------------------------------- 
//-------------------------------------------------------------------------------------------------------------------------------------- 
if($wochentag==4 || $wochentag==5 || $wochentag==6 || $wochentag==0) { //------------------------- donnerstag bis Sonntag Saso laden
//--------------------------------------------------------------------------------------------------------------------------------------		
//---------------------------------------- Halle Block
	$key=0;
	$saso_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and typ=19 ORDER BY tour");
	while($row = $saso_tour->fetch_assoc()) {
		$saso_tour1[$key]['binfo']='Block: '.$row['utyp'].' geplant: '.$row['zeit']." Uhr";
		$wechsel=$row['utyp'];
		$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
		$aa_id= array_search($row['auto'], array_column($a_fahrzg, 'id')); 			
		$ma_id= array_search($row['fahrer'], array_column($a_fahrer, 'id')); 
		$saso_tour1[$key]['start']=$key;
		$saso_tour1[$key]['aktiv']=$a_touren[$ta_id]['aktiv'];	
		$saso_tour1[$key]['tour']=$a_touren[$ta_id]['tour3'];
		$saso_tour1[$key]['auto']=$a_fahrzg[$aa_id]['kz'];			
		$saso_tour1[$key]['status']=$row['status'];			
		$saso_tour1[$key]['fahrerid']=$row['fahrer'];			
		$saso_tour1[$key]['zeit']=$row['zeit'];			
		$saso_tour1[$key]['autoid']=$row['auto'];			
		$saso_tour1[$key]['fahrer']=$a_fahrer[$ma_id]['name'];			
		$saso_tour1[$key]['look']=$row['fertig'];	
		$saso_tour1[$key]['gewicht']=$row['gewicht'];
		$saso_tour1[$key]['gewicht4']=$row['gewicht4'];	
		$sasonorm=$row['Norm']; 
		$key++;
	}
	$template->assign('saso_tour',$saso_tour1);  
	$template->assign('sasoanzeige',$key);	
	$template->assign('sasonorm',$sasonorm);	
}	
	
		
	$template->assign('kw', $kw);

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