Mercurial > bms / changeset

--- a/www/includes/db_product.php	Wed Jul 14 20:51:45 2021 +0200
+++ b/www/includes/db_product.php	Sat Aug 21 16:14:44 2021 +0200
@@ -1093,9 +1093,7 @@
         $sql2 .= " LIMIT 1;";
         $result2 = mysqli_query($connect, $sql2);
         $ar = mysqli_affected_rows($connect);
-        if ($ar == 1) {
-         	syslog(LOG_NOTICE, "Reduced fermentable `".$item['f_name']."' from `".$item['f_supplier']."' with ".$amount." kg");
-        } else if ($ar == 0) {
+	if ($ar == 0) {
                 $sql2  = "UPDATE inventory_fermentables SET inventory = 0";
                 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['f_name']);
                 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['f_origin']);
@@ -1104,9 +1102,7 @@
                 $sql2 .= " LIMIT 1;";
                 $result2 = mysqli_query($connect, $sql2);
                 $ar = mysqli_affected_rows($connect);
-                if ($ar == 1) {
-                        syslog(LOG_NOTICE, "Reduced fermentable `".$item['f_name']."' from `".$item['f_supplier']."' to 0 kg");
-                } else if ($ar == 0) {
+		if ($ar == 0) {
                         syslog(LOG_NOTICE, "Reduce fermentable `".$item['f_name']."' from `".$item['f_supplier']."' failed");
                 }
         }
@@ -1126,9 +1122,7 @@
         $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;";
         $result2 = mysqli_query($connect, $sql2);
         $ar = mysqli_affected_rows($connect);
-        if ($ar == 1) {
-                syslog(LOG_NOTICE, "Reduced hop `".$item['h_name']."' from `".$item['h_origin']."' with ".$amount." kg");
-        } else if ($ar == 0) {
+        if ($ar == 0) {
                 $sql2  = "UPDATE inventory_hops SET inventory = 0";
                 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['h_name']);
                 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['h_origin']);
@@ -1136,9 +1130,7 @@
                 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;";
                 $result2 = mysqli_query($connect, $sql2);
                 $ar = mysqli_affected_rows($connect);
-                if ($ar == 1) {
-                        syslog(LOG_NOTICE, "Reduced hop `".$item['h_name']."' from `".$item['h_origin']."' to 0 kg");
-                } else if ($ar == 0) {
+                if ($ar == 0) {
                         syslog(LOG_NOTICE, "Reduce hop `".$item['h_name']."' from `".$item['h_origin']."' failed");
                 }
         }
@@ -1156,17 +1148,13 @@
         $sql2 .= "' AND inventory >= " . $amount . " LIMIT 1;";
         $result2 = mysqli_query($connect, $sql2);
         $ar = mysqli_affected_rows($connect);
-        if ($ar == 1) {
-                syslog(LOG_NOTICE, "Reduced misc `".$item['m_name']."' with ".$amount);
-        } else if ($ar == 0) { 
+        if ($ar == 0) {
                 $sql2  = "UPDATE inventory_miscs SET inventory = 0";
                 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['m_name']);
                 $sql2 .= "' AND inventory < " . $amount . " LIMIT 1;";
                 $result2 = mysqli_query($connect, $sql2); 
                 $ar = mysqli_affected_rows($connect);
-                if ($ar == 1) {
-                       syslog(LOG_NOTICE, "Reduced misc `".$item['m_name']."' to 0");
-                } else if ($ar == 0) { 
+                if ($ar == 0) {
                        syslog(LOG_NOTICE, "Reduce misc `".$item['m_name']."' failed");
                 }
         }
@@ -1187,9 +1175,7 @@
         $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;";
         $result2 = mysqli_query($connect, $sql2);
         $ar = mysqli_affected_rows($connect);
-        if ($ar == 1) {
-		syslog(LOG_NOTICE, "Reduced yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' with ".$amount);
-        } else if ($ar == 0) {
+        if ($ar == 0) {
                 $sql2  = "UPDATE inventory_yeasts SET inventory = 0";
                 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['y_name']);
                 $sql2 .= "' AND laboratory='" . mysqli_real_escape_string($connect, $item['y_laboratory']);
@@ -1198,9 +1184,7 @@
                 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;";
                 $result2 = mysqli_query($connect, $sql2);
                 $ar = mysqli_affected_rows($connect);
-                if ($ar == 1) {
-                        syslog(LOG_NOTICE, "Reduced yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' to 0");
-                } else if ($ar == 0) {
+                if ($ar == 0) {
                 	syslog(LOG_NOTICE, "Reduce yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' failed");
                 }
         }