Wed, 25 Jan 2023 16:12:16 +0100
Fixed replace a yeast field offsets.
/** * EditProfileStyle.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 "EditProfileStyle.h" #include "../ui/ui_EditProfileStyle.h" #include "MainWindow.h" EditProfileStyle::EditProfileStyle(int id, QWidget *parent) : QDialog(parent), ui(new Ui::EditProfileStyle) { QSqlQuery query; qDebug() << "EditProfileStyle record:" << id; ui->setupUi(this); this->recno = id; WindowTitle(); ui->typeEdit->addItem(tr("Lager")); ui->typeEdit->addItem(tr("Ale")); ui->typeEdit->addItem(tr("Mead")); ui->typeEdit->addItem(tr("Wheat")); ui->typeEdit->addItem(tr("Mixed")); ui->typeEdit->addItem(tr("Cider")); if (id >= 0) { query.prepare("SELECT * FROM profile_styles WHERE record = :recno"); query.bindValue(":recno", id); query.exec(); query.next(); ui->styleEdit->setText(query.value(1).toString()); ui->catEdit->setText(query.value(2).toString()); ui->catnrEdit->setValue(query.value(3).toInt()); ui->groupEdit->setText(query.value(4).toString()); ui->guideEdit->setText(query.value(5).toString()); ui->typeEdit->setCurrentIndex(query.value(6).toInt()); ui->ogminEdit->setValue(query.value(7).toDouble()); ui->ogmaxEdit->setValue(query.value(8).toDouble()); ui->fgminEdit->setValue(query.value(9).toDouble()); ui->fgmaxEdit->setValue(query.value(10).toDouble()); ui->ibuminEdit->setValue(query.value(11).toDouble()); ui->ibumaxEdit->setValue(query.value(12).toDouble()); ui->ebcminEdit->setValue(query.value(13).toDouble()); ui->ebcmaxEdit->setValue(query.value(14).toDouble()); ui->co2minEdit->setValue(query.value(15).toDouble()); ui->co2maxEdit->setValue(query.value(16).toDouble()); ui->abvminEdit->setValue(query.value(17).toDouble()); ui->abvmaxEdit->setValue(query.value(18).toDouble()); ui->notesEdit->setPlainText(query.value(19).toString()); ui->profileEdit->setPlainText(query.value(20).toString()); ui->ingredientsEdit->setPlainText(query.value(21).toString()); ui->examplesEdit->setPlainText(query.value(22).toString()); } else { /* Set some defaults */ ui->catnrEdit->setValue(0); ui->guideEdit->setText("BKG 2019"); ui->typeEdit->setCurrentIndex(0); ui->ogminEdit->setValue(1.030); ui->ogmaxEdit->setValue(1.060); ui->fgminEdit->setValue(1.005); ui->fgmaxEdit->setValue(1.010); ui->ibuminEdit->setValue(20); ui->ibumaxEdit->setValue(30); ui->ebcminEdit->setValue(52); ui->ebcmaxEdit->setValue(79); ui->co2minEdit->setValue(2.0); ui->co2maxEdit->setValue(2.5); ui->abvminEdit->setValue(4.0); ui->abvmaxEdit->setValue(5.0); } connect(ui->styleEdit, &QLineEdit::textChanged, this, &EditProfileStyle::is_changed); connect(ui->catEdit, &QLineEdit::textChanged, this, &EditProfileStyle::is_changed); connect(ui->catnrEdit, &QSpinBox::textChanged, this, &EditProfileStyle::is_changed); connect(ui->groupEdit, &QLineEdit::textChanged, this, &EditProfileStyle::is_changed); connect(ui->guideEdit, &QLineEdit::textChanged, this, &EditProfileStyle::is_changed); connect(ui->typeEdit, &QComboBox::currentTextChanged, this, &EditProfileStyle::is_changed); connect(ui->ogminEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::ogmin_changed); connect(ui->ogmaxEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::ogmax_changed); connect(ui->fgminEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::fgmin_changed); connect(ui->fgmaxEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::fgmax_changed); connect(ui->ibuminEdit, &QSpinBox::textChanged, this, &EditProfileStyle::ibumin_changed); connect(ui->ibumaxEdit, &QSpinBox::textChanged, this, &EditProfileStyle::ibumax_changed); connect(ui->ebcminEdit, &QSpinBox::textChanged, this, &EditProfileStyle::ebcmin_changed); connect(ui->ebcmaxEdit, &QSpinBox::textChanged, this, &EditProfileStyle::ebcmax_changed); connect(ui->co2minEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::co2min_changed); connect(ui->co2maxEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::co2max_changed); connect(ui->abvminEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::abvmin_changed); connect(ui->abvmaxEdit, &QDoubleSpinBox::textChanged, this, &EditProfileStyle::abvmax_changed); connect(ui->notesEdit, SIGNAL(textChanged()), this, SLOT(is_changed())); connect(ui->profileEdit, SIGNAL(textChanged()), this, SLOT(is_changed())); connect(ui->ingredientsEdit, SIGNAL(textChanged()), this, SLOT(is_changed())); connect(ui->examplesEdit, SIGNAL(textChanged()), this, SLOT(is_changed())); ui->saveButton->setEnabled(false); ui->deleteButton->setEnabled((id >= 0) ? true:false); } EditProfileStyle::~EditProfileStyle() { qDebug() << "EditProfileStyle done"; delete ui; emit entry_changed(); } /* * Window header, mark any change with '**' */ void EditProfileStyle::WindowTitle() { QString txt; if (this->recno < 0) { txt = QString(tr("BMSapp - Add new beer style")); } else { txt = QString(tr("BMSapp - Edit beer style %1").arg(this->recno)); } if (this->textIsChanged) { txt.append((QString(" **"))); } setWindowTitle(txt); } void EditProfileStyle::on_saveButton_clicked() { QSqlQuery query; /* If there are errors in the form, show a message and do "return;" */ if (ui->styleEdit->text().length() < 2) { QMessageBox::warning(this, tr("Edit Style"), tr("Beer style is empty or too short.")); return; } if (this->textIsChanged) { if (this->recno == -1) { query.prepare("INSERT INTO profile_styles SET name=:name, category=:category, " "category_number=:catnr, style_letter=:group, style_guide=:guide, type=:type, " "og_min=:og_min, og_max=:og_max, fg_min=:fg_min, fg_max=:fg_max, ibu_min=:ibu_min, " "ibu_max=:ibu_max, color_min=:ebc_min, color_max=:ebc_max, carb_min=:co2_min, " "carb_max=:co2_max, abv_min=:abv_min, abv_max=:abv_max, notes=:notes, " "profile=:profile, ingredients=:ingredients, examples=:examples, uuid=:uuid"); } else { query.prepare("UPDATE profile_styles SET name=:name, category=:category, " "category_number=:catnr, style_letter=:group, style_guide=:guide, type=:type, " "og_min=:og_min, og_max=:og_max, fg_min=:fg_min, fg_max=:fg_max, ibu_min=:ibu_min, " "ibu_max=:ibu_max, color_min=:ebc_min, color_max=:ebc_max, carb_min=:co2_min, " "carb_max=:co2_max, abv_min=:abv_min, abv_max=:abv_max, notes=:notes, " "profile=:profile, ingredients=:ingredients, examples=:examples WHERE record=:recno"); } query.bindValue(":name", ui->styleEdit->text()); query.bindValue(":category", ui->catEdit->text()); query.bindValue(":catnr", QString("%1").arg(ui->catnrEdit->value())); query.bindValue(":group", ui->groupEdit->text()); query.bindValue(":guide", ui->guideEdit->text()); query.bindValue(":type", ui->typeEdit->currentIndex()); query.bindValue(":og_min", QString("%1").arg(ui->ogminEdit->value(), 4, 'f', 3, '0')); query.bindValue(":og_max", QString("%1").arg(ui->ogmaxEdit->value(), 4, 'f', 3, '0')); query.bindValue(":fg_min", QString("%1").arg(ui->fgminEdit->value(), 4, 'f', 3, '0')); query.bindValue(":fg_max", QString("%1").arg(ui->fgmaxEdit->value(), 4, 'f', 3, '0')); query.bindValue(":ibu_min", QString("%1").arg(ui->ibuminEdit->value(), 1, 'f', 0, '0')); query.bindValue(":ibu_max", QString("%1").arg(ui->ibumaxEdit->value(), 1, 'f', 0, '0')); query.bindValue(":ebc_min", QString("%1").arg(ui->ebcminEdit->value(), 1, 'f', 0, '0')); query.bindValue(":ebc_max", QString("%1").arg(ui->ebcmaxEdit->value(), 1, 'f', 0, '0')); query.bindValue(":co2_min", QString("%1").arg(ui->co2minEdit->value(), 2, 'f', 1, '0')); query.bindValue(":co2_max", QString("%1").arg(ui->co2maxEdit->value(), 2, 'f', 1, '0')); query.bindValue(":abv_min", QString("%1").arg(ui->abvminEdit->value(), 2, 'f', 1, '0')); query.bindValue(":abv_max", QString("%1").arg(ui->abvmaxEdit->value(), 2, 'f', 1, '0')); query.bindValue(":notes", ui->notesEdit->toPlainText()); query.bindValue(":profile", ui->profileEdit->toPlainText()); query.bindValue(":ingredients", ui->ingredientsEdit->toPlainText()); query.bindValue(":examples", ui->examplesEdit->toPlainText()); if (this->recno == -1) { query.bindValue(":uuid", QUuid::createUuid().toString().mid(1, 36)); } else { query.bindValue(":recno", this->recno); } query.exec(); if (query.lastError().isValid()) { qDebug() << "EditProfileStyle" << 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() << "EditProfileStyle Saved"; } } ui->saveButton->setEnabled(false); this->textIsChanged = false; WindowTitle(); } void EditProfileStyle::on_deleteButton_clicked() { QSqlQuery query; query.prepare("DELETE FROM profile_styles WHERE record = :recno"); query.bindValue(":recno", this->recno); query.exec(); if (query.lastError().isValid()) { qDebug() << "EditProfileStyle" << 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() << "EditProfileStyle Deleted" << this->recno; } this->close(); this->setResult(1); } void EditProfileStyle::is_changed() { ui->saveButton->setEnabled(true); ui->deleteButton->setEnabled((this->recno >= 0) ? true:false); this->textIsChanged = true; WindowTitle(); } void EditProfileStyle::ogmin_changed() { if (ui->ogminEdit->value() > (ui->ogmaxEdit->value() - 0.001)) ui->ogmaxEdit->setValue(ui->ogminEdit->value() + 0.001); is_changed(); } void EditProfileStyle::ogmax_changed() { if (ui->ogmaxEdit->value() < (ui->ogminEdit->value() + 0.001)) ui->ogminEdit->setValue(ui->ogmaxEdit->value() - 0.001); is_changed(); } void EditProfileStyle::fgmin_changed() { if (ui->fgminEdit->value() > (ui->fgmaxEdit->value() - 0.001)) ui->fgmaxEdit->setValue(ui->fgminEdit->value() + 0.001); is_changed(); } void EditProfileStyle::fgmax_changed() { if (ui->fgmaxEdit->value() < (ui->fgminEdit->value() + 0.001)) ui->fgminEdit->setValue(ui->fgmaxEdit->value() - 0.001); is_changed(); } void EditProfileStyle::ibumin_changed() { if (ui->ibuminEdit->value() > (ui->ibumaxEdit->value() - 1)) ui->ibumaxEdit->setValue(ui->ibuminEdit->value() + 1); is_changed(); } void EditProfileStyle::ibumax_changed() { if (ui->ibumaxEdit->value() < (ui->ibuminEdit->value() + 1)) ui->ibuminEdit->setValue(ui->ibumaxEdit->value() - 1); is_changed(); } void EditProfileStyle::ebcmin_changed() { if (ui->ebcminEdit->value() > (ui->ebcmaxEdit->value() - 1)) ui->ebcmaxEdit->setValue(ui->ebcminEdit->value() + 1); is_changed(); } void EditProfileStyle::ebcmax_changed() { if (ui->ebcmaxEdit->value() < (ui->ebcminEdit->value() + 1)) ui->ebcminEdit->setValue(ui->ebcmaxEdit->value() - 1); is_changed(); } void EditProfileStyle::co2min_changed() { if (ui->co2minEdit->value() > (ui->co2maxEdit->value() - 0.1)) ui->co2maxEdit->setValue(ui->co2minEdit->value() + 0.1); is_changed(); } void EditProfileStyle::co2max_changed() { if (ui->co2maxEdit->value() < (ui->co2minEdit->value() + 0.1)) ui->co2minEdit->setValue(ui->co2maxEdit->value() - 0.1); is_changed(); } void EditProfileStyle::abvmin_changed() { if (ui->abvminEdit->value() > (ui->abvmaxEdit->value() - 0.1)) ui->abvmaxEdit->setValue(ui->abvminEdit->value() + 0.1); is_changed(); } void EditProfileStyle::abvmax_changed() { if (ui->abvmaxEdit->value() < (ui->abvminEdit->value() + 0.1)) ui->abvminEdit->setValue(ui->abvmaxEdit->value() - 0.1); is_changed(); } void EditProfileStyle::on_quitButton_clicked() { if (this->textIsChanged) { int rc = QMessageBox::warning(this, tr("Style changed"), tr("This beerstyle 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 editor page */ } } this->close(); this->setResult(1); }