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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
|
<?php
require("../main.inc.php");
$connect=mysql_connect('localhost','root','');
mysql_select_db('dolibarr');
$code=$_GET['id'];
$req=mysql_query("select lls.rowid,lls.nom,llx_extra.s_gps1 as lat , llx_extra.s_gps as lon from llx_societe lls , llx_societe_extrafields llx_extra
where lls.rowid=llx_extra.fk_object and llx_extra.c_ag='$code' ");
$listeDesPoints='';
$listeNomsociete='';
while($data=mysql_fetch_array($req))
{
$lat=$data['lat']; $lon=$data['lon'];
if($listeDesPoints!='') $listeDesPoints.=',';
$listeDesPoints.='['.$data['lat'].','.$data['lon'].','.$data['nom'].']';
$listeNomsociete.='['.$data['nom'].']';
// $nom=$data['nom'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>recouvrement</title>
<script type="text/javascript" src="js/jquery-1.8.2.js"></script>
<script type="text/javascript" src="js/jquery-ui.js"></script>
<script type="text/javascript" src="js/script.js"></script>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=true"></script>
<script type="text/javascript">
function initialize() {
var lat='<?php echo $lat; ?>'
var lon='<?php echo $lon; ?>'
var liste_des_points='<?php echo $listeDesPoints; ?>';
var maposition= new google.maps.LatLng(lat,lon);
map = new google.maps.Map(document.getElementById("carte"), {
zoom: 14,
center: maposition,
mapTypeId: google.maps.MapTypeId.ROADMAP
});
}
function generateMarkers(locations) {
for (var i = 0; i < locations.length; i++) {
new google.maps.Marker({
position: new google.maps.LatLng(locations[i][0], locations[i][1]),
map: map,
title: locations[i][2]
});
}
}
window.onload = function () {
initialize();
generateMarkers(liste_des_points);
};
</script>
<script type="text/javascript">
</script>
<link rel="stylesheet" href="css/jquery-ui.css">
<link rel="stylesheet" href="css/style.css">
</head>
<body>
<div id="carte" style="width:800px; height:600px;">
</div>
</body>
</html> |
Partager