deleting old folder after move

[geo.git] / edit_wp5_web_folder / geo / queries / pol_query.php

diff --git a/edit_wp5_web_folder/geo/queries/pol_query.php b/edit_wp5_web_folder/geo/queries/pol_query.php
deleted file mode 100644 (file)
index 249a187..0000000
--- a/edit_wp5_web_folder/geo/queries/pol_query.php
+++ /dev/null
@@ -1,65 +0,0 @@
-<?php\r
-\r
-\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
-       // 'POLYGON((-5.7107 41.43,-5.11 40.84,-5.7 40.8,-5.11 41.433,-5.7107 41.43))'\r
-       //$geom="POLYGON((".$_GET['point_params[0]']."))";\r
-       //\r
-       $x=$_GET['x'];\r
-       $y=$_GET['y'];\r
-\r
-       $polygon=$_GET['polygon'];\r
-\r
-//     echo "point is".$x.",".$y;\r
-       $query="select code from $polygon where CONTAINS(the_geom,GeomFromText('POINT($x $y)',4326))";\r
-//echo $query;\r
-       //the_geom && GeomFromText('POINT($x $y)',4326)";\r
-        $query_result=pg_query($query) or die ("algun errorrrr");\r
-                $count=pg_numrows($query_result);\r
-\r
-        if ($count==0)\r
-        {\r
-        print "<div id='content'> HERE THERE IS NO POLYGON!";\r
-        }\r
-        else\r
-        {\r
-        \r
-         print "<div id='content'>\r
-\r
-               <table border='0' class='sortable paginated'>                    \r
-               <thead>\r
-            <tr>";\r
-      while ($row = pg_fetch_array($query_result, NULL, PGSQL_ASSOC)) \r
-                               {   \r
-                       $sql2="select  COUNT(p.pk) as records,count(distinct(p.genus)) as genus from user_points p INNER JOIN $polygon poly ON p.userid='pou' and p.the_geom && poly.the_geom and poly.code='".$row['code']."' and CONTAINS(poly.the_geom,p.the_geom) group by p.userid,poly.code,poly.the_geom";\r
-                       \r
-                       \r
-\r
-              print "<th class='sort-alpha'>$polygon  code: ".$row['code']."</th>";     \r
-                           }\r
-                       print "</thead><tbody> ";\r
-\r
-               \r
-     $query_result2=pg_query($sql2) or die ("algun error2");\r
-        while ($row2 = pg_fetch_array($query_result2, NULL, PGSQL_ASSOC)) {\r
-\r
-                print "<tr class='even' style='display: table-row;'>";\r
-\r
-                print "<td><a id='repaginate'>Number of records ".$row2['records']."</a></td></tr>";\r
-                        print "<tr class='even' style='display: table-row;'>";\r
-               print "<td><a id='repaginate'>Number of genus ".$row2['genus']."</a></td></tr>";\r
-\r
-               \r
-                }\r
-               \r
-        //echo $result;\r
-               //} \r
-       print "</table>\r
-       </div>\r
-          </tbody>";\r
-          }\r
-\r
-       ?>
\ No newline at end of file