[prev in list] [next in list] [prev in thread] [next in thread]
List: mapbender-commits
Subject: [Mapbender-commits] r1147 - trunk/mapbender/http/php
From: svn_mapbender () osgeo ! org (svn_mapbender () osgeo ! org)
Date: 2007-02-27 8:21:24
Message-ID: 20070227132123.B68A9329800B () lists ! osgeo ! org
[Download RAW message or body]
Author: christoph
Date: 2007-02-27 08:21:22 -0500 (Tue, 27 Feb 2007)
New Revision: 1147
Modified:
trunk/mapbender/http/php/mod_filteredGroup_filteredGui.php
Log:
fixed bug
1653348 mod_filteredGroup_filteredGui.php
Modified: trunk/mapbender/http/php/mod_filteredGroup_filteredGui.php
===================================================================
--- trunk/mapbender/http/php/mod_filteredGroup_filteredGui.php 2007-02-26 13:16:10 \
UTC (rev 1146)
+++ trunk/mapbender/http/php/mod_filteredGroup_filteredGui.php 2007-02-27 13:21:22 \
UTC (rev 1147) @@ -142,86 +142,93 @@
$cnt_group++;
}
-/*get allocated gui from \
selected_group******************************************************************************/
-$arrayGuis=mb_getGUIs($logged_user_id);
-$v = array();
-$t = array();
-$sql_group_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_group.fkey_mb_group_id \
FROM gui_mb_group ";
-$sql_group_mb_gui .= " JOIN gui ON gui_mb_group.fkey_gui_id = gui.gui_id ";
-$sql_group_mb_gui .= "WHERE gui_mb_group.fkey_mb_group_id = $1 ";
-if(!$selected_group){
- if($group_id[0] > 0){
- array_push($v,$group_id[0]);
- array_push($t,'i');
+if ($cnt_group > 0) {
+
+ /*get allocated gui from \
selected_group******************************************************************************/
+ $arrayGuis=mb_getGUIs($logged_user_id);
+ $v = array();
+ $t = array();
+ $sql_group_mb_gui = "SELECT gui.gui_id, gui.gui_name, gui_mb_group.fkey_mb_group_id \
FROM gui_mb_group "; + $sql_group_mb_gui .= " JOIN gui ON gui_mb_group.fkey_gui_id = \
gui.gui_id "; + $sql_group_mb_gui .= "WHERE gui_mb_group.fkey_mb_group_id = $1 ";
+ if(!$selected_group){
+ if($group_id[0] > 0){
+ array_push($v,$group_id[0]);
+ array_push($t,'i');
+ }
+ else{
+ array_push($v, "NULL");
+ array_push($t,'i');
+ }
}
- else{
- array_push($v, "NULL");
+ else if($selected_group){
+ array_push($v,$selected_group);
array_push($t,'i');
}
-}
-else if($selected_group){
- array_push($v,$selected_group);
- array_push($t,'i');
-}
-$sql_group_mb_gui .= " AND gui.gui_id IN (";
-$c = 2;
-for($i=0; $i<count($arrayGuis); $i++){
- if($i>0){ $sql_group_mb_gui .= ",";}
- $sql_group_mb_gui .= "$".$c;
- array_push($v,$arrayGuis[$i]);
- array_push($t,'s');
- $c++;
-}
-$sql_group_mb_gui .= ") ORDER BY gui.gui_name";
+ $sql_group_mb_gui .= " AND gui.gui_id IN (";
+ $c = 2;
+ for($i=0; $i<count($arrayGuis); $i++){
+ if($i>0){ $sql_group_mb_gui .= ",";}
+ $sql_group_mb_gui .= "$".$c;
+ array_push($v,$arrayGuis[$i]);
+ array_push($t,'s');
+ $c++;
+ }
+ $sql_group_mb_gui .= ") ORDER BY gui.gui_name";
+
+ $res_group_mb_gui = db_prep_query($sql_group_mb_gui,$v,$t);
+ while($row = db_fetch_array($res_group_mb_gui)){
+ $gui_id_group[$cnt_gui_group] = $row["gui_id"];
+ $gui_name_group[$cnt_gui_group] = $row["gui_name"];
+ $cnt_gui_group++;
+ }
-$res_group_mb_gui = db_prep_query($sql_group_mb_gui,$v,$t);
-while($row = db_fetch_array($res_group_mb_gui)){
- $gui_id_group[$cnt_gui_group] = $row["gui_id"];
- $gui_name_group[$cnt_gui_group] = $row["gui_name"];
- $cnt_gui_group++;
-}
-
-/*INSERT HTML*/
-echo "<form name='form1' action='" . $self ."' method='post'>";
-
-/*insert all group in \
selectbox********************************************************************/
-echo "<div class='text1'>GROUP: </div>";
-echo "<select style='background:#ffffff' class='select1' name='selected_group' \
onChange='submit()' size='10'>";
-for($i=0; $i<$cnt_group; $i++){
- echo "<option value='" . $group_id[$i] . "' ";
- if($selected_group && $selected_group == $group_id[$i]){
- echo "selected";
+ /*INSERT HTML*/
+ echo "<form name='form1' action='" . $self ."' method='post'>";
+
+ /*insert all group in \
selectbox********************************************************************/ + echo \
"<div class='text1'>GROUP: </div>"; + echo "<select style='background:#ffffff' \
class='select1' name='selected_group' onChange='submit()' size='10'>"; + for($i=0; \
$i<$cnt_group; $i++){ + echo "<option value='" . $group_id[$i] . "' ";
+ if($selected_group && $selected_group == $group_id[$i]){
+ echo "selected";
+ }
+ echo ">" . $group_name[$i] . "</option>";
}
- echo ">" . $group_name[$i] . "</option>";
+ echo "</select>";
+
+ /*insert all gui in \
selectbox**********************************************************************/ \
+ echo "<div class='text2'>GUI:</div>"; + echo "<select style='background:#ffffff' \
class='select2' multiple='multiple' name='selected_gui[]' size='$fieldHeight' >"; \
+ for($i=0; $i<$cnt_gui; $i++){ + echo "<option value='" . $gui_id_array[$i] . "'>" \
. $gui_name[$i] . "</option>"; + }
+ echo "</select>";
+
+ /*Button*******************************************************************************************/
+
+ echo "<div class='button1'><input type='button' value='==>' \
onClick='validate(\"insert\")'></div>"; + echo "<input type='hidden' name='insert'>";
+
+ echo "<div class='button2'><input type='button' value='<==' \
onClick='validate(\"remove\")'></div>"; + echo "<input type='hidden' name='remove'>";
+
+ /*insert group_gui_dependence in \
selectbox*********************************************************/ + echo "<div \
class='text3'>SELECTED GUI:</div>"; + echo "<select style='background:#ffffff' \
class='select3' multiple='multiple' name='remove_gui[]' size='$fieldHeight' >"; \
+ for($i=0; $i<$cnt_gui_group; $i++){ + echo "<option value='" . $gui_id_group[$i] \
. "'>" . $gui_name_group[$i] . "</option>"; + }
+ echo "</select>";
+
+ echo "</form>";
}
-echo "</select>";
-
-/*insert all gui in \
selectbox**********************************************************************/
-echo "<div class='text2'>GUI:</div>";
-echo "<select style='background:#ffffff' class='select2' multiple='multiple' \
name='selected_gui[]' size='$fieldHeight' >";
-for($i=0; $i<$cnt_gui; $i++){
- echo "<option value='" . $gui_id_array[$i] . "'>" . $gui_name[$i] . "</option>";
+else {
+ echo "<div class = 'text3'>There are no groups available for this user.</div>";
}
-echo "</select>";
-/*Button*******************************************************************************************/
-echo "<div class='button1'><input type='button' value='==>' \
onClick='validate(\"insert\")'></div>";
-echo "<input type='hidden' name='insert'>";
-
-echo "<div class='button2'><input type='button' value='<==' \
onClick='validate(\"remove\")'></div>";
-echo "<input type='hidden' name='remove'>";
-
-/*insert group_gui_dependence in \
selectbox*********************************************************/
-echo "<div class='text3'>SELECTED GUI:</div>";
-echo "<select style='background:#ffffff' class='select3' multiple='multiple' \
name='remove_gui[]' size='$fieldHeight' >";
-for($i=0; $i<$cnt_gui_group; $i++){
- echo "<option value='" . $gui_id_group[$i] . "'>" . $gui_name_group[$i] . \
"</option>";
-}
-echo "</select>";
-
-echo "</form>";
-
?>
<script type="text/javascript">
<!--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic