--- /dev/null
+<?php\r
+require_once("../path_index.php");\r
+\r
+//echo("called");\r
+$s=$_GET['s'];\r
+$userid=$_GET['userid'];\r
+$lon=$_GET['lon'];\r
+$lat=$_GET['lat'];\r
+$fields=$_GET['fields'];\r
+//$current_sld=$_GET['sld'];\r
+//$sld_dir = DIR_PLATFORM."/edit_wp5/geo/sld"; \r
+//updated by ftheeten 26/02/2010 -> corrected by ftheeten 03/03/2010 ('$sld_file' shouldn't appear in the path)\r
+//$sld_dir=DIR_PLATFORM."/synthesys/www/fitxers/sld_mapviewer/$sld_file";\r
+//$sld_dir=DIR_PLATFORM."/synthesys/www/fitxers/sld_mapviewer";\r
+$sld_dir=SLD_DIR;\r
+$sld_file=md5($_SERVER["REQUEST_URI"] ).".sld";\r
+$sld_sp_file=md5($_SERVER["REQUEST_URI"] )."_sp.sld";\r
+$sld_fourth_file=md5($_SERVER["REQUEST_URI"] )."_fourth.sld";\r
+\r
+$e = dir($sld_dir);\r
+$time=time();\r
+while($entry = $e->read()) { \r
+ if ($entry!= "." && $entry!= "..") { \r
+\r
+ $f_last_modified = filemtime($sld_dir."/".$entry);\r
+\r
+if ($time-$f_last_modified >400000)\r
+{\r
+unlink($sld_dir."/".$entry);\r
+} \r
+\r
+ } \r
+} \r
+$e->close();\r
+\r
+if (!is_numeric($lat) || !is_numeric($lon) || !is_numeric($fields))\r
+ {\r
+ die ("You are using letters instead of numbers!");\r
+ }\r
+ $new_data=$_GET['new_data'];\r
+\r
+// $sld_file=$current_sld;\r
+\r
+\r
+ $error = "";\r
+ $msg = "";\r
+ $fileElementName = 'file';\r
+ if (isset($_POST['fileframe'])) \r
+ {\r
+ $filename = $_FILES['file']['name'];\r
+// echo $filename;\r
+ }\r
+ if(!empty($_FILES[$fileElementName]['error']))\r
+ {\r
+ switch($_FILES[$fileElementName]['error'])\r
+ {\r
+\r
+ case '1':\r
+ $error = 'The uploaded file exceeds the upload_max_filesize directive in php.ini';\r
+ break;\r
+ case '2':\r
+ $error = 'The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form';\r
+ break;\r
+ case '3':\r
+ $error = 'The uploaded file was only partially uploaded';\r
+ break;\r
+ case '4':\r
+ $error = 'No file was uploaded.';\r
+ break;\r
+\r
+ case '6':\r
+ $error = 'Missing a temporary folder';\r
+ break;\r
+ case '7':\r
+ $error = 'Failed to write file to disk';\r
+ break;\r
+ case '8':\r
+ $error = 'File upload stopped by extension';\r
+ break;\r
+ case '999':\r
+ default:\r
+ $error = 'No error code avaiable';\r
+ }\r
+ }elseif(empty($_FILES['file']['tmp_name']) || $_FILES['file']['tmp_name'] == 'none')\r
+ {\r
+ $error = 'No file was uploaded..';\r
+ }else \r
+ {\r
+\r
+ \r
+ $tf = $upload_dir.'/'.md5(rand()).".test";\r
+\r
+ //move_uploaded_file($_FILES["file"]["tmp_name"],DIR_PLATFORM."/edit_wp5/geo/loaded_CSVs/" . $_FILES["file"]["name"]);\r
+ move_uploaded_file($_FILES["file"]["tmp_name"],UPLOAD_DIR. $_FILES["file"]["name"]);\r
+\r
+ $msg .= " File Name: " . $_FILES["file"]["tmp_name"]. ", ";\r
+ $msg .= " File Size: " . @filesize($_FILES['file']['tmp_name']);\r
+\r
+ //$msg .= "Stored in: " . DIR_PLATFORM."/edit_wp5/geo/loaded_CSVs/".$_FILES["file"]["name"];\r
+ //$path=DIR_PLATFORM."/edit_wp5/geo/loaded_CSVs/".$_FILES["file"]["name"];\r
+ $msg .= "Stored in: " . UPLOAD_DIR.$_FILES["file"]["name"];\r
+ $path=UPLOAD_DIR.$_FILES["file"]["name"];\r
+ //chmod added by ftheeten 25/02/2009\r
+ chmod($path,0755);\r
+ \r
+\r
+// $sld_file=$userid.".sld"; \r
+ \r
+\r
+ //$conn = pg_connect("host=localhost port=5432 password=postgres user=postgres dbname=geoest");\r
+ $conn = pg_connect(POSTGIS_CS);\r
+ if (pg_ErrorMessage($conn)) { \r
+ echo "<p><b>Ocurrio un error conectando a la base de datos: .</b></p>"; \r
+ }\r
+ else {\r
+\r
+ global $sld_file,$sld_sp_file,$sld_fourth_file,$conn;\r
+ $time=time();\r
+ //3 hores?\r
+ $maxtime=time()+3600;\r
+ //$total=$upload_dir.'/'.$filename;\r
+$inserta="SET CLIENT_ENCODING TO 'LATIN1';select * from edit_import_csv ('$path','$fields','$lon','$lat',4326,',','$userid',current_date::timestamp);insert into user_table values ('$userid','$sessionid',current_date::timestamp,'$maxtime','$time');";\r
+ //vacuum analyze user_points;vacuum analyze test_csvimportpk;";\r
+ pg_exec($inserta) or die ("Some error occurred; is your data forsld_mapviewer/mat right? Did you fill all the parameters correctly? Does your data have some 'strange' (non LATIN1 encoding) character ??");\r
+\r
+ $BBOX_sql="select extent(user_points.the_geom) from user_points where user_points.userid='$userid' "; \r
+\r
+ $postgis_result=pg_query($BBOX_sql);\r
+ while ($row = pg_fetch_array($postgis_result, NULL, PGSQL_ASSOC))\r
+ {\r
+ $b=substr($row['extent'],4);\r
+ $c=substr($b,0,-1); \r
+ $bbox=str_replace(' ',',',$c);\r
+ }\r
+ $bbox2=explode(',',$bbox);\r
+ $x1=$bbox2[0]; \r
+ $y1=$bbox2[1]; \r
+ $x2=$bbox2[2]; \r
+ $y2=$bbox2[3];\r
+ $bbox=$x1.",".$y1.",".$x2.",".$y2; \r
+\r
+function third($userid,$sld_file)\r
+{\r
+ //$conn = pg_connect("host=localhost port=5432 password=postgres user=postgres dbname=geoest");\r
+ $conn = pg_connect(POSTGIS_CS);\r
+ $misql="select distinct(genus) from user_points where userid='$userid'";\r
+ $postgis_result=pg_exec($misql) or die;\r
+ $numFilas =pg_NumRows($postgis_result);\r
+\r
+ $gml = new DOMDocument;\r
+ $gml ="<?xml version=\"1.0\" encoding=\"LATIN1\"?>";\r
+ $gml.="<featureType>";\r
+ //per cada g\1anere....\r
+ for($i=0;$i<$numFilas;$i++)\r
+ {\r
+ //ponga cada fila de la resulta en una matriz\r
+ $result_matriz = pg_Fetch_Array($postgis_result,$i);\r
+ $gml .="<genus>";\r
+ $gml .="<name>".$result_matriz[0]."</name>";\r
+ $gml .="</genus>";\r
+ }\r
+ $gml .="</featureType>";\r
+ pg_close($conn);\r
+ $dom_new = new DOMDocument();\r
+ $xsl = new XSLTProcessor;\r
+ $xsl->setParameter( '', 'user', "$userid");\r
+ $xslt='php_xsl/SLD_php.xsl';\r
+ $style = realpath($xslt);\r
+ $dom_new->load($style);\r
+ $xsl->importStyleSheet($dom_new);\r
+ $dom_new->loadXML($gml);\r
+ $out = $xsl->transformToXML($dom_new);\r
+ //$sld=URL_SITE."/edit_wp5/geo/sld/$sld_file";\r
+ //$sld_path_towrite="/var/edit/edit_wp5/geo/sld/$sld_file";\r
+ $sld=SLD_URL1."/$sld_file";\r
+ $sld_path_towrite=SLD_DIR."/$sld_file";\r
+\r
+ $fp=fopen($sld_path_towrite,"w");\r
+ $write=fwrite($fp,$out);\r
+// create_sld('php_xsl/SLD_php.xsl',$sld_file,$gml);\r
+\r
+} \r
+\r
+function third_fourth($userid,$sld_sp_file)\r
+{ \r
+ //third&fourth fields symbolization\r
+ global $userid,$sld_sp_file;\r
+ //$conn = pg_connect("host=localhost port=5432 password=postgres user=postgres dbname=geoest");\r
+ $conn = pg_connect(POSTGIS_CS);\r
+ $misql="select distinct(specie),genus from user_points where userid='$userid' order by genus";\r
+\r
+ $postgis_result=pg_exec($misql) or die;\r
+ $numFilas =pg_NumRows($postgis_result);\r
+ $gml = new DOMDocument;\r
+ $gml ="<?xml version=\"1.0\" encoding=\"LATIN1\"?>";\r
+ $gml.="<featureType>";\r
+ //per cada g\1anere....\r
+ for($i=0;$i<$numFilas;$i++)\r
+ {\r
+ //ponga cada fila de la resulta en una matriz\r
+ $result_matriz = pg_Fetch_Array($postgis_result,$i);\r
+ $gml .="<specie>";\r
+ $gml .="<name>".$result_matriz[0]."</name>";\r
+ $gml .="<genus>";\r
+ $gml .="<genus_name>".$result_matriz[1]."</genus_name>";\r
+ $gml .="</genus>";\r
+ $gml .="</specie>";\r
+ }\r
+ $gml .="</featureType>";\r
+ pg_close($conn);\r
+ $dom_new = new DOMDocument();\r
+ $xsl = new XSLTProcessor;\r
+ $xsl->setParameter( '', 'user', "$userid");\r
+$xslt='php_xsl/SLD_php2.xsl';//,$sld_sp_file);\r
+$dom_new = new DOMDocument();\r
+$xsl = new XSLTProcessor;\r
+$xsl->setParameter( '', 'user', "$userid");\r
+$style = realpath($xslt);\r
+$dom_new->load($style);\r
+$xsl->importStyleSheet($dom_new);\r
+$dom_new->loadXML($gml);\r
+$out = $xsl->transformToXML($dom_new);\r
+ //$sld=URL_SITE."/edit_wp5/geo/sld/$sld_file";\r
+ //$sld_path_towrite="/var/edit/edit_wp5/geo/sld/$sld_file";\r
+ $sld=SLD_URL1."/$sld_file";\r
+ $sld_path_towrite=SLD_DIR."/$sld_file";\r
+$fp=fopen($sld_path_towrite,"w");\r
+$write=fwrite($fp,$out);\r
+}\r
+function fourth($userid,$sld_fourth_file)\r
+{ global $userid,$sld_fourth_file;\r
+ //$conn = pg_connect("host=localhost port=5432 password=postgres user=postgres dbname=geoest");\r
+ $conn = pg_connect(POSTGIS_CS);\r
+ $misql2="select distinct(specie) from user_points where userid='$userid'";\r
+ $postgis_result=pg_exec($misql2) or die;\r
+ $numFilas =pg_NumRows($postgis_result);\r
+\r
+ $gml = new DOMDocument;\r
+ $gml ="<?xml version=\"1.0\" encoding=\"LATIN1\"?>";\r
+ $gml.="<featureType>";\r
+ //per cada g\1anere....\r
+ for($i=0;$i<$numFilas;$i++)\r
+ {\r
+ //ponga cada fila de la resulta en una matriz\r
+ $result_matriz = pg_Fetch_Array($postgis_result,$i);\r
+ $gml .="<sp>";\r
+ $gml .="<name>".$result_matriz[0]."</name>";\r
+ $gml .="</sp>";\r
+ }\r
+ $gml .="</featureType>";\r
+ pg_close($conn);\r
+ $dom_new = new DOMDocument();\r
+ $xsl = new XSLTProcessor;\r
+ $xsl->setParameter( '', 'user', "$userid");\r
+ $xslt='php_xsl/SLD_fourth.xsl';\r
+ $dom_new = new DOMDocument();\r
+ $xsl = new XSLTProcessor;\r
+ $xsl->setParameter( '', 'user', "$userid");\r
+ $style = realpath($xslt);\r
+ $dom_new->load($style);\r
+ $xsl->importStyleSheet($dom_new);\r
+ $dom_new->loadXML($gml);\r
+ $out = $xsl->transformToXML($dom_new);\r
+ //$sld=URL_SITE."/edit_wp5/geo/sld/$sld_file";\r
+ //$sld_path_towrite="/var/edit/edit_wp5/geo/sld/$sld_file";\r
+ $sld=SLD_URL1."/$sld_file";\r
+ $sld_path_towrite=SLD_DIR."/$sld_file";\r
+ $fp=fopen($sld_path_towrite,"w");\r
+ $write=fwrite($fp,$out);\r
+// create_sld('php_xsl/SLD_fourth.xsl',$sld_fourth_file);\r
+}\r
+\r
+$j="{error: '" . $error . "',bbox: '" . $bbox. "',userid: '" . $userid. "'";\r
+/*\r
+switch ($s)\r
+{\r
+ case 3: third($userid,$sld_file);\r
+ $j.=",genus_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_file. "'}";\r
+ break;\r
+ case 4: fourth($userid,$sld_fourth_file);\r
+ $j.=",fourth_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_fourth_file. "'}";\r
+\r
+ break;\r
+\r
+ case 5: third_fourth($userid,$sld_sp_file);\r
+ $j.=",sp_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_sp_file. "'}"; \r
+ break;\r
+ case 34: third($userid,$sld_file);fourth($userid,$sld_fourth_file);\r
+ $j.=",genus_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_file. "'";\r
+ $j.=",fourth_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_fourth_file. "'}";\r
+ \r
+ break;\r
+\r
+ case 35: third($userid,$sld_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",genus_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_file. "'";\r
+ $j.=",sp_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_sp_file. "'}"; \r
+ \r
+ break;\r
+\r
+ case 45: fourth($userid,$sld_fourth_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",fourth_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_fourth_file. "'";\r
+ $j.=",sp_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_sp_file. "'}";\r
+ break;\r
+ case 345: third($userid,$sld_file);fourth($userid,$sld_fourth_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",genus_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_file. "'";\r
+ $j.=",fourth_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_fourth_file. "'";\r
+ $j.=",sp_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_sp_file. "'}";\r
+ break;\r
+\r
+} \r
+*/\r
+\r
+switch ($s)\r
+{\r
+ case 3: third($userid,$sld_file);\r
+ $j.=",genus_sld: '".SLD_URL1.$sld_file. "'}";\r
+ break;\r
+ case 4: fourth($userid,$sld_fourth_file);\r
+ $j.=",fourth_sld: '".SLD_URL1.$sld_fourth_file. "'}";\r
+\r
+ break;\r
+\r
+ case 5: third_fourth($userid,$sld_sp_file);\r
+ $j.=",sp_sld: '".SLD_URL1.$sld_sp_file. "'}"; \r
+ break;\r
+ case 34: third($userid,$sld_file);fourth($userid,$sld_fourth_file);\r
+ $j.=",genus_sld: '".SLD_URL1.$sld_file. "'";\r
+ $j.=",fourth_sld: '".SLD_URL1.$sld_fourth_file. "'}";\r
+ \r
+ break;\r
+\r
+ case 35: third($userid,$sld_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",genus_sld: '".SLD_URL1.$sld_file. "'";\r
+ $j.=",sp_sld: '".SLD_URL1.$sld_sp_file. "'}"; \r
+ \r
+ break;\r
+\r
+ case 45: fourth($userid,$sld_fourth_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",fourth_sld: '".SLD_URL1.$sld_fourth_file. "'";\r
+ $j.=",sp_sld: '".SLD_URL1.$sld_sp_file. "'}";\r
+ break;\r
+ case 345: third($userid,$sld_file);fourth($userid,$sld_fourth_file);third_fourth($userid,$sld_sp_file);\r
+ $j.=",genus_sld: '".SLD_URL1.$sld_file. "'";\r
+ $j.=",fourth_sld: '".SLD_URL1.$sld_fourth_file. "'";\r
+ $j.=",sp_sld: '".SLD_URL1.$sld_sp_file. "'}";\r
+ break;\r
+\r
+} \r
+\r
+}\r
+\r
+ }\r
+ \r
+echo $j;\r
+/*\r
+\r
+ global $sld_file,$sld_sp_file,$sld_fourth_file; global $bbox;global $userid;\r
+ echo "{";\r
+ echo "error: '" . $error . "',\n";\r
+ echo "bbox: '" . $bbox. "',\n";\r
+ echo "userid: '" . $userid. "',\n";\r
+ echo "genus_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_file. "',\n";\r
+ echo "sp_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_sp_file. "',\n";\r
+ echo "fourth_sld: URL_SITE.'/edit_wp5/geo/sld/".$sld_fourth_file. "'\n";\r
+ echo "}";\r
+ */\r
+\r
+?>\r