[ka-Map-users] display search result per Layer, not Repeated Result

[Lorenzo Becchi]

Hi Donny,
if I've understood your problem, you don't need to use the default 
search.php file for your search.
That file use mapserver to perform searches and you have a better system 
that is your postgres db.
what you have to do is customize the search.php to avoid it to go and 
ask to mapserver but directly to your db. With a little join of tables 
you can have your search as you like.

regards
lorenzo


donny wicaks wrote:
> Hi, All
>
> I'm Donny Wicaksono from Indonesia. i'm developing a web-gis. I use 
> ka-map and postgis as database.
>
> I have difficulties, i really hope anyone can help me.. :)
>
> I'm developing accident occurrences in a certain location, for example 
> in one district. They are displayed as points in ka-map. The 
> occurrences are yearly, in 2004, 2005, and 2006. The map and the 
> points have already successfully displayed. The identify function per 
> point is working and also is the search function.
>
>
> This is my map file in Layer part:
> .................................
> LAYER
>     NAME 'accident 2006'
>     GROUP 'Accident 2006'
>     TYPE POINT
>     CONNECTIONTYPE postgis
>     CONNECTION "host=localhost user='postgis' password=password 
> dbname='car_accidents'"
>     DATA 'coordinates FROM cases'
>     FILTER "extract(year from date)='2006'"
>    
>     METADATA
>       'wms_title' 'cases'
>       'queryable'    'true'
>       'searchfield'    'car_type'
>       'fields'    'car_type:Car Type,accident_type:Accident 
> Type,description:Description,date:Date,time:Time,time_zone:Time Zone'
>     END
>     STATUS on
>     TRANSPARENCY 100
>     PROJECTION
>     'proj=longlat'
>     'ellps=WGS84'
>     'datum=WGS84'
>     'no_defs'
>     ''
>     END
>     LABELITEM 'car_type'
>     CLASS
>     TEMPLATE "kueri.html"
>        NAME 'Year 2006'
>        STYLE
>          SYMBOL 'CIRCLE'
>          SIZE 7
>          OUTLINECOLOR 0 0 0
>          COLOR 255 0 0
>        END
>       LABEL
>       SIZE small
>       COLOR 0 0 0
>       ANGLE 0
>       BUFFER 2
>      END
>     END
>     PROCESSING "close_connection=DEFER"
>   END
>     #Circle symbol
>       SYMBOL
>         NAME 'CIRCLE'
>         TYPE ellipse
>         FILLED true
>         POINTS
>           1 1
>         END
>       END
>   ...........................
>
>
>
> But this is the problem i'm facing:
>
> In my ka-map system, the search results are able to be displayed. But 
> the results are not distributed in the three appropriate layers (as i 
> mentioned above, i have three layers: 2004, 2005, and 2006).
> For example, i search "Bus", and i get the results for buses accidents 
> in 2004, 2005, and 2006 complete with accident type, description, date 
> and time data. say i get 17 data.
> Then, the all 17 results are displayed three times as Results for 
> Layer Year 2004, Results for Layer Year 2005, and Results for Layer 
> Year 2006.
>
> I want to place the data result in their right place: the 2004 data 
> result in Results for Layer Year  2004, the 2005 data result in 
> Results for Layer Year  2005, and the 2006 data result in Results for 
> Layer Year  2006.
>
> How should I configure my map file to do that? Or do I have to 
> configure another files? If so, which files, and how should i 
> configure them?
>
> I will appreciate any helps....
>
> Thank You
>
> -don-
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ka-map-users
>