| author | Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> |
| Mon, 21 Nov 2011 16:24:43 +0100 | |
| changeset 18 | d0aa14180761 |
| parent 16 | 3ebe66308a00 |
| child 20 | 5877137431e4 |
| permissions | -rw-r--r-- |
|
16
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
1 |
<?php |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
2 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
3 |
/** |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
4 |
* @author Bettina Schwarzer, Fritz-Haber-Institut |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
5 |
* @copyright 10/2011 |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
6 |
* |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
7 |
* INSERT Rechte |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
8 |
*/ |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
9 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
10 |
error_reporting(E_ALL ^ E_NOTICE); |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
11 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
12 |
session_start(); |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
13 |
if (! isset($_SESSION["userid"])) |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
14 |
{
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
15 |
include_once ("inc/func_lib.inc.php");
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
16 |
login($_SERVER["PHP_SELF"]); |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
17 |
exit; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
18 |
} |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
19 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
20 |
if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("rte",$_SESSION["recht"]) && !in_array("rtr",$_SESSION["recht"])))
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
21 |
{
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
22 |
header("Location: start.php");
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
23 |
exit; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
24 |
} |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
25 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
26 |
?> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
27 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
28 |
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
29 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
30 |
<head> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
31 |
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
32 |
<link type="text/css" href="/fhiiqm/css/db.css" rel="Stylesheet" /> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
33 |
<title>Nutzer fhiiqm</title> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
34 |
</head> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
35 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
36 |
<body> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
37 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
38 |
<?php |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
39 |
echo " "; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
40 |
echo "<div class=\"float-br smaller\" valign='top'>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
41 |
echo " user: " . $_SESSION["userid"]; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
42 |
echo " <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
43 |
echo "<div class=\"float-r\"><img src=\"img/user_go.png\" border=\"0\" alt=\"User, Rechte eingeben\" title=\"User, Rechte eingeben\"/></div>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
44 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
45 |
include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
46 |
if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
47 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
48 |
$sql = "SELECT u.persknr, CONCAT (nachname, ', ',vorname) AS ma, userid, |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
49 |
CASE WHEN ISNULL(pwd) THEN '-' ELSE 'ja' END AS pw |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
50 |
FROM fhiiqm.userweb u INNER JOIN fhiiqm.Mitarbeiter m ON u.persknr = m.persknr |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
51 |
ORDER BY ma"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
52 |
if ($result = $dbc -> queryObjectArray($sql)) |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
53 |
{
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
54 |
$bg1 = "#F8F8F8"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
55 |
$bg2 = "#DEDFE1"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
56 |
$bg = "#FFFFFF"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
57 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
58 |
echo "<div align='center'>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
59 |
echo "<p><b>Liste der fhiiqm-Nutzer</b></p>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
60 |
echo "<p>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Sichten/Bearbeiten der Nutzer-Rechte</p>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
61 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
62 |
echo "<table cellpadding='2' cellspacing='2'>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
63 |
// Listenkopf |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
64 |
echo "<tr bgcolor='#68ACBF'>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
65 |
echo "<th>Mitarbeiter</th><th>userid</th><th>passwort?</th><th> </th></tr>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
66 |
foreach ($result as $row) |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
67 |
{
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
68 |
if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
69 |
echo "<tr bgcolor='" . $bg . "'><td><b>$row->ma</b></td>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
70 |
echo "<td>$row->userid</td>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
71 |
echo "<td class='center'>$row->pw</td>"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
72 |
echo "<td><a href='/fhiiqm/recht_ed.php?pid=$row->persknr'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
73 |
} |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
74 |
echo "</table></div>\n"; |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
75 |
} |
|
18
d0aa14180761
+ anlagen edit, korrekturen ma_fkt
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
16
diff
changeset
|
76 |
if (!is_null($_SESSION["recht"]) && in_array("re",$_SESSION["recht"]))
|
|
d0aa14180761
+ anlagen edit, korrekturen ma_fkt
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
16
diff
changeset
|
77 |
echo "<p> <a href=\"/fhiiqm/recht_ed.php\" target=\"_self\" title=\"Nutzer erfassen\" class=\"sc\">Weiteren Nutzer & Rechte erfassen</a></p>\n"; |
|
16
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
78 |
|
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
79 |
?> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
80 |
</body> |
|
3ebe66308a00
nochmal Recht, Prodgroup->Vertrag edit
Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de>
parents:
diff
changeset
|
81 |
</html> |