<?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 YouTubeGalleryViewLinkslist extends JView
{
    function display($tpl = null)
    {

		global $mainframe;
		
		

		JToolBarHelper::title(JText::_('YouTube Gallery - Video Lists'), 'generic.png');
		
		
		JToolBarHelper::addNewX('newItem');
		
		JToolBarHelper::customX( 'copyItem', 'copy.png', 'copy_f2.png', 'Copy', true);
		JToolBarHelper::customX( 'updateItem', 'forward.png', 'forward_f2.png', 'Update', true);
		JToolBarHelper::customX( 'refreshItem', 'forward.png', 'forward_f2.png', 'Refresh ', true);
		JToolBarHelper::deleteListX();


		$db = & JFactory::getDBO();

		$context			= 'com_youtubegallery.linkslist.';

		$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' );

		$filter_category= $mainframe->getUserStateFromRequest($context."filter_category",'filter_category','',	'integer' );

		$where = array();

		if($filter_category!=0)
			$where[]='`catid`='.$filter_category;

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

		}
		
		

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

		$query = 'SELECT COUNT(*)'
		. ' FROM #__youtubegallery_videolists 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';
		
		
		jimport('joomla.html.pagination');
		$pageNav = new JPagination( $total, $limitstart, $limit );

		$query = 'SELECT s.*, #__youtubegallery_categories.categoryname AS the_categoryname, count(#__youtubegallery_videos.id) AS number_of_videos FROM #__youtubegallery_videolists AS s '
		. implode (' ', $inner).' '
		. $where
		
		
		. ' GROUP BY s.id '
		. $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;
		$available_categories=$this->getAllCategories();
		
		$lists['categories']=JHTML::_('select.genericlist', $available_categories, 'filter_category', $javascript ,'id','categoryname', $filter_category);

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


		parent::display($tpl);
    }
	
	function getAllCategories()
    {
        	$db =& JFactory::getDBO();
		
        	$query = 'SELECT `id`, `categoryname` FROM `#__youtubegallery_categories` ORDER BY `categoryname`';
        	$db->setQuery( $query );
        	$available_categories = $db->loadObjectList();
        	$this->array_insert($available_categories ,array("id" => 0, "categoryname" => JText::_( 'Select Category' )),0);
        	return $available_categories;
    }
	
	
	function array_insert(&$array, $insert, $position = -1)
    {
                $position = ($position == -1) ? (count($array)) : $position ;
                if($position != (count($array))) {
                $ta = $array;
                for($i = $position; $i < (count($array)); $i++)
                {
                        if(!isset($array[$i])) {
                                 die("\r\nInvalid array: All keys must be numerical and in sequence.");
                        }
                        $tmp[$i+1] = $array[$i];
                        unset($ta[$i]);
                }       
                $ta[$position] = $insert;
                $array = $ta + $tmp;
                
                } else {
                     $array[$position] = $insert;
                }
                ksort($array);
                return true;
    }   
}
?>