--- a/fhiiqm/as_report.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/as_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -115,6 +115,13 @@
</tr>
<tr>
<td class="bigger">
+ <a href="/fhiiqm/report/gefgr_gefahr_pic_report.php" title="Gefgruppe_Gefahr_Piktogramm">(5b) Gefährdunggruppe - Gefährdung - Piktogramm</a>
+ <br /> Auswahl: Gefährdungsgruppe, Gefährdung
+ <br /> Ansicht: Gefährdungsgruppe, Gefährdung, Piktogramm, Piktogramm-Bezeichnung
+ </td>
+ </tr>
+ <tr>
+ <td class="bigger">
<a href="/fhiiqm/report/gefahr_ap_report.php" title="Gefährdungen Arbeitsplatz">(6) Gefährdungen am Arbeitsplatz</a>
<br /> Auswahl: Haus, Raum, Arbeitsplatz-Typ, Gefährdung
<br /> Ansicht: Haus, Raum-Nr. Raum-Bezeichnung, Arbeitsplatz-Typ, Gefährdung, Maßnahmen
--- a/fhiiqm/css/db.css Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/css/db.css Mon Jul 01 14:36:18 2013 +0200
@@ -206,6 +206,16 @@
text-decoration: none;
color: #000066;
background-color: #a5adbd}
+
+.buttonb
+{ font-family: Verdana, Arial, Helvetica, Geneva, sans-serif;
+ border: 2px solid;
+ border-style:outset;
+ border-color: #a5adbd;
+ text-decoration: none;
+ font-weight: bold;
+ color: #000066;
+ background-color: #a5adbd}
.buttonr
{ font-family: Verdana, Arial, Helvetica, Geneva, sans-serif;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/keytyp_form.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,95 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Form keytyp
+ */
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $okn = true;
+
+?>
+<div align="center">
+<h5>* - Felder sind erforderlich!</h5>
+</div>
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_key">
+<!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> -->
+<div align="center">
+<table width="40%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Schlüsseltyp *</td>
+ <td><input name="ky[typ]" type="text" size="10" maxlength="10" value="<?php echo $ky['typ']; ?>" />
+ <?php
+ if (isset($ky['typ']) && $ky['typ']<'!')
+ {
+ echo "<br><span class=\"red\">Keytyp ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Level *</td>
+ <td><input name="ky[level]" type="text" size="10" maxlength="10" value="<?php echo $ky['level']; ?>" />
+ <?php
+ if (isset($ky['level']) && $ky['level']<'!')
+ {
+ echo "<br><span class=\"red\">Keylevel ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Parent-Level (*)</td>
+ <td><input name="ky[parent]" type="text" size="10" maxlength="10" value="<?php echo $ky['parent']; ?>" />
+ </td>
+ </tr>
+ <tr><td>Hierarchietyp</td>
+ <td><select name="ky[hier]">
+ <?php
+ if ($ky['hier'] == -1) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT key_hiertyp_ID, key_hiertyp_bez FROM Key_Hiertyp ORDER BY 2";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->key_hiertyp_ID == $ky['hier']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->key_hiertyp_ID\">$row->key_hiertyp_ID - $row->key_hiertyp_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Schlüsseltyp-Bezeichnung</td>
+ <td><input name="ky[bez]" type="text" size="50" maxlength="50" value="<?php echo $ky['bez']; ?>" />
+ </td>
+ </tr>
+ <tr><td>Schießanlage</td>
+ <td><select name="ky[anl]">
+ <?php
+ if ($ky['anl'] == -1) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT key_anl_ID, key_anl_bez FROM Key_Anlage ORDER BY 2";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->key_anl_ID == $ky['anl']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->key_anl_ID\">$row->key_anl_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <input type="hidden" name="ky[okn]" value="<?php echo $okn; ?>"/>
+<!-- </table>
+ </div>
+</form> -->
\ No newline at end of file
--- a/fhiiqm/form/raum_aptyp_form.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/form/raum_aptyp_form.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -115,6 +115,11 @@
</div>
</td>
</tr>
+ <tr>
+ <td>Bemerkung</td>
+ <td><textarea name="ap[bem]" cols="80" rows="10"><?php echo $ap['bem']; ?></textarea>
+ <div>max. 800 Zeichen sind möglich</div></td>
+ </tr>
<!--
</table>
</form>
--- a/fhiiqm/form/raum_form.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/form/raum_form.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -178,6 +178,12 @@
<td><input name="raum[rflae]" type="text" size="10" maxlength="10" value="<?php echo $raum['rflae']; ?>"/>
</td>
</tr>
+<!-- <tr>
+ <td>Bemerkung</td>
+ <td><textarea name="raum[bem]" cols="80" rows="10"><?php // echo $raum['bem']; ?></textarea>
+ <div>max. 800 Zeichen sind möglich</div></td>
+ </tr>
+-->
<tr>
<td>Dateibezeichnung Raumplan (*)</td>
<td><input name="raum[rfname]" type="text" size="50" maxlength="50" value="<?php echo $raum['rfname']; ?>">
Binary file fhiiqm/img/key.png has changed
--- a/fhiiqm/inc/dbconnect.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/inc/dbconnect.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -89,7 +89,7 @@
else
{ //kein Ergebnis
$this->error = "";
- $this->result->free();
+ if (isset($this->result) && is_object($this->result)) $this->result->free();
$this->_connid->next_result(); // wegen OUT-Parameter in stored procedures
return false;
}
@@ -125,7 +125,7 @@
else
{ //kein Ergebnis
$this->error = "";
- $this->result->free();
+ if (isset($this->result) && is_object($this->result)) $this->result->free();
$this->_connid->next_result(); // wegen OUT-Parameter in stored procedures
return false;
}
--- a/fhiiqm/inc/func_lib.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/inc/func_lib.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -318,5 +318,5 @@
else
return 0;
}
-
+
?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/keytyp_dat_show.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,30 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Anlisten INSERT/UPDATE Daten Keytyp
+ */
+
+ echo "<table>\n";
+ echo "<tr><td>Schlüsseltyp: </td><td>" . $ky["typ"] . "</td></tr>\n";
+ echo "<tr><td>Level: </td><td>" . $ky["level"] . "</td></tr>\n";
+ echo "<tr><td>Parent-Level: </td><td>" . $ky["parent"] . "</td></tr>\n";
+ if ($ky["hier"])
+ {
+ $sql = "SELECT key_hiertyp_bez FROM Key_Hiertyp WHERE key_hiertyp_ID ='" . $ky["hier"] ."'";
+ $hier = $dbc -> querySingleItem($sql);
+ echo "<tr><td>Hierarchietyp: </td><td>" . $ky["hier"] . " - $hier</td></tr>\n";
+ }
+ else echo "<tr><td>Hierarchietyp: </td><td> </td></tr>\n";
+ echo "<tr><td>Bezeichnung: </td><td>" . $ky["bez"] . "</td></tr>\n";
+ if ($ky["anl"])
+ {
+ $sql = "SELECT key_anl_bez FROM Key_Anlage WHERE key_anl_ID = ".$ky["anl"];
+ $anl = $dbc -> querySingleItem($sql);
+ echo "<tr><td>Schließanlage: </td><td>$anl</td></tr>\n";
+ }
+ else echo "<tr><td>Schließanlage: </td><td> </td></tr>\n";
+ echo "</table>\n";
+?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/keytyp_list_ac.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,51 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Autocomplete keytyp
+ */
+
+ header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ $q = strtolower(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben, term UTF-8 codiert
+ $typ = $_GET['t']; // k=keytyp, l=level
+ $dep = $_GET['d']; // Depotkorrektur: keytyp nicht in Depot dep
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick
+ if ($typ == "k")
+ $sql = "SELECT keytyp_ID as val,keytyp_ID as label, keytyp_ID as id
+ FROM `fhiiqm`.`Keytyp`
+ WHERE keytyp_ID LIKE '%".$q."%' COLLATE latin1_general_ci
+ ORDER BY 1";
+ elseif ($typ == "l")
+ $sql = "SELECT key_level as label,key_level as val, key_level as id
+ FROM `fhiiqm`.`Keytyp`
+ WHERE key_level LIKE '%".$q."%' COLLATE latin1_general_ci
+ ORDER BY 1";
+ elseif ($dep == "d")
+ $sql = "SELECT CONCAT(key_level,' - ',k.keytyp_ID) as label,k.keytyp_ID as val, k.keytyp_ID as id
+ FROM Keytyp k LEFT OUTER JOIN Keytyp_Depot d ON k.keytyp_ID = d.keytyp_ID AND depot_ID = '".$dep."'
+ WHERE k.keytyp_ID LIKE '%".$q."%' AND d.keytyp_ID IS NULL
+ ORDER BY 1";
+ else
+ $sql = "SELECT CONCAT(key_level,' - ',keytyp_ID) as label,keytyp_ID as val, keytyp_ID as id
+ FROM Keytyp
+ WHERE keytyp_ID LIKE '%".$q."%'
+ ORDER BY 1";
+
+ $result = $dbc ->queryObjectArray($sql);
+ if ($result)
+ {
+ foreach ($result as $row)
+ {
+ $clist[] = "{\"label\": \"" . $row->label . "\",\"value\": \"" . $row->val . "\",\"id\": \"" . $row->id . "\"}";
+ }
+ echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet
+ }
+ $dbc -> close();
+?>
\ No newline at end of file
--- a/fhiiqm/inc/menu.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/inc/menu.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -183,6 +183,19 @@
</li>\n";
}
// }
+ if (in_array("kr",$_SESSION["recht"]) || in_array("ke",$_SESSION["recht"]))
+ {
+ echo "<li>Schlüsselverwaltung\n";
+ echo "<ul>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_tract_dep.php\" target=\"_blank\" title=\"Keytyp Transfer Depot\">Schlüsseltyp innerhalb Depots verschieben</a></li>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_tract_ma.php\" target=\"_blank\" title=\"Keytyp Transfer MA\">Schlüsseltyp Depot - MA verschieben</a></li>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_ma_search.php\" target=\"_blank\" title=\"MA-Keytyp Suche\">Schlüsseltypen - Mitarbeiter Suche</a></li>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_search.php\" target=\"_blank\" title=\"Keytyp MA Suche\">Schlüsseltyp suchen, bearbeiten</a></li>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_korr_dep.php\" target=\"_blank\" title=\"Keytyp Korrektur Depot\">Schlüsseltyp Depot - Korrektur</a></li>\n";
+ echo "<li><a href=\"/fhiiqm/keytyp_report.php\" target=\"_blank\" title=\"Report Keytyp\">Berichte Schlüsseltyp</a></li>\n";
+ echo "</ul>\n
+ </li>\n";
+ }
echo "<li>Mitarbeiter - Telefon\n
<ul>\n";
if (in_array("mte",$_SESSION["recht"]))
--- a/fhiiqm/inc/pdf_ma_tel.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/inc/pdf_ma_tel.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -11,7 +11,8 @@
class PDF extends FPDF
{
var $y0, $y, $xa, $width, $height;
- var $wid = array(55,25,40,15,40); // Breite: Spalten 'new'
+// var $wid = array(55,25,40,15,40); // Breite: Spalten 'new'
+ var $wid = array(65,15,40,15,40); // Breite: Spalten 'new'
var $fancy = 1;
var $anzcol = 2;
var $col = 0;
--- a/fhiiqm/inc/raum_aptyp_dat_show.inc.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/inc/raum_aptyp_dat_show.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -9,7 +9,7 @@
*/
echo "<table>\n";
- $sql = "SELECT geb_ID, raum_nr, raum_name FROM Raum WHERE raum_ID = " . $ap['raum'];
+ $sql = "SELECT geb_ID, raum_nr, raum_name, raum_bem FROM Raum WHERE raum_ID = " . $ap['raum'];
$res = $dbc -> queryObjectArray($sql);
foreach ($res as $row)
{
@@ -26,5 +26,6 @@
if ($atyp && $atyp != -1) echo "$next<td>$atyp</td></tr>\n";
}
}
+ echo "<tr><td>Bemerkung: </td><td>$row->raum_bem</td></tr>\n";
echo "</table>\n";
?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/show_img_gef.inc.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,26 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 04/2013
+ */
+
+ $gid=urldecode($_GET["gid"]);
+ if (!$gid) return false;
+ include_once ($_SERVER['DOCUMENT_ROOT']. "/fhiiqm/inc/dbconnect.inc.php");
+
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $sql = "SELECT gefahr_pic FROM Gefahr WHERE gefahr_ID='" . $gid ."'";
+ $pic = $dbc -> querySingleItem($sql);
+
+ if ($pic)
+ {
+ /*** set the headers and display the image ***/
+ header("Content-type: image/jpg");
+
+ /*** output the image ***/
+ echo $pic;
+ }
+ else echo $gid;
+?>
\ No newline at end of file
--- a/fhiiqm/info_betrst_ed.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/info_betrst_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -256,8 +256,9 @@
echo "</div>\n";
//Filename wenn Upload?
- foreach ($_FILES["ifile"]["error"] as $key => $err)
- if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
+ if (isset($_FILES["ifile"]["error"]))
+ foreach ($_FILES["ifile"]["error"] as $key => $err)
+ if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
if (!$ok || (!$sub && !$del && !$dup))
{
--- a/fhiiqm/info_ed.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/info_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -206,8 +206,9 @@
echo "</div>\n";
//Filename wenn Upload?
- foreach ($_FILES["ifile"]["error"] as $key => $err)
- if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
+ if (isset($_FILES["ifile"]["error"]))
+ foreach ($_FILES["ifile"]["error"] as $key => $err)
+ if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
if (!$ok || (!$sub && !$del && !$dup))
{
--- a/fhiiqm/info_ed3.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/info_ed3.php Mon Jul 01 14:36:18 2013 +0200
@@ -260,8 +260,9 @@
echo "</div>\n";
//Filename wenn Upload?
- foreach ($_FILES["ifile"]["error"] as $key => $err)
- if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
+ if (isset($_FILES["ifile"]["error"]))
+ foreach ($_FILES["ifile"]["error"] as $key => $err)
+ if ($err == 0 && !$inf["ifname"][$key]) $ok = $ok && false;
if (!$ok || (!$sub && !$del && !$dup))
{
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,186 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * INSERT, UPDATE Keytype
+ */
+
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // userid: Depot 'FHI', 'edit' = 1 -> Keytyp bearbeitbar
+ $redit = 0;
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT edit FROM KeyDepot_userweb WHERE depot_ID = 'FHI' AND userid = '$uid'";
+ $redit = $dbc -> querySingleItem($sql);
+
+ $sub = $_POST["eintragen"];
+ $del = $_POST["del"];
+ $ky = $_POST["ky"];
+ $okn = $ky["okn"];
+ $ok = $_POST["ok"];
+ if (!$okn) $ok=0;
+ $kid = $_GET["i"]; // keytyp
+ $getp = "s=1&k=$kid"
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Keytyp bearbeiten</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/key.png\" border=\"0\" alt=\"Keytyp bearbeiten\" title=\"Schlüsseltyp bearbeiten\"/></div>\n";
+
+ if ($redit)
+ if ($kid) $text = "editieren"; else $text = "erfassen";
+ else $text = "Ansicht";
+ echo "<div align=\"center\">";
+ echo "<h3>Schlüsseltyp $text</h3>";
+ echo "</div>\n";
+ if ((!$sub && !$del) || !isset($ky) || !$ok)
+ {
+ if ($kid && (!$sub || !$del) && !isset($ma))
+ {
+ $sql = "SELECT keytyp_ID,key_level,key_parent,key_hiertyp_ID,keytyp_bez,key_anl_ID FROM Keytyp WHERE keytyp_ID='$kid'";
+ if ($result = $dbc -> queryObjectArray($sql))
+ foreach ($result as $row)
+ {
+ $ky['typ'] = $row->keytyp_ID;
+ $ky['level'] = $row->key_level;
+ $ky['parent'] = $row->key_parent;
+ $ky['hier'] = $row->key_hiertyp_ID;
+ $ky['bez'] = $row->keytyp_bez;
+ $ky['anl'] = $row->key_anl_ID;
+ }
+ }
+ include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/keytyp_form.inc.php");
+
+ if ($sub || $del)
+ {
+ if ($sub)
+ $frage = "Alle Angaben ok?";
+ elseif ($del)
+ $frage = "Schlüsseltyp wirklich löschen?";
+ echo "<tr>
+ <td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
+ <td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
+ if ($ok) echo "checked=\"checked\"";
+ echo " /></td>\n</tr>\n";
+ }
+ if (!is_null($_SESSION["recht"]) && in_array("ke",$_SESSION["recht"]) && $redit)
+ {
+ echo "
+ <tr><td> </td>\n
+ <td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />";
+ if ($kid)
+ {
+ echo " <input class=\"buttonr\" type=\"submit\" value=\"löschen\" name=\"del\" title=\"delete\" />";
+// echo " <input class=\"button\" type=\"submit\" value=\"duplizieren\" name=\"dup\" title=\"delete\" />";
+ }
+ echo "</td></tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"keytyp_search.php?$getp\" target=\"_self\" title=\"Schlüsseltyp-Suche\">« zur Schlüsseltyp-Suche</a></p>\n";
+ echo "</form>\n";
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($del)
+ {
+ $sql = "DELETE FROM Keytyp WHERE keytyp_ID='$kid'";
+ if ($dbc -> execute($sql))
+ echo "<p class='green'><b>DELETE: Daten zu '$kid' wurden erfolgreich gelöscht.</b></p>\n";
+ else
+ {
+ echo "<p class='red'><b>DELETE: Daten zu '$kid' konnten nicht gelöscht werden!</b></p>\n";
+ echo "sql = $sql<br />";
+ echo "error DELETE: " . $dbc->error . "<br />";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/keytyp_dat_show.inc.php");
+ }
+ else
+ {
+ if ($ky['hier'] == -1) $ky['hier'] = null;
+ if ($ky['anl'] == -1) $ky['anl'] = null;
+ foreach ($ky as &$elem) if (!$elem) $elem = null; // NULL-Eintrag in Leerfelder
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ if ($kid) // UPDATE
+ {
+ $stmt -> prepare("UPDATE Keytyp SET
+ key_level = ?,
+ key_parent = ?,
+ key_hiertyp_ID = ?,
+ keytyp_bez = ?,
+ key_anl_ID = ?
+ WHERE keytyp_ID = '$kid'");
+ $stmt -> bind_param('sssss',$ky['level'],$ky['parent'],$ky['hier'],$ky['bez'],$ky['anl']);
+// echo "UPDATE: ". var_dump($stmt);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error UPDATE Keytyp: " . $stmt->error . "<br><br>\n";
+ }
+ else
+ {
+ $stmt -> prepare("INSERT INTO Keytype (keytyp_ID,key_level,key_parent,key_hier_ID,key_bez,key_anl_ID) VALUES(?,?,?,?,?,?)");
+ $stmt -> bind_param('ssssss',$ky['typ'],$ky['level'],$ky['parent'],$ky['hier'],$ky['bez'],$ky['anl']);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error INSERT Keytyp: " . $stmt->error . "<br><br>\n";
+ }
+ if ($result) // INSERT/UPDATE Keytyp
+ {
+ //Eingabe Daten erfolgreich
+ echo "<p class='green'><b>Keytypdaten zu '" . $ky['typ']. "', Level = '". $ky['level'] . "' wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<br /><br />\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>Keytypdaten zu '" . $ky['typ']. "', Level = '". $ky['level'] . "' konnten nicht gespeichert werden.</b></p>\n";
+ echo "error: ". $dbc -> error;
+ echo "<br /><br />\n";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/keytyp_dat_show.inc.php");
+ }
+
+ }
+ echo "</div>";
+ echo "<p class='sc'> <a href=\"keytyp_search.php?$getp\" target=\"_self\" title=\"Schlüsseltyp-Suche\">« zur Schlüsseltyp-Suche</a></p>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Schlüsseltyp erfassen\">Neuen Schlüsseltyp erfassen</a></p>\n";
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_korr_dep.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,211 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Keytyp add, lost Depot
+ */
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // zulaessige Depots, 'edit' = 1 -> bearbeitbar
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT depot_ID,edit FROM KeyDepot_userweb WHERE userid = '$uid'";
+ $res = $dbc -> queryObjectArray($sql);
+ foreach ($res as $row)
+ if ($row->edit) $adep[] = $row->depot_ID;
+// print_r($adep); echo "<br />";
+ $aaction = array("get" => "Zugang", "out" => "Abgang", "lost" => "Verlust"); //Bezeichnung Transfer
+
+ $ky = $_POST["ky"];
+ $dep = $ky['dep'];
+ if (!$dep) $dep='AC';
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness-1.8.21/jquery-ui-1.8.21.custom.css" rel="Stylesheet" />
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.7.2.min.js"></script>
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.21.custom.min.js"></script>
+ <title>Keytyp Dep korrigieren</title>
+</head>
+
+<body>
+ <script>
+ $(document).ready(function() {
+ var dep = document.getElementById("dep");
+ dep = dep.value;
+ $("#ktn").autocomplete({
+ source: "/fhiiqm/inc/keytyp_list_ac.inc.php?t=d&d="+dep,
+ minLength: 2,
+ select: function(event,ui){$("#ktn").val(ui.item.id);}
+ });
+ });
+ </script>
+
+<?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/key.png\" border=\"0\" alt=\"Keytyp transferieren\" title=\"Depotverwaltung Schlüsseltyp\"/></div>\n";
+
+ echo "<div align=\"center\">";
+ echo "<h3>Korrektur Schlüsseltyp im Depot</h3>";
+ echo "</div>\n";
+
+ if (!isset($adep))
+ echo "<p class='red'> Sie haben nicht das Recht, Schlüssel in Depots zu pflegen. Bitte wenden Sie sich an Frau Kohl.</p>";
+ else
+ {
+
+ $out = $_POST["out"];
+ $get = $_POST["get"];
+ $lost = $_POST["lost"];
+
+ if (isset($ky) && ($out || $lost))
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzdep < $ky["anz"]) $err = "Abgang/Verlust: Bestand '". $ky["kt"] ."' Depot 'FHI': <b>$anzdep < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky["anz"]) && !is_numeric($ky["anz"]) && ($out || $get || $lost)) $err = "Anzahl ist ncht numerisch!";
+
+ if (!isset($ky) || (!$out && !$get && !$lost) || $err)
+ {
+?>
+ <div align="center">
+ <h5>* - Felder sind erforderlich!</h5>
+ </div>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_key">
+ <div align="center">
+ <?php
+ if ($err) echo "<p class='red'>$err</p>\n";
+ ?>
+ <table width="50%" border="0" cellspacing="3" cellpadding="3">
+
+ <tr>
+ <td>Depot *</td><td>Schlüsseltyp *</td><td>Schlüsseltyp neu</td><td>Anzahl *</td>
+ </tr>
+ <tr>
+ <td><select id="dep" name="ky[dep]" onchange="this.form.submit();">
+ <?php
+ $strdep = "'". implode("','",$adep) ."'";
+// echo "$strdep<br />";
+ $sql = "SELECT * FROM fhiiqm.KeyDepot WHERE depot_ID IN ($strdep)";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['dep'] && !$beg) $ky['dep'] = $row->depot_ID;
+ if ($row->depot_ID == $ky['dep']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->depot_ID\">$row->depot_ID: $row->depot_bez</option>\n";
+ $beg=1;
+ }
+ $beg=0;
+ ?>
+ </select>
+ </td>
+ <td><select name="ky[kt]">
+ <?php
+ $strdep = "'". implode("','",$adep) ."'";
+ $sql = "SELECT key_level,d.keytyp_ID,keytyp_bez,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot d INNER JOIN Keytyp k ON d.keytyp_ID=k.keytyp_ID
+ WHERE depot_ID = '" . $ky['dep'] . "'
+ GROUP BY key_level,d.keytyp_ID,keytyp_bez";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['kt'] && !$beg)
+ $ky['kt'] = $row->keytyp_ID;
+ if ($row->keytyp_ID == $ky['kt']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->keytyp_ID\">$row->key_level - $row->keytyp_ID [$row->keytyp_bez] ($row->bestand)</option>\n";
+ $beg=1;
+ }
+ $beg=0;
+ ?>
+ </select>
+ oder
+ </td>
+ <td><input id="ktn" name="ky[ktn]" type="text" size="10" maxlength="10" value="<?php echo $ky['ktn']; ?>" /></td>
+ <td><input name="ky[anz]" type="text" size="5" maxlength="3" value="<?php echo $ky['anz']; ?>" /></td>
+ </tr>
+ <tr><td> </td><td colspan="3">neuer Schlüsseltyp: bitte mind. 2 Zeichen Schlüsseltyp eingeben -> Liste der verfügbaren</td></tr>
+ <tr><td>Bemerkung</td><td colspan="3"><textarea name="ky[bem]" cols="50" rows="2"><?php echo $ky['bem']; ?></textarea></td></tr>
+ <?php
+ if (in_array("ke",$_SESSION["recht"]))
+ {
+ ?>
+ <tr><td> </td><td colspan="3"><input class="button" type="submit" name="get" value="Zugang +" title="Zugang"/>
+ <input class="button" type="submit" name="out" value="Abgang -" title="Abgang"/>
+ <input class="button" type="submit" name="lost" value="Verlust -" title="Verlust"/></td></tr>
+ <?php
+ }
+ ?>
+ </table>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+ if (is_numeric($ky["anz"]) && $ky["anz"] != 0)
+ {
+ $ky["bem"] = substr($ky["bem"],0,100);
+ if ($ky["ktn"] > '') $kt = $ky["ktn"]; else $kt = $ky["kt"];
+ if ($get) $action = "get";
+ elseif ($out) $action = "out";
+ elseif ($lost) $action = "lost";
+ $adate = new DateTime();
+ $adate = $adate->format('Y-m-d H:i:s');
+
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ $stmt -> prepare("INSERT INTO Keytyp_Depot (keytyp_ID,depot_ID,depot_date,depot_action,depot_anz,depot_bem) VALUES(?,?,?,?,?,?)");
+ $stmt -> bind_param('ssssis', $kt,$ky["dep"], $adate,$action,$ky["anz"],$ky["bem"]);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error Korrekur(INSERT) Schlüsseltyp: " . $stmt->error . "<br><br>\n";
+ if ($result) // INSERT/UPDATE Keytyp
+ {
+ //Eingabe Daten erfolgreich
+ echo "<p class='green'><b>".$aaction["$action"].": Anzahl Schlüsseltyp '$kt' im Depot '" . $ky['dep']. "' wurde erfolgreich aktualisiert.</b></p>\n";
+ }
+ else
+ echo "<p class='red'><b>".$aaction["$action"].": Anzahl Schlüsseltyp '$kt' im Depot '" . $ky['dep']."' konnte nicht gespeichert werden.</b></p>\n";
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '$kt'";
+ $newanz = $dbc -> querySingleItem($sql);
+ echo "<p>neuer Bestand Depot '" .$ky["dep"]."', Schlüsseltyp '$kt' = $newanz </p><br /><br />\n";
+ }
+ }
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Depot-Korrektur\">Weitere Depot-Korrektur</a></p>\n";
+ }
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_ma_search.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,185 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Schlüssel pro Mitarbeiter
+ */
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness-1.8.21/jquery-ui-1.8.21.custom.css" rel="Stylesheet" />
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.7.2.min.js"></script>
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.21.custom.min.js"></script>
+ <title>Mitarbeiter-Schlüssel Suche</title>
+
+</head>
+
+<body>
+ <script>
+ $(document).ready(function() {
+ $("#ma").focus();
+ $("#ma").autocomplete({
+ source: "/fhiiqm/inc/ma_list_ac.inc.php",
+ minLength: 2,
+ select: function(event,ui){$("#pid").val(ui.item.id);
+ $("#s").val(1);},
+ close: function(event,ui){$("#f_makey").submit();}
+ });
+ $("#kt").autocomplete({
+ source: "/fhiiqm/inc/keytyp_list_ac.inc.php",
+ minLength: 2,
+ select: function(event,ui){$("#kt").val(ui.item.id);
+ $("#s").val(1);},
+ close: function(event,ui){$("#f_makey").submit();}
+ });
+ });
+ </script>
+<?php
+ echo " ";
+ echo "<div class=\"float-br smaller sc\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r sc\"><img src=\"/fhiiqm/img/key.png\" border=\"0\" alt=\"key\" title=\"key\"/></div>\n";
+
+ echo "<div align='center'><h3>Schlüssel - Mitarbeiter</h3></div>\n";
+
+ $ky = $_POST["ky"]; // Parameter aus Form
+//print_r($ky); echo "<br />";
+ $search = $_POST["search"];
+ if (!$ky)
+ {
+ $ky['persknr'] = $_GET['p'];
+ $ky['kt'] = $_GET['k'];
+ }
+ if (!$search) $search = $_GET["s"];
+ If (!$search) $search = $ky["s"];
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_makey" id="f_makey" target="_self">
+ <table width="30%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Bitte Mitarbeiter</td>
+ <td><input class="long20" type="text" name="ky[ma]" id="ma" value="<?php echo $ky['ma']; ?>"/></td>
+ </tr>
+ <tr>
+ <td>oder Schlüsseltyp wählen</td>
+ <td><input class="long20" type="text" name="ky[kt]" id="kt" value="<?php echo $ky['kt']; ?>"/>
+ <br />jeweils mindestens 2 Zeichen eingeben
+ <input type="hidden" name="ky[persknr]" id="pid" value="<?php echo $ky['persknr']; ?>"/>
+ <input type="hidden" name="ky[s]" id="s" value="<?php echo $ky['s']; ?>"/>
+ </td>
+ </tr>
+ </form>
+ </div>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+ if ($ky["persknr"])
+ {
+ $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem,
+ (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status
+ FROM fhiiqm.Mitarbeiter m
+ INNER JOIN Keytyp_MA km ON m.persknr=km.persknr
+ INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID
+ WHERE m.aktiv<2 AND m.persknr = ".$ky["persknr"].
+ " ORDER BY key_level, pers_date";
+ //echo "sql = $sql<br />";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ echo "<p><b>".$ky["ma"]." -> Schlüssel</b></p>\n";
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ echo "<table width='35%' border='0' cellspacing='2' cellpadding='2'>\n";
+ echo "<tr bgcolor='#68ACBF'><th>Schlüssel</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>Bemerkung</th></tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ $dat = new DateTime($row->pers_date);
+ echo "<tr bgcolor='" . $bg . "'><td>$row->key_level - $row->keytyp_ID</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td>
+ <td>".nl2br($row->pers_bem)."</td></tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ }
+ else
+ {
+ echo "<p class='red'> An <b>".$ky["ma"]."</b> wurden keine Schlüssel vergeben!</p>";
+ echo "</div>\n";
+ echo "<br /> ";
+ }
+ }
+ else
+ {
+ $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem,
+ CONCAT(TRIM(nachname), ', ',vorname,' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname,
+ (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status
+ FROM fhiiqm.Mitarbeiter m
+ INNER JOIN Keytyp_MA km ON m.persknr=km.persknr
+ INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID
+ WHERE m.aktiv<2 AND km.keytyp_ID = '".$ky["kt"].
+ "' ORDER BY nvname, pers_date";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ $sql = "SELECT key_level FROM Keytyp WHERE keytyp_ID = '".$ky["kt"]."'";
+ $keylevel = $dbc -> querySingleItem($sql);
+ echo "<p><b>'$keylevel' - '".$ky["kt"]."' -> Mitarbeiter</b></p>\n";
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n";
+ echo "<tr bgcolor='#68ACBF'><th>Mitarbeiter</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>Bemerkung</th></tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ $dat = new DateTime($row->pers_date);
+ echo "<tr bgcolor='" . $bg . "'><td>$row->nvname</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td>
+ <td>".nl2br($row->pers_bem)."</td></tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ }
+ else
+ {
+ echo "<p class='red'> <b>".$ky["kt"]."</b> wurde nicht vergeben!</p>";
+ echo "</div>\n";
+ echo "<br /> ";
+ }
+
+ }
+ echo " <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"neue Suche\" class=\"sc\">neue Mitarbeiter-Schlüsselsuche</a>\n";
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,64 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Reportauswahl Keytyp
+ *
+ */
+
+
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_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 href="css/db.css" rel="STYLESHEET" type="TEXT/CSS" />
+ <link href="css/navio.css" rel="STYLESHEET" type="TEXT/CSS" />
+ <meta name="author" content="Bettina Schwarzer,FHI" />
+
+ <title>Reports Keytyp</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 sc\"><img src=\"/fhiiqm/img/key.png\" border=\"0\" alt=\"Berichte Keytyp\" title=\"Berichte Schlüsseltyp\"/></div>\n";
+?>
+ <h3> Berichte Schlüsseltyp</h3>
+ <div align="center">
+ <table width="94%" cellspacing="4" cellpadding="4">
+ <tr>
+ <td class="bigger">
+ <a href="/fhiiqm/report/keytyp_dep_anz_report.php" title="Keytyp-Depot">Schlüsseltyp - Depot</a>
+ <br /> Auswahl: Depot, Schlüsseltyp
+ <br /> Ansicht: Depot, Schlüsseltyp, Anzahl Zugang, Abgang, Verlust, Bestand
+ </td>
+ </tr>
+ </table>
+ </div>
+
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_search.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,156 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Schlüsselsuche mit Anzeige Hierarchie
+ * Eingabe keytype oder Level
+ * Edit keytype
+ */
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness-1.8.21/jquery-ui-1.8.21.custom.css" rel="Stylesheet" />
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.7.2.min.js"></script>
+ <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.21.custom.min.js"></script>
+ <title>Keytyp Suche</title>
+
+</head>
+
+<body>
+ <script>
+ $(document).ready(function() {
+ $("#key").focus();
+ $("#key").autocomplete({
+ source: "/fhiiqm/inc/keytyp_list_ac.inc.php?t=k",
+ minLength: 2,
+ select: function(event,ui){$("#key").val(ui.item.id);
+ $("#s").val(1);},
+ close: function(event,ui){$("#form_key").submit();}
+ });
+ $("#level").autocomplete({
+ source: "/fhiiqm/inc/keytyp_list_ac.inc.php?t=l",
+ minLength: 2,
+ select: function(event,ui){$("#level").val(ui.item.id);
+ $("#s").val(1);},
+ close: function(event,ui){$("#form_key").submit();}
+ });
+ });
+ </script>
+<?php
+ echo " ";
+ echo "<div class=\"float-br smaller sc\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r sc\"><img src=\"/fhiiqm/img/key.png\" border=\"0\" alt=\"key\" title=\"key\"/></div>\n";
+
+ echo "<div align='center'><h3>Schlüssel und -Hierarchie</h3></div>\n";
+
+ $ky = $_POST["ky"]; // Parameter aus Form
+ if (!$ky)
+ {
+ $ky['key'] = $_GET['k'];
+ $ky['level'] = $_GET['l'];
+ }
+ $search = $_POST["search"];
+ if (!$search) $search = $_GET["s"];
+ If (!$search) $search = $ky["s"];
+
+ $getp = "s=1&l=".$ky['level'];
+
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <p>Bitte Kriterien für die Suche wählen</p>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_key" id="form_key" target="_self">
+ <table width="30%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Schlüsselnummer</td>
+ <td><input type="text" name="ky[key]" id="key" maxlength="10" value="<?php echo $ky['key']; ?>" /></td>
+ </tr>
+ <tr>
+ <td>Level</td>
+ <td><input type="text" name="ky[level]" id="level" maxlength="10" value="<?php echo $ky['level']; ?>" />
+ <br />jeweils mindestens 2 Zeichen eingeben
+ <input type="hidden" name="ky[s]" id="s" value="<?php echo $ky['s']; ?>"/>
+</td>
+ </tr>
+<!-- <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Suchen"/></td>
+ </tr> -->
+ </table>
+ </form>
+ </div>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+ $sql = "CALL key_hier('". $ky['key']."','".$ky['level']."')";
+ $result = $dbc -> queryObjectArray($sql);
+ if ($result)
+ {
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n";
+ echo "<tr bgcolor='#68ACBF'><th>keytyp</th><th>level</th><th>parent</th><th>bezeichnung</th><th>hierarchie-typ</th><th> </th></tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ if (strtoupper($row->keytyp_ID) == strtoupper($ky['key'])) $keytyp = "<b>$row->keytyp_ID</b>"; else $keytyp = $row->keytyp_ID;
+ if ($row->key_level == $ky['level']) $keylevel = "<b>$row->key_level</b>"; else $keylevel = $row->key_level;
+ echo "<tr bgcolor='" . $bg . "'>";
+ echo "<td>$keytyp</td>";
+ echo "<td>$keylevel</td>";
+ echo "<td>$row->key_parent</td>";
+ echo "<td>$row->keytyp_bez</td>";
+ echo "<td>$row->key_hiertyp_ID</td>";
+ if (in_array("ke",$_SESSION["recht"]) && (strtoupper($row->keytyp_ID) == strtoupper($ky['key']) || $row->key_level == $ky['level']))
+ echo "<td><a href='/fhiiqm/keytyp_ed.php?i=$row->keytyp_ID&$getp'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>";
+ else echo "<td> </td>";
+ echo "</tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ }
+ else
+ {
+ echo "<p class='red'> Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
+ echo "</div>\n";
+ echo "<br /> ";
+ }
+ echo " <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"neue Suche\" class=\"sc\">neue Schlüsselsuche</a>\n";
+
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_tract_dep.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,206 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Keytyp Transaktion Depot - Depot
+ */
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // zulaessige Depots: nur FHI
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT depot_ID,edit FROM KeyDepot_userweb WHERE userid = '$uid'";
+// $sql = "SELECT depot_ID FROM KeyDepot_userweb WHERE userid = '$uid'";
+ $res = $dbc -> queryObjectArray($sql);
+ foreach ($res as $row)
+ if ($row->edit) $adep[] = $row->depot_ID;
+// print_r($adep); echo "<br />";
+ $aaction = array("get" => "Rücknahme", "out" => "Ausgabe", "lost" => "Verlust"); //Bezeichnung Transfer
+
+?>
+
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Keytyp Depot transferieren</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/key.png\" border=\"0\" alt=\"Keytyp transferieren\" title=\"Depotverwaltung Schlüsseltyp\"/></div>\n";
+
+ echo "<div align=\"center\">";
+ echo "<h3>Schlüsseltyp von/in Depot verschieben</h3>";
+ echo "</div>\n";
+
+ if (!isset($adep))
+ echo "<p class='red'> Sie haben nicht das Recht, Transfers von Schlüsseln in Depots vorzunehmen. Bitte wenden Sie sich an Frau Kohl.</p>";
+ else
+ {
+
+ $out = $_POST["out"];
+ $get = $_POST["get"];
+// $lost = $_POST["lost"];
+ $ky = $_POST["ky"];
+ if (isset($ky) && $get)
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzdep < $ky["anz"]) $err = "Rücknahme: Bestand '". $ky["kt"] ."' Depot '". $ky["dep"] . "': <b>$anzdep < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky) && $out)
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='FHI' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzdep < $ky["anz"]) $err = "Ausgabe: Bestand '". $ky["kt"] ."' Depot 'FHI': <b>$anzdep < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky["anz"]) && !is_numeric($ky["anz"]) && ($out || $get || $lost)) $err = "Anzahl ist ncht numerisch!";
+
+ if (!isset($ky) || (!$out && !$get) || $err)
+ {
+ /* form: 'accept-charset="utf-8"' wegen Umlauten in Formfeldern und Nichtnutzen mysqli, sondern sp für INSERTS */
+ ?>
+ <div align="center">
+ <h5>* - Felder sind erforderlich!</h5>
+ </div>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_key" accept-charset="utf-8">
+ <div align="center">
+ <?php
+ if ($err) echo "<p class='red'>$err</p>\n";
+ ?>
+ <table width="45%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Depot FHI Schlüsseltyp *</td><td>Anzahl *</td><td>Depot *</td>
+ </tr>
+ <tr>
+ <td><select name="ky[kt]" onchange="this.form.submit();">
+ <?php
+ $sql = "SELECT key_level,d.keytyp_ID,keytyp_bez,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot d INNER JOIN Keytyp k ON d.keytyp_ID=k.keytyp_ID
+ WHERE depot_ID='FHI'
+ GROUP BY key_level,keytyp_ID,keytyp_bez";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['kt'] && !$start) $ky['kt'] = $row->keytyp_ID;
+ if ($row->keytyp_ID == $ky['kt']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->keytyp_ID\">$row->key_level - $row->keytyp_ID [$row->keytyp_bez] ($row->bestand)</option>\n";
+ $start=1;
+ }
+ ?>
+ </select>
+ </td>
+ <td><input name="ky[anz]" type="text" size="5" maxlength="3" value="<?php echo $ky['anz']; ?>" /></td>
+ <td><select name="ky[dep]" onchange="this.form.submit();">
+ <?php
+ $strdep = "'". implode("','",$adep) ."'";
+ echo "$strdep<br />";
+ $sql = "SELECT * FROM fhiiqm.KeyDepot WHERE depot_ID IN ($strdep)";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['dep'] && !$beg) $ky['dep'] = $row->depot_ID;
+ if ($row->depot_ID == $ky['dep']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->depot_ID\">$row->depot_ID: $row->depot_bez</option>\n";
+ $beg=1;
+ }
+ ?>
+ </select>
+ <?php
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ // echo "nach submit: $sql<br />";
+ $anzdep = $dbc->querySingleItem($sql);
+ echo " ($anzdep)";
+ ?>
+ </td>
+ </tr>
+ <tr><td>Bemerkung</td><td colspan="2"><textarea name="ky[bem]" cols="50" rows="2"><?php echo $ky['bem']; ?></textarea></td></tr>
+ <?php
+ if (in_array("ke",$_SESSION["recht"]))
+ {
+ ?>
+ <tr><td></td><td><input class="button" type="submit" name="out" value="-> Ausgabe " title="Ausgabe"/></td></tr>
+ <tr><td></td><td><input class="button" type="submit" name="get" value="<- Rücknahme" title="Rueckgabe"/></td></tr>
+ <!-- <tr><td></td><td><input class="button" type="submit" name="lost" value="<- Verlust " title="Verlust"/></td></tr> -->
+ <?php
+ }
+ ?>
+ </table>
+ <?php
+ }
+ else
+ {
+ echo "<div align=\"center\">";
+ // print_r($ky); echo "$get,$out,$lost<br />";
+ $umls = array("Ä","Ö","Ü","ä","ö","ü","ß");
+ $umlr = array("Ae","Oe","Ue","ae","oe","ue","ss");
+ if ($get) $action = "get";
+ elseif ($out) $action = "out";
+ elseif ($lost) $action = "lost";
+ if (isset($ky) && $ky)
+ {
+ // $ky["bem"] = str_replace($umls,$umlr,str_replace("'","\"",substr($ky["bem"],0,100)));
+ $ky["bem"] = str_replace("'","\"",substr($ky["bem"],0,100));
+ if (is_numeric($ky["anz"]) && $ky["anz"] != 0)
+ {
+ $sql = "CALL keytyp_tract_dep('FHI','".$ky["dep"]."','".$ky["kt"]."',".$ky["anz"].",'$action','" .$ky["bem"]."',@suc)";
+ $result = $dbc ->queryObjectArray($sql);
+ if ($dbc -> querySingleItem("SELECT @suc"))
+ echo "<p class='green'><b>" . $aaction["$action"].": ".$ky["anz"]. " Schlüssel '". $ky['kt'] .
+ "' wurde(n) erfolgreich zwischen Depot 'FHI' und Depot '".$ky["dep"]. "' transferiert.</b></p>\n";
+ else
+ echo "<p class='red'><b>" . $aaction["$action"].": ".$ky["anz"]. " Schlüssel '". $ky['kt'] .
+ "' konnte(n) nicht zwischen Depot 'FHI' und Depot '".$ky["dep"]. "' transferiert werden.</b></p>\n";
+ }
+ else
+ echo "<p class='red'><b>" . $aaction["$action"].": '".$ky["anz"]. "' Schlüssel '". $ky['kt'] .
+ "' konnte(n) nicht zwischen Depot 'FHI' und Depot '".$ky["dep"]. "' transferiert werden.</b></p>\n";
+
+ $sql = "SELECT SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='FHI' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzfhi = $dbc->querySingleItem($sql);
+ $sql = "SELECT SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+
+ echo "<p>Aktueller Bestand Schlüsseltyp '". $ky["kt"] ."'<br /> Depot FHI: $anzfhi<br /> Depot ". $ky["dep"] . ": $anzdep</p><br /><br />\n";
+ }
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Transfer Depot\">Weiterer Depot-Transfer</a></p>\n";
+ }
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_tract_ma.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,268 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Keytyp Transaktion Depot - Depot
+ */
+
+ 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("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // zulaessige Depots
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT depot_ID FROM KeyDepot_userweb WHERE userid = '$uid'";
+ $res = $dbc -> queryObjectArray($sql);
+ foreach ($res as $row)
+ $adep[] = $row->depot_ID;
+// print_r($adep); echo "<br />";
+ $aaction = array("get" => "Rücknahme", "out" => "Ausgabe", "lost" => "Verlust"); //Bezeichnung Transfer
+
+?>
+
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Keytyp MA transferieren</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/key.png\" border=\"0\" alt=\"Keytyp transferieren\" title=\"Depotverwaltung Schlüsseltyp\"/></div>\n";
+
+ echo "<div align=\"center\">";
+ echo "<h3>Schlüsseltyp von/an Depot an/von Mitarbeiter verschieben</h3>";
+ echo "</div>\n";
+ if (!isset($adep))
+ echo "<p class='red'> Sie haben nicht das Recht, Transfers von Schlüsseln zu Mitarbeitern vorzunehmen. Bitte wenden Sie sich an Frau Kohl.</p>";
+ else
+ {
+
+ $out = $_POST["out"];
+ $get = $_POST["get"];
+ $lost = $_POST["lost"];
+ $ky = $_POST["ky"];
+
+//print_r($ky); echo "<br />";
+ if (isset($ky) && $get)
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN pers_action='get' THEN IFNULL(pers_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN pers_action='out' THEN IFNULL(pers_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN pers_action='lost' THEN IFNULL(pers_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_MA WHERE persknr='".$ky["ma"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzma = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzma < $ky["anz"]) $err = "Rücknahme: Bestand '". $ky["kt"] ."' Mitarbeiter '". $ky["ma"] . "': <b>$anzma < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky) && $lost)
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN pers_action='get' THEN IFNULL(pers_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN pers_action='out' THEN IFNULL(pers_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN pers_action='lost' THEN IFNULL(pers_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_MA WHERE persknr='".$ky["ma"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzma = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzma < $ky["anz"]) $err = "Verlust: Bestand '". $ky["kt"] ."' Mitarbeiter '". $ky["ma"] . "': <b>$anzma < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky) && $out)
+ {
+ $sql = "SELECT IFNULL(SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END),0) - IFNULL(SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END),0) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $anzdep < $ky["anz"]) $err = "Ausgabe: Bestand '". $ky["kt"] ."' Depot '".$ky["dep"]."': <b>$anzdep < ".$ky["anz"]."</b> (Transfer-Anzahl)!";
+ }
+ if (isset($ky["anz"]) && !is_numeric($ky["anz"]) && ($out || $get || $lost)) $err = "Anzahl ist ncht numerisch!";
+
+ if (!isset($ky) || (!$out && !$get && !$lost) || $err)
+ {
+ /* form: 'accept-charset="utf-8"' wegen Umlauten in Formfeldern und Nichtnutzen mysqli, sondern sp für INSERTS */
+?>
+ <div align="center">
+ <h5>* - Felder sind erforderlich!</h5>
+ </div>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_key" accept-charset="utf-8">
+ <div align="center">
+ <?php
+ if ($err) echo "<p class='red'>$err</p>\n";
+ ?>
+ <table width="55%" border="0" cellspacing="3" cellpadding="3">
+
+ <tr>
+ <td>Depot *</td><td>Schlüsseltyp *</td><td>Anzahl *</td><td>Mitarbeiter *</td>
+ </tr>
+ <tr>
+ <td><select name="ky[dep]" onchange="this.form.submit();">
+ <?php
+ $strdep = "'". implode("','",$adep) ."'";
+ $sql = "SELECT * FROM fhiiqm.KeyDepot WHERE depot_ID IN ($strdep)";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['dep'] && !$beg) $ky['dep'] = $row->depot_ID;
+ if ($row->depot_ID == $ky['dep']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->depot_ID\">$row->depot_ID: $row->depot_bez</option>\n";
+ $beg=1;
+ }
+ $beg=0;
+ ?>
+ </select>
+ </td>
+ <td><select name="ky[kt]" onchange="this.form.submit();">
+ <?php
+ $sql = "SELECT key_level,d.keytyp_ID,keytyp_bez,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot d INNER JOIN Keytyp k ON d.keytyp_ID=k.keytyp_ID
+ WHERE depot_ID = '" . $ky['dep'] . "'
+ GROUP BY key_level,d.keytyp_ID,keytyp_bez";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if (!$ky['kt'] && !$beg)
+ $ky['kt'] = $row->keytyp_ID;
+ if ($row->keytyp_ID == $ky['kt']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->keytyp_ID\">$row->key_level - $row->keytyp_ID [$row->keytyp_bez] ($row->bestand)</option>\n";
+ $beg=1;
+ }
+ $beg=0;
+ ?>
+ </select>
+ </td>
+ <td><input name="ky[anz]" type="text" size="5" maxlength="3" value="<?php echo $ky['anz']; ?>" /></td>
+ <td><select name="ky[ma]" onchange="this.form.submit();">
+ <?php
+ if ($ky['dep'] == 'FHI') $wher = " WHERE 1=1";
+ else $wher = "INNER JOIN KeyDepot_Abteilung k ON a.abt_ID=k.abt_ID WHERE depot_ID = '" . $ky['dep'] . "'";
+ $sql = "SELECT persknr,CONCAT(TRIM(nachname), ', ',vorname,' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname
+ FROM fhiiqm.Mitarbeiter m INNER JOIN Abteilung a ON m.abt_tel=a.abt_ID
+ $wher AND m.aktiv<2
+ ORDER BY nvname";
+// echo "$sql<br />";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ $apers[] = $row->persknr;
+ if (!in_array($ky['ma'],$apers)) $ky['ma'] = null;
+ foreach ($res as $row)
+ {
+ if (!$ky['ma'] && !$beg) $ky['ma'] = $row->persknr;
+ if ($row->persknr == $ky['ma']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->persknr\">$row->nvname</option>\n";
+ $beg=1;
+ }
+ $beg=0;
+ }
+ ?>
+ </select>
+ <?php
+ $sql = "SELECT IFNULL(IFNULL(SUM(CASE WHEN pers_action='get' THEN IFNULL(pers_anz,0) ELSE 0 END),0)
+ - IFNULL(SUM(CASE WHEN pers_action='out' THEN IFNULL(pers_anz,0) ELSE 0 END),0)
+ - IFNULL(SUM(CASE WHEN pers_action='lost' THEN IFNULL(pers_anz,0) ELSE 0 END),0),0) AS bestand
+ FROM Keytyp_MA WHERE persknr=".$ky['ma']." AND keytyp_ID='".$ky['kt']."'";
+// echo "sql anzahl keytyp_ID = $sql<br />";
+ $anzkey = $dbc -> querySingleItem($sql);
+ echo " ($anzkey)";
+ ?>
+ </td>
+ </tr>
+ <tr><td>Bemerkung</td><td colspan="2"><textarea name="ky[bem]" cols="50" rows="2"><?php echo $ky['bem']; ?></textarea></td>
+ <?php
+ // Schluessel / MA anzeigen
+ $sql = "SELECT key_level,m.keytyp_ID,
+ SUM(CASE WHEN pers_action='get' THEN IFNULL(pers_anz,0) ELSE 0 END) -
+ SUM(CASE WHEN pers_action='out' THEN IFNULL(pers_anz,0) ELSE 0 END) -
+ SUM(CASE WHEN pers_action='lost' THEN IFNULL(pers_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_MA m INNER JOIN Keytyp k ON m.keytyp_ID=k.keytyp_ID
+ WHERE persknr=".$ky['ma']."
+ GROUP BY key_level,m.keytyp_ID
+ ORDER BY key_level,m.keytyp_ID";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ echo "<td>";
+// echo "sql alle keytyp_ma = $sql<br />";
+ foreach ($res as $row)
+ {
+ if (!$beg) $br = ""; else $br = "<br />";
+ echo "$br$row->key_level - $row->keytyp_ID: $row->bestand";
+ $beg=1;
+ }
+ echo "</td>";
+ }
+ echo "</tr>";
+ if (in_array("ke",$_SESSION["recht"]))
+ {
+ ?>
+ <tr><td></td><td><input class="button" type="submit" name="out" value="-> Ausgabe " title="Ausgabe"/></td></tr>
+ <tr><td></td><td><input class="button" type="submit" name="get" value="<- Rücknahme" title="Rueckgabe"/></td></tr>
+ <tr><td></td><td><input class="button" type="submit" name="lost" value="<- Verlust " title="Verlust"/></td></tr>
+ <?php
+ }
+ ?>
+ </table>
+<?php
+ }
+ else
+ {
+ echo "<div align=\"center\">";
+// print_r($ky); echo "$get,$out,$lost<br />";
+ $umls = array("Ä","Ö","Ü","ä","ö","ü","ß");
+ $umlr = array("Ae","Oe","Ue","ae","oe","ue","ss");
+ if ($get) $action = "get";
+ elseif ($out) $action = "out";
+ elseif ($lost) $action = "lost";
+ if (isset($ky) && $ky)
+ {
+ // $ky["bem"] = str_replace($umls,$umlr,str_replace("'","\"",substr($ky["bem"],0,100)));
+ $ky["bem"] = str_replace("'","\"",substr($ky["bem"],0,100));
+ $sql = "SELECT CONCAT(nachname,', ',vorname) AS nvname FROM Mitarbeiter WHERE persknr=".$ky["ma"];
+ $nvname = $dbc->querySingleItem($sql);
+ if (is_numeric($ky["anz"]) && $ky["anz"] != 0)
+ {
+ $sql = "CALL keytyp_tract_ma('".$ky["dep"]."','".$ky["ma"]."','".$ky["kt"]."',".$ky["anz"].",'$action','" .$ky["bem"]."',@suc)";
+ $result = $dbc ->queryObjectArray($sql);
+// $suc = 1;
+// if ($suc)
+ if ($dbc -> querySingleItem("SELECT @suc"))
+ echo "<p class='green'><b>" . $aaction["$action"].": ".$ky["anz"]. " Schlüssel '". $ky['kt'] .
+ "' wurde(n) erfolgreich zwischen Depot '".$ky["dep"]. "' und '$nvname' transferiert.</b></p>\n";
+ else
+ echo "<p class='red'><b>" . $aaction["$action"].": ".$ky["anz"]. " Schlüssel '". $ky['kt'] .
+ "' konnte(n) nicht zwischen Depot '".$ky["dep"]. "' und '$nvname' transferiert werden.</b></p>\n";
+ }
+ else
+ echo "<p class='red'><b>" . $aaction["$action"].": '".$ky["anz"]. "' Schlüssel '". $ky['kt'] .
+ "' konnte(n) nicht zwischen Depot '".$ky["dep"]. "' und '$nvname' transferiert werden.</b></p>\n";
+
+ $sql = "SELECT SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot WHERE depot_ID='".$ky["dep"]."' AND keytyp_ID = '". $ky["kt"] ."'";
+ $anzdep = $dbc->querySingleItem($sql);
+
+ echo "<p>Aktueller Bestand Schlüsseltyp '". $ky["kt"] ."' im Depot ". $ky["dep"] . ": $anzdep</p><br /><br />\n";
+ }
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Transfer Depot-MA\">Weiterer Depot-MA Transfer</a></p>\n";
+ }
+ }
+?>
+
+</body>
+</html>
\ No newline at end of file
--- a/fhiiqm/raum_aptyp_ed.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_aptyp_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -105,7 +105,7 @@
{
if ($apid && !$sub && !isset($ap))
{
- $sql = "SELECT geb_ID, r.raum_ID,a.arbplatz_typ
+ $sql = "SELECT geb_ID, r.raum_ID,a.arbplatz_typ, raum_bem
FROM Raum_Arbplatz_Typ a RIGHT OUTER JOIN Raum r ON a.raum_ID = r.raum_ID
WHERE r.raum_ID = $apid
ORDER BY a.arbplatz_typ";
@@ -116,6 +116,7 @@
$ap["geb"] = $row->geb_ID;
$ap["raum"] = $row->raum_ID;
$ap["aptyp"][] = $row->arbplatz_typ;
+ $ap["bem"] = $row->raum_bem;
}
}
}
@@ -153,6 +154,15 @@
$stmt = $dbc -> stmtinit();
if (is_object($stmt))
{
+ $ap['bem'] = substr($ap['bem'],0,800);
+ if (!isset($ap['bem']) || $ap['bem']<'!') $ap['bem'] = null;
+ $stmt -> prepare("UPDATE fhiiqm.Raum SET
+ raum_bem = ?
+ WHERE raum_ID = $apid");
+
+ $stmt -> bind_param('s',$ap['bem']);
+ $retr = $stmt -> execute();
+
$retd = 1;
if ($apid && is_array($ap['aptyp']))
{ //UPDATE
@@ -177,13 +187,16 @@
}
}
- if ($rett)
+ if ($rett && $retr)
{
echo "<p class='green'><b>Arbeitsplatztypen für Raum-ID '$apid' wurden erfolgreich gespeichert.</b></p>\n";
include ("inc/raum_aptyp_dat_show.inc.php");
}
else
+ {
echo "<p class='red'><b>Arbeitsplatztypen für Raum-ID '$apid'' wurden nicht oder nur teilweise gespeichert</b></p>\n";
+ echo "retr = $retr, rett = $rett<br />";
+ }
echo "</div>";
echo "<p class='sc'> <a href=\"raum_aptyp_flist.php$getp\" target=\"_self\" title=\"Raum-Arbplatztyp-Liste\">« zur Raum-Arbplatztyp-Liste</a></p>\n";
--- a/fhiiqm/raum_ins.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_ins.php Mon Jul 01 14:36:18 2013 +0200
@@ -113,6 +113,8 @@
//INSERT Raum
$raum['rbez'] = substr($raum['rbez'],0,50);
$raum['rnum'] = substr($raum['rnum'],0,10);
+// $raum['bem'] = substr($raum['bem'],0,800);
+// if (!isset($raum['bem']) || $raum['bem']<'!') $raum['bem'] = null;
if ($raum['rtyp']== -1) $rtyp = "NULL"; else $rtyp = "'" . $raum['rtyp'] . "'";
if ($raum['reityp']== -1) $raum['reityp'] = null;
if ($raum['reikat']== -1) $raum['reikat'] = null;
--- a/fhiiqm/raum_report.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -60,11 +60,25 @@
</tr>
<tr>
<td class="bigger">
+ <a href="/fhiiqm/report/raum_info_as_report.php" title="Raum Info">Raum Informationen Arbeitssicherheit</a>
+ <br /> Auswahl: Haus, Raum, Raum-Typ
+ <br /> Ansicht: Datenblatt 'Dauerbetrieb' (Haus, Raum-Nr., Raum-Bezeichnung, Raum-Typ, Geräte-Anzahl, Gefährdungen, Verantwortliche, Raum-Nutzer)
+ </td>
+ </tr>
+ <tr>
+ <td class="bigger">
<a href="/fhiiqm/report/raum_dez_anl_report.php" title="Dauerversuch">Labor Dauerversuch</a>
<br /> Auswahl: Haus, Raum, Raum-Typ
<br /> Ansicht: Datenblatt 'Dauerbetrieb' (Haus, Raum-Nr., Raum-Bezeichnung, Raum-Typ, Geräte, Verantwortliche)
</td>
</tr>
+ <tr>
+ <td class="bigger">
+ <a href="/fhiiqm/report/raum_dversuch_report.php" title="Dauerversuch 2">Labor Dauerversuch Aushang</a>
+ <br /> Auswahl: Haus, Raum, Raum-Typ
+ <br /> Ansicht: Datenblatt 'Dauerbetrieb' (Haus, Raum-Nr., Raum-Bezeichnung, Raum-Typ, Geräte-Anzahl, Gefährdungen, Verantwortliche, Raum-Nutzer)
+ </td>
+ </tr>
</table>
</div>
--- a/fhiiqm/raum_upd.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_upd.php Mon Jul 01 14:36:18 2013 +0200
@@ -79,7 +79,7 @@
if (!$upd && !$del)
{
$sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID,raumtyp_ID,reinigung_typ_ID,raum_flaeche,raum_file,
- reinigung_kat,reinigung_turnus_ID,boden_typ_ID
+ reinigung_kat,reinigung_turnus_ID,boden_typ_ID,raum_bem
FROM fhiiqm.Raum WHERE raum_ID = $rid";
if ($result = $dbc ->queryObjectArray($sql))
{
@@ -87,14 +87,15 @@
{
$raum['rnum'] = $row->raum_nr;
$raum['rbez'] = $row->raum_name;
- $raum['geb'] = $row->geb_ID;
+ $raum['geb'] = $row->geb_ID;
$raum['rtyp'] = $row->raumtyp_ID;
- $raum['reityp'] = $row->reinigung_typ_ID;
+ $raum['reityp'] = $row->reinigung_typ_ID;
$raum['rflae'] = str_replace(".",",",$row->raum_flaeche);
$raum['rfname'] = $row->raum_file;
$raum['reikat'] = $row->reinigung_kat;
$raum['reitur'] = $row->reinigung_turnus_ID;
- $raum['boden'] = $row->boden_typ_ID;
+ $raum['boden'] = $row->boden_typ_ID;
+// $raum['bem'] = $row->raum_bem;
}
}
}
@@ -150,6 +151,8 @@
//UPDATE Raum
$raum['rbez'] = substr($raum['rbez'],0,50);
$raum['rnum'] = substr($raum['rnum'],0,10);
+// $raum['bem'] = substr($raum['bem'],0,800);
+// if (!isset($raum['bem']) || $raum['bem']<'!') $raum['bem'] = null;
if ($raum['rtyp']== -1) $raum['rtyp'] = null;
if ($raum['reityp']== -1) $raum['reityp'] = null;
if ($raum['reikat']== -1) $raum['reikat'] = null;
--- a/fhiiqm/raum_vma_ed.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_vma_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -112,6 +112,8 @@
foreach ($res as $row)
$raum["ma"][] = $row->persknr;
}
+ $sql = "SELECT raum_bem FROM fhiiqm.Raum WHERE raum_ID = $rid";
+ $raum["bem"] = $dbc -> querySingleItem($sql);
}
$sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID,raumtyp_ID,raum_flaeche,raum_file
FROM fhiiqm.Raum WHERE raum_ID = $rid";
@@ -125,8 +127,15 @@
$raum['rtyp'] = $row->raumtyp_ID;
$raum['rflae'] = str_replace(".",",",$row->raum_flaeche);
$raum['rfname'] = $row->raum_file;
- }
+ }
+ $sql = "SELECT arbplatz_typ FROM Raum_Arbplatz_Typ WHERE raum_ID = $rid";
+ if ($res = $dbc ->queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ $raum["aptyp"][] = $row->arbplatz_typ;
+ }
}
+
?>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_info" target="_self">
<div align="center">
@@ -151,6 +160,14 @@
<td bgcolor="#D6E6E6"><?php echo $raum['rtyp']; ?>
</td>
</tr>
+ <?php
+ echo "<tr><td>Arbeitsplatztyp(en)</td>";
+ echo "<td bgcolor='#D6E6E6'>";
+ foreach ($raum['aptyp'] as $apt)
+ $lapt .= $apt.", ";
+ $lapt = substr($lapt,0,strlen($lapt)-2);
+ echo "$lapt</td></tr>\n";
+ ?>
<tr>
<td>Raum-Fläche (m<sup>2</sup>)</td>
<td bgcolor="#D6E6E6"><?php echo $raum['rflae']; ?>
@@ -226,6 +243,11 @@
</div>
</td>
</tr>
+ <tr>
+ <td>Bemerkung</td>
+ <td bgcolor="#D6E6E6"><textarea name="raum[bem]" cols="80" rows="10"><?php echo $raum['bem']; ?></textarea>
+ <div>max. 800 Zeichen sind möglich</div></td>
+ </tr>
<?php
if ($sub)
@@ -263,6 +285,14 @@
$stmt = $dbc -> stmtinit();
if (is_object($stmt))
{
+ $raum['bem'] = substr($raum['bem'],0,800);
+ if (!isset($raum['bem']) || $raum['bem']<'!') $raum['bem'] = null;
+ $stmt -> prepare("UPDATE fhiiqm.Raum SET
+ raum_bem = ?
+ WHERE raum_ID = $rid");
+
+ $stmt -> bind_param('s',$raum['bem']);
+ $retr = $stmt -> execute();
$retd = 1;
if ($rid && is_array($raum['ma']))
{ //UPDATE
@@ -288,14 +318,14 @@
}
}
// echo "UPDATE-sql = $sql<br />\n";
- if ($retv)
+ if ($retv && $retr)
{//Eingabe Daten erfolgreich
echo "<p class='green'><b>Raumverantwortliche zu ID '$rid' wurden erfolgreich gespeichert.</b></p>\n";
echo "<br />\n";
// Anzeigen gespeicherter Verantwortlichen
echo "<table>";
- $sql = "SELECT r.raum_ID,geb_ID, raum_nr, raum_name,
+ $sql = "SELECT r.raum_ID,geb_ID, raum_nr, raum_name, raum_bem,
CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as ma
FROM Raum r LEFT OUTER JOIN Raum_MA rm ON r.raum_ID=rm.raum_ID
LEFT OUTER JOIN fhiiqm.Mitarbeiter m ON rm.persknr=m.persknr
@@ -310,6 +340,7 @@
{
echo "<tr><td>Haus: </td><td>$row->geb_ID</td></tr>\n";
echo "<tr><td>Raum: </td><td>$row->raum_nr, $row->raum_name</td></tr>\n";
+ echo "<tr><td>Bemerkung: </td><td>$row->raum_bem</td></tr>\n";
echo "<tr><td>Verantwortliche(r): </td><td>$row->ma";
$first=1;
}
--- a/fhiiqm/raum_vma_flist.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_vma_flist.php Mon Jul 01 14:36:18 2013 +0200
@@ -95,7 +95,7 @@
$bg = "#FFFFFF";
echo "<div align='center'>\n";
- echo "<p><b>Liste Räume und Raum-Verantwortliche (Labore und Technik)</b></p>\n";
+ echo "<p><b>Liste Räume und Raum-Verantwortliche (Chemielager, Labor, Technik, Werkstatt)</b></p>\n";
echo "<table border='0' cellspacing='0'>\n";
echo "<tr><td class='bigger'>Mittels '<img src='/fhiiqm/img/auf.gif' border='0' width='11' hight='11' />' / '<img src='/fhiiqm/img/ab.gif' border='0' width='11' hight='11' />'
--- a/fhiiqm/recht_list.php Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/recht_list.php Mon Jul 01 14:36:18 2013 +0200
@@ -86,10 +86,14 @@
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 'ddr' THEN 1 END) AS dez_dat_read,
+ COUNT(CASE recht_ID WHEN 'dde' THEN 1 END) AS dez_dat_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 'kr' THEN 1 END) AS key_read,
+ COUNT(CASE recht_ID WHEN 'ke' THEN 1 END) AS key_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 'mtr' THEN 1 END) AS ma_tel_read,
@@ -100,8 +104,6 @@
COUNT(CASE recht_ID WHEN 'pze' THEN 1 END) AS proz_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 'ddr' THEN 1 END) AS dez_dat_read,
- COUNT(CASE recht_ID WHEN 'dde' THEN 1 END) AS dez_dat_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,
@@ -135,6 +137,7 @@
<th colspan='2'>Vertrag</th>
<th colspan='2'>Vertr.Partner</th>
<th colspan='2'>dez. Daten</th>
+ <th colspan='2'>Schlüs.-Vw</th>
<th colspan='2'>Recht</th></tr>\n";
echo "<tr bgcolor='#68ACBF'>";
echo "<th>userid</th><th>read</th><th>edit</th>
@@ -150,6 +153,7 @@
<th>read</th><th>edit</th>
<th>read</th><th>edit</th>
<th>read</th><th>edit</th>
+ <th>read</th><th>edit</th>
</tr>\n";
foreach ($result as $row)
{
@@ -179,6 +183,8 @@
echo "<td class='center green'><b>" . str_replace("0"," ",str_replace("1","x",$row->vertr_part_edit)) ."</b></td>";
echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->dez_dat_read)) ."</b></td>";
echo "<td class='center green'><b>" . str_replace("0"," ",str_replace("1","x",$row->dez_dat_edit)) ."</b></td>";
+ echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->key_read)) ."</b></td>";
+ echo "<td class='center green'><b>" . str_replace("0"," ",str_replace("1","x",$row->key_edit)) ."</b></td>";
echo "<td class='center'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_read)) ."</b></td>";
echo "<td class='center green'><b>" . str_replace("0"," ",str_replace("1","x",$row->recht_edit)) ."</b></td>";
echo "</tr>\n";
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/report/gefgr_gefahr_pic_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,305 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Report Gefahrgruppe - Gefaehrdung - Pictogramm
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("asr",$_SESSION["recht"]) && !in_array("ase",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+ }
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Report Gefährdungsgruppe-Gefährdung-Piktogramm</title>
+</head>
+
+<body>
+
+<?php
+ echo " ";
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ 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=\"/fhiiqm/img/role.png\" border=\"0\" alt=\"Arbeitssicherheit\" title=\"Arbeitssicherheit\"/></div>\n";
+
+ $rag = $_POST["rag"]; // Parameter aus Form
+ $search = $_POST["search"];
+ if (!$search) $search = $_GET["s"];
+
+ $zeil = $rag["z"];
+ if (!$zeil) $zeil = $_GET["z"];
+ if (!$zeil) $zeil = 9999; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ if (!$start) $start=0;
+
+ if (!is_array($rag))
+ {
+ $rag["gef"] = $_GET["g"];
+ $rag["gru"] = $_GET["u"];
+ $rag["bind"] = $_GET["b"];
+ $rag["sort1"] = $_GET["s1"];
+ $rag["sort2"] = $_GET["s2"];
+ $rag["sort3"] = $_GET["s3"];
+ }
+ $_GET["g"] = $rag["gef"];
+ $_GET["u"] = $rag["gru"];
+ $_GET["b"] = $rag["bind"];
+ $_GET["s1"] = $rag["sort1"];
+ $_GET["s2"] = $rag["sort2"];
+ $_GET["s3"] = $rag["sort3"];
+ $_GET["z"] = $zeil;
+
+ if ($search && $_GET['s'] != 2)
+ {
+ echo "<span class='sc'>";
+ echo "<br /> <a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Gefgruppe-Gef.-Pic\" class=\"sc\">neuer Bericht Gefährdungsgruppe - Gefährdung - Piktogramm</a>\n";
+ echo "</span>";
+ }
+ echo "<div align='center'>\n";
+ echo "<p><b>(5b) Bericht Gefährdungsgruppe - Gefährdung - Piktogramm</b></p>\n";
+ echo "</div>\n";
+
+
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <p>Bitte Kriterien für die Suche wählen</p>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_as_report.php" target="_self">
+ <table width="50%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Gefährdungs-Gruppe</td>
+ <td><select name="rag[gru]" onchange="this.form.submit();">
+ <?php
+ if ($rag["atyp"] == -1) $select = " selected='selected' "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT gefahrgr_ID,gefahrgr_bez FROM fhiiqm.Gefahr_Gruppe ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $select = ($row->gefahrgr_ID == $rag['gru'])? " selected='selected'" : "";
+ echo "<option$select value=\"$row->gefahrgr_ID\">$row->gefahrgr_ID - $row->gefahrgr_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Gefährdung</td>
+ <td><select name="rag[gef]">
+ <?php
+ if ($rag["gru"] && $rag["gru"]>0) $wher = " WHERE gefahrgr_ID = " . $rag["gru"]; else $wher = "";
+ if ($rag["gef"] == -1) $select = " selected='selected' "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr $wher
+ ORDER BY CONVERT(substring(gefahr_ID,1,INSTR(gefahr_ID,'.')-1),DECIMAL),CONVERT(SUBSTRING(gefahr_ID,INSTR(gefahr_ID,'.')+1),DECIMAL);";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $select = ($row->gefahr_ID == $rag['gef'])? " selected='selected'" : "";
+ echo "<option$select value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Verknüpfung</td>
+ <td>UND
+ <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>>
+ ODER
+ <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
+ </tr>
+ <tr>
+ <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+ <?php
+ $sort = array("-1"=>"","1"=>"Gefährdungsgruppe","2"=>"Gefährdung");
+ for ($i=1; $i<3; $i++)
+ {
+ echo "$i. <select name='rag[sort$i]'>\n";
+ foreach ($sort as $key=>$val)
+ {
+ $rsort = "sort" . $i;
+ if ($rag[$rsort] == $val) $select= " selected"; else $select = "";
+ echo "<option$select value='$key'>$val</option>\n";
+ }
+ echo "</select> \n";
+ }
+ echo "</td></tr>\n";
+
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
+ if (!$rag['z']) $rag['z'] = 9999;
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $rag['z']) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td></tr>\n";
+
+ ?>
+ <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
+ </tr>
+ </table>
+ </div>
+ </form>
+
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+ $sql = "SELECT gg.gefahrgr_ID,g.gefahr_ID,gefahrgr_bez,gefahr_bez,gefahr_pic,gefahr_pic_bez
+ FROM Gefahr_Gruppe gg LEFT OUTER JOIN Gefahr g ON gg.gefahrgr_ID=g.gefahrgr_ID ";
+
+ $lim = " LIMIT $start,$zeil";
+
+ if (!$rag["bind"]) $bind = " AND "; else $bind = $rag["bind"];
+
+ if ($rag["gru"]> -1)
+ {
+ if ($where) $where .= "$bind g.gefahrgr_ID = '$rag[gru]' "; else $where = " g.gefahrgr_ID = '$rag[gru]' ";
+ $krit = " [Gefährdungsgruppe = '" . $dbc -> querySingleItem("SELECT gefahrgr_bez FROM Gefahr_Gruppe WHERE gefahrgr_ID='".$rag['gru'] ."'")."']";
+ }
+ if ($rag["gef"]> -1)
+ {
+ $where = " g.gefahr_ID = '$rag[gef]' ";
+ if ($krit) $bd = " ".$bind; else $bd = "";
+ $krit .= "$bd [Gefährdung = '" . $dbc -> querySingleItem("SELECT gefahr_bez FROM Gefahr WHERE gefahr_ID='".$rag['gef'] ."'")."']";
+ }
+ if ($where) $where = " WHERE ($where)";
+
+ if ($rag["sort1"]>0 || $rag["sort2"]>0 || $rag["sort3"]>0)
+ {
+ if ($rag["sort1"]>0) $ord = " ORDER BY " . $rag["sort1"];
+ if ($rag["sort2"]>0) $ord .= ",".$rag["sort2"];
+ if ($rag["sort3"]>0) $ord .= ",".$rag["sort3"];
+ }
+ $sql .= $where;
+ if ($ord && strpos($ord,'2')>0) $ord = str_replace("2","CONVERT(substring(g.gefahr_ID,1,INSTR(g.gefahr_ID,'.')-1),DECIMAL),CONVERT(SUBSTRING(g.gefahr_ID,INSTR(g.gefahr_ID,'.')+1),DECIMAL)",$ord);
+ $sql .= $ord . $lim;
+// echo "sql = $sql<br />\n";
+ $result = $dbc ->queryObjectArray($sql);
+
+ if ($krit )echo "Suchergebnis für $krit"; else echo "Suchergebnis\n";
+ $ianz = $dbc -> querySingleItem("SELECT COUNT(*)
+ FROM Gefahr_Gruppe gg LEFT OUTER JOIN Gefahr g
+ ON gg.gefahrgr_ID=g.gefahrgr_ID $where");
+ printf ("<p>Anzahl: %s</p>", $ianz);
+
+ if ($result)
+ {
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ echo "<table border='1' width='50%' cellspacing='0' cellpadding='2'>\n";
+ // Listenkopf
+ echo "<tr bgcolor='#68ACBF'>";
+ echo "<th>Gefährdungsgruppe</th>";
+ echo "<th>Gefährdung</th>";
+ echo "<th>pic</th>";
+ echo "<th>pic_bez</th>";
+ echo "</tr>\n";
+
+ foreach ($result as $row)
+ {
+ $gid = $row->gefahr_ID;
+ if ($gru != $row->gefahrgr_ID)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='" . $bg . "'>";
+ echo "<td>$row->gefahrgr_ID - $row->gefahrgr_bez</td>";
+ echo "<td nowrap='1'>$row->gefahr_ID - $row->gefahr_bez</td>";
+ $gid = urlencode(trim($gid));
+ echo "<td><img name='gefahr' width='30px' src=" . "'/fhiiqm/inc/show_img_gef.inc.php?gid=$gid' alt='$gef' title='$gef'></td>";
+ echo "<td>$row->gefahr_pic_bez</td></tr>\n";
+ }
+ elseif ($gru == $row->gefahrgr_ID && $gfid != $row->gefahr_ID)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='" . $bg . "'>";
+ echo "<td> </td>";
+ echo "<td nowrap='1'>$row->gefahr_ID - $row->gefahr_bez</td>";
+ $gid = urlencode(trim($gid));
+ echo "<td><img name='gefahr' width='30px' src=" . "'/fhiiqm/inc/show_img_gef.inc.php?gid=$gid' alt='$gef' title='$gef'></td>";
+ echo "<td>$row->gefahr_pic_bez</td></tr>\n";
+ }
+ $gfid = $row->gefahr_ID;
+ $gru = $row->gefahrgr_ID;
+ }
+ echo "</table>\n";
+ echo "<p></p><table width=60%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
+ <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
+ echo "</div>\n";
+
+ echo "<br /> ";
+ if ($search != 2) // Aufruf aus fhiiqm
+ {
+ // Parameter aus $_GET fuer weitere Seiten
+ $_GET["s"] = 1; // bewirkt weitere Suche
+ foreach ($_GET as $key=>$val)
+ {
+ if ($key != "st") $liste .= "&" . $key ."=".$val;
+ }
+ // Links auf andere Seiten generieren
+ liste_links($start,$zeil,$ianz,$liste);
+ }
+ }
+ else
+ {
+ echo "<p class='red'> Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
+ echo "</div>\n";
+ }
+ if ($search != 2)
+ {
+ echo "<span class='sc'>";
+ echo "<br /><br /> <a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Gefgruppe-Gef.-Pic\" class=\"sc\">neuer Bericht Gefährdungsgruppe - Gefährdung - Piktogramm</a>\n";
+ echo "</span>";
+ }
+ else
+ echo "<a href='javascript:history.back();' onMouseOver=\"{window.status='Zurück'; return true;}\">« Zurück</a>";
+
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/report/keytyp_dep_anz_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,277 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2013
+ *
+ * Report Uebersicht Keytyp in Depots
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // zulaessige Depots
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT depot_ID FROM KeyDepot_userweb WHERE userid = '$uid'";
+ $res = $dbc -> queryObjectArray($sql);
+ foreach ($res as $row)
+ $adep[] = $row->depot_ID;
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Report Übersicht Schlüsseltypen</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=\"/fhiiqm/img/key.png\" border=\"0\" alt=\"Keytyp Ü:bersicht\" title=\"Schlüsseltypen im Depot\"/></div>\n";
+
+ $ky = $_POST["ky"]; // Parameter aus Form
+ $search = $_POST["search"];
+ if (!$search) $search = $_GET["s"];
+
+ $zeil = $ky["z"];
+ if (!$zeil) $zeil = $_GET["z"];
+ if (!$zeil) $zeil = 9999; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ if (!$start) $start=0;
+
+ if (!is_array($ky))
+ {
+ $ky["dep"] = $_GET["d"];
+ $ky["kt"] = $_GET["k"];
+ $ky["bind"] = $_GET["b"];
+ $ky["sort1"] = $_GET["s1"];
+ $ky["sort2"] = $_GET["s2"];
+ }
+ $_GET["d"] = $ky["dep"];
+ $_GET["k"] = $ky["kt"];
+ $_GET["b"] = $ky["bind"];
+ $_GET["s1"]= $ky["sort1"];
+ $_GET["s2"]= $ky["sort2"];
+ $_GET["z"] = $zeil;
+
+ echo "<span class='sc'>";
+ echo "<br /> <a href=\"/fhiiqm/keytyp_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Übersicht Keytyp\" class=\"sc\">neuer Bericht Übersicht Schlüsseltypen</a>\n";
+ echo "</span>";
+
+ echo "<div align='center'>\n";
+ echo "<p><b>Bericht Übersicht Schlüsseltypen </b></p>\n";
+ echo "</div>\n";
+
+
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <p>Bitte Kriterien für die Suche wählen</p>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self">
+ <table width="50%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Depot</td>
+ <td><select name="ky[dep]" onchange="this.form.submit();">
+ <?php
+ if ($ky["dep"] == -1) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $strdep = "'". implode("','",$adep) ."'";
+ $sql = "SELECT * FROM fhiiqm.KeyDepot WHERE depot_ID IN ($strdep)";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if ($row->depot_ID == $ky['dep']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->depot_ID\">$row->depot_ID: $row->depot_bez</option>\n";
+ }
+ $beg=0;
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Schlüsseltyp</td>
+ <td><select name="ky[kt]">
+ <?php
+ if ($ky["kt"] == -1) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $strdep = "'". implode("','",$adep) ."'";
+ $sql = "SELECT key_level,d.keytyp_ID,keytyp_bez,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot d INNER JOIN Keytyp k ON d.keytyp_ID=k.keytyp_ID
+ WHERE depot_ID = '" . $ky['dep'] . "'
+ GROUP BY key_level,d.keytyp_ID,keytyp_bez";
+ if ($res = $dbc -> queryObjectArray($sql))
+ foreach ($res as $row)
+ {
+ if ($row->keytyp_ID == $ky['kt']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value=\"$row->keytyp_ID\">$row->key_level - $row->keytyp_ID [$row->keytyp_bez] ($row->bestand)</option>\n";
+ }
+ $beg=0;
+ ?>
+ </select>
+ </tr>
+ <tr>
+ <td>Verknüpfung</td>
+ <td>UND
+ <input type="radio" name="ky[bind]" value="AND" <?php if (isset($ky["bind"]) && $ky["bind"]=="AND") echo "checked='checked'"; else echo "checked='checked'";?>>
+ ODER
+ <input type="radio" name="ky[bind]" value="OR" <?php if (isset($ky["bind"]) && $ky["bind"]=="OR") echo "checked='checked'"; ?>></td>
+ </tr>
+ <tr>
+ <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+ <?php
+ $sort = array("-1"=>"","1"=>"Depot","2"=>"Schlüsseltyp");
+ for ($i=1; $i<3; $i++)
+ {
+ echo "$i. <select name='ky[sort$i]'>\n";
+ foreach ($sort as $key=>$val)
+ {
+ $rsort = "sort" . $i;
+ if ($ky[$rsort] == $val) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select> \n";
+ }
+ echo "</td></tr>\n";
+
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<tr><td>Zeilen/Seite?</td><td><select name='ky[z]'>\n";
+ if (!$ky['z']) $ky['z'] = 9999;
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $ky['z']) $select = "selected='selected'"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td></tr>\n";
+
+ ?>
+ <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
+ </tr>
+ </table>
+ </div>
+ </form>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+ $sql = "SELECT depot_ID,key_level,d.keytyp_ID,keytyp_bez,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) AS anzget,
+ SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) AS anzout,
+ SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS anzlost,
+ SUM(CASE WHEN depot_action='get' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='out' THEN IFNULL(depot_anz,0) ELSE 0 END) - SUM(CASE WHEN depot_action='lost' THEN IFNULL(depot_anz,0) ELSE 0 END) AS bestand
+ FROM fhiiqm.Keytyp_Depot d INNER JOIN Keytyp k ON d.keytyp_ID=k.keytyp_ID
+ GROUP BY depot_ID,keytyp_ID";
+
+ $lim = " LIMIT $start,$zeil";
+
+ if (!$ky["bind"]) $bind = " AND "; else $bind = $ky["bind"];
+
+ if ($ky["dep"]> -1) $where = " depot_ID = '$ky[dep]' ";
+ if ($ky["kt"]> -1)
+ if ($where) $where .= "$bind keytyp_ID = '$ky[kt]' "; else $where = " keytyp_ID = '$ky[kt]'' ";
+ if ($where) $where = " HAVING ($where)";
+
+ if ($ky["sort1"]>0 || $ky["sort2"]>0)
+ {
+ if ($ky["sort1"]>0) $ord = " ORDER BY " . $ky["sort1"];
+ if ($ky["sort2"]>0) $ord .= ",".$ky["sort2"];
+ }
+
+ $sql .= $where;
+ $ianz = $dbc -> numrows($sql);
+ $sql .= $ord . $lim;
+ $result = $dbc ->queryObjectArray($sql);
+ if ($dbc -> error)
+ {
+ echo "error SELECT: " . $dbc -> error . "<br /><br />";
+ echo "sql = $sql<br />\n";
+ }
+ if ($ky["dep"]> -1) $krit = " [Depot = '" . $ky["dep"] ."']";
+ if ($ky["kt"] > -1)
+ {
+ if ($krit) $bd = " ".$bind; else $bd = "";
+ $krit .= $bd." [Schlüsseltyp = '".$ky["kt"]."']";
+ }
+ if ($krit )echo "Suchergebnis für $krit"; else echo "Suchergebnis\n";
+ printf ("<p>Anzahl Schlüsseltypen: %s</p>", $ianz);
+
+ if ($result)
+ {
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ echo "<table border='1' cellspacing='0' cellpadding='2'>\n";
+ // Listenkopf
+ echo "<tr bgcolor='#68ACBF'>";
+ echo "<th>Depot</th><th>Schlüsseltyp</th><th>Schlüsseltyp-Bezeichnung</th><th>Zugang</th><th>Abgang</th><th>Verlust</th><th>Bestand</th>";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='" . $bg . "'>";
+ echo "<td>$row->depot_ID</td><td>$row->key_level - $row->keytyp_ID</td><td>$row->keytyp_bez</td>";
+ echo "<td class='right'>$row->anzget</td><td class='right'>$row->anzout</td><td class='right'>$row->anzlost</td><td class='right'>$row->bestand</td>";
+ echo "</tr>";
+ }
+ echo "</table>\n";
+ echo "<p></p><table width=40%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
+ <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
+ echo "</div>\n";
+
+ echo "<br /> ";
+ if ($search != 2) // Aufruf aus fhiiqm
+ {
+ // Parameter aus $_GET fuer weitere Seiten
+ $_GET["s"] = 1; // bewirkt weitere Suche
+ foreach ($_GET as $key=>$val)
+ {
+ if ($key != "st") $liste .= "&" . $key ."=".$val;
+ }
+ // Links auf andere Seiten generieren
+ liste_links($start,$zeil,$ianz,$liste);
+ }
+ }
+ else
+ {
+ echo "<p class='red'> Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
+ echo "</div>\n";
+ echo "<br /> ";
+ }
+ echo "<span class='sc'>";
+ echo "<br /><br /> <a href=\"/fhiiqm/keytyp_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Übersicht Keytyp\" class=\"sc\">neuer Bericht Übersicht Schlüsseltypen</a>\n";
+ echo "</span>";
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/report/raum_dversuch_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,339 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 04/2013
+ *
+ * Report Labor Dauerbetrieb 2(portrait)
+ * $_GET['s']=2 - Aufruf aus adm-fhi-Seite ohne Anmeldung
+ *
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("ddr",$_SESSION["recht"]) && !in_array("dde",$_SESSION["recht"]) &&
+ !in_array("rr",$_SESSION["recht"]) && !in_array("re",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+ }
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Report Labor Dauerversuch</title>
+</head>
+
+<body>
+<?php
+ echo " ";
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ echo "<div class=\"float-br smaller sc\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r sc\"><img src=\"/fhiiqm/img/house.png\" border=\"0\" alt=\"Raum\" title=\"Raum\"/></div>\n";
+ }
+
+ $rag = $_POST["rag"]; // Parameter aus Form
+ $search = $_POST["search"];
+ if (!$search) $search = $_GET["s"];
+
+ $zeil = $rag["z"];
+ if (!$zeil) $zeil = $_GET["z"];
+ if (!$zeil) $zeil = 9999; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ if (!$start) $start=0;
+
+
+ if (!is_array($rag))
+ {
+ $rag["geb"] = $_GET["g"];
+ $rag["rnum"] = $_GET["r"];
+ $rag["rtyp"] = $_GET["t"];
+ $rag["bind"] = $_GET["b"];
+ $rag["sort1"] = $_GET["s1"];
+ }
+/*
+ $_GET["g"] = $rag["geb"];
+ $_GET["r"] = $rag["rnum"];
+ $_GET["t"] = $rag["rtyp"];
+ $_GET["b"] = $rag["bind"];
+ $_GET["s1"] = $rag["sort1"];
+ $_GET["z"] = $zeil;
+*/
+ if ($search && $_GET['s'] != 2)
+ {
+ echo "<span class='sc'>";
+ echo "<br /> <a href=\"/fhiiqm/raum_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Report Dauerversuch\" class='sc'>neuer Bericht Labor Dauerversuch</a>\n";
+ echo "</span>";
+ }
+ echo "<div align='center'>\n";
+ echo "<p class='sc'><b>Labor Dauerversuch (2)</b></p>\n";
+ echo "</div>\n";
+
+
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <p>Bitte Kriterien für die Suche wählen</p>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self">
+ <table width="50%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Haus</td>
+ <td>
+ <select name="rag[geb]" size="1" onchange="this.form.submit();">
+ <?php
+ if ($rag["geb"] == "") $select = " selected "; else $select = "";
+ echo "<option $select value=\"\"></option>\n";
+ $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->geb_ID == $rag['geb'])
+ echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+ else
+ echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Nummer</td>
+ <td><select name="rag[rnum]">
+ <?php
+ if ($rag["rnum"] == "0") $select = " selected "; else $select = "";
+ echo "<option $select value=\"0\"></option>\n";
+ if (isset($rag["geb"]) && $rag["geb"] > "") $where = " WHERE geb_ID = '".$rag["geb"]."'"; else $where = "";
+ echo "Gebaeude: ".$rag["geb"]."<br />\n";
+ $sql = "SELECT geb_ID, raum_ID,raum_nr,raum_name FROM fhiiqm.Raum $where ORDER BY 1,3";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raum_ID == $rag['rnum'])
+ echo "<option selected value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+ else
+ echo "<option value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Raumtyp</td>
+ <td><select name="rag[rtyp]">
+ <?php
+ if ($rag["rtyp"] == "") $select = " selected "; else $select = "";
+ echo "<option $select value=\"\"></option>\n";
+ $sql = "SELECT raumtyp_ID,raumtyp_bez FROM fhiiqm.Raum_Typ WHERE raumtyp_ID IN ('LA', 'T') ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raumtyp_ID == $rag['rtyp'])
+ echo "<option selected value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
+ else
+ echo "<option value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr>
+ <td>Verknüpfung</td>
+ <td>UND
+ <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>>
+ ODER
+ <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
+ </tr>
+ <tr>
+ <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+ <?php
+ $sort = array(""=>"","1"=>"Gebäude, Raum-Nr.","2"=>"Raum-Nr., Gebäude","5"=>"Raum-Typ, Gebäude, Raum-Nr.");
+ for ($i=1; $i<2; $i++)
+ {
+ echo "<select name='rag[sort$i]'>\n";
+ foreach ($sort as $key=>$val)
+ {
+ $rsort = "sort" . $i;
+ if ($rag[$rsort] == $val) $select= " selected"; else $select = "";
+ echo "<option$select value='$key'>$val</option>\n";
+ }
+ echo "</select> \n";
+ }
+ echo "</td></tr>\n";
+/*
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
+ if (!$rag['z']) $rag['z'] = 9999;
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $rag['z']) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td></tr>\n";
+*/
+ ?>
+ <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
+ </tr>
+ </table>
+ </div>
+ </form>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($rag["geb"]>"!") $krit = " [Gebäude = '" . $rag["geb"] ."']";
+ if ($krit) $bd = " ".$rag["bind"]; else $bd = "";
+ if ($rag["rnum"])
+ {
+ $rnr = $dbc -> querySingleItem("SELECT raum_nr FROM Raum WHERE raum_ID = ". $rag["rnum"]);
+ $krit .= $bd. " [Raum-Nr. = '$rnr']";
+ }
+ $bd = ($krit)? (" ".$rag["bind"]) : " ";
+ if ($rag["rtyp"]) $krit .= $bd . " [Raumtyp = '".$rag["rtyp"]."']";
+
+ $sql = "CALL raum_vma_tel_las_aptyp_report('".$rag["sort1"]."','".$rag["bind"]."','".$rag["geb"]."','".$rag["rnum"]."','".$rag["rtyp"]."',$start,$zeil,@anz)";
+
+ $result = $dbc -> queryObjectArray($sql);
+ if ($result)
+ {
+// print_r ($result);
+ echo "<p class='sc'>$krit</p>";
+ $begin = 0;
+ foreach ($result as $row)
+ {
+ if ($begin) echo "<p style=\"page-break-before:always\"> </p>";
+ echo "<h3>Dauerbetrieb</h3>\n";
+ echo "<table width='90%' border='1' frame='box' rules='rows' cellspacing='2' cellpadding='10'>\n";
+ echo "<tr><td width='45%'><b>Gebäude: $row->geb_ID</b></td><td width='55%'><b>Raum-Nr.: $row->raum_nr</b>
+ $row->raum_name [$row->raumtyp_bez]</td></tr>\n";
+ echo "<tr><td colspan='2'><b>Besondere Gefahren:</b></td></tr>\n";
+ echo "<tr><td><b>Bemerkungen:</b></td><td>$row->raum_bem</td></tr>\n";
+ if ($row->las_anz || $row->al_anz)
+ {
+ echo "<tr><td><b>Geräte:</b></td><td>";
+ if ($row->las_anz)
+ echo "Laser: ".$row->las_anz. "<br />";
+ if ($row->al_anz)
+ echo "Anlagen: ".$row->al_anz. "<br />";
+ echo "</td></tr>\n";
+ }
+ else
+ echo "<tr><td colspan='2'><b>Geräte:</b></td></tr>\n";
+ echo "<tr><td><b>Gefährdungen:</b></td><td>";
+ if (isset($row->gef) && $row->gef)
+ {
+ $agef = explode(";",$row->gef);
+ $apbez = array();
+ foreach ($agef as $gef)
+ {
+ $sql = "SELECT gefahr_pic_bez FROM Gefahr WHERE gefahr_ID='" . $gef ."'";
+ $pbez = $dbc -> querySingleItem($sql);
+ if (!in_array($pbez,$apbez))
+ {
+ $apbez[] = $pbez;
+ $gid = urlencode(trim($gef));
+ echo "<img name='gefahr' width='60px' src=" . "'/fhiiqm/inc/show_img_gef.inc.php?gid=$gid' alt='$gef' title='$gef'> ";
+ }
+ }
+ }
+ else echo " ";
+ echo "</td></tr>\n";
+ echo "<tr><td colspan='2'><b>Bei Störungen zu benachrichtigen:</b></td></tr>\n";
+ if ($row->vmatel>"!")
+ {
+ $vpnr = 0;
+ $mat = explode(";",$row->vmatel); //persknr:MA|tel
+ $first = true;
+ foreach ($mat as $ma)
+ {
+ $pnr = substr($ma,0,strpos($ma,":"));
+ $tel = substr($ma,strpos($ma,"|")+1);
+ $nam = substr($ma,strpos($ma,":")+1,strlen($ma)-strlen($pnr)-strlen($tel)-2);
+ $sp = " ";
+ if ($pnr != $vpnr)
+ {
+ if (!$first) echo "</td></tr>\n";
+ echo "<tr><td>$sp$nam</td><td>Telefon: $tel";
+ }
+ else echo ", $tel";
+ $first = false;
+ $vpnr = $pnr;
+ }
+ echo "</td></tr>\n";
+ }
+ else echo "<tr><td colspan='2'> </td></tr>\n";
+ echo "<tr><td colspan='2'><b>Mitarbeiter:</b>";
+ if ($row->rma>"!")
+ {
+ $mat = explode(";",$row->rma); //persknr:MA
+ $firs = true;
+ foreach ($mat as $ma)
+ {
+ $pnr = substr($ma,0,strpos($ma,":"));
+ $nam = substr($ma,strpos($ma,":")+1,strlen($ma)-strlen($pnr)-1);
+ if ($firs) $br = "";
+ else $br = "<br /> ";
+ echo "$br $nam";
+ $firs = false;
+ }
+ echo "</td></tr>\n";
+ }
+ else echo "</td></tr>\n";
+ echo "</table>\n";
+ echo "<p>Innerbetrieblicher Notdienst: Telefonzentrale: <b>9</b>, nachts/Wochenende: <b>4444</b></p>\n";
+ $begin = 1;
+ }
+
+ echo "<p></p><table width=99%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
+ <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
+
+ }
+ else echo "<p class='red'> Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
+
+ echo "</div>\n";
+ if ($search != 2)
+ {
+ echo "<span class=\"sc\">";
+ echo "<br /> <a href=\"/fhiiqm/raum_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Report Dauerversuch\">neuer Bericht Labor Dauerversuch</a></span>\n";
+ }
+ else
+ echo "<a class='sc' href='javascript:history.back();' onMouseOver=\"{window.status='Zurück'; return true;}\">« Zurück</a>";
+ }
+
+?>
+
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/report/raum_info_as_report.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,349 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * Report Labor Info(portrait)
+ * $_GET['s']=2 - Aufruf aus adm-fhi-Seite ohne Anmeldung
+ *
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("ddr",$_SESSION["recht"]) && !in_array("dde",$_SESSION["recht"]) &&
+ !in_array("rr",$_SESSION["recht"]) && !in_array("re",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+ }
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Report Labor Info</title>
+</head>
+
+<body>
+<?php
+ echo " ";
+ if (!isset($_GET['s']) || $_GET['s'] != 2 )
+ {
+ echo "<div class=\"float-br smaller sc\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r sc\"><img src=\"/fhiiqm/img/house.png\" border=\"0\" alt=\"Raum\" title=\"Raum\"/></div>\n";
+ }
+
+ $rag = $_POST["rag"]; // Parameter aus Form
+ $search = $_POST["search"];
+ if (!$search) $search = $_GET["s"];
+
+ $zeil = $rag["z"];
+ if (!$zeil) $zeil = $_GET["z"];
+ if (!$zeil) $zeil = 9999; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ if (!$start) $start=0;
+
+
+ if (!is_array($rag))
+ {
+ $rag["geb"] = $_GET["g"];
+ $rag["rnum"] = $_GET["r"];
+ $rag["rtyp"] = $_GET["t"];
+ $rag["bind"] = $_GET["b"];
+ $rag["sort1"] = $_GET["s1"];
+ }
+/*
+ $_GET["g"] = $rag["geb"];
+ $_GET["r"] = $rag["rnum"];
+ $_GET["t"] = $rag["rtyp"];
+ $_GET["b"] = $rag["bind"];
+ $_GET["s1"] = $rag["sort1"];
+ $_GET["z"] = $zeil;
+*/
+ if ($search && $_GET['s'] != 2)
+ {
+ echo "<span class='sc'>";
+ echo "<br /> <a href=\"/fhiiqm/raum_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Report Labor Info\" class='sc'>neuer Bericht Raum Information AS</a>\n";
+ echo "</span>";
+ }
+ echo "<div align='center'>\n";
+ echo "<p class='sc'><b>Report Raum Informationen Arbeitssicherheit</b></p>\n";
+ echo "</div>\n";
+
+
+ if (!$search)
+ {
+?>
+ <div align="center">
+ <p>Bitte Kriterien für die Suche wählen</p>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self">
+ <table width="50%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Haus</td>
+ <td>
+ <select name="rag[geb]" size="1" onchange="this.form.submit();">
+ <?php
+ if ($rag["geb"] == "") $select = " selected "; else $select = "";
+ echo "<option $select value=\"\"></option>\n";
+ $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->geb_ID == $rag['geb'])
+ echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+ else
+ echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Nummer</td>
+ <td><select name="rag[rnum]">
+ <?php
+ if ($rag["rnum"] == "0") $select = " selected "; else $select = "";
+ echo "<option $select value=\"0\"></option>\n";
+ if (isset($rag["geb"]) && $rag["geb"] > "") $where = " WHERE geb_ID = '".$rag["geb"]."'"; else $where = "";
+ echo "Gebaeude: ".$rag["geb"]."<br />\n";
+ $sql = "SELECT geb_ID, raum_ID,raum_nr,raum_name FROM fhiiqm.Raum $where ORDER BY 1,3";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raum_ID == $rag['rnum'])
+ echo "<option selected value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+ else
+ echo "<option value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Raumtyp</td>
+ <td><select name="rag[rtyp]">
+ <?php
+ if ($rag["rtyp"] == "") $select = " selected "; else $select = "";
+ echo "<option $select value=\"\"></option>\n";
+ $sql = "SELECT raumtyp_ID,raumtyp_bez FROM fhiiqm.Raum_Typ WHERE raumtyp_ID IN ('LA', 'LC', 'T', 'WE') ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raumtyp_ID == $rag['rtyp'])
+ echo "<option selected value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
+ else
+ echo "<option value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr>
+ <td>Verknüpfung</td>
+ <td>UND
+ <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>>
+ ODER
+ <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
+ </tr>
+ <tr>
+ <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+ <?php
+ $sort = array(""=>"","1"=>"Gebäude, Raum-Nr.","2"=>"Raum-Nr., Gebäude","5"=>"Raum-Typ, Gebäude, Raum-Nr.");
+ for ($i=1; $i<2; $i++)
+ {
+ echo "<select name='rag[sort$i]'>\n";
+ foreach ($sort as $key=>$val)
+ {
+ $rsort = "sort" . $i;
+ if ($rag[$rsort] == $val) $select= " selected"; else $select = "";
+ echo "<option$select value='$key'>$val</option>\n";
+ }
+ echo "</select> \n";
+ }
+ echo "</td></tr>\n";
+/*
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
+ if (!$rag['z']) $rag['z'] = 9999;
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $rag['z']) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td></tr>\n";
+*/
+ ?>
+ <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
+ </tr>
+ </table>
+ </div>
+ </form>
+<?php
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($rag["geb"]>"!") $krit = " [Gebäude = '" . $rag["geb"] ."']";
+ if ($krit) $bd = " ".$rag["bind"]; else $bd = "";
+ if ($rag["rnum"])
+ {
+ $rnr = $dbc -> querySingleItem("SELECT raum_nr FROM Raum WHERE raum_ID = ". $rag["rnum"]);
+ $krit .= $bd. " [Raum-Nr. = '$rnr']";
+ }
+ $bd = ($krit)? (" ".$rag["bind"]) : " ";
+ if ($rag["rtyp"]) $krit .= $bd . " [Raumtyp = '".$rag["rtyp"]."']";
+
+ $sql = "CALL raum_vma_tel_las_gefgr_report('".$rag["sort1"]."','".$rag["bind"]."','".$rag["geb"]."','".$rag["rnum"]."','".$rag["rtyp"]."',$start,$zeil,@anz)";
+
+ $result = $dbc -> queryObjectArray($sql);
+ if ($result)
+ {
+// print_r ($result);
+ echo "<p class='sc'>$krit</p>";
+ $begin = 0;
+ foreach ($result as $row)
+ {
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ if ($begin) echo "<p style=\"page-break-before:always\"> </p>";
+ echo "<h3>Raum Information</h3>\n";
+ echo "<table width='90%' border='1' frame='box' rules='rows' cellspacing='2' cellpadding='8'>\n";
+ echo "<tr><td width='45%'><b>Gebäude: $row->geb_ID</b></td><td width='55%'><b>Raum-Nr.: $row->raum_nr</b>
+ $row->raum_name</td></tr>\n";
+ echo "<tr><td><b>Arbeitsgruppe(n):</b></td><td>".str_replace(";","<br />",$row->ag)."</td></tr>\n";
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ if ($row->las_anz || $row->al_anz)
+ {
+ echo "<tr bgcolor='$bg'><td><b>Gefährdungen Geräte:</b></td><td>";
+ if ($row->las_anz)
+ echo "Laser (Klassen 3A, 3B, 4): ".$row->las_anz. "<br />";
+ if ($row->al_anz)
+ echo "Anlagen: ".$row->al_anz. "<br />";
+ echo "</td></tr>\n";
+ }
+ else
+ echo "<tr bgcolor='$bg'><td colspan='2'><b>Gefährdungen Geräte:</b></td></tr>\n";
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td colspan='2'><b>Allgemeine Gefährdungen:</b></td></tr>";
+ if (isset($row->gef) && $row->gef)
+ {
+ $first = true;
+ $vgbez = "";
+ $agef = explode(";",$row->gef);
+ foreach ($agef as $gef)
+ {
+ list($gf,$gbez) = explode("|",$gef);
+ if ($gbez != $vgbez)
+ {
+ if (!$first) echo "</td></tr>";
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td> $gbez</td><td>";
+ $first = true;
+ $apbez = array();
+ }
+ $sql = "SELECT gefahr_pic_bez FROM Gefahr WHERE gefahr_ID='" . $gf ."'";
+ $pbez = $dbc -> querySingleItem($sql);
+ if (!in_array($pbez,$apbez))
+ {
+ $apbez[] = $pbez;
+ $gid = urlencode(trim($gf));
+ echo "<img name='gefahr' width='30px' src=" . "'/fhiiqm/inc/show_img_gef.inc.php?gid=$gid' alt='$gf' title='$gf'> ";
+ }
+ $vgbez = $gbez;
+ $first = false;
+ }
+ }
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td colspan='2'><b>Bei Störungen zu benachrichtigen:</b></td></tr>\n";
+ if ($row->vmatel>"!")
+ {
+ $vpnr = 0;
+ $mat = explode(";",$row->vmatel); //persknr:MA|tel
+ $first = true;
+ foreach ($mat as $ma)
+ {
+ $pnr = substr($ma,0,strpos($ma,":"));
+ $tel = substr($ma,strpos($ma,"|")+1);
+ $nam = substr($ma,strpos($ma,":")+1,strlen($ma)-strlen($pnr)-strlen($tel)-2);
+ $sp = " ";
+ if ($pnr != $vpnr)
+ {
+ if (!$first) echo "</td></tr>\n";
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td>$sp$nam</td><td>Telefon: $tel";
+ }
+ else echo ", $tel";
+ $first = false;
+ $vpnr = $pnr;
+ }
+ echo "</td></tr>\n";
+ }
+ else
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td colspan='2'> </td></tr>\n";
+ }
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td><b>Bemerkungen:</b></td><td>$row->raum_bem</td></tr>\n";
+ if ($row->raum_feuerl)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td><b>Feuerlöscher im Raum:</b></td><td>$row->raum_feuerl</td></tr>\n";
+ }
+ echo "</table>\n";
+ echo "<p>Innerbetrieblicher Notdienst: Telefonzentrale: <b>9</b>, nachts/Wochenende: <b>4444</b></p>\n";
+ $begin = 1;
+ }
+
+ echo "<p></p><table width=99%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
+ <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
+
+ }
+ else echo "<p class='red'> Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
+
+ echo "</div>\n";
+ if ($search != 2)
+ {
+ echo "<span class=\"sc\">";
+ echo "<br /> <a href=\"/fhiiqm/raum_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
+ echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Report Labor Info\" class='sc'>neuer Bericht Raum Information AS</a></span>\n";
+ }
+ else
+ echo "<a class='sc' href='javascript:history.back();' onMouseOver=\"{window.status='Zurück'; return true;}\">« Zurück</a>";
+ }
+
+?>
+
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/test/blob_show.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,32 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 4/2013
+ */
+
+
+
+?>
+<!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 href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Report Labor Dauerversuch</title>
+</head>
+
+<body>
+<p>Gefährdungssymbole</p>
+<?php
+ for ($i = 0; $i<10; $i++)
+ {
+ $gid = urlencode('3.1');
+ echo " <img name='gefahr' width='60px' height='60' src=" . "'/fhiiqm/inc/show_img_gef.inc.php?gid=$gid' alt='3.1'>";
+ }
+
+?>
+</body>
+</html>
\ No newline at end of file
