$start_element, 'end_element' => $end_element);
echo "[wpsc_category_description]";
}
/**
* wpsc print category url function
* places the shortcode for the category URL
*/
function wpsc_print_category_url() {
echo "[wpsc_category_url]";
}
/**
* wpsc print category id function
* places the shortcode for the category URL
*/
function wpsc_print_category_id() {
echo "[wpsc_category_id]";
}
/**
* wpsc print category classes function
* places classes for the category including selected state
*/
function wpsc_print_category_classes() {
echo "[wpsc_category_classes]";
}
/**
* wpsc print product list function
* places the shortcode for the product list
* @param string starting HTML element
* @param string ending HTML element
*/
function wpsc_print_product_list() {
global $wpsc_category_query;
if (get_option('catsprods_display_type') == 1) {
echo "[wpsc_category_product_list]";
}
}
/**
* wpsc print subcategory function
* places the shortcode for the subcategories, accepts parameters for the subcategories container, have this as if using a list
* @param string starting HTML element
* @param string ending HTML element
*/
function wpsc_print_subcategory($start_element = '', $end_element = '') {
global $wpsc_category_query;
$wpsc_category_query['subcategory_container'] = array('start_element' => $start_element, 'end_element' => $end_element);
echo "[wpsc_subcategory]";
}
/**
* wpsc print category image function
* places the shortcode for the category image, accepts parameters for width and height
* @param integer width
* @param integer height
*/
function wpsc_print_category_image($width = null, $height = null) {
global $wpsc_category_query;
$wpsc_category_query['image_size'] = array('width' => $width, 'height' => $height);
echo "[wpsc_category_image]";
}
/**
* wpsc print category products count function
* places the shortcode for the category product count, accepts parameters for the container element
* @param string starting HTML element
* @param string ending HTML element
*/
function wpsc_print_category_products_count($start_element = '', $end_element = '') {
global $wpsc_category_query;
$wpsc_category_query['products_count'] = array('start_element' => $start_element, 'end_element' => $end_element);
echo "[wpsc_category_products_count]";
}
/**
* wpsc end category query function
*/
function wpsc_end_category_query() {
global $wpdb, $wpsc_category_query;
$category_html = ob_get_clean();
echo wpsc_display_category_loop($wpsc_category_query, $category_html);
unset($GLOBALS['wpsc_category_query']);
}
/**
* wpsc category loop function
* This function recursively loops throuh the categories to display the category tree.
* WARNING: this function is recursive, be careful what you do with it.
* @param array the category query
* @param string the category html
* @return string - the finished category html
*/
function wpsc_display_category_loop($query, $category_html){
global $wpdb, $wpsc_query;
$category_sql_segment = array();
$category_sql_segment[] = "`active`='1'";
if(is_numeric($query['category_group']) ) {
$category_group = absint($query['category_group']);
$category_sql_segment[] = "`group_id`='$category_group'";
} else if($query['category_group']=='all' ||$query['category_group']=='all+list') {
$category_group = 1;
}
/// select by parent category
$category_sql_segment[] = "`category_parent` = '".absint($query['parent_category_id'])."'";
if(!isset($query['order_by'])) {
$query['order_by'] = array("column" => 'name', "direction" =>'asc');
}
$column = $wpdb->escape($query['order_by']['column']);
if(strtolower($query['order_by']['direction']) == "desc") {
$order = "DESC";
} else {
$order = "ASC";
}
//exit("SELECT `id`, `name`, `nice-name`, `description`, `image` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE ".implode(" AND ", $category_sql_segment)." ORDER BY `{$column}` $order");
$category_sql_segment = apply_filters('wpsc_display_category_loop_category_sql_segments', $category_sql_segment);
$category_data = $wpdb->get_results("SELECT `id`, `name`, `nice-name`, `description`, `image` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE ".implode(" AND ", $category_sql_segment)." ORDER BY `{$column}` $order",ARRAY_A);
//echo "".print_r($category_sql_segment, true)."
";
$output ='';
foreach((array)$category_data as $category_row) {
$modified_query = $query;
$modified_query['parent_category_id'] = $category_row['id'];
$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 ('{$category_row['id']}') AND `p`.`active` IN ('1') AND `p`.`publish` IN('1')");
$start_element = $query['products_count']['start_element'];
$end_element = $query['products_count']['end_element'];
$category_count_html = $start_element.$category_count.$end_element;
$category_description = '';
if($category_row['description'] != '') {
$start_element = $query['description_container']['start_element'];
$end_element = $query['description_container']['end_element'];
$category_description = $start_element.wpautop(wptexturize( wp_kses(stripslashes($category_row['description']), $allowedtags ))).$end_element;
}
$category_classes = 'wpsc-cat-item wpsc-cat-item-' . $category_row['id'];
if ( $wpsc_query->query_vars['category_id'] == $category_row['id']) {
$category_classes .= ' wpsc-current-cat';
}
$sub_categories = wpsc_display_category_loop($modified_query, $category_html);
if($sub_categories != '') {
$start_element = $query['subcategory_container']['start_element'];
$end_element = $query['subcategory_container']['end_element'];
$sub_categories = $start_element.$sub_categories.$end_element;
}
$category_image = wpsc_place_category_image($category_row['id'], $modified_query);
$width = $query['image_size']['width'] - 4;
$height = $query['image_size']['height'] - 4;
$category_image_html = '';
if(($query['show_thumbnails'] == 1)) {
if(($category_row['image'] != '') && is_file(WPSC_CATEGORY_DIR.$category_row['image'])) {
$category_image_html = "
";
} else {
$category_image_html = "";
$category_image_html .= " \n\r";
$category_image_html .= " \n\r";
$category_image_html .= " ".__('N/A', 'wpsc')."\n\r";
$category_image_html .= " \n\r";
$category_image_html .= " \n\r";
}
}
$category_product_list = wpsc_category_product_list($category_row['id']);
$tags_to_replace = array('[wpsc_category_name]',
'[wpsc_category_description]',
'[wpsc_category_url]',
'[wpsc_category_id]',
'[wpsc_category_classes]',
'[wpsc_category_image]',
'[wpsc_subcategory]',
'[wpsc_category_products_count]',
'[wpsc_category_product_list]');
$content_to_place = array(
htmlentities($category_row['name'],ENT_QUOTES, 'UTF-8'),
$category_description,
wpsc_category_url($category_row['id']),
$category_row['id'],
$category_classes,
$category_image_html,
$sub_categories,
$category_count_html,
$category_product_list);
$output .= str_replace($tags_to_replace, $content_to_place ,$category_html);
}
return $output;
}
/**
* wpsc category image function
* if no parameters are passed, the category is not resized, otherwise it is resized to the specified dimensions
* @param integer category id
* @param array category query array
* @return string - the category image URL, or the URL of the resized version
*/
function wpsc_place_category_image($category_id, $query) {
// show the full sized image for the product, if supplied with dimensions, will resize image to those.
global $wpsc_query, $wpdb;
$width = $query['image_size']['width'];
$height = $query['image_size']['height'];
//echo "".print_r($query, true)."
";
$image_url = "index.php?wpsc_request_image=true&category_id=".$category_id."&width=".$width."&height=".$height;
return htmlspecialchars($image_url);
}
function wpsc_category_product_list($category_id) {
global $wpdb;
$output = '';
$category_id = (int)$category_id;
if (get_option('catsprods_display_type') == 1) {
$product_data = $wpdb->get_results("SELECT `products`.`id`, `products`.`name`
FROM `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` AS `cats`
JOIN `".WPSC_TABLE_PRODUCT_LIST."` as `products`
ON `cats`.`product_id` = `products`.`id`
WHERE `cats`.`category_id` = '$category_id'
AND `products`.`publish`='1'
AND `products`.`active` = '1'
ORDER BY `products`.`name` ASC
", ARRAY_A);
if(count($product_data) > 0){
$output .= "\n\r";
} //end if productsIDs
}
return $output;
}
/// category template tags end here
// pe.{
// To stick this in sidebar, main page (calling products_page.php) must be called before sidebar.php in the loop (think)
function display_subcategories($id) {
global $wpdb;
if(get_option('permalink_structure') != '') {
$seperator ="?";
} else {
$seperator ="&";
}
$subcategory_sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active`='1' AND `category_parent` = '".absint($id)."' ORDER BY `nice-name`";
$subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A);
if($subcategories != null) {
$output .= "";
foreach($subcategories as $subcategory) {
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 ('{$subcategory['id']}') AND `p`.`active` IN ('1') AND `p`.`publish` IN('1')");
$addCount = " (".$count.")";
} //end get_option
$output .= "- ".stripslashes($subcategory['name'])."$addCount".display_subcategories($subcategory['id'])."
";
}
$output .= "
";
} else {
return '';
}
return $output;
}
// Marked for removal
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 = "";
switch(get_option('show_categorybrands')) {
case 1:
$output .= "
";
break;
}
$output .= "
";
if((get_option('show_categorybrands') == 1 ) || (get_option('show_categorybrands') == 2)) {
$output .= "
";
$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 .= "
";
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 .= "- ".stripslashes($option['name'])."".$addCount."";
}else{
// Adrian - otherwise create normal category text with or without product count
if (!$image) {
$output .= "
- ".stripslashes($option['name'])."".$addCount."";
} else {
$output .= "
![](" . WPSC_CATEGORY_URL . $option[)
".stripslashes($option['name'])."".$addCount."";
}
}//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 .= "";
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 .= "- ".$productName[0]['name']."
";
}//end foreach
$output .= "
";
}//end if productsIDs
}//end if get_option
}//end else
$output .= "
";
}
$output .= "
";
}
if((get_option('show_categorybrands') == 1 ) || (get_option('show_categorybrands') == 3))
{
if(get_option('show_categorybrands') == 1) {
$output .= "
";
} else {
$output .= "";
}
//$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 .= "- ".stripslashes($option['name'])."
";
}
}
//$output .= $output;
$output .= "
";
}
$output .= "