IQM: fhiiqm/report/raum_ohne_rag_report.php@9c668cd391fa (annotated)

29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	1	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	2
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	3	/**
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	4	* @author Bettina Schwarzer, Fritz-Haber-Institut
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	5	* @copyright 08/2012
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	6	*
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	7	* Report Raeume, Raumtyp, Aptyp ohne Zuordnung Arbeitsgruppe
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	8	*
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	9	*
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	10	*/
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	11
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	12	error_reporting(E_ALL ^ E_NOTICE);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	13
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	14	if (!isset($_GET['s']) \|\| $_GET['s'] != 2 )
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	15	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	16	session_start();
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	17	if (! isset($_SESSION["userid"]))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	18	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	19	include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	20	login($_SERVER["PHP_SELF"]);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	21	exit;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	22	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	23
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	24	if (is_null($_SESSION["recht"]) \|\| (!is_null($_SESSION["recht"]) && !in_array("asr",$_SESSION["recht"]) && !in_array("ase",$_SESSION["recht"])))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	25	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	26	header("Location: start.php");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	27	exit;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	28	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	29	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	30	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	31	if (!isset($dbc) \|\| !$dbc) $dbc = new dbconnection();
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	32
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	33
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	34	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	35	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	36	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	37
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	38	<head>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	39	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	40	<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	41	<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	42	<title>Report Raum ohne AG</title>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	43	</head>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	44
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	45	<body>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	46
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	47	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	48	echo " ";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	49	if (!isset($_GET['s']) \|\| $_GET['s'] != 2 )
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	50	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	51	echo "<div class=\"float-br smaller\" valign='top'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	52	echo "   user: " . $_SESSION["userid"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	53	echo "   <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	54	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	55	echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/role.png\" border=\"0\" alt=\"Raum\" title=\"Raum\"/></div>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	56
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	57	$rag = $_POST["rag"]; // Parameter aus Form
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	58	$search = $_POST["search"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	59	if (!$search) $search = $_GET["s"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	60
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	61	$zeil = $rag["z"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	62	if (!$zeil) $zeil = $_GET["z"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	63	if (!$zeil) $zeil = 9999; // Anzahl der gezeigten Zeilen
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	64	$start = $_GET["st"]; // Start bei DS $start+1
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	65	if (!$start) $start=0;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	66
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	67
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	68	if (!is_array($rag))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	69	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	70	$rag["geb"] = $_GET["g"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	71	$rag["rtyp"] = $_GET["t"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	72	$rag["bind"] = $_GET["b"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	73	$rag["sort1"] = $_GET["s1"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	74	$rag["sort2"] = $_GET["s2"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	75	$rag["sort3"] = $_GET["s3"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	76	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	77	$_GET["g"] = $rag["geb"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	78	$_GET["t"] = $rag["rtyp"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	79	$_GET["b"] = $rag["bind"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	80	$_GET["s1"] = $rag["sort1"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	81	$_GET["s2"] = $rag["sort2"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	82	$_GET["s3"] = $rag["sort3"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	83	$_GET["z"] = $zeil;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	84
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	85	if ($search && $_GET['s'] != 2)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	86	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	87	echo "<span class='sc'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	88	echo "<br />   <a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	89	echo "   \|   <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Räume ohne AG\" class=\"sc\">neuer Bericht Räume ohne AG Zuordnung</a>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	90	echo "</span>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	91	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	92	echo "<div align='center'>\n";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	93	echo "<p><b>(1b) Bericht Räume ohne Arbeitsgruppen-Zuordnung </b></p>\n";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	94	echo "</div>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	95
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	96
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	97	if (!$search)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	98	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	99	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	100	<div align="center">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	101	<p>Bitte Kriterien für die Suche wählen</p>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	102	<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_raum" target="_self">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	103	<table width="50%" border="0" cellspacing="3" cellpadding="3">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	104	<tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	105	<td>Haus</td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	106	<td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	107	<select name="rag[geb]" size="1">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	108	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	109	if ($rag["geb"] == -1) $select = " selected "; else $select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	110	echo "<option $select value=\"-1\"></option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	111	$sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	112	if ($result = $dbc->queryObjectArray($sql))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	113	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	114	foreach ($result as $row)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	115	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	116	if ($row->geb_ID == $rag['geb'])
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	117	echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	118	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	119	echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	120	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	121	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	122	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	123	</select>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	124	</td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	125	</tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	126	<tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	127	<td>Raumtyp</td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	128	<td><select name="rag[rtyp]">
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	129	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	130	if ($rag["rtyp"] == -1) $select = " selected "; else $select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	131	echo "<option $select value=\"-1\"></option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	132	$sql = "SELECT raumtyp_ID,raumtyp_bez FROM fhiiqm.Raum_Typ ORDER BY 1";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	133	if ($result = $dbc->queryObjectArray($sql))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	134	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	135	foreach ($result as $row)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	136	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	137	if ($row->raumtyp_ID == $rag['rtyp'])
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	138	echo "<option selected value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	139	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	140	echo "<option value=\"$row->raumtyp_ID\">$row->raumtyp_ID - $row->raumtyp_bez</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	141	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	142	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	143	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	144	</select></td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	145	</tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	146	<tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	147	<td>Verknüpfung</td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	148	<td>UND
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	149	<input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	150	ODER
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	151	<input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	152	</tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	153	<tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	154	<td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	155	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	156	$sort = array("-1"=>"","1"=>"Gebäude","2"=>"Raum-Nr.","4"=>"Raum-Typ");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	157	for ($i=1; $i<4; $i++)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	158	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	159	echo "$i.  <select name='rag[sort$i]'>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	160	foreach ($sort as $key=>$val)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	161	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	162	$rsort = "sort" . $i;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	163	if ($rag[$rsort] == $val) $select= " selected"; else $select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	164	echo "<option$select value='$key'>$val</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	165	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	166	echo "</select>    \n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	167	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	168	echo "</td></tr>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	169
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	170	$azeil = array(10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	171	echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	172	if (!$rag['z']) $rag['z'] = 9999;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	173	foreach ($azeil as $key=>$val)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	174	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	175	if ($key == $rag['z']) $select = "selected"; else $select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	176	echo "<option $select value='$key'>$val</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	177	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	178	echo "</select></td></tr>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	179
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	180	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	181	<tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	182	<td> </td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	183	<td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	184	</tr>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	185	</table>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	186	</div>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	187	</form>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	188	<?php
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	189	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	190	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	191	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	192	echo "<div align='center'>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	193
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	194	$sql = "SELECT geb_ID,raum_nr,raum_name,r.raumtyp_ID,raumtyp_bez,t.arbplatz_typ,arbplatz_typ_bez,r.raum_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	195	FROM Raum r LEFT OUTER JOIN
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	196	fhiiqm.Raum_RaumArbGruppe ra ON r.raum_ID=ra.raum_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	197	LEFT OUTER JOIN Raum_Arbplatz_Typ t ON r.raum_ID = t.raum_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	198	LEFT OUTER JOIN Raum_Typ rt ON r.raumtyp_ID = rt.raumtyp_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	199	LEFT OUTER JOIN Arbplatz_Typ at ON t.arbplatz_typ = at.arbplatz_typ
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	200	WHERE ra.raum_ID IS NULL";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	201
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	202	$lim = " LIMIT $start,$zeil";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	203
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	204	if (!$rag["bind"]) $bind = " AND "; else $bind = $rag["bind"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	205
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	206	if ($rag["geb"]> -1) $where = " geb_ID = '$rag[geb]' ";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	207	if ($rag["rtyp"]> -1)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	208	if ($where) $where .= "$bind r.raumtyp_ID = '$rag[rtyp]' "; else $where = " r.raumtyp_ID = '$rag[rtyp]' ";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	209	if ($where) $where = " AND ($where)";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	210
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	211	if ($rag["sort1"]>0 \|\| $rag["sort2"]>0 \|\| $rag["sort3"]>0)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	212	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	213	if ($rag["sort1"]>0) $ord = " ORDER BY " . $rag["sort1"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	214	if ($rag["sort2"]>0) $ord .= ",".$rag["sort2"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	215	if ($rag["sort3"]>0) $ord .= ",".$rag["sort3"];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	216	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	217
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	218	$sql .= $where;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	219	// $ianz = $dbc -> numrows($sql);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	220	$sql .= $ord . $lim;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	221	// echo "sql = $sql<br />\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	222	$result = $dbc ->queryObjectArray($sql);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	223
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	224	if ($rag["geb"] > -1) $krit = " [Gebäude = '" . $rag["geb"] ."']";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	225	if ($rag["rtyp"] > -1)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	226	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	227	if ($krit) $bd = " ".$bind; else $bd = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	228	$rtn = $dbc -> querySingleItem("SELECT raumtyp_bez FROM Raum_Typ WHERE raumtyp_ID='".$rag["rtyp"]."'");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	229	$krit .= $bd." [Raum-Typ = '$rtn']";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	230	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	231	if ($krit )echo "Suchergebnis für $krit"; else echo "Suchergebnis\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	232	$ianz = $dbc -> querySingleItem("SELECT COUNT(*)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	233	FROM Raum r LEFT OUTER JOIN
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	234	fhiiqm.Raum_RaumArbGruppe ra ON r.raum_ID=ra.raum_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	235	LEFT OUTER JOIN Raum_Arbplatz_Typ t ON r.raum_ID = t.raum_ID
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	236	WHERE ra.raum_ID IS NULL $where");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	237	printf ("<p>Anzahl gefundener Raum-Arbeitsplatztyp-Zuordnungen: %s</p>", $ianz);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	238
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	239	if ($result)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	240	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	241	include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	242
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	243	$bg1 = "#F8F8F8";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	244	$bg2 = "#DEDFE1";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	245	$bg = "#FFFFFF";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	246	echo "<table border='1' cellspacing='0' cellpadding='2'>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	247	// Listenkopf
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	248	echo "<tr bgcolor='#68ACBF'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	249	if ($rag['geb'] == -1) echo "<th>Gebäude</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	250	echo "<th>Raum-Nr.</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	251	echo "<th>Raum-Bezeichnung</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	252	if ($rag['rtyp'] == -1) echo "<th>Raum-Typ</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	253	echo "<th>Arbeitsplatz-Typ</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	254	echo "</tr>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	255
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	256	foreach ($result as $row)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	257	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	258	if ($row->raum_ID != $rid)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	259	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	260	if ($rid) echo "</td></tr>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	261	if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	262	echo "<tr bgcolor='" . $bg . "'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	263	if ($rag['geb'] == -1) echo "<td>$row->geb_ID</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	264	echo "<td>$row->raum_nr</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	265	echo "<td>$row->raum_name</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	266	if ($rag['rtyp'] == -1) echo "<td>$row->raumtyp_ID - $row->raumtyp_bez</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	267	echo "<td>$row->arbplatz_typ - $row->arbplatz_typ_bez";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	268	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	269	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	270	echo "<br />$row->arbplatz_typ - $row->arbplatz_typ_bez";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	271	$rid = $row->raum_ID;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	272	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	273	echo "</table>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	274	echo "<p></p><table width=60%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	275	<img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	276	echo "</div>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	277
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	278	echo "<br />   ";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	279	if ($search != 2) // Aufruf aus fhiiqm
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	280	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	281	// Parameter aus $_GET fuer weitere Seiten
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	282	$_GET["s"] = 1; // bewirkt weitere Suche
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	283	foreach ($_GET as $key=>$val)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	284	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	285	if ($key != "st") $liste .= "&" . $key ."=".$val;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	286	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	287	// Links auf andere Seiten generieren
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	288	liste_links($start,$zeil,$ianz,$liste);
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	289	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	290	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	291	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	292	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	293	echo "<p class='red'>   Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	294	echo "</div>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	295	echo "<br />   ";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	296	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	297	if ($search != 2)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	298	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	299	echo "<span class='sc'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	300	echo "<br /><br />   <a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	301	echo "   \|   <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Räume ohne AG\" class=\"sc\">neuer Bericht Räume ohne AG Zuordnung</a>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	302	echo "</span>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	303	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	304	else
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	305	echo "<a href='javascript:history.back();' onMouseOver=\"{window.status='Zurück'; return true;}\">« Zurück</a>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	306	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	307
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	308	?>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	309
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	310	</body>
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	311	</html>

author	Bettina Schwarzer
	Fri, 20 Dec 2013 15:19:32 +0100
changeset 41	9c668cd391fa
parent 33	f1a8785434e4
permissions	-rw-r--r--