comparison: src/database/db_product.cpp
src/database/db_product.cpp
- changeset 423
- 8cb46020796a
- parent 384
- d68826df8b63
- child 432
- f189af715073
equal
deleted
inserted
replaced
| 422:d7907c91f746 | 423:8cb46020796a |
|---|---|
| 62 prod->eq_tun_height = query.value("eq_tun_height").toDouble(); | 62 prod->eq_tun_height = query.value("eq_tun_height").toDouble(); |
| 63 prod->eq_top_up_water = query.value("eq_top_up_water").toDouble(); | 63 prod->eq_top_up_water = query.value("eq_top_up_water").toDouble(); |
| 64 prod->eq_trub_chiller_loss = query.value("eq_trub_chiller_loss").toDouble(); | 64 prod->eq_trub_chiller_loss = query.value("eq_trub_chiller_loss").toDouble(); |
| 65 prod->eq_evap_rate = query.value("eq_evap_rate").toDouble(); | 65 prod->eq_evap_rate = query.value("eq_evap_rate").toDouble(); |
| 66 prod->eq_boil_time = query.value("eq_boil_time").toDouble(); | 66 prod->eq_boil_time = query.value("eq_boil_time").toDouble(); |
| 67 prod->eq_calc_boil_volume = query.value("eq_calc_boil_volume").toInt() ? true:false; | 67 // prod->eq_calc_boil_volume = query.value("eq_calc_boil_volume").toInt() ? true:false; |
| 68 prod->eq_top_up_kettle = query.value("eq_top_up_kettle").toDouble(); | 68 prod->eq_top_up_kettle = query.value("eq_top_up_kettle").toDouble(); |
| 69 prod->eq_hop_utilization = query.value("eq_hop_utilization").toDouble(); | 69 // prod->eq_hop_utilization = query.value("eq_hop_utilization").toDouble(); |
| 70 prod->eq_lauter_volume = query.value("eq_lauter_volume").toDouble(); | 70 // prod->eq_lauter_volume = query.value("eq_lauter_volume").toDouble(); |
| 71 prod->eq_lauter_height = query.value("eq_lauter_height").toDouble(); | 71 // prod->eq_lauter_height = query.value("eq_lauter_height").toDouble(); |
| 72 prod->eq_lauter_deadspace = query.value("eq_lauter_deadspace").toDouble(); | 72 prod->eq_lauter_deadspace = query.value("eq_lauter_deadspace").toDouble(); |
| 73 prod->eq_kettle_volume = query.value("eq_kettle_volume").toDouble(); | 73 prod->eq_kettle_volume = query.value("eq_kettle_volume").toDouble(); |
| 74 prod->eq_kettle_height = query.value("eq_kettle_height").toDouble(); | 74 prod->eq_kettle_height = query.value("eq_kettle_height").toDouble(); |
| 75 prod->eq_mash_volume = query.value("eq_mash_volume").toDouble(); | 75 prod->eq_mash_volume = query.value("eq_mash_volume").toDouble(); |
| 76 prod->eq_mash_max = query.value("eq_mash_max").toDouble(); | 76 prod->eq_mash_max = query.value("eq_mash_max").toDouble(); |
| 77 prod->eq_efficiency = query.value("eq_efficiency").toDouble(); | 77 prod->eq_efficiency = query.value("eq_efficiency").toDouble(); |
| 78 prod->eq_chiller_type = query.value("eq_chiller_type").toInt(); | |
| 79 prod->eq_chiller_to79 = query.value("eq_chiller_to79").toDouble(); | |
| 80 prod->eq_chiller_volume = query.value("eq_chiller_volume").toDouble(); | |
| 81 prod->eq_chiller_lpm = query.value("eq_chiller_lpm").toDouble(); | |
| 82 prod->eq_chiller_loss = query.value("eq_chiller_loss").toDouble(); | |
| 78 | 83 |
| 79 prod->brew_date_start = query.value("brew_date_start").toDateTime(); | 84 prod->brew_date_start = query.value("brew_date_start").toDateTime(); |
| 80 prod->brew_mash_ph = query.value("brew_mash_ph").toDouble(); | 85 prod->brew_mash_ph = query.value("brew_mash_ph").toDouble(); |
| 81 prod->brew_mash_sg = query.value("brew_mash_sg").toDouble(); | 86 prod->brew_mash_sg = query.value("brew_mash_sg").toDouble(); |
| 82 prod->brew_mash_efficiency = query.value("brew_mash_efficiency").toDouble(); | 87 prod->brew_mash_efficiency = query.value("brew_mash_efficiency").toDouble(); |
| 559 "inventory_reduced=:inventory_reduced, locked=:locked, " | 564 "inventory_reduced=:inventory_reduced, locked=:locked, " |
| 560 "eq_name=:eq_name, eq_boil_size=:eq_boil_size, eq_efficiency=:eq_efficiency, " | 565 "eq_name=:eq_name, eq_boil_size=:eq_boil_size, eq_efficiency=:eq_efficiency, " |
| 561 "eq_batch_size=:eq_batch_size, eq_tun_volume=:eq_tun_volume, eq_tun_weight=:eq_tun_weight, " | 566 "eq_batch_size=:eq_batch_size, eq_tun_volume=:eq_tun_volume, eq_tun_weight=:eq_tun_weight, " |
| 562 "eq_tun_specific_heat=:eq_tun_specific_heat, eq_tun_material=:eq_tun_material, eq_tun_height=:eq_tun_height, " | 567 "eq_tun_specific_heat=:eq_tun_specific_heat, eq_tun_material=:eq_tun_material, eq_tun_height=:eq_tun_height, " |
| 563 "eq_top_up_water=:eq_top_up_water, eq_trub_chiller_loss=:eq_chiller_loss, eq_evap_rate=:eq_evap_rate, " | 568 "eq_top_up_water=:eq_top_up_water, eq_trub_chiller_loss=:eq_chiller_loss, eq_evap_rate=:eq_evap_rate, " |
| 564 "eq_boil_time=:eq_boil_time, eq_calc_boil_volume=:eq_calcboil, eq_top_up_kettle=:eq_top_up_kettle, " | 569 "eq_boil_time=:eq_boil_time, eq_top_up_kettle=:eq_top_up_kettle, eq_notes=:eq_notes, " |
| 565 "eq_hop_utilization=:eq_hopfactor, eq_notes=:eq_notes, eq_lauter_volume=:eq_lauter_volume, " | 570 "eq_lauter_deadspace=:eq_lauter_deadspace, eq_kettle_volume=:eq_kettle_volume, " |
| 566 "eq_lauter_height=:eq_lauter_height, eq_lauter_deadspace=:eq_lauter_deadspace, eq_kettle_volume=:eq_kettle_volume, " | |
| 567 "eq_kettle_height=:eq_kettle_height, eq_mash_volume=:eq_mash_volume, eq_mash_max=:eq_mash_max, " | 571 "eq_kettle_height=:eq_kettle_height, eq_mash_volume=:eq_mash_volume, eq_mash_max=:eq_mash_max, " |
| 572 "eq_chiller_type=:eq_chiller_type, eq_chiller_to79=:eq_chiller_to79, eq_chiller_volume=:eq_chiller_volume, " | |
| 573 "eq_chiller_lpm=:eq_chiller_lpm, eq_chiller_loss=:eq_chiller_loss, " | |
| 568 "brew_date_start=:brew_date_start, brew_mash_ph=:brew_mash_ph, brew_mash_sg=:brew_mash_sg, " | 574 "brew_date_start=:brew_date_start, brew_mash_ph=:brew_mash_ph, brew_mash_sg=:brew_mash_sg, " |
| 569 "brew_mash_efficiency=:brew_mash_efficiency, brew_sparge_temperature=:brew_sparge_temperature, " | 575 "brew_mash_efficiency=:brew_mash_efficiency, brew_sparge_temperature=:brew_sparge_temperature, " |
| 570 "brew_sparge_volume=:brew_sparge_volume, brew_sparge_est=:brew_sparge_est, brew_sparge_ph=:brew_sparge_ph, " | 576 "brew_sparge_volume=:brew_sparge_volume, brew_sparge_est=:brew_sparge_est, brew_sparge_ph=:brew_sparge_ph, " |
| 571 "brew_preboil_volume=:brew_preboil_volume, brew_preboil_sg=:brew_preboil_sg, brew_preboil_ph=:brew_preboil_ph, " | 577 "brew_preboil_volume=:brew_preboil_volume, brew_preboil_sg=:brew_preboil_sg, brew_preboil_ph=:brew_preboil_ph, " |
| 572 "brew_preboil_efficiency=:brew_preboil_efficiency, brew_aboil_volume=:brew_aboil_volume, " | 578 "brew_preboil_efficiency=:brew_preboil_efficiency, brew_aboil_volume=:brew_aboil_volume, " |
| 653 query.bindValue(":eq_tun_height", round(prod->eq_tun_height * 1000) / 1000); | 659 query.bindValue(":eq_tun_height", round(prod->eq_tun_height * 1000) / 1000); |
| 654 query.bindValue(":eq_top_up_water", round(prod->eq_top_up_water * 10) / 10); | 660 query.bindValue(":eq_top_up_water", round(prod->eq_top_up_water * 10) / 10); |
| 655 query.bindValue(":eq_chiller_loss", round(prod->eq_trub_chiller_loss * 10) / 10); | 661 query.bindValue(":eq_chiller_loss", round(prod->eq_trub_chiller_loss * 10) / 10); |
| 656 query.bindValue(":eq_evap_rate", round(prod->eq_evap_rate * 100) / 100); | 662 query.bindValue(":eq_evap_rate", round(prod->eq_evap_rate * 100) / 100); |
| 657 query.bindValue(":eq_boil_time", round(prod->eq_boil_time)); | 663 query.bindValue(":eq_boil_time", round(prod->eq_boil_time)); |
| 658 query.bindValue(":eq_calcboil", prod->eq_calc_boil_volume ? 1:0); | 664 //query.bindValue(":eq_calcboil", prod->eq_calc_boil_volume ? 1:0); |
| 659 query.bindValue(":eq_top_up_kettle", round(prod->eq_top_up_kettle * 10) / 10); | 665 query.bindValue(":eq_top_up_kettle", round(prod->eq_top_up_kettle * 10) / 10); |
| 660 query.bindValue(":eq_hopfactor", round(prod->eq_hop_utilization)); | 666 //query.bindValue(":eq_hopfactor", round(prod->eq_hop_utilization)); |
| 661 query.bindValue(":eq_notes", prod->eq_notes); | 667 query.bindValue(":eq_notes", prod->eq_notes); |
| 662 query.bindValue(":eq_lauter_volume", round(prod->eq_lauter_volume * 10) / 10); | 668 //query.bindValue(":eq_lauter_volume", round(prod->eq_lauter_volume * 10) / 10); |
| 663 query.bindValue(":eq_lauter_height", round(prod->eq_lauter_height * 1000) / 1000); | 669 //query.bindValue(":eq_lauter_height", round(prod->eq_lauter_height * 1000) / 1000); |
| 664 query.bindValue(":eq_lauter_deadspace", round(prod->eq_lauter_deadspace * 10) / 10); | 670 query.bindValue(":eq_lauter_deadspace", round(prod->eq_lauter_deadspace * 10) / 10); |
| 665 query.bindValue(":eq_kettle_volume", round(prod->eq_kettle_volume * 10) / 10); | 671 query.bindValue(":eq_kettle_volume", round(prod->eq_kettle_volume * 10) / 10); |
| 666 query.bindValue(":eq_kettle_height", round(prod->eq_kettle_height * 1000) / 1000); | 672 query.bindValue(":eq_kettle_height", round(prod->eq_kettle_height * 1000) / 1000); |
| 667 query.bindValue(":eq_mash_volume", round(prod->eq_mash_volume * 10) / 10); | 673 query.bindValue(":eq_mash_volume", round(prod->eq_mash_volume * 10) / 10); |
| 668 query.bindValue(":eq_mash_max", round(prod->eq_mash_max * 10) / 10); | 674 query.bindValue(":eq_mash_max", round(prod->eq_mash_max * 10) / 10); |
