Mercurial > bms / file diff

--- a/www/crontasks.php	Fri Oct 18 13:20:35 2019 +0200
+++ b/www/crontasks.php	Fri May 01 16:37:31 2020 +0200
@@ -74,9 +74,9 @@
 
 
 /*
- * Check fementation logs.
+ * Check several logs.
  */
-$query = "SELECT record,code,name,log_brew,log_fermentation FROM products;";
+$query = "SELECT record,code,name,log_brew,log_fermentation,log_ispindel,log_co2pressure FROM products;";
 $result = mysqli_query($connect, $query);
 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 	$logfile = "log/fermentation/" . $row['code'] . " " . $row['name'] . ".log";
@@ -89,6 +89,26 @@
 		syslog(LOG_NOTICE, $query);
 		$result1 = mysqli_query($connect, $query);
 	}
+	$logfile = "log/ispindel/" . $row['code'] . " " . $row['name'] . ".log";
+	if (file_exists($logfile))
+                $ok = 1;
+        else
+                $ok = 0;
+        if ($ok != $row['log_ispindel']) {
+                $query = "UPDATE products SET log_ispindel='" . $ok . "' WHERE record='" . $row['record'] . "';";
+                syslog(LOG_NOTICE, $query);
+                $result1 = mysqli_query($connect, $query);
+        }
+	$logfile = "log/co2pressure/" . $row['code'] . " " . $row['name'] . ".log";
+        if (file_exists($logfile))
+                $ok = 1;
+        else
+                $ok = 0;
+        if ($ok != $row['log_co2pressure']) {
+                $query = "UPDATE products SET log_co2pressure='" . $ok . "' WHERE record='" . $row['record'] . "';";
+                syslog(LOG_NOTICE, $query);
+                $result1 = mysqli_query($connect, $query);
+        }
 }