[Mapbender-commits] r8676 - trunk/mapbender/http/plugins

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2013-07-24 01:49:26 -0700 (Wed, 24 Jul 2013)
New Revision: 8676

Modified:
   trunk/mapbender/http/plugins/mb_extendedSearch_server.php
Log:
Change order of group list in extented search to upper(mb_group_name)

Modified: trunk/mapbender/http/plugins/mb_extendedSearch_server.php
===================================================================
--- trunk/mapbender/http/plugins/mb_extendedSearch_server.php	2013-07-18 03:56:45 UTC (rev 8675)
+++ trunk/mapbender/http/plugins/mb_extendedSearch_server.php	2013-07-24 08:49:26 UTC (rev 8676)
@@ -181,7 +181,7 @@
 	$entries['group_name'] = array();
 	$entries['group_title'] = array();
 
-	$sql= "SELECT mb_group_id, mb_group_name, mb_group_title from registrating_groups LEFT OUTER JOIN mb_group ON (mb_group_id=fkey_mb_group_id)  GROUP BY mb_group_id, mb_group_name, mb_group_title ORDER BY mb_group_name";
+	$sql= "SELECT mb_group_id, mb_group_name, UPPER(mb_group_name) as upper_group_name,mb_group_title from registrating_groups LEFT OUTER JOIN mb_group ON (mb_group_id=fkey_mb_group_id)  GROUP BY mb_group_id, mb_group_name, mb_group_title ORDER BY upper_group_name";
 	$res = pg_query($sql);
 	while($row = db_fetch_array($res)){
 		array_push($entries['user_department'], $row['mb_group_id']);