www/js/global.js

/*****************************************************************************
 * Copyright (C) 2014-2019
 *
 * Michiel Broek <mbroek at mbse dot eu>
 *
 * This file is part of BrewCloud
 *
 * 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.
 *****************************************************************************/


// dropdownlists arrays

var StageData = [
 { id: 0,  en: 'Plan',        nl: 'Plan' },
 { id: 1,  en: 'Wait',        nl: 'Wacht' },
 { id: 2,  en: 'Brew',        nl: 'Brouwen' },
 { id: 3,  en: 'Primary',     nl: 'Hoofdgisting' },
 { id: 4,  en: 'Secondary',   nl: 'Nagisting' },
 { id: 5,  en: 'Tertiary',    nl: 'Lagering' },
 { id: 6,  en: 'Package',     nl: 'Afvullen' },
 { id: 7,  en: 'Carbonation', nl: 'Hergisten' },
 { id: 8,  en: 'Mature',      nl: 'Rijpen' },
 { id: 9,  en: 'Taste',       nl: 'Proeven' },
 { id: 10, en: 'Ready',       nl: 'Gereed' },
 { id: 11, en: 'Closed', nl: 'Afgesloten' }
],
StageSource = {
 localdata: StageData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
StageAdapter = new $.jqx.dataAdapter(StageSource),

MaterialData = [
 { id: 0,  en: 'Stainless Steel', nl: 'RVS',       sh: 0.11 },
 { id: 1,  en: 'Aluminium',       nl: 'Aluminium', sh: 0.22 },
 { id: 2,  en: 'Plastics',        nl: 'Kunststof', sh: 0.46 },
 { id: 3,  en: 'Copper',          nl: 'Koper',     sh: 0.092 }
],
MaterialSource = {
 localdata: MaterialData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }, { name: 'sh' }]
},
MaterialAdapter = new $.jqx.dataAdapter(MaterialSource),

