\n";
$Out.= "\n".
"\n".
"\n".
"\n";
///////////////////////////////////////////////////////////////////
// SQL abfrage für die benötigten schichten
///////////////////////////////////////////////////////////////////
$SQL = "SELECT * FROM `ShiftEntry` WHERE (`SID` = '$SID') ORDER BY `TID`, `UID` DESC ;";
$Erg = mysql_query($SQL, $con);
$Anzahl = mysql_num_rows($Erg);
$Feld=-1;
for( $i = 0; $i < $Anzahl; $i++ )
{
$Temp_TID = mysql_result($Erg, $i, "TID");
// wenn sich der Type ändert wird zumnästen feld geweckselt
if( ($i==0) || ($Temp_TID_old != $Temp_TID) )
{
$Feld++;
$Temp[$Feld]["free"]=0;
$Temp[$Feld]["Engel"]=array();
}
$Temp[$Feld]["TID"] = $Temp_TID;
$Temp[$Feld]["UID"] = mysql_result($Erg, $i, "UID");
// ist es eine zu vergeben schicht?
if( $Temp[$Feld]["UID"] == 0 )
$Temp[$Feld]["free"]++;
else
$Temp[$Feld]["Engel"][] = $Temp[$Feld]["UID"];
$Temp_TID_old = $Temp[$Feld]["TID"];
} // FOR
///////////////////////////////////////////////////////////////////
// Aus gabe der Schicht
///////////////////////////////////////////////////////////////////
if( isset($Temp) && count($Temp) )
foreach( $Temp as $TempEntry => $TempValue )
{
$Out.= "\n";
// ausgabe EngelType
$Out.= "| ". $EngelTypeID[ $TempValue["TID"] ];
// ausgabe Eingetragener Engel
if( count($TempValue["Engel"]) > 0 )
{
if( count($TempValue["Engel"]) == 1 )
$Out.= " ". trim(Get_Text("inc_schicht_ist")). ":";
else
$Out.= " ". trim(Get_Text("inc_schicht_sind")). ":";
$Out.= " | \n";
$Out.= "";
foreach( $TempValue["Engel"] as $TempEngelEntry=> $TempEngelID )
$Out.= UID2Nick( $TempEngelID ). ", ";
// $Out.= UID2Nick( $TempEngelID ). DisplayAvatar( $TempEngelID ). ", ";
$Out = substr( $Out, 0, strlen($Out)-2 );
}
else
{
$Out.= ": | \n";
$Out.= "\n";
}
// ausgabe benötigter Engel
////////////////////////////
if( $_SESSION['CVS']["nonpublic/schichtplan_add.php"] == "Y")
{
if ( $TempValue["free"] > 0)
{
if( count($TempValue["Engel"]) > 0)
$Out.= ", ";
$Out.= $TempValue["free"]. "x free ";
}
}
$Out.= " | \n";
$Out.= "
\n";
} // FOREACH
$Out.= "\n";
return $Out;
} // function Ausgabe_Feld_Inhalt
/*#######################################################
# gibt die engelschischten für einen Ruam aus #
#######################################################*/
function ausgabe_Zeile( $RID, $Time, &$AnzahlEintraege )
{
global $con;
$SQL = "SELECT `SID`, `Len`, `Man` FROM `Shifts` ".
"WHERE ( (`RID` = '$RID') AND ".
"((`DateE` like '". gmdate("Y-m-d H", $Time+3600). "%') OR ".
" (`DateS` like '". gmdate("Y-m-d H", $Time). "%')) ) ORDER BY `DateS`;";
$ErgRoom = mysql_query($SQL, $con);
$Out= "";
if( mysql_num_rows( $ErgRoom)>0 )
for( $i=1; $i<=mysql_num_rows( $ErgRoom); $i++ )
{
$AnzahlEintraege++;
$Out.= ausgabe_Feld_Inhalt( mysql_result( $ErgRoom, $i-1, "SID"),
mysql_result( $ErgRoom, $i-1, "Man"));
if( (mysql_num_rows( $ErgRoom) > 1) && !($i==mysql_num_rows( $ErgRoom)) )
$Out.= "
";
// $Out.= "
\n";
}
else
$Out.= " ";
$Out.= " | \n";
return $Out;
}
?>