714 $this->Cell(0, 5, 'Brouwdag gegevens',0,0,'C',true); |
733 $this->Cell(0, 5, 'Brouwdag gegevens',0,0,'C',true); |
715 $this->Ln(); |
734 $this->Ln(); |
716 |
735 |
717 $this->SetFont('Helvetica','',9); |
736 $this->SetFont('Helvetica','',9); |
718 $this->SetFillColor(210,245,255); |
737 $this->SetFillColor(210,245,255); |
719 |
|
720 $this->SetX($this->TableX); |
738 $this->SetX($this->TableX); |
721 $this->Cell(35,5,'Datum start',0,0,'L',true); |
739 $this->Cell(35,5,'Datum start',0,0,'L',true); |
722 $this->Cell(50,5,$row['brew_date_start'],0,0,'L',true); |
740 $this->Cell(50,5,$row['brew_date_start'],0,0,'L',true); |
723 $this->Cell($vul,5,'',0,0,'L',false); |
741 $this->Cell($vul,5,'',0,0,'L',false); |
724 $this->Cell(35,5,'Maisch zuurgraad',0,0,'L',true); |
742 $this->Cell(35,5,'Datum eind',0,0,'L',true); |
725 $this->Cell(50,5,sprintf("%.1f", $row['brew_mash_ph']).' pH',0,0,'L',true); |
743 $this->Cell(50,5,$row['brew_date_end'],0,0,'L',true); |
|
744 $this->Ln(10); |
|
745 |
|
746 $domash = 0; |
|
747 $arr = json_decode($row['json_mashs'], true); |
|
748 foreach($arr as $item) { |
|
749 if ($item['step_sg'] > 1.005) |
|
750 $domash = 1; |
|
751 } |
|
752 if ($domash) { |
|
753 $this->SetX($this->TableX); |
|
754 $this->SetFont('Helvetica','B',9); |
|
755 $this->SetFillColor(175,175,255); |
|
756 $vul = $this->w - $this->rMargin - $this->lMargin - 125; |
|
757 $this->Cell(5, 5, '',0,0,'L',true); |
|
758 $this->Cell($vul,5, 'Maisch stap',0,0,'L',true); |
|
759 $this->Cell(30,5, 'Type',0,0,'L',true); |
|
760 $this->Cell(30,5, 'Temperatuur',0,0,'L',true); |
|
761 $this->Cell(30,5, 'SG',0,0,'L',true); |
|
762 $this->Cell(30,5, 'pH',0,0,'L',true); |
|
763 $this->Ln(); |
|
764 $this->SetFont('Helvetica','',9); |
|
765 $this->SetFillColor(210,245,255); |
|
766 $arr = json_decode($row['json_mashs'], true); |
|
767 $step = 0; |
|
768 foreach($arr as $item) { |
|
769 $step++; |
|
770 $this->Cell(5,5,$step,0,0,'L',true); |
|
771 $this->Cell($vul,5,$item['step_name'],0,0,'L',true); |
|
772 $this->Cell(30,5,$mashtype[$item['step_type']],0,0,'L',true); |
|
773 $this->Cell(30,5,sprintf("%.1f",$item['step_temp']).'-'.sprintf("%.1f",$item['end_temp']).DEG.'C',0,0,'L',true); |
|
774 $this->Cell(30,5,sprintf("%.3f",$item['step_sg']),0,0,'L',true); |
|
775 $this->Cell(30,5,sprintf("%.2f",$item['step_ph']),0,0,'L',true); |
|
776 $this->Ln(); |
|
777 } |
|
778 $this->Ln(); |
|
779 } |
|
780 |
|
781 $this->SetX($this->TableX); |
|
782 $this->SetFont('Helvetica','B',9); |
|
783 $this->SetFillColor(175,175,255); |
|
784 $vul = $this->w - $this->rMargin - $this->lMargin - 130; |
|
785 $this->Cell($vul, 5, 'Gegeven',0,0,'L',true); |
|
786 $this->Cell(50, 5, 'Gewenst',0,0,'L',true); |
|
787 $this->Cell(50, 5, 'Werkelijk',0,0,'L',true); |
|
788 $this->Cell(30, 5, 'Verschil',0,0,'L',true); |
|
789 $this->Ln(); |
|
790 |
|
791 $this->SetX($this->TableX); |
|
792 $this->SetFont('Helvetica','',9); |
|
793 $this->SetFillColor(210,245,255); |
|
794 $this->Cell($vul,5,'Maisch zuurgraad',0,0,'L',true); |
|
795 $this->Cell(50,5,sprintf("%.1f", $row['mash_ph']).' pH',0,0,'L',true); |
|
796 $this->Cell(50,5,sprintf("%.2f", $row['brew_mash_ph']).' pH',0,0,'L',true); |
|
797 $this->PrintDiff($row['mash_ph'], $row['brew_mash_ph'], 2, ' pH'); |
726 $this->Ln(); |
798 $this->Ln(); |
727 |
799 |
728 $this->SetX($this->TableX); |
800 $this->SetX($this->TableX); |
729 $this->Cell(35,5,'Datum eind',0,0,'L',true); |
801 $this->Cell($vul,5,'Maisch densiteit',0,0,'L',true); |
730 $this->Cell(50,5,$row['brew_date_end'],0,0,'L',true); |
802 $this->Cell(50,5,density_str(floatval($est_mash_sg)),0,0,'L',true); |
731 $this->Cell($vul,5,'',0,0,'L',false); |
|
732 $this->Cell(35,5,'Maisch densiteit',0,0,'L',true); |
|
733 $this->Cell(50,5,density_str(floatval($row['brew_mash_sg'])),0,0,'L',true); |
803 $this->Cell(50,5,density_str(floatval($row['brew_mash_sg'])),0,0,'L',true); |
734 $this->Ln(); |
804 $this->PrintDiff($est_mash_sg, $row['brew_mash_sg'], 3, ' SG'); |
735 |
805 $this->Ln(); |
736 $this->SetX($this->TableX); |
806 |
737 $this->Cell(85+$vul,5,'',0,0,'L',false); |
807 $this->SetX($this->TableX); |
738 $this->Cell(35,5,'Maisch rendement',0,0,'L',true); |
808 $this->Cell($vul,5,'Maisch rendement',0,0,'L',true); |
|
809 $this->Cell(50,5,'100.0%',0,0,'L',true); |
739 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_mash_efficiency']))."%",0,0,'L',true); |
810 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_mash_efficiency']))."%",0,0,'L',true); |
|
811 $this->PrintDiff(100.0, $row['brew_mash_efficiency'], 1, '%'); |
|
812 $this->Ln(); |
|
813 |
|
814 $this->SetX($this->TableX); |
|
815 $this->Cell($vul,5,'Spoelwater zuurgraad',0,0,'L',true); |
|
816 $this->Cell(50,5,sprintf("%.1f", $row['sparge_ph']).' pH',0,0,'L',true); |
|
817 $this->Cell(50,5,sprintf("%.2f", $row['brew_sparge_ph']).' pH',0,0,'L',true); |
|
818 $this->PrintDiff($row['sparge_ph'], $row['brew_sparge_ph'], 2, ' pH'); |
|
819 $this->Ln(7); |
|
820 |
|
821 $this->SetX($this->TableX); |
|
822 $this->Cell($vul,5,'Voor koken zuurgraad',0,0,'L',true); |
|
823 $this->Cell(50,5,'',0,0,'L',true); |
|
824 $this->Cell(50,5,sprintf("%.2f", $row['brew_preboil_ph'])." pH",0,0,'L',true); |
|
825 $this->Cell(30,5,'',0,0,'L',true); |
|
826 $this->Ln(); |
|
827 |
|
828 $this->SetX($this->TableX); |
|
829 $this->Cell($vul,5,'Voor koken densiteit',0,0,'L',true); |
|
830 $this->Cell(50,5,'',0,0,'L',true); |
|
831 $this->Cell(50,5,density_str(floatval($row['brew_preboil_sg'])),0,0,'L',true); |
|
832 $this->Cell(30,5,'',0,0,'L',true); |
|
833 $this->Ln(); |
|
834 |
|
835 $this->SetX($this->TableX); |
|
836 $this->Cell($vul,5,'Voor koken volume',0,0,'L',true); |
|
837 $this->Cell(50,5,sprintf("%.1f", $row['boil_size'] * 1.04)." liter",0,0,'L',true); |
|
838 $this->Cell(50,5,sprintf("%.1f", $row['brew_preboil_volume'])." liter",0,0,'L',true); |
|
839 $this->PrintDiff($row['boil_size'] * 1.04, $row['brew_preboil_volume'], 1, ' liter'); |
|
840 $this->Ln(); |
|
841 |
|
842 $this->SetX($this->TableX); |
|
843 $this->Cell($vul,5,'Voor koken rendement',0,0,'L',true); |
|
844 $this->Cell(50,5,sprintf("%.1f", floatval($row['efficiency']))."%",0,0,'L',true); |
|
845 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_preboil_efficiency']))."%",0,0,'L',true); |
|
846 $this->PrintDiff($row['efficiency'], $row['brew_preboil_efficiency'], 1, '%'); |
|
847 $this->Ln(7); |
|
848 |
|
849 $this->SetX($this->TableX); |
|
850 $this->Cell($vul,5,'Na koken zuurgraad',0,0,'L',true); |
|
851 $this->Cell(50,5,'',0,0,'L',true); |
|
852 $this->Cell(50,5,sprintf("%.2f", $row['brew_aboil_ph'])." pH",0,0,'L',true); |
|
853 $this->Cell(30,5,'',0,0,'L',true); |
|
854 $this->Ln(); |
|
855 |
|
856 $this->SetX($this->TableX); |
|
857 $this->Cell($vul,5,'Na koken densiteit',0,0,'L',true); |
|
858 $this->Cell(50,5,density_str(floatval($row['est_og'])),0,0,'L',true); |
|
859 $this->Cell(50,5,density_str(floatval($row['brew_aboil_sg'])),0,0,'L',true); |
|
860 $this->PrintDiff($row['est_og'], $row['brew_aboil_sg'], 3, ' SG'); |
|
861 $this->Ln(); |
|
862 |
|
863 $this->SetX($this->TableX); |
|
864 $this->Cell($vul,5,'Na koken volume',0,0,'L',true); |
|
865 $this->Cell(50,5,sprintf("%.1f", $row['batch_size'] * 1.04)." liter",0,0,'L',true); |
|
866 $this->Cell(50,5,sprintf("%.1f", $row['brew_aboil_volume'])." liter",0,0,'L',true); |
|
867 $this->PrintDiff($row['batch_size'] * 1.04, $row['brew_aboil_volume'], 1, ' liter'); |
|
868 $this->Ln(); |
|
869 |
|
870 $this->SetX($this->TableX); |
|
871 $this->Cell($vul,5,'Na koken rendement',0,0,'L',true); |
|
872 $this->Cell(50,5,sprintf("%.1f", floatval($row['efficiency']))."%",0,0,'L',true); |
|
873 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_aboil_efficiency']))."%",0,0,'L',true); |
|
874 $this->PrintDiff($row['efficiency'], $row['brew_aboil_efficiency'], 1, '%'); |
740 $this->Ln(7); |
875 $this->Ln(7); |
741 |
876 |
742 $this->SetX($this->TableX); |
877 $this->SetX($this->TableX); |
743 $this->Cell(35,5,'Voor koken zuurgraad',0,0,'L',true); |
878 $this->Cell($vul,5,'Koeler & trub verlies',0,0,'L',true); |
744 $this->Cell(50,5,sprintf("%.1f", $row['brew_preboil_ph'])." pH",0,0,'L',true); |
879 $this->Cell(50,5,sprintf("%.1f", floatval($row['eq_trub_chiller_loss'])).' liter',0,0,'L',true); |
745 $this->Cell($vul,5,'',0,0,'L',false); |
880 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_tcloss'])).' liter',0,0,'L',true); |
746 $this->Cell(35,5,'Na koken zuurgraad',0,0,'L',true); |
881 $this->PrintDiff($row['eq_trub_chiller_loss'], $row['brew_fermenter_tcloss'], 1, ' lter'); |
747 $this->Cell(50,5,sprintf("%.1f", $row['brew_aboil_ph'])." pH",0,0,'L',true); |
882 $this->Ln(); |
748 $this->Ln(); |
883 |
749 |
884 $this->SetX($this->TableX); |
750 $this->SetX($this->TableX); |
885 $this->Cell($vul,5,'Extra water in gistvat',0,0,'L',true); |
751 $this->Cell(35,5,'Voor koken densiteit',0,0,'L',true); |
886 $this->Cell(50,5,sprintf("%.1f", floatval($row['eq_top_up_water'])).' liter',0,0,'L',true); |
752 $this->Cell(50,5,density_str(floatval($row['brew_preboil_sg'])),0,0,'L',true); |
887 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_extrawater'])).' liter',0,0,'L',true); |
753 $this->Cell($vul,5,'',0,0,'L',false); |
888 $this->PrintDiff($row['eq_top_up_water'], $row['brew_fermenter_extrawater'], 1, ' liter'); |
754 $this->Cell(35,5,'Na koken densiteit',0,0,'L',true); |
889 $this->Ln(); |
755 $this->Cell(50,5,density_str(floatval($row['brew_aboil_sg'])),0,0,'L',true); |
890 |
756 $this->Ln(); |
891 $this->SetX($this->TableX); |
757 |
892 $this->Cell($vul,5,'Volume naar gistvat',0,0,'L',true); |
758 $this->SetX($this->TableX); |
893 $this->Cell(50,5,sprintf("%.1f", floatval($row['batch_size']) - floatval($row['eq_trub_chiller_loss'])).' liter',0,0,'L',true); |
759 $this->Cell(35,5,'Voor koken volume',0,0,'L',true); |
894 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_volume'])).' liter',0,0,'L',true); |
760 $this->Cell(50,5,sprintf("%.1f", $row['brew_preboil_volume'])." liter",0,0,'L',true); |
895 $this->PrintDiff(floatval($row['batch_size']) - floatval($row['eq_trub_chiller_loss']), $row['brew_fermenter_volume'], 1, ' liter'); |
761 $this->Cell($vul,5,'',0,0,'L',false); |
896 $this->Ln(); |
762 $this->Cell(35,5,'Na koken volume',0,0,'L',true); |
897 |
763 $this->Cell(50,5,sprintf("%.1f", $row['brew_aboil_volume'])." liter",0,0,'L',true); |
898 $this->SetX($this->TableX); |
764 $this->Ln(); |
899 $this->Cell($vul,5,'Densiteit in gistvat',0,0,'L',true); |
765 |
900 $this->Cell(50,5,density_str(floatval($row['est_og'])),0,0,'L',true); |
766 $this->SetX($this->TableX); |
901 $this->Cell(50,5,density_str(floatval($row['brew_fermenter_sg'])),0,0,'L',true); |
767 $this->Cell(35,5,'Voor koken rendement',0,0,'L',true); |
902 $this->PrintDiff($row['est_og'], $row['brew_fermenter_sg'], 3, ' SG'); |
768 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_preboil_efficiency']))."%",0,0,'L',true); |
903 $this->Ln(); |
769 $this->Cell($vul,5,'',0,0,'L',false); |
904 |
770 $this->Cell(35,5,'Na koken rendement',0,0,'L',true); |
905 $this->SetX($this->TableX); |
771 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_aboil_efficiency']))."%",0,0,'L',true); |
906 $this->Cell($vul,5,'Kleur in gistvat',0,0,'L',true); |
772 $this->Ln(7); |
907 $this->Cell(50,5,sprintf("%.0f", floatval($row['est_color'])).' EBC',0,0,'L',true); |
773 |
908 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_color'])).' EBC',0,0,'L',true); |
774 $this->SetX($this->TableX); |
909 $this->PrintDiff($row['est_color'], $row['brew_fermenter_color'], 0, ' EBC'); |
775 $this->Cell(35,5,'Spoelwater temperatuur',0,0,'L',true); |
910 $this->Ln(); |
776 $this->Cell(50,5,sprintf("%.1f", $row['sparge_temp']).DEG.'C',0,0,'L',true); |
911 |
777 $this->Cell($vul,5,'',0,0,'L',false); |
912 $this->SetX($this->TableX); |
778 $this->Cell(35,5,'Koel methode',0,0,'L',true); |
913 $this->Cell($vul,5,'Bitterheid in gistvat',0,0,'L',true); |
779 $this->Cell(50,5,$coolingtype[$row['brew_cooling_method']],0,0,'L',true); |
914 $this->Cell(50,5,sprintf("%.0f", floatval($row['est_ibu'])).' IBU',0,0,'L',true); |
780 $this->Ln(); |
915 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_ibu'])).' IBU',0,0,'L',true); |
781 |
916 $this->PrintDiff($row['est_ibu'], $row['brew_fermenter_ibu'], 0, ' IBU'); |
782 $this->SetX($this->TableX); |
917 $this->Ln(7); |
783 $this->Cell(35,5,'Spoelwater geschat',0,0,'L',true); |
918 |
784 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_sparge_est'])).' liter',0,0,'L',true); |
919 $this->SetX($this->TableX); |
785 $this->Cell($vul,5,'',0,0,'L',false); |
920 $this->Cell($vul,5,'Koelen methode',0,0,'L',true); |
786 $this->Cell(35,5,'Koel temperatuur',0,0,'L',true); |
921 $this->Cell(50,5,$coolingtype[$row['brew_cooling_method']],0,0,'L',true); |
787 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_cooling_to'])).DEG.'C',0,0,'L',true); |
922 $this->Ln(); |
788 $this->Ln(); |
923 |
789 |
924 $this->SetX($this->TableX); |
790 $this->SetX($this->TableX); |
925 $this->Cell($vul,5,'Koelen temperatuur',0,0,'L',true); |
791 $this->Cell(35,5,'Spoelwater zuurgraad',0,0,'L',true); |
926 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_cooling_to'])).DEG.'C',0,0,'L',true); |
792 $this->Cell(50,5,sprintf("%.1f", $row['brew_sparge_ph']).' pH',0,0,'L',true); |
927 $this->Ln(); |
793 $this->Cell($vul,5,'',0,0,'L',false); |
928 |
794 $this->Cell(35,5,'Koel tijdsduur',0,0,'L',true); |
929 $this->SetX($this->TableX); |
795 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_cooling_time'])).' minuten',0,0,'L',true); |
930 $this->Cell($vul,5,'Koelen tijdsduur',0,0,'L',true); |
796 $this->Ln(7); |
931 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_cooling_time'])).' minuten',0,0,'L',true); |
797 |
932 $this->Ln(7); |
798 $this->SetX($this->TableX); |
|
799 $this->Cell(35,5,'Whirlpool +85'.DEG.'C',0,0,'L',true); |
|
800 $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool9']).' minuten',0,0,'L',true); |
|
801 $this->Cell($vul,5,'',0,0,'L',false); |
|
802 $this->Cell(35,5,'Koeler & trub verlies',0,0,'L',true); |
|
803 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_tcloss'])).' liter',0,0,'L',true); |
|
804 $this->Ln(); |
|
805 |
|
806 $this->SetX($this->TableX); |
|
807 $this->Cell(35,5,'Whirlpool 72..79'.DEG.'C',0,0,'L',true); |
|
808 $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool7']).' minuten',0,0,'L',true); |
|
809 $this->Cell($vul,5,'',0,0,'L',false); |
|
810 $this->Cell(35,5,'Extra water in gistvat',0,0,'L',true); |
|
811 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_extrawater'])).' liter',0,0,'L',true); |
|
812 $this->Ln(); |
|
813 |
|
814 $this->SetX($this->TableX); |
|
815 $this->Cell(35,5,'Whirlpool 60..66'.DEG.'C',0,0,'L',true); |
|
816 $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool6']).' minuten',0,0,'L',true); |
|
817 $this->Cell($vul,5,'',0,0,'L',false); |
|
818 $this->Cell(35,5,'Volume naar gistvat',0,0,'L',true); |
|
819 $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_volume'])).' liter',0,0,'L',true); |
|
820 $this->Ln(); |
|
821 |
|
822 $this->SetX($this->TableX); |
|
823 $this->Cell(35,5,'Whirlpool koud',0,0,'L',true); |
|
824 $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool2']).' minuten',0,0,'L',true); |
|
825 $this->Cell($vul,5,'',0,0,'L',false); |
|
826 $this->Cell(35,5,'Densiteit in gistvat',0,0,'L',true); |
|
827 $this->Cell(50,5,density_str(floatval($row['brew_fermenter_sg'])),0,0,'L',true); |
|
828 $this->Ln(7); |
|
829 |
|
830 $this->SetX($this->TableX); |
|
831 $this->Cell(35,5,'Beluchten met',0,0,'L',true); |
|
832 $this->Cell(50,5,$aerationtype[$row['brew_aeration_type']],0,0,'L',true); |
|
833 $this->Cell($vul,5,'',0,0,'L',false); |
|
834 $this->Cell(35,5,'Kleur in gistvat',0,0,'L',true); |
|
835 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_color'])).' EBC',0,0,'L',true); |
|
836 $this->Ln(); |
|
837 |
|
838 $this->SetX($this->TableX); |
|
839 $this->Cell(35,5,'Beluchten snelheid/tijd',0,0,'L',true); |
|
840 $this->Cell(50,5,$row['brew_aeration_speed'].'/'.$row['brew_aeration_time'],0,0,'L',true); |
|
841 $this->Cell($vul,5,'',0,0,'L',false); |
|
842 $this->Cell(35,5,'Bitterheid in gistvat',0,0,'L',true); |
|
843 $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_ibu'])).' IBU',0,0,'L',true); |
|
844 $this->Ln(); |
|
845 } |
933 } |
846 |
934 |
847 function Fermentation($row) { |
935 function Fermentation($row) { |
848 |
936 |
849 if ($this->GetY() > 230) |
937 if ($this->GetY() > 230) |