FermentableTypeData = [
 { id: 0, en: 'Grain',       nl: 'Mout' },
 { id: 1, en: 'Sugar',       nl: 'Suiker' },
 { id: 2, en: 'Extract',     nl: 'Vloeibaar extract' },
 { id: 3, en: 'Dry extract', nl: 'Droog extract' },
 { id: 4, en: 'Adjunct',     nl: 'Ongemout graan' }
],
FermentableTypeSource = {
 localdata: FermentableTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
FermentableTypeAdapter = new $.jqx.dataAdapter(FermentableTypeSource),

GrainTypeData = [
 { id: 0, en: 'Base',      nl: 'Basismout' },
 { id: 1, en: 'Roast',     nl: 'Geroosterde mout' },
 { id: 2, en: 'Crystal',   nl: 'Cara- of crystalmout' },
 { id: 3, en: 'Kilned',    nl: 'Geëeste mout'},
 { id: 4, en: 'Sour malt', nl: 'Zuurmout' },
 { id: 5, en: 'Special',   nl: 'Speciale mout' },
 { id: 6, en: 'No malt',   nl: 'Geen mout' }
],
GrainTypeSource = {
 localdata: GrainTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
GrainTypeAdapter = new $.jqx.dataAdapter(GrainTypeSource),

AddedData = [
 { id: 0, en: 'Mash', nl: 'Maischen' },
 { id: 1, en: 'Boil', nl: 'Koken' },
 { id: 2, en: 'Fermentation', nl: 'Vergisten' },
 { id: 3, en: 'Lagering', nl: 'Nagisten/lageren' },
 { id: 4, en: 'Bottle', nl: 'Bottelen' },
 { id: 5, en: 'Kegs', nl: 'Fust' }
],
AddedSource = {
 localdata: AddedData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
AddedAdapter = new $.jqx.dataAdapter(AddedSource),

HopTypeData = [
 { id: 0, en: 'Bittering', nl: 'Bitterhop' },
 { id: 1, en: 'Aroma',     nl: 'Aromahop' },
 { id: 2, en: 'Both',      nl: 'Beide' }
],
HopTypeSource = {
 localdata: HopTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
HopTypeAdapter = new $.jqx.dataAdapter(HopTypeSource),

HopFormData = [
 { id: 0, en: 'Pellet',   nl: 'Pellets' },
 { id: 1, en: 'Plug',     nl: 'Plugs' },
 { id: 2, en: 'Leaf',     nl: 'Bloemen' },
 { id: 3, en: 'Leaf wet', nl: 'Hop nat' },
 { id: 4, en: 'Cryo',     nl: 'Cryo' }
],
HopFormSource = {
 localdata: HopFormData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
HopFormAdapter = new $.jqx.dataAdapter(HopFormSource),

HopUseData = [
 { id: 0, en: 'Mash',       nl: 'Maischhop' },
 { id: 1, en: 'First wort', nl: 'First wort hop' },
 { id: 2, en: 'Boil',       nl: 'Koken' },
 { id: 3, en: 'Aroma',      nl: 'Vlamuit' },
 { id: 4, en: 'Whirlpool',  nl: 'Whirlpool' },
 { id: 5, en: 'Dry hop',    nl: 'Koudhop' }
],
HopUseSource = {
 localdata: HopUseData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
HopUseAdapter = new $.jqx.dataAdapter(HopUseSource),

YeastTypeData = [
 { id: 0, en: 'Lager',     nl: 'Ondergist' },
 { id: 1, en: 'Ale',       nl: 'Bovengist' },
 { id: 2, en: 'Wheat',     nl: 'Tarwegist' },
 { id: 3, en: 'Wine',      nl: 'Wijngist' },
 { id: 4, en: 'Champagne', nl: 'Champagnegist' }
// { id: 5, en: 'Brett',     nl: 'Brett' },
// { id: 6, en: 'Kveik',     nl: 'Kveik' },
// { id: 7, en: 'Mixed',     nl: 'Mixed' },
// { id: 8, en: 'Spontaneous', nl: 'Spontaan' },
// { id: 9, en: 'Other',       nl: 'Overig' }
],
YeastTypeSource = {
 localdata: YeastTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
YeastTypeAdapter = new $.jqx.dataAdapter(YeastTypeSource),

YeastFormData = [
 { id: 0, en: 'Liquid',  nl: 'Vloeibaar',    cells: 100000000000 },
 { id: 1, en: 'Dry',     nl: 'Korrel',       cells: 15000000000 },
 { id: 2, en: 'Slant',   nl: 'Schuine buis', cells: 1700000000 },
 { id: 3, en: 'Culture', nl: 'Slurry',       cells: 1700000000 },
 { id: 4, en: 'Frozen',  nl: 'Ingevroren',   cells: 1700000000 },
 { id: 5, en: 'Bottle',  nl: 'Depot',        cells: 1700000000 }
],
YeastFormSource = {
 localdata: YeastFormData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }, { name: 'cells' }]
},
YeastFormAdapter = new $.jqx.dataAdapter(YeastFormSource),

YeastUseData = [
 { id: 0, en: 'Primary',   nl: 'Hoofdgisting' },
 { id: 1, en: 'Secondary', nl: 'Nagisting' },
 { id: 2, en: 'Tertiary',  nl: 'Lagering' },
 { id: 3, en: 'Bottle',    nl: 'Bottelen' }
],
YeastUseSource = {
 localdata: YeastUseData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }, { name: 'cells' }]
},
YeastUseAdapter = new $.jqx.dataAdapter(YeastUseSource),

FlocculationData = [
 { id: 0, en: 'Low',       nl: 'Laag' },
 { id: 1, en: 'Medium',    nl: 'Medium' },
 { id: 2, en: 'High',      nl: 'Hoog' },
 { id: 3, en: 'Very high', nl: 'Zeer hoog' }
],
FlocculationSource = {
 localdata: FlocculationData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
FlocculationAdapter = new $.jqx.dataAdapter(FlocculationSource),

StarterTypeData = [
 { id: 0, en: 'Stirred', nl: 'Geroerd' },
 { id: 1, en: 'Shaken',  nl: 'Geschud' },
 { id: 2, en: 'Simple',  nl: 'Simpel' }
],
StarterTypeSource = {
 localdata: StarterTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
StarterTypeAdapter = new $.jqx.dataAdapter(StarterTypeSource),

MiscTypeData = [
 { id: 0, en: 'Spice',          nl: 'Specerij' },
 { id: 1, en: 'Herb',           nl: 'Kruid' },
 { id: 2, en: 'Flavor',         nl: 'Smaakstof' },
 { id: 3, en: 'Fining',         nl: 'Klaringsmiddel' },
 { id: 4, en: 'Water agent',    nl: 'Brouwzout' },
 { id: 5, en: 'Yeast nutrient', nl: 'Gistvoeding' },
 { id: 6, en: 'Other',          nl: 'Overig' }
],
MiscTypeSource = {
 localdata: MiscTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
MiscTypeAdapter = new $.jqx.dataAdapter(MiscTypeSource),

MiscUseData = [
 { id: 0, en: 'Starter',   nl: 'Starter' },
 { id: 1, en: 'Mash',      nl: 'Maischen' },
 { id: 2, en: 'Boil',      nl: 'Koken' },
 { id: 3, en: 'Primary',   nl: 'Hoofdvergisting' },
 { id: 4, en: 'Secondary', nl: 'Nagisting/lagering' },
 { id: 5, en: 'Bottling',  nl: 'Bottelen' }
],
MiscUseSource = {
 localdata: MiscUseData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
MiscUseAdapter = new $.jqx.dataAdapter(MiscUseSource),

StyleTypeData = [
 { id: 0, en: 'Lager', nl: 'Ondergistend bier' },
 { id: 1, en: 'Ale',   nl: 'Bovengistend bier' },
 { id: 2, en: 'Mead',  nl: 'Mede' },
 { id: 3, en: 'Wheat', nl: 'Tarwebier' },
 { id: 4, en: 'Mixed', nl: 'Gemengd' },
 { id: 5, en: 'Cider', nl: 'Cider' }
],
StyleTypeSource = {
 localdata: StyleTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
StyleTypeAdapter = new $.jqx.dataAdapter(StyleTypeSource),

MashStepTypeData = [
 { id: 0, en: 'Infusion',    nl: 'Infusie' },
 { id: 1, en: 'Temperature', nl: 'Verwarming' },
 { id: 2, en: 'Decoction',   nl: 'Decoctie' }
],
MashStepTypeSource = {
 localdata: MashStepTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
MashStepTypeAdapter = new $.jqx.dataAdapter(MashStepTypeSource),

RecipeTypeData = [
 { id: 0, en: 'Extract',      nl: 'Extract' },
 { id: 1, en: 'Partial Mash', nl: 'Deelmaisch' },
 { id: 2, en: 'All Grain',    nl: 'Mout' }
],
RecipeTypeSource = {
 localdata: RecipeTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
RecipeTypeAdapter = new $.jqx.dataAdapter(RecipeTypeSource),

IBUmethodData = [
 { id: 0, en: 'Tinseth', nl: 'Tinseth' },
 { id: 1, en: 'Rager',   nl: 'Rager' },
 { id: 2, en: 'Daniels', nl: 'Daniels' }
// { id: 3, en: 'Garetz',  nl: 'Garetz' }, // Not yet supported.
// { id: 4, en: 'Mosher',  nl: 'Mosher' },
// { id: 5, en: 'Noonan',  nl: 'Noonan' }
],
IBUmethodSource = {
 localdata: IBUmethodData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
IBUmethodAdapter = new $.jqx.dataAdapter(IBUmethodSource),

ColorMethodData = [
 { id: 0, en: 'Morey',       nl: 'Morey' },
 { id: 1, en: 'Mosher',      nl: 'Mosher' },
 { id: 2, en: 'Daniels',     nl: 'Daniels' },
 { id: 3, en: 'Halberstadt', nl: 'Halberstadt' },
 { id: 4, en: 'Naudts',      nl: 'Naudts' }
],
ColorMethodSource = {
 localdata: ColorMethodData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
ColorMethodAdapter = new $.jqx.dataAdapter(ColorMethodSource),

CoolingTypeData = [
 { id: 0, en: '-',                   nl: '-' },
 { id: 1, en: 'Emersion chiller',    nl: 'Dompelkoeler' },
 { id: 2, en: 'Counterflow chiller', nl: 'Tegenstroomkoeler' },
 { id: 3, en: 'Au bain marie',       nl: 'Au bain marie' },
 { id: 4, en: 'Natural',             nl: 'Laten afkoelen' }
],
CoolingTypeSource = {
 localdata: CoolingTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
CoolingTypeAdapter = new $.jqx.dataAdapter(CoolingTypeSource),

AerationTypeData = [
 { id: 0, en: 'None',   nl: 'Geen' },
 { id: 1, en: 'Air',    nl: 'Lucht' },
 { id: 2, en: 'Oxygen', nl: 'Zuurstof' }
],
AerationTypeSource = {
 localdata: AerationTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
AerationTypeAdapter = new $.jqx.dataAdapter(AerationTypeSource),

AcidTypeData = [
 { id: 0, en: 'Lactic',       nl: 'Melkzuur' },
 { id: 1, en: 'Hydrochloric', nl: 'Zoutzuur' },
 { id: 2, en: 'Phosphoric',   nl: 'Fosforzuur' },
 { id: 3, en: 'Sulfuric',     nl: 'Zwavelzuur' }
],
AcidTypeSource = {
 localdata: AcidTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
AcidTypeAdapter = new $.jqx.dataAdapter(AcidTypeSource),

BaseTypeData = [
 { id: 0, en: 'Sodiumbicarbonate', nl: 'NaHCO3' },
 { id: 1, en: 'Sodiumcarbonate',   nl: 'Na2CO3' },
 { id: 2, en: 'Calciumcarbonate',  nl: 'CaCO3' },
 { id: 3, en: 'Calciumhydroxide',  nl: 'Ca(OH)2' }
],
BaseTypeSource = {
 localdata: BaseTypeData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
BaseTypeAdapter = new $.jqx.dataAdapter(BaseTypeSource),

SpargeSourceData = [
 { id: 0, en: 'Source 1', nl: 'Bron 1' },
 { id: 1, en: 'Source 2', nl: 'Bron 2' },
 { id: 2, en: 'Mixed',    nl: 'Gemengd' }
],
SpargeSourceSource = {
 localdata: SpargeSourceData,
 datatype: 'array',
 datafields: [{ name: 'id' }, { name: 'en' }, { name: 'nl' }]
},
SpargeSourceAdapter = new $.jqx.dataAdapter(SpargeSourceSource),


// options for editors

Show1wat = { inputMode: 'simple', theme: theme, width: 74, height: 23, decimalDigits: 1, readOnly: true },
Show2wat = { inputMode: 'simple', theme: theme, width: 74, height: 23, decimalDigits: 2, readOnly: true },
Show3wat = { inputMode: 'simple', theme: theme, width: 74, height: 23, decimalDigits: 3, readOnly: true },
Smal0dec = { inputMode: 'simple', theme: theme, width: 50, height: 23, decimalDigits: 0, readOnly: true },
Smal1dec = { inputMode: 'simple', theme: theme, width: 50, height: 23, decimalDigits: 1, readOnly: true },
Show0dec = { inputMode: 'simple', theme: theme, width: 90, height: 23, readOnly: true, decimalDigits: 0 },
Show1dec = { inputMode: 'simple', theme: theme, width: 90, height: 23, readOnly: true, decimalDigits: 1 },
Show2dec = { inputMode: 'simple', theme: theme, width: 90, height: 23, readOnly: true, decimalDigits: 2 },
Show3dec = { inputMode: 'simple', theme: theme, width: 90, height: 23, readOnly: true, decimalDigits: 3 },
  SGopts = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0.990, max: 1.199, decimalDigits: 3, spinButtons: true },
Spin1dec = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, decimalDigits: 1, spinButtons: true },
Spin2dec = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, decimalDigits: 2, spinButtons: true },
Spin3dec = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, decimalDigits: 3, spinButtons: true },
  SpinpH = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 1, max: 14, decimalDigits: 1, spinButtons: true },
 Spin2pH = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 1, max: 14, decimalDigits: 2, spinButtons: true },
  YeastT = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, max: 40, decimalDigits: 1, spinButtons: true },
  PosInt = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, decimalDigits: 0, spinButtons: true },
Perc1dec = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, max: 100, decimalDigits: 1, spinButtons: true },
   Perc0 = { inputMode: 'simple', theme: theme, width: 110, height: 23, min: 0, max: 100, decimalDigits: 0, spinButtons: true },
Dateopts = {
 theme: theme, width: 150, height: 23, allowNullDate: true, todayString: 'Vandaag', clearString: 'Wissen', showFooter: true,
 formatString: 'yyyy-MM-dd', enableBrowserBoundsDetection: true
},
DateTimeopts = {
 theme: theme, width: 230, height: 23, allowNullDate: true, todayString: 'Vandaag', clearString: 'Wissen', showFooter: true,
 formatString: 'yyyy-MM-dd HH:mm:ss', enableBrowserBoundsDetection: true, showTimeButton: true
},


sugardensity = 1.611, //kg/l in solution

// Styles dropdown list
stylesSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'category', type: 'string' },
  { name: 'category_number', type: 'number' },
  { name: 'style_letter', type: 'string' },
  { name: 'style_guide', type: 'string' },
  { name: 'type', type: 'int' },
  { name: 'og_min', type: 'float' },
  { name: 'og_max', type: 'float' },
  { name: 'fg_min', type: 'float' },
  { name: 'fg_max', type: 'float' },
  { name: 'ibu_min', type: 'float' },
  { name: 'ibu_max', type: 'float' },
  { name: 'color_min', type: 'float' },
  { name: 'color_max', type: 'float' },
  { name: 'carb_min', type: 'float' },
  { name: 'carb_max', type: 'float' },
  { name: 'abv_min', type: 'float' },
  { name: 'abv_max', type: 'float' },
  { name: 'notes', type: 'string' },
  { name: 'profile', type: 'string' },
  { name: 'ingredients', type: 'string' },
  { name: 'examples', type: 'string' }
 ],
 url: 'includes/db_profile_styles.php'
},
styleslist = new $.jqx.dataAdapter(stylesSource),

// Equipemnt dropdown list
equipmentSource = {
 datatype: 'json',
 datafields: [
  { 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' }
 ],
 url: 'includes/db_inventory_equipments.php'
},
equipmentlist = new $.jqx.dataAdapter(equipmentSource),

// dropdownlist datasource from inventory_fermentables
fermentableInvSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'type', type: 'int' },
  { name: 'yield', type: 'float' },
  { name: 'color', type: 'float' },
  { name: 'add_after_boil', type: 'int' },
  { name: 'origin', type: 'string' },
  { name: 'supplier', type: 'string' },
  { name: 'coarse_fine_diff', type: 'float' },
  { name: 'moisture', type: 'float' },
  { name: 'diastatic_power', type: 'float' },
  { name: 'protein', type: 'float' },
  { name: 'dissolved_protein', type: 'float' },
  { name: 'max_in_batch', type: 'float' },
  { name: 'recommend_mash', type: 'int' },
  { name: 'graintype', type: 'int' },
  { name: 'di_ph', type: 'float' },
  { name: 'acid_to_ph_57', type: 'float' },
  { name: 'inventory', type: 'float' },
  { name: 'cost', type: 'float' }
 ],
 url: 'getfermentablesources.php'
},
fermentableinstock = false,
fermentablelist = new $.jqx.dataAdapter(fermentableInvSource, {
 beforeLoadComplete: function(records) {
  var row, i, data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
   if (row.inventory || ! fermentableinstock)
    data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),
fermentablesugars = new $.jqx.dataAdapter(fermentableInvSource, {
 beforeLoadComplete: function(records) {
  var row, i, data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
   if (row.type == 1 || row.type == 3) // Sugars or dry extract
    data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),

// dropdownlist datasource from inventory_hops
hopInvSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'origin', type: 'string' },
  { name: 'type', type: 'int' },
  { name: 'alpha', type: 'float' },
  { name: 'beta', type: 'float' },
  { name: 'humulene', type: 'float' },
  { name: 'caryophyllene', type: 'float' },
  { name: 'cohumulone', type: 'float' },
  { name: 'myrcene', type: 'float' },
  { name: 'hsi', type: 'float' },
  { name: 'useat', type: 'int' },
  { name: 'form', type: 'int' },
  { name: 'total_oil', type: 'float' },
  { name: 'inventory', type: 'float' },
  { name: 'cost', type: 'float' }
 ],
 url: 'gethopsources.php'
},
hopinstock = false,
hoplist = new $.jqx.dataAdapter(hopInvSource, {
 beforeLoadComplete: function(records) {
  var row, i, data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
   if (row.inventory || ! hopinstock)
    data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),

// dropdownlist datasource from inventory_miscs
miscInvSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'type', type: 'int' },
  { name: 'use_use', type: 'int' },
  { name: 'amount_is_weight', type: 'int' },
  { name: 'time', type: 'float' },
  { name: 'inventory', type: 'float' },
  { name: 'cost', type: 'float' }
 ],
 url: 'getmiscsources.php'
},
miscinstock = false,
misclist = new $.jqx.dataAdapter(miscInvSource, {
 beforeLoadComplete: function(records) {
  var row, i, data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
    if (row.inventory || ! miscinstock)
     data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),

// dropdownlist datasource from inventory_yeasts
yeastInvSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'type', type: 'int' },
  { name: 'form', type: 'int' },
  { name: 'laboratory', type: 'string' },
  { name: 'product_id', type: 'string' },
  { name: 'min_temperature', type: 'float' },
  { name: 'max_temperature', type: 'float' },
  { name: 'flocculation', type: 'int' },
  { name: 'attenuation', type: 'float' },
  { name: 'cells', type: 'float' },
  { name: 'inventory', type: 'float' },
  { name: 'cost', type: 'float' },
  { name: 'tolerance', type: 'float' }
 ],
 url: 'getyeastsources.php'
},
yeastinstock = false,
yeastlist = new $.jqx.dataAdapter(yeastInvSource, {
 beforeLoadComplete: function(records) {
  var row, i, data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
   if (row.inventory || ! yeastinstock)
    data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),

// dropdownlist datasource from inventory_waters
waterInvSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'unlimited_stock', type: 'int' },
  { name: 'calcium', type: 'float' },
  { name: 'sulfate', type: 'float' },
  { name: 'chloride', type: 'float' },
  { name: 'sodium', type: 'float' },
  { name: 'magnesium', type: 'float' },
  { name: 'ph', type: 'float' },
  { name: 'total_alkalinity', type: 'float' },
  { name: 'inventory', type: 'float' },
  { name: 'cost', type: 'float' },
 ],
 url: 'getwatersources.php'
},
waterinstock = false,
waterlist = new $.jqx.dataAdapter(waterInvSource, {
 beforeLoadComplete: function(records) {
  var data, i, row;
  data = new Array();
  for (i = 0; i < records.length; i++) {
   row = records[i];
   if (row.inventory || row.unlimited_stock || ! waterinstock)
    data.push(row);
  }
  return data;
 },
 loadError: function(jqXHR, status, error) {
  console.log(status + ' ' + error);
 },
}),

