<?php
/*
  $Id: mfg_categories.php,v 0.9 2007/02/23 12:00:00 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
  
    By default when a customer selects to show products from a specific manufacturer, all the categories containing products by that manufacturer are displayed into a single drop-down box.
    This contribution displays multiple category drop-downs, one for each level of categories.
*/

    define('FILTER_DROP_DOWN_DEVIDER', ' ›› ');
    define('FILTER_DEFAULT_TEXT', 'All Categories');
    define('FILTER_DEFAULT_TEXT_NEXT', 'Choose Here Now');
    define('FILTER_DEFAULT_TEXT_INACTIVE', '------');


    $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name, c.parent_id as parent_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and c.categories_id = cd.categories_id order by c.parent_id, c.sort_order, cd.categories_name";
          
          
    $filterlist_query = tep_db_query($filterlist_sql);
    if (tep_db_num_rows($filterlist_query) > 1) {
      echo '            <td align="left" class="main" width="100%" colspan="3">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';      

        $options = '';
        $num_max_cats = 0;
        $category_options = array();    
      while ($filterlist = tep_db_fetch_array($filterlist_query)) {
      
            $filter_id = $filterlist['id'];
        $categories = array();
        tep_get_parent_categories($categories, $filter_id);
        $categories = array_reverse($categories);
        $categories[] = $filter_id; //add this category to the end
        
            for ($i=0, $n=sizeof($categories); $i<$n; ++$i) { //FILTER_MAX_LEVELS //sizeof($categories)

                if (tep_not_null($categories[($i+1)]) && !in_arrayr($categories[($i+1)], $category_options)) {
                    if ($i == 0 && !in_arrayr($categories[$i], $category_main)) {
                        $category_options_name = tep_get_cat_name($categories[$i]);    
                        $category_main[] = array('id' => $categories[$i], 'text' => $category_options_name);    
                        
                        $category_options_name = tep_get_cat_name($categories[($i+1)]);
                  $category_options[$categories[$i]][] = array('id' => $categories[($i+1)], 'text' => $category_options_name);    
                    }
                    else {
                        $category_options_name = tep_get_cat_name($categories[($i+1)]);
                  $category_options[$categories[$i]][] = array('id' => $categories[($i+1)], 'text' => $category_options_name);                
                    }
                    
                    $category_options[$categories[$i]] = tep_sort_array_names($category_options[$categories[$i]]);
                }
                if (($i+1) > $num_max_cats) $num_max_cats = ($i+1);
            }  
        }  

        while (list ($key, $val) = each ($category_options)) {
          $this_level_option_names = '';
          $this_level_option_values = '';
          
            foreach($category_options[$key] as $key2 => $val2) {
                $this_level_option_names .= '"' . $val2['text'] . '",';
                $this_level_option_values .= $val2['id'] . ',';
            }
            
            $this_level_option_names = substr_replace($this_level_option_names,"",-1);
            $this_level_option_values = substr_replace($this_level_option_values,"",-1);

      if (sizeof($category_options[$key]) == 1) { //add this for single category javascript redirect
          $this_level_option_names = $this_level_option_names . ',""';
          $this_level_option_values = $this_level_option_values . ',-1';
            }
            
            $options .= 'optionsArray[' . $key . '] = new Array(' . $this_level_option_names . ')' . "\n";
            $options .= 'valuesArray[' . $key . '] = new Array(' . $this_level_option_values . ')' . "\n";
        }

        $category_main = tep_sort_array_names($category_main);
        array_unshift($category_main, array('id' => '', 'text' => FILTER_DEFAULT_TEXT));

      //DRAW THE FIRST MAIN DROP DOWN
        echo tep_draw_pull_down_menu('Menu', $category_main, '', 'onChange="updateOptions(0,this.options[this.selectedIndex].value);"');
          
        $default_text = array(array('id' => '', 'text' => FILTER_DEFAULT_TEXT_INACTIVE));
          
        // DRAW THE REST OF THE DROP DOWNS - start at 1, 0 is already drawn
        for ($i=1, $n=$num_max_cats; $i<$n; ++$i) {
            $menu_number = $i;
            echo FILTER_DROP_DOWN_DEVIDER;
            echo tep_draw_pull_down_menu('Menu', $default_text, '', 'onChange="updateOptions(' . $menu_number . ',this.options[this.selectedIndex].value);"');
        }
        
        //DRAW DEFAULT HIDDEN FIELDS
        echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
        echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
      echo tep_draw_hidden_field('filter_id', '', 'value=""');      

      echo '</form></td>' . "\n";
    }
    else { // NOTHING TO DISPLAY
        echo '            <td align="center" class="main" width="100%" colspan="3"> </td>';
    }

