I need a multi-level faceted search implemented
As you can see from the interface, there are 3 levels of facets. Moreover, some of these facets are for fields with one-to-many relationships. For example, a book can have more than one category or reading level. These one-to-many relationships are represented via, "link through" tables for the most part. Refer to the attached db diagram and note that what's referred to as "subjects" in the diagram are shown as "Categories" in the mockup.
The first contractor on this project recommended Apache SOLR and begain implementing it. However, after repeated delays, they have yet to implement the one-to-many facets.
It is imperative that you do not apply for this project unless you have provable experience with this type of search IN A Ruby on Rails environment. It is *not* a requirement that SOLR be used if you have another engine you have used to successfully implement this.
You will be asked to prove you can do this job by first implementing one of the one-to-many faceted searches.
There is an "Add to List" link on the page. This will allow the user to add the current search results--after as much refinement as they wish--to a list. Lists are already implemented and eagerly awaiting this Add to List function.
We also use MySQL as our RDB and Subversion for our source control. The project is being developed in RoR 3.08.
Once work as progressed half-way, we will release 1/2 the agreed upon amount. The remainder will be paid upon project completion.
There are also several other features of this site that have yet to be implemented. A robust, working solution delivered in on time will be rewarded with future work--both from this project and others.