<?php
function initExtraleuk(){
	
	$output = '';
	$output .= '<div class="quintuple-column">';

    $output .= showIntro();

	$output .= showAllProducts(5,'extraleuk');
	$output .= '</div>';
	$output .= '<div class="clear"></div>';
	return $output;
}

function showIntro(){

    global $mysqli;
    $output = '';

    $query = 'SELECT p.title, p.titleEn, p.image, p.description, p.descriptionEn
			  FROM actie AS p, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = p.id
			  AND s.linkname = "actie"
			  AND p.published = 1
			  ORDER BY p.itemOrder DESC
			  LIMIT 1';
    if($result = $mysqli->query($query)){
        if($result->num_rows > 0)
        {
            $record = $result->fetch_assoc();
            $_SESSION['lang'] == 'nl' || empty($record['titleEn']) ? $title = fromDatabase($record['title']) : $title = fromDatabase($record['titleEn']);
            $_SESSION['lang'] == 'nl' || empty($record['descriptionEn']) ? $description = fromDatabase($record['description']) : $description = fromDatabase($record['descriptionEn']);
            $image = replaceShortcodes($record['image'],312);

            $output .= '<div class="sale-content-holder">';
                $output .= '<div class="sale-image-holder">';
                $output .= $image;
                $output .= '</div>';
                $output .= '<div class="sale-desc-holder">';

                $output .= '<h1>'.$title.'</h1>';
                $output .= $description;

                $output .= '</div>';
                $output .= '<div class="clear"></div>';
            $output .= '</div>';
            $output .= '<div class="clear"></div>';
        }
    }

    return $output;

}


function showFilter(){
	global $mysqli;
	$output = '';



	if($catResult = $mysqli->query('SELECT c.id, c.category 
									FROM product_categories AS c, content_status AS s
									WHERE s.active = 1
									AND s.itemId = c.id
									AND s.linkname = "product_categories" 
									ORDER BY c.category ASC')){
		
		////////////// FILTER \\\\\\\\\\\\\\
	$output .= '<ul id="filterlist-collection">';
			$output .= '<li><h2>filter</h2></li>';
			
			while($catRecord = $catResult->fetch_assoc()){
				$catId = $catRecord['id'];
				$category = $catRecord['category'];
				//create session
				if(!isset($_SESSION['show-categories'][$catId])){	
					$_SESSION['show-categories'][$catId] = 1;
				}
				$output .= '<li>
								<input class="cbfilter" type="checkbox" value="'.$category.'" name="cat'.$catId.'" onchange="filter(\'#placeholders .item-ph\');filter(\'#items .product-filterlist-thumb-holder\');"';
								if($_SESSION['show-categories'][$catId] == 1) $output .= ' checked';
								$output .= '> ';
								$output .= $category;
							$output .= '</li>';
			}
		$output .= '</ul>';
	}
	return $output;
}

?>