Printable View
This contribution expands the advanced search function to Categories, Subcategories and EZ Pages.
Categories, Subcategories - searches in Name and Description
EZ Pages - searches in Title and Html_Text
It will display results for products, categories and EZpages and indicate if there are no matches available.
Updated install instructions and screenshots now included.
If you have installed Twitch Restrict Categories by Customer or Group with this module please install the filter update here:
http://www.zen-cart.com/showthread.p...75#post1235575
is it 1.5.0 compatible ??
I don't have any v1.50 carts to test it on, it should work. You could give it a try or let me know if you'd like me to test it on your cart. Be sure to make backups before making any changes.
I have a question/need help with your search.Quote:
Originally Posted by twitchtoo
My site has a billion categories, but if you wanted to search for otters, for example, you'd get zero results because the products are only called "otter shirt" using an include that pulls the name of the category into the product name (which was necessary to avoid creating a billion products).
The categories have real names though, so there is a category called "otters." I figured your plugin would be perfect to solve my search by category problem, but there are two snags...
1. The picture for each category says "no image available" instead of pulling the icon for that category.
2. My category descriptions use a trick to pull the name of the category into them (which you were actually helping me with in another thread) so the descriptions of the categories in the search end up like "Embroidered Personalized Gifts for the Lover" instead of "Embroidered Personalized Otter Gifts for the Otter Lover"
Between those two things, it makes it hard to see which result is the one you want. For instance: http://doodlesport.com/super/index.p...=otter&x=0&y=0
There is otter in "trotter horse" and "otter"
So... for problem #2 I need to add code like
$current_categories_description = str_replace('<!--category-->', $breadcrumb->last(), $current_categories_description);
Which is how I tricked the descriptions into inserting the category name in the product descriptions, but I'm having trouble figuring out how add category names to the results - they aren't already there.
For problem #1, need to tell it to pull the category pictures. Then, even if the descriptions are goofy, at least the picture will tell them which is the right result.
Hope that makes sense! Happy to pay you for your help.
It looks like this no_picture image is a bug, I'm working on the fix as I type this :)
The bug fix is here...Quote:
Originally Posted by twitchtoo
includes/templates/YOUR_TEMPLATE/templates/tpl_modules_advanced_search_categories.php
Line 82 - 86 - replace this:
if ($listing->fields['categories_image'] == '') {
$lc_text .= '<img src="images/no_picture.jpg" width='.IMAGE_PRODUCT_LISTING_WIDTH.' height='.IMAGE_PRODUCT_LISTING_HEIGHT.'/></a>';
} else {
$lc_text .= zen_image(DIR_WS_IMAGES . $listing->fields['categories_image'], $listing->fields['category_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
}
With this:
$lc_text .= zen_image(DIR_WS_IMAGES . zen_get_categories_image($listing->fields['categories_id']), $listing->fields['category_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT) . '</a>'; // if ($listing->fields['categories_image'] == '') {
// $lc_text .= '<img src="images/no_picture.jpg" width='.IMAGE_PRODUCT_LISTING_WIDTH.' height='.IMAGE_PRODUCT_LISTING_HEIGHT.'/></a>';
// } else {
// $lc_text .= zen_image(DIR_WS_IMAGES . $listing->fields['categories_image'], $listing->fields['category_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
// }
And you should see category images if they exist. I'll add this bug fix to the next release of Advanced Search Plus :)
If you haven't already, install Admin Display Product/Catalog Thumbnails so you can see the category images in the admin - category/product listing.
Located here:
http://www.zen-cart.com/downloads.php?do=file&id=1346
On to your second question...
If you look in the same file as the bug fix in my last post, line 76 holds the category_description output. Try your new description code there... I would try it myself but the last coffee is finally wearing off it's sleep time.Quote:
Originally Posted by avansant
Advanced Search Plus 2.02 has been submitted for review.
It's also available on my site if you can't wait :)
Hm. Looks like my post here didn't save - I did get the photo to show up using your instructions, thank you so much! I sent you some coffee money through your site. I can't get my dynamic category keywords to show up though. Using your direction I looked at the code near line 76 and tried
$zen_get_category_description = str_replace('<!--category-->', $categories_name, $zen_get_category_description);
I tried
$current_categories_description = str_replace('<!--category-->', $categories_name, $current_categories_description);
too
but that didn't work. Any idea how I can finish this bit? I'm using the wrong code for calling either the description or the category name for this file, but I can't figure out where I'm going wrong.
This code:
switch ($column_list_cat[$col]) {
case 'CATEGORY_LIST_NAME':
$lc_align = 'left';
$lc_text = '<h3 class="itemTitle"><a href="'
. zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_name'] . '</a></h3><div class="listingDescription">'
. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listi ng->fields['categories_id'], $_SESSION['languages_id']))))
. '</div>' ;
break;
Gets populated by this filter:
zen_get_category_description
So you could change the normal output of the description in the core file so it's consistent site wide.
- includes/functions/functions_lookups.php
OR
Restructure the variable on the page before it displays the output.
- includes/templates/YOUR_TEMPLATE/templates/tpl_modules_advanced_search_categories.php
$avansant_category_desc = 'add your custom script here'
Look over the file, trace the variables back to the source SQL query before randomly calling functions... echo and print_r are your friends ;)
I like core changes, one change - site wide application, less processing.
And thank you for the coffee, I'm enjoying one now :)
Hi. I am looking to add an Exact Match function to the advanced search. I have listings that are partly the same name.
Example
OKI C510
OKI C510DN
OKI C5100
If I put OKI C510 into the search bar it will pull up the listing for C510DN and C5100 as well. Is there a way to filter this out as it I would have to create literally thousands of categories if I had to sort them into individual ones.
I would like to put in OKI C510 into the search bar and only see the exact match, not the variations that contain the same sequence of numbers and letters.
In theory, you need to change the search 'LIKE' to 'EQUALS'
Or use the SQL boundaries search to match the whole word.
That way it's not looking for everything, it's only looking for exact matches to the keyword you have typed in.
Do you think that it could be integrated into the advanced search function or would that upset the working of it? From the way my toner/ink cartridge finder would need to search i would need to have a more refined search than the standard and also your addon search. Instead of a generic search, pulling out everything that has part of the search term in it, it would need to filter out anything that isn't an exact match.
Have you any ideas for coding this as an option so that the filtering is reflected in the domain name which could be copied and pasted into the links for my cartridge finder? I can get round it to a degree but I may lose custom because only certain products would be shown instead of the complete range of options for a customer's printer. The other thing is that if the general search were to be too specific people would not be able to see all of the available options for their product, whereas if it was an option it could be usefull for both my customer and me.
Hi, I have problem with this plugin. It works all great, but no showing catregory name in results. The $listing->fields['categories_id'] in tpl_modules_advanced_search_categories.php is clean... Where will be problem?
Many thanks.
Although we could change the search engine, it may be beneficial to run a VB script on your database. In the past I've created searchable indexes with automation scripts that actually put a static 'label' or 'model' or 'sku' in a new searchable field. This is always 100% compatible with every new version of zen and super fast and easy to change if ever you need to.Quote:
Originally Posted by Axeman
Instead of searching everything for something, search one column for everything. Reduces processing time to boot.
I need to see your site files to check, I emailed you.Quote:
Originally Posted by puhycz
So, I send two emails, do you receive it? Thanks.
Sorry no, please try again mate.Quote:
Originally Posted by puhycz
Advanced Search Plus for Zen Cart v1.54 is complete.
Check the forum plugins or my website for your copy.
What's new:
- forum bug fixes installed
- instructions re-written entirely
- screenshots included
- simplified fileset included and installed on stock Zen Cart 1.54
- separate security install instructions for anyone using Twitch Restrict with this module
As will all of the other modules I support, there's a stock zc v1.54 live/admin demo site available on my site.
I've run into a small problem with the new version. When testing carts, I frequently just try to retrieve really cheap products to buy. If you add in the price function with no keywords as I normally do, I get an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by e.toc_chapter, e.toc_sort_order, e.pages_title' at line 1 :: SELECT * from ezpages e where (e.status_header = 1 or e.status_footer = 1 or e.status_sidebox = 1) and order by e.toc_chapter, e.toc_sort_order, e.pages_title ==> (as called by) /home/domain/public_html/includes/modules/coffee/advanced_search_ezpages.php on line 77 <== in /home/domain/public_html/includes/classes/db/mysql/query_factory.php on line 155
I'm having this issue too. I'm running 2.03 of the module on Zen Cart 1.5.5e.Quote:
Originally Posted by puhycz
In tpl_modules_advanced_search_categories.php, if I change
toCode:
$lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_name'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;
I do see a hyperlink to the category ID number.Code:$lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_id'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;
I love this module and it fixes what I consider to be a big oversight in Zen Cart, so I'm hoping this can be resolved.
I've started updates to this module, watch for the 1.55f release shortly :)
The Fix:Quote:
Originally Posted by Gamethrall
includes/modules/YOUR_TEMPLATE/advanced_search_categories.php
replace line 45
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id ";
with this:
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id, cd.categories_name ";
This will display the correctly named category name below the image as a clickable link.
Advanced Search Plus has been rewritten to work with 1.56c and will be submitted shortly.
This module has been included in the Twitch Base6 core.
All known bugs have been fixed, some new features added.
Thanks for your support! :cheers:
This module generates PHP Warning logs when used with PHP 7.x
Specifically
PHP Warning: Use of undefined constant CATEGORY_LIST_NAME - assumed 'CATEGORY_LIST_NAME' in advanced_search_categories.php on line 15.
PHP Warning: Use of undefined constant CATEGORY_LIST_IMAGE - assumed 'CATEGORY_LIST_IMAGE' in advanced_search_categories.php on line 16.
The issue here seems to be that the module doesn't contain any SQL commands to add these to the configuration table.
I simply added them to the end of Configuration > Product Listing as that is where the Product versions of these defines are set.
If you wish to do the same, run this from admin Tools > Install SQL Patches
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`, `val_function`) VALUES
(NULL, 'Display Category Image', 'CATEGORY_LIST_IMAGE', '0', 'Do you want to display the Category Image?', 8, 50, NULL, 'NOW()', NULL, NULL, NULL),
(NULL, 'Display Category Name', 'CATEGORY_LIST_NAME', '1', 'Do you want to display the Category Name?', 8, 51, NULL, 'NOW()', NULL, NULL, NULL);
Hello. Are there any updates on this plugin? I don't see it updated on the ZC site or your own. Or is anyone using an alternative?
Quote:
Originally Posted by jsquared
Yes public releases are on the way, I'm almost finished Twitch Wholesale PRO then all Twitch modules will be updated
Was this ever submitted?Quote:
Originally Posted by twitchtoo
Quote:
Originally Posted by lat9
Twitch Advanced Search Plus for 1.55f
and
Twitch Advanced Search Plus for 1.56c
have been submitted to the forum plugins...
today.
:eek:
I'll take a short break and get one made for 1.57c tonight.
Submitted to the forum plugins:
Twitch Advanced Search Plus (Public Release)
21a for ZenCart v1.57c
June 24.2021
Updates for 1.57c...
- PHP each() function deprecated - fixed in - includes/modules/advanced_search_categories.php (line 23)
- Added Category Path display switch in Admin
Zen Cart 1.57c fileset included.
Not backwards compatible with previous versions.
And
Twitch Advanced Search Plus (Public Release)
20j for ZenCart v1.56c
June 24.2021
Updates for 1.56c...
- Master ON/OFF switch
- Properly displays category name, category path - breadcrumb text for categories and products
- Control Category Image and Name display on product listing
- Integrates with Twitch Product Listing Advanced for 1.56c (module not included) This module allows advanced user/admin control of product listing features old and new, along with Twitch MRC (product groups) compatibility.
- PHP each() function deprecated - fixed in - includes/modules/advanced_search_categories.php (line 23)
These replace any previous versions for their respective Zen Cart version only.
If my work has helped you today in any way, show your appreciation with things like positive feedback or donations.
Find me at www.twitchtoo.com
:cheers:
Available for 1.57 here:
https://www.zen-cart.com/downloads.php?do=file&id=822
Hi,
Thank you twitchtoo for creating this fabulous plugin! I have installed it in my v.1.5.8 cart and it works great, brings up and shows images of my search results. The one thing is if you simply type in a Search query and hit Enter, it comes up with the buffering circle and continues and continues.
Have I done something wrong in my install or have a setting in Admin wrong? I don't want customers turned off from using the Search if they use it this way rather than waiting that millisecond and having the results come up.
Any ideas on how I could fix this??
Thank you for your help.