Advertisement
Guest User

Untitled

a guest
Aug 8th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. $( "#cow" ).draggable({ revert: true});
  2. $( "#map" ).droppable({
  3. drop: function( event, ui ) {
  4. var point = map.getLonLatFromPixel( map.events.getMousePosition(event, ui ))
  5. OpenLayers.Util.getElement("pos").innerHTML = point
  6.  
  7.  
  8. }
  9. });
  10.  
  11. $( "#cow" ).draggable({ revert: true});
  12. $( "#map" ).droppable({
  13. drop: function( event, ui ) {
  14. var farmid = 448;
  15. var point = map.getLonLatFromPixel( map.events.getMousePosition(event, ui ) )
  16. var lon = point.lon.toFixed(3);
  17. var lat = point.lat.toFixed(3);
  18. var dropPosition = point.lon.toFixed(3) + ' ' + point.lat.toFixed(3);
  19.  
  20. $.ajax({
  21. type: "GET",
  22. url: "../php/position.php",
  23. contentType: "application/json; charset=utf-8",
  24. data: "{'farmid':'"+ farmid +"', 'position':'"+ dropPosition +"'}",
  25. success: function(returnval){
  26.  
  27. var pid = parseInt(returnval);
  28. var selectB = new OpenLayers.Control.SelectFeature([farmbounds]);
  29. for(var f=0;f<farmbounds.features.length;f++) {
  30. if(farmbounds.features[f].fid == 'farmpaddocks.'+pid+'') {
  31. selectB.select(farmbounds.features[f]);
  32. break;
  33. }}
  34. }//success
  35. });//ajax
  36. }
  37. });
  38.  
  39. <?php
  40. $farmid= $_GET["farmid"];
  41. $position = $_GET["position"];
  42. $db = pg_connect("host=localhost dbname=postgis user=aaaaa password=bbbbb" );
  43. $sql = "SELECT * FROM public.farmpaddocks WHERE farmid = '$farmid' AND st_contains(farmpaddocks.the_geom,ST_GeomFromText('POINT($position)',3111)) ='t'";
  44. $resultD = pg_query($db,$sql);
  45. while($rowD=pg_fetch_row($resultD))
  46. {
  47. $paddockid= $rowD[0];
  48. echo $paddockid;
  49. }
  50.  
  51. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement