Fri, 30 Nov 2018 17:40:39 +0100
Removed all calculations from the equipemnts database script and added missing fields. Added missing fields to the inventory equipemnts edit screen. Added conditional batch size calculation to the equipments editor. Added specific heat settings to the equipments editor.
<?php require($_SERVER['DOCUMENT_ROOT']."/config.php"); require($_SERVER['DOCUMENT_ROOT']."/version.php"); #Connect to the database $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); if (! $connect) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } mysqli_set_charset($connect, "utf8" ); // get data and store in a json array $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; if (isset($_GET['insert'])) { // INSERT COMMAND $sql = "INSERT INTO `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); $sql .= "', type='" . $_GET['type']; $sql .= "', yield='" . $_GET['yield']; $sql .= "', color='" . $_GET['color']; ($_GET['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_GET['supplier']); $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); $sql .= "', coarse_fine_diff='" . $_GET['coarse_fine_diff']; $sql .= "', moisture='" . $_GET['moisture']; $sql .= "', diastatic_power='" . $_GET['diastatic_power']; $sql .= "', protein='" . $_GET['protein']; $sql .= "', max_in_batch='" . $_GET['max_in_batch']; ($_GET['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; $sql .= "', ibu_gal_per_lb='" . $_GET['ibu_gal_per_lb']; ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; $sql .= "', di_ph='" . $_GET['di_ph']; $sql .= "', acid_to_ph_57='" . $_GET['acid_to_ph_57']; $sql .= "', graintype='" . mysqli_real_escape_string($connect, $_GET['graintype']); $sql .= "', inventory='" . $_GET['inventory']; $sql .= "', cost='" . $_GET['cost']; $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; //$sql .= "', supplier_rec='" . $_GET['supplier_rec']; $sql .= "';"; $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); } else { syslog(LOG_NOTICE, "db_inventory_fermentables: inserted ".$_GET['name']); } echo $result; } else if (isset($_GET['update'])) { // UPDATE COMMAND $sql = "UPDATE `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); $sql .= "', type='" . $_GET['type']; $sql .= "', yield='" . $_GET['yield']; $sql .= "', color='" . $_GET['color']; ($_GET['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_GET['supplier']); $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); $sql .= "', coarse_fine_diff='" . $_GET['coarse_fine_diff']; $sql .= "', moisture='" . $_GET['moisture']; $sql .= "', diastatic_power='" . $_GET['diastatic_power']; $sql .= "', protein='" . $_GET['protein']; $sql .= "', max_in_batch='" . $_GET['max_in_batch']; ($_GET['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; $sql .= "', ibu_gal_per_lb='" . $_GET['ibu_gal_per_lb']; ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; $sql .= "', di_ph='" . $_GET['di_ph']; $sql .= "', acid_to_ph_57='" . $_GET['acid_to_ph_57']; $sql .= "', graintype='" . mysqli_real_escape_string($connect, $_GET['graintype']); $sql .= "', inventory='" . $_GET['inventory']; $sql .= "', cost='" . $_GET['cost']; $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; //$sql .= "', supplier_rec='" . $_GET['supplier_rec']; $sql .= "' WHERE record='" . $_GET['record'] . "';"; $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); } else { syslog(LOG_NOTICE, "db_inventory_fermentables: updated record ".$_GET['record']); } echo $result; } else if (isset($_GET['delete'])) { // DELETE COMMAND $sql = "DELETE FROM `inventory_fermentables` WHERE record='".$_GET['record']."';"; $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); } else { syslog(LOG_NOTICE, "db_inventory_fermentables: deleted record ".$_GET['record']); } echo $result; } else { // SELECT COMMAND $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $fermentables[] = array( 'record' => $row['record'], 'name' => $row['name'], 'type' => $row['type'], 'yield' => $row['yield'], 'color' => $row['color'], 'add_after_boil' => $row['add_after_boil'], 'origin' => $row['origin'], 'supplier' => $row['supplier'], 'notes' => $row['notes'], 'coarse_fine_diff' => $row['coarse_fine_diff'], 'moisture' => $row['moisture'], 'diastatic_power' => $row['diastatic_power'], 'protein' => $row['protein'], 'max_in_batch' => $row['max_in_batch'], 'recommend_mash' => $row['recommend_mash'], 'ibu_gal_per_lb' => $row['ibu_gal_per_lb'], 'always_on_stock' => $row['always_on_stock'], 'di_ph' => $row['di_ph'], 'acid_to_ph_57' => $row['acid_to_ph_57'], 'graintype' => $row['graintype'], 'inventory' => $row['inventory'], 'cost' => $row['cost'], 'production_date' => $row['production_date'], 'tht_date' => $row['tht_date'] ); } echo json_encode($fermentables); } ?>