26 $sql .= "', form='" . $_GET['form']; |
26 $sql .= "', form='" . $_GET['form']; |
27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
29 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
29 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
30 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
30 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
31 $sql .= "', inventory='" . $_GET['inventory']; |
31 $sql .= "', inventory='" . $_GET['inventory'] / 1000.0; |
32 $sql .= "', cost='" . $_GET['cost']; |
32 $sql .= "', cost='" . $_GET['cost']; |
33 $sql .= "', production_date='" . $_GET['production_date']; |
33 $sql .= "', production_date='" . $_GET['production_date']; |
34 $sql .= "', tht_date='" . $_GET['tht_date']; |
34 $sql .= "', tht_date='" . $_GET['tht_date']; |
35 $sql .= "', total_oil='" . $_GET['total_oil']; |
35 $sql .= "', total_oil='" . $_GET['total_oil']; |
36 $sql .= "';"; |
36 $sql .= "';"; |
56 $sql .= "', form='" . $_GET['form']; |
56 $sql .= "', form='" . $_GET['form']; |
57 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
57 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
58 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
58 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
59 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
59 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
60 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
60 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
61 $sql .= "', inventory='" . $_GET['inventory']; |
61 $sql .= "', inventory='" . $_GET['inventory'] / 1000.0; |
62 $sql .= "', cost='" . $_GET['cost']; |
62 $sql .= "', cost='" . $_GET['cost']; |
63 $sql .= "', production_date='" . $_GET['production_date']; |
63 $sql .= "', production_date='" . $_GET['production_date']; |
64 $sql .= "', tht_date='" . $_GET['tht_date']; |
64 $sql .= "', tht_date='" . $_GET['tht_date']; |
65 $sql .= "', total_oil='" . $_GET['total_oil']; |
65 $sql .= "', total_oil='" . $_GET['total_oil']; |
66 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
66 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
101 'form' => $row['form'], |
101 'form' => $row['form'], |
102 'notes' => $row['notes'], |
102 'notes' => $row['notes'], |
103 'origin' => $row['origin'], |
103 'origin' => $row['origin'], |
104 'substitutes' => $row['substitutes'], |
104 'substitutes' => $row['substitutes'], |
105 'always_on_stock' => $row['always_on_stock'], |
105 'always_on_stock' => $row['always_on_stock'], |
106 'inventory' => $row['inventory'], |
106 'inventory' => $row['inventory'] * 1000, |
107 'cost' => $row['cost'], |
107 'cost' => $row['cost'], |
108 'production_date' => $row['production_date'], |
108 'production_date' => $row['production_date'], |
109 'tht_date' => $row['tht_date'], |
109 'tht_date' => $row['tht_date'], |
110 'total_oil' => $row['total_oil'] |
110 'total_oil' => $row['total_oil'] |
111 ); |
111 ); |