1091 $sql2 .= "' AND supplier='" . mysqli_real_escape_string($connect, $item['f_supplier']); |
1091 $sql2 .= "' AND supplier='" . mysqli_real_escape_string($connect, $item['f_supplier']); |
1092 $sql2 .= "' AND inventory >= " . $amount; |
1092 $sql2 .= "' AND inventory >= " . $amount; |
1093 $sql2 .= " LIMIT 1;"; |
1093 $sql2 .= " LIMIT 1;"; |
1094 $result2 = mysqli_query($connect, $sql2); |
1094 $result2 = mysqli_query($connect, $sql2); |
1095 $ar = mysqli_affected_rows($connect); |
1095 $ar = mysqli_affected_rows($connect); |
1096 if ($ar == 1) { |
1096 if ($ar == 0) { |
1097 syslog(LOG_NOTICE, "Reduced fermentable `".$item['f_name']."' from `".$item['f_supplier']."' with ".$amount." kg"); |
|
1098 } else if ($ar == 0) { |
|
1099 $sql2 = "UPDATE inventory_fermentables SET inventory = 0"; |
1097 $sql2 = "UPDATE inventory_fermentables SET inventory = 0"; |
1100 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['f_name']); |
1098 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['f_name']); |
1101 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['f_origin']); |
1099 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['f_origin']); |
1102 $sql2 .= "' AND supplier='" . mysqli_real_escape_string($connect, $item['f_supplier']); |
1100 $sql2 .= "' AND supplier='" . mysqli_real_escape_string($connect, $item['f_supplier']); |
1103 $sql2 .= "' AND inventory < " . $amount; |
1101 $sql2 .= "' AND inventory < " . $amount; |
1104 $sql2 .= " LIMIT 1;"; |
1102 $sql2 .= " LIMIT 1;"; |
1105 $result2 = mysqli_query($connect, $sql2); |
1103 $result2 = mysqli_query($connect, $sql2); |
1106 $ar = mysqli_affected_rows($connect); |
1104 $ar = mysqli_affected_rows($connect); |
1107 if ($ar == 1) { |
1105 if ($ar == 0) { |
1108 syslog(LOG_NOTICE, "Reduced fermentable `".$item['f_name']."' from `".$item['f_supplier']."' to 0 kg"); |
|
1109 } else if ($ar == 0) { |
|
1110 syslog(LOG_NOTICE, "Reduce fermentable `".$item['f_name']."' from `".$item['f_supplier']."' failed"); |
1106 syslog(LOG_NOTICE, "Reduce fermentable `".$item['f_name']."' from `".$item['f_supplier']."' failed"); |
1111 } |
1107 } |
1112 } |
1108 } |
1113 } |
1109 } |
1114 |
1110 |
1124 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['h_origin']); |
1120 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['h_origin']); |
1125 $sql2 .= "' AND form=" . $item['h_form']; |
1121 $sql2 .= "' AND form=" . $item['h_form']; |
1126 $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;"; |
1122 $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;"; |
1127 $result2 = mysqli_query($connect, $sql2); |
1123 $result2 = mysqli_query($connect, $sql2); |
1128 $ar = mysqli_affected_rows($connect); |
1124 $ar = mysqli_affected_rows($connect); |
1129 if ($ar == 1) { |
1125 if ($ar == 0) { |
1130 syslog(LOG_NOTICE, "Reduced hop `".$item['h_name']."' from `".$item['h_origin']."' with ".$amount." kg"); |
|
1131 } else if ($ar == 0) { |
|
1132 $sql2 = "UPDATE inventory_hops SET inventory = 0"; |
1126 $sql2 = "UPDATE inventory_hops SET inventory = 0"; |
1133 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['h_name']); |
1127 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['h_name']); |
1134 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['h_origin']); |
1128 $sql2 .= "' AND origin='" . mysqli_real_escape_string($connect, $item['h_origin']); |
1135 $sql2 .= "' AND form=" . $item['h_form']; |
1129 $sql2 .= "' AND form=" . $item['h_form']; |
1136 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;"; |
1130 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;"; |
1137 $result2 = mysqli_query($connect, $sql2); |
1131 $result2 = mysqli_query($connect, $sql2); |
1138 $ar = mysqli_affected_rows($connect); |
1132 $ar = mysqli_affected_rows($connect); |
1139 if ($ar == 1) { |
1133 if ($ar == 0) { |
1140 syslog(LOG_NOTICE, "Reduced hop `".$item['h_name']."' from `".$item['h_origin']."' to 0 kg"); |
|
1141 } else if ($ar == 0) { |
|
1142 syslog(LOG_NOTICE, "Reduce hop `".$item['h_name']."' from `".$item['h_origin']."' failed"); |
1134 syslog(LOG_NOTICE, "Reduce hop `".$item['h_name']."' from `".$item['h_origin']."' failed"); |
1143 } |
1135 } |
1144 } |
1136 } |
1145 } |
1137 } |
1146 |
1138 |
1154 $sql2 = "UPDATE inventory_miscs SET inventory = inventory - " . $amount; |
1146 $sql2 = "UPDATE inventory_miscs SET inventory = inventory - " . $amount; |
1155 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['m_name']); |
1147 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['m_name']); |
1156 $sql2 .= "' AND inventory >= " . $amount . " LIMIT 1;"; |
1148 $sql2 .= "' AND inventory >= " . $amount . " LIMIT 1;"; |
1157 $result2 = mysqli_query($connect, $sql2); |
1149 $result2 = mysqli_query($connect, $sql2); |
1158 $ar = mysqli_affected_rows($connect); |
1150 $ar = mysqli_affected_rows($connect); |
1159 if ($ar == 1) { |
1151 if ($ar == 0) { |
1160 syslog(LOG_NOTICE, "Reduced misc `".$item['m_name']."' with ".$amount); |
|
1161 } else if ($ar == 0) { |
|
1162 $sql2 = "UPDATE inventory_miscs SET inventory = 0"; |
1152 $sql2 = "UPDATE inventory_miscs SET inventory = 0"; |
1163 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['m_name']); |
1153 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['m_name']); |
1164 $sql2 .= "' AND inventory < " . $amount . " LIMIT 1;"; |
1154 $sql2 .= "' AND inventory < " . $amount . " LIMIT 1;"; |
1165 $result2 = mysqli_query($connect, $sql2); |
1155 $result2 = mysqli_query($connect, $sql2); |
1166 $ar = mysqli_affected_rows($connect); |
1156 $ar = mysqli_affected_rows($connect); |
1167 if ($ar == 1) { |
1157 if ($ar == 0) { |
1168 syslog(LOG_NOTICE, "Reduced misc `".$item['m_name']."' to 0"); |
|
1169 } else if ($ar == 0) { |
|
1170 syslog(LOG_NOTICE, "Reduce misc `".$item['m_name']."' failed"); |
1158 syslog(LOG_NOTICE, "Reduce misc `".$item['m_name']."' failed"); |
1171 } |
1159 } |
1172 } |
1160 } |
1173 } |
1161 } |
1174 |
1162 |
1185 $sql2 .= "' AND product_id='" . mysqli_real_escape_string($connect, $item['y_product_id']); |
1173 $sql2 .= "' AND product_id='" . mysqli_real_escape_string($connect, $item['y_product_id']); |
1186 $sql2 .= "' AND form=" . $item['y_form']; |
1174 $sql2 .= "' AND form=" . $item['y_form']; |
1187 $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;"; |
1175 $sql2 .= " AND inventory >= " . $amount . " LIMIT 1;"; |
1188 $result2 = mysqli_query($connect, $sql2); |
1176 $result2 = mysqli_query($connect, $sql2); |
1189 $ar = mysqli_affected_rows($connect); |
1177 $ar = mysqli_affected_rows($connect); |
1190 if ($ar == 1) { |
1178 if ($ar == 0) { |
1191 syslog(LOG_NOTICE, "Reduced yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' with ".$amount); |
|
1192 } else if ($ar == 0) { |
|
1193 $sql2 = "UPDATE inventory_yeasts SET inventory = 0"; |
1179 $sql2 = "UPDATE inventory_yeasts SET inventory = 0"; |
1194 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['y_name']); |
1180 $sql2 .= " WHERE name='" . mysqli_real_escape_string($connect, $item['y_name']); |
1195 $sql2 .= "' AND laboratory='" . mysqli_real_escape_string($connect, $item['y_laboratory']); |
1181 $sql2 .= "' AND laboratory='" . mysqli_real_escape_string($connect, $item['y_laboratory']); |
1196 $sql2 .= "' AND product_id='" . mysqli_real_escape_string($connect, $item['y_product_id']); |
1182 $sql2 .= "' AND product_id='" . mysqli_real_escape_string($connect, $item['y_product_id']); |
1197 $sql2 .= "' AND form=" . $item['y_form']; |
1183 $sql2 .= "' AND form=" . $item['y_form']; |
1198 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;"; |
1184 $sql2 .= " AND inventory < " . $amount . " LIMIT 1;"; |
1199 $result2 = mysqli_query($connect, $sql2); |
1185 $result2 = mysqli_query($connect, $sql2); |
1200 $ar = mysqli_affected_rows($connect); |
1186 $ar = mysqli_affected_rows($connect); |
1201 if ($ar == 1) { |
1187 if ($ar == 0) { |
1202 syslog(LOG_NOTICE, "Reduced yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' to 0"); |
|
1203 } else if ($ar == 0) { |
|
1204 syslog(LOG_NOTICE, "Reduce yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' failed"); |
1188 syslog(LOG_NOTICE, "Reduce yeast `".$item['y_product_id'].' '.$item['y_name']."' from `".$item['y_laboratory']."' failed"); |
1205 } |
1189 } |
1206 } |
1190 } |
1207 } |
1191 } |
1208 |
1192 |