// dropdownlist datasource from profile_water
waterProfileSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'calcium', type: 'float' },
  { name: 'bicarbonate', type: 'float' },
  { name: 'sulfate', type: 'float' },
  { name: 'chloride', type: 'float' },
  { name: 'sodium', type: 'float' },
  { name: 'magnesium', type: 'float' },
  { name: 'ph', type: 'float' },
  { name: 'total_alkalinity', type: 'float' },
 ],
 url: 'includes/db_profile_water.php'
},
waterprofiles = new $.jqx.dataAdapter(waterProfileSource),

// dropdownlist datasource from profile_mash
mashProfileSource = {
 datatype: 'json',
 datafields: [
  { name: 'record', type: 'number' },
  { name: 'name', type: 'string' },
  { name: 'steps', type: 'array' }
 ],
 url: 'includes/db_profile_mash.php'
},
mashlist = new $.jqx.dataAdapter(mashProfileSource),


/*
 * From "Rekenen aan bier" by Hans Halberstadt.
 */
K1s = 0.384, K1a = -0.177, K1e = 0.241, K1g = 0.247, Ks = 0.1415, Ka1 = 0.058, Ka2 = 0.078, Ke = 0.174, Kg = 0.109;

// =E2/E6+(E3/E6)*$B$24/$B$23+(E3/E6)*(E3/E6)*$B$25/$B$23+E4/E6*$B$26/$B$23+E5/E6*$B$27/$B$23
// For Brix
function A(sugar, volume, alc, eiwit, glycerol) {

 var vol, A;

 vol = volume * 1000;
 A = sugar / vol + (alc / vol) * Ka1 / Ks + (alc / vol) * (alc / vol) * Ka2 / Ks + eiwit / vol * Ke / Ks + glycerol / vol * Kg / Ks;
 console.log('A(' + sugar + ',' + volume + ',' + alc + ',' + eiwit + ',' + glycerol + '):' + A);
 return A;
}

