<?php
	$q_cat = sprintf("SELECT kms_categories.categorie_name, kms_categories.url FROM kms_categories WHERE kms_categories.url='%s'", $pagina);
	$r_cat = mysql_query($q_cat);
	$rec_cat = mysql_fetch_array($r_cat);
	
	$q_subcat = sprintf("SELECT kms_subcategories.subcategorie_id, kms_subcategories.subcategorie_name, kms_subcategories.url FROM kms_subcategories WHERE kms_subcategories.url='%s'", $subpagina);
	$r_subcat = mysql_query($q_subcat);
	$rec_subcat = mysql_fetch_array($r_subcat);
	
	$page_nr = $sub_subpagina;

	if(empty($page_nr)){ 
		$page_nr = 1; 
		$van_nr = 0;	
		$tot_nr = 12;	
	}else{	
		$van_nr = (($page_nr - 1) * $artikelen_pp) - 1;	
		$tot_nr = $artikelen_pp;
	}

	$vorige_pagina = $page_nr - 1;
	$volgende_pagina = $page_nr + 1; 
	
	$q_count = sprintf("SELECT COUNT(kms_articles.article_id) AS totaal_articles FROM kms_articles WHERE kms_articles.subcategorie_id = '%s' AND kms_articles.popular = 'no'", $rec_subcat['subcategorie_id']);
	$r_count = mysql_query($q_count);
	$rec_count = mysql_fetch_array($r_count);
	
	$erbij = 1 / 12;
	
	$max_pagina = ceil(($rec_count['totaal_articles'] / $artikelen_pp) + $erbij);
	
	if($page_nr == 1){ 
		if($rec_count['totaal_articles'] == 0){
			$totaal_weergave_van_1 = 0; 
		}else{
			$totaal_weergave_van_1 = 1; 
		}
		if($max_pagina > 1){
			$totaal_weergave_van_2 = 12 + 2; 
		}else{
			if($rec_count['totaal_articles'] > 0){
				$totaal_weergave_van_2 = $rec_count['totaal_articles'] + 2;
			}else{
				$totaal_weergave_van_2 = 2;
			}
		}
	}else{
		$pagina_voor = ($page_nr - 2) * 13;
		$totaal_weergave_van_1 = $pagina_voor + 14 + 1; // voorheen + eerste pagina + een extra
		
		if($max_pagina > $page_nr){
			$totaal_weergave_van_2 = $totaal_weergave_van_1 + 13 - 1; // -1 is de verbetering van de plus 1	
		}else{
			if($rec_count['totaal_articles'] >= 2){
				$totaal_weergave_van_2 = $rec_count['totaal_articles'] + 2;	
			}else{
				$totaal_weergave_van_2 = $rec_count['totaal_articles'];	
			}
		}		
	}
	if($rec_count['totaal_articles'] > 0){
		$totaal_weergave_tot = $rec_count['totaal_articles'] + 2; 
	}else{
		$totaal_weergave_tot = 2; 
	}
	
	if(($totaal_weergave_van_2 - $totaal_weergave_van_1) < 5){
		$extraCSS = true;	
	}
?>			

<div id="headerBreadcrump">
	<div class="dotLineTop"></div>
	<div class="textLeft"><a href="/">Home</a><span class="slash">/</span><a class="active" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); ?>"><?php echo(html_entity_decode($rec_subcat['subcategorie_name'])); ?></a></div>
    <div class="textCenter">
		<?php 
        if($rec_count['totaal_articles'] == 0){
			echo("Geen artikelen"); 
        }else{
            echo($totaal_weergave_van_1." - ".$totaal_weergave_van_2." van ".$totaal_weergave_tot." artikelen"); 
        } ?>
    </div>
    <div class="textRight">
    <?php if($max_pagina != 1){ ?>
    	<ul>
		<?php 
			for ($nummer = 1; $nummer <= $max_pagina; $nummer++) { ?>
                
                <li><a <?php if($nummer == $page_nr){ echo("class=\"active\""); } ?> 
                href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); if($nummer != 1) { echo("/".$nummer); } ?>" title="Pagina <?php echo($nummer); ?>"><?php echo($nummer); ?></a>
                <?php if($nummer != $max_pagina){ echo("<span class=\"dash\">|</span>"); } ?></li>
                
        <?php } ?>
	    </ul>  
    <?php } ?>      
    </div>   
    <div class="clear_both"></div>
    <div class="dotLineBottom"></div>
</div>

<div id="leftSide">

    <div id="searchBlock" class="width281">
        <?php include("searchBlock.php"); ?>
    </div>
    
    <div id="contactBlock" class="width281">
        <?php include("contactBlock.php"); ?>
    </div>
    
</div>

