<?php

function getErvaringen(){
	
	$output = '';
	
	if(isset($_GET['sub'])){
		$output .= showInterview();
	}
	else{
		$output .= showList();
	}
	
	return $output;
}


function showList(){
	
	global $mysqli;
	
	//// Get Info Introtext \\\\
	$introquery = 'SELECT title, description 
			  FROM ervaringenintro AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "ervaringenintro" 
			  LIMIT 1'; 
	$introresult = $mysqli->query($introquery);
	$introrecord = $introresult->fetch_assoc();
	
	$introtitle = fromDatabase($introrecord['title']);
	$introdescription = fromDatabase($introrecord['description']);
	
	//// create variable \\\\
	$output = '';
	$output .= '<div class="pagetop"></div>';
	
	$output .= '<div class="mid-content-container page-top-margin references">';
		$output .= '<h1>'.$introtitle.'</h1>';
		$output .= '<hr class="mid-content" />';

		//// intro tekst \\\\
		$output .= '<div class="page-column">';
			$output .= $introdescription;
		$output .= '</div>';
		$output .= '<div class="clear"></div>';
		//// Get Info Winkelaanbod \\\\
		$query = 'SELECT e.id, e.title, e.naam, e.description, e.thumbnail
				  FROM ervaringen AS e, content_status AS s
				  WHERE s.active = 1
				  AND s.itemId = e.id
				  AND s.linkname = "ervaringen" 
				  ORDER BY e.itemOrder DESC'; 
		$result = $mysqli->query($query);
		
		$output .= '<div class="thumb-row">';
		
		$blocks = '';
		$i = 1;
		while($record = $result->fetch_assoc()){	
			$ervaringId = $record['id'];
			$quote = fromDatabase($record['title']);
			$naam = fromDatabase($record['naam']);
			$shortcode = $record['thumbnail'];

            $blocks .='<div class="block">
                        <h2 class="quote"><span class="first-quote">&ldquo;</span>'.$quote.'&rdquo;</h2>
                        <span class="pay-off">'.$naam.'</span>';
            $blocks .= '<div class="image-container">';


            $shortcode = substr($shortcode, 1, -1);
            $mediaResult = $mysqli->query('SELECT id, title, path, filename_hover FROM media_files WHERE shortcode = "'.$shortcode.'" LIMIT 1');
            $mediaRecord = $mediaResult->fetch_assoc();
            $filename = $mediaRecord['path'];
            $hover = $mediaRecord['filename_hover'];
            $mediaTitle = fromDatabase($mediaRecord['title']);
            $linkQuote = linkname($quote);


            $blocks .= '<a id="client' . $ervaringId . '" class="image-holder" href="./klantervaringen/'.$linkQuote.'/">';
            $blocks .= '<img src="./images/uploads/'.$hover.'" alt="'.$mediaTitle.'" />';
            $blocks .= '</a>';
            $blocks .= '<a class="hover-button web-btn" href="./klantervaringen/'.$linkQuote.'/" >
								<span class="btn-text">Lees het interview</span>
								<span class="arrow btn-arrow"></span>
								<span class="btn-green-288"></span>
								<span class="btn-darkgreen-288 hover"></span>
							</a>';


            $blocks .= '</div></div>';
            $output .= $blocks;
            $blocks = '';

			$i++;
		}
		$output .= '<div class="clear thumb-img-replacement"></div>';
		$output .= '</div>';
	$output .= '</div>';

	//// return output \\\\
	return $output; 
	
}

