<?php

function getHome(){
	global $mysqli;
	
	//// create variable \\\\
	$output = '';
	
	//// Get Info \\\\
	$query = 'SELECT title, description 
			  FROM welkom AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "welkom" 
			  LIMIT 1'; 
	$result = $mysqli->query($query);
	$record = $result->fetch_assoc();
	
	$title = fromDatabase($record['title']);
	$description = fromDatabase($record['description']);	
	
	//// banner \\\\
	$output .= '<div id="banner-holder">';	
	
		// get info \\
	$bannerquery = 'SELECT b.title, b.photo, b.link, b.name ,b.quote  
			  FROM banners AS b, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = b.id
			  AND s.linkname = "banners"
			  ORDER BY itemOrder ASC'; 
	if($bannerresult = $mysqli->query($bannerquery)){
		$numbanners = $bannerresult->num_rows;
		if($numbanners > 0){
			
			$output .= '<div class="large-banner-mask" id="large-banner-mask">';

				$i = 0;
				$banners = array();
				$quotes = array();
				while($bannerrecord = $bannerresult->fetch_assoc()){
					$bannertitle = fromDatabase($bannerrecord['title']);	
					$shortcode = $bannerrecord['photo'];
					$url = $bannerrecord['link'];

                    if(substr($url,0,7) != 'http://' &&
                            substr($url,0,8) != 'https://' &&
                            substr($url,0,1) != '/' &&
                            !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] = array();
					$banners[$i]['name'] = $bannerrecord['name'];
					$banners[$i]['quote'] = $bannerrecord['quote'];
					$banners[$i]['url'] = $url;
                    $banners[$i]['output'] = '';
                    $images = '/images/uploads/'.$filename;
//                    echo $images.'<br/>';
//                    echo "<img src='".$images."'/><br/>";

                    if(!empty($url)){
                        $banners[$i]['output'] .= '<a class="image-slider" href="'.$url.'" style="background-image: url('.$images.');"></a>';
                    }
                    else
                    {
                        $banners[$i]['output'] .= '<span class="image-slider" style="background-image: url('.$images.');"></span>';
                    }
					$i++;
				}
				
				//randomize
				shuffle($banners);
				
				//max 5 banners
				if($numbanners > 5) $numbanners = 5;
				for($i=0;$i<$numbanners;$i++){
					
					//quote
					if(!empty($banners[$i]['quote'])){
						if(!empty($url)) $output .= '<a href="'.$banners[$i]['url'].'">';
						$output .= '<div id="bannerquote'.($i+1).'" class="quote-holder"';
						$output .= '>';
							$output .= '<div class="quote-left"></div><div class="quote-mid">';
							if(!empty($banners[$i]['name'])) $output .= '<span class="name">'.$banners[$i]['name'].':</span>';
							$output .= '&ldquo;'.$banners[$i]['quote'].'&rdquo;</div>';
							$output .= '<div class="quote-right"></div>';
							$output .= '<div class="clear"></div>';
						$output .= '</div>';
						if(!empty($url)) $output .= '</a>';
					}
					else{
						$output .= '<div id="bannerquote'.($i+1).'"	class="hidden"></div>';
					}
					
					//image
					$output .= '<div id="bannerimage'.($i+1).'" class="large-banner-holder"';
					if($i != 0) $output .= ' style="opacity:0"';
					$output .= '>';
				
					$output .= $banners[$i]['output'];
				
					$output .= '</div>';
				}
				$output .= '<script type="text/javascript">updateNumLargeBanner('.$numbanners.')</script>';
			$output .= '</div>';
			
		}
		else{	
			$output .= '<div id="banner-image"><img src="./images/temp/jan.jpg" alt="jan jansen" /></div>';
		}
	}
	else{	
		$output .= $mysqli->error;
		//$output .= '<div id="banner-image"><img src="./images/temp/jan.jpg" alt="jan jansen" /></div>';
	}

	$output .= '</div>';
	$output .= '<div class="banner-shadow"></div>';
	
	//// content \\\\
	$output .= '<div class="mid-content-container">';
	
		//// heading \\\\
		$output .= '<h1>'.$title.'</h1>';
		$output .= '<hr class="mid-content" />';
		
		//// text \\\\
		$output .= '<div class="home-text-column">';
			$output .= $description;
		$output .= '</div>';
		
		//// buttons \\\\
		$output .= '<div class="home-btn-column">';
			
			// ORANGE BUTTON WINKELAANBOD \\
			$output .= '<a class="hover-button large w248 home-our-shops" href="./onze-winkels/">
							<span class="btn-text large">Onze winkels</span>
							<span class="large-arrow-circle btn-arrow large"></span>
							<span class="btn-orange-248"></span>
							<span class="btn-darkorange-248 hover"></span>
						</a>';
			//$output .= '<a href="./winkelaanbod/" class="btn-orange-248">Bekijk<br />winkelaanbod<span class="large-arrow-circle btn-large-arrow"></span></a>';

			// LEUK WINKELEN / ERVARINGEN \\
			$output .= '<a class="hover-button w248" href="./klantervaringen/">
							<span class="btn-text">Ervaringen van klanten</span>
							<span class="arrow btn-arrow"></span>
							<span class="btn-green-248"></span>
							<span class="btn-darkgreen-248 hover"></span>
						</a>';
			//$output .= '<a href="./referenties/" class="btn-green-248">Ervaringen van klanten<span class="arrow btn-arrow"></span></a>';

			// FACEBOOK \\
			$output .= '<a class="hover-button social home-facebook-btn" href="https://www.facebook.com/verrassendveel/" target="_blank">
							<span class="btn-facebook"></span>
							<span class="btn-facebookhover hover"></span>
						</a>';
			
			//$output .= '<a href="https://www.facebook.com/langstraat.biz/" target="_blank" class="btn-facebook home-facebook-btn"></a>';
			$output .= '<span class="home-facebook-link"><a href="https://www.facebook.com/verrassendveel/" target="_blank">Like ons op Facebook</a></span><br />';


			
			# VESTIGEN KNOP
			/*$cbresult = $mysqli->query('SELECT homeButton FROM vestigen LIMIT 1');
			$cbrecord = $cbresult->fetch_assoc();
			$hb = $cbrecord['homeButton'];
			if($hb == 1){
				$output .= '<div class="pand-te-huur">';
					$output .= '<h2>Ondernemers opgelet:</h2>';
					$output .= '<a href="./vestigen/" class="btn-brown-244" title="pand te huur">Pand te huur! <span class="arrow btn-arrow"></span></a>';
				$output .= '</div>';
			}*/
			
			
			
		$output .= '</div>';
		
		$output .= '<div class="clear"></div>';
		$output .= '<hr class="mid-content" />';
	$output .= '</div>';
	
	//// return output \\\\
	return $output; 
	
}

?>