query_vars['paged'];
if($page != '')
$wp_query->query_vars['paged'] = $page;
if($wp_query->is_single === true) {
$wp_query->query_vars['paged'] = $curpage;
return wpsc_product_url($wp_query->post->ID);
} else {
if( 1 < $wp_query->query_vars['paged']) {
if(get_option('permalink_structure'))
$output .= "paged/{$wp_query->query_vars['paged']}/";
else
$output = add_query_arg('paged', '', $output);
}
return $output;
}
}
/**
* wpsc_pagination generates and returns the urls for pagination
* @access public
*
* @since 3.8
* @param $totalpages (INT) Number of pages,
* @param $per_page (INT) Number of products per page
* @param $current_page (INT) Current Product page number
* @param $page_link (STRING) URL of Page
*
* @return
*/
function wpsc_pagination($totalpages = '', $per_page = '', $current_page = '', $page_link = '') {
global $wp_query,$wpsc_query;
$num_paged_links = 4; //amount of links to show on either side of current page
$additional_links = '';
//additional links, items per page and products order
if( get_option('permalink_structure') != '' ){
$additional_links_separator = '?';
}else{
$additional_links_separator = '&';
}
if( !empty( $_GET['items_per_page'] ) ){
$additional_links = $additional_links_separator . 'items_per_page=' . $_GET['items_per_page'];
$additional_links_separator = '&';
}
if( !empty( $_GET['product_order'] ) )
$additional_links .= $additional_links_separator . 'product_order=' . $_GET['product_order'];
$additional_links = apply_filters('wpsc_pagination_additional_links', $additional_links);
//end of additional links
if(empty($totalpages)){
$totalpages = $wp_query->max_num_pages;
}
if(empty($per_page))
$per_page = (int)get_option('wpsc_products_per_page');
$current_page = absint( get_query_var('paged') );
if($current_page == 0)
$current_page = 1;
if(empty($page_link))
$page_link = wpsc_a_page_url();
//if there is no pagination
if(!get_option('permalink_structure')) {
$category = '?';
if(isset($wpsc_query->query_vars['wpsc_product_category']))
$category = '?wpsc_product_category='.$wp_query->query_vars['wpsc_product_category'];
if(isset($wpsc_query->query_vars['wpsc_product_category']) && is_string($wpsc_query->query_vars['wpsc_product_category'])){
$page_link = get_option('blogurl').$category.'&paged';
}else{
$page_link = get_option('product_list_url').$category.'&paged';
}
$separator = '=';
}else{
// This will need changing when we get product categories sorted
if(isset($wpsc_query->query_vars['wpsc_product_category']))
$page_link = trailingslashit(get_option('product_list_url')).$wpsc_query->query_vars['wpsc_product_category'].'/';
else
$page_link = trailingslashit(get_option('product_list_url'));
$separator = 'page/';
}
// If there's only one page, return now and don't bother
if($totalpages == 1)
return;
// Pagination Prefix
$output = __('Pages: ','wpsc');
if(get_option('permalink_structure')){
// Should we show the FIRST PAGE link?
if($current_page > 1)
$output .= "" . __('« First', 'wpsc') . "";
// Should we show the PREVIOUS PAGE link?
if($current_page > 1) {
$previous_page = $current_page - 1;
if( $previous_page == 1 )
$output .= " " . __('< Previous', 'wpsc') . "";
else
$output .= " " . __('< Previous', 'wpsc') . "";
}
$i =$current_page - $num_paged_links;
$count = 1;
if($i <= 0) $i =1;
while($i < $current_page){
if($count <= $num_paged_links){
if($count == 1)
$output .= " ".$i."";
else
$output .= " ".$i."";
}
$i++;
$count++;
}
// Current Page Number
if($current_page > 0)
$output .= "$current_page";
//Links after Current Page
$i = $current_page + $num_paged_links;
$count = 1;
if($current_page < $totalpages){
while(($i) > $current_page){
if($count < $num_paged_links && ($count+$current_page) <= $totalpages){
$output .= " ".($count+$current_page)."";
$i++;
}else{
break;
}
$count ++;
}
}
if($current_page < $totalpages) {
$next_page = $current_page + 1;
$output .= "" . __('Next >', 'wpsc') . "";
}
// Should we show the LAST PAGE link?
if($current_page < $totalpages) {
$output .= "" . __('Last »', 'wpsc') . "";
}
} else {
// Should we show the FIRST PAGE link?
if($current_page > 1)
$output .= "" . __('« First', 'wpsc') . "";
// Should we show the PREVIOUS PAGE link?
if($current_page > 1) {
$previous_page = $current_page - 1;
if( $previous_page == 1 )
$output .= " " . __('< Previous', 'wpsc') . "";
else
$output .= " " . __('< Previous', 'wpsc') . "";
}
$i =$current_page - $num_paged_links;
$count = 1;
if($i <= 0) $i =1;
while($i < $current_page){
if($count <= $num_paged_links){
if($i == 1)
$output .= " ".$i."";
else
$output .= " ".$i."";
}
$i++;
$count++;
}
// Current Page Number
if($current_page > 0)
$output .= "$current_page";
//Links after Current Page
$i = $current_page + $num_paged_links;
$count = 1;
if($current_page < $totalpages){
while(($i) > $current_page){
if($count < $num_paged_links && ($count+$current_page) <= $totalpages){
$output .= " ".($count+$current_page)."";
$i++;
}else{
break;
}
$count ++;
}
}
if($current_page < $totalpages) {
$next_page = $current_page + 1;
$output .= "" . __('Next >', 'wpsc') . "";
}
// Should we show the LAST PAGE link?
if($current_page < $totalpages) {
$output .= "" . __('Last »', 'wpsc') . "";
}
}
// Return the output.
echo $output;
}
/**
* wpsc_show_stock_availability
*
* Checks to see whether stock symbols need to be shown
* @return boolean - true is the option has been checked false otherwise
*/
function wpsc_show_stock_availability(){
if( get_option('list_view_quantity') == 1 )
return true;
else
return false;
}
/**
* wpsc product image function
*
* if no parameters are passed, the image is not resized, otherwise it is resized to the specified dimensions
*
* @param integer attachment_ID
* @param integer width
* @param integer height
* @return string - the product image URL, or the URL of the resized version
*/
function wpsc_product_image( $attachment_id = 0, $width = null, $height = null ) {
// Do some dancing around the image size
if ( ( ( $width >= 10 ) && ( $height >= 10 ) ) && ( ( $width <= 1024 ) && ( $height <= 1024 ) ) )
$intermediate_size = "wpsc-{$width}x{$height}";
// Get image url if we have enough info
if ( ( $attachment_id > 0 ) && ( !empty( $intermediate_size ) ) ) {
// Get all the required information about the attachment
$uploads = wp_upload_dir();
$image_meta = get_post_meta( $attachment_id, '' );
$file_path = get_attached_file( $attachment_id );
// Clean up the meta array
foreach ( $image_meta as $meta_name => $meta_value )
$image_meta[$meta_name] = maybe_unserialize( array_pop( $meta_value ) );
$attachment_metadata = $image_meta['_wp_attachment_metadata'];
// Determine if we already have an image of this size
if ( isset( $attachment_metadata['sizes'] ) && (count( $attachment_metadata['sizes'] ) > 0) && ( isset( $attachment_metadata['sizes'][$intermediate_size] ) ) ) {
$intermediate_image_data = image_get_intermediate_size( $attachment_id, $intermediate_size );
$image_url = $intermediate_image_data['url'];
} else {
$image_url = "index.php?wpsc_action=scale_image&attachment_id={$attachment_id}&width=$width&height=$height";
}
// Not enough info so attempt to fallback
} else {
if ( !empty( $attachment_id ) ) {
$image_url = "index.php?wpsc_action=scale_image&attachment_id={$attachment_id}&width=$width&height=$height";
} else {
$image_url = false;
}
}
if(empty($image_url) && !empty($file_path)){
$image_meta = get_post_meta( $attachment_id, '_wp_attached_file' );
$image_url = $uploads['baseurl'].'/'.$image_meta[0];
}
if( is_ssl() && !strstr( $image_url, 'https' ) ) str_replace('http', 'https', $image_url);
// @todo - put fallback 'No image' catcher here
return apply_filters( 'wpsc_product_image', $image_url );
}
function wpsc_product_no_image_fallback( $image_url = '' ) {
if ( !empty( $image_url ) )
return $image_url;
else
return apply_filters( 'wpsc_product_noimage', WPSC_CORE_THEME_URL . 'wpsc-images/noimage.png' );
}
add_filter( 'wpsc_product_image', 'wpsc_product_no_image_fallback' );
/**
* wpsc show pnp function
* @return boolean - true if display_pnp is 1 false otherwise
*/
function wpsc_show_pnp(){
global $post;
if(1 == get_option('display_pnp'))
return true;
return false;
}
/**
* wpsc_product_variation_price_available function
* Checks for the lowest price of a products variations
*
* @return $price (string) number formatted price
*/
function wpsc_product_variation_price_available($product_id){
global $wpdb;
$price = $wpdb->get_var('
SELECT
`pm`.`meta_value`
FROM
`' . $wpdb->postmeta . '` `pm`
JOIN
`' . $wpdb->posts . '` `p`
ON
`pm`.`post_id` = `p`.`id`
WHERE
`p`.`post_type`= "wpsc-product"
AND
`p`.`post_parent` = ' . $product_id . '
AND
`pm`.`meta_key` = GREATEST("_wpsc_price","_wpsc_special_price")
AND
`p`.`ID` IN (
SELECT `' . $wpdb->postmeta . '`.`post_id` FROM `' . $wpdb->postmeta . '` WHERE `meta_key` = "_wpsc_stock" AND `meta_value` != "0"
)
ORDER BY
`meta_value` ASC
LIMIT 1'
);
$price = wpsc_currency_display($price, array('display_as_html' => false));
return $price;
}
/**
* wpsc product price function
* @return string - the product price
*/
function wpsc_the_product_price( $no_decimals = false ) {
global $wpsc_query, $wpsc_variations, $wpdb;
if ( isset($wpsc_variations->first_variations) && count( $wpsc_variations->first_variations ) > 0 ) {
//select the variation ID with lowest price
$output = wpsc_product_variation_price_available(get_the_ID());
$from = ' from ';
} else {
$product_id = get_the_ID();
$from = '';
$full_price = get_post_meta( $product_id, '_wpsc_price', true );
$special_price = get_post_meta( $product_id, '_wpsc_special_price', true );
$price = $full_price;
if ( ($full_price > $special_price) && ($special_price > 0) )
$price = $special_price;
if ( $no_decimals == true )
$price = array_shift( explode( ".", $price ) );
$args = array(
'display_as_html' => false,
'display_decimal_point' => !$no_decimals
);
$output = wpsc_currency_display( $price,$args );
}
//if product has variations - add 'from'
$from = apply_filters('wpsc_product_variation_text',$from);
if ( isset($wpsc_variations->first_variations) && count( $wpsc_variations->first_variations ) > 0 && !empty($from))
$output = sprintf(__(' from %s', 'wpsc'), $output);
return $output;
}
function wpsc_calculate_price( $product_id, $variations = null, $special = true ) {
global $wpdb;
$p_id = $product_id;
if ( count( $variations ) > 0 ){
if(!isset($variations) || is_array($variations) && in_array(0,$variations,true)) return;
$product_id = wpsc_get_child_object_in_terms( $product_id, $variations, 'wpsc-variation' );
}else if ( !$product_id )
$product_id = get_the_ID();
if( !$product_id && count( $variations ) > 0){
$product_ids = wpsc_get_child_object_in_select_terms( $p_id, $variations, 'wpsc_variation' );
$sql = "SELECT `post_id` FROM ".$wpdb->postmeta." WHERE `meta_key` = '_wpsc_stock' AND `meta_value` != '0' AND `post_id` IN (".implode(',' , $product_ids).")";
$stock_available = $wpdb->get_col($sql);
$sql = "SELECT `post_id` FROM ".$wpdb->postmeta." WHERE `meta_key` = '_wpsc_price' AND `post_id` IN (".implode(',',$stock_available).") ORDER BY `meta_value` ASC LIMIT 1";
$product_id = $wpdb->get_var($sql);
}
if ( $special ) {
$full_price = get_post_meta( $product_id, '_wpsc_price', true );
$special_price = get_post_meta( $product_id, '_wpsc_special_price', true );
$price = $full_price;
if ( ($full_price > $special_price) && ($special_price > 0) ) {
$price = $special_price;
}
} else {
$price = get_post_meta( $product_id, '_wpsc_price', true );
}
return $price;
}
/**
* wpsc display categories function
* Used to determine whether to display products on the page
* @return boolean - true for yes, false for no
*/
function wpsc_display_categories() {
global $wp_query;
$output = false;
if ( !is_numeric( get_option( 'wpsc_default_category' ) ) ) {
if ( isset( $wp_query->query_vars['products'] ) )
$category_id = $wp_query->query_vars['products'];
else if ( isset( $_GET['products'] ) )
$category_id = $_GET['products'];
// if we have no categories, and no search, show the group list
if ( is_numeric( get_option( 'wpsc_default_category' ) ) || (isset( $product_id ) && is_numeric( $product_id )) || (isset( $_GET['product_search'] ) && $_GET['product_search'] != '') )
$output = true;
if ( (get_option( 'wpsc_default_category' ) == 'all+list'))
$output = true;
if (get_option( 'wpsc_default_category' ) == 'list' && (!isset($wp_query->query_vars['wpsc_product_category']) || !isset($wp_query->query_vars['product_tag']) && get_option('wpsc_display_categories')))
$output = true;
}
if ( isset( $category_id ) && $category_id > 0 )
$output = false;
if ( get_option( 'wpsc_display_categories' ))
$output = true;
return $output;
}
/**
* wpsc display products function
* Used to determine whether to display products on the page
* @return boolean - true for yes, false for no
*/
function wpsc_display_products() {
global $post;
$product_page_id = wpec_get_the_post_id_by_shortcode('[productspage]');
//we have to display something, if we are not displaying categories, then we must display products
$output = true;
if ( wpsc_display_categories ( ) ) {
if ( get_option( 'wpsc_default_category' ) == 'list' && $post->ID == $product_page_id )
$output = false;
if ( isset( $_GET['range'] ) || isset( $_GET['category'] ) )
$output = true;
}
return $output;
}
/**
* this page url function, returns the URL of this page
* @return string - the URL of the current page
*/
function wpsc_this_page_url() {
global $wpsc_query, $wp_query;
if ( $wpsc_query->is_single === true ) {
$output = wpsc_product_url( $wp_query->post->ID );
} else if ( isset( $wpsc_query->category ) && $wpsc_query->category != null ) {
$output = wpsc_category_url( $wpsc_query->category );
if ( $wpsc_query->query_vars['page'] > 1 ) {
if ( get_option( 'permalink_structure' ) ) {
$output .= "page/{$wpsc_query->query_vars['page']}/";
} else {
$output = add_query_arg( 'page_number', $wpsc_query->query_vars['page'], $output );
}
}
} elseif ( isset( $id ) ) {
$output = get_permalink( $id );
} else {
$output = get_permalink( get_the_ID() );
}
return $output;
}
/**
* is single product function, determines if we are viewing a single product
* @return boolean - true, or false...
*/
function wpsc_is_single_product() {
global $wp_query;
if ( $wp_query->is_single === 1 )
$state = true;
else
$state = false;
return $state;
}
/**
* category class function, categories can have a specific class, this gets that
* @return string - the class of the selected category
*/
function wpsc_category_class() {
global $wpdb, $wp_query;
$category_nice_name = '';
if ( 'wpsc_product_category' == $wp_query->query_vars['taxonomy'] ) {
$catid = wpsc_get_the_category_id($wp_query->query_vars['term'],'slug');
} else {
$catid = get_option( 'wpsc_default_category' );
if ( $catid == 'all+list' ) {
$catid = 'all';
}
}
if ( (int)$catid > 0 ){
$term = get_term($catid, 'wpsc_product_category');
$category_nice_name = $term->slug;
}else if ( $catid == 'all' ){
$category_nice_name = 'all-categories';
}
return $category_nice_name;
}
/**
* category transition function, finds the transition between categories
* @return string - the class of the selected category
*/
function wpsc_current_category_name() {
global $wp_query;
$term_data = get_term( $wp_query->post->term_id, 'wpsc_product_category' );
return $term_data->name;
}
/**
* category transition function, finds the transition between categories
* @return string - the class of the selected category
*/
function wpsc_category_transition() {
global $wpdb, $wp_query, $wpsc_query;
$current_category_id = null;
$previous_category_id = null;
$current_product_index = (int)$wp_query->current_post;
$previous_product_index = ((int)$wp_query->current_post - 1);
if ( $previous_product_index >= 0 && isset($wp_query->posts[$previous_product_index]->term_id))
$previous_category_id = $wp_query->posts[$previous_product_index]->term_id;
else
$previous_category_id = 0;
if(isset($wp_query->post->term_id))
$current_category_id = $wp_query->post->term_id;
if (( $current_category_id != $previous_category_id )&& $previous_category_id != null)
return true;
else
return false;
}
/**
* wpsc show fb like function, check whether to show facebook like
* @return boolean true if option is on, otherwise, false
*/
function wpsc_show_fb_like(){
if('on' == get_option('wpsc_facebook_like'))
return true;
else
return false;
}
/**
* wpsc have products function, the product loop
* @return boolean true while we have products, otherwise, false
*/
function wpsc_have_products() {
return have_posts();
}
/**
* wpsc the product function, gets the next product,
* @return nothing
*/
function wpsc_the_product() {
global $wpsc_custom_meta, $wpsc_variations;
the_post();
$wpsc_custom_meta = new wpsc_custom_meta( get_the_ID() );
$wpsc_variations = new wpsc_variations( get_the_ID() );
}
/**
* wpsc in the loop function,
* @return boolean - true if we are in the loop
*/
function wpsc_in_the_loop() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
global $wpsc_query;
return $wpsc_query->in_the_loop;
}
/**
* wpsc rewind products function, rewinds back to the first product
* @return nothing
*/
function wpsc_rewind_products() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
global $wpsc_query;
return $wpsc_query->rewind_posts();
}
/**
* wpsc the product id function,
* @return integer - the product ID
*/
function wpsc_the_product_id() {
return get_the_ID();
}
/**
* wpsc edit the product link function
* @return string - a link to edit this product
*/
function wpsc_edit_the_product_link( $link = null, $before = '', $after = '', $id = 0 ) {
global $wpsc_query, $current_user, $table_prefix, $wp_query;
if ( $link == null )
$link = __( 'Edit', 'wpsc' );
$product_id = $wp_query->post->ID;
if ( $id > 0 )
$product_id = $id;
$siteurl = get_option( 'siteurl' );
$output = '';
if(is_user_logged_in()){
get_currentuserinfo();
if ( $current_user->{$table_prefix . 'capabilities'}['administrator'] == 1 )
$output = $before . "" . $link . "" . $after;
}
return $output;
}
/**
* wpsc the product title function
* @return string - the product title
*/
function wpsc_the_product_title() {
return get_the_title();
}
/**
* wpsc product description function
* @return string - the product description
*/
function wpsc_the_product_description() {
$content = get_the_content( __( 'Read the rest of this entry »', 'wpsc' ) );
return wpautop($content,1);
}
/**
* wpsc additional product description function
* TODO make this work with the tabbed multiple product descriptions, may require another loop
* @return string - the additional description
*/
function wpsc_the_product_additional_description() {
global $post;
if ( !empty( $post->post_excerpt ) )
return $post->post_excerpt;
else
return false;
}
/**
* wpsc product permalink function
* @return string - the URL to the single product page for this product
*/
function wpsc_the_product_permalink() {
global $wp_query;
return get_permalink();
}
/**
* wpsc external link function
* @return string - the product price
*/
function wpsc_product_external_link( $id = null ) {
if ( is_numeric( $id ) && ( $id > 0 ) )
$id = absint( $id );
else
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset( $product_meta['external_link'] ) ) {
$external_link = $product_meta['external_link'];
return esc_url( $external_link );
}
}
/**
* wpsc external link text function
* @return string - the product external link text
*/
function wpsc_product_external_link_text( $id = null, $default = null ) {
if ( is_numeric( $id ) && ( $id > 0 ) )
$id = absint( $id );
else
$id = get_the_ID();
$external_link_text = __( 'Buy Now', 'wpsc' );
if ( $default != null ) {
$external_link_text = $default;
}
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset( $product_meta['external_link_text'] ) && !empty( $product_meta['external_link_text'] ) ) {
$external_link_text = $product_meta['external_link_text'];
}
return esc_html( $external_link_text );
}
/**
* wpsc external link target function
* @return string - the product external link target
*/
function wpsc_product_external_link_target( $id = null, $external_link_target = '' ) {
if ( is_numeric( $id ) && ( $id > 0 ) )
$id = absint( $id );
else
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset( $product_meta['external_link_target'] ) && !empty( $product_meta['external_link_target'] ) ) {
$external_link_target = $product_meta['external_link_target'];
}
return esc_attr( $external_link_target );
}
/**
* wpsc product sku function
* @return string - the product price
*/
function wpsc_product_sku( $id = null ) {
if ( is_numeric( $id ) && ( $id > 0 ) )
$id = absint( $id );
else
$id = get_the_ID();
$product_sku = get_post_meta( $id, '_wpsc_sku', true );
return esc_attr( $product_sku );
}
/**
* wpsc product creation time function
* @return string - the product price
*/
function wpsc_product_creation_time( $format = null ) {
global $wpsc_query;
if ( $format == null )
$format = "Y-m-d H:i:s";
return mysql2date( $format, $wpsc_query->product['date_added'] );
}
/**
* wpsc check variation stock availability function
* @return string - the product price
*/
function wpsc_check_variation_stock_availability( $product_id, $variations ) {
global $wpdb;
$selected_post = (array)get_posts( array(
'post_parent' => $product_id,
'post_type' => "wpsc-product",
'post_status' => 'all',
'suppress_filters' => true
) );
foreach ( $selected_post as $variation ) {
$matches = 0;
$terms = wp_get_object_terms( $variation->ID, 'wpsc-variation' );
foreach ( $terms as $term ) {
if ( in_array( $term->term_id, $variations ) )
$matches++;
if ( $matches == count( $variations ) ) {
$the_selected_product = $variation->ID;
}
}
}
if ( wpsc_product_has_stock( $the_selected_product ) ) {
$stock = get_product_meta( $the_selected_product, "stock", true );
$stock = apply_filters( 'wpsc_product_variation_stock', $stock, $id );
if ( 0 < $stock )
return $stock;
}else{
$stock = get_product_meta( $the_selected_product, "stock", true );
$stock = apply_filters( 'wpsc_product_variation_stock', $stock, $id );
if ( is_numeric($stock) ){
$claimed_stock = $wpdb->get_var("SELECT SUM(`stock_claimed`) FROM `".WPSC_TABLE_CLAIMED_STOCK."` WHERE `product_id` IN('$the_selected_product')");
$stock = ($stock - $claimed_stock);
return $stock;
}
}
return '';
}
/**
* wpsc product has stock function
* @return boolean - true if the product has stock or does not use stock, false if it does not
*/
function wpsc_product_has_stock( $id = null ) {
global $wpdb;
// maybe do wpsc_clear_stock_claims first?
if ( is_numeric( $id ) && ( $id > 0 ) )
$id = absint( $id );
else
$id = get_the_ID();
$stock = get_post_meta( $id, '_wpsc_stock', true );
$stock = apply_filters( 'wpsc_product_stock', $stock, $id );
$variations = get_children( array( "post_type" => "wpsc-product", "post_parent" => $id ) );
if ( is_numeric( $stock ) ) {
if ( $stock > 0 && empty($variations)) {
$claimed_stock = $wpdb->get_var("SELECT SUM(`stock_claimed`) FROM `".WPSC_TABLE_CLAIMED_STOCK."` WHERE `product_id` IN($id)");
if($stock - $claimed_stock > 0)
return true;
}
if ( count( $variations ) ) {
foreach ( $variations as $variation ) {
$stock = get_post_meta( $variation->ID, '_wpsc_stock', true );
$claimed_stock = $wpdb->get_var("SELECT SUM(`stock_claimed`) FROM `".WPSC_TABLE_CLAIMED_STOCK."` WHERE `product_id` IN($variation->ID)");
if ( is_numeric( $stock ) && ($stock - $claimed_stock) > 0 ) {
return true;
}
}
}
} else {
return true;
}
}
/**
* wpsc_is_product_external( $product_id = 0 )
*
* Checks if current product is external.
*
* @param int $product_id
*/
function wpsc_is_product_external( $product_id = 0 ) {
// Get product ID if incorrect value was passed
if ( empty( $product_id ) || !is_numeric( $product_id ) )
$product_id = wpsc_the_product_id();
// Get external link
$external_link = wpsc_product_external_link( $product_id );
// Use external if set
if ( !empty( $external_link ) )
return true;
else
return false;
}
/**
* wpsc product remaining stock function
* @return integer - the amount of remaining stock, or null if product is stockless
*/
function wpsc_product_remaining_stock( $id = null ) {
if ( is_numeric( $id ) && ($id > 0) )
$id = absint( $id );
else
$id = get_the_ID();
$is_limited_stock = get_post_meta( $id, '_wpsc_stock', true );
if ( is_numeric( $is_limited_stock ) ) {
$product_stock = get_post_meta( $id, '_wpsc_stock', true );
return absint( $product_stock );
} else {
return null;
}
}
/**
* wpsc is donation function
* @return boolean - true if it is a donation, otherwise false
*/
function wpsc_product_is_donation( $id = null ) {
if ( is_numeric( $id ) && ($id > 0) )
$id = absint( $id );
else
$id = get_the_ID();
$is_donation = get_post_meta( $id, '_wpsc_is_donation', true );
if ( $is_donation == 1 )
return true;
else
return false;
}
/**
* wpsc product on special function
* @return boolean - true if the product is on special, otherwise false
*/
function wpsc_product_on_special() {
global $wpsc_query;
$price = get_product_meta( get_the_ID(), 'price', true );
$special_price = get_product_meta( get_the_ID(), 'special_price', true );
if ( ($special_price > 0) && (($price - $special_price) > 0) )
return true;
else
return false;
}
/**
* wpsc product has file function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_file() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
global $wpsc_query, $wpdb;
if ( is_numeric( $wpsc_query->product['file'] ) && ($wpsc_query->product['file'] > 0) )
return true;
return false;
}
/**
* wpsc product is modifiable function
* @return boolean - true if the product has a file
*/
function wpsc_product_is_customisable() {
global $wpsc_query, $wpdb;
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( (isset($product_meta['engraved']) && $product_meta['engraved'] == true) || (isset($product_meta['can_have_uploaded_image']) && $product_meta['can_have_uploaded_image'] == true) )
return true;
return false;
}
/**
* wpsc product has personal text function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_personal_text() {
global $wpsc_query, $wpdb;
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset($product_meta['engraved']) && $product_meta['engraved'] == true )
return true;
return false;
}
/**
* wpsc product has personal file function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_supplied_file() {
global $wpsc_query, $wpdb;
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset($product_meta['can_have_uploaded_image']) && $product_meta['can_have_uploaded_image'] == true )
return true;
return false;
}
/**
* wpsc product postage and packaging function
* @return string - currently only valid for flat rate
*/
function wpsc_product_postage_and_packaging() {
if ( isset( $id ) && is_numeric( $id ) && ($id > 0) )
$id = absint( $id );
else
$id = get_the_ID();
$product_meta = get_post_meta( $id, '_wpsc_product_metadata', true );
if ( isset( $product_meta['shipping'] ) && is_array( $product_meta['shipping'] ) && 1 != $product_meta['no_shipping'])
return wpsc_currency_display( $product_meta['shipping']['local'] );
else
return wpsc_currency_display( 0 );
}
/**
* wpsc normal product price function
* TODO determine why this function is here
* @return string - returns some form of product price
*/
function wpsc_product_normal_price($forRSS = false) {
global $wpsc_query, $wpdb, $wpsc_variations;
if ( is_object($wpsc_variations) && count( $wpsc_variations->first_variations ) > 0 ) {
//select the variation ID with lovest price
$product_id = $wpdb->get_var('SELECT `posts`.`id` FROM ' . $wpdb->posts . ' `posts` JOIN ' . $wpdb->postmeta . ' `postmeta` ON `posts`.`id` = `postmeta`.`post_id` WHERE `posts`.`post_parent` = ' . get_the_ID() . ' AND `posts`.`post_type` = "wpsc-product" AND `posts`.`post_status` = "inherit" AND `postmeta`.`meta_key`="_wpsc_price" ORDER BY (`postmeta`.`meta_value`)+0 ASC LIMIT 1');
$from = ' from ';
} else {
$product_id = get_the_ID();
$from = '';
}
$from = apply_filters('wpsc_product_variation_text',$from);
$price = get_product_meta( $product_id, 'price', true );
if($forRSS)
$output = $from.wpsc_currency_display( $price, array( 'display_as_html' => false ) );
else
$output = $from.wpsc_currency_display( $price );
return $output;
}
/**
* wpsc product image function
* @return string - the URL to the thumbnail image
*/
function wpsc_the_product_image( $width='', $height='', $product_id='' ) {
if ( empty( $product_id ) )
$product_id = get_the_ID();
$product = get_post( $product_id );
if ( $product->post_parent > 0 )
$product_id = $product->post_parent;
$attached_images = (array)get_posts( array(
'post_type' => 'attachment',
'numberposts' => 1,
'post_status' => null,
'post_parent' => $product_id,
'orderby' => 'menu_order',
'order' => 'ASC'
) );
$post_thumbnail_id = get_post_thumbnail_id( $product_id );
$src = wp_get_attachment_image_src( $post_thumbnail_id, 'large' );
if ( !empty( $src ) && is_string( $src[0] ) ) {
return $src[0];
} elseif ( !empty( $attached_images ) ) {
$attached_image = wp_get_attachment_image_src( $attached_images[0]->ID, 'large' );
return $attached_image[0];
} else {
return apply_filters( 'wpsc_product_image', false);
}
}
/**
* wpsc check display type
*
* Check the display view for the selected category
*
* @return string - display type
*/
function wpsc_check_display_type(){
global $wpsc_query, $post;
if(isset($wpsc_query->query_vars['taxonomy']) && 'wpsc_product_category' == $wpsc_query->query_vars['taxonomy'] && is_string($wpsc_query->query_vars['term']) && 1 < $wpsc_query->post_count)
$display_type = wpsc_get_the_category_display($wpsc_query->query_vars['term']);
else
$display_type = get_option('product_view');
return $display_type;
}
/**
* wpsc product thumbnail function
*
* Show the thumbnail image for the product
*
* @return string - the URL to the thumbnail image
*/
function wpsc_the_product_thumbnail( $width = null, $height = null, $product_id = 0, $page = 'products-page' ) {
$display = wpsc_check_display_type();
// Get the product ID if none was passed
if ( empty( $product_id ) )
$product_id = get_the_ID();
// Load the product
$product = get_post( $product_id );
// Get ID of parent product if one exists
if ( !empty( $product->post_parent ) )
$product_id = $product->post_parent;
// Load image proportions if none were passed
if ( ( $width < 10 ) || ( $height < 10 ) ) {
$width = get_option( 'product_image_width' );
$height = get_option( 'product_image_height' );
}
// Use product thumbnail
if ( has_post_thumbnail( $product_id ) && 'single' != $page) {
$thumbnail_id = get_post_thumbnail_id( $product_id );
// Use first product image
} else {
// Get all attached images to this product
$attached_images = (array)get_posts( array(
'post_type' => 'attachment',
'numberposts' => 1,
'post_status' => null,
'post_parent' => $product_id ,
'orderby' => 'menu_order',
'order' => 'ASC'
) );
if ( !empty( $attached_images ) )
$thumbnail_id = $attached_images[0]->ID;
}
//Overwrite height & width if custom dimensions exist for thumbnail_id
if ( 'grid' != $display && 'products-page' == $page && isset($thumbnail_id)) {
$custom_width = get_post_meta( $thumbnail_id, '_wpsc_custom_thumb_w', true );
$custom_height = get_post_meta( $thumbnail_id, '_wpsc_custom_thumb_h', true );
if ( !empty( $custom_width ) && !empty( $custom_height ) ) {
$width = $custom_width;
$height = $custom_height;
}
} elseif( $page == 'single' && isset($thumbnail_id)) {
$custom_thumbnail = get_post_meta( $thumbnail_id, '_wpsc_selected_image_size', true );
if(!$custom_thumbnail)
$custom_thumbnail = array($width, $height);
$src = wp_get_attachment_image_src( $thumbnail_id, $custom_thumbnail );
if ( !empty( $src ) && is_string( $src[0] ) ) {
return $src[0];
}
}
// Return image link...
if ( isset($thumbnail_id) &&( $image_link = wpsc_product_image( $thumbnail_id, $width, $height ) ))
return $image_link;
// ... or false as if no image was found.
else
return false;
}
/**
* Return the class(es) that should be applied to a product image's tag.
*
* If the thickbox effect is enabled for product images (presentation setting), the thickbox class name is included
*
* This function is called from theme files when outputting product img tags
*
* @since 3.8
* @return string space-separated list of class names (for use in a class="") attribute
*/
function wpsc_the_product_image_link_classes() {
$classes = array( );
if ( get_option( 'show_thumbnails_thickbox' ) )
$classes[] = 'thickbox';
$classes[] = 'preview_link';
$classes = apply_filters( 'wpsc_the_product_image_link_classes', $classes );
return implode( ' ', $classes );
}
/**
* wpsc product comment link function
* @return string - javascript required to make the intense debate link work
*/
function wpsc_product_comment_link() {
// add the product comment link
global $wpsc_query;
if ( get_option( 'wpsc_enable_comments' ) == 1 ) {
$enable_for_product = get_product_meta( get_the_ID(), 'enable_comments' );
if ( (get_option( 'wpsc_comments_which_products' ) == 1 && $enable_for_product == '') || $enable_for_product == 'yes' ) {
$original = array( "&", "'", ":", "/", "@", "?", "=" );
$entities = array( "%26", "%27", "%3A", "%2F", "%40", "%3F", "%3D" );
$output = "
";
}
}
return $output;
}
/**
* wpsc product comments function
* @return string - javascript for the intensedebate comments
*/
function wpsc_product_comments() {
global $wpsc_query;
$output = '';
// add the product comments
if ( get_option( 'wpsc_enable_comments' ) == 1 ) {
$enable_for_product = get_product_meta( $wpsc_query->product['id'], 'enable_comments' );
if ( (get_option( 'wpsc_comments_which_products' ) == 1 && $enable_for_product == '') || $enable_for_product == 'yes' ) {
$output = "
";
}
}
return $output;
}
/**
* wpsc have custom meta function
* @return boolean - true while we have custom meta to display
*/
function wpsc_have_custom_meta() {
global $wpsc_custom_meta;
return esc_html( $wpsc_custom_meta->have_custom_meta() );
}
/**
* wpsc the custom meta function
* @return nothing - iterate through the custom meta vallues
*/
function wpsc_the_custom_meta() {
global $wpsc_custom_meta;
return esc_html( $wpsc_custom_meta->the_custom_meta() );
}
/**
* wpsc custom meta name function
* @return string - the custom metal name
*/
function wpsc_custom_meta_name() {
global $wpsc_custom_meta;
return esc_html( $wpsc_custom_meta->custom_meta_values['meta_key'] );
}
/**
* wpsc custom meta value function
* @return string - the custom meta value
*/
function wpsc_custom_meta_value() {
global $wpsc_custom_meta;
return esc_html( $wpsc_custom_meta->custom_meta_values['meta_value'] );
}
/**
* wpsc have variation groups function
* @return boolean - true while we have variation groups
*/
function wpsc_have_variation_groups() {
global $wpsc_variations;
return $wpsc_variations->have_variation_groups();
}
/**
* wpsc the variation group function
* @return nothing - iterate through the variation groups
*/
function wpsc_the_variation_group() {
global $wpsc_variations;
$wpsc_variations->the_variation_group();
}
/**
* wpsc have variations function
* @return boolean - true while we have variations
*/
function wpsc_have_variations() {
global $wpsc_variations;
return $wpsc_variations->have_variations();
}
/**
* wpsc the variation function
* @return nothing - iterate through the variations
*/
function wpsc_the_variation() {
global $wpsc_variations;
$wpsc_variations->the_variation();
}
function wpsc_product_has_multicurrency() {
global $wpdb, $wpsc_query;
$currency = get_product_meta(get_the_ID(),'currency',true);
if ( count( $currency ) > 0 )
return true;
else
return false;
}
function wpsc_display_product_multicurrency() {
global $wpdb, $wpsc_query;
$results = get_product_meta(get_the_ID(),'currency',true);
if ( count( $results ) > 0 ) {
foreach ( (array)$results as $isocode => $curr ) {
$currency_data = $wpdb->get_row( "SELECT `symbol`,`symbol_html`,`code` FROM `" . WPSC_TABLE_CURRENCY_LIST . "` WHERE `isocode`='" . $isocode . "' LIMIT 1", ARRAY_A );
if ( $currency_data['symbol'] != '' )
$currency_sign = $currency_data['symbol_html'];
else
$currency_sign = $currency_data['code'];
if ( !empty( $currency_sign ) )
return '' . $isocode . ' ' . wpsc_currency_display( $curr["meta_value"] ) . '
';
}
}
return false;
}
/**
* wpsc variation group name function
* @return string - the variaton group name
*/
function wpsc_the_vargrp_name() {
// get the variation group name;
global $wpsc_variations;
return $wpsc_variations->variation_group->name;
}
/**
* wpsc variation group form ID function
* @return string - the variation group form id, for labels and the like
*/
function wpsc_vargrp_form_id() {
// generate the variation group form ID;
global $wpsc_variations, $wpsc_variations;
$product_id = get_the_ID();
$form_id = "variation_select_{$product_id}_{$wpsc_variations->variation_group->term_id}";
return $form_id;
}
/**
* wpsc variation group ID function
* @return integer - the variation group ID
*/
function wpsc_vargrp_id() {
global $wpsc_variations;
return $wpsc_variations->variation_group->term_id;
}
/**
* wpsc the variation name function
* @return string - the variation name
*/
function wpsc_the_variation_name() {
global $wpsc_variations;
return stripslashes( $wpsc_variations->variation->name );
}
/**
* wpsc the variation ID function
* @return integer - the variation ID
*/
function wpsc_the_variation_id() {
global $wpsc_variations;
return $wpsc_variations->variation->term_id;
}
/**
* wpsc the variation out_of_stock function
* @return string - HTML attribute to disable select options and radio buttons
*/
function wpsc_the_variation_out_of_stock() {
global $wpsc_query, $wpdb, $wpsc_variations;
$out_of_stock = false;
// If there is more than one variation group we cannot determine a stock status for individual variations
// Also, if the item is not stock limited, there is no need to check variation stock status
$product_id = get_the_ID();
$stock = get_product_meta( $product_id, 'stock' );
if ( ($wpsc_variations->variation_group_count == 1) && (is_numeric( $stock[0] )) ) {
$product_id = get_the_ID();
$variation_group_id = $wpsc_variations->variation_group->term_id;
$variation_id = $wpsc_variations->variation->term_id;
$wpq = array( 'variations' => $wpsc_variations->variation->slug,
'post_status' => 'inherit',
'post_type' => 'wpsc-product',
'post_parent' => $product_id );
$query = new WP_Query( $wpq );
if ( $query->post_count != 1 ) {
// Should never happen
return FALSE;
}
$variation_product_id = $query->posts[0]->ID;
$stock = get_product_meta( $variation_product_id, "stock" );
$stock = $stock[0];
if ( $stock < 1 ) {
$out_of_stock = true;
}
}
if ( $out_of_stock == true )
return "disabled='disabled'";
else
return '';
}
/**
* wpsc product rater function
* @return string - HTML to display the product rater
*/
function wpsc_product_rater() {
global $wpsc_query;
$product_id = get_the_ID();
$output = '';
if ( get_option( 'product_ratings' ) == 1 ) {
$output .= "";
}
return $output;
}
function wpsc_product_existing_rating( $product_id ) {
global $wpdb;
$get_average = $wpdb->get_results( "SELECT AVG(`rated`) AS `average`, COUNT(*) AS `count` FROM `" . WPSC_TABLE_PRODUCT_RATING . "` WHERE `productid`='" . $product_id . "'", ARRAY_A );
$average = floor( $get_average[0]['average'] );
$count = $get_average[0]['count'];
$output = " ";
for ( $l = 1; $l <= $average; ++$l ) {
$output .= "![$l](" . WPSC_CORE_IMAGES_URL . "/gold-star.gif "$l")
";
}
$remainder = 5 - $average;
for ( $l = 1; $l <= $remainder; ++$l ) {
$output .= "![$l](" . WPSC_CORE_IMAGES_URL . "/grey-star.gif "$l")
";
}
$output .= " (" . $count . ") \r\n";
$output .= " \r\n";
return $output;
}
function wpsc_product_new_rating( $product_id ) {
global $wpdb;
$cookie_data = '';
if (isset($_COOKIE['voting_cookie'][$product_id])) {
$cookie_data = explode( ",", $_COOKIE['voting_cookie'][$product_id] );
}
$vote_id = 0;
if ( isset($cookie_data[0]) && is_numeric( $cookie_data[0] ) )
$vote_id = absint( $cookie_data[0] );
$previous_vote = 1;
if ( $vote_id > 0 )
$previous_vote = $wpdb->get_var( "SELECT `rated` FROM `" . WPSC_TABLE_PRODUCT_RATING . "` WHERE `id`='" . $vote_id . "' LIMIT 1" );
$output = "";
return $output;
}
/**
* wpsc currency sign function
* @return string - the selected currency sign for the store
*/
function wpsc_currency_sign() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
global $wpdb;
$currency_sign_location = get_option( 'currency_sign_location' );
$currency_type = get_option( 'currency_type' );
$currency_symbol = $wpdb->get_var( "SELECT `symbol_html` FROM `" . WPSC_TABLE_CURRENCY_LIST . "` WHERE `id`='" . $currency_type . "' LIMIT 1" );
return $currency_symbol;
}
/**
* wpsc has pages function
* @return boolean - true if we have pages
*/
function wpsc_has_pages() {
if(1 == get_option('use_pagination'))
return true;
else
return false;
}
/**
* this is for the multi adding property, it checks to see whether multi adding is enabled;
*
*/
function wpsc_has_multi_adding() {
if ( get_option( 'multi_add' ) == 1 && (get_option( 'addtocart_or_buynow' ) != 1) ) {
return true;
} else {
return false;
}
}
/**
* wpsc page is selected function
* @return boolean - true if the page is selected
*/
function wpsc_page_is_selected() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
// determine if we are on this page
global $wpsc_query;
return $wpsc_query->page['selected'];
}
/**
* wpsc page URL function
* @return string - the page URL
*/
function wpsc_page_url() {
_deprecated_function( __FUNCTION__, '3.8', 'the updated ' . __FUNCTION__ . '' );
// generate the page URL
global $wpsc_query;
return $wpsc_query->page['url'];
}
/**
* wpsc product count function
* @return string - the page URL
*/
function wpsc_product_count() {
global $wp_query;
return count($wp_query->post);
}
//The following code was removed from WP 3.8, present in 3.7 - Not sure why it was removed and not refactored. (JS)
/**
* wpsc the variation price function
* @return string - the variation price
*/
function wpsc_the_variation_price( $return_as_numeric = false ) {
global $wpdb, $wpsc_variations;
if ( $wpsc_variations->variation_count > 0 ) {
$product_id = get_the_ID();
$wpq = array( 'variations' => $wpsc_variations->variation->slug,
'post_status' => 'inherit,publish',
'post_type' => 'wpsc-product',
'post_parent' => $product_id );
$query = new WP_Query( $wpq );
// Should never happen
if ( $query->post_count != 1 )
return false;
$variation_product_id = $query->posts[0]->ID;
$price = get_product_meta( $variation_product_id, "price",true );
$special_price = get_product_meta( $variation_product_id, "special_price", true );
if($special_price < $price && $special_price > 0)
$price = $special_price;
if ( !$return_as_numeric ) {
$output = wpsc_currency_display( $price,array( 'display_as_html' => false ) );
} else {
$output = $price;
}
} else {
$output = false;
}
return $output;
}
/**
* wpsc the variation stock function
* @return mixed - Stock level for the variation or FALSE if it can't be calculated
*/
function wpsc_the_variation_stock() {
global $wpdb, $wpsc_variations;
if ( $wpsc_variations->variation_count > 0 ) {
$product_id = get_the_ID();
$wpq = array( 'variations' => $wpsc_variations->variation->slug,
'post_status' => 'inherit',
'post_type' => 'wpsc-product',
'post_parent' => $product_id );
$query = new WP_Query( $wpq );
// Should never happen
if ( $query->post_count != 1 )
return false;
// Get the stock count
$vp_id = $query->posts[0]->ID;
$stock = get_product_meta( $vp_id, "stock" );
$stock[0] = apply_filters( 'wpsc_product_variation_stock', $stock[0], $id );
$output = $stock[0];
} else {
return false;
}
return $output;
}
/**
* wpsc_category_grid_view function
* @return bool - whether the category is in grid view or not
*/
function wpsc_category_grid_view(){
if(get_option('wpsc_category_grid_view') == 1)
return true;
else
return false;
}
/**
* wpsc_show_category_description function
* @return bool - whether to show category description or not
*/
function wpsc_show_category_description(){
return get_option('wpsc_category_description');
}
/**
* wpsc_show_category_thumbnails function
* @return bool - whether to show category thumbnails or not
*/
function wpsc_show_category_thumbnails(){
if(get_option('show_category_thumbnails') && wpsc_category_image())
return true;
else
return false;
}
/**
* wpsc_show_thumbnails function
* @return bool - whether to show thumbnails or not
*/
function wpsc_show_thumbnails(){
return get_option('show_thumbnails');
}
/**
* gold_cart_display_gallery function
* @return bool - whether to show gold cart gallery or not
*/
function gold_cart_display_gallery(){
return function_exists('gold_shpcrt_display_gallery');
}
function wpsc_you_save($args = null){
$defaults = array(
'product_id' => false,
'type' => "percentage",
'variations' => false
);
$args = wp_parse_args( $args, $defaults );
extract( $args, EXTR_SKIP );
global $wpdb;
if(!$product_id)
if(function_exists('wpsc_the_product_id')){
//select the variation ID with lowest price
$product_id = $wpdb->get_var('SELECT `posts`.`id` FROM ' . $wpdb->posts . ' `posts` JOIN ' . $wpdb->postmeta . ' `postmeta` ON `posts`.`id` = `postmeta`.`post_id` WHERE `posts`.`post_parent` = ' . wpsc_the_product_id() . ' AND `posts`.`post_type` = "wpsc-product" AND `posts`.`post_status` = "inherit" AND `postmeta`.`meta_key`="_wpsc_price" ORDER BY (`postmeta`.`meta_value`)+0 ASC LIMIT 1');
if(!$product_id)
$product_id=wpsc_the_product_id();
}
if(!$product_id)
return 0;
if($variations)
$sale_price = wpsc_calculate_price( (int)$_POST['product_id'], $variations, true );
else
$sale_price = get_product_meta($product_id, 'special_price', true);
//if sale price is zero, false, or anything similar - return false
if(!$sale_price)
return 0;
if($variations)
$regular_price = wpsc_calculate_price( (int)$_POST['product_id'], $variations, false );
else
$regular_price = get_product_meta($product_id, 'price', true);
//if actual price is zero, false, or something similar, or is less than sale price - return false
if( !$regular_price || !( $sale_price < $regular_price) )
return 0;
switch($type){
case "amount":
return $regular_price - $sale_price;
break;
default:
if(number_format ( ($regular_price - $sale_price) / $regular_price * 100 , 2 ) == 100)
return (99.99);
else
return number_format ( ($regular_price - $sale_price) / $regular_price * 100 , 2 );
}
}
function wpsc_get_downloadable_files($product_id){
$args = array(
'post_type' => 'wpsc-product-file',
'post_parent' => $product_id,
'numberposts' => -1,
'post_status' => 'all',
);
$attached_files = (array)get_posts( $args );
return $attached_files;
}
?>