www/includes/db_product.php

changeset 773
f4161330ed01
parent 768
ae1195153fa2
child 774
92e1e8f175a2
equal deleted inserted replaced
772:f9d266eb0ec6 773:f4161330ed01
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

mercurial