69 QString w; |
69 QString w; |
70 QWidget* pWidget; |
70 QWidget* pWidget; |
71 QHBoxLayout* pLayout; |
71 QHBoxLayout* pLayout; |
72 |
72 |
73 qDebug() << "ProdOnName reload"; |
73 qDebug() << "ProdOnName reload"; |
74 QSqlQuery query("SELECT record,name,st_name,og,fg,brew_date_start,code FROM products WHERE stage = '11' ORDER BY name,brew_date_start"); |
74 QSqlQuery query("SELECT record,name,st_name,og,fg,package_date,code FROM products WHERE stage = '11' ORDER BY name,package_date"); |
75 const QStringList labels({tr("Name"), tr("Style"), tr("OG"), tr("FG"), tr("Date"), tr("Code"), tr("Edit")}); |
75 const QStringList labels({tr("Name"), tr("Style"), tr("OG"), tr("FG"), tr("Date"), tr("Code"), tr("Edit")}); |
76 |
76 |
77 this->tableOnName->setColumnCount(7); |
77 this->tableOnName->setColumnCount(7); |
78 this->tableOnName->setColumnWidth(0, 500); /* Product name */ |
78 this->tableOnName->setColumnWidth(0, 500); /* Product name */ |
79 this->tableOnName->setColumnWidth(1, 200); /* Style */ |
79 this->tableOnName->setColumnWidth(1, 200); /* Style */ |
97 |
97 |
98 item = new QTableWidgetItem(QString("%1").arg(query.value("fg").toFloat(), 4, 'f', 3, '0' )); |
98 item = new QTableWidgetItem(QString("%1").arg(query.value("fg").toFloat(), 4, 'f', 3, '0' )); |
99 item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter); |
99 item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter); |
100 this->tableOnName->setItem(ridx, 3, item); |
100 this->tableOnName->setItem(ridx, 3, item); |
101 |
101 |
102 this->tableOnName->setItem(ridx, 4, new QTableWidgetItem(query.value("brew_date_start").toDate().toString("dd MMM yyyy"))); |
102 this->tableOnName->setItem(ridx, 4, new QTableWidgetItem(query.value("package_date").toDate().toString("dd MMM yyyy"))); |
103 this->tableOnName->setItem(ridx, 5, new QTableWidgetItem(query.value("code").toString())); |
103 this->tableOnName->setItem(ridx, 5, new QTableWidgetItem(query.value("code").toString())); |
104 |
104 |
105 /* Add the Edit button */ |
105 /* Add the Edit button */ |
106 QWidget* pWidget = new QWidget(); |
106 QWidget* pWidget = new QWidget(); |
107 QPushButton* btn_edit = new QPushButton(); |
107 QPushButton* btn_edit = new QPushButton(); |