--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/user_recht_list.php Thu Jan 12 11:41:22 2012 +0100
@@ -0,0 +1,127 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 01/2012
+ *
+ * Liste Rechte je Nutzer
+ */
+
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ("inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("rte",$_SESSION["recht"]) && !in_array("rtr",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+?>
+
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+
+<head>
+ <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
+ <link type="text/css" href="/fhiiqm/css/db.css" rel="Stylesheet" media="screen"/>
+ <link type="text/css" href="/fhiiqm/css/db_print.css" rel="Stylesheet" media="print"/>
+ <title>Nutzer-Recht fhiiqm</title>
+</head>
+
+<body>
+
+<?php
+ echo " ";
+ echo "<div class=\"float-br smaller\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r\"><img src=\"img/user_go.png\" border=\"0\" alt=\"User, Rechte eingeben\" title=\"User, Rechte eingeben\"/></div>\n";
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $sql = "SELECT userid,
+ count(CASE recht_ID WHEN 'ar' THEN 1 END) AS anlage_read,
+ COUNT(CASE recht_ID WHEN 'ae' THEN 1 END) AS anlage_edit,
+ COUNT(CASE recht_ID WHEN 'fmr' THEN 1 END) AS funkt_ma_read,
+ COUNT(CASE recht_ID WHEN 'fme' THEN 1 END) AS funkt_ma_edit,
+ COUNT(CASE recht_ID WHEN 'ir' THEN 1 END) AS info_read,
+ COUNT(CASE recht_ID WHEN 'ie' THEN 1 END) AS info_edit,
+ COUNT(CASE recht_ID WHEN 'lr' THEN 1 END) AS laser_read,
+ COUNT(CASE recht_ID WHEN 'le' THEN 1 END) AS laser_edit,
+ COUNT(CASE recht_ID WHEN 'pr' THEN 1 END) AS prod_read,
+ COUNT(CASE recht_ID WHEN 'pe' THEN 1 END) AS prod_edit,
+ COUNT(CASE recht_ID WHEN 'rr' THEN 1 END) AS raum_read,
+ COUNT(CASE recht_ID WHEN 're' THEN 1 END) AS raum_edit,
+ COUNT(CASE recht_ID WHEN 'rtr' THEN 1 END) AS recht_read,
+ COUNT(CASE recht_ID WHEN 'rte' THEN 1 END) AS recht_edit,
+ COUNT(CASE recht_ID WHEN 'vr' THEN 1 END) AS vertrag_read,
+ COUNT(CASE recht_ID WHEN 've' THEN 1 END) AS vertrag_edit,
+ COUNT(CASE recht_ID WHEN 'vpr' THEN 1 END) AS vertr_part_read,
+ COUNT(CASE recht_ID WHEN 'vpe' THEN 1 END) AS vertr_part_edit
+ FROM `fhiiqm`.`user_recht`
+ GROUP BY userid";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+
+ echo "<div align='center'>\n";
+ echo "<p><b>Liste der fhiiqm-Nutzer und Rechte</b></p>\n";
+ echo "<p>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Sichten/Bearbeiten der Nutzer-Rechte</p>";
+
+ echo "<table cellpadding='2' cellspacing='2'>\n";
+ // Listenkopf
+ echo "<tr bgcolor='#68ACBF'>";
+ echo "<th>userid</th><th>Anlage read</th><th>Anlage edit</th>
+ <th>FktMa read</th><th>FktMa edit</th>
+ <th>Info read</th><th>Info edit</th>
+ <th>Laser read</th><th>Laser edit</th>
+ <th>Prod read</th><th>Prod edit</th>
+ <th>Raum read</th><th>Raum edit</th>
+ <th>Recht read</th><th>Recht edit</th>
+ <th>Vertrag read</th><th>Vertrag edit</th>
+ <th>VtrPart read</th><th>VtrPart edit</th>
+ </tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='" . $bg . "'><td><b>$row->userid</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->anlage_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->anlage_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->funkt_ma_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->funkt_ma_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->info_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->info_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->laser_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->laser_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->prod_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->prod_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->raum_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertrag_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_read)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_edit)) ."</b></td>";
+ echo "</tr>\n";
+ }
+ echo "</table></div>\n";
+ }
+ if (!is_null($_SESSION["recht"]) && in_array("re",$_SESSION["recht"]))
+ echo "<p class=\"sc\"> <a href=\"/fhiiqm/recht_ed.php\" target=\"_self\" title=\"Nutzer erfassen\">Weiteren Nutzer & Rechte erfassen</a></p>\n";
+
+?>
+</body>
+</html>
\ No newline at end of file