www/includes/db_product.php

changeset 321
4116e6184609
parent 299
047ead629d4a
child 326
bf5fa5277c9f
--- 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");

mercurial