// =E2/E6+(E3/E6)*$B$20/$B$19+E4/E6*$B$21/$B$19+E5/E6*$B$22/$B$19
// for Plato
function B(sugar, volume, alc, eiwit, glycerol) {

 var vol, B;

 vol = volume * 1000;
 B = sugar / vol + (alc / vol) * K1a / K1s + eiwit / vol * K1e / K1s + glycerol / vol * K1g / K1s;
 console.log('B(' + sugar + ',' + volume + ',' + alc + ',' + eiwit + ',' + glycerol + '):' + B);
 return B;
}


$(document).ready(function() {

 $('#jqxMenu').jqxMenu({
  width: 1280,
  height: '30px',
  autoOpen: false,
  clickToOpen: true,
  theme: theme
 });
 $('#jqxWidget').css('visibility', 'visible');

});


function Round(n, d) {
 for (var i = 0, m = 1; i < d; i++, m *= 10);
 return Math.round(n * m) / m;
}


function ebc_to_srm(ebc) {
 var srm = -1.32303E-12 * Math.pow(ebc, 4) - 0.00000000291515 * Math.pow(ebc, 3) + 0.00000818515 * Math.pow(ebc, 2) + 0.372038 * ebc + 0.596351;
 if (srm < 0)
  srm = 0;
 return srm;
}


