Sun, 19 Aug 2018 15:36:13 +0200
Inventory fermentables and hops to standard weight format.
<?php require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); page_header('Hoofdmenu', NULL); ?> <div id="MainPanel"> <div id="ContentPanel"></div> <pre> <?php $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); $result = $mysqli->query("SELECT name,inventory,cost FROM inventory_fermentables WHERE inventory > 0"); $tot_fermentables = 0.0; printf("Vergistbaar ingredient Voorraad Prijs/kg Waarde\n"); printf("---------------------------------------- ---------- -------- --------\n"); while($row = $result->fetch_array(MYSQLI_ASSOC)) { $value = $row['inventory'] * $row['cost']; $tot_fermentables += $value; // printf("%-40s %10.5f kg %8.2f %8.2f \n", $row['name'], $row['inventory'], $row['cost'], $value); } printf("---------------------------------------- --------\n"); printf("Totaal %8.2f\n\n", $tot_fermentables); $tot_hops = 0.0; $result = $mysqli->query("SELECT name,inventory,cost FROM inventory_hops WHERE inventory > 0"); $tot_fermentables = 0.0; printf("Hoppen Voorraad Prijs/kg Waarde\n"); printf("---------------------------------------- ---------- -------- --------\n"); while($row = $result->fetch_array(MYSQLI_ASSOC)) { $value = $row['inventory'] * $row['cost']; $tot_hops += $value; printf("%-40s %10.5f kg %8.2f %8.2f \n", $row['name'], $row['inventory'], $row['cost'], $value); } printf("---------------------------------------- --------\n\n"); printf("Totaal %8.2f\n", $tot_hops ); $tot_yeats = 0.0; $result = $mysqli->query("SELECT name,inventory,cost FROM inventory_yeasts WHERE inventory > 0"); $tot_fermentables = 0.0; printf("Hoppen Voorraad Prijs/kg Waarde\n"); printf("---------------------------------------- ---------- -------- --------\n"); while($row = $result->fetch_array(MYSQLI_ASSOC)) { $value = $row['inventory'] * $row['cost']; $tot_yeasts += $value; printf("%-40s %10.5f kg %8.2f %8.2f \n", $row['name'], $row['inventory'], $row['cost'], $value); } printf("---------------------------------------- --------\n\n"); printf("Totaal %8.2f\n", $tot_yeasts ); ?> </pre> </div> <?php page_footer(); ?>