<?php

function getActueel(){
	global $mysqli;
	
	//// Get Info Introtext \\\\
	$query = 'SELECT a.title, a.description, a.date 
			  FROM actueel AS a, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = a.id
			  AND s.linkname = "actueel"
			  ORDER BY a.itemOrder DESC';
	$result = $mysqli->query($query);
	$numTotalItems = $result->num_rows;
			  
	//set max items
	$maxItems = 5;
	$numPages = ceil($numTotalItems / $maxItems); 
	if($numPages == 0) $numPages = 1;
	
	//set current page
	$sessionName = 'actueel_thisPage';
	if(isset($_SESSION[$sessionName])){
		$thispage = $_SESSION[$sessionName];
	}
	else{
		$thispage = 1;
	}
	
	$limitFrom = ($thispage * $maxItems)-$maxItems;

	//load max items
	$query .= ' LIMIT '.$limitFrom.','.$maxItems;		
	$result = $mysqli->query($query);
	
	//check if page is still needed
	$newNumItems = $result->num_rows;
	if($newNumItems == 0 && $numTotalItems != 0){
		$_SESSION[$sessionName]	=  $_SESSION[$sessionName] - 1;
		header('location: ./');		
	}		  
		  
	
	//// create variable \\\\
	$output = '';
	$output .= '<div class="pagetop"></div>';
	$output .= '<div class="mid-content-container page-top-margin">';
		$output .= '<h1>Actueel</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>';

	$output .= '</div>';
	
	$output .= '<div class="mid-small-content-container">';
	
	while($record = $result->fetch_assoc()){
	
		$title = fromDatabase($record['title']);
		$date = fromDatabase($record['date']);
		$description = fromDatabase($record['description']);
		$description = replaceShortcodes($description, 496);	
			$output .= '<div class="actueel-item-holder">';
				$output .= '<h3>'.$title.'</h3>';
				$output .= '<span class="date">'.$date.'</span>';
				$output .= $description;
		$output .= '</div>';	
	}
	
	
		//page control
	if($numPages > 1){
		$output .= '<div class="page-control">';
			if($thispage != 1){ $output .= '<span class="page-control-previous" onclick="updateSession(\''.$sessionName.'\','.($thispage-1).')">Vorige pagina</span>'; }
			if($thispage != $numPages){ $output .= '<span class="page-control-next" onclick="updateSession(\''.$sessionName.'\','.($thispage+1).')">Volgende pagina</span>'; }
		$output .= '</div>';
	}
	
	$output .= '</div>';
	
	
	
	//// return output \\\\
	return $output; 
	
}

?>