Sun, 30 Sep 2018 21:42:14 +0200
Added style selector in recipe editer. Better formatting of cellsrenderer fields. Added When field to the fermentables list. Attempts to calculate the fermentables.
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | page_header('Hoofdmenu', NULL); |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | ?> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | <div id="MainPanel"> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | <div id="ContentPanel"></div> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | <pre> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | <?php |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | $result = $mysqli->query("SELECT name,inventory,cost FROM inventory_fermentables WHERE inventory > 0"); |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | $tot_fermentables = 0.0; |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
13 | printf("Vergistbaar ingredient Voorraad Prijs/kg Waarde\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
14 | printf("------------------------------------------------------------ ---------- -------- --------\n"); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | while($row = $result->fetch_array(MYSQLI_ASSOC)) { |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | $value = $row['inventory'] * $row['cost']; |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | $tot_fermentables += $value; |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
18 | // printf("%-60s %10.5f kg %8.2f %8.2f \n", $row['name'], $row['inventory'], $row['cost'], $value); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | } |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
20 | printf(" --------\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
21 | printf("Totaal %8.2f\n\n", $tot_fermentables); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | $tot_hops = 0.0; |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
24 | $result = $mysqli->query("SELECT name,form,origin,inventory,cost FROM inventory_hops WHERE inventory > 0"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
25 | printf("Hoppen Voorraad Prijs/kg Waarde\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
26 | printf("------------------------------------------------------------ ---------- -------- --------\n"); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | while($row = $result->fetch_array(MYSQLI_ASSOC)) { |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | $value = $row['inventory'] * $row['cost']; |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
29 | $tot_hops += $value; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
30 | $hop = $row['form'] . " " . $row['origin'] . " - " . $row['name']; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
31 | $stock = floatval($row['inventory']) * 1000.0; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
32 | // printf("%-60s %10.1f gr %8.2f %8.2f \n", $hop, $stock, $row['cost'], $value); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
33 | } |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
34 | printf(" --------\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
35 | printf("Totaal %8.2f\n\n", $tot_hops ); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
37 | $tot_yeasts = 0.0; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
38 | $result = $mysqli->query("SELECT name,laboratory,product_id,form,inventory,cost FROM inventory_yeasts WHERE inventory > 0"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
39 | printf("Gisten Voorraad Prijs/kg Waarde\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
40 | printf("------------------------------------------------------------ ---------- -------- --------\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
41 | while($row = $result->fetch_array(MYSQLI_ASSOC)) { |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
42 | $value = $row['inventory'] * $row['cost']; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
43 | $yeast = $row['laboratory'] . " " .$row['product_id'] . " - " . $row['name']; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
44 | $tot_yeasts += $value; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
45 | $stock = floatval($row['inventory']) * 1000.0; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
46 | ($row['form'] == 'Dry') ? $amount = "gr" : $amount = "ml"; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
47 | // printf("%-60s %10.1f %s %8.2f %8.2f \n", $yeast, $stock, $amount, $row['cost'], $value); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
48 | } |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
49 | printf(" --------\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
50 | printf("Totaal %8.2f\n\n", $tot_yeasts ); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
51 | |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
52 | $tot_miscs = 0.0; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
53 | $result = $mysqli->query("SELECT name,type,amount_is_weight,inventory,cost FROM inventory_miscs WHERE inventory > 0"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
54 | printf("Diverse ingredienten Voorraad Prijs/kg Waarde\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
55 | printf("------------------------------------------------------------ ---------- -------- --------\n"); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | while($row = $result->fetch_array(MYSQLI_ASSOC)) { |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
57 | $value = $row['inventory'] * $row['cost']; |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
58 | $misc = $row['type'] . " " . $row['name']; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
59 | $tot_miscs += $value; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
60 | $stock = floatval($row['inventory']) * 1000.0; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
61 | ($row['amount_is_weight']) ? $amount = "gr" : $amount = "ml"; |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
62 | printf("%-60s %10.1f %s %8.2f %8.2f \n", $misc, $stock, $amount, $row['cost'], $value); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
63 | } |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
64 | printf(" --------\n"); |
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
65 | printf("Totaal %8.2f\n\n", $tot_miscs ); |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
66 | ?> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
67 | </pre> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
68 | </div> |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
69 | |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
70 | <?php |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
71 | page_footer(); |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | ?> |