Sun, 23 Jun 2024 11:51:22 +0200
Archive products on code and on date all use the packaging date.
src/ProdOnCode.cpp | file | annotate | diff | comparison | revisions | |
src/ProdOnName.cpp | file | annotate | diff | comparison | revisions |
--- 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 */