<?php
session_start();

require_once('connect.php');
require_once('functions.php');
// Choose language & get text
$lang = getLang();
require_once '../lang/'.$lang.'Strings.php';


$output = getSmallDocs();
echo $output;

function getSmallDocs(){
	
	//get text
	$siteText = getSiteText();
	
	if(isset($_SESSION['documents-groupLinkname'])){
		$groupId = $_SESSION['documents-groupLinkname'];
	}
	else{
		$groupId = 'all';	
	}
	
	$output = '';
	
	$pageName = $_GET['page'];
	//check if medialib
	$result = mysql_query('SELECT mediaLib FROM _pages WHERE name = "'.$pageName.'" LIMIT 1');
	$record = mysql_fetch_assoc($result);
	$mediaLib = $record['mediaLib'];
	//menu
		$output .= '<div class="small-lib-menu">';
			$output .= '<ul>';
			if($mediaLib == 1) $output .= '<li onclick="checkSmallLib(\'media\',\''.$pageName.'\')" class="small-lib-menu-non-active">'.$siteText['libSubMenuMediaTitle'].'</li>';
			$output .= '<li onclick="checkSmallLib(\'documents\',\''.$pageName.'\')">'.$siteText['libSubMenuDocTitle'].'</li>';
			$output .= '<div class="clear">';
		$output .= '</ul>';
		$output .= '</div>';
	
 	//content container
 	$output .= '<div class="single-column-content column-margin-left">';
	
		//title
		$output .= '<h1>'.$siteText['libSubMenuDocTitle'].'</h1>';
		//select album
		$output .= '<span class="small-lib-from-album">'.$siteText['fromGroup'].'</span>';
		$output .= '<div class="clear"></div>';
		
		//select menu
		$output .= '<form action="" id="moveToGroupForm" name="moveToGroupForm" method=post>';
			$output .= '<select name="selectToGroup" onChange="updateSessionInner(\'small-lib-con\',\'./php/smallDocs.php\',\'documents-groupLinkname\',this.value);" style="width: 198px;">';
				//first option
				$output .= '<option value="all">All</option>';
				// get all media groups and groupid's
				//media groups
				$groupquery = 'SELECT DISTINCT d.id, d.title, d.linkname
							  FROM documents_groups AS d, status AS s
							  WHERE s.itemId = d.id
							  AND s.active = "1"
							  ORDER BY d.title ASC';
				$groupresult = mysql_query($groupquery);
				while($grouprecord = mysql_fetch_assoc($groupresult)){
					$selectGroupId = $grouprecord['id'];
					$selectGroupTitle = $grouprecord['title'];
					$selectGroupLinkname = $grouprecord['linkname'];
					
					$output .= '<option value="'.$selectGroupId.'"';
						if($selectGroupId == $groupId ) $output .= ' selected ';
					$output .= '>'.$selectGroupTitle.'</option>';
				}
			$output .= '</select>';
		$output .= '</form>';
		$output .= '<div class="clear"></div>';		
		
	$query = 'SELECT d.id, d.title, d.shortcode, d.type, d.url, d.ext 
				FROM documents AS d, status AS s 
				WHERE s.page="documents" 
				AND s.itemId = d.id 
				AND s.active=1 
				ORDER BY d.timest DESC';	
	//overwrite the query above
	if($groupId != 'all'){			
		$query = 'SELECT DISTINCT d.id, d.title, d.ext, d.shortcode, d.url, d.timest
				  FROM documents AS d, status AS s, documents_groups AS dg, documents_grouprows AS dr
				  WHERE s.itemId = d.id
				  AND s.active = "1"
				  AND s.page = "documents"
				  AND dg.id = "'.$groupId.'"
				  AND dg.id = dr.groupId
				  AND d.id = dr.mediaId
				  ORDER BY d.id DESC';		
	}
					
	$result = mysql_query($query);
	$numItems = mysql_num_rows($result);
	
	//set max items
	$maxItems = 6;
	$numPages = ceil($numItems / $maxItems); 
	
	$sessionName = 'small-documents-'.$groupId.'-page';
	if(isset($_SESSION[$sessionName])){ 
		$thisPage = $_SESSION[$sessionName];
	}
	else{
		$thisPage = 1;
	}
	
	$limitFrom = ($thisPage * $maxItems)-$maxItems;
	
	// get only the number of items that you want
	$selectedQuery = $query .= ' LIMIT '.$limitFrom.', '.$maxItems.';';	
	$result = mysql_query($selectedQuery);
	
	$row = 0;
	$arr[0] = 'odd';
	$arr[1] = 'even';
	while($record = mysql_fetch_assoc($result)){
		$itemId = $record['id'];
		$title = fromDatabase($record['title']);
		$shortcode = $record['shortcode'];
		$ext = $record['ext'];
		
		
		if(strlen($title) > 22){
			$title = substr($title,0,20).'..';	
		}
		
		$output .= '<div class="small-lib-doc-row" onclick="checkInsert(\''.$shortcode.'\');">
						<div class="small-lib-doc-row-ext">'.$ext.'</div><div class="small-lib-doc-row-title">'.$title.'</div>
						<div class="clear"></div>
					</div>';
		
		
		/*$output .= '<div class="'.$arr[$row].'">';			
			//$output .= '<img src="'.$thumb.'" class="smallMediaMiniThumb" alt="'.$title.'" />';
			$output .= '<div class="smallMediaTitle">'.$title.'</div>';
			$output .= '<a href="#" class="smallMediaInsert" onclick="checkInsert(\''.$shortcode.'\');"><img src="./images/insert.png" /></a>';
			$output .= '<a href="#" class="smallMediaId">'.$shortcode.'</a>';
		$output .= '</div>';
		//$output .= '<input type="button" value="insert" class="insertMedia" onclick="checkInsert(\''.$shortcode.'\');"/></div>';
		*/
		$row == 0 ? $row++ : $row--;
	}
	
	$output .= '<div class="clear"></div>';
	
	//page control
	if($numPages > 1){
		$output .= '<div class="small-lib-page-control-container">';
			if($thisPage != 1){ $output .= '<span class="small-lib-page-control-previous" onclick="updateSessionInner(\'small-lib-con\',\'./php/smallDocs.php?page='.$pageName.'\',\''.$sessionName.'\','.($thisPage-1).');">'.$siteText['prevPage'].'</a></span>'; }
			if($thisPage != $numPages){ $output .= '<span class="small-lib-page-control-next"  onclick="updateSessionInner(\'small-lib-con\',\'./php/smallDocs.php?page='.$pageName.'\',\''.$sessionName.'\','.($thisPage+1).');">'.$siteText['nextPage'].'</a></span>'; }
		$output .= '</div>';
	}
	$output .= '</div>';
	
	return $output;		

}
?>