view.php

<?php

/**
 *  @module         foldergallery
 *  @version        see info.php of this module
 *  @author         cms-lab (initiated by Jürg Rast)
 *  @copyright      2010-2018 cms-lab 
 *  @license        GNU General Public License
 *  @license terms  see info.php of this module
 *  @platform       see info.php of this module
 * 
 */
 
// include class.secure.php to protect this file and the whole CMS!
if (defined('LEPTON_PATH')) {	
	include(LEPTON_PATH.'/framework/class.secure.php'); 
} else {
	$oneback = "../";
	$root = $oneback;
	$level = 1;
	while (($level < 10) && (!file_exists($root.'/framework/class.secure.php'))) {
		$root .= $oneback;
		$level += 1;
	}
	if (file_exists($root.'/framework/class.secure.php')) { 
		include($root.'/framework/class.secure.php'); 
	} else {
		trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR);
	}
}
// end include class.secure.php


$oFGF = foldergallery_frontend::getInstance();
$oFGF->init_frontend_page($page_id, $section_id);
LEPTON_handle::include_files ( '/modules/foldergallery/backend.functions.php');
$oTWIG = lib_twig_box::getInstance();
$oTWIG->registerModule('foldergallery');

// Foldergallery settings
$settings = $oFGF->fg_settings;
$thumb_size = $settings['thumb_size'];
$root_dir = $settings['root_dir'];
$catpic = (int) $settings['catpic'];
$ratio = $settings['ratio']; 

// Build the category tree
/*
$aCatTree = array();
$oFGF->buildCatTree( 0, $aCatTree, 0);
echo (LEPTON_tools::display( $aCatTree ,'pre','ui message'));
return 0; // No "die" - we just exit here (in this __FILE__ and keep the current process going on ..
*/
$result = array();
$subCat = array();
$images = array();
$error = false;
$title = PAGE_TITLE;


// only subpages/subfolder
if((isset($_GET['cat']) && is_string($_GET['cat']))) {
	$currentCat = $_GET['cat'];
} else {
	$currentCat = '';
}

$currentCat_id = 0;
$sRootDescription = NULL;
$bIsRootPage = false;

$all_cats = array();
$database->execute_query(
    'SELECT * FROM `'.TABLE_PREFIX.'mod_foldergallery_categories` WHERE `section_id`='.$section_id.' AND `is_empty`=0 AND `active`=1 ORDER BY `position` DESC',
    true,
    $all_cats,
    true
);

foreach($all_cats as &$result)
{
	$p = $result['parent'].'/'.$result['categorie'] ;
	
	if ($result['parent'] == '-1') 
	{
		$p = ''; 
		$sRootDescription = $result['description'];
		$sRootTitle = $result['cat_name'];
	}
	
	if ($p == $currentCat)
	{
		$currentCat_id = $result['id'];
		if( $result['parent'] == '-1' )
		{
		    $bIsRootPage = true;
		}
		break;	
	}
}

//	display root if there are no subfolders
if(!$currentCat){
	$sql = 'SELECT * FROM '.TABLE_PREFIX.'mod_foldergallery_categories WHERE section_id='.$section_id.' AND parent="" AND is_empty=0 AND active=1 ORDER BY position ASC';
} else {
	$sql = 'SELECT * FROM '.TABLE_PREFIX.'mod_foldergallery_categories WHERE section_id='.$section_id.' AND parent="'.$currentCat.'" AND is_empty=0 AND active=1 ORDER BY position DESC';
}

$subCats = array();
$database->execute_query(
    $sql,
    true,
    $subCats,
    true
);

if(count($subCats) == 0) {
	$error = true;
}

if(count($subCats > 0) && $subCats['parent_id'] != -1) {
// get thumb (file_name) from files table
	foreach($subCats as $thumb) {
		if($catpic == 2) { // last
				$cat_thumb = $database->get_one("SELECT file_name FROM ".TABLE_PREFIX."mod_foldergallery_files WHERE parent_id =".$thumb['parent_id']." ORDER BY position DESC");
		}
		if($catpic == 1) { // first
				$cat_thumb = $database->get_one("SELECT file_name FROM ".TABLE_PREFIX."mod_foldergallery_files WHERE parent_id =".$thumb['parent_id']." ORDER BY position ASC");
		}
		if($catpic == 0) { // random
				$all_thumbs = array();
				$database->execute_query("SELECT file_name FROM ".TABLE_PREFIX."mod_foldergallery_files WHERE parent_id =".$thumb['parent_id']." ORDER BY position" ,
					true,
					$all_thumbs,
					true
				);
				$cat_thumb = array_rand($all_thumbs);
		}		
	}
}




echo(LEPTON_tools::display($cat_thumb,'pre','ui red message'));
echo('<br />');
echo(LEPTON_tools::display($subCats['categorie'],'pre','ui info message'));

$bread = "";
// create breadcrumb, get current cat path (only for subgalleries, not root)
if ( isset( $_GET['cat'] ) ) {
    $path  = explode( '/', $_GET['cat'] );

    // first element is empty as the string begins with /
    array_shift($path);
    foreach ( $path as $i => $cat_name ) {
        $catres = $database->query("SELECT cat_name FROM ".TABLE_PREFIX."mod_foldergallery_categories WHERE categorie = '$cat_name' LIMIT 1");
        $cat    = $catres->fetchRow();
        $bread = '<li> <a href="'
               .  $oFGF->view_url
               .  '?cat=/'.implode('/', array_slice( $path, 0, ($i+1) ) )
               .  '">'.$cat['cat_name'].'</a></li>';
	}
	$breadcrumb = 1;

} else {
	$breadcrumb = 0;
}



// get thumbsize from settings
$catWidth = $settings['thumb_size'] + 10;
if ($settings['ratio'] > 1) {
	if ($settings['thumb_size']  >= 150) $catHeight = $settings['thumb_size'] + 10;
	else $catHeight = $settings['thumb_size']/$settings['ratio'] + 50 ;
}
else {
	if ($settings['thumb_size']  >= 150) $catHeight = $settings['thumb_size'] + 10;
	else $catHeight = $settings['thumb_size'] + 50 ;
}

$data = array(
	'oFGF'		=> $oFGF,
	'page_id'	=> $page_id,
	'section_id'=> $section_id,
	'breadcrumb'=> $breadcrumb,	
	'bread'		=> $bread,
	'subCats'	=>$subCats,
	'cat_thumb'	=>$cat_thumb,	
	'page_title'=> PAGE_TITLE,
	'all_cats'=>$all_cats,	
	'catWidth'=> $catWidth,
	'catHeight'=> $catHeight,
//	'AllCartegories' => $aAllCartegories,	
	'leptoken'	=> get_leptoken()
);
		
echo $oTWIG->render( 
	"@foldergallery/frontend/view_".$settings['lightbox'].".lte",	//	template-filename
	$data							//	template-data
);


?>