function show_cats_brands($category_group = null, $display_method = null, $order_by = 'name', $image = null)
{
global $wpdb;
if ($category_group == null) {
$category_group = $wpdb->get_var("SELECT `id` FROM `" . WPSC_TABLE_CATEGORISATION_GROUPS . "` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ");
} else {
$category_group = (int) $category_group;
}
// Show cats & brands list if displaying on every page or if on a shop page (bit hacky but out of time).
if (get_option('cat_brand_loc') != 3 && !function_exists("nzshpcrt_display_categories_groups") && $display_method != 'sidebar') {
return;
}
if (get_option('permalink_structure') != '') {
$seperator = "?";
} else {
$seperator = "&";
}
$output = "<div class='PeSwitcher'>";
switch (get_option('show_categorybrands')) {
case 1:
$output .= "<ul id='PeCatsBrandsBoth' class='category_brand_header'><li id='PeSwitcherFirst'><a href='' onclick='return prodgroupswitch(\"categories\");'>" . TXT_WPSC_CATEGORIES . "</a> | <a href='' onclick='return prodgroupswitch(\"brands\");'>" . TXT_WPSC_BRANDS . "</a></li></ul>";
break;
}
$output .= "</div>";
$output .= "<div class='PeCatsBrands'>";
if (get_option('show_categorybrands') == 1 || get_option('show_categorybrands') == 2) {
$output .= "<div class='PeCategories categorydisplay'>";
$categories = $wpdb->get_results("SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$category_group}') AND `active`='1' AND `category_parent` = '0' ORDER BY `" . $wpdb->escape($order_by) . "` ASC", ARRAY_A);
if ($categories != null) {
$output .= "<ul class='PeCategories'>";
foreach ($categories as $option) {
// Adrian - check option for category count
if (get_option('show_category_count') == 1) {
//show product count for each category
$count = $wpdb->get_var("SELECT COUNT(`p`.`id`) FROM `" . WPSC_TABLE_ITEM_CATEGORY_ASSOC . "` AS `a` JOIN `" . WPSC_TABLE_PRODUCT_LIST . "` AS `p` ON `a`.`product_id` = `p`.`id` WHERE `a`.`category_id` IN ('{$option['id']}') AND `p`.`active` IN ('1')");
$addCount = " (" . $count . ")";
}
//end get_option
// No more mootools
if (get_option('catsprods_display_type') == 1) {
$output .= "<li class='cat-item'><span class='category'><a class='productlink' href='" . wpsc_category_url($option['id']) . "'>" . stripslashes($option['name']) . "</a>" . $addCount . "</span>";
} else {
// Adrian - otherwise create normal category text with or without product count
if (!$image) {
$output .= "<li class='cat-item'><span class='category'><a class='productlink' href='" . wpsc_category_url($option['id']) . "'>" . stripslashes($option['name']) . "</a>" . $addCount . "</span>";
} else {
$output .= "<li class='cat-item'><img src='" . WPSC_CATEGORY_URL . $option['image'] . "'><br><span class='category'><a class='productlink' href='" . wpsc_category_url($option['id']) . "'>" . stripslashes($option['name']) . "</a>" . $addCount . "</span>";
}
}
//end get_option
$subcategory_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$category_group}') AND `active`='1' AND `category_parent` = '" . $option['id'] . "' ORDER BY `id`";
$subcategories = $wpdb->get_results($subcategory_sql, ARRAY_A);
if ($subcategories != null) {
$output .= display_subcategories($option['id']);
} else {
// Adrian - check if the user wants categories only or sliding categories
if (get_option('permalink_structure') != '') {
$uri = $_SERVER['REQUEST_URI'];
$category = explode('/', $uri);
$count = count($category);
$category_nice_name = $category[$count - 2];
$category_nice_name2 = $wpdb->get_var("SELECT `nice-name` FROM " . WPSC_TABLE_PRODUCT_CATEGORIES . " WHERE id='{$option['id']}'");
if ($category_nice_name == $category_nice_name2) {
$list_product = true;
} else {
$list_product = false;
}
}
if (get_option('catsprods_display_type') == 1 && ($option['id'] == $_GET['category'] || $list_product)) {
// Adrian - display all products for that category
$product_sql = "SELECT product_id FROM `" . WPSC_TABLE_ITEM_CATEGORY_ASSOC . "` WHERE `category_id` = '" . $option['id'] . "'";
$productIDs = $wpdb->get_results($product_sql, ARRAY_A);
if ($productIDs != null) {
$output .= "<ul class='category-product-list'>";
foreach ($productIDs as $productID) {
$ID = $productID['product_id'];
$productName_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_LIST . "` WHERE `id` = '" . $ID . "'";
$productName = $wpdb->get_results($productName_sql, ARRAY_A);
if ($productName[0]['active']) {
$output .= "<li class='cat-item'><a class='productlink' href='" . wpsc_product_url($ID, $option['id']) . "'>" . $productName[0]['name'] . "</a></li>";
}
}
//end foreach
$output .= "</ul>";
}
//end if productsIDs
}
//end if get_option
}
//end else
$output .= "</li>";
}
$output .= "</ul>";
}
$output .= "</div>";
}
if (get_option('show_categorybrands') == 1 || get_option('show_categorybrands') == 3) {
if (get_option('show_categorybrands') == 1) {
$output .= "<ul class='PeBrands branddisplay' style='display: none;'>";
} else {
$output .= "<ul class='PeBrands branddisplay'>";
}
//$output ='';
$brands = $wpdb->get_results("SELECT * FROM `" . $wpdb->prefix . "product_brands` WHERE `active`='1' ORDER BY `order` ASC", ARRAY_A);
if ($brands != null) {
foreach ($brands as $option) {
$output .= "<li><a class='categorylink' href='" . get_option('product_list_url') . $seperator . "brand=" . $option['id'] . "'>" . stripslashes($option['name']) . "</a></li>";
}
}
//$output .= $output;
$output .= "</ul>";
}
$output .= "</div>";
echo $output;
}
function show_cats_brands($category_group = null, $display_method = null, $order_by = 'name', $image = null)
{
global $wpdb;
if ($category_group == null) {
$category_group = $wpdb->get_var("SELECT `id` FROM `" . $wpdb->prefix . "wpsc_categorisation_groups` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ");
} else {
$category_group = (int) $category_group;
}
// Show cats & brands list if displaying on every page or if on a shop page (bit hacky but out of time).
if (get_option('cat_brand_loc') != 3 && !function_exists("nzshpcrt_display_categories_groups") && $display_method != 'sidebar') {
return;
}
if (get_option('permalink_structure') != '') {
$seperator = "?";
} else {
$seperator = "&";
}
$output = "<div class='PeSwitcher'>";
switch (get_option('show_categorybrands')) {
case 1:
$output .= "<ul id='PeCatsBrandsBoth' class='category_brand_header'><li id='PeSwitcherFirst'><a href='' onclick='return prodgroupswitch(\"categories\");'>" . TXT_WPSC_CATEGORIES . "</a> | <a href='' onclick='return prodgroupswitch(\"brands\");'>" . TXT_WPSC_BRANDS . "</a></li></ul>";
break;
}
$output .= "</div>";
$output .= "<div class='PeCatsBrands'>";
if (get_option('show_categorybrands') == 1 || get_option('show_categorybrands') == 2) {
$output .= "<div class='PeCategories categorydisplay'>";
$categories = $wpdb->get_results("SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `group_id` IN ('{$category_group}') AND `active`='1' AND `category_parent` = '0' ORDER BY `" . $wpdb->escape($order_by) . "` ASC", ARRAY_A);
if ($categories != null) {
$output .= "<ul class='PeCategories'>";
foreach ($categories as $option) {
// Adrian - check option for category count
if (get_option('show_category_count') == 1) {
//show product count for each category
$count_sql = "SELECT count(*) FROM `" . $wpdb->prefix . "item_category_associations` WHERE `category_id` = '" . $option['id'] . "'";
$count = $wpdb->get_var($count_sql);
$addCount = " [" . $count . "]";
}
//end get_option
// Adrian - if sliding category type selected, NO link for category text, mootools.js creates the linkable sliders onDomReady.
if (get_option('catsprods_display_type') == 1) {
$output .= "<li class='MainCategory'><strong class='category'>" . stripslashes($option['name']) . $addCount . "</strong>";
} else {
// Adrian - otherwise create normal category text with or without product count
if (!$image) {
$output .= "<li class='MainCategory'><strong class='category'><a class='productlink' href='" . wpsc_category_url($option['id']) . "'>" . stripslashes($option['name']) . $addCount . "</a></strong>";
} else {
$output .= "<li class='MainCategory'><img src='" . get_option('siteurl') . "/wp-content/uploads/wpsc/category_images/" . $option['image'] . "'><br><strong class='category'><a class='productlink' href='" . wpsc_category_url($option['id']) . "'>" . stripslashes($option['name']) . $addCount . "</a></strong>";
}
}
//end get_option
$subcategory_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `group_id` IN ('{$category_group}') AND `active`='1' AND `category_parent` = '" . $option['id'] . "' ORDER BY `id`";
$subcategories = $wpdb->get_results($subcategory_sql, ARRAY_A);
if ($subcategories != null) {
$output .= display_subcategories($option['id']);
} else {
// Adrian - check if the user wants categories only or sliding categories
if (get_option('catsprods_display_type') == 1) {
// Adrian - display all products for that category
$product_sql = "SELECT product_id FROM `" . $wpdb->prefix . "item_category_associations` WHERE `category_id` = '" . $option['id'] . "'";
$productIDs = $wpdb->get_results($product_sql, ARRAY_A);
if ($productIDs != null) {
$output .= "<ul>";
foreach ($productIDs as $productID) {
$ID = $productID['product_id'];
$productName_sql = "SELECT name FROM `" . $wpdb->prefix . "product_list` WHERE `id` = '" . $ID . "'";
$productName = $wpdb->get_var($productName_sql);
$output .= "<li><a class='productlink' href='" . wpsc_product_url($ID, $option['id']) . "'>" . $productName . "</a></li>";
}
//end foreach
$output .= "</ul>";
}
//end if productsIDs
}
//end if get_option
}
//end else
$output .= "</li>";
}
$output .= "</ul>";
}
$output .= "</div>";
}
if (get_option('show_categorybrands') == 1 || get_option('show_categorybrands') == 3) {
if (get_option('show_categorybrands') == 1) {
$output .= "<ul class='PeBrands branddisplay' style='display: none;'>";
} else {
$output .= "<ul class='PeBrands branddisplay'>";
}
//$output ='';
$brands = $wpdb->get_results("SELECT * FROM `" . $wpdb->prefix . "product_brands` WHERE `active`='1' ORDER BY `order` ASC", ARRAY_A);
if ($brands != null) {
foreach ($brands as $option) {
$output .= "<li><a class='categorylink' href='" . get_option('product_list_url') . $seperator . "brand=" . $option['id'] . "'>" . stripslashes($option['name']) . "</a></li>";
}
}
//$output .= $output;
$output .= "</ul>";
}
$output .= "</div>";
echo $output;
}