function srm_to_ebc(srm) {
 var ebc = Math.round(0.000000000176506 * Math.pow(srm, 4) + 0.000000154529 * Math.pow(srm, 3) - 0.000159428 * Math.pow(srm, 2) + 2.68837 * srm - 1.6004);
 if (ebc < 0)
  ebc = 0;
 return ebc;
}


/* Return incremented color by the boil and yeast.
 * https://www.hobbybrouwen.nl/forum/index.php/topic,19020.msg281132.html#msg281132 */
function get_kt(ebc) {

 var kt = 1;
 if (ebc < 3)
  kt = 3.5;
 else if (ebc < 6)
  kt = 3;
 else if (ebc < 8)
  kt = 2.75;
 else if (ebc < 10)
  kt = 2.5;
 else if (ebc < 20)
  kt = 1.8;
 else if (ebc < 30)
  kt = 1.6;
 else if (ebc < 60)
  kt = 1.3;
 else if (ebc < 100)
  kt = 1.2;
 else if (ebc < 300)
  kt = 1.1;
 return kt;
}


function abvol(og, fg) {
 if (((og - fg) < 0) || (fg < 0.9))
  return 0;
 var factor = og * 3157 * Math.pow(10, -5) + 9.716 * Math.pow(10, -2);
 return (og * 1000 - fg * 1000) * factor;
}


