APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

 

Top Rated Plugins

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

You are here:
Follow us on Twitter
Item Plugin EXTENSION Warp11 GMaps item

EXTENSION Warp11 GMaps item

9
Categories: Item Plugin
Author: Josep

Custom pin images & latitude/longitude positioning

Updated by JCoves v1.0

================

Added the following attributes at SQL Query:

  • Icon: Use custom pin image, specify the image URL 
  • Latlong: Specify Latitude and Longitude instead of address to increase performance on multiple markers. Ex: 41.380268, 2.190475

================

Original Pluguin

================ 

The Warp11 GMaps plugin provides an easy way of incorporating a Google Map on your page.

The plugin was created bij Richard & Sergei Martens of the Warp 11 Center of Excellence.

The plugin uses a number of parameters / settings:

  • StreetViewControl
  • navigationControl
  • maptype
  • mapTypeControl
  • mapTypeControl_position
  • mapTypeControl_style
  • address (page item)
  • zoom (integer)

It is essential that the page-items mentioned in the settings are rendered before then gmaps plugin. Otherwise the plugin cannot read the values. The page items can be of the hidden type.

Width and Hight of the page-item are used to create the map.

More information can be found at http://apex.warp11.nl


Keywords
Googlemaps, multiple location, gmaps, google, map,maps, gmap

Company: Freelance
Date added: 4.8.2011
Views: 2836
Votes: 5
Reviews: 24
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
Share code for a sample page
by Patrick Miller
on January 27, 2013
Hi,
I have not been able to get maps to show up on a page following instructions. Can someone make available a sample application where we can look at the code in a page that is displaying correctly?

Thanks,
Pat
0 
by falhi
on October 23, 2012
i Use 4 Tables in my Query and
in "Infowindow" of each Marker i show 5 colums from this Tables :

(in "Infowindow")

Number : -----
Adresse : ------
Customer : -----
code : -----
Picture : Link (Link to Pop Up)

and of course latitude and longitude in parametres.

if it less than 50 markers it work
if it more than 50 markers Page Load slowly and Plugin show markers slowly and if you want zoom it make a lot of time
and if you show 300 markers it give you messge box "this Script must be stop"
0 
by Josep
on October 23, 2012
Hi Falhi,

For big number of markers you should use "latlong" parameter and inform latitude and longitude instead of "text address".

If you specify text address it makes an AJAX call for each marker (which is really slow). Instead, you should save each pin location once located and use that location instead of text adress.

Hope that helps. You can see a running sample of this version at
http://apex.oracle.com/pls/apex/f?p=JOSEPCOVES
0 
by falhi
on October 23, 2012
today on my server there was an update for java 6 to 7 I install then
I test a table of 300 markers to display the page that loads and does nothing after a few seconds gives me error that need to stop this script!

I tested with 200 markers same result,
UNTIL 50 markers markers appear on the map and slowly but very lorde to manipulate the zoom

:-(

3 days ago I tested with 50 it works very well but now nn
is that there is a connection with java?!? and how to solve the problem!
0 
Maximum Markers
by Josep
on October 23, 2012
Hi Falhi,

There is no limit for markers. What bug did you find? Could you publish any sample online?
0 
Maximum Markers !?
by falhi
on October 23, 2012
when I add more than 200 markers plugin bug??!
what is a maximum number of markers that must not be exceeded??

I have more than 3000 markers to show :-(
0 
by Josep
on October 22, 2012
Hi Andy,

Good enhacement! With APEX 4.2 there's the possibility to add extra attrubites, we can expand the plugin and unify it in my plugin.

Could you send me the plugin export?
josepcoves (at) relational.es
10 
by Andy C Chow
on October 20, 2012
I made some minor changes to the plugin and it showed the circles - with various scales - instead of custom markers. Here is what I did:

Added another variable to hold the 7th column in the SQL for scale:
t_scale number(10,2);

Changed the following section from '4 - 6' to '4 - 7':
t_column_value_list := apex_plugin_util.get_data (
p_sql_statement => p_item.lov_definition,
p_min_columns => 4,
p_max_columns => 7, -- was 6 before
p_component_name => p_item.id);

Added the following section:
if (t_column_value_list.EXISTS(7)) then
t_scale := t_column_value_list(7)(i);
end if;

Changed the following section for icon:
if (t_pin_icon is null) then
htp.p(' icon: {path: google.maps.SymbolPath.CIRCLE,
strokeColor:"#FFFFFF",
strokeOpacity:1.0,
strokeWeight:0.5,
fillColor:"#FF0000",
fillOpacity:0.5,
scale: ' || nvl(t_scale,4) * 3 || '},'); -- show enlarged circles
else
htp.p(' icon:"'||t_pin_icon||'",'); -- show custom markers
end if;

----------------

That was it and it worked.

Thanks.
10 
gomap overlays
by Andy C Chow
on October 20, 2012
Hi,

This plugin is very nice. I downloaded the new version of the jquery.gomap plugin. I would like to implement the overlays (particularly circles) to the map - beside the custom markers. Could you kindly show me how to make it work in your plugin?

http://www.pittss.lv/jquery/gomap/solutions/overlays.html

Thanks.
0 
APEX IR PLUGIN
by falhi
on October 19, 2012
thanks for your answers,

to show you an example of plugin what i want ,
this is an example of plugin map with his IR click plugin,
when you click in the Row Plugin Map move map to your marker Selected in de Report

http://www.gx-samples.com:8888/apex/f?p=100:LOGIN:75072524015801

when you download a plugin you have 2 plugin

1)dynamic_action_plugin_de_fichtner_fit_ir_col_click
2) OpenLayers_Plugin_UTF8

without render map it use only center map
From interactive report to Plugin map

can you Create this Action Plugin for your Plugin Map ??
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.