pmapper-users — p.mapper users mailing list

Re: [pmapper-users] intersect with selection management plugin

[Thomas R. <tr...@si...>]

I send your mail to the mailing-list after a small "cleaning"...

Concerning "intersect with current selection" it is working well on my 
local pmapper copy? I'm trying to commit all local modification in 
pmapper4 trunk version.

For search operators, I'm looking what is missing in pmapper4 trunk 
version to allow it...

bye

Thomas

Le 16/07/2014 18:13, jose macau a écrit :
> my initial post ("This post has NOT been accepted by the mailing list 
> yet."), i don't know know why, i don't now if you can see it...
>
> title: intersect with selection management plugin
>
> post:
>
> hi,
>
> i'm trying to use "intersect with current selection" (through the 
> graphical queries plugin or query editor plugin) but i can´t get any 
> results.
>
> i have no php errors, only php notices:
>
> first selection:
>
> [15-Jul-2014 10:38:06 UTC] PHP Notice:  Undefined offset: 0 in 
> /var/www/pmapper-4.3.2/incphp/xajax/x_select.php on line 96
> [15-Jul-2014 10:38:15 UTC] PHP Notice:  Undefined index: JSON_Results 
> in 
> /var/www/pmapper-4.3.2/plugins/graphicalqueries/x_graphicalqueries.php 
> on line 19
> [15-Jul-2014 10:38:15 UTC] PHP Notice:  Undefined variable: poly in 
> /var/www/pmapper-4.3.2/plugins/graphicalqueries/x_graphicalqueries.php 
> on line 28
> [15-Jul-2014 10:38:16 UTC] PHP Notice:  Undefined offset: 0 in 
> /var/www/pmapper-4.3.2/incphp/xajax/x_select.php on line 96
>
> intersect with current selection:
>
> [15-Jul-2014 10:40:25 UTC] PHP Notice:  Undefined variable: poly in 
> /var/www/pmapper-4.3.2/plugins/graphicalqueries/x_graphicalqueries.php 
> on line 28
> [15-Jul-2014 10:40:25 UTC] PHP Notice:  Undefined offset: 1 in 
> /var/www/pmapper-4.3.2/plugins/common/selectTools.inc.php on line 421
> [15-Jul-2014 10:40:25 UTC] PHP Notice:  Trying to get property of 
> non-object in 
> /var/www/pmapper-4.3.2/plugins/common/selectTools.inc.php on line 421
> [15-Jul-2014 10:40:26 UTC] PHP Notice:  Undefined offset: 0 in 
> /var/www/pmapper-4.3.2/incphp/xajax/x_select.php on line 96
>
> ================
>
> and another question:
>
> it´s possible to load the selection management plugin with search tool 
> plugin (like with the graphical queries plugin and query editor plugin)?
>
> ================
>
> thanks
>
> best regards,
> José
>
>
> 2014-07-16 16:26 GMT+01:00 jose macau <jos...@gm... 
> <mailto:jos...@gm...>>:
>
>     Ok, magnificent!!!
>     Thank you very much Thomas.
>
>     But the my initial question was intersect with selection
>     management plugin.
>     I get the "replace selection", the "add to current selection",
>     the"exclude from the current selection" but not the "intersect
>     with current selection" operation.
>
>
>     2014-07-16 16:08 GMT+01:00 Thomas RAFFIN <tr...@si...
>     <mailto:tr...@si...>>:
>
>         Found!
>
>         In plugins/queryeditor/queryeditor.js, function
>         "setLayerName", near line 134, you should have (like here:
>         http://svn.pmapper.net/trac/browser/trunk/pmapper/plugins/queryeditor/queryeditor.js):
>
>         var options = '<option value="#"></option>\n';
>
>         with a "#" sign. In your code it is a "%".
>
>

	
	

Re: [pmapper-users] intersect with selection management plugin

[jose m. <jos...@gm...>]

now i'm trying to make intersect with selection management plugin and with
the pmapper demo version and the result is the same: No records found!



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025544.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] Print pdf in pmapper 4.3.2 change size font

[Thomas R. <tr...@si...>]

Hi,

I think it is due to MapServer version that is not correctly supported 
in pmapper.

