99 |
100 |
100 qDebug() << "InventoryFermentables reload"; |
101 qDebug() << "InventoryFermentables reload"; |
101 |
102 |
102 QSqlQuery query("SELECT * FROM inventory_fermentables ORDER BY supplier,name"); |
103 QSqlQuery query("SELECT * FROM inventory_fermentables ORDER BY supplier,name"); |
103 const QStringList labels({tr("Origin"), tr("Supplier"), tr("Name"), tr("Type"), tr("Grain"), tr("Color"), tr("Yield"), tr("Stock"), tr("Edit")}); |
104 const QStringList labels({tr("Origin"), tr("Supplier"), tr("Name"), tr("Type"), tr("Grain"), tr("Color"), tr("Yield"), tr("Stock"), tr("Edit")}); |
104 const QStringList types({tr("Grain"), tr("Sugar"), tr("Extract"), tr("Dry extract"), tr("Adjunct")}); |
|
105 const QStringList graintypes({tr("Base"), tr("Roast"), tr("Crystal"), tr("Kilned"), tr("Sour Malt"), tr("Special"), tr("No malt")}); |
|
106 |
105 |
107 /* origin supplier name type graintype color yield inventory Edit */ |
106 /* origin supplier name type graintype color yield inventory Edit */ |
108 this->tableFermentables->setColumnCount(9); |
107 this->tableFermentables->setColumnCount(9); |
109 this->tableFermentables->setColumnWidth(0, 130); /* Origin */ |
108 this->tableFermentables->setColumnWidth(0, 130); /* Origin */ |
110 this->tableFermentables->setColumnWidth(1, 170); /* Supplier */ |
109 this->tableFermentables->setColumnWidth(1, 170); /* Supplier */ |
125 query.first(); |
124 query.first(); |
126 for (int ridx = 0 ; ridx < query.size() ; ridx++ ) { |
125 for (int ridx = 0 ; ridx < query.size() ; ridx++ ) { |
127 this->tableFermentables->setItem(ridx, 0, new QTableWidgetItem(query.value(6).toString())); |
126 this->tableFermentables->setItem(ridx, 0, new QTableWidgetItem(query.value(6).toString())); |
128 this->tableFermentables->setItem(ridx, 1, new QTableWidgetItem(query.value(7).toString())); |
127 this->tableFermentables->setItem(ridx, 1, new QTableWidgetItem(query.value(7).toString())); |
129 this->tableFermentables->setItem(ridx, 2, new QTableWidgetItem(query.value(1).toString())); |
128 this->tableFermentables->setItem(ridx, 2, new QTableWidgetItem(query.value(1).toString())); |
130 this->tableFermentables->setItem(ridx, 3, new QTableWidgetItem(types[query.value(2).toInt()])); |
129 this->tableFermentables->setItem(ridx, 3, new QTableWidgetItem(fermentable_types[query.value(2).toInt()])); |
131 this->tableFermentables->setItem(ridx, 4, new QTableWidgetItem(graintypes[query.value(20).toInt()])); |
130 this->tableFermentables->setItem(ridx, 4, new QTableWidgetItem(fermentable_graintypes[query.value(20).toInt()])); |
132 w = QString("%1 EBC").arg(query.value(4).toDouble(), 1, 'f', 0, '0' ); |
131 w = QString("%1 EBC").arg(query.value(4).toDouble(), 1, 'f', 0, '0' ); |
133 QTableWidgetItem *item = new QTableWidgetItem(w); |
132 QTableWidgetItem *item = new QTableWidgetItem(w); |
134 item->setTextAlignment(Qt::AlignRight|Qt::AlignVCenter); |
133 item->setTextAlignment(Qt::AlignRight|Qt::AlignVCenter); |
135 this->tableFermentables->setItem(ridx, 5, item); |
134 this->tableFermentables->setItem(ridx, 5, item); |
136 w = QString("%1 %").arg(query.value(3).toFloat(), 3, 'f', 1, '0' ); |
135 w = QString("%1 %").arg(query.value(3).toFloat(), 3, 'f', 1, '0' ); |