diff options
author | Philip Häusler <msquare@notrademark.de> | 2011-06-13 18:05:51 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2011-06-13 18:05:51 +0200 |
commit | 04973d1fa148381978b1251d10118e6bab86f435 (patch) | |
tree | 39f5a304342054e9da8c0452866b4f6eb69f87af /www-ssl_old/admin/free_DECT.php | |
parent | 89fd736f36dc89becacc30dc250d7a3e93e9569f (diff) |
moved public files to public, old and yet untouched files to directories ending with _old
Diffstat (limited to 'www-ssl_old/admin/free_DECT.php')
-rw-r--r-- | www-ssl_old/admin/free_DECT.php | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/www-ssl_old/admin/free_DECT.php b/www-ssl_old/admin/free_DECT.php new file mode 100644 index 00000000..4b4e3085 --- /dev/null +++ b/www-ssl_old/admin/free_DECT.php @@ -0,0 +1,65 @@ +<?php +require_once ('../bootstrap.php'); + +include ("config/config_db.php"); +include ("includes/funktion_db_list.php"); +include ("includes/funktion_user.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!='')"; +} else { + $inuse = " WHERE (DECT!='')"; +} + +//########################################################################################################## + +$SQL = "SELECT * FROM User" . $inuse . ";"; +$Erg = mysql_query($SQL, $con); +$Zeilen = mysql_num_rows($Erg); +for ($i = 0; $i < $Zeilen; $i++) { + // get DECT number + echo mysql_result($Erg, $i, "DECT") . "\t"; + + // get all user rights + $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=" . mysql_result($Erg, $i, "UID") . ";"; + $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); + $UserRights = mysql_fetch_array($Erg_RIGHT); + + foreach ($UserRights as $Var => $Value) { + if ((strpos($Var, ".php") === false) AND (strpos($Var, "/") === false) AND (strpos($Var, "UID") === false) AND (is_numeric($Var) === false)) { + echo "\"" . $Var . "\"=" . $Value . "\t"; + } + } + + // get shift types + $SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=" . mysql_result($Erg, $i, "UID") . " GROUP BY TID;"; + $Erg_TYPES = mysql_query($SQL_TYPES, $con); + $Zeilen_Typen = mysql_num_rows($Erg_TYPES); + for ($j = 0; $j < $Zeilen_Typen; $j++) { + echo "\"TID_" . TID2Type(mysql_result($Erg_TYPES, $j, "TID")) . "\"=Y\t"; + } + + echo "\n"; + // echo "<br />"; +} +?> + |