[Cartoweb-users] SRID-edit plugin

[Pierre GIRAUD]

Sorry, the patch wasn't sufficient for rectangle selections.
Can you apply the following patch ?

Index: ServerEdit.php
===================================================================
RCS file: 
/var/lib/cvs/projects/cw3/cartoweb3/plugins/edit/server/ServerEdit.php,v
retrieving revision 1.12
diff -u -r1.12 ServerEdit.php
--- ServerEdit.php    12 Jun 2006 12:14:18 -0000    1.12
+++ ServerEdit.php    12 Jun 2006 15:48:27 -0000
@@ -445,7 +445,7 @@
                 case 'Rectangle':
                     $sql = sprintf('SELECT *, astext(%s) as %s FROM 
%s.%s ' .
                                    'WHERE intersects (%s, ' .
-                                   "'BOX3D(%s %s, %s %s)'::box3d)",
+                                   "setSRID('BOX3D(%s %s, %s 
%s)'::box3d), %s)",
                                    $this->geomColumn,
                                    $this->geomColumn,
                                    $this->editSchema,
@@ -454,7 +454,8 @@
                                    $shape->minx,
                                    $shape->miny,
                                    $shape->maxx,
-                                   $shape->maxy
+                                   $shape->maxy,
+                                   $this->getSrid()
                                    );
                    
                     $this->log->debug($sql);


Jacolin Yves wrote:

>Hello,
>I downloaded CVS version and only copy-past edit directory. I always got this 
>problem ! If I just clic on the object, it is ok (but my fields are fill by 
>"undefinied"). If I clic and drag, I always got this error !
>
>Y.
>Le Lundi 12 Juin 2006 17:32, Pierre GIRAUD a écrit :
>  
>
>>Jacolin Yves wrote:
>>    
>>
>>>Hi,
>>>I go an error with the edit plugin. I created postgis layer with
>>>srid=2154. After creating my first polygon, I try to select it and I get
>>>this error : "class:   SoapFaultWrapper
>>>message:   Error [2, pg_exec() [function.pg-exec]: Query failed: ERREUR:
>>>Operation on mixed SRID geometries, /usr/share/pear/DB/pgsql.php, 335]
>>>Backtrace:..."
>>>
>>>Have you got an idea from where this problem came from ?
>>>
>>>Thanks,
>>>
>>>Y.
>>>      
>>>
>>This bug was previously signaled by Simon DURAND-TERRASSON
>>(http://bugzilla.maptools.org/show_bug.cgi?id=1482).
>>It is now fixed in the cvs version.
>>
>>If you need it working in a 3.2 version of Cartoweb, just tell me, I'll
>>send you a patch.
>>
>>Regards
>>
>>Pierre
>>_______________________________________________
>>Cartoweb-users mailing list
>>Cartoweb-users at lists.maptools.org
>>http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>    
>>
>
>  
>


-- 
_________________________________________________________
Pierre GIRAUD
Géomaticien, Analyste

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex 

Tel : 00 33 4 79 44 44 93
Mail : pierre.giraud at camptocamp.com
http://www.camptocamp.com