We would like an advanced search page building for a customized cubecart 3 site.

The search page would allow the user to narrow search by using any or all of the following fields. In database field CubeCart_inventory the product must have a status of 1 to be shown in search results if status is zero it should not be shown in results.

BY Keyword/s
Text input will search in all sections of CubeCart_inventory
Will have a drop down option
Containing any of these words
Containing all these words
Containing exact phrase


ByCategory

Check boxes for each category of act in database (DB field is CubeCart_category)

By Town Or City
Alphabetical Multiple select option built from content of Table CubeCart_inventory field xtra3

By Price Range
From and to to price boxes checked against Table CubeCart_inventory field xtra11 if xtra 11 has no data product not shown in results

Demo Material Check Boxes

Acts with Mp3 Demos check box checks db Table CubeCart_inventory fields xtra12 AND xtra 14 if there is data in those fields that is a positive for this option

Acts with Video Demos check box checks db Table CubeCart_inventory field embedYouTube if there is data in this field that is a positive for this option

Available For Summer Season Work: Check Box checks db Table CubeCart_inventory field xtra5 for a value of YES case must be irrelevant

Available For Work Abroad: Check Box checks db table CubeCart_inventory field xtra6 for a value of YES case must be irrelevant



Results page to show in same format as category pages in all cases acts with demos will be shown before acts with no demos. If user checks one of the demo boxes only acts with those demos will be shown.

If result number is low or zero a message will appear

There weren't many results try broadening your search by not being so specific.

Al results pages to have a search again link at the top and bottom.

Obviously this needs building in cubes normal format so it integrates with the rest of the site so files will be

File advancedsearch.php putting in includes/content
File advancedsearch.tpl putting in skins/new1/styletemplates/content/

Please also be aware that the site uses a search engine friendly mod using apache rewrite via htaccess but it need not be applied to search results.

PLEASE DO NOT BID UNLESS YOU ARE EXPERIENCED WITH CUBECART!!

PLEASE DO NOT BID OVER THE CLIENTS BUDGET YOUR BID WILL BE REMOVED