Fri, 01 May 2020 11:56:24 +0200
Version 0.3.32 Inventory water and profile water edit screens updated and added ion balance fields. Moved acid specs to global.js. In prod_edit and rec_edit changed the water calculations, eliminated the double percentage calculation. The pH values in the water tab have now 2 decimal digits. The mash pH field is only shown in auto calculate mode. The calculated acid addition results are now a bit better and compare with several famous spreadsheets.
<?php require_once('config.php'); $query = "SELECT * FROM inventory_waters ORDER BY name"; $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); if (! $connect) { echo "[]"; return; } $result = mysqli_query($connect, $query); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $waters[] = array( 'record' => $row['record'], 'name' => $row['name'], 'unlimited_stock' => $row['unlimited_stock'], 'calcium' => $row['calcium'], 'sulfate' => $row['sulfate'], 'chloride' => $row['chloride'], 'sodium' => $row['sodium'], 'magnesium' => $row['magnesium'], 'ph' => $row['ph'], 'total_alkalinity' => $row['total_alkalinity'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] ); } header("Content-type: application/json"); echo json_encode($waters);