81 _uuid = query.value("uuid").toString(); |
81 _uuid = query.value("uuid").toString(); |
82 _beercode = query.value("beercode").toString(); |
82 _beercode = query.value("beercode").toString(); |
83 _beername = query.value("beername").toString(); |
83 _beername = query.value("beername").toString(); |
84 |
84 |
85 sql = "SELECT " |
85 sql = "SELECT " |
86 "st_carb_min,st_carb_max,secondary_temp,primary_end_temp,bottle_carbonation_temp" |
86 "st_carb_min,st_carb_max,secondary_temp,primary_end_temp,bottle_carbonation_temp," |
|
87 "bottle_carbonation" |
87 " FROM products WHERE code=:code AND name=:name"; |
88 " FROM products WHERE code=:code AND name=:name"; |
88 query2.prepare(sql); |
89 query2.prepare(sql); |
89 query2.bindValue(":code", _beercode); |
90 query2.bindValue(":code", _beercode); |
90 query2.bindValue(":name", _beername); |
91 query2.bindValue(":name", _beername); |
91 query2.exec(); |
92 query2.exec(); |
96 TSec = query2.value("primary_end_temp").toDouble(); |
97 TSec = query2.value("primary_end_temp").toDouble(); |
97 if (TSec < 1) |
98 if (TSec < 1) |
98 TSec = 18; |
99 TSec = 18; |
99 |
100 |
100 double carbtemp = query2.value("bottle_carbonation_temp").toDouble(); |
101 double carbtemp = query2.value("bottle_carbonation_temp").toDouble(); |
101 double barmin = Utils::GetPressureBar(Utils::CarbCO2toS(query2.value("st_carb_min").toDouble(), TSec, 1), carbtemp); |
102 double barmin = Utils::GetPressureBar(Utils::CarbCO2toS(query2.value("st_carb_min").toDouble(), TSec, 1), carbtemp); |
102 double barmax = Utils::GetPressureBar(Utils::CarbCO2toS(query2.value("st_carb_max").toDouble(), TSec, 1), carbtemp); |
103 double barmax = Utils::GetPressureBar(Utils::CarbCO2toS(query2.value("st_carb_max").toDouble(), TSec, 1), carbtemp); |
|
104 double barthis = Utils::GetPressureBar(Utils::CarbCO2toS(query2.value("bottle_carbonation").toDouble(), TSec, 1), carbtemp); |
103 ui->minVol->setValue(query2.value("st_carb_min").toDouble()); |
105 ui->minVol->setValue(query2.value("st_carb_min").toDouble()); |
104 ui->maxVol->setValue(query2.value("st_carb_max").toDouble()); |
106 ui->maxVol->setValue(query2.value("st_carb_max").toDouble()); |
|
107 ui->thisVol->setValue(query2.value("bottle_carbonation").toDouble()); |
105 ui->minBar->setValue(barmin); |
108 ui->minBar->setValue(barmin); |
106 ui->maxBar->setValue(barmax); |
109 ui->maxBar->setValue(barmax); |
107 qDebug() << " beerdata" << TSec << carbtemp << barmin << barmax; |
110 ui->thisBar->setValue(barthis); |
|
111 qDebug() << " beerdata" << TSec << carbtemp << barmin << barmax << barthis; |
108 |
112 |
109 ui->barMeter->setNominal(barmin); |
113 ui->barMeter->setNominal(barmin); |
110 ui->barMeter->setCritical(barmax); |
114 ui->barMeter->setCritical(barmax); |
111 } |
115 } |
112 |
116 |