pmapper-users Mailing List for p.mapper (Page 5)
Brought to you by:
arminburger
You can subscribe to this list here.
2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(41) |
Nov
(124) |
Dec
(80) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2007 |
Jan
(56) |
Feb
(51) |
Mar
(155) |
Apr
(58) |
May
(67) |
Jun
(83) |
Jul
(76) |
Aug
(32) |
Sep
(58) |
Oct
(113) |
Nov
(63) |
Dec
(83) |
2008 |
Jan
(31) |
Feb
(34) |
Mar
(69) |
Apr
(30) |
May
(87) |
Jun
(64) |
Jul
(47) |
Aug
(18) |
Sep
(35) |
Oct
(53) |
Nov
(37) |
Dec
(31) |
2009 |
Jan
(23) |
Feb
(40) |
Mar
(65) |
Apr
(54) |
May
(92) |
Jun
(55) |
Jul
(87) |
Aug
(27) |
Sep
(81) |
Oct
(32) |
Nov
(77) |
Dec
(51) |
2010 |
Jan
(44) |
Feb
(59) |
Mar
(77) |
Apr
(54) |
May
(36) |
Jun
(36) |
Jul
(52) |
Aug
(62) |
Sep
(68) |
Oct
(58) |
Nov
(72) |
Dec
(27) |
2011 |
Jan
(15) |
Feb
(42) |
Mar
(37) |
Apr
(55) |
May
(84) |
Jun
(27) |
Jul
(27) |
Aug
(42) |
Sep
(42) |
Oct
(18) |
Nov
(83) |
Dec
(71) |
2012 |
Jan
(50) |
Feb
(75) |
Mar
(79) |
Apr
(43) |
May
(18) |
Jun
(22) |
Jul
(20) |
Aug
(13) |
Sep
(26) |
Oct
(30) |
Nov
(21) |
Dec
(30) |
2013 |
Jan
(57) |
Feb
(63) |
Mar
(53) |
Apr
(40) |
May
(39) |
Jun
(16) |
Jul
(43) |
Aug
(16) |
Sep
(37) |
Oct
(64) |
Nov
(31) |
Dec
(7) |
2014 |
Jan
(14) |
Feb
(6) |
Mar
(2) |
Apr
(9) |
May
(1) |
Jun
(18) |
Jul
(95) |
Aug
(6) |
Sep
(25) |
Oct
(33) |
Nov
(29) |
Dec
(30) |
2015 |
Jan
(16) |
Feb
(3) |
Mar
(4) |
Apr
(9) |
May
(19) |
Jun
|
Jul
(11) |
Aug
(3) |
Sep
(9) |
Oct
(11) |
Nov
(4) |
Dec
(9) |
2016 |
Jan
(21) |
Feb
(9) |
Mar
(6) |
Apr
(13) |
May
(21) |
Jun
(4) |
Jul
(3) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
2017 |
Jan
(1) |
Feb
(4) |
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
|
Nov
(1) |
Dec
|
2018 |
Jan
(3) |
Feb
(4) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2019 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
(3) |
May
(1) |
Jun
|
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2020 |
Jan
(1) |
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Bruno M. <BMo...@cm...> - 2016-01-22 13:16:09
|
Int: 1669/DSIQ/2015 Hi, I'm trying to develop a new plugin that saves info to database. My aim is to create several plugins based on Drawing Plugin, and make them work at the same time, each saving different type of information to database. What should I do to build my own plugin? What should I change in Drawing Plugin to build my own? Thank you Bruno Moreira Especialista de Informática [cid:image003.jpg@01D15514.E93F4640] Câmara Municipal de Santiago do Cacém | Town Hall of Santiago do Cacém Divisão de Sistemas de Informação e Qualidade | Information Systems and Quality Unit Informática - Information Technologies Service Praça do Município | 7540-136 Santiago do Cacém | Portugal Tel.: +351 269 829 400 Ext.: ( 5509 ) |Tel. Direto: +351 269 829 456 Fax: +351 269 829 498 E-mail: DS...@cm...<mailto:DS...@cm...> ge...@cm...<mailto:ge...@cm...> | www.cm-santiagocacem.pt<http://www.cm-santiagocacem.pt/> www.facebook.com/munsantiagocacem<http://www.facebook.com/munsantiagocacem> | https://twitter.com/#!/cmsantiagocacem Este e-mail pretende ser amigo do ambiente. Pondere antes de o imprimir. This e-mail is environment friendly. Please think twice before printing it. AVISO LEGAL: Esta mensagem é confidencial e dirigida apenas ao destinatário. Se a recebeu por erro, solicitamos que o comunique ao remetente e a elimine, assim como qualquer documento anexo. Não há renúncia à confidencialidade nem a nenhum privilégio devido a erro de omissão. DISCLAIMER: This message is confidential and intended exclusively for the address. If you received this message by mistake, please inform the sender and delete the message and attachments. No confidentiality nor any privilege regarding the information is waived or lost any mistransmission. ##################################################################################### Esta mensagem de e-mail foi verificada para Vírus e Conteúdo pelo MailMarshal ##################################################################################### |
From: Marcelo <man...@gm...> - 2016-01-21 11:31:01
|
OK thanks... this is the error: Fatal error: Call to a member function getAllGroupNames() on a non-object in /var/www/html/pmapper/incphp/init/initmap.php on line 290 this is the line /*** LAYERS ***/ // Test for groups with blanks $gList = $this->map->getAllGroupNames(); foreach ($gList as $gr) { if (preg_match('/\s/', $gr)) { pm_logDebug(0, "P.MAPPER-ERROR: Group '$gr' defined in the map file has blanks in its name. This is not possible for the p.mapper application. Remove blanks or substitute with e.g. '_'."); } } I have no idea of php. So what I am missing to make it work? regards, Marcelo El 20/01/16 a las 16:11, Armin Burger escribió: PHP Notices are not errors, but notices... if you get them it means that they are not disabled as described in the manual. Deactivate them in php.ini, with error_reporting = E_ALL & ~E_NOTICE as described. Then try again if you have problems. armin On 20/01/16 12:02, Marcelo wrote: Hi! I'm making and install from strach but can get it done properly. after I follow the steps in the debian instalation (using ubuntu 14.04.3) can't load the maps: I keep having this error. [:error] [pid 16551] [client xx.xx.xx.xx:34112] PHP Notice: Trying to get property of non-object in /var/www/html/pmapper/incphp/query/search.php on line 54, referer: [1]http://xxxxxx/pmapper/map.phtml I know this an error on php but I'm almost sure that I follow the instruction. Maybe I skip some line in the text, that is why my error in the log ... Sorry my english, regards, Marcelo ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! [2]http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ pmapper-users mailing list [3]pma...@li... [4]https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! [5]http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ pmapper-users mailing list [6]pma...@li... [7]https://lists.sourceforge.net/lists/listinfo/pmapper-users References 1. http://xxxxxx/pmapper/map.phtml 2. http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 3. mailto:pma...@li... 4. https://lists.sourceforge.net/lists/listinfo/pmapper-users 5. http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 6. mailto:pma...@li... 7. https://lists.sourceforge.net/lists/listinfo/pmapper-users |
From: Armin B. <arm...@gm...> - 2016-01-20 19:11:48
|
PHP Notices are not errors, but notices... if you get them it means that they are not disabled as described in the manual. Deactivate them in php.ini, with error_reporting = E_ALL & ~E_NOTICE as described. Then try again if you have problems. armin On 20/01/16 12:02, Marcelo wrote: > Hi! I'm making and install from strach but can get it done properly. > > after I follow the steps in the debian instalation (using ubuntu > 14.04.3) can't load the maps: I keep having this error. > > [:error] [pid 16551] [client xx.xx.xx.xx:34112] PHP Notice: Trying to > get property of non-object in > /var/www/html/pmapper/incphp/query/search.php on line 54, referer: > http://xxxxxx/pmapper/map.phtml > > > I know this an error on php but I'm almost sure that I follow the > instruction. Maybe I skip some line in the text, that is why my error in > the log ... > > > Sorry my english, > regards, > Marcelo > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 > _______________________________________________ > pmapper-users mailing list > pma...@li... > https://lists.sourceforge.net/lists/listinfo/pmapper-users > |
From: Marcelo <man...@gm...> - 2016-01-20 11:01:50
|
Hi! I'm making and install from strach but can get it done properly. after I follow the steps in the debian instalation (using ubuntu 14.04.3) can't load the maps: I keep having this error. [:error] [pid 16551] [client xx.xx.xx.xx:34112] PHP Notice: Trying to get property of non-object in /var/www/html/pmapper/incphp/query/search.php on line 54, referer: http://xxxxxx/pmapper/map.phtml I know this an error on php but I'm almost sure that I follow the instruction. Maybe I skip some line in the text, that is why my error in the log ... Sorry my english, regards, Marcelo |
From: vitor_mr <vit...@ho...> - 2016-01-08 19:34:27
|
How do I to the Pmapper to be accessible for mobile devices (cell)? -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Pmapper-mobile-devices-cell-tp4025825.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: gioza <al...@al...> - 2016-01-08 19:33:53
|
Hi, pmapper isn't optimized for mobile devices especially phones -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-Pmapper-moblie-tp4025823p4025824.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: vitor_mr <vit...@ho...> - 2016-01-08 19:18:32
|
How do I get my pmapper (map) accessible to mobile phone? Someone has already achieved? -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Pmapper-moblie-tp4025822.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: jose m. <jos...@gm...> - 2015-12-23 10:31:14
|
Thanks in qgis the service has (no) scale limitation! -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-how-to-add-google-satellite-imagery-layer-in-pmapper-4-3-2-tp4025815p4025820.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: gioza <al...@al...> - 2015-12-23 10:15:20
|
Hi, first of all pay attention to GOOGLE MAPS TERMS OF USE. In the way above illustrated the "attributions" doesn't appear on the map and I think it is mandatory to use them. By the way, scale limitation is probably due to google maps service. Try to check the max scale directly in google maps...even in qgis the service has scale limitation -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-how-to-add-google-satellite-imagery-layer-in-pmapper-4-3-2-tp4025815p4025819.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Juliano C. P. A. <jul...@ho...> - 2015-12-22 22:41:36
|
Hello, I have one SHPfile with 3 columns [ street name / first number / last number ] but i don't know how search in 2 columns using only one field. MAPFILE: LAYER NAME "Street1" GROUP GEOSTREET1 TYPE LINE STATUS OFF DATA "streetnum_line.shp" TOLERANCEUNITS meters TOLERANCE 15 CLASS NAME " " TEMPLATE void END METADATA "DESCRIPTION" "Street" "RESULT_FIELDS" "STREET,NUMBER1,NUMBER2" "RESULT_HEADERS" "Street Name, First Number, Last Number" "LAYER_ENCODING" "ISO-8859-1" "ows_title" "Street" END END I need search this Address: STREET NAME => ONE STREET NUMBER => 110 SQL Expression: SELECT * FROM streetnum_line WHERE STREET = "ONE STREET" and NUMBER1<= 110 and NUMBER2 => 110 SEARCH XML: (not working) <searchitem name="Address" description="Street Name / Number"> <layer type="shape" name="Street1"> <field type="s" name="STREET" description="Street" wildcard="0" sort="asc"> </field> <field type="n" name="NUMBER1" description="Number" compare=">="> </field> </layer> </searchitem> Can anybody help me? |
From: jose m. <jos...@gm...> - 2015-12-22 17:09:22
|
Hi Giovanni, It works through the pmapper 4! But it works only until the scale 750. For higher scales, like 1:500, the parameter PROCESSING "BANDS=1" is required... so the image only appears in black & white mode. Any clue? Thanks -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-how-to-add-google-satellite-imagery-layer-in-pmapper-4-3-2-tp4025815p4025818.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Zerubabel M. <ben...@gm...> - 2015-12-16 06:21:39
|
Hi all, i have already install Mapserver in IIS, but i'm stuck with install pmapper in IIS, are guys have tutorial or any idea to install pmapper 4.3.2 in IIS? thanks <https://www.avast.com/lp-safe-emailing?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> This email has been sent from a virus-free computer protected by Avast. www.avast.com <https://www.avast.com/lp-safe-emailing?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2> |
From: gioza <al...@al...> - 2015-12-15 10:03:41
|
Have a look to this: http://www.gdal.org/frmt_wms_googlemaps_tms.xml save the xml in your data directory (where your shapefiles are). I think you have to add epsg 900913 or 3753 in your projections files. In your mapfile create a layer: LAYER NAME "gdal" STATUS OFF TYPE RASTER DATA "frmt_wms_googlemaps_tms.xml" #NAME OF XML FILE!!! PROCESSING "OVERSAMPLE_RATIO=1" PROJECTION "init=EPSG:900913" END END add in your config.xml gdal (or the name you want) layer in this way google maps work in pmapper4 but I prefer pmapper5 -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-how-to-add-google-satellite-imagery-layer-in-pmapper-4-3-2-tp4025815p4025816.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: harpinder s. <har...@re...> - 2015-12-15 09:04:44
|
Kindly provide details regarding adding a google satellite imagery/map layer in pmapper 4.3.2 based application ? . |
From: gioza <al...@al...> - 2015-12-15 07:47:17
|
pmapper5 or pmapper4? -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-how-to-add-google-satellite-imagery-layer-in-pmapper-tp4025813p4025814.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: harpinder s. <har...@re...> - 2015-12-15 05:16:37
|
Kindly provide details regarding adding a google satellite imagery/map layer in pmapper application . regards, |
From: gioza <al...@al...> - 2015-11-17 11:01:58
|
Hi all, In pmapper5 I realised that google maps layer isn't visible on mobile devices (android), you can't zoom on it or pan. If I use in pmapper OL2.11 and jquery 1.7 as it was in the first release, google maps layer is fine! Any help? thanks, Giovanni -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Pmapper5-problem-with-google-maps-layer-in-mobile-devices-tp4025812.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Armin B. <arm...@gm...> - 2015-11-07 16:44:25
|
you mainly need to run some debugging as described here: http://svn.pmapper.net/trac/wiki/FaqDebugging armin On 04/11/15 21:36, luca paganotti wrote: > Hi list, I'm new to map server and pmapper. I'm requested to setup a centOS > 7 box running mapserver and pmapper (v. 4). I followed some info I found on: > > - http://svn.pmapper.net/trac/wiki/DocQuickinstall > - > http://www.rigacci.net/wiki/doku.php/formazione/web_programming/pmapper4 > > but unfortunately I'm not able to view any map/layer. I see the ui but the > map loading stucks forever telling me that a loading is in progress ... > forever ... > > I'm asking this list, but if it's not the right place where to ask, please > redirect me to the right place. > > I'm searching for a detailed step by step guide on how to setup at least a > pmapper site with the demodata visible. > Please forgive my english and thanks for any answer. > > ---------------------------------------------------------------- > -- Luca Paganotti > ---------------------------------------------------------------- > -- sourceforge email: > -- luc...@us... > -- skype name: luca.paganotti > [image: http://it.linkedin.com/in/lucapaganotti] > <http://it.linkedin.com/in/lucapaganotti> > ----------------------------------------------------------------- > -- Mistakes are portals of discovery - JAAJ > ----------------------------------------------------------------- > ------------------------------------------------------------------------------ > _______________________________________________ > pmapper-users mailing list > pma...@li... > https://lists.sourceforge.net/lists/listinfo/pmapper-users > |
From: luca p. <luc...@gm...> - 2015-11-04 20:37:00
|
Hi list, I'm new to map server and pmapper. I'm requested to setup a centOS 7 box running mapserver and pmapper (v. 4). I followed some info I found on: - http://svn.pmapper.net/trac/wiki/DocQuickinstall - http://www.rigacci.net/wiki/doku.php/formazione/web_programming/pmapper4 but unfortunately I'm not able to view any map/layer. I see the ui but the map loading stucks forever telling me that a loading is in progress ... forever ... I'm asking this list, but if it's not the right place where to ask, please redirect me to the right place. I'm searching for a detailed step by step guide on how to setup at least a pmapper site with the demodata visible. Please forgive my english and thanks for any answer. ---------------------------------------------------------------- -- Luca Paganotti ---------------------------------------------------------------- -- sourceforge email: -- luc...@us... -- skype name: luca.paganotti [image: http://it.linkedin.com/in/lucapaganotti] <http://it.linkedin.com/in/lucapaganotti> ----------------------------------------------------------------- -- Mistakes are portals of discovery - JAAJ ----------------------------------------------------------------- |
From: gioza <al...@al...> - 2015-11-04 15:35:31
|
Hi all, have anyone of you tested the maximum zoom for tiles in pmapper5? Is 19th level the max zoom for tiles? thanks, bye -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Pmapper5-max-zoom-for-tiles-tp4025809.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Valerio <not...@gm...> - 2015-10-30 08:01:23
|
Hi all, is it possible in pmapper to change variables in mapfile as in CGI Mapserver? i.e. I'd like to filter on the fly a layer with a particular attribute value. If it would be necessary to write code in php, is there some sample code with php-mapscript api? thanks in advance regards Val |
From: jose m. <jos...@gm...> - 2015-10-29 21:39:41
|
Thanks Armin! Yes, it's possible to define the sort/order via the SQL definition in the search.xml file, like: <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano DESC</sql> However the result is not reflected in the drop-down list. This means that's not possible to get the drop-down list sorted in descending order? -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-4-3-2-search-in-postgis-with-option-sort-desc-tp4025805p4025807.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Armin B. <arm...@gm...> - 2015-10-29 20:13:02
|
the "sort" parameter is not used for options and DB connection type, but as you already noticed, it's also not needed since one can easily define the sort/order directly via the SQL definition. armin On 29/10/15 15:42, jose mvm wrote: > Hi, > > I' am trying to get a drop-down list for search, sorted by descending order: > > ===== > <searchitem name="RegistoProcessosObra" description="Processos de Obra"> > <layer type="postgis" name="RegistoProcessosObra"> > <field type="n" name="proc_ano" description="Ano" wildcard="2"> > <definition type="options" connectiontype="db" sort="desc"> > <dsn encoding="UTF-8">pgsql://zemacau:z53498k@10.27.2.24/pmapper</dsn> > <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS > NOT NULL ORDER BY proc_ano</sql> > </definition> > </field> > <field type="n" name="proc_numero" description="Número" wildcard="2" /> > <field type="s" name="cod_edificio" description="Código Edifício" > wildcard="0" /> > </layer> > </searchitem> > ===== > > But it seems to me that the option SORT in the search.xml file is ignored by > the search.php file... > > pm_debug.log shows me that information: > > ===== > [29-Oct-2015 14:20:04] P.MAPPER debug info > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => options > [connectiontype] => db > [sort] => desc > ) > > [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper > [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano > IS NOT NULL ORDER BY proc_ano > ) > > [29-Oct-2015 14:20:04] P.MAPPER debug info > search.php->getOptionsFromDb() > SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL > ORDER BY proc_ano > [29-Oct-2015 14:20:04] P.MAPPER debug info > search.php->getOptionsFromDb()->json > { "1960":"1960", "1961":"1961", "1962":"1962", "1963":"1963", > "1964":"1964", "1967":"1967", "1969":"1969", "1970":"1970", "1972":"1972", > "1975":"1975", "1979":"1979", "1984":"1984", "1985":"1985", "1986":"1986", > "1987":"1987", "1988":"1988", "1989":"1989", "1990":"1990", "1991":"1991", > "1992":"1992", "1993":"1993", "1994":"1994", "1995":"1995", "1996":"1996", > "1997":"1997", "1998":"1998", "1999":"1999", "2000":"2000", "2001":"2001", > "2002":"2002", "2003":"2003", "2004":"2004", "2005":"2005", "2006":"2006", > "2007":"2007", "2008":"2008", "2009":"2009", "2010":"2010", "2011":"2011", > "2012":"2012", "2013":"2013", "2014":"2014", "2015":"2015"} > ===== > > If i force the SELECT in search.xml file with DESC, like this: > > <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT > NULL ORDER BY proc_ano DESC</sql> > > the pm_debug.log shows me the coorect information: > > ===== > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => options > [connectiontype] => db > [sort] => desc > ) > > [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper > [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano > IS NOT NULL ORDER BY proc_ano DESC > ) > > [29-Oct-2015 14:27:18] P.MAPPER debug info > search.php->getOptionsFromDb() > SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL > ORDER BY proc_ano DESC > [29-Oct-2015 14:27:18] P.MAPPER debug info > search.php->getOptionsFromDb()->json > { "2015":"2015", "2014":"2014", "2013":"2013", "2012":"2012", > "2011":"2011", "2010":"2010", "2009":"2009", "2008":"2008", "2007":"2007", > "2006":"2006", "2005":"2005", "2004":"2004", "2003":"2003", "2002":"2002", > "2001":"2001", "2000":"2000", "1999":"1999", "1998":"1998", "1997":"1997", > "1996":"1996", "1995":"1995", "1994":"1994", "1993":"1993", "1992":"1992", > "1991":"1991", "1990":"1990", "1989":"1989", "1988":"1988", "1987":"1987", > "1986":"1986", "1985":"1985", "1984":"1984", "1979":"1979", "1975":"1975", > "1972":"1972", "1970":"1970", "1969":"1969", "1967":"1967", "1964":"1964", > "1963":"1963", "1962":"1962", "1961":"1961", "1960":"1960"} > ===== > > But the drop-down list appears always sorted in ascending order... > <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025805/dropdownlist.jpg> > > I think this is a pmapper bug... > > Can anyone help me, please? > Thanks in advance > > > > > -- > View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-4-3-2-search-in-postgis-with-option-sort-desc-tp4025805.html > Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > pmapper-users mailing list > pma...@li... > https://lists.sourceforge.net/lists/listinfo/pmapper-users > |
From: jose m. <jos...@gm...> - 2015-10-29 14:42:18
|
Hi, I' am trying to get a drop-down list for search, sorted by descending order: ===== <searchitem name="RegistoProcessosObra" description="Processos de Obra"> <layer type="postgis" name="RegistoProcessosObra"> <field type="n" name="proc_ano" description="Ano" wildcard="2"> <definition type="options" connectiontype="db" sort="desc"> <dsn encoding="UTF-8">pgsql://zemacau:z53498k@10.27.2.24/pmapper</dsn> <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano</sql> </definition> </field> <field type="n" name="proc_numero" description="Número" wildcard="2" /> <field type="s" name="cod_edificio" description="Código Edifício" wildcard="0" /> </layer> </searchitem> ===== But it seems to me that the option SORT in the search.xml file is ignored by the search.php file... pm_debug.log shows me that information: ===== [29-Oct-2015 14:20:04] P.MAPPER debug info XML->//definition SimpleXMLElement Object ( [@attributes] => Array ( [type] => options [connectiontype] => db [sort] => desc ) [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano ) [29-Oct-2015 14:20:04] P.MAPPER debug info search.php->getOptionsFromDb() SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano [29-Oct-2015 14:20:04] P.MAPPER debug info search.php->getOptionsFromDb()->json { "1960":"1960", "1961":"1961", "1962":"1962", "1963":"1963", "1964":"1964", "1967":"1967", "1969":"1969", "1970":"1970", "1972":"1972", "1975":"1975", "1979":"1979", "1984":"1984", "1985":"1985", "1986":"1986", "1987":"1987", "1988":"1988", "1989":"1989", "1990":"1990", "1991":"1991", "1992":"1992", "1993":"1993", "1994":"1994", "1995":"1995", "1996":"1996", "1997":"1997", "1998":"1998", "1999":"1999", "2000":"2000", "2001":"2001", "2002":"2002", "2003":"2003", "2004":"2004", "2005":"2005", "2006":"2006", "2007":"2007", "2008":"2008", "2009":"2009", "2010":"2010", "2011":"2011", "2012":"2012", "2013":"2013", "2014":"2014", "2015":"2015"} ===== If i force the SELECT in search.xml file with DESC, like this: <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano DESC</sql> the pm_debug.log shows me the coorect information: ===== XML->//definition SimpleXMLElement Object ( [@attributes] => Array ( [type] => options [connectiontype] => db [sort] => desc ) [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano DESC ) [29-Oct-2015 14:27:18] P.MAPPER debug info search.php->getOptionsFromDb() SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL ORDER BY proc_ano DESC [29-Oct-2015 14:27:18] P.MAPPER debug info search.php->getOptionsFromDb()->json { "2015":"2015", "2014":"2014", "2013":"2013", "2012":"2012", "2011":"2011", "2010":"2010", "2009":"2009", "2008":"2008", "2007":"2007", "2006":"2006", "2005":"2005", "2004":"2004", "2003":"2003", "2002":"2002", "2001":"2001", "2000":"2000", "1999":"1999", "1998":"1998", "1997":"1997", "1996":"1996", "1995":"1995", "1994":"1994", "1993":"1993", "1992":"1992", "1991":"1991", "1990":"1990", "1989":"1989", "1988":"1988", "1987":"1987", "1986":"1986", "1985":"1985", "1984":"1984", "1979":"1979", "1975":"1975", "1972":"1972", "1970":"1970", "1969":"1969", "1967":"1967", "1964":"1964", "1963":"1963", "1962":"1962", "1961":"1961", "1960":"1960"} ===== But the drop-down list appears always sorted in ascending order... <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025805/dropdownlist.jpg> I think this is a pmapper bug... Can anyone help me, please? Thanks in advance -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-4-3-2-search-in-postgis-with-option-sort-desc-tp4025805.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. |
From: Valerio <not...@gm...> - 2015-10-29 12:25:37
|
Thank you Armin, it works Val 2015-10-28 21:12 GMT+01:00 Armin Burger <arm...@gm...>: > There was a misconfiguration of the web server, now it should work again. > > thanks > armin > > On 28/10/15 18:16, Valerio wrote: > > Hello, > > plugin and documentation page are not reachable (404): > > http://svn.pmapper.net/trac/wiki > > is there a new url? > > > > thanks in advance > > regards > > > > Valerio > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > pmapper-users mailing list > > pma...@li... > > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > pmapper-users mailing list > pma...@li... > https://lists.sourceforge.net/lists/listinfo/pmapper-users > |