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

25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	1	<?php
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	2
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	3	/**
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	4	* @author Bettina Schwarzer, Fritz-Haber-Institut
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	5	* @copyright 02/2012
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	6	*
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	7	* Report Info (GVP)
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	8	*
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	9	*/
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	10
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	11	error_reporting(E_ALL ^ E_NOTICE);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	12
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	13	session_start();
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	14	if (! isset($_SESSION["userid"]))
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	15	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	16	include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	17	login($_SERVER["PHP_SELF"]);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	18	exit;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	19	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	20
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	21	if (is_null($_SESSION["recht"]) \|\| (!is_null($_SESSION["recht"]) && !in_array("ir",$_SESSION["recht"]) && !in_array("ie",$_SESSION["recht"])))
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	22	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	23	header("Location: start.php");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	24	exit;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	25	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	26
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	27	?>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	28	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	29	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	30
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	31	<head>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	32	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	33	<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	34	<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	35
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	36	<title>Geschäftsverteilungsplan</title>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	37	</head>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	38
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	39	<body >
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	40
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	41	<?php
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	42	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	43	include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	44
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	45	$dbc = new dbconnection();
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	46
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	47	$report = $_GET["r"]; // Berichtstyp: 'p' -> Produkte, 'k' -> Kennzahlen
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	48	$create = $_POST["create"];
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	49	$inf = $_POST["inf"];
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	50	// $sort = array("-1"=>"","15"=>"Kennzeichen","2"=>"Teilgebiet");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	51
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	52	echo " ";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	53	echo "<div class=\"float-br smaller sc\" valign='top'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	54	echo "   user: " . $_SESSION["userid"];
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	55	echo "   <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	56	echo "<div class=\"float-r sc\"><img src=\"/fhiiqm/img/document_image_ver.png\" border=\"0\" alt=\"Infodaten\" title=\"Infodaten\"/></div>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	57
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	58	if (!isset($create) \|\| !$create)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	59	{ // Form Kriterien
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	60	echo "<div align=\"center\">";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	61	echo "<h3>Geschäftsverteilungsplan</h3>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	62
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	63	echo "<p>Bitte die Kriterien für den Bericht wählen</p>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	64
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	65	echo "<form action=\"". $_SERVER['PHP_SELF'] ."?r=$report\" method=\"post\" enctype=\"application/x-www-form-urlencoded\" name=\"form_inf\">\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	66	echo "<table width=\"30%\" border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	67	echo "<tr>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	68	// echo "<tr><td>Infotyp wie</td><td><input name='inf[ityp]' type='text' size='10' maxlength='50' value='". $inf['ityp'] ."' /></td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	69	if ($report == 'k')
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	70	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	71	echo "<td>Kennzeichen wie</td><td><input name='inf[kz]' type='text' size='10' maxlength='10' value='". $inf['kz'] ."' /></td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	72	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	73	else
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	74	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	75	echo "<td>Produktbereich</td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	76	echo "<td><select name='inf[prodb]'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	77	if (is_array($inf['prodb'])) $select = in_array( "-1", $inf['prodb'] ) ? ' selected' : null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	78	echo "<option $select value=\"-1\"></option>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	79	$sql = "SELECT prod_ber_ID,prod_ber_name FROM Produkt_Bereich ORDER BY 1";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	80	if ($result = $dbc->queryObjectArray($sql))
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	81	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	82	foreach ($result as $row)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	83	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	84	$prod=str_replace(" "," ",htmlentities($row->prod_ber_name));
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	85	if (is_array($inf['prodb'])) $select = in_array($row->prod_ber_ID, $inf['prodb']) ? ' selected' : null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	86	echo "<option $select value=\"\|$row->prod_ber_ID\|\">$row->prod_ber_ID $prod</option>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	87	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	88	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	89	echo "</select></td></tr>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	90	echo "<tr><td>Produktgruppe</td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	91	echo "<td><select name='inf[prodg]'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	92	if ($inf["prodg"] == -1) $select = " selected "; else $select = "";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	93	echo "<option $select value=\"-1\"></option>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	94	$sql = "SELECT prod_group_ID, prod_group_name, prod_group_hier FROM Produkt_Gruppe ORDER BY 3";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	95	if ($result = $dbc->queryObjectArray($sql))
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	96	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	97	$select = "";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	98	foreach ($result as $row)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	99	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	100	if (isset($inf["prodg"])) $select = ($row->prod_group_ID == $inf["prodg"] ) ? ' selected' : null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	101	echo "<option $select value=\"\|$row->prod_group_ID\|\">$row->prod_group_hier $row->prod_group_name</option>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	102	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	103	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	104	echo "</select></td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	105	echo
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	106	"</tr>\n";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	107	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	108	echo "<tr><td>Status Freigabe</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	109	echo "<td><select name='inf[stat]'>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	110	if ($inf["stat"] == -1) $select = " selected "; else $select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	111	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: 26 diff changeset	112	$sql = "SELECT info_freigabe_ID, info_freigabe_bez FROM Info_Freigabe ORDER BY 2";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	113	if ($result = $dbc->queryObjectArray($sql))
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	114	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	115	$select = "";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	116	foreach ($result as $row)
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	117	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	118	if (isset($inf["stat"])) $select = ($row->info_freigabe_ID == $inf["stat"] ) ? ' selected' : null;
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	119	echo "<option $select value=\"$row->info_freigabe_ID\">$row->info_freigabe_ID - $row->info_freigabe_bez</option>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	120	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	121	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	122	echo "</select></td></tr>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	123
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	124	/* echo "<tr><td>Sortierung nach</td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	125	echo "<td><select name='inf[sort]'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	126	foreach ($sort as $key=>$val)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	127	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	128	if ($inf["sort"] == $key) $select= " selected"; else $select = "";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	129	echo "<option$select value='$key'>$val</option>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	130	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	131	echo "</select></td></tr>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	132	*/
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	133	echo " <tr>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	134	<td> </td>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	135	<td colspan='3'><input class=\"button\" type=\"submit\" name=\"create\" value=\"Bericht erstellen\"></td>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	136	</tr>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	137	</table>\n
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	138	</form>\n
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	139	</div>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	140
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	141	// echo "<p>   <a href=\"/fhiiqm/vertrag_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a></p>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	142	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	143	else
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	144	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	145	// Auswertung Kriterien
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	146	// if ($inf["ityp"]) $ityp = "'" . $inf["ityp"] . "'"; else $ityp = "''";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	147	echo "<span class=\"sc\">";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	148	echo "<br />   <a href=\"/fhiiqm/info_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: 26 diff changeset	149	echo "   \|   <a href=\"" . $_SERVER["PHP_SELF"] . "?r=$report\" target=\"_self\" title=\"Report Info GVP\">neuer Bericht GVP </a></span>\n";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	150	if ($inf['stat'] > -1) // Status Freigabe
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	151	{
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	152	$stat = $inf['stat'];
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	153	$statb = $dbc -> querySingleItem("SELECT info_freigabe_bez FROM Info_Freigabe WHERE info_freigabe_ID=$stat");
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	154	}
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	155	else $stat = "''";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	156	if ($report == 'k')
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	157	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	158	if ($inf["kz"] && $inf["kz"] > "!") $kz = "'".$inf["kz"]."'";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	159	else $kz = "''";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	160	// Parameter: 4:ifotyp=6, 15:Kz, 16:freigabe
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	161	$sql = "CALL info_report(15,'',4,6,15,$kz,16,$stat,0,100,@anz)";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	162
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	163	$result = $dbc ->queryObjectArray($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	164	if ($dbc -> error) echo "$sql<br />".$dbc -> error."<br />";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	165
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	166	if ($kz > "''") $filter = "Filter: [Kennzeichen wie $kz]"; else $filter = "Filter: []";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	167	$kz =" nach Kennzeichen";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	168	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	169	else
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	170	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	171	if ($inf["prodb"] && $inf["prodb"] != '-1')
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	172	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	173	$prodb = $inf["prodb"];
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	174	$sql = "SELECT prod_ber_name FROM Produkt_Bereich WHERE prod_ber_ID = REPLACE('" .$inf["prodb"] ."','\|','')";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	175	$prodbb = $dbc -> querySingleItem($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	176	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	177	else $prodb = "''";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	178	if ($inf["prodg"] && $inf["prodg"] != '-1')
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	179	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	180	$prodg = $inf["prodg"];
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	181	$sql = "SELECT prod_group_name FROM Produkt_Gruppe WHERE prod_group_ID = REPLACE('" .$inf["prodg"] ."','\|','')";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	182	$prodgb = $dbc -> querySingleItem($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	183	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	184	else $prodg = "''";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	185	if ($prodb > "''" && $prodg > "''") $prod = "'" . $prodg . substr($prodb,1) . "'";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	186	elseif ($prodb > "''" && $prodg == "''") $prod = "'" . $prodb . "'";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	187	elseif ($prodb == "''" && $prodg > "''") $prod = "'" . $prodg . "'";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	188	else $prod = "''";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	189
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	190	if ($inf["sort"] && $inf["sort"] != '-1') $sor = $inf["sort"]; else $sor=15;
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	191	// Parameter: 4:ifotyp=6, 5:produkt, 16:freigabe
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	192	// es wird immer nach Kennzeichen Info sortiert
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	193	$sql = "CALL info_report($sor,'',4,6,5,$prod,16,$stat,0,500,@anz)";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	194
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	195	$result = $dbc ->queryObjectArray($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	196	if ($dbc -> error) echo "$sql<br />".$dbc -> error."<br />";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	197	//Filteranzeige
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	198	if ($prodbb && $prodgb)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	199	$filter = "[Produktbereich = $prodbb] UND [Produktgruppe = $prodgb]";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	200	elseif ($prodbb && !$prodgb)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	201	$filter = "[Produktbereich = $prodbb]";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	202	elseif (!$prodbb && $prodgb)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	203	$filter = "[Produktgruppe = $prodgb]";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	204	else $filter = "[]";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	205	$filter = "Filter: $filter";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	206	}
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	207	if ($statb) $filter = ($filter > " ") ? "$filter UND [Status Freigabe = $statb]" : "[Status Freigabe = $statb]";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	208
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	209	echo "<div class='sc' align='center'><h3>Geschäftsverteilungsplan$kz</h3></div>\n"; // Anzeige nur Screen
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	210	echo "<div align='center'>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	211
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	212	// echo "<p>Kriterien: Infotyp wie $ityp, Produktbereich = '" .$prodbb. "', Produktgruppe = '" .$prodgb. "'; Sortierung nach ".$sort[$sor] . " </p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	213
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	214	if ($result)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	215	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	216	echo "<p class='sc'>$filter</p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	217	$ianz = $dbc -> querySingleItem("SELECT @anz");
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	218	echo "<p class='sc'>Anzahl Aufgaben:   $ianz</p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	219
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	220	if ($report == 'k')
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	221	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	222	$start = true;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	223	if (!$start) echo "</table>\n<p style=\"page-break-after:always\"> </p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	224	echo "<div class='pr' align='center'><h3>Geschäftsverteilungsplan nach Kennzeichen</h3></div>\n"; // Anzeige nur im Ausdruck
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	225	echo "<table border='1' cellspacing='0' cellpadding='2' width=99%>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	226	// Listenkopf
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	227	echo "<tr bgcolor='#68ACBF'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	228	echo "<th width='5%'>Kennzeichen</th>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	229	// echo "<th width='10%'>Produktgruppe</th>";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	230	echo "<th width='25%'>Aufgabe (prod)</th>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	231	echo "<th width='35%'>Teilgebiet (kurzinfo)</th>";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	232	echo "<th colspan='2'>Zuständigkeit</th>";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	233	if ($stat == "''") echo "<th>Status</th>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	234
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	235	$bg1 = "#F8F8F8";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	236	$bg2 = "#DEDFE1";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	237	$bg = "#FFFFFF";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	238	foreach ($result as $row)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	239	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	240	//nur jeweils eine Produktzuordnung zu Info
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	241	list($prod,$pg,$pb) = explode ('\|',$row->prod); // prodgroup, prodbereich stehen innerhalb von \|-Zeichen in prod
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	242	if ($pg != $pgv)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	243	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	244	// Produktgruppenname
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	245	$sql = "SELECT prod_group_name FROM Produkt_Gruppe WHERE prod_group_ID IN ($pg)";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	246	$pgb = $dbc -> querySingleItem($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	247	//$start = false;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	248	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	249	if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	250	echo "<tr bgcolor='" . $bg . "'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	251	echo "<td>$row->infsort</td>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	252	// echo "<td>$pgb</td>";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	253	echo "<td>$prod</td>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	254	// echo "<td>$row->iname</td>";
3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	255	echo "<td>".nl2br($row->ilong)."</td>";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	256	if (strtoupper(substr($row->infsort,0,2)) == 'BK' && $row->betrag)
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	257	{
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	258	$colsp="";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	259	$betr = "<td class='right'>max. ".number_format($row->betrag,2,",",".")." €</td>";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	260	}
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	261	else {$colsp = " colspan='2'"; $betr="";}
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	262	echo "<td$colsp>".str_replace(";","<br />",$row->verantw)."</td>";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	263	echo $betr;
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	264	if ($stat == "''") echo "<td>$row->freigabe</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	265	echo "</tr>\n";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	266	$pgv = $pg;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	267	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	268	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	269	else
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	270	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	271	// if ($prodgb) echo "<p><b>$prodgb<b></p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	272	$i=0;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	273	foreach ($result as $row)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	274	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	275	if ($i==0)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	276	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	277	$vprodid = $row->prodid;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	278	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	279	$aprod = explode('; ',$row->prod);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	280	$prod=null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	281	$pg=null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	282	$pb=null;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	283	foreach ($aprod as $eprod)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	284	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	285	list($pro,$prg,$prb) = explode ('\|',$eprod); // prodgroup, prodbereich stehen innerhalb von \|-Zeichen in prod
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	286	$prod .= $pro . "; ";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	287	$pg .= $prg . ",";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	288	$pb .= $prb . ",";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	289	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	290	// es wird angenommen, dass jeweils nur 1 Produkt/Info zugeordnet ist
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	291	$prod = substr($prod,0,strlen($prod)-2);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	292	$pg = substr($pg,0,strlen($pg)-1);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	293	$pb = substr($pb,0,strlen($pb)-1);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	294	//echo "prod = $prod, pg = $pg, pb = $pb <br />";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	295	if ($pb != $vpb)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	296	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	297	$sql = "SELECT prod_ber_name FROM Produkt_Bereich WHERE prod_ber_ID IN ($pb)";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	298	$pberbez = $dbc -> querySingleItem($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	299	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	300	if ($pg != $vpg)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	301	{
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	302	if ($i!=0) echo "</table>\n<p style=\"page-break-after:always\"> </p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	303	echo "<div class='pr' align='center'><h3>Geschäftsverteilungsplan</h3></div>\n"; // Anzeige nur im Ausdruck
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	304	// Produktbereich immer anzeigen
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	305	echo "<p><b>$pberbez</b></p>";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	306	// Produktgruppe fuer Teiliste + Bemerkung
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	307	$sql = "SELECT prod_group_name,IFNULL(prod_group_bem,' ') AS bem FROM Produkt_Gruppe WHERE prod_group_ID IN ($pg)";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	308	$res = $dbc -> queryObjectArray($sql);
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	309	if ($res)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	310	foreach ($res as $ro)
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	311	echo "<p><b>".$ro->prod_group_name."</b></p><p>".$ro->bem."</p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	312
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	313	echo "<table border='1' cellspacing='0' cellpadding='2' width=99%>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	314	// Listenkopf
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	315	echo "<tr bgcolor='#68ACBF'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	316	echo "<th width='5%'>Kennzeichen</th>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	317	// echo "<th>Infotyp</th>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	318	echo "<th width='30%'>Aufgabe (prod)</th>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	319	echo "<th width='30%'>Teilgebiet (kurzinfo)</th>";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	320	// echo "<th width='40%'>Kurzinfo</th>";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	321	echo "<th colspan='2'>Zuständigkeit</th>";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	322	if ($stat == "''") echo "<th>Status</th>";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	323	$bg1 = "#F8F8F8";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	324	$bg2 = "#DEDFE1";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	325	$bg = "#FFFFFF";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	326	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	327	if ($row->prodid != $vprodid && $pg == $vpg) echo "<tr><td colspan='5'> </td></tr>\n"; // Leerzeile
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	328	if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	329	echo "<tr bgcolor='" . $bg . "'>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	330	echo "<td>$row->infsort</td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	331	// echo "<td>$row->ityp</td>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	332	echo "<td>".$prod."</td>";
26 3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	333	// echo "<td>$row->iname</td>";
3c1e3ac7089f + csv-Dateien Laser, Vertrag, Raum Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 25 diff changeset	334	echo "<td>".nl2br($row->ilong)."</td>";
33 f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	335	if (strtoupper(substr($row->infsort,0,2)) == 'BK' && $row->betrag)
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	336	{
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	337	$colsp="";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	338	$betr = "<td class='right'>max. ".number_format($row->betrag,2,",",".")." €</td>";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	339	}
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	340	else {$colsp = " colspan='2'"; $betr="";}
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	341	echo "<td$colsp>".str_replace(";","<br />",$row->verantw)."</td>";
f1a8785434e4 + MA-Telefon-Liste, Edit MA, Telefon Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 29 diff changeset	342	echo $betr;
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	343	if ($stat == "''") echo "<td>$row->freigabe</td>";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	344	echo "</tr>\n";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	345	$vprodid = $row->prodid;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	346	$vpg = $pg;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	347	$vpb = $pb;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	348	$i++;
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	349	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	350	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	351
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	352	echo "</table>\n";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	353
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	354	echo "<p></p><table width=99%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	355	<img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	356
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	357	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	358	else echo "<p class='red'>   Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	359
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	360	echo "</div>\n";
29 72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	361	echo "<span class=\"sc\">";
72f79dab938e + Infotyp 7,8,81, Info-Report, Reports AS, Menu anpassen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 26 diff changeset	362	echo "<br />   <a href=\"/fhiiqm/info_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: 26 diff changeset	363	echo "   \|   <a href=\"" . $_SERVER["PHP_SELF"] . "?r=$report\" target=\"_self\" title=\"Report Info GVP\">neuer Bericht GVP </a></span>\n";
25 482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	364	}
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	365
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	366	?>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	367
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	368	</body>
482252ff12fd + Prozesse edit, Liste; Reports Info, GVP Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	369	</html>

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