Ok, we need this quickly. We hired someone to do the work for us and it's just not where it needs to be.
We are launching a website in a matter of a few days and need quick turn-around.
We need a complex search built that queries several elements on our MS SQL database. The previous programmer built it in .NET but I don't care what it's written in.
Here are the project specifics.
We use keyword searches to search "business name" (TABLE: completebusinessdata) and "categories" (CATEGORIES table). We also utilize synonyms (TABLE: SYNONYMS) to replace the keywords with predetermined values, ie remodeling=remodelers.
For example a search for "remodeling contractors" would look for both terms in either the business name or business category. It finds results, and then runs another search using any available synonyms. With the remodeling=remodelers synonym example, the search would turn into "remodelers contractors" and would look for both terms in either the business name or business category. It doesnt matter if a business name was "Tom's Remodeling Contractors" or "Contractors of Remodeling by Jim" or "Charleston's Remodelers Contractors" or "Columbia's Contractors of Remodelers" or IF the business category was titled "Remodeling Contractors" or "Contractors Remodeling" or "Contractor Remodelers" or "Remodelers Contractors". All of those businesses that had that those search terms in either the business name or category would be returned.
NOW, if the search did not find matches with both "remodeling contractors" or the synonymized version of "remodelers contractors" terms, it would then break apart the original search keywords "remodeling contractors" and the synonymized version "remodelers contractors" and find &amp; return all matches that have "remodeling" "contractors" "remodelers" in either (or both) the business name or business category.
The search ignores these words and does not search-but will search the other values:
shop - shops - service - services - company - companies - store - stores
A two or more term exact match on business name only will then immediately return results.
Triggers should remove special characters, ie 'C &amp; L' -&gt; 'C L'
Now, a couple of important factors.
1) The search results will be displayed a certain way. We will give you the layout, but it's pretty basic.
2) We must have quick turn-around within 24-48 hours for testing.
3) Escrow can be made once we see a good working copy. Payment will be released once complete. Escrow will not be made in advance.
4) We do not have a lot of money to spend on this. We can just about guarantee future work though.
5) We can supply you with a development sandbox with access to the DB
6) Generic responses will NOT be considered.
Looking forward to seeing who can tackle this baby.