function showInterview(){
	global $mysqli;
	
	//// get intro \\\\
	$introquery = 'SELECT title 
			  FROM ervaringenintro AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "ervaringenintro" 
			  LIMIT 1'; 
	$introresult = $mysqli->query($introquery);
	$introrecord = $introresult->fetch_assoc();
	
	$introtitle = fromDatabase($introrecord['title']);
	
	//// get id \\\\
	$idquery = 'SELECT e.id, e.title FROM ervaringen AS e, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = e.id
			  AND s.linkname = "ervaringen"'; 
	$idresult = $mysqli->query($idquery);
	while($idrecord = $idresult->fetch_assoc()){
		$title = fromDatabase($idrecord['title']);
		$link = linkname($title);
		if($link == $_GET['sub']) $itemId = $idrecord['id'];
	}
	
	if(isset($itemId) && !empty($itemId)){
	
	
		//// Get Info ervaringen \\\\
		$query = 'SELECT e.id, e.title, e.naam, e.description, e.thumbnail
				  FROM ervaringen AS e, content_status AS s
				  WHERE s.active = 1
				  AND s.itemId = e.id
				  AND s.linkname = "ervaringen" 
				  AND e.id = '.$itemId.' LIMIT 1'; 
		$result = $mysqli->query($query);
		$record = $result->fetch_assoc();
	
		$ervaringId = $record['id'];
		$quote = fromDatabase($record['title']);
		$naam = fromDatabase($record['naam']);
		$description = fromDatabase($record['description']);
		$description = replaceShortcodes($description, 352);
		$shortcode = $record['thumbnail'];
		$output = '';
		
		
		//// create variable \\\\
		$output = '';
		$output .= '<div class="pagetop"></div>';
		
		$output .= '<div class="mid-content-container page-top-margin ">';
			$output .= '<h1>'.$introtitle.' &rsaquo; interview&hellip;</h1>';
			$output .= '<hr class="mid-content" />';
			
			//// intro tekst \\\\
			$output .= '<div class="page-column margin-right-40 no-mobile-margin-bottom">';
				$output .= '<span class="interiew-name">&hellip;met '.$naam.'</span>';
				$output .= '<h2 class="quote">&ldquo;'.$quote.'&rdquo;</h2>';
				
				$output .= $description;
				
				
				$output .= '<a class="hover-button" href="./klantervaringen/">
								<span class="btn-text-back">Terug naar overzicht</span>
								<span class="arrow-back btn-arrow-back"></span>
								<span class="btn-green-288"></span>
								<span class="btn-darkgreen-288 hover"></span>
							</a>';
				
				
			$output .= '</div>';
			
			//// image \\\\
			$output .= '<div class="page-column no-mobile-margin-top">';
				$shortcode = substr($shortcode, 1, -1);
				$mediaResult = $mysqli->query('SELECT title, path, filename_hover FROM media_files WHERE shortcode = "'.$shortcode.'" LIMIT 1');
				$mediaRecord = $mediaResult->fetch_assoc();
				$filename = $mediaRecord['path'];
				$hover = $mediaRecord['filename_hover'];
				$mediaTitle = $mediaRecord['title'];
				
				$photoRel = linkname($mediaTitle);
				$photoRel = str_replace('-','',$photoRel);
				
				///// photos \\\\\
				$photoquery = 	'SELECT mf.title, mf.path 
								FROM media_files AS mf, ervaringen_photos AS ph
								WHERE ph.shortcode = mf.shortcode
								AND ph.itemId = '.$itemId.'
								ORDER by ph.photoOrder';
				$photosResult = $mysqli->query($photoquery);				
				$numphotos = $photosResult->num_rows;
				
				$first = '';
				$other = '';
				$count = 0;
				while($photoRecord = $photosResult->fetch_assoc()){
					$photoPath = $photoRecord['path'];
					if($count == 0){ $first = './images/uploads/'.$photoPath; }
					else{
						$other .= '<a href="./images/uploads/'.$photoPath.'" rel="lightbox['.$photoRel.']" class="hidden">&nbsp;</a>';
					}
					$count++;
				}
				
				if($numphotos > 0){ $output .= '<a class="image-holder slider interview-image" href="'.$first.'" rel="lightbox['.$photoRel.']">'; }
				else{$output .= '<span class="image-holder slider interview-image">'; }
					// als de naam leeg is is het geen interview maar gwoon informatie
					if($numphotos > 0) $output .= '<span class="plus"></span>';
					if($numphotos > 0) $output .= '<span class="white"></span>';

					$output .= '<img src="./images/uploads/'.$hover.'" alt="'.$mediaTitle.'" />';
				if($numphotos > 0){$output .= '</a>';}
				else{$output .= '</span>'; }
				$output .= $other;
				
				
			$output .= '</div>';
			$output .= '<div class="clear"></div>';
		$output .= '</div>';
	}
	else{
		$output = '';
		$output .= '<div class="pagetop"></div>';
		
		$output .= '<div class="mid-content-container page-top-margin">';
			$output .= '<h1>Oeps...</h1>';
			$output .= '<hr class="mid-content" />';
			
			//// intro tekst \\\\
			$output .= '<div class="page-column">';
				$output .= 'Dit interview is helaas niet gevonden. Onze excuses voor het ongemak.';
			$output .= '</div>';
			$output .= '<div class="clear"></div>';
		$output .= '</div>';
	}
	
	return $output;
	
}



?>