src/Setup.cpp

/**
 * Setup.cpp is part of bmsapp.
 *
 * bmsapp 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 3 of the License, or
 * (at your option) any later version.
 *
 * bmsapp 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 this program.  If not, see <http://www.gnu.org/licenses/>.
 */
#include "Setup.h"
#include "config.h"
#include "global.h"
#include "MainWindow.h"


Setup::Setup(QWidget *parent) : QDialog(parent)
{
    QSqlQuery query;
    QGridLayout *gridLayout;
    QWidget *topWidget;
    QFrame *line;

    qDebug() << "Setup start";

    gridLayout = new QGridLayout(this);
    gridLayout->setObjectName(QString::fromUtf8("gridLayout"));
    topWidget = new QWidget(this);
    topWidget->setObjectName(QString::fromUtf8("topWidget"));

    breweryLabel = new QLabel(topWidget);
    breweryLabel->setObjectName(QString::fromUtf8("breweryLabel"));
    breweryLabel->setGeometry(QRect(60, 20, 131, 20));
    breweryLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    breweryLabel->setText(tr("Brewery name:"));
    breweryEdit = new QLineEdit(topWidget);
    breweryEdit->setObjectName(QString::fromUtf8("breweryEdit"));
    breweryEdit->setGeometry(QRect(212, 20, 941, 23));
    breweryEdit->setToolTip(tr("The name for this brewery."));

    line = new QFrame(topWidget);
    line->setObjectName(QString::fromUtf8("line"));
    line->setGeometry(QRect(0, 60, 1251, 20));
    line->setFrameShape(QFrame::HLine);
    line->setFrameShadow(QFrame::Sunken);

    fwhLabel = new QLabel(topWidget);
    fwhLabel->setObjectName(QString::fromUtf8("fwhLabel"));
    fwhLabel->setGeometry(QRect(10, 120, 181, 20));
    fwhLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    fwhLabel->setText(tr("First Wort Hop factor:"));

    mashhopLabel = new QLabel(topWidget);
    mashhopLabel->setObjectName(QString::fromUtf8("mashhopLabel"));
    mashhopLabel->setGeometry(QRect(10, 150, 181, 20));
    mashhopLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    mashhopLabel->setText(tr("Mash Hop factor:"));

    pelletLabel = new QLabel(topWidget);
    pelletLabel->setObjectName(QString::fromUtf8("pelletLabel"));
    pelletLabel->setGeometry(QRect(10, 240, 181, 20));
    pelletLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    pelletLabel->setText(tr("Hop Pellets utilisation:"));

    hopplugLabel = new QLabel(topWidget);
    hopplugLabel->setObjectName(QString::fromUtf8("plugsLabel"));
    hopplugLabel->setGeometry(QRect(10, 270, 181, 20));
    hopplugLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hopplugLabel->setText(tr("Hop Plugs utilisation:"));

    leafLabel = new QLabel(topWidget);
    leafLabel->setObjectName(QString::fromUtf8("leafLabel"));
    leafLabel->setGeometry(QRect(10, 300, 181, 20));
    leafLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    leafLabel->setText(tr("Hop Leafs utilisation:"));

    wethopLabel = new QLabel(topWidget);
    wethopLabel->setObjectName(QString::fromUtf8("wethopLabel"));
    wethopLabel->setGeometry(QRect(10, 330, 181, 20));
    wethopLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    wethopLabel->setText(tr("Wet Hop utilisation:"));

    cryohopLabel = new QLabel(topWidget);
    cryohopLabel->setObjectName(QString::fromUtf8("cryohopLabel"));
    cryohopLabel->setGeometry(QRect(10, 360, 181, 20));
    cryohopLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    cryohopLabel->setText(tr("Cryo Hop\302\256 utilisation:"));

    extractLabel = new QLabel(topWidget);
    extractLabel->setObjectName(QString::fromUtf8("extractLabel"));
    extractLabel->setGeometry(QRect(10, 390, 181, 20));
    extractLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    extractLabel->setText(tr("CO2 Hop Extract utilisation:"));

    hapelletLabel = new QLabel(topWidget);
    hapelletLabel->setObjectName(QString::fromUtf8("hapelletLabel"));
    hapelletLabel->setGeometry(QRect(380, 240, 181, 20));
    hapelletLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hapelletLabel->setText(tr("Hop Pellets water absorption:"));

    hahopplugLabel = new QLabel(topWidget);
    hahopplugLabel->setObjectName(QString::fromUtf8("haplugsLabel"));
    hahopplugLabel->setGeometry(QRect(380, 270, 181, 20));
    hahopplugLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hahopplugLabel->setText(tr("Hop Plugs water absorption:"));

    haleafLabel = new QLabel(topWidget);
    haleafLabel->setObjectName(QString::fromUtf8("haleafLabel"));
    haleafLabel->setGeometry(QRect(380, 300, 181, 20));
    haleafLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    haleafLabel->setText(tr("Hop Leafs water absorption:"));

    hawethopLabel = new QLabel(topWidget);
    hawethopLabel->setObjectName(QString::fromUtf8("hawethopLabel"));
    hawethopLabel->setGeometry(QRect(380, 330, 181, 20));
    hawethopLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hawethopLabel->setText(tr("Wet Hop water absorption:"));

    hacryohopLabel = new QLabel(topWidget);
    hacryohopLabel->setObjectName(QString::fromUtf8("hacryohopLabel"));
    hacryohopLabel->setGeometry(QRect(380, 360, 181, 20));
    hacryohopLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hacryohopLabel->setText(tr("Cryo Hop\302\256 water absorption:"));

    fwhEdit = new QSpinBox(topWidget);
    fwhEdit->setObjectName(QString::fromUtf8("fwhEdit"));
    fwhEdit->setGeometry(QRect(210, 120, 81, 24));
    fwhEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    fwhEdit->setAccelerated(true);
    fwhEdit->setMinimum(-50);
    fwhEdit->setMaximum(50);
    fwhEdit->setToolTip(tr("The efficiency for First Wort Hopping."));
    fwhEdit->setSuffix(tr("%"));

    mashhopEdit = new QSpinBox(topWidget);
    mashhopEdit->setObjectName(QString::fromUtf8("mashhopEdit"));
    mashhopEdit->setGeometry(QRect(210, 150, 81, 24));
    mashhopEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    mashhopEdit->setAccelerated(true);
    mashhopEdit->setMinimum(-95);
    mashhopEdit->setMaximum(50);
    mashhopEdit->setToolTip(tr("The efficiency for Mash hopping."));
    mashhopEdit->setSuffix(tr("%"));

    pelletEdit = new QDoubleSpinBox(topWidget);
    pelletEdit->setObjectName(QString::fromUtf8("pelletEdit"));
    pelletEdit->setGeometry(QRect(210, 240, 81, 24));
    pelletEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    pelletEdit->setAccelerated(true);
    pelletEdit->setMaximum(100);
    pelletEdit->setDecimals(1);
    pelletEdit->setToolTip(tr("The utilisation for hop pellets, default 22"));
    pelletEdit->setSuffix(tr("%"));

    hopplugEdit = new QDoubleSpinBox(topWidget);
    hopplugEdit->setObjectName(QString::fromUtf8("hopplugEdit"));
    hopplugEdit->setGeometry(QRect(210, 270, 81, 24));
    hopplugEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hopplugEdit->setAccelerated(true);
    hopplugEdit->setMaximum(100);
    hopplugEdit->setDecimals(1);
    hopplugEdit->setToolTip(tr("The utilisation for hop plugs, default 20.4"));
    hopplugEdit->setSuffix(tr("%"));

    leafEdit = new QDoubleSpinBox(topWidget);
    leafEdit->setObjectName(QString::fromUtf8("leafEdit"));
    leafEdit->setGeometry(QRect(210, 300, 81, 24));
    leafEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    leafEdit->setAccelerated(true);
    leafEdit->setMaximum(100);
    leafEdit->setDecimals(1);
    leafEdit->setToolTip(tr("The utilisation for hop leafs, default 20"));
    leafEdit->setSuffix(tr("%"));

    wethopEdit = new QDoubleSpinBox(topWidget);
    wethopEdit->setObjectName(QString::fromUtf8("wethopEdit"));
    wethopEdit->setGeometry(QRect(210, 330, 81, 24));
    wethopEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    wethopEdit->setAccelerated(true);
    wethopEdit->setMaximum(100);
    wethopEdit->setDecimals(1);
    wethopEdit->setToolTip(tr("The utilisation for fresh hops, default 3.6"));
    wethopEdit->setSuffix(tr("%"));

    cryohopEdit = new QDoubleSpinBox(topWidget);
    cryohopEdit->setObjectName(QString::fromUtf8("cryohopEdit"));
    cryohopEdit->setGeometry(QRect(210, 360, 81, 24));
    cryohopEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    cryohopEdit->setAccelerated(true);
    cryohopEdit->setMaximum(100);
    cryohopEdit->setDecimals(1);
    cryohopEdit->setToolTip(tr("The utilisation for using Cryo Hop\302\256, default 50"));
    cryohopEdit->setSuffix(tr("%"));

    extractEdit = new QDoubleSpinBox(topWidget);
    extractEdit->setObjectName(QString::fromUtf8("extractEdit"));
    extractEdit->setGeometry(QRect(210, 390, 81, 24));
    extractEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    extractEdit->setAccelerated(true);
    extractEdit->setMaximum(100);
    extractEdit->setDecimals(1);
    extractEdit->setToolTip(tr("The utilisation for using CO2 hop extract, default 35"));
    extractEdit->setSuffix(tr("%"));

    grainLabel = new QLabel(topWidget);
    grainLabel->setObjectName(QString::fromUtf8("grainLabel"));
    grainLabel->setGeometry(QRect(400, 120, 161, 20));
    grainLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    grainLabel->setText(tr("Grain Absorption:"));

    brixLabel = new QLabel(topWidget);
    brixLabel->setObjectName(QString::fromUtf8("brixLabel"));
    brixLabel->setGeometry(QRect(400, 150, 161, 20));
    brixLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    brixLabel->setText(tr("Brix Correction factor:"));

    heightLabel = new QLabel(topWidget);
    heightLabel->setObjectName(QString::fromUtf8("heightLabel"));
    heightLabel->setGeometry(QRect(400, 180, 161, 20));
    heightLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    heightLabel->setText(tr("Brewery height meters:"));

    titleLabel = new QLabel(topWidget);
    titleLabel->setObjectName(QString::fromUtf8("titleLabel"));
    titleLabel->setGeometry(QRect(5, 80, 1251, 20));
    QFont font;
    font.setFamily(QString::fromUtf8("DejaVu Sans"));
    font.setPointSize(12);
    font.setBold(true);
    font.setWeight(75);
    titleLabel->setFont(font);
    titleLabel->setAlignment(Qt::AlignCenter);
    titleLabel->setText(tr("Brew settings."));

    colorLabel = new QLabel(topWidget);
    colorLabel->setObjectName(QString::fromUtf8("colorLabel"));
    colorLabel->setGeometry(QRect(800, 120, 121, 16));
    colorLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    colorLabel->setText(tr("Color Calculation:"));

    ibuLabel = new QLabel(topWidget);
    ibuLabel->setObjectName(QString::fromUtf8("ibuLabel"));
    ibuLabel->setGeometry(QRect(800, 150, 121, 16));
    ibuLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    ibuLabel->setText(tr("IBU Calculation:"));

    waterLabel = new QLabel(topWidget);
    waterLabel->setObjectName(QString::fromUtf8("waterLabel"));
    waterLabel->setGeometry(QRect(800, 180, 121, 16));
    waterLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    waterLabel->setText(tr("Default Water:"));

    yeastLabel = new QLabel(topWidget);
    yeastLabel->setObjectName(QString::fromUtf8("yeastLabel"));
    yeastLabel->setGeometry(QRect(800, 210, 121, 16));
    yeastLabel->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    yeastLabel->setText(tr("Private Yeast bank:"));

    grainEdit = new QDoubleSpinBox(topWidget);
    grainEdit->setObjectName(QString::fromUtf8("grainEdit"));
    grainEdit->setGeometry(QRect(580, 120, 101, 24));
    grainEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    grainEdit->setAccelerated(true);
    grainEdit->setMinimum(0.500000000000000);
    grainEdit->setMaximum(1.100000000000000);
    grainEdit->setSingleStep(0.010000000000000);
    grainEdit->setStepType(QAbstractSpinBox::DefaultStepType);
    grainEdit->setValue(1.000000000000000);
    grainEdit->setToolTip(tr("Absorption with water by the grain (L/Kg)"));
    grainEdit->setSuffix(tr(" L/Kg"));

    brixEdit = new QDoubleSpinBox(topWidget);
    brixEdit->setObjectName(QString::fromUtf8("brixEdit"));
    brixEdit->setGeometry(QRect(580, 150, 101, 24));
    brixEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    brixEdit->setAccelerated(true);
    brixEdit->setMinimum(1.000000000000000);
    brixEdit->setMaximum(1.090000000000000);
    brixEdit->setSingleStep(0.010000000000000);
    brixEdit->setStepType(QAbstractSpinBox::DefaultStepType);
    brixEdit->setValue(1.000000000000000);
    brixEdit->setToolTip(tr("Plato to Brix conversion factor."));

    heightEdit = new QSpinBox(topWidget);
    heightEdit->setObjectName(QString::fromUtf8("heightEdit"));
    heightEdit->setGeometry(QRect(580, 180, 101, 24));
    heightEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    heightEdit->setAccelerated(true);
    heightEdit->setMinimum(-430);
    heightEdit->setMaximum(8849);
    heightEdit->setStepType(QAbstractSpinBox::DefaultStepType);
    heightEdit->setValue(0);
    heightEdit->setToolTip(tr("Height in meters above/below sealevel to calculate the exact boiling point and hop isomerizon."));

    hapelletEdit = new QDoubleSpinBox(topWidget);
    hapelletEdit->setObjectName(QString::fromUtf8("hapelletEdit"));
    hapelletEdit->setGeometry(QRect(580, 240, 101, 24));
    hapelletEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hapelletEdit->setAccelerated(true);
    hapelletEdit->setSingleStep(0.010000000000000);
    hapelletEdit->setMaximum(20);
    hapelletEdit->setDecimals(2);
    hapelletEdit->setToolTip(tr("The water absorption by hop pellets, default 2.67"));
    hapelletEdit->setSuffix(tr(" ml/gr"));

    hahopplugEdit = new QDoubleSpinBox(topWidget);
    hahopplugEdit->setObjectName(QString::fromUtf8("hahopplugEdit"));
    hahopplugEdit->setGeometry(QRect(580, 270, 101, 24));
    hahopplugEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hahopplugEdit->setAccelerated(true);
    hahopplugEdit->setSingleStep(0.010000000000000);
    hahopplugEdit->setMaximum(20);
    hahopplugEdit->setDecimals(2);
    hahopplugEdit->setToolTip(tr("The water absorption by hop plugs, default 2.67"));
    hahopplugEdit->setSuffix(tr(" ml/gr"));

    haleafEdit = new QDoubleSpinBox(topWidget);
    haleafEdit->setObjectName(QString::fromUtf8("haleafEdit"));
    haleafEdit->setGeometry(QRect(580, 300, 101, 24));
    haleafEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    haleafEdit->setAccelerated(true);
    haleafEdit->setSingleStep(0.010000000000000);
    haleafEdit->setMaximum(20);
    haleafEdit->setDecimals(2);
    haleafEdit->setToolTip(tr("The water absorption by hop leafs, default 6.01"));
    haleafEdit->setSuffix(tr(" ml/gr"));

    hawethopEdit = new QDoubleSpinBox(topWidget);
    hawethopEdit->setObjectName(QString::fromUtf8("hawethopEdit"));
    hawethopEdit->setGeometry(QRect(580, 330, 101, 24));
    hawethopEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hawethopEdit->setAccelerated(true);
    hawethopEdit->setSingleStep(0.010000000000000);
    hawethopEdit->setMaximum(20);
    hawethopEdit->setDecimals(2);
    hawethopEdit->setToolTip(tr("The water absorption by fresh hops, default 1.21"));
    hawethopEdit->setSuffix(tr(" ml/gr"));

    hacryohopEdit = new QDoubleSpinBox(topWidget);
    hacryohopEdit->setObjectName(QString::fromUtf8("hacryohopEdit"));
    hacryohopEdit->setGeometry(QRect(580, 360, 101, 24));
    hacryohopEdit->setAlignment(Qt::AlignRight|Qt::AlignTrailing|Qt::AlignVCenter);
    hacryohopEdit->setAccelerated(true);
    hacryohopEdit->setSingleStep(0.010000000000000);
    hacryohopEdit->setMaximum(20);
    hacryohopEdit->setDecimals(2);
    hacryohopEdit->setToolTip(tr("The water absorption by Cryo Hop\302\256, default 2.67"));
    hacryohopEdit->setSuffix(tr(" ml/gr"));

    colorEdit = new QComboBox(topWidget);
    colorEdit->setObjectName(QString::fromUtf8("colorEdit"));
    colorEdit->setGeometry(QRect(940, 120, 161, 23));
    colorEdit->setMinimumContentsLength(4);
    colorEdit->setIconSize(QSize(0, 0));
    colorEdit->setCurrentText(QString());
    colorEdit->setPlaceholderText(tr("Choose color"));

    ibuEdit = new QComboBox(topWidget);
    ibuEdit->setObjectName(QString::fromUtf8("ibuEdit"));
    ibuEdit->setGeometry(QRect(940, 150, 161, 23));
    ibuEdit->setMinimumContentsLength(4);
    ibuEdit->setIconSize(QSize(0, 0));
    ibuEdit->setCurrentText(QString());
    ibuEdit->setPlaceholderText(tr("Choose color"));

    waterEdit = new QComboBox(topWidget);
    waterEdit->setObjectName(QString::fromUtf8("waterEdit"));
    waterEdit->setGeometry(QRect(940, 180, 211, 23));
    waterEdit->setMinimumContentsLength(4);
    waterEdit->setIconSize(QSize(0, 0));
    waterEdit->setCurrentText(QString());
    waterEdit->setPlaceholderText(tr("Choose color"));

    yeastEdit = new QComboBox(topWidget);
    yeastEdit->setObjectName(QString::fromUtf8("yeastEdit"));
    yeastEdit->setGeometry(QRect(940, 210, 211, 23));
    yeastEdit->setMinimumContentsLength(4);
    yeastEdit->setIconSize(QSize(0, 0));
    yeastEdit->setCurrentText(QString());
    yeastEdit->setPlaceholderText(tr("Choose color"));

    logoLabel = new QLabel(topWidget);
    logoLabel->setObjectName(QString::fromUtf8("logoLabel"));
    logoLabel->setGeometry(QRect(940, 260, 211, 211));
    logoLabel->setAlignment(Qt::AlignCenter);
    logoLabel->setText(tr("Logo here"));

    quitButton = new QPushButton(topWidget);
    quitButton->setObjectName(QString::fromUtf8("quitButton"));
    quitButton->setGeometry(QRect(50, 520, 80, 23));
    QIcon icon;
    icon.addFile(QString::fromUtf8(":icons/silk/door_out.png"), QSize(), QIcon::Normal, QIcon::Off);
    quitButton->setIcon(icon);
    quitButton->setText(tr("Quit"));

    saveButton = new QPushButton(topWidget);
    saveButton->setObjectName(QString::fromUtf8("saveButton"));
    saveButton->setGeometry(QRect(200, 520, 80, 23));
    QIcon icon1;
    icon1.addFile(QString::fromUtf8(":icons/silk/disk.png"), QSize(), QIcon::Normal, QIcon::Off);
    saveButton->setIcon(icon1);
    saveButton->setText(tr("Save"));
    saveButton->setEnabled(false);

    openButton = new QPushButton(topWidget);
    openButton->setObjectName(QString::fromUtf8("openButton"));
    openButton->setGeometry(QRect(810, 260, 111, 23));
    QIcon icon2;
    icon2.addFile(QString::fromUtf8(":/icons/silk/folder_picture.png"), QSize(), QIcon::Normal, QIcon::Off);
    openButton->setIcon(icon2);
    openButton->setText(tr("Load logo"));

    gridLayout->addWidget(topWidget, 0, 0, 1, 1);

    connect(quitButton, SIGNAL(clicked()), this, SLOT(on_quitButton_clicked()));
    connect(saveButton, SIGNAL(clicked()), this, SLOT(on_saveButton_clicked()));
    connect(openButton, SIGNAL(clicked()), this, SLOT(on_openButton_clicked()));
    connect(this, SIGNAL(firstWindow()), parent, SLOT(fromSetup()));
    connect(this, SIGNAL(setTitle(QString)), parent, SLOT(windowTitle(QString)));

    emit setTitle(QString(tr("Setup")));

    query.prepare("SELECT * FROM profile_setup WHERE record='1'");
    query.exec();
    query.next();

    breweryEdit->setText(query.value("brewery_name").toString()); // max 128
    connect(breweryEdit, &QLineEdit::textChanged, this, &Setup::is_changed);

    fwhEdit->setValue(query.value("factor_fwh").toInt());
    mashhopEdit->setValue(query.value("factor_mashhop").toInt());
    pelletEdit->setValue(query.value("ut_pellet").toDouble());
    hopplugEdit->setValue(query.value("ut_plug").toDouble());
    leafEdit->setValue(query.value("ut_leaf").toDouble());
    wethopEdit->setValue(query.value("ut_wethop").toDouble());
    cryohopEdit->setValue(query.value("ut_t45").toDouble());
    extractEdit->setValue(query.value("ut_co2extract").toDouble());
    connect(fwhEdit, &QSpinBox::textChanged, this, &Setup::is_changed);
    connect(mashhopEdit, &QSpinBox::textChanged, this, &Setup::is_changed);
    connect(pelletEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(hopplugEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(leafEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(wethopEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(cryohopEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(extractEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);

    grainEdit->setValue(query.value("grain_absorption").toDouble());
    brixEdit->setValue(query.value("brix_correction").toDouble());
    heightEdit->setValue(query.value("brewery_height").toInt());
    hapelletEdit->setValue(query.value("ha_pellet").toDouble());
    hahopplugEdit->setValue(query.value("ha_plug").toDouble());
    haleafEdit->setValue(query.value("ha_leaf").toDouble());
    hawethopEdit->setValue(query.value("ha_wethop").toDouble());
    hacryohopEdit->setValue(query.value("ha_t45").toDouble());
    connect(grainEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(brixEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(heightEdit, &QSpinBox::textChanged, this, &Setup::is_changed);
    connect(hapelletEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(hahopplugEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(haleafEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(hawethopEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);
    connect(hacryohopEdit, &QDoubleSpinBox::textChanged, this, &Setup::is_changed);

    colorEdit->addItem("Morey");
    colorEdit->addItem("Mosher");
    colorEdit->addItem("Daniels");
    colorEdit->addItem("Halberstadt");
    colorEdit->addItem("Naudts");
    colorEdit->setCurrentIndex(query.value("color_method").toInt());
    connect(colorEdit, &QComboBox::currentTextChanged, this, &Setup::is_changed);

    for (int i = 0; i < 3; i++)
	ibuEdit->addItem(g_ibu_method[i]);
    ibuEdit->setCurrentIndex(query.value("ibu_method").toInt());
    connect(ibuEdit, &QComboBox::currentTextChanged, this, &Setup::is_changed);

    QSqlQuery query2("SELECT record,name FROM inventory_waters");
    query2.first();
    int pos = -1;
    waterEdit->setEditable(true);
    waterEdit->setPlaceholderText(tr("Choose default water"));
    for (int i = 0 ; i < query2.size() ; i++ ) {
	waterEdit->addItem(query2.value(1).toString());
	if (query2.value(0).toInt() == query.value("default_water").toInt()) {
	    pos = i;
	}
	query2.next();
    }
    if (pos >= 0)
	waterEdit->setCurrentIndex(pos);
    connect(waterEdit, &QComboBox::currentTextChanged, this, &Setup::is_changed);

    QSqlQuery query3("SELECT DISTINCT laboratory FROM inventory_yeasts ORDER BY laboratory");
    query3.first();
    pos = -1;
    yeastEdit->setEditable(true);
    yeastEdit->setPlaceholderText(tr("Choose laboratory"));
    for (int i = 0 ; i < query3.size() ; i++ ) {
	yeastEdit->addItem(query3.value(0).toString());
	if (QString::compare(query.value("my_yeastlab").toString(), query3.value(0).toString(), Qt::CaseSensitive) == 0)
	    pos = i;
	query3.next();
    }
    if (pos >= 0)
	yeastEdit->setCurrentIndex(pos);
    connect(yeastEdit, &QComboBox::currentTextChanged, this, &Setup::is_changed);

    /* logo */
    logoByteArray = query.value("brewery_logo").toByteArray();
    QPixmap outPixmap = QPixmap();
    outPixmap.loadFromData(logoByteArray);
    logoLabel->setPixmap(outPixmap);
    logoLabel->adjustSize();
}


Setup::~Setup() {}


bool Setup::loadFile(const QString &fileName)
{
    QImageReader reader(fileName);
    reader.setAutoTransform(true);
    const QImage newImage = reader.read();
    if (newImage.isNull()) {
        QMessageBox::information(this, QGuiApplication::applicationDisplayName(), tr("Cannot load %1: %2")
                                 .arg(QDir::toNativeSeparators(fileName), reader.errorString()));
        return false;
    }
    setImage(newImage);
    setWindowFilePath(fileName);
    is_changed();
    return true;
}


void Setup::setImage(const QImage &newImage)
{
    image = newImage;

    qDebug() << "setImage" << image.width() << image.height() << "size" << image.sizeInBytes();

    QBuffer buffer(&logoByteArray);
    buffer.open(QIODevice::WriteOnly);
    image.save(&buffer, "PNG"); // writes image into logoByteArray in PNG format

    this->logoLabel->setPixmap(QPixmap::fromImage(image));
    scaleFactor = 1.0;

//    this->logoLabel->resize(scaleFactor * ui->logoLabel->pixmap(Qt::ReturnByValue).size());
    this->logoLabel->adjustSize();
}


void Setup::on_openButton_clicked()
{
    static bool firstDialog = true;

    qDebug() << "Setup open";

    QFileDialog dialog(this, tr("Open File"));

    if (firstDialog) {
        firstDialog = false;
        const QStringList picturesLocations = QStandardPaths::standardLocations(QStandardPaths::PicturesLocation);
        dialog.setDirectory(picturesLocations.isEmpty() ? QDir::currentPath() : picturesLocations.last());
    }

    /* Only a few image formats are valid */
    QStringList mimeTypeFilters ({ "image/bmp", "image/gif", "image/jpeg", "image/png", "image/svg+xml" });
    dialog.setMimeTypeFilters(mimeTypeFilters);
    dialog.setNameFilter("Images (*.bmp *.BMP *.gif *.GIF *.jpg *.JPG *.png *.PNG *.svg *.SVG)");
    dialog.setAcceptMode(QFileDialog::AcceptOpen);

    while (dialog.exec() == QDialog::Accepted && !loadFile(dialog.selectedFiles().constFirst())) {}
}


/*
 * Also called from the Quit button if there are changes to save.
 */
void Setup::on_saveButton_clicked()
{
    QSqlQuery query;

    /*
     * Search record number of the current water.
     */
    query.prepare("SELECT record FROM inventory_waters WHERE name=:name");
    query.bindValue(":name", this->waterEdit->currentText());
    query.exec();
    query.first();
    int record = query.value(0).toInt();

    /*
     * Update all other data
     */
    query.prepare("UPDATE profile_setup SET brewery_name=:brewery, brewery_logo=:logo, factor_mashhop=:mashhop, factor_fwh=:fwh, "
		  "ut_pellet=:pellet, ut_plug=:plug, ut_leaf=:leaf, ut_wethop=:wet, ut_t45=:cryo, ut_co2extract=:extract, "
		  "color_method=:color, ibu_method=:ibu, "
		  "brix_correction=:brix, grain_absorption=:grain, default_water=:water, my_yeastlab=:yeast, "
		  "brewery_height=:height, "
		  "ha_pellet=:hapellet, ha_plug=:haplug, ha_leaf=:haleaf, ha_wethop=:hawet, ha_t45=:hacryo "
		  "WHERE record='1'");
    query.bindValue(":brewery", this->breweryEdit->text());
    query.bindValue(":logo", logoByteArray);
    query.bindValue(":mashhop", this->mashhopEdit->value());
    query.bindValue(":fwh", this->fwhEdit->value());
    query.bindValue(":pellet", this->pelletEdit->value());
    query.bindValue(":plug", this->hopplugEdit->value());
    query.bindValue(":leaf", this->leafEdit->value());
    query.bindValue(":wet", this->wethopEdit->value());
    query.bindValue(":cryo", this->cryohopEdit->value());
    query.bindValue(":extract", this->extractEdit->value());
    query.bindValue(":color", this->colorEdit->currentIndex());
    query.bindValue(":ibu", this->ibuEdit->currentIndex());
    query.bindValue(":brix", this->brixEdit->value());
    query.bindValue(":grain", this->grainEdit->value());
    query.bindValue(":water", record);
    query.bindValue(":yeast", this->yeastEdit->currentText());
    query.bindValue(":height", this->heightEdit->value());
    query.bindValue(":hapellet", this->hapelletEdit->value());
    query.bindValue(":haplug", this->hahopplugEdit->value());
    query.bindValue(":haleaf", this->haleafEdit->value());
    query.bindValue(":hawet", this->hawethopEdit->value());
    query.bindValue(":hacryo", this->hacryohopEdit->value());
    query.exec();
    if (query.lastError().isValid()) {
	qDebug() << "Setup Save error:" << query.lastError();
	QMessageBox::warning(this, tr("Database error"),
			tr("MySQL error: %1\n%2\n%3")
			.arg(query.lastError().nativeErrorCode())
			.arg(query.lastError().driverText())
			.arg(query.lastError().databaseText()));
    } else {
	qDebug() << "Setup Saved";
    }

    this->fieldIsChanged = false;
    saveButton->setEnabled(false);
    emit setTitle(QString(tr("Setup")));
}


void Setup::on_quitButton_clicked()
{
    if (this->fieldIsChanged) {
	int rc = QMessageBox::warning(this, tr("Setup changed"), tr("The global setup has been modified. Save changes?"),
				QMessageBox::Save | QMessageBox::Discard | QMessageBox::Cancel, QMessageBox::Save);
	switch (rc) {
	    case QMessageBox::Save:
			on_saveButton_clicked();
			break;	/* Saved and then Quit */
	    case QMessageBox::Discard:
			break;	/* Quit without Save */
	    case QMessageBox::Cancel:
			return;	/* Return to the setup page */
	}
    }
    emit firstWindow();
}


void Setup::is_changed()
{
    saveButton->setEnabled(true);
    this->fieldIsChanged = true;
    emit setTitle(QString(tr("Setup") + " **"));
}