src/database/db_product.cpp

changeset 458
ac216a75ca9b
parent 433
40d4d2bb5f11
child 478
a3653722b0d6
equal deleted inserted replaced
457:5028c1c4c526 458:ac216a75ca9b
59 prod->eq_tun_weight = query.value("eq_tun_weight").toDouble(); 59 prod->eq_tun_weight = query.value("eq_tun_weight").toDouble();
60 prod->eq_tun_specific_heat = query.value("eq_tun_specific_heat").toDouble(); 60 prod->eq_tun_specific_heat = query.value("eq_tun_specific_heat").toDouble();
61 prod->eq_tun_material = query.value("eq_tun_material").toInt(); 61 prod->eq_tun_material = query.value("eq_tun_material").toInt();
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_loss = query.value("eq_trub_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();
562 "log_fermentation=:log_fermentation, log_ispindel=:log_ispindel, log_co2pressure=:log_co2pressure, " 562 "log_fermentation=:log_fermentation, log_ispindel=:log_ispindel, log_co2pressure=:log_co2pressure, "
563 "inventory_reduced=:inventory_reduced, locked=:locked, " 563 "inventory_reduced=:inventory_reduced, locked=:locked, "
564 "eq_name=:eq_name, eq_boil_size=:eq_boil_size, eq_efficiency=:eq_efficiency, " 564 "eq_name=:eq_name, eq_boil_size=:eq_boil_size, eq_efficiency=:eq_efficiency, "
565 "eq_batch_size=:eq_batch_size, eq_tun_volume=:eq_tun_volume, eq_tun_weight=:eq_tun_weight, " 565 "eq_batch_size=:eq_batch_size, eq_tun_volume=:eq_tun_volume, eq_tun_weight=:eq_tun_weight, "
566 "eq_tun_specific_heat=:eq_tun_specific_heat, eq_tun_material=:eq_tun_material, eq_tun_height=:eq_tun_height, " 566 "eq_tun_specific_heat=:eq_tun_specific_heat, eq_tun_material=:eq_tun_material, eq_tun_height=:eq_tun_height, "
567 "eq_top_up_water=:eq_top_up_water, eq_trub_chiller_loss=:eq_chiller_loss, eq_evap_rate=:eq_evap_rate, " 567 "eq_top_up_water=:eq_top_up_water, eq_trub_loss=:eq_trub_loss, eq_evap_rate=:eq_evap_rate, "
568 "eq_boil_time=:eq_boil_time, eq_top_up_kettle=:eq_top_up_kettle, eq_notes=:eq_notes, " 568 "eq_boil_time=:eq_boil_time, eq_top_up_kettle=:eq_top_up_kettle, eq_notes=:eq_notes, "
569 "eq_lauter_deadspace=:eq_lauter_deadspace, eq_kettle_volume=:eq_kettle_volume, " 569 "eq_lauter_deadspace=:eq_lauter_deadspace, eq_kettle_volume=:eq_kettle_volume, "
570 "eq_kettle_height=:eq_kettle_height, eq_mash_volume=:eq_mash_volume, eq_mash_max=:eq_mash_max, " 570 "eq_kettle_height=:eq_kettle_height, eq_mash_volume=:eq_mash_volume, eq_mash_max=:eq_mash_max, "
571 "eq_chiller_type=:eq_chiller_type, eq_chiller_to79=:eq_chiller_to79, eq_chiller_volume=:eq_chiller_volume, " 571 "eq_chiller_type=:eq_chiller_type, eq_chiller_to79=:eq_chiller_to79, eq_chiller_volume=:eq_chiller_volume, "
572 "eq_chiller_lpm=:eq_chiller_lpm, eq_chiller_loss=:eq_chiller_loss, " 572 "eq_chiller_lpm=:eq_chiller_lpm, eq_chiller_loss=:eq_chiller_loss, "
655 query.bindValue(":eq_tun_weight", round(prod->eq_tun_weight * 10) / 10); 655 query.bindValue(":eq_tun_weight", round(prod->eq_tun_weight * 10) / 10);
656 query.bindValue(":eq_tun_specific_heat", round(prod->eq_tun_specific_heat * 1000) / 1000); 656 query.bindValue(":eq_tun_specific_heat", round(prod->eq_tun_specific_heat * 1000) / 1000);
657 query.bindValue(":eq_tun_material", prod->eq_tun_material); 657 query.bindValue(":eq_tun_material", prod->eq_tun_material);
658 query.bindValue(":eq_tun_height", round(prod->eq_tun_height * 1000) / 1000); 658 query.bindValue(":eq_tun_height", round(prod->eq_tun_height * 1000) / 1000);
659 query.bindValue(":eq_top_up_water", round(prod->eq_top_up_water * 10) / 10); 659 query.bindValue(":eq_top_up_water", round(prod->eq_top_up_water * 10) / 10);
660 query.bindValue(":eq_chiller_loss", round(prod->eq_trub_chiller_loss * 10) / 10); 660 query.bindValue(":eq_trub_loss", round(prod->eq_trub_loss * 10) / 10);
661 query.bindValue(":eq_evap_rate", round(prod->eq_evap_rate * 100) / 100); 661 query.bindValue(":eq_evap_rate", round(prod->eq_evap_rate * 100) / 100);
662 query.bindValue(":eq_boil_time", round(prod->eq_boil_time)); 662 query.bindValue(":eq_boil_time", round(prod->eq_boil_time));
663 //query.bindValue(":eq_calcboil", prod->eq_calc_boil_volume ? 1:0); 663 //query.bindValue(":eq_calcboil", prod->eq_calc_boil_volume ? 1:0);
664 query.bindValue(":eq_top_up_kettle", round(prod->eq_top_up_kettle * 10) / 10); 664 query.bindValue(":eq_top_up_kettle", round(prod->eq_top_up_kettle * 10) / 10);
665 //query.bindValue(":eq_hopfactor", round(prod->eq_hop_utilization)); 665 //query.bindValue(":eq_hopfactor", round(prod->eq_hop_utilization));

mercurial