}
//debuttxt
//$tbl_info=adressegps($tmptrajet[$j]["lat1"],$tmptrajet[$j]["lon1"]);
if ($j == 0) {
$tbl_info = adressegps($tmptrajet[$j]["lat1"], $tmptrajet[$j]["lon1"]);
} else {
$tbl_info = adressegps($tmptrajet[$j - 1]["lat2"], $tmptrajet[$j - 1]["lon2"]);
}
if (is_array($tbl_info)) {
$debut = $tbl_info["adresse"] . "<br><img src=\"" . __racineweb__ . "/tpl/img/lieux/" . $tbl_info["icon"] . "\"> <span>" . $tbl_info["libelle"] . "</span>";
} else {
$debut = $tbl_info;
}
$tmptrajet[$j]["debuttxt"] = "<span>" . affichedatetime($tmptrajet[$j]["debut"]) . "</span><br>" . $debut;
//fintxt
$tbl_info = adressegps($tmptrajet[$j]["lat2"], $tmptrajet[$j]["lon2"]);
if (is_array($tbl_info)) {
$fin = $tbl_info["adresse"] . "<br><img src=\"" . __racineweb__ . "/tpl/img/lieux/" . $tbl_info["icon"] . "\"> <span>" . $tbl_info["libelle"] . "</span>";
} else {
$fin = $tbl_info;
}
//$tmptrajet[$j]["fintxt"]=$fin;
$tmptrajet[$j]["fintxt"] = "<span>" . affichedatetime($tmptrajet[$j]["fin"]) . "</span><br>" . $fin;
$tmptrajet[$j]["km"] = round($tmptrajet[$j]["km"], 2);
$totaldistance += $tmptrajet[$j]["km"];
if ($tmptrajet[$j]["lat2"] == "" && $tmptrajet[$j]["lon2"] == "") {
$tmptrajet[$j]["lat2"] = $tmptrajet[$j]["lat1"];
$tmptrajet[$j]["lon1"] = $tmptrajet[$j]["lon1"];
$tmptrajet[$j]["fin"] = "";
$tmptrajet[$j]["fintxt"] = $tmptrajet[$j]["debuttxt"];
$tmptrajet[$j]["datediff"] = "-";
//print $sql."<br>";
$link = query($sql);
$nbgo = 0;
$nbstay = 0;
while ($tbl = fetch($link)) {
//recherche catégorie
$sql = "select * from " . __racinebd__ . "categorie_compte_device ccd\r\n inner join " . __racinebd__ . "categorie_compte cc on ccd.categorie_compte_id=cc.categorie_compte_id where device_id=" . $tbl["phantom_device_id"];
//print $sql;
$link2 = query($sql);
$tbl_list_cat = array();
while ($tbl2 = fetch($link2)) {
$tbl_list_cat[] = $tbl2["libelle"];
}
$tbl["listcat"] = implode(", ", $tbl_list_cat);
$debut = "";
$tbl_info = adressegps($tbl["latitude"], $tbl["longitude"]);
if (is_array($tbl_info)) {
$debut .= "<img src=\"" . __racineweb__ . "/tpl/img/lieux/" . $tbl_info["icon"] . "\"> <span>" . $tbl_info["libelle"] . "</span>";
} else {
$debut .= $tbl_info;
}
$tbl["adresse"] = $debut;
$tbl["agence"] = $key_list_agence[$tbl["agence_compte_id"]];
$tabval = etatvoiturecouleur($tbl["phantom_device_id"]);
$tbl["couleur"] = $tabval[1];
if ($tabval[0] == 1) {
$nbgo++;
$tbl["moteur"] = "Moteur Allumé";
} else {
$nbstay++;
$tbl["moteur"] = "Moteur Eteint";
