<?php

/* 
	Deense Kroon
	Collection
	
	Mike Ontwerpt 2012
	www.mikeontwerpt.nl
	
	initCollection(); 
	showFilter(); 
	showBanner(); 
	showCollection(); 

*/

function initCollection(){
	
	$output = '';

    if(defined('URL_SUB') && URL_SUB == 'van-het-merk'){
        $output .= showBrand(URL_SUB2);
    }
    else{
        $output .= showBanner();
    }

    //$output .= showCollection();
    $output .= showAllProducts(5);

	return $output;
}

function showBanner(){
	global $mysqli;
	$output = '';
	////////////////// BANNER \\\\\\\\\\\\\\\\\\\\\\\
	/* load & display small banner */
	//$output .= '<div class="middle-banner-holder">';
	// get info \\
	$query = 'SELECT b.title, b.bannerimage, b.url 
			  FROM banners AS b, content_status AS s
			  WHERE type = 2
			  AND s.active = 1
			  AND s.itemId = b.id
			  AND s.linkname = "banners"
			  ANd b.published = 1
			  ORDER BY itemOrder ASC'; 
	if($result = $mysqli->query($query)){
		$numbanners = $result->num_rows;
		if($numbanners > 0){
			$i = 0;
			$banners = array();
			while($record = $result->fetch_assoc()){
				$title = fromDatabase($record['title']);	
				$shortcode = $record['bannerimage'];
				$url = $record['url'];
				if(substr($url,0,7) != 'http://' && substr($url,0,8) != 'https://' && !empty($url)) $url = 'http://'.$url;
				
				//get image
				$shortcode = substr($shortcode, 1, -1);
				$mediaResult = $mysqli->query('SELECT title, path FROM media_files WHERE shortcode = "'.$shortcode.'" LIMIT 1');
				$mediaRecord = $mediaResult->fetch_assoc();
				$filename = $mediaRecord['path'];
				
				$banners[$i] = '';
					if(!empty($url)) $banners[$i] .= '<a href="'.$url.'" target="_blank">';
						$banners[$i] .= '<img src="/images/uploads/'.$filename.'" alt="'.$title.'" class="banner"/>';
					if(!empty($url)) $banners[$i] .= '</a>';
				$i++;
			}
			
			shuffle($banners);
			
			$output .= $banners[0];

		}
	}
	else{			
		$output .= '<img src="/images/temp/test-banner-middle.jpg" class="banner"/>';
	}
	//$output .= '</div>';
	return $output;	
}

function showBrand($linktitle){
	/* get mysqli */
	global $mysqli;
	
	//search for id
	$itemId = 0;
	$titleQuery = 'SELECT b.id, b.title
			  FROM merken AS b, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = b.id
			  AND s.linkname = "merken"
			  ORDER BY b.itemOrder DESC';
	if($titelResult = $mysqli->query($titleQuery)){
		while($titleRecord = $titelResult->fetch_assoc()){
			$title = fromDatabase($titleRecord['title']);
			$linkTitle = linkname($title);
			if($linkTitle == URL_SUB2){
				$itemId = $titleRecord['id'];
			}
		}
	}	
	
	$output = '';
	/* get info */
	$query = 'SELECT m.title, m.description, m.descriptionEn, m.image, m.logo, m.timest
			  FROM merken AS m, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = m.id
			  AND s.linkname = "merken"
			  AND m.id = '.$itemId.'
			  LIMIT 1';
		if($result = $mysqli->query($query)){
			$record = $result->fetch_assoc();
			$title = fromDatabase($record['title']);
			$_SESSION['lang'] == 'nl' || empty($record['descriptionEn']) ? $description = fromDatabase($record['description']) : $description = fromDatabase($record['descriptionEn']);
			$image = replaceShortcodes($record['image'],240);
			
			$shortcode = $record['logo'];
			//get image
			$shortcode = substr($shortcode, 1, -1);
			$mediaResult = $mysqli->query('SELECT title, path FROM media_files WHERE shortcode = "'.$shortcode.'" LIMIT 1');
			$mediaRecord = $mediaResult->fetch_assoc();
			$logo = '/images/uploads/'.$mediaRecord['path'];

			//calucate logo size
			$w = 120;
			$h = 16;
			if(is_file($_SERVER['DOCUMENT_ROOT'] . $logo))
			{
				$temp = getimagesize($_SERVER['DOCUMENT_ROOT'] . $logo);
				$thisW = $temp[0];
				$thisH = $temp[1];

				$ratio = $w/$h;
				if($thisH == 0 || (($thisW / $thisH) > $ratio)){
					$w = ($thisH*$w) / $h;
				}
			}
			$description = replaceShortcodes($description);
			
			$linktitle = linkname($title);
			$link = '/toont-haar-collectie/van-het-merk/'.$linktitle.'/';
			
			$output .= '<div class="brand-item-holder">';
                $output .= '<span class="brand-item-image">';
                    $output .= '<a href="'.$link.'"><span class="brand-item-logo"><img src="'.$logo.'" alt="'.$title.'" width="'.$w.'" /></span></a>';
                    $output .= '<a href="'.$link.'">'.$image.'</a>';
                $output .= '</span>';
                $output .= '<span class="brand-item-description">
								<h1>' . $title . '</h1>
								'.$description.'
							</span>';
				$output .= '<div class="clear"></div>';
			$output .= '</div>';
				
				
		}
	$output .= '<div class="clear"></div>';
	
	return $output;
}

	


?>