diff -r f71bb1104375 -r 4116e6184609 www/includes/db_product.php --- a/www/includes/db_product.php Mon Mar 04 20:54:22 2019 +0100 +++ b/www/includes/db_product.php Tue Mar 05 20:28:44 2019 +0100 @@ -421,7 +421,7 @@ * SELECT, produce a list of products that are not yet Closed. */ if (isset($_GET['select']) && ($_GET['select'] == "inprod")) { - $query = "SELECT record,name,code,birth,stage FROM products WHERE stage != '11' ORDER BY birth,code;"; + $query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY birth,code;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $brews[] = array( @@ -429,7 +429,9 @@ 'name' => $row['name'], 'code' => $row['code'], 'birth' => $row['birth'], - 'stage' => $row['stage'] + 'stage' => $row['stage'], + 'brew_date' => substr($row['brew_date_start'], 0, 10), + 'package_date' => $row['package_date'] ); } header("Content-type: application/json");