'; ?>
wfs_edit
WFS Configuration
new Configuration
Select WFS Configuration:
".$_REQUEST["f_geom"].";"; $res = db_query($sql); $sql = "UPDATE wfs_conf_element SET "; $sql .= "f_gid = 1"; $sql .= " WHERE fkey_wfs_conf_id = ".$_REQUEST["gaz"]." AND f_id = ".$_REQUEST["f_gid"].";"; $res = db_query($sql); $sql = "UPDATE wfs_conf_element SET "; $sql .= "f_gid = 0"; $sql .= " WHERE fkey_wfs_conf_id = ".$_REQUEST["gaz"]." AND f_id <> ".$_REQUEST["f_gid"].";"; $res = db_query($sql); for($i=0; $i<$_REQUEST["num"]; $i++){ $sql = "UPDATE wfs_conf_element SET "; $sql .= "f_search = '"; if(!empty($_REQUEST["f_search".$i])){ $sql .= '1'; }else{$sql .= '0';} $sql .= "',"; $sql .= "f_pos = '".$_REQUEST["f_pos".$i]."',"; $sql .= "f_style_id = '".$_REQUEST["f_style_id".$i]."',"; $sql .= "f_toupper = '" ; if(!empty($_REQUEST["f_toupper".$i])){ $sql .= '1'; }else{$sql .= '0';} $sql .= "',"; $sql .= "f_label = '".$_REQUEST["f_label".$i]."',"; $sql .= "f_label_id = '".$_REQUEST["f_label_id".$i]."',"; $sql .= "f_show = '"; if(!empty($_REQUEST["f_show".$i])){ $sql .= '1'; }else{$sql .= '0';} $sql .= "',"; $sql .= "f_respos = '".$_REQUEST["f_respos".$i]."' "; $sql .= ","; $sql .= "f_edit = '"; if(!empty($_REQUEST["f_edit".$i])){ $sql .= '1'; }else{$sql .= '0';} $sql .= "',"; $sql .= "f_form_element_html = '".addslashes($_REQUEST["f_form_element_html".$i]); $sql .= "',"; $sql .= "f_mandatory = '"; if(!empty($_REQUEST["f_mandatory".$i])){ $sql .= '1'; }else{$sql .= '0';} $sql .= "' "; $sql .= " WHERE fkey_wfs_conf_id = ".$_REQUEST["gaz"]." AND f_id = ".$_REQUEST["f_id".$i].";"; $res = db_query($sql); } } /* end save wfs_conf properties */ /* select wfs */ $sql = "SELECT * FROM wfs_conf"; $res = db_query($sql); echo "
"; $cnt = 0; while($row = db_fetch_array($res)){ echo "
".$row["wfs_conf_id"]." ".$row["wfs_conf_abstract"]."
"; $cnt++; } echo "
"; /* end select wfs */ /* configure elements */ if(isset($_REQUEST["gaz"])){ $sql = "SELECT * FROM wfs_conf WHERE wfs_conf_id = ".$_REQUEST["gaz"]; $res = db_query($sql); if($row = db_fetch_array($res)){ echo "
"; echo "
GazetterID:
".$row["wfs_conf_id"]."
" ; echo "
Abstract:
" ; echo "
Label:
" ; echo "
Label_id:
" ; echo "
Button:
" ; echo "
Button_id:
" ; echo "
Style:
".$row["g_style"]."
" ; echo "
Buffer:
" ; echo "
ResultStyle:
".$row["g_res_style"]."
" ; echo "
WZ-Graphics:
"; echo "
"; } /* set element options */ $sql = "SELECT * FROM wfs_conf_element "; $sql .= "JOIN wfs_element ON wfs_conf_element.f_id = wfs_element.element_id "; $sql .= "WHERE fkey_wfs_conf_id = ".$_REQUEST["gaz"]; $res = db_query($sql); echo "
"; echo "
"; echo "
ID
"; echo "
name
"; echo "
type
"; echo "
geom
"; echo "
gid
"; echo "
search
"; echo "
pos
"; echo "
style_id
"; echo "
upper
"; echo "
label
"; echo "
label_id
"; echo "
show
"; echo "
position
"; echo "
mandatory
"; echo "
edit
"; echo "
html
"; echo "
"; $cnt = 0; while($row = db_fetch_array($res)){ echo "
"; echo "
"; echo "
".$row["element_name"]."
"; echo "
".$row["element_type"]."
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
".$row["f_form_element_html"]."
"; echo "
"; $cnt++; } echo "
"; echo "
"; echo "
"; } /* end configure elements */ ?>