<?php

if($stream == 'download'){
  header('Content-disposition: attachment; filename=' . $attestation_name);
}
header('Content-Type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8"?>';

?>

<Verzendingen>
  <Verzending xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <v0002_inkomstenjaar><?php echo date('Y', strtotime('-1 year'));?></v0002_inkomstenjaar>
    <v0010_bestandtype>BELCOTAX</v0010_bestandtype>
    <v0011_aanmaakdatum><?php echo date('d-m-Y')?></v0011_aanmaakdatum>
    <v0014_naam>Propulse ASBL</v0014_naam>
    <v0015_adres>Av Balzac 10</v0015_adres>
    <v0016_postcode>1300</v0016_postcode>
    <v0017_gemeente>Wavre</v0017_gemeente>
    <v0018_telefoonnummer>+32498882138</v0018_telefoonnummer>
    <v0020_identificatie>BConv86</v0020_identificatie>
    <v0021_contactpersoon>Nicolas Jauquet</v0021_contactpersoon>
    <v0022_taalcode>2</v0022_taalcode>
    <v0023_emailadres>[email protected]</v0023_emailadres>
    <v0024_nationaalnr>0692855261</v0024_nationaalnr>
    <v0025_typeenvoi>0</v0025_typeenvoi>
    <v0028_landwoonplaats>150</v0028_landwoonplaats>
    <Aangiften>
        <Aangifte>
            <a1002_inkomstenjaar><?php echo date('Y', strtotime('-1 year'));?></a1002_inkomstenjaar>
            <a1005_registratienummer>0692855261</a1005_registratienummer>
            <a1007_division></a1007_division>
            <a1011_naamnl1></a1011_naamnl1>
            <a1013_adresnl></a1013_adresnl>
            <a1014_postcodebelgisch>1300</a1014_postcodebelgisch>
            <a1015_gemeente></a1015_gemeente>
            <a1016_landwoonplaats>150</a1016_landwoonplaats>
            <a1017_telefoonnummer>+32498882138</a1017_telefoonnummer>
            <a1019_contactpersoon>Nicolas Jauquet</a1019_contactpersoon>
            <a1020_taalcode>2</a1020_taalcode>
            <a1027_naamfr1>Propulse ASBL</a1027_naamfr1>
            <a1028_naamfr2></a1028_naamfr2>
            <a1029_adresfr>Av Balzac 10</a1029_adresfr>
            <a1030_gemeentefr>Wavre</a1030_gemeentefr>
            <a1037_nationaalnr></a1037_nationaalnr>
            <a1038_emailadres>[email protected]</a1038_emailadres>
            <Opgaven>
                <Opgave32586>
                <?php
                    $att_nb;
                    $grand_total;
                    $controleNb8011;
                    $n;
                    $lvl_excluded = array();

                    switch ($level) {
                    case 'clear':
                        $lvl_excluded = array('warning','error');
                        break;
                    case 'warning':
                        $lvl_excluded = array('error');
                        break;
                    case 'error':
                        $lvl_excluded;
                        break;
                    }

                    foreach ($attestations as $key => $attestations_child) {
                        foreach ($attestations_child as $key => $att) {
                            if(array_intersect($att['controls'], $lvl_excluded)){
                                continue;
                            }
                            $controleNb8011;

                            $att_nb++;
                            $n++;
                            $grand_total = ($att['period_course_total'] * 100) +  $grand_total;

                            $controleNb8011 = $controleNb8011 + $att_nb ;

                            //fix use 2 period to encode the rest of modulo
                            $dt1 = (int) round(floor($att['period_course_total'] / ($att['course_lessons'] - 1)) * 100);
                            $dt2 = (int) round($att['period_course_total'] * 100) - ($dt1 * ($att['course_lessons'] - 1));

                            if($dt2 == 0){
                                $dt1 = $att['period_course_total'] * 100 / $att['course_lessons'];
                                if($dt1 * $att['course_lessons'] != $att['period_course_total'] * 100){
                                    echo "<debug_amount>".$dt1."x".$att['course_lessons']."!=".$att['period_course_total']."</debug_amount>";
                                }
                                $dt2 = 0;
                            }
                ?>
                            <Fiche28186>
                                <?php if(($att['warning']=='yes' || $att['control']=='error' ) && $stream != 'download') : ?>
                                    <debug>
                                        <?php if($att['control']!= 'error') : ?>
                                            <debug_level>Warning</debug_level>
                                        <?php else : ?>
                                            <debug_level>Error</debug_level>
                                        <?php endif ?>
                                        <debug_data><?php echo $att['errors']?></debug_data>
                                    </debug>
                                <?php endif ?>
                                <f2002_inkomstenjaar><?php echo date('Y', strtotime('-1 year'));?></f2002_inkomstenjaar>
                                <f2003_gewestdirectie></f2003_gewestdirectie>
                                <f2004_ontvangkantoor></f2004_ontvangkantoor>
                                <f2005_registratienummer>0692855261</f2005_registratienummer>
                                <f2007_division></f2007_division>
                                <f2008_typefiche>28186</f2008_typefiche>
                                <f2009_volgnummer><?php echo $att_nb?></f2009_volgnummer>
                                <f2010_referentie><?php echo substr($att['ref'],0,19)?></f2010_referentie>
                                <f2011_nationaalnr><?if($att['parent']['register_number']!=0){echo $att['parent']['register_number'];}?></f2011_nationaalnr>
                                <f2012_geboortedatum><?php echo $this->crud_model->date_to_iso_fr($att['parent']['dob']);?></f2012_geboortedatum>
                                <f2013_naam><?php echo $att['parent']['LastName']?></f2013_naam>
                                <f2015_adres><?php echo $att['parent']['l1']?></f2015_adres>
                                <f2016_postcodebelgisch><?php echo trim($att['parent']['pc'])?></f2016_postcodebelgisch>
                                <f2017_gemeente><?php echo $att['parent']['location']?></f2017_gemeente>
                                <f2018_landwoonplaats>150</f2018_landwoonplaats>
                                <f2028_typetraitement>0</f2028_typetraitement>
                                <f2029_enkelopgave325>0</f2029_enkelopgave325>
                                <f2114_voornamen><?php echo $att['parent']['FirstName']?></f2114_voornamen>
                                <f86_2031_certificationautorisation>1</f86_2031_certificationautorisation>

                                <f86_2055_begindate1><?php echo $this->crud_model->date_to_iso_fr($att['course_start'])?></f86_2055_begindate1>
                                <f86_2056_enddate1><?php echo $this->crud_model->date_to_iso_fr($att['course_end'])?></f86_2056_enddate1>
                                <f86_2059_totaalcontrole><?php echo $att['period_course_total'] * 100 * 2 ?></f86_2059_totaalcontrole>
                                <f86_2060_amount1><?php if($dt2 != 0){ echo ($dt1 * ($att['course_lessons']-1)); }else{ echo $dt1 * $att['course_lessons'];}?></f86_2060_amount1>
                                <f86_2061_amount2><?php if($dt2 != 0){ echo $dt2; }?></f86_2061_amount2>
                                <f86_2062_amount3></f86_2062_amount3>
                                <f86_2063_amount4></f86_2063_amount4>
                                <f86_2064_totalamount><?php echo $att['period_course_total'] * 100 ?></f86_2064_totalamount>
                                <f86_2093_begindate2><?php if($dt2!='0'){ echo $this->crud_model->date_to_iso_fr($att['course_end']); }?></f86_2093_begindate2>
                                <f86_2100_certifierpostnr>1060</f86_2100_certifierpostnr>
                                <f86_2101_childcountry>150</f86_2101_childcountry>
                                <f86_2102_childaddress><?php echo $att['parent']['l1']?></f86_2102_childaddress>
                                <f86_2106_childname><?php echo $att['s_last_name']?></f86_2106_childname>
                                <f86_2107_childfirstname><?php echo $att['s_first_name']?></f86_2107_childfirstname>
                                <f86_2109_certifiercbenumber>0231907895</f86_2109_certifiercbenumber>
                                <f86_2110_numberofday1><?php echo (int) $att['course_lessons'] - (($dt2 != 0) ? -1 : 0) ?></f86_2110_numberofday1>
                                <f86_2111_dailytariff1><?php echo $dt1 ?></f86_2111_dailytariff1>
                                <f86_2113_numberofday2><?php if ($dt2 != 0) { echo "1"; }?></f86_2113_numberofday2>
                                <f86_2115_dailytariff2><?php if ($dt2 != 0) { echo $dt2; }?></f86_2115_dailytariff2>
                                <f86_2116_numberofday3></f86_2116_numberofday3>
                                <f86_2117_dailytariff3></f86_2117_dailytariff3>
                                <f86_2119_numberofday4></f86_2119_numberofday4>
                                <f86_2120_dailytariff4></f86_2120_dailytariff4>
                                <f86_2139_childpostnr><?php echo trim($att['parent']['pc'])?></f86_2139_childpostnr>
                                <f86_2140_childmunicipality><?php echo $att['parent']['location']?></f86_2140_childmunicipality>
                                <f86_2144_enddate2><?php if($dt2!='0'){ echo $this->crud_model->date_to_iso_fr($att['course_end']); }?></f86_2144_enddate2>
                                <f86_2153_nnchild><?php if($att['s_register_number']!=0){echo $att['s_register_number'];}?></f86_2153_nnchild>
                                <f86_2154_certifiermunicipality>Bruxelles</f86_2154_certifiermunicipality>
                                <f86_2155_certifiername>Office de la Naissance et de L'Enfance</f86_2155_certifiername>
                                <f86_2156_certifieradres>95 Chaussée de Charleroi</f86_2156_certifieradres>
                                <f86_2157_begindate3></f86_2157_begindate3>
                                <f86_2158_enddate3></f86_2158_enddate3>
                                <f86_2161_begindate4></f86_2161_begindate4>
                                <f86_2162_enddate4></f86_2162_enddate4>
                                <f86_2163_childbirthdate><?php echo $this->crud_model->date_to_iso_fr($att['s_dob'])?></f86_2163_childbirthdate>
                                <f86_2164_beginvaliditycertification>06-10-2020</f86_2164_beginvaliditycertification>
                                <f86_2171_endvaliditycertification></f86_2171_endvaliditycertification>
                            </Fiche28186>
            <?php
                        }
                    }
            ?>
                </Opgave32586>
            </Opgaven>
            <r8002_inkomstenjaar><?php echo date('Y', strtotime('-1 year'));?></r8002_inkomstenjaar>
            <r8005_registratienummer>0692855261</r8005_registratienummer>
            <r8007_division></r8007_division>
            <r8010_aantalrecords><?php echo $att_nb+2?></r8010_aantalrecords>
            <r8011_controletotaal><?php echo $controleNb8011?></r8011_controletotaal>
            <r8012_controletotaal><?php echo $grand_total*2?></r8012_controletotaal>
            <r8013_totaalvoorheffingen>0</r8013_totaalvoorheffingen>
        </Aangifte>
    </Aangiften>
    <r9002_inkomstenjaar><?php echo date('Y', strtotime('-1 year'));?></r9002_inkomstenjaar>
    <r9010_aantallogbestanden>3</r9010_aantallogbestanden>
    <r9011_totaalaantalrecords><?php echo $att_nb+4?></r9011_totaalaantalrecords>
    <r9012_controletotaal><?php echo $controleNb8011?></r9012_controletotaal>
    <r9013_controletotaal><?php echo $grand_total*2?></r9013_controletotaal>
    <r9014_controletotaal>0</r9014_controletotaal>
  </Verzending>
</Verzendingen>