Hi,
I would like to display markers on the google map from Apex.
knowing that I have a table "client" in database oracle :
code_client | adresse_client | laltitude | longitude | order
---------------------------------------------------------------------------------------
00001 | Adresse1 | 30.45985 | -9.660478333 | 1
00002 | Adresse2 | 30.45674333|-9.659188333 | 2
00002 | Adresse2 | 30.50261333|-9.660558333 | 3
.
.
.
---------------------------------------------------------------------------------------------
I create Page in Apex and Region ..... in Body of this region I have this javascript code :
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>Google Maps Multiple Markers</title>
<script src="http://maps.google.com/maps/api/js?sensor=false"
type="text/javascript"></script>
</head>
<body>
<div id="map" style="width: 500px; height: 400px;"></div>
<script type="text/javascript">
var locations = [
['Bondi Beach', -33.890542, 151.274856, 4],
['Coogee Beach', -33.923036, 151.259052, 5],
['Cronulla Beach', -34.028249, 151.157507, 3],
['Manly Beach', -33.80010128657071, 151.28747820854187, 2],
['Maroubra Beach', -33.950198, 151.259302, 1]
];
var map = new google.maps.Map(document.getElementById('map'), {
zoom: 10,
center: new google.maps.LatLng(-33.92, 151.25),
mapTypeId: google.maps.MapTypeId.ROADMAP
});
var infowindow = new google.maps.InfoWindow();
var marker, i;
for (i = 0; i < locations.length; i++) {
marker = new google.maps.Marker({
position: new google.maps.LatLng(locations
[1], locations[i][2]),
map: map
});
google.maps.event.addListener(marker, 'click', (function(marker, i) {
return function() {
infowindow.setContent(locations[i][0]);
infowindow.open(map, marker);
}
})(marker, i));
}
</script>
</body>
</html>
-----------------------------
this is a static data in this example but
I want to Replace this array :
var locations = [
['Bondi Beach', -33.890542, 151.274856, 4],
['Coogee Beach', -33.923036, 151.259052, 5],
['Cronulla Beach', -34.028249, 151.157507, 3],
['Manly Beach', -33.80010128657071, 151.28747820854187, 2],
['Maroubra Beach', -33.950198, 151.259302, 1]
];
by my table "client" :
does anyone 'can help me display markers by coordinates "laltitude" and "longitude" and display the infowindow "code_client" and "order" by clicking on the marker!???
thanks