You should try to upgrade to MapsErver 6.2 or 6.4.

Thomas
Le 17/07/2014 13:19, nando_gcia a écrit :
> Print pdf in pmapper 4.3.2 change size font
>
> Hi, I have installed pmapper 4.3.2, mapserver 6.0.1 and my question is that
> the font size increases when a pdf printing is performed?. Otherwise the
> font size is equal to the plane.
>
> Attached images to view.
>
> Pmapper 1st option: print as image in the browser
>
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_print_option_1.jpg>
>
> Pmapper 2nd option: print as pdf in the browser
>
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_print_option_2.jpg>
>
> Pmapper 3rd option: download image with resolution as
>
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_download_option.jpg>
>
>
> Why in pdf print change the font size?
>
>
>
> --
> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Print-pdf-in-pmapper-4-3-2-change-size-font-tp4025542.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>

-- 


Thomas RAFFIN
Chef de Projet Internet
tr...@si... <mailto:tr...@si...> 	Sirap <http://sirap.fr> 	Tel 
: 04 75 72 84 10
Fax : 04 75 70 07 98
Rue Paul Louis Héroult - BP 253
26106 Romans cedex

[pmapper-users] Print pdf in pmapper 4.3.2 change size font

[nando_gcia <nan...@ho...>]

Print pdf in pmapper 4.3.2 change size font

Hi, I have installed pmapper 4.3.2, mapserver 6.0.1 and my question is that
the font size increases when a pdf printing is performed?. Otherwise the
font size is equal to the plane.

Attached images to view.

Pmapper 1st option: print as image in the browser

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_print_option_1.jpg> 

Pmapper 2nd option: print as pdf in the browser

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_print_option_2.jpg> 

Pmapper 3rd option: download image with resolution as

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025542/pmapper_-_download_option.jpg> 


Why in pdf print change the font size?



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/Print-pdf-in-pmapper-4-3-2-change-size-font-tp4025542.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] intersect with selection management plugin

[jose m. <jos...@gm...>]

after correcting the local error as you said, now my js file is equal to the
last revision (1337) avaiable in the trunk repository but the problem with
INTERSECT with Selection Management Plugin remains.

and I posted another question too:

if it is possible to load the Selection Management Plugin with Search Tool
Plugin (as with the Graphical Queries Plugin and Query Editor Plugin)?

I hope you can help me!

Thank you very much Thomas



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025541.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] intersect with selection management plugin

[Thomas R. <tr...@si...>]

As seen together, it was due to local errors in your js file.

Le 16/07/2014 13:08, jose mvm a écrit :
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/qe.jpg>
>
> the query editor pugin automatically detect the field type.
> the error ocurs when i presse "add".
>
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/post.jpg>
>
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/get.jpg>
>
>
>
>
>
> --
> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025539.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>

-- 


Thomas RAFFIN
Chef de Projet Internet
tr...@si... <mailto:tr...@si...> 	Sirap <http://sirap.fr> 	Tel 
: 04 75 72 84 10
Fax : 04 75 70 07 98
Rue Paul Louis Héroult - BP 253
26106 Romans cedex

Re: [pmapper-users] intersect with selection management plugin

[jose m. <jos...@gm...>]

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/qe.jpg> 

the query editor pugin automatically detect the field type.
the error ocurs when i presse "add".

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/post.jpg> 

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025539/get.jpg> 





--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025539.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] intersect with selection management plugin

[Thomas R. <tr...@si...>]

Well, the "getFieldType(ecopontos_gesamb, %)" in error log tell us that 
the plugin is trying to read the data type for a table named 
"(ecopontos_gesamb" and an attribute named "%"...

Can you send me:
- a screenhsot of the query editor dialog just after selecting this 
field en its type (that is not automatically return due to this error)
- the query parameters (GET en POST) (with Firebug in Firefox, or 
development tool in chrome)

