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

13 741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	1	<?php
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	2
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	3	/**
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	4	* @author Bettina Schwarzer, Fritz-Haber-Institut
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	5	* @copyright 08/2011
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	6	*
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	7	* Report Vertrag
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	8	*
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	9	*/
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	10
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	11	error_reporting(E_ALL ^ E_NOTICE);
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	12
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	13	session_start();
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	14	if (! isset($_SESSION["userid"]))
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	15	{
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	16	include_once ($_SERVER["DOCUMENT_ROOT"] . "/fhiiqm/inc/func_lib.inc.php");
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	17	login($_SERVER["PHP_SELF"]);
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	18	exit;
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	19	}
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	20
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	21	if (is_null($_SESSION["recht"]) \|\| (!is_null($_SESSION["recht"]) && !in_array("vr",$_SESSION["recht"]) && !in_array("ve",$_SESSION["recht"])))
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	22	{
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	23	header("Location: /fhiiqm/start.php");
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	24	exit;
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	25	}
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	26	?>
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	27	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	28	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	29
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	30	<head>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	31	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	32	<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	33	<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	34	<title>Bericht Vertrag-Kosten</title>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	35	</head>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	36
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	37	<body >
13 741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	38
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	39	<?php
13 741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	40	echo " ";
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	41	echo "<div class=\"float-br smaller\" valign='top'>";
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	42	echo "   user: " . $_SESSION["userid"];
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	43	echo "   <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	44	echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/document_mark_as_final.png\" border=\"0\" alt=\"Bericht\" title=\"Bericht\"/></div>\n";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	45
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	46	$vr = $_POST["vr"]; // Parameter aus Form
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	47	$create = $_POST["create"];
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	48	$rvnr = 1; // Report-Kz
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	49
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	50	// print_r($vr); echo "<br /><br />";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	51
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	52	echo "<div align='center'><h3>Bericht: Vertrag - Kosten pro Jahr</h3></div>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	53	if (!isset($create) \|\| !$create)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	54	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	55	include($_SERVER["DOCUMENT_ROOT"]. "/fhiiqm/form/vertrag_report_form.inc.php");
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	56	echo "<p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p>";
13 741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	57	echo "<p>   <a href=\"/fhiiqm/vertrag_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a></p>\n";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	58	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	59	else
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	60	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	61	// Kriterien sind klar
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	62	echo "<div align='center'>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	63
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	64	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	65	// include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	66
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	67	$dbc = new dbconnection();
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	68
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	69	$sql1 = "SELECT v.contract_ID,contract_name,contract_l,contract_begin,contract_end,v.vtyp_ID,
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	70	pv.produkt_ID,prod_name,prod_group_ID,kosten,k_year,vtyp_kurz
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	71	FROM fhiiqm.Vertrag v
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	72	LEFT OUTER JOIN fhiiqm.Vertrag_Kosten k ON v.contract_ID=k.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	73	LEFT OUTER JOIN fhiiqm.Produkt_Vertrag pv ON v.contract_ID=pv.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	74	LEFT OUTER JOIN fhiiqm.Produkt p ON pv.produkt_ID=p.produkt_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	75	LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID ";
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	76	// WHERE (contract_end IS NULL OR YEAR(contract_end)>=YEAR(Current_Date()))";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	77
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	78	$sql2 = "SELECT SUM(kosten) AS sumkosten, k_year
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	79	FROM fhiiqm.Vertrag v
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	80	LEFT OUTER JOIN fhiiqm.Vertrag_Kosten k ON v.contract_ID=k.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	81	LEFT OUTER JOIN fhiiqm.Produkt_Vertrag pv ON v.contract_ID=pv.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	82	LEFT OUTER JOIN fhiiqm.Produkt p ON pv.produkt_ID=p.produkt_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	83	LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID ";
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	84
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	85
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	86	$sql3 = "SELECT COUNT(DISTINCT v.contract_ID) AS anzv
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	87	FROM fhiiqm.Vertrag v
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	88	LEFT OUTER JOIN fhiiqm.Vertrag_Kosten k ON v.contract_ID=k.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	89	LEFT OUTER JOIN fhiiqm.Produkt_Vertrag pv ON v.contract_ID=pv.contract_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	90	LEFT OUTER JOIN fhiiqm.Produkt p ON pv.produkt_ID=p.produkt_ID
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	91	LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID ";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	92
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	93	if (!$vr["bind"]) $bind = " AND "; else $bind = $vr["bind"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	94
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	95	if ($vr["prodg"]> -1)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	96	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	97	if ($where) $where .= " $bind prod_group_ID = $vr[prodg] "; else $where = " prod_group_ID = $vr[prodg] ";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	98
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	99	if ($krit) $bd = " ".$bind; else $bd = "";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	100	$sql = "SELECT prod_group_name FROM Produkt_Gruppe WHERE prod_group_ID = " . $vr["prodg"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	101	$res = $dbc -> querySingleItem($sql);
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	102	$krit .= $bd." [Produktgruppe = '$res']";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	103	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	104	if ($vr["prod"]> -1)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	105	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	106	if ($where) $where .= " $bind pv.produkt_ID= $vr[prod] "; else $where = " pv.produkt_ID= $vr[prod] ";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	107
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	108	if ($krit) $bd = " ".$bind; else $bd = "";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	109	$sql = "SELECT prod_name FROM Produkt WHERE produkt_ID = " . $vr["prod"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	110	$res = $dbc -> querySingleItem($sql);
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	111	$krit .= $bd. " [Produkt = '$res']";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	112	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	113	if ($vr["vtyp"]> -1)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	114	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	115	if ($where) $where .= " $bind v.vtyp_ID = $vr[vtyp] "; else $where = " v.vtyp_ID = $vr[vtyp] ";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	116
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	117	if ($krit) $bd = " ".$bind; else $bd = "";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	118	$sql = "SELECT vtyp_bezeichnung FROM Vertrag_Typ WHERE vtyp_ID = " . $vr["vtyp"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	119	$res = $dbc -> querySingleItem($sql);
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	120	$krit .= $bd." [Vertragtyp = '$res']";
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	121	}
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	122	if ($vr["jahr"]> -1)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	123	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	124	if ($where) $where .= " $bind k_year = $vr[jahr] "; else $where = " k_year = $vr[jahr] ";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	125	// $hav = " HAVING k_year = $vr[jahr]";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	126
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	127	if ($krit) $bd = " ".$bind; else $bd = "";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	128	$krit .= $bd." [Kostenjahr = '" . $vr["jahr"] ."']";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	129	}
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	130	if ($where) $where = " WHERE $where";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	131
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	132	if ($vr["sort1"]>0 \|\| $rag["sort2"]>0)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	133	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	134	if ($vr["sort1"]>0) $ord = " ORDER BY " . $vr["sort1"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	135	if ($vr["sort2"]>0) $ord .= ",".$vr["sort2"];
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	136	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	137
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	138	$sql1 .= $where . $ord;
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	139	// echo "<br /><br />sql1 = $sql1<br /><br />\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	140	$result = $dbc ->queryObjectArray($sql1);
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	141	if ($dbc->error) echo $dbc->error . "<br />";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	142	if ($krit )echo "<p>Filter: $krit</p>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	143
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	144	if ($result)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	145	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	146	$bg1 = "#F8F8F8";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	147	$bg2 = "#DEDFE1";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	148	$bg = "#FFFFFF";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	149	echo "<table border='1' cellspacing='0' cellpadding='2' width=65%>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	150	// Listenkopf
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	151	echo "<tr bgcolor='#68ACBF'>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	152	echo "<th width='25%'>Bezeichnung</th>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	153	echo "<th width='40%'>Beschreibung</th>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	154	echo "<th width='3%'>Typ</th>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	155	echo "<th width='15%'>zu Produkt</th>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	156	echo "<th width='12%'>Kosten (€)</th>";
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	157	echo "<th width='5%'>Jahr</th></tr>\n";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	158
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	159
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	160	foreach ($result as $row)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	161	{
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	162	if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	163	echo "<tr bgcolor='" . $bg . "'>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	164	echo "<td>$row->contract_name</td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	165	echo "<td>$row->contract_l</td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	166	echo "<td>$row->vtyp_kurz</td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	167	echo "<td>$row->prod_name</td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	168	echo "<td class='right'>". number_format($row->kosten,2,",",".") ."</td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	169	echo "<td class='center'>$row->k_year</td></tr>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	170	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	171
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	172	// Summe Kosten
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	173	$sql2 .= $where . " GROUP BY k_year";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	174	// echo "<br /><br />sql2 = $sql2<br /><br />\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	175	$result = $dbc ->queryObjectArray($sql2);
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	176	if ($dbc->error) echo $dbc->error . "<br />";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	177	if ($result)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	178	{
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	179	// Anzahl gefilterter Vertraege
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	180	if ($where) $sql3 .= " $where";
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	181	// echo "sql3 = $sql3<br /><br />";
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	182	$rc = $dbc -> querySingleItem($sql3);
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	183	$i = 0;
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	184	foreach ($result as $row)
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	185	{
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	186	if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	187	echo "<tr bgcolor='" . $bg . "'>";
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	188	if ($rc && $i == 0)
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	189	echo "<td colspan='3'><b>Anzahl Verträge:   $rc</b></td>";
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	190	else
2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	191	echo "<td colspan='3'> </td>";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	192	echo "<td><b>∑ Kosten</b></td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	193	echo "<td class='right'><b>". number_format($row->sumkosten,2,",",".") ."</b></td>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	194	echo "<td class='center'><b>$row->k_year</b></td></tr>\n";
12 2d8be944f381 + Report Vertrag - Kuendigungstermin, Korrekturen Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 11 diff changeset	195	$i++;
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	196	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	197	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	198
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	199	echo "</table>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	200
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	201	echo "<p></p><table width=65%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	202	<img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	203
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	204	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	205	else echo "<p class='red'>   Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	206
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	207	echo "</div>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	208	echo "<br /><br />   <a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\"
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	209	title=\"Report Vertrag-Kosten\" class=\"sc\">neuer Bericht Vertrag - Kosten</a></p>\n";
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	210
13 741b35e9ebbe Rechteverwaltung I Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: 12 diff changeset	211	echo "<p>   <a href=\"/fhiiqm/vertrag_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>« zur Berichtsübersicht</a></p>\n";
11 245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	212	}
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	213
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	214	?>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	215
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	216	</body>
245f994f8fa0 + Report Vertrag Bettina Schwarzer <schwarzer@fhi-berlin.mpg.de> parents: diff changeset	217	</html>

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