diff options
| -rwxr-xr-x | www-ssl/admin/free_DECT.php | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/www-ssl/admin/free_DECT.php b/www-ssl/admin/free_DECT.php new file mode 100755 index 00000000..0a6bba87 --- /dev/null +++ b/www-ssl/admin/free_DECT.php @@ -0,0 +1,50 @@ +<?PHP + +include ("../../includes/config_db.php"); +include ("../../includes/funktion_db_list.php"); + + +####################################################### +# Ermitteln freier Engel +# +# auslesen aller Engel und dazugehoerige Schichten +####################################################### + +$SQL = "SELECT Shifts.*, ShiftEntry.* ". + "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; + +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); + +$inuse=""; +for ($i=0; $i < $Zeilen; $i++) +{ + if ($inuse!="") + $inuse.= " OR "; + $inuse.= "(UID = \"". mysql_result($Erg, $i, "UID"). "\")"; +} +if ($inuse!="") + $inuse=" WHERE (NOT (".$inuse.")) AND (DECT!='')"; + + +//########################################################################################################## + +$SQL = "SELECT * FROM User".$inuse.";"; +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); +for ($i=0; $i < $Zeilen; $i++) +{ + $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=". mysql_result($Erg, $i, "UID"). ";"; + $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); + + echo mysql_result($Erg, $i, "DECT"). "\t"; + echo "Info=". mysql_result($Erg_RIGHT, 0, "Info"). "\t"; + echo "Herald=". mysql_result($Erg_RIGHT, 0, "Herald"). "\t"; + echo "Conference=". mysql_result($Erg_RIGHT, 0, "Conference"). "\t"; + + echo "\n"; +} + +?> + |