diff -r d68826df8b63 -r 09af9f46518f src/EditFermentable.cpp --- a/src/EditFermentable.cpp Sun Jul 31 20:23:27 2022 +0200 +++ b/src/EditFermentable.cpp Mon Aug 01 13:05:23 2022 +0200 @@ -56,11 +56,6 @@ query.bindValue(":recno", id); query.exec(); query.next(); - - QSqlRecord rec = query.record(); - for (int i = 0; i < rec.count(); i++) - qDebug() << i << rec.fieldName(i) << query.value(i); - ui->nameEdit->setText(query.value("name").toString()); ui->notesEdit->setPlainText(query.value("notes").toString()); ui->originEdit->setText(query.value("origin").toString()); @@ -146,7 +141,6 @@ EditFermentable::~EditFermentable() { - qDebug() << "EditFermentable done"; delete ui; emit entry_changed(); } @@ -238,7 +232,7 @@ } query.exec(); if (query.lastError().isValid()) { - qDebug() << "EditFermentable" << query.lastError(); + qWarning() << "EditFermentable" << query.lastError(); QMessageBox::warning(this, tr("Database error"), tr("MySQL error: %1\n%2\n%3") .arg(query.lastError().nativeErrorCode()) @@ -255,15 +249,69 @@ } +void EditFermentable::on_cloneButton_clicked() +{ + QSqlQuery query; + + query.prepare("INSERT INTO inventory_fermentables SET name=:name, type=:type, yield=:yield, color=:color, " + "add_after_boil=:addafter, origin=:origin, supplier=:supplier, notes=:notes, coarse_fine_diff=:coarse, " + "moisture=:moisture, diastatic_power=:diastatic, protein=:protein, dissolved_protein=:dissolved, " + "max_in_batch=:maxinbatch, recommend_mash=:mash, added=:added, always_on_stock=:always, di_ph=:diph, " + "acid_to_ph_57=:acidph, graintype=:graintype, inventory=:inventory, cost=:cost, production_date=:prod, " + "tht_date=:tht, uuid = :uuid"); + query.bindValue(":name", ui->nameEdit->text() + " [copy]"); + query.bindValue(":type", ui->typeEdit->currentIndex()); + query.bindValue(":yield", QString("%1").arg(ui->yieldEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":color", QString("%1").arg(ui->colorEdit->value(), 1, 'f', 0, '0')); + query.bindValue(":addafter", ui->addafterEdit->isChecked() ? 1:0); + query.bindValue(":origin", ui->originEdit->text()); + query.bindValue(":supplier", ui->supplierEdit->text()); + query.bindValue(":notes", ui->notesEdit->toPlainText()); + query.bindValue(":coarse", QString("%1").arg(ui->coarseEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":moisture", QString("%1").arg(ui->moistureEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":diastatic", Utils::kolbach_to_lintner(ui->wkEdit->value())); + query.bindValue(":protein", QString("%1").arg(ui->proteinEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":dissolved", QString("%1").arg(ui->dissolvedEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":maxinbatch", QString("%1").arg(ui->maxinbatchEdit->value(), 2, 'f', 1, '0')); + query.bindValue(":mash", ui->mashEdit->isChecked() ? 1:0); + query.bindValue(":added", ui->addedEdit->currentIndex()); + query.bindValue(":always", ui->alwaysEdit->isChecked() ? 1:0); + query.bindValue(":diph", QString("%1").arg(ui->diphEdit->value(), 3, 'f', 2, '0')); + query.bindValue(":acidph", QString("%1").arg(ui->acidphEdit->value(), 6, 'f', 5, '0')); + query.bindValue(":graintype", ui->graintypeEdit->currentIndex()); + query.bindValue(":inventory", QString("%1").arg(0, 4, 'f', 3, '0')); + query.bindValue(":cost", QString("%1").arg(ui->costEdit->value(), 3, 'f', 2, '0')); + query.bindValue(":prod", QDate()); + query.bindValue(":tht", QDate()); + query.bindValue(":uuid", QUuid::createUuid().toString().mid(1, 36)); + query.exec(); + if (query.lastError().isValid()) { + qWarning() << "EditFermentable" << 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() << "EditFermentable Saved"; + } +} + + void EditFermentable::on_deleteButton_clicked() { QSqlQuery query; + int rc = QMessageBox::warning(this, tr("Delete fermentable"), tr("Delete %1").arg(ui->nameEdit->text()), + QMessageBox::Yes | QMessageBox::No, QMessageBox::No); + if (rc == QMessageBox::No) + return; + query.prepare("DELETE FROM inventory_fermentables WHERE record = :recno"); query.bindValue(":recno", this->recno); query.exec(); if (query.lastError().isValid()) { - qDebug() << "EditFermentable" << query.lastError(); + qWarning() << "EditFermentable" << query.lastError(); QMessageBox::warning(this, tr("Database error"), tr("MySQL error: %1\n%2\n%3") .arg(query.lastError().nativeErrorCode())