<?php

/**
 * @version		1.4
 * @package		mod_cn_mobileMenu
 * @author    	Caleb Nance
 * @copyright	Copyright (c) 2009 - 2010 CalebNance.com. All rights reserved.
 * @license		GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
 *
 *				helper.php
 */
 
 defined('_JEXEC') or die ('Access Denied');
 
 class modmobileMenuHelper
 {
	function getMenu($sublevel, $items)
	{
		# CONNECT TO DB FOR THE MENU INFO
		
		$db =& JFactory::getDBO();
		if($sublevel == 'all') {
			$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND sublevel = 0 ORDER BY ordering ASC";
		}else {
			$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND sublevel= '".$sublevel."' ORDER BY ordering ASC";
		}
		$db->setQuery($query);
		$options = $db->loadObjectList();
		
		return $options;
	}
	
	function getSubMenu1($id, $items){
		
		$db =& JFactory::getDBO();
		$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND parent = ".$id." AND sublevel = 1  ORDER BY ordering ASC";
		$db->setQuery($query);
		$options = $db->loadObjectList();
		
		return $options;
	}
	
	function getSubMenu2($id, $items){
		
		$db =& JFactory::getDBO();
		$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND parent = ".$id." AND sublevel = 2  ORDER BY ordering ASC";
		$db->setQuery($query);
		$options = $db->loadObjectList();
		
		return $options;
	}
	
	function getSubMenu3($id, $items){
		
		$db =& JFactory::getDBO();
		$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND parent = ".$id." AND sublevel = 3  ORDER BY ordering ASC";
		$db->setQuery($query);
		$options = $db->loadObjectList();
		
		return $options;
	}
	
	function getSubMenu4($id, $items){
		
		$db =& JFactory::getDBO();
		$query = "SELECT id, name, link, ordering, published, parent, sublevel FROM #__menu WHERE menutype = '".$items. "' AND published = 1 AND parent = ".$id." AND sublevel = 4  ORDER BY ordering ASC";
		$db->setQuery($query);
		$options = $db->loadObjectList();
		
		return $options;
	}
	 
 }