<?php
	$q_project = "SELECT kms_projecten.project_id, kms_projecten.naam, kms_projecten.categorie, kms_projecten.bouwmaand, kms_projecten.bouwjaar, kms_projecten.architect, kms_projecten.locatie, kms_projecten.omschrijving, kms_projecten.image_dir, kms_projecten.url, kms_projecten.sort_order FROM kms_projecten WHERE kms_projecten.url='$sub_subpagina' AND kms_projecten.categorie = '$subpagina'";

	$r_project = mysql_query($q_project);

	$rec_project = mysql_fetch_array($r_project);
	
	switch ($rec_project['bouwmaand']) {
		case "jan":	$maand = "Januari";	break;
		case "feb": $maand = "Februari"; break;
		case "mrt": $maand = "Maart"; break;
		case "apr": $maand = "April"; break; 
		case "mei": $maand = "Mei";	break;
		case "juni": $maand = "Juni"; break;
		case "julie": $maand = "Juli"; break;
		case "aug": $maand = "Augustus"; break;
		case "sept": $maand = "September"; break;
		case "okt": $maand = "Oktober"; break;
		case "nov": $maand = "November"; break;
		case "dec": $maand = "December"; break;
	}
	
	$categorie_naam = str_replace("_"," ",ucfirst($rec_project['categorie']));
	$categorie_naam = str_replace(" en "," &amp; ",$categorie_naam);
	$categorie_url = str_replace("_","-",$rec_project['categorie']);

?>

<div class="projectDetail">

	<h1><?php echo(html_entity_decode($rec_project['naam'])); ?></h1>

    <div class="data">
        <em>Bouwjaar</em> <?php echo($maand); ?> <?php echo($rec_project['bouwjaar']); ?><br />
        <em>Architect</em> <?php echo(html_entity_decode($rec_project['architect'])); ?><br />
        <em>Locatie</em> <?php echo(html_entity_decode($rec_project['locatie'])); ?><br />
        <em>Categorie</em> <?php echo(html_entity_decode($categorie_naam)); ?>
    </div>     
    <?php echo(html_entity_decode($rec_project['omschrijving'])); ?>  

</div>
<div id="projectFotos">

    <div class="projectFotosFotos">
        <ul>
        <?php
	        $foto_counter = 0;
			$q_fotos = "SELECT kms_project_images.icon_dir FROM kms_project_images WHERE kms_project_images.project_id =".$rec_project['project_id']." ORDER BY kms_project_images.sort_order ASC";
			$r_fotos = mysql_query($q_fotos);
			
			while($rec_fotos = mysql_fetch_array($r_fotos)){ $foto_counter++;
		?>      
        	<li><img src="/project_images/<?php echo($rec_project['image_dir']); ?>/foto_<?php echo($rec_fotos['icon_dir']); ?>.jpg" width="364" /></li>
        <?php } ?>    
        </ul>        
    </div>
    <div class="projectFotosMenu">
        <ul>
        <?php for ($i = 1; $i <= $foto_counter; $i++) { if( strlen($i) == 1){ $nummer = "0".$i; }else{ $nummer = $i; } ?>
            <li><a><?php echo($nummer); ?></a></li>
        <?php } ?>       
        </ul>
    </div>
    <div class="projectFotosArrows">
    	<?php if($foto_counter > 1){ ?>
            <ul>
                <li class="first"><a class="prevBtn"></a></li>
                <li><a class="nextBtn"></a></li>
            </ul>
        <?php } ?>
    </div>


