<?php
/**
 * Extra Search Joomla! 1.5 Native Component
 * @version 3.8.3
 * @author Design COmpass corp <support@joomlaboat.com>
 * @link http://www.joomlaboat.com
 * @GNU General Public License
 **/

// no direct access
defined('_JEXEC') or die('Restricted access');

jimport( 'joomla.application.component.view');




class YouTubeGalleryViewThemelist extends JView
{
    function display($tpl = null)
    {

		global $mainframe;
		
		

		JToolBarHelper::title(JText::_('YouTube Gallery - Theme Lists'), 'generic.png');
		
		
		JToolBarHelper::addNewX('newItem');
		
		JToolBarHelper::customX( 'copyItem', 'copy.png', 'copy_f2.png', 'Copy', true);
		
		JToolBarHelper::customX( 'uploadItem', 'upload.png', 'upload_f2.png', 'Import', false);
		JToolBarHelper::deleteListX();


		$db = & JFactory::getDBO();

		$context			= 'com_youtubegallery.themelist.';

		$filter_order		= $mainframe->getUserStateFromRequest( $context.'filter_order',		'filter_order',		's.id',	'cmd' );
		$filter_order_Dir	= $mainframe->getUserStateFromRequest( $context.'filter_order_Dir',	'filter_order_Dir',	'',			'word' );
		
		$search				= $mainframe->getUserStateFromRequest( $context.'search',			'search',			'',			'string' );
		
		$limit		= $mainframe->getUserStateFromRequest( $context.'limit', 'limit', $mainframe->getCfg('list_limit'), 'int' );
		$limitstart = $mainframe->getUserStateFromRequest( $context.'limitstart', 'limitstart', 0, 'int' );

		$where = array();

		if ($search)
		{
			$where[] = 'LOWER(s.themename) LIKE '.$db->Quote( '%'.$db->getEscaped($search,true).'%', false );

		}
		
		

		$where		= count( $where ) ? ' WHERE ' . implode( ' AND ', $where ) : '';
		

		$query = 'SELECT COUNT(*)'
		. ' FROM #__youtubegallery_themes AS s '
		. $where
		;
		
		
		$db->setQuery( $query );
		if (!$db->query())    echo ( $db->stderr());
		$total = $db->loadResult();
		

		$orderby	= 'ORDER BY '. $filter_order .' '. $filter_order_Dir ;
		//$inner=array();
		//$inner[]='LEFT JOIN `#__youtubegallery_categories` ON #__youtubegallery_categories.id=catid';
		//$inner[]='LEFT JOIN `#__youtubegallery_videos` ON #__youtubegallery_videos.listid=s.id AND #__youtubegallery_videos.isvideo';
		//. implode (' ', $inner).' '		
		
		jimport('joomla.html.pagination');
		$pageNav = new JPagination( $total, $limitstart, $limit );

		$query = 'SELECT s.* FROM #__youtubegallery_themes AS s '
		. $where

		. $orderby
		
		;
		
		$db->setQuery($query, $pageNav->limitstart, $pageNav->limit );
		if (!$db->query())    echo ( $db->stderr());
		
		$rows = $db->loadObjectList();
		
		
		if(!isset($rows))
		{
			$rows=array();
		}
		
		
		foreach($rows as $r)
			$r->checked_out='';


		$javascript		= 'onchange="document.adminForm.submit();"';

		$lists['order_Dir']	= $filter_order_Dir;
		$lists['order']		= $filter_order;

		// search filter
		$lists['search']= $search;
		$this->assignRef('items',		$rows);
		$this->assignRef('pagination',		$pageNav);
		$this->assignRef('lists',		$lists);


		parent::display($tpl);
    }
}
?>