# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1660123733 -7200
# Node ID bdef871e6db76410b02ac266fd8ea0f082fb2b1c
# Parent  2641860ad61d071ba5a9ebcee21737450ff7a824
Reinstalled the product archives menus

diff -r 2641860ad61d -r bdef871e6db7 www/includes/global.inc.php
--- a/www/includes/global.inc.php	Sat Aug 06 22:10:28 2022 +0200
+++ b/www/includes/global.inc.php	Wed Aug 10 11:28:53 2022 +0200
@@ -222,7 +222,14 @@
        </li>
       </ul>
      </li>
-     <li style='width: 80px;'><a href="prod_inprod.php">Productie</a></li>
+     <li style='width: 80px;'>Productie
+      <ul style='width: 200px;'>
+       <li><img style='float: left; margin-right: 5px;' src='images/beerstyles.png' /><a href="prod_inprod.php">In productie</a></li>
+       <li><img style='float: left; margin-right: 5px;' src='images/database.png' /><a href="prod_archive_code.php">Archief op code</a></li>
+       <li><img style='float: left; margin-right: 5px;' src='images/database.png' /><a href="prod_archive_date.php">Archief op datum</a></li>
+       <li><img style='float: left; margin-right: 5px;' src='images/database.png' /><a href="prod_archive_name.php">Archief op naam</a></li>
+      </ul>
+     </li>
      <li style='width: 80px;'><a href="rec_main.php">Recepten</a></li>
      <li style='width: 80px;'><a href="gen_about.php">Over</a></li>
     </ul>
