<?php

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

$matemp = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['tourID']."'"); 

$jahr = 	$matemp['jahr'];
$monat = 	$matemp['monat'];
$tag = 		$matemp['tag'];
$kw = 		$matemp['kw'];

$i=0; $i=$matemp['typ'];
 
	if ($i== 3) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND gh>0 ORDER BY name"); }
elseif ($i== 4) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND lvz>0 ORDER BY name"); }
elseif ($i== 5) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND pin>0 ORDER BY name"); }
elseif ($i== 6) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND post>0 ORDER BY name"); }
elseif ($i== 7) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND rs>0 ORDER BY name"); }
elseif ($i== 8) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND saso>0 ORDER BY name"); }
elseif ($i== 9) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND grm>0 ORDER BY name"); }
elseif ($i==10) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND mp>0 ORDER BY name"); }
elseif ($i==11) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND werb>0 ORDER BY name"); }
elseif ($i==12) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND mb>0 ORDER BY name"); }
elseif ($i==13) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND tip>0 ORDER BY name"); }
elseif ($i==14) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND werb>0 ORDER BY name"); }
elseif ($i==15) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND faz>0 ORDER BY name"); }	
elseif ($i==16) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND pleer>0 ORDER BY name"); }	
elseif ($i==17) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND lvz>0 ORDER BY name"); }
elseif ($i==18) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND lvz>0 ORDER BY name"); }
elseif ($i==20) { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND sonstige>0 ORDER BY name"); }										
		   else { $tempma = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER BY name"); }	

//------------- Mitarbeiter da 
$fahrer_ok=1;
$test_ma = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND mid='".$matemp['fahrer']."' ");
if($test_ma['num_rows'] > 0) {
	$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$test_ma['grund']."'");		
	if($row_icon['nichtda']==$row['typ']) 	{ $fahrer_ok=0; } 
	else if($row_icon['nichtda']==1) 		{ $fahrer_ok=0; } 	
	else if($row_icon['nichtda']==99) 		{ $fahrer_ok=3; } 	
	else { $fahrer_ok=2; }
} else {
	$fahrer_ok=1;
}
echo $fahrer_ok;
$template->assign('fahrer_ok', $fahrer_ok); 
$template->assign('tempma', $tempma); 
$template->assign('typ', $matemp['typ']); 
$template->assign('id', $_POST['tourID']); 
$template->assign('fahrer_id', $matemp['fahrer']); 
$template->assign('content', 'tpl/ajax/ma_auswahl.tpl');


echo json_encode($tempma);

?>