calculate_horizontal_cylinder_volume( $tank['radius_mm'], ($tank['radius_mm'] * 2) - ($dist + $tank['add_to_distance']), $tank['length_mm'] ); return $res['fluid_volume_liters']; } foreach ($tank_ids as $id) { $t_res = $db->query("tanks", "SELECT * FROM tanks WHERE record_id = $id"); $t = $t_res->fetch_assoc(); $sql_graph = "SELECT *, FROM_UNIXTIME(FLOOR(UNIX_TIMESTAMP(date_time_measured) / ($interval_min * 60)) * ($interval_min * 60)) as interval_time FROM tank_level_log WHERE tank_id = $id AND date_time_measured BETWEEN '$from_date' AND '$to_date' GROUP BY interval_time ORDER BY interval_time ASC"; $g_res = $db->query("tank_level_log", $sql_graph); $labels = []; $values = []; while ($row = $g_res->fetch_assoc()) { $labels[] = date("H:i", strtotime($row['interval_time'])); $values[] = round(calcVol($func, $t, $row['distance'])); } $start_log = $db->query("tank_level_log", "SELECT distance FROM tank_level_log WHERE tank_id=$id AND date_time_measured <= '$from_date' ORDER BY date_time_measured DESC LIMIT 1")->fetch_assoc(); $end_log = $db->query("tank_level_log", "SELECT distance FROM tank_level_log WHERE tank_id=$id AND date_time_measured <= '$to_date' ORDER BY date_time_measured DESC LIMIT 1")->fetch_assoc(); $start_v = calcVol($func, $t, $start_log['distance'] ?? null); $end_v = calcVol($func, $t, $end_log['distance'] ?? null); $report_data[] = [ 'id' => $id, 'name' => $t['name'], 'start' => $start_v, 'end' => $end_v, 'diff' => $end_v - $start_v, 'max' => count($values) > 0 ? max($values) : 0, 'min' => count($values) > 0 ? min($values) : 0, 'labels' => $labels, 'values' => $values ]; } ?>

Inventory Report

— (m Intervals)
Close

Executive Summary

= 0) ? 'diff-pos' : 'diff-neg'; ?>
Tank Name Start (L) End (L) Net Change
0 ? '+' : '') . number_format($row['diff']); ?>

0 ? '+' : '') . number_format($row['diff']); ?> L
Period High L
Period Low L