Changeset 135

Timestamp:

12/02/11 15:15:59 (11 years ago)

Author:

astrid.emde

Message:

Umstellung auf Suche in der Art:

Nachname
Nachname, Vorname
Nachna*
Doppel-Name, Vor*
Nachname, Zwei Vornamen
Nachname, Doppel-Vorname

File:

• trunk/data/mapbender/http/nav/alkisnav_eig.php (modified) (2 diffs)

trunk/data/mapbender/http/nav/alkisnav_eig.php

@@ -41 +41 @@
         global $gkz, $gemeinde, $epsg, $con, $name, $person, $gb;
         $linelimit=120;
-        $arr = explode(" ", $name);
+        $arr = explode(",", $name);
         $name0 = trim($arr[0]);
         $name1 = trim($arr[1]);
@@ -54 +54 @@
         } else {
                 $match1 = trim($name1)."%";
-        }       
+        }               
+        
         $sql ="SELECT p.nachnameoderfirma, p.vorname, p.gml_id FROM ax_person as p ";
         if($match1 != '%'){
-                $sql.="WHERE p.vorname ILIKE $1 AND nachnameoderfirma ILIKE $2 ";               
+                $sql.="WHERE nachnameoderfirma ILIKE $1 AND p.vorname ILIKE $2 ";               
                 $sql.="ORDER BY p.nachnameoderfirma, p.vorname LIMIT $3 ;";
                 $v=array($match, $match1, $linelimit);