<?php

function getRoute(){
	global $mysqli;
	//// create variable \\\\
	$output = '';
	$output .= '<div class="pagetop"></div>';
	$output .= '<div class="mid-content-container page-top-margin route-page">';
		$output .= '<h1>Adres en route</h1>';
		$output .= '<hr class="mid-content" />';
		//social media
		// FACEBOOK \\
		$output .= '<a class="hover-button socialtop top-facebook-btn" href="https://www.facebook.com/verrassendveel/" target="_blank">
						<span class="btn-facebook"></span>
						<span class="btn-facebookhover hover"></span>
					</a>';
		
		$output .= '<div class="page-column">';

            // Contact
            $output .= '<p>';
            $output .= '<h2>Adres</h2>';
            $output .= 'VerrassendVeel winkels<br />
                        Langstraat 3<br />
                        5595 AA Leende';
            $output .= '</p>';

			//content 
			if(isset($_GET['sub'])){
				$idquery = 'SELECT r.id, r.title FROM route AS r, content_status AS s
						  WHERE s.active = 1
						  AND s.itemId = r.id
						  AND s.linkname = "route"'; 
				$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)){
				$query = 'SELECT DISTINCT r.title, r.description
						  FROM route AS r, content_status AS s
						  WHERE s.active = 1
						  AND s.itemId = r.id
						  AND s.linkname = "route" 
						  AND r.id = '.$itemId.' Limit 1';	
				}
				else{
				$query = 'SELECT DISTINCT r.title, r.description, r.itemOrder
					 	FROM route AS r, content_status AS s
					 	WHERE s.active = 1
						AND s.itemId = r.id
					  	AND s.linkname = "route" 
					  	ORDER BY r.itemOrder DESC Limit 1';
				}
			}
			else{
				$query = 'SELECT DISTINCT r.title, r.description, r.itemOrder
					 	FROM route AS r, content_status AS s
					  	WHERE s.active = 1
						AND s.itemId = r.id
					 	AND s.linkname = "route" 
					  	ORDER BY r.itemOrder DESC Limit 1';
			}
		
			if( ! $result = $mysqli->query($query)) dd($mysqli->error);
			$record = $result->fetch_assoc();
			$title = fromDatabase($record['title']);
			$description = fromDatabase($record['description']);
            $description = replaceShortcodes($description, 352);

            $output .= '<h2>'.$title.'</h2>';
			$output .= $description;
			
			
		$output .= '</div>';

        $output .= '<a target="_blank" href="https://www.google.nl/maps/@51.3582061,5.5646912,3a,75y,123.36h,89.62t/data=!3m9!1e1!3m7!1s_rzEUmhMjuoI0eK_JOPSIg!2e0!7i13312!8i6656!9m2!1b1!2i51?hl=nl">';
            $output .= '<span class="hover-button w306 large google-maps-btn">
                            <span class="btn-text large">Plan uw route<br />met Google Maps</span>
                            <span class="large-arrow-circle btn-arrow large"></span>
                            <span class="btn-orange-306"></span>
                            <span class="btn-darkorange-306 hover"></span>
                        </span>';

            $output .='<div id="map" data-googlex="51.357670" data-googley="5.564125"></div>';
        $output .= '</a>';

        $output .= '<div class="clear"></div>';

    $output .= '</div>';
	$output .= '<div class="clear"></div>';
	
	//// return output \\\\
	return $output; 
	
}

?>