Le 16/07/2014 12:26, jose mvm a écrit :
> Hi Thomas!
>
> Here is an example:
>
> LAYER
> 	NAME "GESAMB_EcoPontos"
> 	STATUS DEFAULT
> 	TYPE POINT
> 	CONNECTIONTYPE POSTGIS
> 	CONNECTION "host=xxx.xxx.xxx.xxx port=5432 dbname=pmapper user=xxx
> password=xxx"
> 	DATA "the_geom FROM ecopontos_gesamb USING UNIQUE gid"
> 	CLASSITEM "tipo"
> 	TEMPLATE "void"
> 	METADATA
> 		DESCRIPTION "GESAMB - Ecopontos"
> 		RESULT_FIELDS "numero, papel, embalagens, vidro, pilhao, oleao, tipo,
> propriet, observ, freguesia, first_lug1, designacao"
> 		RESULT_HEADERS "Numero, Papel, Embalagens, Vidro, Pilhao, Oleao, Tipo,
> Proprietario, Observacoes, Freguesia, Localidade, Local"
> 		"LAYER_ENCODING" "UTF-8"
> 	END
> 	CLASS
> 		NAME 'Ecoponto'
> 		EXPRESSION 'Superfície'
> 		STYLE
> 			COLOR 62 118 181
> 			OUTLINECOLOR 0 0 0
> 			SYMBOL 'square'
> 			SIZE 10
> 		END
> 	END
> 	CLASS
> 		NAME 'Vidrao'
> 		EXPRESSION "Vidrão"
> 		STYLE
> 			COLOR 87 200 92
> 			OUTLINECOLOR 0 0 0
> 			SYMBOL 'circle'
> 			SIZE 10
> 		END    		
> 	END 	
> END
> ===========================================
> The
>
> "ERROR - Easy_MDB2 - getFieldType(ecopontos_gesamb, %) - : MDB2 Error: not
> found"
>
> occurs with all layers whenever I use queryeditor plugin, although the table
> shows the desired results.
>
> Thank you very much for your help.
>
>
>
> --
> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025537.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users

-- 


Thomas RAFFIN
Chef de Projet Internet
tr...@si... <mailto:tr...@si...> 	Sirap <http://sirap.fr> 	Tel 
: 04 75 72 84 10
Fax : 04 75 70 07 98
Rue Paul Louis Héroult - BP 253
26106 Romans cedex

Re: [pmapper-users] intersect with selection management plugin

[jose m. <jos...@gm...>]

Hi Thomas!

Here is an example:

LAYER
	NAME "GESAMB_EcoPontos"
	STATUS DEFAULT
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=xxx.xxx.xxx.xxx port=5432 dbname=pmapper user=xxx
password=xxx"
	DATA "the_geom FROM ecopontos_gesamb USING UNIQUE gid"
	CLASSITEM "tipo"
	TEMPLATE "void"
	METADATA
		DESCRIPTION "GESAMB - Ecopontos"
		RESULT_FIELDS "numero, papel, embalagens, vidro, pilhao, oleao, tipo,
propriet, observ, freguesia, first_lug1, designacao"
		RESULT_HEADERS "Numero, Papel, Embalagens, Vidro, Pilhao, Oleao, Tipo,
Proprietario, Observacoes, Freguesia, Localidade, Local"
		"LAYER_ENCODING" "UTF-8"
	END
	CLASS
		NAME 'Ecoponto'
		EXPRESSION 'Superfície'
		STYLE
			COLOR 62 118 181
			OUTLINECOLOR 0 0 0
			SYMBOL 'square'
			SIZE 10
		END
	END
	CLASS
		NAME 'Vidrao'
		EXPRESSION "Vidrão"
		STYLE
			COLOR 87 200 92
			OUTLINECOLOR 0 0 0
			SYMBOL 'circle'
			SIZE 10
		END    		
	END 	
END
===========================================
The

"ERROR - Easy_MDB2 - getFieldType(ecopontos_gesamb, %) - : MDB2 Error: not
found"

occurs with all layers whenever I use queryeditor plugin, although the table
shows the desired results.

Thank you very much for your help.



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025537.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] intersect with selection management plugin

[Thomas R. <tr...@si...>]

Hi,

Can you write here your layer definition please (ie: the mapfile part).