<div id="rightSide">
    <div id="mainContent">
    
   	<?php if(empty($sub_subpagina)){ ?> 
        <div id="mainLeft">
            <ul class="populairProducts <?php if($extraCSS){ echo("minWidth"); }?>">
            
            <?php            
            	$q_pop_articles = sprintf("SELECT kms_articles.article_name, kms_articles.article_number, kms_articles.brand_id, kms_articles.image_dir, kms_articles.url, kms_brands.brand_name FROM kms_articles INNER JOIN kms_brands ON kms_articles.brand_id = kms_brands.brand_id WHERE kms_articles.subcategorie_id='%s' AND kms_articles.popular = 'yes' ORDER BY kms_articles.sort_order ASC", $rec_subcat['subcategorie_id']);
				$r_pop_articles = mysql_query($q_pop_articles);
				
				$pop_art_counter = 0;
				
				while($rec_pop_articles = mysql_fetch_array($r_pop_articles)){ ?>
                <li class="<?php if($pop_art_counter % 2 == 0){ echo("first"); } ?> width236">
                    <div class="topBackgr"></div>
                    <div class="contentBlock">
                        <div class="divContent">
                            <div class="title"><strong><?php echo(html_entity_decode($rec_cat['categorie_name'])); ?></strong> populair</div>
                            <div class="name">
                                <a class="productName" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_pop_articles['url']); ?>" title="<?php echo(html_entity_decode($rec_pop_articles['article_name'])); ?>"><span class="nameSpan"><?php echo(html_entity_decode($rec_pop_articles['article_name'])); ?></span><span class="arrows">&raquo;</span></a>
                                <span class="categorieName"><?php echo(html_entity_decode($rec_pop_articles['brand_name'])); ?></span>
                            </div>                            
                            <div class="image">
                                <img src="/article_images/<?php echo($rec_pop_articles['image_dir']); ?>/populair.jpg" width="204" alt="<?php echo(html_entity_decode($rec_pop_articles['article_name'])); ?>"/>
                                <div class="artikelnr"><?php echo(html_entity_decode($rec_pop_articles['article_number'])); ?></div>
                            </div>
                        </div>                    
                    </div>
                    <div class="bottomBackgr"></div>
                </li>
             	<?php $pop_art_counter++; 
				} ?>
                             
            </ul>
        </div>

        <div id="mainRight">
            <?php include("rightSide.php"); ?>
        </div>  
        
    <?php } ?>              
    </div>
    
    <div id="subContent">
    
	<?php if(!empty($sub_subpagina)){ ?> 
        <div id="mainRight">
            <?php include("rightSide.php"); ?>
        </div>  
    <?php } ?>
    
        <ul class="overviewProducts <?php if($extraCSS){ echo("minWidth"); }?>" >
        	<?php
				$q_articles = sprintf("SELECT kms_articles.article_name, kms_articles.article_number, kms_articles.image_dir, kms_articles.url FROM kms_articles WHERE kms_articles.subcategorie_id='%s' AND kms_articles.popular = 'no' ORDER BY kms_articles.sort_order ASC LIMIT ".$van_nr.", ".$tot_nr, $rec_subcat['subcategorie_id']);
				$r_articles = mysql_query($q_articles);
				
				$articles_counter = 0;
				
				while($rec_articles = mysql_fetch_array($r_articles)){ ?>

                    <li class="
						<?php 
							if(empty($sub_subpagina)){
								if($articles_counter % 3 == 0){ echo("first"); } 
							}else{
								if($articles_counter <= 4){
									if($articles_counter % 2 == 0){ echo("first"); } 
									if($articles_counter == 4){ $articles_counter = 6; }
								}else{
									if($articles_counter % 3 == 0){ echo("first"); } 
								}								
							}
							
						?> width236">
                        <div class="topBackgr"></div>
                        <div class="contentBlock">
                            <div class="divContent">
                                <div class="name">
                                    <a href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']."/".$rec_articles['url']); ?>" title="<?php echo(html_entity_decode($rec_articles['article_name'])); ?>"><span class="nameSpan"><?php echo(html_entity_decode($rec_articles['article_name'])); ?></span><span class="arrows">&raquo;</span></a>
                                </div>                            
                                <div class="image">
                                    <img src="/article_images/<?php echo($rec_articles['image_dir']); ?>/thumb.jpg" width="125" alt="<?php echo(html_entity_decode($rec_articles['article_name'])); ?>"/>
                                    <div class="artikelnr"><?php echo(html_entity_decode($rec_articles['article_number'])); ?></div>
                                </div>
                                <div class="meerInfo">meer info</div> 
                            </div>                    
                        </div>
                        <div class="bottomBackgr"></div>
                    </li>
                <?php 
					$articles_counter++; 
				} ?>
                         
		</ul>
    </div>
    <?php if($max_pagina != 1){ ?>
        <div id="categoriePageMenu">
            <?php if($vorige_pagina > 0){ ?>
                <a class="arrowLeft" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); if($vorige_pagina != 1) { echo("/".$vorige_pagina); } ?>" title="Vorige pagina"></a>
            <?php }else{ ?>
                <a class="arrowLeft grijs"></a>
            <?php } ?>
            
            <?php 
            if($volgende_pagina <= $max_pagina){ ?>
                <a class="arrowRight" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); if($volgende_pagina != 1) { echo("/".$volgende_pagina); } ?>" title="Volgende pagina"></a>
            <?php }else{ ?>
                <a class="arrowRight grijs"></a>
            <?php } ?>
        </div>
   <?php } ?>
</div>

<div id="footerBreadcrump">
	<div class="dotLine"></div>
	<div class="textLeft"><a href="/">Home</a><span class="slash">/</span><a class="active" href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); ?>"><?php echo(html_entity_decode($rec_subcat['subcategorie_name'])); ?></a></div>
	<div class="textCenter"><?php echo($totaal_weergave_van_1);?> - <?php echo($totaal_weergave_van_2);?> van <?php echo($totaal_weergave_tot);?> artikelen</div>
    <div class="textRight">
    <?php if($max_pagina != 1){ ?>
    	<ul>
		<?php 
			for ($nummer = 1; $nummer <= $max_pagina; $nummer++) { ?>
                
                <li><a <?php if($nummer == $page_nr){ echo("class=\"active\""); } ?> 
                href="/<?php echo($rec_cat['url']."/".$rec_subcat['url']); if($nummer != 1) { echo("/".$nummer); } ?>" title="Pagina <?php echo($nummer); ?>"><?php echo($nummer); ?></a>
                <?php if($nummer != $max_pagina){ echo("<span class=\"dash\">|</span>"); } ?></li>
                
        <?php } ?>
	    </ul> 
    <?php } ?>       
    </div>   
</div>