add dect export

git-svn-id: svn://svn.cccv.de/engel-system@331 29ba0400-6e00-0410-a75a-ca02368028f8

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";
+}
+
+?>
+