function product_display_list($product_list, $group_type, $group_sql = '', $search_sql = '')
{
global $wpdb;
$siteurl = get_option('siteurl');
if ((double) WPSC_VERSION < 3.8) {
$images_dir = 'images';
} else {
$images_dir = 'wpsc-core/images';
}
if (get_option('permalink_structure') != '') {
$seperator = "?";
} else {
$seperator = "&";
}
$product_listing_data = wpsc_get_product_listing($product_list, $group_type, $group_sql, $search_sql);
$product_list = $product_listing_data['product_list'];
$output .= $product_listing_data['page_listing'];
if ($product_listing_data['category_id']) {
$category_nice_name = $wpdb->get_var("SELECT `nice-name` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id` ='" . (int) $product_listing_data['category_id'] . "' LIMIT 1");
} else {
$category_nice_name = '';
}
if ($product_list != null) {
$output .= "<table class='list_productdisplay {$category_nice_name}'>";
$i = 0;
foreach ($product_list as $product) {
$num++;
if ($i % 2 == 1) {
$output .= " <tr class='product_view_{$product['id']}'>";
} else {
$output .= " <tr class='product_view_{$product['id']}' style='background-color:#EEEEEE'>";
}
$i++;
$output .= " <td style='width: 9px;'>";
if ($product['description'] != null) {
$output .= "<a href='#' class='additional_description_link' onclick='return show_additional_description(\"list_description_" . $product['id'] . "\",\"link_icon" . $product['id'] . "\");'>";
$output .= "<img style='margin-top:3px;' id='link_icon" . $product['id'] . "' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/icon_window_expand.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' />";
$output .= "</a>";
}
$output .= " </td>\n\r";
$output .= " <td width='55%'>";
if ($product['special'] == 1) {
$special = "<strong class='special'>" . TXT_WPSC_SPECIAL . " - </strong>";
} else {
$special = "";
}
$output .= "<a href='" . wpsc_product_url($product['id']) . "' class='wpsc_product_title' ><strong>" . stripslashes($product['name']) . "</strong></a>";
$output .= " </td>";
$variations_procesor = new nzshpcrt_variations();
$variations_output = $variations_procesor->display_product_variations($product['id'], false, false, true);
if ($variations_output[1] !== null) {
$product['price'] = $variations_output[1];
}
$output .= " <td width='10px' style='text-align: center;'>";
if ($product['quantity'] < 1 && $product['quantity_limited'] == 1) {
$output .= "<img style='margin-top:5px;' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/no_stock.gif' title='No' alt='No' />";
} else {
$output .= "<img style='margin-top:4px;' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/yes_stock.gif' title='Yes' alt='Yes' />";
}
$output .= " </td>";
$output .= " <td width='10%'>";
if ($product['special'] == 1 && $variations_output[1] === null) {
$output .= nzshpcrt_currency_display($product['price'] - $product['special_price'], $product['notax'], false, $product['id']) . "<br />";
} else {
$output .= "<span id='product_price_" . $product['id'] . "'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span>";
}
$output .= " </td>";
$output .= " <td width='20%'>";
if (get_option('addtocart_or_buynow') == '0') {
$output .= "<form name='{$num}' id='product_" . $product['id'] . "' method='POST' action='" . get_option('product_list_url') . $seperator . "category=" . $_GET['category'] . "' onsubmit='submitform(this);return false;' >";
}
if (get_option('list_view_quantity') == 1) {
$output .= "<input type='text' name='quantity' value='1' size='3' maxlength='3'> ";
}
$output .= $variations_output[0];
$output .= "<input type='hidden' name='item' value='" . $product['id'] . "' />";
$output .= "<input type='hidden' name='prodid' value='" . $product['id'] . "'>";
if (get_option('wpsc_selected_theme') == 'iShop') {
if (get_option('addtocart_or_buynow') == '0') {
if ($product['quantity_limited'] == 1 && $product['quantity'] < 1) {
$output .= "<input disabled='true' type='submit' value='' name='Buy' class='wpsc_buy_button'/>";
} else {
$output .= "<input type='submit' name='Buy' value='' class='wpsc_buy_button'/>";
}
} else {
if (!($product['quantity_limited'] == 1 && $product['quantity'] < 1)) {
$output .= google_buynow($product['id']);
}
}
} else {
if (get_option('addtocart_or_buynow') == '0') {
if ($product['quantity_limited'] == 1 && $product['quantity'] < 1) {
$output .= "<input disabled='true' type='submit' name='Buy' class='wpsc_buy_button' value='" . TXT_WPSC_ADDTOCART . "' />";
} else {
$output .= "<input type='submit' name='Buy' class='wpsc_buy_button' value='" . TXT_WPSC_ADDTOCART . "' />";
}
} else {
if (!($product['quantity_limited'] == 1 && $product['quantity'] < 1)) {
$output .= google_buynow($product['id']);
}
}
}
$output .= "</form>";
$output .= " </td>\n\r";
$output .= " </tr>\n\r";
$output .= " <tr class='list_view_description'>\n\r";
$output .= " <td colspan='5'>\n\r";
$output .= " <div id='list_description_" . $product['id'] . "'>\n\r";
$output .= $product['description'];
$output .= " </div>\n\r";
$output .= " </td>\n\r";
$output .= " </tr>\n\r";
}
$output .= "</table>";
} else {
$output .= "<p>" . TXT_WPSC_NOITEMSINTHIS . " " . $group_type . ".</p>";
}
return $output;
}
function product_display_default($product_list, $group_type, $group_sql = '', $search_sql = '')
{
global $wpdb, $wp_rewrite;
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('product_display_default', 'start');
}
$siteurl = get_option('siteurl');
if ($wp_rewrite->permalink_structure != '') {
$seperator = "?";
} else {
$seperator = "&";
}
$product_listing_data = wpsc_get_product_listing($product_list, $group_type, $group_sql, $search_sql);
if ($product_list == '') {
$product_list = $product_listing_data['product_list'];
}
if (get_option('wpsc_page_number_position') == 1 || get_option('wpsc_page_number_position') == 3) {
$output .= $product_listing_data['page_listing'];
}
if ($product_listing_data['category_id']) {
$category_nice_name = $wpdb->get_var("SELECT `nice-name` FROM `" . $wpdb->prefix . "product_categories` WHERE `id` ='" . (int) $product_listing_data['category_id'] . "' LIMIT 1");
} else {
$category_nice_name = '';
}
if ($product_list != null) {
// breadcrumbs start here
if (get_option("show_breadcrumbs") == '1' && is_numeric($product_listing_data['category_id'])) {
$output .= "<div class='breadcrumb'>";
$output .= "<a href='" . get_option('siteurl') . "'>" . get_option('blogname') . "</a> » ";
$category = $product_listing_data['category_id'];
$category_info = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_categories WHERE id='" . $category . "'", ARRAY_A);
$category_name = $wpdb->get_var("SELECT name FROM {$wpdb->prefix}product_categories WHERE id='" . $category . "'");
while ($category_info[0]['category_parent'] != 0) {
$category_info = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_categories WHERE id='" . $category_info[0]['category_parent'] . "'", ARRAY_A);
$output .= "<a href='" . wpsc_category_url($category_info[0]['id']) . "'>" . $category_info[0]['name'] . "</a> » ";
}
$output .= "" . $category_name . "";
// $output .= $product_list[0]['name'];
$output .= "</div>";
}
// breadcrumbs end here
foreach ($product_list as $product) {
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('product_start_loop', 'start', true);
}
$num++;
if (function_exists('wpsc_theme_html')) {
$wpsc_theme = wpsc_theme_html($product);
}
$output .= "<div class='productdisplay default_product_display product_view_{$product['id']} {$category_nice_name}'>";
$output .= " <div class='textcol'>";
if ($category_data[0]['fee'] == 0) {
$output .= " <div class='imagecol'>";
if (get_option('show_thumbnails') == 1) {
if ($product['image'] != null) {
$image_size = @getimagesize(WPSC_IMAGE_DIR . $product['image']);
$output .= "<a href='" . WPSC_IMAGE_URL . $product['image'] . "' class='thickbox preview_link' rel='" . str_replace(" ", "_", $product['name']) . "'>";
if ($product['thumbnail_image'] != null) {
$image_file_name = $product['thumbnail_image'];
} else {
$image_file_name = $product['image'];
}
$output .= "<img src='" . WPSC_THUMBNAIL_URL . $image_file_name . "' title='" . htmlentities($product['name'], ENT_QUOTES) . "' alt='" . htmlentities($product['name'], ENT_QUOTES) . "' id='product_image_" . $product['id'] . "' class='product_image'/>";
$output .= "</a>";
if (function_exists("gold_shpcrt_display_extra_images")) {
$output .= gold_shpcrt_display_extra_images($product['id'], $product['name']);
}
} else {
if (get_option('product_image_width') != '') {
$output .= "<img src='" . WPSC_URL . "/no-image-uploaded.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' width='" . get_option('product_image_width') . "' height='" . get_option('product_image_height') . "' id='product_image_" . $product['id'] . "' class='product_image' />";
} else {
$output .= "<img src='" . WPSC_URL . "/no-image-uploaded.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' id='product_image_" . $product['id'] . "' class='product_image' />";
}
}
if (function_exists('drag_and_drop_items')) {
$output .= drag_and_drop_items("product_image_" . $product['id']);
}
}
$output .= "</div>";
}
if ($product['special'] == 1) {
$special = "<span class='special'>" . TXT_WPSC_SPECIAL . " - </span>";
} else {
$special = "";
}
$output .= "<form id='product_" . $product['id'] . "' name='product_" . $product['id'] . "' method='post' action='" . get_option('product_list_url') . $seperator . "category=" . $_GET['category'] . "' onsubmit='submitform(this);return false;' >";
$output .= "<input type='hidden' name='prodid' value='" . $product['id'] . "' />";
$output .= "<div class='producttext'><h2 class='prodtitles'>";
if (get_option('hide_name_link') != 1) {
$output .= "<a href='" . wpsc_product_url($product['id']) . "' class='wpsc_product_title' >{$special}" . stripslashes($product['name']) . "</a>";
} else {
$output .= "<a class='wpsc_product_title' >{$special}<strong>" . stripslashes($product['name']) . "</strong></a>";
}
$output .= "</h2>";
ob_start();
do_action('wpsc_product_addons', $product['id']);
$output .= ob_get_contents();
ob_end_clean();
if (is_numeric($product['file']) && $product['file'] > 0) {
$file_data = $wpdb->get_row("SELECT * FROM `" . $wpdb->prefix . "product_files` WHERE `id`='" . $product['file'] . "' LIMIT 1", ARRAY_A);
if ($file_data != null && function_exists('listen_button')) {
$output .= listen_button($file_data['idhash'], $file_data['id']);
}
}
if ($product['description'] != '') {
$output .= "<p class='wpsc_description'>" . nl2br(stripslashes($product['description'])) . "</p>";
}
if ($product['additional_description'] != '') {
$output .= "<a href='#' class='additional_description_link' onclick='return show_additional_description(\"additionaldescription" . $product['id'] . "\",\"link_icon" . $product['id'] . "\");'>";
$output .= "<img id='link_icon" . $product['id'] . "' class='additional_description_button' src='" . WPSC_URL . "/images/icon_window_expand.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' />";
$output .= TXT_WPSC_MOREDETAILS . "</a>";
$output .= "<span class='additional_description' id='additionaldescription" . $product['id'] . "'><br />";
$output .= nl2br(stripslashes($product['additional_description'])) . "";
$output .= "</span><br />";
}
// print the custom fields here, if there are any
$custom_fields = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}wpsc_productmeta` WHERE `product_id` IN('{$product['id']}') AND `custom` IN('1') ", ARRAY_A);
if (count($custom_fields) > 0) {
$output .= "<div class='custom_meta'>";
foreach ((array) $custom_fields as $custom_field) {
$output .= "<strong>{$custom_field['meta_key']}:</strong> {$custom_field['meta_value']} <br />";
}
$output .= "</div>";
}
ob_start();
do_action('wpsc_product_addon_after_descr', $product['id']);
$output .= ob_get_contents();
ob_end_clean();
$variations_procesor = new nzshpcrt_variations();
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('display_product_variations', 'start', true);
}
$variations_output = $variations_procesor->display_product_variations($product['id'], false, false, true);
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('display_product_variations', 'stop', true);
}
if ($variations_output[0] != '') {
//will always be set, may sometimes be an empty string
$output .= "<p class='wpsc_variation_forms'>" . $variations_output[0] . "</p>";
}
if ($variations_output[1] !== null) {
$product['price'] = $variations_output[1];
}
$extras_processor = new extras();
$extras_output = $extras_processor->display_product_extras($product['id'], false, false, true);
$output .= "<p class='wpsc_extras_forms'>" . $extras_output . "</p>";
$output .= "<p class='wpsc_product_price'>";
if ($product['donation'] == 1) {
$currency_sign_location = get_option('currency_sign_location');
$currency_type = get_option('currency_type');
$currency_symbol = $wpdb->get_var("SELECT `symbol_html` FROM `" . $wpdb->prefix . "currency_list` WHERE `id`='" . $currency_type . "' LIMIT 1");
$output .= "<label for='donation_price_" . $product['id'] . "'>" . TXT_WPSC_DONATION . ":</label> {$currency_symbol}<input type='text' id='donation_price_" . $product['id'] . "' name='donation_price' value='" . number_format($product['price'], 2) . "' size='6' /><br />";
} else {
if ($product['special'] == 1 && $variations_output[1] === null) {
$output .= "<span class='oldprice'>" . TXT_WPSC_PRICE . ": " . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />";
$output .= TXT_WPSC_PRICE . ": " . nzshpcrt_currency_display($product['price'] - $product['special_price'], $product['notax'], false, $product['id']) . "<br />";
} else {
$output .= TXT_WPSC_PRICE . ": <span id='product_price_" . $product['id'] . "'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />";
}
// if(get_option('display_pnp') == 1) {
// $output .= TXT_WPSC_PNP.": " . nzshpcrt_currency_display($product['pnp'], 1) . "<br />";
// }
}
$output .= "</p>";
$output .= "<input type='hidden' name='item' value='" . $product['id'] . "' />";
$updatelink_sql = "SELECT * FROM " . $wpdb->prefix . "wpsc_productmeta WHERE product_id =" . $product['id'] . " AND meta_key='external_link'";
$updatelink_data = $wpdb->get_results($updatelink_sql, ARRAY_A);
$updatelink = get_product_meta($product['id'], 'external_link', true);
if (function_exists('wpsc_theme_html')) {
$wpsc_theme = wpsc_theme_html($product);
}
if ($product['quantity_limited'] == 1 && $product['quantity'] < 1 && $variations_output[1] === null) {
$output .= "<p class='soldout'>" . TXT_WPSC_PRODUCTSOLDOUT . "</p>";
} else {
if (get_option('hide_addtocart_button') != 1 && get_option('payment_gateway') != 'google') {
if (get_option('addtocart_or_buynow') == 0) {
if (isset($wpsc_theme) && is_array($wpsc_theme) && $wpsc_theme['html'] != '') {
$output .= $wpsc_theme['html'];
} else {
$output .= "<input type='submit' id='product_" . $product['id'] . "_submit_button' class='wpsc_buy_button' name='Buy' value='" . TXT_WPSC_ADDTOCART . "' />";
}
}
}
}
if (get_option('product_ratings') == 1) {
$output .= "<div class='product_footer'>";
$output .= "<div class='product_average_vote'>";
$output .= "<strong>" . TXT_WPSC_AVGCUSTREVIEW . ":</strong>";
$output .= nzshpcrt_product_rating($product['id']);
$output .= "</div>";
$output .= "<div class='product_user_vote'>";
$vote_output = nzshpcrt_product_vote($product['id'], "onmouseover='hide_save_indicator(\"saved_" . $product['id'] . "_text\");'");
if ($vote_output[1] == 'voted') {
$output .= "<strong><span id='rating_" . $product['id'] . "_text'>" . TXT_WPSC_YOURRATING . ":</span>";
$output .= "<span class='rating_saved' id='saved_" . $product['id'] . "_text'> " . TXT_WPSC_RATING_SAVED . "</span>";
$output .= "</strong>";
} else {
if ($vote_output[1] == 'voting') {
$output .= "<strong><span id='rating_" . $product['id'] . "_text'>" . TXT_WPSC_RATETHISITEM . ":</span>";
$output .= "<span class='rating_saved' id='saved_" . $product['id'] . "_text'> " . TXT_WPSC_RATING_SAVED . "</span>";
$output .= "</strong>";
}
}
$output .= $vote_output[0];
$output .= "</div>";
$output .= "</div>";
}
$output .= "</div>";
$output .= "</form>";
//exit("<pre>".print_r($updatelink_data,1)."</pre>");
if (count($updatelink_data) > 0 && $updatelink_data[0]['meta_value'] != '') {
$output .= external_link($product['id']);
} else {
if (get_option('addtocart_or_buynow') == '1') {
if (get_option('payment_gateway') == 'google') {
$output .= google_buynow($product['id']);
} else {
if (get_option('payment_gateway') == 'paypal_multiple') {
$output .= "<form onsubmit='log_paypal_buynow(this)' target='paypal' action='" . get_option('paypal_multiple_url') . "' method='post'>\n\t\t\t\t\t\t\t<input type='hidden' name='business' value='" . get_option('paypal_multiple_business') . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='cmd' value='_xclick'>\n\t\t\t\t\t\t\t<input type='hidden' name='item_name' value='" . $product['name'] . "'>\n\t\t\t\t\t\t\t<input type='hidden' id='item_number' name='item_number' value='" . $product['id'] . "'>\n\t\t\t\t\t\t\t<input type='hidden' id='amount' name='amount' value='" . $product['price'] . "'>\n\t\t\t\t\t\t\t<input type='hidden' id='unit' name='unit' value='" . $product['price'] . "'>\n\t\t\t\t\t\t\t<input type='hidden' id='shipping' name='ship11' value='" . $shipping . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='handling' value='" . get_option('base_local_shipping') . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='currency_code' value='" . get_option('paypal_curcode') . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='undefined_quantity' value='0'>\n\t\t\t\t\t\t\t<input type='image' name='submit' border='0' src='https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif' alt='PayPal - The safer, easier way to pay online'>\n\t\t\t\t\t\t\t<img alt='' border='0' width='1' height='1' src='https://www.paypal.com/en_US/i/scr/pixel.gif' >\n\t\t\t\t\t\t</form>\n\t\t\t\t\t";
}
}
}
}
$output .= " </div>\n\r";
$output .= " <div class='clear'></div>\n\r";
$output .= "</div>";
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('product_start_loop', 'stop', true);
}
}
} else {
if ($_GET['product_search'] != null) {
$output .= "<br /><strong class='cattitles'>" . TXT_WPSC_YOUR_SEARCH_FOR . " \"" . $_GET['product_search'] . "\" " . TXT_WPSC_RETURNED_NO_RESULTS . "</strong>";
} else {
$output .= "<p>" . TXT_WPSC_NOITEMSINTHIS . " " . $group_type . ".</p>";
if (get_option('wpsc_default_category') == $product_listing_data['category_id']) {
$output .= wpsc_odd_category_setup();
}
}
}
if (get_option('wpsc_page_number_position') == 2 || get_option('wpsc_page_number_position') == 3) {
$output .= $product_listing_data['page_listing'];
}
$output = str_replace('$', '$', $output);
if (WPSC_DEBUG === true) {
wpsc_debug_start_subtimer('product_display_default', 'stop');
}
return $output;
}
