diff -r 3cbd81ea9391 -r d202777ebae5 www/getfermentlog.php
--- a/www/getfermentlog.php	Sat Jan 19 20:42:11 2019 +0100
+++ b/www/getfermentlog.php	Mon Jan 21 20:45:18 2019 +0100
@@ -3,57 +3,116 @@
 require_once('config.php');
 
 if (isset($_GET["code"]))
-	$code = $_GET["code"];
+	$code = $_GET["code"] . ' ' . $_GET["name"];
 else
-	$code = "TB0015";
+	$code = "TB0015 Winterbier-2";
 
-$query = "SELECT datetime,temperature_air,temperature_beer,temperature_chiller,temperature_room,target_low,target_high,heater_usage,cooler_usage FROM log_fermentation WHERE product_code='".$code."'";
-$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
-if (! $connect) {
-	echo "[]";
-	return;
+$filename = 'log/fermentation/' . $code . '.log';
+/*
+ * From Stackoverflow, the fastest way to count the lines in a file.
+ */
+$file = new \SplFileObject($filename, 'r');
+$file->seek(PHP_INT_MAX);
+// $file->key() = lines in the file.
+
+define ('MAX_INTERVALS', 10);
+$GRAPH_INTERVAL = array ( 0, 1, 5, 15, 30, 60, 120, 240, 480, 720 );
+$GRAPH_DATALINES = array ( 0, 800, 3200, 12000, 24000, 48000, 96000, 192000, 384000, 768000 );
+
+
+for ($graphstep = 1; $graphstep <= MAX_INTERVALS; $graphstep++) {
+	if ($file->key() < $GRAPH_DATALINES[$graphstep])
+		break;
 }
-$step = 600; // Must be a multiple of 300
-$ld = 0;
-$lh = 0;
-$ch = 0;
-$lc = 0;
-$cc = 0;
-$result = mysqli_query($connect, $query);
-while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
+if ($graphstep > MAX_INTERVALS)
+	$graphstep = MAX_INTERVALS;
+
+//echo $code . '.log lines=' . $file->key() . ' interval=' . $GRAPH_INTERVAL[$graphstep] . ' graphstep=' . $graphstep . PHP_EOL;
 
-	$dt = new DateTime($row['datetime'], new DateTimeZone('Europe/Amsterdam'));
-	$ts = $dt->getTimestamp();
-	$diff = $ts - $ld;
+/*
+ * 2014-11-15 18:39,BEER,PRIMARY,20.312,19.750,-1.500,20.5,18.6,18.8,35,12345,0,67890,Whatsup
+ *          |         |     |      |      |      |      |    |    |   |   |   |   |      |
+ * datetime +         |     |      |      |      |      |    |    |   |   |   |   |      |
+ * mode --------------+     |      |      |      |      |    |    |   |   |   |   |      |
+ * stage -------------------+      |      |      |      |    |    |   |   |   |   |      |
+ * temp air -----------------------+      |      |      |    |    |   |   |   |   |      |
+ * temp beer -----------------------------+      |      |    |    |   |   |   |   |      |
+ * temp chiller ---------------------------------+      |    |    |   |   |   |   |      |
+ * temp room -------------------------------------------+    |    |   |   |   |   |      |
+ * setpoint low ---------------------------------------------+    |   |   |   |   |      |
+ * setpoint high -------------------------------------------------+   |   |   |   |      |
+ * heater power ------------------------------------------------------+   |   |   |      |
+ * heater usage ----------------------------------------------------------+   |   |      |
+ * cooler power --------------------------------------------------------------+   |      |
+ * cooler usage ------------------------------------------------------------------+      |
+ * event --------------------------------------------------------------------------------+
+ */
+
+$heater_l = 0;
+$cooler_l = 0;
+
+$handle = @fopen($filename, "r");
+if ($handle) {
+	$lines = 0;
+	while (($buffer = fgets($handle, 4096)) !== false) {
+
+		$buffer = preg_replace( "/\r|\n/", "", $buffer);
+		$row = explode(",", $buffer);
+		if ($row[1] != 'Mode') {
 
-	if ($diff < $step) {
-		// Read on
-	} else if ($diff > $step) {
-		// Reset, out of sync.
-		$ld = $ts;
-		$lh = $ch = $row['heater_usage'];
-		$lc = $cc = $row['cooler_usage'];
-	} else {
-		// This is a valid timeframe.
-		$ch = $row['heater_usage'];
-		$cc = $row['cooler_usage'];
-		$heat = round(($ch - $lh) / ($step / 100));
-		$cool = round(($cc - $lc) / ($step / 100));
-//		echo $heat . ' ' . $cool . PHP_EOL;
-		$logs[] = array(
-			'date' => $row['datetime'],
-			'air' => $row['temperature_air'],
-			'beer' => $row['temperature_beer'],
-			'chiller' => $row['temperature_chiller'],
-			'room' => $row['temperature_room'],
-			'tlo' => $row['target_low'],
-			'thi' => $row['target_high'],
-			'heater' => $heat,
-			'cooler' => $cool
-		);
-		$ld = $ts;
-		$lh = $ch;
-		$lc = $cc;
+			$hr = intval(substr($buffer, 11, 2));
+			if ((($graphstep == 1)) ||
+			    (($graphstep == 2) && ((substr($buffer, 15, 1) == '0') || (substr($buffer, 15, 1) == '5'))) ||
+			    (($graphstep == 3) && ((substr($buffer, 14, 2) == '00') || (substr($buffer, 14, 2) == '15') ||
+						   (substr($buffer, 14, 2) == '30') || (substr($buffer, 14, 2) == '45'))) ||
+			    (($graphstep == 4) && ((substr($buffer, 14, 2) == '00') || (substr($buffer, 14, 2) == '30'))) ||
+			    (($graphstep == 5) && (substr($buffer, 14, 2) == '00')) ||
+			    (($graphstep == 6) && (substr($buffer, 14, 2) == '00') && (($hr % 2) == 0)) ||
+			    (($graphstep == 7) && (substr($buffer, 14, 2) == '00') && (($hr % 4) == 0)) ||
+			    (($graphstep == 8) && (substr($buffer, 14, 2) == '00') && (($hr % 8) == 0)) ||
+			    (($graphstep == 9) && (substr($buffer, 14, 2) == '00') && (($hr % 12) == 0))) {
+//				echo $hr . ' ' . $row[1] . ' ' . $buffer;
+				$lines++;
+
+				$heat_used = $cool_used = 0;
+				if ($row[10] && ($row[10] != "NA") && ($heater_l > 0)) {
+					$heat_used = round((intval($row[10]) - $heater_l) * 100 / ($GRAPH_INTERVAL[$graphstep] * 60));
+				}
+				if ($row[12] && ($row[12] != "NA") && ($cooler_l > 0)) {
+					$cool_used = round((intval($row[12]) - $cooler_l) * 100 / ($GRAPH_INTERVAL[$graphstep] * 60));
+				}
+
+
+//				echo $GRAPH_INTERVAL[$graphstep] . ' ' . $heat_used . ' ' . $cool_used . PHP_EOL;
+
+				if (($heat_used <= 100) && ($cool_used <= 100)) {
+					$logs[] = array(
+						'date' => $row[0],
+						'air' => $row[3],
+						'beer' => $row[4],
+						'chiller' => $row[5],
+						'room' => $row[6],
+						'tlo' => $row[7],
+						'thi' => $row[8],
+						'heater' => $heat_used,
+						'cooler' => $cool_used,
+						'event' => $row[13]
+					);
+				}
+
+				if ($row[10] && ($row[10] != "NA"))
+					$heater_l = intval($row[10]);
+				if ($row[12] && ($row[12] != "NA"))
+					$cooler_l = intval($row[12]);
+			}
+		}
+
 	}
+	if (!feof($handle)) {
+		echo "Error: unexpected fgets() fail\n";
+	}
+	fclose($handle);
 }
+
 echo json_encode($logs);
+//echo $lines . ' lines' . PHP_EOL;