Hello,
I have two PostGIS layers: one with lines representing hiking paths, one
with polygons representing administrative units, with the mapfile
definitions in [1].
I am trying to elaborate a query in pmapper which would allow to select
an admin unit in an options list and then in a second field select
amongst the hikes that cross through that admin unit.
To start with, one general question: is it possible to create an options
list dependent on the first options list (i.e. chose an admin unit in
the first list and the get a second options list with only those hikes
that cross that admin unit), or does the second field have to be a
suggest field ?
Now, even using a suggest field in the second part, I just can't seem to
get the correct config to make it work.
At [0] is the searchitem definition.
At this stage, I don't get any error message, but searches are empty,
even though executing them directly in PostgreSQL works.
No error message in the postgresql, php or apache2 logs...
Any hints ?
Moritz
[0] Searchitem definition
<searchitem name="balades_selon_communes" description="Choisir
une balade selon une commune bruxelloise">
<layer type="postgis" name="balades_avec_communes">
<field type="s" name="muniname1" description="Nom de la
commune" wildcard="2">
<definition type="options" connectiontype="db"
sort="asc" firstoption="Sélectionner une commune" nosubmit="1">
<dsn
encoding="UTF-8">pgsql://USER:PASSWD@SERVER/DATABASE</dsn>
<sql>SELECT DISTINCT muniname1,muniname1 FROM
communes ORDER BY muniname1</sql>
<events>onchange="resetSuggestCache();$('#pmsfld_name').val('')"</events>
</definition>
</field>
<field type="s" name="name" description="Nom de la
balade" wildcard="2">
<definition type="suggest" connectiontype="db"
minlength="1" sort="asc" firstoption="Sélectionner une balade"
dependfld="muniname1">
<dsn
encoding="UTF-8">pgsql://USER:PASSWD@SERVER/DATABASE</dsn>
<sql>SELECT DISTINCT name,name FROM balades JOIN
communes ON (ST_Crosses(ST_Transform(balades.the_geom, 31370),
communes.the_geom)) WHERE name ~* E'^[search]' AND muniname1 =
'[dependfldval]' ORDER BY name</sql>
</definition>
</field>
</layer>
</searchitem>
[1] Mapfile definitions
#admin units
LAYER
NAME 'communes'
TYPE POLYGON
TEMPLATE void
CONNECTIONTYPE postgis
CONNECTION "dbname='MyDatabase' host=localhost port=5432
user='MyUser' password='MyPassword' sslmode=disable"
DATA 'the_geom FROM (SELECT gid, the_geom, muniname1 FROM communes)
as subquery USING UNIQUE gid USING srid=31370'
METADATA
"DESCRIPTION" "communes"
"RESULT_FIELDS" "gid,muniname1"
"RESULT_HEADERS" "ID,Nom"
"ows_title" "communes"
"LAYER_ENCODING" "UTF-8"
END
TRANSPARENCY 100
PROJECTION
"init=epsg:31370"
END
CLASS
NAME 'communes'
STYLE
WIDTH 1
OUTLINECOLOR 0 0 0
END
END
END
#hikes
LAYER
NAME "balades"
TYPE LINE
TEMPLATE void
CONNECTIONTYPE postgis
CONNECTION "dbname='MyDatabase' host=localhost port=5432
user='MyUser' password='MyPassword' sslmode=disable"#Prendre simplement
tous les champs de la table balades
DATA "the_geom FROM (SELECT b.gid, b.the_geom, b.name,
b.duree_minutes, b.longueur_metres, upper(a.prenom) || ' ' ||
upper(a.nom) as nom, a.email, a.section FROM balades b JOIN auteur a ON
(b.id_auteur = a.id)) AS SUBQUERY USING UNIQUE gid USING srid=4326"
METADATA
"RESULT_FIELDS" "name,duree_minutes,longueur_metres,nom,section"
"RESULT_HEADERS" "BALADE,DUREE (min),LONGUEUR (m),AUTEUR,SECTION"
"DESCRIPTION" "Balades"
"ows_title" "balades"
"LAYER_ENCODING" "UTF-8"
END #Metadata
PROJECTION
"init=epsg:4326"
END #Projection
CLASS
NAME 'Balades'
COLOR 255 0 0
END #Class
END #Layer
------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
