An Idea: Additional Admin Menu for Additional extensions!

Code: Select all

<?php

// Viewer support functions for HTML templates


//
// use OpenCart's admin/config.php
//
require_once("config.php");


//
// find the last update date of the menu DB tables
//
function lastMenusUpdate() {
	$sql = "SHOW TABLE STATUS FROM ".DB_NAME." LIKE 'menu%';";
	$rows = mysql_query($sql) or die('Query failed: ' . mysql_error());
	$result = "0000-00-00 00:00:00";
	while ($row = mysql_fetch_array($rows, MYSQL_ASSOC)) {
		$lastUpdate = $row['Update_time'];
		if ($lastUpdate > $result) {
			$result = $lastUpdate;
		}
	}
	return $result;
}


//
// get an array of menu items from a database query and/or session object
//
function getMenus( $languageId ) {
	if ( (!isset($_SESSION['menus'])) || 
	     (!isset($_SESSION['menus_date'])) ||
	     ($_SESSION['menus_date'] < lastMenusUpdate())
	) {
		$menus =  array();
		$sql  = "SELECT m.menu_id, m.parent_menu_id, m.title, m.icon, m.href, m.sort_order, md.* ";
		$sql .= "FROM `menu` m ";
		$sql .= "INNER JOIN menu_description md ON md.menu_id = m.menu_id ";
		$sql .= "AND md.language_id =$languageId ";
		$sql .= "ORDER BY m.parent_menu_id, m.sort_order, m.menu_id;";
		$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
		while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
			$menus[] = $row;
		}
		$_SESSION['menus'] = &$menus;
		$_SESSION['menus_date'] = date( "Y-m-d H:i:s" );
		mysql_free_result($result);
	}
	return $_SESSION['menus'];
}


//
// generate an HTML view of (possibly nested) menus, using UL and LI HTML-elements
//
function generateMenusView( &$menus, $id, $level, $noRaquo=FALSE ) {
	$listItems = "";
	$style = "";
	$width = 0;
	$j = count( $menus );
	for ($i=0; $i<$j; $i++) {
		$menu = $menus[$i];
		if ($menu['parent_menu_id'] != $id) {
			continue;
		}
		$title = $category['title'];
		$href = HTTP_SERVER."index.php?".htmlentities(urlencode($menu['href']));
		$subList = generateMenusView( $menus, $menu['menu_id'], $level+2, $noRaquo );
		$indent = str_repeat( "  ", $level+1 );
		$listItems .= ($i != 0) ? $indent : "";
		$listItems .= "<li><a href=\"$href\">";
		if (strlen($subList)>0) {
			if ($id==0) {
				$listItems .= htmlentities($title);
				$listItems .= ($noRaquo) ? "" : " »";
			}
			else {
				$listItems .= ($noRaquo) ? "" : " <span style=\"float:right;\">»</span>";
				$listItems .= htmlentities($title);
			}
		}
		else {
			$listItems .= htmlentities($title);
		}
		$listItems .= "</a>";
		$width = max( $width, strlen($title) );
		$listItems .= ($subList != "") ? "\n".$subList : "";
		$listItems .= ($subList != "") ? $indent : "";
		$listItems .= "</li>\n";
	}
	$result = "";
	if (strlen($listItems) > 0) {
		if ($id>0) {
			$width = round($width * 12.5) + (($width <= 10) ? 12.5*2 : 0);
			$indent = str_repeat( "  ", $level );
			$result = $indent;
			$result .= "<ul style=\"width:$width"."px;\">\n".$listItems;
			$result .= $indent;
			$result .= "</ul>\n";
		}
		else {
			$result = $listItems;
		}
	}
	return $result;
}

?>

Code: Select all

<div class="adminMenu">
  <ul>
    <li>Admin
      <ul>
        <li>Home</li>
        <li>Catalog</li>
        <li>Configuration
          <ul>
            <li>Setting</li>
....
....
....
          </ul>
        </li>
      </ul>
    </li> 
  </ul>
</div>