1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
<?php
include ("../../../camp2011/includes/config_db.php");
include ("../../../camp2011/includes/funktion_db_list.php");
include ("../../../camp2011/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 />";
}
?>
|
