--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/ma_ed_form.inc.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,188 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Form Mitarbeiter/Objekte FHI
+ */
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $okn = true;
+ if (!$ma) $ma['geb'] = 'A';
+
+?>
+<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_ma">
+<div align="center">
+<table width="60%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Name *</td>
+ <td><input name="ma[name]" type="text" size="30" maxlength="30" value="<?php echo $ma['name']; ?>" />
+ <?php
+ if (isset($ma['name']) && $ma['name']<'!')
+ {
+ echo "<br><span class=\"red\">Name ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Vorname</td>
+ <td><input name="ma[vname]" type="text" size="30" maxlength="30" value="<?php echo $ma['vname']; ?>" />
+ <?php
+ /* if (isset($ma['vname']) && $ma['vname']<'!')
+ {
+ echo "<br><span class=\"red\">Vorname ist erforderlich!</span>\n";
+ $okn = false;
+ } */
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Titel</td>
+ <td><input name="ma[titel]" type="text" size="30" maxlength="30" value="<?php echo $ma['titel']; ?>" /></td>
+ </tr>
+ <tr><td>Ort</td>
+ <td valign="top">Haus
+ <select name="ma[geb]" onchange="this.form.submit();">
+ <?php
+ if ($ma['geb'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->geb_ID == $ma['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>
+ Raum
+ <select name="ma[raum]">
+ <?php
+ if ($ma['raum'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT raum_ID, raum_nr, raum_name FROM `fhiiqm`.`Raum` WHERE geb_ID='" . $ma['geb'] ."' ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raum_ID == $ma['raum'])
+ echo "<option selected value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
+ else
+ echo "<option value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Telefon</td>
+ <td><div id="addtel">
+ <select name="ma[tel][]" size="1">
+ <?php
+ $select = null;
+ $select = ( "-1"==$ma['tel'][0] ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT telefon_nr,geb_ID,raum_nr, telefon_typ FROM fhiiqm.Telefon t
+ LEFT OUTER JOIN Raum r ON t.raum_ID=r.Raum_ID
+ ORDER BY telefon_nr
+";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr;
+ if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";
+ $select = ( $row->telefon_nr==$ma['tel'][0] ) ? ' selected' : null;
+ echo "<option $select value=\"$row->telefon_nr\">$teln $telr</option>\n";
+ $tel .= "'".$row->telefon_nr. "':'" . $teln ." ". $telr. "',";
+ }
+ }
+ $tel = substr($tel,0,strlen($tel)-1);
+ ?>
+ </select>
+ <script type="text/javascript">
+ <!--
+ arr = {<?php echo ($tel); ?>}; // Ergebnis: {key:'value',key:'value',...}
+ //-->
+ </script>
+ oder neu <input name="ma[ntel][]" type="text" size="20" maxlength="20" value="<?php echo $ma['ntel'][0]; ?>" />
+ öffentlich <input name="ma[pub][]" type="checkbox" value="1" <?php if ($ma['pub'][0]) echo "checked"; ?> />
+ <a href="<?php echo "javascript:addInput('addtel');" ?>" title="weitere Telefon-Nr."><img src="/fhiiqm/img/add.png" /></a>
+ <a href="<?php echo "javascript:delInput('addtel');" ?>" title="löschen letzte Telefon-Nr."><img src="/fhiiqm/img/delete.png" /></a><br />
+ <?php
+ if (isset($ma) && (!$ok || $sub))
+ {
+ if (count($ma['ntel'])>1 || count($ma['tel'])>1)
+ {
+ $i=0;
+ foreach ($ma['tel'] as $atel)
+ {
+ if ($i>0)
+ {
+ echo "<select name=\"ma[tel][]\" size=\"1\">";
+
+ $select = ( "-1" == $atel ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+ foreach ($result as $row)
+ {
+ if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr;
+ if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";
+ $select = ( $row->telefon_nr == $atel ) ? ' selected' : null;
+ echo "<option $select value=\"$row->telefon_nr\">$teln $telr</option>\n";
+ }
+ echo "</select>";
+ echo " oder neu <input name=\"ma[ntel][]\" type=\"text\" size=\"20\" maxlength=\"20\" value=\"".$ma['ntel'][$i]."\" />";
+ echo " öffentlich <input name=\"ma[pub][$i]\" type=\"checkbox\" value=\"1\"";
+ $check = ($ma['pub'][$i]) ? " checked" : "" ;
+ echo "$check /><br />";
+ }
+ $i++;
+ }
+ }
+ }
+ ?>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>E-Mail</td>
+ <td><input name="ma[email]" type="text" size="30" maxlength="100" value="<?php echo $ma['email']; ?>" /></td>
+ </tr>
+ <tr><td>Abteilung *</td>
+ <td valign="top">
+ <select name="ma[abt]">
+ <?php
+ $sql = "SELECT abt_ID, abt_name, abt_long FROM `fhiiqm`.`Abteilung` ORDER BY abt_ID+0";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->abt_ID == $ma['abt'])
+ echo "<option selected value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
+ else
+ echo "<option value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
+ }
+ }
+ ?>
+ </select>
+ Mitarbeiter FHI? <input name="ma[fhi]" type="checkbox" value="1" <?php if ($ma['fhi']) echo "checked"; ?> />
+ <input type="hidden" name="okn" value="<?php echo $okn; ?>" />
+ </td>
+ </tr>
+<!--
+</table>
+ </div>
+</form>
+-->
\ No newline at end of file
Binary file fhiiqm/img/group.png has changed
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/ma_tel_dat_show.inc.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,59 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Anlisten INSERT/UPDATE Daten Mitarbeiter - Telefon
+ */
+
+ echo "<table>\n";
+ echo "<tr><td>Name: </td><td>" . $ma["name"] . "</td></tr>\n";
+ echo "<tr><td>Vorname: </td><td>" . $ma["vname"] . "</td></tr>\n";
+ echo "<tr><td>Titel: </td><td>" . $ma["titel"] . "</td></tr>\n";
+ echo "<tr><td>E-Mail: </td><td>" . $ma["email"] . "</td></tr>\n";
+ if ($ma['abt'])
+ {
+ $sql = "SELECT abt_name FROM Abteilung WHERE abt_ID = ".$ma['abt'];
+ $abt = $dbc -> querySingleItem($sql);
+ echo "<tr><td>Abteilung: </td><td>$abt</td></tr>\n";
+ }
+ else
+ echo "<tr><td>Abteilung: </td><td>&nbst;</td></tr>\n";
+ $i=0;
+ foreach ($ma['tel'] as $tel)
+ {
+ if ($tel > "!" && $tel != "-1")
+ {
+ $pub = ($ma["pub"][$i] == 'NULL')? " " : "[öffentlich]";
+ echo "<tr><td>Telefon: </td><td>$tel $pub</td></tr>\n";
+ }
+ $i++;
+ }
+ $i=0;
+ foreach ($ma['ntel'] as $tel)
+ {
+ if ($tel > "!")
+ {
+ $pub = ($ma["pub"][$i] == 'NULL')? " " : "[öffentlich]";
+ echo "<tr><td>Telefon: </td><td>$tel $pub</td></tr>\n";
+ }
+ $i++;
+ }
+ if ($ma["raum"] > "-1")
+ {
+ $sql = "SELECT raum_nr, geb_ID FROM Raum WHERE raum_ID=" . $ma["raum"];
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ echo "<tr><td>Ort: </td><td>" . $row->geb_ID . " " . $row->raum_nr ."</td></tr>\n";
+ }
+
+ }
+ else
+ echo "<tr><td>Ort: </td><td> </td></tr>\n";
+
+ $fhi = ($ma["fhi"])? "ja" : " ";
+ echo "<tr><td>Mitarbeiter FHI: </td><td>$fhi</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/tel_dat_show.inc.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,28 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Anlisten INSERT/UPDATE Daten Mitarbeiter - Telefon
+ */
+
+ echo "<table>\n";
+ echo "<tr><td>Nummer: </td><td>" . $tf["tel"] . "</td></tr>\n";
+ $tt = ($tf["typ"] == "fax")? strtoupper($tf["typ"]) : $tf["typ"];
+ echo "<tr><td>Typ: </td><td>$tt</td></tr>\n";
+ if ($tf["raum"] > "-1")
+ {
+ $sql = "SELECT raum_nr, geb_ID FROM Raum WHERE raum_ID=" . $tf["raum"];
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ echo "<tr><td>Ort: </td><td>" . $row->geb_ID . " " . $row->raum_nr ."</td></tr>\n";
+ }
+ }
+ else
+ echo "<tr><td>Ort: </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/vertrag_prod_list_ac.inc.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,60 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 10/2012
+ *
+ * Autocomplete Vertragssuche Produkt
+ */
+
+ header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ // Recht Produktgruppe beruecksichtigen
+ session_start();
+ if (is_array($_SESSION["prodg"]))
+ {
+ foreach ($_SESSION["prodg"] as $val)
+ $listg .= "," .$val;
+ $listg = substr($listg,1);
+ }
+ else $listg = "";
+
+ $q = strtolower(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben, term UTF-8 codiert
+
+ $su = array("ä","ö","ü","ß","Ä","Ö","Ü");
+ $er = array("ä","ö","ü","ß","Ä","Ö","Ü");
+// $er = array("ae","oe","ue","ss","Ae;","Oe","Ue");
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+ $sql = "SELECT v.contract_ID,contract_name,prod_name,part_firma,t.vtyp_kurz,contract_begin
+ FROM fhiiqm.Vertrag v LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID
+ LEFT OUTER JOIN Vertrag_Partner vp ON v.contract_ID=vp.contract_ID
+ LEFT OUTER JOIN Partner p ON vp.part_ID=p.part_ID
+ LEFT OUTER JOIN Produkt_Vertrag prv ON v.contract_ID=prv.contract_ID
+ LEFT OUTER JOIN Produkt pr ON prv.produkt_ID=pr.produkt_ID";
+ if ($listg > "")
+ $sql .= " WHERE prod_group_ID IN ($listg) ";
+ else
+ $sql .= " WHERE 1=1 ";
+
+ $sql .= " AND prod_name LIKE '%".$q."%' COLLATE latin1_general_ci
+ ORDER BY contract_name";
+
+ $result = $dbc ->queryObjectArray($sql);
+ if ($result)
+ {
+ foreach ($result as $row)
+ {
+ $cb = new DateTime($row->contract_begin);
+// $clist[] = "\"" . $row->contract_ID . " - " . str_replace($su,$er,$row->contract_name) . " | " .
+// str_replace($su,$er,$row->vtyp_bezeichnung) . " | VBeginn: " . $cb->format('d.m.Y') . "\"";
+ $clist[] = "\"" . $row->contract_ID . " - " . $row->contract_name . " | " . strtoupper($row->prod_name) . " | " . $row->part_firma. " | " .
+ $row->vtyp_kurz . " | VBeginn: " . $cb->format('d.m.Y') . "\"";
+ }
+ echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet
+ }
+ $dbc -> close();
+?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/ma_tel_ed.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,321 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 12/2012
+ *
+ * INSERT/UPDATE/(DELETE) 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("fmr",$_SESSION["recht"]) && !in_array("fme",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $sub = $_POST["eintragen"];
+ $del = $_POST["del"];
+ $ma = $_POST["ma"];
+ $okn = $_POST["okn"];
+ $ok = $_POST["ok"];
+ if (!$okn) $ok=0;
+ $pid = $_GET["i"]; // persknr
+
+ $sort = $_GET["s"]; // Sortierung nach Spalte
+ $dir = $_GET["d"]; // Sortierrichtung
+ $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
+ $filter = $_GET["b"]; // Filterbegriff
+ $getp = "&s=$sort&d=$dir&f=$fnum&b=$filter"; // Parameter Listenanzeige
+
+// print_r ($ma); echo "<br />sub = $sub<br /><br />";
+
+?>
+<!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>Mitarbeiter bearbeiten</title>
+
+ <script type="text/javascript">
+ <!--
+ var counter = 0;
+ var limit = 99;
+ var arr = new Array();
+ function addInput(divName){
+ if (counter == limit) {
+ alert("Das Limit von " + counter + " zusätzlichen inputs ist erreicht");
+ }
+ else {
+ var newdiv = document.createElement('div');
+ var opt="<option value='-1'></option>";
+ for (var key in arr)
+ {
+ opt = opt.concat("<option value='",key,"'>",arr[key],"</option>\n" );
+ }
+ opt += "</select>";
+ newdiv.innerHTML = "<select name='ma[tel][]'>"+opt;
+ newdiv.innerHTML += " oder neu <input type='text' name='ma[ntel][]' size='20' maxlength='20' />";
+ newdiv.innerHTML += " öffentlich <input type='checkbox' name='ma[pub][" + (counter+1) + "]' value='1' />";
+ document.getElementById(divName).appendChild(newdiv);
+ counter++;
+ }
+ }
+ function delInput(divId){
+ var kn = document.getElementById(divId);
+ while (kn.childNodes.length>0 && kn.lastChild.nodeName != "SELECT" && kn.lastChild.nodeName != "A")
+ {
+// alert ("vor "+kn.lastChild.nodeName+", nodetyp = "+ kn.lastChild.nodeType);
+ var knc = kn.lastChild;
+ document.getElementById(divId).removeChild(knc);
+ }
+ if (kn.lastChild.nodeName == "SELECT") document.getElementById(divId).removeChild(kn.lastChild);
+ }
+ //-->
+ </script>
+
+</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/group.png\" border=\"0\" alt=\"Mitarbeiter bearbeiten\" title=\"Mitarbeiter bearbeiten\"/></div>\n";
+
+ if ($pid) $text = "editieren"; else $text = "erfassen";
+ echo "<div align=\"center\">";
+ echo "<h3>Mitarbeiter $text</h3>";
+ echo "</div>\n";
+ if ((!$sub && !$del) || !isset($ma) || !$ok)
+ {
+
+ if ($pid && (!$sub || !$del) && !isset($ma))
+ {
+ $sql = "SELECT nachname,vorname,titel,abt_tel,email,aktiv FROM Mitarbeiter WHERE persknr=$pid";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $ma['name'] = $row->nachname;
+ $ma['vname'] = $row->vorname;
+ $ma['titel'] = $row->titel;
+ $ma['abt'] = $row->abt_tel;
+ $ma['email'] = $row->email;
+ $ma['fhi'] = ($row->aktiv == 1)? 1 : 0;
+ }
+ }
+ // Haus,Raum
+ $sql = "SELECT ma.raum_ID, geb_ID FROM Mitarbeiter_Raum ma INNER JOIN Raum r ON ma.raum_ID=r.raum_ID
+ WHERE persknr=$pid ORDER BY raum_ID";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $ma['geb'] = $row->geb_ID;
+ $ma['raum'] = $row->raum_ID;
+ }
+ }
+ // Telefon
+ $sql = "SELECT m.telefon_nr,public
+ FROM fhiiqm.MA_Telefon m INNER JOIN Telefon t ON m.telefon_nr=t.telefon_nr
+ WHERE persknr = $pid";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $ma['tel'][] = $row->telefon_nr;
+ $ma['pub'][] = ($row->public)? 1 : 0;
+ }
+ }
+ }
+ include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/ma_ed_form.inc.php");
+
+ if ($sub || $del)
+ {
+ if ($sub)
+ $frage = "Alle Angaben ok?";
+ elseif ($del)
+ $frage = "Mitarbeiter 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("fme",$_SESSION["recht"]))
+ {
+ echo "
+ <tr><td> </td>\n
+ <td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />";
+ if ($pid)
+ {
+ 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=\"ma_tel_flist.php?e=1$getp\" target=\"_self\" title=\"Telefon-Liste\">« zur Telefon-Liste</a></p>\n";
+ echo "</form>\n";
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($del)
+ { // nur aktiv auf 0 setzen
+ $sql = "UPDATE Mitarbeiter SET aktiv=0 WHERE persknr = $pid";
+ $retdi = $dbc -> execute($sql);
+ $sql = "DELETE FROM Mitarbeiter_Raum WHERE persknr = $pid";
+ $retdi = $dbc -> execute($sql);
+ $sql = "DELETE FROM MA_Telefon WHERE persknr = $pid";
+ $retdi = $dbc -> execute($sql);
+ if ($retdi)
+ {
+ echo "<p class='green'><b>DELETE: Daten zu '".$ma["name"]. ", ". $ma['vname'] ."' wurden erfolgreich gelöscht.</b></p>\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>DELETE: Daten zu '".$ma["name"]. ", ". $ma['vname'] ."' konnten nicht gelöscht werden!</b></p>\n";
+ echo "sql = $sql<br />";
+ echo "error DELETE: " . $dbc->error . "<br />";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/ma_tel_dat_show.inc.php");
+ }
+ else //INSERT oder UPDATE
+ {
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ if ($ma['fhi']) $aktiv = 1; else $aktiv = 2;
+ if ($pid) //UPDATE
+ {
+ $stmt -> prepare("UPDATE Mitarbeiter SET
+ nachname = ?,
+ vorname = ?,
+ titel = ?,
+ email = ?,
+ abt_tel = ?,
+ aktiv = ?
+ WHERE persknr = $pid");
+ $stmt -> bind_param('ssssii',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'], $aktiv);
+// echo "UPDATE: ". var_dump($stmt);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error UPDATE Mitarbeiter: " . $stmt->error . "<br><br>\n";
+ }
+ else
+ {
+ $sql = "SELECT MAX(persknr) FROM Mitarbeiter WHERE persknr < 9500";
+ $pid = $dbc -> querySingleItem($sql) + 1;
+ $stmt -> prepare ("INSERT INTO Mitarbeiter (persknr, nachname, vorname, titel,email,abt_tel,aktiv) VALUES (?,?,?,?,?,?,?)");
+ $stmt -> bind_param('issssii',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'], $aktiv);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error INSERT Mitarbeiter: " . $stmt->error . "<br><br>\n";
+ }
+ if ($result)
+ {
+ $ret = 1;
+ // raum
+ if ($ma["raum"] > "-1")
+ {
+ $sql = "DELETE FROM Mitarbeiter_Raum WHERE persknr=$pid";
+ $redr = $dbc -> execute($sql);
+ if ($redr)
+ {
+ $sql = "INSERT INTO Mitarbeiter_Raum (persknr, raum_ID) VALUES ($pid, " . $ma["raum"] . ")";
+ $ret = $dbc -> execute($sql);
+ }
+ }
+ if (is_array($ma['ntel']))
+ {
+ foreach ($ma['ntel'] as $tel)
+ {
+ if ($tel > "!")
+ {
+ $sql = "SELECT COUNT(*) FROM Telefon WHERE telefon_nr ='$tel'";
+ $anz = $dbc -> querySingleItem($sql);
+ if ( $anz == 0)
+ {
+ $sql = "INSERT INTO Telefon (telefon_nr) VALUES('$tel')";
+ $rest = $dbc -> execute($sql);
+ if ($rest) $ret = 1; else $ret = 0;
+ }
+ }
+ }
+ }
+ if ($ret)
+ {
+ $sql = "DELETE FROM MA_Telefon WHERE persknr = $pid";
+ $redmt = $dbc -> execute($sql);
+ if ($redmt)
+ {
+ $i=0;
+ foreach ($ma['tel'] as $tel)
+ {
+ if ($tel >"!" && $tel != "-1")
+ {
+ if (!isset($ma['pub'][$i])) $ma['pub'][$i] = 'NULL';
+ $sql = "INSERT INTO MA_Telefon (persknr, telefon_nr, public) VALUES ($pid,'$tel'," . $ma['pub'][$i] . ")";
+ $rest = $dbc -> execute($sql);
+ if ($rest) $ret = 1; else $ret = 0;
+ }
+ $i++;
+ }
+ $i=0;
+ foreach ($ma['ntel'] as $tel)
+ {
+ if ($tel >"!")
+ {
+ if (!isset($ma['pub'][$i])) $ma['pub'][$i] = 'NULL';
+ $sql = "INSERT INTO MA_Telefon (persknr, telefon_nr, public) VALUES ($pid,'$tel'," . $ma['pub'][$i] . ")";
+ $rest = $dbc -> execute($sql);
+ if ($rest) $ret = 1; else $ret = 0;
+ }
+ $i++;
+ }
+ }
+ }
+ }
+ }
+ if ($result && $redmt && $ret) // INSERT/UPDATE Info
+ {
+ //Eingabe Daten erfolgreich
+ echo "<p class='green'><b>Mitarbeiterdaten zu " . $ma['name']. ", ". $ma['vname'] . " wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<br /><br />\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>Mitarbeiterdaten zu " . $ma['name']. ", ". $ma['vname'] . " wurden nicht oder nur teilweise gespeichert.</b></p>\n";
+ echo "error: ". $dbc -> error;
+ echo "<br /><br />\n";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/ma_tel_dat_show.inc.php");
+ }
+ echo "</div>";
+ echo "<p class='sc'> <a href=\"ma_tel_flist.php?e=1$getp\" target=\"_self\" title=\"Telefonliste\">Mitarbeiterliste</a></p>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Mitarbeiter erfassen\">Neuen Mitarbeiter erfassen</a></p>\n";
+ }
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/ma_tel_flist.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,227 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Telefonliste ohne Anmeldung
+ *
+ * $_GET["e"] = 1, ='editieren', muss gesetzt sein
+ *
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ if (isset($_GET["i"]) && $_GET["i"]) $edit = $_GET["i"]; // wegen tab_column, "i" als "e" missbraucht -> editieren ermoeglichen
+ if (!$edit) $edit = $_GET["e"];
+ if (!$edit) $edit = $_POST["e"];
+ if (isset($edit))
+ {
+ 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("fmr",$_SESSION["recht"]) && !in_array("fme",$_SESSION["recht"])
+ && !in_array("ddr",$_SESSION["recht"]) && !in_array("dde",$_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="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+
+ <title>MA-Telefonliste</title>
+</head>
+
+<body onload="document.ffilter.filter.focus();">
+
+<?php
+ if (isset($edit))
+ {
+ 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/group.png\" border=\"0\" alt=\"Telefonliste\" title=\"Telefonliste\"/></div>\n";
+ }
+
+ // Felder, nach denen gefiltert werden kann
+ $fields = array(2=>"Name",3=>"Vorname",5=>"Abteilung",6=>"Telefon/Fax",9=>"Haus", 10=>"Raum");
+// $fieldf = array(2=>"trim(nachname)",3=>"vorname",5=>"abt_name",6=>"mt.telefon_nr",9=>"geb_ID", 10=>"raum_nr");
+ $fieldf = array(2=>"name",3=>"vorname",5=>"abt_name",6=>"telefon_nr",9=>"geb_ID", 10=>"raum_nr");
+
+ $sort = $_GET["s"]; // Sortierung nach Spalte
+ if (!isset($sort) && !$sort) $sort = $_POST["s"];
+
+ $dir = $_GET["d"]; // Sortierrichtung
+ if (!isset($dir) && !$dir) $dir = $_POST["d"];
+
+ $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
+ if (!isset($fnum) && !$fnum) $fnum = $_POST["f"];
+
+ $filter = $_POST["filter"];
+ if (!isset($filter) && !$filter) $filter = $_GET["b"];
+
+ $subf = $_POST["subf"]; // submit
+
+ if (!isset($fnum) || !$fnum) $fnum = 1;
+ if (!isset($filter) || !$filter) $filter = "";
+ if (!isset($sort) || !$sort) $sort = 2; // Name
+ if (!$dir || $dir < "!") $dir = "";
+// print_r ($_REQUEST); echo "<br /><br />";
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+
+ $dbc = new dbconnection();
+/*
+ $sql = "SELECT m.persknr, TRIM(nachname) as name, vorname, titel, abt_name, mt.telefon_nr, telefon_typ, public, geb_ID, raum_nr, email
+ FROM Mitarbeiter m LEFT OUTER JOIN
+ Abteilung a ON m.abt_tel=a.abt_ID LEFT OUTER JOIN
+ MA_Telefon mt ON m.persknr=mt.persknr INNER JOIN
+ Telefon t ON mt.telefon_nr=t.telefon_nr LEFT OUTER JOIN
+ Raum r ON t.raum_ID = r.raum_ID
+ WHERE aktiv>0 AND (m.abt_tel <> 7)
+ UNION
+ SELECT m.persknr, TRIM(nachname) as name, vorname, titel, IFNULL(rag_bez,'INF') as abt_name, mt.telefon_nr, telefon_typ, public, geb_ID, raum_nr, email
+ FROM Mitarbeiter m LEFT OUTER JOIN
+ MA_Telefon mt ON m.persknr=mt.persknr INNER JOIN
+ Telefon t ON mt.telefon_nr=t.telefon_nr LEFT OUTER JOIN
+ Raum r ON t.raum_ID = r.raum_ID LEFT OUTER JOIN
+ MA_RaumArbGruppe ma ON m.persknr=ma.persknr LEFT OUTER JOIN
+ RaumArb_Gruppe rag ON ma.rag_ID=rag.rag_ID
+ WHERE aktiv>0 AND m.abt_tel=7";
+*/
+ $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email FROM v_tel_list";
+ if ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; else $wher = "";
+ if ($sort == 2) $sort = "2, 3, 5";
+ if ($sort == 5) $sort = "5, 2, 3";
+ if ($sort) $ord = " ORDER BY $sort, 6"; // immer nach Telefon-Nr als 2.
+ $sql .= $wher . $ord;
+// echo "sql = $sql<br /><br />";
+ $result = $dbc ->queryObjectArray($sql);
+
+ if ($result)
+ {
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ $getp = "&s=$sort&d=$dir&f=$fnum&b=$filter"; // Parameter Listenanzeige
+
+ echo "<div align='center'>\n";
+ echo "<p><b>Mitarbeiter - Telefonliste</b></p>\n";
+
+ echo "<table border='0' cellspacing='0'>\n";
+ echo "<tr><td class='bigger'>Mittels '<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/auf.gif' border='0' width='11' hight='11' />' / '<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/ab.gif' border='0' width='11' hight='11' />'
+ können Sie nach bestimmten Spalten auf- bzw. absteigend sortieren</td></tr>
+ <tr><td class='bigger'>'<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/filter.gif' border='0' width='14' hight='11' />' ermöglicht das Filtern nach ausgewählten Spalten der Liste</td></tr>
+ <tr><td class='bigger'>Rote Telefon-/Fax-Nummern sind nur intern erreichbar</td></tr>";
+ if ($edit)
+ echo "<tr><td class='bigger'>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Bearbeiten der Angaben</tr>";
+
+ echo "</table><br />\n";
+
+ if (isset($fnum) && $fnum>1 && !$filter && !$subf)
+ {
+ // Formular anzeigen fuer Filterbegriff
+ $text = $fields[$fnum];
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<form action=" . $_SERVER['PHP_SELF'] . " method='post' enctype='application/x-www-form-urlencoded' id='ffilter' name='ffilter' target='_self'>\n";
+ echo "<input type='hidden' name='s' value='$sort'>";
+ echo "<input type='hidden' name='d' value='$dir'>";
+ echo "<input type='hidden' name='f' value='$fnum'>";
+ echo "<input type='hidden' name='e' value='$edit'>";
+ echo "<table width=\"45%\" border=\"0\">\n";
+ echo "<tr><td>filtern nach $text: </td>";
+ echo "<td><input id='filter' name='filter' type=\"text\" size=\"30\" maxlength=\"30\" value=\"$filter\"/></td>";
+/*
+ echo "<td>Zeilen/Seite? <select name='z'>\n";
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $zeil) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td>\n";
+*/
+ echo "<td><input class=\"button\" type=\"hidden\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n";
+ echo "</form>\n";
+ echo "<p> </p>\n";
+ }
+ echo "<table width='55%'>\n";
+
+ if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n";
+
+ // Listenkopf generieren
+ echo "<tr bgcolor='#68ACBF'>";
+ tab_column(2,"Name",$sort,$dir,2,$fnum,$filter,$start,$zeil,$edit);
+ tab_column(3,"Vorname",$sort,$dir,3,$fnum,$filter,$start,$zeil,$edit);
+ tab_column(5,"Abteilung",$sort,$dir,5,$fnum,$filter,$start,$zeil,$edit);
+ tab_column(6,"Telefon/Fax",$sort,$dir,6,$fnum,$filter,$start,$zeil,$edit);
+ tab_column(9,"Haus",$sort,$dir,9,$fnum,$filter,$start,$zeil,$edit);
+ tab_column(10,"Raum",$sort,$dir,10,$fnum,$filter,$start,$zeil,$edit);
+ if ($edit && !is_null($_SESSION["recht"]) && in_array("fme", $_SESSION["recht"]))
+ echo "<th> </th>";
+ echo "</tr>\n";
+ foreach ($result as $row)
+ {
+ if ($row->persknr != $vpnr)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ $titel = ($row->titel)? ", $row->titel" : "" ;
+ $email = ($row->email)? "<a href='mailto:$row->email'>$row->name$titel</a>" : "$row->name$titel";
+ echo "<tr bgcolor='" . $bg . "'><td >$email</td>";
+ echo "<td>$row->vorname</td>";
+ echo "<td>$row->abt_name</td>";
+ // echo "<td class=\"left\">$row->telnr " . ($row->telefon_typ == 'fax')? ", " . strtoupper($row->telefon_typ) : "" . "</td>";
+ $ttyp = ($row->telefon_typ == 'fax')? " " . strtoupper($row->telefon_typ) : "";
+ $rot = ($row->public)? "" : " class=\"red\"";
+ echo "<td$rot>$row->telefon_nr $ttyp</td>";
+ echo "<td>$row->geb_ID</td>";
+ echo "<td>$row->raum_nr</td>";
+ if ($edit && !is_null($_SESSION["recht"]) && in_array("fme", $_SESSION["recht"]))
+ echo "<td><a href='/fhiiqm/ma_tel_ed.php?i=$row->persknr$getp'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>";
+ echo "</tr>\n";
+ }
+ else
+ {
+ echo "<tr bgcolor='" . $bg . "'><td colspan='3'> </td>";
+ $ttyp = ($row->telefon_typ == 'fax')? " " . strtoupper($row->telefon_typ) : "";
+ $rot = ($row->public)? "" : " class=\"red\"";
+ echo "<td$rot>$row->telefon_nr $ttyp</td>";
+ echo "<td>$row->geb_ID</td>";
+ echo "<td>$row->raum_nr</td>";
+ if ($edit && !is_null($_SESSION["recht"]) && in_array("fme", $_SESSION["recht"]))
+ echo "<td> </td>";
+ echo "</tr>\n";
+ }
+ $vpnr = $row->persknr;
+ }
+ echo "</table></div>\n";
+
+ }
+ else
+ {
+ echo "<div align=center>";
+ if ($dbc -> error)
+ echo "error: " . $dbc -> error . "<br />\n";
+ else
+ {
+ echo "<p class='red'> Leider nichts gefunden für ". $fields["$fnum"] . " wie '$filter'!</p><br />";
+ echo " <a href=\"" . $_SERVER["PHP_SELF"] . "?$edit\" target=\"_self\" title=\"Telefonliste\" class=\"sc\">Telefonliste</a></p>\n";
+ }
+ echo "</div>";
+ }
+
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/raum_vma_ed.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,333 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 10/2012
+ *
+ * UPDATE(/DELETE) Raum-Verantwortliche
+*/
+
+
+ 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("ddr",$_SESSION["recht"]) && !in_array("dde",$_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" media="screen"/>
+ <link href="css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+
+ <title>Aktualisieren Raum-Verantwortliche</title>
+</head>
+
+<body>
+ <script type="text/javascript">
+ <!--
+ var counter = 0;
+ var limit = 99;
+ var arr = new Array();
+ function addInput(divName){
+ if (counter == limit) {
+ alert("Das Limit von " + counter + " zusätzlichen inputs ist erreicht");
+ }
+ else {
+ var newdiv = document.createElement('div');
+ var count;
+ var opt="<option value='-1'></option>";
+ for (var key in arr)
+ {
+ opt = opt.concat("<option value='",key,"'>",arr[key],"</option>\n" );
+ }
+ opt += "</select>\n";
+ newdiv.innerHTML += "<select name='raum[ma][]'>"+opt;
+ document.getElementById(divName).appendChild(newdiv);
+ counter++;
+ }
+ }
+ function delInput(divId){
+ var kn = document.getElementById(divId);
+ while (kn.childNodes.length>0 && kn.lastChild.nodeName != "SELECT" && kn.lastChild.nodeName != "A")
+ {
+// alert ("vor "+kn.lastChild.nodeName+", nodetyp = "+ kn.lastChild.nodeType);
+ var knc = kn.lastChild;
+ document.getElementById(divId).removeChild(knc);
+ }
+ if (kn.lastChild.nodeName == "SELECT") document.getElementById(divId).removeChild(kn.lastChild);
+ }
+ //-->
+ </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/house.png\" border=\"0\" alt=\"Raumdaten bearbeiten\" title=\"Raumdaten bearbeiten\"/></div>\n";
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+ $rid = $_GET["i"];
+ if (!$rid) $rid=1;
+ $zeil = $_GET["z"];
+ $start = $_GET["st"];
+ $geb = $_GET["b"];
+
+ $ok = $_POST["ok"];
+ $sub = $_POST["sub"];
+ $raum = $_POST["raum"];
+
+// print_r($raum);
+// echo "<br><br>\n";
+
+ echo "<div align=\"center\"><h3>Raum - Verantwortliche editieren</h3></div>\n";
+
+ $liste="?st=$start&z=$zeil&s=2&f=2&b=$geb"; //Link fuer Raumliste
+
+ if (!$sub || !isset($raum) || !$ok )
+ {
+ if (!$sub && !isset($raum))
+ {
+ $sql = "SELECT persknr FROM Raum_MA WHERE raum_ID = $rid";
+ if ($res = $dbc ->queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ $raum["ma"][] = $row->persknr;
+ }
+ }
+ $sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID,raumtyp_ID,raum_flaeche,raum_file
+ FROM fhiiqm.Raum WHERE raum_ID = $rid";
+ if ($result = $dbc ->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $raum['rnum'] = $row->raum_nr;
+ $raum['rbez'] = $row->raum_name;
+ $raum['geb'] = $row->geb_ID;
+ $raum['rtyp'] = $row->raumtyp_ID;
+ $raum['rflae'] = str_replace(".",",",$row->raum_flaeche);
+ $raum['rfname'] = $row->raum_file;
+ }
+ }
+?>
+ <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_info" target="_self">
+ <div align="center">
+ <table width="30%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Haus</td>
+ <td bgcolor="#D6E6E6"><?php echo $raum['geb']; ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Nummer</td>
+ <td bgcolor="#D6E6E6"><?php echo $raum['rnum']; ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Bezeichnung</td>
+ <td bgcolor="#D6E6E6"><?php echo $raum['rbez']; ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Typ</td>
+ <td bgcolor="#D6E6E6"><?php echo $raum['rtyp']; ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Raum-Fläche (m<sup>2</sup>)</td>
+ <td bgcolor="#D6E6E6"><?php echo $raum['rflae']; ?>
+ </tr>
+ <tr>
+ <td>Raumplan</td>
+ <td bgcolor="#D6E6E6"><?php if ($raum['rfname']>='!' && file_exists("raeume/".$raum['rfname']))
+ echo "<a href='raeume/" . $raum['rfname'] ."'>" . substr($raum['rfname'],strpos($raum['rfname'],"_")+1) . "</a>";
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Verantwortliche *
+ <br /> leeres Feld = Löschen
+ </td>
+ <td bgcolor="#D6E6E6">
+ <div id="add">
+ <select name="raum[ma][]" size="1">
+ <?php
+ $select = null;
+ $select = ( "-1"==$ap['gf'][0] ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as ma
+ FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID
+ WHERE aktiv < 2
+ ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $select = ( $row->persknr===$raum['ma'][0] ) ? ' selected' : null;
+ echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
+ $sgf .= "'".$row->persknr."':'".$row->ma."',";
+ }
+ }
+ $sgf = substr($sgf,0,strlen($sgf)-1);
+ ?>
+ </select>
+ <script type="text/javascript">
+ <!--
+ arr = {<?php echo ($sgf); ?>}; // Ergebnis: {'key':'value','key':'value',...}
+ //-->
+ </script>
+
+ <a href="<?php echo "javascript:addInput('add');" ?>" title="weiterer Verantwortlicher"><img src="/fhiiqm/img/add.png" /></a>
+ <a href="<?php echo "javascript:delInput('add');" ?>" title="löschen letzten Verantwortlichen"><img src="/fhiiqm/img/delete.png" /></a><br />
+ <?php
+ if ($rid || ($sub && isset($raum) && !$ok))
+ {
+ if (count($raum['ma'])>1)
+ {
+ $i=0;
+ foreach ($raum['ma'] as $mae)
+ {
+ if ($i>0)
+ {
+ echo "<select name=\"raum[ma][]\" size=\"1\">";
+
+ $select = ( "-1" == $mae ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+ foreach ($result as $row)
+ {
+ $select = ( $row->persknr === $mae ) ? ' selected' : null;
+ echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
+ }
+ echo "</select><br/>\n";
+ }
+ $i++;
+ }
+ }
+ }
+ ?>
+ </div>
+ </td>
+ </tr>
+
+<?php
+ if ($sub)
+ {
+ $frage = "Alle Angaben ok?";
+ echo "<tr>
+ <td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
+ <td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
+ if ($ok) echo "checked";
+ echo " /></td>\n</tr>\n";
+ }
+
+ if (!is_null($_SESSION["recht"]) && in_array("dde", $_SESSION["recht"]))
+ {
+ echo "<tr>\n";
+ echo "
+ <td> </td>
+ <td><input class=\"button\" type=\"submit\" value=\"ändern\" name=\"sub\" title=\"update\" /></td>\n";
+ echo "</tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"raum_vma_flist.php$liste\" target=\"_self\" title=\"Raumliste\">« zur Raumliste</a></p>\n";
+ echo "</form>\n";
+
+ }
+ elseif ($ok && $sub)
+ {
+ echo "<div align='center'>\n";
+ //daten speichern
+
+ //UPDATE Raum
+
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ $retd = 1;
+ if ($rid && is_array($raum['ma']))
+ { //UPDATE
+ // Loeschen alte Raumverantwortliche
+ $retd = $dbc -> execute("DELETE FROM Raum_MA WHERE raum_ID = ". $rid);
+ }
+
+ if ($retd && is_array($raum['ma']))
+ {
+ $retv = 1;
+ $stmt -> prepare("INSERT INTO Raum_MA (raum_ID,persknr) VALUES(?,?)");
+ for ($k=0; $k<count($raum["ma"]); $k++)
+ {
+ if ($raum["ma"][$k] && $raum["ma"][$k] != -1)
+ {
+ $stmt -> bind_param('ii',$rid,$raum["ma"][$k]);
+ $retv = $stmt -> execute();
+ if (!$retv) $retv = false;
+ }
+ }
+ if (!$retv) echo "error INSERT Raumverantwortliche: $stmt->error<br />\n";
+
+ }
+ }
+// echo "UPDATE-sql = $sql<br />\n";
+ if ($retv)
+ {//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,
+ 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
+ LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID
+ WHERE r.raum_ID = $rid
+ ORDER BY 5";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if (!$first && $row->raum_ID != $vrid)
+ {
+ 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>Verantwortliche(r): </td><td>$row->ma";
+ $first=1;
+ }
+ elseif ($row->raum_ID == $vrid && $row->ma >"")
+ echo "<br />$row->ma";
+ $vrid = $row->raum_ID;
+ }
+ }
+ echo "</td></tr></table>\n";
+ }
+ }
+
+ if ($ok && ($sub))
+ {
+ // Raumliste filtern mit zuletzt eingegeben Haus
+ echo "</div><br /><br />\n";
+ echo "<p class='sc'> <a href=\"raum_vma_flist.php$liste\" target=\"_self\" title=\"Raumliste\">Zurück zur Raumliste</a></p>\n";
+ }
+
+?>
+
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/raum_vma_flist.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,208 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 10/2012
+ */
+
+ 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("ddr",$_SESSION["recht"]) && !in_array("dde",$_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" media="screen"/>
+ <link href="css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+
+ <title>Liste Raumverantwortliche</title>
+</head>
+
+<body onload="document.ffilter.filter.focus();">
+
+<?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/house.png\" border=\"0\" alt=\"Raumdaten\" title=\"Raumdaten\"/></div>\n";
+
+ // Felder, nach denen gefiltert werden kann
+ $fields = array(2=>"Gebäude",6=>"Raum-Typ",9=>"Verantwortliche");
+
+ $zeil = $_GET["z"];
+ if (!$zeil) $zeil = $_POST["z"];
+ if (!$zeil) $zeil = 25; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"];
+ if (!$start) $start=0;
+
+ $sort = $_GET["s"]; // Sortierung nach Spalte
+ if (!isset($sort) && !$sort) $sort = $_POST["s"];
+
+ $dir = $_GET["d"]; // Sortierrichtung
+ if (!isset($dir) && !$dir) $dir = $_POST["d"];
+
+ $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
+ if (!isset($fnum) && !$fnum) $fnum = $_POST["f"];
+
+ $filter = $_POST["filter"];
+ if (!isset($filter) && !$filter) $filter = $_GET["b"];
+
+ $subf = $_POST["subf"]; // submit
+
+ if (!isset($fnum) && !$fnum) $fnum = 1;
+ if (!isset($filter) && !$filter) $filter = "";
+ if (!isset($sort) && !$sort) $sort = 2;
+ if (!isset($dir) && !$dir) $dir = "";
+/*
+ $sql = "SELECT COUNT(*) AS anzr FROM fhiiqm.Raum";
+ $anz = $dbc -> querySingleItem($sql);
+
+ $sql = "SELECT raum_ID, raum_nr, raum_name, geb_ID, r.raumtyp_ID, raumtyp_bez, raum_flaeche, raum_file
+ FROM `fhiiqm`.`Raum` r LEFT OUTER JOIN fhiiqm.Raum_Typ t ON r.raumtyp_ID = t.raumtyp_ID
+ ORDER BY geb_ID, raum_nr LIMIT $start,20 ";
+*/
+
+ include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+ $sql = "CALL raum_ma_flist($sort,'" . $dir . "',$fnum, '" . $filter . "',$start,$zeil,@anz);";
+ // Parameter: Nr. Sortfeld, Sortierrichtung, Nr. Filterfeld, Filterbegriff, (StartNr DS) -1, Anzahl Zeilen=DS, Anzahl gefundener Raeume
+ // liefert: raum_ID, geb_ID, raum_nr, raum_name, raum_typ_ID, raumtyp_bez, raum_flaeche, raum_file, Raum-Verantwortliche
+// echo "sql = $sql<br />";
+ $result = $dbc ->queryObjectArray($sql);
+
+ if ($result)
+ {
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+
+ echo "<div align='center'>\n";
+ echo "<p><b>Liste Räume und Raum-Verantwortliche (Labore und Technik)</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' />'
+ können Sie nach jeder Spalte auf- bzw. absteigend sortieren</td></tr>
+ <tr><td class='bigger'>'<img src='/fhiiqm/img/filter.gif' border='0' width='14' hight='11' />' ermöglicht das Filtern nach ausgewählten Spalten der Liste</td></tr>
+ <tr><td class='bigger'>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Bearbeiten der Raumdaten</td></tr>\n";
+ echo "</table>\n";
+
+ $ranz = $dbc -> querySingleItem("SELECT @anz");
+ printf ("<p>Es wurden %s Räume gefunden.</p>", $ranz);
+
+ if (isset($fnum) && $fnum>1 && !$filter && !$subf)
+ {
+ // Formular anzeigen fuer Filterbegriff
+ $text = $fields[$fnum];
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<form action=" . $_SERVER['PHP_SELF'] . " method='post' enctype='application/x-www-form-urlencoded' id='ffilter' name='ffilter' target='_self'>\n";
+ echo "<input type='hidden' name='s' value='$sort'>";
+ echo "<input type='hidden' name='d' value='$dir'>";
+ echo "<input type='hidden' name='f' value='$fnum'>";
+ echo "<table width=\"40%\" border=\"0\">\n";
+ echo "<tr><td>filtern nach $text: </td>";
+ echo "<td><input id='filter' name='filter' type=\"text\" size=\"30\" maxlength=\"30\" value=\"$filter\"/></td>";
+ echo "<td>Zeilen/Seite? <select name='z'>\n";
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $zeil) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td>\n";
+ echo "<td><input class=\"button\" type=\"submit\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n";
+ echo "</form>\n";
+ echo "<p> </p>\n";
+ }
+ echo "<table>\n";
+
+ if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td><tr>\n";
+
+ // Listenkopf generieren
+ echo "<tr bgcolor='#68ACBF'>";
+ tab_column(2,"Haus",$sort,$dir,2,$fnum,$filter,$start,$zeil);
+ tab_column(3,"Raum-Nr.",$sort,$dir,0,$fnum,$filter,$start,$zeil);
+ tab_column(4,"Bezeichnung",$sort,$dir,0,$fnum,$filter,$start,$zeil);
+ tab_column(6,"Raum-Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil);
+ tab_column(7,"Fläche(m<sup>2</sup>)",$sort,$dir,0,$fnum,$filter,$start,$zeil);
+ tab_column(8,"Raumplan",$sort,$dir,0,$fnum,$filter,$start,$zeil);
+ tab_column(9,"Verantwortliche",$sort,$dir,9,$fnum,$filter,$start,$zeil);
+ echo "<th> </th></tr>\n";
+
+// echo "<tr bgcolor='#68ACBF'><th>Raum-Nr.</th><th>Bezeichnung</th><th>Haus</th><th>Typ</th><th>Fläche (m<sup>2</sup>)</th><th>Raumplan</th><th> </th>
+// </tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='" . $bg . "'>";
+ echo "<td>$row->geb_ID</td>";
+ echo "<td class='left'>$row->raum_nr</td>";
+ echo "<td>$row->raum_name</td>";
+ echo "<td>$row->raumtyp_ID: $row->raumtyp_bez</td>";
+ echo "<td class='right'>" . str_replace(".",",",$row->raum_flaeche) . "</td>";
+ if (file_exists("raeume/".$row->raum_file))
+ {
+ $raum_file = substr($row->raum_file,strpos($row->raum_file,"_")+1);
+ echo "<td><a href=\"raeume/$row->raum_file\">$raum_file</td>";
+ }
+ else
+ echo "<td>$row->raum_file</td>";
+ echo "<td>" . str_replace("; ","<br />",$row->vma)."</td>";
+ echo "<td><a href='/fhiiqm/raum_vma_ed.php?i=$row->raum_ID&st=$start&z=$zeil&b=$filter'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n";
+ }
+ echo "</table></div>\n";
+
+ echo "<br /> ";
+
+ // Sortierung und Filter aus $_GET fuer weitere Seiten
+ foreach ($_GET as $key=>$val)
+ {
+ if ($key != "st") $liste .= "&" . $key ."=".$val;
+ }
+ // Sortierung und Filter aus $_POST fuer weitere Seiten
+ if ($subf)
+ foreach ($_POST as $key=>$val)
+ {
+ if ($key != "st" && $key != "subf" && $key != "filter") $liste .= "&" . $key ."=".$val;
+ if ($key == "filter") $liste .= "&b=" . $val;
+ }
+
+ // Links auf andere Seiten generieren
+ liste_links($start,$zeil,$ranz,$liste);
+
+ }
+ else
+ {
+ if ($dbc -> error)
+ echo "error: " . $dbc -> error . "<br />\n";
+ else
+ {
+ echo "<p class='red'> Leider nichts gefunden für ". $fields["$fnum"] . " wie '$filter'!</p><br />";
+ echo " <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Raumliste\">Raumliste</a></p>\n";
+ }
+
+ }
+ $dbc -> close();
+
+ if (!is_null($_SESSION["recht"]) && in_array("re",$_SESSION["recht"]))
+ echo "<p> <a href=\"raum_ins.php\" target=\"_self\" title=\"Raum erfassen\" class=\"sc\">Weiteren Raum erfassen</a></p>\n";
+
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/report/ma_quit_email.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,117 @@
+#!/usr/bin/php
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 10/2012
+ *
+ * sendet email an Sekretariate am Ende des Monats
+ * mit Namen der ausgeschiedenen Mitarbeiter in diesem Monat
+ * auch als cron-Job einsetzbar
+ *
+ */
+
+ include_once("/var/www/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $addr = array ( "AC" => "acsek@fhi-berlin.mpg.de",
+ "CP" => "mehnert@fhi-berlin.mpg.de,misch@fhi-berlin.mpg.de",
+ "MP" => "doelln@fhi-berlin.mpg.de",
+ "PC" => "reimers@fhi-berlin.mpg.de,bunkherr@fhi-berlin.mpg.de",
+ "TH" => "thsecretary@fhi-berlin.mpg.de",
+ "VW" => "admsek@fhi-berlin.mpg.de",
+ "INF" => "admsek@fhi-berlin.mpg.de"
+ );
+ $mon = array ( "January" => "Januar",
+ "February" => "Februar",
+ "March" => "März",
+ "April" => "April",
+ "May" => "Mai",
+ "June" => "Juni",
+ "July" => "Juli",
+ "August" => "August",
+ "September" => "September",
+ "October" => "Oktober",
+ "November" => "November",
+ "December" => "Dezember"
+ );
+/*
+ $sql = "SELECT nachname, vorname, abt_name,max(timestamp) as dat
+ FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN Abteilung a
+ ON m.abt_tel=a.abt_ID
+ WHERE aktiv != 1 AND (timestamp) > LAST_DAY(NOW()) - INTERVAL 1 MONTH
+ GROUP BY abt_name, nachname, vorname";
+*/
+ $sql = "CALL ma_change(0)";
+ // liefert: nachname,vorname,abt,dat,aktiv
+ $result = $dbc -> queryObjectArray($sql);
+ if ($result)
+ {
+ $heute = new DateTime();
+ $me = $heute->format("F");
+ $infoh = "
+ <html>
+ <head>
+ <title>Mitarbeiter (IQM-DB)</title>
+ </head>
+ <body>
+ <p>Liebe Kollegin,</p>
+ <p>im Monat " . $mon["$me"] ." haben folgende Mitarbeiter Ihre Abteilung / das FHI verlassen:</p>
+ <table border='1' cellspacing='0' cellpadding='5'>\n
+ <tr><td>Name</td><td>Vorname</td><td>Abteilung</td></tr>\n";
+
+ $trenn = md5( time() );
+// $eaddr = "kaendler@fhi-berlin.mpg.de"; // nur fuer Test
+ $eaddr = "schwarzer@fhi-berlin.mpg.de"; // nur fuer Test
+// $eaddr = "bettina.schwarzer@gmx.de"; // nur fuer Test
+ $eheader =
+// 'Reply-To: noreply@' .$_SERVER['SERVER_NAME'] . "\r\n" .
+ 'Message-ID: <' .$trenn.'@achilleus.rz-berlin.mpg.de'.">\r\n" .
+ 'X-Mailer: PHP v' .phpversion() . "\r\n" .
+ 'Bcc: schwarzer@fhi-berlin.mpg.de' . "\r\n" .
+ 'From: noreply@achilleus.rz-berlin.mpg.de'."\r\n" .
+ 'MIME-Version: 1.0' . "\r\n" .
+ 'Content-Type: text/html; charset=iso-8859-1' . "\r\n" ;
+// $eheader .= " boundary = " .$trenn; // nur fuer Content-Type: multipart/mixed email
+ $eheader .= "\r\n\r\n";
+ $esubj = "Mitarbeiter FHI";
+
+ // Mailbody vorbereiten
+// $mailbody = "This is a multi-part message in MIME format\r\n";
+// $mailbody .= "--" .$trenn. "\r\n";
+// $mailbody .= "Content-Type: text/html; charset=iso-8859-1\r\n";
+// $mailbody .= "Content-Transfer-Encoding: 8bit\r\n\r\n";
+
+ $emesse = "<p>Diese Information unterstützt Sie dabei, Ihre Mitarbeiter-Listen und -Zuordnungen aktuell zu halten.</p>";
+ $emesse .= "<br /><p>Das ist eine automatisch generierte E-Mail, bitte nicht darauf antworten.</p>\n";
+ $emesse .= "<p>Beste Grüße, Ihre FHIIQM-Datenbank</p>\n</body></html>\n";
+
+ $first = 1; $info = "";
+ foreach ($result as $row)
+ {
+ if ($first) $abt = $row->abt;
+ $dat = new DateTime($row->dat);
+ if ($abt == $row->abt)
+ {
+// $info .= "<tr><td>$row->nachname</td><td>$row->vorname</td><td>". $dat->format('d.m.Y')."</td><td>$row->abt</td></tr>\n";
+ $info .= "<tr><td>$row->nachname</td><td>$row->vorname</td><td>$row->abt</td></tr>\n";
+ }
+ else
+ {
+// $emess = $mailbody . $infoh."\n".$info ."</table>\n" . $emesse ."\n";
+ $emess = $infoh."\n".$info ."</table>\n" . $emesse ."\n";
+// $eaddr = $addr["$abt"];
+ mail($eaddr,$esubj,$emess,$eheader);
+// echo "<br />adr=$eaddr<br />mess= $emess";
+// $info = "<tr><td>$row->nachname</td><td>$row->vorname</td><td>". $dat->format('d.m.Y')."</td><td>$row->abt</td></tr>\n";
+ $info = "<tr><td>$row->nachname</td><td>$row->vorname</td><td>$row->abt</td></tr>\n";
+ }
+ $abt = $row->abt;
+ $first = 0;
+ }
+ $emess = $infoh."\n".$info ."</table>\n" . $emesse ."\n";
+// $eaddr = $addr["$abt"];
+ mail($eaddr,$esubj,$emess,$eheader);
+// echo "<br />adr=$eaddr<br />mess= $emess";
+ }
+?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/tel_ed.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,271 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Edit Telefon
+ */
+
+ 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("fmr",$_SESSION["recht"]) && !in_array("fme",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $sub = $_POST["eintragen"];
+ $del = $_POST["del"];
+ $tf = $_POST["tf"];
+ $okn = $_POST["okn"];
+ $ok = $_POST["ok"];
+ if (!$okn) $ok=0;
+ $tid = urldecode($_GET["i"]); // Telefon
+
+ $sort = $_GET["s"]; // Sortierung nach Spalte
+ $dir = $_GET["d"]; // Sortierrichtung
+ $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
+ $filter = $_GET["b"]; // Filterbegriff
+ $zeil = $_GET["z"]; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ $getp = "s=$sort&d=$dir&f=$fnum&b=$filter&st=$start&z=$zeil"; // Parameter Listenanzeige
+
+// print_r ($tf); echo ", i= $tid<br />sub = $sub<br /><br />";
+
+?>
+<!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>Telefon 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/group.png\" border=\"0\" alt=\"Mitarbeiter bearbeiten\" title=\"Mitarbeiter bearbeiten\"/></div>\n";
+
+ if ($tid) $text = "editieren"; else $text = "erfassen";
+ echo "<div align=\"center\">";
+ echo "<h3>Telefon $text</h3>";
+ echo "</div>\n";
+ if ((!$sub && !$del) || !$ok)
+ {
+
+ if ($tid && (!$sub || !$del) && !isset($tf))
+ {
+ $sql = "SELECT telefon_nr, telefon_typ, raum_ID FROM Telefon WHERE telefon_nr='$tid'";
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $tf['tel'] = $row->telefon_nr;
+ $tf['typ'] = $row->telefon_typ;
+ $tf['raum'] = $row->raum_ID;
+ }
+ }
+ // Haus
+ if ($tf['raum'])
+ {
+ $sql = "SELECT geb_ID FROM Raum
+ WHERE raum_ID = " . $tf['raum'];
+ $tf['geb'] = $dbc -> querySingleItem($sql);
+ }
+ }
+ $okn = true;
+ if (!$tf) $tf['geb'] = 'A';
+?>
+ <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_ma">
+ <div align="center">
+ <table width="60%" border="0" cellspacing="3" cellpadding="3">
+ <tr>
+ <td>Telefon *</td>
+ <td><input name="tf[tel]" type="text" size="30" maxlength="30" value="<?php echo $tf['tel']; ?>" />
+ <?php
+ if (isset($tf['tel']) && $tf['tel']<'!')
+ {
+ echo "<br><span class=\"red\">Telefon-Nummer ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>Telefontyp *</td>
+ <td><select name="tf[typ]">
+ <?php
+ $sql = "SHOW COLUMNS FROM Telefon WHERE Field = 'telefon_typ'";
+ if ($result = $dbc->queryRow($sql))
+ {
+ foreach ($result as $row)
+ $arr=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$row[1]));
+ foreach ($arr as $typ)
+ {
+ if ($typ == $tf["typ"])
+ echo "<option selected value=\"$typ\">$typ</option>\n";
+ else
+ echo "<option value=\"$typ\">$typ</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr><td>Ort</td>
+ <td valign="top">Haus
+ <select name="tf[geb]" onchange="this.form.submit();">
+ <?php
+ if ($tf['geb'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->geb_ID == $tf['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>
+ Raum
+ <select name="tf[raum]">
+ <?php
+ if ($tf['raum'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT raum_ID, raum_nr, raum_name FROM `fhiiqm`.`Raum` WHERE geb_ID='" . $tf['geb'] ."' ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raum_ID == $tf['raum'])
+ echo "<option selected value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
+ else
+ echo "<option value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <input type="hidden" name="okn" value="<?php echo $okn; ?>" />
+
+<?php
+ if ($sub || $del)
+ {
+ if ($sub)
+ $frage = "Alle Angaben ok?";
+ elseif ($del)
+ $frage = "Telefon 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("fme",$_SESSION["recht"]))
+ {
+ echo "
+ <tr><td> </td>\n
+ <td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />";
+ if ($tid)
+ {
+ 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=\"tel_flist.php?$getp\" target=\"_self\" title=\"Telefon-Liste\">« zur Telefon-Liste</a></p>\n";
+ echo "</form>\n";
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($del)
+ { // Telefon-Nr. auch in MA_Telefon loeschen
+ $sql = "DELETE FROM Telefon WHERE telefon_nr ='$tid'";
+ $retdi = $dbc -> execute($sql);
+ if ($retdi)
+ {
+ echo "<p class='green'><b>DELETE: TelefonNr. '".$tf["tel"] ."' wurde erfolgreich gelöscht (auch die Mitarbeiterzuordnung).</b></p>\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>DELETE: TelefonNr. '".$tf["tel"] ."' konnte nicht gelöscht werden!</b></p>\n";
+ echo "sql = $sql<br />";
+ echo "error DELETE: " . $dbc->error . "<br />";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/tel_dat_show.inc.php");
+ }
+ else //INSERT oder UPDATE
+ {
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ if ($tf["raum"] == "-1") $tf["raum"] = 'NULL';
+ if ($tid) //UPDATE
+ {
+ $stmt -> prepare("UPDATE Telefon SET
+ telefon_nr = ?,
+ telefon_typ = ?,
+ raum_ID = ?
+ WHERE telefon_nr = '$tid'");
+ $stmt -> bind_param('sss',$tf["tel"],$tf["typ"],$tf["raum"]);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error UPDATE Telefon: " . $stmt->error . "<br><br>\n";
+ }
+ else
+ {
+ $stmt -> prepare("INSERT INTO Telefon (telefon_nr, telefon_typ, raum_ID) VALUES (?,?,?)");
+ $stmt -> bind_param('sss',$tf["tel"],$tf["typ"],$tf["raum"]);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error INSERT Telefon: " . $stmt->error . "<br><br>\n";
+ }
+ }
+ if ($result) // INSERT/UPDATE Telefon
+ {
+ //Eingabe Daten erfolgreich
+ echo "<p class='green'><b>Telefondaten zu '" . $tf['tel']. "' wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<br /><br />\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>Telefondaten zu '" . $tf['tel']. "' wurden nicht gespeichert.</b></p>\n";
+ echo "error: ". $dbc -> error;
+ echo "<br /><br />\n";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/tel_dat_show.inc.php");
+ }
+ echo "</div>";
+ echo "<p class='sc'> <a href=\"tel_flist.php?$getp\" target=\"_self\" title=\"Telefonliste\">Telefonliste</a></p>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Telefon erfassen\">Neue Telefon-Nummer erfassen</a></p>\n";
+ }
+?>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/tel_flist.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,187 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2012
+ *
+ * Liste aller Telefone
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ include_once ("inc/func_lib.inc.php");
+
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("fmr",$_SESSION["recht"]) && !in_array("fme",$_SESSION["recht"])
+ && !in_array("ddr",$_SESSION["recht"]) && !in_array("dde",$_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="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+
+ <title>Telefonliste</title>
+</head>
+
+<body onload="document.ffilter.filter.focus();">
+<?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/group.png\" border=\"0\" alt=\"Telefondaten\" title=\"Telefondaten\"/></div>\n";
+
+ // Felder, nach denen gefiltert werden kann
+ $fields = array(2=>"Nummer",3=>"Typ",4=>"Haus", 5=>"Raum");
+ $fieldf = array(2=>"telefon_nr",3=>"telefon_typ",4=>"geb_ID",5=>"raum_nr");
+
+ $sort = $_GET["s"]; // Sortierung nach Spalte
+ if (!isset($sort) && !$sort) $sort = $_POST["s"];
+
+ $dir = $_GET["d"]; // Sortierrichtung
+ if (!isset($dir) && !$dir) $dir = $_POST["d"];
+
+ $fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
+ if (!isset($fnum) && !$fnum) $fnum = $_POST["f"];
+
+ $filter = $_POST["filter"];
+ if (!isset($filter) && !$filter) $filter = $_GET["b"];
+
+ $zeil = $_GET["z"];
+ if (!$zeil) $zeil = $_POST["z"];
+ if (!$zeil) $zeil = 25; // Anzahl der gezeigten Zeilen
+ $start = $_GET["st"]; // Start bei DS $start+1
+ if (!$start) $start=0;
+
+ if (!isset($fnum) || !$fnum) $fnum = 1;
+ if (!isset($filter) || !$filter) $filter = "";
+ if (!isset($sort) || !$sort) $sort = 2; // Name
+ if (!$dir || $dir < "!") $dir = "";
+
+ $subf = $_POST["subf"]; // submit
+
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ $sql = "SELECT 1, telefon_nr, telefon_typ, geb_ID, raum_nr FROM Telefon t LEFT OUTER JOIN Raum r ON t.raum_ID = r.raum_ID";
+ if (strtoupper($filter) == "NULL") $wher = " WHERE ". $fieldf[$fnum] . " IS NULL ";
+ elseif ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'";
+ else $wher = "";
+if ($sort == 4) $sort = "4,5";
+ if ($sort) $ord = " ORDER BY $sort ";
+ $sql .= $wher . $ord;
+ $ianz = $dbc -> numrows($sql); // Anzahl DS
+ $sql .= "LIMIT $start,$zeil";
+
+ if ($result = $dbc -> queryObjectArray($sql))
+ {
+
+ $bg1 = "#F8F8F8";
+ $bg2 = "#DEDFE1";
+ $bg = "#FFFFFF";
+ $getp = "&s=$sort&d=$dir&f=$fnum&b=$filter&st=$start&z=$zeil"; // Parameter Listenanzeige
+
+ echo "<div align='center'>\n";
+ echo "<p><b>Telefonliste</b></p>\n";
+
+ echo "<table border='0' cellspacing='0'>\n";
+ echo "<td class='bigger'>Mittels '<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/auf.gif' border='0' width='11' hight='11' />' / '<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/ab.gif' border='0' width='11' hight='11' />'
+ können Sie nach bestimmten Spalten auf- bzw. absteigend sortieren</td></tr>
+ <tr><td class='bigger'>'<img src='http://achilleus.rz-berlin.mpg.de/fhiiqm/img/filter.gif' border='0' width='14' hight='11' />' ermöglicht das Filtern nach ausgewählten Spalten der Liste</td></tr>";
+ echo "<tr><td class='bigger'>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Bearbeiten der Telefondaten</td></tr>";
+ echo "</table><br />\n";
+
+ if (isset($fnum) && $fnum>1 && !$filter && !$subf)
+ {
+ // Formular anzeigen fuer Filterbegriff
+ $text = $fields[$fnum];
+ $azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<form action=" . $_SERVER['PHP_SELF'] . " method='post' enctype='application/x-www-form-urlencoded' id='ffilter' name='ffilter' target='_self'>\n";
+ echo "<input type='hidden' name='s' value='$sort'>";
+ echo "<input type='hidden' name='d' value='$dir'>";
+ echo "<input type='hidden' name='f' value='$fnum'>";
+ echo "<table width=\"30%\" border=\"0\">\n";
+ echo "<tr><td>filtern nach $text: </td>";
+ echo "<td><input id='filter' name='filter' type=\"text\" size=\"20\" maxlength=\"30\" value=\"$filter\"/></td>";
+ echo "<td>Zeilen/Seite? <select name='z'>\n";
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $zeil) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td>\n";
+ echo "<td><input class=\"button\" type=\"submit\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n";
+ echo "</form>\n";
+ echo "<p> </p>\n";
+ }
+ echo "<table width='30%'>\n";
+ if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n";
+
+ // Listenkopf generieren
+ echo "<tr bgcolor='#68ACBF'>";
+ tab_column(2,"Nummer",$sort,$dir,2,$fnum,$filter,$start,$zeil);
+ tab_column(3,"Typ",$sort,$dir,3,$fnum,$filter,$start,$zeil);
+ tab_column(4,"Haus",$sort,$dir,4,$fnum,$filter,$start,$zeil);
+ tab_column(5,"Raum",$sort,$dir,5,$fnum,$filter,$start,$zeil);
+ echo "<th> </th>";
+ echo "</tr>\n";
+ foreach ($result as $row)
+ {
+ if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+ echo "<tr bgcolor='$bg'><td>$row->telefon_nr</td>";
+ $tt = ($row->telefon_typ == "fax")? strtoupper($row->telefon_typ) : $row->telefon_typ;
+ echo "<td>$tt</td>";
+ echo "<td>$row->geb_ID</td>";
+ echo "<td>$row->raum_nr</td>";
+ echo "<td><a href='/fhiiqm/tel_ed.php?i=".urlencode($row->telefon_nr).$getp."'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>";
+ echo "</tr>\n";
+ }
+ echo "</table></div>\n";
+ echo "<br /> ";
+
+ // Sortierung und Filter aus $_GET fuer weitere Seiten
+ foreach ($_GET as $key=>$val)
+ {
+ if ($key != "st") $liste .= "&" . $key ."=".$val;
+ }
+ // Sortierung und Filter aus $_POST fuer weitere Seiten
+ if ($subf)
+ foreach ($_POST as $key=>$val)
+ {
+ if ($key != "st" && $key != "subf" && $key != "filter") $liste .= "&" . $key ."=".$val;
+ if ($key == "filter") $liste .= "&b=" . $val;
+ }
+
+ // Links auf andere Seiten generieren
+ liste_links($start,$zeil,$ianz,$liste);
+ }
+ else
+ {
+ echo "<div align=center>";
+ if ($dbc -> error)
+ echo "error: " . $dbc -> error . "<br />\n";
+ else
+ {
+ echo "<p class='red'> Leider nichts gefunden für ". $fields["$fnum"] . " wie '$filter'!</p><br />";
+ echo " <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Telefonliste\" class=\"sc\">Telefonliste</a></p>\n";
+ }
+ echo "</div>";
+ }
+
+?>
+</body>
+</html>
\ No newline at end of file
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/test/test_pdf.php Fri Nov 16 10:40:03 2012 +0100
@@ -0,0 +1,19 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 10/2012
+ *
+ * TEST pdf
+ */
+
+echo "pdf erstellen möglich?";
+try
+{ $p = new PDFlib;
+ echo "<br /> Ja!";
+}
+catch (Exception $e)
+{ echo "<br /> Nein! " . $e->getMessage();}
+//[Fri Oct 26 15:29:38 2012] [error] [client 141.14.133.204] PHP Fatal error: Class 'PDFlib' not found in /var/www/fhiiqm/test/test_pdf.php on line 11
+
+?>
\ No newline at end of file
