src/ProdOnName.cpp

changeset 539
e5972bf6e50c
parent 228
c859e8efa470
equal deleted inserted replaced
538:19cbd065765e 539:e5972bf6e50c
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();

mercurial