Thu, 09 Jun 2022 11:16:00 +0200
Added the main record update to the product splitting. Block edit of the product code if the product is splitted.
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | /** |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | * db_product.cpp is part of bmsapp. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | * |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | * bmsapp is free software: you can redistribute it and/or modify |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | * it under the terms of the GNU General Public License as published by |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | * the Free Software Foundation, either version 3 of the License, or |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | * (at your option) any later version. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | * |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | * bmsapp is distributed in the hope that it will be useful, |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | * GNU General Public License for more details. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | * |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | * You should have received a copy of the GNU General Public License |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | #include "global.h" |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | #include "db_product.h" |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | bool DB_product::load(Product *prod, QDialog *dialog, int recno) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
24 | QSqlQuery query, yquery; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
25 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
26 | query.prepare("SELECT * FROM products WHERE record = :recno"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | query.bindValue(":recno", recno); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | query.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | if (! query.first()) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
30 | qWarning() << "loadProduct seek error record" << recno; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
31 | QMessageBox::warning(dialog, QObject::tr("Database error"), QObject::tr("MySQL error: record %1 not found").arg(recno)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
32 | dialog->done(QDialog::Rejected); // At this stage, this doesn't work because the dialog is not yet visible. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
33 | return false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
34 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | QSqlRecord rec = query.record(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | for (int i = 0; i < rec.count(); i++) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | qDebug() << i << rec.fieldName(i) << query.value(i); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | prod->record = query.value("record").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | prod->uuid = query.value("uuid").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | prod->name = query.value("name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | prod->code = query.value("code").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | prod->birth = query.value("birth").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | prod->stage = query.value("stage").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | prod->notes = query.value("notes").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
47 | prod->log_brew = query.value("log_brew").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
48 | prod->log_fermentation = query.value("log_fermentation").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
49 | prod->log_ispindel = query.value("log_ispindel").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | prod->log_co2pressure = query.value("log_co2pressure").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
51 | prod->inventory_reduced = query.value("inventory_reduced").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
52 | prod->locked = query.value("locked").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
53 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | prod->eq_name = query.value("eq_name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
55 | prod->eq_notes = query.value("eq_notes").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | prod->eq_boil_size = query.value("eq_boil_size").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
57 | prod->eq_batch_size = query.value("eq_batch_size").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | prod->eq_tun_volume = query.value("eq_tun_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | prod->eq_tun_weight = query.value("eq_tun_weight").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | prod->eq_tun_specific_heat = query.value("eq_tun_specific_heat").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
61 | prod->eq_tun_material = query.value("eq_tun_material").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | prod->eq_tun_height = query.value("eq_tun_height").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
63 | prod->eq_top_up_water = query.value("eq_top_up_water").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
64 | prod->eq_trub_chiller_loss = query.value("eq_trub_chiller_loss").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
65 | prod->eq_evap_rate = query.value("eq_evap_rate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
66 | prod->eq_boil_time = query.value("eq_boil_time").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
67 | prod->eq_calc_boil_volume = query.value("eq_calc_boil_volume").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
68 | prod->eq_top_up_kettle = query.value("eq_top_up_kettle").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
69 | prod->eq_hop_utilization = query.value("eq_hop_utilization").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
70 | prod->eq_lauter_volume = query.value("eq_lauter_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
71 | prod->eq_lauter_height = query.value("eq_lauter_height").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | prod->eq_lauter_deadspace = query.value("eq_lauter_deadspace").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
73 | prod->eq_kettle_volume = query.value("eq_kettle_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
74 | prod->eq_kettle_height = query.value("eq_kettle_height").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
75 | prod->eq_mash_volume = query.value("eq_mash_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
76 | prod->eq_mash_max = query.value("eq_mash_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
77 | prod->eq_efficiency = query.value("eq_efficiency").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
78 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
79 | prod->brew_date_start = query.value("brew_date_start").toDateTime(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
80 | prod->brew_mash_ph = query.value("brew_mash_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
81 | prod->brew_mash_sg = query.value("brew_mash_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
82 | prod->brew_mash_efficiency = query.value("brew_mash_efficiency").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
83 | prod->brew_sparge_temperature = query.value("brew_sparge_temperature").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
84 | prod->brew_sparge_volume = query.value("brew_sparge_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
85 | prod->brew_sparge_est = query.value("brew_sparge_est").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
86 | prod->brew_sparge_ph = query.value("brew_sparge_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
87 | prod->brew_preboil_volume = query.value("brew_preboil_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
88 | prod->brew_preboil_sg = query.value("brew_preboil_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
89 | prod->brew_preboil_ph = query.value("brew_preboil_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
90 | prod->brew_preboil_efficiency = query.value("brew_preboil_efficiency").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
91 | prod->brew_aboil_volume = query.value("brew_aboil_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
92 | prod->brew_aboil_sg = query.value("brew_aboil_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
93 | prod->brew_aboil_ph = query.value("brew_aboil_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
94 | prod->brew_aboil_efficiency = query.value("brew_aboil_efficiency").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
95 | prod->brew_cooling_method = query.value("brew_cooling_method").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
96 | prod->brew_cooling_time = query.value("brew_cooling_time").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
97 | prod->brew_cooling_to = query.value("brew_cooling_to").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
98 | prod->brew_whirlpool9 = query.value("brew_whirlpool9").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
99 | prod->brew_whirlpool7 = query.value("brew_whirlpool7").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
100 | prod->brew_whirlpool6 = query.value("brew_whirlpool6").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
101 | prod->brew_whirlpool2 = query.value("brew_whirlpool2").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
102 | prod->brew_fermenter_volume = query.value("brew_fermenter_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
103 | prod->brew_fermenter_extrawater = query.value("brew_fermenter_extrawater").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
104 | prod->brew_fermenter_tcloss = query.value("brew_fermenter_tcloss").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
105 | prod->brew_aeration_time = query.value("brew_aeration_time").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
106 | prod->brew_aeration_speed = query.value("brew_aeration_speed").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
107 | prod->brew_aeration_type = query.value("brew_aeration_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
108 | prod->brew_fermenter_sg = query.value("brew_fermenter_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
109 | prod->brew_fermenter_ibu = query.value("brew_fermenter_ibu").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
110 | prod->brew_fermenter_color = query.value("brew_fermenter_color").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
111 | prod->brew_date_end = query.value("brew_date_end").toDateTime(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
112 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
113 | prod->og = query.value("og").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
114 | prod->fg = query.value("fg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
115 | prod->primary_start_temp = query.value("primary_start_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
116 | prod->primary_max_temp = query.value("primary_max_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
117 | prod->primary_end_temp = query.value("primary_end_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
118 | prod->primary_end_sg = query.value("primary_end_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
119 | prod->primary_end_date = query.value("primary_end_date").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
120 | prod->secondary_temp = query.value("secondary_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
121 | prod->secondary_end_sg = query.value("secondary_end_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
122 | prod->secondary_end_date = query.value("secondary_end_date").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
123 | prod->tertiary_temp = query.value("tertiary_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
124 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
125 | prod->package_date = query.value("package_date").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
126 | prod->package_volume = query.value("package_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
127 | prod->package_infuse_amount = query.value("package_infuse_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
128 | prod->package_infuse_abv = query.value("package_infuse_abv").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
129 | prod->package_infuse_notes = query.value("package_infuse_notes").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
130 | prod->package_abv = query.value("package_abv").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
131 | prod->package_ph = query.value("package_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
132 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
133 | prod->bottle_amount = query.value("bottle_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
134 | prod->bottle_carbonation = query.value("bottle_carbonation").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
135 | prod->bottle_priming_sugar = query.value("bottle_priming_sugar").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
136 | prod->bottle_priming_amount = query.value("bottle_priming_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
137 | prod->bottle_priming_water = query.value("bottle_priming_water").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
138 | prod->bottle_carbonation_temp = query.value("bottle_carbonation_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
139 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
140 | prod->keg_amount = query.value("keg_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
141 | prod->keg_carbonation = query.value("keg_carbonation").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
142 | prod->keg_priming_sugar = query.value("keg_priming_sugar").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
143 | prod->keg_priming_amount = query.value("keg_priming_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
144 | prod->keg_priming_water = query.value("keg_priming_water").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
145 | prod->keg_carbonation_temp = query.value("keg_carbonation_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
146 | prod->keg_forced_carb = query.value("keg_forced_carb").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
147 | prod->keg_pressure = query.value("keg_pressure").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
148 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
149 | prod->taste_notes = query.value("taste_notes").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
150 | prod->taste_rate = query.value("taste_rate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
151 | prod->taste_date = query.value("taste_date").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
152 | prod->taste_color = query.value("taste_color").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
153 | prod->taste_transparency = query.value("taste_transparency").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
154 | prod->taste_head = query.value("taste_head").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
155 | prod->taste_aroma = query.value("taste_aroma").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
156 | prod->taste_taste = query.value("taste_taste").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
157 | prod->taste_mouthfeel = query.value("taste_mouthfeel").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
158 | prod->taste_aftertaste = query.value("taste_aftertaste").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
159 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
160 | prod->st_name = query.value("st_name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
161 | prod->st_letter = query.value("st_letter").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
162 | prod->st_guide = query.value("st_guide").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
163 | prod->st_category = query.value("st_category").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
164 | prod->st_category_number = query.value("st_category_number").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
165 | prod->st_type = query.value("st_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
166 | prod->st_og_min = query.value("st_og_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
167 | prod->st_og_max = query.value("st_og_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
168 | prod->st_fg_min = query.value("st_fg_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
169 | prod->st_fg_max = query.value("st_fg_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
170 | prod->st_ibu_min = query.value("st_ibu_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
171 | prod->st_ibu_max = query.value("st_ibu_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
172 | prod->st_color_min = query.value("st_color_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
173 | prod->st_color_max = query.value("st_color_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
174 | prod->st_carb_min = query.value("st_carb_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
175 | prod->st_carb_max = query.value("st_carb_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
176 | prod->st_abv_min = query.value("st_abv_min").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
177 | prod->st_abv_max = query.value("st_abv_max").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
178 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
179 | prod->type = query.value("type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
180 | prod->batch_size = query.value("batch_size").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
181 | prod->boil_size = query.value("boil_size").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
182 | prod->boil_time = query.value("boil_time").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
183 | prod->efficiency = query.value("efficiency").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
184 | prod->est_og = query.value("est_og").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
185 | prod->est_og3 = query.value("est_og3").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
186 | prod->est_fg = query.value("est_fg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
187 | prod->est_abv = query.value("est_abv").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
188 | prod->est_color = query.value("est_color").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
189 | prod->color_method = query.value("color_method").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
190 | prod->est_ibu = query.value("est_ibu").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
191 | prod->ibu_method = query.value("ibu_method").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
192 | prod->est_carb = query.value("est_carb").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
193 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
194 | prod->sparge_temp = query.value("sparge_temp").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
195 | prod->sparge_ph = query.value("sparge_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
196 | prod->sparge_volume = query.value("sparge_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
197 | prod->sparge_source = query.value("sparge_source").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
198 | prod->sparge_acid_type = query.value("sparge_acid_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
199 | prod->sparge_acid_perc = query.value("sparge_acid_perc").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
200 | prod->sparge_acid_amount = query.value("sparge_acid_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
201 | prod->mash_ph = query.value("mash_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
202 | prod->mash_name = query.value("mash_name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
203 | prod->calc_acid = query.value("calc_acid").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
204 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
205 | prod->w1_name = query.value("w1_name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
206 | prod->w1_amount = query.value("w1_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
207 | prod->w1_calcium = query.value("w1_calcium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
208 | prod->w1_sulfate = query.value("w1_sulfate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
209 | prod->w1_chloride = query.value("w1_chloride").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
210 | prod->w1_sodium = query.value("w1_sodium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
211 | prod->w1_magnesium = query.value("w1_magnesium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
212 | prod->w1_total_alkalinity = query.value("w1_total_alkalinity").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
213 | prod->w1_ph = query.value("w1_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
214 | prod->w1_cost = query.value("w1_cost").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
215 | prod->w2_name = query.value("w2_name").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
216 | prod->w2_amount = query.value("w2_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
217 | prod->w2_calcium = query.value("w2_calcium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
218 | prod->w2_sulfate = query.value("w2_sulfate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
219 | prod->w2_chloride = query.value("w2_chloride").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
220 | prod->w2_sodium = query.value("w2_sodium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
221 | prod->w2_magnesium = query.value("w2_magnesium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
222 | prod->w2_total_alkalinity = query.value("w2_total_alkalinity").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
223 | prod->w2_ph = query.value("w2_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
224 | prod->w2_cost = query.value("w2_cost").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
225 | prod->wg_amount = query.value("wg_amount").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
226 | prod->wg_calcium = query.value("wg_calcium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
227 | prod->wg_sulfate = query.value("wg_sulfate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
228 | prod->wg_chloride = query.value("wg_chloride").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
229 | prod->wg_sodium = query.value("wg_sodium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
230 | prod->wg_magnesium = query.value("wg_magnesium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
231 | prod->wg_total_alkalinity = query.value("wg_total_alkalinity").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
232 | prod->wg_ph = query.value("wg_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
233 | prod->wb_calcium = query.value("wb_calcium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
234 | prod->wb_sulfate = query.value("wb_sulfate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
235 | prod->wb_chloride = query.value("wb_chloride").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
236 | prod->wb_sodium = query.value("wb_sodium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
237 | prod->wb_magnesium = query.value("wb_magnesium").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
238 | prod->wb_total_alkalinity = query.value("wb_total_alkalinity").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
239 | prod->wb_ph = query.value("wb_ph").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
240 | prod->wa_acid_name = query.value("wa_acid_name").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
241 | prod->wa_acid_perc = query.value("wa_acid_perc").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
242 | prod->wa_base_name = query.value("wa_base_name").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
243 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
244 | prod->starter_enable = query.value("starter_enable").toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
245 | prod->starter_type = query.value("starter_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
246 | prod->starter_sg = query.value("starter_sg").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
247 | prod->starter_viability = query.value("starter_viability").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
248 | if (query.value("yeast_prod_date").toString().length() == 10) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
249 | prod->yeast_prod_date = query.value("yeast_prod_date").toDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
250 | else |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
251 | prod->yeast_prod_date = QDate(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
252 | prod->yeast_pitchrate = query.value("yeast_pitchrate").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
253 | prod->prop_type[0] = query.value("prop1_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
254 | prod->prop_volume[0] = query.value("prop1_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
255 | prod->prop_type[1] = query.value("prop2_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
256 | prod->prop_volume[1] = query.value("prop2_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
257 | prod->prop_type[2] = query.value("prop3_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
258 | prod->prop_volume[2] = query.value("prop3_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
259 | prod->prop_type[3] = query.value("prop4_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
260 | prod->prop_volume[3] = query.value("prop4_volume").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
261 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
262 | prod->divide_type = query.value("divide_type").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
263 | prod->divide_size = query.value("divide_size").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
264 | prod->divide_factor = query.value("divide_factor").toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
265 | prod->divide_parts = query.value("divide_parts").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
266 | prod->divide_part = query.value("divide_part").toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
267 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
268 | QJsonParseError parseError; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
269 | const auto& f_json = query.value("json_fermentables").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
270 | if (!f_json.trimmed().isEmpty()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
271 | const auto& formattedJson = QString("%1").arg(f_json); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
272 | QJsonDocument fermentables = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
273 | if (parseError.error != QJsonParseError::NoError) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
274 | qWarning() << "Parse error: " << parseError.errorString() << "at" << parseError.offset ; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
275 | } else if (fermentables.isArray()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
276 | double percentcheck = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
277 | for (int i = 0; i < fermentables.array().size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
278 | QJsonObject obj = fermentables.array().at(i).toObject(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
279 | Fermentables f; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
280 | f.f_inventory = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
281 | f.f_avail = false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
282 | f.f_name = obj["f_name"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
283 | f.f_origin = obj["f_origin"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
284 | f.f_supplier = obj["f_supplier"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
285 | f.f_amount = obj["f_amount"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
286 | f.f_cost = obj["f_cost"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
287 | f.f_type = obj["f_type"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
288 | f.f_yield = obj["f_yield"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
289 | f.f_color = obj["f_color"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
290 | f.f_coarse_fine_diff = obj["f_coarse_fine_diff"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
291 | f.f_moisture = obj["f_moisture"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
292 | f.f_diastatic_power = obj["f_diastatic_power"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
293 | f.f_protein = obj["f_protein"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
294 | f.f_dissolved_protein = obj["f_dissolved_protein"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
295 | f.f_max_in_batch = obj["f_max_in_batch"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
296 | f.f_graintype = obj["f_graintype"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
297 | f.f_added = obj["f_added"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
298 | f.f_recommend_mash = obj["f_recommend_mash"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
299 | f.f_add_after_boil = obj["f_add_after_boil"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
300 | f.f_adjust_to_total_100 = obj["f_adjust_to_total_100"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
301 | f.f_percentage = obj["f_percentage"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
302 | f.f_di_ph = obj["f_di_ph"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
303 | f.f_acid_to_ph_57 = obj["f_acid_to_ph_57"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
304 | if (f.f_adjust_to_total_100) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
305 | prod->fermentables_use100 = true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
306 | percentcheck += f.f_percentage; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
307 | /* Check and update inventory */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
308 | yquery.prepare("SELECT inventory FROM inventory_fermentables WHERE name=:name AND supplier=:supplier AND origin=:origin"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
309 | yquery.bindValue(":name", f.f_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
310 | yquery.bindValue(":supplier", f.f_supplier); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
311 | yquery.bindValue(":origin", f.f_origin); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
312 | yquery.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
313 | if (yquery.first()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
314 | f.f_avail = true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
315 | f.f_inventory = yquery.value(0).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
316 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
317 | prod->fermentables.append(f); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
318 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
319 | qDebug() << "fermentables" << prod->fermentables.size() << percentcheck; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
320 | if (percentcheck == 0 && prod->fermentables.size()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
321 | /* Missing percentages, fix it. */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
322 | double total = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
323 | for (int i = 0; i < prod->fermentables.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
324 | if (prod->fermentables.at(i).f_added < 4) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
325 | total += prod->fermentables.at(i).f_amount; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
326 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
327 | for (int i = 0; i < prod->fermentables.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
328 | if (prod->fermentables.at(i).f_added < 4) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
329 | prod->fermentables[i].f_percentage = round((prod->fermentables.at(i).f_amount / total) * 10000.0) / 100.0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
330 | } |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
331 | qInfo() << " fixed missing percentages"; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
332 | // is_changed(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
333 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
334 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
335 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
336 | qDebug() << "empty fermentables"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
337 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
338 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
339 | const auto& h_json = query.value("json_hops").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
340 | if (!h_json.trimmed().isEmpty()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
341 | const auto& formattedJson = QString("%1").arg(h_json); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
342 | QJsonDocument hops = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
343 | if (parseError.error != QJsonParseError::NoError) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
344 | qWarning() << "Parse error: " << parseError.errorString() << "at" << parseError.offset; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
345 | } else if (hops.isArray()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
346 | for (int i = 0; i < hops.array().size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
347 | QJsonObject obj = hops.array().at(i).toObject(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
348 | Hops h; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
349 | h.h_avail = false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
350 | h.h_inventory = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
351 | h.h_name = obj["h_name"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
352 | h.h_origin = obj["h_origin"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
353 | h.h_amount = obj["h_amount"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
354 | h.h_cost = obj["h_cost"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
355 | h.h_type = obj["h_type"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
356 | h.h_form = obj["h_form"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
357 | h.h_useat = obj["h_useat"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
358 | h.h_time = obj["h_time"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
359 | h.h_alpha = obj["h_alpha"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
360 | h.h_beta = obj["h_beta"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
361 | h.h_hsi = obj["h_hsi"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
362 | h.h_humulene = obj["h_humulene"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
363 | h.h_caryophyllene = obj["h_caryophyllene"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
364 | h.h_cohumulone = obj["h_cohumulone"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
365 | h.h_myrcene = obj["h_myrcene"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
366 | h.h_total_oil = obj["h_total_oil"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
367 | /* Check and update inventory */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
368 | yquery.prepare("SELECT inventory FROM inventory_hops WHERE name=:name AND origin=:origin"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
369 | yquery.bindValue(":name", h.h_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
370 | yquery.bindValue(":origin", h.h_origin); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
371 | yquery.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
372 | if (yquery.first()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
373 | h.h_avail = true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
374 | h.h_inventory = yquery.value(0).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
375 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
376 | prod->hops.append(h); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
377 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
378 | qDebug() << "hops" << prod->hops.size(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
379 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
380 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
381 | qDebug() << "empty hops"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
382 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
383 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
384 | const auto& m_json = query.value("json_miscs").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
385 | if (!m_json.trimmed().isEmpty()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
386 | const auto& formattedJson = QString("%1").arg(m_json); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
387 | QJsonDocument miscs = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
388 | if (parseError.error != QJsonParseError::NoError) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
389 | qWarning() << "Parse error: " << parseError.errorString() << "at" << parseError.offset; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
390 | } else if (miscs.isArray()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
391 | for (int i = 0; i < miscs.array().size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
392 | QJsonObject obj = miscs.array().at(i).toObject(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
393 | Miscs m; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
394 | m.m_avail = false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
395 | m.m_inventory = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
396 | m.m_name = obj["m_name"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
397 | m.m_amount = obj["m_amount"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
398 | m.m_type = obj["m_type"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
399 | m.m_use_use = obj["m_use_use"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
400 | m.m_time = obj["m_time"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
401 | m.m_amount_is_weight = obj["m_amount_is_weight"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
402 | m.m_cost = obj["m_cost"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
403 | /* Check and update inventory */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
404 | yquery.prepare("SELECT inventory FROM inventory_miscs WHERE name=:name"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
405 | yquery.bindValue(":name", m.m_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
406 | yquery.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
407 | if (yquery.first()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
408 | m.m_avail = true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
409 | m.m_inventory = yquery.value(0).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
410 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
411 | prod->miscs.append(m); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
412 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
413 | qDebug() << "miscs" << prod->miscs.size(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
414 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
415 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
416 | qDebug() << "empty miscs"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
417 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
418 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
419 | const auto& y_json = query.value("json_yeasts").toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
420 | if (!y_json.trimmed().isEmpty()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
421 | const auto& formattedJson = QString("%1").arg(y_json); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
422 | QJsonDocument yeasts = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
423 | if (parseError.error != QJsonParseError::NoError) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
424 | qWarning() << "Parse error: " << parseError.errorString() << "at" << parseError.offset ; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
425 | } else if (yeasts.isArray()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
426 | for (int i = 0; i < yeasts.array().size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
427 | QJsonObject obj = yeasts.array().at(i).toObject(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
428 | Yeasts y; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
429 | /* First some defaults for newer fields. */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
430 | y.y_tolerance = y.y_harvest_time = y.y_pitch_temperature = y.y_zymocide = 0; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
431 | y.y_avail = y.y_sta1 = y.y_bacteria = y.y_harvest_top = y.y_pofpos = false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
432 | y.y_gr_hl_lo = 50; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
433 | y.y_sg_lo = 1.04; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
434 | y.y_gr_hl_hi = 80; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
435 | y.y_sg_hi = 1.08; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
436 | /* Now get what we have got */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
437 | y.y_name = obj["y_name"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
438 | y.y_laboratory = obj["y_laboratory"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
439 | y.y_product_id = obj["y_product_id"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
440 | y.y_amount = obj["y_amount"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
441 | y.y_type = obj["y_type"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
442 | y.y_form = obj["y_form"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
443 | y.y_min_temperature = obj["y_min_temperature"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
444 | y.y_max_temperature = obj["y_max_temperature"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
445 | y.y_flocculation = obj["y_flocculation"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
446 | y.y_attenuation = obj["y_attenuation"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
447 | y.y_cells = obj["y_cells"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
448 | y.y_tolerance = obj["y_tolerance"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
449 | y.y_inventory = obj["y_inventory"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
450 | y.y_use = obj["y_use"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
451 | y.y_sta1 = obj["y_sta1"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
452 | y.y_bacteria = obj["y_bacteria"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
453 | y.y_harvest_top = obj["y_harvest_top"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
454 | y.y_harvest_time = obj["y_harvest_time"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
455 | y.y_pitch_temperature = obj["y_pitch_temperature"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
456 | y.y_pofpos = obj["y_pofpos"].toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
457 | y.y_zymocide = obj["y_zymocide"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
458 | y.y_gr_hl_lo = obj["y_gr_hl_lo"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
459 | y.y_sg_lo = obj["y_sg_lo"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
460 | y.y_gr_hl_hi = obj["y_gr_hl_hi"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
461 | y.y_sg_hi = obj["y_sg_hi"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
462 | y.y_cost = obj["y_cost"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
463 | /* |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
464 | * Possible data upgrade needed. |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
465 | */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
466 | yquery.prepare("SELECT tolerance,cells,sta1,bacteria,harvest_top,harvest_time,pitch_temperature," |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
467 | "pofpos,zymocide,gr_hl_lo,sg_lo,gr_hl_hi,sg_hi,inventory " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
468 | "FROM inventory_yeasts WHERE name=:name AND laboratory=:laboratory AND product_id=:product_id"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
469 | yquery.bindValue(":name", y.y_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
470 | yquery.bindValue(":laboratory", y.y_laboratory); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
471 | yquery.bindValue(":product_id", y.y_product_id); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
472 | yquery.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
473 | if (yquery.first()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
474 | if (y.y_tolerance == 0 || y.y_cells == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
475 | y.y_tolerance = yquery.value(0).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
476 | y.y_cells = yquery.value(1).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
477 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
478 | y.y_sta1 = yquery.value(2).toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
479 | y.y_bacteria = yquery.value(3).toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
480 | y.y_harvest_top = yquery.value(4).toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
481 | y.y_harvest_time = yquery.value(5).toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
482 | y.y_pitch_temperature = yquery.value(6).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
483 | y.y_pofpos = yquery.value(7).toInt() ? true:false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
484 | y.y_zymocide = yquery.value(8).toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
485 | y.y_gr_hl_lo = yquery.value(9).toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
486 | y.y_sg_lo = yquery.value(10).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
487 | y.y_gr_hl_hi = yquery.value(11).toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
488 | y.y_sg_hi = yquery.value(12).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
489 | y.y_inventory = yquery.value(13).toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
490 | y.y_avail = true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
491 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
492 | qDebug() << y.y_name << y.y_product_id << "not found for upgrade"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
493 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
494 | prod->yeasts.append(y); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
495 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
496 | qDebug() << "yeasts" << prod->yeasts.size(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
497 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
498 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
499 | qDebug() << "empty yeasts"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
500 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
501 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
502 | const auto& ma_json = query.value("json_mashs").toString().trimmed(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
503 | if (!ma_json.trimmed().isEmpty()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
504 | const auto& formattedJson = QString("%1").arg(ma_json); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
505 | QJsonDocument mashs = QJsonDocument::fromJson(formattedJson.toUtf8(), &parseError); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
506 | if (parseError.error != QJsonParseError::NoError) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
507 | qWarning() << "Parse error: " << parseError.errorString() << "at" << parseError.offset ; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
508 | } else if (mashs.isArray()) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
509 | for (int i = 0; i < mashs.array().size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
510 | QJsonObject obj = mashs.array().at(i).toObject(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
511 | Mashs m; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
512 | m.step_name = obj["step_name"].toString(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
513 | m.step_type = obj["step_type"].toInt(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
514 | m.step_volume = obj["step_volume"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
515 | m.step_infuse_amount = obj["step_infuse_amount"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
516 | m.step_infuse_temp = obj["step_infuse_temp"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
517 | m.step_temp = obj["step_temp"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
518 | m.step_time = obj["step_time"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
519 | m.ramp_time = obj["ramp_time"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
520 | m.end_temp = obj["end_temp"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
521 | m.step_wg_ratio = obj["step_wg_ratio"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
522 | m.step_ph = obj["step_ph"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
523 | m.step_sg = obj["step_sg"].toDouble(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
524 | prod->mashs.append(m); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
525 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
526 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
527 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
528 | qDebug() << "empty mashs"; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
529 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
530 | qDebug() << "mashs" << prod->mashs.size(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
531 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
532 | return true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
533 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
534 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
535 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
536 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
537 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
538 | bool DB_product::save(Product *prod, QDialog *dialog) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
539 | { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
540 | QSqlQuery query; |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
541 | QString sql = ""; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
542 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
543 | if (prod->record == -1) { |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
544 | sql = "INSERT INTO products SET "; |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
545 | } else { |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
546 | sql = "UPDATE products SET "; |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
547 | } |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
548 | sql.append("name=:name, code=:code, birth=:birth, stage=:stage, notes=:notes, log_brew=:log_brew, " |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
549 | "log_fermentation=:log_fermentation, log_ispindel=:log_ispindel, log_co2pressure=:log_co2pressure, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
550 | "inventory_reduced=:inventory_reduced, locked=:locked, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
551 | "eq_name=:eq_name, eq_boil_size=:eq_boil_size, eq_efficiency=:eq_efficiency, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
552 | "eq_batch_size=:eq_batch_size, eq_tun_volume=:eq_tun_volume, eq_tun_weight=:eq_tun_weight, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
553 | "eq_tun_specific_heat=:eq_tun_specific_heat, eq_tun_material=:eq_tun_material, eq_tun_height=:eq_tun_height, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
554 | "eq_top_up_water=:eq_top_up_water, eq_trub_chiller_loss=:eq_chiller_loss, eq_evap_rate=:eq_evap_rate, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
555 | "eq_boil_time=:eq_boil_time, eq_calc_boil_volume=:eq_calcboil, eq_top_up_kettle=:eq_top_up_kettle, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
556 | "eq_hop_utilization=:eq_hopfactor, eq_notes=:eq_notes, eq_lauter_volume=:eq_lauter_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
557 | "eq_lauter_height=:eq_lauter_height, eq_lauter_deadspace=:eq_lauter_deadspace, eq_kettle_volume=:eq_kettle_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
558 | "eq_kettle_height=:eq_kettle_height, eq_mash_volume=:eq_mash_volume, eq_mash_max=:eq_mash_max, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
559 | "brew_date_start=:brew_date_start, brew_mash_ph=:brew_mash_ph, brew_mash_sg=:brew_mash_sg, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
560 | "brew_mash_efficiency=:brew_mash_efficiency, brew_sparge_temperature=:brew_sparge_temperature, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
561 | "brew_sparge_volume=:brew_sparge_volume, brew_sparge_est=:brew_sparge_est, brew_sparge_ph=:brew_sparge_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
562 | "brew_preboil_volume=:brew_preboil_volume, brew_preboil_sg=:brew_preboil_sg, brew_preboil_ph=:brew_preboil_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
563 | "brew_preboil_efficiency=:brew_preboil_efficiency, brew_aboil_volume=:brew_aboil_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
564 | "brew_aboil_sg=:brew_aboil_sg, brew_aboil_ph=:brew_aboil_ph, brew_aboil_efficiency=:brew_aboil_efficiency, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
565 | "brew_cooling_method=:brew_cooling_method, brew_cooling_time=:brew_cooling_time, brew_cooling_to=:brew_cooling_to, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
566 | "brew_whirlpool9=:brew_whirlpool9, brew_whirlpool7=:brew_whirlpool7, brew_whirlpool6=:brew_whirlpool6, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
567 | "brew_whirlpool2=:brew_whirlpool2, brew_fermenter_volume=:brew_fermenter_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
568 | "brew_fermenter_extrawater=:brew_fermenter_extrawater, brew_fermenter_tcloss=:brew_fermenter_tcloss, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
569 | "brew_aeration_time=:brew_aeration_time, brew_aeration_speed=:brew_aeration_speed, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
570 | "brew_aeration_type=:brew_aeration_type, brew_fermenter_sg=:brew_fermenter_sg, brew_fermenter_ibu=:brew_fermenter_ibu, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
571 | "brew_fermenter_color=:brew_fermenter_color, brew_date_end=:brew_date_end, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
572 | "og=:og, fg=:fg, primary_start_temp=:primary_start_temp, primary_max_temp=:primary_max_temp, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
573 | "primary_end_temp=:primary_end_temp, primary_end_sg=:primary_end_sg, primary_end_date=:primary_end_date, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
574 | "secondary_temp=:secondary_temp, secondary_end_sg=:secondary_end_sg, secondary_end_date=:secondary_end_date, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
575 | "tertiary_temp=:tertiary_temp, package_date=:package_date, package_volume=:package_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
576 | "package_infuse_amount=:package_infuse_amount, package_infuse_abv=:package_infuse_abv, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
577 | "package_infuse_notes=:package_infuse_notes, package_abv=:package_abv, package_ph=:package_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
578 | "bottle_amount=:bottle_amount, bottle_carbonation=:bottle_carbonation, bottle_priming_sugar=:bottle_priming_sugar, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
579 | "bottle_priming_amount=:bottle_priming_amount, bottle_priming_water=:bottle_priming_water, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
580 | "bottle_carbonation_temp=:bottle_carbonation_temp, keg_amount=:keg_amount, keg_carbonation=:keg_carbonation, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
581 | "keg_priming_sugar=:keg_priming_sugar, keg_priming_amount=:keg_priming_amount, keg_priming_water=:keg_priming_water, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
582 | "keg_carbonation_temp=:keg_carbonation_temp, keg_forced_carb=:keg_forced_carb, keg_pressure=:keg_pressure, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
583 | "taste_notes=:taste_notes, taste_rate=:taste_rate, taste_date=:taste_date, taste_color=:taste_color, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
584 | "taste_transparency=:taste_transparency, taste_head=:taste_head, taste_aroma=:taste_aroma, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
585 | "taste_taste=:taste_taste, taste_mouthfeel=:taste_mouthfeel, taste_aftertaste=:taste_aftertaste, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
586 | "st_name=:st_name, st_letter=:st_letter, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
587 | "st_guide=:st_guide, st_category=:st_category, st_category_number=:st_catnr, st_type=:st_type, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
588 | "st_og_min=:st_og_min, st_og_max=:st_og_max, st_fg_min=:st_fg_min, st_fg_max=:st_fg_max, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
589 | "st_ibu_min=:st_ibu_min, st_ibu_max=:st_ibu_max, st_color_min=:st_color_min, st_color_max=:st_color_max, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
590 | "st_carb_min=:st_carb_min, st_carb_max=:st_carb_max, st_abv_min=:st_abv_min, st_abv_max=:st_abv_max, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
591 | "type=:type, batch_size=:batch_size, boil_size=:boil_size, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
592 | "boil_time=:boil_time, efficiency=:efficiency, est_og=:est_og, est_og3=:est_og3, est_fg=:est_fg, est_abv=:est_abv, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
593 | "est_color=:est_color, color_method=:color_method, est_ibu=:est_ibu, ibu_method=:ibu_method, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
594 | "est_carb=:est_carb, sparge_temp=:sparge_temp, sparge_ph=:sparge_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
595 | "sparge_volume=:sparge_volume, sparge_source=:sparge_source, sparge_acid_type=:sparge_acid_type, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
596 | "sparge_acid_perc=:sparge_acid_perc, sparge_acid_amount=:sparge_acid_amount, mash_ph=:mash_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
597 | "mash_name=:mash_name, calc_acid=:calc_acid, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
598 | "w1_name=:w1_name, w1_amount=:w1_amount, w1_calcium=:w1_calcium, w1_sulfate=:w1_sulfate, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
599 | "w1_chloride=:w1_chloride, w1_sodium=:w1_sodium, w1_magnesium=:w1_magnesium, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
600 | "w1_total_alkalinity=:w1_total_alkalinity, w1_ph=:w1_ph, w1_cost=:w1_cost, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
601 | "w2_name=:w2_name, w2_amount=:w2_amount, w2_calcium=:w2_calcium, w2_sulfate=:w2_sulfate, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
602 | "w2_chloride=:w2_chloride, w2_sodium=:w2_sodium, w2_magnesium=:w2_magnesium, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
603 | "w2_total_alkalinity=:w2_total_alkalinity, w2_ph=:w2_ph, w2_cost=:w2_cost, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
604 | "wg_amount=:wg_amount, wg_calcium=:wg_calcium, wg_sulfate=:wg_sulfate, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
605 | "wg_chloride=:wg_chloride, wg_sodium=:wg_sodium, wg_magnesium=:wg_magnesium, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
606 | "wg_total_alkalinity=:wg_total_alkalinity, wg_ph=:wg_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
607 | "wb_calcium=:wb_calcium, wb_sulfate=:wb_sulfate, wb_chloride=:wb_chloride, wb_sodium=:wb_sodium, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
608 | "wb_magnesium=:wb_magnesium, wb_total_alkalinity=:wb_total_alkalinity, wb_ph=:wb_ph, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
609 | "wa_acid_name=:wa_acid_name, wa_acid_perc=:wa_acid_perc, wa_base_name=:wa_base_name, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
610 | "starter_enable=:starter_enable, starter_type=:starter_type, starter_sg=:starter_sg, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
611 | "starter_viability=:starter_viability, yeast_prod_date=:yeast_prod_date, yeast_pitchrate=:yeast_pitchrate, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
612 | "prop1_type=:prop1_type, prop1_volume=:prop1_volume, prop2_type=:prop2_type, prop2_volume=:prop2_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
613 | "prop3_type=:prop3_type, prop3_volume=:prop3_volume, prop4_type=:prop4_type, prop4_volume=:prop4_volume, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
614 | "divide_type=:divide_type, divide_size=:divide_size, divide_factor=:divide_factor, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
615 | "divide_parts=:divide_parts, divide_part=:divide_part, " |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
616 | "json_fermentables=:json_fermentables, json_hops=:json_hops, json_miscs=:json_miscs, " |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
617 | "json_yeasts=:json_yeasts, json_mashs=:json_mashs"); |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
618 | |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
619 | if (prod->record == -1) { |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
620 | sql.append(", uuid=:uuid"); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
621 | } else { |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
622 | sql.append(" WHERE record = :recno"); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
623 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
624 | |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
625 | query.prepare(sql); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
626 | query.bindValue(":name", prod->name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
627 | query.bindValue(":code", prod->code); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
628 | query.bindValue(":birth", prod->birth); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
629 | query.bindValue(":stage", prod->stage); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
630 | query.bindValue(":notes", prod->notes); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
631 | query.bindValue(":log_brew", prod->log_brew ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
632 | query.bindValue(":log_fermentation", prod->log_fermentation ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
633 | query.bindValue(":log_ispindel", prod->log_ispindel ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
634 | query.bindValue(":log_co2pressure", prod->log_co2pressure ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
635 | query.bindValue(":inventory_reduced", prod->inventory_reduced); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
636 | query.bindValue(":locked", prod->locked ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
637 | query.bindValue(":eq_name", prod->eq_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
638 | query.bindValue(":eq_boil_size", round(prod->eq_boil_size * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
639 | query.bindValue(":eq_batch_size", round(prod->eq_batch_size * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
640 | query.bindValue(":eq_tun_volume", round(prod->eq_tun_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
641 | query.bindValue(":eq_tun_weight", round(prod->eq_tun_weight * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
642 | query.bindValue(":eq_tun_specific_heat", round(prod->eq_tun_specific_heat * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
643 | query.bindValue(":eq_tun_material", prod->eq_tun_material); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
644 | query.bindValue(":eq_tun_height", round(prod->eq_tun_height * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
645 | query.bindValue(":eq_top_up_water", round(prod->eq_top_up_water * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
646 | query.bindValue(":eq_chiller_loss", round(prod->eq_trub_chiller_loss * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
647 | query.bindValue(":eq_evap_rate", round(prod->eq_evap_rate * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
648 | query.bindValue(":eq_boil_time", round(prod->eq_boil_time)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
649 | query.bindValue(":eq_calcboil", prod->eq_calc_boil_volume ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
650 | query.bindValue(":eq_top_up_kettle", round(prod->eq_top_up_kettle * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
651 | query.bindValue(":eq_hopfactor", round(prod->eq_hop_utilization)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
652 | query.bindValue(":eq_notes", prod->eq_notes); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
653 | query.bindValue(":eq_lauter_volume", round(prod->eq_lauter_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
654 | query.bindValue(":eq_lauter_height", round(prod->eq_lauter_height * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
655 | query.bindValue(":eq_lauter_deadspace", round(prod->eq_lauter_deadspace * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
656 | query.bindValue(":eq_kettle_volume", round(prod->eq_kettle_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
657 | query.bindValue(":eq_kettle_height", round(prod->eq_kettle_height * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
658 | query.bindValue(":eq_mash_volume", round(prod->eq_mash_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
659 | query.bindValue(":eq_mash_max", round(prod->eq_mash_max * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
660 | query.bindValue(":eq_efficiency", round(prod->eq_efficiency * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
661 | query.bindValue(":brew_date_start", prod->brew_date_start); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
662 | query.bindValue(":brew_mash_ph", round(prod->brew_mash_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
663 | query.bindValue(":brew_mash_sg", round(prod->brew_mash_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
664 | query.bindValue(":brew_mash_efficiency", round(prod->brew_mash_efficiency * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
665 | query.bindValue(":brew_sparge_temperature", round(prod->brew_sparge_temperature * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
666 | query.bindValue(":brew_sparge_volume", round(prod->brew_sparge_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
667 | query.bindValue(":brew_sparge_est", round(prod->brew_sparge_est * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
668 | query.bindValue(":brew_sparge_ph", round(prod->brew_sparge_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
669 | query.bindValue(":brew_preboil_volume", round(prod->brew_preboil_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
670 | query.bindValue(":brew_preboil_sg", round(prod->brew_preboil_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
671 | query.bindValue(":brew_preboil_ph", round(prod->brew_preboil_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
672 | query.bindValue(":brew_preboil_efficiency", round(prod->brew_preboil_efficiency * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
673 | query.bindValue(":brew_aboil_volume", round(prod->brew_aboil_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
674 | query.bindValue(":brew_aboil_sg", round(prod->brew_aboil_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
675 | query.bindValue(":brew_aboil_ph", round(prod->brew_aboil_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
676 | query.bindValue(":brew_aboil_efficiency", round(prod->brew_aboil_efficiency * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
677 | query.bindValue(":brew_cooling_method", prod->brew_cooling_method); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
678 | query.bindValue(":brew_cooling_time", round(prod->brew_cooling_time * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
679 | query.bindValue(":brew_cooling_to", round(prod->brew_cooling_to * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
680 | query.bindValue(":brew_whirlpool9", round(prod->brew_whirlpool9)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
681 | query.bindValue(":brew_whirlpool7", round(prod->brew_whirlpool7)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
682 | query.bindValue(":brew_whirlpool6", round(prod->brew_whirlpool6)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
683 | query.bindValue(":brew_whirlpool2", round(prod->brew_whirlpool2)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
684 | query.bindValue(":brew_fermenter_volume", round(prod->brew_fermenter_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
685 | query.bindValue(":brew_fermenter_extrawater", round(prod->brew_fermenter_extrawater * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
686 | query.bindValue(":brew_fermenter_tcloss", round(prod->brew_fermenter_tcloss * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
687 | query.bindValue(":brew_aeration_time", round(prod->brew_aeration_time)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
688 | query.bindValue(":brew_aeration_speed", round(prod->brew_aeration_speed * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
689 | query.bindValue(":brew_aeration_type", prod->brew_aeration_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
690 | query.bindValue(":brew_fermenter_sg", round(prod->brew_fermenter_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
691 | query.bindValue(":brew_fermenter_ibu", round(prod->brew_fermenter_ibu * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
692 | query.bindValue(":brew_fermenter_color", round(prod->brew_fermenter_color * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
693 | query.bindValue(":brew_date_end", prod->brew_date_end); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
694 | query.bindValue(":og", round(prod->og * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
695 | query.bindValue(":fg", round(prod->fg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
696 | query.bindValue(":primary_start_temp", round(prod->primary_start_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
697 | query.bindValue(":primary_max_temp", round(prod->primary_max_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
698 | query.bindValue(":primary_end_temp", round(prod->primary_end_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
699 | query.bindValue(":primary_end_sg", round(prod->primary_end_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
700 | query.bindValue(":primary_end_date", prod->primary_end_date); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
701 | query.bindValue(":secondary_temp", round(prod->secondary_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
702 | query.bindValue(":secondary_end_sg", round(prod->secondary_end_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
703 | query.bindValue(":secondary_end_date", prod->secondary_end_date); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
704 | query.bindValue(":tertiary_temp", round(prod->tertiary_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
705 | query.bindValue(":package_date", prod->package_date); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
706 | query.bindValue(":package_volume", round(prod->package_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
707 | query.bindValue(":package_infuse_amount", round(prod->package_infuse_amount * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
708 | query.bindValue(":package_infuse_abv", round(prod->package_infuse_abv * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
709 | query.bindValue(":package_infuse_notes", prod->package_infuse_notes); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
710 | query.bindValue(":package_abv", round(prod->package_abv * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
711 | query.bindValue(":package_ph", round(prod->package_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
712 | query.bindValue(":bottle_amount", round(prod->bottle_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
713 | query.bindValue(":bottle_carbonation", round(prod->bottle_carbonation * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
714 | query.bindValue(":bottle_priming_sugar", prod->bottle_priming_sugar); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
715 | query.bindValue(":bottle_priming_amount", round(prod->bottle_priming_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
716 | query.bindValue(":bottle_priming_water", round(prod->bottle_priming_water * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
717 | query.bindValue(":bottle_carbonation_temp", round(prod->bottle_carbonation_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
718 | query.bindValue(":keg_amount", round(prod->keg_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
719 | query.bindValue(":keg_carbonation", round(prod->keg_carbonation * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
720 | query.bindValue(":keg_priming_sugar", prod->keg_priming_sugar); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
721 | query.bindValue(":keg_priming_amount", round(prod->keg_priming_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
722 | query.bindValue(":keg_priming_water", round(prod->keg_priming_water * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
723 | query.bindValue(":keg_carbonation_temp", round(prod->keg_carbonation_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
724 | query.bindValue(":keg_forced_carb", prod->keg_forced_carb ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
725 | query.bindValue(":keg_pressure", round(prod->keg_pressure * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
726 | query.bindValue(":taste_notes", prod->taste_notes); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
727 | query.bindValue(":taste_rate", round(prod->taste_rate * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
728 | query.bindValue(":taste_date", prod->taste_date); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
729 | query.bindValue(":taste_color", prod->taste_color); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
730 | query.bindValue(":taste_transparency", prod->taste_transparency); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
731 | query.bindValue(":taste_head", prod->taste_head); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
732 | query.bindValue(":taste_aroma", prod->taste_aroma); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
733 | query.bindValue(":taste_taste", prod->taste_taste); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
734 | query.bindValue(":taste_mouthfeel", prod->taste_mouthfeel); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
735 | query.bindValue(":taste_aftertaste", prod->taste_aftertaste); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
736 | query.bindValue(":st_name", prod->st_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
737 | query.bindValue(":st_letter", prod->st_letter); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
738 | query.bindValue(":st_guide", prod->st_guide); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
739 | query.bindValue(":st_category", prod->st_category); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
740 | query.bindValue(":st_catnr", prod->st_category_number); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
741 | query.bindValue(":st_type", prod->st_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
742 | query.bindValue(":st_og_min", round(prod->st_og_min * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
743 | query.bindValue(":st_og_max", round(prod->st_og_max * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
744 | query.bindValue(":st_fg_min", round(prod->st_fg_min * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
745 | query.bindValue(":st_fg_max", round(prod->st_fg_max * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
746 | query.bindValue(":st_ibu_min", round(prod->st_ibu_min * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
747 | query.bindValue(":st_ibu_max", round(prod->st_ibu_max * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
748 | query.bindValue(":st_color_min", round(prod->st_color_min * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
749 | query.bindValue(":st_color_max", round(prod->st_color_max * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
750 | query.bindValue(":st_carb_min", round(prod->st_carb_min * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
751 | query.bindValue(":st_carb_max", round(prod->st_carb_max * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
752 | query.bindValue(":st_abv_min", round(prod->st_abv_min * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
753 | query.bindValue(":st_abv_max", round(prod->st_abv_max * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
754 | query.bindValue(":type", prod->type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
755 | query.bindValue(":batch_size", round(prod->batch_size * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
756 | query.bindValue(":boil_size", round(prod->boil_size * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
757 | query.bindValue(":boil_time", round(prod->boil_time * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
758 | query.bindValue(":efficiency", round(prod->efficiency * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
759 | query.bindValue(":est_og", round(prod->est_og * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
760 | query.bindValue(":est_og3", round(prod->est_og3 * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
761 | query.bindValue(":est_fg", round(prod->est_fg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
762 | query.bindValue(":est_abv", round(prod->est_abv * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
763 | query.bindValue(":est_color", round(prod->est_color * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
764 | query.bindValue(":color_method", prod->color_method); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
765 | query.bindValue(":est_ibu", round(prod->est_ibu * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
766 | query.bindValue(":ibu_method", prod->ibu_method); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
767 | query.bindValue(":est_carb", round(prod->est_carb * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
768 | query.bindValue(":sparge_temp", round(prod->sparge_temp * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
769 | query.bindValue(":sparge_ph", round(prod->sparge_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
770 | query.bindValue(":sparge_volume", round(prod->sparge_volume * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
771 | query.bindValue(":sparge_source", prod->sparge_source); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
772 | query.bindValue(":sparge_acid_type", prod->sparge_acid_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
773 | query.bindValue(":sparge_acid_perc", round(prod->sparge_acid_perc * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
774 | query.bindValue(":sparge_acid_amount", round(prod->sparge_acid_amount * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
775 | query.bindValue(":mash_ph", round(prod->mash_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
776 | query.bindValue(":mash_name", prod->mash_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
777 | query.bindValue(":calc_acid", prod->calc_acid ?1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
778 | query.bindValue(":w1_name", prod->w1_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
779 | query.bindValue(":w1_amount", round(prod->w1_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
780 | query.bindValue(":w1_calcium", round(prod->w1_calcium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
781 | query.bindValue(":w1_sulfate", round(prod->w1_sulfate * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
782 | query.bindValue(":w1_chloride", round(prod->w1_chloride * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
783 | query.bindValue(":w1_sodium", round(prod->w1_sodium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
784 | query.bindValue(":w1_magnesium", round(prod->w1_magnesium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
785 | query.bindValue(":w1_total_alkalinity", round(prod->w1_total_alkalinity * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
786 | query.bindValue(":w1_ph", round(prod->w1_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
787 | query.bindValue(":w1_cost", round(prod->w1_cost * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
788 | query.bindValue(":w2_name", prod->w2_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
789 | query.bindValue(":w2_amount", round(prod->w2_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
790 | query.bindValue(":w2_calcium", round(prod->w2_calcium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
791 | query.bindValue(":w2_sulfate", round(prod->w2_sulfate * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
792 | query.bindValue(":w2_chloride", round(prod->w2_chloride * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
793 | query.bindValue(":w2_sodium", round(prod->w2_sodium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
794 | query.bindValue(":w2_magnesium", round(prod->w2_magnesium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
795 | query.bindValue(":w2_total_alkalinity", round(prod->w2_total_alkalinity * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
796 | query.bindValue(":w2_ph", round(prod->w2_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
797 | query.bindValue(":w2_cost", round(prod->w2_cost * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
798 | query.bindValue(":wg_amount", round(prod->wg_amount * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
799 | query.bindValue(":wg_calcium", round(prod->wg_calcium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
800 | query.bindValue(":wg_sulfate", round(prod->wg_sulfate * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
801 | query.bindValue(":wg_chloride", round(prod->wg_chloride * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
802 | query.bindValue(":wg_sodium", round(prod->wg_sodium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
803 | query.bindValue(":wg_magnesium", round(prod->wg_magnesium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
804 | query.bindValue(":wg_total_alkalinity", round(prod->wg_total_alkalinity * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
805 | query.bindValue(":wg_ph", round(prod->wg_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
806 | query.bindValue(":wb_calcium", round(prod->wb_calcium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
807 | query.bindValue(":wb_sulfate", round(prod->wb_sulfate * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
808 | query.bindValue(":wb_chloride", round(prod->wb_chloride * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
809 | query.bindValue(":wb_sodium", round(prod->wb_sodium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
810 | query.bindValue(":wb_magnesium", round(prod->wb_magnesium * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
811 | query.bindValue(":wb_total_alkalinity", round(prod->wb_total_alkalinity * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
812 | query.bindValue(":wb_ph", round(prod->wb_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
813 | query.bindValue(":wa_acid_name", prod->wa_acid_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
814 | query.bindValue(":wa_acid_perc", round(prod->wa_acid_perc * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
815 | query.bindValue(":wa_base_name", prod->wa_base_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
816 | query.bindValue(":starter_enable", prod->starter_enable ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
817 | query.bindValue(":starter_type", prod->starter_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
818 | query.bindValue(":starter_sg", round(prod->starter_sg * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
819 | query.bindValue(":starter_viability", prod->starter_viability); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
820 | query.bindValue(":yeast_prod_date", prod->yeast_prod_date); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
821 | query.bindValue(":yeast_pitchrate", round(prod->yeast_pitchrate * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
822 | query.bindValue(":prop1_type", prod->prop_type[0]); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
823 | query.bindValue(":prop1_volume", round(prod->prop_volume[0] * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
824 | query.bindValue(":prop2_type", prod->prop_type[1]); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
825 | query.bindValue(":prop2_volume", round(prod->prop_volume[1] * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
826 | query.bindValue(":prop3_type", prod->prop_type[2]); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
827 | query.bindValue(":prop3_volume", round(prod->prop_volume[2] * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
828 | query.bindValue(":prop4_type", prod->prop_type[3]); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
829 | query.bindValue(":prop4_volume", round(prod->prop_volume[3] * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
830 | query.bindValue(":divide_type", prod->divide_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
831 | query.bindValue(":divide_size", round(prod->divide_size * 10) / 10); |
270
a0f72d7ace1f
Added create splitted batches. Fixed rounding amount values at several places.
Michiel Broek <mbroek@mbse.eu>
parents:
262
diff
changeset
|
832 | query.bindValue(":divide_factor", round(prod->divide_factor * 10000) / 10000); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
833 | query.bindValue(":divide_parts", prod->divide_parts); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
834 | query.bindValue(":divide_part", prod->divide_part); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
835 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
836 | if (prod->fermentables.size() == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
837 | query.bindValue(":json_fermentables", "[]"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
838 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
839 | QJsonArray array; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
840 | for (int i = 0; i < prod->fermentables.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
841 | QJsonObject obj; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
842 | obj.insert("f_name", prod->fermentables.at(i).f_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
843 | obj.insert("f_origin", prod->fermentables.at(i).f_origin); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
844 | obj.insert("f_supplier", prod->fermentables.at(i).f_supplier); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
845 | obj.insert("f_amount", round(prod->fermentables.at(i).f_amount * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
846 | obj.insert("f_cost", round(prod->fermentables.at(i).f_cost * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
847 | obj.insert("f_type", prod->fermentables.at(i).f_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
848 | obj.insert("f_yield", round(prod->fermentables.at(i).f_yield * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
849 | obj.insert("f_color", round(prod->fermentables.at(i).f_color * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
850 | obj.insert("f_coarse_fine_diff", round(prod->fermentables.at(i).f_coarse_fine_diff * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
851 | obj.insert("f_moisture", round(prod->fermentables.at(i).f_moisture * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
852 | obj.insert("f_diastatic_power", round(prod->fermentables.at(i).f_diastatic_power * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
853 | obj.insert("f_protein", round(prod->fermentables.at(i).f_protein * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
854 | obj.insert("f_dissolved_protein", round(prod->fermentables.at(i).f_dissolved_protein * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
855 | obj.insert("f_max_in_batch", prod->fermentables.at(i).f_max_in_batch); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
856 | obj.insert("f_graintype", prod->fermentables.at(i).f_graintype); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
857 | obj.insert("f_added", prod->fermentables.at(i).f_added); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
858 | obj.insert("f_recommend_mash", prod->fermentables.at(i).f_recommend_mash ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
859 | obj.insert("f_add_after_boil", prod->fermentables.at(i).f_add_after_boil ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
860 | obj.insert("f_adjust_to_total_100", prod->fermentables.at(i).f_adjust_to_total_100 ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
861 | obj.insert("f_percentage", round(prod->fermentables.at(i).f_percentage * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
862 | obj.insert("f_di_ph", round(prod->fermentables.at(i).f_di_ph * 100000) / 100000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
863 | obj.insert("f_acid_to_ph_57", round(prod->fermentables.at(i).f_acid_to_ph_57 * 100000) / 100000); |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
864 | // qDebug() << "fermentables_Json" << i << obj; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
865 | array.append(obj); /* Append this object */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
866 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
867 | QJsonDocument doc; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
868 | doc.setArray(array); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
869 | query.bindValue(":json_fermentables", doc.toJson(QJsonDocument::Compact)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
870 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
871 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
872 | if (prod->hops.size() == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
873 | query.bindValue(":json_hops", "[]"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
874 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
875 | QJsonArray array; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
876 | for (int i = 0; i < prod->hops.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
877 | QJsonObject obj; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
878 | obj.insert("h_name", prod->hops.at(i).h_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
879 | obj.insert("h_origin", prod->hops.at(i).h_origin); |
270
a0f72d7ace1f
Added create splitted batches. Fixed rounding amount values at several places.
Michiel Broek <mbroek@mbse.eu>
parents:
262
diff
changeset
|
880 | obj.insert("h_amount", round(prod->hops.at(i).h_amount * 100000) / 100000); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
881 | obj.insert("h_cost", round(prod->hops.at(i).h_cost * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
882 | obj.insert("h_type", prod->hops.at(i).h_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
883 | obj.insert("h_form", prod->hops.at(i).h_form); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
884 | obj.insert("h_useat", prod->hops.at(i).h_useat); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
885 | obj.insert("h_time", round(prod->hops.at(i).h_time)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
886 | obj.insert("h_alpha", round(prod->hops.at(i).h_alpha * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
887 | obj.insert("h_beta", round(prod->hops.at(i).h_beta * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
888 | obj.insert("h_hsi", round(prod->hops.at(i).h_hsi * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
889 | obj.insert("h_humulene", round(prod->hops.at(i).h_humulene * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
890 | obj.insert("h_caryophyllene", round(prod->hops.at(i).h_caryophyllene * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
891 | obj.insert("h_cohumulone", round(prod->hops.at(i).h_cohumulone * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
892 | obj.insert("h_myrcene", round(prod->hops.at(i).h_myrcene * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
893 | obj.insert("h_total_oil", round(prod->hops.at(i).h_total_oil * 100) / 100); |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
894 | // qDebug() << "hops_Json" << i << obj; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
895 | array.append(obj); /* Append this object */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
896 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
897 | QJsonDocument doc; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
898 | doc.setArray(array); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
899 | query.bindValue(":json_hops", doc.toJson(QJsonDocument::Compact)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
900 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
901 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
902 | if (prod->miscs.size() == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
903 | query.bindValue(":json_miscs", "[]"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
904 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
905 | QJsonArray array; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
906 | for (int i = 0; i < prod->miscs.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
907 | QJsonObject obj; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
908 | obj.insert("m_name", prod->miscs.at(i).m_name); |
270
a0f72d7ace1f
Added create splitted batches. Fixed rounding amount values at several places.
Michiel Broek <mbroek@mbse.eu>
parents:
262
diff
changeset
|
909 | obj.insert("m_amount", round(prod->miscs.at(i).m_amount * 100000) / 100000); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
910 | obj.insert("m_type", prod->miscs.at(i).m_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
911 | obj.insert("m_use_use", prod->miscs.at(i).m_use_use); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
912 | obj.insert("m_time", round(prod->miscs.at(i).m_time)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
913 | obj.insert("m_amount_is_weight", prod->miscs.at(i).m_amount_is_weight ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
914 | obj.insert("m_cost", round(prod->miscs.at(i).m_cost * 10000) / 10000); |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
915 | // qDebug() << "miscs_Json" << i << obj; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
916 | array.append(obj); /* Append this object */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
917 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
918 | QJsonDocument doc; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
919 | doc.setArray(array); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
920 | query.bindValue(":json_miscs", doc.toJson(QJsonDocument::Compact)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
921 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
922 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
923 | if (prod->yeasts.size() == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
924 | query.bindValue(":json_yeasts", "[]"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
925 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
926 | QJsonArray array; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
927 | for (int i = 0; i < prod->yeasts.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
928 | QJsonObject obj; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
929 | obj.insert("y_name", prod->yeasts.at(i).y_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
930 | obj.insert("y_laboratory", prod->yeasts.at(i).y_laboratory); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
931 | obj.insert("y_product_id", prod->yeasts.at(i).y_product_id); |
270
a0f72d7ace1f
Added create splitted batches. Fixed rounding amount values at several places.
Michiel Broek <mbroek@mbse.eu>
parents:
262
diff
changeset
|
932 | obj.insert("y_amount", round(prod->yeasts.at(i).y_amount * 100000) / 100000); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
933 | obj.insert("y_type", prod->yeasts.at(i).y_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
934 | obj.insert("y_form", prod->yeasts.at(i).y_form); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
935 | obj.insert("y_min_temperature", round(prod->yeasts.at(i).y_min_temperature * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
936 | obj.insert("y_max_temperature", round(prod->yeasts.at(i).y_max_temperature * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
937 | obj.insert("y_flocculation", prod->yeasts.at(i).y_flocculation); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
938 | obj.insert("y_attenuation", round(prod->yeasts.at(i).y_attenuation * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
939 | obj.insert("y_cells", prod->yeasts.at(i).y_cells); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
940 | obj.insert("y_tolerance", round(prod->yeasts.at(i).y_tolerance * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
941 | obj.insert("y_inventory", round(prod->yeasts.at(i).y_inventory * 10000) / 10000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
942 | obj.insert("y_use", prod->yeasts.at(i).y_use); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
943 | obj.insert("y_sta1", prod->yeasts.at(i).y_sta1 ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
944 | obj.insert("y_bacteria", prod->yeasts.at(i).y_bacteria ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
945 | obj.insert("y_harvest_top", prod->yeasts.at(i).y_harvest_top ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
946 | obj.insert("y_harvest_time", prod->yeasts.at(i).y_harvest_time); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
947 | obj.insert("y_pitch_temperature", round(prod->yeasts.at(i).y_pitch_temperature * 10) / 10); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
948 | obj.insert("y_pofpos", prod->yeasts.at(i).y_pofpos ? 1:0); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
949 | obj.insert("y_zymocide", prod->yeasts.at(i).y_zymocide); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
950 | obj.insert("y_gr_hl_lo", prod->yeasts.at(i).y_gr_hl_lo); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
951 | obj.insert("y_sg_lo", round(prod->yeasts.at(i).y_sg_lo * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
952 | obj.insert("y_gr_hl_hi", prod->yeasts.at(i).y_gr_hl_hi); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
953 | obj.insert("y_sg_hi", round(prod->yeasts.at(i).y_sg_hi * 1000) / 1000); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
954 | obj.insert("y_cost", round(prod->yeasts.at(i).y_cost * 1000) / 1000); |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
955 | // qDebug() << "yeasts_Json" << i << obj; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
956 | array.append(obj); /* Append this object */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
957 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
958 | QJsonDocument doc; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
959 | doc.setArray(array); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
960 | query.bindValue(":json_yeasts", doc.toJson(QJsonDocument::Compact)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
961 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
962 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
963 | if (prod->mashs.size() == 0) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
964 | query.bindValue(":json_mashs", "[]"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
965 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
966 | QJsonArray array; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
967 | for (int i = 0; i < prod->mashs.size(); i++) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
968 | QJsonObject obj; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
969 | obj.insert("step_name", prod->mashs.at(i).step_name); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
970 | obj.insert("step_type", prod->mashs.at(i).step_type); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
971 | obj.insert("step_volume", round(prod->mashs.at(i).step_volume * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
972 | obj.insert("step_infuse_amount", round(prod->mashs.at(i).step_infuse_amount * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
973 | obj.insert("step_infuse_temp", round(prod->mashs.at(i).step_infuse_temp * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
974 | obj.insert("step_temp", round(prod->mashs.at(i).step_temp * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
975 | obj.insert("step_time", round(prod->mashs.at(i).step_time * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
976 | obj.insert("ramp_time", round(prod->mashs.at(i).ramp_time * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
977 | obj.insert("end_temp", round(prod->mashs.at(i).end_temp * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
978 | obj.insert("step_wg_ratio", round(prod->mashs.at(i).step_wg_ratio * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
979 | obj.insert("step_ph", round(prod->mashs.at(i).step_ph * 100) / 100); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
980 | obj.insert("step_sg", round(prod->mashs.at(i).step_sg * 10000) / 10000); |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
981 | // qDebug() << "mashs_Json" << i << obj; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
982 | array.append(obj); /* Append this object */ |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
983 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
984 | QJsonDocument doc; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
985 | doc.setArray(array); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
986 | query.bindValue(":json_mashs", doc.toJson(QJsonDocument::Compact)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
987 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
988 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
989 | if (prod->record == -1) { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
990 | query.bindValue(":uuid", QUuid::createUuid().toString().mid(1, 36)); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
991 | } else { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
992 | query.bindValue(":recno", prod->record); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
993 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
994 | query.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
995 | if (query.lastError().isValid()) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
996 | qWarning() << "saveProduct" << query.lastError(); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
997 | QMessageBox::warning(dialog, QObject::tr("Database error"), |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
998 | QObject::tr("MySQL error: %1\n%2\n%3") |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
999 | .arg(query.lastError().nativeErrorCode()) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1000 | .arg(query.lastError().driverText()) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1001 | .arg(query.lastError().databaseText())); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1002 | return false; |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1003 | } |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1004 | |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1005 | /* |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1006 | * If this was a new product, find out what record number we |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1007 | * have got and set it. So when the user saves this record |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1008 | * again, it will be updated instead of inserting a new copy. |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1009 | */ |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1010 | if (prod->record < 0) { |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1011 | QVariant id = query.lastInsertId(); |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1012 | prod->record = id.toInt(); |
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1013 | qInfo() << "saveProduct Inserted record" << prod->record; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1014 | } else { |
262
6bab9440aeb9
Code cleanup in database functions.
Michiel Broek <mbroek@mbse.eu>
parents:
256
diff
changeset
|
1015 | qInfo() << "saveProduct Updated record" << prod->record; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1016 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1017 | return true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1018 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1019 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1020 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1021 | bool DB_product::dele(QDialog *dialog, int recno) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1022 | { |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1023 | QSqlQuery query; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1024 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1025 | query.prepare("DELETE FROM products WHERE record = :recno"); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1026 | query.bindValue(":recno", recno); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1027 | query.exec(); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1028 | if (query.lastError().isValid()) { |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
1029 | qWarning() << "deleteProduct" << query.lastError(); |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1030 | QMessageBox::warning(dialog, QObject::tr("Database error"), |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1031 | QObject::tr("MySQL error: %1\n%2\n%3") |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1032 | .arg(query.lastError().nativeErrorCode()) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1033 | .arg(query.lastError().driverText()) |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1034 | .arg(query.lastError().databaseText())); |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1035 | return false; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1036 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1037 | |
256
c136bd15b084
Make use of new logging handler.
Michiel Broek <mbroek@mbse.eu>
parents:
248
diff
changeset
|
1038 | qInfo() << "deleteProduct Deleted" << recno; |
248
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1039 | return true; |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1040 | } |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1041 | |
1a7a5dffba58
Moved product record load, save and delete to a separate file and use passed record data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1042 |