fhiiqm/ma_tel_pdf.php
changeset 34 fc60ef80a7ad
parent 33 f1a8785434e4
--- 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');