Le 15/07/2014 21:47, jose mvm a écrit :
> I also get these errors and notices when i search with query editor plugin:
>
> [15-Jul-2014 19:45:10 UTC] ERROR - Easy_MDB2 -
> getFieldType(ecopontos_gesamb, %) - :
> MDB2 Error: not found
> [15-Jul-2014 19:45:10 UTC] ERROR - Easy_MDB2 -
> getFieldType(ecopontos_gesamb, %) - :
> MDB2 Error: not found
> [15-Jul-2014 19:45:11 UTC] PHP Notice:  Undefined index: fldName in
> /var/www/pmapper-4.3.2/incphp/query/query.php on line 721
> [15-Jul-2014 19:45:12 UTC] PHP Notice:  Undefined variable: mode in
> /var/www/pmapper-4.3.2/plugins/queryeditor/x_queryeditor.php on line 304
>
> but query shows the expected results.
>
> thanks
>
>
>
> --
> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025535.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>

-- 


Thomas RAFFIN
Chef de Projet Internet
tr...@si... <mailto:tr...@si...> 	Sirap <http://sirap.fr> 	Tel 
: 04 75 72 84 10
Fax : 04 75 70 07 98
Rue Paul Louis Héroult - BP 253
26106 Romans cedex

Re: [pmapper-users] intersect with selection management plugin

[jose m. <jos...@gm...>]

I also get these errors and notices when i search with query editor plugin:

[15-Jul-2014 19:45:10 UTC] ERROR - Easy_MDB2 -
getFieldType(ecopontos_gesamb, %) - :
MDB2 Error: not found
[15-Jul-2014 19:45:10 UTC] ERROR - Easy_MDB2 -
getFieldType(ecopontos_gesamb, %) - :
MDB2 Error: not found
[15-Jul-2014 19:45:11 UTC] PHP Notice:  Undefined index: fldName in
/var/www/pmapper-4.3.2/incphp/query/query.php on line 721
[15-Jul-2014 19:45:12 UTC] PHP Notice:  Undefined variable: mode in
/var/www/pmapper-4.3.2/plugins/queryeditor/x_queryeditor.php on line 304

but query shows the expected results.

thanks



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/intersect-with-selection-management-plugin-tp4025534p4025535.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] Search several database columns at the same time with the same search field

[Pedro V. <ped...@ya...>]

Hi

I tried in several ways, but without success, because I had to get the content of col1 and col2.

Then I remembered to do it the right way and normalized the database. So now it is working with a FULL OUTER JOIN.

Thanks for your support!


Best regards,
Pedro

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[nando_gcia <nan...@ho...>]

All right, now it works perfectly. Thank you all and of course Armin



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025532.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] Search several database columns at the same time with the same search field

[Suman <an...@ya...>]

I think you should do this

SELECT DISTINCT id FROM table 
WHERE col_1 ilike '^[search]' OR col_2 ilike '^[search]' 
ORDER BY col_1 

to obtain your expected result.

and this will only show the id in suggest list.

i think this will help you. Enjoy 

suman





--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-Search-several-database-columns-at-the-same-time-with-the-same-search-field-tp4025500p4025531.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] Search several database columns at the same time with the same search field

[Pedro V. <ped...@ya...>]

Hi Armin,

Thank you very much for your help!

My goal is to have only one search form field, and use the value inserted there to do the search in two columns at the same time. That is, search the same value in both columns.

For example, this table

id | col1 | col2
1 | 2001 | 2005
2 | 2006 | 2008
3 | 2007 | 2011
4 | 2008 | 2013
...

I want to something like this query

SELECT id, col_1, col2 FROM table 
WHERE col_1 ilike '%2008%' OR col_2 ilike '%2008%' 
ORDER BY col_1

to obtain this result

id | col1 | col2
2 | 2006 | 2008
4 | 2008 | 2013


Do you think this is possible?


Thanks!

Best regards,
Pedro

Re: [pmapper-users] Search several database columns at the same time with the same search field

[Armin B. <arm...@gm...>]

I would guess something like that (haven't fully understood what you 
want, though...) could be achieved via the "sql_where" definition in the 
XML file,

I found an old sample like

<searchitem name="cmeu01" description="Communes">
   <layer type="postgis" name="cmeu01">
     <field type="s" name="cmbname" description="Name" wildcard="1"/>
     <field type="n" name="id" description="Commune ID"/>
     <sql_from>cmeu01</sql_from>
     <sql_where>(cmbname ~* '[cmbname]' OR cminame ~* '[cmbname]') AND 
