<?php
/**
* @author Bettina Schwarzer, Fritz-Haber-Institut
* @copyright 01/2013
*
* Telefonliste als pdf erstellen
*
*/
error_reporting(E_ALL ^ E_NOTICE);
include ($_SERVER['DOCUMENT_ROOT']."/fhiiqm/inc/pdf_ma_tel.inc.php");
include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
$dbc = new dbconnection();
$sub = $_POST['sub'];
$sortp = $_POST['sortp'];
if (!$sortp) $sortp = $_GET['sp'];
$abt = $_POST['abt'];
if (!$abt) $abt = $_GET['a'];
$fmt = $_POST['form'];
if (!fmt) $fmt = $_GET['t'];
$sort = $_GET["s"]; // Sortierung nach Spalte
$dir = $_GET["d"]; // Sortierrichtung
$fnum = $_GET["f"]; // Spaltennummer, nach der aktuell gefiltert wird
$filter = $_GET["b"]; // Filterbegriff
$edit = $_GET["e"]; // Telefonliste editierbar
$getp = "e=$edit&s=$sort&d=$dir&f=$fnum&b=$filter"; // Parameter Listenanzeige Mitarbeiter/Objekte-Telefonliste
if (!$sub)
{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
<title>MA/O-Telefonliste -> PDF</title>
</head>
<body>
<div align="center">
<p><b>PDF: Mitarbeiter/Objekte - Telefonliste</b></p>
<?php
echo "<form action=" . $_SERVER['PHP_SELF'] . " method='post' enctype='application/x-www-form-urlencoded' id='ffilter' name='ffilter' target='_self'>\n";
echo "<table width=\"30%\" border=\"0\">\n";
echo "<tr><td>Format</td>";
echo " <td><select name=\"form\">
<option value=1>normal</option>
<option value=2>small</option>
<option value=3>tiny</option>
<option value=4>new</option>
</select>\n";
echo " </td></tr>\n";
echo "<tr><td>filtern nach Abteilung</td>";
echo " <td valign=\"top\">
<select name=\"abt\">";
echo "<option value=\"-1\"></option>\n";
$sql = "SELECT abt_ID, abt_name, abt_long FROM `fhiiqm`.`Abteilung` ORDER BY abt_ID+0";
if ($result = $dbc->queryObjectArray($sql))
{
foreach ($result as $row)
{
if ($row->abt_ID == $ma['abt'])
echo "<option selected value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
else
echo "<option value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";
}
}
echo " </select></td></tr>\n";
echo "<tr><td>sortieren nach</td>";
echo " <td><select name='sortp'>";
echo " <option value=\"-1\"></option>\n";
echo " <option value='2'>Name</option>\n";
echo " <option value='12'>Abteilung</option>\n";
echo " </select></td></tr>\n";
echo "<tr><td> </td><td><input class=\"button\" type=\"submit\" name=\"sub\" value=\" pdf erstellen \" /></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
echo "</div>\n";
echo "<p><br /><br /> <a href=/fhiiqm/ma_tel_flist.php?$getp>« zur Telefon-Liste</a></p>\n";
echo "</body></html>\n";
}
else
{
if ($fmt == 2 || $fmt == 3) $wher = " WHERE sort=1 "; else $wher = " WHERE 1=1 ";
$sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, geb_ID, raum_nr, email, abt_tel+0
FROM v_tel_list_ma_raum " . $wher;
// intern/extern
$ip=getenv("REMOTE_ADDR");
$ippart=explode(".",$ip);
if (($ippart[0] == 141 && $ippart[1] == 14) || ($ippart[0] == 172 && $ippart[1] == 16))
$wip = "";
else
$wip = " AND public=1 ";
if ($sortp == '2') $sortp = "name COLLATE latin1_general_ci,3,12,5,IFNULL(sort,99),6"; // Name
elseif ($sortp == '12') $sortp = "12,5,name COLLATE latin1_general_ci,3,IFNULL(sort,99),6"; // abt_ID
else $sortp = "name COLLATE latin1_general_ci,3,12,5,IFNULL(sort,99),6";
if ($abt > '-1') $wher = " AND abt_tel = $abt "; else $wher = "";
$sql .= $wher . $wip . " ORDER BY $sortp";
if ($result = $dbc ->queryObjectArray($sql))
{
$pdf = new PDF();
$pdf->SetLeftMargin(25);
if ($fmt == 4)
{
$header=array('Name','Abteilung','Tel/Fax','Raum','E-Mail');
$pdf->anzcol = null;
}
$pdf->AddPage();
$pdf->AliasNbPages(); // Anzahl Seiten
$pdf->Image($_SERVER['DOCUMENT_ROOT']."/fhiiqm/img/tel/tellist_kopf1n.jpg",$pdf->lMargin-20,$pdf->tMargin+17,210);
$pdf->AddPage();
$pdf->Image($_SERVER['DOCUMENT_ROOT']."/fhiiqm/img/tel/tellist_kopf2n.jpg",$pdf->lMargin-20,$pdf->tMargin+14,210);
$pdf->AddPage();
$pdf->Image($_SERVER['DOCUMENT_ROOT']."/fhiiqm/img/tel/tellist_kopf3n.jpg",$pdf->lMargin-20,$pdf->tMargin+14,210);
$pdf->AddPage();
$pdf->Image($_SERVER['DOCUMENT_ROOT']."/fhiiqm/img/tel/tellist_kopf4n.jpg",$pdf->lMargin-20,$pdf->tMargin+14,210);
$pdf->AddPage();
$pdf->height = 3.5;
$pdf->SetFont('times','','');
switch ($fmt)
{
case 1:
$pdf->anzcol = 1;
$pdf->Normal($result);
break;
case 2:
$pdf->xa = $pdf->lMargin;
$pdf->fancy = 0; // mehrspaltig
$pdf->anzcol = 2;
$colwidth = 85;
$pdf->Small($result,$colwidth,$pdf->height);
break;
case 3:
$pdf->xa = $pdf->lMargin;
$pdf->fancy = 0; // mehrspaltig
$pdf->anzcol = 3;
$colwidth = 55;
$pdf->Small($result,$colwidth,$pdf->height);
break;
case 4:
$pdf->fancy = 1; // einspaltig
$pdf->SetFont('helvetica','',9);
$pdf->FancyTable($header,$result);
break;
}
$pdf->Ln();
$pdf->SetDisplayMode('real');
$pdf->Output();
// als Download
// $pdf->Output('ma_tel_list.pdf','D');
}
}
?>