Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/getmiscsources.php@082c23b26055

www/getmiscsources.php

Mon, 12 Nov 2018 16:34:43 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Mon, 12 Nov 2018 16:34:43 +0100

changeset 89

082c23b26055

parent 60

dbbe408108ea

child 296

69fadd1aded2

permissions

-rw-r--r--

Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.

<?php
require_once('config.php');

$query = "SELECT * FROM inventory_miscs 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)) {
	$miscs[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'type' => $row['type'],
		'use_use' => $row['use_use'],
		'time' => $row['time'],
		'amount_is_weight' => $row['amount_is_weight'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
echo json_encode($miscs);