?>
</ul>
<?php
$producttags_split_sql = "select p.`products_id`,pd.`products_name` from " . TABLE_PRODUCTS . " p," . TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id` = pd.`products_id` AND right(LEFT(pd.`products_name`,9),1) LIKE '" . strtolower($_GET['letter']) . "'";
//print_r($producttags_split_sql);LEFT(pd.`products_name`,1)
$producttags_split = new splitPageResults($producttags_split_sql, PRODCUTTAGS_LIST_PAGE_SIZE, 'p.products_id', 'page');
$zco_notifier->notify('NOTIFY_MODULE_PRODUCT_LISTING_RESULTCOUNT', $producttags_split->number_of_rows);
$producttags = $db->Execute($producttags_split->sql_query);
//echo $producttags->RecordCount();
?>
<ul class="a_z_grid">
<?php
if ($producttags->RecordCount() > 0) {
while (!$producttags->EOF) {
echo '<li><a href="' . zen_href_link(zen_get_info_page($producttags->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($_GET['cPath']) . '&products_id=' . $producttags->fields['products_id']) . '" >' . str_replace("Replica ", "", $producttags->fields['products_name']) . '</a>';
$producttags->MoveNext();
}
} else {
if (!in_array($_GET['letter'], range('a', 'z')) && $_GET['letter'] != '0-9') {
//cx update
//zen_redirect(zen_href_link(FILENAME_DEFINE_PAGE_NOT_FOUND));
echo '<div style="text-align:center"><div class="error_box" style="width:300px;text-align:center; margin:0 auto;">Sorry,This is Tags "' . $_GET['letter'] . '" no Container Products</div></div>';
}
//echo FILENAME_DEFINE_PAGE_NOT_FOUND;
//zen_redirect(zen_href_link(FILENAME_DEFINE_PAGE_NOT_FOUND));
}
?>
</ul>
<?php
//print_r(zen_get_all_get_params(array('page', 'info', 'x', 'y')));
$canonicalLink = '';
switch (TRUE) {
/**
* SSL Pages get no special treatment, since they're not normally indexed (unless the entire site is intentionally set to always be SSL, which is not typical)
*/
case $request_type == 'SSL' && substr(HTTP_SERVER, 0, 5) != 'https':
$canonicalLink = '';
break;
/**
* for products (esp those linked to multiple categories):
*/
/**
* for products (esp those linked to multiple categories):
*/
case strstr($current_page, '_info') && isset($_GET['products_id']):
$canonicalLink = zen_href_link($current_page, ($includeCPath ? 'cPath=' . zen_get_generated_category_path_rev(zen_get_products_category_id($_GET['products_id'])) . '&' : '') . 'products_id=' . $_GET['products_id'], 'NONSSL', false);
break;
/**
* for product listings:
*/
/**
* for product listings:
*/
case $current_page == 'index' && isset($_GET['cPath']):
$canonicalLink = zen_href_link($current_page, zen_get_all_get_params($excludeParams), 'NONSSL', false);
break;
/**
* for music products:
*/
/**
* for music products:
<?php
/**
* Side Box Template
*
* @package templateSystem
* @copyright Copyright 2003-2011 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_featured.php 18698 2011-05-04 14:50:06Z wilt $
*/
$content = "";
$content .= '<div class="sideBoxContent centeredContent">';
$featured_box_counter = 0;
while (!$random_featured_product->EOF) {
$featured_box_counter++;
$featured_box_price = zen_get_products_display_price($random_featured_product->fields['products_id']);
$content .= "\n" . ' <div class="sideBoxContentItem">';
$content .= '<a href="' . zen_href_link(zen_get_info_page($random_featured_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_featured_product->fields["master_categories_id"]) . '&products_id=' . $random_featured_product->fields["products_id"]) . '">' . zen_image(DIR_WS_IMAGES . $random_featured_product->fields['products_image'], $random_featured_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
$content .= '<br />' . $random_featured_product->fields['products_name'] . '</a>';
$content .= '<div>' . $featured_box_price . '</div>';
$content .= '</div>';
$random_featured_product->MoveNextRandom();
}
$content .= '</div>' . "\n";
$row = 0;
$col = 0;
$list_box_contents = array();
$title = '';
$num_products_count = $new_products_query == '' ? 0 : $new_products->RecordCount();
// show only when 1 or more
if ($num_products_count > 0) {
if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0) {
$col_width = floor(100 / $num_products_count);
} else {
$col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
}
while (!$new_products->EOF) {
$products_price = zen_get_products_display_price($new_products->fields['products_id']);
if (!isset($productsInCategory[$new_products->fields['products_id']])) {
$productsInCategory[$new_products->fields['products_id']] = zen_get_generated_category_path_rev($new_products->fields['master_categories_id']);
}
$list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsNew centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"', 'text' => (($new_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_products->fields['products_image'], $new_products->fields['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . $new_products->fields['products_name'] . '</a><br />' . $products_price);
$col++;
if ($col > SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - 1) {
$col = 0;
$row++;
}
$new_products->MoveNextRandom();
}
if ($new_products->RecordCount() > 0) {
if (isset($new_products_category_id) && $new_products_category_id != 0) {
$category_title = zen_get_categories_name((int) $new_products_category_id);
$title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '') . '</h2>';
} else {
$title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . '</h2>';
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0) {
$specials_query_raw = "SELECT p.products_id, p.products_image, pd.products_name,\n p.master_categories_id\n FROM (" . TABLE_PRODUCTS . " p\n LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id\n LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )\n WHERE p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1'\n AND s.status = 1\n AND pd.language_id = :languagesID\n AND p.shop_id = " . (int) $_SESSION['shop_id'] . "\n ORDER BY s.specials_date_added DESC";
$specials_query_raw = $db->bindVars($specials_query_raw, ':languagesID', $_SESSION['languages_id'], 'integer');
$specials_split = new splitPageResults($specials_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS);
$specials = $db->Execute($specials_split->sql_query);
$row = 0;
$col = 0;
$list_box_contents = array();
$title = '';
$num_products_count = $specials->RecordCount();
if ($num_products_count) {
if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS == 0) {
$col_width = floor(100 / $num_products_count);
} else {
$col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS);
}
$list_box_contents = array();
while (!$specials->EOF) {
$products_price = zen_get_products_display_price($specials->fields['products_id']);
$specials->fields['products_name'] = zen_get_products_name($specials->fields['products_id']);
$list_box_contents[$row][$col] = array('params' => 'class="specialsListBoxContents"' . ' ' . 'style="width:' . $col_width . '%;"', 'text' => '<a href="' . zen_href_link(zen_get_info_page($specials->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($specials->fields['master_categories_id']) . '&products_id=' . $specials->fields['products_id']) . '">' . (($specials->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : zen_image(DIR_WS_IMAGES . $specials->fields['products_image'], $specials->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>') . '<br /><a class="pro_name_hight" href="' . zen_href_link(zen_get_info_page($specials->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($specials->fields['master_categories_id']) . '&products_id=' . $specials->fields['products_id']) . '">' . $specials->fields['products_name'] . '</a><br />' . $products_price);
$col++;
if ($col > SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS - 1) {
$col = 0;
$row++;
}
$specials->MoveNext();
}
require $template->get_template_dir('tpl_specials_default.php', DIR_WS_TEMPLATE, $current_page_base, 'templates') . '/tpl_specials_default.php';
}
}
* @copyright Portions Copyright 2003 osCommerce
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$show_submit = zen_run_normal();
$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_LISTING, 'p.products_id', 'page');
$zco_notifier->notify('NOTIFY_MODULE_PRODUCT_LISTING_RESULTCOUNT', $listing_split->number_of_rows);
$how_many = 0;
$tpl_products = array('title' => '', 'products' => array());
if ($listing_split->number_of_rows > 0) {
$listing = $db->Execute($listing_split->sql_query, false, true, CACHE_TIMELIFT);
while (!$listing->EOF) {
$the_categories_name_query = "select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id= '" . $listing->fields['master_categories_id'] . "' and language_id= '" . $_SESSION['languages_id'] . "'";
$the_categories_name = $db->Execute($the_categories_name_query, null, true, CACHE_TIMELIFT);
$tpl_products['products'][$listing->fields['products_id']] = array('name' => $listing->fields['products_name'], 'image' => $listing->fields['products_image'], 'quantity' => $listing->fields['products_quantity'], 'weight' => $listing->fields['products_weight'], 'type' => $listing->fields['products_type'], 'categories_id' => $listing->fields['master_categories_id'], 'categories_name' => $the_categories_name->fields['categories_name'], 'categories_href' => zen_href_link(FILENAME_DEFAULT, 'cPath=' . $listing->fields['master_categories_id']), 'manufacturers_id' => $listing->fields['manufacturers_id'], 'products_price' => $listing->fields['products_price'], 'tax_class_id' => $listing->fields['products_tax_class_id'], 'description' => zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION), 'content' => $listing->fields['products_description'], 'specials_price' => $listing->fields['specials_new_products_price'], 'final_price' => $listing->fields['final_price'], 'sort_order' => $listing->fields['products_sort_order'], 'is_call' => $listing->fields['product_is_call'], 'is_always_free_shipping' => $listing->fields['product_is_always_free_shipping'], 'qty_box_status' => $listing->fields['products_qty_box_status'], 'href' => zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']), 'display_price' => zen_get_products_display_price($listing->fields['products_id']), 'is_free' => get_product_is_free($listing->fields['products_id']), 'display_normal_price' => get_normal_price($listing->fields['products_id']), 'display_special_price' => get_special_price($listing->fields['products_id']), 'display_sale_price' => get_sale_discount_price($listing->fields['products_id']));
if (PRODUCT_LIST_MANUFACTURER != 0) {
$tpl_products['products'][$listing->fields['products_id']]['show_manufacturer'] = true;
$tpl_products['products'][$listing->fields['products_id']]['manufacturers_name'] = $listing->fields['manufacturers_name'];
$tpl_products['products'][$listing->fields['products_id']]['manufacturers_href'] = zen_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing->fields['manufacturers_id']);
}
$listing->MoveNext();
}
$error_categories = false;
} else {
$tpl_products = array('title' => '', 'products' => array());
$error_categories = true;
}
$multiple_buy = false;
if ($how_many > 0 and $show_submit == true and $listing_split->number_of_rows > 0 and (PRODUCT_LISTING_MULTIPLE_ADD_TO_CART == 1 or PRODUCT_LISTING_MULTIPLE_ADD_TO_CART == 3)) {
$show_top_submit_button = true;
<div class="price">
<?php
echo $products_price;
?>
</div>
</div>
</div>
<!-- Product Grid View Ends -->
<!-- Product List View -->
<div class="product-listview list-view">
<div class="row product-list-row">
<div class="col col-lg-4 col-sm-4">
<div class="product-image">
<div class="image">
<a href="<?php
echo zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']);
?>
"><?php
echo $display_products_image;
?>
</a>
</div>
</div>
</div>
<div class="col col-lg-8 col-sm-8">
<div class="product-info">
<h3 class="name">
<?php
echo $display_products_name;
?>
</h3>
$frist_get_pid_query3 = " select distinct products_id\n\t\t from products \n\t\t\t\t\t\t\t where products_status = 1 \n\t\t\t\t\t\t\t order by products_date_added desc\n\t\t\t\t\t\t\t limit 0," . MAX_DISPLAY_NEW_PRODUCTS;
$frist_get_pid_db3 = $db->Execute($frist_get_pid_query3);
$frist_get_pid3 = array();
if ($frist_get_pid_db3->RecordCount() > 0) {
while (!$frist_get_pid_db3->EOF) {
$frist_get_pid3[] = $frist_get_pid_db3->fields['products_id'];
$frist_get_pid_db3->MoveNext();
}
$frist_pid_str3 = implode(',', $frist_get_pid3);
$new_products_query = "select distinct p.products_id, p.products_image, \n\t\t\t\t\t\t\t\t\t\t\t\t pd.products_name,\n\t\t\t\t\t\t\t\t\t\t\t\t p.master_categories_id\n\t\t\t\t\t\t\t\t from " . TABLE_PRODUCTS . " p, \n\t\t\t\t\t\t\t\t\t " . TABLE_PRODUCTS_DESCRIPTION . " pd\n\t\t\t\t\t\t\t\t where p.products_id = pd.products_id\n\t\t\t\t\t\t\t\t and pd.language_id = " . (int) $_SESSION['languages_id'] . "\n\t\t\t\t\t\t\t\t and p.products_id in(" . $frist_pid_str3 . ")\n\t\t\t\t\t\t\t\t ";
//. $display_limit;
}
}
} else {
// get all products and cPaths in this subcat tree
$productsInCategory = zen_get_categories_products_list($manufacturers_id > 0 && $_GET['filter_id'] > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath, false, true, 0, $display_limit);
if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {
// build products-list string to insert into SQL query
foreach ($productsInCategory as $key => $value) {
$list_of_products .= $key . ', ';
}
$list_of_products = substr($list_of_products, 0, -2);
// remove trailing comma
$new_products_query = "select distinct p.products_id, p.products_image, \n\t pd.products_name,\n p.master_categories_id\n from " . TABLE_PRODUCTS . " p, \n\t\t\t\t\t\t " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = pd.products_id \n\t\t\t\t\t\t and p.products_status = 1 \n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.products_id in (" . $list_of_products . ") \n\t\t\t\t\t\t order by p.products_ordered desc,p.products_date_added desc limit 0," . MAX_DISPLAY_NEW_PRODUCTS;
}
}
if ($new_products_query != '') {
$new_products_db = $db->Execute($new_products_query);
}
$num_products_count = $new_products_query == '' ? 0 : $new_products_db->RecordCount();
// show only when 1 or more
<?php
/**
* featured sidebox - displays a random Featured Product
*
* @package templateSystem
* @author JunsGo@msn.com
* @copyright Copyright 2013 SL Development Team
* @copyright Portions Copyright 2003 osCommerce
*/
// test if box should display
$show_featured = true;
if ($show_featured == true) {
$random_featured_products_query = "select p.products_id, p.products_image, pd.products_name,\n p.master_categories_id, p.product_is_free\n from (" . TABLE_PRODUCTS . " p\n left join " . TABLE_FEATURED . " f on p.products_id = f.products_id\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )\n where p.products_id = f.products_id\n and p.products_id = pd.products_id\n and p.products_status = 1\n and f.status = 1\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
// randomly select ONE featured product from the list retrieved:
// $random_featured_product = zen_random_select($random_featured_products_query);
$random_featured_product = $db->ExecuteRandomMulti($random_featured_products_query, MAX_RANDOM_SELECT_FEATURED_PRODUCTS, true, CACHE_TIMELIFT);
if ($random_featured_product->RecordCount() > 0) {
$tpl_feature_array = array();
while (!$random_featured_product->EOF) {
$tpl_feature_array[] = array('id' => $random_featured_product->fields['products_id'], 'name' => $random_featured_product->fields['products_name'], 'href' => zen_href_link(zen_get_info_page($random_featured_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_featured_product->fields["master_categories_id"]) . '&products_id=' . $random_featured_product->fields["products_id"]), 'image' => $random_featured_product->fields['products_image'], 'price' => zen_get_products_display_price($random_featured_product->fields['products_id']), 'categories_id' => $random_featured_product->fields['master_categories_id'], 'is_free' => $random_featured_product->fields['product_is_free'] == 1 ? true : false, 'display_normal_price' => get_normal_price($random_featured_product->fields['products_id']), 'display_special_price' => get_special_price($random_featured_product->fields['products_id']), 'display_sale_price' => get_sale_discount_price($random_featured_product->fields['products_id']));
$random_featured_product->MoveNextRandom();
}
require $template->get_template_dir('tpl_featured.php', DIR_WS_TEMPLATE, $current_page_base, 'sideboxes') . '/tpl_featured.php';
}
}
$review_query = "select products_id, reviews_rating from " . TABLE_REVIEWS . " where products_id='{$pid}'";
$review_res = $db->Execute($review_query);
$rating_stars = $review_res->fields['reviews_rating'];
if ($pid == $sid) {
$msg_product = "<div class='tag tag-orange' title=''><div class='text'>SALE</div></div>";
} else {
if ($pid == $fid) {
$msg_product = "<div class='tag tag-orange' title=''><div class='text'>HOT</div></div>";
} else {
$msg_product = "<div class='tag tag-blue' title=''><div class='text'>NEW</div></div>";
}
}
$products_name = $relatedResult->fields['products_name'];
//$products_name = ltrim(substr($products_name, 0, 35) . ''); //Trims and Limits the product name
if (!isset($productsInCategory[$relatedResult->fields['products_id']])) {
$productsInCategory[$relatedResult->fields['products_id']] = zen_get_generated_category_path_rev($relatedResult->fields['master_categories_id']);
}
if (UN_MODULE_WISHLISTS_ENABLED) {
$wishlist_link = zen_href_link(UN_FILENAME_WISHLIST, 'products_id=' . $relatedResult->fields['products_id'] . '&action=wishlist_add_product');
} else {
$wishlist_link = '';
}
$compare_link = 'javascript: compareNew(' . $relatedResult->fields['products_id'] . ', \'add\')';
$buy_now = zen_get_buy_now_button($relatedResult->fields['products_id'], '');
if ($buy_now != NULL) {
$buy_now = '<a title="Sold Out" class="detailbutton-wrapper add-to-cart" href="' . zen_href_link(zen_get_info_page($relatedResult->fields['products_id']), 'cPath=' . $productsInCategory[$relatedResult->fields['products_id']] . '&products_id=' . $relatedResult->fields['products_id']) . '"><i class="fa fa-ban fa-lg"></i></a>';
} elseif ($attribute_product == $pid) {
$buy_now = '<a title="Add to Cart" class="detailbutton-wrapper add-to-cart" href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $relatedResult->fields['products_id']) . '"><i class="fa fa-shopping-cart fa-lg"></i></a>';
} else {
$buy_now = '<a title="Add to Cart" class="detailbutton-wrapper add-to-cart" href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $relatedResult->fields['products_id']) . '"><i class="fa fa-shopping-cart fa-lg"></i></a>';
}
<?php
/**
* Side Box Template
*
* @package templateSystem
* @copyright Copyright 2003-2011 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_whats_new.php 18698 2011-05-04 14:50:06Z wilt $
*/
$content = "";
$content .= '<div class="sideBoxContent centeredContent">';
$whats_new_box_counter = 0;
while (!$random_whats_new_sidebox_product->EOF) {
$whats_new_box_counter++;
$whats_new_price = zen_get_products_display_price($random_whats_new_sidebox_product->fields['products_id']);
$content .= "\n" . ' <div class="sideBoxContentItem">';
$content .= '<div class="sidebox_content"><div class="product_sideboximage">' . zen_image(DIR_WS_IMAGES . $random_whats_new_sidebox_product->fields['products_image'], $random_whats_new_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</div>';
$content .= '<div class="product_sideboxname"><a href="' . zen_href_link(zen_get_info_page($random_whats_new_sidebox_product->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($random_whats_new_sidebox_product->fields['master_categories_id']) . '&products_id=' . $random_whats_new_sidebox_product->fields['products_id']) . '">' . $random_whats_new_sidebox_product->fields['products_name'] . '</a>';
$content .= '<div class="sidebox_price">' . $whats_new_price . '</div></div></div>';
$content .= '</div>';
$random_whats_new_sidebox_product->MoveNextRandom();
}
$content .= '</div>' . "\n";
<?php
/**
* specials sidebox - displays a random product "on special"
*
* @package templateSystem
* @author JunsGo@msn.com
* @copyright Copyright 2013 SL Development Team
* @copyright Portions Copyright 2003 osCommerce
*/
// test if box should display
$show_specials = false;
if (isset($_GET['products_id'])) {
$show_specials = false;
} else {
$show_specials = true;
}
if ($show_specials == true) {
$random_specials_sidebox_product_query = "select p.products_id, pd.products_name, p.products_price,\n p.products_tax_class_id, p.products_image,\n s.specials_new_products_price,\n p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s\n where p.products_status = 1\n and p.products_id = s.products_id\n and pd.products_id = s.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and s.status = 1";
// $random_specials_sidebox_product = zen_random_select($random_specials_sidebox_product_query);
$random_specials_sidebox_product = $db->ExecuteRandomMulti($random_specials_sidebox_product_query, MAX_RANDOM_SELECT_SPECIALS, true, CACHE_TIMELIFT);
if ($random_specials_sidebox_product->RecordCount() > 0) {
$tpl_special_array = array();
while (!$random_specials_sidebox_product->EOF) {
$tpl_special_array[] = array('id' => $random_specials_sidebox_product->fields["products_id"], 'name' => $random_specials_sidebox_product->fields["products_name"], 'href' => zen_href_link(zen_get_info_page($random_specials_sidebox_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_specials_sidebox_product->fields["master_categories_id"]) . '&products_id=' . $random_specials_sidebox_product->fields["products_id"]), 'image' => $random_specials_sidebox_product->fields['products_image'], 'price' => zen_get_products_display_price($random_specials_sidebox_product->fields['products_id']), 'categories_id' => $random_specials_sidebox_product->fields['master_categories_id'], 'tax_class_id' => $random_specials_sidebox_product->fields['products_tax_class_id']);
$random_specials_sidebox_product->MoveNextRandom();
}
require $template->get_template_dir('tpl_specials.php', DIR_WS_TEMPLATE, $current_page_base, 'sideboxes') . '/tpl_specials.php';
}
}
function zen_get_reviews($products_id)
{
global $db;
$reviewArray = array();
$querySql = "SELECT r.`reviews_rating` FROM reviews r\n WHERE r.`status` = 1 AND r.`products_id` = " . $products_id . "\n ORDER BY r.`reviews_rating` DESC";
$reviews = $db->Execute($querySql);
if ($reviews->RecordCount() > 0) {
while (!$reviews->EOF) {
$reviewArray[] = $reviews->fields['reviews_rating'];
$reviews->MoveNext();
}
$outString = '<span class="fl">';
$starNum = $reviewArray[0];
for ($i = 0; $i < 5; $i++) {
if ($i < $starNum) {
$outString .= '<span class="star"></span>';
} else {
$outString .= '<span class="star_gray"></span>';
}
}
$outString .= ' <a href="' . zen_href_link(zen_get_info_page($products_id), 'cPath=' . zen_get_generated_category_path_rev($_GET['cPath']) . '&products_id=' . $products_id) . '" >' . sizeof($reviewArray) . ' review</a></span>';
} else {
$outString = '<span class="fl"><a href="' . zen_href_link(zen_get_info_page($products_id), 'cPath=' . zen_get_generated_category_path_rev($_GET['cPath']) . '&products_id=' . $products_id) . '#review" >' . PRODUCTS_LISTING_WRITE_VIEWS . '</a></span>';
}
return $outString;
}
if ($productIsSBA[$i] && (PRODINFO_ATTRIBUTE_PLUGIN_MULTI == 'single_dropdown' || PRODINFO_ATTRIBUTE_PLUGIN_MULTI == 'single_radioset') && (PRODINFO_ATTRIBUTE_DYNAMIC_STATUS == '1' || PRODINFO_ATTRIBUTE_DYNAMIC_STATUS == '2')) {
/* Breakdown the attributes into individual attributes to then be able to
* feed them into the applicable section(s).
*
*/
}
foreach ($_POST['id'] as $key => $value) {
$check = zen_get_attributes_valid($_POST['products_id'], $key, $value);
if ($check == false) {
$the_list .= TEXT_ERROR_OPTION_FOR . '<span class="alertBlack">' . zen_options_name($key) . '</span>' . TEXT_INVALID_SELECTION . '<span class="alertBlack">' . ($value == (int) PRODUCTS_OPTIONS_VALUES_TEXT_ID ? TEXT_INVALID_USER_INPUT : zen_values_name($value)) . '</span>' . '<br />';
}
}
}
if (!is_numeric($_POST['cart_quantity']) || $_POST['cart_quantity'] < 0) {
// adjust quantity when not a value
$chk_link = '<a href="' . zen_href_link(zen_get_info_page($_POST['products_id']), 'cPath=' . zen_get_generated_category_path_rev(zen_get_products_category_id($_POST['products_id'])) . '&products_id=' . $_POST['products_id']) . '">' . zen_get_products_name($_POST['products_id']) . '</a>';
$messageStack->add_session('header', ERROR_CORRECTIONS_HEADING . ERROR_PRODUCT_QUANTITY_UNITS_SHOPPING_CART . $chk_link . ' ' . PRODUCTS_ORDER_QTY_TEXT . zen_output_string_protected($_POST['cart_quantity']), 'caution');
$_POST['cart_quantity'] = 0;
}
$attr_list = array();
$attr_dash = array();
$attr_id = array();
$attr_val = array();
if ((PRODINFO_ATTRIBUTE_PLUGIN_MULTI == 'single_dropdown' || PRODINFO_ATTRIBUTE_PLUGIN_MULTI == 'single_radioset') && (PRODINFO_ATTRIBUTE_DYNAMIC_STATUS == '1' || PRODINFO_ATTRIBUTE_DYNAMIC_STATUS == '2')) {
/*single dropdown as multiple*/
$attr_list = explode(',', $_POST['attrcomb']);
foreach ($attr_list as $attr_item) {
list($attr_id, $attr_val) = explode('-', $attr_item);
if (zen_not_null($attr_id) && zen_not_null($attr_val)) {
$_POST['id'][$attr_id] = $attr_val;
}
$col = 0;
$list_box_contents = array();
$title = '';
$num_products_count = $specials_index_query == '' ? 0 : $specials_index->RecordCount();
// show only when 1 or more
if ($num_products_count > 0) {
if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS == 0) {
$col_width = floor(100 / $num_products_count);
} else {
$col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS);
}
$list_box_contents = array();
while (!$specials_index->EOF) {
$products_price = zen_get_products_display_price($specials_index->fields['products_id']);
if (!isset($productsInCategory[$specials_index->fields['products_id']])) {
$productsInCategory[$specials_index->fields['products_id']] = zen_get_generated_category_path_rev($specials_index->fields['master_categories_id']);
}
$specials_index->fields['products_name'] = zen_get_products_name($specials_index->fields['products_id']);
$list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsSpecials centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"', 'text' => (($specials_index->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($specials_index->fields['products_id']), 'cPath=' . $productsInCategory[$specials_index->fields['products_id']] . '&products_id=' . (int) $specials_index->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $specials_index->fields['products_image'], $specials_index->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($specials_index->fields['products_id']), 'cPath=' . $productsInCategory[$specials_index->fields['products_id']] . '&products_id=' . $specials_index->fields['products_id']) . '">' . $specials_index->fields['products_name'] . '</a><br />' . $products_price);
$col++;
if ($col > SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS - 1) {
$col = 0;
$row++;
}
$specials_index->MoveNextRandom();
}
if ($specials_index->RecordCount() > 0) {
$title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_SPECIALS_INDEX, strftime('%B')) . '</h2>';
$zc_show_specials = true;
}
}
<?php
/**
* whats_new sidebox - displays a random "new" product
*
* @package templateSystem
* @author JunsGo@msn.com
* @copyright Copyright 2013 SL Development Team
* @copyright Portions Copyright 2003 osCommerce
*/
// display limits
// $display_limit = zen_get_products_new_timelimit();
$idx = 0;
$tpl_what_new = array();
$display_limit = zen_get_new_date_range();
// var_dump($display_limit);exit;
$random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,\n p.master_categories_id, p.product_is_free\n from (" . TABLE_PRODUCTS . " p\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )\n where p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.shop_id = " . (int) $_SESSION['shop_id'] . "\n and p.products_status = 1 " . $display_limit;
$random_whats_new_sidebox_product = $db->ExecuteRandomMulti($random_whats_new_sidebox_product_query, MAX_RANDOM_SELECT_NEW, true, CACHE_TIMELIFT);
if ($random_whats_new_sidebox_product->RecordCount() > 0) {
// var_dump($random_whats_new_sidebox_product);
// exit;
while (!$random_whats_new_sidebox_product->EOF) {
$tpl_what_new[$idx] = array('id' => $random_whats_new_sidebox_product->fields['products_id'], 'name' => $random_whats_new_sidebox_product->fields['products_name'], 'href' => zen_href_link(zen_get_info_page($random_whats_new_sidebox_product->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($random_whats_new_sidebox_product->fields['master_categories_id']) . '&products_id=' . $random_whats_new_sidebox_product->fields['products_id']), 'image' => $random_whats_new_sidebox_product->fields['products_image'], 'price' => zen_get_products_display_price($random_whats_new_sidebox_product->fields['products_id']), 'categories_id' => $random_whats_new_sidebox_product->fields['master_categories_id'], 'tax_class_id' => $random_whats_new_sidebox_product->fields['products_tax_class_id'], 'is_free' => $random_whats_new_sidebox_product->fields['product_is_free'] == '1' ? true : false, 'display_normal_price' => get_normal_price($random_whats_new_sidebox_product->fields['products_id']), 'display_special_price' => get_special_price($random_whats_new_sidebox_product->fields['products_id']), 'display_sale_price' => get_sale_discount_price($random_whats_new_sidebox_product->fields['products_id']));
++$idx;
$random_whats_new_sidebox_product->MoveNextRandom();
}
unset($idx);
require $template->get_template_dir('tpl_whats_new2.php', DIR_WS_TEMPLATE, $current_page_base, 'sideboxes') . '/tpl_whats_new2.php';
}
public static function product_link($product)
{
if ($_GET['filter_id'] > 0) {
$category_filter = $_GET['filter_id'];
} elseif ($_GET['cPath'] > 0) {
$category_filter = $_GET['cPath'];
} else {
$category_filter = $product->fields['master_categories_id'];
}
$parameters = 'cPath=' . zen_get_generated_category_path_rev($category_filter) . '&products_id=' . $product->fields['products_id'];
return zen_href_link(zen_get_info_page($product->fields['products_id']), $parameters);
}
<?php
/**
* Electronics Template designed by zen-cart-power.com
* zen-cart-power.com - Zen Cart templates and modules
* Power your Zen Cart!
*
*
* @copyright Copyright 2008-2009 Zen-Cart-Power.com
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/
$content = "";
$specials_box_counter = 0;
while (!$random_specials_sidebox_product->EOF) {
$specials_box_counter++;
$specials_box_price = zen_get_products_display_price($random_specials_sidebox_product->fields['products_id']);
$content .= '<div class="sideBoxContent centeredContent">';
$content .= '<a href="' . zen_href_link(zen_get_info_page($random_specials_sidebox_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_specials_sidebox_product->fields["master_categories_id"]) . '&products_id=' . $random_specials_sidebox_product->fields["products_id"]) . '">' . zen_image(DIR_WS_IMAGES . $random_specials_sidebox_product->fields['products_image'], $random_specials_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
$content .= '<a class="sidebox-products" href="' . zen_href_link(zen_get_info_page($random_specials_sidebox_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_specials_sidebox_product->fields["master_categories_id"]) . '&products_id=' . $random_specials_sidebox_product->fields["products_id"]) . '">';
$content .= $random_specials_sidebox_product->fields['products_name'] . '</a>';
$content .= '<div>' . $specials_box_price . '</div>';
$content .= '</div>';
$random_specials_sidebox_product->MoveNextRandom();
}
echo $list_box_contents[$row]['product_is_always_free_shipping'];
?>
</p>
<div class="black line_120 margin_t">
<strong>Our Price: </strong>
<?php
if (!empty($specials_price)) {
//caizhouqing by bof
$products_price = $products_price * ($specials_price / $products_price);
echo '<a href="' . zen_href_link(zen_get_info_page($list_box_contents[$row]['products_id']), 'cPath=' . zen_get_generated_category_path_rev($_GET['cPath']) . '&products_id=' . $list_box_contents[$row]['products_id'] . '&action=buy_now') . '" >';
echo '<span class="car_price">';
echo $list_box_contents[$row]['products_price'] == 0 ? $currencies->display_price($products_price, zen_get_tax_rate($products_tax_class_id)) : $currencies->display_price($products_price, zen_get_tax_rate($products_tax_class_id));
echo '</span>';
echo '</a>';
} elseif ($list_box_contents[$row]['products_quantity'] > 0) {
echo '<a href="' . zen_href_link(zen_get_info_page($list_box_contents[$row]['products_id']), 'cPath=' . zen_get_generated_category_path_rev($_GET['cPath']) . '&products_id=' . $list_box_contents[$row]['products_id'] . '&action=buy_now') . '" >';
echo '<span class="car_price">';
echo $list_box_contents[$row]['products_price'] == 0 ? $currencies->display_price($list_box_contents[$row]['products_price_sample'], zen_get_tax_rate($products_tax_class_id)) : $currencies->display_price($list_box_contents[$row]['products_price'], zen_get_tax_rate($products_tax_class_id));
echo '</span>';
echo '</a>';
} else {
echo '<span">';
echo $list_box_contents[$row]['products_price'] == 0 ? $currencies->display_price($list_box_contents[$row]['products_price_sample'], zen_get_tax_rate($products_tax_class_id)) : $currencies->display_price($list_box_contents[$row]['products_price'], zen_get_tax_rate($products_tax_class_id));
echo '</span>';
}
?>
<div class="margin_t">Compare at: <?php
echo $list_box_contents[$row]['products_price_retail'];
?>
</div>
<div><span class="fl"><?php
<!--</div>-->
<?php
$display_qty = $flag_show_product_info_in_cart_qty == 1 ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . '1' . '</p>' : '';
if ($products_qty_box_status == 0 or $products_quantity_order_max == 1) {
// hide the quantity box and default to 1
$the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', $products->fields['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
} else {
// show the quantity box
$the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . zen_get_buy_now_qty($products->fields['products_id']) . '" maxlength="6" size="4" /><br />' . zen_get_products_quantity_min_units_display($products->fields['products_id']) . '<br />' . zen_draw_hidden_field('products_id', $products->fields['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
}
$display_button = zen_get_buy_now_button($products->fields['products_id'], $the_button);
$products_description = zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($products->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION);
$products_description = ltrim(substr($products_description, 0, 250) . '');
$moreinfo = '<a class="more_info_text" href="' . zen_href_link(zen_get_info_page($products->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products->fields['master_categories_id']) . '&products_id=' . $products->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
?>
<!-- product data -->
<div class="product-listview list-view">
<div class="row product-list-row">
<div class="col col-lg-2 col-md-3 col-sm-3 col-xs-12">
<a href="<?php
echo zen_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id']);
?>
">
<?php
/**
* @package modules
* @author JunsGo@msn.com
* @copyright Copyright 2013 SL Development Team
* @copyright Portions Copyright 2003 osCommerce
*/
$tpl_products = array('title' => '', 'products' => array());
if ((int) $_GET['products_id'] > 0) {
$sql = 'SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price,
p.products_sort_order, p.product_is_call, p.product_is_free, p.product_is_always_free_shipping, p.products_qty_box_status
FROM ' . TABLE_PRODUCTS_DESCRIPTION . ' pd, .' . TABLE_PRODUCTS . ' p left join ' . TABLE_MANUFACTURERS . ' m on (p.manufacturers_id = m.manufacturers_id),
' . TABLE_PRODUCTS_TO_CATEGORIES . ' p2c left join ' . TABLE_SPECIALS . ' s on (p2c.products_id = s.products_id)
WHERE p.products_status = 1 and (p.products_id = p2c.products_id) and (pd.products_id = p2c.products_id)
and p.shop_id = ' . (int) $_SESSION['shop_id'] . '
and pd.language_id = \'' . (int) $_SESSION['languages_id'] . '\' and p.master_categories_id = \'' . (int) zen_get_products_category_id($_GET['products_id']) . '\'
ORDER BY RAND()';
$relateds = $db->Execute($sql, MAX_DISPLAY_PRODUCTS_RELATED, true, CACHE_TIMELIFT);
while (!$relateds->EOF) {
$tpl_products['products'][$relateds->fields['products_id']] = array('name' => $relateds->fields['products_name'], 'image' => $relateds->fields['products_image'], 'quantity' => $relateds->fields['products_quantity'], 'weight' => $relateds->fields['products_weight'], 'type' => $relateds->fields['products_type'], 'categories_id' => $relateds->fields['master_categories_id'], 'manufacturers_id' => $relateds->fields['manufacturers_id'], 'products_price' => $relateds->fields['products_price'], 'tax_class_id' => $relateds->fields['products_tax_class_id'], 'specials_price' => $relateds->fields['specials_new_products_price'], 'final_price' => $relateds->fields['final_price'], 'sort_order' => $relateds->fields['products_sort_order'], 'is_call' => $relateds->fields['product_is_call'], 'is_always_free_shipping' => $relateds->fields['product_is_always_free_shipping'], 'qty_box_status' => $relateds->fields['products_qty_box_status'], 'href' => zen_href_link(zen_get_info_page($relateds->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($relateds->fields['master_categories_id']))) . '&products_id=' . $relateds->fields['products_id']), 'display_price' => zen_get_products_display_price($relateds->fields['products_id']), 'is_free' => $relateds->fields['product_is_free'] == '1' ? true : false, 'display_normal_price' => get_normal_price($relateds->fields['products_id']), 'display_special_price' => get_special_price($relateds->fields['products_id']), 'display_sale_price' => get_sale_discount_price($relateds->fields['products_id']));
$relateds->MoveNext();
}
}
/**
* pre-calculate the category path
* see {@link http://www.zen-cart.com/wiki/index.php/Developers_API_Tutorials#InitSystem wikitutorials} for more details.
*
* @package initSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: init_category_path.php 4769 2006-10-17 02:59:21Z drbyte $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$show_welcome = false;
if (isset($_GET['cPath'])) {
$cPath = zen_get_generated_category_path_rev($_GET['cPath']);
//ModiFy By showq
//For breadcrumb is full
//print_r($cPath); is trace
} elseif (isset($_GET['products_id']) && !zen_check_url_get_terms()) {
$cPath = zen_get_product_path($_GET['products_id']);
} else {
if (SHOW_CATEGORIES_ALWAYS == '1' && !zen_check_url_get_terms()) {
$show_welcome = true;
$cPath = defined('CATEGORIES_START_MAIN') ? CATEGORIES_START_MAIN : '';
} else {
$show_welcome = false;
$cPath = '';
}
}
if (zen_not_null($cPath)) {
foreach ($cats as $key => $value) {
$mycats[] = $value["link"];
}
$cats = '<ul id="couponCatRestrictions">' . '<li>' . implode('<li>', $mycats) . '</ul>';
$text_coupon_help .= $cats;
$text_coupon_help .= TEXT_COUPON_HELP_PRODUCTS;
$get_result = $db->Execute("select * from " . TABLE_COUPON_RESTRICT . " where coupon_id='" . (int) $lookup_coupon_id . "' and product_id !='0'");
$prods = array();
while (!$get_result->EOF) {
if ($get_result->fields['coupon_restrict'] == 'N') {
$restrict = TEXT_PROD_ALLOWED;
} else {
$restrict = TEXT_PROD_DENIED;
}
$result = $db->Execute("SELECT * FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = pd.products_id and\n pd.language_id = '" . (int) $_SESSION['languages_id'] . "' and p.products_id = '" . $get_result->fields['product_id'] . "'");
$prods[] = array("validity" => $get_result->fields['coupon_restrict'] == 'N' ? 'A' : 'D', 'name' => $result->fields["products_name"], 'link' => '<a href="' . zen_href_link(zen_get_info_page($result->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($result->fields['master_categories_id']) . '&products_id=' . $result->fields['products_id']) . '">' . $result->fields['products_name'] . '</a>' . $restrict);
$get_result->MoveNext();
}
if (sizeof($prods) == 0) {
$prods[] = array("link" => TEXT_NO_PROD_RESTRICTIONS);
}
sort($prods);
$myprods = array();
foreach ($prods as $key => $value) {
$myprods[] = $value["link"];
}
$prods = '<ul id="couponProdRestrictions">' . '<li>' . implode('<li>', $myprods) . '</ul>';
$text_coupon_help .= $prods . TEXT_COUPON_GV_RESTRICTION;
}
}
// include template specific file name defines
<?php
/**
* Side Box Template
*
* @package templateSystem
* @copyright Copyright 2003-2011 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_featured.php 18698 2011-05-04 14:50:06Z wilt $
*/
$content = "";
$content .= '<div class="sideBoxContent centeredContent">';
$featured_box_counter = 0;
while (!$random_featured_product->EOF) {
$featured_name = $random_featured_product->fields['products_name'];
$featured_name = ltrim(substr($featured_name, 0, 20));
$featured_box_counter++;
$featured_box_price = zen_get_products_display_price($random_featured_product->fields['products_id']);
$content .= "\n" . ' <div class="sideBoxContentItem">';
$content .= '<div class="sidebox_content"><div class="product_sideboximage">' . zen_image(DIR_WS_IMAGES . $random_featured_product->fields['products_image'], $featured_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</div>';
$content .= '<div class="product_sideboxname"><a href="' . zen_href_link(zen_get_info_page($random_featured_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_featured_product->fields["master_categories_id"]) . '&products_id=' . $random_featured_product->fields["products_id"]) . '">' . $featured_name . '</a>';
$content .= '<div class="sidebox_price">' . $featured_box_price . '</div></div></div>';
$content .= '</div>';
$random_featured_product->MoveNextRandom();
}
$content .= '</div>' . "\n";
$lc_align = 'right';
$lc_text = $listing->fields['products_quantity'];
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_align = 'right';
$lc_text = $listing->fields['products_weight'];
break;
case 'PRODUCT_LIST_IMAGE':
$lc_align = 'center';
if ($listing->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
$lc_text = '';
} else {
if (isset($_GET['manufacturers_id'])) {
$lc_text = '<a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id']) > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $listing->fields['products_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
} else {
$lc_text = '<a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id']) > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $listing->fields['products_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
}
}
break;
}
$list_box_contents[$rows][$col] = array('align' => $lc_align, 'params' => 'class="productListing-data"', 'text' => $lc_text);
}
// add description and match alternating colors
//if (PRODUCT_LIST_DESCRIPTION > 0) {
// $rows++;
// if ($extra_row == 1) {
// $list_box_description = "productListing-data-description-even";
// $extra_row=0;
// } else {
// $list_box_description = "productListing-data-description-odd";
// $extra_row=1;
<?php
// -----
// Scrolling "what's new" sidebox, based on the whats_new.php sidebox that's built into Zen Cart!
//
// Copyright (c) 2014, Vinos de Frutas Tropicales (lat9)
// Copyright 2003-2011 Zen Cart Development Team
// Copyright 2003 osCommerce
// License: http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
//
$content = '<div class="sideBoxContent centeredContent">';
while (!$whats_new_scrolling->EOF) {
$whats_new_price = zen_get_products_display_price($whats_new_scrolling->fields['products_id']);
$content .= "\n" . ' <div class="sideBoxContentItem hiddenField whatsNewScroller">';
$content .= '<a href="' . zen_href_link(zen_get_info_page($whats_new_scrolling->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($whats_new_scrolling->fields['master_categories_id']) . '&products_id=' . $whats_new_scrolling->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $whats_new_scrolling->fields['products_image'], $whats_new_scrolling->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
$content .= '<br />' . $whats_new_scrolling->fields['products_name'] . '</a>';
$content .= '<div>' . $whats_new_price . '</div>';
$content .= '</div>';
$whats_new_scrolling->MoveNextRandom();
}
$content .= '</div><script type="text/javascript">$("div.whatsNewScroller").cycle(10000);</script>' . "\n";
/**
* Method to handle cart Action - multiple add products
*
* @param string forward destination
* @param url parameters
* @todo change while loop to a foreach
*/
function actionMultipleAddProduct($goto, $parameters)
{
global $messageStack;
if ($this->display_debug_messages) {
$messageStack->add_session('header', 'FUNCTION ' . __FUNCTION__, 'caution');
}
$addCount = 0;
if (is_array($_POST['products_id']) && sizeof($_POST['products_id']) > 0) {
//echo '<pre>'; echo var_dump($_POST['products_id']); echo '</pre>';
while (list($key, $val) = each($_POST['products_id'])) {
$prodId = preg_replace('/[^0-9a-f:.]/', '', $key);
if (is_numeric($val) && $val > 0) {
$adjust_max = false;
$qty = $val;
$add_max = zen_get_products_quantity_order_max($prodId);
$cart_qty = $this->in_cart_mixed($prodId);
$new_qty = $this->adjust_quantity($qty, $prodId, 'shopping_cart');
// bof: adjust new quantity to be same as current in stock
$chk_current_qty = zen_get_products_stock($prodId);
if (STOCK_ALLOW_CHECKOUT == 'false' && $new_qty > $chk_current_qty) {
$new_qty = $chk_current_qty;
$messageStack->add_session('shopping_cart', ($this->display_debug_messages ? 'FUNCTION ' . __FUNCTION__ . ': ' : '') . WARNING_PRODUCT_QUANTITY_ADJUSTED . zen_get_products_name($prodId), 'caution');
}
// eof: adjust new quantity to be same as current in stock
if ($add_max == 1 and $cart_qty == 1) {
// do not add
$adjust_max = 'true';
} else {
// bof: adjust new quantity to be same as current in stock
if (STOCK_ALLOW_CHECKOUT == 'false' && $new_qty + $cart_qty > $chk_current_qty) {
$adjust_new_qty = 'true';
$alter_qty = $chk_current_qty - $cart_qty;
$new_qty = $alter_qty > 0 ? $alter_qty : 0;
$messageStack->add_session('shopping_cart', ($this->display_debug_messages ? 'FUNCTION ' . __FUNCTION__ . ': ' : '') . WARNING_PRODUCT_QUANTITY_ADJUSTED . zen_get_products_name($prodId), 'caution');
}
// eof: adjust new quantity to be same as current in stock
// adjust quantity if needed
if ($new_qty + $cart_qty > $add_max and $add_max != 0) {
$adjust_max = 'true';
$new_qty = $add_max - $cart_qty;
}
$this->add_cart($prodId, $this->get_quantity($prodId) + $new_qty);
$addCount++;
}
if ($adjust_max == 'true') {
if ($this->display_debug_messages) {
$messageStack->add_session('header', 'FUNCTION ' . __FUNCTION__ . '<br>' . ERROR_MAXIMUM_QTY . zen_get_products_name($prodId), 'caution');
}
$messageStack->add_session('shopping_cart', ERROR_MAXIMUM_QTY . zen_get_products_name($prodId), 'caution');
}
}
if (!is_numeric($val) || $val < 0) {
// adjust quantity when not a value
$chk_link = '<a href="' . zen_href_link(zen_get_info_page($prodId), 'cPath=' . zen_get_generated_category_path_rev(zen_get_products_category_id($prodId)) . '&products_id=' . $prodId) . '">' . zen_get_products_name($prodId) . '</a>';
$messageStack->add_session('header', ERROR_CORRECTIONS_HEADING . ERROR_PRODUCT_QUANTITY_UNITS_SHOPPING_CART . $chk_link . ' ' . PRODUCTS_ORDER_QTY_TEXT . zen_output_string_protected($val), 'caution');
$val = 0;
}
}
// display message if all is good and not on shopping_cart page
if ($addCount && DISPLAY_CART == 'false' && $_GET['main_page'] != FILENAME_SHOPPING_CART && $messageStack->size('shopping_cart') == 0) {
$messageStack->add_session('header', ($this->display_debug_messages ? 'FUNCTION ' . __FUNCTION__ . ': ' : '') . SUCCESS_ADDED_TO_CART_PRODUCTS, 'success');
} else {
if (DISPLAY_CART == 'false') {
zen_redirect(zen_href_link(FILENAME_SHOPPING_CART));
}
}
zen_redirect(zen_href_link($goto, zen_get_all_get_params($parameters)));
}
}
$link = '<a href="' . zen_href_link(FILENAME_PRODUCTS_ALL, zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_all->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a> ';
}
}
$the_button = $link;
$products_link = '<span class="more-info"><a href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a></span>';
$display_products_button = zen_get_buy_now_button($products_all->fields['products_id'], $the_button, $products_link) . '<br />' . zen_get_products_quantity_min_units_display($products_all->fields['products_id']) . str_repeat('<br clear="all" />', substr(PRODUCT_ALL_BUY_NOW, 3, 1));
} else {
$link = '<span class="more-info"><a href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a></span>';
$the_button = $link;
$products_link = '<span class="more-info"><a href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a></span>';
$display_products_button = zen_get_buy_now_button($products_all->fields['products_id'], $the_button, $products_link) . '<br />' . zen_get_products_quantity_min_units_display($products_all->fields['products_id']) . str_repeat('<br clear="all" />', substr(PRODUCT_ALL_BUY_NOW, 3, 1));
}
if (PRODUCT_ALL_LIST_DESCRIPTION > '0') {
$disp_text = zen_get_products_description($products_all->fields['products_id']);
$disp_text = zen_clean_html($disp_text);
$display_products_description = stripslashes(zen_trunc_string($disp_text, PRODUCT_ALL_LIST_DESCRIPTION, '...<br /><span class="more-info float-right"><a href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a></span>'));
} else {
$display_products_description = '';
}
?>
<tr class="<?php
echo (int) ($row_counter / 2) == $row_counter / 2 ? 'productListing-even' : 'productListing-odd';
?>
">
<td>
<table class="table-product-attributes" border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php
echo IMAGE_PRODUCT_ALL_LISTING_WIDTH + 10;
?>
" valign="top" class="listing-img main" align="center">
$link = '<a href="' . zen_href_link(FILENAME_PRODUCTS_NEW, zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a> ';
}
}
$the_button = $link;
$products_link = '<a href="' . zen_href_link(zen_get_info_page($products_new->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_new->fields['master_categories_id']) . '&products_id=' . $products_new->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
$display_products_button = zen_get_buy_now_button($products_new->fields['products_id'], $the_button, $products_link) . '<br />' . zen_get_products_quantity_min_units_display($products_new->fields['products_id']) . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_BUY_NOW, 3, 1));
} else {
$link = '<a href="' . zen_href_link(zen_get_info_page($products_new->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_new->fields['master_categories_id']) . '&products_id=' . $products_new->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
$the_button = $link;
$products_link = '<a href="' . zen_href_link(zen_get_info_page($products_new->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_new->fields['master_categories_id']) . '&products_id=' . $products_new->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
$display_products_button = zen_get_buy_now_button($products_new->fields['products_id'], $the_button, $products_link) . '<br />' . zen_get_products_quantity_min_units_display($products_new->fields['products_id']) . str_repeat('<br clear="all" />', substr(PRODUCT_NEW_BUY_NOW, 3, 1));
}
if (PRODUCT_NEW_LIST_DESCRIPTION > '0') {
$disp_text = zen_get_products_description($products_new->fields['products_id']);
$disp_text = zen_clean_html($disp_text);
$display_products_description = stripslashes(zen_trunc_string($disp_text, PRODUCT_NEW_LIST_DESCRIPTION, '<a href="' . zen_href_link(zen_get_info_page($products_new->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_new->fields['master_categories_id']) . '&products_id=' . $products_new->fields['products_id']) . '"> ' . MORE_INFO_TEXT . '</a>'));
} else {
$display_products_description = '';
}
?>
<ul class="list_product clear">
<li class="relative"><?php
echo $display_products_image;
?>
</li>
<li class="li_con">
<dl>
<dt><?php
echo $display_products_name;
?>
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_align = 'right';
if ($listing->fields['products_weight'] != '') {
$trg_extra_val .= '<div class="product-weight">' . TABLE_HEADING_WEIGHT . ' : ' . $listing->fields['products_weight'] . '</div>';
}
//$lst_lc_text = '<div class="product-weight">'.$listing->fields['products_weight'].'</div>';
break;
case 'PRODUCT_LIST_IMAGE':
$lc_align = 'center';
if ($listing->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
$lc_text = '';
$lst_lc_text = '';
} else {
if (isset($_GET['manufacturers_id'])) {
$product_img_link = zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id']) > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']);
$product_img_src = mb_getbaseimg_effects($listing->fields['products_image']);
$second_img_src = mb_gethoverimg_effects($listing->fields['products_image']);
$product_img = zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $products_name, IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT);
} else {
$product_img_src = mb_getbaseimg_effects($listing->fields['products_image']);
$second_img_src = mb_gethoverimg_effects($listing->fields['products_image']);
$product_img = zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $products_name, IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT);
}
}
break;
}
$product_contents[] = $lc_text;
// Used For Column Layout (Grid Layout) Option
$listview_product_contents[] = $lst_lc_text;
}