id = [id]</sql_where>
   </layer>
</searchitem>


If the <sql_from> tag is really used I don't remember any more.


armin


On 07/11/2014 09:08 PM, Pedro Venâncio wrote:
> Hi,
>
> Do you think this is possible just configuring the search in the config_xxx.xml? I've tried several ways, but without success.
>
>
> Thanks.
>
> Best regards,
> Pedro
>
>
>
>
>
> ----- Mensagem original -----
>> DE: Pedro
>>
>> Hi,
>>
>> I'm trying to create a search of type suggest, that search multiple columns
>> of a PostGIS layer, at the same time.
>>
>> For example,
>>
>> col1 | col2
>> a | b
>> c | d
>> e | f
>> ...
>>
>>
>> I tried this:
>>
>> <searchitem name="n_casas" description="Casas">
>>      <layer type="postgis" name="tipo">
>>          <field type="s" name="col1"
>> alias="nomes" description="Nome" wildcard="0"
>> operator="OR">
>>              <definition type="suggest"
>> connectiontype="db" minlength="0" sort="asc">
>>                  <dsn
>> encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn>
>>                  <sql>SELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~*
>> '[search]' ORDER BY col1</sql>
>>              </definition>
>>          </field>
>>          <field type="s" name="col2"
>> alias="nomes" operator="OR">
>>              <definition type="suggest"
>> connectiontype="db" minlength="0" sort="asc">
>>                  <dsn
>> encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn>
>>                  <sql>SELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~*
>> '[search]' ORDER BY col2</sql>
>>              </definition>
>>          </field>
>>      </layer>
>> </searchitem>
>>
>>
>> This way I can search and get the correct result. However, two fields are
>> displayed to do the search (image attached), and I want to just get one field,
>> where it does the search for the values ​​of the two columns (col1 and col2).
>>
>> Any suggestions?
>>
>> Thank you very much!
>>
>> Best regards,
>> Pedro
>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

Re: [pmapper-users] Search several database columns at the same time with the same search field

[Pedro V. <ped...@ya...>]

Hi,

Do you think this is possible just configuring the search in the config_xxx.xml? I've tried several ways, but without success.


Thanks.

Best regards,
Pedro





----- Mensagem original -----
> DE: Pedro 
> 
> Hi,
> 
> I'm trying to create a search of type suggest, that search multiple columns 
> of a PostGIS layer, at the same time.
> 
> For example,
> 
> col1 | col2
> a | b
> c | d
> e | f
> ...
> 
> 
> I tried this:
> 
> <searchitem name="n_casas" description="Casas">
>     <layer type="postgis" name="tipo">
>         <field type="s" name="col1" 
> alias="nomes" description="Nome" wildcard="0" 
> operator="OR">
>             <definition type="suggest" 
> connectiontype="db" minlength="0" sort="asc">
>                 <dsn 
> encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn>
>                 <sql>SELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* 
> '[search]' ORDER BY col1</sql>
>             </definition>
>         </field> 
>         <field type="s" name="col2" 
> alias="nomes" operator="OR">
>             <definition type="suggest" 
> connectiontype="db" minlength="0" sort="asc">
>                 <dsn 
> encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn>
>                 <sql>SELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* 
> '[search]' ORDER BY col2</sql>
>             </definition>
>         </field> 
>     </layer>
> </searchitem>
> 
> 
> This way I can search and get the correct result. However, two fields are 
> displayed to do the search (image attached), and I want to just get one field, 
> where it does the search for the values ​​of the two columns (col1 and col2).
> 
> Any suggestions?
> 
> Thank you very much!
> 
> Best regards,
> Pedro
> 

Re: [pmapper-users] No Legend Wanted

[Armin B. <arm...@gm...>]

use this setting in the configuration XML:

<legendStyle>swap</legendStyle>



On 07/11/2014 06:23 PM, bean wrote:
> Is it possible to prevent the creation of a legend?
>
> I've found a few ways to prevent the creation but they all throw
> errors in the log. I'd like to do this cleanly but I'm not great at
> PHP. Can someone point me in the right direction?
>
> bean
>
> ------------------------------------------------------------------------------
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[Armin B. <arm...@gm...>]

