<?php

function getTextWithAlbum($key,$linkname){
	
	//start output
	$output = '';
	
	//get info from database
	$query = 'SELECT DISTINCT a.id, a.linkname, a.title, a.description, a.albumOrder
				FROM '.$linkname.'_albums AS a, status AS s
				WHERE s.active = 1
				AND s.page = "'.$linkname.'"
				AND s.itemId = a.id
				ORDER by albumOrder DESC';
	$result = mysql_query($query);
	$numAlbums = mysql_num_rows($result);
	
	$query .= ' LIMIT 1';
	$result = mysql_query($query);
	
	if($numAlbums > 0){
		$record = mysql_fetch_assoc($result);
		$albumId = $record['id'];
		$title = fromDatabase($record['title']);
		$description = fromDatabase($record['description']);	
		$albumOrder = $record['albumOrder'];
		$description = replaceShortcodes($description); 
		
		//get page else page = 1
		$pageNr = 1;
		
		$headertitle = $title;
		if($linkname == 'totaalinrichting') $headertitle = $linkname;
		
		//decription
		$output .= '<div id="contentBox'.$key.'" class="contentBox">';
			$output .= '<h1 class="h1InContentBox">'.strtolower($headertitle).'</h1>';
			$output .= $description;
		$output .= '</div>';
			
		//logo and footer
		$output .= '<div class="textBlockContainer">
						<div class="headerBox">
							<img src="/images/structure/logowelcome.png" alt="Smulders Interieurprojecten" />
						</div>';
			$output .= '<div class="footerBox" id="footerBox'.$key.'">';
			//	$output .= '<span class="floatLeft link"><img src="./images/structure/arrowSmallLeft.png" alt="Smulders Interieur Heeze - vorige project" class="barArrow"/> <span class="adjustKerningV">V</span>orig project</span>';
			if($numAlbums > 1) $output .= '<span class="floatRight link" onclick="getNewAlbumPage(\''.$linkname.'\','.$key.','.$numAlbums.','.($albumOrder-1).');" ><span class="adjustKerningV">V</span>olgend project <img src="./images/structure/arrowSmallRight.png" alt="Smulders Interieur Heeze - volgend project" class="barArrow"/></span>'; 
				$output .= '<div class="clear"></div>';
			$output .= '</div>';
		$output .= '</div>';
			   
		## photos	   
		
		//get info from database
		$photoQuery = 'SELECT DISTINCT id, thumb, filename
					FROM '.$linkname.'_photos
					WHERE albumId = '.$albumId.'
					ORDER by photoOrder DESC ';
		$photoResult = mysql_query($photoQuery);
		$numPhotos = mysql_num_rows($photoResult);
		
		//set max items
		$maxPhotos = 9;
		$numPages = ceil($numPhotos / $maxPhotos); 
		if($numPages == 0) $numPages = 1;
		$thisPage = 1;
		
		//header
		$output .= '<div id="sp'.$key.'" class="spContainer" >';
			$output .= '<div class="spBar">';
				$output .= '<h2 class="floatLeft">Foto&rsquo;s bij '.strtolower($title).'</h2>';
				//$output .= '<span class="projectCount floatRight">1 / 3</span>';
				$output .= '<div class="clear"></div>';
			$output .= '</div>';
			//rows			
			$output .= '<div class="spContent">';
			$output .= '<div class="spColumnHolder">';
			$output .= '<div class="spColumn">';
			$output .= '<div class="spThumbRow">';
			
			$bigColCount = 0;
			$colCount = 0;
			$photoCount = 0;
			
			while($photoRecord = mysql_fetch_assoc($photoResult)){
				$photoId = $photoRecord['id'];
				$thumb = '/images/'.$linkname.'/'.$albumId.'/thumb/'.$photoRecord['thumb'];
				$filename = '/images/'.$linkname.'/'.$albumId.'/'.$photoRecord['filename'];
				
				if($bigColCount == 0 && $photoCount != 0){		
					//end row
					$output .= '<div class="clear"></div>';
					$output .= '</div>';
					//end column
					$output .= '<div class="clear"></div>';
					$output .= '</div>';
					//new column
					$output .= '<div class="spColumn">';
					//new row
					$output .= '<div class="spThumbRow">';
				}
				else if($colCount == 0 && $photoCount != 0){
					$output .= '<div class="clear"></div>';
					$output .= '</div>';
					$output .= '<div class="spThumbRow">';
				}
				
				$sb_linkname = str_replace('-','_',$linkname);
				$output .= '<div class="spThumb';
				if($colCount == 2)$output .= ' noMargin';
				$output .= '"><a href="'.$filename.'" class="shadowbox" data-rel="shadowbox['.$sb_linkname.$albumId.']" title="Smulders Interieur Heeze"><img src="'.$thumb.'" alt="" height="100"/></a></div>';
	
				$colCount++;
				$bigColCount++;
				$photoCount++;
				
				if($colCount == 3){
					$colCount = 0;
				}	
				
				if($bigColCount == $maxPhotos){
					$bigColCount = 0;
				}			
			}
			//end row
			$output .= '<div class="clear"></div>';
			$output .= '</div>';
			//end column
			$output .= '<div class="clear"></div>';
			$output .= '</div>';
			//end columnHolder
			$output .= '<div class="clear"></div>';
			$output .= '</div>';
			//end content
			$output .= '</div>';
			//pagecontrol
			$output .= '<div class="spBar spFooterBar">';
				//$output .= '<span class="floatLeft link"  onClick="smallAlbumNextPage(\'sp4\',\'prev\')"><img src="./images/structure/arrowSmallLeft.png" alt="Smulders Interieur Heeze - vorige project" class="barArrow"/> <span class="adjustKerningV">V</span>orige foto&rsquo;s</span>';
				if($numPages > 1) $output .= '<span class="floatRight link" onClick="smallAlbumNextPage(\''.$linkname.'\','.$key.','.$numPages.','.($thisPage+1).',\'next\');" >Meer foto&rsquo;s <img src="./images/structure/arrowSmallRight.png" alt="Smulders Interieur Heeze - vorige project" class="barArrow"/></span>';
			$output .= '</div>';
		
		$output .= '</div>';
	}	
	
	return $output;
	
}

?>