Schnellschuß:
Suche
$sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';
ersetze mit:
//BOC respect specials (see below in $listing_sql), noRiddle
//$sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';
$eff_sort = ($sorting_data['products_sorting'] == 'p.products_price' ? 'smaller_price' : $sorting_data['products_sorting']);
$sorting = ' ORDER BY '.$eff_sort.' '.$sorting_data['products_sorting2'].' ';
//EOC respect specials (see below in $listing_sql), noRiddle
Suche:
$listing_sql = "-- /includes/modules/default.php
SELECT ".$select."
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_discount_allowed,
p.products_weight,
p.products_tax_class_id,
p.manufacturers_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_description,
pd.products_short_description
FROM ".TABLE_PRODUCTS_DESCRIPTION." pd
JOIN ".TABLE_PRODUCTS." p
".$from."
WHERE p.products_status = '1'
AND p.products_id = pd.products_id
AND pd.language_id = '".(int) $_SESSION['languages_id']."'
".$group_check."
".$fsk_lock."
".$where."
".$sorting;
ersetze mit:
$listing_sql = "-- /includes/modules/default.php
SELECT ".$select."
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
#p.products_price,
if(ps.specials_new_products_price < p.products_price, ps.specials_new_products_price, p.products_price) as smaller_price, #respect specials, noRiddle
p.products_discount_allowed,
p.products_weight,
p.products_tax_class_id,
p.manufacturers_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_description,
pd.products_short_description
FROM ".TABLE_PRODUCTS_DESCRIPTION." pd
JOIN ".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_SPECIALS." ps ON ps.products_id = p.products_id
".$from."
WHERE p.products_status = '1'
AND p.products_id = pd.products_id
AND pd.language_id = '".(int) $_SESSION['languages_id']."'
".$group_check."
".$fsk_lock."
".$where."
".$sorting;
Das Dropdown im Backend braucht nicht geändert zu werden.
Wenn man nach "Preis" sortiert werden Sonderangebote automatisch bei der Sortierung berücksichtigt.
Gruß,
noRiddle