<?php
/**
* @author Bettina Schwarzer, Fritz-Haber-Institut
* @copyright 12/2012
*
* Report Mitarbeiter - Bezuege
* $_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("ir",$_SESSION["recht"]) && !in_array("ie",$_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"/>
<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>Report MA - Beziehungen</title>
</head>
<body>
<script>
$(function() {
$("#persknr").autocomplete({
source: "/fhiiqm/inc/ma_list_ac.inc.php",
minLength: 2,
select: function(event,ui){$("#pid").val(ui.item.id);}
});
$("#dat").datepicker({
dateFormat: 'yy-mm-dd', //nur Datum
yearRange: '2000:2025',
changeMonth: true,
changeYear: true,
firstDay: 1,
dayNamesMin: ['So','Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ],
monthNamesShort: ['Jan','Feb','Mar','Apr','Mai','Jun','Jul','Aug','Sep','Okt','Nov','Dez']
});
});
</script>
<?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/user.png\" border=\"0\" alt=\"Raum\" title=\"Raum\"/></div>\n";
}
$par = $_POST["par"]; // Parameter aus Form
$search = $_POST["search"];
if (!$search) $search = $_GET["s"];
if ($search && $_GET['s'] != 2)
{
echo "<span class='sc'>";
echo "<br /> <a href=\"/fhiiqm/info_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"MA - Relation\" class='sc'>neuer Bericht Mitarbeiter & Zuordnungen</a>\n";
echo "</span>";
}
echo "<div align='center'>\n";
echo "<p><b>Mitarbeiter und ihre Zuordnungen</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="30%" border="0" cellspacing="3" cellpadding="3">
<tr><td>Status Mitarbeiter/Objekt</td>
<td><select name="par[act]" size="1" onchange="this.form.submit();">
<option value="1" <?php if ($par["act"]== "1") echo "selected='selected'"; ?>>aktiv</option>
<option value="0" <?php if ($par["act"]== "0") echo "selected='selected'"; ?>>ausgeschieden</option>
<option value="2" <?php if ($par["act"]== "2") echo "selected='selected'"; ?>>sonstig</option>
</select></td>
</tr>
<tr>
<td>Mitarbeiter</td>
<td><input class="long20" type="text" name="par[persknr]" id="persknr" value="<?php echo $par['persknr']; ?>"/>
<br />Eingabe von mind. 2 Zeichen -> Namensliste
</td>
</tr>
<tr><td>Abteilung</td>
<td><select name="par[abt]" size="1">
<option value=""></option>
<?php $sql = "SELECT abt_name FROM Abteilung ORDER BY abt_ID+0";
$result = $dbc -> queryObjectArray($sql);
foreach ($result as $row)
echo "<option value=$row->abt_name>$row->abt_name</option>"
?>
</select>
</td>
</tr>
<?php if ($par["act"]== "0")
{
echo "<tr>
<td>ab Datum</td>
<td><input class=\"long10\" name=\"par[dat]\" id=\"dat\" value=\"".$par['dat']."\" /></td>
</tr>\n";
}
?>
<tr>
<input type="hidden" name="par[pers]" id="pid" value="<?php echo $par['pers']; // Author ?>"/>
<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 (!isset($par["act"])) $par["act"] = 0;
if (isset($par["act"])) $krit = " [Status = '" . $par["act"] ."']";
if ($par["pers"]>0) $krit .= " UND [Mitarbeiter = '" .$par["persknr"] ."']"; else $par["pers"] = 0;
if ($par["abt"]>"") $krit .= " UND [Abteilung = '" .$par["abt"] ."']"; else $par["abt"] = "";
if ($par["dat"]>"") $krit .= " UND [Datum >= '" .$par["dat"] ."']"; else $par["dat"] = "";
$sql = "CALL ma_relation('".$par["act"]."',". $par["pers"].",'".$par["abt"]."','".$par["dat"]."')";
//echo "$sql<br />";
$result = $dbc -> queryObjectArray($sql);
if ($result)
{
echo "<p>$krit</p>";
$begin = 0;
// print_r ($result);
foreach ($result as $row)
{
if ($begin) echo "<p style=\"page-break-before:always\"> </p>";
echo "<table width='90%' border='0' frame='box' cellspacing='2' cellpadding='10'>\n";
echo "<tr><td><b>$row->name</b>, Abteilung: <b>$row->abt</b></td></tr>\n";
echo "</table>\n";
echo "<table width='90%' border='1' frame='box' rules='rows' cellspacing='2' cellpadding='10'>\n";
if ($row->rag)
{
$str=null;
echo "<tr><td><u>Arbeitsgruppe:</u> ";
$arr = explode("; ",$row->rag);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
// echo str_replace("; ","<br />",substr($row->rag,strpos($row->rag,"|")+1)) ."</td></tr>\n";
}
if ($row->fkt)
{
echo "<tr><td><u>Beauftragung:</u><br /> ";
echo str_replace("; ","<br />",str_replace("|"," - ",$row->fkt)) ."</td></tr>\n";
}
if ($row->raumva)
{
$str=null;
echo "<tr><td><u>Raumverantwortlich:</u> ";
$arr = explode("; ",$row->raumva);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
// echo str_replace("; ","<br />",substr($row->raumva,strpos($row->raumva,"|")+1)) ."</td></tr>\n";
}
if ($row->infaut)
{
$str=null;
echo "<tr><td><u>Info - Autor:</u> ";
$arr = explode("; ",$row->infaut);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->infva)
{
$str=null;
echo "<tr><td><u>Info - Verantwortlich:</u> ";
$arr = explode("; ",$row->infva);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->vertrba)
{
$str=null;
echo "<tr><td><u>Vertrag - Bearbeiter:</u> ";
$arr = explode("; ",$row->vertrba);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->lasva)
{
$str=null;
echo "<tr><td><u>Laser - Verantwortlich:</u> ";
$arr = explode("; ",$row->lasva);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->anlva)
{
$str=null;
echo "<tr><td><u>Anlage - Verantwortlich:</u> ";
$arr = explode("; ",$row->anlva);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->prozva)
{
$str=null;
echo "<tr><td><u>Prozess - Verantwortlich:</u> ";
$arr = explode("; ",$row->prozva);
foreach ($arr as $e)
$str .= "<br />" . substr($e,strpos($e,"|")+1);
echo "$str</td></tr>\n";
}
if ($row->tel)
{
$str=null;
echo "<tr><td><u>Telefon/Fax:</u> ";
$arr = explode("; ",$row->tel);
foreach ($arr as $e)
{
$fax = (substr($e,strpos($e,"|")+1) == 'fax')? ' FAX' : '';
$str .= "<br />" . substr($e,0,strpos($e,"|")) . $fax;
}
echo "$str</td></tr>\n";
}
echo "</table>\n";
// $begin = 1;
echo "<p> </p>\n";
}
}
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/info_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
echo " | <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"MA - Relation\" class='sc'>neuer Bericht Mitarbeiter & Zuordnungen</a></span>\n";
}
else
echo "<a href='javascript:history.back();' onMouseOver=\"{window.status='Zurück'; return true;}\">« Zurück</a>";
}
?>
</body>
</html>