1) { $sql_gui .= ","; } $sql_gui .= "$" . $i; array_push($t, "s"); } $sql_gui.= ") ORDER BY gui_name"; $res_gui = db_prep_query($sql_gui, $v, $t); while($row = db_fetch_array($res_gui)){ $gui_id[$cnt_gui] = $row["gui_id"]; $gui_name[$cnt_gui] = $row["gui_name"]; $gui_description[$cnt_gui] = $row["gui_description"]; #echo"$gui_name[$cnt_gui]"; $cnt_gui++; } /*get allocated gui ********************************************************************************************/ /*get allocated wms from allocated gui ********************************************************************************************/ $sql_gui_wms = "SELECT DISTINCT fkey_wms_id, fkey_gui_id FROM gui_wms WHERE fkey_gui_id IN ("; $v = $arrayGuis; $t = array(); for ($i = 1; $i <= count($arrayGuis); $i++) { if ($i > 1) { $sql_gui_wms .= ","; } $sql_gui_wms .= "$".$i; array_push($t, "s"); } $sql_gui_wms.= ") ORDER BY fkey_wms_id"; $res_gui_wms = db_prep_query($sql_gui_wms, $v, $t); while($row = db_fetch_array($res_gui_wms)){ $fkey_gui_id[$cnt_gui_wms] = $row["fkey_gui_id"]; $fkey_wms_id[$cnt_gui_wms] = $row["fkey_wms_id"]; $cnt_gui_wms++; } /*get allocated wms from allocated gui ********************************************************************************************/ /*get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/ $sql_wms = "SELECT DISTINCT wms_title, wms_abstract, wms_getcapabilities, wms_version FROM wms WHERE wms_id IN ("; $v = $fkey_wms_id; $t = array(); for ($i = 1; $i <= count($fkey_wms_id); $i++){ if ($i > 1) { $sql_wms .= ","; } $sql_wms .= "$" . $i; array_push($t, "s"); } $sql_wms.= ") ORDER BY wms_title"; $res_wms = db_prep_query($sql_wms, $v, $t); while($row = db_fetch_array($res_wms)){ $wms_title[$cnt_wms] = $row["wms_title"]; $wms_abstract[$cnt_wms] = $row["wms_abstract"]; $wms_getcapabilities[$cnt_wms] = $row["wms_getcapabilities"]; $wms_version[$cnt_wms] = $row["wms_version"]; $cnt_wms++; } /*get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/ /*INSERT HTML*/ echo "
"; if (empty($wms_show)){ #gui echo $selectGuiText; echo"
"; echo"
"; echo ""; echo " "; echo ""; echo " "; echo " "; for($i=0; $i<$cnt_gui; $i++){ echo ""; echo ""; echo ""; echo ""; } echo " "; echo "
".$guiNameText."".$guiAbstractText."
".$gui_name[$i]."
".$gui_description[$i]."
"; } else { echo ""; /*get group gui WMS ********************************************************************************************/ $sql_fkey_show_gui_wms = "SELECT DISTINCT fkey_wms_id, fkey_gui_id FROM gui_wms WHERE fkey_gui_id = $1"; #$sql_fkey_show_gui_wms.= ") ORDER BY fkey_wms_id"; $v = array($wms_show); $t = array("s"); $res_fkey_show_gui_wms = db_prep_query($sql_fkey_show_gui_wms, $v, $t); while($row = db_fetch_array($res_fkey_show_gui_wms)){ $fkey_show_gui_gui_id[$cnt_fkey_show_gui_wms] = $row["fkey_gui_id"]; $fkey_show_gui_wms_id[$cnt_fkey_show_gui_wms] = $row["fkey_wms_id"]; #echo"$fkey_show_gui_wms_id[$cnt_fkey_show_gui_wms]"; $cnt_fkey_show_gui_wms++; } /*get group gui WMS ********************************************************************************************/ /*gui: get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/ if(count($fkey_show_gui_wms_id)>0){ $sql_show_gui_wms = "SELECT DISTINCT wms_title, wms_abstract, wms_getcapabilities, wms_id, wms_version FROM wms WHERE wms_id IN ("; $v = $fkey_show_gui_wms_id; $t = array(); for ($i = 1; $i <= count($fkey_show_gui_wms_id); $i++){ if ($i > 1) { $sql_show_gui_wms .= ","; } $sql_show_gui_wms .= "$".$i; array_push($t, "s"); } $sql_show_gui_wms.= ") ORDER BY wms_title"; $res_show_gui_wms = db_prep_query($sql_show_gui_wms, $v, $t); while($row = db_fetch_array($res_show_gui_wms)){ $gui_wms_id[$cnt_show_gui_wms] = $row["wms_id"]; $gui_wms_title[$cnt_show_gui_wms] = $row["wms_title"]; $gui_wms_abstract[$cnt_show_gui_wms] = $row["wms_abstract"]; $gui_wms_getcapabilities[$cnt_show_gui_wms] = $row["wms_getcapabilities"]; $gui_wms_version[$cnt_show_gui_wms] = $row["wms_version"]; #echo"$gui_wms_title[$cnt_show_gui_wms]"; $cnt_show_gui_wms++; } /*gui: get allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/ /*table with allocated wms-Abstract and wms-Capabilities from allocated gui ********************************************************************************************/ #if (isset($cnt_show_gui_wms > 0)) } if ($cnt_show_gui_wms > 0){ /*get selected gui name for table caption ********************************************************************************************/ $sql_gui_table = "SELECT * FROM gui WHERE gui_id = $1"; $v = array($wms_show); $t = array("s"); $res_gui_table = db_prep_query($sql_gui_table, $v, $t); while($row = db_fetch_array($res_gui_table)){ $gui_id_table[$cnt_gui_table] = $row["gui_id"]; $gui_name_table[$cnt_gui_table] = $row["gui_name"]; $cnt_gui_table++; #echo"$gui_id_table[0]"; } /*get selected gui name for table caption ********************************************************************************************/ echo"
"; echo"
"; echo $selectWmsText . " " . $gui_name_table[0]; echo"
"; echo"
"; echo ""; echo " "; echo ""; echo " "; echo " "; for($i=0; $i<$cnt_show_gui_wms; $i++){ echo ""; echo ""; echo ""; echo ""; } echo " "; echo "
".$wmsTitleText."".$wmsAbstractText."
".$gui_wms_title[$i]."
".$gui_wms_abstract[$i]."
"; } else{ echo"
"; echo"
"; echo"
"; echo "no wms in this gui"; } } echo ""; echo ""; echo ""; echo "
"; ?>