Mercurial > bms / file diff

--- a/www/js/prod_inprod.js	Mon Mar 04 20:54:22 2019 +0100
+++ b/www/js/prod_inprod.js	Tue Mar 05 20:28:44 2019 +0100
@@ -31,6 +31,8 @@
 			{ name: 'code', type: 'string' },
 			{ name: 'birth', type: 'string' },
 			{ name: 'stage', type: 'int' },
+			{ name: 'brew_date', type: 'string' },
+			{ name: 'package_date', type: 'string' },
 		],
 		id: 'record',
 		url: "includes/db_product.php?select=inprod"
@@ -59,9 +61,32 @@
 			{ text: 'Datum', datafield: 'birth', width: 120 },
 			{ text: 'Code', datafield: 'code', width: 120 },
 			{ text: 'Naam', datafield: 'name' },
-			{ text: 'Fase', datafield: 'stage', width: 130,
+			{ text: 'Fase', datafield: 'stage', width: 200,
 			  cellsrenderer: function (index, datafield, value, defaultvalue, column, rowdata) {
-				return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + StageData[value].nl + "</span>";
+				// 2 = brew, 6 = package, 7 = carbonation, 8 = mature, 9 = taste
+				var fase = StageData[value].nl;
+				if (value == 2) {
+					fase = StageData[value].nl + " op " + rowdata.brew_date;
+				}
+				if (value >= 6 && value < 9) {
+					var d = new Date();
+					var date2 = rowdata.package_date;
+					date2 = date2.split('-');
+					// Now we convert the array to a Date object
+					date1 = new Date(d.getFullYear(), d.getMonth(), d.getDate());
+					date2 = new Date(date2[0], date2[1]-1, date2[2]);
+					// We use the getTime() method and get the unixtime
+					date1_unixtime = parseInt(date1.getTime() / 1000);
+					date2_unixtime = parseInt(date2.getTime() / 1000);
+					// This is the calculated difference in seconds
+					var timeDifference = date1_unixtime - date2_unixtime;
+					var timeDifferenceInDays = timeDifference / 60 / 60 / 24;
+					if (timeDifferenceInDays >= 14)
+						fase = StageData[value].nl + " dag " + (timeDifferenceInDays - 14) + " van 42";
+					else
+						fase = StageData[value].nl + " dag " + timeDifferenceInDays + " van 14";
+				}
+				return "<span style='margin: 3px; margin-top: 6px; float: left;'>" + fase + "</span>";
 			  }
 		       	},
 			{ text: '', datafield: 'Edit', width: 100, align: 'center', columntype: 'button', cellsrenderer: function () {