Mercurial > bms / file revision

/*****************************************************************************
 * 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
stylesUrl = "includes/db_profile_styles.php",
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: stylesUrl
},
styleslist = new $.jqx.dataAdapter(stylesSource),

// Equipemnt dropdown list
equipmentUrl = "includes/db_inventory_equipments.php",
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: equipmentUrl
},
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;
}