<?php

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


function showList(){	
	global $mysqli;
	
	//// Get Info Introtext \\\\
	$introquery = 'SELECT title, description 
			  FROM winkelintro AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "winkelintro" 
			  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 stores">';
		$output .= '<h1>'.$introtitle.'</h1>';
		
		
		$output .= '<hr class="mid-content" />';
		
		//social media
		// FACEBOOK \\
//		$output .= '<a class="hover-button socialtop top-facebook-btn" href="https://www.facebook.com/langstraat.biz/" target="_blank">
//						<span class="btn-facebook"></span>
//						<span class="btn-facebookhover hover"></span>
//					</a>';
		
		//// intro tekst \\\\
		$output .= '<div class="page-column">';
			$output .= $introdescription;
		$output .= '</div>';


        /**
         * A / B testing
         */
        // Do we have a query string (QnD fix)
        if(isVariant()) {
            // Show button
            $output .= '<div class="page-column centered-button-holder">';

                $output .= '<a href="/route/" class="hover-button w306 large">
                                <span class="btn-text large">Kom eens langs</span>
                                <span class="large-arrow-circle btn-arrow large"></span>
                                <span class="btn-orange-306"></span>
                                <span class="btn-darkorange-306 hover"></span>
                            </a>';
                $output .= '<div class="clear"></div>';
            $output .= '</div>';
        }


		$output .= '<div class="clear"></div>';
		
		//// Get Info Winkelaanbod \\\\
		$query = 'SELECT w.id, w.title, w.onderschrift, w.website, w.telefoon, w.naam, w.description, w.thumbnail
				  FROM winkelaanbod AS w, content_status AS s
				  WHERE s.active = 1
				  AND s.itemId = w.id
				  AND s.linkname = "winkelaanbod" 
				  ORDER BY w.itemOrder DESC'; 
		$result = $mysqli->query($query);
		
		$output .= '<div class="thumb-row">';

        $blocks = '';
		$i = 1;
		while($record = $result->fetch_assoc()){	
			$bedrijfsnaam = fromDatabase($record['title']);
			$onderschrift = fromDatabase($record['onderschrift']);
			$website = $displayWeb = fromDatabase($record['website']);
			$shortcode = $record['thumbnail'];
			$telefoon = fromDatabase($record['telefoon']);
			if(substr($website,0,7) != 'http://' && !empty($website)) $website = 'http://'.$website;

            $blocks .='<div class="block">
                        <h2>'.$bedrijfsnaam.'</h2>
                        <span class="pay-off">'.$onderschrift.'</span>';
            if(!empty($telefoon)){ $blocks .= '<span class="thumbnail-telefoon">'.$telefoon; }
            if(!empty($displayWeb)){ $blocks .= ' - <a href="'.$website.'" target="_blank">'.$displayWeb.'</a></span>'; }
            $blocks .= '<div class="image-container">';

            $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();
            $coloredImage = $mediaRecord['filename_hover'];
            $mediaTitle = fromDatabase($mediaRecord['title']);

            $linkBedrijfsnaam = linkname($bedrijfsnaam);


            $blocks .= '<a class="image-holder" href="./onze-winkels/'.$linkBedrijfsnaam.'/">';
            $blocks .= '<img src="./images/uploads/'.$coloredImage.'" alt="'.$mediaTitle.'" />';
            $blocks .= '</a>';

            $blocks .= '<a class="hover-button web-btn" href="./onze-winkels/'.$linkBedrijfsnaam.'/">
                                <span class="btn-text">Lees meer</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 winkelintro AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "winkelintro" 
			  LIMIT 1'; 
	$introresult = $mysqli->query($introquery);
	$introrecord = $introresult->fetch_assoc();
	
	$introtitle = fromDatabase($introrecord['title']);
	
	//// get id \\\\
	$idquery = 'SELECT w.id, w.title FROM winkelaanbod AS w, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = w.id
			  AND s.linkname = "winkelaanbod"'; 
	$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 w.id, w.title, w.website, w.onderschrift,  w.telefoon, w.naam, w.description, w.thumbnail
				  FROM winkelaanbod AS w, content_status AS s
				  WHERE s.active = 1
				  AND s.itemId = w.id
				  AND s.linkname = "winkelaanbod" 
				  AND w.id = '.$itemId.' LIMIT 1'; 
		$result = $mysqli->query($query);
		$record = $result->fetch_assoc();
	
		$ervaringId = $record['id'];
		$bedrijfsnaam = fromDatabase($record['title']);
		$onderschrift = fromDatabase($record['onderschrift']);
		$naam = fromDatabase($record['naam']);
		
		$description = fromDatabase($record['description']);
		$description = replaceShortcodes($description, 352);
		
		$shortcode = $record['thumbnail'];
		
		$telefoon = fromDatabase($record['telefoon']);
		$website = $displaywebsite = fromDatabase($record['website']);
		
		if(substr($website,0,7) != 'http://' && !empty($website)) $website = 'http://'.$website;
		
		$output = '';
		
		
		//// create variable \\\\
		$output = '';
		$output .= '<div class="pagetop"></div>';
		
		$output .= '<div class="mid-content-container page-top-margin">';
			$output .= '<h1>'.$introtitle.' &rsaquo; '.$bedrijfsnaam.'</h1>';
			$output .= '<hr class="mid-content" />';
			
			//// intro tekst \\\\
			$output .= '<div class="page-column margin-right-40 no-mobile-margin-bottom">';
        $output .= include DOCUMENT_ROOT . '/app/views/partials/backButton.php';

        if(!empty($naam)) {
                $output .= '<span class="interiew-name">interview met '.$naam.'</span>';
                $output .= '<span class="interiew-pay-off">van '.$bedrijfsnaam.'</span>';
            }
            else
            {
                $output .= '<span class="interiew-name">' . $bedrijfsnaam .'</span>';
                $output .= '<span class="interiew-pay-off">van '.$onderschrift.'</span>';
            }
				
				$output .= $description;

                //$output .= include DOCUMENT_ROOT . '/app/views/partials/backButton.php';



        $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, winkelaanbod_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 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 .= '<br /><br />';
				$output .= '<strong>'.$bedrijfsnaam.'</strong><br />';
				if(!empty($onderschrift)) $output .= '<span class="pay-off">'.$onderschrift.'</span><br />';
				$output .= '<br />';
				if(!empty($telefoon)) $output .= $telefoon.'<br />';
				if(!empty($website)) $output .= '<a href="'.$website.'" target="_blank">'.$displaywebsite.'</a><br />';
				
			$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;
	
}