Rsg2DbSelections.php

<?php
/**
 * Class Rsg2DbSelections
 * Contains functions to select images, galleries from the RSGallery2 database
 * Returns lists
 * @copyright (C) 2015 RSGallery2 Team
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
 * @version 4.0.1
 */
class Rsg2DbSelections
{	
	/**
	* Get a list of all galleries (id/parent) ordered by parent/ordering
     * @return array of id/parent associations
	*/
    public function ListOfAllGalleriesOrdered ()
    {
		$database = JFactory::getDBO();
		$query = $database->getQuery(true);
        
		$query->select('id, parent')
		    ->from('#__rsgallery2_galleries')
		    ->order('parent, ordering');
		$database->setQuery( $query );
        
		$allGalleries = $database->loadObjectList();
	}	
	
	/**
	* Get limited ($count) number of random images
	* if $gallerySelection is set then only requested galleries will be returned
     * @param int $count Restricts size of returned array
     * @param string $gallerySelection defines gallery ids to use. Example "2,3"
     * @return array of db image items
	*/
    public function RandomImagesLimited ($count=0, $gallerySelection=null)
    {
		$database = JFactory::getDBO();
		$query = $database->getQuery(true);
        
		$query->select('*')
			->from('#__rsgallery2_files')
			->where('published = 1');

		/*	NOTE TODO Access should be checked for galleries, not for images
			// If user is not a Super Admin then use View Access Levels
			if (!$superAdmin) { // No View Access check for Super Administrators
				$query->where('access IN ('.$groupsIN.')'); //@todo use trash state: published=-2
			}
		*/
		
		// Select only galleries from what user wants
		if ($gallerySelection) {
			$query->where('gallery_id IN ('.$gallerySelection.')');
		}
		
		$query->order('rand()');
		$database->setQuery($query, 0, $count);	//$count is the number of results to return

		$randomImages = $database->loadAssocList();
		return $randomImages;
	}	
	
}