Mercurial > bmsapp / changeset

--- a/src/ProdOnCode.cpp	Sun Jun 23 11:35:42 2024 +0200
+++ b/src/ProdOnCode.cpp	Sun Jun 23 11:51:22 2024 +0200
@@ -71,7 +71,7 @@
     QHBoxLayout* pLayout;
 
     qDebug() << "ProdOnCode reload";
-    QSqlQuery query("SELECT record,name,st_name,og,fg,brew_date_start,code FROM products WHERE stage = '11' ORDER BY code,brew_date_start");
+    QSqlQuery query("SELECT record,name,st_name,og,fg,package_date,code FROM products WHERE stage = '11' ORDER BY code,package_date");
     const QStringList labels({tr("Code"), tr("Name"), tr("Style"), tr("OG"), tr("FG"),  tr("Date"), tr("Edit")});
 
     this->tableOnCode->setColumnCount(7);
@@ -100,7 +100,7 @@
         item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
         this->tableOnCode->setItem(ridx, 4, item);
 
-	this->tableOnCode->setItem(ridx, 5, new QTableWidgetItem(query.value("brew_date_start").toDate().toString("dd MMM yyyy")));
+	this->tableOnCode->setItem(ridx, 5, new QTableWidgetItem(query.value("package_date").toDate().toString("dd MMM yyyy")));
 
 	/* Add the Edit button */
         QWidget* pWidget = new QWidget();

--- a/src/ProdOnName.cpp	Sun Jun 23 11:35:42 2024 +0200
+++ b/src/ProdOnName.cpp	Sun Jun 23 11:51:22 2024 +0200
@@ -71,7 +71,7 @@
     QHBoxLayout* pLayout;
 
     qDebug() << "ProdOnName reload";
-    QSqlQuery query("SELECT record,name,st_name,og,fg,brew_date_start,code FROM products WHERE stage = '11' ORDER BY name,brew_date_start");
+    QSqlQuery query("SELECT record,name,st_name,og,fg,package_date,code FROM products WHERE stage = '11' ORDER BY name,package_date");
     const QStringList labels({tr("Name"), tr("Style"), tr("OG"), tr("FG"),  tr("Date"), tr("Code"), tr("Edit")});
 
     this->tableOnName->setColumnCount(7);
@@ -99,7 +99,7 @@
         item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
         this->tableOnName->setItem(ridx, 3, item);
 
-	this->tableOnName->setItem(ridx, 4, new QTableWidgetItem(query.value("brew_date_start").toDate().toString("dd MMM yyyy")));
+	this->tableOnName->setItem(ridx, 4, new QTableWidgetItem(query.value("package_date").toDate().toString("dd MMM yyyy")));
 	this->tableOnName->setItem(ridx, 5, new QTableWidgetItem(query.value("code").toString()));
 
 	/* Add the Edit button */