|
|
|
local variable $customer_group_id
if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') {
$customer_group_id = $_SESSION['sppc_customer_group_id'];
} else {
$customer_group_id = '0';
}
$specials_query_raw = "select p.products_id, p.products_restriction, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id = '" . (int)$customer_group_id . "' order by s.specials_date_added DESC";
// EOF Separate Pricing Per Customer
$specials_split = new splitPageResults($specials_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS);
if (($specials_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
| display_count(TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?> |
display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> |
|
|
sql_query);
$no_of_specials = tep_db_num_rows($specials_query);
// get all product prices from the table products_groups in one query
// traverse specials_query for products_id's, store the query result in a numbered array
while ($_specials = tep_db_fetch_array($specials_query)) {
$specials[] = $_specials;
$list_of_prdct_ids[] = $_specials['products_id'];
} // end while ($_specials = tep_db_fetch_array($specials_query))
// a line needed for the selection of the products_id's
$pg_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' ";
if ($no_of_specials > 1) {
for ($n = 1 ; $n < count($list_of_prdct_ids) ; $n++) {
$pg_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' ";
}
}
// now get all the customers_group_price's
$pg_query = tep_db_query("select products_id, customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where (".$pg_list_of_prdct_ids.") and customers_group_id = '" . $customer_group_id . "'");
// put all the info in an array called new_prices
while ($pg_array = tep_db_fetch_array($pg_query)) {
$new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['customers_group_price']);
}
// we already got the results from the query and put them into an array, can't use while now
//BOF Product restriction
$restricted = 0;
$data = mktime(0,0,0,date("m"),date("d"),date("Y")-18)."
";
//EOF Product restriction
// while ($specials = tep_db_fetch_array($specials_query)) {
for ($x = 0; $x < $no_of_specials; $x++) {
$row++;
// replace products prices with those from customers_group table
if (!empty($new_prices)) {
for ($i = 0; $i < count($new_prices); $i++) {
if ($specials[$x]['products_id'] == $new_prices[$i]['products_id'] ) {
$specials[$x]['products_price'] = $new_prices[$i]['products_price'];
}
}
} // end if (!empty($new_prices)
//BOF Product restriction
$show = 1;
if($specials[$x]['products_restriction']){
if(tep_session_is_registered('customer_id')){
if($data < $_SESSION['customer_dob']){
$show = 0;
$error_restriction = 'non hai raggiunto la maggior età';
}
} else {
$show = 0;
$error_restriction = 'non sei loggato o non hai raggiunto la maggior età';
}
}
if($show == 1){
//EOF Product restriction
echo '
' . tep_image(DIR_WS_IMAGES . $specials[$x]['products_image'], $specials[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '
' . $specials[$x]['products_name'] . '
' . $currencies->display_price($specials[$x]['products_price'], tep_get_tax_rate($specials[$x]['products_tax_class_id'])) . '
' . $currencies->display_price($specials[$x]['specials_new_products_price'], tep_get_tax_rate($specials[$x]['products_tax_class_id'])) . '
| ' . "\n";
// EOF Separate Pricing per Customer, specials code
if ((($row / 3) == floor($row / 3))) {
?>
|
0){
?>
| ATTENZIONE: Alcuni prodotti, destinati ad un pubblico adulto, non possono essere visualizzati in quanto |
|
number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
| display_count(TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?> |
display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> |
|
|
|
| |