$db_tako = $p2[$j][3];
}
if (isset($p2[$j][9])) {
$d_glan = $p2[$j][9] == "" ? '' : ($gvv == 2 ? date("G.i", $p2[$j][9] + $tz) : date("G:i:s", $p2[$j][9] + $tz));
$db_glan = $p2[$j][9];
}
if (isset($p2[$j][3]) && isset($p2[$j][9])) {
$d_gtim = duree($p2[$j][3], $p2[$j][9], $gvv, "-----");
}
// glider time
if (isset($p2[$j][4])) {
$d_plan = $p2[$j][4] == "" ? '' : ($gvv == 2 ? date("G.i", $p2[$j][4] + $tz) : date("G:i:s", $p2[$j][4] + $tz));
$db_plan = $p2[$j][4];
}
if (isset($p2[$j][3]) && isset($p2[$j][4])) {
$d_ptim = duree($p2[$j][3], $p2[$j][4], $gvv, "-----");
}
// plane time
if ($p2[$j][11] != '') {
$d_malt = $db_malt = "{$p2[$j][11]}";
}
// Altitude Max
if ($torecord == true) {
$torecordreq .= "('{$dbdate}','{$airfield}','{$num}','{$d_preg}','{$d_pmod}','{$db_plan}','{$d_greg}','{$d_gcn}','{$d_gmod}','{$db_glan}','{$db_tako}','{$db_malt}','{$d_pfid}','{$d_gfid}'),";
}
if ($d_malt != '' && $d_malt != '----') {
if ($alti == "QFE") {
$d_malt = $d_malt - $airfieldaltitude;
}
$d_malt = round($d_malt * $m2f);
}
}
} else {
$duree = 0;
}
echo "<TR bgcolor='#eeeeee'><TD>1 Mois </TD><TD>" . $somme . "</TD><TD>" . duree($duree) . "</TD><td>" . intval($duree / 3600 * $conso) . " Wh</td></TR>";
$query0 = "SELECT SUM(actif) AS somme, date FROM `periph_" . $periph['nom'] . "` WHERE date < curdate() AND date > DATE_SUB(curdate(), INTERVAL 1 YEAR)";
$req0 = mysql_query($query0, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error());
$value0 = mysql_fetch_assoc($req0);
if (!($value0['somme'] == NULL)) {
$somme = $value0['somme'];
} else {
$somme = 0;
}
if (!($somme == 0)) {
$duree = 0;
$query0 = "SELECT date FROM `periph_" . $periph['nom'] . "` WHERE actif = 1 AND date < curdate() AND DATE_FORMAT(`date`, '%Y%m%d') > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), '%Y%m%d') ORDER BY DATE_FORMAT(`date`, '%Y%m%d') DESC";
$req0 = mysql_query($query0, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error());
while ($value0 = mysql_fetch_assoc($req0)) {
$query1 = "SELECT `date` FROM `periph_" . $periph['nom'] . "` WHERE actif = 0 AND `date` > '" . $value0['date'] . "' ORDER BY `date` LIMIT 1";
$req1 = mysql_query($query1, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error());
$value1 = mysql_fetch_assoc($req1);
$query2 = "SELECT TIMESTAMPDIFF(SECOND, '" . $value0['date'] . "', '" . $value1['date'] . "') AS duree";
$req2 = mysql_query($query2, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error());
$value2 = mysql_fetch_assoc($req2);
$duree += $value2['duree'];
}
} else {
$duree = 0;
}
echo "<TR bgcolor='#dddddd'><TD>1 An </TD><TD>" . $somme . "</TD><TD>" . duree($duree) . "</TD><td>" . intval($duree / 3600 * $conso) . " Wh</td></TR>";
echo "</TABLE></CENTER>";
