<?php

	$page_nr = $sub_subpagina;
	$artikelen_pp = 20;
	
	if(empty($page_nr)){ 
		$page_nr = 1; 
		$van_nr = 0;	
		$tot_nr = 17;	
	}else{
		$van_nr = (($page_nr - 1) * $artikelen_pp) - 3;	
		$tot_nr = $artikelen_pp;
	}

	$q_count = "SELECT COUNT(kms_projecten.project_id) AS totaal_articles FROM kms_projecten WHERE kms_projecten.categorie = '$subpagina'";
	$r_count = mysql_query($q_count);
	$rec_count = mysql_fetch_array($r_count);
	
	$erbij = 1 / 17;
	
	$max_pagina = ceil(($rec_count['totaal_articles'] / $artikelen_pp) + $erbij);
	
	$q_projecten = "SELECT kms_projecten.project_id, kms_projecten.naam, kms_projecten.categorie, kms_projecten.url, kms_projecten.image_dir FROM kms_projecten WHERE kms_projecten.categorie = '$subpagina' ORDER BY kms_projecten.sort_order ASC LIMIT ".$van_nr.", ".$tot_nr;
	$r_projecten = mysql_query($q_projecten);

?>
    
<ul class="projectenOverzicht">

<?php 
$first = true;
$counter = 1;

while($rec_projecten = mysql_fetch_array($r_projecten)){ 
	
	$q_foto = sprintf("SELECT kms_project_images.icon_dir FROM kms_project_images WHERE kms_project_images.project_id='%s' ORDER BY kms_project_images.sort_order ASC LIMIT 0,1", $rec_projecten[0]);
	$r_foto = mysql_query($q_foto);
	$rec_foto = mysql_fetch_array($r_foto);
	
	if(!empty($rec_foto[0])){ ?>

	<li class="<?php if($first){ echo("first"); if($page_nr == 1) { echo(" groot"); } } ?><?php if($counter == 8){ echo("first"); } ?><?php if($counter == 13){ echo("first"); } ?>">
    	<a href="/projecten/<?php echo(str_replace("_","-",$rec_projecten['categorie'])); ?>/<?php echo($rec_projecten['url']); ?>"><span><?php echo(html_entity_decode($rec_projecten['naam'])); ?></span>
        <?php if($first){ ?>	
        	<img src="/project_images/<?php echo($rec_projecten['image_dir']); ?>/tegel_<?php echo($rec_foto[0]); ?>.jpg" />
        <?php }else{ ?>
        	<img src="/project_images/<?php echo($rec_projecten['image_dir']); ?>/thumb_<?php echo($rec_foto[0]); ?>.jpg" />
        <?php } ?>
        </a>
    </li>
<?php	
	$first = false;
	$counter++;
	
	$categorie_naam = str_replace("_"," ",ucfirst($rec_projecten['categorie']));
	$categorie_naam = str_replace(" en "," &amp; ",$categorie_naam);
	$categorie_url = str_replace("_","-",$rec_projecten['categorie']);
	
	}
} ?>

</ul>

<div class="projectenFooter">
	<div class="breadCrump"><a href="/" title="Home">home</a>&nbsp;/&nbsp;<a href="/projecten/algemeen" title="Projecten">projecten</a>&nbsp;/&nbsp;<a class="active" href="/projecten/<?php echo($categorie_url); ?>" title="<?php echo($categorie_naam); ?>"><?php echo(strtolower($categorie_naam)); ?></a></div>
    <div class="paginaNummers">
    	<ul>
		<?php for ($nummer = 1; $nummer <= $max_pagina; $nummer++) { ?>
                <li><a <?php if($nummer == $page_nr){ echo("class=\"active\""); } ?> 
                href="/<?php echo("projecten/".$categorie_url); if($nummer != 1) { echo("/".$nummer); } ?>" title="Pagina <?php echo($nummer); ?>">
				<?php if( strlen($nummer) == 1){ echo("0".$nummer); }else{ echo($nummer); } ?></a>
                <?php if($nummer != $max_pagina){ echo("<span>|</span>"); } ?></li>
        <?php } ?>
       </ul>
    </div>    
</div>