--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/src/EditProfileFerment.cpp Wed Mar 16 21:26:31 2022 +0100
@@ -0,0 +1,449 @@
+/**
+ * EditProfileFerment.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 "EditProfileFerment.h"
+#include "../ui/ui_EditProfileFerment.h"
+#include "bmsapp.h"
+
+
+EditProfileFerment::EditProfileFerment(int id, QWidget *parent) : QDialog(parent), ui(new Ui::EditProfileFerment)
+{
+ QSqlQuery query;
+
+ qDebug() << "EditProfileFerment record:" << id;
+ ui->setupUi(this);
+ this->recno = id;
+
+ ui->sensorEdit->addItem(tr("Beer"));
+ ui->sensorEdit->addItem(tr("Fridge"));
+
+ if (id >= 0) {
+ query.prepare("SELECT * FROM profile_fermentation WHERE record = :recno");
+ query.bindValue(":recno", id);
+ query.exec();
+ query.next();
+
+ ui->nameEdit->setText(query.value(2).toString());
+ ui->temploEdit->setValue(query.value(3).toDouble());
+ ui->temphiEdit->setValue(query.value(4).toDouble());
+ ui->sensorEdit->setCurrentIndex(query.value(5).toInt());
+
+ QJsonParseError parseError;
+ const auto& json = query.value(8).toString();
+
+ if (!json.trimmed().isEmpty()) {
+ const auto& formattedJson = QString("%1").arg(json);
+ this->steps = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError);
+
+ if (parseError.error != QJsonParseError::NoError)
+ qDebug() << "Parse error: " << parseError.errorString() << "at" << parseError.offset ;
+ }
+
+ } else {
+ /* Set some defaults */
+ const auto& formattedJson = QString("[]");
+ this->steps = QJsonDocument::fromJson(formattedJson.toUtf8());
+ }
+
+ connect(ui->nameEdit, &QLineEdit::textChanged, this, &EditProfileFerment::is_changed);
+ connect(ui->temploEdit, &QDoubleSpinBox::textChanged, this, &EditProfileFerment::templo_changed);
+ connect(ui->temphiEdit, &QDoubleSpinBox::textChanged, this, &EditProfileFerment::temphi_changed);
+ connect(ui->sensorEdit, &QComboBox::currentTextChanged, this, &EditProfileFerment::is_changed);
+ connect(ui->stepsTable, SIGNAL(cellChanged(int, int)), this, SLOT(cell_Changed(int, int)));
+
+ ui->saveButton->setEnabled(false);
+ ui->deleteButton->setEnabled((id >= 0) ? true:false);
+
+ emit refreshTable();
+
+ WindowTitle();
+}
+
+
+void EditProfileFerment::refreshTable()
+{
+ QString w;
+ QWidget* pWidget;
+ QHBoxLayout* pLayout;
+ double d;
+
+// qDebug() << "refreshTable" << this->steps << this->steps.isArray() << this->steps.array().size() ;
+ /*
+ * During filling the table turn off the cellChanged signal because every cell that is filled
+ * triggers the cellChanged signal. The QTableWidget has no better signal to use.
+ */
+ this->ignoreChanges = true;
+
+ const QStringList labels({tr("Step name"), tr("Start °C"), tr("End °C"), tr("Sensor"), tr("Ramp time"), tr("Rest time"), tr("Button")});
+ ui->stepsTable->setColumnCount(7);
+ ui->stepsTable->setColumnWidth(0, 248); /* Step name */
+ ui->stepsTable->setColumnWidth(1, 75); /* Start temp */
+ ui->stepsTable->setColumnWidth(2, 75); /* End temp */
+ ui->stepsTable->setColumnWidth(3, 120); /* Sensor */
+ ui->stepsTable->setColumnWidth(4, 85); /* Ramp time */
+ ui->stepsTable->setColumnWidth(5, 85); /* Rest time */
+ ui->stepsTable->setColumnWidth(6, 80); /* Button */
+ ui->stepsTable->setHorizontalHeaderLabels(labels);
+ ui->stepsTable->verticalHeader()->hide();
+ ui->stepsTable->setRowCount(this->steps.array().size());
+
+ totalsteps = 0;
+ duration = 0;
+
+ if (this->steps.isArray()) {
+ totalsteps = this->steps.array().size();
+ for (int i = 0; i < this->steps.array().size(); i++) {
+ QJsonObject obj = this->steps.array().at(i).toObject();
+
+ ui->stepsTable->setItem(i, 0, new QTableWidgetItem(obj["name"].toString()));
+
+ /* Numbers can be double quoted or not, the old application could do this wrong. */
+ if (obj["target_lo"].isString())
+ d = QString(obj["target_lo"].toString()).toDouble();
+ else
+ d = obj["target_lo"].toDouble();
+ w = QString("%1").arg(d, 2, 'f', 1, '0');
+ QTableWidgetItem *item = new QTableWidgetItem(w);
+ item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
+ ui->stepsTable->setItem(i, 1, item);
+
+ if (obj["target_hi"].isString())
+ d = QString(obj["target_hi"].toString()).toDouble();
+ else
+ d = obj["target_hi"].toDouble();
+ w = QString("%1").arg(d, 2, 'f', 1, '0');
+ item = new QTableWidgetItem(w);
+ item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
+ ui->stepsTable->setItem(i, 2, item);
+
+ /* Adding fridgemode 0, 1 as combobox. */
+ QComboBox* myComboBox = new QComboBox();
+ myComboBox->addItem(tr("Beer"));
+ myComboBox->addItem(tr("Fridge"));
+ ui->stepsTable->setCellWidget(i, 3, myComboBox);
+
+ if (obj["fridgemode"].isString()) {
+ d = QString(obj["fridgemode"].toString()).toDouble();
+ } else {
+ d = obj["fridgemode"].toDouble();
+ }
+
+ myComboBox->setCurrentIndex((int)d);
+ connect<void(QComboBox::*)(int)>(myComboBox, &QComboBox::currentIndexChanged, this, &EditProfileFerment::combo_Changed);
+
+ if (obj["steptime"].isString())
+ d = QString(obj["steptime"].toString()).toDouble();
+ else
+ d = obj["steptime"].toDouble();
+ w = QString("%1").arg(d, 1, 'f', 0, '0');
+ item = new QTableWidgetItem(w);
+ item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
+ ui->stepsTable->setItem(i, 4, item);
+ duration += (int)d;
+
+ if (obj["resttime"].isString())
+ d = QString(obj["resttime"].toString()).toDouble();
+ else
+ d = obj["resttime"].toDouble();
+ w = QString("%1").arg(d, 1, 'f', 0, '0');
+ item = new QTableWidgetItem(w);
+ item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
+ ui->stepsTable->setItem(i, 5, item);
+ duration += (int)d;
+
+ /* Add the Delete row button */
+ pWidget = new QWidget();
+ QPushButton* btn_edit = new QPushButton();
+ btn_edit->setObjectName(QString("%1").arg(i)); /* Send row with the button */
+ btn_edit->setText(tr("Delete"));
+ connect(btn_edit, SIGNAL(clicked()), this, SLOT(on_deleteRow_clicked()));
+ pLayout = new QHBoxLayout(pWidget);
+ pLayout->addWidget(btn_edit);
+ pLayout->setContentsMargins(5, 0, 5, 0);
+ pWidget->setLayout(pLayout);
+ ui->stepsTable->setCellWidget(i, 6, pWidget);
+ }
+ }
+
+ /* Show the calculated total fermentation time. */
+ ui->totalEdit->setText(Utils::hours_to_string(duration));
+ this->ignoreChanges = false;
+}
+
+
+EditProfileFerment::~EditProfileFerment()
+{
+ qDebug() << "EditProfileFerment done";
+ delete ui;
+ emit entry_changed();
+}
+
+
+/*
+ * Window header, mark any change with '**'
+ */
+void EditProfileFerment::WindowTitle()
+{
+ QString txt;
+
+ if (this->recno < 0) {
+ txt = QString(tr("BMSapp - Add new fermentation profile"));
+ } else {
+ txt = QString(tr("BMSapp - Edit fermentation profile %1").arg(this->recno));
+ }
+
+ if (this->textIsChanged) {
+ txt.append((QString(" **")));
+ }
+ setWindowTitle(txt);
+}
+
+
+void EditProfileFerment::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 Ferment"), tr("Name empty or too short."));
+ return;
+ }
+
+ if (this->textIsChanged) {
+ if (this->recno == -1) {
+ query.prepare("INSERT INTO profile_fermentation SET name=:name, inittemp_lo=:templo, "
+ "inittemp_hi=:temphi, fridgemode=:fridgemode, totalsteps=:totalsteps, duration=:duration, "
+ "steps=:steps, uuid = :uuid");
+ } else {
+ query.prepare("UPDATE profile_fermentation SET name=:name, inittemp_lo=:templo, "
+ "inittemp_hi=:temphi, fridgemode=:fridgemode, totalsteps=:totalsteps, duration=:duration, "
+ "steps=:steps WHERE record = :recno");
+ }
+ query.bindValue(":name", ui->nameEdit->text());
+ query.bindValue(":templo", QString("%1").arg(ui->temploEdit->value(), 2, 'f', 1, '0'));
+ query.bindValue(":temphi", QString("%1").arg(ui->temphiEdit->value(), 2, 'f', 1, '0'));
+ query.bindValue(":fridgemode", ui->sensorEdit->currentIndex());
+ query.bindValue(":totalsteps", QString("%1").arg(totalsteps));
+ query.bindValue(":duration", QString("%1").arg(duration));
+ query.bindValue(":steps", this->steps.toJson(QJsonDocument::Compact));
+ 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() << "EditProfileFerment" << 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() << "EditProfileFerment Saved";
+ }
+ }
+
+ ui->saveButton->setEnabled(false);
+ this->textIsChanged = false;
+ WindowTitle();
+}
+
+
+void EditProfileFerment::on_deleteButton_clicked()
+{
+ QSqlQuery query;
+
+ query.prepare("DELETE FROM profile_fermentation WHERE record = :recno");
+ query.bindValue(":recno", this->recno);
+ query.exec();
+ if (query.lastError().isValid()) {
+ qDebug() << "EditProfileFerment" << 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() << "EditProfileFerment Deleted" << this->recno;
+ }
+
+ this->close();
+ this->setResult(1);
+}
+
+
+void EditProfileFerment::is_changed()
+{
+ ui->saveButton->setEnabled(true);
+ ui->deleteButton->setEnabled((this->recno >= 0) ? true:false);
+ this->textIsChanged = true;
+ WindowTitle();
+}
+
+
+/*
+ * Rebuild the json string from the table contents.
+ */
+void EditProfileFerment::make_Json()
+{
+ QTableWidgetItem *item;
+ QJsonArray array;
+
+ for (int i = 0; i < ui->stepsTable->rowCount(); i++) {
+
+ QJsonObject obj;
+ item = ui->stepsTable->item(i, 0);
+ obj.insert("name", item->text());
+ item = ui->stepsTable->item(i, 1);
+ obj.insert("target_lo", item->text().toDouble());
+ item = ui->stepsTable->item(i, 2);
+ obj.insert("target_hi", item->text().toDouble());
+ QWidget *widget = ui->stepsTable->cellWidget(i, 3);
+ obj.insert("fridgemode", static_cast<QComboBox*>(widget)->currentIndex() );
+ item = ui->stepsTable->item(i, 4);
+ obj.insert("steptime", item->text().toInt());
+ item = ui->stepsTable->item(i, 5);
+ obj.insert("resttime", item->text().toInt());
+// qDebug() << "make_Json" << i << obj;
+ array.append(obj); /* Append this object */
+ }
+
+// qDebug() << array;
+ /* Copy to the global array and refresh */
+ this->steps.setArray(array);
+ is_changed();
+ emit refreshTable();
+}
+
+
+void EditProfileFerment::cell_Changed(int nRow, int nCol)
+{
+ QString w;
+
+ if (this->ignoreChanges)
+ return;
+
+ qDebug() << "Cell at row " + QString::number(nRow) + " column " + QString::number(nCol) + " was changed.";
+
+ /*
+ * Check the temperature ranges. Make sure that the high temperature is at least
+ * 0.1 degree higher then the low temperature.
+ */
+ if (nCol == 1) { // Low temperature was changed
+ if (ui->stepsTable->item(nRow, 1)->text().toDouble() > (ui->stepsTable->item(nRow, 2)->text().toDouble() - 0.1)) {
+ w = QString("%1").arg(ui->stepsTable->item(nRow, 1)->text().toDouble() + 0.1, 2, 'f', 1, '0');
+ ui->stepsTable->setItem(nRow, 2, new QTableWidgetItem(w));
+ }
+ } else if (nCol == 2) { // High temperature was changed
+ if (ui->stepsTable->item(nRow, 2)->text().toDouble() < (ui->stepsTable->item(nRow, 1)->text().toDouble() + 0.1)) {
+ w = QString("%1").arg(ui->stepsTable->item(nRow, 2)->text().toDouble() - 0.1, 2, 'f', 1, '0');
+ ui->stepsTable->setItem(nRow, 1, new QTableWidgetItem(w));
+ }
+ }
+ make_Json();
+}
+
+
+void EditProfileFerment::combo_Changed()
+{
+ make_Json();
+}
+
+
+void EditProfileFerment::templo_changed()
+{
+ if (ui->temploEdit->value() > (ui->temphiEdit->value() - 0.1))
+ ui->temphiEdit->setValue(ui->temploEdit->value() + 0.1);
+ is_changed();
+}
+
+
+void EditProfileFerment::temphi_changed()
+{
+ if (ui->temphiEdit->value() < (ui->temploEdit->value() + 0.1))
+ ui->temploEdit->setValue(ui->temphiEdit->value() - 0.1);
+ is_changed();
+}
+
+
+/*
+ * Add new row and initialize all fields.
+ */
+void EditProfileFerment::on_addButton_clicked()
+{
+ QWidget* pWidget;
+ QHBoxLayout* pLayout;
+
+ qDebug() << "Add row" << totalsteps;
+ this->ignoreChanges = true;
+ ui->stepsTable->insertRow(totalsteps);
+ ui->stepsTable->setItem(totalsteps, 0, new QTableWidgetItem(QString("new row %1").arg(totalsteps)));
+ ui->stepsTable->setItem(totalsteps, 1, new QTableWidgetItem(QString("19.8")));
+ ui->stepsTable->setItem(totalsteps, 2, new QTableWidgetItem(QString("20.0")));
+ QComboBox* myComboBox = new QComboBox();
+ myComboBox->addItem(tr("Beer"));
+ myComboBox->addItem(tr("Fridge"));
+ myComboBox->setCurrentIndex(0);
+ ui->stepsTable->setCellWidget(totalsteps, 3, myComboBox);
+ ui->stepsTable->setItem(totalsteps, 4, new QTableWidgetItem(QString("0")));
+ ui->stepsTable->setItem(totalsteps, 5, new QTableWidgetItem(QString("0")));
+
+ pWidget = new QWidget();
+ QPushButton* btn_edit = new QPushButton();
+ btn_edit->setObjectName(QString("%1").arg(totalsteps)); /* Send row with the button */
+ btn_edit->setText(tr("Delete"));
+ connect(btn_edit, SIGNAL(clicked()), this, SLOT(on_deleteRow_clicked()));
+ pLayout = new QHBoxLayout(pWidget);
+ pLayout->addWidget(btn_edit);
+ pLayout->setContentsMargins(5, 0, 5, 0);
+ pWidget->setLayout(pLayout);
+ ui->stepsTable->setCellWidget(totalsteps, 6, pWidget);
+
+ this->ignoreChanges = false;
+ make_Json();
+}
+
+
+void EditProfileFerment::on_deleteRow_clicked()
+{
+ QPushButton *pb = qobject_cast<QPushButton *>(QObject::sender());
+ int row = pb->objectName().toInt();
+ qDebug() << "Delete row" << row;
+ ui->stepsTable->removeRow(row);
+ make_Json();
+}
+
+
+void EditProfileFerment::on_quitButton_clicked()
+{
+ if (this->textIsChanged) {
+ int rc = QMessageBox::warning(this, tr("Fermentation changed"), tr("This fermentation profile 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);
+}