251 connect(quitButton, SIGNAL(clicked()), parent, SLOT(fromRecipesTree())); |
251 connect(quitButton, SIGNAL(clicked()), parent, SLOT(fromRecipesTree())); |
252 connect(insertButton, SIGNAL(clicked()), this, SLOT(on_insertButton_clicked())); |
252 connect(insertButton, SIGNAL(clicked()), this, SLOT(on_insertButton_clicked())); |
253 connect(openButton, SIGNAL(clicked()), this, SLOT(on_openButton_clicked())); |
253 connect(openButton, SIGNAL(clicked()), this, SLOT(on_openButton_clicked())); |
254 |
254 |
255 connect(this, SIGNAL(setStatus(QString)), parent, SLOT(statusMsg(QString))); |
255 connect(this, SIGNAL(setStatus(QString)), parent, SLOT(statusMsg(QString))); |
256 emit refreshTable(); |
256 |
257 } |
|
258 |
|
259 |
|
260 void RecipesTree::refreshTable() |
|
261 { |
|
262 QTreeWidgetItem *st_guide, *st_group, *st_name, *name; |
|
263 |
|
264 qDebug() << "RecipesTree reload" << treeWidget->autoExpandDelay(); |
|
265 |
|
266 treeWidget->clear(); |
|
267 // treeWidget->setAutoExpandDelay(1); |
257 // treeWidget->setAutoExpandDelay(1); |
268 // treeWidget->setUpdatesEnabled(true); |
258 // treeWidget->setUpdatesEnabled(true); |
269 // treeWidget->collapseAll(); |
259 // treeWidget->collapseAll(); |
270 // treeWidget->setRootIsDecorated(false); |
260 // treeWidget->setRootIsDecorated(false); |
271 treeWidget->setColumnCount(4); |
261 treeWidget->setColumnCount(4); |
273 treeWidget->header()->setSectionResizeMode(QHeaderView::ResizeToContents); |
263 treeWidget->header()->setSectionResizeMode(QHeaderView::ResizeToContents); |
274 // treeWidget->setEditTriggers(QAbstractItemView::NoEditTriggers); |
264 // treeWidget->setEditTriggers(QAbstractItemView::NoEditTriggers); |
275 |
265 |
276 connect(treeWidget, SIGNAL(itemClicked(QTreeWidgetItem *, int)), this, SLOT(on_item_clicked(QTreeWidgetItem*, int))); |
266 connect(treeWidget, SIGNAL(itemClicked(QTreeWidgetItem *, int)), this, SLOT(on_item_clicked(QTreeWidgetItem*, int))); |
277 connect(treeWidget, SIGNAL(itemDoubleClicked(QTreeWidgetItem *, int)), this, SLOT(on_item_doubleclicked(QTreeWidgetItem*, int))); |
267 connect(treeWidget, SIGNAL(itemDoubleClicked(QTreeWidgetItem *, int)), this, SLOT(on_item_doubleclicked(QTreeWidgetItem*, int))); |
|
268 |
|
269 emit refreshTable(); |
|
270 } |
|
271 |
|
272 |
|
273 void RecipesTree::refreshTable() |
|
274 { |
|
275 QTreeWidgetItem *st_guide, *st_group, *st_name, *name; |
|
276 |
|
277 qDebug() << "RecipesTree reload" << treeWidget->autoExpandDelay(); |
|
278 |
|
279 treeWidget->clear(); |
278 |
280 |
279 QSqlQuery query0; |
281 QSqlQuery query0; |
280 query0.prepare("SELECT DISTINCT st_guide FROM recipes ORDER BY st_guide"); |
282 query0.prepare("SELECT DISTINCT st_guide FROM recipes ORDER BY st_guide"); |
281 query0.exec(); |
283 query0.exec(); |
282 query0.first(); |
284 query0.first(); |
356 if (record < 1) { |
358 if (record < 1) { |
357 recipeBox->setEnabled(false); |
359 recipeBox->setEnabled(false); |
358 return; |
360 return; |
359 } |
361 } |
360 |
362 |
361 qDebug() << "showRecipe 2"; |
|
362 /* |
363 /* |
363 * Fill in basic details of the selected recipe. |
364 * Fill in basic details of the selected recipe. |
364 */ |
365 */ |
365 QSqlQuery query; |
366 QSqlQuery query; |
366 query.prepare("SELECT batch_size,boil_size,boil_time,efficiency,est_og,est_fg,est_abv,est_color,color_method,est_ibu,ibu_method,est_carb,notes,name " |
367 query.prepare("SELECT batch_size,boil_size,boil_time,efficiency,est_og,est_fg,est_abv,est_color,color_method,est_ibu,ibu_method,est_carb,notes,name " |
367 "FROM recipes WHERE record=:record"); |
368 "FROM recipes WHERE record=:record"); |
368 query.bindValue(":record", record); |
369 query.bindValue(":record", record); |
369 qDebug() << "showRecipe 3"; |
|
370 query.exec(); |
370 query.exec(); |
371 qDebug() << "showRecipe 4"; |
|
372 if (query.size() == 1) { |
371 if (query.size() == 1) { |
373 qDebug() << "showRecipe 5 ok"; |
|
374 query.first(); |
372 query.first(); |
375 qDebug() << "showRecipe 6"; |
|
376 volumeEdit->setValue(query.value(0).toDouble()); |
373 volumeEdit->setValue(query.value(0).toDouble()); |
377 boilvolumeEdit->setValue(query.value(1).toDouble()); |
374 boilvolumeEdit->setValue(query.value(1).toDouble()); |
378 boiltimeEdit->setValue(query.value(2).toInt()); |
375 boiltimeEdit->setValue(query.value(2).toInt()); |
379 efficiencyEdit->setValue(query.value(3).toDouble()); |
376 efficiencyEdit->setValue(query.value(3).toDouble()); |
380 ogEdit->setValue(query.value(4).toDouble()); |
377 ogEdit->setValue(query.value(4).toDouble()); |
381 fgEdit->setValue(query.value(5).toDouble()); |
378 fgEdit->setValue(query.value(5).toDouble()); |
382 abvEdit->setValue(query.value(6).toInt()); |
379 abvEdit->setValue(query.value(6).toInt()); |
383 colorEdit->setValue(query.value(7).toInt()); |
380 colorEdit->setValue(query.value(7).toInt()); |
|
381 colorEdit->setStyleSheet(Utils::ebc_to_style(query.value(7).toInt())); |
384 colormethodEdit->setText(c_method[query.value(8).toInt()]); |
382 colormethodEdit->setText(c_method[query.value(8).toInt()]); |
385 ibuEdit->setValue(query.value(9).toInt()); |
383 ibuEdit->setValue(query.value(9).toInt()); |
386 ibumethodEdit->setText(i_method[query.value(10).toInt()]); |
384 ibumethodEdit->setText(i_method[query.value(10).toInt()]); |
387 co2Edit->setValue(query.value(11).toDouble()); |
385 co2Edit->setValue(query.value(11).toDouble()); |
388 remarksEdit->setPlainText(query.value(12).toString()); |
386 remarksEdit->setPlainText(query.value(12).toString()); |
389 recipeBox->setTitle(query.value(13).toString()); |
387 recipeBox->setTitle(query.value(13).toString()); |
390 recipeBox->setEnabled(true); |
388 recipeBox->setEnabled(true); |
391 qDebug() << "showRecipe 7"; |
|
392 } else { |
389 } else { |
393 qDebug() << "showRecipe 5 error"; |
|
394 qDebug() << "Error getting recipe record" << record; |
390 qDebug() << "Error getting recipe record" << record; |
395 } |
391 } |
|
392 qDebug() << "showRecipe done"; |
396 } |
393 } |
397 |
394 |
398 |
395 |
399 RecipesTree::~RecipesTree() {} |
396 RecipesTree::~RecipesTree() {} |
400 |
397 |