Mercurial > bms / file diff

--- a/www/crontasks.php	Tue Jan 21 21:16:26 2020 +0100
+++ b/www/crontasks.php	Wed Jan 29 13:26:01 2020 +0100
@@ -76,7 +76,7 @@
 /*
  * Check fementation logs.
  */
-$query = "SELECT record,code,name,log_brew,log_fermentation FROM products;";
+$query = "SELECT record,code,name,log_brew,log_fermentation,log_ispindel 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,16 @@
 		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);
+        }
 }