--- a/fhiiqm/ma_tel_pdf.php Fri Dec 21 15:31:50 2012 +0100
+++ b/fhiiqm/ma_tel_pdf.php Wed Feb 27 09:43:08 2013 +0100
@@ -76,9 +76,9 @@
{
$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 ";
- if ($sortp == '2') $sortp = "name COLLATE latin1_general_ci,3,12,5,6"; // Name
- elseif ($sortp == '12') $sortp = "12,5,name COLLATE latin1_general_ci,3,6"; // abt_ID
- else $sortp = "name COLLATE latin1_general_ci,3,12,5,6";
+ 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 = " WHERE abt_tel = $abt "; else $wher = "";
@@ -89,8 +89,9 @@
$pdf = new PDF();
$pdf->SetLeftMargin(25);
$pdf->AddPage();
- $pdf->AliasNbPages();
+ $pdf->AliasNbPages(); // Anzahl Seiten
$pdf->SetFont('helvetica','',9);
+// $pdf->SetFont('times','',8);
$pdf->FancyTable($header,$result);
$pdf->SetDisplayMode('real');