<?php

	$nieuwsbrief_id = $_GET['nieuwsbrief_id'];

	$query_afmeldingen = "SELECT kes_afmeldingen.email_id FROM kes_afmeldingen WHERE kes_afmeldingen.nieuwsbrief_id = '$nieuwsbrief_id'";
	$res_afmeldingen = mysql_query($query_afmeldingen);
	
	$kleur_actief = true;
	$counter_acief = 0;
?>

<h1><a href="index.php?p=statistieken">Statistieken</a> > <a href="index.php?p=statistieken_nieuwsbrief&amp;nieuwsbrief_id=<?php echo($nieuwsbrief_id); ?>">Nieuwsbrief</a> > <a href="index.php?p=statistieken_bounces&amp;nieuwsbrief_id=<?php echo($nieuwsbrief_id); ?>">Afmeldingen en bounces</a></h1>

<br /><br />
<h1>Afmeldingen</h1>

<table cellpadding="5" cellspacing="0" border="0">
    <tr>
        <th>Nr</th>
        <th>Achternaam</th>
        <th>Bedrijfsnaam</th>
        <th>Emailadres</th>
        <th>Taal</th>
        <th>Categorie A</th>
        <th>Categorie B</th>
        <th>Acties</th>
    </tr>
    
    
    <?php 
    
    while($rec_afmeldingen = mysql_fetch_array($res_afmeldingen)){ 
    
        $counter_acief++;
		
		$email_id = $rec_afmeldingen[0];
		
		$query_user = "SELECT kes_emailadressen.email_id, kes_emailadressen.achternaam, kes_emailadressen.bedrijfsnaam, kes_emailadressen.emailadres, kes_emailadressen.taal, kes_emailadressen.categorie_a, kes_emailadressen.categorie_b FROM kes_emailadressen WHERE kes_emailadressen.email_id = '$email_id'";
		$res_user = mysql_query($query_user);
		$rec_user = mysql_fetch_array($res_user);
    
    ?>
        
    <tr <?php if($kleur_actief){ echo("style=\"background-color:#e6e8eb; \""); $kleur_actief = false; }else{ $kleur_actief = true; }?> >
    
        <td><?php echo( $counter_acief ); ?></td>
        <td><?php echo( $rec_user['achternaam']); ?></td>
        <td><?php echo( $rec_user['bedrijfsnaam'] ); ?></td>
        <td><?php echo( $rec_user['emailadres'] ); ?></td>
        <td><?php echo( $rec_user['taal'] ); ?></td>
        <td><?php echo( $rec_user['categorie_a'] ); ?></td>
        <td><?php echo( $rec_user['categorie_b'] ); ?></td>
        <td><a href="index.php?p=statistieken_user&amp;email_id=<?php echo($rec_user['email_id']); ?>">Meer info</a></td>
    </tr>
    
<?php } ?>

</table>
<br /><br />

<?php

	$query_hardbounces = "SELECT kes_bounces.email_id FROM kes_bounces WHERE kes_bounces.nieuwsbrief_id='$nieuwsbrief_id' AND kes_bounces.type_bounce ='hardbounce'";
	$res_hardbounces = mysql_query($query_hardbounces);

	$kleur_hardbounces = true;
	$counter_hardbounces = 0;
?>
<br /><br />
<h1>Hardbounces</h1>

<table cellpadding="5" cellspacing="0" border="0">
    <tr>
        <th>Nr</th>
        <th>Achternaam</th>
        <th>Bedrijfsnaam</th>
        <th>Emailadres</th>
        <th>Taal</th>
        <th>Categorie A</th>
        <th>Categorie B</th>
        <th>Acties</th>
    </tr>
    
    
    <?php 
    
    while($rec_hardbounces = mysql_fetch_array($res_hardbounces)){ 
    
        $counter_hardbounces++;
		
		$email_id = $rec_hardbounces[0];
		
		$query_user = "SELECT kes_emailadressen.email_id, kes_emailadressen.achternaam, kes_emailadressen.bedrijfsnaam, kes_emailadressen.emailadres, kes_emailadressen.taal, kes_emailadressen.categorie_a, kes_emailadressen.categorie_b FROM kes_emailadressen WHERE kes_emailadressen.email_id = '$email_id'";
		$res_user = mysql_query($query_user);
		$rec_user = mysql_fetch_array($res_user);
    
    ?>
        
    <tr <?php if($kleur_hardbounces){ echo("style=\"background-color:#e6e8eb; \""); $kleur_hardbounces = false; }else{ $kleur_hardbounces = true; }?> >
    
        <td><?php echo( $counter_hardbounces ); ?></td>
        <td><?php echo( $rec_user['achternaam']); ?></td>
        <td><?php echo( $rec_user['bedrijfsnaam'] ); ?></td>
        <td><?php echo( $rec_user['emailadres'] ); ?></td>
        <td><?php echo( $rec_user['taal'] ); ?></td>
        <td><?php echo( $rec_user['categorie_a'] ); ?></td>
        <td><?php echo( $rec_user['categorie_b'] ); ?></td>
        <td><a href="index.php?p=statistieken_user&amp;email_id=<?php echo($rec_user['email_id']); ?>">Meer info</a></td>
    </tr>
    
<?php } ?>

</table>
<br /><br />

<?php

	$query_softbounces = "SELECT kes_bounces.email_id FROM kes_bounces WHERE kes_bounces.nieuwsbrief_id='$nieuwsbrief_id' AND kes_bounces.type_bounce ='softbounce'";
	$res_softbounces = mysql_query($query_softbounces);
	
	
	$kleur_softbounces = true;
	$counter_softbounces = 0;
?>
<br /><br />
<h1>Softbounces</h1>

<table cellpadding="5" cellspacing="0" border="0">
    <tr>
        <th>Nr</th>
        <th>Achternaam</th>
        <th>Bedrijfsnaam</th>
        <th>Emailadres</th>
        <th>Taal</th>
        <th>Categorie A</th>
        <th>Categorie B</th>
        <th>Acties</th>
    </tr>
    
    
    <?php 
    
    while($rec_softbounces = mysql_fetch_array($res_softbounces)){ 
    
        $counter_softbounces++;
		
		$email_id = $rec_softbounces[0];
		
		$query_user = "SELECT kes_emailadressen.email_id, kes_emailadressen.achternaam, kes_emailadressen.bedrijfsnaam, kes_emailadressen.emailadres, kes_emailadressen.taal, kes_emailadressen.categorie_a, kes_emailadressen.categorie_b FROM kes_emailadressen WHERE kes_emailadressen.email_id = '$email_id'";
		$res_user = mysql_query($query_user);
		$rec_user = mysql_fetch_array($res_user);
    
    ?>
        
    <tr <?php if($kleur_softbounces){ echo("style=\"background-color:#e6e8eb; \""); $kleur_softbounces = false; }else{ $kleur_softbounces = true; }?> >
    
        <td><?php echo( $counter_softbounces ); ?></td>
        <td><?php echo( $rec_user['achternaam']); ?></td>
        <td><?php echo( $rec_user['bedrijfsnaam'] ); ?></td>
        <td><?php echo( $rec_user['emailadres'] ); ?></td>
        <td><?php echo( $rec_user['taal'] ); ?></td>
        <td><?php echo( $rec_user['categorie_a'] ); ?></td>
        <td><?php echo( $rec_user['categorie_b'] ); ?></td>
        <td><a href="index.php?p=statistieken_user&amp;email_id=<?php echo($rec_user['email_id']); ?>">Meer info</a></td>
    </tr>
    
<?php } ?>

</table>
<br /><br />