$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>";