<?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 'asr' THEN 1 END) AS as_read,
COUNT(CASE recht_ID WHEN 'ase' THEN 1 END) AS as_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>Arb.Sichh. read</th><th>Arb.Sichh. 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->as_read)) ."</b></td>";
echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->as_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>