<?php

/* 
	Deense Kroon
	Blog
	
	Mike Ontwerpt 2012
	www.mikeontwerpt.nl
	
	initBlog(); 
	
	showLargeBanner();
	showPopular();
	showCollection();

*/
	
function initBlog(){
	$output = '';
	
	if(defined('URL_SUB')){
		$output .= showBlogItem();
	}
	else{
		$output .= showBlogPage();
	}
	return $output;
}

function showBlogPage(){
	/* get mysqli */
	global $mysqli;
	$output = '';
	$output .= '<div class="blog-item-holder">';
		$output .= '<h1>deense kroon blogt</h1>';
	$output .= '</div>';
	/* get info */
	$query = 'SELECT b.title, b.description, b.timest
			  FROM blog AS b, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = b.id
			  AND s.linkname = "blog"
			  AND b.published = 1 
			  ORDER BY b.itemOrder DESC';
	if($result = $mysqli->query($query)){
		
		while($record = $result->fetch_assoc()){
			$title = $record['title'];
			$description = $record['description'];
			
			$title = fromDatabase($title);
			$linkTitle = linkname($title);
			$description = fromDatabase($description);
			$description = replaceShortcodes($description);
			
			$date = date('d / m / y', $record['timest']);
			
			$output .= '<div class="blog-item-holder">';
				$output .= '<span class="blog-item-date">'.$date.'</span>';
				$output .= '<span class="blog-item-title"><a href="/blogt/'.$linkTitle.'/">'.$title.'</a></span>';
				$output .= '<span class="blog-item-description">'.$description.'</span>';
				$output .= '<div class="blog-social-holder">';
					$output .= '<a href="#" class="btn-facebook"></a>';
					$output .= '<a href="#" class="btn-twitter"></a>';
				$output .= '</div>';
			$output .= '</div>';
			
		}
	}
	
	return $output;
}


function showBlogItem(){
	/* get mysqli */
	global $mysqli;
	
	//search for id
	$itemId = 0;
	$titleQuery = 'SELECT b.id, b.title
			  FROM blog AS b, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = b.id
			  AND s.linkname = "blog"
			  ORDER BY b.itemOrder DESC';
	if($titelResult = $mysqli->query($titleQuery)){
		while($titleRecord = $titelResult->fetch_assoc()){
			$title = fromDatabase($titleRecord['title']);
			$linkTitle = linkname($title);
			if($linkTitle == URL_SUB){
				$itemId = $titleRecord['id'];
			}
		}
	}	
	$output = '';
	$output .= '<div class="blog-item-holder">';
		$output .= '<h1>deense kroon blogt</h1>';
		$output .= '<a href="/blogt/">&lsaquo; terug naar ons blog</a>';
	$output .= '</div>';
	
	if($itemId != 0){
		
		/* get info */
		$query = 'SELECT b.title, b.description, b.timest
				  FROM blog AS b, content_status AS s
				  WHERE s.active = 1
				  AND s.itemId = b.id
				  AND s.linkname = "blog"
				  AND b.id = '.$itemId.' LIMIT 1';
		if($result = $mysqli->query($query)){
			
			while($record = $result->fetch_assoc()){
				$title = $record['title'];
				$description = $record['description'];
				
				$title = fromDatabase($title);
				$linkTitle = linkname($title);
				$description = fromDatabase($description);
				$description = replaceShortcodes($description);
				
				$date = date('d / m / y', $record['timest']);
				
				$output .= '<div class="blog-item-holder">';
					$output .= '<span class="blog-item-date">'.$date.'</span>';
					$output .= '<span class="blog-item-title"><a href="/blogt/'.$linkTitle.'/">'.$title.'</a></span>';
					$output .= '<span class="blog-item-description">'.$description.'</span>';
					$output .= '<div class="blog-social-holder">';
						$output .= '<a href="#" class="btn-facebook"></a>';
						$output .= '<a href="#" class="btn-twitter"></a>';
					$output .= '</div>';
				$output .= '</div>';
				
			}
		}
	}
	else{
		$output .= 'Helaas werd er geen bericht gevonden';	
	}
	return $output;
	
}


?>