www/inv_instock.php

<?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();
?>