/* Kleurwerking naar SRM. Niet voor Halberstadt, Naudts */
function kw_to_srm(colormethod, c) {
 if (colormethod == 0)
  return 1.4922 * Math.pow(c, 0.6859); //Morey
 if (colormethod == 1)
  return 0.3 * c + 4.7; //Mosher
 if (colormethod == 2)
  return 0.2 * c + 8.4; //Daniels
 return 0; //Halberstadt,Naudts
}


function kw_to_ebc(colormethod, c) {
 return srm_to_ebc(kw_to_srm(colormethod, c));
}


/*
 * Berekeningen uit https://www.hobbybrouwen.nl/forum/index.php/topic,6079.msg69464.html#msg69464
 */
function toIBU(Use, Form, SG, Volume, Amount, Boiltime, Alpha, Method) {

 var gravity, liters, alpha, mass, time, fmoment = 1.0, pfactor = 1.0, ibu = 0, boilfactor, sgfactor,
     AddedAlphaAcids, Bigness_factor, BoilTime_factor, utiisation;

 gravity = parseFloat(SG);
 liters = parseFloat(Volume);
 alpha = parseFloat(Alpha) / 100;
 mass = parseFloat(Amount) * 1000;
 time = parseFloat(Boiltime);

 if ((Use == 3) || (Use == 4) || (Use == 5)) { // Aroma, Whirlpool or Dry hop.
  fmoment = 0.0;
 } else if (Use == 0) { // Mash
  fmoment += my_factor_mashhop / 100; // Brouwhulp
 } else if (Use == 1) { // First wort
  fmoment += my_factor_fwh / 100; // Brouwhulp, Louis, Ozzie
 }

 if (Form == 0) { // Pellet
  pfactor += my_factor_pellet / 100;
 } else if (Form == 1) { // Plug
  pfactor += my_factor_plug / 100;
 } else if (Form == 3) { // Wet leaf
  pfactor += my_factor_wethop / 100; // From https://github.com/chrisgilmerproj/brewday/blob/master/brew/constants.py
 } else if (Form == 4) { // Cryo hop
  pfactor += my_factor_cryohop / 100;
 }

 if (Method == 0) { // Tinseth
  /* http://realbeer.com/hops/research.html */
  AddedAlphaAcids = (alpha * mass * 1000) / liters;
  Bigness_factor = 1.65 * Math.pow(0.000125, gravity - 1);
  BoilTime_factor = ((1 - Math.exp(-0.04 * time)) / 4.15);
  utiisation = Bigness_factor * BoilTime_factor;
  ibu = Round(utiisation * AddedAlphaAcids * fmoment * pfactor, 1);
 }
 if (Method == 2) { // Daniels
  if (Form == 2) // Leaf
   boilfactor = -(0.0041 * time * time) + (0.6162 * time) + 1.5779;
  else
   boilfactor = -(0.0051 * time * time) + (0.7835 * time) + 1.9348;
  if (gravity < 1050)
   sgfactor = 0;
  else
   sgfactor = (gravity - 1050) / 200;
  ibu = Round(fmoment * ((mass * (alpha * 100) * boilfactor * 0.1) / (liters * (1 + sgfactor))), 1);
 }
 if (Method == 1) { // Rager
  boilfactor = fmoment * 18.11 + 13.86 * Math.tanh((time * 31.32) / 18.27);
  if (gravity < 1050)
   sgfactor = 0;
  else
   sgfactor = (gravity - 1050) / 200;
  ibu = Round((mass * (alpha * 100) * boilfactor * 0.1) / (liters * (1 + sgfactor)), 1);
 }

 //console.log("toIBU("+Use+","+Form+","+SG+","+Volume+","+Amount+","+Boiltime+","+Alpha+","+Method+"):"+ibu+" fm:"+fmoment+" pf:"+pfactor);
 return ibu;
}


