diff -r 3775ee26657f -r 55c2510891b8 www/js/inv_equipments.js
--- a/www/js/inv_equipments.js	Mon Aug 01 09:56:23 2022 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,451 +0,0 @@
-/*****************************************************************************
- * Copyright (C) 2014-2022
- *
- * Michiel Broek <mbroek at mbse dot eu>
- *
- * This file is part of Brewery Management System
- *
- * 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.
- *****************************************************************************/
-
-
-function createDelElements() {
- $('#eventWindow').jqxWindow({
-  theme: theme,
-  position: { x: 490, y: 210 },
-  width: 300,
-  height: 175,
-  resizable: false,
-  isModal: true,
-  modalOpacity: 0.4,
-  okButton: $('#delOk'),
-  cancelButton: $('#delCancel'),
-  initContent: function() {
-   $('#delOk').jqxButton({ template: 'danger', width: '65px', theme: theme });
-   $('#delCancel').jqxButton({ template: 'success', width: '65px', theme: theme });
-   $('#delCancel').focus();
-  }
- });
- $('#eventWindow').jqxWindow('hide');
-}
-
-
-$(document).ready(function() {
-
- function calcBatchVolume() {
-  var calc = $('#calc_boil_volume').val(),
-  boil_size = parseFloat($('#boil_size').jqxNumberInput('decimal')),
-  evap_rate = parseFloat($('#evap_rate').jqxNumberInput('decimal')),
-  boil_time = parseFloat($('#boil_time').jqxNumberInput('decimal')),
-  top_up = parseFloat($('#top_up_kettle').jqxNumberInput('decimal')),
-  batch = parseFloat($('#batch_size').jqxNumberInput('decimal'));
-
-  if (calc) { // If checked, calculate the batch size.
-   batch = boil_size - (evap_rate * boil_time / 60) + top_up;
-   $('#batch_size').val(batch);
-  }
-  $('#vol_fermenter').val((batch / 1.04) + parseFloat($('#top_up_water').jqxNumberInput('decimal')) - parseFloat($('#trub_chiller_loss').jqxNumberInput('decimal')));
- }
-
- // tooltips
- $('#name').jqxTooltip({ content: 'De unieke naam van deze brouw installatie.' });
- $('#notes').jqxTooltip({ content: 'Extra opmerkingen over deze installatie.' });
- $('#tun_volume').jqxTooltip({ content: 'Maisch kuip volume.' });
- $('#tun_height').jqxTooltip({ content: 'Maisch kuip hoogte in cm.' });
- $('#tun_weight').jqxTooltip({ content: 'Maisch kuip gewicht in Kg.' });
- $('#tun_material').jqxTooltip({ content: 'Maisch kuip materiaal. Nodig om de juiste inmaisch temperatuur te berekenen.' });
- $('#mash_volume').jqxTooltip({ content: 'Liters maisch water voor de eerste maisch stap.' });
- $('#mash_max').jqxTooltip({ content: 'Maximale moutstort voor deze installatie in Kg.' });
- $('#lauter_volume').jqxTooltip({ content: 'Totaal filter volume.' });
- $('#lauter_height').jqxTooltip({ content: 'Hoogte van de filterpan in cm.' });
- $('#lauter_deadspace').jqxTooltip({ content: 'Volume verlies in de filterpan.' });
- $('#efficiency').jqxTooltip({ content: 'Gemiddeld brouwzaalrendement.' });
- $('#kettle_volume').jqxTooltip({ content: 'Kook ketel volume in liters.' });
- $('#kettle_height').jqxTooltip({ content: 'Kook ketel hoogte in cm.' });
- $('#boil_size').jqxTooltip({ content: 'Volume in liters voor de kook bij 100&deg;C in de kook ketel.' });
- $('#evap_rate').jqxTooltip({ content: 'Verdamping in liters per uur.' });
- $('#boil_time').jqxTooltip({ content: 'Kooktijd in minuten.' });
- $('#top_up_kettle').jqxTooltip({ content: 'Extra water toevoegen tijdens het koken.' });
- $('#hop_utilization').jqxTooltip({ content: '100% voor kleinere installaties, hoger voor grote brouwerijen.' });
- $('#batch_size').jqxTooltip({ content: 'Volume bij 100&deg;C aan het einde van de kook.' });
- $('#trub_chiller_loss').jqxTooltip({ content: 'Standaard verlies in liters tijdens koelen en overbrengen van de wort naar het gistvat.' });
- $('#top_up_water').jqxTooltip({ content: 'Extra water toe te voegen in het gistvat.' });
- $('#vol_fermenter').jqxTooltip({ content: 'Het aantal liters in het gistvat.' });
-
- var dataRecord = {},
- url = 'includes/db_inventory_equipments.php',
- // prepare the data
- source = {
-  datatype: 'json',
-  cache: false,
-  datafields: [
-   { name: 'record', type: 'number' },
-   { name: 'uuid', type: 'string' },
-   { name: 'name', type: 'string' },
-   { name: 'boil_size', type: 'float' },
-   { name: 'batch_size', type: 'float' },
-   { name: 'tun_volume', type: 'float' },
-   { name: 'tun_weight', type: 'float' },
-   { name: 'tun_specific_heat', type: 'float' },
-   { name: 'tun_material', type: 'int' },
-   { name: 'tun_height', type: 'float' },
-   { name: 'top_up_water', type: 'float' },
-   { name: 'trub_chiller_loss', type: 'float' },
-   { name: 'evap_rate', type: 'float' },
-   { name: 'boil_time', type: 'float' },
-   { name: 'calc_boil_volume', type: 'int' },
-   { name: 'top_up_kettle', type: 'float' },
-   { name: 'hop_utilization', type: 'float' },
-   { name: 'notes', type: 'string' },
-   { name: 'lauter_volume', type: 'float' },
-   { name: 'lauter_height', type: 'float' },
-   { name: 'lauter_deadspace', type: 'float' },
-   { name: 'kettle_volume', type: 'float' },
-   { name: 'kettle_height', type: 'float' },
-   { name: 'mash_volume', type: 'float' },
-   { name: 'mash_max', type: 'float' },
-   { name: 'efficiency', type: 'float' }
-  ],
-  id: 'record',
-  url: url,
-  deleterow: function(rowid, commit) {
-   // synchronize with the server - send delete command
-   var data = 'delete=true&' + $.param({ record: rowid });
-   $.ajax({
-    dataType: 'json',
-    url: url,
-    cache: false,
-    data: data,
-    type: 'POST',
-    success: function(data) {
-     if (data.error) {
-      console.log('delete: ' + data.msg);
-      alert('Fout: ' + data.msg);
-     } else {
-      console.log('delete: success');
-     }
-     //commit(true);
-     location.reload(true);
-    },
-    error: function(jqXHR, textStatus, errorThrown) { commit(false); }
-   });
-  },
-  addrow: function(rowid, rowdata, position, commit) {
-   var data = 'insert=true&' + $.param(rowdata);
-   $.ajax({
-    dataType: 'json',
-    url: url,
-    cache: false,
-    data: data,
-    type: 'POST',
-    success: function(data) {
-     if (data.error) {
-      console.log('insert: ' + data.msg);
-      alert('Fout: ' + data.msg);
-     } else {
-      console.log('insert: success');
-     }
-     location.reload(true);
-    },
-    error: function(jqXHR, textStatus, errorThrown) { commit(false); }
-   });
-  },
-  updaterow: function(rowid, rowdata, commit) {
-   var data = 'update=true&' + $.param(rowdata);
-   $.ajax({
-    dataType: 'json',
-    url: url,
-    cache: false,
-    data: data,
-    type: 'POST',
-    success: function(data) {
-     if (data.error) {
-      console.log('updaterow: ' + data.msg);
-      alert('Fout: ' + data.msg);
-     } else {
-      console.log('updaterow: success');
-     }
-     //commit(true);
-     location.reload(true);
-    },
-    error: function(jqXHR, textStatus, errorThrown) { console.log('updaterow: ' + textStatus); commit(false); }
-   });
-  }
- },
- dataAdapter = new $.jqx.dataAdapter(source),
- editrow = -1;
-
- // initialize the input fields.
- $('#name').jqxInput({ theme: theme, width: 250, height: 23 });
- $('#notes').jqxInput({ theme: theme, width: 640, height: 100 });
- $('#boil_size').jqxNumberInput(Spin1dec);
- $('#batch_size').jqxNumberInput(Spin2dec);
- $('#batch_size').jqxNumberInput({ spinButtonsStep: 0.5 });
- $('#tun_volume').jqxNumberInput(Spin1dec);
- $('#tun_weight').jqxNumberInput(Spin2dec);
- $('#tun_specific_heat').jqxNumberInput({ inputMode: 'simple', readOnly: true, theme: theme, width: 70, height: 23, decimalDigits: 3 });
- $('#tun_material').jqxDropDownList({
-  theme: theme,
-  source: MaterialAdapter,
-  valueMember: 'id',
-  displayMember: 'nl',
-  width: 180,
-  height: 23,
-  autoDropDownHeight: true
- });
- $('#tun_height').jqxNumberInput(Spin1dec);
- $('#top_up_water').jqxNumberInput(Spin1dec);
- $('#trub_chiller_loss').jqxNumberInput(Spin1dec);
- $('#evap_rate').jqxNumberInput(Spin2dec);
- $('#boil_time').jqxNumberInput(PosInt);
- $('#boil_time').jqxNumberInput({ max: 1440 });
- $('#calc_boil_volume').jqxCheckBox({ theme: theme, width: 120, height: 23 });
- $('#calc_boil_volume').on('checked', function(event) {
-  $('#batch_size').jqxNumberInput({ readOnly: true, width: 90, spinButtons: false });
- });
- $('#calc_boil_volume').on('unchecked', function(event) {
-  $('#batch_size').jqxNumberInput({ readOnly: false, width: 110, spinButtons: true });
- });
- $('#top_up_kettle').jqxNumberInput(Spin1dec);
- $('#hop_utilization').jqxNumberInput(Perc0);
- $('#hop_utilization').jqxNumberInput({ Max: 200 });
- $('#lauter_volume').jqxNumberInput(Spin1dec);
- $('#lauter_height').jqxNumberInput(Spin1dec);
- $('#lauter_deadspace').jqxNumberInput(Spin1dec);
- $('#kettle_volume').jqxNumberInput(Spin1dec);
- $('#kettle_height').jqxNumberInput(Spin1dec);
- $('#mash_volume').jqxNumberInput(Spin1dec);
- $('#mash_max').jqxNumberInput(Spin1dec);
- $('#efficiency').jqxNumberInput(Perc1dec);
- $('#vol_fermenter').jqxNumberInput(Show2dec);
-
- // initialize jqxGrid
- $('#jqxgrid').jqxGrid({
-  width: 1280,
-  height: 630,
-  source: dataAdapter,
-  theme: theme,
-  showstatusbar: true,
-  renderstatusbar: function(statusbar) {
-   var rowCount = $("#jqxgrid").jqxGrid('getrows').length;
-   statusbar.append('<div style="float: left; margin: 8px; color: orange !important;">Aantal items: ' + rowCount + '</div>');
-   var addButton, container = $('<div style="overflow: hidden; position: relative; margin: 5px;"></div>');
-   addButton = $('<div style="float: right; margin-right: 15px;"><img style="position: relative; margin-top: 2px;" ' +
-     'src="images/add.png"/><span style="margin-left: 4px; position: relative; top: -4px;">Nieuw</span></div>');
-   expButton = $('<div style="float: right; margin-right: 50px;"><img style="position: relative; margin-top: 2px;" ' +
-     'src="images/database.png"/><span style="margin-left: 4px; position: relative; top: -10px;">Export</span></div>');
-   container.append(addButton);
-   container.append(expButton);
-   statusbar.append(container);
-   addButton.jqxButton({ theme: theme, width: 90, height: 17 });
-   expButton.jqxButton({ theme: theme, width: 90, height: 17 });
-   // add new row.
-   addButton.click(function(event) {
-    editrow = -1;
-    $('#popupWindow').jqxWindow({ position: { x: 110, y: 30 } });
-    $('#name').val('Nieuwe brouwset');
-    dataRecord.uuid = '';
-    $('#boil_size').val(18);
-    $('#batch_size').val(15.3);
-    $('#vol_fermenter').val(14.2);
-    $('#tun_volume').val(20);
-    $('#tun_weight').val(2);
-    $('#tun_specific_heat').val(0.11);
-    $('#tun_material').val(0);
-    $('#tun_height').val(20);
-    $('#top_up_water').val(0);
-    $('#trub_chiller_loss').val(0.5);
-    $('#evap_rate').val(1.8);
-    $('#boil_time').val(90);
-    $('#calc_boil_volume').val(1);
-    $('#top_up_kettle').val(0);
-    $('#hop_utilization').val(100);
-    $('#notes').val('');
-    $('#lauter_volume').val(20);
-    $('#lauter_height').val(20);
-    $('#lauter_deadspace').val(0.5);
-    $('#kettle_volume').val(20);
-    $('#kettle_height').val(20);
-    $('#mash_volume').val(18);
-    $('#mash_max').val(6);
-    $('#efficiency').val(75);
-    $('#popupWindow').jqxWindow('open');
-   });
-   expButton.click(function(event) {
-    window.open('export_equipments.php');
-   });
-  },
-  filterable: false,
-  ready: function() {
-   $('#boil_size').on('change', function(event) { calcBatchVolume(); });
-   $('#evap_rate').on('change', function(event) { calcBatchVolume(); });
-   $('#boil_time').on('change', function(event) { calcBatchVolume(); });
-   $('#top_up_kettle').on('change', function(event) { calcBatchVolume(); });
-   $('#calc_boil_volume').on('change', function(event) { calcBatchVolume(); });
-   $('#top_up_water').on('change', function(event) { calcBatchVolume(); });
-   $('#trub_chiller_loss').on('change', function(event) { calcBatchVolume(); });
-   $('#tun_material').on('select', function(event) {
-    dataRecord.tun_specific_heat = MaterialData[event.args.index].sh;
-    $('#tun_specific_heat').val(dataRecord.tun_specific_heat);
-   });
-  },
-  columns: [
-   { text: 'Installatie naam', datafield: 'name', width: 200 },
-   { text: 'Kook volume', datafield: 'boil_size', width: 110, align: 'right', cellsalign: 'right', cellsformat: 'f1' },
-   { text: 'Batch volume', datafield: 'batch_size', width: 110, align: 'right', cellsalign: 'right', cellsformat: 'f1' },
-   { text: 'Opmerkingen', datafield: 'notes' },
-   { text: '', datafield: 'Edit', width: 100, align: 'center', columntype: 'button', cellsrenderer: function() {
-    return 'Wijzig';
-    }, buttonclick: function(row) {
-     // open the popup window when the user clicks a button.
-     editrow = row;
-     $('#popupWindow').jqxWindow({ position: { x: 110, y: 30 } });
-     // get the clicked row's data and initialize the input fields.
-     dataRecord = $('#jqxgrid').jqxGrid('getrowdata', editrow);
-     $('#name').val(dataRecord.name);
-     $('#boil_size').val(dataRecord.boil_size);
-     $('#batch_size').val(dataRecord.batch_size);
-     $('#tun_volume').val(dataRecord.tun_volume);
-     $('#tun_weight').val(dataRecord.tun_weight);
-     $('#tun_specific_heat').val(dataRecord.tun_specific_heat);
-     $('#tun_material').val(dataRecord.tun_material);
-     $('#tun_height').val(dataRecord.tun_height);
-     $('#top_up_water').val(dataRecord.top_up_water);
-     $('#trub_chiller_loss').val(dataRecord.trub_chiller_loss);
-     $('#evap_rate').val(dataRecord.evap_rate);
-     $('#boil_time').val(dataRecord.boil_time);
-     $('#calc_boil_volume').val(dataRecord.calc_boil_volume);
-     $('#top_up_kettle').val(dataRecord.top_up_kettle);
-     $('#hop_utilization').val(dataRecord.hop_utilization);
-     $('#notes').val(dataRecord.notes);
-     $('#lauter_volume').val(dataRecord.lauter_volume);
-     $('#lauter_height').val(dataRecord.lauter_height);
-     $('#lauter_deadspace').val(dataRecord.lauter_deadspace);
-     $('#kettle_volume').val(dataRecord.kettle_volume);
-     $('#kettle_height').val(dataRecord.kettle_height);
-     $('#mash_volume').val(dataRecord.mash_volume);
-     $('#mash_max').val(dataRecord.mash_max);
-     $('#efficiency').val(dataRecord.efficiency);
-     // show the popup window.
-     $('#popupWindow').jqxWindow('open');
-    }
-   }
-  ]
- });
- // initialize the popup window and buttons.
- $('#popupWindow').jqxWindow({
-  width: 1050,
-  height: 600,
-  resizable: false,
-  theme: theme,
-  isModal: true,
-  autoOpen: false,
-  cancelButton: $('#Cancel'),
-  modalOpacity: 0.40
- });
- $('#popupWindow').on('open', function() {
-  $('#name').jqxInput('selectAll');
- });
- $('#Delete').jqxButton({ template: 'danger', width: '90px', theme: theme });
- $('#Delete').click(function() {
-  if (editrow >= 0) {
-   // Open a popup to confirm this action.
-   $('#eventWindow').jqxWindow('open');
-   $('#delOk').click(function() {
-    var rowID = $('#jqxgrid').jqxGrid('getrowid', editrow);
-    $('#jqxgrid').jqxGrid('deleterow', rowID);
-   });
-  }
-  $('#popupWindow').jqxWindow('hide');
- });
- $('#Cancel').jqxButton({ template: 'primary', width: '90px', theme: theme });
- $('#Clone').jqxButton({ template: 'warning', width: '90px', theme: theme });
- $('#Clone').click(function() {
-  var row = {
-   record: -1,
-   name: $('#name').val() + ' kopie',
-   uuid: '',
-   boil_size: parseFloat($('#boil_size').jqxNumberInput('decimal')),
-   batch_size: parseFloat($('#batch_size').jqxNumberInput('decimal')),
-   tun_volume: parseFloat($('#tun_volume').jqxNumberInput('decimal')),
-   tun_weight: parseFloat($('#tun_weight').jqxNumberInput('decimal')),
-   tun_specific_heat: parseFloat($('#tun_specific_heat').jqxNumberInput('decimal')),
-   tun_material: $('#tun_material').val(),
-   tun_height: parseFloat($('#tun_height').jqxNumberInput('decimal')),
-   top_up_water: parseFloat($('#top_up_water').jqxNumberInput('decimal')),
-   trub_chiller_loss: parseFloat($('#trub_chiller_loss').jqxNumberInput('decimal')),
-   evap_rate: parseFloat($('#evap_rate').jqxNumberInput('decimal')),
-   boil_time: parseFloat($('#boil_time').jqxNumberInput('decimal')),
-   calc_boil_volume: $('#calc_boil_volume').val(),
-   top_up_kettle: parseFloat($('#top_up_kettle').jqxNumberInput('decimal')),
-   hop_utilization: parseFloat($('#hop_utilization').jqxNumberInput('decimal')),
-   notes: $('#notes').val(),
-   lauter_volume: parseFloat($('#lauter_volume').jqxNumberInput('decimal')),
-   lauter_height: parseFloat($('#lauter_height').jqxNumberInput('decimal')),
-   lauter_deadspace: parseFloat($('#lauter_deadspace').jqxNumberInput('decimal')),
-   kettle_volume: parseFloat($('#kettle_volume').jqxNumberInput('decimal')),
-   kettle_height: parseFloat($('#kettle_height').jqxNumberInput('decimal')),
-   mash_volume: parseFloat($('#mash_volume').jqxNumberInput('decimal')),
-   mash_max: parseFloat($('#mash_max').jqxNumberInput('decimal')),
-   efficiency: parseFloat($('#efficiency').jqxNumberInput('decimal'))
-  };
-  $('#jqxgrid').jqxGrid('addrow', null, row);
-  $('#popupWindow').jqxWindow('hide');
- });
- $('#Save').jqxButton({ template: 'success', width: '90px', theme: theme });
- // update the edited row when the user clicks the 'Save' button.
- $('#Save').click(function() {
-  var row, rowID = -1;
-  if (editrow >= 0) {
-   rowID = $('#jqxgrid').jqxGrid('getrowid', editrow);
-  }
-  row = {
-   record: rowID,
-   name: $('#name').val(),
-   uuid: dataRecord.uuid,
-   boil_size: parseFloat($('#boil_size').jqxNumberInput('decimal')),
-   batch_size: parseFloat($('#batch_size').jqxNumberInput('decimal')),
-   tun_volume: parseFloat($('#tun_volume').jqxNumberInput('decimal')),
-   tun_weight: parseFloat($('#tun_weight').jqxNumberInput('decimal')),
-   tun_specific_heat: parseFloat($('#tun_specific_heat').jqxNumberInput('decimal')),
-   tun_material: $('#tun_material').val(),
-   tun_height: parseFloat($('#tun_height').jqxNumberInput('decimal')),
-   top_up_water: parseFloat($('#top_up_water').jqxNumberInput('decimal')),
-   trub_chiller_loss: parseFloat($('#trub_chiller_loss').jqxNumberInput('decimal')),
-   evap_rate: parseFloat($('#evap_rate').jqxNumberInput('decimal')),
-   boil_time: parseFloat($('#boil_time').jqxNumberInput('decimal')),
-   calc_boil_volume: $('#calc_boil_volume').val(),
-   top_up_kettle: parseFloat($('#top_up_kettle').jqxNumberInput('decimal')),
-   hop_utilization: parseFloat($('#hop_utilization').jqxNumberInput('decimal')),
-   notes: $('#notes').val(),
-   lauter_volume: parseFloat($('#lauter_volume').jqxNumberInput('decimal')),
-   lauter_height: parseFloat($('#lauter_height').jqxNumberInput('decimal')),
-   lauter_deadspace: parseFloat($('#lauter_deadspace').jqxNumberInput('decimal')),
-   kettle_volume: parseFloat($('#kettle_volume').jqxNumberInput('decimal')),
-   kettle_height: parseFloat($('#kettle_height').jqxNumberInput('decimal')),
-   mash_volume: parseFloat($('#mash_volume').jqxNumberInput('decimal')),
-   mash_max: parseFloat($('#mash_max').jqxNumberInput('decimal')),
-   efficiency: parseFloat($('#efficiency').jqxNumberInput('decimal'))
-  };
-  if (editrow >= 0) {
-   $('#jqxgrid').jqxGrid('updaterow', rowID, row);
-  } else {
-   $('#jqxgrid').jqxGrid('addrow', null, row);
-  }
-  $('#popupWindow').jqxWindow('hide');
- });
- createDelElements();
-});
-