diff -r 2641860ad61d -r bdef871e6db7 www/js/prod_archive_code.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/js/prod_archive_code.js	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,66 @@
+/*****************************************************************************
+ * Copyright (C) 2019
+ *
+ * Michiel Broek <mbroek at mbse dot eu>
+ *
+ * This file is part of BMS
+ *
+ * This is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2, or (at your option) any
+ * later version.
+ *
+ * BrewCloud is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with ThermFerm; see the file COPYING.  If not, write to the Free
+ * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+ *****************************************************************************/
+
+
+$(document).ready(function() {
+ var source = {
+  datatype: 'json',
+  cache: false,
+  datafields: [
+   { name: 'record', type: 'number' },
+   { name: 'name', type: 'string' },
+   { name: 'code', type: 'string' },
+   { name: 'date', type: 'string' },
+   { name: 'style', type: 'string' },
+   { name: 'og', type: 'float' },
+   { name: 'fg', type: 'float' },
+   { name: 'batch_size', type: 'float' },
+  ],
+  id: 'record',
+  url: 'includes/db_product.php?select=archcode'
+ },
+ dataAdapter = new $.jqx.dataAdapter(source);
+
+ // initialize jqxGrid
+ $('#jqxgrid').jqxGrid({
+  width: 1280,
+  height: 630,
+  source: dataAdapter,
+  theme: theme,
+  columns: [
+   { text: 'Code', datafield: 'code', width: 100 },
+   { text: 'Naam', datafield: 'name' },
+   { text: 'Stijl', datafield: 'style', width: 250 },
+   { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3' },
+   { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3' },
+   { text: 'Datum', datafield: 'date', width: 120 },
+   { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1' },
+   { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function() {
+    return 'Bekijk';
+    }, buttonclick: function(row) {
+     var datarecord = dataAdapter.records[row];
+     window.location.href = 'prod_view.php?record=' + datarecord.record + '&select=archcode&return=prod_archive_code.php';
+    }
+   }
+  ],
+ });
+});
diff -r 2641860ad61d -r bdef871e6db7 www/js/prod_archive_date.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/js/prod_archive_date.js	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,70 @@
+/*****************************************************************************
+ * Copyright (C) 2019
+ *
+ * Michiel Broek <mbroek at mbse dot eu>
+ *
+ * This file is part of BMS
+ *
+ * This is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2, or (at your option) any
+ * later version.
+ *
+ * BrewCloud is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with ThermFerm; see the file COPYING.  If not, write to the Free
+ * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+ *****************************************************************************/
+
+
+$(document).ready(function() {
+ var source = {
+  datatype: 'json',
+  cache: false,
+  datafields: [
+   { name: 'record', type: 'number' },
+   { name: 'name', type: 'string' },
+   { name: 'code', type: 'string' },
+   { name: 'year', type: 'string' },
+   { name: 'date', type: 'string' },
+   { name: 'style', type: 'string' },
+   { name: 'og', type: 'float' },
+   { name: 'fg', type: 'float' },
+   { name: 'batch_size', type: 'float' },
+  ],
+  id: 'record',
+  url: 'includes/db_product.php?select=archdate'
+ },
+ dataAdapter = new $.jqx.dataAdapter(source);
+
+ // initialize jqxGrid
+ $('#jqxgrid').jqxGrid({
+  width: 1280,
+  height: 630,
+  source: dataAdapter,
+  groupable: true,
+  theme: theme,
+  columns: [
+   { text: 'Jaar', datafield: 'year', width: 80 },
+   { text: 'Datum', datafield: 'date', width: 120, menu: false },
+   { text: 'Naam', datafield: 'name', menu: false },
+   { text: 'Stijl', datafield: 'style', width: 250 },
+   { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3', menu: false },
+   { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3', menu: false },
+   { text: 'Code', datafield: 'code', width: 100, menu: false },
+   { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1', menu: false },
+   { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function() {
+    return 'Bekijk';
+    }, buttonclick: function(row) {
+     var datarecord = dataAdapter.records[row];
+     window.location.href = 'prod_view.php?record=' + datarecord.record + '&select=archdate&return=prod_archive_date.php';
+    }
+   }
+  ],
+  groups: ['year']
+ });
+});
diff -r 2641860ad61d -r bdef871e6db7 www/js/prod_archive_name.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/js/prod_archive_name.js	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,66 @@
+/*****************************************************************************
+ * Copyright (C) 2019
+ *
+ * Michiel Broek <mbroek at mbse dot eu>
+ *
+ * This file is part of BMS
+ *
+ * This is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2, or (at your option) any
+ * later version.
+ *
+ * BrewCloud is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with ThermFerm; see the file COPYING.  If not, write to the Free
+ * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+ *****************************************************************************/
+
+
+$(document).ready(function() {
+ var source = {
+  datatype: 'json',
+  cache: false,
+  datafields: [
+   { name: 'record', type: 'number' },
+   { name: 'name', type: 'string' },
+   { name: 'code', type: 'string' },
+   { name: 'date', type: 'string' },
+   { name: 'style', type: 'string' },
+   { name: 'og', type: 'float' },
+   { name: 'fg', type: 'float' },
+   { name: 'batch_size', type: 'float' },
+  ],
+  id: 'record',
+  url: 'includes/db_product.php?select=archname'
+ },
+ dataAdapter = new $.jqx.dataAdapter(source);
+
+ // initialize jqxGrid
+ $('#jqxgrid').jqxGrid({
+  width: 1280,
+  height: 630,
+  source: dataAdapter,
+  theme: theme,
+  columns: [
+   { text: 'Naam', datafield: 'name' },
+   { text: 'Stijl', datafield: 'style', width: 250 },
+   { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3' },
+   { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3' },
+   { text: 'Datum', datafield: 'date', width: 120 },
+   { text: 'Code', datafield: 'code', width: 100 },
+   { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1' },
+   { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function() {
+    return 'Bekijk';
+    }, buttonclick: function(row) {
+     var datarecord = dataAdapter.records[row];
+     window.location.href = 'prod_view.php?record=' + datarecord.record + '&select=archname&return=prod_archive_name.php';
+    }
+   }
+  ],
+ });
+});
diff -r 2641860ad61d -r bdef871e6db7 www/prod_archive_code.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/prod_archive_code.php	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,14 @@
+<?php
+require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
+page_header('Producten archief op code', 'prod_archive_code');
+?>
+
+   <div id="jqxgrid"></div>
+    <div style="margin-top: 30px;">
+    <div id="cellbegineditevent"></div>
+    <div style="margin-top: 10px;" id="cellendeditevent"></div>
+   </div>
+
+<?php
+page_footer();
+?>
diff -r 2641860ad61d -r bdef871e6db7 www/prod_archive_date.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/prod_archive_date.php	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,14 @@
+<?php
+require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
+page_header('Producten archief op datum', 'prod_archive_date');
+?>
+
+   <div id="jqxgrid"></div>
+    <div style="margin-top: 30px;">
+    <div id="cellbegineditevent"></div>
+    <div style="margin-top: 10px;" id="cellendeditevent"></div>
+   </div>
+
+<?php
+page_footer();
+?>
diff -r 2641860ad61d -r bdef871e6db7 www/prod_archive_name.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/prod_archive_name.php	Wed Aug 10 11:28:53 2022 +0200
@@ -0,0 +1,14 @@
+<?php
+require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
+page_header('Producten archief op naam', 'prod_archive_name');
+?>
+
+   <div id="jqxgrid"></div>
+    <div style="margin-top: 30px;">
+    <div id="cellbegineditevent"></div>
+    <div style="margin-top: 10px;" id="cellendeditevent"></div>
+   </div>
+
+<?php
+page_footer();
+?>