".$VM_LANG->_PHPSHOP_EXPAND_TREE."
|
".$VM_LANG->_PHPSHOP_COLLAPSE_TREE."
";
echo "
";
echo $menu_htmlcode;
class phpShopmenu {
/***************************************************
* function traverse_tree_down
*/
function traverse_tree_down(&$mymenu_content, $category_id='0', $level='0') {
static $ibg = -1;
global $db, $module, $mosConfig_live_site;
$level++;
$query = "SELECT category_name as cname, category_id as cid, category_child_id as ccid "
. "FROM #__{sc}_category as a, #__{sc}_category_xref as b "
. "WHERE a.category_publish='Y' AND "
. " b.category_parent_id='$category_id' AND a.category_id=b.category_child_id "
. "ORDER BY category_parent_id, list_order, category_name ASC";
$db->query( $query );
$categories = $db->record;
if( !( $categories==null ) ) {
$i = 1;
foreach ($categories as $category) {
$ibg++;
$Treeid = $ibg == 0 ? 1 : $ibg;
$itemid = isset($_REQUEST['Itemid']) ? '&Itemid='.intval($_REQUEST['Itemid']) : "";
$mymenu_content.= ",\n[null,'".$category->cname;
$mymenu_content.= ps_product_category::products_in_category( $category->cid );
$mymenu_content.= "','".$_SERVER['PHP_SELF'].'?option=com_supacart&page=product.product_category_form&category_id='.$category->cid."','_self','".$category->cname."'\n ";
$q = "SELECT #__{sc}_product.product_name,#__{sc}_product.product_id FROM #__{sc}_product, #__{sc}_product_category_xref ";
$q .= "WHERE #__{sc}_product.product_id=#__{sc}_product_category_xref.product_id ";
$q .= "AND #__{sc}_product_category_xref.category_id='".$category->cid."' ";
$q .= "ORDER BY #__{sc}_product.product_name";
$db->query( $q );
$products = $db->record;
$xx = 1;
foreach( $products as $product ) {
// get name and link (just to save space in the code later on)
$mymenu_content.= ",\n[null,'".$product->product_name;
$url = $_SERVER['PHP_SELF'].'?option=com_supacart&page=product.product_form&product_id='.$product->product_id;
$mymenu_content .= "','".$url."','_self','".$product->product_name."']";
if( $xx++ < sizeof( $products ))
$mymenu_content .= ",\n";
else
$mymenu_content .= "\n";
}
/* recurse through the subcategories */
$this->traverse_tree_down($mymenu_content, $category->ccid, $level);
/* let's see if the loop has reached its end */
if ( $i == sizeof( $categories ) && $level == 1)
$mymenu_content.= "]";
else
$mymenu_content.= "]";
$i++;
}
}
else {
}
}
}
/************* END OF CATEGORY TREE ******************************
*********************************************************
*/
?>