alternative sub-menu approach

Code: Select all

.box .category a {
	padding: 0px 0px 0px 10px;
	display: block;
	font-size:14px;
	font-weight:bold;
	text-decoration: none;
	margin-bottom: 8px;
}

Code: Select all

.box .subcategory a{
	background: url('../image/bullet_1.png') no-repeat 15px 4px;
	padding: 0px 0px 0px 25px;
	display: block;
	font-size:11px;
	font-weight:bold;
	text-decoration: none;
	margin-bottom: 8px;
}

Code: Select all

			$results = $database->getRows("select c.category_id, cd.name from category c left join category_description cd on (c.category_id = cd.category_id) where parent_id = '0' and language_id = '" . (int)$language->getId() . "' order by c.sort_order");

    		foreach ($results as $result) {
      			$category_data[] = array(
       				'name' => $result['name'],
        			'href' => $url->href('category', false, array('path' => $result['category_id']))
          		);
			}

Code: Select all

			$results = $database->getRows("select c.category_id, cd.name from category c left join category_description cd on (c.category_id = cd.category_id) where parent_id = '0' and language_id = '" . (int)$language->getId() . "' order by c.sort_order");

    		foreach ($results as $result) {
      			$category_data[] = array(
				'catid' => $result['category_id'],
       				'name' => $result['name'],
        			'href' => $url->href('category', false, array('path' => $result['category_id']))
          		);
			}

				$subcategory_data = array();
				
				$results = $database->getRows("select c.category_id, c.parent_id, cd.name from category c left join category_description cd on (c.category_id = cd.category_id) where c.parent_id != 0 and language_id = '" . (int)$language->getId() . "' order by c.sort_order");
				
        		foreach ($results as $result) {
          			$subcategory_data[] = array(
						'parid' => $result['parent_id'],
            			'name'  => $result['name'],
            			'href' => $url->href('category', false, array('path' => $result['category_id']))
      			);
				}
		    $view->set('subcategories', $subcategory_data);

Code: Select all

<div class="category">
    <?php foreach ($categories as $category) { ?>
    <a href="<?php echo $category['href']; ?>"><?php echo $category['name']; ?></a>
    <?php } ?>
  </div>

Code: Select all

    <?php foreach ($categories as $category) { ?>
      <div class="category"><a href="<?php echo $category['href']; ?>"><?php echo $category['name']; ?></a> </div>
	<?php foreach ($subcategories as $subcategory) { ?>
    <?php if  ($category['catid'] == $subcategory['parid']){ ?>
    <div class="subcategory"><a href="<?php echo $subcategory['href']; ?>"><?php echo $subcategory['name']; ?></a></div>
    <?php } ?>
    <?php } ?>
	    <?php } ?>
  

Code: Select all

<?php

//  The following comment appears at each modified location.
//  Changes to support sort order in Category drop down list.
require_once('Tree.php');
require_once('Tree/Factory/List.php');
//

class ModuleCategory extends Controller
{
	function fetch()
	{
		$config   =& $this->locator->get('config');
		$database =& $this->locator->get('database');
		$language =& $this->locator->get('language');
		$url      =& $this->locator->get('url');

		if ($config->get('category_status'))
		{
			$language->load('extension/module/category.php');

			$view = $this->locator->create('template');

    		$view->set('heading_title', $language->get('heading_title'));

    		$category_data = array();
            $list_data = array();

            $results = $database->getRows("select c.category_id, cd.name, c.parent_id, c.path, c.sort_order from category c left join category_description cd on (c.category_id = cd.category_id) where cd.language_id = '" . (int)$language->getId() . "' order by c.path");
    		foreach ($results as $result)
    		{
                $list_data[] = $result['path'];
      			$category_data[$result['category_id']] = array(
       				'name' => $result['name'],
        			'href' => $url->href('category', false, array('path' => $result['path'])),
                    'sort_order' => (int)$result['sort_order'],
                    'indent' => (count(explode('_', $result['path'])) - 1)
      			);
    		}

            $new_category_data = array();

			// If we get no data, there is no need to sort with the tree.
            if ($list_data)
            {
	            $rit = new Tree_Factory_List($list_data, '_');
	            $tree = Tree::factory($rit);
	            $tree->nodes->traverse('setTags', $category_data);
	            $tree->usortNodes('cmp');
	            $flatList = $tree->nodes->getFlatList();
	            foreach ($flatList as $node)
	            {
	                $tag = $node->getTag();
	                $new_category_data[] = $tag;
	            }
			}
    		$view->set('categories', $new_category_data);

			return $view->fetch('module/category.tpl');
		}
  	}
}

//  Changes to support sort order in Category drop down list.
function setTags($node, $data)
{
    $tag =  $data[$node->getTag()];
    $node->setTag($tag);
}
function cmp($first, $second)
{
   $ret = 0;

   if ( isset( $first) && isset($second) )
    {
        $a =$first->getTag();
        $b = $second->getTag();

        if ($a['sort_order'] < $b['sort_order']) $ret = -1;
        if ($a['sort_order'] > $b['sort_order']) $ret = 1;
    }

    return $ret;
}

?>

Code: Select all

<!-- A more complex indent example,
     using unordered lists.
     -->
<div class="box">
	<div class="heading"><?php echo $heading_title; ?></div>
	<div class="category" >
	<ul>
		<?php
		$prev_level = 0;
		foreach ($categories as $category)
		{
			$level = $category['indent'];
			if ($prev_level < $level)
			{  ?>
				<ul><li><a href="<?php echo $category['href']; ?>" ><?php htmlEcho( $category['name']);?></a>
<?php		}
			elseif ($prev_level > $level)
			{  ?>
				</li></ul></li><li><a href="<?php echo $category['href']; ?>" ><?php htmlEcho( $category['name']);?></a>
<?php		}
			else
			{  ?>
				<li><a href="<?php echo $category['href']; ?>" ><?php htmlEcho( $category['name']);?></a>
<?php		}
			$prev_level = $level;
		}  ?>
		</ul>
	</div>
</div>