irbis_al,
сделал следующее:
You can also read data from a table and display as markers in a map. For instance the location of clients:
Step 1: create a new blank page
Step 2: in the database, create a table where client name, address, city and country are stored. In this case, the table is called cv_klanten.
Step 3: in the database, create the following procedure:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
create or replace procedure show_markers is
cursor c_klt is
select address||', '||city||', '||country geoloc
from cv_klanten
order by id;
l_t number(3) := 0;
begin
htp.print('<script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAA1XbMiDxx_BTCY2_FkPh06RRaGTYH6UMl8mADNa0YKuWNNa8VNxQEerTAUcfkyrr6OwBovxn7TDAH5Q"" dirty="false"></script>
<script>');
htp.print('function initialize() {');
htp.print('var map = null;');
htp.print('var geocoder = null;');
htp.print('if (GBrowserIsCompatible()) {');
htp.print('map = new GMap2(document.getElementById("map_canvas"));');
htp.print('map.setCenter(new GLatLng(51.7500, 5.0000), 7);');
htp.print('map.addControl(new GLargeMapControl());');
htp.print('map.addControl(new GMapTypeControl());');
htp.print('geocoder = new GClientGeocoder();');
for r_klt in c_klt
loop
htp.print('geocoder.getLatLng(');
htp.print(''''||r_klt.geoloc||''''||',');
htp.print('function(point) {');
htp.print('var baseIcon = new GIcon(G_DEFAULT_ICON);');
htp.print('baseIcon.shadow = "http://www.google.com/mapfiles/shadow50.png";');
htp.print('baseIcon.iconSize = new GSize(20, 34);');
htp.print('baseIcon.shadowSize = new GSize(37, 34);');
htp.print('baseIcon.iconAnchor = new GPoint(9, 34);');
htp.print('baseIcon.infoWindowAnchor = new GPoint(9, 2);');
htp.print('var letteredIcon = new GIcon(baseIcon);');
htp.print('letteredIcon.image = "http://www.google.com/mapfiles/marker'||chr(65+l_t)||'.png";');
htp.print('markerOptions = { icon:letteredIcon };');
htp.print('var marker = new GMarker(point,markerOptions);');
htp.print('map.addOverlay(marker);');
htp.print('}');
htp.print(');');
l_t := l_t + 1;
end loop;
htp.print('}');
htp.print('}');
htp.print('</script>');
htp.print(' <body onload="initialize()" style="font-family: Arial;border: 0 none;">');
htp.print(' <div id="map_canvas" style="width: 500px; height: 600px"></div>');
htp.print(' </body>');
end;
/
This script uses iconic markers which are actually images which are stored at Google.com. For each letter icon there is an image available. Furthermore, you can see that the procedure loops all records of the table and for each record it places a marker on the map.
Step 4: in the created page, create a region of type PL/SQL dynamic content and include the following code:
Если я правильно понял, то выполнив эти шаги, должна получится карта с маркерами
