Filteroption Suche

[jobra@…]

v2.0.7.2 rev 14622

wenn ich z.b. nach Testartikel 4 suche und dann nach hersteller1 sortieren lasse, werden dennoch produkte aller hersteller angezeigt.

[anonymous]

bitte den inhalt der datei 99_advanced_search_result.php tauschewn in:

<?php
/* -----------------------------------------------------------------------------------------

$Id: 99_advanced_search_result.php 14029 2022-02-08 16:19:21Z GTB $

modified eCommerce Shopsoftware
​http://www.modified-shop.org

Copyright (c) 2009 - 2013 [www.modified-shop.org]
-----------------------------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

if (basename($PHP_SELF) == FILENAME_ADVANCED_SEARCH_RESULT) {

set $_GET variables for function xtc_get_all_get_params()
$keywords = $_GETkeywords = !empty($_GETkeywords) ? stripslashes(trim(urldecode($_GETkeywords))) : false;
$pfrom = $_GETpfrom = !empty($_GETpfrom) ? str_replace(',', '.', stripslashes(trim(urldecode($_GETpfrom)))) : false;
$pto = $_GETpto = !empty($_GETpto) ? str_replace(',', '.', stripslashes(trim(urldecode($_GETpto)))) : false;
$manufacturers_id = $_GETmanufacturers_id = !empty($_GETmanufacturers_id) ? (int)$_GETmanufacturers_id : false;
$categories_id = $_GETcategories_id = !empty($_GETcategories_id) ? (int)$_GETcategories_id : false;
$_GETinc_subcat = !empty($_GETinc_subcat) ? (int)$_GETinc_subcat : null;

manufacturers
$manu_check = $manufacturers_id !== false ? " AND p.manufacturers_id = '".$manufacturers_id."' " : "";

filter
$filter_where = ;
$tags_array = get_filter_tags();
if (count($tags_array) > 0) {

$filter_where .= "AND p.products_id IN (".implode(', ', $tags_array).")";

}

include subcategories if needed
$p2c_condition = ;
if ($categories_id !== false) {

if (isset($_GETinc_subcat) && $_GETinc_subcat == '1') {

$subcategories_array = array ();
xtc_get_subcategories($subcategories_array, $categories_id);
$subcategories_array[] = $categories_id;
$p2c_condition = " AND p2c.categories_id IN ('".implode("', '", $subcategories_array)."') ";

} else {

$p2c_condition = " AND p2c.categories_id = '".$categories_id."' ";

}

}

price by currency
$NeedTax = false;

if ($pfrom

$pto) {

$rate = xtc_get_currencies_values($_SESSIONcurrency);
$rate = $ratevalue;
if ($rate && $pfrom) {

$pfrom = $pfrom / $rate;

}
if ($rate && $pto) {

$pto = $pto / $rate;

}
if ($_SESSIONcustomers_statuscustomers_status_show_price_tax) {

$NeedTax = true;

}

}

price filters
$pfrom_check = ;
if (($pfrom != ) && (is_numeric($pfrom))) {

if ($NeedTax) {

$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round((".$pfrom."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";

} else {

$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round(".$pfrom.",".PRICE_PRECISION.") ) ";

}

}

$pto_check = ;
if (($pto != ) && (is_numeric($pto))) {

if ($NeedTax) {

$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round((".$pto."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";

} else {

$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round(".$pto.",".PRICE_PRECISION.") ) ";

}

}

build query
$select_str = "SELECT ".ADD_SELECT_SEARCH."

p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_heading_title,
pd.products_short_description,
pd.products_description,
IFNULL(s.specials_new_products_price, p.products_price) AS price ";

if (PRODUCT_LIST_FILTER == 'true') {

$select_str = "SELECT p.products_id ";

}

$from_str = "FROM ".TABLE_PRODUCTS." AS p

JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd

ON p.products_id = pd.products_id

AND trim(pd.products_name) !=
AND pd.language_id = '".(int)$_SESSIONlanguages_id."'

JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c

ON p2c.products_id = pd.products_id

".$p2c_condition."

JOIN ".TABLE_CATEGORIES." c

ON c.categories_id = p2c.categories_id

AND c.categories_status = 1

".CATEGORIES_CONDITIONS_C." ";

$from_str .= SEARCH_IN_ATTR == 'true' ? " LEFT JOIN ".TABLE_PRODUCTS_ATTRIBUTES." AS pa ON p.products_id = pa.products_id

LEFT JOIN ".TABLE_PRODUCTS_OPTIONS_VALUES." AS pov ON pa.options_values_id = pov.products_options_values_id AND pov.language_id = '".(int) $_SESSIONlanguages_id."' " : "";

$from_str .= "LEFT JOIN ".TABLE_SPECIALS." AS s ON p.products_id = s.products_id ".SPECIALS_CONDITIONS_S." ";
$from_str .= SEARCH_IN_MANU == 'true' ? " LEFT JOIN ".TABLE_MANUFACTURERS." AS m ON p.manufacturers_id = m.manufacturers_id " : "";

if (SEARCH_IN_FILTER == 'true') {

$from_str .= "LEFT JOIN ".TABLE_PRODUCTS_TAGS." pt ON pt.products_id = p.products_id

LEFT JOIN ".TABLE_PRODUCTS_TAGS_VALUES." ptv ON ptv.options_id = pt.options_id AND ptv.values_id = pt.values_id AND ptv.status = '1' AND ptv.languages_id = '".(int)$_SESSIONlanguages_id."' ";

}

$tax_where = ;
if ($NeedTax) {

if (!isset ($_SESSIONcustomer_country_id)) {

$_SESSIONcustomer_country_id = STORE_COUNTRY;
$_SESSIONcustomer_zone_id = STORE_ZONE;

}
$from_str .= " LEFT JOIN ".TABLE_TAX_RATES." tr ON p.products_tax_class_id = tr.tax_class_id

LEFT JOIN ".TABLE_ZONES_TO_GEO_ZONES." gz ON tr.tax_zone_id = gz.geo_zone_id ";

$tax_where = " AND (gz.zone_country_id IS NULL OR gz.zone_country_id = '0' OR gz.zone_country_id = '".(int) $_SESSIONcustomer_country_id."')

AND (gz.zone_id is null OR gz.zone_id = '0' OR gz.zone_id = '".(int) $_SESSIONcustomer_zone_id."')";

}

where-string
$where_str = " WHERE p.products_status = '1' "
.PRODUCTS_CONDITIONS_P
.$filter_where
.$manu_check
.$tax_where
.$pfrom_check
.$pto_check;

create $search_keywords array
$keywordcheck = xtc_parse_search_string($keywords, $search_keywords);

go for keywords... this is the main search process
if ($keywords && $keywordcheck) {

include(DIR_WS_INCLUDES.'build_search_query.php');

if (PRODUCT_LIST_FILTER != 'true') {

$where_str .= " GROUP BY p.products_id ";
$where_str .= ((isset($_SESSIONfilter_sorting)) ? $_SESSIONfilter_sorting : 'ORDER BY p.products_id ASC');

}

}

glue together
$listing_sql = $select_str.$from_str.$where_str;

if (PRODUCT_LIST_FILTER == 'true') {

$products_search_array = array();
$result_query = xtDBquery($listing_sql);
while ($result = xtc_db_fetch_array($result_query, true)) {

$products_search_array[$resultproducts_id] = $resultproducts_id;

}
$listing_sql = "SELECT ".ADD_SELECT_SEARCH."

p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_heading_title,
pd.products_short_description,
pd.products_description,
IFNULL(s.specials_new_products_price, p.products_price) AS price

FROM ".TABLE_PRODUCTS." p
JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd

ON p.products_id = pd.products_id

AND pd.language_id = '".(int)$_SESSIONlanguages_id."'

".$from."

WHERE p.products_id IN ('".implode("', '", $products_search_array)."')

".((isset($_SESSIONfilter_sorting)) ? $_SESSIONfilter_sorting : 'ORDER BY p.products_id ASC');

}

$_GETkeywords = urlencode($keywords);

}

?>

[Torsten Riemer]

Wie oft willst du das noch melden!?
Duplikat von Ticket #2310 und deinem früheren Ticket #2356.