Mon, 11 Apr 2022 20:45:22 +0200
Blocked hop table edit. Implemented add and delete hop rows. Started the ui of the water tab.
/** * EditHop.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 "EditHop.h" #include "../ui/ui_EditHop.h" #include "MainWindow.h" EditHop::EditHop(int id, QWidget *parent) : QDialog(parent), ui(new Ui::EditHop) { QSqlQuery query; qDebug() << "EditHop record:" << id; ui->setupUi(this); this->recno = id; WindowTitle(); ui->typeEdit->addItem(tr("Bittering")); ui->typeEdit->addItem(tr("Aroma")); ui->typeEdit->addItem(tr("Both")); ui->formEdit->addItem(tr("Pellet")); ui->formEdit->addItem(tr("Plug")); ui->formEdit->addItem(tr("Leaf")); ui->formEdit->addItem(tr("Leaf Wet")); /* Not in beerxml */ ui->formEdit->addItem(tr("Cryo")); /* Not in beerxml */ if (id >= 0) { query.prepare("SELECT * FROM inventory_hops WHERE record = :recno"); query.bindValue(":recno", id); query.exec(); query.next(); ui->nameEdit->setText(query.value(1).toString()); ui->alphaEdit->setValue(query.value(2).toDouble()); ui->betaEdit->setValue(query.value(3).toDouble()); ui->humuleneEdit->setValue(query.value(4).toDouble()); ui->caryEdit->setValue(query.value(5).toDouble()); ui->cohumuloneEdit->setValue(query.value(6).toDouble()); ui->myrceneEdit->setValue(query.value(7).toDouble()); ui->hsiEdit->setValue(query.value(8).toDouble()); ui->typeEdit->setCurrentIndex(query.value(9).toInt()); ui->formEdit->setCurrentIndex(query.value(10).toInt()); ui->notesEdit->setPlainText(query.value(11).toString()); ui->originEdit->setText(query.value(12).toString()); ui->substitutesEdit->setText(query.value(13).toString()); ui->alwaysEdit->setChecked(query.value(14).toInt() ? true:false); ui->inventoryEdit->setValue(query.value(15).toDouble()); ui->costEdit->setValue(query.value(16).toDouble()); ui->valueEdit->setValue(query.value(15).toDouble() * query.value(16).toDouble()); if (query.value(17).toString().length() == 10) { ui->prodEdit->setDate(query.value(17).toDate()); } else { ui->prodEdit->clear(); } if (query.value(18).toString().length() == 10) { ui->thtEdit->setDate(query.value(18).toDate()); } else { ui->thtEdit->clear(); } ui->oilEdit->setValue(query.value(19).toDouble()); } else { /* Set some defaults */ ui->typeEdit->setCurrentIndex(0); ui->formEdit->setCurrentIndex(0); ui->prodEdit->clear(); ui->thtEdit->clear(); } connect(ui->nameEdit, &QLineEdit::textChanged, this, &EditHop::is_changed); connect(ui->alphaEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->betaEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->humuleneEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->caryEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->cohumuloneEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->myrceneEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->hsiEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->typeEdit, &QComboBox::currentTextChanged, this, &EditHop::is_changed); connect(ui->formEdit, &QComboBox::currentTextChanged, this, &EditHop::is_changed); connect(ui->notesEdit, SIGNAL(textChanged()), this, SLOT(is_changed())); connect(ui->originEdit, &QLineEdit::textChanged, this, &EditHop::is_changed); connect(ui->substitutesEdit, &QLineEdit::textChanged, this, &EditHop::is_changed); connect(ui->alwaysEdit, &QCheckBox::stateChanged, this, &EditHop::is_changed); connect(ui->inventoryEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->costEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); connect(ui->prodEdit, &QDateEdit::dateChanged, this, &EditHop::is_changed); connect(ui->thtEdit, &QDateEdit::dateChanged, this, &EditHop::is_changed); connect(ui->oilEdit, &QDoubleSpinBox::textChanged, this, &EditHop::is_changed); ui->saveButton->setEnabled(false); ui->deleteButton->setEnabled((ui->inventoryEdit->value() == 0 && id >= 0) ? true:false); } EditHop::~EditHop() { qDebug() << "EditHop done"; delete ui; emit entry_changed(); } /* * Window header, mark any change with '**' */ void EditHop::WindowTitle() { QString txt; if (this->recno < 0) { txt = QString(tr("BMSapp - Add new hop")); } else { txt = QString(tr("BMSapp - Edit hop %1").arg(this->recno)); } if (this->textIsChanged) { txt.append((QString(" **"))); } setWindowTitle(txt); } void EditHop::on_saveButton_clicked() { QSqlQuery query; /* If there are errors in the form, show a message and do "return;" */ if (ui->nameEdit->text().length() < 2) { QMessageBox::warning(this, tr("Edit Hop"), tr("Name empty or too short.")); return; } if (ui->originEdit->text().length() < 2) { QMessageBox::warning(this, tr("Edit Hop"), tr("Origin empty or too short.")); return; } if (this->textIsChanged) { if (this->recno == -1) { query.prepare("INSERT INTO inventory_hops SET name=:name, alpha=:alpha, beta=:beta, " "humulene=:humulene, caryophyllene=:cary, cohumulone=:cohumulone, myrcene=:myrcene, " "hsi=:hsi, type=:type, form=:form, notes=:notes, origin=:origin, substitutes=:substitutes, " "always_on_stock=:always, inventory=:inventory, cost=:cost, production_date=:prod, " "tht_date=:tht, total_oil=:oil, uuid = :uuid"); } else { query.prepare("UPDATE inventory_hops SET name=:name, alpha=:alpha, beta=:beta, " "humulene=:humulene, caryophyllene=:cary, cohumulone=:cohumulone, myrcene=:myrcene, " "hsi=:hsi, type=:type, form=:form, notes=:notes, origin=:origin, substitutes=:substitutes, " "always_on_stock=:always, inventory=:inventory, cost=:cost, production_date=:prod, " "tht_date=:tht, total_oil=:oil WHERE record = :recno"); } query.bindValue(":name", ui->nameEdit->text()); query.bindValue(":alpha", QString("%1").arg(ui->alphaEdit->value(), 2, 'f', 1, '0')); query.bindValue(":beta", QString("%1").arg(ui->betaEdit->value(), 2, 'f', 1, '0')); query.bindValue(":humulene", QString("%1").arg(ui->humuleneEdit->value(), 2, 'f', 1, '0')); query.bindValue(":cary", QString("%1").arg(ui->caryEdit->value(), 2, 'f', 1, '0')); query.bindValue(":cohumulone", QString("%1").arg(ui->cohumuloneEdit->value(), 2, 'f', 1, '0')); query.bindValue(":myrcene", QString("%1").arg(ui->myrceneEdit->value(), 2, 'f', 1, '0')); query.bindValue(":hsi", QString("%1").arg(ui->hsiEdit->value(), 2, 'f', 1, '0')); query.bindValue(":type", ui->typeEdit->currentIndex()); query.bindValue(":form", ui->formEdit->currentIndex()); query.bindValue(":notes", ui->notesEdit->toPlainText()); query.bindValue(":origin", ui->originEdit->text()); query.bindValue(":substitutes", ui->substitutesEdit->text()); query.bindValue(":always", ui->alwaysEdit->isChecked() ? 1:0); query.bindValue(":inventory", QString("%1").arg(ui->inventoryEdit->value(), 5, 'f', 4, '0')); query.bindValue(":cost", QString("%1").arg(ui->costEdit->value(), 3, 'f', 2, '0')); /* Uses https://www.qtcentre.org/threads/17295-How-to-put-empty-value-in-QDateEdit */ query.bindValue(":prod", ui->prodEdit->nullDate()); query.bindValue(":tht", ui->thtEdit->nullDate()); query.bindValue(":oil", QString("%1").arg(ui->oilEdit->value(), 2, 'f', 1, '0')); 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() << "EditHop" << 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() << "EditHop Saved"; } } ui->saveButton->setEnabled(false); this->textIsChanged = false; WindowTitle(); } void EditHop::on_deleteButton_clicked() { QSqlQuery query; query.prepare("DELETE FROM inventory_hops WHERE record = :recno"); query.bindValue(":recno", this->recno); query.exec(); if (query.lastError().isValid()) { qDebug() << "EditHop" << 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() << "EditHop Deleted" << this->recno; } this->close(); this->setResult(1); } void EditHop::is_changed() { ui->valueEdit->setValue(ui->inventoryEdit->value() * ui->costEdit->value()); ui->saveButton->setEnabled(true); ui->deleteButton->setEnabled((ui->inventoryEdit->value() == 0 && this->recno >= 0) ? true:false); this->textIsChanged = true; WindowTitle(); } void EditHop::on_quitButton_clicked() { if (this->textIsChanged) { int rc = QMessageBox::warning(this, tr("Hop changed"), tr("This hop 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); }