Module Search

19.10.2011 13:02
#1
usaipaola
Joomshopping forum user no avatar
Name: paola
06.10.2011
Posts: 12
Quote
Module Search

I have a problem with the Search Module, if I search two words the result includes all products that contain at least one word, you can limit the results to products that contain all words. thanks


Joomla: 1.7
JoomShopping: 3.2.7
Website Url: www.compatibile.eu
 
10.12.2011 22:44
#2
Fredy80
Joomshopping forum user no avatar
Name: Alfredo
10.12.2011
Posts: 7
Quote
Aw: Module Search

I have the same issue. It seem that you solved it already. Did you solve this issue? if you did, how? Thank you


Joomla: 1.7.0
Website Url: www.evomas.com
 
10.02.2012 16:55
#3
kockas
Joomshopping forum user no avatar
Name: kockas
10.07.2008
Posts: 1
Quote
Aw: Module Search

Hello! Serach problem SOLVED!

components/com_jshopping/controllers/search.php (229-233 Line) :

foreach($words as $word){
$word = addcslashes($db->getEscaped($word), "_%");
$search_word[] = "LOWER(prod.`".$lang->get('name')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('short_description')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('description')."`) LIKE '%" . $word . "%' OR prod.product_ean LIKE '%" . $word . "%'";
}
$where_search = implode(" OR ", $search_word);



REPLACE with this:


foreach($words as $word){
$word = addcslashes($db->getEscaped($word), "_%");
$search_word[] = "(LOWER(prod.`".$lang->get('name')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('short_description')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('description')."`) LIKE '%" . $word . "%' OR prod.product_ean LIKE '%" . $word . "%')";
}
$where_search = implode(" AND ", $search_word);

 
30.03.2012 19:03
#4
Fredy80
Joomshopping forum user no avatar
Name: Alfredo
10.12.2011
Posts: 7
Quote
Aw: Module Search

Problem Solved!!! Thank you for your support guys !!!

 
06.04.2012 16:55
#5
ciccio3
Joomshopping forum user no avatar
Name: ciccio
07.09.2011
Posts: 47
Quote
Aw: Module Search

Kokcas: thank you so very much!!
I was getting mad at this for days and I couldn't figure out how easy it was to fix it!

I have joomshopping 3.5.1 and to fix it you just have to change "or" at line 405 with "and"


Last change: 06.04.2012 16:56
 
10.04.2012 11:50
#6
ming67152001
Joomshopping forum user no avatar
Name: jack
06.04.2012
Posts: 1
Quote
Aw: Module Search

Hi,I want to disable Manufacturers in products search function. Anyone can help me?or tell me how to setting? tks.
Aw: Module Search


Joomla: joomla 1.7.2
JoomShopping: Version 3.2.7
 
21.04.2012 06:19
#7
rolyat100
Joomshopping forum user no avatar
Name: Taylor Ruble
16.03.2009
Posts: 44
Quote
Aw: Module Search

I have made the changes below but I am still having the problem that when I put in a word like "tent" it will pull up tents and everything else. How can I get the search function to only pull relevant products to the search?


Joomla: 2.5.4
JoomShopping: latest
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.