// ###############################
// # FUNCTIONS START
// ###############################

function in_arrayr($needle, $haystack) {
    if (is_array($haystack)) {
      foreach ($haystack as $v) {
       if ($needle == $v) return true;
       elseif (is_array($v)) {
         if (in_arrayr($needle, $v) === true) return true;
       }
      }
  }
  return false;
}

function tep_sort_array_names($array)
{    
    if (is_array($array)) {
        foreach($array as $key => $val) {
            $array_id[$key]  = $val['id'];
            $array_name[$key] = $val['text'];
        }
        array_multisort($array_name, SORT_ASC, $array);
    }
    return $array;
}

function tep_get_cat_name($category_id) {
    global $languages_id;
    $cName = '';
    
    $category_sql = ("select distinct
    cd.categories_name
    from " . TABLE_CATEGORIES_DESCRIPTION . " cd
    where cd.categories_id = '" . (int)$category_id . "' and
    cd.language_id = '" . (int)$languages_id . "'");
    
    $category_query = tep_db_query($category_sql);
    while ($category = tep_db_fetch_array($category_query)) {
        $cName = $category['categories_name'];
    }

    return $cName;
}        

// ###############################
// # FUNCTIONS STOP
// ###############################
?>

&lt;script>
<!--

/*
########### START CASCADING DROP DOWNS SCRIPT ###########
*/

// Do Not Edit These Variables
    var _F=document.filter;
    var formMenu=_F.Menu;
    var defaultFirst="<?php echo FILTER_DEFAULT_TEXT_NEXT; ?>";
    var defaultNone="<?php echo FILTER_DEFAULT_TEXT_INACTIVE; ?>";
    var optionsArray = new Array;
    var valuesArray = new Array;
    var arr;
    var varr;
    
//This is the Option Array that will build your options

<?php
    echo $options;
?>

//Do Not Edit Below Here - This is the actual function.

    function updateOptions(menu,array) {
        arr = optionsArray[array];
        varr = valuesArray[array];
        
        if (varr==undefined && array!=0) {
            document.filter.filter_id.value = array;
            document.filter.submit();
        }
        else {
                var current = formMenu[menu + 1].options.length;
                var nextMenu = menu + 1;
                var allMenus = formMenu.length
                
                for (var j=current;j>0;j--) {
                    formMenu[menu + 1].options[j] = null;
                }
                for (int=nextMenu;int<allMenus;int++) {
                    for (var y=formMenu[int].options.length;y>0;y--) {
                        formMenu[int].options[y] = null;
                    }
                    formMenu[int].options[0].text=defaultNone;
                }
                for (var i=0;i<arr.length;i++) {
                    if (varr[i]!=-1) {
                        formMenu[menu + 1].options[formMenu[menu + 1].options.length] = new Option(arr[i],varr[i]);
                    }
                }
                formMenu[menu + 1].options[0].text=defaultFirst;
        }
    }
/*
########### END CASCADING DROP DOWNS SCRIPT ###########
*/
-->
</script>

</tr>
<tr>
<td align="center" class="main" width="33%"></td>