</div>
<div class="projectenMenu">

	<?php 
	if($rec_project['sort_order'] == 1){ ?>
		<a class="vorige grijs">&laquo; vorig project</a>
	<?php }else{
		
		$prev_order = $rec_project['sort_order'] - 1;
		$q_project_prev = "SELECT kms_projecten.url FROM kms_projecten WHERE kms_projecten.categorie='$subpagina' AND kms_projecten.sort_order='$prev_order'";
		$r_project_prev = mysql_query($q_project_prev);
		$rec_project_prev = mysql_fetch_array($r_project_prev);	?>
		
		<a class="vorige" href="/projecten/<?php echo($categorie_url); ?>/<?php echo($rec_project_prev['url']); ?>">&laquo; vorig project</a>

	<?php } ?>
		
		<a class="overzicht" href="/projecten/<?php echo($categorie_url); if($_SESSION['subpagina_nummer'] > 1){ echo("/".$_SESSION['subpagina_nummer']); } ?>">overzicht</a>
    
	<?php 
    
        $q_project_count = "SELECT COUNT(kms_projecten.project_id) as totaal_artikelen FROM kms_projecten WHERE kms_projecten.categorie='$subpagina'";
        $r_project_count = mysql_query($q_project_count);
        $rec_project_count = mysql_fetch_array($r_project_count);
    
    
        if($rec_project['sort_order'] == $rec_project_count['totaal_artikelen']){ ?>
            <a class="volgende grijs">volgend project &raquo;</a>
    <?php }else{
        
            $next_order = $rec_project['sort_order'] + 1;
            $q_project_next = "SELECT kms_projecten.url FROM kms_projecten WHERE kms_projecten.categorie='$subpagina' AND kms_projecten.sort_order='$next_order'";
            $r_project_next = mysql_query($q_project_next);
            $rec_project_next = mysql_fetch_array($r_project_next);	?>
            
            <a class="volgende" href="/projecten/<?php echo($categorie_url); ?>/<?php echo($rec_project_next['url']); ?>">volgend project &raquo;</a>
    <?php	}	?>
    
    
</div>

<div class="gerelateerdeProjecten">
	<h2>Gerelateerde projecten</h2>

	<ul>
    <?php 
		$order_nummers;
		$new_order = 1;
		$nieuwe_totaal = $rec_project_count['totaal_artikelen'] - $rec_project['sort_order'];
		
		$first_order = true;
		
		for ($nummer = 1; $nummer <= $rec_project['sort_order'] + 5; $nummer++) {
			
			if($nummer <= $nieuwe_totaal){
				$order_nummers[$nummer] = $rec_project['sort_order'] + $nummer;
			}else{
				$order_nummers[$nummer] = $new_order;
				$new_order++;
			}
			if($order_nummers[$nummer] == $rec_project['sort_order']){
				$order_nummers[$nummer] = "";
			}
		}

		$q_rel = sprintf("SELECT kms_projecten.project_id, kms_projecten.naam, kms_projecten.image_dir, kms_projecten.url FROM kms_projecten WHERE kms_projecten.categorie='%s' AND (kms_projecten.sort_order='%s' OR kms_projecten.sort_order='%s' 
		OR kms_projecten.sort_order='%s' OR kms_projecten.sort_order='%s' OR kms_projecten.sort_order='%s') ORDER BY kms_projecten.sort_order ASC", $subpagina, 
		$order_nummers[1], $order_nummers[2], $order_nummers[3], $order_nummers[4], $order_nummers[5]);
		$r_rel = mysql_query($q_rel);
		
		while($rec_rel = mysql_fetch_array($r_rel)){	
		
			$q_thumb = "SELECT kms_project_images.icon_dir FROM kms_project_images WHERE kms_project_images.project_id =".$rec_rel['project_id']." ORDER BY kms_project_images.sort_order ASC";
			$r_thumb = mysql_query($q_thumb);
			$rec_thumb = mysql_fetch_array($r_thumb); ?>
            
	        <li class="<?php if($first_order){ echo("first"); } ?>"><a href="/projecten/<?php echo($categorie_url); ?>/<?php echo($rec_rel['url']); ?>">
            	<span><?php echo(html_entity_decode($rec_rel['naam'])); ?></span><img src="/project_images/<?php echo($rec_rel['image_dir']); ?>/thumb_<?php echo($rec_thumb['icon_dir']); ?>.jpg" /></a>
            </li>
            
		<?php $first_order = false; } ?>
    </ul>
</div>

<div class="projectenFooter">
	<div class="breadCrump">
    	<a href="/" title="Home">home</a>&nbsp;/&nbsp;<a href="/projecten/algemeen" title="Projecten">projecten</a>&nbsp;/
        <a href="/projecten/<?php echo($categorie_url); ?>" title="<?php echo($categorie_naam); ?>"><?php echo(strtolower($categorie_naam)); ?></a>&nbsp;/
        <a class="active" href="/projecten/<?php echo($categorie_url); ?>/<?php echo($rec_project['url']); ?>" title="<?php echo(html_entity_decode($rec_project['naam'])); ?>"><?php echo(strtolower(html_entity_decode($rec_project['naam']))); ?></a>
	</div>
</div>