v1.6-v1.7 Advanced Search 4 - Filters & Search 4.12.14

pgerm

Member
XNullUser
Joined
Oct 13, 2021
Messages
178
Reaction score
1
Points
18
NullCash
3
Perfect, thank you for sharing this module! :cool:
 

maty12

Active member
XNullUser
Joined
May 7, 2021
Messages
459
Reaction score
67
Points
28
NullCash
148
An essential tool for shops offering a vast selection of products, Advanced Search 4 allows you to add as many search engines as you want and to position them where you choose.

The module’s search mechanism is filter-based. Filters form the basis for successful layered navigation. They allow your customers to find products that match their search criteria with a minimum number of clicks.
Advanced Search 4 has been developed in order to provide short loading times, even for catalogues containing tens of thousands of products or categories.

Initial version published in 2010 - Winner of the Best Modules Awards en 2012 - Listed among the best-selling add-ons since 2010.

3 types of search are available to you:

  • Search your entire catalogue: the search scope covers the entire catalogue.
  • Search within a selection of products: the search scope covers the page the customer is currently visiting.
  • Search by steps: criteria are refined and displayed as your customers specify their search.

In addition to its main features, the Advanced Search 4 module is also recognised as one of your best allies when it comes to referencing. It includes an optimised page generator for SEO, which allows you to increase your visibility without any duplicated content!

What's New in Version 4.12.14(12/10/2021)
  • Fix sort of search engine when there are many
  • Fix an issue while showing products from sub-categories and when Products by attributes module is enabled (PrestaShop 1.7)
Goood addon!!!! i try to test for my project, thankyou very much
 

adesio

Member
XNullUser
Joined
Sep 9, 2021
Messages
141
Reaction score
1
Points
18
NullCash
3
thank you!thank you!thank you!thank you!thank you!thank you!thank you!
 

fishermanpl

Active member
XNullUser
Joined
Mar 9, 2020
Messages
148
Reaction score
35
Points
28
NullCash
8
Goood addon!!!! i try to test for my project, thankyou very much
 

santicb

New member
XNullUser
Joined
May 6, 2021
Messages
14
Reaction score
0
Points
1
NullCash
4
An essential tool for shops offering a vast selection of products, Advanced Search 4 allows you to add as many search engines as you want and to position them where you choose.

The module’s search mechanism is filter-based. Filters form the basis for successful layered navigation. They allow your customers to find products that match their search criteria with a minimum number of clicks.
Advanced Search 4 has been developed in order to provide short loading times, even for catalogues containing tens of thousands of products or categories.

Initial version published in 2010 - Winner of the Best Modules Awards en 2012 - Listed among the best-selling add-ons since 2010.

3 types of search are available to you:

  • Search your entire catalogue: the search scope covers the entire catalogue.
  • Search within a selection of products: the search scope covers the page the customer is currently visiting.
  • Search by steps: criteria are refined and displayed as your customers specify their search.

In addition to its main features, the Advanced Search 4 module is also recognised as one of your best allies when it comes to referencing. It includes an optimised page generator for SEO, which allows you to increase your visibility without any duplicated content!

What's New in Version 4.12.14(12/10/2021)
  • Fix sort of search engine when there are many
  • Fix an issue while showing products from sub-categories and when Products by attributes module is enabled (PrestaShop 1.7)
thanks for the share! i have been searching a lot
 

khanapurechait

Member
XNullUser
Joined
Mar 17, 2022
Messages
50
Reaction score
0
Points
6
NullCash
11
Thanks a lot. Exactly what I was looking for.Thanks a lot. Exactly what I was looking for.
 

lorenbac

Well-known member
Master
Diamond
Elite
XNullUser
Joined
Sep 27, 2019
Messages
408
Reaction score
634
Points
93
NullCash
2,715
thank you very much for share this module
 

eduard82

New member
XNullUser
Joined
May 18, 2022
Messages
1
Reaction score
0
Points
1
NullCash
2

Thanks a lot for the update. A very good module hides the parameters of already found products.​

Post automatically merged:

Я использую версию 4.12.9. При большом количестве товаров модуль тормозит. Делал оптимизацию MySQL, немного улучшил модуль. Подскажите кто использовал 4.12.14 если оптимизация по скорости?
Post automatically merged:

Оптимизация classes/As4SearchEngine.php


if (AdvancedSearchCoreClass::_isFilledArray($where_translatable_value_range)) {
$subQueryForRange = '
AND acpc'.(int)$id_criterion_group.'.`id_criterion` IN (
SELECT ac'.(int)$id_criterion_group.'.`id_criterion`
FROM `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'` ac'.(int)$id_criterion_group.'
JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'_link` aclink'.(int)$id_criterion_group.' ON (ac'.(int)$id_criterion_group.'.`id_criterion` = aclink'.(int)$id_criterion_group.'.`id_criterion`)
JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'_lang` acl'.(int)$id_criterion_group.' ON (ac'.(int)$id_criterion_group.'.`id_criterion` = acl'.(int)$id_criterion_group.'.`id_criterion` AND acl'.(int)$id_criterion_group.'.`id_lang` = '.(int)$id_lang.' AND ('.implode(' OR ', $where_translatable_value_range).'))
WHERE ac'.(int)$id_criterion_group.'.`id_criterion_group` = '.(int)$id_criterion_group.'
)
';
}

заменить на:

if (AdvancedSearchCoreClass::_isFilledArray($where_translatable_value_range)) {
$subQueryForRange = '
JOIN (
SELECT DISTINCT ac'.(int)$id_criterion_group.'.`id_criterion`
FROM `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'` ac'.(int)$id_criterion_group.'
JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'_link` aclink'.(int)$id_criterion_group.' ON (ac'.(int)$id_criterion_group.'.`id_criterion` = aclink'.(int)$id_criterion_group.'.`id_criterion`)
JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int)$search['id_search'].'_lang` acl'.(int)$id_criterion_group.' ON (ac'.(int)$id_criterion_group.'.`id_criterion` = acl'.(int)$id_criterion_group.'.`id_criterion` AND acl'.(int)$id_criterion_group.'.`id_lang` = '.(int)$id_lang.' AND ('.implode(' OR ', $where_translatable_value_range).'))
WHERE ac'.(int)$id_criterion_group.'.`id_criterion_group` = '.(int)$id_criterion_group.'
) ucpc'.(int)$id_criterion_group.' ON acpc'.(int)$id_criterion_group.'.`id_criterion` = ucpc'.(int)$id_criterion_group.'.`id_criterion`
';
}

также JOIN заменить на STRAIGHT_JOIN при выборе критерия:

STRAIGHT_JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int) $search['id_search'].'_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`'.(AdvancedSearchCoreClass::_isFilledArray($criterionsLinkToIgnore) ? ' AND aclink.`id_criterion_linked` NOT IN ('.implode(', ', array_map('intval', $criterionsLinkToIgnore)) .')' : '') . ')

STRAIGHT_JOIN `'._DB_PREFIX_.'pm_advancedsearch_criterion_'.(int) $search['id_search'].'_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion`)
 

Attachments

  • v4.12.9-pm_advancedsearch4.zip
    797.7 KB · Views: 0
Last edited:

Sillumin

Well-known member
Pro
Master
Diamond
Elite
Joined
Jun 18, 2021
Messages
3,620
Reaction score
743
Points
113
NullCash
5,953
Thank you very much! It is very good module!
 

adesio

Member
XNullUser
Joined
Sep 9, 2021
Messages
141
Reaction score
1
Points
18
NullCash
3
thank you for the share






thank you for the share
 
Top