function ebc_to_color(ebc) {
 return srm_to_color(ebc_to_srm(ebc));
}


function srm_to_color(srm) {
 var i, R, G, B, color, result;

 i = Math.round(srm * 10);
 if (i < 0)
  i = 0;
 if (i > 299)
  i = 299;

 /* Table copied from Brouwhulp/BrewBuddy */

 R = [
 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, //0
 250, 250, 250, 250, 250, 249, 248, 247, 246, 245, 244, 243, 242, 241, 240, 239, 238, 237, 236, 235, //2
 234, 233, 232, 231, 230, 229, 228, 227, 226, 225, 224, 223, 222, 221, 220, 219, 218, 217, 216, 215, //4
 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 200, 199, 199, 198, 198, //6
 197, 197, 196, 196, 195, 195, 194, 194, 193, 193, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, //8
 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, 192, //10
 192, 192, 192, 192, 192, 192, 192, 192, 191, 190, 189, 188, 187, 186, 185, 184, 183, 182, 181, 180, //12
 179, 178, 177, 175, 174, 172, 171, 169, 168, 167, 195, 164, 162, 161, 159, 158, 157, 155, 154, 152, //14
 151, 149, 148, 147, 145, 144, 142, 141, 139, 138, 137, 135, 134, 132, 131, 129, 128, 127, 125, 124, //16
 122, 121, 119, 118, 117, 115, 114, 112, 111, 109, 108, 107, 105, 104, 102, 101, 99, 98, 97, 95, //18
 94, 92, 91, 89, 88, 87, 85, 84, 82, 81, 79, 78, 77, 75, 74, 72, 71, 69, 68, 67, //20
 65, 64, 62, 61, 59, 58, 57, 55, 54, 52, 51, 49, 48, 47, 45, 44, 43, 41, 39, 38, //22
 37, 37, 36, 36, 35, 35, 34, 34, 33, 33, 32, 32, 31, 31, 30, 30, 29, 29, 28, 28, //24
 27, 27, 26, 26, 25, 25, 24, 24, 23, 23, 22, 22, 21, 21, 20, 20, 19, 19, 18, 18, //26
 17, 17, 16, 16, 15, 15, 14, 14, 13, 13, 12, 12, 11, 11, 10, 10, 9, 9, 8, 8];

 G = [
 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250, 250,
 250, 250, 250, 250, 250, 250, 249, 248, 247, 246, 245, 244, 242, 240, 238, 236, 234, 232, 230, 228,
 226, 224, 222, 220, 218, 216, 214, 212, 210, 208, 206, 204, 202, 200, 198, 196, 194, 192, 190, 188,
 186, 184, 182, 180, 178, 176, 174, 172, 170, 168, 166, 164, 162, 160, 158, 156, 154, 152, 150, 148,
 146, 144, 142, 141, 140, 139, 139, 138, 137, 136, 136, 135, 134, 133, 133, 132, 131, 130, 130, 129,
 128, 127, 127, 126, 125, 124, 124, 123, 122, 121, 121, 120, 119, 118, 118, 117, 116, 115, 115, 114,
 113, 112, 112, 111, 110, 109, 109, 108, 107, 106, 106, 105, 104, 103, 103, 102, 101, 100, 100, 99,
 98, 97, 97, 96, 95, 94, 94, 93, 92, 91, 91, 90, 89, 88, 88, 87, 86, 85, 85, 84,
 83, 82, 82, 81, 80, 79, 78, 77, 76, 75, 75, 74, 73, 72, 72, 71, 70, 69, 69, 68,
 67, 66, 66, 65, 64, 63, 63, 62, 61, 60, 60, 59, 58, 57, 57, 56, 55, 54, 54, 53,
 52, 51, 51, 50, 49, 48, 48, 47, 46, 45, 45, 44, 43, 42, 42, 41, 40, 39, 39, 38,
 37, 36, 36, 35, 34, 33, 33, 32, 31, 30, 30, 29, 28, 27, 27, 26, 25, 24, 24, 23,
 22, 22, 22, 21, 21, 21, 20, 20, 20, 19, 19, 19, 18, 18, 18, 17, 17, 17, 16, 16,
 16, 15, 15, 15, 14, 14, 14, 13, 13, 13, 12, 12, 12, 11, 11, 11, 10, 10, 10, 9,
 9, 9, 8, 8, 8, 7, 7, 7, 6, 6, 6, 5, 5, 5, 4, 4, 4, 3, 3, 3];

 B = [
 210, 204, 199, 193, 188, 182, 177, 171, 166, 160, 155, 149, 144, 138, 133, 127, 122, 116, 111, 105,
 100, 94, 89, 83, 78, 72, 67, 61, 56, 50, 45, 45, 45, 46, 46, 46, 46, 47, 47, 47,
 47, 48, 48, 48, 48, 49, 49, 49, 49, 50, 50, 50, 50, 51, 51, 51, 51, 52, 52, 52,
 52, 53, 53, 53, 53, 54, 54, 54, 54, 55, 55, 55, 55, 56, 56, 56, 56, 56, 56, 56,
 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56,
 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56,
 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56, 56,
 56, 56, 56, 55, 55, 55, 55, 54, 54, 54, 54, 53, 53, 53, 53, 52, 52, 52, 52, 51,
 51, 51, 51, 50, 50, 50, 50, 49, 49, 48, 47, 47, 46, 45, 45, 44, 43, 43, 42, 41,
 41, 40, 39, 39, 38, 37, 37, 36, 35, 34, 33, 32, 31, 29, 28, 27, 26, 25, 24, 23,
 21, 20, 19, 18, 17, 16, 15, 13, 12, 11, 10, 9, 8, 9, 9, 10, 10, 11, 11, 12,
 12, 13, 13, 14, 14, 15, 15, 16, 16, 17, 17, 18, 18, 19, 19, 20, 20, 21, 21, 22,
 21, 21, 21, 20, 20, 20, 19, 19, 19, 18, 18, 18, 17, 17, 17, 17, 16, 16, 15, 15,
 15, 14, 14, 14, 13, 13, 13, 12, 12, 12, 11, 11, 11, 10, 10, 10, 9, 9, 9, 8,
 8, 8, 7, 7, 7, 6, 6, 6, 5, 5, 5, 4, 4, 4, 3, 3, 3, 2, 2, 2];

 color = R[i] * 65536 + G[i] * 256 + B[i];
 result = color.toString(16).toUpperCase();
 if (result.length < 6)
  result = '0' + result;
 return '#' + result;
}