now also committed to pm 4 trunk

http://svn.pmapper.net/trac/changeset/1338



On 07/11/2014 07:23 PM, Armin Burger wrote:
> the layout samples *.phtml files have not been updated to reflect some
> changes a while ago for allowing custom orders of JS files.
>
> In your map_plainlayout*.phtml files search for the line (around line 66)
>       echo $jsConfigReference;
>
> and add afterwards the additional line:
>       echo $jsCustomReference;
>
> Then the custom.js from the config directories should be loaded. The
> "map_default.phtml" already has that correctly set.
>
> armin
>
>
> On 07/11/2014 06:16 PM, nando_gcia wrote:
>> Works perfectly with the "default" folder. I modified the file
>> \pmapper\pmapper_demodata\countries.shp adding a new column called
>> "pdf_files" with the value "data1.pdf" in the country of Spain, after I
>> edited \pmapper-4.3.2\config\default\pmapper_demo.map
>>
>>       "RESULT_FIELDS"
>> "ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
>>       "RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
>>       "RESULT_HYPERLINK" "pdf_files||Link to detail"
>>
>> And it works perfectly, so the problem is that the template plainlayout3.
>> Also js_config.php file is different than exists in the "default" folder.
>>
>> Can anyone help me fix it?
>>
>>
>>
>> --
>> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.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
>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[Armin B. <arm...@gm...>]

the layout samples *.phtml files have not been updated to reflect some 
changes a while ago for allowing custom orders of JS files.

In your map_plainlayout*.phtml files search for the line (around line 66)
     echo $jsConfigReference;

and add afterwards the additional line:
     echo $jsCustomReference;

Then the custom.js from the config directories should be loaded. The 
"map_default.phtml" already has that correctly set.

armin


On 07/11/2014 06:16 PM, nando_gcia wrote:
> Works perfectly with the "default" folder. I modified the file
> \pmapper\pmapper_demodata\countries.shp adding a new column called
> "pdf_files" with the value "data1.pdf" in the country of Spain, after I
> edited \pmapper-4.3.2\config\default\pmapper_demo.map
>
>      "RESULT_FIELDS"
> "ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
>      "RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
>      "RESULT_HYPERLINK" "pdf_files||Link to detail"
>
> And it works perfectly, so the problem is that the template plainlayout3.
> Also js_config.php file is different than exists in the "default" folder.
>
> Can anyone help me fix it?
>
>
>
> --
> View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.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
>

[pmapper-users] No Legend Wanted

[bean <be...@wa...>]

Is it possible to prevent the creation of a legend?

I've found a few ways to prevent the creation but they all throw 
errors in the log. I'd like to do this cleanly but I'm not great at 
PHP. Can someone point me in the right direction?

bean

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[nando_gcia <nan...@ho...>]

Works perfectly with the "default" folder. I modified the file
\pmapper\pmapper_demodata\countries.shp adding a new column called
"pdf_files" with the value "data1.pdf" in the country of Spain, after I
edited \pmapper-4.3.2\config\default\pmapper_demo.map

    "RESULT_FIELDS"
"ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
    "RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
    "RESULT_HYPERLINK" "pdf_files||Link to detail"

And it works perfectly, so the problem is that the template plainlayout3.
Also js_config.php file is different than exists in the "default" folder.

Can anyone help me fix it? 



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[nando_gcia <nan...@ho...>]

Raffaele, I've read the documentation pmapper, but I do not know how to fix
the "plainlayout3" template to run the Hyperlink. 



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025522.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[Raffaele M. <raf...@gm...>]

2014-07-11 13:28 GMT+02:00 nando_gcia <nan...@ho...>:

> I agree with you Raffaele.
>
> <
> http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025520/sources_chrome2.jpg
> >
>
> But i don't know how to fix it.
>
>
​http://svn.pmapper.net/trac/wiki/DocManual#DirectoryandFileStructure

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[nando_gcia <nan...@ho...>]

I agree with you Raffaele.

<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025520/sources_chrome2.jpg> 

But i don't know how to fix it.



--
View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025520.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com.