Instant Search

[torvista]

3. About the Admin panel! to be honest i have no plans in creating it, but if anyone other is interested, then by all means feel free to take over

Hmm, I have just invested a whole five minutes in looking at this...which is my limit on javascript.

Apart from the obvious stuff, getting the js to load on the categories.php and changing the "watched" box name from "keyword" to "searches", off the top of your head is there anything else that should need changing for the admin?
thanks
Steve

[AyoobG]

Hmm, I have just invested a whole five minutes in looking at this...which is my limit on javascript.

Apart from the obvious stuff, getting the js to load on the categories.php and changing the "watched" box name from "keyword" to "searches", off the top of your head is there anything else that should need changing for the admin?
thanks
Steve

Hi Steve,

The links that will be generated once the user clicks on the search result will have to be different for the admin file. This can be done by editing the js file:

Replace:
index.php?main_page=product_info&products_id=

with:
categories.php?blahblahblah

but i have to warn you that links must be exactly structured as how they are displayed in the admin file links, otherwise your whole shop can mess up.

too much headache i would say!

[torvista]

too much headache i would say!

Thanks! You are right, there are bigger fish to fry than this!

[DigitalShadow]

Is it possible to show current stock levels for product results?

[DigitalShadow]

Is it possible to show current stock levels for product results?

I've tried my hardest, and I can't figure out how to edit the code to use the 'c' return field to display the stock level for the product. It shouldn't be too hard as it is setup to show the product count for categories.

[DigitalShadow]

Done it.

"SELECT " . TABLE_PRODUCTS_DESCRIPTION . ".products_name, " . TABLE_PRODUCTS . ".products_quantity

		$prodquantity = ($dbProducts->fields['products_quantity']);
		$prodResult = strip_tags($dbProducts->fields['products_name']);
		if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
			$results[] = array(
				//we have 4 seperate variables that will be passed on to instantSearch.js
				//'q' is the result thats been found
				//'c' is the number of item within a category search (we leave this empty for product search, look at the example bellow for category search)
				//'l' is used for creating a link to the product or category
				//'pc' lets us know if the word found is a product or a category
				'q'=>$prodResult,
				'c'=>$prodquantity,
				'l'=>$dbProducts->fields['products_id'],
				'pc'=>"p"
			);
		}else{
			$resultsAddAfter[] = array(
				'q'=>$prodResult,
				'c'=>$prodquantity,
				'l'=>$dbProducts->fields['products_id'],
				'pc'=>"p"

yay

[DigitalShadow]

It would be great to be able to separate the in stock results from those out of stock.... hmmmm

[DigitalShadow]

figure that out too,

modify this

if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
$results[] = array(

[AyoobG]

figure that out too,

modify this

if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
$results[] = array(

Not Bad!

[li-he-qi]

Thank you AyoobG for your long answer!
For my customized need, I have found a very similar add-on from: advancebydesign dot com , which exactly do what I expect. many thanks to Robert, the author.
After testing it for some time, I also made a little changes to it to resolve known issues:

1.change:

$sql = "SELECT products_name,products_id from ". TABLE_PRODUCTS_DESCRIPTION ." ORDER BY products_name ASC";

to:

$sql = "SELECT " . TABLE_PRODUCTS_DESCRIPTION . ".products_name, " . TABLE_PRODUCTS_DESCRIPTION . ".products_id, " . TABLE_PRODUCTS .
".products_status
FROM " . TABLE_PRODUCTS_DESCRIPTION . ", " . TABLE_PRODUCTS . "
WHERE " . TABLE_PRODUCTS . ".products_id = " . TABLE_PRODUCTS_DESCRIPTION . ".products_id
AND " . TABLE_PRODUCTS . ".products_status <> 0
AND language_id = '" . (int)$_SESSION['languages_id'] . "'
ORDER BY " . TABLE_PRODUCTS_DESCRIPTION . ".products_name ASC";


2. to disable links in the search results, change:

1:0

to

0:0

3.
edit the correponding file where you plan to put the search box, such as: tpl_search_header.php, tpl_advance_search_default.php, tpl_search.php

the only remaining problem is that it comflicts with almost all the JS-related add-ons, such as "JQ lightbox, click-show-hide-category, bcastr header banner player", not big issue, all the add-ons still work
if you look at the source code, once we begin to type in the search box, all the loaded files from this add-on come into the <body> part from the <header> part.