summaryrefslogtreecommitdiff
path: root/www-ssl/admin/free_DECT.php
diff options
context:
space:
mode:
Diffstat (limited to 'www-ssl/admin/free_DECT.php')
-rwxr-xr-xwww-ssl/admin/free_DECT.php50
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";
+}
+
+?>
+