function sg_to_plato(sg) {
 return ((135.997 * sg - 630.272) * sg + 1111.14) * sg - 616.868;
}


function plato_to_sg(plato) {
 return 1 + (plato / (258.6 - ((plato / 258.2) * 227.1)));
}


function brix_to_sg(brix) {
 if (my_brix_correction > 0)
  return plato_to_sg(brix / my_brix_correction);
 else
  return plato_to_sg(brix);
}


function sg_to_brix(sg) {
 return sg_to_plato(sg) * my_brix_correction;
}


function estimate_sg(sugars, batch_size) {

 var plato, sg, i;

 plato = 100 * sugars / batch_size;
 sg = plato_to_sg(plato);
 for (i = 0; i < 20; i++) {
  if (sg > 0)
   plato = 100 * sugars / (batch_size * sg);
  sg = plato_to_sg(plato);
 }
 return Round(sg, 4);
}


function estimate_fg(percSugar, percCara, WGratio, TotTme, Temp, attenuation, og) {

 var BD, AttBeer, fg;

 if (percSugar > 40)
  percSugar = 0;
 if (percCara > 50)
  percCara = 0;
 if ((WGratio > 0) && (TotTme > 0)) {
  BD = WGratio;
  if (BD < 2)
   BD = 2;
  if (BD > 5.5)
   BD = 5.5;
  if (Temp < 60)
   Temp = 60;
  if (Temp > 72)
   Temp = 72;
 } else {
  BD = 3.5;
  Temp = 67;
  TotTme = 75;
 }
 if (attenuation < 30)
  attenuation = 77;

 // 0.00825 Attenuation factor yeast
 // 0.00817 Attenuation factor water/grain ration
 // -0.00684 Attenuation factor mash temperature
 // 0.00026 Attenuation factor total mash time  (at some places this is 0.0026 this is wrong!)
 // -0.00356 Attenuation factor percentage crystal malt
 // 0.00553 Attenuation factor percentage simple sugars
 // 0.547 Attenuation factor constant
 AttBeer = 0.00825 * attenuation + 0.00817 * BD - 0.00684 * Temp + 0.00026 * TotTme - 0.00356 * percCara + 0.00553 * percSugar + 0.547;
 fg = Round(1 + (1 - AttBeer) * (og - 1), 4);

 console.log('estimate_fg(' + percSugar + ',' + percCara + ',' + BD + ',' + TotTme + ',' +
             Temp + ',' + attenuation + ',' + og + ') AttBeer:' + AttBeer + ' fg:' + fg);
 return fg;
}


function CalcFrac(TpH, pK1, pK2, pK3) {

 var r1d, r2d, r3d, dd, f2d, f3d, f4d;

 r1d = Math.pow(10, TpH - pK1);
 r2d = Math.pow(10, TpH - pK2);
 r3d = Math.pow(10, TpH - pK3);
 dd = 1 / (1 + r1d + r1d * r2d + r1d * r2d * r3d);
 f2d = r1d * dd;
 f3d = r1d * r2d * dd;
 f4d = r1d * r2d * r3d * dd;
 return f2d + 2 * f3d + 3 * f4d;
}


function lintner_to_kolbach(lintner) {
 return (3.5 * lintner) - 16;
}


function kolbach_to_lintner(kolbach) {
 return (kolbach + 16) / 3.5;
}