<?php
	
/* 
	Deense Kroon
	About
	
	Mike Ontwerpt 2012
	www.mikeontwerpt.nl
	
	initAbout(); 
	

*/
function initAbout(){
	$output = '';

	$output .= showAbout();
	//$output .= showCollection();	
	$output .= showAllProducts();
	return $output;
}


function showAbout(){
	/* get mysqli */
	global $mysqli;
	$output = '';
	/* get info */
	$query = 'SELECT o.title, o.titleEn, o.image, o.description, o.descriptionEn
			  FROM over AS o, content_status AS s
			  WHERE s.active = 1
			  AND o.id = 1
			  AND s.itemId = o.id
			  AND s.linkname = "over"
			  AND o.published = 1 
			  ORDER BY o.itemOrder DESC
			  LIMIT 1';
	if($result = $mysqli->query($query)){
		
		$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']);


        $output .= '
            <div class="contained-layout image-text about">
                <div class="col-3 col-image image-holder">
                 ' . $image . '          
                </div>
                <div class="col-3 col-text">
                    <div class="text-block">
                        <h1>'.$title.'</h1>
                        ' . $description . '                        
                    </div>
                    
                    <div class="about-social-holder">
                        <div class="btn-social">
                            <a href="https://www.facebook.com/pages/Deense-Kroon/270632859677919" target="_blank" class="btn-facebook">
                                <span class="btn-facebook btnhover"></span>
                            </a>
                        </div>
                        <div class="btn-social">
                            <a href="http://twitter.com/#!/deensekroon" class="btn-twitter" target="_blank" >
                                <span class="btn-twitter btnhover"></span>
                            </a>
                        </div>
                    </div>
                </div>
            </div>';

	}
	
	return $output;	

}

function showFilter(){
	global $mysqli;
	$output = '';
	$output .= '<div class="collection-title">';
		$output .= '<h2>collectie</h2>';
	$output .= '</div>';
	if($catResult = $mysqli->query('SELECT id, category FROM product_categories ORDER BY category ASC')){
		
		////////////// FILTER \\\\\\\\\\\\\\
	$output .= '<ul id="filterlist-home">';
			$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;
}
?>